将ResultSet转为List

public static List<Map> resultSetToList(ResultSet rs) throws java.sql.SQLException {   
           if (rs == null)   
               return Collections.EMPTY_LIST;   
           ResultSetMetaData md = rs.getMetaData(); //得到结果集(rs)的结构信息,比如字段数、字段名等   
           int columnCount = md.getColumnCount(); //返回此 ResultSet 对象中的列数   
           List<Map> list = new ArrayList<Map>();   
           Map rowData = new HashMap();   
           while (rs.next()) {   
            rowData = new HashMap(columnCount);   
            for (int i = 1; i <= columnCount; i++) {   
                    rowData.put(md.getColumnName(i).toLowerCase(), rs.getObject(i));   
            }   
            list.add(rowData);   
            System.out.println("list:" + list.toString());   
           }   
           return list;   
   }

 

posted @ 2017-01-19 09:48  myJoan  阅读(277)  评论(0编辑  收藏  举报