String url = "jdbc:odbc:CustomerInformation";
String userID = "jim";
String password = "keogh";
String printrow;
String FirstName; 
String LastName; 
Statement DataRequest;
ResultSet Results;
Connection Db;
try {
   Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver");
   Db = DriverManager.getConnection(url,userID,password);
 }
catch (ClassNotFoundException error) {
      System.err.println("Unable to load the JDBC/ODBC bridge." + 
             error);
      System.exit(1);
}
catch (SQLException error) {
      System.err.println("Cannot connect to the database." + error);
      System.exit(2);
}
try {
      String query = "SELECT FirstName,LastName FROM Customers";
      DataRequest = Db.createStatement();
      Results = DataRequest.executeQuery (query);
}
catch ( SQLException error ){
     System.err.println("SQL error." + error);
      System.exit(3);
}
boolean Records = Results.next();
if (!Records ) {
   System.out.println("No data returned");
   System.exit(4);
}
try {
  do {
     FirstName = Results.getString ( 1 ) ;
      LastName = Results.getString ( 2 ) ;
      printrow = FirstName + " " + LastName;
     System.out.println(printrow);
  } while (Results.next() );
  DataRequest.close();
}
catch (SQLException error ) {
   System.err.println("Data display error." + error);
   System.exit(5);
}