Separate HTML for Basic Foil 48 Example - using Imaginary's mSQL Driver -II

Basic HTML version of Foils prepared 7 October 97

Foil 48 Example - using Imaginary's mSQL 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)

while (rs.next() ) {

int a = rs.getInt(1);

String str = rs.getString(2);

System.out.println("key = " + a);

System.out.println("str = " + str); }

//close the query execution and the database

connection before exiting

stmt.close();

conn.close();

}

//catch any exception and print it to the

system output

catch ( Exception e) {

System.out.println (e.getMessage() );

e.printStackTrace();

}

} // End main

} // End class Select