com.jrefinery.data
Class JdbcCategoryDataset
java.lang.Object
|
+--com.jrefinery.data.AbstractDataset
|
+--com.jrefinery.data.AbstractSeriesDataset
|
+--com.jrefinery.data.DefaultCategoryDataset
|
+--com.jrefinery.data.JdbcCategoryDataset
- All Implemented Interfaces:
- CategoryDataset, Dataset, SeriesChangeListener, SeriesDataset
- public class JdbcCategoryDataset
- extends DefaultCategoryDataset
- implements CategoryDataset
A CategoryDataset implementation over a database JDBC result set.
The dataset is populated via a call to executeQuery with the string sql
query.
The sql query must return at least two columns. The first column will be
the catagory name and remaining columns values.
executeQuery can be called a number of times.
The database connection is read-only and no write back facility exists.
Constructor Summary |
JdbcCategoryDataset(java.sql.Connection con)
Create a new JdbcCategoryDataset using the specificied database connection. |
JdbcCategoryDataset(java.sql.Connection con,
java.lang.String query)
|
JdbcCategoryDataset(java.lang.String url,
java.lang.String driverName,
java.lang.String user,
java.lang.String passwd)
Create a new JdbcCategoryDataset and establish a new database connection. |
Method Summary |
void |
executeQuery(java.lang.String query)
ExecuteQuery will attempt execute the query passed to it against the
existing database connection. |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
JdbcCategoryDataset
public JdbcCategoryDataset(java.lang.String url,
java.lang.String driverName,
java.lang.String user,
java.lang.String passwd)
- Create a new JdbcCategoryDataset and establish a new database connection.
- Parameters:
url
- URL of the database connection.driverName
- The database driver class name.user
- The database user.passwd
- The database users password.
JdbcCategoryDataset
public JdbcCategoryDataset(java.sql.Connection con)
- Create a new JdbcCategoryDataset using the specificied database connection.
- Parameters:
con
- The database connection to use
JdbcCategoryDataset
public JdbcCategoryDataset(java.sql.Connection con,
java.lang.String query)
executeQuery
public void executeQuery(java.lang.String query)
- ExecuteQuery will attempt execute the query passed to it against the
existing database connection. If no connection exists then no action is
taken.
The results from the query are extracted and cached locally, thus applying
an upper limit on how many rows can be retrieved successfully.
- Parameters:
query
- The query to be executed