Module types
Module providing constructors for the various RDBMS data types.
Instance Methods
-
get(resultSet, idx)
-
set(preparedStatement, value, idx)
Instance Methods
-
get(resultSet, idx)
-
set(preparedStatement, value, idx)
Instance Methods
-
getSql(length, precision, scale)
Instance Methods
-
get(resultSet, idx)
-
set(preparedStatement, value, idx)
Instance Methods
-
get(resultSet, idx)
-
set(preparedStatement, value, idx)
Instance Methods
-
get(resultSet, idx)
-
set(preparedStatement, value, idx)
Instance Methods
-
get(resultSet, idx)
-
set(preparedStatement, value, idx)
Instance Methods
-
get(resultSet, idx)
-
set(preparedStatement, value, idx)
Instance Methods
-
get(resultSet, idx)
-
set(preparedStatement, value, idx)
Returns a newly created BinaryType instance
Returns
|
A newly created BinaryType instance |
BinaryType.prototype.get
(resultSet, idx)
Called to retrieve the value from a resultset
Parameters
java.sql.ResultSet |
resultSet |
The resultset to retrieve the value from |
Number |
idx |
The 1-based index position of the column |
Returns
ByteArray |
The result set value at the given column index position |
BinaryType.prototype.set
(preparedStatement, value, idx)
Sets the column value in the prepared statement
Parameters
java.sql.PreparedStatement |
preparedStatement |
The statement |
Object |
value |
The value |
Number |
idx |
The 1-based index position of the column |
Returns a newly created BooleanType instance
Returns
|
A newly created BooleanType instance |
BooleanType.prototype.get
(resultSet, idx)
Called to retrieve the value from a resultset
Parameters
java.sql.ResultSet |
resultSet |
The resultset to retrieve the value from |
Number |
idx |
The 1-based index position of the column |
Returns
Boolean |
The result set value at the given column index position |
BooleanType.prototype.set
(preparedStatement, value, idx)
Sets the column value in the prepared statement
Parameters
java.sql.PreparedStatement |
preparedStatement |
The statement |
Object |
value |
The value |
Number |
idx |
The 1-based index position of the column |
ColumnType
(jdbcType, sql, options)
Creates a new ColumnType instance
Parameters
Number |
jdbcType |
The JDBC type of the column |
String |
sql |
The SQL string used to create the column |
Object |
options |
Optional settings for the column |
Returns
|
A newly created ColumnType instance |
ColumnType.prototype.getSql
(length, precision, scale)
Returns the SQL statement fragment to create the column. Arguments override
any options defined in the database dialect.
Parameters
Number |
length |
Optional length |
Number |
precision |
Optional precision |
Number |
scale |
Optional scale |
Returns
String |
The SQL statement fragment creating the column |
Returns a newly created DateType instance
Returns
|
A newly created DateType instance |
DateType.prototype.get
(resultSet, idx)
Called to retrieve the value from a resultset
Parameters
java.sql.ResultSet |
resultSet |
The resultset to retrieve the value from |
Number |
idx |
The 1-based index position of the column |
Returns
Date |
The result set value at the given column index position |
DateType.prototype.set
(preparedStatement, value, idx)
Sets the column value in the prepared statement
Parameters
java.sql.PreparedStatement |
preparedStatement |
The statement |
Object |
value |
The value |
Number |
idx |
The 1-based index position of the column |
Returns a newly created FloatType instance
Returns
|
A newly created FloatType instance |
FloatType.prototype.get
(resultSet, idx)
Called to retrieve the value from a resultset
Parameters
java.sql.ResultSet |
resultSet |
The resultset to retrieve the value from |
Number |
idx |
The 1-based index position of the column |
Returns
Number |
The result set value at the given column index position |
FloatType.prototype.set
(preparedStatement, value, idx)
Sets the column value in the prepared statement
Parameters
java.sql.PreparedStatement |
preparedStatement |
The statement |
Object |
value |
The value |
Number |
idx |
The 1-based index position of the column |
Returns a newly created IntegerType instance
Returns
|
A newly created IntegerType instance |
IntegerType.prototype.get
(resultSet, idx)
Called to retrieve the value from a resultset
Parameters
java.sql.ResultSet |
resultSet |
The resultset to retrieve the value from |
Number |
idx |
The 1-based index position of the column |
Returns
Number |
The result set value at the given column index position |
IntegerType.prototype.set
(preparedStatement, value, idx)
Sets the column value in the prepared statement
Parameters
java.sql.PreparedStatement |
preparedStatement |
The statement |
Object |
value |
The value |
Number |
idx |
The 1-based index position of the column |
Returns a newly created StringType instance
Returns
|
A newly created StringType instance |
StringType.prototype.get
(resultSet, idx)
Called to retrieve the value from a resultset
Parameters
java.sql.ResultSet |
resultSet |
The resultset to retrieve the value from |
Number |
idx |
The 1-based index position of the column |
Returns
String |
The result set value at the given column index position |
StringType.prototype.set
(preparedStatement, value, idx)
Sets the column value in the prepared statement
Parameters
java.sql.PreparedStatement |
preparedStatement |
The statement |
Object |
value |
The value |
Number |
idx |
The 1-based index position of the column |
Returns a newly created TimeType instance
Returns
|
A newly created TimeType instance |
TimeType.prototype.get
(resultSet, idx)
Called to retrieve the value from a resultset
Parameters
java.sql.ResultSet |
resultSet |
The resultset to retrieve the value from |
Number |
idx |
The 1-based index position of the column |
Returns
Date |
The result set value at the given column index position |
TimeType.prototype.set
(preparedStatement, value, idx)
Sets the column value in the prepared statement
Parameters
java.sql.PreparedStatement |
preparedStatement |
The statement |
Object |
value |
The value |
Number |
idx |
The 1-based index position of the column |
Returns a newly created TimestampType instance
Returns
|
A newly created TimestampType instance |
TimestampType.prototype.get
(resultSet, idx)
Called to retrieve the value from a resultset
Parameters
java.sql.ResultSet |
resultSet |
The resultset to retrieve the value from |
Number |
idx |
The 1-based index position of the column |
Returns
Date |
The result set value at the given column index position |
TimestampType.prototype.set
(preparedStatement, value, idx)
Sets the column value in the prepared statement
Parameters
java.sql.PreparedStatement |
preparedStatement |
The statement |
Object |
value |
The value |
Number |
idx |
The 1-based index position of the column |