DB结果集ResultSet转换为List的方法

 private static List convertList(ResultSet rs) throws SQLException {
  List list = new ArrayList();
  ResultSetMetaData md = rs.getMetaData();
  int columnCount = md.getColumnCount();
  //Map rowData;
  while (rs.next()) {
   //rowData = new HashMap(columnCount);
   Map rowData = new HashMap();
   for (int i = 1; i <= columnCount; i++) {
    rowData.put(md.getColumnName(i), rs.getObject(i));
   }
   list.add(rowData);
  }
  return list;
 }