Module types

Module providing constructors for the various RDBMS data types.

Class BinaryType

Instance Methods

  • get(resultSet, idx)
  • set(preparedStatement, value, idx)

Class BooleanType

Instance Methods

  • get(resultSet, idx)
  • set(preparedStatement, value, idx)

Class ColumnType

Instance Methods

Class DateType

Instance Methods

  • get(resultSet, idx)
  • set(preparedStatement, value, idx)

Class FloatType

Instance Methods

  • get(resultSet, idx)
  • set(preparedStatement, value, idx)

Class IntegerType

Instance Methods

  • get(resultSet, idx)
  • set(preparedStatement, value, idx)

Class StringType

Instance Methods

  • get(resultSet, idx)
  • set(preparedStatement, value, idx)

Class TimeType

Instance Methods

  • get(resultSet, idx)
  • set(preparedStatement, value, idx)

Class TimestampType

Instance Methods

  • get(resultSet, idx)
  • set(preparedStatement, value, idx)

BinaryType ()

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

BooleanType ()

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

DateType ()

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

FloatType ()

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

IntegerType ()

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

StringType ()

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

TimeType ()

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

TimestampType ()

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