com.sankhya.util

Class SQLUtils

java.lang.Object

com.sankhya.util.SQLUtils

public class SQLUtils
extends java.lang.Object

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static interface	SQLUtils.ParameterSetter

Field Summary

Fields

Modifier and Type	Field and Description
static int	IN_CLAUSE_MAX_PARAMS

Method Summary

Modifier and Type	Method and Description
static java.lang.String	appendAnd(java.lang.String sql)
static java.lang.StringBuilder	appendAnd(java.lang.StringBuilder sqlBuilder)
static java.lang.String	appendOr(java.lang.String sql)
static java.lang.StringBuilder	appendOr(java.lang.StringBuilder sqlBuilder)
static java.lang.String	buildINClause(java.lang.String fieldName, int totalPlaceholders)
static java.lang.String	buildINClause(java.lang.String fieldName, int totalPlaceholders, int placeholdersPerClause)
static java.lang.String	buildINClause(java.lang.String fieldName, int totalPlaceholders, int placeholdersPerClause, boolean namedParams)
static java.lang.String	buildINClauseByValues(java.lang.String fieldName, java.util.Collection values)
static java.lang.String	buildINClauseByValues(java.lang.String fieldName, java.util.Collection values, int valuesPerClause, boolean addSimpleQuotes)
static java.lang.String	buildINClauseByValues(java.lang.String fieldName, java.util.Collection values, int valuesPerClause, boolean addSimpleQuotes, boolean useNotIn)
static java.lang.String	buildINClauseByValues(java.lang.String fieldName, java.util.Collection values, int valuesPerClause, boolean addSimpleQuotes, boolean useNotIn, boolean ignoreFieldName)
static java.lang.String	buildINClauseByValues(java.lang.String fieldName, java.lang.String commaSeparatedValues)
static java.lang.String	buildINClauseByValuesWithQuotes(java.lang.String fieldName, java.util.Collection values)
static java.lang.String	buildINClauseByValuesWithQuotes(java.lang.String fieldName, java.util.Collection values, int valuesPerClause)
static java.lang.String	buildINClauseByValuesWithQuotes(java.lang.String fieldName, java.lang.String commaSeparatedValues)
static java.lang.String	buildNOTINClauseByValues(java.lang.String fieldName, java.util.Collection values)
static java.lang.String	buildNOTINClauseByValues(java.lang.String fieldName, java.lang.String commaSeparatedValues)
static void	executeBatchUpdateByValues(java.sql.PreparedStatement pstm, java.lang.Iterable iterable, int batchMaxSize, SQLUtils.ParameterSetter paramSetter)
static java.sql.ResultSet	executeDynamicQuery(java.sql.Connection connection, java.lang.StringBuffer query, java.lang.Object[] params)
static java.lang.String	removeAlias(java.lang.String column)

Methods inherited from class java.lang.Object

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

Field Detail

IN_CLAUSE_MAX_PARAMS

public static final int IN_CLAUSE_MAX_PARAMS

See Also:

Constant Field Values

Method Detail

buildINClause

public static java.lang.String buildINClause(java.lang.String fieldName,
                                             int totalPlaceholders)

buildINClause

public static java.lang.String buildINClause(java.lang.String fieldName,
                                             int totalPlaceholders,
                                             int placeholdersPerClause)

buildINClause

public static java.lang.String buildINClause(java.lang.String fieldName,
                                             int totalPlaceholders,
                                             int placeholdersPerClause,
                                             boolean namedParams)

buildINClauseByValuesWithQuotes

public static java.lang.String buildINClauseByValuesWithQuotes(java.lang.String fieldName,
                                                               java.lang.String commaSeparatedValues)

buildINClauseByValuesWithQuotes

public static java.lang.String buildINClauseByValuesWithQuotes(java.lang.String fieldName,
                                                               java.util.Collection values)

buildINClauseByValuesWithQuotes

public static java.lang.String buildINClauseByValuesWithQuotes(java.lang.String fieldName,
                                                               java.util.Collection values,
                                                               int valuesPerClause)

buildINClauseByValues

public static java.lang.String buildINClauseByValues(java.lang.String fieldName,
                                                     java.util.Collection values,
                                                     int valuesPerClause,
                                                     boolean addSimpleQuotes)

buildINClauseByValues

public static java.lang.String buildINClauseByValues(java.lang.String fieldName,
                                                     java.util.Collection values,
                                                     int valuesPerClause,
                                                     boolean addSimpleQuotes,
                                                     boolean useNotIn)

buildINClauseByValues

public static java.lang.String buildINClauseByValues(java.lang.String fieldName,
                                                     java.util.Collection values,
                                                     int valuesPerClause,
                                                     boolean addSimpleQuotes,
                                                     boolean useNotIn,
                                                     boolean ignoreFieldName)

buildINClauseByValues

public static java.lang.String buildINClauseByValues(java.lang.String fieldName,
                                                     java.lang.String commaSeparatedValues)

buildINClauseByValues

public static java.lang.String buildINClauseByValues(java.lang.String fieldName,
                                                     java.util.Collection values)

buildNOTINClauseByValues

public static java.lang.String buildNOTINClauseByValues(java.lang.String fieldName,
                                                        java.lang.String commaSeparatedValues)

buildNOTINClauseByValues

public static java.lang.String buildNOTINClauseByValues(java.lang.String fieldName,
                                                        java.util.Collection values)

executeDynamicQuery

public static java.sql.ResultSet executeDynamicQuery(java.sql.Connection connection,
                                                     java.lang.StringBuffer query,
                                                     java.lang.Object[] params)
                                              throws java.lang.Exception

Throws:

java.lang.Exception

executeBatchUpdateByValues

public static void executeBatchUpdateByValues(java.sql.PreparedStatement pstm,
                                              java.lang.Iterable iterable,
                                              int batchMaxSize,
                                              SQLUtils.ParameterSetter paramSetter)
                                       throws java.lang.Exception

Throws:

java.lang.Exception

removeAlias

public static java.lang.String removeAlias(java.lang.String column)

appendOr

public static java.lang.StringBuilder appendOr(java.lang.StringBuilder sqlBuilder)

appendOr

public static java.lang.String appendOr(java.lang.String sql)

appendAnd

public static java.lang.StringBuilder appendAnd(java.lang.StringBuilder sqlBuilder)

appendAnd

public static java.lang.String appendAnd(java.lang.String sql)