Java SQL ResultSet to resultSetToMap(Map mappedValues, ResultSet rs)

Description

result Set To Map

License

Open Source License

Declaration

@SuppressWarnings({ "rawtypes", "unchecked" })
    public static void resultSetToMap(Map mappedValues, ResultSet rs) throws SQLException 

Method Source Code

//package com.java2s;
/*//from   w w  w.j a v  a  2s.  com
 * Copyright (c) 2002, 2018, Oracle and/or its affiliates. All rights reserved.
 *
 * This program is free software; you can redistribute it and/or modify it under
 * the terms of the GNU General Public License, version 2.0, as published by the
 * Free Software Foundation.
 *
 * This program is also distributed with certain software (including but not
 * limited to OpenSSL) that is licensed under separate terms, as designated in a
 * particular file or component or in included license documentation. The
 * authors of MySQL hereby grant you an additional permission to link the
 * program and your derivative works with the separately licensed software that
 * they have included with MySQL.
 *
 * Without limiting anything contained in the foregoing, this file, which is
 * part of MySQL Connector/J, is also subject to the Universal FOSS Exception,
 * version 1.0, a copy of which can be found at
 * http://oss.oracle.com/licenses/universal-foss-exception.
 *
 * This program 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 General Public License, version 2.0,
 * for more details.
 *
 * You should have received a copy of the GNU General Public License along with
 * this program; if not, write to the Free Software Foundation, Inc.,
 * 51 Franklin St, Fifth Floor, Boston, MA 02110-1301  USA
 */

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Map;

public class Main {
    @SuppressWarnings({ "rawtypes", "unchecked" })
    public static void resultSetToMap(Map mappedValues, ResultSet rs) throws SQLException {
        while (rs.next()) {
            mappedValues.put(rs.getObject(1), rs.getObject(2));
        }
    }

    @SuppressWarnings({ "rawtypes", "unchecked" })
    public static void resultSetToMap(Map mappedValues, java.sql.ResultSet rs, int key, int value)
            throws SQLException {
        while (rs.next()) {
            mappedValues.put(rs.getObject(key), rs.getObject(value));
        }
    }
}

Related

1. resultSetCurrentData(ResultSet rs)
2. resultSetParseVO(ResultSet rs, Class cls)
3. resultSetToArrayList(ResultSet rs)
4. resultSetToHtmlTable(java.sql.ResultSet rs)
5. resultSetToMap(Map mappedValues, java.sql.ResultSet rs, int key, int value)
6. resultSetToOrderedMap(ResultSet rs)
7. resultSetToSet(PreparedStatement statement)
8. resultSetToString(ResultSet resultSet)
9. resultSetToString(ResultSet resultSet)