org.julp.db

Class DBServicesUtils

java.lang.Object

org.julp.db.DBServicesUtils

All Implemented Interfaces:

java.io.Serializable

public class DBServicesUtils
extends java.lang.Object
implements java.io.Serializable

See Also:

Serialized Form

Field Summary

Fields

Modifier and Type	Field and Description
protected static java.lang.String	COMMA
protected java.lang.String	dateFormat
protected java.text.SimpleDateFormat	dateFormatter
protected java.lang.String	dateTimeFormat
protected java.text.SimpleDateFormat	dateTimeFormatter
protected DBServices	dbServices
protected java.lang.String	decimalFormat
protected java.text.DecimalFormat	decimalFormatter
protected static java.lang.String	DOT
protected static java.lang.String	PARAM_PLACEHOLDER
protected static java.lang.String	SINGLE_QUOTE
protected java.lang.String	timeFormat
protected java.text.SimpleDateFormat	timeFormatter
protected java.lang.String	timestampFormat
protected java.text.SimpleDateFormat	timestampFormatter
protected java.lang.String	zoneId

Constructor Summary

Constructors

Constructor and Description
DBServicesUtils()
DBServicesUtils(DBServices dbServices)

Method Summary

Modifier and Type	Method and Description
java.lang.CharSequence	buildInClause(java.util.Collection<?> params)
java.lang.CharSequence	buildInClause(java.util.Collection<java.lang.String> columnNames, java.util.Collection<java.util.Collection<?>> params, int max) Used together with public CharSequence buildInClause(List<String> columnNames, Collection<Collection> params, int max) to build SQL IN clause
java.lang.CharSequence	buildInClause(java.lang.String columnName, java.util.Collection<?> params, int max) Build 'IN' clause.
java.lang.String	convert(java.lang.String sql, java.util.Collection<?> params) Convert PreparedStatement's SQL and parameters for use in Statement or logging by replacing "?" with parameters values
java.util.Collection<?>	flattenMultiColumnsParams(java.util.Collection<java.util.Collection<?>> params)
java.util.Collection<?>	flattenParams(java.util.Collection<java.util.Collection<?>> params)
protected java.lang.String	formatDate(java.util.Date d)
protected java.lang.String	formatDateTime(java.util.Date d)
protected java.lang.String	formatDecimal(java.lang.Number n)
protected java.lang.String	formatTime(java.sql.Time t)
protected java.lang.String	formatTimestamp(java.sql.Timestamp ts)
java.lang.String	getDateFormat()
java.lang.String	getDateTimeFormat()
DBServices	getDBServices()
java.lang.String	getDecimalFormat()
DataHolder[]	getResultAsDataHoldersArray(java.lang.String sql)
DataHolder[]	getResultAsDataHoldersArray(java.lang.String sql, boolean populateColumnNames)
DataHolder[]	getResultAsDataHoldersArray(java.lang.String sql, java.util.Collection<?> params)
DataHolder[]	getResultAsDataHoldersArray(java.lang.String sql, java.util.Collection<?> params, boolean populateColumnNames)
java.util.List<DataHolder>	getResultAsDataHoldersList(java.lang.String sql)
java.util.List<DataHolder>	getResultAsDataHoldersList(java.lang.String sql, boolean populateColumnNames)
java.util.List<DataHolder>	getResultAsDataHoldersList(java.lang.String sql, java.util.Collection<?> params)
java.util.List<DataHolder>	getResultAsDataHoldersList(java.lang.String sql, java.util.Collection<?> params, boolean populateColumnNames)
protected java.util.List<DataHolder>	getResultAsDataHoldersListInternal(boolean populateColumnNames)
java.util.List<java.util.List<?>>	getResultAsList(java.lang.String sql)
java.util.List<java.util.List<?>>	getResultAsList(java.lang.String sql, java.util.Collection<?> params)
protected java.util.List<java.util.List<?>>	getResultAsListInternal()
java.util.List<java.util.Map<java.lang.String,?>>	getResultAsListOfMaps(java.lang.String sql)
java.util.List<java.util.Map<java.lang.String,?>>	getResultAsListOfMaps(java.lang.String sql, java.util.Collection<?> params)
protected java.util.List<java.util.Map<java.lang.String,?>>	getResultAsListOfMapsInternal()
java.util.Map<java.lang.String,java.util.List<?>>	getResultAsMap(java.lang.String sql)
java.util.Map<java.lang.String,java.util.List<?>>	getResultAsMap(java.lang.String sql, java.util.Collection<?> params)
protected java.util.Map<java.lang.String,java.util.List<?>>	getResultAsMapInternal()
java.util.List<MultiValueObject>	getResultAsMultiValueObjectList(java.lang.String sql)
java.util.List<MultiValueObject>	getResultAsMultiValueObjectList(java.lang.String sql, java.util.Collection<?> params)
protected java.util.List<MultiValueObject>	getResultAsMultiValueObjectListInternal()
<T> java.util.List<ValueObject<T>>	getResultAsValueObjectList(java.lang.String sql)
<T> java.util.List<ValueObject<T>>	getResultAsValueObjectList(java.lang.String sql, java.util.Collection<?> params)
protected <T> java.util.List<ValueObject<T>>	getResultAsValueObjectListInternal()
DataHolder[]	getResultsAsDataHoldersArray(java.lang.String sql, java.util.Collection<?> params)
DataHolder[]	getResultsAsDataHoldersArray(java.lang.String sql, java.util.Collection<?> params, boolean populateColumnNames)
DataHolder[]	getResultsAsDataHoldersArray(java.lang.String sql, java.util.Collection<?> params, int maxNumberOfParams, java.lang.String placeHolder)
DataHolder[]	getResultsAsDataHoldersArray(java.lang.String sql, java.util.Collection<?> params, int maxNumberOfParams, java.lang.String placeHolder, boolean populateColumnNames)
java.util.List<DataHolder>	getResultsAsDataHoldersList(java.lang.String sql, java.util.Collection<?> params)
java.util.List<DataHolder>	getResultsAsDataHoldersList(java.lang.String sql, java.util.Collection<?> params, boolean populateColumnNames)
java.util.List<DataHolder>	getResultsAsDataHoldersList(java.lang.String sql, java.util.Collection<?> params, int maxNumberOfParams, java.lang.String placeHolder)
java.util.List<DataHolder>	getResultsAsDataHoldersList(java.lang.String sql, java.util.Collection<?> params, int maxNumberOfParams, java.lang.String placeHolder, boolean populateColumnNames)
protected java.util.List<DataHolder>	getResultsAsDataHoldersListInternal(boolean populateColumnNames)
java.util.List<java.util.List<?>>	getResultsAsList(java.lang.String sql, java.util.Collection<?> params)
java.util.List<java.util.List<?>>	getResultsAsList(java.lang.String sql, java.util.Collection<?> params, int maxNumberOfParams, java.lang.String placeHolder)
protected java.util.List<java.util.List<?>>	getResultsAsListInternal()
java.util.Map<java.lang.String,java.util.List<?>>	getResultsAsMap(java.lang.String sql, java.util.Collection<?> params)
java.util.Map<java.lang.String,java.util.List<?>>	getResultsAsMap(java.lang.String sql, java.util.Collection<?> params, int maxNumberOfParams, java.lang.String placeHolder)
protected java.util.Map<java.lang.String,java.util.List<?>>	getResultsAsMapInternal()
java.util.List<MultiValueObject>	getResultsAsMultiValueObjectList(java.lang.String sql, java.util.Collection<?> params)
java.util.List<MultiValueObject>	getResultsAsMultiValueObjectList(java.lang.String sql, java.util.Collection<?> params, int maxNumberOfParams, java.lang.String placeHolder)
protected java.util.List<MultiValueObject>	getResultsAsMultiValueObjectListInternal()
<T> java.util.List<ValueObject<T>>	getResultsAsValueObjectList(java.lang.String sql, java.util.Collection<?> params)
<T> java.util.List<ValueObject<T>>	getResultsAsValueObjectList(java.lang.String sql, java.util.Collection<?> params, int maxNumberOfParams, java.lang.String placeHolder)
protected <T> java.util.List<ValueObject<T>>	getResultsAsValueObjectListInternal()
<T> java.util.List<T>	getSingleColumnResultAsList(java.lang.String sql)
<T> java.util.List<T>	getSingleColumnResultAsList(java.lang.String sql, java.util.Collection<?> params)
protected <T> java.util.List<T>	getSingleColumnResultAsListInternal()
<T> java.util.List<T>	getSingleColumnResultsAsList(java.lang.String sql, java.util.Collection<?> params, int maxNumberOfParams, java.lang.String placeHolder)
<T> java.util.List<T>	getSingleColumnResultsAsList(java.lang.String sql, java.util.List<?> params)
protected <T> java.util.List<T>	getSingleColumnResultsAsListInternal()
<T> T	getSingleValue(java.lang.String sql)
<T> T	getSingleValue(java.lang.String sql, java.util.Collection<?> params)
protected <T> T	getSingleValueInternal()
java.lang.String	getTimeFormat()
java.lang.String	getTimestampFormat()
<K,V> java.util.Map<K,V>	getTwoColumnsResultAsLinkedMap(java.lang.String sql)
<K,V> java.util.Map<K,V>	getTwoColumnsResultAsLinkedMap(java.lang.String sql, java.util.Collection<?> params)
protected <K,V> java.util.Map<K,V>	getTwoColumnsResultAsLinkedMapInternal()
<K,V> java.util.Map<K,V>	getTwoColumnsResultAsMap(java.lang.String sql)
<K,V> java.util.Map<K,V>	getTwoColumnsResultAsMap(java.lang.String sql, java.util.Collection<?> params)
protected <K,V> java.util.Map<K,V>	getTwoColumnsResultAsMapInternal()
<K,V> java.util.Map<K,V>	getTwoColumnsResultsAsLinkedMap(java.lang.String sql, java.util.Collection<?> params, int maxNumberOfParams, java.lang.String placeHolder)
<K,V> java.util.Map<K,V>	getTwoColumnsResultsAsMap(java.lang.String sql, java.util.Collection<?> params, int maxNumberOfParams, java.lang.String placeHolder)
protected <K,V> java.util.Map<K,V>	getTwoColumnsResultsAsMapInternal()
void	setDateFormat(java.lang.String dateFormat)
void	setDateTimeFormat(java.lang.String dateTimeFormat)
void	setDBServices(DBServices dbServices)
void	setDecimalFormat(java.lang.String decimalFormat)
void	setTimeFormat(java.lang.String timeFormat)
void	setTimestampFormat(java.lang.String timestampFormat)

Methods inherited from class java.lang.Object

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

Field Detail

dateFormat

protected java.lang.String dateFormat

dateTimeFormat

protected java.lang.String dateTimeFormat

timestampFormat

protected java.lang.String timestampFormat

timeFormat

protected java.lang.String timeFormat

decimalFormat

protected java.lang.String decimalFormat

PARAM_PLACEHOLDER

protected static final java.lang.String PARAM_PLACEHOLDER

See Also:

Constant Field Values

SINGLE_QUOTE

protected static final java.lang.String SINGLE_QUOTE

See Also:

Constant Field Values

DOT

protected static final java.lang.String DOT

See Also:

Constant Field Values

COMMA

protected static final java.lang.String COMMA

See Also:

Constant Field Values

dbServices

protected DBServices dbServices

dateFormatter

protected java.text.SimpleDateFormat dateFormatter

dateTimeFormatter

protected java.text.SimpleDateFormat dateTimeFormatter

timestampFormatter

protected java.text.SimpleDateFormat timestampFormatter

timeFormatter

protected java.text.SimpleDateFormat timeFormatter

decimalFormatter

protected java.text.DecimalFormat decimalFormatter

zoneId

protected java.lang.String zoneId

Constructor Detail

DBServicesUtils

public DBServicesUtils()

DBServicesUtils

public DBServicesUtils(DBServices dbServices)

Method Detail

convert

public java.lang.String convert(java.lang.String sql,
                                java.util.Collection<?> params)

Convert PreparedStatement's SQL and parameters for use in Statement or logging by replacing "?" with parameters values

formatDate

protected java.lang.String formatDate(java.util.Date d)

formatDateTime

protected java.lang.String formatDateTime(java.util.Date d)

formatTime

protected java.lang.String formatTime(java.sql.Time t)

formatTimestamp

protected java.lang.String formatTimestamp(java.sql.Timestamp ts)

formatDecimal

protected java.lang.String formatDecimal(java.lang.Number n)

getDateFormat

public java.lang.String getDateFormat()

setDateFormat

public void setDateFormat(java.lang.String dateFormat)

getTimestampFormat

public java.lang.String getTimestampFormat()

setTimestampFormat

public void setTimestampFormat(java.lang.String timestampFormat)

getTimeFormat

public java.lang.String getTimeFormat()

setTimeFormat

public void setTimeFormat(java.lang.String timeFormat)

getDateTimeFormat

public java.lang.String getDateTimeFormat()

setDateTimeFormat

public void setDateTimeFormat(java.lang.String dateTimeFormat)

getDecimalFormat

public java.lang.String getDecimalFormat()

setDecimalFormat

public void setDecimalFormat(java.lang.String decimalFormat)

getResultAsDataHoldersArray

public DataHolder[] getResultAsDataHoldersArray(java.lang.String sql,
                                                java.util.Collection<?> params,
                                                boolean populateColumnNames)
                                         throws java.sql.SQLException

Throws:

java.sql.SQLException

getResultAsDataHoldersArray

public DataHolder[] getResultAsDataHoldersArray(java.lang.String sql,
                                                boolean populateColumnNames)
                                         throws java.sql.SQLException

Throws:

java.sql.SQLException

getResultAsDataHoldersArray

public DataHolder[] getResultAsDataHoldersArray(java.lang.String sql)
                                         throws java.sql.SQLException

Throws:

java.sql.SQLException

getResultAsDataHoldersArray

public DataHolder[] getResultAsDataHoldersArray(java.lang.String sql,
                                                java.util.Collection<?> params)
                                         throws java.sql.SQLException

Throws:

java.sql.SQLException

getResultsAsDataHoldersArray

public DataHolder[] getResultsAsDataHoldersArray(java.lang.String sql,
                                                 java.util.Collection<?> params)
                                          throws java.sql.SQLException

Throws:

java.sql.SQLException

getResultsAsDataHoldersArray

public DataHolder[] getResultsAsDataHoldersArray(java.lang.String sql,
                                                 java.util.Collection<?> params,
                                                 boolean populateColumnNames)
                                          throws java.sql.SQLException

Throws:

java.sql.SQLException

getResultsAsDataHoldersArray

public DataHolder[] getResultsAsDataHoldersArray(java.lang.String sql,
                                                 java.util.Collection<?> params,
                                                 int maxNumberOfParams,
                                                 java.lang.String placeHolder)
                                          throws java.sql.SQLException

Throws:

java.sql.SQLException

getResultsAsDataHoldersArray

public DataHolder[] getResultsAsDataHoldersArray(java.lang.String sql,
                                                 java.util.Collection<?> params,
                                                 int maxNumberOfParams,
                                                 java.lang.String placeHolder,
                                                 boolean populateColumnNames)
                                          throws java.sql.SQLException

Throws:

java.sql.SQLException

getSingleValue

public <T> T getSingleValue(java.lang.String sql)
                     throws java.sql.SQLException

Throws:

java.sql.SQLException

getSingleValue

public <T> T getSingleValue(java.lang.String sql,
                            java.util.Collection<?> params)
                     throws java.sql.SQLException

Throws:

java.sql.SQLException

getSingleValueInternal

protected <T> T getSingleValueInternal()
                                throws java.sql.SQLException

Throws:

java.sql.SQLException

getSingleColumnResultAsList

public <T> java.util.List<T> getSingleColumnResultAsList(java.lang.String sql)
                                                  throws java.sql.SQLException

Throws:

java.sql.SQLException

getSingleColumnResultAsList

public <T> java.util.List<T> getSingleColumnResultAsList(java.lang.String sql,
                                                         java.util.Collection<?> params)
                                                  throws java.sql.SQLException

Throws:

java.sql.SQLException

getSingleColumnResultAsListInternal

protected <T> java.util.List<T> getSingleColumnResultAsListInternal()
                                                             throws java.sql.SQLException

Throws:

java.sql.SQLException

getSingleColumnResultsAsList

public <T> java.util.List<T> getSingleColumnResultsAsList(java.lang.String sql,
                                                          java.util.Collection<?> params,
                                                          int maxNumberOfParams,
                                                          java.lang.String placeHolder)
                                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

getSingleColumnResultsAsList

public <T> java.util.List<T> getSingleColumnResultsAsList(java.lang.String sql,
                                                          java.util.List<?> params)
                                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

getSingleColumnResultsAsListInternal

protected <T> java.util.List<T> getSingleColumnResultsAsListInternal()
                                                              throws java.sql.SQLException

Throws:

java.sql.SQLException

getTwoColumnsResultAsLinkedMap

public <K,V> java.util.Map<K,V> getTwoColumnsResultAsLinkedMap(java.lang.String sql)
                                                        throws java.sql.SQLException

Throws:

java.sql.SQLException

getTwoColumnsResultAsLinkedMap

public <K,V> java.util.Map<K,V> getTwoColumnsResultAsLinkedMap(java.lang.String sql,
                                                               java.util.Collection<?> params)
                                                        throws java.sql.SQLException

Throws:

java.sql.SQLException

getTwoColumnsResultAsLinkedMapInternal

protected <K,V> java.util.Map<K,V> getTwoColumnsResultAsLinkedMapInternal()
                                                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

getTwoColumnsResultsAsLinkedMap

public <K,V> java.util.Map<K,V> getTwoColumnsResultsAsLinkedMap(java.lang.String sql,
                                                                java.util.Collection<?> params,
                                                                int maxNumberOfParams,
                                                                java.lang.String placeHolder)
                                                         throws java.sql.SQLException

Throws:

java.sql.SQLException

getTwoColumnsResultsAsMap

public <K,V> java.util.Map<K,V> getTwoColumnsResultsAsMap(java.lang.String sql,
                                                          java.util.Collection<?> params,
                                                          int maxNumberOfParams,
                                                          java.lang.String placeHolder)
                                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

getTwoColumnsResultsAsMapInternal

protected <K,V> java.util.Map<K,V> getTwoColumnsResultsAsMapInternal()
                                                              throws java.sql.SQLException

Throws:

java.sql.SQLException

getTwoColumnsResultAsMap

public <K,V> java.util.Map<K,V> getTwoColumnsResultAsMap(java.lang.String sql)
                                                  throws java.sql.SQLException

Throws:

java.sql.SQLException

getTwoColumnsResultAsMap

public <K,V> java.util.Map<K,V> getTwoColumnsResultAsMap(java.lang.String sql,
                                                         java.util.Collection<?> params)
                                                  throws java.sql.SQLException

Throws:

java.sql.SQLException

getTwoColumnsResultAsMapInternal

protected <K,V> java.util.Map<K,V> getTwoColumnsResultAsMapInternal()
                                                             throws java.sql.SQLException

Throws:

java.sql.SQLException

getResultAsValueObjectList

public <T> java.util.List<ValueObject<T>> getResultAsValueObjectList(java.lang.String sql)
                                                              throws java.sql.SQLException

Throws:

java.sql.SQLException

getResultAsValueObjectList

public <T> java.util.List<ValueObject<T>> getResultAsValueObjectList(java.lang.String sql,
                                                                     java.util.Collection<?> params)
                                                              throws java.sql.SQLException

Throws:

java.sql.SQLException

getResultAsValueObjectListInternal

protected <T> java.util.List<ValueObject<T>> getResultAsValueObjectListInternal()
                                                                         throws java.sql.SQLException

Throws:

java.sql.SQLException

getResultsAsValueObjectList

public <T> java.util.List<ValueObject<T>> getResultsAsValueObjectList(java.lang.String sql,
                                                                      java.util.Collection<?> params,
                                                                      int maxNumberOfParams,
                                                                      java.lang.String placeHolder)
                                                               throws java.sql.SQLException

Throws:

java.sql.SQLException

getResultsAsValueObjectList

public <T> java.util.List<ValueObject<T>> getResultsAsValueObjectList(java.lang.String sql,
                                                                      java.util.Collection<?> params)
                                                               throws java.sql.SQLException

Throws:

java.sql.SQLException

getResultsAsValueObjectListInternal

protected <T> java.util.List<ValueObject<T>> getResultsAsValueObjectListInternal()
                                                                          throws java.sql.SQLException

Throws:

java.sql.SQLException

getResultAsMultiValueObjectList

public java.util.List<MultiValueObject> getResultAsMultiValueObjectList(java.lang.String sql)
                                                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

getResultAsMultiValueObjectList

public java.util.List<MultiValueObject> getResultAsMultiValueObjectList(java.lang.String sql,
                                                                        java.util.Collection<?> params)
                                                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

getResultAsMultiValueObjectListInternal

protected java.util.List<MultiValueObject> getResultAsMultiValueObjectListInternal()
                                                                            throws java.sql.SQLException

Throws:

java.sql.SQLException

getResultsAsMultiValueObjectList

public java.util.List<MultiValueObject> getResultsAsMultiValueObjectList(java.lang.String sql,
                                                                         java.util.Collection<?> params,
                                                                         int maxNumberOfParams,
                                                                         java.lang.String placeHolder)
                                                                  throws java.sql.SQLException

Throws:

java.sql.SQLException

getResultsAsMultiValueObjectList

public java.util.List<MultiValueObject> getResultsAsMultiValueObjectList(java.lang.String sql,
                                                                         java.util.Collection<?> params)
                                                                  throws java.sql.SQLException

Throws:

java.sql.SQLException

getResultsAsMultiValueObjectListInternal

protected java.util.List<MultiValueObject> getResultsAsMultiValueObjectListInternal()
                                                                             throws java.sql.SQLException

Throws:

java.sql.SQLException

getResultAsDataHoldersList

public java.util.List<DataHolder> getResultAsDataHoldersList(java.lang.String sql,
                                                             java.util.Collection<?> params,
                                                             boolean populateColumnNames)
                                                      throws java.sql.SQLException

Throws:

java.sql.SQLException

getResultAsDataHoldersList

public java.util.List<DataHolder> getResultAsDataHoldersList(java.lang.String sql,
                                                             boolean populateColumnNames)
                                                      throws java.sql.SQLException

Throws:

java.sql.SQLException

getResultAsDataHoldersListInternal

protected java.util.List<DataHolder> getResultAsDataHoldersListInternal(boolean populateColumnNames)
                                                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

getResultAsDataHoldersList

public java.util.List<DataHolder> getResultAsDataHoldersList(java.lang.String sql)
                                                      throws java.sql.SQLException

Throws:

java.sql.SQLException

getResultAsDataHoldersList

public java.util.List<DataHolder> getResultAsDataHoldersList(java.lang.String sql,
                                                             java.util.Collection<?> params)
                                                      throws java.sql.SQLException

Throws:

java.sql.SQLException

getResultsAsDataHoldersList

public java.util.List<DataHolder> getResultsAsDataHoldersList(java.lang.String sql,
                                                              java.util.Collection<?> params)
                                                       throws java.sql.SQLException

Throws:

java.sql.SQLException

getResultsAsDataHoldersList

public java.util.List<DataHolder> getResultsAsDataHoldersList(java.lang.String sql,
                                                              java.util.Collection<?> params,
                                                              int maxNumberOfParams,
                                                              java.lang.String placeHolder)
                                                       throws java.sql.SQLException

Throws:

java.sql.SQLException

getResultsAsDataHoldersList

public java.util.List<DataHolder> getResultsAsDataHoldersList(java.lang.String sql,
                                                              java.util.Collection<?> params,
                                                              int maxNumberOfParams,
                                                              java.lang.String placeHolder,
                                                              boolean populateColumnNames)
                                                       throws java.sql.SQLException

Throws:

java.sql.SQLException

getResultsAsDataHoldersList

public java.util.List<DataHolder> getResultsAsDataHoldersList(java.lang.String sql,
                                                              java.util.Collection<?> params,
                                                              boolean populateColumnNames)
                                                       throws java.sql.SQLException

Throws:

java.sql.SQLException

getResultsAsDataHoldersListInternal

protected java.util.List<DataHolder> getResultsAsDataHoldersListInternal(boolean populateColumnNames)
                                                                  throws java.sql.SQLException

Throws:

java.sql.SQLException

getResultsAsList

public java.util.List<java.util.List<?>> getResultsAsList(java.lang.String sql,
                                                          java.util.Collection<?> params,
                                                          int maxNumberOfParams,
                                                          java.lang.String placeHolder)
                                                   throws java.sql.SQLException

Returns:

List of Lists

Throws:

java.sql.SQLException

getResultsAsList

public java.util.List<java.util.List<?>> getResultsAsList(java.lang.String sql,
                                                          java.util.Collection<?> params)
                                                   throws java.sql.SQLException

Returns:

List of Lists

Throws:

java.sql.SQLException

getResultsAsListInternal

protected java.util.List<java.util.List<?>> getResultsAsListInternal()
                                                              throws java.sql.SQLException

Throws:

java.sql.SQLException

getResultAsList

public java.util.List<java.util.List<?>> getResultAsList(java.lang.String sql)
                                                  throws java.sql.SQLException

Returns:

List of Lists

Throws:

java.sql.SQLException

getResultAsList

public java.util.List<java.util.List<?>> getResultAsList(java.lang.String sql,
                                                         java.util.Collection<?> params)
                                                  throws java.sql.SQLException

Returns:

List of Lists

Throws:

java.sql.SQLException

getResultAsListInternal

protected java.util.List<java.util.List<?>> getResultAsListInternal()
                                                             throws java.sql.SQLException

Throws:

java.sql.SQLException

getResultsAsMap

public java.util.Map<java.lang.String,java.util.List<?>> getResultsAsMap(java.lang.String sql,
                                                                         java.util.Collection<?> params)
                                                                  throws java.sql.SQLException

Returns:

Map of Lists. Each key is column name and each value is List of column values

Throws:

java.sql.SQLException

getResultsAsMap

public java.util.Map<java.lang.String,java.util.List<?>> getResultsAsMap(java.lang.String sql,
                                                                         java.util.Collection<?> params,
                                                                         int maxNumberOfParams,
                                                                         java.lang.String placeHolder)
                                                                  throws java.sql.SQLException

Returns:

Map of Lists. Each key is column name and each value is List of column values

Throws:

java.sql.SQLException

getResultsAsMapInternal

protected java.util.Map<java.lang.String,java.util.List<?>> getResultsAsMapInternal()
                                                                             throws java.sql.SQLException

Throws:

java.sql.SQLException

getResultAsMap

public java.util.Map<java.lang.String,java.util.List<?>> getResultAsMap(java.lang.String sql)
                                                                 throws java.sql.SQLException

Returns:

Map of Lists. Each key is column name and each value is List of column values

Throws:

java.sql.SQLException

getResultAsMap

public java.util.Map<java.lang.String,java.util.List<?>> getResultAsMap(java.lang.String sql,
                                                                        java.util.Collection<?> params)
                                                                 throws java.sql.SQLException

Returns:

Map of Lists. Each key is column name and each value is List of column values

Throws:

java.sql.SQLException

getResultAsMapInternal

protected java.util.Map<java.lang.String,java.util.List<?>> getResultAsMapInternal()
                                                                            throws java.sql.SQLException

Throws:

java.sql.SQLException

getResultAsListOfMaps

public java.util.List<java.util.Map<java.lang.String,?>> getResultAsListOfMaps(java.lang.String sql)
                                                                        throws java.sql.SQLException

Throws:

java.sql.SQLException

getResultAsListOfMaps

public java.util.List<java.util.Map<java.lang.String,?>> getResultAsListOfMaps(java.lang.String sql,
                                                                               java.util.Collection<?> params)
                                                                        throws java.sql.SQLException

Throws:

java.sql.SQLException

getResultAsListOfMapsInternal

protected java.util.List<java.util.Map<java.lang.String,?>> getResultAsListOfMapsInternal()
                                                                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

buildInClause

public java.lang.CharSequence buildInClause(java.util.Collection<?> params)

buildInClause

public java.lang.CharSequence buildInClause(java.lang.String columnName,
                                            java.util.Collection<?> params,
                                            int max)

Build 'IN' clause. If number of params is greater than max than build it using 'OR': (col_1 in ( ?, ?, ?, ?, ? ) or col_1 in ( ?, ?, ?, ?, ? ) or col_1 in ( ?, ? )) Useful in cases when database cannot handle more than specific number of parameters in 'IN' clause: i.e Oracle

flattenMultiColumnsParams

public java.util.Collection<?> flattenMultiColumnsParams(java.util.Collection<java.util.Collection<?>> params)

flattenParams

public java.util.Collection<?> flattenParams(java.util.Collection<java.util.Collection<?>> params)

buildInClause

public java.lang.CharSequence buildInClause(java.util.Collection<java.lang.String> columnNames,
                                            java.util.Collection<java.util.Collection<?>> params,
                                            int max)

Used together with public CharSequence buildInClause(List<String> columnNames, Collection<Collection> params, int max) to build SQL IN clause

getDBServices

public DBServices getDBServices()

setDBServices

public void setDBServices(DBServices dbServices)