E-charts
1.柱状图和饼状图
1.1怎样展示?
1.1.1).Jfreechart:免费,功能一般,效果一般(不怎么绚丽),但是是之前的产物,以前用的比较多,现在用的比较少了,建议了解
1.1. 2).e-charts:免费,百度出产的,功能强大,效果(绚丽),近几年的产物,现在国内的众多软件公司用的比较多,推荐学习
1.1.3).Hight-charts:国外产生,功能强大,效果绚丽,据说XX是抄袭他的,在国内用的比较少,建议了解
1.2使用图表工具的意义
1.2.1).清晰直观的使得数据可视化
1.1.2).结和后台技术真正做到数据的实时变化,例如可以实现k线图,因为有js定时器
1.1.3).提升软件产品的用户体验
2.e-charts应用举例之通过柱状图显示公司的全年–季度财务统计报告
1.引入e-charts和jquery
<script type="text/javascript" src="<%=request.getContextPath()%>/js/echarts/echarts.js"></script>
<script type="text/javascript" src="<%=request.getContextPath()%>/js/jquery/jquery.js"></script>
2.在<body>标签中设置图显示的在div中
<div id="main" style="width: 600px;height:400px;"></div>:备注如果要是想显示自动适配为就设定为100%
3.后台传递给zhutu.jsp三个list,其目的是为了显示收入,支出和预算
/**
* 1.柱状图
* @param request
* @param response
* @throws IOException
* @throws SQLException
* @throws ClassNotFoundException
* @throws ServletException
*/
private void zhu(HttpServletRequest request, HttpServletResponse response) throws IOException, ClassNotFoundException, SQLException, ServletException {
System.out.println("TuServlet----->zhu()---->");
List<Map<String, Object>> list_shouru=service.queryShouru();
List<Map<String, Object>> list_zhichu=service.queryZhichu();
List<Map<String, Object>> list_yusuan=service.queryYusuan();
request.setAttribute("list_shouru", list_shouru);
request.setAttribute("list_zhichu", list_zhichu);
request.setAttribute("list_yusuan", list_yusuan);
request.getRequestDispatcher("/jsps/manages/tu/zhuTu.jsp").forward(request, response);
}
public List<Map<String, Object>> queryShouru() throws ClassNotFoundException, SQLException {
String sql=" SELECT QUARTER(riqi) jidu,SUM(shouRuJinEr) jiner FROM shouru GROUP BY QUARTER(riqi) ";
List<Map<String, Object>> list_shouru = dao.executeQueryForList(sql);
return list_shouru;
}
public List<Map<String, Object>> queryZhichu() throws ClassNotFoundException, SQLException {
String sql2=" SELECT QUARTER(riqi) jidu,SUM(zhiChuJinEr) jiner FROM zhichu GROUP BY QUARTER(riqi) ";
List<Map<String, Object>> list_zhichu = dao.executeQueryForList(sql2);
return list_zhichu;
}
public List<Map<String, Object>> queryYusuan() throws ClassNotFoundException, SQLException {
String sql3=" SELECT QUARTER(riqi) jidu,SUM(yuSuanJinEr) jiner FROM yusuan GROUP BY QUARTER(riqi) ";
List<Map<String, Object>> list_yusuan = dao.executeQueryForList(sql3);
return list_yusuan;
}
4.在zhutu.jsp中通过js将3个lis