数据库查询结果ResultSet类型 转 List类型

ResultSet类型 转 List类型

	/**
	 * 将数据库查询的结果转换为List<Map<String,Object>>类型
	 * @param res
	 * @return
	 */
	public List<Map<String,Object>> getResultList(ResultSet res) {
		List<Map<String, Object>> list = new ArrayList<Map<String, Object>>();
		try {
			ResultSetMetaData md = res.getMetaData();
			int columnCount = md.getColumnCount();
			while (res.next()) {
				Map<String, Object> rowData = new HashMap<String, Object>();
				for (int i = 1; i <= columnCount; i++)
					rowData.put(md.getColumnName(i), res.getObject(i));
				list.add(rowData);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return list;
	}
}