|
Style Intelligence v12.0 | ||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||
java.lang.Objectinetsoft.report.lens.AbstractTableLens
inetsoft.report.lens.JoinTableLens
public class JoinTableLens
A JoinTableLens provides the results of a join between two other TableLens objects.
| Field Summary | |
|---|---|
static int |
FULL_OUTER_JOIN
Constant specifying that a full outer join should be used. |
static int |
INNER_JOIN
Constant specifying that an inner join should be used. |
static int |
LEFT_OUTER_JOIN
Constant specifying that a left outer join should be used. |
static int |
RIGHT_OUTER_JOIN
Constant specifying that a right outer join should be used. |
| Fields inherited from class inetsoft.report.lens.AbstractTableLens |
|---|
descriptor, isLeftAlign |
| Fields inherited from interface inetsoft.report.TableLens |
|---|
BREAK_BORDER |
| Fields inherited from interface inetsoft.uql.XTable |
|---|
EOT |
| Constructor Summary | |
|---|---|
JoinTableLens(TableLens leftTable,
TableLens rightTable,
int[] leftCols,
int[] rightCols)
Creates a new instance of JoinTableLens using an inner join. |
|
JoinTableLens(TableLens leftTable,
TableLens rightTable,
int[] leftCols,
int[] rightCols,
int joinType)
Creates a new instance of JoinTableLens. |
|
JoinTableLens(TableLens leftTable,
TableLens rightTable,
int[] leftCols,
int[] rightCols,
int joinType,
boolean includeRightJoinCols)
Creates a new instance of JoinTableLens. |
|
| Method Summary | |
|---|---|
void |
cancel()
Cancel the lens and running queries if supported. |
void |
dispose()
Dispose the join table lens. |
boolean |
getBoolean(int r,
int c)
Get the boolean value in one row. |
byte |
getByte(int r,
int c)
Get the byte value in one row. |
int |
getColCount()
Return the number of rows in the table. |
TableDataDescriptor |
getDescriptor()
Get internal table data descriptor which contains table structural infos. |
double |
getDouble(int r,
int c)
Get the double value in one row. |
float |
getFloat(int r,
int c)
Get the float value in one row. |
int |
getHeaderColCount()
Return the number of columns on the left of the table to be treated as header columns. |
int |
getHeaderRowCount()
Return the number of rows on the top of the table to be treated as header rows. |
int |
getInt(int r,
int c)
Get the int value in one row. |
TableLens |
getLeftTable()
Get the left base table lens. |
long |
getLong(int r,
int c)
Get the long value in one row. |
Object |
getObject(int r,
int c)
Return the value at the specified cell. |
TableLens |
getRightTable()
Get the right base table lens. |
int |
getRowCount()
Return the number of columns in the table. |
short |
getShort(int r,
int c)
Get the short value in one row. |
int |
getTrailerColCount()
Return the number of columns on the right of the table to be treated as trailer columns. |
int |
getTrailerRowCount()
Return the number of rows on the bottom of the table to be treated as trailer rows. |
void |
invalidate()
Invalidate the table filter forcely, and the table filter will perform filtering calculation to validate itself. |
boolean |
isCancelled()
Check the TableLens to see if it is cancelled. |
boolean |
isNull(int r,
int c)
Check if the value at one cell is null. |
boolean |
isPrimitive(int col)
Check if is primitive. |
boolean |
moreRows(int row)
Check if there are more rows. |
void |
setObject(int r,
int c,
Object v)
Set the cell value. |
| Methods inherited from class inetsoft.report.lens.AbstractTableLens |
|---|
addChangeListener, clone, containsDrill, containsFormat, findColumnByIdentifier, fireChangeEvent, getAlignment, getBackground, getColBorder, getColBorderColor, getColType, getColumnIdentifier, getColWidth, getDefaultFormat, getFont, getForeground, getInsets, getRowBorder, getRowBorderColor, getRowHeight, getSpan, getXDrillInfo, isLineWrap, removeChangeListener, setColumnIdentifier, setLeftAlign, setLocal |
| Methods inherited from class java.lang.Object |
|---|
equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
| Methods inherited from interface inetsoft.report.TableLens |
|---|
addChangeListener, containsDrill, containsFormat, getAlignment, getBackground, getColBorder, getColBorderColor, getColWidth, getDefaultFormat, getFont, getForeground, getInsets, getRowBorder, getRowBorderColor, getRowHeight, getSpan, getXDrillInfo, isLineWrap, removeChangeListener |
| Methods inherited from interface inetsoft.uql.XTable |
|---|
getColType, getColumnIdentifier, setColumnIdentifier |
| Field Detail |
|---|
public static final int INNER_JOIN
public static final int LEFT_OUTER_JOIN
public static final int RIGHT_OUTER_JOIN
public static final int FULL_OUTER_JOIN
| Constructor Detail |
|---|
public JoinTableLens(TableLens leftTable,
TableLens rightTable,
int[] leftCols,
int[] rightCols)
leftTable - the left-hand table to join.rightTable - the right-hand table to join.leftCols - the indices of the join columns in the left-hand table.rightCols - the indices of the join columns in the right-hand table.
public JoinTableLens(TableLens leftTable,
TableLens rightTable,
int[] leftCols,
int[] rightCols,
int joinType)
leftTable - the left-hand table to join.rightTable - the right-hand table to join.leftCols - the indices of the join columns in the left-hand table.rightCols - the indices of the join columns in the right-hand table.joinType - the type of join to use.
public JoinTableLens(TableLens leftTable,
TableLens rightTable,
int[] leftCols,
int[] rightCols,
int joinType,
boolean includeRightJoinCols)
leftTable - the left-hand table to join.rightTable - the right-hand table to join.leftCols - the indices of the join columns in the left-hand table.rightCols - the indices of the join columns in the right-hand table.joinType - the type of join to use.includeRightJoinCols - true if the join columns from the
right-hand table should be included in the
joined table.| Method Detail |
|---|
public TableLens getLeftTable()
getLeftTable in interface BinaryTableFilterpublic TableLens getRightTable()
getRightTable in interface BinaryTableFilterpublic TableDataDescriptor getDescriptor()
getDescriptor in interface TableLensgetDescriptor in interface XTablegetDescriptor in class AbstractTableLenspublic void invalidate()
invalidate in interface BinaryTableFilterpublic void cancel()
cancel in interface inetsoft.report.internal.table.CancellableTableLenspublic boolean isCancelled()
isCancelled in interface inetsoft.report.internal.table.CancellableTableLenspublic int getColCount()
getColCount in interface XTable
public final boolean isNull(int r,
int c)
isNull in interface XTableisNull in class AbstractTableLensr - the specified row index.c - column number.
public Object getObject(int r,
int c)
getObject in interface XTabler - row number.c - column number.
public final double getDouble(int r,
int c)
getDouble in interface XTablegetDouble in class AbstractTableLensr - the specified row index.c - column number.
public final float getFloat(int r,
int c)
getFloat in interface XTablegetFloat in class AbstractTableLensr - the specified row index.c - column number.
public final long getLong(int r,
int c)
getLong in interface XTablegetLong in class AbstractTableLensr - the specified row index.c - column number.
public final int getInt(int r,
int c)
getInt in interface XTablegetInt in class AbstractTableLensr - the specified row index.c - column number.
public final short getShort(int r,
int c)
getShort in interface XTablegetShort in class AbstractTableLensr - the specified row index.c - column number.
public final byte getByte(int r,
int c)
getByte in interface XTablegetByte in class AbstractTableLensr - the specified row index.c - column number.
public final boolean getBoolean(int r,
int c)
getBoolean in interface XTablegetBoolean in class AbstractTableLensr - the specified row index.c - column number.
public final boolean isPrimitive(int col)
isPrimitive in interface XTableisPrimitive in class AbstractTableLenspublic int getRowCount()
getRowCount in interface XTablepublic int getHeaderColCount()
getHeaderColCount in interface XTablegetHeaderColCount in class AbstractTableLenspublic int getHeaderRowCount()
getHeaderRowCount in interface XTablegetHeaderRowCount in class AbstractTableLenspublic int getTrailerColCount()
getTrailerColCount in interface XTablegetTrailerColCount in class AbstractTableLenspublic int getTrailerRowCount()
getTrailerRowCount in interface XTablegetTrailerRowCount in class AbstractTableLenspublic boolean moreRows(int row)
moreRows in interface XTablemoreRows in class AbstractTableLensrow - row number. If EOT is passed in, this method should wait
until the table is fully loaded.
public void setObject(int r,
int c,
Object v)
setObject in interface XTablesetObject in class AbstractTableLensr - row number.c - column number.v - cell value.public void dispose()
dispose in interface XTabledispose in class AbstractTableLens
|
Copyright © 1996-2014 InetSoft Technology Corp. All Rights Reserved. | ||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | ||||||||