This servlet uses the JDBC:ODBC bridge to query an Access database running on the seame PC as the Java Server.
Servlet
import java.awt.*; import java.awt.event.*; import java.net.*; import java.io.*; import java.util.*; import javax.servlet.*; import javax.servlet.http.*; import java.sql.*; public class jbsJDBCServlet extends HttpServlet { //***** Servlet access to data base public void doGet (HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { String url = "jdbc:odbc:jbsAddress"; String query = "SELECT * FROM main " + "WHERE last = 'smith'"; try { Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection ( url, "", "" ); Statement stmt = con.createStatement (); ResultSet rs = stmt.executeQuery (query); printResultSet ( resp, rs ); rs.close(); stmt.close(); con.close(); } // end try catch (SQLException ex) { while (ex != null) { /* System.out.println ("SQL Exception: " + ex.getMessage ()); ex = ex.getNextException (); */ } // end while } // end catch SQLException catch (java.lang.Exception ex) { ; } } // end doGet private void printResultSet ( HttpServletResponse resp, ResultSet rs ) throws SQLException { ServletOutputStream out; try { resp.setContentType("text/html"); out = resp.getOutputStream(); out.println("<html>"); out.println("<head><title>jbsServerThreaded</title></head>"); out.println("<body>"); out.println("<center><font color=AA0000>"); out.println("<h3>jbsJDBCServlet</h3>"); out.println("<h3>Data Retrieved:</h3>"); out.println("<pre>"); int numCols = rs.getMetaData().getColumnCount (); while ( rs.next() ) { for (int i=1; i<=numCols; i++) { out.print(rs.getString(i) + " | " ); } // end for } // end while out.println(); out.println("</pre>"); out.println("</font></center>"); out.println("</body>"); out.println("</html>"); out.close(); } // end try catch ( IOException except) { } // end catch } // end returnHTML } // end jbsJDBCServlet