JDBC Servlet

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

 

Run the servlet