lumis.util
Class JdbcUtil

java.lang.Object
  lumis.util.JdbcUtil

public class JdbcUtil
extends java.lang.Object

Utility class for JDBC operations.

Since:

4.0.0

Constructor Summary

JdbcUtil()

Method Summary

static java.util.List<java.lang.String>	fillListString(java.sql.PreparedStatement statement, java.lang.String fieldName)
static java.lang.String[]	fillStringArray(java.sql.PreparedStatement statement, java.lang.String fieldName)
static java.lang.String	generateInClause(int numItems) Deprecated. Since 4.2.2.090330 replaced by generateInClause(String, int).
static java.lang.String	generateInClause(java.lang.String fieldName, int numItems) Generates a SQL IN statement for a field.
static java.sql.Timestamp	getTimestampByDate(java.util.Date data)
static java.lang.String	prepareQueryParameter(java.lang.String parameter)

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 java.lang.String prepareQueryParameter(java.lang.String parameter)
                                              throws PortalException

Throws:

PortalException

getTimestampByDate

public static java.sql.Timestamp getTimestampByDate(java.util.Date data)

fillStringArray

public static java.lang.String[] fillStringArray(java.sql.PreparedStatement statement,
                                                 java.lang.String fieldName)
                                          throws java.sql.SQLException

Throws:

java.sql.SQLException

fillListString

public static java.util.List<java.lang.String> fillListString(java.sql.PreparedStatement statement,
                                                              java.lang.String fieldName)
                                                       throws java.sql.SQLException

Throws:

java.sql.SQLException

generateInClause

@Deprecated
public static java.lang.String generateInClause(int numItems)

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

generateInClause

public static java.lang.String generateInClause(java.lang.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