Java Utililty Methods SQL ResultSet String Read

String getString(ResultSet p_rset, int p_col)
static method for handling positional column gets for String values

try {
 return p_rset.getString(p_col);
} catch (SQLException e_sql) {
 return null;

String getString(ResultSet res, String name)
Returns the values of the specified column as a String.

String v = res.getString(name);
return res.wasNull() ? null : v;

String getString(ResultSet resultSet, String columnName)
Returns a string value using a given SQL result set and column name.

String value = null;
if (resultSet != null && columnName != null) {
 value = resultSet.getString(columnName);
return value;

String getString(ResultSet resultSet, String columnName)
get String

String value = null;
if (checkColumn(resultSet, columnName))
 value = resultSet.getString(columnName);
return value;

String getString(ResultSet rs, int index, boolean trim)
get String

String result = rs.getString(index);
if (trim && result != null) {
 return result.trim();
return result;

String getString(ResultSet rs, int ix, int sql_type)
get String

switch (sql_type) {
case Types.DATE:
 Date date = rs.getDate(ix);
 if (date == null)
 return null;
 return df_date.format(date);
case Types.TIMESTAMP:
 Timestamp timestamp = rs.getTimestamp(ix);
...

String getString(ResultSet rs, String column)
ResultSets often come with "NULL" and return nulls, we preferr actual objects with appropriate values.

String t = rs.getString(column);
if (rs.wasNull())
 t = "";
return t;

String getString(ResultSet rs, String columnLabel)
get String

return rs.getString(columnLabel);

String getString(ResultSet rs, String columnName)
get String

String s = rs.getString(columnName);
return rs.wasNull() ? null : s;

String getString(ResultSet rs, String name)
get String

try {
 return "\"" + name + "\":\"" + escapeQuotes(rs.getString(name)) + "\"";
} catch (SQLException ex) {
 return "\"" + name + "\":\"error\"";