自学highcharts饼图，springMVC框架，后台java，mysql数据库，官网下载Highcharts，留待以后备用

jsp页面代码：

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%><%String path = request.getContextPath();String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";%>      
     
      <%=basePath%>">    
      饼图    
      	
       
        <%=path%>/js/Highcharts/js/highcharts.js">    
        
         <%=path%>/js/Highcharts/js/modules/exporting.js">	
         
          $(function () {var rand = Math.random();	$.ajax( {		url : "./pietest.do",		type : "post",		async : false,		data: "rand="+rand,		dataType: "json",		contentType : "application/x-www-form-urlencoded; charset=utf-8",		success : function(data, textStatus) {		    var l = data.length;		    var piedata = [];  		    for(var i=0;i
          
           {point.percentage:.1f}%'        },        plotOptions: {            pie: {                allowPointSelect: true,                cursor: 'pointer',                dataLabels: {                    enabled: true,                    format: '
           {point.name}: {point.percentage:.1f} %',                    style: {                        color: (Highcharts.theme && Highcharts.theme.contrastTextColor) || 'black'                    }                }            }        },        series: [{            type: 'pie',            name: '男女比例',            data: p        }]    });    }            
           
            饼图
           
    
           
              

java代码：

控制器：

@ResponseBody	@RequestMapping(value={"/pietest.do"}, method={RequestMethod.GET,RequestMethod.POST})	public void pietest(HttpServletRequest request,HttpServletResponse response) throws IOException{		System.out.println("111111111111111111111111111111");		response.setCharacterEncoding("utf-8");		PrintWriter out = response.getWriter();		List
      
       > list = null;		list = dialogDao.pieFindInfo();		JSONArray json = JSONArray.fromObject(list);		out.print(json);	}

接口实现：

public List
      
       > pieFindInfo() {		List
       
        
         > list = null;		try {			String sql = "SELECT IF(sex=1,'男','女') sex,COUNT(*) mrs FROM student WHERE id  IN (SELECT id FROM student WHERE sex = 1) UNION ALL SELECT IF(sex=0,'女','男') sex, COUNT(*) fmrs FROM student WHERE id  IN (SELECT id FROM student WHERE sex = 0)";			list = jdbcTemplate.queryForList(sql);		} catch (Exception e) {			e.getStackTrace();		}		return list;	}

结果：