| org.jfree.data.xy.AbstractXYDataset
 org.jfree.data.jdbc.JDBCXYDataset
| JDBCXYDataset | | public class JDBCXYDataset extends AbstractXYDataset implements XYDataset,TableXYDataset,RangeInfo(Code) | | This class provides an
XYDataset 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 x-axis and remaining columns y-axis values.
executeQuery can be called a number of times.
The database connection is read-only and no write back facility exists.
|
| Constructor Summary | |
| public | JDBCXYDataset(String url, String driverName, String user, String password)
Creates a new dataset (initially empty) and establishes a new database
connection. | | public | JDBCXYDataset(Connection con)
Creates a new dataset (initially empty) using the specified database
connection. | | public | JDBCXYDataset(Connection con, String query)
Creates a new dataset using the specified database connection, and
populates it using data obtained with the supplied query. |
| Method Summary | |
| public void | close()
| | public void | executeQuery(String query)
ExecuteQuery will attempt execute the query passed to it against the
existing database connection. | | public void | executeQuery(Connection con, String query)
ExecuteQuery will attempt execute the query passed to it against the
provided database connection. | | public int | getItemCount(int seriesIndex)
Returns the number of items in the specified series.
Parameters:
seriesIndex - the series (zero-based index). | | public int | getItemCount()
Returns the number of items in all series. | | public int | getLegendItemCount()
Returns the number of items that should be displayed in the legend. | | public String[] | getLegendItemLabels()
Returns the legend item labels. | | public Range | getRangeBounds(boolean includeInterval)
Returns the range of the values in this dataset's range.
Parameters:
includeInterval - a flag that determines whether or not they-interval is taken into account. | | public double | getRangeLowerBound(boolean includeInterval)
Returns the minimum y-value in the dataset.
Parameters:
includeInterval - a flag that determines whether or not they-interval is taken into account. | | public double | getRangeUpperBound(boolean includeInterval)
Returns the maximum y-value in the dataset.
Parameters:
includeInterval - a flag that determines whether or not they-interval is taken into account. | | public int | getSeriesCount()
Returns the number of series in the dataset. | | public Comparable | getSeriesKey(int seriesIndex)
Returns the key for the specified series.
Parameters:
seriesIndex - the series (zero-based index). | | public Number | getX(int seriesIndex, int itemIndex)
Returns the x-value for the specified series and item. | | public Number | getY(int seriesIndex, int itemIndex)
Returns the y-value for the specified series and item.
Parameters:
seriesIndex - the series (zero-based index).
Parameters:
itemIndex - the item (zero-based index). | | public boolean | isTimeSeries()
Returns true if the dataset represents time series data,
and false otherwise. | | public void | setTimeSeries(boolean timeSeries)
Sets a flag that indicates whether or not the data represents a time
series. |
| JDBCXYDataset | | public JDBCXYDataset(String url, String driverName, String user, String password) throws SQLException, ClassNotFoundException(Code) | | Creates a new dataset (initially empty) and establishes a new database
connection.
Parameters:
url - URL of the database connection.
Parameters:
driverName - the database driver class name.
Parameters:
user - the database user.
Parameters:
password - the database user's password.
throws:
ClassNotFoundException - if the driver cannot be found.
throws:
SQLException - if there is a problem connecting to the database. |
| JDBCXYDataset | | public JDBCXYDataset(Connection con) throws SQLException(Code) | | Creates a new dataset (initially empty) using the specified database
connection.
Parameters:
con - the database connection.
throws:
SQLException - if there is a problem connecting to the database. |
| JDBCXYDataset | | public JDBCXYDataset(Connection con, String query) throws SQLException(Code) | | Creates a new dataset using the specified database connection, and
populates it using data obtained with the supplied query.
Parameters:
con - the connection.
Parameters:
query - the SQL query.
throws:
SQLException - if there is a problem executing the query. |
| close | | public void close()(Code) | | Close the database connection
|
| executeQuery | | public void executeQuery(String query) throws SQLException(Code) | | 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. |
| executeQuery | | public void executeQuery(Connection con, String query) throws SQLException(Code) | | ExecuteQuery will attempt execute the query passed to it against the
provided database connection. If connection is null 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.
Parameters:
con - the connection the query is to be executed against.
throws:
SQLException - if there is a problem executing the query. |
| getItemCount | | public int getItemCount(int seriesIndex)(Code) | | Returns the number of items in the specified series.
Parameters:
seriesIndex - the series (zero-based index). The itemCount value
See Also: XYDataset |
| getItemCount | | public int getItemCount()(Code) | | Returns the number of items in all series. This method is defined by
the
TableXYDataset interface.
The item count. |
| getLegendItemCount | | public int getLegendItemCount()(Code) | | Returns the number of items that should be displayed in the legend.
The legendItemCount value |
| getLegendItemLabels | | public String[] getLegendItemLabels()(Code) | | Returns the legend item labels.
The legend item labels. |
| getRangeBounds | | public Range getRangeBounds(boolean includeInterval)(Code) | | Returns the range of the values in this dataset's range.
Parameters:
includeInterval - a flag that determines whether or not they-interval is taken into account. The range. |
| getRangeLowerBound | | public double getRangeLowerBound(boolean includeInterval)(Code) | | Returns the minimum y-value in the dataset.
Parameters:
includeInterval - a flag that determines whether or not they-interval is taken into account. The minimum value. |
| getRangeUpperBound | | public double getRangeUpperBound(boolean includeInterval)(Code) | | Returns the maximum y-value in the dataset.
Parameters:
includeInterval - a flag that determines whether or not they-interval is taken into account. The maximum value. |
| getSeriesCount | | public int getSeriesCount()(Code) | | Returns the number of series in the dataset.
The seriesCount value
See Also: XYDataset
See Also: Dataset |
| getSeriesKey | | public Comparable getSeriesKey(int seriesIndex)(Code) | | Returns the key for the specified series.
Parameters:
seriesIndex - the series (zero-based index). The seriesName value
See Also: XYDataset
See Also: Dataset |
| getX | | public Number getX(int seriesIndex, int itemIndex)(Code) | | Returns the x-value for the specified series and item. The
implementation is responsible for ensuring that the x-values are
presented in ascending order.
Parameters:
seriesIndex - the series (zero-based index).
Parameters:
itemIndex - the item (zero-based index). The x-value
See Also: XYDataset |
| getY | | public Number getY(int seriesIndex, int itemIndex)(Code) | | Returns the y-value for the specified series and item.
Parameters:
seriesIndex - the series (zero-based index).
Parameters:
itemIndex - the item (zero-based index). The yValue value
See Also: XYDataset |
| isTimeSeries | | public boolean isTimeSeries()(Code) | | Returns true if the dataset represents time series data,
and false otherwise.
A boolean. |
| setTimeSeries | | public void setTimeSeries(boolean timeSeries)(Code) | | Sets a flag that indicates whether or not the data represents a time
series.
Parameters:
timeSeries - the new value of the flag. |
|
|