JFreeChart项目实例
来源：互联网 发布：手机电信4g网络被劫持 编辑：程序博客网 时间：2024/06/05 21:07
最近利用JFreeChart和MySQL数据库做了一个JSP网页，展现Android Martet全球12个国家的TOP800游戏排名的曲线走势
准备知识，请先阅读我先前写的博客
JFreeChart学习示例
Linux JSP连接MySQL数据库
需导入jar包如下：
完整代码：
<%@ page language="java" contentType="text/html" pageEncoding="utf-8" %><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <%@ page language="java" import="java.sql.*" %> <%@ page language="java" import="java.io.*" %> <%@ page language="java" import="java.io.*" %> <%@ page language="java" import="java.awt.*" %> <%@ page language="java" import="org.jfree.data.*" %> <%@ page language="java" import="org.jfree.data.category.*" %> <%@ page language="java" import="org.jfree.data.general.*" %> <%@ page language="java" import="org.jfree.chart.*" %> <%@ page language="java" import="org.jfree.chart.entity.*" %> <%@ page language="java" import="org.jfree.chart.plot.*" %> <% // GLOBLE PARAMS // MySQL 连接JDBC String MYSQL_DRIVER = "com.mysql.jdbc.Driver"; String MYSQL_URL = "jdbc:mysql://localhost:3306/top800"; // 数据库查询语句 String chartTitle = "GameName of Country"; String sql = "select * from (select name, id, dtime, top, country, category, rating, ratingcount, download, price, version, filesize, requireandroid, url from gametop800 where name like \"%3D Bowling%\" and country = \"usa\" order by dtime desc limit 0, 2147483647) as tbl order by dtime asc"; %><%@page import="org.jfree.chart.plot.PlotOrientation"%><%@page import="java.util.Date"%><%@page import="org.jfree.chart.servlet.ServletUtilities"%><%@page import="org.jfree.chart.axis.NumberAxis"%><%@page import="org.jfree.chart.axis.CategoryAxis"%><%@page import="org.jfree.chart.axis.CategoryLabelPositions"%><html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><title>Top800 Game Free Chart Line</title></head><body><center><form method="post"><div style="margin: auto 30px; width: 1000px" ><select name="game_type"><option value="游戏名称">游戏名称</option><option value="游戏包名">游戏包名</option></select>：<input type="text" name="game_keyword" style="width:300px" /> 所属国家：<select name="countryname" style="width:100px"><option value="usa">usa</option><option value="england">england</option><option value="france">france</option><option value="japan">japan</option><option value="italy">italy</option><option value="german">german</option><option value="india">india</option><option value="spain">spain</option><option value="russia">russia</option><option value="china">china</option><option value="eu">eu</option></select> 记录时间：<select name="game_dtime"><option value="全部">全部</option><option value="最近一周">最近一周</option><option value="最近一月">最近一月</option></select> <input type="submit" value="查询" style="width:60px"></div><hr style="width: 80%" /><%String game_type = new String("游戏名称");String game_keyword = "3D Bowling";String countryname = "usa";String game_dtime = new String("全部");request.setCharacterEncoding("utf-8");game_type = request.getParameter("game_type");game_keyword = request.getParameter("game_keyword");countryname = request.getParameter("countryname");game_dtime = request.getParameter("game_dtime");int limitTop = Integer.MAX_VALUE;game_type = game_type == null ? game_type = "游戏名称" : game_type.trim();game_keyword = game_keyword == null ? game_keyword = "3D Bowling" : game_keyword.trim();countryname = countryname == null ? countryname = "usa" : countryname.trim();game_dtime = game_dtime == null ? game_dtime = "全部" : game_dtime.trim();if (game_dtime != null) {if (game_dtime.equals("全部")) {limitTop = Integer.MAX_VALUE;} else if (game_dtime.equals("最近一周")) {limitTop = 7;} else if (game_dtime.equals("最近一月")) {limitTop = 30;} else {limitTop = Integer.MAX_VALUE;}}if (game_keyword != null && game_keyword != "") {chartTitle = game_keyword + " of " + countryname;if (game_type.equals("游戏名称")) {sql = "select * from (select name, id, dtime, top, country, category, rating, ratingcount, download, price, version, filesize, requireandroid, url from gametop800 where name like \"%"+ game_keyword+ "%\" and country = \""+ countryname+ "\" order by dtime desc limit 0, "+ limitTop + ") as tbl order by dtime asc";} else if (game_type.equals("游戏包名")) {sql = "select * from (select name, id, dtime, top, country, category, rating, ratingcount, download, price, version, filesize, requireandroid, url from gametop800 where id = \""+ game_keyword+ "\" and country = \""+ countryname+ "\" order by dtime desc limit 0, "+ limitTop + ") as tbl order by dtime asc";} else {sql = "select * from (select name, id, dtime, top, country, category, rating, ratingcount, download, price, version, filesize, requireandroid, url from gametop800 where name like \"%"+ game_keyword+ "%\" and country = \""+ countryname+ "\" order by dtime desc limit 0, "+ limitTop + ") as tbl order by dtime asc";}} else {game_type = "游戏名称";game_keyword = "3D Bowling";countryname = "usa";game_dtime = "全部";}%><table border="2" width="40%"><tr><td valign="middle"><b><%=game_type%>：</b></td><td><%=game_keyword%> </td></tr><tr><td valign="middle"><b>所属国家：</b></td><td><%=countryname%></td></tr><tr><td valign="middle"><b>记录时间：</b></td><td><%=game_dtime%></td></tr></table><hr style="width: 80%" /><%DefaultCategoryDataset dataset = new DefaultCategoryDataset();Connection conn = null;Statement stmt = null;ResultSet rs = null;try {// 连接 MySQL 数据库Class.forName(MYSQL_DRIVER).newInstance();conn = DriverManager.getConnection(MYSQL_URL, "root", "");stmt = conn.createStatement();rs = stmt.executeQuery(sql);// 遍历读取的数据集while (rs.next()) {String name = rs.getString(1);String dtime = rs.getString(3);int top = rs.getInt(4);if (name != null && dtime != null) {dataset.addValue(top, name, dtime);// 构造JFreeChart的数据集dataset}}} catch (Exception e) {System.err.println(e.getMessage());}JFreeChart chart = ChartFactory.createLineChart(chartTitle, // 标题"记录时间", // 横轴名称"游戏排名", // 纵轴名称dataset,// 数据集PlotOrientation.VERTICAL,// 垂直视图 true, true, true);final CategoryPlot plot = (CategoryPlot) chart.getPlot();plot.setBackgroundPaint(Color.lightGray);// 背景色plot.setRangeGridlinePaint(Color.blue);// 横轴虚线plot.setRangeGridlinesVisible(true);// 横轴虚线是否可见final NumberAxis rangeAxis = (NumberAxis) plot.getRangeAxis();rangeAxis.setAutoRangeMinimumSize(1);// 距离为1rangeAxis.setAutoRangeIncludesZero(true);// 从零计算rangeAxis.setInverted(true);// 纵轴逆序（原点到顶端，是从大到小）final CategoryAxis categoryAxis = plot.getDomainAxis();if (limitTop == 7) {categoryAxis.setCategoryLabelPositions(CategoryLabelPositions.STANDARD);// 横轴标准显示（水平）} else {categoryAxis.setCategoryLabelPositions(CategoryLabelPositions.UP_45);// 横轴45度显示（倾斜）}FileOutputStream fos_jpg = null;String file_jpg = null;String url_jpg = null;try {final ChartRenderingInfo info = new ChartRenderingInfo(new StandardEntityCollection());file_jpg = ServletUtilities.saveChartAsJPEG(chart, 1200, 600, info, null);// 生成图片url_jpg = request.getContextPath() + "/servlet/DisplayChart?filename=" + file_jpg;// 图片路径} catch (Exception e) {out.println(e);} finally {try {fos_jpg.close();} catch (Exception e) {e.printStackTrace();}}%> <img src=<%=url_jpg%> border="1" /><!-- 显示图片（url_jpg为JFreeChart生成图片的路径） --> <hr style="width: 80%" /><table border="2" borderColor="#00000" cellPadding="0" cellSpacing="0" width="auto" ><tbody><tr><td bgColor="#008080" height="28" align="center" valign="middle"><font color="#ffffff"><b>name</b></font></td><td bgColor="#008080" height="28" align="center" valign="middle"><font color="#ffffff"><b>id</b></font></td><td bgColor="#008080" height="28" align="center" valign="middle"><font color="#ffffff"><b>dtime</b></font></td><td bgColor="#008080" height="28" align="center" valign="middle"><font color="#ffffff"><b>top</b></font></td><td bgColor="#008080" height="28" align="center" valign="middle"><font color="#ffffff"><b>country</b></font></td><td bgColor="#008080" height="28" align="center" valign="middle"><font color="#ffffff"><b>category</b></font></td><td bgColor="#008080" height="28" align="center" valign="middle"><font color="#ffffff"><b>rating</b></font></td><td bgColor="#008080" height="28" align="center" valign="middle"><font color="#ffffff"><b>ratingcount</b></font></td><td bgColor="#008080" height="28" align="center" valign="middle"><font color="#ffffff"><b>download</b></font></td><td bgColor="#008080" height="28" align="center" valign="middle"><font color="#ffffff"><b>price</b></font></td><td bgColor="#008080" height="28" align="center" valign="middle"><font color="#ffffff"><b>version</b></font></td><td bgColor="#008080" height="28" align="center" valign="middle"><font color="#ffffff"><b>filesize</b></font></td><td bgColor="#008080" height="28" align="center" valign="middle"><font color="#ffffff"><b>requireandroid</b></font></td></tr><%try {rs = stmt.executeQuery(sql);while (rs.next()) {%><tr><td height="18" vAlign="middle" align="center"><a href="<%=rs.getString(14)%>" target="_blank"><%=rs.getString(1)%></a></td><td height="18" valign="middle" align="center"><%=rs.getString(2)%></td><td height="18" valign="middle" align="center"><%=rs.getString(3)%></td><td height="18" valign="middle" align="center" bgColor="#ffcc68"><%=rs.getInt(4)%></td><td height="18" valign="middle" align="center"><%=rs.getString(5)%></td><td height="18" valign="middle" align="center"><%=rs.getString(6)%></td><td height="18" valign="middle" align="center"><%=rs.getString(7)%></td><td height="18" valign="middle" align="center"><%=rs.getString(8)%></td><td height="18" valign="middle" align="center"><%=rs.getString(9)%></td><td height="18" valign="middle" align="center"><%=rs.getString(10)%></td><td height="18" valign="middle" align="center"><%=rs.getString(11)%></td><td height="18" valign="middle" align="center"><%=rs.getString(12)%></td><td height="18" valign="middle" align="center"><%=rs.getString(13)%></td></tr><%}} catch (Exception e) {System.out.println(e.getMessage());}%></tbody></table><%try {rs.close();stmt.close();conn.close();} catch (Exception e) {System.out.println(e.getMessage());}%></form></center></body></html>效果图：
这是我们公司（创新工场 Doodle Mobile）出品的经典休闲游戏——3D Bowling，目前已经进入Android Market全球排名前10
- JFreeChart项目实例
- JFreeChart项目实例
- JFreeChart项目实例
- JFreeChart 项目实例
- JFreeChart 实例
- jfreechart实例
- jfreechart实例
- JfreeChart 实例
- JFreeChart实例详解
- JFreeChart实例详解
- JFreeChart使用实例
- jfreechart两简单实例
- JFreeChart 实例(原创)
- JFreeChart 报表实例
- JFreeChart图形报表实例
- Struts2 JFreeChart 实例整合
- jfreechart 柱状图 开发实例
- JFreeChart 图表 实例
- 让C++也支持RMI
- android Animation 动画效果介绍
- reuqest获取file须知
- Oracle CHAR,VARCHAR,VARCHAR2类型的区别与使用
- 详细解析Java中抽象类和接口的区别
- JFreeChart项目实例
- android Animation 动画效果介绍 续
- 工作学习笔记——CSAPP第三章
- 分享2011年50个最棒的wordpress主题
- select 效率问题
- J-LINK烧写不进uboot时的问题
- GBin1随机分享的10个使用简单的插件
- 线段树几题 --------- 成段更新
- 成功路上的关键5步
