正文
移动端与Web端疫情数据展示
提示：扫一扫查出行【扫一扫了解最新限行尾号】
复制提示
1、题目要求
2、整体思想
首先是在前两阶段已经完成的echarts可视化、利用Jsoup爬取疫情数据基础上来进行调用与完善。大致思想是在Android Studio上完成交互去调用ecplise中的Servlet，我新建了两个Servlet为PaquServlet、SearchServlet分别用来接受进行移动端的请求，与Web端的YqServlet分开来，当然也可以不新建Servlet直接调用Web端的YqServlet也是可以的。PaquServlet就是接收到移动端的调用之后开始执行，爬取疫情数据。SearchServlet当接收到移动端的请求调用后开始执行查找功能，这里我分为了两个方法，一个用来查找国内疫情数据，另一个用来查找海外的数据。而国内与海外都存放在同一个数据库表中，所以我又在数据库表中添加了一个Kind的栏位，里面的值为1或2，爬取数据的时候，国内与海外的数据分开爬取，国内的数据Kind等于1，海外的数据Kind等于2，这样查询国内或海外的数据的时候就就方便了，SearchServlet中返回的json数据在Android Studio中解析出来后，我利用的是哈希表来完成分配数据的，使用的是LinearLayout中ListView布局，由于对Android Studio的不熟悉，解析与显示数据以及布局也是在开发过程中最让我头疼的一部分了。 注意：本文采用的是ecplise与Android Studio交互远程连接数据库，Android Studio上面并没有直接连取数据库
3、代码实现
3.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")//移动端爬取用到了该Servlet
public 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")//移动端用到了该Servlet
public 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.2 移动端
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"
8、PSP0级时间记录日志
9、资源分享
项目所需要的jar包 链接：https://pan.baidu.com/s/1z4eqP3Gpa0EqudogM-a-lw 提取码：tr06
疫情数据显示Web端源代码已上传至GitHub https://github.com/xhj1074376195/YiQing_Web
疫情数据显示移动端源代码已上传至GitHub https://github.com/xhj1074376195/YiQing_App
