Java SQL Table Column retrieveCoulmns(String tableName, String columnArray[], Statement statement, long offset, long numberOfRecords)

Description

retrieve Coulmns

License

Apache License

Parameter

Parameter	Description
tableName	a parameter
columnArray	a parameter
statement	a parameter
offset	a parameter
numberOfRecords	a parameter

Exception

Parameter	Description
SQLException	an exception

Return

resultSet

Declaration

public static ResultSet retrieveCoulmns(String tableName, String columnArray[], Statement statement,
        long offset, long numberOfRecords) throws SQLException 

Method Source Code

//package com.java2s;
/*******************************************************************************
 * Copyright 2014 Centre for Development of Advanced Computing(C-DAC), Pune
 * /* w  w  w .  j a v  a  2  s.c om*/
 * 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.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Main {
    /**
     * 
     * @param tableName
     * @param columnArray
     * @param statement
     * @param offset
     * @param numberOfRecords
     * @return resultSet
     * @throws SQLException
     */
    public static ResultSet retrieveCoulmns(String tableName, String columnArray[], Statement statement,
            long offset, long numberOfRecords) throws SQLException {

        String query = "select ";
        for (String column : columnArray) {
            query = query + " " + column + " ,";
        }
        query = query.substring(0, query.length() - 1);
        query = query + "from " + tableName + " Limit " + offset + ", " + numberOfRecords + ";";

        return statement.executeQuery(query);
    }
}

Related

1. resultSetHasColumn(ResultSet rs, String sColumnName)
2. resultSetToOneColumnAsCommamaSeparatedString(ResultSet rs)
3. resultSetToOneColumnAsList(ResultSet rs)
4. resultSetToStringFormat(ResultSet rs, String separator, String quote, boolean column)
5. resultSetValue(ResultSet resultSet, Class parameterClass, Object object, String columnLabel)
6. tableContainsColumn(Connection conn, String table, String column)
7. tableContainsIndex(Connection conn, String table, String column, String index)
8. toColumnNameList(final ResultSet rs)
9. toFlag(ResultSetMetaData metaData, int column)