
how can i create a pie chart on a jsp page using jfreechart which takes values from my databaase??

Here is a jsp code that creates a pie chart using JFreechart api and takes the value from the database.
<%@page import="java.sql.*"%>
<%@page import="java.io.*%>
<%@page import="org.jfree.ui.*%>
<%@page import="org.jfree.chart.ChartPanel%>
<%@page import="org.jfree.chart.ChartFactory%>
<%@page import="org.jfree.chart.ChartUtilities%>
<%@page import="org.jfree.chart.JFreeChart%>
<%@page import="org.jfree.data.*%>
<%@page import="org.jfree.data.jdbc.JDBCPieDataset%>
<%
String query = "SELECT * from result";
JDBCPieDataset dataset = new JDBCPieDataset(
"jdbc:mysql://localhost:3306/test", "com.mysql.jdbc.Driver",
"root", "root");
dataset.executeQuery(query);
JFreeChart chart = ChartFactory.createPieChart("Test", dataset, 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);
%>
For the above code, we have created a database table named result which consists of two fields, id and marks.