Database Connection in JSP
843859Sep 11 2006 — edited Sep 12 2006HI
Class.forName ("sun.jdbc.odbc.jdbcodbcdriver");
String sql = "SELECT * " +"FROM Users";
Connection con=DriverManager.getConnection "jdbc:odbc:Memory");
<b>(Memory is my MSAcess Datbase Name )</b>
Statement s =con.createStatement();
ResultSet rs = s.executeQuery(sql);
while (rs.next());
out.print(rs.getString(1));
I use this code in Jsp page with some html coding. When i call the jsp page using tomcat i am unable to retrive data from the database. the page is displaying html content properly but no database retrival and no errors in the page
Can any one help me
Thanks in advance