JDBC结果集ResultSet映射成map

1.如果字段较多可以考虑封装为map集合

//获取结果
                    ResultSet orderResultSet = preparedStatement1.executeQuery();
                    ResultSet orderItemsResultSet = preparedStatement2.executeQuery();

                    //定义集合封装遍历的结果
                    List<Map<String,Object>> sdbB2cOrdersList = new ArrayList<Map<String,Object>>();
                    List<Map<String,Object>> sdbB2cOrderItemsList = new ArrayList<Map<String,Object>>();
                    Map<String,Object> temp = null;
                    Map<String,Object> temp2 = null;
                    ResultSetMetaData md = orderResultSet.getMetaData();
                    int count = md.getColumnCount();
                    ResultSetMetaData md2 = orderItemsResultSet.getMetaData();
                    int count2 = md2.getColumnCount();
                    //遍历查询结果
                    while(orderResultSet.next()){
                        temp = new HashMap<String,Object>();
                        md =orderResultSet.getMetaData();
                        for (int j = 1; j <= count; j++) {
                            temp.put(md.getColumnName(j),orderResultSet.getObject(j));
                        }
                        sdbB2cOrdersList.add(temp);
                    }
                    //遍历查询结果
                    while(orderItemsResultSet.next()){
                        temp2 = new HashMap<String,Object>();
                        md2 =orderItemsResultSet.getMetaData();
                        for (int j = 1; j <= count2; j++) {
                           temp2.put(md2.getColumnName(j),orderItemsResultSet.getObject(j));
                        }
                        sdbB2cOrderItemsList.add(temp2);
                    }