JAVA中如何将ResultSet结果集转换为List呢?

实现思路:
    借助for循环遍历ResultSet结果集中的数据
	然后插入到list集合中

一、获取ResultSet集合
Class.forName(dom.getDriver()); //加载MYSQL JDBC驱动程序 
String url=dom.getUrl()+"/"+datebaseName+"?characterEncoding=UTF-8";
Connection conn = DriverManager.getConnection(url,dom.getUsername(),dom.getPassword());
Statement stat = conn.createStatement();
String sql="select * from "+tableName+" order by "+order+";";
ResultSet rs=stat.executeQuery(sql);
list=convertList(rs);
stat.close();
conn.close();
return list;

二、转换ResultSet集合转List集合的方法
private static List convertList(ResultSet rs) throws SQLException{
  List list = new ArrayList();
  ResultSetMetaData md = rs.getMetaData();//获取键名
  int columnCount = md.getColumnCount();//获取行的数量
  while (rs.next()) {
    Map rowData = new HashMap();//声明Map
    for (int i = 1; i <= columnCount; i++) {
       rowData.put(md.getColumnName(i), rs.getObject(i));//获取键名及值
    }
   list.add(rowData);
  }
 return list;
}