butler.sql.record
Class RecordList

java.lang.Object
  extended by butler.sql.record.RecordList
All Implemented Interfaces:
java.lang.Iterable, java.util.Collection, java.util.List

public class RecordList
extends java.lang.Object
implements java.util.List

List of records.

Author:
Fredrik Bertilsson

Constructor Summary
RecordList(Join join)
           
RecordList(JPreparedStatement stmt, Query query)
           
RecordList(Query query)
           
RecordList(Query q, java.lang.String xml)
          Constructs a RecordList from the xml representation.
RecordList(RecordList recList, Filter filter)
           
RecordList(Table tab)
           
 
Method Summary
 void add(int index, java.lang.Object element)
           
 boolean add(java.lang.Object o)
           
 boolean addAll(java.util.Collection c)
           
 boolean addAll(int index, java.util.Collection c)
           
 void addFilter(Filter filter)
           
 java.lang.Comparable calculate(CompareAggregateFunction function, Column col)
           
 java.lang.Double calculate(NumericAggregateFunction function, Column col)
           
 void clear()
           
 boolean contains(java.lang.Object o)
           
 boolean containsAll(java.util.Collection c)
           
protected  void finalize()
           
 Record firstRecord()
           
 java.lang.Object get(int index)
           
 Record getFirstRecord()
           
 Record getLastRecord()
           
 Query getQuery()
          Returns the query that has produced this RecordList.
 Table getTable()
          Returns the table to which the records belongs.
 int indexOf(java.lang.Object o)
           
 boolean isEmpty()
           
 java.util.Iterator iterator()
           
 int lastIndexOf(java.lang.Object o)
           
 java.util.ListIterator listIterator()
           
 java.util.ListIterator listIterator(int index)
           
 java.lang.Comparable max(Column col)
           
static RecordList parseRecordList(org.dom4j.Element element)
           
static RecordList parseRecordList(org.dom4j.Element element, Join join)
           
static RecordList parseRecordList(java.lang.String xml)
           
static RecordList parseRecordList(java.lang.String xml, Query q)
           
 java.lang.Object remove(int index)
           
 boolean remove(java.lang.Object o)
           
 boolean removeAll(java.util.Collection c)
           
 boolean retainAll(java.util.Collection c)
           
 void save()
           
 void save0()
          Saves changed or new records in the database.
 java.lang.Object set(int index, java.lang.Object element)
           
 void setFetchSize(int fetchSize)
           
 int size()
           
 void sort(RecordComparator comparator)
           
 java.util.List subList(int fromIndex, int toIndex)
           
 double sum(Column col)
           
 java.lang.Object[] toArray()
           
 java.lang.Object[] toArray(java.lang.Object[] a)
           
 java.lang.String toXML()
           
 void toXML(org.xml.sax.ContentHandler handler)
           
 void toXML(org.xml.sax.ContentHandler handler, boolean compact)
           
 void toXMLSimple(org.xml.sax.ContentHandler handler)
           
 void toXMLSimple(java.lang.String tagName, org.xml.sax.ContentHandler handler)
           
 
Methods inherited from class java.lang.Object
clone, equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 
Methods inherited from interface java.util.List
equals, hashCode
 

Constructor Detail

RecordList

public RecordList(JPreparedStatement stmt,
                  Query query)

RecordList

public RecordList(Query query)
           throws java.lang.Exception
Throws:
java.lang.Exception

RecordList

public RecordList(Join join)
           throws java.lang.Exception
Throws:
java.lang.Exception

RecordList

public RecordList(Table tab)
           throws java.lang.Exception
Throws:
java.lang.Exception

RecordList

public RecordList(Query q,
                  java.lang.String xml)
           throws java.lang.Exception
Constructs a RecordList from the xml representation.

Throws:
java.lang.Exception

RecordList

public RecordList(RecordList recList,
                  Filter filter)
           throws java.lang.Exception
Throws:
java.lang.Exception
Method Detail

getTable

public Table getTable()
Returns the table to which the records belongs.


getQuery

public Query getQuery()
Returns the query that has produced this RecordList.


addFilter

public void addFilter(Filter filter)
               throws java.lang.Exception
Throws:
java.lang.Exception

save0

public void save0()
           throws java.lang.Exception
Saves changed or new records in the database.

Throws:
java.lang.Exception

save

public void save()
          throws java.lang.Exception
Throws:
java.lang.Exception

size

public int size()
Specified by:
size in interface java.util.Collection
Specified by:
size in interface java.util.List

isEmpty

public boolean isEmpty()
Specified by:
isEmpty in interface java.util.Collection
Specified by:
isEmpty in interface java.util.List

contains

public boolean contains(java.lang.Object o)
Specified by:
contains in interface java.util.Collection
Specified by:
contains in interface java.util.List

iterator

public java.util.Iterator iterator()
Specified by:
iterator in interface java.lang.Iterable
Specified by:
iterator in interface java.util.Collection
Specified by:
iterator in interface java.util.List

toArray

public java.lang.Object[] toArray()
Specified by:
toArray in interface java.util.Collection
Specified by:
toArray in interface java.util.List

toArray

public java.lang.Object[] toArray(java.lang.Object[] a)
Specified by:
toArray in interface java.util.Collection
Specified by:
toArray in interface java.util.List

add

public boolean add(java.lang.Object o)
Specified by:
add in interface java.util.Collection
Specified by:
add in interface java.util.List

remove

public boolean remove(java.lang.Object o)
Specified by:
remove in interface java.util.Collection
Specified by:
remove in interface java.util.List

containsAll

public boolean containsAll(java.util.Collection c)
Specified by:
containsAll in interface java.util.Collection
Specified by:
containsAll in interface java.util.List

addAll

public boolean addAll(java.util.Collection c)
Specified by:
addAll in interface java.util.Collection
Specified by:
addAll in interface java.util.List

addAll

public boolean addAll(int index,
                      java.util.Collection c)
Specified by:
addAll in interface java.util.List

removeAll

public boolean removeAll(java.util.Collection c)
Specified by:
removeAll in interface java.util.Collection
Specified by:
removeAll in interface java.util.List

retainAll

public boolean retainAll(java.util.Collection c)
Specified by:
retainAll in interface java.util.Collection
Specified by:
retainAll in interface java.util.List

clear

public void clear()
Specified by:
clear in interface java.util.Collection
Specified by:
clear in interface java.util.List

get

public java.lang.Object get(int index)
Specified by:
get in interface java.util.List

set

public java.lang.Object set(int index,
                            java.lang.Object element)
Specified by:
set in interface java.util.List

add

public void add(int index,
                java.lang.Object element)
Specified by:
add in interface java.util.List

remove

public java.lang.Object remove(int index)
Specified by:
remove in interface java.util.List

indexOf

public int indexOf(java.lang.Object o)
Specified by:
indexOf in interface java.util.List

lastIndexOf

public int lastIndexOf(java.lang.Object o)
Specified by:
lastIndexOf in interface java.util.List

listIterator

public java.util.ListIterator listIterator()
Specified by:
listIterator in interface java.util.List

listIterator

public java.util.ListIterator listIterator(int index)
Specified by:
listIterator in interface java.util.List

subList

public java.util.List subList(int fromIndex,
                              int toIndex)
Specified by:
subList in interface java.util.List

toXML

public java.lang.String toXML()
                       throws java.lang.Exception
Throws:
java.lang.Exception

toXML

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

toXML

public void toXML(org.xml.sax.ContentHandler handler,
                  boolean compact)
           throws java.lang.Exception
Throws:
java.lang.Exception

toXMLSimple

public void toXMLSimple(org.xml.sax.ContentHandler handler)
                 throws java.lang.Exception
Throws:
java.lang.Exception

toXMLSimple

public void toXMLSimple(java.lang.String tagName,
                        org.xml.sax.ContentHandler handler)
                 throws java.lang.Exception
Throws:
java.lang.Exception

calculate

public java.lang.Double calculate(NumericAggregateFunction function,
                                  Column col)
                           throws java.lang.Exception
Throws:
java.lang.Exception

calculate

public java.lang.Comparable calculate(CompareAggregateFunction function,
                                      Column col)
                               throws java.lang.Exception
Throws:
java.lang.Exception

sum

public double sum(Column col)
           throws java.lang.Exception
Throws:
java.lang.Exception

max

public java.lang.Comparable max(Column col)
                         throws java.lang.Exception
Throws:
java.lang.Exception

sort

public void sort(RecordComparator comparator)

getFirstRecord

public Record getFirstRecord()

getLastRecord

public Record getLastRecord()

parseRecordList

public static RecordList parseRecordList(java.lang.String xml,
                                         Query q)
                                  throws java.lang.Exception
Throws:
java.lang.Exception

parseRecordList

public static RecordList parseRecordList(java.lang.String xml)
                                  throws java.lang.Exception
Throws:
java.lang.Exception

parseRecordList

public static RecordList parseRecordList(org.dom4j.Element element)
                                  throws java.lang.Exception
Throws:
java.lang.Exception

parseRecordList

public static RecordList parseRecordList(org.dom4j.Element element,
                                         Join join)
                                  throws java.lang.Exception
Throws:
java.lang.Exception

finalize

protected void finalize()
Overrides:
finalize in class java.lang.Object

firstRecord

public Record firstRecord()
                   throws java.lang.Exception
Throws:
java.lang.Exception

setFetchSize

public void setFetchSize(int fetchSize)