DatabaseFilter Class
- public class DatabaseFilter
extends Object
implements Serializable
The DatabaseFilter class is a helper class for SQL generation.
NOTE: Depending on the database, column names may be case-sensitive.
The most reliable way to avoid column name mistakes is to use setResultSetMetaData().
SQL Generation helper class
-
Hierarchy
-
Object
DatabaseFilter
-
All Implemented Interfaces
-
Serializable
Methods from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
_chFilter
protected char _chFilter
_columns
protected HashMap _columns
_filter
protected DatabaseFilter.FilterTerm _filter
_identifierOptions
protected int _identifierOptions
_maxSortCols
protected int _maxSortCols
_mdDatabase
protected DatabaseMetaData _mdDatabase
_mdResultSet
protected ResultSetMetaData _mdResultSet
_sIdentifierQuote
protected String _sIdentifierQuote
_sort
protected DatabaseFilter.SortTerm _sort
IDENTIFIER_ASIS
public static final int IDENTIFIER_ASIS
IDENTIFIER_CHANGECASE
public static final int IDENTIFIER_CHANGECASE
IDENTIFIER_DEFAULT
public static final int IDENTIFIER_DEFAULT
IDENTIFIER_QUOTE
public static final int IDENTIFIER_QUOTE
IDENTIFIER_TOLOWER
public static final int IDENTIFIER_TOLOWER
IDENTIFIER_TOUPPER
public static final int IDENTIFIER_TOUPPER
opAsc
public static final int opAsc
opContains
public static final int opContains
opDesc
public static final int opDesc
opEmpty
public static final int opEmpty
opEqual
public static final int opEqual
opGreater
public static final int opGreater
opGreaterEqual
public static final int opGreaterEqual
opIn
public static final int opIn
opInvalid
public static final int opInvalid
opIs
public static final int opIs
opIsNot
public static final int opIsNot
opLess
public static final int opLess
opLessEqual
public static final int opLessEqual
opNotEqual
public static final int opNotEqual
opStartsWith
public static final int opStartsWith
sContains
public static final String sContains
sEmpty
public static final String sEmpty
sEquals
public static final String sEquals
sFilterChar
public static final String sFilterChar
sGreaterEqual
public static final String sGreaterEqual
sGreaterThan
public static final String sGreaterThan
sIn
public static final String sIn
sIsEmpty
public static final String sIsEmpty
sIsNotEmpty
public static final String sIsNotEmpty
sLessEqual
public static final String sLessEqual
sLessThan
public static final String sLessThan
sNotEqual
public static final String sNotEqual
sStartsWith
public static final String sStartsWith
sUnitDate
public static final String sUnitDate
sUnitMonth
public static final String sUnitMonth
sUnitYear
public static final String sUnitYear
unitDate
public static final int unitDate
unitDefault
public static final int unitDefault
unitMonth
public static final int unitMonth
unitYear
public static final int unitYear
DatabaseFilter
public DatabaseFilter()
DatabaseFilter
public DatabaseFilter(DatabaseFilter.FilterTerm[] filter,
DatabaseFilter.SortTerm[] sort)
getFilterExpression() Method
public DatabaseControl.SQLFragment getFilterExpression()
getOrderByClause() Method
public DatabaseControl.SQLFragment getOrderByClause()
getSortExpression() Method
public DatabaseControl.SQLFragment getSortExpression()
getWhereClause() Method
public DatabaseControl.SQLFragment getWhereClause()
parseDate(CharSequence, Calendar) Method
public Calendar parseDate(CharSequence buf,
Calendar calDefault)
Parse a date in ISO8601 or SOAP format.
1999-05-31 13:20:00.000
1999-05-31T13:20:00Z
1999-05-31T13:20:00-05:00
Returns
- Calendar if the timezone is explicit (as in 2nd and 3rd) example
the TimeZone of the returned calendar will be UTC. Otherwise the TimeZone
will be as indicated by
calDefault if specified,
or the system default otherwize.
parseQueryString(String) Method
public void parseQueryString(String query)
parseQueryString(String, String, String) Method
public void parseQueryString(String query,
String prefix,
String enc)
throws UnsupportedEncodingException
Exceptions
-
UnsupportedEncodingException
setDatabaseMetaData(DatabaseMetaData) Method
public void setDatabaseMetaData(DatabaseMetaData md)
setIdentifierOptions(int) Method
public void setIdentifierOptions(int flags)
control handling of identifiers in generated SQL.
If setResultSetMetaData() is called IDENTIFIER_TOUPPER and IDENTIFIER_TOLOWER are ignored
and the case will be as specificied by metadata.getColumnName()
setResultSetMetaData(ResultSetMetaData) Method
public void setResultSetMetaData(ResultSetMetaData md)
throws SQLException
Exceptions
-
SQLException