public SqlRunner(DatabaseConnection databaseConnection, String query)

throws:

SQLException

Parameters:

databaseConnection - Database Connection

query - SQL query

See Also:

DatabaseConnection.DatabaseConnection

public SqlRunner(DatabaseConnection databaseConnection, String query, Object[] params)

throws:

SQLException

Parameters:

databaseConnection - Database Connection

query - SQL query

params - Parameter objects for query

See Also:

DatabaseConnection.DatabaseConnection

public SqlRunner(Connection connection, String query)

throws:

SQLException

Parameters:

connection - Connection

query - SQL query

See Also:

Connection

public SqlRunner(Connection connection, String query, Object[] params)

throws:

SQLException

Parameters:

connection - Connection

query - SQL query

params - Parameter objects for query

See Also:

Connection

@Override public void close()

Close connection, avoid closing if null and hide any SQLExceptions that occur.

See Also:

AutoCloseable.close

public boolean isConnectionAlive()

public ResultSet query()

Execute the given SELECT SQL query.

throws:

SQLException

Returns:

ResultSet

<T> public T query(ListResultSetHandler<T> resultSetHandler)

Execute the given SQL SELECT query. The caller is responsible for closing the connection.

throws:

SQLException

Parameters:

resultSetHandler - The handler that converts the results into an object.

Returns:

The object returned by the handler.

See Also:

ListResultSetHandler