1、将结果集ResultSet转化为List集合
//对结果集转换成list集合
public List<Map<String,Object>> getListResult(ResultSet resultSet) throws SQLException{
//创建返回的list集合
List<Map<String,Object>> list = new ArrayList<Map<String,Object>>();
ResultSetMetaData md =result.getMetaData();
int columnCount = md.getColumnCount();
while (result.next()) {
Map<String,Object> map=new HashMap<>();
for(int i=0;i<columnCount;i++){
map.put(md.getColumnName(i+1),result.getString(i+1));
}
list.add(map);
}
return list;
}
2、将list集合转换为json数组字符串,传到前端
list=employeeDao.getRecruit();
JSONArray array= JSONArray.parseArray(JSON.toJSONString(list));
out.println(array);
out.close();