Package org.pjdbc.sql

Interface JdbcTransformer

All Known Implementing Classes:

AbstractJdbcTransformer, CompositeTransformer, RenameTransformer, SchemaTransformer, WhereTransformer

public interface JdbcTransformer

Unified interface for JDBC transformation. Handles input (SQL, parameters) and output (ResultSet values) transformation. Implementations can transform: - SQL strings before execution - Parameter values before binding to PreparedStatements - ResultSet values when retrieved

Method Summary

Modifier and Type	Method	Description
Object	transformParameter(int parameterIndex, Object value, int sqlType)	Transform a parameter before binding to a PreparedStatement.
Object	transformResultValue(int columnIndex, String columnName, Object value, int sqlType)	Transform a value retrieved from a ResultSet.
String	transformSql(String sql)	Transform SQL before execution.

Method Details

transformSql

String transformSql(String sql)
             throws SQLException

Transform SQL before execution.

Parameters:

sql - Original SQL string

Returns:

Transformed SQL string

Throws:

SQLException - if transformation fails

transformParameter

Object transformParameter(int parameterIndex,
 Object value,
 int sqlType)
                   throws SQLException

Transform a parameter before binding to a PreparedStatement.

Parameters:

parameterIndex - 1-based parameter index

value - Original parameter value

sqlType - SQL type from java.sql.Types

Returns:

Transformed parameter value

Throws:

SQLException - if transformation fails

transformResultValue

Object transformResultValue(int columnIndex,
 String columnName,
 Object value,
 int sqlType)
                     throws SQLException

Transform a value retrieved from a ResultSet.

Parameters:

columnIndex - 1-based column index

columnName - Column name (may be null if not available)

value - Original value from ResultSet

sqlType - SQL type from java.sql.Types

Returns:

Transformed value

Throws:

SQLException - if transformation fails