2010.03.09(3)——JfreeChart与后台交互之柱状图

lipeng88213

浏览: 937804 次
性别:
来自: 北京

最近访客更多访客>>

jklwan

小小书僮

诗人lpp

oyhptiandi01

博主相关

博客

微博

相册

留言

关于我

文章分类

全部博客 (526)

社区版块

存档分类

jfreechart Java Spring Servlet Hibernate

2010.03.09(3)——JfreeChart与后台交互之柱状图

这个例子所能达到的目的：
页面有几个复选框，当选择其中几个时，会生成对性的柱状图，并显示在页面上

**************************************************
web.xml
**************************************************

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5" 
	xmlns="http://java.sun.com/xml/ns/javaee" 
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
	xsi:schemaLocation="http://java.sun.com/xml/ns/javaee 
	http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
  	<welcome-file-list>
    	<welcome-file>index.jsp</welcome-file>
  	</welcome-file-list>
	
	<servlet>
      <servlet-name>DispatcherServlet</servlet-name>
      <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
       <init-param>
          <param-name>contextConfigLocation</param-name>
          <param-value>classpath:spring.xml</param-value>
       </init-param>
       <load-on-startup>1</load-on-startup>
   </servlet>
   <servlet-mapping>
   
      <servlet-name>DispatcherServlet</servlet-name>
      <url-pattern>*.do</url-pattern>
   </servlet-mapping>
   
   <servlet>
     	<servlet-name>DisplayChart</servlet-name>
     	<servlet-class>org.jfree.chart.servlet.DisplayChart</servlet-class>
	</servlet>
	<servlet-mapping>
    	<servlet-name>DisplayChart</servlet-name>
		<url-pattern>/servlet/DisplayChart</url-pattern>
	</servlet-mapping>
  
</web-app>

**************************************************
spring.xml
**************************************************

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	     xmlns:aop="http://www.springframework.org/schema/aop"
	     xmlns:tx="http://www.springframework.org/schema/tx"
	     xmlns:context="http://www.springframework.org/schema/context"
	     xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd
           http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.0.xsd
           http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.0.xsd
            http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd"
            default-autowire="byName"> 
	<!-- 
	<aop:aspectj-autoproxy proxy-target-class="true"/>
	-->
	
	<!-- 数据库外部文件配置 -->
    <bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
		<property name="locations">
			<list><value>classpath:db.properties</value></list>
		</property>
		<property name="fileEncoding" value="utf-8" />
	</bean>  
    <!-- 数据库外部文件配置 -->
    
    <!-- 配置数据源 使用dbcp数据源 -->
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">   
        <property name="driverClassName"  
            value="${jdbc.driverClassName}" />   
        <property name="url" value="${jdbc.url}" />   
        <property name="username" value="${jdbc.username}" />   
        <property name="password" value="${jdbc.password}" />   
    </bean>
    
    <!-- 配置数据源 使用dbcp数据源 -->
    
    <!-- Hibernate SessionFactory配置 -->
    <bean id="sessionFactory"  
        class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">   
        <property name="dataSource" ref="dataSource" />
        <property name="annotatedClasses">  
            <list>  
                <value>pojo.JianZhu</value>
                <value>pojo.LiangShi</value>   
            </list>  
        </property>   
        <property name="hibernateProperties">   
            <props>   
                <prop key="hibernate.dialect">   
                    org.hibernate.dialect.OracleDialect   
                </prop>   
                <prop key="show_sql">true</prop>   
                <prop key="hibernate.format_sql">true</prop>   
                <prop key="hibernate.use_sql_comments">true</prop>   
            </props>   
        </property>       
	</bean>
	
	<!-- Hibernate SessionFactory配置 -->
	
	<!-- hibernateTemplate -->
  	<bean id="hibernateTemplate" class="org.springframework.orm.hibernate3.HibernateTemplate">  
	    <property name="sessionFactory" ref="sessionFactory" />  
	</bean> 
	
	<!-- hibernateTemplate -->
	
	<!-- dao -->
	<bean id="testDao" class="dao.TestDaoImp" >
		<property name="hibernateTemplate">
			<ref bean="hibernateTemplate" />
		</property>
	</bean>
	<!-- dao -->
	
	<!-- serice -->
	<bean id="testService" class="service.TestServiceImp" >
		<property name="testDao" >
			<ref bean="testDao" />
		</property>
	</bean>
	<!-- serice -->
	
	<!-- spring MVC -->
	<bean id="testDelegate" class="control.TestControl">
		<property name="testService"><ref bean="testService"/></property>
	</bean>
	
	<bean id="testController" class="org.springframework.web.servlet.mvc.multiaction.MultiActionController">
	    <property name="methodNameResolver" ref="propMethodNameResolver"/>
	    <property name="delegate" ref="testDelegate"/>
	</bean>
	
	<bean id="urlMapping" class="org.springframework.web.servlet.handler.SimpleUrlHandlerMapping">
		<property name="mappings">
			<props>
				<prop key="/test_*.do">testController</prop>
			</props>
		</property>
	</bean>
	
	<bean id="propMethodNameResolver" class="org.springframework.web.servlet.mvc.multiaction.PropertiesMethodNameResolver">   
        <property name="mappings">   
            <props>   
            	<prop key="/test_1.do">test</prop>
            </props>   
        </property>   
    </bean>
            
	<bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
		<property name="viewClass"><value>org.springframework.web.servlet.view.JstlView</value></property>
		<property name="prefix"><value></value></property>
		<property name="suffix"><value>.jsp</value></property>
		<property name="contentType"><value>text/html;charset=utf-8</value></property>
	</bean>
	<!-- spring MVC -->
	
</beans>

**************************************************
pojo类
**************************************************

******************LiangShi.java

package pojo;

import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name="LIANGSHI")
public class LiangShi {
	private String name;
	@Id
	private Integer value;
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public Integer getValue() {
		return value;
	}
	public void setValue(Integer value) {
		this.value = value;
	}
	
}

*******************JianZhu.java

package pojo;

import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name="JIANZHU")
public class JianZhu {
	private String name;
	@Id
	private Integer value;
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public Integer getValue() {
		return value;
	}
	public void setValue(Integer value) {
		this.value = value;
	}
	
}

**************************************************
TestDao
**************************************************

package dao;

import java.util.List;

import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import pojo.JianZhu;
import pojo.LiangShi;

public class TestDaoImp extends HibernateDaoSupport implements TestDao {
	public List<JianZhu> query1(){
		String hql = "from JianZhu";
		return (List<JianZhu>)this.getHibernateTemplate().find(hql);
	}
	
	public List<LiangShi> query2(){
		String hql = "from LiangShi";
		return (List<LiangShi>)this.getHibernateTemplate().find(hql);
	}
	
	public List<JianZhu> query1(Object[] values){
		StringBuffer hql = new StringBuffer("from JianZhu o ");
		if(values!=null){
			hql.append("where ");
		}
		int i = 0;
		for(Object o : values){
			hql.append("o.name='").append(o).append("'");
			i++;
			if(i!=values.length)
				hql.append(" or ");
		}
		System.out.println(hql.toString());
		return (List<JianZhu>)this.getHibernateTemplate().find(hql.toString());
	}
	
	public List<LiangShi> query2(Object[] values){
		StringBuffer hql = new StringBuffer("from LiangShi o ");
		if(values!=null){
			hql.append("where ");
		}
		int i = 0;
		for(Object o : values){
			hql.append("o.name='").append(o).append("'");
			i++;
			if(i!=values.length)
				hql.append(" or ");
		}
		System.out.println(hql.toString());
		return (List<LiangShi>)this.getHibernateTemplate().find(hql.toString());
	}
}

**************************************************
TestService
**************************************************

package service;

import java.util.List;

import pojo.JianZhu;
import pojo.LiangShi;
import dao.TestDao;

public class TestServiceImp implements TestService {
	private TestDao testDao;

	public TestDao getTestDao() {
		return testDao;
	}

	public void setTestDao(TestDao testDao) {
		this.testDao = testDao;
	}
	public List<JianZhu> query1(){
		return this.testDao.query1();
	}
	
	public List<LiangShi> query2(){
		return this.testDao.query2();
	}

	public List<JianZhu> query1(Object[] values) {
		// TODO Auto-generated method stub
		return this.testDao.query1(values);
	}

	public List<LiangShi> query2(Object[] values) {
		// TODO Auto-generated method stub
		return this.testDao.query2(values);
	} 
}

**************************************************
TestControl
**************************************************

package control;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.jfree.data.category.DefaultCategoryDataset;
import org.springframework.web.servlet.ModelAndView;

import pojo.BarChartTest;
import pojo.JianZhu;
import pojo.LiangShi;
import service.TestService;

public class TestControl {
	private TestService testService;

	public TestService getTestService() {
		return testService;
	}

	public void setTestService(TestService testService) {
		this.testService = testService;
	}
	public ModelAndView test(HttpServletRequest request,HttpServletResponse response) throws IOException{
		String city = request.getParameter("city");
		String type = request.getParameter("type");
		String[] values1 = type.split("-");
		String[] values = city.split("-");
		List<JianZhu> list1 = null;
		List<LiangShi> list2 = null;
		for(String str : values1){
			if(str.equals("jianzhu")){
				list1 = testService.query1(values);
			}
			if(str.equals("liangshi")){
				list2 = testService.query2(values);
			}
				
		}
		DefaultCategoryDataset dataset = new DefaultCategoryDataset();
		if(list2!=null){
			for(int i=0;i<list2.size();i++){
				dataset.setValue(list2.get(i).getValue(), "粮食用地", list2.get(i).getName());
			}
		}
		if(list1!=null){
			for(int i=0;i<list1.size();i++){
				dataset.setValue(list1.get(i).getValue(), "建筑用地", list1.get(i).getName());
			}
		}
		PrintWriter out = response.getWriter();
		String str = BarChartTest.drawToHtml(BarChartTest.createChart(dataset), request.getSession(), out;
		out.print(str);
		return null;
	}
}

**************************************************
柱状图：
**************************************************

package pojo;
import java.awt.Color;   
import java.awt.Font;   
import java.io.FileNotFoundException;   
import java.io.FileOutputStream;   
import java.io.IOException;   
import java.io.PrintWriter;

import javax.servlet.http.HttpSession;
  
import org.jfree.chart.ChartFactory;   
import org.jfree.chart.ChartFrame;   
import org.jfree.chart.ChartRenderingInfo;
import org.jfree.chart.ChartUtilities;   
import org.jfree.chart.JFreeChart;   
import org.jfree.chart.axis.CategoryAxis;   
import org.jfree.chart.entity.StandardEntityCollection;
import org.jfree.chart.labels.StandardCategoryItemLabelGenerator;   
import org.jfree.chart.plot.CategoryPlot;   
import org.jfree.chart.plot.PlotOrientation;   
import org.jfree.chart.renderer.category.BarRenderer;   
import org.jfree.chart.renderer.category.BarRenderer3D;
import org.jfree.chart.servlet.ServletUtilities;
import org.jfree.chart.title.LegendTitle;   
import org.jfree.chart.title.TextTitle;   
import org.jfree.data.category.CategoryDataset;   
import org.jfree.data.category.DefaultCategoryDataset;   
  
  
/**  
 * 柱状图和折线图  
 * @author qiujy  
 */  
public class BarChartTest {   
       
       
    /**  
     * step2:创建图表  
     * @param dataset  
     * @return  
     */  
    public static JFreeChart createChart(CategoryDataset dataset) {   
        JFreeChart chart = ChartFactory.createBarChart3D(   //3D柱状图   
        //JFreeChart chart = ChartFactory.createLineChart3D(  //3D折线图   
                "原创图书销量统计", //图表的标题   
                "图书名",  //目录轴的显示标签    
                "销量",   //数值轴的显示标签   
                dataset, //数据集   
                PlotOrientation.VERTICAL,  //图表方式：V垂直;H水平    
                true, // 是否显示图例   
                false, // 是否显示工具提示   
                false // 是否生成URL   
                );   
           
        //===============为了防止中文乱码：必须设置字体   
        chart.setTitle(new TextTitle("原创图书销量统计", new Font("黑体", Font.ITALIC, 22)));   
       
        LegendTitle legend = chart.getLegend(); // 获取图例   
        legend.setItemFont(new Font("宋体", Font.BOLD, 12)); //设置图例的字体，防止中文乱码   
       
        CategoryPlot plot = (CategoryPlot) chart.getPlot(); // 获取柱图的Plot对象(实际图表)   
        // 设置柱图背景色（注意，系统取色的时候要使用16位的模式来查看颜色编码，这样比较准确）   
        plot.setBackgroundPaint(new Color(255, 255, 204));   
        plot.setForegroundAlpha(0.65F); //设置前景色透明度   
           
        // 设置横虚线可见   
        plot.setRangeGridlinesVisible(true);   
        // 虚线色彩   
        plot.setRangeGridlinePaint(Color.gray);   
           
        CategoryAxis h = plot.getDomainAxis(); //获取x轴   
        h.setMaximumCategoryLabelWidthRatio(1.0f);// 横轴上的 Lable 是否完整显示   
        h.setLabelFont(new Font("宋体", Font.BOLD, 12));//设置字体，防止中文乱码   
        h.setTickLabelFont(new Font("宋体", Font.BOLD, 12));// 轴数值    
        //h.setCategoryLabelPositions(CategoryLabelPositions.UP_45);//45度倾斜   
           
        plot.getRangeAxis().setLabelFont(new Font("宋体", Font.BOLD, 12)); //Y轴设置字体，防止中文乱码   
           
        //柱图的呈现器   
        BarRenderer3D renderer = new BarRenderer3D();    
        // 设置柱子宽度    
        //renderer.setMaximumBarWidth(0.05);    
        // 设置柱子高度    
        //renderer.setMinimumBarLength(0.2);    
        // 设置柱子边框颜色    
        renderer.setBaseOutlinePaint(Color.BLACK);    
        // 设置柱子边框可见    
        renderer.setDrawBarOutline(true);    
        //设置每个柱的颜色    
        renderer.setSeriesPaint(0, Color.BLUE);    
        renderer.setSeriesPaint(1, Color.GREEN);    
        renderer.setSeriesPaint(2, Color.RED);    
        //设置每个地区所包含的平行柱的之间距离    
        renderer.setItemMargin(0.05);    
        // 显示每个柱的数值，并修改该数值的字体属性    
        renderer.setIncludeBaseInRange(true);    
        renderer.setBaseItemLabelGenerator(new StandardCategoryItemLabelGenerator());    
        renderer.setBaseItemLabelsVisible(true);    
        // 设置柱的透明度    
        plot.setForegroundAlpha(1.0f);    
        //给柱图添加呈现器   
        plot.setRenderer(renderer);    
           
        // 没有数据的时候显示的内容   
        plot.setNoDataMessage("找不到可用数据...");  
        
        return chart;   
    }   
       
    
    /**  
     * step3: 输出图表到网页  
     * @param destPath  
     * @param chart  
     */
    public static String drawToHtml(JFreeChart chart,HttpSession session,PrintWriter out){
    	ChartRenderingInfo info = new ChartRenderingInfo(
                new StandardEntityCollection());
    	String fileName = "";
    	try
        {
            fileName = ServletUtilities.saveChartAsPNG(chart, 500, 300, info,
                    session);//生成图片
//          Write the image map to the PrintWriter
            ChartUtilities.writeImageMap(out, fileName, info, false);
        }
        catch (IOException e)
        {
            e.printStackTrace();
        }
        out.flush();
        return fileName;//返回生成图片的文件名
    }
   
  
}

这个，和原来的柱状图就两天区别：
1.dataset要改，改为从数据库中获取，我已经去掉了
2.就是drawToHtml(),这个方法的
ChartUtilities.writeImageMap(out, fileName, info, false);
out.flush();
这两句话要注释
因为我们现在只需要生成图片的地址就行了不需要立马就放到页面上去

**************************************************
jsp
**************************************************

<%@ page contentType="text/html;charset=utf-8" pageEncoding="utf-8"%>
<html>
<head>
<title> JFreeChart使用例子</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<script type="text/javascript" src="js/jquery-1.3.2.js"></script>
<script type="text/javascript">
$(function(){
	$("#p").hide();
	$("#bn").click(ajax);
})
function ajax(){
	$.ajax({
		type: "post",
		url: "test_1.do",
		data: {type:fn("t1"),city:fn("t2")},
		dataType: "text",
		success: function(data){
			//$("#p").attr("usermap","#"+data);
			$("#p").attr("src","servlet/DisplayChart?filename="+data);
			$("#p").show();
		}
	});
}
function fn(id){
	var str = "";
	var i = 0;
	$("#"+id+" :checkbox:checked").each(function(){
		str += $(this).val();
		i++;
		if(i!=$("#"+id+" :checkbox:checked").length){
			str += "-";
		}
	});
	return str;
}
</script>
</head>
<body>
<div id="t1">
类型：
建筑<input type="checkbox" name="checkbox" id="checkbox1" value="jianzhu"/>
粮食<input type="checkbox" name="checkbox" id="checkbox2" value="liangshi"/><br />
</div>
<div id="t2">
地区：
唐家岭<input type="checkbox" name="checkbox" id="checkbox3" value="唐家岭"/>
东北旺<input type="checkbox" name="checkbox" id="checkbox4" value="东北旺"/>
上地<input type="checkbox" name="checkbox" id="checkbox5" value="上地"/><br />
</div>
<input type="button" value="生成图片" id="bn" /><br />
<img id="p" width="500" height="300" border="0" >
</body>
</html>

对了还有数据库
**************************************************
sql
**************************************************

create table jianzhu(
name varchar2(20),
value number(20)
)
;
create table liangshi(
name varchar2(20),
value number(20)
)
;
insert into jianzhu values('唐家岭',2000);
insert into jianzhu values('东北旺',1500);
insert into jianzhu values('上地',3200);
insert into liangshi values('唐家岭',7500);
insert into liangshi values('东北旺',4100);
insert into liangshi values('上地',13000);