How do i show the graph between timestamp? Please, help me ..... ( Like i want to show from 10:30am to 18:30pm)
package com.jrefinery.chart.demo;
import com.jrefinery.chart.*;
import com.jrefinery.data.*;
import com.jrefinery.date.*;
import java.sql.*;
public class JFreeChartDemo2 {
public static ResultSet rs;
public double nn;
public static void main(String[] args) {
try {
String driverClassName = "sun.jdbc.odbc.JdbcOdbcDriver" ; // "org.gjt.mm.mysql.Driver";
Driver driver = (Driver)Class.forName(driverClassName).newInstance();
DriverManager.registerDriver(driver);
Connection conn = DriverManager.getConnection("jdbc:odbc:YHOO");
System.out.println("Connection Established");
Statement st = conn.createStatement();
rs = st.executeQuery("Select value from table1");
}
catch (Exception e) {
System.out.println("No Connection");
}
BasicTimeSeries series = new BasicTimeSeries("Random Data",Minute.class);
Day current = new Day(1, 1, 1990);
// Minute minu = new Minute(15,current);
Minute minu = new Minute();
try {
for (int i=0; rs.next(); i++) {
try {
series.add(minu, new Double(rs.getDouble(1)));
minu = (Minute)minu.next();
}
catch (SeriesException e) {
System.err.println("Error adding to series");
}
}
}
catch (Exception e) {
System.err.println("Error adding to data");
}
XYDataset data = new TimeSeriesCollection(series);
JFreeChart chart = ChartFactory.createTimeSeriesChart("Test", "Day", "Value", data, false);
JFreeChartFrame frame = new JFreeChartFrame("Test", chart);
frame.pack();
frame.setVisible(true);
}
}