public SqlRunner(DatabaseConnection databaseConnection, String query)

throws:

SQLException

Parameters:

databaseConnection - Database Connection

query - SQL query

See Also:

com.kms.katalon.core.db.DatabaseConnection#DatabaseConnection(DatabaseType, String)

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

throws:

SQLException

Parameters:

databaseConnection - Database Connection

query - SQL query

params - Parameter objects for query

See Also:

com.kms.katalon.core.db.DatabaseConnection#DatabaseConnection(DatabaseType, String)

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

public T query(ListResultSetHandler<T> resultSetHandler)

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

throws:

SQLException

Returns:

The object returned by the handler.

Parameters:

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

See Also:

ListResultSetHandler