xxl.relational
Class SortBasedMinus

java.lang.Object
  |
  +--xxl.relational.AbstractResultSet
        |
        +--xxl.relational.Minus
              |
              +--xxl.relational.SortBasedMinus
public class SortBasedMinus
extends Minus

Sort-based implementation of the operator "Minus".

Example: 


	new SortBasedMinus(new int[]{1,2}, new boolean[]{true, false}, r1, r2);
computes "(select * from r1) minus (select * from r2)". It must be ensured that both ResultSets are totaly sorted in the same way. In this example, ResultSet r1 and ResultSet r2 have only two columns and both ResultSets are sorted first by column 1 (ascending) and second by column 2 (descending).

... anderer Konstruktor ...

Field Summary
protected  boolean aNext
           
protected  boolean bNext
           
protected  Tuple t
           
protected  Tuple t2
           
protected  java.util.Comparator tupleComparator
           
protected  boolean wasNull
           
 
Fields inherited from class xxl.relational.Minus
a, b
 
Constructor Summary
SortBasedMinus(java.util.Comparator tupleComparator, java.sql.ResultSet a, java.sql.ResultSet b)
           
SortBasedMinus(int[] columns, boolean[] ascending, java.sql.ResultSet a, java.sql.ResultSet b)
           
 
Method Summary
 void close()
           
 byte[] getBytes(int columnIndex)
           
 java.lang.Object getObject(int columnIndex)
           
 boolean next()
           
 boolean wasNull()
           
 
Methods inherited from class xxl.relational.Minus
findColumn, getMetaData
 
Methods inherited from class xxl.relational.AbstractResultSet
absolute, afterLast, beforeFirst, cancelRowUpdates, clearWarnings, deleteRow, first, getArray, getArray, getAsciiStream, getAsciiStream, getBigDecimal, getBigDecimal, getBigDecimal, getBigDecimal, getBinaryStream, getBinaryStream, getBlob, getBlob, getBoolean, getBoolean, getByte, getByte, getBytes, getCharacterStream, getCharacterStream, getClob, getClob, getColumnCount, getConcurrency, getCursorName, getDate, getDate, getDate, getDate, getDouble, getDouble, getFetchDirection, getFetchSize, getFloat, getFloat, getInt, getInt, getLong, getLong, getObject, getObject, getObject, getRef, getRef, getRow, getShort, getShort, getStatement, getString, getString, getTime, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getTimestamp, getType, getUnicodeStream, getUnicodeStream, getWarnings, insertRow, isAfterLast, isBeforeFirst, isFirst, isLast, last, moveToCurrentRow, moveToInsertRow, previous, refreshRow, relative, rowDeleted, rowInserted, rowUpdated, setFetchDirection, setFetchSize, updateAsciiStream, updateAsciiStream, updateBigDecimal, updateBigDecimal, updateBinaryStream, updateBinaryStream, updateBoolean, updateBoolean, updateByte, updateByte, updateBytes, updateBytes, updateCharacterStream, updateCharacterStream, updateDate, updateDate, updateDouble, updateDouble, updateFloat, updateFloat, updateInt, updateInt, updateLong, updateLong, updateNull, updateNull, updateObject, updateObject, updateObject, updateObject, updateRow, updateShort, updateShort, updateString, updateString, updateTime, updateTime, updateTimestamp, updateTimestamp
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

tupleComparator

protected java.util.Comparator tupleComparator

t

protected Tuple t

t2

protected Tuple t2

aNext

protected boolean aNext

bNext

protected boolean bNext

wasNull

protected boolean wasNull
Constructor Detail

SortBasedMinus

public SortBasedMinus(java.util.Comparator tupleComparator,
                      java.sql.ResultSet a,
                      java.sql.ResultSet b)

SortBasedMinus

public SortBasedMinus(int[] columns,
                      boolean[] ascending,
                      java.sql.ResultSet a,
                      java.sql.ResultSet b)
Method Detail

next

public boolean next()
             throws java.sql.SQLException
Overrides:
next in class Minus

getObject

public java.lang.Object getObject(int columnIndex)
                           throws java.sql.SQLException
Overrides:
getObject in class Minus

getBytes

public byte[] getBytes(int columnIndex)
                throws java.sql.SQLException
Overrides:
getBytes in class Minus

wasNull

public boolean wasNull()
                throws java.sql.SQLException
Overrides:
wasNull in class Minus

close

public void close()
           throws java.sql.SQLException
Overrides:
close in class Minus