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>();
}
resList.add(rsMap);
}
return resList;
}
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;
}