Java SQL ResultSet to toMapOfLists(ResultSet rs)

Description

to Map Of Lists

License

Open Source License

Declaration

public static Map<String, List<Object>> toMapOfLists(ResultSet rs) throws SQLException 

Method Source Code

//package com.java2s;
/*//from   w  w  w  .j  a v a 2 s  .  com
 * Copyright 2015 The Solmix Project
 *
 * This is free software; you can redistribute it and/or modify it
 * under the terms of the GNU Lesser General Public License as
 * published by the Free Software Foundation; either version 2.1 of
 * the License, or (at your option) any later version.
 *
 * This software is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
 * Lesser General Public License for more details.
 *
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 * http://www.gnu.org/licenses/ 
 * or see the FSF site: http://www.fsf.org. 
 */

import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;

import java.util.ArrayList;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

public class Main {
    public static Map<String, List<Object>> toMapOfLists(ResultSet rs) throws SQLException {
        Map<String, List<Object>> result = new HashMap<String, List<Object>>(128);
        ResultSetMetaData header = rs.getMetaData();
        for (int ii = 1; ii <= header.getColumnCount(); ii++)
            result.put(header.getColumnName(ii), new ArrayList<Object>());
        while (rs.next()) {
            int ii = 1;
            while (ii <= header.getColumnCount()) {
                result.get(header.getColumnName(ii)).add(rs.getObject(ii));
                ii++;
            }
        }
        return result;
    }
}

Related

1. toJSONFromResultSet(ResultSet resultSet)
2. toListMap(int limit, ResultSet rs)
3. toMap(final ResultSet resultSet)
4. toMap(final ResultSet resultSet)
5. toMapList(ResultSet rs)
6. toObjectArray(ResultSet resultSet)
7. toSingleResult(ResultSet rs)