public class

JDBCPieDataset

extends DefaultPieDataset
java.lang.Object
   ↳ org.jfree.data.general.AbstractDataset
     ↳ org.jfree.data.general.DefaultPieDataset
       ↳ org.jfree.data.jdbc.JDBCPieDataset

Class Overview

A PieDataset that reads data from a database via JDBC.

A query should be supplied that returns data in two columns, the first containing VARCHAR data, and the second containing numerical data. The data is cached in-memory and can be refreshed at any time.

Summary

Public Constructors
JDBCPieDataset(String url, String driverName, String user, String password)
Creates a new JDBCPieDataset and establishes a new database connection.
JDBCPieDataset(Connection con)
Creates a new JDBCPieDataset using a pre-existing database connection.
JDBCPieDataset(Connection con, String query)
Creates a new JDBCPieDataset using a pre-existing database connection.
Public Methods
void close()
Close the database connection
void executeQuery(Connection con, String query)
ExecuteQuery will attempt execute the query passed to it against the existing database connection.
void executeQuery(String query)
ExecuteQuery will attempt execute the query passed to it against the existing database connection.
[Expand]
Inherited Methods
From class org.jfree.data.general.DefaultPieDataset
From class org.jfree.data.general.AbstractDataset
From class java.lang.Object
From interface java.io.ObjectInputValidation
From interface org.jfree.data.KeyedValues
From interface org.jfree.data.Values
From interface org.jfree.data.general.Dataset

Public Constructors

public JDBCPieDataset (String url, String driverName, String user, String password)

Creates a new JDBCPieDataset and establishes a new database connection.

Parameters
url the URL of the database connection.
driverName the database driver class name.
user the database user.
password the database users password.
Throws
ClassNotFoundException if the driver cannot be found.
SQLException if there is a problem obtaining a database connection.

public JDBCPieDataset (Connection con)

Creates a new JDBCPieDataset using a pre-existing database connection.

The dataset is initially empty, since no query has been supplied yet.

Parameters
con the database connection.

public JDBCPieDataset (Connection con, String query)

Creates a new JDBCPieDataset using a pre-existing database connection.

The dataset is initialised with the supplied query.

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

Public Methods

public void close ()

Close the database connection

public void executeQuery (Connection con, 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
con the connection the query is to be executed against
query the query to be executed
Throws
SQLException if there is a problem executing the query.

public void executeQuery (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.
Throws
SQLException if there is a problem executing the query.