Java中将ResultSet结果集转换为List

1、【方法1】借助bean的办法//rs是一个查询语句所返回的结果集ResultSet rs=new ResultSet();rs=pstmt.executeQuery();//将rs逐条取出，并将每一项放在一个bean对应的值里 while(rs.next()) { RecBean rec=new RecBean(); rec.setId(rs.getInt(1)); rec.setAgentNo(rs.getString(2)); rec.setFileName(rs.getString(3)); list.add(rec); }

2、【方法2】借助ResultSetMetaData 和Mapprivate static List convertList(ResultSet rs) throws SQLException { List list = new ArrayList(); ResultSetMetaData md = rs.getMetaData(); int columnCount = md.getColumnCount(); while (rs.next()) { Map rowData = new HashMap(); for (int i = 1; i <= columnCount; i++) { rowData.put(md.getColumnName(i), rs.getObject(i)); } list.add(rowData); } return list;}