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, or DELETE
statement.
Parameters:
| Name | Type | Description |
|---|---|---|
sql |
string | |
params |
todo | |
resultHandler |
function |
- Source:
Returns:
- Type
- JdbcConnection