jfreechart 出错TrueTypeFont.class
package com.ff.servlet;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.awt.Font;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import org.jfree.chart.ChartFactory;
import org.jfree.chart.ChartUtilities;
import org.jfree.chart.JFreeChart;
import org.jfree.chart.axis.CategoryAxis;
import org.jfree.chart.axis.NumberAxis;
import org.jfree.chart.plot.CategoryPlot;
import org.jfree.chart.plot.PlotOrientation;
import org.jfree.chart.title.LegendTitle;
import org.jfree.chart.title.TextTitle;
import org.jfree.data.category.CategoryDataset;
import org.jfree.data.category.DefaultCategoryDataset;
import com.ff.order.*;
import com.ff.product.Product;
import com.ff.util.DBTool;
public class BarServlet extends HttpServlet {
public BarServlet() {
super();
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
CategoryDataset dataset = getDataSet();
JFreeChart chart = ChartFactory.createBarChart3D("产品", // 图标题
"产品", // 目录轴的显示标签
"数量", // 数值轴的显示标签
dataset, PlotOrientation.VERTICAL,// 图表方向:水平,垂直
true, // 是否显示图例
false, // 是否生成工具
false);// 是否生成URL链接
// 设置图标题的字体
Font font = new Font("黑体", Font.HANGING_BASELINE, 20);
TextTitle title = new TextTitle("产品图");
// BarRenderer3D render = new BarRenderer3D();
// render.setBaseItemLabelFont(new Font("黑体",Font.BOLD,12));//12号黑体加粗
// 设置图例中的字体
LegendTitle legend = chart.getLegend();
legend.setItemFont(new Font("宋体", Font.BOLD, 16));
// 横轴
CategoryPlot plot = (CategoryPlot) chart.getPlot();
// CategoryPlot plot = (CategoryPlot) chart.getCategoryPlot();
// plot.setRenderer(render);//使用我们设计的效果
CategoryAxis cateaxis = plot.getDomainAxis();
cateaxis.setLabelFont(new Font("粗体", Font.BOLD, 16));
// 设置横轴的标签
cateaxis.setTickLabelFont(new Font("粗体", Font.BOLD, 16));
// 纵轴
NumberAxis numaxis = (NumberAxis) plot.getRangeAxis();
numaxis.setLabelFont(new Font("宋体", Font.BOLD, 16));
chart.setTitle(title);
FileOutputStream fos_jpg = null;
try {
fos_jpg = new FileOutputStream("D:\\product.jpg");
ChartUtilities.writeChartAsJPEG(fos_jpg, 1, chart, 500, 400, null);
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
} finally {
try {
fos_jpg.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doGet(request,response);
}
public CategoryDataset getDataSet() {
DefaultCategoryDataset dataset = new DefaultCategoryDataset();
Connection conn=DBTool.getConnection();
Statement st=DBTool.getStatment(conn);
String sql="select product.name, count(salesitem.pcount) " +
"from product join salesitem on (product.id=salesitem.productid)group by product.id";
System.out.print(sql);
ResultSet rs=DBTool.getRusultSet(st, sql);
try {
while(rs.next()){
dataset.addValue(rs.getInt(2), "", rs.getString(1));
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
DBTool.close(rs);
DBTool.close(st);
DBTool.close(conn);
}
return dataset;
}
}
数据库查询结果:
|neme |count(salesitem.pcount)|
|商品0| 3 |
|商品1| 2 |
|商品3| 1 |
在Tomcat6.0中老是出 TRuetypeFont的错误
在虚拟机上无错误