Java SQL Table Column readMultiDouble(ResultSet resultSet, String columnName)

Description

Extracts a Double[][] field named columnName from current resultSet record

License

Open Source License

Parameter

Parameter	Description
resultSet	a parameter
columnName	a parameter

Return

Double[][]

Declaration

public static Double[][] readMultiDouble(ResultSet resultSet,
        String columnName) 

Method Source Code

//package com.java2s;
/**// w w w  . j a  v  a2s  . co m
 *   Copyright ? 2010 Timothy James Hruska (tjhruska@yahoo.com)
 *
 *   com.tjhruska.util.container
 *   MultiArrayUtils.java
 *
 *   This program is free software: you can redistribute it and/or modify
 *   it under the terms of the LGNU Lesser General Public License as 
 *   published by the Free Software Foundation, either version 3 of the 
 *   License, or (at your option) any later version.
 *
 *   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
 *   LGNU Lesser General Public License for more details.
 *
 *   You should have received a copy of the LGNU Lesser General Public License
 *   along with this program.  If not, see <http://www.gnu.org/licenses/>.
 */

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

public class Main {
    /**
     * Extracts a Double[][] field named columnName from current resultSet record
     * @param resultSet
     * @param columnName
     * @return Double[][]
     */
    public static Double[][] readMultiDouble(ResultSet resultSet,
            String columnName) {
        Double[][] doubleArray = null;

        try {
            doubleArray = (Double[][]) resultSet.getArray(columnName)
                    .getArray();
        } catch (SQLException x) {
            //just swallow it and return null
        }

        return doubleArray;
    }
}

Related

1. isNull(ResultSet resultSet, String columnName)
2. lookupColumnIndex(final ResultSetMetaData resultSetMetaData, final String columnName)
3. lookupColumnIndex(ResultSetMetaData resultSetMetaData, String name)
4. lookupColumnName(ResultSetMetaData resultSetMetaData, int columnIndex)
5. printTableColumn(Connection conn, String sql)
6. readString(final ResultSet resultSet, final String columnName)
7. readStringFromBlob(ResultSet resultSet, String columnLabel)
8. resultSetAsCount(ResultSet rs, String countColumn)
9. resultSetContainsColumn(ResultSet rs, String column)