Java SQL ResultSet Read getValue(ResultSet result, String strField)

Description

get Value

License

Apache License

Declaration

public static String getValue(ResultSet result, String strField) throws java.sql.SQLException 

Method Source Code

//package com.java2s;
/*/*www.  ja v a2 s  . c o  m*/
 ************************************************************************************
 * Copyright (C) 2001-2010 Openbravo S.L.U.
 * Licensed under the Apache Software License version 2.0
 * 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;

public class Main {
    public static String getValue(ResultSet result, String strField) throws java.sql.SQLException {
        String strValueReturn = result.getString(strField);
        if (result.wasNull())
            strValueReturn = "";
        return strValueReturn;
    }

    public static String getValue(ResultSet result, int pos) throws java.sql.SQLException {
        String strValueReturn = result.getString(pos);
        if (result.wasNull())
            strValueReturn = "";
        return strValueReturn;
    }
}

Related

1. getStatement(ResultSet resultSet)
2. getURI(ResultSet resultSet, String columnLabel)
3. getURI(ResultSet rs, int col)
4. getUUIDFromResultSet(ResultSet rset, String name)
5. getValue(int type, ResultSet resultSet, int columnIndex)
6. getValue(ResultSet resultSet, String columnName, E defaultValue)
7. getValue(ResultSet rs, String sField)
8. getValue4Type(ResultSet rs, String column, Class typeClass)
9. getValueByObjectType(ResultSetMetaData metaData, ResultSet rs, int index)