06-移动端疫情展示

代码实现

Web端（包含前两阶段代码）

 

　　　Info.java:

 

package Bean;

public class Info {

    private int id;

    private String city;

    private String yisi_num;

    private String date;

    private String province;

    private String confirmed_num;

    private String cured_num;

    private String dead_num;

    private String newconfirmed_num;

    public String getNewconfirmed_num() {

        return newconfirmed_num;

    }

    public void setNewconfirmed_num(String newconfirmed_num) {

        this.newconfirmed_num = newconfirmed_num;

    }

    public int getId() {

        return id;

    }

    public void setId(int id) {

        this.id = id;

    }

    public String getCity() {

        return city;

    }

    public void setCity(String city) {

        this.city = city;

    }

    public String getYisi_num() {

        return yisi_num;

    }

    public void setYisi_num(String yisi_num) {

        this.yisi_num = yisi_num;

    }

    public String getDate() {

        return date;

    }

    public void setDate(String date) {

        this.date = date;

    }

    public String getProvince() {

        return province;

    }

    public void setProvince(String province) {

        this.province = province;

    }

    public String getConfirmed_num() {

        return confirmed_num;

    }

    public void setConfirmed_num(String confirmed_num) {

        this.confirmed_num = confirmed_num;

    }

    public String getCured_num() {

        return cured_num;

    }

    public void setCured_num(String cured_num) {

        this.cured_num = cured_num;

    }

    public String getDead_num() {

        return dead_num;

    }

    public void setDead_num(String dead_num) {

        this.dead_num = dead_num;

    }

 

   

}

 

 

　　　Paqu.java（如同它的名字，用来爬取数据的）

 

package control;import java.io.IOException;import java.text.SimpleDateFormat;import java.util.Date;import org.jsoup.Jsoup;import org.jsoup.nodes.Document;import org.jsoup.nodes.Element;import org.jsoup.select.Elements;

import com.gargoylesoftware.htmlunit.BrowserVersion;import com.gargoylesoftware.htmlunit.WebClient;import com.gargoylesoftware.htmlunit.html.HtmlPage;import Dao.AddService;

 

 public class Paqu {

   

    public static void main(String args[]) {

        refesh();

    }

 

    public static void refesh() {

        // TODO Auto-generated method stub

        String sheng="";

        String xinzeng="";

        String leiji="";

        String zhiyu="";

        String siwang="";

        String country="";

        char kind;

         String url = "https://wp.m.163.com/163/page/news/virus_report/index.html?_nw_=1&_anw_=1";

       

        int i=0;

       

        try {

            //构造一个webClient 模拟Chrome 浏览器

            WebClient webClient = new WebClient(BrowserVersion.CHROME);

            //支持JavaScript

            webClient.getOptions().setJavaScriptEnabled(true);

            webClient.getOptions().setCssEnabled(false);

            webClient.getOptions().setActiveXNative(false);

            webClient.getOptions().setCssEnabled(false);

            webClient.getOptions().setThrowExceptionOnScriptError(false);

            webClient.getOptions().setThrowExceptionOnFailingStatusCode(false);

            webClient.getOptions().setTimeout(8000);

            HtmlPage rootPage = webClient.getPage(url);

            //设置一个运行JavaScript的时间

            webClient.waitForBackgroundJavaScript(6000);

            String html = rootPage.asXml();

            Document doc = Jsoup.parse(html);

            //System.out.println(doc);

　　　　　　　　//爬取国内各省数据

            Element listdiv1 = doc.select(".wrap").first();

            Elements listdiv2 = listdiv1.select(".province");

            for(Element s:listdiv2) {

                Elements span = s.getElementsByTag("span");

                Elements real_name=span.select(".item_name");

                Elements real_newconfirm=span.select(".item_newconfirm");

                Elements real_confirm=span.select(".item_confirm");

                Elements real_dead=span.select(".item_dead");

                Elements real_heal=span.select(".item_heal");               

                sheng=real_name.text();

                xinzeng=real_newconfirm.text();

                leiji=real_confirm.text();

                zhiyu=real_heal.text();

                siwang=real_dead.text();

                System.out.println(sheng+" 新增确诊:"+xinzeng+" 累计确诊:"+leiji+" 累计治愈:"+zhiyu+" 累计死亡:"+siwang);

                Date currentTime=new Date();

                SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm");

                String time = formatter.format(currentTime);//获取当前时间

                kind='1';//1代表国内省份，2代表海外，为国内外分开查询做基础

                AddService dao=new AddService();

                dao.add("myinfo", sheng, xinzeng, leiji, zhiyu, siwang,time,kind);//将爬取到的数据添加至数据库，注意需将“myinfo”修改为你的表名            }

　　　　　　　　//爬取海外数据

            Element listdiv11 = doc.getElementById("world_block");

            Elements listdiv22 =listdiv11.select(".chart_table_nation");

            for(Element s:listdiv22) {

                Elements real_name=s.select(".chart_table_name");

                Elements real_newconfirm=s.select(".chart_table_today_confirm");

                Elements real_confirm=s.select(".chart_table_confirm");

                Elements real_dead=s.select(".chart_table_dead");

                Elements real_heal=s.select(".chart_table_heal");

                country=real_name.text();

                xinzeng=real_newconfirm.text();

                leiji=real_confirm.text();

                zhiyu=real_heal.text();

                siwang=real_dead.text();

                System.out.println(country+" 新增确诊:"+xinzeng+" 累计确诊:"+leiji+" 累计治愈:"+zhiyu+" 累计死亡:"+siwang);

                Date currentTime=new Date();

                SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm");

                String time = formatter.format(currentTime);//获取当前时间

                kind='2';//1代表国内省份，2代表海外，为国内外分开查询做基础

                AddService dao=new AddService();

                dao.add("myinfo", country, xinzeng, leiji, zhiyu, siwang,time,kind);//将爬取到的数据添加至数据库，注意需将“myinfo”修改为你的表名                       }   

           

        } catch (IOException e) {

            // TODO Auto-generated catch block            e.printStackTrace();

            System.out.println("爬取失败");

        }

    }

   

}

 

 

 

　　　AddService.java（上面的Paqu.java在爬取中调用了该类，将数据添加到数据库中）

 

package Dao;

import java.sql.Connection;import java.sql.Statement;

import utils.DBUtil;

public class AddService {

    public void add(String table,String sheng,String xinzeng,String leiji,String zhiyu,String dead,String time,char kind) {

        String sql = "insert into "+table+" (Province,Newconfirmed_num ,Confirmed_num,Cured_num,Dead_num,Time,Kind) values('" + sheng + "','" + xinzeng +"','" + leiji +"','" + zhiyu + "','" + dead+ "','" + time+ "','" + kind+ "')";

        System.out.println(sql);

        Connection conn = DBUtil.getConn();

        Statement state = null;

        int a = 0;

        try {

            state = conn.createStatement();

            a=state.executeUpdate(sql);

        } catch (Exception e) {

            e.printStackTrace();

        } finally {

            DBUtil.close(state, conn);

        }       

    }

}

 

 

　　　　DeleteService.java（按需删除数据库中的数据，当重新爬取更新今日数据时调用）

 

package Dao;

import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.SQLException;

import utils.DBUtil;

public class DeleteService {

    public boolean delete(String table,String value)

    {

        boolean c=false;

        Connection conn=DBUtil.getConn();

        PreparedStatement state=null;

        String sql="delete from "+table+" where date(Time) =?";//date（Time）将数据库表中Time转换为只有日期的形式

        try {

            state=conn.prepareStatement(sql);

            state.setString(1,value);

            int num = state.executeUpdate();

            if(num!=0)

            {

                c= true;

            }

            state.close();

            conn.close();

        } catch (SQLException e) {

            // TODO Auto-generated catch block            e.printStackTrace();

        }

        return c;

    }

}

 

 

　　　Get.java（SearchServlet查询表中数据时调用并以List形式返回）

 

package Dao;

import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.util.ArrayList;import java.util.List;

import Bean.Info;import utils.DBUtil;

public class Get {

　　//查询国内各省数据

    public List<Info> listAll(String date1,String date2) {

        ArrayList<Info> list = new ArrayList<>();

        Connection conn=DBUtil.getConn();

        PreparedStatement pstmt = null;

        ResultSet rs = null;

        String sql="select * from myinfo where Kind ='1' and Time between ? and ?";

        try {

            pstmt = conn.prepareStatement(sql);

            pstmt.setString(1, date1);

            pstmt.setString(2, date2);

            rs = pstmt.executeQuery();

            while (rs.next()) {

                Info yq = new Info();

                yq.setId(rs.getInt(1));

                yq.setDate(rs.getString(8));

                yq.setProvince(rs.getString(2));

                yq.setNewconfirmed_num(rs.getString(3));

                yq.setConfirmed_num(rs.getString(4));

                yq.setCured_num(rs.getString(6));

                yq.setDead_num(rs.getString(7));

                list.add(yq);

            }

        } catch (Exception e) {

            e.printStackTrace();

        } finally {

            try {

                conn.close();

            } catch (Exception e) {

                e.printStackTrace();

            }

        }

        return list;

    }

    //查询海外数据

    public List<Info> listAll2(String date1,String date2) {

        ArrayList<Info> list = new ArrayList<>();

        Connection conn=DBUtil.getConn();

        PreparedStatement pstmt = null;

        ResultSet rs = null;

        String sql="select * from myinfo where Kind ='2' and Time between ? and ?";

        try {

            pstmt = conn.prepareStatement(sql);

            pstmt.setString(1, date1);

            pstmt.setString(2, date2);

            System.out.println(sql);

            rs = pstmt.executeQuery();

            while (rs.next()) {

                Info yq = new Info();

                yq.setId(rs.getInt(1));

                yq.setDate(rs.getString(8));

                yq.setProvince(rs.getString(2));

                yq.setNewconfirmed_num(rs.getString(3));

                yq.setConfirmed_num(rs.getString(4));

                yq.setCured_num(rs.getString(6));

                yq.setDead_num(rs.getString(7));

                list.add(yq);

            }

        } catch (Exception e) {

            e.printStackTrace();

        } finally {

            try {

                conn.close();

            } catch (Exception e) {

                e.printStackTrace();

            }

        }

        return list;

    }

}

 

 

　　　Select.java（查询表中是否有今日数据从而判断是否删除.....现在发现根本不需要该方法，直接删除即可，不需要判断表中有没有数据）

 

package Dao;

import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.Statement;import java.util.ArrayList;import java.util.List;

 

import utils.DBUtil;

 

public class Select {

    public boolean select(String time) {

        // TODO Auto-generated method stub

        Connection conn=DBUtil.getConn();

        PreparedStatement pstmt = null;

        ResultSet rs = null;

        boolean b=false;

        String sql="select * from myinfo where date(Time) = ?";

        System.out.println(sql);

        try {

            pstmt = conn.prepareStatement(sql);

            pstmt.setString(1, time);

            rs = pstmt.executeQuery();

            while (rs.next()) {

                b=true;

            }

        } catch (Exception e) {

            e.printStackTrace();

        } finally {

            try {

                conn.close();

            } catch (Exception e) {

                e.printStackTrace();

            }

        }

        return b;

    }

}

 

 

　　　PaquServlet.java（这阶段新建的，专门用来接收移动端爬取请求的）

 

package Servlet;

 

import java.io.IOException;import java.sql.ResultSet;import java.sql.SQLException;import java.text.SimpleDateFormat;import java.util.Date;

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.DeleteService;import control.Paqu;import utils.DBUtil;

 

@WebServlet("/PaquServlet")//移动端爬取用到了该Servletpublic class PaquServlet extends HttpServlet {

 

    @Override

    protected void doGet(HttpServletRequest request, HttpServletResponse response)

            throws ServletException, IOException {

        doPost(request, response);

    }

   

    @Override

    protected void doPost(HttpServletRequest request, HttpServletResponse response)

            throws ServletException, IOException {

        System.out.println("request--->"+request.getRequestURL()+"===="+request.getParameterMap().toString());

        response.setContentType("text/html;charset=utf-8");

        Date currentTime=new Date();

        SimpleDateFormat formatter_date = new SimpleDateFormat("yyyy-MM-dd");

        String date=formatter_date.format(currentTime);

        DeleteService ds=new DeleteService();

        ds.delete("myinfo", date);

        Paqu pq=new Paqu();

        pq.refesh();

    }

   

 

}

 

 

　　SearchServlet.java（也是这阶段新建的，用来接收移动端的查找请求）

 

package Servlet;

 

import java.io.IOException;import java.sql.ResultSet;import java.sql.SQLException;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 com.google.gson.Gson;

import Bean.Info;import Dao.DeleteService;import Dao.Get;import Dao.Select;import control.Paqu;import utils.DBUtil;

 

@WebServlet("/SearchServlet")//移动端用到了该Servletpublic class SearchServlet extends HttpServlet {

 

 

   

    @Override

    protected void doGet(HttpServletRequest request, HttpServletResponse response)

            throws ServletException, IOException {

        doPost(request, response);

    }

   

    @Override

    protected void doPost(HttpServletRequest request, HttpServletResponse response)

            throws ServletException, IOException {

        System.out.println("request--->"+request.getRequestURL()+"===="+request.getParameterMap().toString());

        response.setContentType("text/html;charset=utf-8");

        String method = request.getParameter("method");

        String date1 = request.getParameter("username"); // 获取客户端传过来的参数，移动端的参数叫username与password，我没有修改，可以修改为易于理解的date1，date2，但移动端也要对应修改

        String date2 = request.getParameter("password");

        Get get=new Get();

        List<Info> list=null;

        if(method.equals("province")) {//查询中国省份疫情数据

            list = get.listAll(date1,date2);

        }else

            if(method.equals("country")) {//查询海外疫情数据

                list = get.listAll2(date1, date2);

            }            

        request.setAttribute("list",list);

        Gson gson = new Gson();

        String json = gson.toJson(list);

        try {

            response.getWriter().println(json);

            // 将json数据传给客户端

        } catch (Exception e) {

            e.printStackTrace();

        } finally {

            response.getWriter().close(); // 关闭这个流，不然会发生错误的        }

    }

}

 

 

　　　YqSearch.java（前两个阶段中Web端使用的，移动端没有调用该Servlet）

 

package Servlet;

import java.io.IOException;import java.text.ParseException;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 com.google.gson.Gson;

import Bean.Info;import Dao.DeleteService;import Dao.Get;import Dao.Select;import control.Paqu;

 

/**

 * Servlet implementation class SearchConfirmedServlet

 */

@WebServlet("/YqServlet")public class YqServlet extends HttpServlet {

    private static final long serialVersionUID = 1L;

    Get get=new Get();

    /**

     * @see HttpServlet#HttpServlet()

     */

    public YqServlet() {

        super();

        // TODO Auto-generated constructor stub    }

 

    /**

     * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)

     */

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

        String method = request.getParameter("method");

        if(method.equals("getAllProvince")) {

            try {

                getAllProvince(request, response);

            } catch (ParseException e) {

                // TODO Auto-generated catch block                e.printStackTrace();

            }

        }else if(method.equals("getAllConfirmed")) {

            getAllConfirmed(request, response);

        }

    }

    /**

     * @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);

    }

    protected void getAllProvince(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException, ParseException {

        response.setCharacterEncoding("UTF-8");

        Select s=new Select();

        Date currentTime=new Date();

        SimpleDateFormat formatter_date = new SimpleDateFormat("yyyy-MM-dd");

        String date=formatter_date.format(currentTime);

        String date1 = request.getParameter("date1");

        String date2 = request.getParameter("date2");

        Date today=formatter_date.parse(date);//将现在的date转为日期，方便比较

        Date date22=formatter_date.parse(date2);//将date2转为日期，方便比较

        if(today.before(date22)) {//如果今天日期today比查询后边的date2日期早，需要用到今天的数据

            //不管数据库中有没有今天的数据，运行到这都需要重新爬取一遍，防止官方更新今日数据

            boolean b=s.select(date);//查找数据库中是否存在今天的数据.............黄色部分可删除，前面说到了，用不到查询判断表中是否有今日数据，直接删除就好，反正下面会重新爬取存到数据库

            if(b) {//如果有今日数据已存在，先删除

                DeleteService ds=new DeleteService();

                ds.delete("myinfo", date);

            }

            Paqu pq=new Paqu();//不管数据库是否存在今日数据都会爬取；如果存在，前面已经删除过了，这里的爬取就相当于更新了            pq.refesh();

        }       

        List<Info> list = get.listAll(date1,date2);

        request.setAttribute("list",list);

        request.setAttribute("date1",date1);

        request.setAttribute("date2",date2);

        request.getRequestDispatcher("bar.jsp").forward(request, response);

    }

   

    protected void getAllConfirmed(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

        response.setCharacterEncoding("UTF-8");

        String date1 = request.getParameter("date1");

        String date2 = request.getParameter("date2");

        System.out.println(date1);

        System.out.println(date2);

        List<Info> list = get.listAll(date1,date2);

        HttpSession session = request.getSession();

        session.setAttribute("list",list);

        Gson gson = new Gson();

        String json = gson.toJson(list);

        response.getWriter().write(json);

    }

}

 

 

　　DBUtil.java

 

package utils;

import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;

public class DBUtil {

   

    public static String db_url = "jdbc:mysql://localhost:3306/test?useSSL=false&characterEncoding=UTF-8&serverTimezone=GMT";//如果发布到云服务器就将localhost改为云服务器的ip    public static String db_user = "root";

    public static String db_pass = "root";

   

    public static Connection getConn () {

        Connection conn = null;

       

        try {

            Class.forName("com.mysql.cj.jdbc.Driver");

            conn = DriverManager.getConnection(db_url, db_user, db_pass);

        } catch (Exception e) {

            e.printStackTrace();

        }

       

        return conn;

    }

 

    public static void close (Statement state, Connection conn) {

        if (state != null) {

            try {

                state.close();

            } catch (SQLException e) {

                e.printStackTrace();

            }

        }

       

        if (conn != null) {

            try {

                conn.close();

            } catch (SQLException e) {

                e.printStackTrace();

            }

        }

    }

   

    public static void close (ResultSet rs, Statement state, Connection conn) {

        if (rs != null) {

            try {

                rs.close();

            } catch (SQLException e) {

                e.printStackTrace();

            }

        }

       

        if (state != null) {

            try {

                state.close();

            } catch (SQLException e) {

                e.printStackTrace();

            }

        }

       

        if (conn != null) {

            try {

                conn.close();

            } catch (SQLException e) {

                e.printStackTrace();

            }

        }

    }

 

}

 

 

　　index.jsp

 

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

    pageEncoding="UTF-8"%><!DOCTYPE html><html><head><meta charset="UTF-8"><meta name="viewport" content="width=device-width, initial-scale=1"><title>Insert title here</title><link href="${pageContext.request.contextPath }/bootstrap-3.3.7-dist/css/bootstrap.min.css"  rel="stylesheet"><script src="${pageContext.request.contextPath }/js/jquery-3.3.1.min.js"></script><script src="${pageContext.request.contextPath }/bootstrap-3.3.7-dist/js/bootstrap.min.js"></script>

<style type="text/css">

    .skyblue{

        background:skyblue;

    }

    .pink{

        background:pink;

    }

    *{

        margin:0px;

        padding:0px;

    }

    a{

        font-size:15px;

    }

    </style></head><body>

    <div class="container">

        <form action="YqServlet?method=getAllProvince" method="post">

            <div class="row" style="padding-top: 20px">

                <div class="col-xs-4">

                    <h4>起始时间：</h4>

                    <input type="text" class="form-control" name="date1">

                </div>

                <div class="col-xs-4">

                    <h4>终止时间：</h4>

                    <input type="text" class="form-control" name="date2">

                </div>

                <div class="col-xs-2">

                    <input type="submit" class="btn btn-default" value="查询">

                </div>

            </div>

        </form>

 

    </div></body></html>

 

 

　　bar.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>Insert title here</title><link href="${pageContext.request.contextPath }/bootstrap-3.3.7-dist/css/bootstrap.min.css"  rel="stylesheet"><script src="${pageContext.request.contextPath }/js/jquery.min.js"></script><script src="${pageContext.request.contextPath }/bootstrap-3.3.7-dist/js/bootstrap.min.js"></script><script type="text/javascript" src="${pageContext.request.contextPath }/js/echarts.min.js"></script></head><script type="text/javascript">var dt;function getAllConfirmed(){

   

    var date1 = "${date1}";

    var date2 = "${date2}";

$.ajax({

    url:"YqServlet?method=getAllConfirmed",

    async:false,

    type:"POST",

    data:{"date1":date1,

          "date2":date2

         },

    success:function(data){

        dt = data;

        //alert(dt);    },

    error:function(){

        alert("请求失败");

    },

    dataType:"json"

});

   

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

    var xd = new Array(0)//长度为33

    var yd = new Array(0)//长度为33

    for(var i=0;i<32;i++){

        xd.push(dt[i].province);

        yd.push(dt[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: 'bar',

                stack: '总量',

                data: yd,

                barWidth:20,

                barGap:'10%'

            }

        ]

    };

        // 使用刚指定的配置项和数据显示图表。        myChart.setOption(option);

}</script><body>

    <button class="btn btn-default" onclick="getAllConfirmed()" style="padding-top:20px;font-size:20px">柱状图</button>

    <div id="yiqingchart" style="width:900px; height: 600px;">

       

    </div>

    <table class="table table-striped" style="font-size:20px">

        <tr>

            <td>编号</td>

            <td>时间</td>

            <td>省份</td>

            <td>新增人数</td>

            <td>确诊人数</td>

            <td>治愈人数</td>

            <td>死亡人数</td>

        </tr>

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

        <tr>

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

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

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

            <td>${info.newconfirmed_num}</td>

            <td>${info.confirmed_num}</td>

            <td>${info.cured_num}</td>

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

        </tr>

        </c:forEach>

    </table></body></html>

 

　　3 移动端

　　activity_main.xml

 

<?xml version="1.0" encoding="utf-8"?><LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"

    xmlns:tools="http://schemas.android.com/tools"

    android:id="@+id/activity_main"

    android:layout_width="match_parent"

    android:layout_height="match_parent"

    android:orientation="vertical"

    tools:context="com.example.testnet.MainActivity">

 

<!--    <EditText--><!--    android:id="@+id/et_data_uname"--><!--    android:layout_width="match_parent"--><!--    android:layout_height="wrap_content"--><!--    android:hint="请输入开始时间："--><!--    android:text="2020-03-18"/>-->

<!--    <EditText--><!--        android:id="@+id/et_data_upass"--><!--        android:layout_width="match_parent"--><!--        android:layout_height="wrap_content"--><!--        android:hint="请输入截止时间："--><!--        android:text="2020-03-19" />-->

 

    <TextView

        android:layout_width="match_parent"

        android:layout_height="60dp"

        android:text="请选择开始时间"

        android:textSize="50sp" />

 

    <DatePicker

        android:id="@+id/et_data_uname"

        android:layout_width="match_parent"

        android:layout_height="100dp"

        android:layout_margin="4dp"

        android:datePickerMode="spinner"

        android:calendarViewShown="false"/>

 

    <TextView

        android:layout_width="match_parent"

        android:layout_height="60dp"

        android:text="请选择截止时间"

        android:textSize="50sp" />

 

    <DatePicker

        android:id="@+id/et_data_upass"

        android:layout_width="match_parent"

        android:layout_height="100dp"

        android:layout_margin="4dp"

        android:datePickerMode="spinner"

        android:calendarViewShown="false"/>

 

    <Button

        android:layout_width="match_parent"

        android:layout_height="wrap_content"

        android:onClick="loginGet"

        android:text="爬取（只可获取当天数据）" />

 

    <Button

        android:layout_width="match_parent"

        android:layout_height="wrap_content"

        android:onClick="loginPOST"

        android:text="查询国内疫情信息" />

 

    <Button

        android:layout_width="match_parent"

        android:layout_height="wrap_content"

        android:onClick="loginPOST2"

        android:text="查询海外疫情信息" />

</LinearLayout>

 

 

　　content_main.xml（大的表单）

 

<?xml version="1.0" encoding="utf-8"?><LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"

    android:orientation="vertical" android:layout_width="match_parent"

    android:layout_height="match_parent">

    <LinearLayout

        android:layout_width="wrap_content"

        android:layout_height="50dp">

        <TextView

            android:layout_width="60dp"

            android:layout_height="wrap_content"

            android:layout_alignParentLeft="true"

            android:layout_marginLeft="10dp"

            android:ellipsize="marquee"

            android:gravity="center"

            android:singleLine="true"

            android:text="省份"

            android:textSize="20sp" />

 

        <TextView

            android:id="@+id/tv_date"

            android:layout_width="95dp"

            android:layout_height="wrap_content"

            android:text="时间"

            android:textSize="20sp" />

 

        <TextView

            android:id="@+id/tv_confirmed"

            android:layout_width="55dp"

            android:layout_height="80dp"

            android:text="确诊"

            android:textSize="15sp" />

 

        <TextView

            android:id="@+id/tv_cured"

            android:layout_width="55dp"

            android:layout_height="80dp"

            android:text="治愈"

            android:textSize="15sp" />

 

        <TextView

            android:id="@+id/tv_dead"

            android:layout_width="55dp"

            android:layout_height="80dp"

            android:text="死亡"

            android:textSize="15sp" />

 

        <TextView

            android:id="@+id/tv_new"

            android:layout_width="55dp"

            android:layout_height="80dp"

            android:text="新增"

            android:textSize="15sp" />

    </LinearLayout>

    <ListView

        android:layout_width="wrap_content"

        android:layout_height="wrap_content"

        android:id="@+id/lv_main"/></LinearLayout>

 

 

　　list_item.xml（显示具体的一条一条数据）

 

<?xml version="1.0" encoding="utf-8"?><LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"

    android:orientation="horizontal"

    android:layout_width="match_parent"

    android:layout_height="match_parent">

 

    <TextView

        android:id="@+id/tv_province"

        android:layout_width="60dp"

        android:layout_height="wrap_content"

        android:layout_alignParentLeft="true"

        android:layout_marginLeft="10dp"

        android:ellipsize="marquee"

        android:gravity="center"

        android:singleLine="true"

        android:text="省份"

        android:textSize="20sp" />

 

    <TextView

        android:id="@+id/tv_date"

        android:layout_width="95dp"

        android:layout_height="wrap_content"

        android:text="时间"

        android:textSize="15sp" />

 

    <TextView

        android:id="@+id/tv_confirmed"

        android:layout_width="55dp"

        android:layout_height="80dp"

        android:text="67799"

        android:textSize="20sp" />

 

    <TextView

        android:id="@+id/tv_cured"

        android:layout_width="55dp"

        android:layout_height="80dp"

        android:text="56002"

        android:textSize="20sp" />

 

    <TextView

        android:id="@+id/tv_dead"

        android:layout_width="55dp"

        android:layout_height="80dp"

        android:text="3"

        android:textSize="20sp" />

 

    <TextView

        android:id="@+id/tv_new"

        android:layout_width="55dp"

        android:layout_height="80dp"

        android:text="5"

        android:textSize="20sp" />

</LinearLayout>

 

 

 只需用到info和两个activity即可，另外两个用不到

　　Info.java

 

package com.example.testnet;

public class Info {

    private String id;

    private String city;

    private String yisi_num;

    private String date;

    private String province;

    private String confirmed_num;

    private String cured_num;

    private String dead_num;

    private String newconfirmed_num;

    public String getNewconfirmed_num() {

        return newconfirmed_num;

    }

    public void setNewconfirmed_num(String newconfirmed_num) {

        this.newconfirmed_num = newconfirmed_num;

    }

    public String  getId() {

        return id;

    }

    public void setId(String id) {

        this.id = id;

    }

    public String getCity() {

        return city;

    }

    public void setCity(String city) {

        this.city = city;

    }

    public String getYisi_num() {

        return yisi_num;

    }

    public void setYisi_num(String yisi_num) {

        this.yisi_num = yisi_num;

    }

    public String getDate() {

        return date;

    }

    public void setDate(String date) {

        this.date = date;

    }

    public String getProvince() {

        return province;

    }

    public void setProvince(String province) {

        this.province = province;

    }

    public String getConfirmed_num() {

        return confirmed_num;

    }

    public void setConfirmed_num(String confirmed_num) {

        this.confirmed_num = confirmed_num;

    }

    public String getCured_num() {

        return cured_num;

    }

    public void setCured_num(String cured_num) {

        this.cured_num = cured_num;

    }

    public String getDead_num() {

        return dead_num;

    }

    public void setDead_num(String dead_num) {

        this.dead_num = dead_num;

    }

}

 

 

　　MainActivity.java

 

package com.example.testnet;

import android.content.Intent;import android.os.Bundle;import android.util.Log;import android.view.View;import android.widget.DatePicker;

import androidx.appcompat.app.AppCompatActivity;

import java.io.ByteArrayOutputStream;import java.io.DataInputStream;import java.io.DataOutputStream;import java.io.File;import java.io.FileInputStream;import java.io.FileOutputStream;import java.io.IOException;import java.io.InputStream;import java.io.PrintWriter;import java.net.HttpURLConnection;import java.net.URL;import java.net.URLEncoder;import java.util.HashMap;

 

public class MainActivity extends AppCompatActivity {

 

    String TAG = MainActivity.class.getCanonicalName();//    private EditText et_data_uname;//    private EditText et_data_upass;

    private DatePicker et_data_uname;

    private DatePicker et_data_upass;

    private HashMap<String, String> stringHashMap;

    private String t;

    @Override

    protected void onCreate(Bundle savedInstanceState) {

        super.onCreate(savedInstanceState);

        setContentView(R.layout.activity_main);

        et_data_uname = (DatePicker) findViewById(R.id.et_data_uname);

        et_data_upass = (DatePicker) findViewById(R.id.et_data_upass);

        stringHashMap = new HashMap<>();

    }

 

    public void loginPOST(View view) {

        stringHashMap.put("username",et_data_uname.getYear()+"-"+(et_data_uname.getMonth()+1)+"-"+et_data_uname.getDayOfMonth());

        stringHashMap.put("password", et_data_upass.getYear()+"-"+(et_data_upass.getMonth()+1)+"-"+et_data_upass.getDayOfMonth());

 

        new Thread(postRun).start();

    }

    public void loginPOST2(View view) {

        stringHashMap.put("username",et_data_uname.getYear()+"-"+(et_data_uname.getMonth()+1)+"-"+et_data_uname.getDayOfMonth());

        stringHashMap.put("password", et_data_upass.getYear()+"-"+(et_data_upass.getMonth()+1)+"-"+et_data_upass.getDayOfMonth());

 

        new Thread(postRun2).start();

    }

    public void loginGet(View view) {

        stringHashMap.put("username", et_data_uname.getYear()+"-"+(et_data_uname.getMonth()+1)+"-"+et_data_uname.getDayOfMonth());

        stringHashMap.put("password", et_data_upass.getYear()+"-"+(et_data_upass.getMonth()+1)+"-"+et_data_upass.getDayOfMonth());

        new Thread(getRun).start();

    }

 

    /**

     * get请求线程

     */

    Runnable getRun = new Runnable() {

 

        @Override

        public void run() {

            // TODO Auto-generated method stub            requestGet(stringHashMap);

        }

    };

    /**

     * post请求线程

     */

    Runnable postRun = new Runnable() {

 

        @Override

        public void run() {

            // TODO Auto-generated method stub            requestPost(stringHashMap);

        }

    };

    Runnable postRun2 = new Runnable() {

 

        @Override

        public void run() {

            // TODO Auto-generated method stub            requestPost2(stringHashMap);

        }

    };

 

    /**

     * get提交数据

     *

     * @param paramsMap

     */

    private void requestGet(HashMap<String, String> paramsMap) {

        try {

            String baseUrl = "http://10.0.2.2:8080/YiQing/PaquServlet?";//如果发布到云端，将黄色部分修改为云服务器ip

            StringBuilder tempParams = new StringBuilder();

            int pos = 0;

            for (String key : paramsMap.keySet()) {

                if (pos > 0) {

                    tempParams.append("&");

                }

                tempParams.append(String.format("%s=%s", key, URLEncoder.encode(paramsMap.get(key), "utf-8")));

                pos++;

            }

 

            Log.e(TAG,"params--get-->>"+tempParams.toString());

            String requestUrl = baseUrl + tempParams.toString();

            // 新建一个URL对象

            URL url = new URL(requestUrl);

            // 打开一个HttpURLConnection连接

            HttpURLConnection urlConn = (HttpURLConnection) url.openConnection();

            // 设置连接主机超时时间

            urlConn.setConnectTimeout(5 * 1000);

            //设置从主机读取数据超时

            urlConn.setReadTimeout(5 * 1000);

            // 设置是否使用缓存  默认是true

            urlConn.setUseCaches(true);

            // 设置为Post请求

            urlConn.setRequestMethod("GET");

            //urlConn设置请求头信息

            //设置请求中的媒体类型信息。

            urlConn.setRequestProperty("Content-Type", "application/json");

            //设置客户端与服务连接类型

            urlConn.addRequestProperty("Connection", "Keep-Alive");

            // 开始连接            urlConn.connect();

            // 判断请求是否成功

            if (urlConn.getResponseCode() == 200) {

                // 获取返回的数据

                String result = streamToString(urlConn.getInputStream());

                Log.e(TAG, "Get方式请求成功，result--->" + result);

            } else {

                Log.e(TAG, "Get方式请求失败");

            }

            // 关闭连接            urlConn.disconnect();

        } catch (Exception e) {

            Log.e(TAG, e.toString());

        }

    }

 

    /**

     * post提交数据

     *

     * @param paramsMap

     */

    private void requestPost(HashMap<String, String> paramsMap) {

        try {

            String baseUrl = "http://10.0.2.2:8080/YiQing/SearchServlet?method=province";//如若发布到云端，将黄色部分修改为云端ip             //合成参数

            StringBuilder tempParams = new StringBuilder();

            int pos = 0;

            for (String key : paramsMap.keySet()) {

                if (pos >0) {

                    tempParams.append("&");

                }

                tempParams.append(String.format("%s=%s", key, URLEncoder.encode(paramsMap.get(key), "utf-8")));

                pos++;

            }

            String params = tempParams.toString();

            Log.e(TAG,"params--post-->>"+params);

            // 请求的参数转换为byte数组//            byte[] postData = params.getBytes();

            // 新建一个URL对象

            URL url = new URL(baseUrl);

            // 打开一个HttpURLConnection连接

            HttpURLConnection urlConn = (HttpURLConnection) url.openConnection();

            // 设置连接超时时间

            urlConn.setConnectTimeout(5 * 1000);

            //设置从主机读取数据超时

            urlConn.setReadTimeout(5 * 1000);

            // Post请求必须设置允许输出 默认false

            urlConn.setDoOutput(true);

            //设置请求允许输入 默认是true

            urlConn.setDoInput(true);

            // Post请求不能使用缓存

            urlConn.setUseCaches(false);

            // 设置为Post请求

            urlConn.setRequestMethod("POST");

            //设置本次连接是否自动处理重定向

            urlConn.setInstanceFollowRedirects(true);

            //配置请求Content-Type//            urlConn.setRequestProperty("Content-Type", "application/json");//post请求不能设置这个

            // 开始连接            urlConn.connect();

 

            // 发送请求参数

            PrintWriter dos = new PrintWriter(urlConn.getOutputStream());

            dos.write(params);

            dos.flush();

            dos.close();

            // 判断请求是否成功

            if (urlConn.getResponseCode() == 200) {

                // 获取返回的数据

                String result = streamToString(urlConn.getInputStream());

                Log.e(TAG, "Post方式请求成功，result--->" + result);

                t=result;

                Intent intent = new Intent(MainActivity.this,MainActivity2.class);

                System.out.println(t);

                intent.putExtra("data",t);

                startActivity(intent);

            } else {

                Log.e(TAG, "Post方式请求失败");

            }

            // 关闭连接            urlConn.disconnect();

        } catch (Exception e) {

            Log.e(TAG, e.toString());

        }

    }

 

    private void requestPost2(HashMap<String, String> paramsMap) {

        try {

            String baseUrl = "http://10.0.2.2:8080/YiQing/SearchServlet?method=country";//如若发布到云端，将黄色部分修改为云端ip            //合成参数

            StringBuilder tempParams = new StringBuilder();

            int pos = 0;

            for (String key : paramsMap.keySet()) {

                if (pos >0) {

                    tempParams.append("&");

                }

                tempParams.append(String.format("%s=%s", key, URLEncoder.encode(paramsMap.get(key), "utf-8")));

                pos++;

            }

            String params = tempParams.toString();

            Log.e(TAG,"params--post-->>"+params);

            // 请求的参数转换为byte数组//            byte[] postData = params.getBytes();

            // 新建一个URL对象

            URL url = new URL(baseUrl);

            // 打开一个HttpURLConnection连接

            HttpURLConnection urlConn = (HttpURLConnection) url.openConnection();

            // 设置连接超时时间

            urlConn.setConnectTimeout(5 * 1000);

            //设置从主机读取数据超时

            urlConn.setReadTimeout(5 * 1000);

            // Post请求必须设置允许输出 默认false

            urlConn.setDoOutput(true);

            //设置请求允许输入 默认是true

            urlConn.setDoInput(true);

            // Post请求不能使用缓存

            urlConn.setUseCaches(false);

            // 设置为Post请求

            urlConn.setRequestMethod("POST");

            //设置本次连接是否自动处理重定向

            urlConn.setInstanceFollowRedirects(true);

            //配置请求Content-Type//            urlConn.setRequestProperty("Content-Type", "application/json");//post请求不能设置这个

            // 开始连接            urlConn.connect();

 

            // 发送请求参数

            PrintWriter dos = new PrintWriter(urlConn.getOutputStream());

            dos.write(params);

            dos.flush();

            dos.close();

            // 判断请求是否成功

            if (urlConn.getResponseCode() == 200) {

                // 获取返回的数据

                String result = streamToString(urlConn.getInputStream());

                Log.e(TAG, "Post方式请求成功，result--->" + result);

                t=result;

                Intent intent = new Intent(MainActivity.this,MainActivity2.class);

                System.out.println(t);

                intent.putExtra("data",t);

                startActivity(intent);

            } else {

                Log.e(TAG, "Post方式请求失败");

            }

            // 关闭连接            urlConn.disconnect();

        } catch (Exception e) {

            Log.e(TAG, e.toString());

        }

    }

 

 

    /**

     * 将输入流转换成字符串

     *

     * @param is 从网络获取的输入流

     * @return

     */

    public String streamToString(InputStream is) {

        try {

            ByteArrayOutputStream baos = new ByteArrayOutputStream();

            byte[] buffer = new byte[1024];

            int len = 0;

            while ((len = is.read(buffer)) != -1) {

                baos.write(buffer, 0, len);

            }

            baos.close();

            is.close();

            byte[] byteArray = baos.toByteArray();

            return new String(byteArray);

        } catch (Exception e) {

            Log.e(TAG, e.toString());

            return null;

        }

    }

 

    /**

     * 文件下载

     *

     * @param fileUrl

     */

    private void downloadFile(String fileUrl) {

        try {

            // 新建一个URL对象

            URL url = new URL(fileUrl);

            // 打开一个HttpURLConnection连接

            HttpURLConnection urlConn = (HttpURLConnection) url.openConnection();

            // 设置连接主机超时时间

            urlConn.setConnectTimeout(5 * 1000);

            //设置从主机读取数据超时

            urlConn.setReadTimeout(5 * 1000);

            // 设置是否使用缓存  默认是true

            urlConn.setUseCaches(true);

            // 设置为Post请求

            urlConn.setRequestMethod("GET");

            //urlConn设置请求头信息

            //设置请求中的媒体类型信息。

            urlConn.setRequestProperty("Content-Type", "application/json");

            //设置客户端与服务连接类型

            urlConn.addRequestProperty("Connection", "Keep-Alive");

            // 开始连接            urlConn.connect();

            // 判断请求是否成功

            if (urlConn.getResponseCode() == 200) {

                String filePath = "";//下载文件保存在本地的地址

                File descFile = new File(filePath);

                FileOutputStream fos = new FileOutputStream(descFile);

                ;

                byte[] buffer = new byte[1024];

                int len;

                InputStream inputStream = urlConn.getInputStream();

                while ((len = inputStream.read(buffer)) != -1) {

                    // 写到本地

                    fos.write(buffer, 0, len);

                }

            } else {

                Log.e(TAG, "文件下载失败");

            }

            // 关闭连接            urlConn.disconnect();

        } catch (Exception e) {

            Log.e(TAG, e.toString());

        }

    }

 

    /**

     * 文件上传

     *

     * @param filePath

     * @param paramsMap

     */

    private void upLoadFile(String filePath, HashMap<String, String> paramsMap) {

        try {

            String baseUrl = "http://xxx.com/uploadFile";

            File file = new File(filePath);

            //新建url对象

            URL url = new URL(baseUrl);

            //通过HttpURLConnection对象,向网络地址发送请求

            HttpURLConnection urlConn = (HttpURLConnection) url.openConnection();

            //设置该连接允许读取

            urlConn.setDoOutput(true);

            //设置该连接允许写入

            urlConn.setDoInput(true);

            //设置不能适用缓存

            urlConn.setUseCaches(false);

            //设置连接超时时间

            urlConn.setConnectTimeout(5 * 1000);   //设置连接超时时间

            //设置读取超时时间

            urlConn.setReadTimeout(5 * 1000);   //读取超时

            //设置连接方法post

            urlConn.setRequestMethod("POST");

            //设置维持长连接

            urlConn.setRequestProperty("connection", "Keep-Alive");

            //设置文件字符集

            urlConn.setRequestProperty("Accept-Charset", "UTF-8");

            //设置文件类型

            urlConn.setRequestProperty("Content-Type", "multipart/form-data; boundary=" + "*****");

            String name = file.getName();

            DataOutputStream requestStream = new DataOutputStream(urlConn.getOutputStream());

            requestStream.writeBytes("--" + "*****" + "\r\n");

            //发送文件参数信息

            StringBuilder tempParams = new StringBuilder();

            tempParams.append("Content-Disposition: form-data; name=\"" + name + "\"; filename=\"" + name + "\"; ");

            int pos = 0;

            int size = paramsMap.size();

            for (String key : paramsMap.keySet()) {

                tempParams.append(String.format("%s=\"%s\"", key, paramsMap.get(key), "utf-8"));

                if (pos < size - 1) {

                    tempParams.append("; ");

                }

                pos++;

            }

            tempParams.append("\r\n");

            tempParams.append("Content-Type: application/octet-stream\r\n");

            tempParams.append("\r\n");

            String params = tempParams.toString();

            requestStream.writeBytes(params);

            //发送文件数据

            FileInputStream fileInput = new FileInputStream(file);

            int bytesRead;

            byte[] buffer = new byte[1024];

            DataInputStream in = new DataInputStream(new FileInputStream(file));

            while ((bytesRead = in.read(buffer)) != -1) {

                requestStream.write(buffer, 0, bytesRead);

            }

            requestStream.writeBytes("\r\n");

            requestStream.flush();

            requestStream.writeBytes("--" + "*****" + "--" + "\r\n");

            requestStream.flush();

            fileInput.close();

            int statusCode = urlConn.getResponseCode();

            if (statusCode == 200) {

                // 获取返回的数据

                String result = streamToString(urlConn.getInputStream());

                Log.e(TAG, "上传成功，result--->" + result);

            } else {

                Log.e(TAG, "上传失败");

            }

        } catch (IOException e) {

            Log.e(TAG, e.toString());

        }

    }

 

 

}

 

 

　　MainActivity2.java（当点击查询后，会从MainActivity跳转到该MainActivity2）　　

 

package com.example.testnet;

import android.content.Intent;import android.os.Bundle;import android.widget.ListView;import android.widget.SimpleAdapter;

import androidx.appcompat.app.AppCompatActivity;

import org.json.JSONArray;import org.json.JSONException;import org.json.JSONObject;

import java.util.ArrayList;import java.util.HashMap;import java.util.List;import java.util.Map;

public class MainActivity2 extends AppCompatActivity {

 

    private List<Info> list ;

    private YqAdapter mAdapter;

    Info yq=new Info();

    int n=0;

    @Override

    protected void onCreate(Bundle savedInstanceState) {

        super.onCreate(savedInstanceState);

        setContentView(R.layout.content_main);

        Intent m =getIntent();

        String result=m.getStringExtra("data");

        List<Map<String, Object>> listitem = new ArrayList<Map<String, Object>>();

        String[] province=new String[1000];

        String[] date=new String[1000];

        String[] now=new String[1000];

        String[] cured=new String[1000];

        String[] dead=new String[1000];

        String[] today=new String[1000];

        try {

            JSONArray json = new JSONArray(result);

            for (int i = 0;i<json.length();i++){

                JSONObject jb=json.getJSONObject(i);

                date[i]=jb.getString("date");

                province[i]=jb.getString("province");

                now[i]=jb.getString("confirmed_num");

                cured[i]=jb.getString("cured_num");

                dead[i]=jb.getString("dead_num");

                today[i]=jb.getString("newconfirmed_num");

                n=i+1;

            }

        } catch (JSONException e) {

            e.printStackTrace();

        }

        for (int i = 0; i <n; i++)

        {

            Map<String,Object> map = new HashMap<String, Object>();

            map.put("province",province[i]);

            map.put("date",date[i]);

            map.put("now",now[i]);

            map.put("cured",cured[i]);

            map.put("dead",dead[i]);

            map.put("today",today[i]);

            listitem.add(map);

        }//        for (int i=0;i<n;i++){//            System.out.println(province[i]);//        }

        SimpleAdapter adapter = new SimpleAdapter(this

                , listitem

                , R.layout.list_item

                , new String[]{"province","date","now","cured","dead","today"}

                ,new int[]{R.id.tv_province,R.id.tv_date,R.id.tv_confirmed,R.id.tv_cured,R.id.tv_dead,R.id.tv_new});

        ListView listView =(ListView) findViewById(R.id.lv_main);

        listView.setAdapter(adapter);

    }

}

 

4、移动端与Web端的交互（上面的代码已经实现了交互）

　　移动端只是向Web端发送请求，调用相应的Servlet，一些复杂的运算还是ecplise中进行完成的。

　　刚开始可以参考该篇博客了解交互过程https://blog.csdn.net/qq_34317125/article/details/80533685

5、云服务器配置与部署

　　可以参考我的另一篇博客https://www.cnblogs.com/xhj1074376195/p/12318178.html

　　新获得的云服务要像一台新电脑一样，同样需要下载配置jdk，mysql，Tomcat....

6、运行测试结果

　　Web端

 

 

 　　移动端

  

7、开发过程中出现的问题　

　　1.在Android Studio中将localhost：8080修改为云端服务器ip时，没有把:8080去掉,导致连接不上云端服务器。

　　2.Listview的布局中，没有弄清楚绑定的是哪一个页面，导致一直报空指针，应该修改为ListView控件所在的xml页面。

　　3.在AndroidMainifresh.xml中添加联网设置

<uses-permission android:name="android.permission.INTERNET" />

　　4.新建一个MainActivity2.java之后，在AndroidMainifest.xml中添加Activity活动

<activity android:name=".MainActivity2"/>

　　5.在虚拟机上可以正常运行，但打包apk至真机无法运行，请教同学以及百度后得知，Android 9.0之后 的应用程序，将要求默认使用加密连接，这意味着 Android P(9.0) 将禁止 App 使用所有未加密的连接，因此运行 Android P(9.0) 系统的安卓设备无论是接收或者发送流量，未来都不能明码传输，需要使用下一代(Transport Layer Security)传输层安全协议，而 Android Nougat 和 Oreo 则不受影响。简单来说就是，系统为了安全起见，Android 9.0之后禁止使用不加密的连接。解决办法，在AndroidMainifresh.xml中<application></application>下添加语句允许不加密连接

        android:usesCleartextTraffic="true"

的一部分了。注意：本文采用的是ecplise与Android Studio交互远程连接数据库，Android Studio上面并没有直接连取数据库

 2、代码实现

　　2.1 Web端（包含前两阶段代码）

 

　　　Info.java:

 

package Bean;

public class Info {

    private int id;

    private String city;

    private String yisi_num;

    private String date;

    private String province;

    private String confirmed_num;

    private String cured_num;

    private String dead_num;

    private String newconfirmed_num;

    public String getNewconfirmed_num() {

        return newconfirmed_num;

    }

    public void setNewconfirmed_num(String newconfirmed_num) {

        this.newconfirmed_num = newconfirmed_num;

    }

    public int getId() {

        return id;

    }

    public void setId(int id) {

        this.id = id;

    }

    public String getCity() {

        return city;

    }

    public void setCity(String city) {

        this.city = city;

    }

    public String getYisi_num() {

        return yisi_num;

    }

    public void setYisi_num(String yisi_num) {

        this.yisi_num = yisi_num;

    }

    public String getDate() {

        return date;

    }

    public void setDate(String date) {

        this.date = date;

    }

    public String getProvince() {

        return province;

    }

    public void setProvince(String province) {

        this.province = province;

    }

    public String getConfirmed_num() {

        return confirmed_num;

    }

    public void setConfirmed_num(String confirmed_num) {

        this.confirmed_num = confirmed_num;

    }

    public String getCured_num() {

        return cured_num;

    }

    public void setCured_num(String cured_num) {

        this.cured_num = cured_num;

    }

    public String getDead_num() {

        return dead_num;

    }

    public void setDead_num(String dead_num) {

        this.dead_num = dead_num;

    }

}

 

 

　　　Paqu.java（如同它的名字，用来爬取数据的）

 

package control;import java.io.IOException;import java.text.SimpleDateFormat;import java.util.Date;import org.jsoup.Jsoup;import org.jsoup.nodes.Document;import org.jsoup.nodes.Element;import org.jsoup.select.Elements;

import com.gargoylesoftware.htmlunit.BrowserVersion;import com.gargoylesoftware.htmlunit.WebClient;import com.gargoylesoftware.htmlunit.html.HtmlPage;import Dao.AddService;

 public class Paqu {

    public static void main(String args[]) {

        refesh();

    }

    public static void refesh() {

        // TODO Auto-generated method stub

        String sheng="";

        String xinzeng="";

        String leiji="";

        String zhiyu="";

        String siwang="";

        String country="";

        char kind;

         String url = "https://wp.m.163.com/163/page/news/virus_report/index.html?_nw_=1&_anw_=1";

        int i=0;

        try {

            //构造一个webClient 模拟Chrome 浏览器

            WebClient webClient = new WebClient(BrowserVersion.CHROME);

            //支持JavaScript

            webClient.getOptions().setJavaScriptEnabled(true);

            webClient.getOptions().setCssEnabled(false);

            webClient.getOptions().setActiveXNative(false);

            webClient.getOptions().setCssEnabled(false);

            webClient.getOptions().setThrowExceptionOnScriptError(false);

            webClient.getOptions().setThrowExceptionOnFailingStatusCode(false);

            webClient.getOptions().setTimeout(8000);

            HtmlPage rootPage = webClient.getPage(url);

            //设置一个运行JavaScript的时间

            webClient.waitForBackgroundJavaScript(6000);

            String html = rootPage.asXml();

            Document doc = Jsoup.parse(html);

            //System.out.println(doc);

　　　　　　　　//爬取国内各省数据

            Element listdiv1 = doc.select(".wrap").first();

            Elements listdiv2 = listdiv1.select(".province");

            for(Element s:listdiv2) {

                Elements span = s.getElementsByTag("span");

                Elements real_name=span.select(".item_name");

                Elements real_newconfirm=span.select(".item_newconfirm");

                Elements real_confirm=span.select(".item_confirm");

                Elements real_dead=span.select(".item_dead");

                Elements real_heal=span.select(".item_heal");                

                sheng=real_name.text();

                xinzeng=real_newconfirm.text();

                leiji=real_confirm.text();

                zhiyu=real_heal.text();

                siwang=real_dead.text();

                System.out.println(sheng+" 新增确诊:"+xinzeng+" 累计确诊:"+leiji+" 累计治愈:"+zhiyu+" 累计死亡:"+siwang);

                Date currentTime=new Date();

                SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm");

                String time = formatter.format(currentTime);//获取当前时间

                kind='1';//1代表国内省份，2代表海外，为国内外分开查询做基础

                AddService dao=new AddService();

                dao.add("myinfo", sheng, xinzeng, leiji, zhiyu, siwang,time,kind);//将爬取到的数据添加至数据库，注意需将“myinfo”修改为你的表名            }

　　　　　　　　//爬取海外数据

            Element listdiv11 = doc.getElementById("world_block");

            Elements listdiv22 =listdiv11.select(".chart_table_nation");

            for(Element s:listdiv22) {

                Elements real_name=s.select(".chart_table_name");

                Elements real_newconfirm=s.select(".chart_table_today_confirm");

                Elements real_confirm=s.select(".chart_table_confirm");

                Elements real_dead=s.select(".chart_table_dead");

                Elements real_heal=s.select(".chart_table_heal");

                country=real_name.text();

                xinzeng=real_newconfirm.text();

                leiji=real_confirm.text();

                zhiyu=real_heal.text();

                siwang=real_dead.text();

                System.out.println(country+" 新增确诊:"+xinzeng+" 累计确诊:"+leiji+" 累计治愈:"+zhiyu+" 累计死亡:"+siwang);

                Date currentTime=new Date();

                SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm");

                String time = formatter.format(currentTime);//获取当前时间

                kind='2';//1代表国内省份，2代表海外，为国内外分开查询做基础

                AddService dao=new AddService();

                dao.add("myinfo", country, xinzeng, leiji, zhiyu, siwang,time,kind);//将爬取到的数据添加至数据库，注意需将“myinfo”修改为你的表名                       }    

        } catch (IOException e) {

            // TODO Auto-generated catch block            e.printStackTrace();

            System.out.println("爬取失败");

        }

    }

}

 

 

 

　　　AddService.java（上面的Paqu.java在爬取中调用了该类，将数据添加到数据库中）

 

package Dao;

import java.sql.Connection;import java.sql.Statement;

import utils.DBUtil;

public class AddService {

    public void add(String table,String sheng,String xinzeng,String leiji,String zhiyu,String dead,String time,char kind) {

        String sql = "insert into "+table+" (Province,Newconfirmed_num ,Confirmed_num,Cured_num,Dead_num,Time,Kind) values('" + sheng + "','" + xinzeng +"','" + leiji +"','" + zhiyu + "','" + dead+ "','" + time+ "','" + kind+ "')";

        System.out.println(sql);

        Connection conn = DBUtil.getConn();

        Statement state = null;

        int a = 0;

        try {

            state = conn.createStatement();

            a=state.executeUpdate(sql);

        } catch (Exception e) {

            e.printStackTrace();

        } finally {

            DBUtil.close(state, conn);

        }        

    }

}

 

 

　　　　DeleteService.java（按需删除数据库中的数据，当重新爬取更新今日数据时调用）

 

package Dao;

import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.SQLException;

import utils.DBUtil;

public class DeleteService {

    public boolean delete(String table,String value)

    {

        boolean c=false;

        Connection conn=DBUtil.getConn();

        PreparedStatement state=null;

        String sql="delete from "+table+" where date(Time) =?";//date（Time）将数据库表中Time转换为只有日期的形式

        try {

            state=conn.prepareStatement(sql);

            state.setString(1,value);

            int num = state.executeUpdate();

            if(num!=0)

            {

                c= true;

            }

            state.close();

            conn.close();

        } catch (SQLException e) {

            // TODO Auto-generated catch block            e.printStackTrace();

        }

        return c;

    }

}

 

 

　　　Get.java（SearchServlet查询表中数据时调用并以List形式返回）

 

package Dao;

import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.util.ArrayList;import java.util.List;

import Bean.Info;import utils.DBUtil;

public class Get {

　　//查询国内各省数据

    public List<Info> listAll(String date1,String date2) {

        ArrayList<Info> list = new ArrayList<>();

        Connection conn=DBUtil.getConn();

        PreparedStatement pstmt = null;

        ResultSet rs = null;

        String sql="select * from myinfo where Kind ='1' and Time between ? and ?";

        try {

            pstmt = conn.prepareStatement(sql);

            pstmt.setString(1, date1);

            pstmt.setString(2, date2);

            rs = pstmt.executeQuery();

            while (rs.next()) {

                Info yq = new Info();

                yq.setId(rs.getInt(1));

                yq.setDate(rs.getString(8));

                yq.setProvince(rs.getString(2));

                yq.setNewconfirmed_num(rs.getString(3));

                yq.setConfirmed_num(rs.getString(4));

                yq.setCured_num(rs.getString(6));

                yq.setDead_num(rs.getString(7));

                list.add(yq);

            }

        } catch (Exception e) {

            e.printStackTrace();

        } finally {

            try {

                conn.close();

            } catch (Exception e) {

                e.printStackTrace();

            }

        }

        return list;

    }

    //查询海外数据

    public List<Info> listAll2(String date1,String date2) {

        ArrayList<Info> list = new ArrayList<>();

        Connection conn=DBUtil.getConn();

        PreparedStatement pstmt = null;

        ResultSet rs = null;

        String sql="select * from myinfo where Kind ='2' and Time between ? and ?";

        try {

            pstmt = conn.prepareStatement(sql);

            pstmt.setString(1, date1);

            pstmt.setString(2, date2);

            System.out.println(sql);

            rs = pstmt.executeQuery();

            while (rs.next()) {

                Info yq = new Info();

                yq.setId(rs.getInt(1));

                yq.setDate(rs.getString(8));

                yq.setProvince(rs.getString(2));

                yq.setNewconfirmed_num(rs.getString(3));

                yq.setConfirmed_num(rs.getString(4));

                yq.setCured_num(rs.getString(6));

                yq.setDead_num(rs.getString(7));

                list.add(yq);

            }

        } catch (Exception e) {

            e.printStackTrace();

        } finally {

            try {

                conn.close();

            } catch (Exception e) {

                e.printStackTrace();

            }

        }

        return list;

    }

}

 

 

　　　Select.java（查询表中是否有今日数据从而判断是否删除.....现在发现根本不需要该方法，直接删除即可，不需要判断表中有没有数据）

 

package Dao;

import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.Statement;import java.util.ArrayList;import java.util.List;

import utils.DBUtil;

public class Select {

    public boolean select(String time) {

        // TODO Auto-generated method stub

        Connection conn=DBUtil.getConn();

        PreparedStatement pstmt = null;

        ResultSet rs = null;

        boolean b=false;

        String sql="select * from myinfo where date(Time) = ?";

        System.out.println(sql);

        try {

            pstmt = conn.prepareStatement(sql);

            pstmt.setString(1, time);

            rs = pstmt.executeQuery();

            while (rs.next()) {

                b=true;

            }

        } catch (Exception e) {

            e.printStackTrace();

        } finally {

            try {

                conn.close();

            } catch (Exception e) {

                e.printStackTrace();

            }

        }

        return b;

    }

}

 

 

　　　PaquServlet.java（这阶段新建的，专门用来接收移动端爬取请求的）

 

package Servlet;

import java.io.IOException;import java.sql.ResultSet;import java.sql.SQLException;import java.text.SimpleDateFormat;import java.util.Date;

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.DeleteService;import control.Paqu;import utils.DBUtil;

@WebServlet("/PaquServlet")//移动端爬取用到了该Servletpublic class PaquServlet extends HttpServlet {

    @Override

    protected void doGet(HttpServletRequest request, HttpServletResponse response)

            throws ServletException, IOException {

        doPost(request, response);

    }

    @Override

    protected void doPost(HttpServletRequest request, HttpServletResponse response)

            throws ServletException, IOException {

        System.out.println("request--->"+request.getRequestURL()+"===="+request.getParameterMap().toString());

        response.setContentType("text/html;charset=utf-8");

        Date currentTime=new Date();

        SimpleDateFormat formatter_date = new SimpleDateFormat("yyyy-MM-dd");

        String date=formatter_date.format(currentTime);

        DeleteService ds=new DeleteService();

        ds.delete("myinfo", date);

        Paqu pq=new Paqu();

        pq.refesh();

    }

}

 

 

　　SearchServlet.java（也是这阶段新建的，用来接收移动端的查找请求）

 

package Servlet;

import java.io.IOException;import java.sql.ResultSet;import java.sql.SQLException;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 com.google.gson.Gson;

import Bean.Info;import Dao.DeleteService;import Dao.Get;import Dao.Select;import control.Paqu;import utils.DBUtil;

@WebServlet("/SearchServlet")//移动端用到了该Servletpublic class SearchServlet extends HttpServlet {

    @Override

    protected void doGet(HttpServletRequest request, HttpServletResponse response)

            throws ServletException, IOException {

        doPost(request, response);

    }

    @Override

    protected void doPost(HttpServletRequest request, HttpServletResponse response)

            throws ServletException, IOException {

        System.out.println("request--->"+request.getRequestURL()+"===="+request.getParameterMap().toString());

        response.setContentType("text/html;charset=utf-8");

        String method = request.getParameter("method");

        String date1 = request.getParameter("username"); // 获取客户端传过来的参数，移动端的参数叫username与password，我没有修改，可以修改为易于理解的date1，date2，但移动端也要对应修改

        String date2 = request.getParameter("password");

        Get get=new Get();

        List<Info> list=null;

        if(method.equals("province")) {//查询中国省份疫情数据

            list = get.listAll(date1,date2); 

        }else

            if(method.equals("country")) {//查询海外疫情数据

                list = get.listAll2(date1, date2);

            }             

        request.setAttribute("list",list);

        Gson gson = new Gson();

        String json = gson.toJson(list);

        try {

            response.getWriter().println(json);

            // 将json数据传给客户端

        } catch (Exception e) {

            e.printStackTrace();

        } finally {

            response.getWriter().close(); // 关闭这个流，不然会发生错误的        }

    }

}

 

 

　　　YqSearch.java（前两个阶段中Web端使用的，移动端没有调用该Servlet）

 

package Servlet;

import java.io.IOException;import java.text.ParseException;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 com.google.gson.Gson;

import Bean.Info;import Dao.DeleteService;import Dao.Get;import Dao.Select;import control.Paqu;

/**

 * Servlet implementation class SearchConfirmedServlet

 */

@WebServlet("/YqServlet")public class YqServlet extends HttpServlet {

    private static final long serialVersionUID = 1L;

    Get get=new Get();

    /**

     * @see HttpServlet#HttpServlet()

     */

    public YqServlet() {

        super();

        // TODO Auto-generated constructor stub    }

    /**

     * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)

     */

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

        String method = request.getParameter("method");

        if(method.equals("getAllProvince")) {

            try {

                getAllProvince(request, response);

            } catch (ParseException e) {

                // TODO Auto-generated catch block                e.printStackTrace();

            }

        }else if(method.equals("getAllConfirmed")) {

            getAllConfirmed(request, response);

        }

    }

    /**

     * @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);

    }

    protected void getAllProvince(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException, ParseException {

        response.setCharacterEncoding("UTF-8");

        Select s=new Select();

        Date currentTime=new Date();

        SimpleDateFormat formatter_date = new SimpleDateFormat("yyyy-MM-dd");

        String date=formatter_date.format(currentTime);

        String date1 = request.getParameter("date1");

        String date2 = request.getParameter("date2");

        Date today=formatter_date.parse(date);//将现在的date转为日期，方便比较

        Date date22=formatter_date.parse(date2);//将date2转为日期，方便比较

        if(today.before(date22)) {//如果今天日期today比查询后边的date2日期早，需要用到今天的数据

            //不管数据库中有没有今天的数据，运行到这都需要重新爬取一遍，防止官方更新今日数据

            boolean b=s.select(date);//查找数据库中是否存在今天的数据.............黄色部分可删除，前面说到了，用不到查询判断表中是否有今日数据，直接删除就好，反正下面会重新爬取存到数据库

            if(b) {//如果有今日数据已存在，先删除

                DeleteService ds=new DeleteService();

                ds.delete("myinfo", date);

            }

            Paqu pq=new Paqu();//不管数据库是否存在今日数据都会爬取；如果存在，前面已经删除过了，这里的爬取就相当于更新了            pq.refesh();

        }        

        List<Info> list = get.listAll(date1,date2);

        request.setAttribute("list",list);

        request.setAttribute("date1",date1);

        request.setAttribute("date2",date2);

        request.getRequestDispatcher("bar.jsp").forward(request, response);

    }

    protected void getAllConfirmed(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

        response.setCharacterEncoding("UTF-8");

        String date1 = request.getParameter("date1");

        String date2 = request.getParameter("date2");

        System.out.println(date1);

        System.out.println(date2);

        List<Info> list = get.listAll(date1,date2);

        HttpSession session = request.getSession();

        session.setAttribute("list",list);

        Gson gson = new Gson();

        String json = gson.toJson(list);

        response.getWriter().write(json);

    }

}

 

 

　　DBUtil.java

 

package utils;

import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;

public class DBUtil {

    public static String db_url = "jdbc:mysql://localhost:3306/test?useSSL=false&characterEncoding=UTF-8&serverTimezone=GMT";//如果发布到云服务器就将localhost改为云服务器的ip    public static String db_user = "root";

    public static String db_pass = "root";

    public static Connection getConn () {

        Connection conn = null;

        try {

            Class.forName("com.mysql.cj.jdbc.Driver");

            conn = DriverManager.getConnection(db_url, db_user, db_pass);

        } catch (Exception e) {

            e.printStackTrace();

        }

        return conn;

    }

    public static void close (Statement state, Connection conn) {

        if (state != null) {

            try {

                state.close();

            } catch (SQLException e) {

                e.printStackTrace();

            }

        }

        if (conn != null) {

            try {

                conn.close();

            } catch (SQLException e) {

                e.printStackTrace();

            }

        }

    }

    public static void close (ResultSet rs, Statement state, Connection conn) {

        if (rs != null) {

            try {

                rs.close();

            } catch (SQLException e) {

                e.printStackTrace();

            }

        }

        if (state != null) {

            try {

                state.close();

            } catch (SQLException e) {

                e.printStackTrace();

            }

        }

        if (conn != null) {

            try {

                conn.close();

            } catch (SQLException e) {

                e.printStackTrace();

            }

        }

    }

}

 

 

　　index.jsp

 

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

    pageEncoding="UTF-8"%><!DOCTYPE html><html><head><meta charset="UTF-8"><meta name="viewport" content="width=device-width, initial-scale=1"><title>Insert title here</title><link href="${pageContext.request.contextPath }/bootstrap-3.3.7-dist/css/bootstrap.min.css"  rel="stylesheet"><script src="${pageContext.request.contextPath }/js/jquery-3.3.1.min.js"></script><script src="${pageContext.request.contextPath }/bootstrap-3.3.7-dist/js/bootstrap.min.js"></script>

<style type="text/css">

    .skyblue{

        background:skyblue;

    }

    .pink{

        background:pink;

    }

    *{

        margin:0px;

        padding:0px;

    }

    a{

        font-size:15px;

    }

    </style></head><body>

    <div class="container">

        <form action="YqServlet?method=getAllProvince" method="post">

            <div class="row" style="padding-top: 20px">

                <div class="col-xs-4">

                    <h4>起始时间：</h4>

                    <input type="text" class="form-control" name="date1">

                </div>

                <div class="col-xs-4">

                    <h4>终止时间：</h4>

                    <input type="text" class="form-control" name="date2">

                </div>

                <div class="col-xs-2">

                    <input type="submit" class="btn btn-default" value="查询">

                </div>

            </div>

        </form>

    </div></body></html>

 

 

　　bar.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>Insert title here</title><link href="${pageContext.request.contextPath }/bootstrap-3.3.7-dist/css/bootstrap.min.css"  rel="stylesheet"><script src="${pageContext.request.contextPath }/js/jquery.min.js"></script><script src="${pageContext.request.contextPath }/bootstrap-3.3.7-dist/js/bootstrap.min.js"></script><script type="text/javascript" src="${pageContext.request.contextPath }/js/echarts.min.js"></script></head><script type="text/javascript">var dt;function getAllConfirmed(){

    var date1 = "${date1}";

    var date2 = "${date2}";

$.ajax({

    url:"YqServlet?method=getAllConfirmed",

    async:false,

    type:"POST",

    data:{"date1":date1,

          "date2":date2

         },

    success:function(data){

        dt = data;

        //alert(dt);    },

    error:function(){

        alert("请求失败");

    },

    dataType:"json"

});

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

    var xd = new Array(0)//长度为33

    var yd = new Array(0)//长度为33

    for(var i=0;i<32;i++){

        xd.push(dt[i].province);

        yd.push(dt[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: 'bar',

                stack: '总量',

                data: yd,

                barWidth:20,

                barGap:'10%'

            }

        ]

    };

        // 使用刚指定的配置项和数据显示图表。        myChart.setOption(option);

}</script><body>

    <button class="btn btn-default" onclick="getAllConfirmed()" style="padding-top:20px;font-size:20px">柱状图</button>

    <div id="yiqingchart" style="width:900px; height: 600px;">

    </div>

    <table class="table table-striped" style="font-size:20px">

        <tr>

            <td>编号</td>

            <td>时间</td>

            <td>省份</td>

            <td>新增人数</td>

            <td>确诊人数</td>

            <td>治愈人数</td>

            <td>死亡人数</td>

        </tr>

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

        <tr>

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

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

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

            <td>${info.newconfirmed_num}</td>

            <td>${info.confirmed_num}</td>

            <td>${info.cured_num}</td>

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

        </tr>

        </c:forEach>

    </table></body></html>

 

　　3移动端

　　activity_main.xml

 

<?xml version="1.0" encoding="utf-8"?><LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"

    xmlns:tools="http://schemas.android.com/tools"

    android:id="@+id/activity_main"

    android:layout_width="match_parent"

    android:layout_height="match_parent"

    android:orientation="vertical"

    tools:context="com.example.testnet.MainActivity">

<!--    <EditText--><!--    android:id="@+id/et_data_uname"--><!--    android:layout_width="match_parent"--><!--    android:layout_height="wrap_content"--><!--    android:hint="请输入开始时间："--><!--    android:text="2020-03-18"/>-->

<!--    <EditText--><!--        android:id="@+id/et_data_upass"--><!--        android:layout_width="match_parent"--><!--        android:layout_height="wrap_content"--><!--        android:hint="请输入截止时间："--><!--        android:text="2020-03-19" />-->

    <TextView

        android:layout_width="match_parent"

        android:layout_height="60dp"

        android:text="请选择开始时间"

        android:textSize="50sp" />

    <DatePicker

        android:id="@+id/et_data_uname"

        android:layout_width="match_parent"

        android:layout_height="100dp"

        android:layout_margin="4dp"

        android:datePickerMode="spinner"

        android:calendarViewShown="false"/>

    <TextView

        android:layout_width="match_parent"

        android:layout_height="60dp"

        android:text="请选择截止时间"

        android:textSize="50sp" />

    <DatePicker

        android:id="@+id/et_data_upass"

        android:layout_width="match_parent"

        android:layout_height="100dp"

        android:layout_margin="4dp"

        android:datePickerMode="spinner"

        android:calendarViewShown="false"/>

    <Button

        android:layout_width="match_parent"

        android:layout_height="wrap_content"

        android:onClick="loginGet"

        android:text="爬取（只可获取当天数据）" />

    <Button

        android:layout_width="match_parent"

        android:layout_height="wrap_content"

        android:onClick="loginPOST"

        android:text="查询国内疫情信息" />

    <Button

        android:layout_width="match_parent"

        android:layout_height="wrap_content"

        android:onClick="loginPOST2"

        android:text="查询海外疫情信息" />

</LinearLayout>

 

 

　　content_main.xml（大的表单）

 

<?xml version="1.0" encoding="utf-8"?><LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"

    android:orientation="vertical" android:layout_width="match_parent"

    android:layout_height="match_parent">

    <LinearLayout

        android:layout_width="wrap_content"

        android:layout_height="50dp">

        <TextView

            android:layout_width="60dp"

            android:layout_height="wrap_content"

            android:layout_alignParentLeft="true"

            android:layout_marginLeft="10dp"

            android:ellipsize="marquee"

            android:gravity="center"

            android:singleLine="true"

            android:text="省份"

            android:textSize="20sp" />

        <TextView

            android:id="@+id/tv_date"

            android:layout_width="95dp"

            android:layout_height="wrap_content"

            android:text="时间"

            android:textSize="20sp" />

        <TextView

            android:id="@+id/tv_confirmed"

            android:layout_width="55dp"

            android:layout_height="80dp"

            android:text="确诊"

            android:textSize="15sp" />

        <TextView

            android:id="@+id/tv_cured"

            android:layout_width="55dp"

            android:layout_height="80dp"

            android:text="治愈"

            android:textSize="15sp" />

        <TextView

            android:id="@+id/tv_dead"

            android:layout_width="55dp"

            android:layout_height="80dp"

            android:text="死亡"

            android:textSize="15sp" />

        <TextView

            android:id="@+id/tv_new"

            android:layout_width="55dp"

            android:layout_height="80dp"

            android:text="新增"

            android:textSize="15sp" />

    </LinearLayout>

    <ListView

        android:layout_width="wrap_content"

        android:layout_height="wrap_content"

        android:id="@+id/lv_main"/></LinearLayout>

 

 

　　list_item.xml（显示具体的一条一条数据）

 

<?xml version="1.0" encoding="utf-8"?><LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"

    android:orientation="horizontal"

    android:layout_width="match_parent"

    android:layout_height="match_parent">

    <TextView

        android:id="@+id/tv_province"

        android:layout_width="60dp"

        android:layout_height="wrap_content"

        android:layout_alignParentLeft="true"

        android:layout_marginLeft="10dp"

        android:ellipsize="marquee"

        android:gravity="center"

        android:singleLine="true"

        android:text="省份"

        android:textSize="20sp" />

    <TextView

        android:id="@+id/tv_date"

        android:layout_width="95dp"

        android:layout_height="wrap_content"

        android:text="时间"

        android:textSize="15sp" />

    <TextView

        android:id="@+id/tv_confirmed"

        android:layout_width="55dp"

        android:layout_height="80dp"

        android:text="67799"

        android:textSize="20sp" />

    <TextView

        android:id="@+id/tv_cured"

        android:layout_width="55dp"

        android:layout_height="80dp"

        android:text="56002"

        android:textSize="20sp" />

    <TextView

        android:id="@+id/tv_dead"

        android:layout_width="55dp"

        android:layout_height="80dp"

        android:text="3"

        android:textSize="20sp" />

    <TextView

        android:id="@+id/tv_new"

        android:layout_width="55dp"

        android:layout_height="80dp"

        android:text="5"

        android:textSize="20sp" />

</LinearLayout>

 

 

 只需用到info和两个activity即可，另外两个用不到

　　Info.java

 

package com.example.testnet;

public class Info {

    private String id;

    private String city;

    private String yisi_num;

    private String date;

    private String province;

    private String confirmed_num;

    private String cured_num;

    private String dead_num;

    private String newconfirmed_num;

    public String getNewconfirmed_num() {

        return newconfirmed_num;

    }

    public void setNewconfirmed_num(String newconfirmed_num) {

        this.newconfirmed_num = newconfirmed_num;

    }

    public String  getId() {

        return id;

    }

    public void setId(String id) {

        this.id = id;

    }

    public String getCity() {

        return city;

    }

    public void setCity(String city) {

        this.city = city;

    }

    public String getYisi_num() {

        return yisi_num;

    }

    public void setYisi_num(String yisi_num) {

        this.yisi_num = yisi_num;

    }

    public String getDate() {

        return date;

    }

    public void setDate(String date) {

        this.date = date;

    }

    public String getProvince() {

        return province;

    }

    public void setProvince(String province) {

        this.province = province;

    }

    public String getConfirmed_num() {

        return confirmed_num;

    }

    public void setConfirmed_num(String confirmed_num) {

        this.confirmed_num = confirmed_num;

    }

    public String getCured_num() {

        return cured_num;

    }

    public void setCured_num(String cured_num) {

        this.cured_num = cured_num;

    }

    public String getDead_num() {

        return dead_num;

    }

    public void setDead_num(String dead_num) {

        this.dead_num = dead_num;

    }

}

 

 

　　MainActivity.java

 

package com.example.testnet;

import android.content.Intent;import android.os.Bundle;import android.util.Log;import android.view.View;import android.widget.DatePicker;

import androidx.appcompat.app.AppCompatActivity;

import java.io.ByteArrayOutputStream;import java.io.DataInputStream;import java.io.DataOutputStream;import java.io.File;import java.io.FileInputStream;import java.io.FileOutputStream;import java.io.IOException;import java.io.InputStream;import java.io.PrintWriter;import java.net.HttpURLConnection;import java.net.URL;import java.net.URLEncoder;import java.util.HashMap;

public class MainActivity extends AppCompatActivity {

    String TAG = MainActivity.class.getCanonicalName();//    private EditText et_data_uname;//    private EditText et_data_upass;

    private DatePicker et_data_uname;

    private DatePicker et_data_upass;

    private HashMap<String, String> stringHashMap;

    private String t;

    @Override

    protected void onCreate(Bundle savedInstanceState) {

        super.onCreate(savedInstanceState);

        setContentView(R.layout.activity_main);

        et_data_uname = (DatePicker) findViewById(R.id.et_data_uname);

        et_data_upass = (DatePicker) findViewById(R.id.et_data_upass);

        stringHashMap = new HashMap<>();

    }

    public void loginPOST(View view) {

        stringHashMap.put("username",et_data_uname.getYear()+"-"+(et_data_uname.getMonth()+1)+"-"+et_data_uname.getDayOfMonth());

        stringHashMap.put("password", et_data_upass.getYear()+"-"+(et_data_upass.getMonth()+1)+"-"+et_data_upass.getDayOfMonth());

        new Thread(postRun).start();

    }

    public void loginPOST2(View view) {

        stringHashMap.put("username",et_data_uname.getYear()+"-"+(et_data_uname.getMonth()+1)+"-"+et_data_uname.getDayOfMonth());

        stringHashMap.put("password", et_data_upass.getYear()+"-"+(et_data_upass.getMonth()+1)+"-"+et_data_upass.getDayOfMonth());

        new Thread(postRun2).start();

    }

    public void loginGet(View view) {

        stringHashMap.put("username", et_data_uname.getYear()+"-"+(et_data_uname.getMonth()+1)+"-"+et_data_uname.getDayOfMonth());

        stringHashMap.put("password", et_data_upass.getYear()+"-"+(et_data_upass.getMonth()+1)+"-"+et_data_upass.getDayOfMonth());

        new Thread(getRun).start();

    }

    /**

     * get请求线程

     */

    Runnable getRun = new Runnable() {

        @Override

        public void run() {

            // TODO Auto-generated method stub            requestGet(stringHashMap);

        }

    };

    /**

     * post请求线程

     */

    Runnable postRun = new Runnable() {

        @Override

        public void run() {

            // TODO Auto-generated method stub            requestPost(stringHashMap);

        }

    };

    Runnable postRun2 = new Runnable() {

        @Override

        public void run() {

            // TODO Auto-generated method stub            requestPost2(stringHashMap);

        }

    };

    /**

     * get提交数据

     *

     * @param paramsMap

     */

    private void requestGet(HashMap<String, String> paramsMap) {

        try {

            String baseUrl = "http://10.0.2.2:8080/YiQing/PaquServlet?";//如果发布到云端，将黄色部分修改为云服务器ip

            StringBuilder tempParams = new StringBuilder();

            int pos = 0;

            for (String key : paramsMap.keySet()) {

                if (pos > 0) {

                    tempParams.append("&");

                }

                tempParams.append(String.format("%s=%s", key, URLEncoder.encode(paramsMap.get(key), "utf-8")));

                pos++;

            }

            Log.e(TAG,"params--get-->>"+tempParams.toString());

            String requestUrl = baseUrl + tempParams.toString();

            // 新建一个URL对象

            URL url = new URL(requestUrl);

            // 打开一个HttpURLConnection连接

            HttpURLConnection urlConn = (HttpURLConnection) url.openConnection();

            // 设置连接主机超时时间

            urlConn.setConnectTimeout(5 * 1000);

            //设置从主机读取数据超时

            urlConn.setReadTimeout(5 * 1000);

            // 设置是否使用缓存  默认是true

            urlConn.setUseCaches(true);

            // 设置为Post请求

            urlConn.setRequestMethod("GET");

            //urlConn设置请求头信息

            //设置请求中的媒体类型信息。

            urlConn.setRequestProperty("Content-Type", "application/json");

            //设置客户端与服务连接类型

            urlConn.addRequestProperty("Connection", "Keep-Alive");

            // 开始连接            urlConn.connect();

            // 判断请求是否成功

            if (urlConn.getResponseCode() == 200) {

                // 获取返回的数据

                String result = streamToString(urlConn.getInputStream());

                Log.e(TAG, "Get方式请求成功，result--->" + result);

            } else {

                Log.e(TAG, "Get方式请求失败");

            }

            // 关闭连接            urlConn.disconnect();

        } catch (Exception e) {

            Log.e(TAG, e.toString());

        }

    }

    /**

     * post提交数据

     *

     * @param paramsMap

     */

    private void requestPost(HashMap<String, String> paramsMap) {

        try {

            String baseUrl = "http://10.0.2.2:8080/YiQing/SearchServlet?method=province";//如若发布到云端，将黄色部分修改为云端ip             //合成参数

            StringBuilder tempParams = new StringBuilder();

            int pos = 0;

            for (String key : paramsMap.keySet()) {

                if (pos >0) {

                    tempParams.append("&");

                }

                tempParams.append(String.format("%s=%s", key, URLEncoder.encode(paramsMap.get(key), "utf-8")));

                pos++;

            }

            String params = tempParams.toString();

            Log.e(TAG,"params--post-->>"+params);

            // 请求的参数转换为byte数组//            byte[] postData = params.getBytes();

            // 新建一个URL对象

            URL url = new URL(baseUrl);

            // 打开一个HttpURLConnection连接

            HttpURLConnection urlConn = (HttpURLConnection) url.openConnection();

            // 设置连接超时时间

            urlConn.setConnectTimeout(5 * 1000);

            //设置从主机读取数据超时

            urlConn.setReadTimeout(5 * 1000);

            // Post请求必须设置允许输出 默认false

            urlConn.setDoOutput(true);

            //设置请求允许输入 默认是true

            urlConn.setDoInput(true);

            // Post请求不能使用缓存

            urlConn.setUseCaches(false);

            // 设置为Post请求

            urlConn.setRequestMethod("POST");

            //设置本次连接是否自动处理重定向

            urlConn.setInstanceFollowRedirects(true);

            //配置请求Content-Type//            urlConn.setRequestProperty("Content-Type", "application/json");//post请求不能设置这个

            // 开始连接            urlConn.connect();

            // 发送请求参数

            PrintWriter dos = new PrintWriter(urlConn.getOutputStream());

            dos.write(params);

            dos.flush();

            dos.close();

            // 判断请求是否成功

            if (urlConn.getResponseCode() == 200) {

                // 获取返回的数据

                String result = streamToString(urlConn.getInputStream());

                Log.e(TAG, "Post方式请求成功，result--->" + result);

                t=result;

                Intent intent = new Intent(MainActivity.this,MainActivity2.class);

                System.out.println(t);

                intent.putExtra("data",t);

                startActivity(intent);

            } else {

                Log.e(TAG, "Post方式请求失败");

            }

            // 关闭连接            urlConn.disconnect();

        } catch (Exception e) {

            Log.e(TAG, e.toString());

        }

    }

    private void requestPost2(HashMap<String, String> paramsMap) {

        try {

            String baseUrl = "http://10.0.2.2:8080/YiQing/SearchServlet?method=country";//如若发布到云端，将黄色部分修改为云端ip            //合成参数

            StringBuilder tempParams = new StringBuilder();

            int pos = 0;

            for (String key : paramsMap.keySet()) {

                if (pos >0) {

                    tempParams.append("&");

                }

                tempParams.append(String.format("%s=%s", key, URLEncoder.encode(paramsMap.get(key), "utf-8")));

                pos++;

            }

            String params = tempParams.toString();

            Log.e(TAG,"params--post-->>"+params);

            // 请求的参数转换为byte数组//            byte[] postData = params.getBytes();

            // 新建一个URL对象

            URL url = new URL(baseUrl);

            // 打开一个HttpURLConnection连接

            HttpURLConnection urlConn = (HttpURLConnection) url.openConnection();

            // 设置连接超时时间

            urlConn.setConnectTimeout(5 * 1000);

            //设置从主机读取数据超时

            urlConn.setReadTimeout(5 * 1000);

            // Post请求必须设置允许输出 默认false

            urlConn.setDoOutput(true);

            //设置请求允许输入 默认是true

            urlConn.setDoInput(true);

            // Post请求不能使用缓存

            urlConn.setUseCaches(false);

            // 设置为Post请求

            urlConn.setRequestMethod("POST");

            //设置本次连接是否自动处理重定向

            urlConn.setInstanceFollowRedirects(true);

            //配置请求Content-Type//            urlConn.setRequestProperty("Content-Type", "application/json");//post请求不能设置这个

            // 开始连接            urlConn.connect();

            // 发送请求参数

            PrintWriter dos = new PrintWriter(urlConn.getOutputStream());

            dos.write(params);

            dos.flush();

            dos.close();

            // 判断请求是否成功

            if (urlConn.getResponseCode() == 200) {

                // 获取返回的数据

                String result = streamToString(urlConn.getInputStream());

                Log.e(TAG, "Post方式请求成功，result--->" + result);

                t=result;

                Intent intent = new Intent(MainActivity.this,MainActivity2.class);

                System.out.println(t);

                intent.putExtra("data",t);

                startActivity(intent);

            } else {

                Log.e(TAG, "Post方式请求失败");

            }

            // 关闭连接            urlConn.disconnect();

        } catch (Exception e) {

            Log.e(TAG, e.toString());

        }

    }

    /**

     * 将输入流转换成字符串

     *

     * @param is 从网络获取的输入流

     * @return

     */

    public String streamToString(InputStream is) {

        try {

            ByteArrayOutputStream baos = new ByteArrayOutputStream();

            byte[] buffer = new byte[1024];

            int len = 0;

            while ((len = is.read(buffer)) != -1) {

                baos.write(buffer, 0, len);

            }

            baos.close();

            is.close();

            byte[] byteArray = baos.toByteArray();

            return new String(byteArray);

        } catch (Exception e) {

            Log.e(TAG, e.toString());

            return null;

        }

    }

    /**

     * 文件下载

     *

     * @param fileUrl

     */

    private void downloadFile(String fileUrl) {

        try {

            // 新建一个URL对象

            URL url = new URL(fileUrl);

            // 打开一个HttpURLConnection连接

            HttpURLConnection urlConn = (HttpURLConnection) url.openConnection();

            // 设置连接主机超时时间

            urlConn.setConnectTimeout(5 * 1000);

            //设置从主机读取数据超时

            urlConn.setReadTimeout(5 * 1000);

            // 设置是否使用缓存  默认是true

            urlConn.setUseCaches(true);

            // 设置为Post请求

            urlConn.setRequestMethod("GET");

            //urlConn设置请求头信息

            //设置请求中的媒体类型信息。

            urlConn.setRequestProperty("Content-Type", "application/json");

            //设置客户端与服务连接类型

            urlConn.addRequestProperty("Connection", "Keep-Alive");

            // 开始连接            urlConn.connect();

            // 判断请求是否成功

            if (urlConn.getResponseCode() == 200) {

                String filePath = "";//下载文件保存在本地的地址

                File descFile = new File(filePath);

                FileOutputStream fos = new FileOutputStream(descFile);

                ;

                byte[] buffer = new byte[1024];

                int len;

                InputStream inputStream = urlConn.getInputStream();

                while ((len = inputStream.read(buffer)) != -1) {

                    // 写到本地

                    fos.write(buffer, 0, len);

                }

            } else {

                Log.e(TAG, "文件下载失败");

            }

            // 关闭连接            urlConn.disconnect();

        } catch (Exception e) {

            Log.e(TAG, e.toString());

        }

    }

    /**

     * 文件上传

     *

     * @param filePath

     * @param paramsMap

     */

    private void upLoadFile(String filePath, HashMap<String, String> paramsMap) {

        try {

            String baseUrl = "http://xxx.com/uploadFile";

            File file = new File(filePath);

            //新建url对象

            URL url = new URL(baseUrl);

            //通过HttpURLConnection对象,向网络地址发送请求

            HttpURLConnection urlConn = (HttpURLConnection) url.openConnection();

            //设置该连接允许读取

            urlConn.setDoOutput(true);

            //设置该连接允许写入

            urlConn.setDoInput(true);

            //设置不能适用缓存

            urlConn.setUseCaches(false);

            //设置连接超时时间

            urlConn.setConnectTimeout(5 * 1000);   //设置连接超时时间

            //设置读取超时时间

            urlConn.setReadTimeout(5 * 1000);   //读取超时

            //设置连接方法post

            urlConn.setRequestMethod("POST");

            //设置维持长连接

            urlConn.setRequestProperty("connection", "Keep-Alive");

            //设置文件字符集

            urlConn.setRequestProperty("Accept-Charset", "UTF-8");

            //设置文件类型

            urlConn.setRequestProperty("Content-Type", "multipart/form-data; boundary=" + "*****");

            String name = file.getName();

            DataOutputStream requestStream = new DataOutputStream(urlConn.getOutputStream());

            requestStream.writeBytes("--" + "*****" + "\r\n");

            //发送文件参数信息

            StringBuilder tempParams = new StringBuilder();

            tempParams.append("Content-Disposition: form-data; name=\"" + name + "\"; filename=\"" + name + "\"; ");

            int pos = 0;

            int size = paramsMap.size();

            for (String key : paramsMap.keySet()) {

                tempParams.append(String.format("%s=\"%s\"", key, paramsMap.get(key), "utf-8"));

                if (pos < size - 1) {

                    tempParams.append("; ");

                }

                pos++;

            }

            tempParams.append("\r\n");

            tempParams.append("Content-Type: application/octet-stream\r\n");

            tempParams.append("\r\n");

            String params = tempParams.toString();

            requestStream.writeBytes(params);

            //发送文件数据

            FileInputStream fileInput = new FileInputStream(file);

            int bytesRead;

            byte[] buffer = new byte[1024];

            DataInputStream in = new DataInputStream(new FileInputStream(file));

            while ((bytesRead = in.read(buffer)) != -1) {

                requestStream.write(buffer, 0, bytesRead);

            }

            requestStream.writeBytes("\r\n");

            requestStream.flush();

            requestStream.writeBytes("--" + "*****" + "--" + "\r\n");

            requestStream.flush();

            fileInput.close();

            int statusCode = urlConn.getResponseCode();

            if (statusCode == 200) {

                // 获取返回的数据

                String result = streamToString(urlConn.getInputStream());

                Log.e(TAG, "上传成功，result--->" + result);

            } else {

                Log.e(TAG, "上传失败");

            }

        } catch (IOException e) {

            Log.e(TAG, e.toString());

        }

    }

}

 

 

　　MainActivity2.java（当点击查询后，会从MainActivity跳转到该MainActivity2）　　

 

package com.example.testnet;

import android.content.Intent;import android.os.Bundle;import android.widget.ListView;import android.widget.SimpleAdapter;

import androidx.appcompat.app.AppCompatActivity;

import org.json.JSONArray;import org.json.JSONException;import org.json.JSONObject;

import java.util.ArrayList;import java.util.HashMap;import java.util.List;import java.util.Map;

public class MainActivity2 extends AppCompatActivity {

    private List<Info> list ;

    private YqAdapter mAdapter;

    Info yq=new Info();

    int n=0;

    @Override

    protected void onCreate(Bundle savedInstanceState) {

        super.onCreate(savedInstanceState);

        setContentView(R.layout.content_main);

        Intent m =getIntent();

        String result=m.getStringExtra("data");

        List<Map<String, Object>> listitem = new ArrayList<Map<String, Object>>();

        String[] province=new String[1000];

        String[] date=new String[1000];

        String[] now=new String[1000];

        String[] cured=new String[1000];

        String[] dead=new String[1000];

        String[] today=new String[1000];

        try {

            JSONArray json = new JSONArray(result);

            for (int i = 0;i<json.length();i++){

                JSONObject jb=json.getJSONObject(i);

                date[i]=jb.getString("date");

                province[i]=jb.getString("province");

                now[i]=jb.getString("confirmed_num");

                cured[i]=jb.getString("cured_num");

                dead[i]=jb.getString("dead_num");

                today[i]=jb.getString("newconfirmed_num");

                n=i+1;

            }

        } catch (JSONException e) {

            e.printStackTrace();

        }

        for (int i = 0; i <n; i++)

        {

            Map<String,Object> map = new HashMap<String, Object>();

            map.put("province",province[i]);

            map.put("date",date[i]);

            map.put("now",now[i]);

            map.put("cured",cured[i]);

            map.put("dead",dead[i]);

            map.put("today",today[i]);

            listitem.add(map);

        }//        for (int i=0;i<n;i++){//            System.out.println(province[i]);//        }

        SimpleAdapter adapter = new SimpleAdapter(this

                , listitem

                , R.layout.list_item

                , new String[]{"province","date","now","cured","dead","today"}

                ,new int[]{R.id.tv_province,R.id.tv_date,R.id.tv_confirmed,R.id.tv_cured,R.id.tv_dead,R.id.tv_new});

        ListView listView =(ListView) findViewById(R.id.lv_main);

        listView.setAdapter(adapter);

    }

}

 

4、移动端与Web端的交互（上面的代码已经实现了交互）

　　移动端只是向Web端发送请求，调用相应的Servlet，一些复杂的运算还是ecplise中进行完成的。

　　刚开始可以参考该篇博客了解交互过程https://blog.csdn.net/qq_34317125/article/details/80533685

5、云服务器配置与部署

　　可以参考我的另一篇博客https://www.cnblogs.com/xhj1074376195/p/12318178.html 

　　新获得的云服务要像一台新电脑一样，同样需要下载配置jdk，mysql，Tomcat....

6、运行测试结果

　　Web端

 

 

 　　移动端

 

7、开发过程中出现的问题　

　　1.在Android Studio中将localhost：8080修改为云端服务器ip时，没有把:8080去掉,导致连接不上云端服务器。

　　2.Listview的布局中，没有弄清楚绑定的是哪一个页面，导致一直报空指针，应该修改为ListView控件所在的xml页面。

　　3.在AndroidMainifresh.xml中添加联网设置

<uses-permission android:name="android.permission.INTERNET" />

　　4.新建一个MainActivity2.java之后，在AndroidMainifest.xml中添加Activity活动

<activity android:name=".MainActivity2"/>

　　5.在虚拟机上可以正常运行，但打包apk至真机无法运行，请教同学以及百度后得知，Android 9.0之后 的应用程序，将要求默认使用加密连接，这意味着 Android P(9.0) 将禁止 App 使用所有未加密的连接，因此运行 Android P(9.0) 系统的安卓设备无论是接收或者发送流量，未来都不能明码传输，需要使用下一代(Transport Layer Security)传输层安全协议，而 Android Nougat 和 Oreo 则不受影响。简单来说就是，系统为了安全起见，Android 9.0之后禁止使用不加密的连接。解决办法，在AndroidMainifresh.xml中<application></application>下添加语句允许不加密连接

        android:usesCleartextTraffic="true"