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.

Use this to override the standard translator attribute, translator in Column annotation:

 @Column(translator=BooleanYNColumnTranslator.class) 
 boolean someBoolean;
 

An alternative is to use BooleanYNTranslator:

 @ImplicitType(translator=BooleanYNTranslator.class) 
 boolean someBoolean;
 

Since:

1.0

Author:

Jeff Miller

Constructor Summary

Constructors

Constructor and Description
BooleanYNColumnTranslator(RowField<R,java.lang.Boolean> rowField, java.lang.String columnName) Constructs for a RowField and column name.

Method Summary

Modifier and Type	Method and Description
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, getRowField, getTypeTranslator, isIdentity, isReadOnly, newInstance, setIdentity, setReadOnly, setTypeTranslator

Methods inherited from class java.lang.Object

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

Constructor Detail

BooleanYNColumnTranslator

public BooleanYNColumnTranslator(RowField<R,java.lang.Boolean> rowField,
                                 java.lang.String columnName)
                          throws java.lang.Exception

Constructs for a RowField and column name.

Parameters:

rowField - field within row class that contains the boolean

columnName - sql column name associated with rowField

Throws:

java.lang.Exception - if error

Since:

3.4

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