sk.vracon.sqlcomments.core

Class StatementGenerator

java.lang.Object

sk.vracon.sqlcomments.core.StatementGenerator

public class StatementGenerator
extends Object

Utility class to process statement objects and generate JPA and JDBC statements.

To log generated statement string, setup logging for this class to debug level.

Constructor Summary

Constructors

Constructor and Description
StatementGenerator()

Method Summary

Methods

Modifier and Type	Method and Description
CallableStatement	createPreparedCall(Connection connection, Statement statement, Map<String,Object> parameters, Set<String> acceptNullParameters) Creates callable statement for given JDBC connection and parameters.
PreparedStatement	createPreparedStatement(Connection connection, Statement statement, Map<String,Object> parameters, Set<String> acceptNullParameters, Long offset, Long limit, boolean withKeys) Creates prepared statement for given JDBC connection and parameters.
PreparedStatement	createPreparedStatement(Connection connection, Statement statement, Map<String,Object> parameters, Set<String> acceptNullParameters, Long offset, Long limit, String[] keysToGenerate) Creates prepared statement for given JDBC connection and parameters.
String	generateJdbcStatement(Statement statement, Map<String,Object> parameters, Set<String> acceptNullParameters, List<Object> jdbcParams, Long offset, Long limit) Creates JDBC-like statement string.
String	generateStatement(Statement statement, Map<String,Object> parameters, Set<String> acceptNullParameters, Long offset, Long limit) Creates statement string.
void	setDialect(DatabaseDialect dialect) Sets database dialect to use.

Methods inherited from class java.lang.Object

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

Constructor Detail

StatementGenerator

public StatementGenerator()

Method Detail

createPreparedStatement

public PreparedStatement createPreparedStatement(Connection connection,
                                        Statement statement,
                                        Map<String,Object> parameters,
                                        Set<String> acceptNullParameters,
                                        Long offset,
                                        Long limit,
                                        boolean withKeys)
                                          throws StatementException

Creates prepared statement for given JDBC connection and parameters.

Parameters:

connection - JDBC connection

statement - statement to process

parameters - parameters to use

acceptNullParameters - names of parameters accepting null values

offset - result set offset

limit - result set limit

withKeys - if true prepared statement will return auto-generated keys

Throws:

StatementException

See Also:

Connection.prepareStatement(String, int)

createPreparedStatement

public PreparedStatement createPreparedStatement(Connection connection,
                                        Statement statement,
                                        Map<String,Object> parameters,
                                        Set<String> acceptNullParameters,
                                        Long offset,
                                        Long limit,
                                        String[] keysToGenerate)
                                          throws StatementException

Creates prepared statement for given JDBC connection and parameters.

Parameters:

connection - JDBC connection

statement - statement to process

parameters - parameters to use

acceptNullParameters - names of parameters accepting null values

offset - result set offset

limit - result set limit

keysToGenerate - list of keys to generate

Throws:

StatementException

See Also:

Connection.prepareStatement(String, String[])

createPreparedCall

public CallableStatement createPreparedCall(Connection connection,
                                   Statement statement,
                                   Map<String,Object> parameters,
                                   Set<String> acceptNullParameters)
                                     throws StatementException

Creates callable statement for given JDBC connection and parameters.

Parameters:

connection - JDBC connection

statement - statement to process

parameters - parameters to use

acceptNullParameters - names of parameters accepting null values

Throws:

StatementException

generateJdbcStatement

public String generateJdbcStatement(Statement statement,
                           Map<String,Object> parameters,
                           Set<String> acceptNullParameters,
                           List<Object> jdbcParams,
                           Long offset,
                           Long limit)

Creates JDBC-like statement string.

This method is useful when standard createPreparedCall(Connection, Statement, Map, Set) and #createPreparedStatement(Connection, Statement, Map, Set, boolean) are not enough. It returns generated statement string with replaced SQL parameters by '?' and parameter values are put into jdbcParams list.

Parameters:

statement - statement to process

parameters - parameters to use

acceptNullParameters - names of parameters accepting null values

jdbcParams - list where will be generated JDBC parameters

offset - result set offset

limit - result set limit

Returns:

generated JDBC-like statement

See Also:

#generateStatement(Statement, Map, Set)

generateStatement

public String generateStatement(Statement statement,
                       Map<String,Object> parameters,
                       Set<String> acceptNullParameters,
                       Long offset,
                       Long limit)
                         throws ScriptException

Creates statement string.

Statement is processed row by row. Row is omitted if:

1. Parameters in SQL is missing or has null value and is not mentioned in acceptNullValues.
2. Control script didn't return 'true'.

All replacement parameters are replaced by value. If there's no parameter with appropriate name, replacement is left without change.

This method is could be used for generating JPA statements.

Parameters:

statement - statement to process

parameters - parameters to use

acceptNullParameters - names of parameters accepting null values

offset - result set offset

limit - result set limit

Returns:

constructed statement string without replaced SQL parameters

Throws:

ScriptException

setDialect

public void setDialect(DatabaseDialect dialect)

Sets database dialect to use.

Parameters:

dialect - database dialect