四、JSP源程序：
<%@ page contentType="text/html;charset=GBK"%>
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<%@ page import="java.awt.*" %>
<%@ page import="org.jfree.chart.*" %>
<%@ page import="org.jfree.chart.plot.*" %>
<%@ page import="org.jfree.chart.servlet.ServletUtilities" %>
<%@ page import="org.jfree.chart.entity.StandardEntityCollection" %>
<%@ page import="org.jfree.chart.renderer.category.BarRenderer3D" %>
<%@ page import="org.jfree.data.category.DefaultCategoryDataset" %>
<%@ page import="org.jfree.data.general.DefaultPieDataset" %>
<%@ page import="org.jfree.chart.renderer.category.BarRenderer3D" %>
<html>
<head><title>Jfree圖表</title>
<meta http-equiv="Content-Type" content="text/html;charset=gb2312">
</head>
<body>
<div align="cente"><P><font size="4" face="楷體_GB2312"><strong><font color="#0099ff">招生統計信息</font></strong></font></p>
</div>
<%
//設置生成餅狀圖
int i=0;
String[] area={"南京市","鎮江市","常州市","無錫市","蘇州市","南通市"};
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:aaa");
Statement sql=con.createStatement();
ResultSet rs=sql.executeQuery("select * from test");
//按地區進行統計
PrintWriter pw=null;
DefaultPieDataset dataset=new DefaultPieDataset();
//設置數據源
while(rs.next()){
String dq=rs.getString("dq");
dataset.setValue(area[i],Integer.parseInt(dq));
//添加數據，參數包括名稱和數值
i++;
}
rs.close();
sql.close();
con.close();
JFreeChart chart=ChartFactory.createPieChart("餅型圖",dataset,true,true,true);
chart.setTitle("統計圖");//設置圖片標題
ChartRenderingInfo info=new ChartRenderingInfo(new StandardEntityCollection());
String filename=ServletUtilities.saveChartAsJPEG(chart,300,200,info,session);
//設置生成圖片，包括圖片的大小，長度是300，寬是200
//out.println(filename);
session.setAttribute("file_name1",filename);
String URL= request.getContextPath() + "/servlet/DisplayChart?filename=" + filename;
session.setAttribute("file_url1",URL);
}
catch(SQLException e){
out.println(e);
}
%><%
//生成柱狀圖
try{
int j=0;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:aaa");
Statement sql=con.createStatement();
ResultSet rs=sql.executeQuery("select * from test");
DefaultCategoryDataset dataset=new DefaultCategoryDataset();//設置數據源
while(rs.next()){
dataset.addValue(Integer.parseInt(rs.getString("dq")),"學校",area[j]);
//添加數據，參數包括名稱和數值
j++;
}
JFreeChart chart1=ChartFactory.createBarChart3D("統計圖","招生地區","招生人數",
????????????????dataset,PlotOrientation.VERTICAL,false,false,false);
CategoryPlot plot=chart1.getCategoryPlot();
BarRenderer3D renderer1=new BarRenderer3D();
renderer1.setItemLabelsVisible(true);//顯示每個柱子上的數據
renderer1.setItemMargin(0.1);//設置每個柱子之間的距離
plot.setRenderer(renderer1);//讓上面對柱子的設置生效
String filename=ServletUtilities.saveChartAsJPEG(chart1,300,200,session);
//生成圖片，包括圖片的大小
session.setAttribute("file_name2",filename);
String URL=request.getContextPath()+"/servlet/DisplayChart?filename="+filename;
session.setAttribute("file_url2",URL);
}catch(SQLException e){}
%>
<center><img src="<%=session.getAttribute("file_url1")%>" width=300 height=200 border=0 usemap="#<%=session.getAttribute("file_name1") %>">
<img src="<%=session.getAttribute("file_url2") %>" width=300 height=200 border=0 usemap="#<%=session.getAttribute("file_name2")%>"></center>
</html>