Sample client code -- ADTmag

Sample client code

By Nitin Nanda
February 5, 2001

COMPONENT JAVA
Extending the Power of JDBC Drivers
Nitin Nanda
Listing 5. Sample client code.


try
{
     Class.forName("com.jr.driver.JRDriver");

     Connection connection = DriverManager.
              getConnection("jdbc:jr:myDb","sa", "");

     Statement statement = connection.createStatement();

     //"testtable" is present in the DSN
     ResultSet resultSet = statement.
        executeQuery("select * from testtable");

     while(resultSet.next())
     {
	      /* do processing here */
     }
     
     resultSet.close();
     statement.close();
     connection.close();

}
catch(Exception exception)
{
     System.out.println(exception.getMessage());
     exception.printStackTrace();
}