用了两天的时间才把这个简陋的世界疫情图做出来，是真的不容易，数据是通过python爬取的，再通过web数据库链接呈现再界面上：
在可视化地图里面有一个稍微有点难度的就是获取数据，可以通过$.ajax({});方法获取数据，再讲数据再jsp中转换为js格式即可，我把一些基本的代码发表一下。
servlet层：
package Servlet; import java.io.IOException; 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 Bean.shengfen; import Dao.Dao; /** * Servlet implementation class AjaxServlet */ @WebServlet("/AjaxServlet") public class AjaxServlet extends HttpServlet { private static final long serialVersionUID = 1L; /** * @see HttpServlet#HttpServlet() */ public AjaxServlet() { super(); // TODO Auto-generated constructor stub } /** * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { System.out.println("..1"); request.setCharacterEncoding("UTF-8"); Dao dao = new Dao(); java.util.List<shengfen> list = dao.Ajax(); System.out.println(list.get(0).province); Gson gson = new Gson(); String json = gson.toJson(list); response.setHeader("Content-Type","text/html;charset=UTF-8"); response.getWriter().write(json); } 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 javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import Dao.Dao; /** * Servlet implementation class AllconfirmedServlet */ @WebServlet("/AllconfirmedServlet") public class AllconfirmedServlet extends HttpServlet { private static final long serialVersionUID = 1L; /** * @see HttpServlet#HttpServlet() */ public AllconfirmedServlet() { super(); // TODO Auto-generated constructor stub } /** * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { Dao dao = new Dao(); int allpeo = dao.addpeo(); System.out.println(allpeo); request.getSession().setAttribute("allpeo", allpeo); request.getRequestDispatcher("View.jsp").forward(request, 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.io.UnsupportedEncodingException; 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 Bean.shengfen; import Dao.Dao; /** * Servlet implementation class selectServlet */ @WebServlet("/selectServlet") public class selectServlet extends HttpServlet { private static final long serialVersionUID = 1L; /** * @see HttpServlet#HttpServlet() */ public selectServlet() { super(); // TODO Auto-generated constructor stub } /** * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { select(request,response); } private void select(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { Dao dao = new Dao(); java.util.List<shengfen> list = dao.selecttime(); System.out.println(list); if(list != null) { request.setAttribute("list", list); request.getRequestDispatcher("View.jsp").forward(request, response); }else { request.setAttribute("message", "数据获取失败！"); request.getRequestDispatcher("View.jsp").forward(request, 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 javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import Bean.shengfen; import Dao.Dao; /** * Servlet implementation class timeServlet */ @WebServlet("/timeServlet") public class timeServlet extends HttpServlet { private static final long serialVersionUID = 1L; /** * @see HttpServlet#HttpServlet() */ public timeServlet() { super(); // TODO Auto-generated constructor stub } /** * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { Dao dao = new Dao(); String time = dao.list(); request.getSession().setAttribute("time", time); request.getRequestDispatcher("View.jsp").forward(request, response); } protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub doGet(request, response); } }
Dao层：
package Dao; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.List; import Bean.shengfen; import DBUtil.DBUtil; public class Dao { static int id = 1; public List<shengfen> selecttime() { String sql="select * from world_map_copy1 "; System.out.println(sql); Connection conn = DBUtil.getConn(); Statement stat = null; List<shengfen> list = new ArrayList<>(); ResultSet rs = null; shengfen sf =null; try { stat = conn.createStatement(); rs = stat.executeQuery(sql); while(rs.next()) { String Province = rs.getString("provinceName"); int Confirmed_num = rs.getInt("confirmedCount"); int Cured_num = rs.getInt("curedCount"); int Dead_num = rs.getInt("deadCount"); String time = rs.getString("time"); sf = new shengfen(Province,id,Confirmed_num,Cured_num,Dead_num,time); id++; list.add(sf); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } id = 1; return list; } public List<shengfen> Ajax() { String sql="select * from world_map_copy1"; System.out.println(sql); Connection conn = DBUtil.getConn(); Statement stat = null; List<shengfen> list = new ArrayList<>(); ResultSet rs = null; shengfen sf =null; try { stat = conn.createStatement(); rs = stat.executeQuery(sql); while(rs.next()) { String Province = rs.getString("provinceName"); int Confirmed_num = rs.getInt("confirmedCount"); int Cured_num = rs.getInt("curedCount"); int Dead_num = rs.getInt("deadCount"); sf = new shengfen(Province,id,Confirmed_num,Cured_num,Dead_num,null); id++; list.add(sf); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } id = 1; return list; } public int addpeo() { String sql="select sum(currentConfirmedCount) from world_map_copy1 "; System.out.println(sql); Connection conn = DBUtil.getConn(); Statement stat = null; ResultSet rs = null; int i = 0; try { stat = conn.createStatement(); rs = stat.executeQuery(sql); while(rs.next()) { i = rs.getInt("sum(currentConfirmedCount)"); } System.out.println(i); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return i; } public String list() { String sql="select * from world_map_copy1"; Connection conn = DBUtil.getConn(); Statement stat = null; ResultSet rs = null; String time = null; try { stat = conn.createStatement(); rs = stat.executeQuery(sql); while(rs.next()) { time = rs.getString("time"); } System.out.println(time); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return time; } }
Bean层：
package Bean; public class shengfen { public String province; public int id; public int confirmed_num; public int cured_num; public int dead_num; public String time; public String getTime() { return time; } public void setTime(String time) { this.time = time; } public int getDead_num() { return dead_num; } public void setDead_num(int dead_num) { dead_num = dead_num; } public String getProvince() { return province; } public void setProvince(String province) { this.province = province; } public int getId() { return id; } public void setId(int id) { this.id = id; } public int getConfirmed_num() { return confirmed_num; } public void setConfirmed_num(int confirmed_num) { this.confirmed_num = confirmed_num; } public int getCured_num() { return cured_num; } public void setCured_num(int cured_num) { this.cured_num = cured_num; } public shengfen(String province, int id, int confirmed_num, int cured_num, int dead_num, String time) { super(); this.province = province; this.id = id; this.confirmed_num = confirmed_num; this.cured_num = cured_num; this.dead_num = dead_num; this.time = time; } }
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"> <!--声明文档兼容模式，表示使用IE浏览器的最新模式--> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <!--设置视口的宽度(值为设备的理想宽度)，页面初始缩放值<理想宽度/可见宽度>--> <meta name="viewport" content="width=device-width, initial-scale=1"> <!-- 上述3个meta标签*必须*放在最前面，任何其他内容都*必须*跟随其后！ --> <title>世界疫情查询</title> <!-- 引入Bootstrap核心样式文件 --> <link href="css/bootstrap.min.css" rel="stylesheet"> <!-- 引入jQuery核心js文件 --> <script src="js/jquery-1.11.3.min.js"></script> <!-- 引入BootStrap核心js文件 --> <script src="js/bootstrap.min.js"></script> <title>Insert title here</title> <!-- 引入 echarts.js --> <script src="https://cdn.staticfile.org/echarts/4.3.0/echarts.min.js"></script> <style type="text/css"> .father{ float: left; margin: 5px; margin-left: 5px; } .table{ float: left; margin:2px; margin-left: 1px; overflow:scroll; } .echart{ float: left; margin:1px; } #one{ margin:2px; margin-left: 1px; } .listtable{ overflow:scroll; } </style> <title>疫情图</title> </head> <body style="background-color: #000000"> <div id="father1" class="father" style=" 250px;height:700px;background-color: #4B4B4B;"> <div id="one" class="all" style=" 245px;height:90px;background-color: #4B4B4Bborder: 1px solid red;"> <label for="userid" style="font-size: 28px;color: red;" >总确诊人数：<%=session.getAttribute("allpeo")%></label> </div> <div id="one" class="listtable" style=" 245px;height:500px;background-color: #4B4B4B;"> <table class="table" > <c:forEach items="${list}" var="item" > <tr> <td><label for="userid" style="font-size: 18px;color: red;" >${item.province} ${item.confirmed_num}</label></td> </tr> </c:forEach> </table> </div> <div id="one" class="time" style=" 245px;height:90px;background-color: #4B4B4B;"> <label for="userid" style="font-size: 28px;color: red;" ><%=session.getAttribute("time")%></label> </div> </div> <div id="father2" class="father" style="720px;height:700px;background-color: #4B4B4B"> <script src="js/echarts.js"></script> <script src="js/world(1).js"></script> <script type="text/javascript"> var mess; $(function(){ $.ajax({ url : "AjaxServlet", async : false, type : "POST", success : function(data) { mess = data; }, error : function() { alert("请求失败"); }, dataType : "json" }); var myChart = echarts.init(document.getElementById('father2')); var mydata = new Array(0); for(var i = 0;i<mess.length;i++){ var d = {}; d["name"] = mess[i].province; d["value"] = mess[i].confirmed_num; d["heal"] = mess[i].cured_num; d["dead"] = mess[i].dead_num; mydata.push(d); } option = { title: { sublink: 'http://esa.un.org/wpp/Excel-Data/population.htm', left: 'center', top: 'top' }, tooltip: { formatter : function(params) { return params.name + '<br/>' + '确诊人数 : ' + params.value + '<br/>' + '死亡人数 : ' + params['data'].dead + '<br/>' + '治愈人数 : ' + params['data'].heal ; }//数据格式化 }, visualMap : { min : 0, max : 500, inRange : { color : ['#CC6633', '#ffaa85', '#bc1a19','#990000' ] //取值范围的颜色 }, pieces:[ {gt:5000}, {gt:1000,lte:4999}, {gte:500,lte:999}, {gte:1,lte:499}, {value:0,label:'0',color:'#ffffff'}, ], show : true //图注 }, series: [ { name: '世界疫情', 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": "锡亚琴冰川地区" } } ] }; myChart.setOption(option); }); </script> </div> <div id="father3" class="father" style=" 480px;height:700px;background-color: #4B4B4B;"> <div class="table" style="235px;height:500px;background-color: #4B4B4B;"> <table class="table" style="color: #4B4B4B";> <tr> <label for="userid" style="font-size: 18px;color: red;" >死亡人数</label> </tr> <c:forEach items="${list}" var="item" > <tr> <td><label for="userid" style="font-size: 18px;color: red;" >${item.province} ${item.dead_num}</label></td> </tr> </c:forEach> </table> </div> <div class="table" style="235px;height:500px;background-color: #4B4B4B;"> <table class="table" > <label for="userid" style="font-size: 18px;color: red;" >治愈人数</label> <c:forEach items="${list}" var="item" > <tr> <td><label for="userid" style="font-size: 18px;color: red;" >${item.province} ${item.cured_num}</label></td> </tr> </c:forEach> </table> </div> <div id="main" class="echart" style="470px;height:190px;background-color: #4B4B4B;"> <script type="text/javascript"> // 基于准备好的dom，初始化echarts实例 var myChart = echarts.init(document.getElementById('main')); var arr = new Array(); var index = 0; <c:forEach items="${list}" var="item"> arr[index++] = ${item.confirmed_num}; </c:forEach> // 指定图表的配置项和数据 var option = { title: { text: '疫情统计' }, tooltip: { show: true }, legend: { data:['患者数'] }, xAxis : [ { type : 'category', axisLabel:{ interval:0,//横轴信息全部显示 rotate:40,//-30度角倾斜显示 }, data : [ <c:forEach items="${list}" var="item"> ["${item.province}"], </c:forEach> ] } ], yAxis : [ { type : 'value' } ], series : [ { name:'患者数', type:'bar', data: arr } ] }; // 使用刚指定的配置项和数据显示图表。 myChart.setOption(option); </script> </div> </div> </body> </html>
数据呈现的有点乱，还需要继续努力，缩小与别人之间的差距。