Hi Friend,

1) If you want to generate bar chart using JFreeChart in java, try the following :

import org.jfree.chart.ChartFactory;
import org.jfree.chart.*;
import org.jfree.chart.JFreeChart;
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;
import java.sql.*;

public class BarChartExample {

public static void main( String[] args) throws Exception{
String query="SELECT * from chart1";
JDBCCategoryDataset dataset=new JDBCCategoryDataset("jdbc:mysql://192.168.10.112:3306/mysql";,
"com.mysql.jdbc.Driver","root","root");

dataset.executeQuery(query);
JFreeChart chart = ChartFactory .createBarChart3D(
"Bar Chart",
"Task",
"Hours",
dataset,
PlotOrientation.VERTICAL,true, true, false);
ChartFrame frame=new ChartFrame("Bar Chart",chart);
frame.setVisible(true);
frame.setSize(400,350);
}
}

2) In JSP,try the following:

<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<%@ page import="org.jfree.chart.ChartFrame" %>
<%@ page import="org.jfree.chart.ChartFactory" %>
<%@ page import="org.jfree.chart.ChartUtilities" %>
<%@ page import="org.jfree.chart.JFreeChart" %>
<%@ page import="org.jfree.chart.plot.PlotOrientation"%>
<%@ page import="org.jfree.data.*" %>
<%@ page import="org.jfree.data.jdbc.JDBCCategoryDataset"%>

<%
String query="SELECT * from chart1";
JDBCCategoryDataset dataset=new JDBCCategoryDataset("jdbc:mysql://192.168.10.112:3306/mysql";,
"com.mysql.jdbc.Driver","root","root");

dataset.executeQuery( query);
JFreeChart chart = ChartFactory .createBarChart3D(
"Bar Chart",
"Task",
"Hours",
dataset,
PlotOrientation.VERTICAL,true, true, false);
ChartFrame frame=new ChartFrame("Bar Chart",chart);
frame.setVisible(true);
frame.setSize(400,350);
try
{
ChartUtilities.saveChartAsJPEG(new File("C:/chart.jpg"), chart, 400, 300);
}
catch (IOException e)
{
System.out.println("Problem in creating chart.");
}
%>
Thanks