Overview
JavaFX Framework for access to Relational Databases via JDBC
Attribute Summary
name | type | description |
---|---|---|
Public | ||
autoCommit | Boolean |
indicates if the connection is in autoCommit mode or not. |
dataSource | DataSource |
the DataSource to use to establish the database connection. |
dbUrl | String |
optional database connection URL If a dataSource is provided, it will be used to establish the connection. |
password | String |
optional connection password |
statement | Statement |
holds a resuable statement |
user | String |
optional connection user id |
warnings | Warning[] |
holds the last set of warnings from an sql execution |
Protected |
Inherited Attributes
Function Summary
- public closeConnection() : Void
-
close the database connection
- public commit() : Void
-
convenience method to commit a transaction
- public execute(sql: String, ) : Boolean
-
execute an sql statement
- public execute(sql: String, values: String, ) : Boolean
-
execute an sql statement, using the values Sequence to populate the parameters in the prepared statment.
- public execute(sql: String, statement: Statement, ) : Boolean
-
execute an sql statement
- public execute(preparedStatement: PreparedStatement, values: String, ) : Boolean
-
execute a prepared statement, using the values Sequence to populate the parameters in the prepared statement.
- public executeUpdate(sql: String, ) : Integer
-
execute an sql statement, this sql statement is always committed
- public executeUpdate(sql: String, values: String, ) : Integer
-
execute an sql statement, using the values Sequence to populate the parameters in the prepared statment.
- public executeUpdate(preparedStatement: PreparedStatement, values: String, ) : Integer
-
execute an sql statement
- public getConnection() : Connection
-
get the database connection
- public getPreparedStatement(sql: String, ) : PreparedStatement
-
Convenience method to get a PreparedStatement
- public getStatement() : Statement
-
Convenience method to get a statement
- public query(sql: String, ) : ResultSet
-
perform a query
- public query(sql: String, process: Function1, ) : Void
-
perform a query
- public release(savepoint: Savepoint, ) : Void
-
convenience method to release a save point
- public rollback() : Void
-
convenience method to abort a transaction
- public rollback(savepoint: Savepoint, ) : Void
-
convenience method to rollback to a save point
- public setSavepoint(savepoint: String, ) : Savepoint
-
convenience method to set a save point
Inherited Functions
Attributes
public autoCommit: Boolean
indicates if the connection is in autoCommit mode or not.
public dataSource: DataSource
the DataSource to use to establish the database connection. If a dataSource is provided, it will be used to establish the connection. Otherwise, the dbURL and user/password attributes will be used.
public dbUrl: String
optional database connection URL If a dataSource is provided, it will be used to establish the connection. Otherwise, the dbURL and user/password attributes will be used.
public password: String
optional connection password
public statement: Statement
holds a resuable statement
public user: String
optional connection user id
public warnings: Warning[]
holds the last set of warnings from an sql execution
Functions
public closeConnection():Void
close the database connection
public commit():Void
convenience method to commit a transaction
public execute(sql: String, ):Boolean
-
Parameters
- sql
- the sql statement
-
Returns
- Boolean
- true if a result set is available
execute an sql statement
public execute(sql: String, values: String, ):Boolean
-
Parameters
- sql
- the sql statement
- values
- the sequence containing the parameter values
-
Returns
- Boolean
- true if a result set is available
execute an sql statement, using the values Sequence to populate the parameters in the prepared statment.
public execute(sql: String, statement: Statement, ):Boolean
-
Parameters
- sql
- the sql statement
- statement
- the statement to use
-
Returns
- Boolean
- true if a result set is available
execute an sql statement
public execute(preparedStatement: PreparedStatement, values: String, ):Boolean
-
Parameters
- preparedStatement
- the prepared statement
- values
- the sequence containing the parameter values
-
Returns
- Boolean
- true if a result set is available
execute a prepared statement, using the values Sequence to populate the parameters in the prepared statement.
public executeUpdate(sql: String, ):Integer
-
Parameters
- sql
- the sql statement
-
Returns
- Integer
- the number of rows updated
execute an sql statement, this sql statement is always committed
public executeUpdate(sql: String, values: String, ):Integer
-
Parameters
- sql
- the sql statement
- values
- the sequence containing the parameter values
-
Returns
- Integer
- the number of rows updated
execute an sql statement, using the values Sequence to populate the parameters in the prepared statment. This sql statement is always committed
public executeUpdate(preparedStatement: PreparedStatement, values: String, ):Integer
-
Parameters
- preparedStatement
- the sql statement
- values
- the statement to use
-
Returns
- Integer
- the number of rows updated
execute an sql statement
public getPreparedStatement(sql: String, ):PreparedStatement
-
Parameters
- sql
- the sql statement
-
Returns
- PreparedStatement
- the prepared statement
Convenience method to get a PreparedStatement
public getStatement():Statement
-
Returns
- Statement
- the statement
Convenience method to get a statement
public query(sql: String, ):ResultSet
-
Parameters
- sql
- the sql query
-
Returns
- ResultSet
- the ResultSet
perform a query
public query(sql: String, process: Function1, ):Void
-
Parameters
- sql
- the sql query
- process
- the function to call for each row in the ResultSet
perform a query
public release(savepoint: Savepoint, ):Void
-
Parameters
- savepoint
- the save point
convenience method to release a save point
public rollback():Void
convenience method to abort a transaction
public rollback(savepoint: Savepoint, ):Void
-
Parameters
- savepoint
- the save point
convenience method to rollback to a save point
public setSavepoint(savepoint: String, ):Savepoint
-
Parameters
- savepoint
- the save point identifier
-
Returns
- Savepoint
- the save point
convenience method to set a save point