Here is the code I was using.

public dbfReader() {
       Clipper = new org.netbeans.lib.sql.ConnectionSource();
       Clipper.setDatabase("jdbc:odbc:SurgeOn32");
       Clipper.setDriver("sun.jdbc.odbc.JdbcOdbcDriver");
       try {
           Connection conn = DriverManager.getConnection
(Clipper.getDatabase(),"","");
           Statement stmt = conn.createStatement();
           ResultSet rs;
 
           rs = stmt.executeQuery("SELECT P_LNAME FROM PATGEN1 WHERE P_GID
= 0001234");
           while ( rs.next() ) {
               String lastName = rs.getString("P_LNAME");
               System.out.println(lastName);
           }
            conn.close();
       } catch (Exception e) {
           System.err.println("Got an exception! ");
           System.err.println(e.getMessage());
       }

   }
   
}