Java SQL Table Column getColumn(ResultSet result, int col)

Description

Get a string from a result set, trimming trailing blanks.

License

Open Source License

Parameter

Parameter	Description
result	a parameter
col	a parameter

Exception

Parameter	Description

Return

the resulted string

Declaration

static String getColumn(ResultSet result, int col) throws java.sql.SQLException 

Method Source Code

//package com.java2s;
/*/*ww  w. jav a 2  s  .  c  om*/
 * ====================
 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
 *
 * Copyright 2008-2009 Sun Microsystems, Inc. All rights reserved.
 *
 * The contents of this file are subject to the terms of the Common Development
 * and Distribution License("CDDL") (the "License").  You may not use this file
 * except in compliance with the License.
 *
 * You can obtain a copy of the License at
 * http://opensource.org/licenses/cddl1.php
 * See the License for the specific language governing permissions and limitations
 * under the License.
 *
 * When distributing the Covered Code, include this CDDL Header Notice in each file
 * and include the License file at http://opensource.org/licenses/cddl1.php.
 * If applicable, add the following below this CDDL Header, with the fields
 * enclosed by brackets [] replaced by your own identifying information:
 * "Portions Copyrighted [year] [name of copyright owner]"
 * ====================
 */

import java.sql.ResultSet;

public class Main {
    /**
     * Get a string from a result set, trimming trailing blanks.
     *
     * @param result
     * @param col
     * @return the resulted string
     * @throws java.sql.SQLException
     */
    static String getColumn(ResultSet result, int col) throws java.sql.SQLException {
        String s = result.getString(col);
        if (s != null) {
            s = s.trim();
        }
        return s;
    }
}

Related

1. columnLabels(final ResultSet results)
2. containsColumn(ResultSet rs, String columnName)
3. extractColumnTypeName(ResultSetMetaData resultSetMetaData, int index)
4. generateKey(Statement statement, String TableName, String KeyColumn)
5. getAllFromSensorDb( final Connection jdbcConnection, final String tableName, final String orderByColumn)
6. getColumnDisplaySize(int col, ResultSetMetaData rsmd)
7. getColumnIndexFromColumnName(ResultSetMetaData metaData, String columnName)
8. getColumnLabelMap(ResultSet resultSet)
9. getColumnMetaData(Connection conn, String table, String column)