lumis.util

Class JdbcUtil

java.lang.Object

lumis.util.JdbcUtil

public class JdbcUtil
extends Object

Utility class for JDBC operations.

Since:

4.0.0

Version:

$Revision: 20807 $ $Date: 2017-11-30 19:08:51 +0000 (Thu, 30 Nov 2017) $

Constructor Summary

Constructors

Constructor and Description
JdbcUtil()

Method Summary

Modifier and Type	Method and Description
static List<String>	fillListString(PreparedStatement statement, String fieldName)
static String[]	fillStringArray(PreparedStatement statement, String fieldName)
static String	generateInClause(int numItems) Deprecated. Since 4.2.2.090330 replaced by generateInClause(String, int).
static String	generateInClause(String fieldName, int numItems) Generates a SQL IN statement for a field.
static String	generateInlineInClause(String fieldName, Collection<String> values) Generates a SQL IN statement for a field.
static Timestamp	getTimestampByDate(Date data)
static String	prepareLargeTextCompareField(String fieldName) Properly convert SQL Text fields for comparisons in queries. The following conversions apply: Oracle: to_char(fieldName) MSSQL: convert(nvarchar(MAX), fieldName) For all other Databases the fieldName is returned.
static String	prepareQueryParameter(String parameter)
static void	setLargeFetchSize(Statement statement) Sets a statement's fetch size to a standard large value.

Methods inherited from class java.lang.Object

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

Constructor Detail

JdbcUtil

public JdbcUtil()

Method Detail

prepareQueryParameter

public static String prepareQueryParameter(String parameter)
                                    throws PortalException

Throws:

PortalException

getTimestampByDate

public static Timestamp getTimestampByDate(Date data)

fillStringArray

public static String[] fillStringArray(PreparedStatement statement,
                                       String fieldName)
                                throws SQLException

Throws:

SQLException

fillListString

public static List<String> fillListString(PreparedStatement statement,
                                          String fieldName)
                                   throws SQLException

Throws:

SQLException

generateInClause

@Deprecated
public static String generateInClause(int numItems)

Deprecated. Since 4.2.2.090330 replaced by generateInClause(String, int).

generateInClause

public static String generateInClause(String fieldName,
                                      int numItems)

Generates a SQL IN statement for a field. The IN statement is generated using ? for each parameter, according to the numItems argument.

Parameters:

fieldName - the field operand before the IN operator (e.g.: columnName or table.column).

numItems - the number of parameters to be included in the IN statement.

Returns:

the SQL code fragment for the IN statement.

Since:

4.2.2.090330

generateInlineInClause

public static String generateInlineInClause(String fieldName,
                                            Collection<String> values)
                                     throws PortalException

Generates a SQL IN statement for a field. The IN statement is generated using in-line value for each item, according to the values argument.

Parameters:

fieldName - the field operand before the IN operator (e.g.: columnName or table.column).

values - the values to be included in the IN statement.

Returns:

the SQL code fragment for the IN statement.

Throws:

PortalException

Since:

10.3.0

setLargeFetchSize

public static void setLargeFetchSize(Statement statement)
                              throws SQLException

Sets a statement's fetch size to a standard large value.

Parameters:

statement - the statement.

Throws:

SQLException - if an thrown by the JDBC driver.

Since:

10.0.0

prepareLargeTextCompareField

public static String prepareLargeTextCompareField(String fieldName)

Properly convert SQL Text fields for comparisons in queries.

The following conversions apply:
• Oracle: to_char(fieldName)
• MSSQL: convert(nvarchar(MAX), fieldName)
For all other Databases the fieldName is returned.

Parameters:

fieldName - the name of the field to be wrapped in the conversion statement, including the table aliases.

Returns:

The fieldName wrapped in the conversion statement when applicable

Since:

10.0.0