Pie chart on jsp

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.