butler.sql.filter
Class QBEFilter

java.lang.Object
  butler.sql.filter.Filter
      butler.sql.filter.QBEFilter

public class QBEFilter
extends Filter

Query by example filter. This filter will match only if all columns in the given record with a value set, matches the corresponding values in the records in the table.
If a given record has given values 'AAA' and 'BBB' for column A and B, the where-clause will look like:
where A = 'AAA' and B = 'BBB'.

Author:

Fredrik Bertilsson

Constructor Summary

QBEFilter(Record rec)

Method Summary

java.lang.String	getSQL()
java.util.List	getValues()
java.util.List	params2db(java.util.List params)
static QBEFilter	parse(org.dom4j.Element element, java.util.Map tableDictonary)
void	toXML(org.xml.sax.ContentHandler handler)

Methods inherited from class butler.sql.filter.Filter

and, copy, createId, equals, filter, getCaption, getFilter, getId, getLeafFilters, getNestedQuery, getOperator, getParamDatatypes, getValues, hashCode, modify, not, or, parseFilter, registerFilterParser, setCaption, setId, setOperator, setSize, setSize, toXML

Methods inherited from class java.lang.Object

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

Constructor Detail

QBEFilter

public QBEFilter(Record rec)
          throws java.lang.Exception

Throws:

java.lang.Exception

Method Detail

getSQL

public java.lang.String getSQL()
                        throws java.lang.Exception

Overrides:

getSQL in class Filter

Throws:

java.lang.Exception

getValues

public java.util.List getValues()

Overrides:

getValues in class Filter

params2db

public java.util.List params2db(java.util.List params)
                         throws java.lang.Exception

Overrides:

params2db in class Filter

Throws:

java.lang.Exception

toXML

public void toXML(org.xml.sax.ContentHandler handler)
           throws java.lang.Exception

Overrides:

toXML in class Filter

Throws:

java.lang.Exception

parse

public static QBEFilter parse(org.dom4j.Element element,
                              java.util.Map tableDictonary)
                       throws java.lang.Exception

Throws:

java.lang.Exception