Java Utililty Methods SQL ResultSet Read

ResultSet rs = null;
try {
    System.out.println(query);
    System.out.println(conn);
    Statement st = conn.createStatement();
    rs = st.executeQuery(query);
    if (!rs.next())
        rs = null;
...

ResultSet rs;
PreparedStatement st = connection.prepareStatement(query);
rs = st.executeQuery();
return rs;

Connection conn;
Statement stmt;
ResultSet rs = null;
try {
    conn = DriverManager.getConnection(
            "jdbc:mysql://localhost:3306/rspamd?characterEncoding=utf8&useSSL=true", "root", "root");
    stmt = conn.createStatement();
    rs = stmt.executeQuery(sql);
...

ArrayList<String> list = null;
if (rs == null)
    return list;
list = new ArrayList<String>();
ResultSetMetaData rsmd = rs.getMetaData();
int colCount = rsmd.getColumnCount();
for (int i = 1; i <= colCount; i++) {
    String colName = rsmd.getColumnName(i);
...

ResultSetMetaData md = rs.getMetaData();
int nCols = md.getColumnCount();
String[] ret = new String[nCols];
for (int i = 0; i < ret.length; i++) {
    ret[i] = md.getColumnName(i + 1);
return (ret);

Timestamp ts = rs.getTimestamp(sColumnName);
if (ts != null)
    return new Date(ts.getTime());
return null;

if (mStatement != null) {
    try {
        return mStatement.executeQuery(command);
    } catch (SQLException e) {
        System.out.println(mSqlHelperPrefix + e);
        return null;
System.out.println("SQLHelper: statement==null");
return null;

Connection c = getDefaultDerbyConnection();
ResultSet rs = c.createStatement().executeQuery(sql);
return rs;

Statement stmt = null;
ResultSet rs = null;
try {
    stmt = conn.createStatement();
    rs = stmt.executeQuery(sql);
} catch (SQLException e) {
    throw new RuntimeException("Could not execute query:" + sql, e);
return rs;

HashMap lhs = new HashMap(5);
ResultSetMetaData rsmd = rs.getMetaData();
int colSize = rsmd.getColumnCount();
for (int i = 1; i < colSize + 1; i++) {
    lhs.put(rsmd.getColumnName(i).toUpperCase(), getJavaType(rsmd.getColumnName(i), rsmd.getColumnType(i),
            rsmd.getPrecision(i), rsmd.getScale(i)));
return lhs;
...