Java SQL ResultSet mapResultSet(ResultSet set)

Description

map Result Set

License

Open Source License

Declaration

public static Map<String, Object> mapResultSet(ResultSet set) throws SQLException 

Method Source Code

//package com.java2s;
/*******************************************************************************
 * Copyright (c) 2014 BestSolution.at and others.
 * All rights reserved. This program and the accompanying materials
 * are made available under the terms of the Eclipse Public License v1.0
 * which accompanies this distribution, and is available at
 * http://www.eclipse.org/legal/epl-v10.html
 *
 * Contributors://  w w  w.j  ava2  s  .co m
 *     Tom Schindl <tom.schindl@bestsolution.at> - initial API and implementation
 *******************************************************************************/

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

import java.util.HashMap;

import java.util.Map;

public class Main {
    public static Map<String, Object> mapResultSet(ResultSet set) throws SQLException {
        Map<String, Object> map = new HashMap<String, Object>();
        ResultSetMetaData m = set.getMetaData();
        int columnCount = m.getColumnCount();

        for (int i = 0; i < columnCount; i++) {
            map.put(m.getColumnName(i), set.getObject(i));
        }
        return map;
    }
}

Related

1. isResultEmpty(ResultSet theResult)
2. isReturnsInvalidResultSetException(SQLException se)
3. isSupportedResultSetType(Connection connection, int resultSetType)
4. loadListMap(final ResultSet rs)
5. logCurrentResultSetRow(Log log, String msg, ResultSet rs)
6. moveToPageNo(ResultSet rs, int pageNo, int pageSize)
7. parseSqlResultToListMap(ResultSet rs)
8. putResultSetToMap(final Hashtable map, final ResultSet resultSet, final String... keys)
9. safeGetString(ResultSet r, String name)