Hi Friend,

Try the following code:

import java.sql.*;
import java.io.*;
import org.jfree.ui.*;
import org.jfree.chart.ChartPanel;
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.createBarChart("Test", "Id", "Marks",
dataset, PlotOrientation.VERTICAL, true, true, false);
ChartPanel chartPanel = new ChartPanel(chart);
chartPanel.setPreferredSize(new java.awt.Dimension(500, 270));
ApplicationFrame f=new ApplicationFrame("Chart");
f.setContentPane(chartPanel);
f.pack();
f.setVisible(true);
try {
ChartUtilities.saveChartAsJPEG(new File("C:/chart.jpg"),
chart,400, 300);
} catch (IOException e) {
System.out.println("Problem in creating chart.");
}
}
}

For the above code, we have created following database table:

CREATE TABLE `chart` (
`id` bigint(40) NOT NULL auto_increment,
`marks` int(40) default NULL,
PRIMARY KEY (`id`)
)
Thanks

The Above code is good...

But i need a line graph with the data values in the chart itself..