动态读取ResultSet

private static class MyResultSetHandler {

  List list = new ArrayList();

  public void handle(ResultSet rs) throws SQLException {
   ResultSetMetaData rsmd = rs.getMetaData();
   int count = rsmd.getColumnCount();
   String[] names = new String[count];
   for (int i = 1; i <= count; i++) {
    names[i - 1] = rsmd.getColumnName(i);
   }
   while (rs.next()) {
    Map map = new HashMap(4,2);
    for (int i = 0; i < count; i++)
     map.put(names[i], rs.getObject(names[i]));
    list.add(map);
   }
  }
 }