org.sormula.translator.standard

Class SqlDateTranslator

java.lang.Object

org.sormula.translator.standard.SqlDateTranslator

All Implemented Interfaces:

TypeTranslator<java.sql.Date>

public class SqlDateTranslator
extends java.lang.Object
implements TypeTranslator<java.sql.Date>

Translates using PreparedStatement.setDate(int, java.sql.Date) and ResultSet.getDate(int). This translator is available by default for all tables when Database is created.

Since:

1.6 and 2.0

Author:

Jeff Miller

Constructor Summary

Constructors

Constructor and Description
SqlDateTranslator()

Method Summary

Modifier and Type	Method and Description
java.sql.Date	read(java.sql.ResultSet resultSet, int columnIndex) Reads value from result set.
void	write(java.sql.PreparedStatement preparedStatement, int parameterIndex, java.sql.Date parameter) Sets parameter value in the prepared statement.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

SqlDateTranslator

public SqlDateTranslator()

Method Detail

write

public void write(java.sql.PreparedStatement preparedStatement,
                  int parameterIndex,
                  java.sql.Date parameter)
           throws java.lang.Exception

Sets parameter value in the prepared statement.

Specified by:

write in interface TypeTranslator<java.sql.Date>

Parameters:

preparedStatement - set column value as parameter in this statement

parameterIndex - set parameter at this index

parameter - value to set in prepared statement

Throws:

java.lang.Exception - if error

read

public java.sql.Date read(java.sql.ResultSet resultSet,
                          int columnIndex)
                   throws java.lang.Exception

Reads value from result set.

Specified by:

read in interface TypeTranslator<java.sql.Date>

Parameters:

resultSet - read value from this result set

columnIndex - read value at this column index from result set

Returns:

result set value at parameter index

Throws:

java.lang.Exception - if error