<%@ page import="java.sql.*" %> <%! public void jspInit() { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); } catch (ClassNotFoundException e) { } } %>

Keyword:
Search In: <% //Open the Categories table try { String sql = "SELECT * FROM Categories"; Connection con = DriverManager.getConnection("jdbc:odbc:JavaWeb"); Statement s = con.createStatement(); ResultSet rs = s.executeQuery(sql); while (rs.next()) { out.print(""); out.print(rs.getString(2)); out.print("\n"); } s.close(); con.close(); } catch (SQLException e) { out.println(e.toString()); } catch (Exception e) { out.println(e.toString()); } %>