|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--org.jfree.data.AbstractDataset | +--org.jfree.data.JDBCXYDataset
This class provides an chart 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.
Field Summary | |
boolean |
isTimeSeries
|
protected double |
maxValue
The maximum y value of the returned result set |
protected double |
minValue
The minimum y value of the returned result set |
Constructor Summary | |
JDBCXYDataset(java.sql.Connection con)
Creates a new JDBCXYDataset (initially empty) using the specified database connection. |
|
JDBCXYDataset(java.sql.Connection con,
java.lang.String query)
Creates a new JDBCXYDataset using the specified database connection, and populates it using data obtained with the supplied query. |
|
JDBCXYDataset(java.lang.String url,
java.lang.String driverName,
java.lang.String user,
java.lang.String passwd)
Creates a new JDBCXYDataset (initially empty) and establishes a new database connection. |
Method Summary | |
void |
close()
Close the database connection |
void |
executeQuery(java.lang.String query)
ExecuteQuery will attempt execute the query passed to it against the existing database connection. |
int |
getItemCount(int seriesIndex)
Returns the number of items in the specified series. |
int |
getLegendItemCount()
Returns the number of items that should be displayed in the legend. |
java.lang.String[] |
getLegendItemLabels()
Returns the legend item labels. |
java.lang.Number |
getMaximumRangeValue()
Returns the maximum data value in the dataset's range. |
java.lang.Number |
getMinimumRangeValue()
Returns the minimum data value in the dataset's range. |
int |
getSeriesCount()
Returns the number of series in the dataset. |
java.lang.String |
getSeriesName(int seriesIndex)
Returns the name of the specified series. |
Range |
getValueRange()
Returns the range of the values in this dataset's range (y-values). |
java.lang.Number |
getXValue(int seriesIndex,
int itemIndex)
Returns the x-value for the specified series and item. |
java.lang.Number |
getYValue(int seriesIndex,
int itemIndex)
Returns the y-value for the specified series and item. |
Methods inherited from class org.jfree.data.AbstractDataset |
addChangeListener, fireDatasetChanged, getGroup, notifyListeners, removeChangeListener, setGroup |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Methods inherited from interface org.jfree.data.Dataset |
addChangeListener, getGroup, removeChangeListener, setGroup |
Field Detail |
protected double maxValue
protected double minValue
public boolean isTimeSeries
Constructor Detail |
public JDBCXYDataset(java.lang.String url, java.lang.String driverName, java.lang.String user, java.lang.String passwd)
url
- URL of the database connection.driverName
- The database driver class name.user
- The database user.passwd
- The database users password.public JDBCXYDataset(java.sql.Connection con)
con
- The database connection.public JDBCXYDataset(java.sql.Connection con, java.lang.String query)
con
- The connection.query
- The SQL query.Method Detail |
public void executeQuery(java.lang.String query)
query
- The query to be executedpublic java.lang.Number getXValue(int seriesIndex, int itemIndex)
getXValue
in interface XYDataset
seriesIndex
- The series (zero-based index).itemIndex
- The item (zero-based index).
XYDataset
public java.lang.Number getYValue(int seriesIndex, int itemIndex)
getYValue
in interface XYDataset
seriesIndex
- The series (zero-based index).itemIndex
- The item (zero-based index).
XYDataset
public int getItemCount(int seriesIndex)
getItemCount
in interface XYDataset
seriesIndex
- The series (zero-based index).
XYDataset
public int getSeriesCount()
getSeriesCount
in interface SeriesDataset
XYDataset
,
Dataset
public java.lang.String getSeriesName(int seriesIndex)
getSeriesName
in interface SeriesDataset
seriesIndex
- The series (zero-based index).
XYDataset
,
Dataset
public int getLegendItemCount()
public java.lang.String[] getLegendItemLabels()
public java.lang.Number getMinimumRangeValue()
getMinimumRangeValue
in interface RangeInfo
RangeInfo
public java.lang.Number getMaximumRangeValue()
getMaximumRangeValue
in interface RangeInfo
RangeInfo
public void close()
public Range getValueRange()
getValueRange
in interface RangeInfo
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |