info.bioinfweb.commons.sql

Class SQLUtils

java.lang.Object

info.bioinfweb.commons.sql.SQLUtils

public class SQLUtils
extends java.lang.Object

Utility class for common tasks related to SQL operations.

Author:

Ben Stöver

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	SQL_SET_SEPARATOR

Constructor Summary

Constructors

Constructor and Description
SQLUtils()

Method Summary

Modifier and Type	Method and Description
static java.lang.String	addLeadingKeyword(java.lang.String cond, java.lang.String keyword)
static java.lang.String	addTrailingKeyword(java.lang.String cond, java.lang.String keyword)
static java.lang.String	createIntListCond(java.lang.String columnName, java.util.List<java.lang.Integer> values, java.lang.String operator)
static <E extends java.lang.Enum<E>> java.util.EnumSet<E>	readEnumSet(java.sql.ResultSet rs, java.lang.String columnLabel, java.lang.Class<E> enumClass) Reads a value of an SQL SET column into an EnumSet.
static <E extends java.lang.Enum<E>> java.util.EnumSet<E>	readEnumSet(java.lang.String value, java.lang.Class<E> enumClass) Reads a value of an SQL SET column into an EnumSet.

Methods inherited from class java.lang.Object

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

Field Detail

SQL_SET_SEPARATOR

public static final java.lang.String SQL_SET_SEPARATOR

See Also:

Constant Field Values

Constructor Detail

SQLUtils

public SQLUtils()

Method Detail

createIntListCond

public static java.lang.String createIntListCond(java.lang.String columnName,
                                                 java.util.List<java.lang.Integer> values,
                                                 java.lang.String operator)

addLeadingKeyword

public static java.lang.String addLeadingKeyword(java.lang.String cond,
                                                 java.lang.String keyword)

addTrailingKeyword

public static java.lang.String addTrailingKeyword(java.lang.String cond,
                                                  java.lang.String keyword)

readEnumSet

public static <E extends java.lang.Enum<E>> java.util.EnumSet<E> readEnumSet(java.sql.ResultSet rs,
                                                                             java.lang.String columnLabel,
                                                                             java.lang.Class<E> enumClass)
                                                                      throws java.sql.SQLException

Reads a value of an SQL SET column into an EnumSet.

Note that the names of the enumeration constants used in SQL and in Java need to be identical (case sensitive match).

If null is read from the database the returned set will also be null. If an empty string (representation of an empty SET) is read an empty set will be returned.

Parameters:

rs - the result set to read the data from

columnLabel - the label of the column containing the SET value

enumClass - the enum class that represents the SQL SET in Java

Returns:

an enum set corresponding the value in the database

Throws:

java.sql.SQLException

readEnumSet

public static <E extends java.lang.Enum<E>> java.util.EnumSet<E> readEnumSet(java.lang.String value,
                                                                             java.lang.Class<E> enumClass)

Reads a value of an SQL SET column into an EnumSet.

Note that the names of the enumeration constants used in SQL and in Java need to be identical (case sensitive match).

If null is specified as value the returned set will also be null. If an empty string is specified as value an empty set will be returned.

Parameters:

value - the string representation of the SQL SET value

enumClass - the enum class that represents the SQL SET in Java

Returns:

an enum set corresponding the value in the database