Hello,
I am Using Access Database to connect with JDBC in Java and my program looks like this...
public class ...{
..............
................
...............
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:shree");
}catch(Exception e){
e.printStackTrace();
System.exit(1);
}
try{
stmt=con.createStatement();
ResultSet rs=stmt.executeQuery(query);
ResultSetMetaData rsmd=rs.getMetaData();
System.out.println("");
out.println("<font color=gray>");
out.println("<u><b>"+"The Developers with " +level+ " Skill level in "+softwarename + " is/are :"+"</b></u>");
out.println("</font>");
out.println("<hr border=2 color=midnightblue>");
out.println("\n");
out.println("<br>");
int no_column=rsmd.getColumnCount();
for(int i=1;i<=no_column;i++){
if(i>1) out.print(",");
String columnnames=rsmd.getColumnName(i);
out.print("<B>"+columnnames+"\t\t"+"</b>");
}
out.println("<br>");
while(rs.next()) {
for(int i=1;i<=no_column;i++){
if(i>1) out.print(",");
String columnValue=rs.getString(i);
out.print(columnValue+"\t\t");
}
out.println("<br>");
}
stmt.close();
con.close();
}catch(java.sql.SQLException e){
System.out.println(e.toString());
}
out.close();
}
}
Please help me to connect this program to Tomcat and work from tomcat server.
It's very urgent...
Thank You.