世界疫情可视化展示-----echarts
开头：我们有的是热情、激情、无限的动力，清明三天放假休息，为了纪念牺牲的烈士，我们集体决定仿照约翰·霍普金斯大学制作全球疫情发布图（WEB版），可以实时访问。行动起来吧。随时抽查，今天工作八小时。这是今天早上王老师对我们说的话。然后此时此刻我还在干弄活。但是还是通过晚上时间把他做出来了。
我的实现：
内容：思路就是先把布局搭好，然后分别实现各个功能。这里要用到echarts。基本布局是三部分。由上图可以看出。因为我所有数据库列全用的是varchar，所以用过查询并降序不能实现。读者可以将人数的列用int定义，则可以实现。
代码如下：主页面---- world.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>世界疫情展示</title> <link href="${pageContext.request.contextPath}/css/bootstrap.min.css" rel="stylesheet"> <script src="${pageContext.request.contextPath}/js/jquery-3.3.1.min.js"></script> <script src="${pageContext.request.contextPath}/js/bootstrap.min.js"></script> <script type="text/javascript" src="${pageContext.request.contextPath}/js/echarts.min(1).js"></script> <script src="${pageContext.request.contextPath}/js/world.js"></script> </head> <script type="text/javascript"> <!--世界地图--> $(function(){ <!-- 通过ajax异步获取数据--> $.ajax({ url:"GetAllWorldConfirmedServlet", async:true, type:"POST", data:{}, success:function(data){ var mydata = new Array(0); for(var i=0;i<data.length;i++){ var d = { }; d["name"] = data[i].name;//.substring(0, 2); d["value"] = data[i].confirmed_num-data[i].cured_num; d["yisi_num"] = data[i].yisi_num; d["cured_num"] = data[i].cured_num; d["dead_num"] = data[i].dead_num; mydata.push(d); } option = { title: { sublink: 'http://esa.un.org/wpp/Excel-Data/population.htm', left: 'center', top: 'top' }, tooltip: { trigger: 'item', formatter: function (params) { return params.name + '<br/>' + '确诊人数 : ' + params.value + '<br/>' + '死亡人数 : ' + params['data'].dead_num + '<br/>' + '治愈人数 : ' + params['data'].cured_num + '<br/>' } }, visualMap: { min: 0, max: 1000, text:['High','Low'], realtime: false, calculable: true, color: ['orangered','#f47920','#fedcbd'] }, series: [ { name: 'World Population (2010)', type: 'map', mapType: 'world', roam: true, itemStyle:{ emphasis:{label:{show:true}} }, data: mydata, nameMap:{ "Canada": "加拿大", "Turkmenistan": "土库曼斯坦", "Saint Helena": "圣赫勒拿", "Lao PDR": "老挝", "Lithuania": "立陶宛", "Cambodia": "柬埔寨", "Ethiopia": "埃塞俄比亚", "Faeroe Is.": "法罗群岛", "Swaziland": "斯威士兰", "Palestine": "巴勒斯坦", "Belize": "伯利兹", "Argentina": "阿根廷", "Bolivia": "玻利维亚", "Cameroon": "喀麦隆", "Burkina Faso": "布基纳法索", "Aland": "奥兰群岛", "Bahrain": "巴林", "Saudi Arabia": "沙特阿拉伯", "Fr. Polynesia": "法属波利尼西亚", "Cape Verde": "佛得角", "W. Sahara": "西撒哈拉", "Slovenia": "斯洛文尼亚", "Guatemala": "危地马拉", "Guinea": "几内亚", "Dem. Rep. Congo": "刚果（金）", "Germany": "德国", "Spain": "西班牙", "Liberia": "利比里亚", "Netherlands": "荷兰", "Jamaica": "牙买加", "Solomon Is.": "所罗门群岛", "Oman": "阿曼", "Tanzania": "坦桑尼亚", "Costa Rica": "哥斯达黎加", "Isle of Man": "曼岛", "Gabon": "加蓬", "Niue": "纽埃", "Bahamas": "巴哈马", "New Zealand": "新西兰", "Yemen": "也门", "Jersey": "泽西岛", "Pakistan": "巴基斯坦", "Albania": "阿尔巴尼亚", "Samoa": "萨摩亚", "Czech Rep.": "捷克", "United Arab Emirates": "阿拉伯联合酋长国", "Guam": "关岛", "India": "印度", "Azerbaijan": "阿塞拜疆", "N. Mariana Is.": "北马里亚纳群岛", "Lesotho": "莱索托", "Kenya": "肯尼亚", "Belarus": "白俄罗斯", "Tajikistan": "塔吉克斯坦", "Turkey": "土耳其", "Afghanistan": "阿富汗", "Bangladesh": "孟加拉国", "Mauritania": "毛里塔尼亚", "Dem. Rep. Korea": "朝鲜", "Saint Lucia": "圣卢西亚", "Br. Indian Ocean Ter.": "英属印度洋领地", "Mongolia": "蒙古", "France": "法国", "Cura?ao": "库拉索岛", "S. Sudan": "南苏丹", "Rwanda": "卢旺达", "Slovakia": "斯洛伐克", "Somalia": "索马里", "Peru": "秘鲁", "Vanuatu": "瓦努阿图", "Norway": "挪威", "Malawi": "马拉维", "Benin": "贝宁", "St. Vin. and Gren.": "圣文森特和格林纳丁斯", "Korea": "韩国", "Singapore": "新加坡", "Montenegro": "黑山共和国", "Cayman Is.": "开曼群岛", "Togo": "多哥", "China": "中国", "Heard I. and McDonald Is.": "赫德岛和麦克唐纳群岛", "Armenia": "亚美尼亚", "Falkland Is.": "马尔维纳斯群岛（福克兰）", "Ukraine": "乌克兰", "Ghana": "加纳", "Tonga": "汤加", "Finland": "芬兰", "Libya": "利比亚", "Dominican Rep.": "多米尼加", "Indonesia": "印度尼西亚", "Mauritius": "毛里求斯", "Eq. Guinea": "赤道几内亚", "Sweden": "瑞典", "Vietnam": "越南", "Mali": "马里", "Russia": "俄罗斯", "Bulgaria": "保加利亚", "United States": "美国", "Romania": "罗马尼亚", "Angola": "安哥拉", "Chad": "乍得", "South Africa": "南非", "Fiji": "斐济", "Liechtenstein": "列支敦士登", "Malaysia": "马来西亚", "Austria": "奥地利", "Mozambique": "莫桑比克", "Uganda": "乌干达", "Japan": "日本", "Niger": "尼日尔", "Brazil": "巴西", "Kuwait": "科威特", "Panama": "巴拿马", "Guyana": "圭亚那", "Madagascar": "马达加斯加", "Luxembourg": "卢森堡", "American Samoa": "美属萨摩亚", "Andorra": "安道尔", "Ireland": "爱尔兰", "Italy": "意大利", "Nigeria": "尼日利亚", "Turks and Caicos Is.": "特克斯和凯科斯群岛", "Ecuador": "厄瓜多尔", "U.S. Virgin Is.": "美属维尔京群岛", "Brunei": "文莱", "Australia": "澳大利亚", "Iran": "伊朗", "Algeria": "阿尔及利亚", "El Salvador": "萨尔瓦多", "C?te d'Ivoire": "科特迪瓦", "Chile": "智利", "Puerto Rico": "波多黎各", "Belgium": "比利时", "Thailand": "泰国", "Haiti": "海地", "Iraq": "伊拉克", "S?o Tomé and Principe": "圣多美和普林西比", "Sierra Leone": "塞拉利昂", "Georgia": "格鲁吉亚", "Denmark": "丹麦", "Philippines": "菲律宾", "S. Geo. and S. Sandw. Is.": "南乔治亚岛和南桑威奇群岛", "Moldova": "摩尔多瓦", "Morocco": "摩洛哥", "Namibia": "纳米比亚", "Malta": "马耳他", "Guinea-Bissau": "几内亚比绍", "Kiribati": "基里巴斯", "Switzerland": "瑞士", "Grenada": "格林纳达", "Seychelles": "塞舌尔", "Portugal": "葡萄牙", "Estonia": "爱沙尼亚", "Uruguay": "乌拉圭", "Antigua and Barb.": "安提瓜和巴布达", "Lebanon": "黎巴嫩", "Uzbekistan": "乌兹别克斯坦", "Tunisia": "突尼斯", "Djibouti": "吉布提", "Greenland": "格陵兰", "Timor-Leste": "东帝汶", "Dominica": "多米尼克", "Colombia": "哥伦比亚", "Burundi": "布隆迪", "Bosnia and Herz.": "波斯尼亚和黑塞哥维那", "Cyprus": "塞浦路斯", "Barbados": "巴巴多斯", "Qatar": "卡塔尔", "Palau": "帕劳", "Bhutan": "不丹", "Sudan": "苏丹", "Nepal": "尼泊尔", "Micronesia": "密克罗尼西亚", "Bermuda": "百慕大", "Suriname": "苏里南", "Venezuela": "委内瑞拉", "Israel": "以色列", "St. Pierre and Miquelon": "圣皮埃尔和密克隆群岛", "Central African Rep.": "中非", "Iceland": "冰岛", "Zambia": "赞比亚", "Senegal": "塞内加尔", "Papua New Guinea": "巴布亚新几内亚", "Trinidad and Tobago": "特立尼达和多巴哥", "Zimbabwe": "津巴布韦", "Jordan": "约旦", "Gambia": "冈比亚", "Kazakhstan": "哈萨克斯坦", "Poland": "波兰", "Eritrea": "厄立特里亚", "Kyrgyzstan": "吉尔吉斯斯坦", "Montserrat": "蒙特塞拉特", "New Caledonia": "新喀里多尼亚", "Macedonia": "马其顿", "Paraguay": "巴拉圭", "Latvia": "拉脱维亚", "Hungary": "匈牙利", "Syria": "叙利亚", "Honduras": "洪都拉斯", "Myanmar": "缅甸", "Mexico": "墨西哥", "Egypt": "埃及", "Nicaragua": "尼加拉瓜", "Cuba": "古巴", "Serbia": "塞尔维亚", "Comoros": "科摩罗", "United Kingdom": "英国", "Fr. S. Antarctic Lands": "南极洲", "Congo": "刚果（布）", "Greece": "希腊", "Sri Lanka": "斯里兰卡", "Croatia": "克罗地亚", "Botswana": "博茨瓦纳", "Siachen Glacier": "锡亚琴冰川地区" } } ] }; var myChart = echarts.init(document.getElementById('main')); myChart.setOption(option); }, error:function(){ alert("请求失败"); }, dataType:"json" }); }); </script> <!--折线图 --> <script type="text/javascript"> $(function(){ var dt; $.ajax({ url:"GetAllChinaConfirmedServlet", async:true, type:"POST", data:{}, success:function(data){ var myChart = echarts.init(document.getElementById('worldZXT')); var xd = new Array(0); var yd = new Array(0); for(var i=0;i<data.length;i+=4){ xd.push(data[i].date); yd.push(data[i].confirmed_num); } // 指定图表的配置项和数据 var option = { title: { text: '世界确诊人数' }, tooltip: { show: true, trigger: 'axis' }, legend: { data: ['确诊人数'] }, grid: { left: '3%', right: '4%', bottom: '3%', containLabel: true }, toolbox: { feature: { saveAsImage: {} } }, xAxis: { type: 'category', boundaryGap: false, axisLabel:{ //横坐标上的文字斜着显示 文字颜色 begin interval:0, rotate:45, margin:60, textStyle:{color:"#ec6869" } //横坐标上的文字换行显示 文字颜色end }, data: xd }, yAxis: { type: 'value' }, series: [ { name: '确诊人数', type: 'line', stack: '总量', data: yd, barWidth:20, barGap:'10%' } ] }; // 使用刚指定的配置项和数据显示图表。 myChart.setOption(option); }, error:function(){ alert("请求失败"); }, dataType:"json" }); }); </script> <body> <div style="position:fixed;width:100%;height:100%;"> <div style="width:400px;height:100%;border:1px solid #ccc;float:left"> <div style="width:100%;height:15%;border:1px solid #ccc;float:left;"> <h3 style="color:red">总确诊人数:${countryConfirmedCount}</h3> </div> <div style="width:100%;height:70%;border:1px solid #ccc;float:left;overflow-y:scroll;"> <table> <c:forEach items="${countryList}" var="country"> <tr> <td><h4 style="color:red"> 确诊人数：${country.dead_num}</h4> <h5> ${country.name}</h5> <br></td> </tr> </c:forEach> </table> </div> <div style="width:100%;height:15%;border:1px solid #ccc;float:left;"> 更新时间：<br/><h3 style="color:red">${lastUpdateTime}</h3> </div> </div> <div id="main" style="width:1000px;height:100%;border:1px solid #ccc;float:left" ></div> <div style="width:520px;height:100%;border:1px solid #ccc;float:left"> <div style="width:50%;height:70%;border:1px solid #ccc;float:left;overflow-y:scroll;"> <h3> 总死亡人数:${countryConfirmedCount}</h3> <table> <c:forEach items="${countryList}" var="country"> <tr> <td><h4 style="color:red"> 死亡人数：${country.dead_num}</h4> <h5> ${country.name}</h5> <br></td> </tr> </c:forEach> </table> </div> <div style="width:50%;height:70%;border:1px solid #ccc;float:left;overflow-y:scroll;"> <h3> 总治愈人数:${countryCuredCount}</h3> <table> <c:forEach items="${countryList}" var="country"> <tr> <td><h4 style="color:red"> 治愈人数：${country.dead_num}</h4> <h5> ${country.name}</h5> <br></td> </tr> </c:forEach> </table> </div> <div id="worldZXT" style="width:100%;height:30%;border:1px solid #ccc;float:left"></div> </div> </div> </body> </html>
dao层：访问数据库
package Dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import DBUtil.Util; import bin.Country; import bin.Info; public class Dao { public List<Country> getAllCountry() { Connection con = null; PreparedStatement ps = null; ResultSet rs = null; List<Country> countryList = new ArrayList<>(); try { con = Util.getConnection(); String sql = "select * from yiqing_world order by confirmed_num DESC"; ps = con.prepareStatement(sql); rs = ps.executeQuery(); while(rs.next()) { Country country = new Country(); country.setId(rs.getString(1)); country.setName(rs.getString(2)); country.setConfirmed_num(rs.getString(3)); country.setYisi_num(rs.getString(6)); country.setCured_num(rs.getString(4)); country.setDead_num(rs.getString(5)); country.setDate(rs.getString(7)); countryList.add(country); } return countryList; }catch(Exception e) { throw new RuntimeException(e); }finally { try { rs.close(); } catch (SQLException e) { e.printStackTrace(); } Util.release(con, ps); } } public List<Country> getAllChinaConfirmed() { Connection con = null; PreparedStatement ps = null; ResultSet rs = null; List<Country> countryList = new ArrayList<>(); try { con = Util.getConnection(); String sql = "select * from world_"; ps = con.prepareStatement(sql); rs = ps.executeQuery(); while(rs.next()) { Country country = new Country(); country.setName(rs.getString(1)); country.setConfirmed_num(rs.getString(2)); country.setYisi_num(rs.getString(3)); country.setCured_num(rs.getString(4)); country.setDead_num(rs.getString(5)); country.setDate(rs.getString(7)); countryList.add(country); } return countryList; }catch(Exception e) { throw new RuntimeException(e); }finally { try { rs.close(); } catch (SQLException e) { e.printStackTrace(); } Util.release(con, ps); } } // 查询全世界所有的确诊人数 public int countryConfirmedCount() { Connection con = null; PreparedStatement ps = null; ResultSet rs = null; try { con = Util.getConnection(); String sql = "select sum(confirmed_num) as count from yiqing_world"; ps = con.prepareStatement(sql); rs = ps.executeQuery(); return rs.getInt("count"); }catch(Exception e) { throw new RuntimeException(e); }finally { Util.release(con, ps); } } }
Servlet：
获取世界所有的数据
package Servlet; import java.io.IOException; import java.text.SimpleDateFormat; import java.util.Date; import java.util.List; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import org.apache.catalina.Session; import com.google.gson.Gson; import Dao.Dao; import bin.Country; /** * Servlet implementation class GetAllWorldConfirmedServlet */ @WebServlet("/GetAllWorldConfirmedServlet") public class GetAllWorldConfirmedServlet extends HttpServlet { private static final long serialVersionUID = 1L; Dao dao = new Dao(); /** * @see HttpServlet#HttpServlet() */ public GetAllWorldConfirmedServlet() { super(); // TODO Auto-generated constructor stub } /** * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=UTF-8"); request.setCharacterEncoding("UTF-8"); List<Country> countryList = dao.getAllCountry(); int countryConfirmedCount=0,countryCuredCount=0,countryDeadCount=0; for(int i=0;i<countryList.size();i++) { countryConfirmedCount += Integer.valueOf(countryList.get(i).getConfirmed_num()); countryCuredCount += Integer.valueOf(countryList.get(i).getCured_num()); countryDeadCount += Integer.valueOf(countryList.get(i).getDead_num()); } HttpSession session = request.getSession(); session.setAttribute("countryList",countryList); session.setAttribute("countryConfirmedCount",countryConfirmedCount); session.setAttribute("countryCuredCount",countryCuredCount); session.setAttribute("countryDeadCount",countryDeadCount); session.setAttribute("lastUpdateTime",countryList.get(3).getDate()); Gson gson = new Gson(); String json = gson.toJson(countryList); response.getWriter().write(json); } /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub doGet(request, response); } }
获取中国历史所有的数据：（本来应该是全世界的，但是我爬下来的数据没对全世界的历史数据，只有更新数据）
package Servlet; import java.io.IOException; import java.util.List; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.google.gson.Gson; import Dao.Dao; import bin.Country; /** * Servlet implementation class GetAllChinaConfirmedServlet */ @WebServlet("/GetAllChinaConfirmedServlet") public class GetAllChinaConfirmedServlet extends HttpServlet { private static final long serialVersionUID = 1L; Dao dao = new Dao(); /** * @see HttpServlet#HttpServlet() */ public GetAllChinaConfirmedServlet() { super(); // TODO Auto-generated constructor stub } /** * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=UTF-8"); request.setCharacterEncoding("UTF-8"); List<Country> ChinaList = dao.getAllChinaConfirmed(); Gson gson = new Gson(); String json = gson.toJson(ChinaList); response.getWriter().write(json); } /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub doGet(request, response); } }
连接数据的就不发了。
结尾：做的过程没有遇到太多的问题。遇到的问题自己最后都解决了。之前做echarts的测试感觉很难毫无头绪，耗费时间长。现在还是比较上手。人都是会进步，只有学了就有效果。如果读者知道哪个网址有世界历史数据，可以给我留言一下谢谢。任何对于代码有问题的、不懂得，留言。大佬还需要多给我提意见。
