|
|||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--com.java4less.rreport.RJDBCSource
Uses a database table (or a SQL query) as data source for an area.
Field Summary | |
boolean |
allowParameters
If true, the [%] parameters in the SQL statement will be replaced with the values provided (see setParameter()). |
java.awt.Frame |
parentFrame
to be used by RReport Visual Builder. |
boolean |
promptForParameters
to be used by RReport Visual Builder. |
Constructor Summary | |
RJDBCSource(java.sql.Statement pst,
java.lang.String psSQL)
The fields' names in the select command (psSQL) must match the elements' names in the area. |
Method Summary | |
java.lang.String |
getFilter()
current filter that will be used to contruct the SQL statement. |
java.lang.String[] |
getFromFields()
field names in the linked RJDBCSource used for the relationship (this is normally the primary key). |
RSource |
getLinkSource()
linked RJDBCSource. |
java.sql.Statement |
getStatement()
gets or sets the Statement object used for executing the SQL query. |
java.lang.String[] |
getToFields()
field names in this RDBCSource used for the relationship (this is normally a foreign key). |
void |
rsource_end()
closes table |
java.lang.Object |
rsource_getData(java.lang.String FieldName)
get value for field "Fieldname". |
boolean |
rsource_nextRecord()
get next record in table |
boolean |
rsource_start()
opens database table |
void |
setFilter(java.lang.String s)
current filter that will be used to contruct the SQL statement. |
void |
setFromFields(java.lang.String[] s)
field names in the linked RJDBCSource used for the relationship (this is normally the primary key). |
void |
setLinkSource(RJDBCSource l)
linked RJDBCSource. |
void |
setLinkSource(RSource l)
linked RJDBCSource. |
void |
setParameter(java.lang.String param,
java.lang.String value)
sets a value for a parameter. |
void |
setSQL(java.lang.String s)
changes the sql of this data source |
void |
setStatement(java.sql.Statement pst)
gets or sets the Statement object used for executing the SQL query. |
void |
setToFields(java.lang.String[] s)
field names in this RDBCSource used for the relationship (this is normally a foreign key). |
Methods inherited from class java.lang.Object |
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
public java.awt.Frame parentFrame
public boolean promptForParameters
public boolean allowParameters
Constructor Detail |
public RJDBCSource(java.sql.Statement pst, java.lang.String psSQL)
Method Detail |
public void setParameter(java.lang.String param, java.lang.String value)
setParameter
in interface RSource
public void setSQL(java.lang.String s)
public java.sql.Statement getStatement()
public void setStatement(java.sql.Statement pst)
public RSource getLinkSource()
getLinkSource
in interface RSource
public void setLinkSource(RJDBCSource l)
public void setLinkSource(RSource l)
setLinkSource
in interface RSource
public java.lang.String[] getFromFields()
getFromFields
in interface RSource
public java.lang.String[] getToFields()
getToFields
in interface RSource
public void setFromFields(java.lang.String[] s)
setFromFields
in interface RSource
public void setToFields(java.lang.String[] s)
setToFields
in interface RSource
public java.lang.String getFilter()
public void setFilter(java.lang.String s)
public java.lang.Object rsource_getData(java.lang.String FieldName)
rsource_getData
in interface RSource
public boolean rsource_nextRecord()
rsource_nextRecord
in interface RSource
public boolean rsource_start()
rsource_start
in interface RSource
public void rsource_end()
rsource_end
in interface RSource
|
|||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |