$jdbc

( documentation for Telosys generator version 4.1.0 )

Object providing the JDBC SQL requests for a given entity

Since : 2.1.1

Attributes and methods

.attributesForInsert : List

Returns the list of all the attributes required for the SQL INSERT
All the attributes required to populate the PreparedStatement from a bean instance

Example :
$jdbc.attributesForInsert
Since : 2.1.1

.attributesForPrimaryKey : List

Returns the list of all the attributes required for the Primary Key

Example :
$jdbc.attributesForPrimaryKey
Since : 2.1.1

.attributesForSelect : List

Returns the list of all the attributes required for the SQL SELECT
All the attributes required to populate the bean instance from the result set

Example :
$jdbc.attributesForSelect
Since : 2.1.1

.attributesForUpdate : List

Returns the list of all the attributes required for the SQL UPDATE

Example :
$jdbc.attributesForUpdate
Since : 2.1.1

.sqlDelete : String

Returns the JDBC SQL DELETE request

Example :
$jdbc.sqlDelete
Since : 2.1.1

.sqlInsert : String

Returns the JDBC SQL INSERT request

Example :
$jdbc.sqlInsert
Since : 2.1.1

.sqlSelect : String

Returns the JDBC SQL 'SELECT xxx FROM xxx' request

Example :
$jdbc.sqlSelect
Since : 3.0.0

.sqlSelectCount : String

Returns the JDBC SQL 'SELECT COUNT(*) FROM xxx' request

Example :
$jdbc.sqlSelectCount
Since : 3.0.0

.sqlSelectCountWherePK : String

Returns the JDBC SQL 'SELECT COUNT(*) FROM xxx WHERE pk = xxx' request
Can be used to check the existence of a record for the given PK

Example :
$jdbc.sqlSelectCountWherePK
Since : 3.0.0

.sqlSelectWherePK : String

Returns the JDBC SQL 'SELECT xxx FROM xxx WHERE pk = xxx' request

Example :
$jdbc.sqlSelectWherePK
Since : 3.0.0

.sqlUpdate : String

Returns the JDBC SQL UPDATE request

Example :
$jdbc.sqlUpdate
Since : 2.1.1