Java prog#85. JFreeChart : Query (Sqlite,MySql) base charts

[@samgab113]

Hello, I have some questions, the JDBCCategoryDataSet is a class you created? or it comes with the ojdb14.jar library or another library?? if you created it can you share the code? ChartFrame is a class that you created or it is from the library? if you created it can you show me the code? Assuming that it belongs to the library how does it handle the close button and can you edit the close button action? Thanks

[@zukiyamaful]

i want to know this too,

[@brainiacmarco4014]

That's a internal class of JFreeChart, after you install the library you get this class

[@djnightcorezz787]

@@brainiacmarco4014 u sure ? I did not find it

[@brainiacmarco4014]

@@djnightcorezz787 hi, try type JDBCCategoryDa ,for example, and control space. Of Course you need have installed the library Jfreechart before.

[@fahrulrozi409]

hey i want to ask, if the database values changed, will the chart changes too without closing it /re-run first?

[@anildhami448]

I want to know if the sql query is dynamic means if query is like this: String sql = SELECT date, pressure FROM Userinfo WHERE Pumpid = ?; then how to plot BarChart or LineCHart?

[@enriquecruz7968]

Amigo! Your video was very helpful. Thanks so much.

[@fahrulrozi409]

hey pls spill the class that you Imported in this code

[@marulihasurungan5150]

why my JDBCCategoryDataset eror, how?

[@banicamanga7720]

Thank you for the tutorial. How would you create a bar graph with different categories? For example for x-axis would have the year and each year split into male and female and the y-axis is the population

[@TheWIECZNYMARZYCIEL]

hi, what if some of the results which gave the table on chart?

[@vanko26]

Neat and simple! Thanks, mate!

[@franckdoukaga5938]

Hi! just a help how can i create a line of integer according a serie time from a database example(92, 07:20:23),(80, 07:20:25),(85, 07:21:02).....

[@NanaZimmerUCLEAR360]

I liked this session. You've been helping me with my senior project. thank you

[@djnightcorezz787]

where Can I have the javaconnect class ? plz help

[@colinandpeter]

Trying to get my head into the space that's java after too many years away from programming. I can get the sql query to populate the chart just fine. Thank you for your very clear and concise tutorials;. But, a question and there had to be on. what if I want to filter or refine my database results. something like String query = "Select * from pumpdata where pressure = ?"; this would work under a preparedstatement where the ? is defined and passed into the string but what about when using JDBCCategoryDataset and at the moment I can not seem to find any way. So suggestions apart from a good night sleep. Are appreciated.

[@colinandpeter]

I found it, String query = "Select * from pumpdata where pressure = ' "+ pressureVariable +" ' ";

[@rutujajambhulkar4709]

Is it working?@@colinandpeter

[@TheHeaney01]

How do you put more than one line on the graph?

[@Imtiaazs]

Will this also work with apache derby?

[@brainiacmarco4014]

of course, postgrees, Oracle, SQLLite..

[@ohoodalhindi6456]

is it possible to explain "Guntt chart" .

[@safedupkid]

Been having difficulty with this for a while, thanks for your simple and straight forward tutorial. How would I approach adding other data lines into the graph?

[@rohitnarang007]

Hey ..I want to draw an organization chart. Is this possible with Jchart .

[@TheWIECZNYMARZYCIEL]

String sql = SELECT date, pressure FROM Userinfo WHERE Pumpid = ?; not chart :(

[@exodus9776]

hi, this isnt working for me. i need help. it wont show the lines

[@AngeloMaciRoberto]

Hi friend, this is the correct line. JDBCCategoryDataset dataset = new JDBCCategoryDataset(javaconnect.ConnectDB(), query);

[@exodus9776]

thanks for the help !

[@SANJEEVKUMAR-rh2wm]

with due respect, sir when i run program, in the chart only y-axis is showing others are not. and if you don't mind please share the JDBC connection class. thanking you..

[@OmarAhmedRamadan]

Thanks Code try { String query ="select id,age from employees"; JDBCCategoryDataset dataset = new JDBCCategoryDataset(Connect.connect(),query); // from class Connect JFreeChart chart =ChartFactory.createLineChart("Query Chart", "id", "age", dataset, PlotOrientation.VERTICAL, false, true, true); BarRenderer render =null; CategoryPlot plot=null; render = new BarRenderer(); ChartFrame fram = new ChartFrame("Query Chart", chart); fram.setVisible(true); fram.setSize(600,650); } catch (Exception e) { }

[@emqudrummer]

So, you use mysql as database and jfreechart as library to make a chart bro? Can i make this cart working in web application?

[@brainiacmarco4014]

for sure that's possible with Java EE

[@anildhami448]

Is your problem solved? if yes how?

[@rafare7]

Very well , thanks brother.

[@asadnizami5465]

can you give me a source code

[@lingasrinureddy2002]

hii.....i want full code programmes....

[@esvaramoorthyvipisanan292]

linga srinu reddy now do you have this code

[@andreapaz4392]

thanks a lot!

[@31khuutrongphuc18]

Thank you >_

[@jeanrodrigues6249]

WZ

[@lingasrinureddy2002]

hi