Represents a SQL query interface to a database
no type hierarchy
no supertypes hierarchy
SQLOperationsSQLClientJDBCClient| Inherited Attributes |
Attributes inherited from: Objecthash, string |
| Methods | |
query | shared SQLOperations query(String sql, Anything(Throwable|ResultSet) resultHandler)Executes the given SQL Parameters:
|
querySingle | shared SQLOperations querySingle(String sql, Anything(Throwable|Array) handler)Execute a one shot SQL statement that returns a single SQL row. This method will reduce the boilerplate code by getting a connection from the pool (this object) and return it back after the execution. Only the first result from the result set is returned. Parameters:
|
querySingleWithParams | shared SQLOperations querySingleWithParams(String sql, Array arguments, Anything(Throwable|Array) handler)Execute a one shot SQL statement with arguments that returns a single SQL row. This method will reduce the boilerplate code by getting a connection from the pool (this object) and return it back after the execution. Only the first result from the result set is returned. Parameters:
|
queryWithParams | shared SQLOperations queryWithParams(String sql, Array params, Anything(Throwable|ResultSet) resultHandler)Executes the given SQL Parameters:
|
update | shared SQLOperations update(String sql, Anything(Throwable|UpdateResult) resultHandler)Executes the given SQL statement which may be an Parameters:
|
updateWithParams | shared SQLOperations updateWithParams(String sql, Array params, Anything(Throwable|UpdateResult) resultHandler)Executes the given prepared statement which may be an Parameters:
|
| Inherited Methods |
Methods inherited from: Objectequals |