|
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.AttributeTableLens
inetsoft.report.lens.JDBCTableLens
public class JDBCTableLens
The JDBCTableLens is an interface to present the result of a SQL query as the content of a table. It extends the AttributeTableLens so the attributes of the table can be controlled by the users.
A table lens can be created from a JDBC ResultSet. The result set can be returned from a regular query, or a stored procedure call. Alternatively, a JDBCTableLens can also be created from a SQL query directly.
| Field Summary |
|---|
| Fields inherited from class inetsoft.report.lens.AttributeTableLens |
|---|
alignmap, attritable, backgroundmap, cache, check, colborderCmap, colbordermap, fontmap, foregroundmap, insetsmap, linkmap, presentermap, rowborderCmap, rowbordermap, table, wrapmap |
| Fields inherited from class inetsoft.report.lens.AbstractTableLens |
|---|
descriptor, isLeftAlign |
| Fields inherited from interface inetsoft.report.TableLens |
|---|
BREAK_BORDER, NULL |
| Fields inherited from interface inetsoft.uql.XTable |
|---|
EOT |
| Constructor Summary | |
|---|---|
JDBCTableLens(ResultSet data)
Create a table lens from the result of a sql query. |
|
JDBCTableLens(String[] hdrs,
ResultSet data)
Create a table lens from the result of a sql query. |
|
JDBCTableLens(String url,
String uid,
String passwd,
String sql)
Create table from a sql query. |
|
JDBCTableLens(String url,
String uid,
String passwd,
String sql,
String[] headers)
Create table from a sql query. |
|
| Method Summary | |
|---|---|
void |
leftTrim()
Left trim the string values in the table. |
void |
leftTrim(int col)
Left trim the string values in the table of a column. |
void |
rightTrim()
Right trim the string values in the table. |
void |
rightTrim(int col)
Right trim the string values in the table of a column. |
void |
setHeaders(String[] hdrs)
Set the columns headers of the table. |
void |
setMapping(Map labelMap)
Map the column labels using the mapping. |
void |
setMapping(String[][] mapping)
Map the column labels using the mapping. |
void |
trim()
Trim the string values in the table. |
void |
trim(int col)
Trim the string values in the table of a column. |
| Methods inherited from class inetsoft.report.lens.AbstractTableLens |
|---|
addChangeListener, containsDrill, containsFormat, findColumnByIdentifier, fireChangeEvent, getBoolean, getByte, getDefaultFormat, getDouble, getFloat, getInt, getLong, getShort, getXDrillInfo, isNull, isPrimitive, 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, getDefaultFormat, getXDrillInfo, removeChangeListener |
| Methods inherited from interface inetsoft.uql.XTable |
|---|
getBoolean, getByte, getDouble, getFloat, getInt, getLong, getShort, isNull, isPrimitive, setColumnIdentifier |
| Constructor Detail |
|---|
public JDBCTableLens(String url,
String uid,
String passwd,
String sql)
throws SQLException
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
url - jdbc url.uid - user id.passwd - password.sql - sql query.
SQLException
public JDBCTableLens(String url,
String uid,
String passwd,
String sql,
String[] headers)
throws SQLException
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
url - jdbc url.uid - user id.passwd - password.sql - sql query.headers - the column headers of this table.
SQLException
public JDBCTableLens(ResultSet data)
throws SQLException
data - sql query result.
SQLException
public JDBCTableLens(String[] hdrs,
ResultSet data)
throws SQLException
hdrs - the column headers of this table.data - sql query result.
SQLException| Method Detail |
|---|
public void setHeaders(String[] hdrs)
hdrs - columns headers.public void setMapping(String[][] mapping)
mapping - a mapping from the columns labels in the query to
the labels used for displaying.public void setMapping(Map labelMap)
labelMap - a mapping from the columns labels in the query to
the labels used for displaying.public void trim()
public void trim(int col)
public void leftTrim()
public void leftTrim(int col)
public void rightTrim()
public void rightTrim(int col)
|
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 | ||||||||