Java SQL ResultSet String Read getString(ResultSet rs, String columnName)

Here you can find the source of getString(ResultSet rs, String columnName)

Description

get String

License

Open Source License

Declaration

@CheckForNull
    public static String getString(ResultSet rs, String columnName) throws SQLException 

Method Source Code

//package com.java2s;
/*/*from ww  w .  ja v  a 2s  .c o m*/
 * SonarQube
 * Copyright (C) 2009-2017 SonarSource SA
 * mailto:info AT sonarsource DOT com
 *
 * This program is free software; you can redistribute it and/or
 * modify it under the terms of the GNU 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 GNU
 * Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public License
 * along with this program; if not, write to the Free Software Foundation,
 * Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
 */

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

import javax.annotation.CheckForNull;

public class Main {
    @CheckForNull
    public static String getString(ResultSet rs, String columnName) throws SQLException {
        String s = rs.getString(columnName);
        return rs.wasNull() ? null : s;
    }

    @CheckForNull
    public static String getString(ResultSet rs, int columnIndex) throws SQLException {
        String s = rs.getString(columnIndex);
        return rs.wasNull() ? null : s;
    }
}

Related

  1. getString(ResultSet resultSet, String columnName)
  2. getString(ResultSet rs, int index, boolean trim)
  3. getString(ResultSet rs, int ix, int sql_type)
  4. getString(ResultSet rs, String column)
  5. getString(ResultSet rs, String columnLabel)
  6. getString(ResultSet rs, String name)
  7. getString(ResultSet rs, String name, String ifnull)
  8. getStringChunks(ResultSet rs, int colIndex, StringBuffer buf)
  9. getStringFromResultSetEmptyIsNull(ResultSet rset, String fieldName)