Hi Friend,

Try the following code:

<%@page import="java.io.*"%>
<%@page import="java.sql.*"%>
<%@page import="org.jfree.chart.*"%>
<%@page import="org.jfree.chart.plot.*"%>
<%@page import="org.jfree.data.category.*"%>
<%
DefaultCategoryDataset dataset = new DefaultCategoryDataset();
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root";);
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select * from barchart");
while(rs.next()){
dataset.addValue(Double.parseDouble(rs.getString(1)), "Population", rs.getString(4));
dataset.addValue(Double.parseDouble(rs.getString(2)), "Prices", rs.getString(4));
dataset.addValue(Double.parseDouble(rs.getString(2)), "Temperature", rs.getString(4));
}
JFreeChart chart = ChartFactory.createBarChart(
"Bar Chart ",
"Months",
"Value",
dataset,
PlotOrientation.VERTICAL,
true,
true,
false
);
String f="C:/chart.jpg";
ChartUtilities.saveChartAsJPEG(new File(f), chart, 600, 300);
}
catch(Exception e){}
%>

Thanks