Separate Focus HTML for Basic Foil 50 Example - Using Weblogic's Oracle Driver -II

Basic HTML version of Foils prepared 7 October 97

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

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

1	//result set or hit list is obtained after
2	// executing the query
3	//and using a cursor it is displayed
4	ResultSet rs = stmt.getResultSet ( );
5	while (rs.next () ) {
6	System.out.println( rs.getString(1) + "-" +
7	rs.getString(2) + "-" + rs.getString(3) );
8	}
9	//get the metadata using the result set
10	ResultSetMetaData rsmd = rs.getMetaData ();
11	System.out.println("Number of Columns:"
12	+ rsmd.getColumnCount() );