public class

JDBCCategoryDataset

extends DefaultCategoryDataset
java.lang.Object
   ↳ org.jfree.data.general.AbstractDataset
     ↳ org.jfree.data.category.DefaultCategoryDataset
       ↳ org.jfree.data.jdbc.JDBCCategoryDataset

Class Overview

A CategoryDataset implementation over a database JDBC result set. The dataset is populated via a call to executeQuery(String) with the string SQL query. The SQL query must return at least two columns. The first column will be the category name and remaining columns values (each column represents a series). Subsequent calls to executeQuery(String) will refresh the dataset.

The database connection is read-only and no write back facility exists.

NOTE: Many people have found this class too restrictive in general use. For the greatest flexibility, please consider writing your own code to read data from a ResultSet and populate a DefaultCategoryDataset directly.

Summary

Public Constructors
JDBCCategoryDataset(String url, String driverName, String user, String passwd)
Creates a new dataset with a database connection.
JDBCCategoryDataset(Connection connection)
Create a new dataset with the given database connection.
JDBCCategoryDataset(Connection connection, String query)
Creates a new dataset with the given database connection, and executes the supplied query to populate the dataset.
Public Methods
void executeQuery(Connection con, String query)
Populates the dataset by executing the supplied query against the existing database connection.
void executeQuery(String query)
Populates the dataset by executing the supplied query against the existing database connection.
boolean getTranspose()
Returns a flag that controls whether or not the table values are transposed when added to the dataset.
void setTranspose(boolean transpose)
Sets a flag that controls whether or not the table values are transposed when added to the dataset.
[Expand]
Inherited Methods
From class org.jfree.data.category.DefaultCategoryDataset
From class org.jfree.data.general.AbstractDataset
From class java.lang.Object
From interface java.io.ObjectInputValidation
From interface org.jfree.data.KeyedValues2D
From interface org.jfree.data.Values2D
From interface org.jfree.data.general.Dataset

Public Constructors

public JDBCCategoryDataset (String url, String driverName, String user, String passwd)

Creates a new dataset with a database connection.

Parameters
url the URL of the database connection.
driverName the database driver class name.
user the database user.
passwd the database user's password.
Throws
ClassNotFoundException if the driver cannot be found.
SQLException if there is an error obtaining a connection to the database.

public JDBCCategoryDataset (Connection connection)

Create a new dataset with the given database connection.

Parameters
connection the database connection.

public JDBCCategoryDataset (Connection connection, String query)

Creates a new dataset with the given database connection, and executes the supplied query to populate the dataset.

Parameters
connection the connection.
query the query.
Throws
SQLException if there is a problem executing the query.

Public Methods

public void executeQuery (Connection con, String query)

Populates the dataset by executing the supplied query 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
con the connection.
query the query.
Throws
SQLException if there is a problem executing the query.

public void executeQuery (String query)

Populates the dataset by executing the supplied query 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.
Throws
SQLException if there is a problem executing the query.

public boolean getTranspose ()

Returns a flag that controls whether or not the table values are transposed when added to the dataset.

Returns
  • A boolean.

public void setTranspose (boolean transpose)

Sets a flag that controls whether or not the table values are transposed when added to the dataset.

Parameters
transpose the flag.