I have this code for the chart:
Code: Select all
import org.jfree.chart.ChartFactory;
import org.jfree.chart.ChartPanel;
import org.jfree.chart.JFreeChart;
import org.jfree.chart.plot.PlotOrientation;
import org.jfree.data.xy.XYSeries;
import org.jfree.data.xy.XYSeriesCollection;
import org.jfree.ui.ApplicationFrame;
import org.jfree.ui.RefineryUtilities;
import org.jfree.data.time.Day;
import java.sql.*;
import java.awt.Dimension;
import ca.edbc.util.EdbcEx;
public class XYSeriesDemo extends ApplicationFrame {
public XYSeriesDemo(final String title) {
super(title);
XYSeries series = new XYSeries("SPC",false,true);
try {
Class.forName("ca.edbc.jdbc.EdbcDriver");
Connection con = DriverManager.getConnection(url,uid,password);
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(sqlSelect);
while(rs.next()) {
series.add(new Day(rs.getDate(2)).getMiddleMillisecond(), rs.getInt(1));
}
} catch (NumberFormatException e) {
System.err.println("Error adding to series");
} catch (ClassNotFoundException clex) {
//
} catch (SQLException sqlex) {
//
}
final XYSeriesCollection data = new XYSeriesCollection(series);
final JFreeChart chart = ChartFactory.createXYLineChart(
"XY Series Demo",
"X",
"Y",
data,
PlotOrientation.VERTICAL,
true,
true,
false
);
final ChartPanel chartPanel = new ChartPanel(chart);
chartPanel.setPreferredSize(new Dimension(800, 570));
setContentPane(chartPanel);
}
public static void main(final String[] args) {
final XYSeriesDemo demo = new XYSeriesDemo("SPC Chart");
demo.pack();
RefineryUtilities.centerFrameOnScreen(demo);
demo.setVisible(true);
}
}
what gives? any clue?
Read