Java Reference
In-Depth Information
L
ISTING
7.3
Continued
// Load the Driver class file
Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver”);
// Make a connection to the ODBC datasource Movie Catalog
con = DriverManager.getConnection(“jdbc:odbc:Movie Catalog”,
“”, “”);
// Create the statement
Statement statement = con.createStatement();
// Use the created statement to SELECT the DATA
// FROM the Titles Table.
ResultSet rs = statement.executeQuery(“SELECT * “ +
“FROM Titles”);
// Iterate over the ResultSet
while ( rs.next() ) {
// get the title_name, which is a String
System.err.println(“Title Name = “ + rs.getString(“title_name”));
// get the rating
System.err.println(“Title Rating = “ + rs.getString(“rating”));
// get the price
System.err.println(“Title Price = “ + rs.getString(“price”));
// get the quantity
System.err.println(“Title Quantity = “ + rs.getString(“quantity”)
+ “\n”);
}
// Close the ResultSet
rs.close();
System.in.read();
}
catch (IOException ioe) {
System.err.println(ioe.getMessage());
}
catch (SQLException sqle) {
System.err.println(sqle.getMessage());
}
catch (ClassNotFoundException cnfe) {
System.err.println(cnfe.getMessage());
