/**
*无需对象类型,将一个结果集转换成一个List,
*每一条记录都用LinkedHashMap保存,保证表中列的顺序,然后添加到List中保证记录的顺序,
*取值时遍历即可,在一定程度上简化了取值操作
- @param rs 需要转换的结果集
- @return 转换后的List
*/
public static List populate(ResultSet rs ){
ResultSetMetaData rsmd = null;
ArrayList list = null;
try {
rsmd = rs.getMetaData();
int columnCount = rsmd.getColumnCount();
list = new ArrayList();
while(rs.next()) {
LinkedHashMap<Object, Object> lhm = new LinkedHashMap<>();
for(int i=1; i<=columnCount; i++) {
lhm.put(rsmd.getColumnName(i),rs.getObject(i));
}
list.add(lhm);
}
} catch (SQLException e) {
e.printStackTrace();
}
return list;
}