* GREY=local LOCAL HTML version of Foils prepared 13 March 1997

Foil 20 Example - Using Weblogic's Oracle Driver -II

From Overview of Java Database Connection Basic Information Technology Course CPS616 -- Spring Semester 1997. by Udayan Parvate, Tom Pulikal (Geoffrey C. Fox) *
//result set or hit list is obtained after
// executing the query
//and using a cursor it is displayed
ResultSet rs = stmt.getResultSet ( );
while (rs.next () ) {
System.out.println( rs.getString(1) + "-" +
rs.getString(2) + "-" + rs.getString(3) );
}
//get the metadata using the result set
ResultSetMetaData rsmd = rs.getMetaData ();
System.out.println("Number of Columns:"
+ rsmd.getColumnCount() );

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 Tue Jul 22 1997