Overview

JavaFX Framework for access to Relational Databases via JDBC

Attribute Summary

nametypedescription
Public
autoCommitBoolean

indicates if the connection is in autoCommit mode or not.

dataSourceDataSource

the DataSource to use to establish the database connection.

dbUrlString

optional database connection URL If a dataSource is provided, it will be used to establish the connection.

passwordString

optional connection password

statementStatement

holds a resuable statement

userString

optional connection user id

warningsWarning[]

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 getConnection():Connection

Returns
Connection
the connection

get the database connection

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