全国疫情统计可视化地图 01

 第一阶段目标:
导入全国疫情数据库payiqing.sql(MySQL数据库)。
可以按照时期查询各个省市的疫情统计表格。
以折线图或柱状图展示某天的全国各省的确诊人数。  

<%@ page language="java" contentType="text/html; charset=UTF-8"

    pageEncoding="UTF-8"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

<title>全国疫情统计可视化地图</title>

<script type="text/javascript" src="${pageContext.request.contextPath}/static/js/jquery-1.12.1.js"></script>

<script type="text/javascript" src="${pageContext.request.contextPath}/static/bootstrap-3.3.5-dist/js/bootstrap.js"></script>

<link rel="stylesheet" href="${pageContext.request.contextPath}/static/bootstrap-3.3.5-dist/css/bootstrap.css" />

</head>

<frameset frameborder="no" rows="82px, *">

    <frame src="head.jsp">

    <frameset  cols="285px, *">

        <frame src="left.jsp">

        <frame  name="mainAction">

    </frameset>

</frameset>

</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"

    pageEncoding="UTF-8"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

<title>Insert title here</title>

 

<style type="text/css">

body {

    margin: 0;

    padding: 0;

    font-size: 12px;

    font-family: "Microsoft Yahei", Verdana, Arial, Helvetica, sans-serif

}

.leftMenu {

    min-width:220px;

    width:268px;

    margin:40px auto 0 auto;

}

.menu {

    border: #bdd7f2 1px solid;

    border-top: #0080c4 4px solid;

    border-bottom: #0080c4 4px solid;

    background: #f4f9ff repeat-y right;

    margin-left: 10px;

}

.menu .ListTitle {

 

    border-bottom: 1px #98c9ee solid;

    display: block;

    text-align: center;

    /*position: relative;*/

    height: 38px;

    line-height: 38px;

    cursor: pointer;

    /*+min-width:220px;*/

 

    +width:100%;

}

.ListTitlePanel {

    position: relative;

}

.leftbgbt {

    position: absolute;

    background: no-repeat;

    width: 11px;

    height: 52px;

    left: -11px;

    top: -4px;

}

/*.leftbgbt {

    float:left;

    background: no-repeat;

    width: 11px;

    height: 52px;

    left: 0px;

    top: 0px;

    zoom:1;

    z-index:200px;

}

*/

.leftbgbt2 {

    position: absolute;

    background: no-repeat;

    width: 11px;

    height: 48px;

    left: -11px;

    top: -1px;

}

.menuList {

    display: block;

    height: auto;

}

.menuList div {

    height: 28px;

    line-height: 24px;

    border-bottom: 1px #98c9ee dotted;

}

.menuList div a {

    display: block;

    background: #fff;

    line-height: 28px;

    height: 28px;

    

    color: #185697;

    text-decoration: none;

}

.menuList div a:hover {

    color: #f30;

    background: #0080c4;

    color: #fff;

}

</style>

 

<script type="text/javascript" src="${pageContext.request.contextPath }/static/js/jquery-1.12.1.js"></script>

<script type="text/javascript">

$(document).ready(function() {

    var menuParent = $('.menu > .ListTitlePanel > div');//获取menu下的父层的DIV

    var menuList = $('.menuList');

    $('.menu > .menuParent > .ListTitlePanel > .ListTitle').each(function(i) {//获取列表的大标题并遍历

        $(this).click(function(){

            if($(menuList[i]).css('display') == 'none'){

                $(menuList[i]).slideDown(300);

            }

            else{

                $(menuList[i]).slideUp(300);

            }

        });

    });

});

</script>

 

</head>

<body style="margin-top: -30px;">

 

<div class="leftMenu">

    <div class="menu">

        <div class="menuParent">

            <div class="ListTitlePanel">

                <div class="ListTitle">

                    <strong>资料查询</strong>

                    <div class="leftbgbt2"> </div>

                </div>

            </div>

            <div class="menuList" style="text-align:center">

                <div> <a target="mainAction"  href="${pageContext.request.contextPath}/listall.jsp">疫情查询</a></div>

                <div> <a target="mainAction" href="${pageContext.request.contextPath}/keshihuaceshi.jsp">全国疫情柱状图统计</a></div>

 

            </div>

        </div>

        

        </div>

</div>

 

</body>

</html>

 


<%@ page language="java" contentType="text/html; charset=utf-8"

    pageEncoding="utf-8"%>

<script>

console.log($('#bt1').val())

console.log($('#bt2').val());

</script>

 

 

<!DOCTYPE html>

<html>

<head>

    <meta charset="utf-8">

    <title>ECharts</title>

    <!-- 引入 echarts.js -->

    <script src="echarts.min.js"></script>

</head>

<body>

<div>

      

        <form action="courseServlet?method=select" method="post" onsubmit="return check()">

            <div >

                查询时间<input type="data" id="data" name="data"/>    <td>      <button type="submit" class="b"> </button>

</td>            </div>

            

        </form>

    </div>

    <script type="text/javascript">

        function check() {

            var data = document.getElementById("data");;

          

            

            //非空

            if(data.value == '') {

                alert('请填写时间');

                return false;

            }

        }

    </script>

<div>

      

        <table class="tb">

            <tr>

                <td>时间</td>

                <td>省份</td>

                <td>确诊患者</td>

                <td>治愈</td>

                <td>死亡</td>

                <td>编码</td>

            </tr>

            <!-- forEach遍历出adminBeans -->

             <c:forEach items="${info}" var="item">

                <tr>

                    <td>${item.data}</td>

                    <td>${item.province}</td>

                    <td>${item.con_num}</td>

                    <td>${item.cure_num}</td>

                    <td>${item.dead_num}</td>

                    <td>${item.code}</td>

                </tr>

            </c:forEach>

            <tr>

                <td>2020-02-08 02:28:59</td>

                <td>湖北省</td>

                <td>24953</td>

                <td>1123</td>

                <td>699</td>

                <td>420000</td>

            </tr>

            <tr>

                <td>2020-02-08 02:28:59</td>

                <td>广东省</td>

                <td>1075</td>

                <td>105</td>

                <td>1</td>

                <td>440000</td>

            </tr>

            <tr>

                <td>2020-02-08 02:28:59</td>

                <td>浙江省</td>

                <td>1048</td>

                <td>136</td>

                <td>0</td>

                <td>330000</td>

            </tr>

            <tr>

                <td>2020-02-08 02:28:59</td>

                <td>河南省</td>

                <td>981</td>

                <td>99</td>

                <td>4</td>

                <td>410000</td>

            </tr>

            <tr>

                <td>2020-02-08 02:28:59</td>

                <td>安徽省</td>

                <td>733</td>

                <td>57</td>

                <td>0</td>

                <td>340000</td>

            </tr>

            <tr>

                <td>2020-02-08 02:28:59</td>

                <td>江西省</td>

                <td>698</td>

                <td>55</td>

                <td>0</td>

                <td>360000</td>

            </tr>

            <tr>

                <td>2020-02-08 02:28:59</td>

                <td>江苏省</td>

                <td>439</td>

                <td>43</td>

                <td>0</td>

                <td>320000</td>

            </tr>

            <tr>

                <td>2020-02-08 02:28:59</td>

                <td>重庆市</td>

                <td>426</td>

                <td>31</td>

                <td>2</td>

                <td>500000</td>

            </tr>

            <tr>

                <td>2020-02-08 02:28:59</td>

                <td>山东省</td>

                <td>407</td>

                <td>40</td>

                <td>0</td>

                <td>370000</td>

            </tr>

            <tr>

                <td>2020-02-08 02:28:59</td>

                <td>四川省</td>

                <td>363</td>

                <td>52</td>

                <td>1</td>

                <td>510000</td>

            </tr>

            <tr>

                <td>2020-02-08 02:28:59</td>

                <td>北京市</td>

                <td>315</td>

                <td>34</td>

                <td>2</td>

                <td>110000</td>

            </tr>

            <tr>

                <td>2020-02-08 02:28:59</td>

                <td>黑龙江省</td>

                <td>295</td>

                <td>13</td>

                <td>5</td>

                <td>230000</td>

            </tr>

            <tr>

                <td>2020-02-08 02:28:59</td>

                <td>上海市</td>

                <td>286</td>

                <td>41</td>

                <td>1</td>

                <td>310000</td>

            </tr>

            <tr>

                <td>2020-02-08 02:28:59</td>

                <td>河北省</td>

                <td>195</td>

                <td>28</td>

                <td>1</td>

                <td>130000</td>

            </tr>

            <tr>

                <td>2020-02-08 02:28:59</td>

                <td>陕西省</td>

                <td>195</td>

                <td>19</td>

                <td>0</td>

                <td>610000</td>

            </tr>

            <tr>

                <td>2020-02-08 02:28:59</td>

                <td>广东省</td>

                <td>1075</td>

                <td>105</td>

                <td>1</td>

                <td>440000</td>

            </tr>

            <tr>

                <td>2020-02-08 02:28:59</td>

                <td>广西壮族自治区</td>

                <td>183</td>

                <td>17</td>

                <td>0</td>

                <td>450000</td>

            </tr>

            <tr>

                <td>2020-02-08 02:28:59</td>

                <td>云南省</td>

                <td>138</td>

                <td>12</td>

                <td>0</td>

                <td>530000</td>

            </tr>

            <tr>

                <td>2020-02-08 02:28:59</td>

                <td>海南省</td>

                <td>124</td>

                <td>11</td>

                <td>2</td>

                <td>460000</td>

            </tr>

            <tr>

                <td>2020-02-08 02:28:59</td>

                <td>山西省</td>

                <td>104</td>

                <td>15</td>

                <td>0</td>

                <td>140000</td>

            </tr>

            <tr>

                <td>2020-02-08 02:28:59</td>

                <td>广东省</td>

                <td>1075</td>

                <td>105</td>

                <td>1</td>

                <td>440000</td>

            </tr>

            <tr>

                <td>2020-02-08 02:28:59</td>

                <td>辽宁省</td>

                <td>99</td>

                <td>7</td>

                <td>0</td>

                <td>210000</td>

            </tr>

            <tr>

                <td>2020-02-08 02:28:59</td>

                <td>广东省</td>

                <td>1075</td>

                <td>105</td>

                <td>1</td>

                <td>440000</td>

            </tr>

            <tr>

                <td>2020-02-08 02:28:59</td>

                <td>贵州省</td>

                <td>89</td>

                <td>6</td>

                <td>1</td>

                <td>520000</td>

            </tr>

            <tr>

                <td>2020-02-08 02:28:59</td>

                <td>天津市</td>

                <td>1075</td>

                <td>105</td>

                <td>1</td>

                <td>440000</td>

            </tr>

            <tr>

                <td>2020-02-08 02:28:59</td>

                <td>天津市</td>

                <td>88</td>

                <td>2</td>

                <td>1</td>

                <td>120000</td>

            </tr>

            <tr>

                <td>2020-02-08 02:28:59</td>

                <td>甘肃省</td>

                <td>71</td>

                <td>9</td>

                <td>1</td>

                <td>620000</td>

            </tr>

            <tr>

                <td>2020-02-08 02:28:59</td>

                <td>吉林省</td>

                <td>69</td>

                <td>4</td>

                <td>1</td>

                <td>220000</td>

            </tr>

            <tr>

                <td>2020-02-08 02:28:59</td>

                <td>内蒙古自治区</td>

                <td>52</td>

                <td>5</td>

                <td>0</td>

                <td>150000</td>

            </tr>

            <tr>

                <td>2020-02-08 02:28:59</td>

                <td>宁夏回族自治区</td>

                <td>45</td>

                <td>5</td>

                <td>0</td>

                <td>640000</td>

            </tr>

            <tr>

                <td>2020-02-08 02:28:59</td>

                <td>新疆维吾尔自治区</td>

                <td>42</td>

                <td>0</td>

                <td>0</td>

                <td>650000</td>

            </tr>

             <tr>

                <td>2020-02-08 02:28:59</td>

                <td>香港</td>

                <td>26</td>

                <td>0</td>

                <td>1</td>

                <td>810000</td>

            </tr>

            <tr>

                <td>2020-02-08 02:28:59</td>

                <td>青海省</td>

                <td>18</td>

                <td>3</td>

                <td>0</td>

                <td>630000</td>

            </tr>

            

            <tr>

                <td>2020-02-08 02:28:59</td>

                <td>台湾</td>

                <td>17</td>

                <td>1</td>

                <td>1</td>

                <td>710000</td>

            </tr>

        </table>

    </div>

    <!-- ECharts准备一个具备大小(宽高)的Dom -->

    <div id="main" style="width: 600px;height:400px;"></div>

    <script type="text/javascript">

        // 基于准备好的dom,初始化echarts实例

        var myChart = echarts.init(document.getElementById('main'));

 

        // 指定图表的配置项和数据

        var option = {

            title: {

                text: '本日各省确诊病例数量分析'

            },

            tooltip: {},

            legend: {

                data:['人数']

            },

            xAxis: {

                data: ["湖北省","广东省","浙江省","河南省"

                    ,"安徽省"

                    ,"江西省"

                    ,"江苏省"

                    ,"重庆市"

                    ,"山东省"

                    ,"四川省"

                    ,"北京市"

                    ,"黑龙江省"

                    ,"上海市"

                    ,"河北省"

                    ,"陕西省"

                    ,"广西壮族自治区"

                    ,"云南省"

                    ,"海南省"

                    ,"山西省"

                    ,"辽宁省"

                    ,"贵州省"

                    ,"天津市"

                    ,"甘肃省"

                    ,"吉林省"

                    ,"内蒙古自治区"

                    ,"宁夏回族自治区"

                    ,"新疆维吾尔自治区"

                    ,"香港"

                    ,"青海省"

                    ,"台湾"]

            },

            yAxis: {},

            series: [{

                name: '人数',

                type: 'bar',

                data: [24953,

                    1075,

                    1048,

                    981,

                    733,

                    698,

                    439,

                    426,

                    407,

                    363,

                    315,

                    295,

                    286,

                    195,

                    195,

                    183,

                    138,

                    124,

                    104,

                    99,

                    89,

                    88,

                    71,

                    69,

                    52,

                    45,

                    42,

                    26,

                    18,

                    17]

            }]

        };

 

        // 使用刚指定的配置项和数据显示图表。

        myChart.setOption(option);

    </script>

</body>

</html>

 

</html>

<%@ 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>

</head>

<body>

<%

        Object message = request.getAttribute("message");

        if (message != null && !"".equals(message)) {

    %>

    <script type="text/javascript">

               alert("<%=request.getAttribute("message")%>");

    </script>

    <%

        }

    %>

    <div align="center">

        <h1>各省市疫情统计表</h1>

        <br>

        日期范围<input type="date" id="btime" name="btime">-<input type="date" id="etime" name="etime">

        <button type="button" class="btn btn-info" onclick="checkfind()">查询</button>    

        <br><br>

        <table>

          <thead>

            <tr>

                <th>编号</th>

              <th>日期</th>

              <th>省名</th>

              <th>市名</th>

              <th>确诊人数</th>

              <th>治愈人数</th>

              <th>死亡人数</th>

            </tr>

          </thead>

          <tbody>

          <c:forEach items="${pres}" var="item">

            <tr class="active">

            <td>${item.id}</td>

              <td>${item.date}</td>

              <td>${item.name}</td>

              <td>${item.city}</td>

              <td>${item.confirmed}</td>

              <td>${item.cured}</td>

              <td>${item.dead}</td>

           </tr>

          </c:forEach>

          </tbody>

        </table>

    </div>

<script type="text/javascript">

 

function checkfind()

{

    var btime=document.getElementById("btime").value;

    var etime=document.getElementById("etime").value;

    if(btime==""||etime==""||(btime==""&&etime==""))

    {

        alert("请填写时间");

        return ;

    }

    else

    {

        window.location.href = "checkfind?btime="+btime+"&etime="+etime;

    }

}

 

</script>

</body>

</html>

 

<%@page import="entity.Cvf"%>

<%@page import="java.util.List"%>

<%@ page language="java" contentType="text/html; charset=UTF-8"

    pageEncoding="UTF-8"%>

<!DOCTYPE html>

<html>

<head>

<meta charset="UTF-8">

<title>链接地址</title>

</head>

<body>

<%         request.setCharacterEncoding("utf-8");

List <Cvf> cvfs =(List<Cvf>) request.getAttribute("cvfs");

%>

 

      <table >

      <thead >

         <tr>

         <th>标题</th>

         <th>关键词</th>

         </tr>

  </thead>

  <tbody class="htbody">

         <%

 

         if(cvfs!=null){

           for(Cvf cvf:cvfs){

            %>            

            <tr>                

                <td><a href="<%=cvf.getChref() %>"><%=cvf.getCname() %></a></td>

                <td><%=cvf.getCkeyword() %></td>

            </tr>

            <%

           }

         }

         %>

         </tbody>

      </table> 

</div>

</body>

</html>

 


<%@page import="java.util.Iterator"%>

<%@page import="java.util.HashMap"%>

<%@page import="entity.Cvf"%>

<%@page import="java.util.List"%>

<%@ page language="java" contentType="text/html; charset=UTF-8"

    pageEncoding="UTF-8"%>

<!DOCTYPE html>

<html>

<head>

<meta charset="UTF-8">

<title>CVPR词云</title>

    <script type="text/javascript" src="Echart/echarts.js"></script>

    <script type="text/javascript" src="Echart/echarts-wordcloud.min.js"></script>

 

</head>

<body>

<%         request.setCharacterEncoding("utf-8");

List <Cvf> cvfs =(List<Cvf>) request.getAttribute("cvfs");

int i=0;

int j=0;

int k=0;

HashMap<String, Integer> hm=new HashMap();

if(cvfs!=null){

for(Cvf cvf:cvfs){i++;

if (!hm.containsKey(cvf.getCkeyword())) {

hm.put(cvf.getCkeyword(), 1);

}else {

Integer counts=hm.get(cvf.getCkeyword());

hm.put(cvf.getCkeyword(), counts+1);

}

 

}

}

%>

<div id="main" style="width: 800px; height: 600px"></div>

    <script>

            var myChart = echarts.init(document.getElementById('main'));

            option = {

                    title: {

                        text: '词云',//标题

                        x: 'center',

                        textStyle: {

                            fontSize: 23

                        }

 

                    },

                    backgroundColor: '#F7F7F7',

                    tooltip: {

                        show: true

                    },

                    series: [{

                        name: '热点分析',//数据提示窗标题

                        type: 'wordCloud',

                        sizeRange: [6, 66],//画布范围,如果设置太大会出现少词(溢出屏幕)

                        rotationRange: [-45, 90],//数据翻转范围

                        //shape: 'circle',

                        textPadding: 0,

                        autoSize: {

                            enable: true,

                            minSize: 6

                        },

                        drawOutOfBound: true,//词云显示完整,超出画布的也显示

                        textStyle: {

                            normal: {

                                color: function() {

                                    return 'rgb(' + [

                                        Math.round(Math.random() * 160),

                                        Math.round(Math.random() * 160),

                                        Math.round(Math.random() * 160)

                                    ].join(',') + ')';

                                }

                            },

                            emphasis: {

                                shadowBlur: 10,

                                shadowColor: '#333'

                            }

                        },

                        data:[

                         <%

              //获取request域中的数据

               Iterator<String> it=hm.keySet().iterator();

               while(it.hasNext()) {

               String keyName=it.next();

 

              %>

              {name:"<%=keyName%>",value:<%=hm.get(keyName) %>},

              <%

             

              }

              %>

                        ]

                    }]

                  };

 

        myChart.setOption(option,true);

        myChart.on('click',function(param){

         var selected = param.name;

         if(selected){      

         window.open("ListServlet?keyword="+selected);

         }

 

         });

    </script>

</body>

</html>

 

 

posted @ 2020-03-05 14:23  qazvve  阅读(501)  评论(0编辑  收藏  举报