处理ResultSet查询结果并返回一个List方法---利用元数据

private List<Map<String, Object>> parseResultSet(final ResultSet rs) throws Exception{
List<Map<String, Object>> resList = new ArrayList<Map<String, Object>>();
ResultSetMetaData rmd = rs.getMetaData();//获取元数据
int columnCount = rmd.getColumnCount();//获取总的列数
while(rs.next()){
Map<String, Object> rsMap = new HashMap<String, Object>();

for(int i=1; i<columnCount; i++){

//循环每一列，并取得该列的值

rsMap.put(rmd.getColumnName(i), rs.getObject(i));
}
resList.add(rsMap);
}

return resList;
}