Getting Particular Rows from a Database Table
This example retrieves all rows from a table called ``mytable'' whose column COL_A equals ``Patrick Chan''. A row in ``mytable'' consists of a string, integer, and floating point number. 

 try {
   Statement stmt = connection.createStatement();
   ResultSet rs = stmt.executeQuery(
     "SELECT * FROM mytable WHERE COL_A = 
       'Patrick Chan'");
   rs.next();
   String s = rs.getString("COL_A");
   int i = rs.getInt("COL_B");
   float f = rs.getFloat("COL_C");
   process(s, i, f);
 } catch (SQLException e) {
 }