Hi Friend,

We have used jfreechart library to create a bar graph. And the chart displays the database values.If you want to download the jar files,please visit the following link:

http://www.roseindia.net/chartgraphs/jfreechart-introduction.shtml

Here is the code:

import java.sql.* ;
import java.io.* ;
import org.jfree.chart.ChartFactory ;
import org.jfree.chart.ChartUtilities;
import org.jfree.chart.JFreeChart ;
import org.jfree.chart.plot.PlotOrientation;
import org.jfree.data.* ;
import org.jfree.data.jdbc.JDBCCategoryDataset;

public class Chart{
public static void main(String[]args) throws Exception{


String query="SELECT * from chart";
JDBCCategoryDataset dataset=new JDBCCategoryDataset("jdbc:mysql://localhost:3306/test";;,
"com.mysql.jdbc.Driver","root","root");

dataset.executeQuery( query);
JFreeChart chart = ChartFactory .createBarChart3D(
"Test",
"Id",
"Score",
dataset,
PlotOrientation.VERTICAL,true, true, false);
try
{
ChartUtilities.saveChartAsJPEG(new File("C:/chart.jpg"), chart, 400, 300);
}
catch (IOException e)
{
System.out.println("Problem in creating chart.");
}
}
}

Thanks