| java.lang.Object de.progra.charting.model.JDBCPlotter
JDBCPlotter | public class JDBCPlotter (Code) | | The class is used to convert database queries into ChartDataModels.
You can initialize the Plotter with database parameters and afterwards
you can run consecutive queries resulting in a new database.
|
Method Summary | |
public DefaultChartDataModel | createChartDataModelInstance(String sqlQuery, String[] sqlRows) Given a SQL query and the row titles this method creates a DefaultChartDataModel. | public DefaultChartDataModel | createChartDataModelInstance(String sqlQuery, String[] sqlRows, String[] dataSets) Given a SQL query and the row titles this method creates a DefaultChartDataModel. | public DefaultChartDataModel | createChartDataModelInstance(String sqlQuery, String columnRow, String[] sqlRows) Given a SQL query and the row titles this method creates a DefaultChartDataModel. | public DefaultChartDataModel | createChartDataModelInstance(String sqlQuery, String columnRow, String[] sqlRows, String[] dataSets) Given a SQL query and the row titles this method creates a DefaultChartDataModel. | public ObjectChartDataModel | createObjectChartDataModelInstance(String sqlQuery, String columnRow, String[] sqlRows) Given a SQL query and the row titles this method creates a ObjectChartDataModel. | public ObjectChartDataModel | createObjectChartDataModelInstance(String sqlQuery, String columnRow, String[] sqlRows, String[] dataSets) Given a SQL query and the row titles this method creates an ObjectChartDataModel. |
JDBCPlotter | public JDBCPlotter(String jdbcDriver, String jdbcURL, String username, String password) throws JDBCPlotterException(Code) | | Creates a new JDBCPlotter using the given driver and URL.
Parameters: jdbcDriver - the fully qualified classname of the SQL driver class. Parameters: jdbcURL - the URL of the JDBC database to connect to. Parameters: username - the username for the JDBC resource Parameters: password - the user's password |
createChartDataModelInstance | public DefaultChartDataModel createChartDataModelInstance(String sqlQuery, String[] sqlRows) throws JDBCPlotterException(Code) | | Given a SQL query and the row titles this method creates a DefaultChartDataModel.
The columns are initialized with values starting from 0.
Parameters: sqlQuery - the SQL query to be performed Parameters: sqlRows - the rows from the ResultSet which should be included in the ChartDataModel and whichwill be used as the DataSet titles. |
createChartDataModelInstance | public DefaultChartDataModel createChartDataModelInstance(String sqlQuery, String[] sqlRows, String[] dataSets) throws JDBCPlotterException(Code) | | Given a SQL query and the row titles this method creates a DefaultChartDataModel.
The columns are initialized with values starting from 0.
Parameters: sqlQuery - the SQL query to be performed Parameters: sqlRows - the rows from the ResultSet which should be included in the ChartDataModel Parameters: dataSets - the DataSet titles which should be given to the ChartDataModel instead of the sqlRows titles |
createChartDataModelInstance | public DefaultChartDataModel createChartDataModelInstance(String sqlQuery, String columnRow, String[] sqlRows) throws JDBCPlotterException(Code) | | Given a SQL query and the row titles this method creates a DefaultChartDataModel.
The columns are initialized with values from columnRow.
Parameters: sqlQuery - the SQL query to be performed Parameters: columnRow - the row from the ResultSet which should be taken as the column (x-axis) values Parameters: sqlRows - the rows from the ResultSet which should be included in the ChartDataModel and whichwill be used as the DataSet titles. |
createChartDataModelInstance | public DefaultChartDataModel createChartDataModelInstance(String sqlQuery, String columnRow, String[] sqlRows, String[] dataSets) throws JDBCPlotterException(Code) | | Given a SQL query and the row titles this method creates a DefaultChartDataModel.
The columns are initialized with values from columnRow.
Parameters: sqlQuery - the SQL query to be performed Parameters: columnRow - the row from the ResultSet which should be taken as the column (x-axis) values Parameters: sqlRows - the rows from the ResultSet which should be included in the ChartDataModel Parameters: dataSets - the DataSet titles which should be given to the ChartDataModel instead of the sqlRows titles |
createObjectChartDataModelInstance | public ObjectChartDataModel createObjectChartDataModelInstance(String sqlQuery, String columnRow, String[] sqlRows) throws JDBCPlotterException(Code) | | Given a SQL query and the row titles this method creates a ObjectChartDataModel.
The columns are initialized with values from row columnRow.
Parameters: sqlQuery - the SQL query to be performed Parameters: columnRow - the row from the ResultSet which should be taken as the column (x-axis) values Parameters: sqlRows - the rows from the ResultSet which should be included in the ChartDataModel and whichwill be used as the DataSet titles. |
createObjectChartDataModelInstance | public ObjectChartDataModel createObjectChartDataModelInstance(String sqlQuery, String columnRow, String[] sqlRows, String[] dataSets) throws JDBCPlotterException(Code) | | Given a SQL query and the row titles this method creates an ObjectChartDataModel.
The columns are initialized with values of row columnRow.
Parameters: sqlQuery - the SQL query to be performed Parameters: columnRow - the row from the ResultSet which should be taken as the column (x-axis) values Parameters: sqlRows - the rows from the ResultSet which should be included in the ChartDataModel Parameters: dataSets - the DataSet titles which should be given to the ChartDataModel instead of the sqlRows titles |
|
|