Basic HTML version of Foils prepared 23 June 1997

Foil 42 JDBC Servlet Example (contd.)

From Overview of JDBC and its use with Microsoft Access UC Web Applications Certificate -- June 26 97. by Nancy McCracken(Sangetta Aggarwal, Udayan Parvate, Tom Pulikal)


1 try {
2 Class.forName("weblogic.jdbc.oci.Driver"); /* load the driver classes and get the connection to the database */
3 Connection con = DriverManager.getConnection(url,username,password);
4 //create and execute the query statement
5 Statement stmt = con.createStatement();
6 ResultSet rs = stmt.executeQuery(query);
7 dispResultSet(rs,out);
8 //close connections here
9 } Catch(SQLException ex) {
10 //print the exceptions caught
11 }
12 }

in Table To:


© Northeast Parallel Architectures Center, Syracuse University, npac@npac.syr.edu

If you have any comments about this server, send e-mail to webmaster@npac.syr.edu.

Page produced by wwwfoil on Thu Jan 8 1998