把ResultSet对象转变成List对象

最新推荐文章于 2023-09-11 01:10:18 发布

koushr

最新推荐文章于 2023-09-11 01:10:18 发布

阅读量1.8k

点赞数

本文链接：https://blog.csdn.net/koushr/article/details/50775182

版权

private static List<Map<String, Object>> convertRS2List(ResultSet rs) throws SQLException {
		List<Map<String, Object>> list = new ArrayList<Map<String, Object>>();
		// return the description of this ResultSet object's columns
		ResultSetMetaData rsMetaData = rs.getMetaData();
		// return the number of columns
		int columnCount = rsMetaData.getColumnCount();
		String columnName = "";
		while (rs.next()) {
			Map<String, Object> rowData = new HashMap<String, Object>();
			for (int i = 1; i <= columnCount; i++) {
				// return 第i列的column name
				columnName = rsMetaData.getColumnName(i);
				rowData.put(columnName, rs.getObject(i));
			}
			list.add(rowData);
		}
		return list;
}

可以查看common-dbUtils-xxx.jar包中BeanListHander的handle（）方法，里面有此方法的代码。