将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;

}