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) {
 }