Creating TimeChart from MySql

Question

Here´s what i want to do: I have in my DB a certain entity, let´s call it "people" and another one, let´s call it "room". The amount of people in the room can change every 15 minutes,i.e full hour, quarter after, etc. Now, i want to create a timechart with jfreechart that shows the amount of people in the room for a period of 3 years, zoomable to the quarter hour (or minute, for all i care :))

Question 1: the dataset. Can i use the JDBCXYDataset to do it or is it better to execute the query and write the data from the resultset to a TimeseriesCollection (code example??)

Question2: i want the chart to initialize showing the whole 3 years and beeing able to zoom in to the individual days/hours/minutes. How do i set this up ?

Thanks for helping.

jzd · Accepted Answer · 2011-03-14 17:06:17Z

2

Your best bet is going to just run a query and create a TimePeriodValuesCollection. JDBCXYDataset is just an XYDataset.

For your second question, you just need to have your Time Period Series populated with three years of data. If you do that the chart is going to show the whole three years by default. Then you can zoom.

When creating the data, use a TimePeriodValues populated with SimpleTimePeriod 's objects.

edited Mar 14, 2011 at 17:06

answered Mar 14, 2011 at 15:22

jzd

23.6k9 gold badges58 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jannis Alexakis Over a year ago

Hm, another question arises. Can (or should) i do series.add(new Minute(...)?

jzd Over a year ago

Actually there is not a TimeSeries for 1/4 of an hour. So I am updating my answer to suggest TimePeriodValuesCollection, which you can add a one SimpleTimePeriod object for each 15min time span.

Collectives™ on Stack Overflow

Creating TimeChart from MySql

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related