Separate HTML for Basic Foil 42 JDBC Servlet Example (contd.)

Basic HTML version of Foils prepared 7 October 97

Foil 42 JDBC Servlet Example (contd.)

From Overview of JDBC and its use with Microsoft Access ARL Database Tutorial -- February 98. by Nancy McCracken(Sangetta Aggarwal, Udayan Parvate, Tom Pulikal)

try {

Class.forName("weblogic.jdbc.oci.Driver"); /* load the driver classes and get the connection to the database */

Connection con = DriverManager.getConnection(url,username,password);

//create and execute the query statement

Statement stmt = con.createStatement();

ResultSet rs = stmt.executeQuery(query);

dispResultSet(rs,out);

//close connections here

} Catch(SQLException ex) {

//print the exceptions caught

}