new JdbcConnection()
Represents the
JdbcConnection
which is obtained from the JdbcService
.
- Source:
Methods
-
close(handler)
-
Closes the connection. Important to always close the connection when you are done so it's returned to the pool.
Parameters:
Name Type Description handler
function - Source:
-
commit(handler) → {JdbcConnection}
-
Commits all changes made since the previous commit/rollback.
Parameters:
Name Type Description handler
function - Source:
Returns:
- Type
- JdbcConnection
-
execute(sql, resultHandler) → {JdbcConnection}
-
Executes the given SQL statement
Parameters:
Name Type Description sql
string resultHandler
function - Source:
Returns:
- Type
- JdbcConnection
-
query(sql, params, resultHandler) → {JdbcConnection}
-
Executes the given SQL
SELECT
statement which returns the results of the query.Parameters:
Name Type Description sql
string params
todo resultHandler
function - Source:
Returns:
- Type
- JdbcConnection
-
rollback(handler) → {JdbcConnection}
-
Rolls back all changes made since the previous commit/rollback.
Parameters:
Name Type Description handler
function - Source:
Returns:
- Type
- JdbcConnection
-
setAutoCommit(autoCommit, resultHandler) → {JdbcConnection}
-
Sets the auto commit flag for this connection. True by default. Set to false if you want
Parameters:
Name Type Description autoCommit
boolean resultHandler
function - Source:
Returns:
- Type
- JdbcConnection
-
update(sql, params, resultHandler) → {JdbcConnection}
-
Executes the given SQL statement which may be an
INSERT
,UPDATE
, orDELETE
statement.Parameters:
Name Type Description sql
string params
todo resultHandler
function - Source:
Returns:
- Type
- JdbcConnection