e4s.db
Class E4DBFilterOr

java.lang.Object
  e4s.util.E4Object
      e4s.db.E4DBFilter
          e4s.db.E4DBFilterOr

All Implemented Interfaces:

E4DBFilter_Intf, E4DBFilterOr_Intf

Direct Known Subclasses:

T_E4S_CLIENT_Sel.T_E4S_CLIENT_Or, T_E4S_CLIENT_VAL_Sel.T_E4S_CLIENT_VAL_Or, T_E4S_COMPANY_GROUP_Sel.T_E4S_COMPANY_GROUP_Or, T_E4S_COMPANY_Sel.T_E4S_COMPANY_Or, T_E4S_COMPANY_USER_Sel.T_E4S_COMPANY_USER_Or, T_E4S_FREEFIELD_DEF_Sel.T_E4S_FREEFIELD_DEF_Or, T_E4S_FREEFIELD_VAL_Sel.T_E4S_FREEFIELD_VAL_Or, T_E4S_HINT_READ_Sel.T_E4S_HINT_READ_Or, T_E4S_HINT_Sel.T_E4S_HINT_Or, T_E4S_LOGIN_HISTORY_Sel.T_E4S_LOGIN_HISTORY_Or, T_E4S_MAIL_SENT_Sel.T_E4S_MAIL_SENT_Or, T_E4S_OVERVIEW_Sel.T_E4S_OVERVIEW_Or, T_E4S_PERMISSION_COMPANY_Sel.T_E4S_PERMISSION_COMPANY_Or, T_E4S_PERMISSION_GROUP_Sel.T_E4S_PERMISSION_GROUP_Or, T_E4S_PERMISSION_USER_Sel.T_E4S_PERMISSION_USER_Or, T_E4S_QUERY_CLIENTS_Sel.T_E4S_QUERY_CLIENTS_Or, T_E4S_QUERY_PARAMS_Sel.T_E4S_QUERY_PARAMS_Or, T_E4S_QUERY_Sel.T_E4S_QUERY_Or, T_E4S_TRANS_APP_Sel.T_E4S_TRANS_APP_Or, T_E4S_TRANS_DATA_Sel.T_E4S_TRANS_DATA_Or, T_E4S_TRANS_SYS_Sel.T_E4S_TRANS_SYS_Or, T_E4S_USER_VAL_Sel.T_E4S_USER_VAL_Or

public class E4DBFilterOr
extends E4DBFilter
implements E4DBFilterOr_Intf

Definition for an LOGICAL_CONNEX_OR SQL-WHERE construct.

Since:

JDK 1.4

See Also:

E4DBFilter, E4DBFilterAnd, E4DBFilter_Intf

Field Summary

Fields inherited from class e4s.db.E4DBFilter

COMP_EMPTY, COMP_EQUALS, COMP_GREATER, COMP_GREATER_EQUAL, COMP_IN, COMP_IS_NOT_NULL, COMP_IS_NULL, COMP_LESS, COMP_LESS_EQUAL, COMP_LIKE, COMP_NOT_EMPTY, COMP_NOT_EQUALS, COMP_NOT_IN, COMP_NOT_LIKE

Fields inherited from class e4s.util.E4Object

CRLF, E4S_CORE_SYSTEM_LANGUAGE, NBSP, NULLSTR, URL_ENCODING_CHARSET

Constructor Summary

E4DBFilterOr()

Method Summary

static java.lang.String	_getSVNVersionString() Get version info string from subversion.
E4DBFilterAnd_Intf	AND() Create an AND-where element, linked to this OR-ed where.
java.lang.String	getWhere()
void	isEmpty(E4DBColumnName fieldname) Set a filter on a column that must either be empty or null
void	isNotEmpty(E4DBColumnName fieldname) Set an E4DBFilterAnd filter on a column that must not be empty and not null (...
void	isNotNull(E4DBColumnName fieldname) Set a filter on a column that must not be null
void	isNull(E4DBColumnName fieldname) Set a filter on a column that must be null
void	setFilter_NOT(E4DBColumnName fieldname, long[] filter) Creates a filter using the SQL NOT-IN statement.
void	setFilter_NOT(E4DBColumnName fieldname, java.lang.String[] filter) Creates a filter using the SQL NOT-IN statement.
void	setFilter(E4DBColumnName fieldname, boolean filter)
void	setFilter(E4DBColumnName fieldname, java.util.Date filter)
void	setFilter(E4DBColumnName fieldname, E4Date filter)
void	setFilter(E4DBColumnName fieldname, E4Long filter)
void	setFilter(E4DBColumnName fieldname, E4Long[] filter) Creates a filter using the SQL IN statement.
void	setFilter(E4DBColumnName fieldname, E4String filter)
void	setFilter(E4DBColumnName fieldname, E4String[] filter) Creates a filter using the SQL IN statement.
void	setFilter(E4DBColumnName fieldname, float filter)
void	setFilter(E4DBColumnName fieldname, int filter)
void	setFilter(E4DBColumnName fieldname, int comp_operator, boolean filter)
void	setFilter(E4DBColumnName fieldname, int comp_operator, java.util.Date filter)
void	setFilter(E4DBColumnName fieldname, int comp_operator, E4Date filter)
void	setFilter(E4DBColumnName fieldname, int comp_operator, E4DBColumnName compareTo)
void	setFilter(E4DBColumnName fieldname, int comp_operator, E4Long filter)
void	setFilter(E4DBColumnName fieldname, int comp_operator, E4String filter)
void	setFilter(E4DBColumnName fieldname, int comp_operator, E4String filter, boolean quote)
void	setFilter(E4DBColumnName fieldname, int comp_operator, float filter)
void	setFilter(E4DBColumnName fieldname, int comp_operator, int filter)
void	setFilter(E4DBColumnName fieldname, int comp_operator, long filter)
void	setFilter(E4DBColumnName fieldname, int comp_operator, java.lang.String filter)
void	setFilter(E4DBColumnName fieldname, int comp_operator, java.lang.String filter, boolean quote)
void	setFilter(E4DBColumnName fieldname, long filter)
void	setFilter(E4DBColumnName fieldname, long[] filter) Creates a filter using the SQL IN statement.
void	setFilter(E4DBColumnName fieldname, java.lang.String filter)
void	setFilter(E4DBColumnName fieldname, java.lang.String[] filter) Creates a filter using the SQL IN statement.
java.lang.String	toString() Return the SQL clause.

Methods inherited from class e4s.db.E4DBFilter

Escape, Escape, finalize, getApplObj, getClient, getSession, getWhere, isWhereDefined, OP, resetWhere, setFilter_IN, setFilter_IN, setFilter_IN, setFilter_IN, setFilter_IN, setFilter_NOT_IN, setFilter_NOT_IN, setFilter_NOT_IN, setFilter_NOT_IN, setFilter_NOT_IN, setFilter, setFilter, setWhere, toString

Methods inherited from class e4s.util.E4Object

Calendar, CName, CName, E4LabelApp, E4LabelApp, E4LabelApp, E4LabelApp, E4LabelApp, E4LabelApp, E4LabelNone, E4LabelNone, E4LabelNone, E4LabelNone, E4LabelSys, E4LabelSys, e4sCopyright, e4sVersion, encode, encode, encode, encodeHtml, encodeHtml, encodeHtml, encodeURL, encodeURL, encodeURL, getLINE, getTRACE, getTRACE, getTRACE, getTRACE, getTRACE, getTRACE, getTraceMemory, HtmlEncode, HtmlEncode, HtmlEncode, isdecimal, isdigit, isnotok, isnotok, isnumeric, isok, isok, isok, isok, lastCallingFunction, lastCallingFunction, lastCallingFunction, lastCallingFunction, lastCallingStack, mkdirs, null2nbsp, null2nbsp, null2nbsp, ok, ok, ok, ok, outPrintln, setLogFile4Trace, setTraceMemory, STACKTRACE, toDebug, toDouble, toFloat, toFloat, TRACE_CALLS, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, TRACE, wait

Methods inherited from class java.lang.Object

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

Methods inherited from interface e4s.db.E4DBFilter_Intf

isWhereDefined, resetWhere

Constructor Detail

E4DBFilterOr

public E4DBFilterOr()

Method Detail

isNull

public void isNull(E4DBColumnName fieldname)
            throws E4DBException

Set a filter on a column that must be null. [..x IS NULL..].

Specified by:

isNull in interface E4DBFilterOr_Intf

Parameters:

fieldname - the column to filter

Throws:

E4DBException

See Also:

isNotNull(e4s.db.E4DBColumnName), isEmpty(e4s.db.E4DBColumnName)

isNotNull

public void isNotNull(E4DBColumnName fieldname)
               throws E4DBException

Set a filter on a column that must not be null. [..x IS NOT NULL..].

Specified by:

isNotNull in interface E4DBFilterOr_Intf

Parameters:

fieldname - the column to filter

Throws:

E4DBException

See Also:

isNull(e4s.db.E4DBColumnName), isNotEmpty(e4s.db.E4DBColumnName)

isEmpty

public void isEmpty(E4DBColumnName fieldname)
             throws E4DBException

Set a filter on a column that must either be empty or null. [..x = '' OR x IS NULL..].

Specified by:

isEmpty in interface E4DBFilterOr_Intf

Parameters:

fieldname - the column to filter

Throws:

E4DBException

See Also:

isNull(e4s.db.E4DBColumnName), isNotEmpty(e4s.db.E4DBColumnName)

isNotEmpty

public void isNotEmpty(E4DBColumnName fieldname)
                throws E4DBException

Set an E4DBFilterAnd filter on a column that must not be empty and not null (... WHERE (x IS NOT NULL AND x != '')...).

Specified by:

isNotEmpty in interface E4DBFilterOr_Intf

Parameters:

fieldname - the column to filter

Throws:

E4DBException

See Also:

isNull(e4s.db.E4DBColumnName), isNotEmpty(e4s.db.E4DBColumnName)

AND

public E4DBFilterAnd_Intf AND()

Create an AND-where element, linked to this OR-ed where.

 e.g.   E4DBSelect record = new E4DBSelect(new e4s.db.TableName("mytable"));
       record.setFilter("A",1);
       E4DBFilterOr or = record.OR();
       or.setFilter("B",2);
       E4DBFilterAnd and = or.AND();
       and.setFilter("C",3);
       and.setFilter("D",4);
 results in 
       SELECT * FROM mytable WHERE A=1 OR (B=2 OR (C=3 AND D=4))
 

Specified by:

AND in interface E4DBFilterOr_Intf

Returns:

the created and added OR-filter element.

setFilter

public void setFilter(E4DBColumnName fieldname,
                      java.lang.String filter)
               throws E4DBException

Specified by:

setFilter in interface E4DBFilterOr_Intf

Throws:

E4DBException

setFilter

public void setFilter(E4DBColumnName fieldname,
                      E4String filter)
               throws E4DBException

Specified by:

setFilter in interface E4DBFilterOr_Intf

Throws:

E4DBException

setFilter

public void setFilter(E4DBColumnName fieldname,
                      long filter)
               throws E4DBException

Specified by:

setFilter in interface E4DBFilterOr_Intf

Throws:

E4DBException

setFilter

public void setFilter(E4DBColumnName fieldname,
                      float filter)
               throws E4DBException

Specified by:

setFilter in interface E4DBFilterOr_Intf

Throws:

E4DBException

setFilter

public void setFilter(E4DBColumnName fieldname,
                      E4Long filter)
               throws E4DBException

Specified by:

setFilter in interface E4DBFilterOr_Intf

Throws:

E4DBException

setFilter

public void setFilter(E4DBColumnName fieldname,
                      java.util.Date filter)
               throws E4DBException

Throws:

E4DBException

setFilter

public void setFilter(E4DBColumnName fieldname,
                      E4Date filter)
               throws E4DBException

Throws:

E4DBException

setFilter

public void setFilter(E4DBColumnName fieldname,
                      int comp_operator,
                      java.lang.String filter)
               throws E4DBException

Specified by:

setFilter in interface E4DBFilterOr_Intf

Throws:

E4DBException

setFilter

public void setFilter(E4DBColumnName fieldname,
                      int comp_operator,
                      java.lang.String filter,
                      boolean quote)
               throws E4DBException

Specified by:

setFilter in interface E4DBFilterOr_Intf

Throws:

E4DBException

setFilter

public void setFilter(E4DBColumnName fieldname,
                      int comp_operator,
                      E4String filter)
               throws E4DBException

Specified by:

setFilter in interface E4DBFilterOr_Intf

Throws:

E4DBException

setFilter

public void setFilter(E4DBColumnName fieldname,
                      int comp_operator,
                      E4String filter,
                      boolean quote)
               throws E4DBException

Specified by:

setFilter in interface E4DBFilterOr_Intf

Throws:

E4DBException

setFilter

public void setFilter(E4DBColumnName fieldname,
                      int comp_operator,
                      long filter)
               throws E4DBException

Specified by:

setFilter in interface E4DBFilterOr_Intf

Throws:

E4DBException

setFilter

public void setFilter(E4DBColumnName fieldname,
                      int comp_operator,
                      float filter)
               throws E4DBException

Specified by:

setFilter in interface E4DBFilterOr_Intf

Throws:

E4DBException

setFilter

public void setFilter(E4DBColumnName fieldname,
                      int comp_operator,
                      E4Long filter)
               throws E4DBException

Specified by:

setFilter in interface E4DBFilterOr_Intf

Throws:

E4DBException

setFilter

public void setFilter(E4DBColumnName fieldname,
                      int comp_operator,
                      int filter)
               throws E4DBException

Specified by:

setFilter in interface E4DBFilterOr_Intf

Throws:

E4DBException

setFilter

public void setFilter(E4DBColumnName fieldname,
                      int filter)
               throws E4DBException

Specified by:

setFilter in interface E4DBFilterOr_Intf

Throws:

E4DBException

setFilter

public void setFilter(E4DBColumnName fieldname,
                      boolean filter)
               throws E4DBException

Specified by:

setFilter in interface E4DBFilterOr_Intf

Throws:

E4DBException

setFilter

public void setFilter(E4DBColumnName fieldname,
                      int comp_operator,
                      boolean filter)
               throws E4DBException

Specified by:

setFilter in interface E4DBFilterOr_Intf

Throws:

E4DBException

setFilter

public void setFilter(E4DBColumnName fieldname,
                      int comp_operator,
                      E4Date filter)
               throws E4DBException

Throws:

E4DBException

setFilter

public void setFilter(E4DBColumnName fieldname,
                      int comp_operator,
                      java.util.Date filter)
               throws E4DBException

Specified by:

setFilter in interface E4DBFilterOr_Intf

Throws:

E4DBException

setFilter

public void setFilter(E4DBColumnName fieldname,
                      int comp_operator,
                      E4DBColumnName compareTo)
               throws E4DBException

Specified by:

setFilter in interface E4DBFilterOr_Intf

Throws:

E4DBException

setFilter

public void setFilter(E4DBColumnName fieldname,
                      long[] filter)
               throws E4DBException

Creates a filter using the SQL IN statement. Example: filter = {1,2,3} results in "fieldname IN (1,2,3)"

Specified by:

setFilter in interface E4DBFilterOr_Intf

Parameters:

fieldname - the name of the column

filter - an array of values

Throws:

E4DBException

setFilter

public void setFilter(E4DBColumnName fieldname,
                      E4Long[] filter)
               throws E4DBException

Creates a filter using the SQL IN statement. Example: filter = {1,2,3} results in "fieldname IN (1,2,3)"

Parameters:

fieldname - the name of the column

filter - an array of values

Throws:

E4DBException

setFilter

public void setFilter(E4DBColumnName fieldname,
                      java.lang.String[] filter)
               throws E4DBException

Creates a filter using the SQL IN statement. Example: filter = {"A","B"} results in "fieldname IN ('A','B')"

Specified by:

setFilter in interface E4DBFilterOr_Intf

Parameters:

fieldname - the name of the column

filter - an array of values

Throws:

E4DBException

setFilter

public void setFilter(E4DBColumnName fieldname,
                      E4String[] filter)
               throws E4DBException

Creates a filter using the SQL IN statement. Example: filter = {"A","B"} results in "fieldname IN ('A','B')"

Specified by:

setFilter in interface E4DBFilterOr_Intf

Parameters:

fieldname - the name of the column

filter - an array of values

Throws:

E4DBException

setFilter_NOT

public void setFilter_NOT(E4DBColumnName fieldname,
                          long[] filter)
                   throws E4DBException

Creates a filter using the SQL NOT-IN statement. Example: filter = {1,2,3} results in "fieldname NOT IN (1,2,3)"

Specified by:

setFilter_NOT in interface E4DBFilterOr_Intf

Parameters:

fieldname - the name of the column

filter - an array of values

Throws:

E4DBException

setFilter_NOT

public void setFilter_NOT(E4DBColumnName fieldname,
                          java.lang.String[] filter)
                   throws E4DBException

Creates a filter using the SQL NOT-IN statement. Example: filter = {"A","B"} results in "fieldname NOT IN ('A','B')"

Specified by:

setFilter_NOT in interface E4DBFilterOr_Intf

Parameters:

fieldname - the name of the column

filter - an array of values

Throws:

E4DBException

getWhere

public java.lang.String getWhere()

Specified by:

getWhere in interface E4DBFilter_Intf

Specified by:

getWhere in interface E4DBFilterOr_Intf

toString

public java.lang.String toString()

Return the SQL clause.

Overrides:

toString in class E4Object

_getSVNVersionString

public static java.lang.String _getSVNVersionString()

Get version info string from subversion.

Returns:

the version info string.

See Also:

E4Util.getRevisionCodeFromSVN(Class)