org.sormula.translator.standard
Class BooleanYNColumnTranslator<R>

java.lang.Object
  org.sormula.translator.AbstractColumnTranslator<R,java.lang.Boolean>
      org.sormula.translator.standard.BooleanYNColumnTranslator<R>

All Implemented Interfaces:

ColumnTranslator<R>

public class BooleanYNColumnTranslator<R>
extends AbstractColumnTranslator<R,java.lang.Boolean>

Translates a boolean field using PreparedStatement.setString(int, String) and ResultSet.getString(int). "Y" is used for true and "N" is used for false.

Since:

1.0

Author:

Jeff Miller

Constructor Summary

BooleanYNColumnTranslator(java.lang.reflect.Field field, java.lang.String columnName)
See super class constructor for description.

Method Summary

void	read(java.sql.ResultSet resultSet, int columnIndex, R row) Reads column value from result set and sets in row object.
void	write(java.sql.PreparedStatement preparedStatement, int parameterIndex, R row) Gets column value from row and sets as parameter in prepared statement.

Methods inherited from class org.sormula.translator.AbstractColumnTranslator

getColumnName, getField, getSormulaField, getTypeTranslator, isIdentity, newInstance, setIdentity, setTypeTranslator

Methods inherited from class java.lang.Object

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

Constructor Detail

BooleanYNColumnTranslator

public BooleanYNColumnTranslator(java.lang.reflect.Field field,
                                 java.lang.String columnName)
                          throws java.lang.Exception

See super class constructor for description.

Throws:

java.lang.Exception

Method Detail

write

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

Gets column value from row and sets as parameter in prepared statement.

Specified by:

write in interface ColumnTranslator<R>

Overrides:

write in class AbstractColumnTranslator<R,java.lang.Boolean>

Parameters:

preparedStatement - set column value as parameter in this statement

parameterIndex - set parameter at this index

row - get value from this row

Throws:

java.lang.Exception - if error

read

public void read(java.sql.ResultSet resultSet,
                 int columnIndex,
                 R row)
          throws java.lang.Exception

Reads column value from result set and sets in row object.

Specified by:

read in interface ColumnTranslator<R>

Overrides:

read in class AbstractColumnTranslator<R,java.lang.Boolean>

Parameters:

resultSet - read column from this result set

columnIndex - read value at this column index from result set

row - set value in this row

Throws:

java.lang.Exception - if error