使用Android显示疫情信息

问题描述

　　

 

 

 问题分析

　　把数据通过服务器端发布，后由移动端接收数据并显示。

源码

　　python爬虫部分

　　

# author: pjh time: 2020/3/18
# coding=utf-8
import pymysql
import requests
import json

url = "https://c.m.163.com/ug/api/wuhan/app/data/list-total?t=316765403234"
header = {"user-agent": "Mozilla/5.0 (Linux; Android 8.0.0; Pixel 2 XL Build/OPD1.170816.004) AppleWebKit/537.36 ("
                        "KHTML, like Gecko) Chrome/80.0.3987.116 Mobile Safari/537.36"}
response = requests.get(url, headers=header)
mydir = json.loads(response.content.decode())
# 数据库的连接
db = pymysql.connect(host='localhost', port=3306, user='root', passwd='123456', db='yiqing', charset='utf8')
# 使用cursor方法创建一个游标
cursor = db.cursor()
for item in mydir['data']['areaTree']:
    name = item['name']
    confirm = item['total']['confirm']
    severe = item['total']['severe']
    heal = item['total']['heal']
    dead = item['total']['dead']
    suspect = item['total']['suspect']
    idcode = item['id']
    lastUpdateTime = item['lastUpdateTime']
    # 插入数据
    # sql = "insert into global(id,name,confirm,suspect,heal,dead,severe,idcode,lastupdatetime) values ({},'{}'," \
    #       "'{}','{}','{}','{}','{}','{}','{}');".format(
    #     0, name, confirm, suspect, heal, dead, severe, idcode, lastUpdateTime)

    # 更新数据
    sql = "update global set name='{}' confirm='{}',suspect='{}',heal='{}',dead='{}',severe='{}',lastupdatetime='{}'" \
          " where idcode='{}'".format(name, confirm, suspect, heal, dead, severe, lastUpdateTime, idcode)
    print(sql)
    cursor.execute(sql)
    db.commit()

 

　　服务器端发布的servlet部分

　　

package com.pjh.servlet;

import java.io.IOException;
import java.io.PrintWriter;

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.pjh.DBUtils.DBUtils;

/**
 * Servlet implementation class sendDataServlet
 */
@WebServlet("/sendDataServlet")
public class sendDataServlet extends HttpServlet {
    private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public sendDataServlet() {
        super();
        // TODO Auto-generated constructor stub
    }

    /**
     * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        response.setContentType("text/html;charset=utf-8");
        request.setCharacterEncoding("utf-8");
        response.setCharacterEncoding("utf-8");
        PrintWriter out = response.getWriter();
        String date = request.getParameter("date");
        System.out.println(date);
        String result = DBUtils.queryGlobalLatestDataByDate2(date).toString();
        out.write(result);
        out.flush();
        out.close();
    }

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

}

　　Android部分的代码

　　在AndroidManifest.xml中添加两句代码用于联网：

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

　　activity_main.xml

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:orientation="vertical"
    android:id="@+id/activity_main"
    android:gravity="center_horizontal">

    <EditText
        android:id="@+id/query_date"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:ems="10"
        android:inputType="textPersonName"
        android:text=""/>
    <Button
        android:id="@+id/send_request"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="查询"/>

    <ListView
        android:layout_width="match_parent"
        android:layout_height="match_parent">

        <TextView
            android:id="@+id/response_data"
            android:layout_width="match_parent"
            android:layout_height="wrap_content"
            />
    </ListView>
</LinearLayout>

　　MainActivity.java

package com.example.yiqing;

import androidx.appcompat.app.AppCompatActivity;

import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.TextView;

import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.net.HttpURLConnection;
import java.net.MalformedURLException;
import java.net.ProtocolException;
import java.net.URL;

public class MainActivity extends AppCompatActivity {

    private TextView textView;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        findViewById(R.id.send_request).setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                sendData();
            }
        });

        textView = (TextView) findViewById(R.id.response_data);
    }

    private void sendData() {
        //开启线程，发送请求
        new Thread(new Runnable() {
            @Override
            public void run() {
                HttpURLConnection connection = null;
                BufferedReader reader = null;
                try {
//                    EditText editText = findViewById(R.id.query_date);
//                    String date = editText.getText().toString();
                    URL url = new URL("http://10.0.2.2:8086/yiqing/sendDataServlet?date=2020-03-18");
//                    URL url = new URL("http://www.163.com");
                    connection = (HttpURLConnection) url.openConnection();
                    //设置请求方法
                    connection.setRequestMethod("GET");
                    //设置连接超时时间（毫秒）
                    connection.setConnectTimeout(5000);
                    //设置读取超时时间（毫秒）
                    connection.setReadTimeout(5000);

                    //返回输入流
                    InputStream in = connection.getInputStream();

                    //读取输入流
                    reader = new BufferedReader(new InputStreamReader(in));
                    StringBuilder result = new StringBuilder();
                    String line;
                    while ((line = reader.readLine()) != null) {
                        result.append(line);
                    }
                    show(result.toString());
                } catch (MalformedURLException e) {
                    e.printStackTrace();
                } catch (ProtocolException e) {
                    e.printStackTrace();
                } catch (IOException e) {
                    e.printStackTrace();
                } finally {
                    if (reader != null) {
                        try {
                            reader.close();
                        } catch (IOException e) {
                            e.printStackTrace();
                        }
                    }
                    if (connection != null) {//关闭连接
                        connection.disconnect();
                    }
                }
            }
        }).start();

    }

    private void show(final String result) {
        runOnUiThread(new Runnable() {
            @Override
            public void run() {
                    textView.setText(result);
            }
        });
    }
}