Search found 15 matches

by marouene_
Mon May 07, 2012 8:17 pm
Forum: JFreeChart
Topic: Draw a line in Time series
Replies: 1
Views: 2921

Draw a line in Time series

hi,

How are you ? Hope you are doing right :)

So, i'm workin on a time series collection, every thing is workin, i can draw my chart, but i want to add a static line (for example y=5) in my chart and i don't have an idea how can i do that.


Can you help me please?
thank you
by marouene_
Wed Apr 25, 2012 9:19 pm
Forum: JFreeChart
Topic: Problem when Using Jfreechart with Mysql
Replies: 4
Views: 6364

Re: Problem when Using Jfreechart with Mysql

Hi, Now, my question is related to Jfreechart. Supposed we have this tables : +------------+----------+---------+ | day | Time | value | +------------+----------+---------+ | 2012-04-16 | 16:09:50 | 4619.46 | | 2012-04-16 | 17:10:05 | 3497.93 | | 2012-04-16 | 18:09:13 | 5862.1 | | 2012-04-16 | 19:09...
by marouene_
Tue Apr 24, 2012 10:00 pm
Forum: JFreeChart
Topic: Problem when Using Jfreechart with Mysql
Replies: 4
Views: 6364

Re: Problem when Using Jfreechart with Mysql

no help please ?
by marouene_
Sun Apr 22, 2012 7:33 pm
Forum: JFreeChart
Topic: Problem when Using Jfreechart with Mysql
Replies: 4
Views: 6364

Problem when Using Jfreechart with Mysql

Hi Everybody how are you ? Hope you are doing right ... Great, i'm working on a Java Servlet wich extract vlaues saved on a Mysql database. Actually all is working, when i use a simple sql request, i can draw the chart using Jfreechart... But the goal of my application is to draw a chart of the prev...
by marouene_
Wed Apr 27, 2011 12:11 pm
Forum: JFreeChart
Topic: Read values on Jfreechart graph
Replies: 2
Views: 4264

Re: Read values on Jfreechart graph

no idea?
by marouene_
Fri Apr 22, 2011 10:45 am
Forum: JFreeChart
Topic: Read values on Jfreechart graph
Replies: 2
Views: 4264

Read values on Jfreechart graph

Hello, i want to know if it's possible to read the values when i put the cursor on the graph like this

Image
by marouene_
Wed Apr 20, 2011 2:34 pm
Forum: JFreeChart
Topic: Porblem with month in Jfreechart
Replies: 4
Views: 6105

Re: Porblem with month in Jfreechart

No idea?
by marouene_
Tue Apr 19, 2011 10:44 pm
Forum: JFreeChart
Topic: Porblem with month in Jfreechart
Replies: 4
Views: 6105

Re: Porblem with month in Jfreechart

this is my sql querry : select month(date),avg(ftp) from ftptable group by month(date); this is my table : http://img233.imageshack.us/img233/6492/sqle.jpg i take some changes in my code, this is the new version final TimeSeries series = new TimeSeries("", Month.class); ResultSet rs = con.execute("s...
by marouene_
Tue Apr 19, 2011 3:53 pm
Forum: JFreeChart
Topic: Problem with seriesTimes
Replies: 3
Views: 3649

Re: Problem with seriesTimes

how .?
by marouene_
Tue Apr 19, 2011 3:50 pm
Forum: JFreeChart
Topic: Porblem with month in Jfreechart
Replies: 4
Views: 6105

Porblem with month in Jfreechart

hello, i test ResultSet rs = con.execute("select month(date),avg(usr) from table group by month(date);"); while(rs.next()){ int v1; v1 = rs.getInt("month(date)"); double v2=rs.getFloat("avg(ftp)"); Calendar cal = Calendar.getInstance(); series.addOrUpdate( new Month(v1,cal.get(Calendar.YEAR)), v2); ...
by marouene_
Tue Apr 19, 2011 2:46 pm
Forum: JFreeChart
Topic: Problem Jfreechart SQL
Replies: 2
Views: 3114

Re: Problem Jfreechart SQL

the problem is in this part of code : java.sql.Timestamp v1; v1 = rs.getTimestamp(""+Hour+""); because when i did select date ,debit from table; it works succesfully because the type of "date" is date. but when i did select month(date) it did'nt work, because the type of month(date) is int....
by marouene_
Sun Apr 17, 2011 11:48 pm
Forum: JFreeChart
Topic: Problem with seriesTimes
Replies: 3
Views: 3649

Problem with seriesTimes

Hello,
i hava a probleme in my Jfreechart graph,
i used a mysql database, i have a column ' date ' , the format is yyyy-mm-dd
i have also another column rate (type float);
i cant dress the graphe of the variation of the rate (avg(rate)) in function of month
please help
ty
by marouene_
Thu Apr 14, 2011 4:28 pm
Forum: JFreeChart
Topic: Probleme with jfreechart
Replies: 2
Views: 3866

Re: Probleme with jfreechart

ty it work :)
ty :)

have you an idea about the relation between jfreechart and sql ? i have a problem :)
by marouene_
Wed Apr 13, 2011 3:58 pm
Forum: JFreeChart
Topic: Problem Jfreechart SQL
Replies: 2
Views: 3114

Problem Jfreechart SQL

Hello, i have a database like this | TABLE | CREATE TABLE | +----------+------------------------------------------------------------------------------------------------------------------------------------------------------+ | ftptable | CREATE TABLE `ftptable` ( `date` date DEFAULT NULL, `heure` tim...
by marouene_
Wed Apr 13, 2011 3:21 pm
Forum: JFreeChart
Topic: Probleme with jfreechart
Replies: 2
Views: 3866

Probleme with jfreechart

Good morning, i have a little probleme : i used timeseries to show my graphe , this is my code : public JFreeChart tracercourbe (String Hour, String debit, String table ,String title,String ordonné,String where) throws SQLException, IOException { connexionBD con = new connexionBD(); TimeSeries serie...