Java SQL ResultSet to resultSetToOrderedMap(ResultSet rs)

Description

result Set To Ordered Map

License

Apache License

Declaration

private static Map<String, Object> resultSetToOrderedMap(ResultSet rs) throws SQLException 

Method Source Code

//package com.java2s;
/*/* www. j a  v a2s.c o  m*/
 * Copyright 2012 - 2016 Splice Machine, Inc.
 *
 * Licensed under the Apache License, Version 2.0 (the "License"); you may not use
 * this file except in compliance with the License. You may obtain a copy of the
 * License at
 *
 * http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software distributed
 * under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR
 * CONDITIONS OF ANY KIND, either express or implied. See the License for the
 * specific language governing permissions and limitations under the License.
 */

import java.sql.*;
import java.util.*;

public class Main {
    private static Map<String, Object> resultSetToOrderedMap(ResultSet rs) throws SQLException {
        Map<String, Object> result = new LinkedHashMap<>();
        ResultSetMetaData rsmd = rs.getMetaData();
        int cols = rsmd.getColumnCount();

        for (int i = 1; i <= cols; i++) {
            result.put(rsmd.getColumnName(i), rs.getObject(i));
        }

        return result;
    }
}

Related

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