com.hfg.sql

Class SQLUtil

java.lang.Object

com.hfg.sql.SQLUtil

public class SQLUtil
extends Object

SQL utility functions.

Field Summary

Fields

Modifier and Type	Field and Description
static Level	sSQLLoggingLevel

Constructor Summary

Constructors

Constructor and Description
SQLUtil()

Method Summary

Modifier and Type	Method and Description
static void	close(Connection inConn)
static void	close(ResultSet inResultSet)
static void	close(Statement inStmt)
static void	closeResultSetAndStatement(ResultSet inResultSet)
static boolean	execute(Connection inConn, String inSQL)
static boolean	execute(PreparedStatement inPreparedStatement)
static boolean	execute(Statement inStatement, String inSQL)
static ResultSet	executeQuery(Connection inConn, String inSQL)
static ResultSet	executeQuery(Connection inConn, String inSQL, SQLStatementOptions inOptions)
static int	executeQuery(PreparedStatement inPreparedStatement)
static ResultSet	executeQuery(Statement inStatement, String inSQL)
static int	executeUpdate(Connection inConn, String inSQL)
static int	executeUpdate(PreparedStatement inPreparedStatement)
static int	executeUpdate(Statement inStatement, CharSequence inSQL)
static Double	getDouble(ResultSet inResultSet, DatabaseCol inColumn)
static Double	getDouble(ResultSet inResultSet, int inColumnIndex)
static Double	getDouble(ResultSet inResultSet, String inColumnLabel)
static Float	getFloat(ResultSet inResultSet, DatabaseCol inColumn)
static Float	getFloat(ResultSet inResultSet, int inColumnIndex)
static Float	getFloat(ResultSet inResultSet, String inColumnLabel)
static Integer	getInteger(ResultSet inResultSet, DatabaseCol inColumn)
static Integer	getInteger(ResultSet inResultSet, int inColumnIndex)
static Integer	getInteger(ResultSet inResultSet, String inColumnLabel)
static Logger	getLogger()
static Long	getLong(ResultSet inResultSet, DatabaseCol inColumn)
static Long	getLong(ResultSet inResultSet, int inColumnIndex)
static Long	getLong(ResultSet inResultSet, String inColumnLabel)
static int	getRowCount(Connection inConn, DatabaseTable inTable, Collection<SQLClause> inClauses) A convenience method for getting a count of rows that meet a specific criteria.
static int	getRowCount(Connection inConn, DatabaseTable inTable, WhereClause inWhereClause) A convenience method for getting a count of rows that meet a specific criteria.
static void	setDate(PreparedStatement inPreparedStatement, int inIndex, Date inValue) A null-tolerant wrapper for PreparedStatement's setDate().
static void	setDate(PreparedStatement inPreparedStatement, int inIndex, Date inValue) A null-tolerant wrapper for PreparedStatement's setDate().
static void	setDouble(PreparedStatement inPreparedStatement, int inIndex, Double inValue) A null-tolerant wrapper for PreparedStatement's setDouble().
static void	setFloat(PreparedStatement inPreparedStatement, int inIndex, Float inValue) A null-tolerant wrapper for PreparedStatement's setFloat().
static void	setInt(PreparedStatement inPreparedStatement, int inIndex, Integer inValue) A null-tolerant wrapper for PreparedStatement's setInt().
static void	setLong(PreparedStatement inPreparedStatement, int inIndex, Long inValue) A null-tolerant wrapper for PreparedStatement's setLong().
static void	setShort(PreparedStatement inPreparedStatement, int inIndex, Short inValue) A null-tolerant wrapper for PreparedStatement's setShort().
static void	setString(PreparedStatement inPreparedStatement, int inIndex, String inValue) A null-tolerant wrapper for PreparedStatement's setString().
static void	setTimestamp(PreparedStatement inPreparedStatement, int inIndex, Timestamp inValue) A null-tolerant wrapper for PreparedStatement's setTimestamp().
static List<String>	splitBatchSQL(Reader inSQL)
static String	sqlString(Object inValue)
static String	sqlString(String inValue)
static String	sqlStringList(Collection<? extends Object> inValues)
static String	sqlStringWithDoubleQuotes(String inValue) All single and double quotes internal to the string are doubled for escaping.

Methods inherited from class java.lang.Object

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

Field Detail

sSQLLoggingLevel

public static Level sSQLLoggingLevel

Constructor Detail

SQLUtil

public SQLUtil()

Method Detail

getLogger

public static Logger getLogger()

sqlString

public static String sqlString(Object inValue)

sqlString

public static String sqlString(String inValue)

sqlStringWithDoubleQuotes

public static String sqlStringWithDoubleQuotes(String inValue)

All single and double quotes internal to the string are doubled for escaping.

Parameters:

inValue - the value string to be escaped for single and double quotes

Returns:

the escaped value

sqlStringList

public static String sqlStringList(Collection<? extends Object> inValues)

execute

public static boolean execute(Connection inConn,
                              String inSQL)
                       throws SQLException

Throws:

SQLException

execute

public static boolean execute(PreparedStatement inPreparedStatement)
                       throws JDBCException

Throws:

JDBCException

execute

public static boolean execute(Statement inStatement,
                              String inSQL)
                       throws JDBCException

Throws:

JDBCException

executeUpdate

public static int executeUpdate(Connection inConn,
                                String inSQL)
                         throws SQLException

Throws:

SQLException

executeUpdate

public static int executeUpdate(PreparedStatement inPreparedStatement)
                         throws SQLException

Throws:

SQLException

executeUpdate

public static int executeUpdate(Statement inStatement,
                                CharSequence inSQL)
                         throws SQLException

Throws:

SQLException

executeQuery

public static ResultSet executeQuery(Connection inConn,
                                     String inSQL)
                              throws SQLException

Throws:

SQLException

executeQuery

public static ResultSet executeQuery(Connection inConn,
                                     String inSQL,
                                     SQLStatementOptions inOptions)
                              throws SQLException

Throws:

SQLException

executeQuery

public static int executeQuery(PreparedStatement inPreparedStatement)
                        throws SQLException

Throws:

SQLException

executeQuery

public static ResultSet executeQuery(Statement inStatement,
                                     String inSQL)
                              throws JDBCException

Throws:

JDBCException

closeResultSetAndStatement

public static void closeResultSetAndStatement(ResultSet inResultSet)
                                       throws JDBCException

Throws:

JDBCException

close

public static void close(ResultSet inResultSet)
                  throws JDBCException

Throws:

JDBCException

close

public static void close(Statement inStmt)
                  throws JDBCException

Throws:

JDBCException

close

public static void close(Connection inConn)
                  throws JDBCException

Throws:

JDBCException

splitBatchSQL

public static List<String> splitBatchSQL(Reader inSQL)
                                  throws IOException

Throws:

IOException

getInteger

public static Integer getInteger(ResultSet inResultSet,
                                 String inColumnLabel)
                          throws SQLException

Throws:

SQLException

getInteger

public static Integer getInteger(ResultSet inResultSet,
                                 DatabaseCol inColumn)
                          throws SQLException

Throws:

SQLException

getInteger

public static Integer getInteger(ResultSet inResultSet,
                                 int inColumnIndex)
                          throws SQLException

Throws:

SQLException

getLong

public static Long getLong(ResultSet inResultSet,
                           String inColumnLabel)
                    throws SQLException

Throws:

SQLException

getLong

public static Long getLong(ResultSet inResultSet,
                           DatabaseCol inColumn)
                    throws SQLException

Throws:

SQLException

getLong

public static Long getLong(ResultSet inResultSet,
                           int inColumnIndex)
                    throws SQLException

Throws:

SQLException

getFloat

public static Float getFloat(ResultSet inResultSet,
                             String inColumnLabel)
                      throws SQLException

Throws:

SQLException

getFloat

public static Float getFloat(ResultSet inResultSet,
                             DatabaseCol inColumn)
                      throws SQLException

Throws:

SQLException

getFloat

public static Float getFloat(ResultSet inResultSet,
                             int inColumnIndex)
                      throws SQLException

Throws:

SQLException

getDouble

public static Double getDouble(ResultSet inResultSet,
                               String inColumnLabel)
                        throws SQLException

Throws:

SQLException

getDouble

public static Double getDouble(ResultSet inResultSet,
                               DatabaseCol inColumn)
                        throws SQLException

Throws:

SQLException

getDouble

public static Double getDouble(ResultSet inResultSet,
                               int inColumnIndex)
                        throws SQLException

Throws:

SQLException

setString

public static void setString(PreparedStatement inPreparedStatement,
                             int inIndex,
                             String inValue)
                      throws SQLException

A null-tolerant wrapper for PreparedStatement's setString().

Parameters:

inPreparedStatement - the PreparedStatement in which to set the value

inIndex - the parameter index where the value should be placed

inValue - the value to insert into the PreparedStatement

Throws:

SQLException

setFloat

public static void setFloat(PreparedStatement inPreparedStatement,
                            int inIndex,
                            Float inValue)
                     throws SQLException

A null-tolerant wrapper for PreparedStatement's setFloat().

Parameters:

inPreparedStatement - the PreparedStatement in which to set the value

inIndex - the parameter index where the value should be placed

inValue - the value to insert into the PreparedStatement

Throws:

SQLException

setDouble

public static void setDouble(PreparedStatement inPreparedStatement,
                             int inIndex,
                             Double inValue)
                      throws SQLException

A null-tolerant wrapper for PreparedStatement's setDouble().

Parameters:

inPreparedStatement - the PreparedStatement in which to set the value

inIndex - the parameter index where the value should be placed

inValue - the value to insert into the PreparedStatement

Throws:

SQLException

setInt

public static void setInt(PreparedStatement inPreparedStatement,
                          int inIndex,
                          Integer inValue)
                   throws SQLException

A null-tolerant wrapper for PreparedStatement's setInt().

Parameters:

inPreparedStatement - the PreparedStatement in which to set the value

inIndex - the parameter index where the value should be placed

inValue - the value to insert into the PreparedStatement

Throws:

SQLException

setShort

public static void setShort(PreparedStatement inPreparedStatement,
                            int inIndex,
                            Short inValue)
                     throws SQLException

A null-tolerant wrapper for PreparedStatement's setShort().

Parameters:

inPreparedStatement - the PreparedStatement in which to set the value

inIndex - the parameter index where the value should be placed

inValue - the value to insert into the PreparedStatement

Throws:

SQLException

setLong

public static void setLong(PreparedStatement inPreparedStatement,
                           int inIndex,
                           Long inValue)
                    throws SQLException

A null-tolerant wrapper for PreparedStatement's setLong().

Parameters:

inPreparedStatement - the PreparedStatement in which to set the value

inIndex - the parameter index where the value should be placed

inValue - the value to insert into the PreparedStatement

Throws:

SQLException

setDate

public static void setDate(PreparedStatement inPreparedStatement,
                           int inIndex,
                           Date inValue)
                    throws SQLException

A null-tolerant wrapper for PreparedStatement's setDate().

Parameters:

inPreparedStatement - the PreparedStatement in which to set the value

inIndex - the parameter index where the value should be placed

inValue - the value to insert into the PreparedStatement

Throws:

SQLException

setDate

public static void setDate(PreparedStatement inPreparedStatement,
                           int inIndex,
                           Date inValue)
                    throws SQLException

A null-tolerant wrapper for PreparedStatement's setDate().

Parameters:

inPreparedStatement - the PreparedStatement in which to set the value

inIndex - the parameter index where the value should be placed

inValue - the value to insert into the PreparedStatement

Throws:

SQLException

setTimestamp

public static void setTimestamp(PreparedStatement inPreparedStatement,
                                int inIndex,
                                Timestamp inValue)
                         throws SQLException

A null-tolerant wrapper for PreparedStatement's setTimestamp().

Parameters:

inPreparedStatement - the PreparedStatement in which to set the value

inIndex - the parameter index where the value should be placed

inValue - the value to insert into the PreparedStatement

Throws:

SQLException

getRowCount

public static int getRowCount(Connection inConn,
                              DatabaseTable inTable,
                              WhereClause inWhereClause)
                       throws SQLException

A convenience method for getting a count of rows that meet a specific criteria.

Parameters:

inConn - the database connection

inTable - the database table

inWhereClause - the where clause to use

Throws:

SQLException

getRowCount

public static int getRowCount(Connection inConn,
                              DatabaseTable inTable,
                              Collection<SQLClause> inClauses)
                       throws SQLException

A convenience method for getting a count of rows that meet a specific criteria.

Parameters:

inConn - the database connection

inTable - the database table

inClauses - additional clauses to use

Throws:

SQLException