体温上报APP——打印

对于展示的信息要求可以实现按照样表自动从数据库中生成个人14天健康记录表。

EchartActivity.java文件：

package com.example.application;

import android.content.Intent;
import android.net.Uri;
import android.os.Bundle;
import android.webkit.WebView;
import android.webkit.WebViewClient;

import androidx.appcompat.app.AppCompatActivity;

public class EchartActivity extends AppCompatActivity {
    private WebView chartshow_web;
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_echart);

        chartshow_web=(WebView)findViewById(R.id.chartshow_web);
        chartshow_web.getSettings().setAllowFileAccess(true);
        chartshow_web.getSettings().setJavaScriptEnabled(true);
        chartshow_web.loadUrl("file:///android_asset/echart.html");



        new Thread(new Runnable() {
            @Override
            public void run() {
                try{
                    Thread.sleep(2000);
                } catch (InterruptedException e){
                    e.printStackTrace();
                }
            }
        }).start();
    }


}

OutActivity.java文件：

package com.example.application;

import android.content.Context;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Build;
import android.os.Environment;
import androidx.appcompat.app.AppCompatActivity;
import java.io.File;
import java.util.ArrayList;
import java.util.Calendar;
import android.os.Bundle;

import android.view.View;
import android.widget.TextView;
import android.widget.Toast;

import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;


public class OutActivity extends AppCompatActivity {
    public static WritableFont arial12font = null;
    public static WritableCellFormat arial12format = null;
    public static WritableFont arial12font_ = null;
    public static WritableCellFormat arial12format_ = null;
    public static WritableFont arial12font_1 = null;
    public static WritableCellFormat arial12format_1 = null;
    public static WritableFont arial18font = null;
    public static WritableCellFormat arial18format = null;
    public final static String UTF8_ENCODING = "UTF-8";
    public final static String GBK_ENCODING = "GBK";


    private ArrayList<ArrayList<String>> recordList;
    private DatabaseHelper myHelper;
    public SQLiteDatabase db;
    private String username;
    private TextView tv_pass;
    private String where="石家庄铁道大学";
    private Calendar cal;
    private String year;
    private String month;
    private String day;
    private String date;
    private String ID;
    private String phone;

    private static String[] title = { "日期","每日体温","健康状况","当日所在地","备注" };
    private File file;
    private String fileName;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_out);
        //模拟数据集合
        tv_pass=(TextView)findViewById(R.id.out_path) ;
        Intent intent=getIntent();
        username=intent.getStringExtra("user_name");

        myHelper=new DatabaseHelper(this);
        db=myHelper.getWritableDatabase();
        getTime();

        Cursor cursor = db.query("ALL_information", null, "name = ?", new String[]{username}, null, null, null);//读取数据库所有信息
        if(cursor.moveToFirst()){
                ID=cursor.getString(cursor.getColumnIndex("ID"));
                phone=cursor.getString(cursor.getColumnIndex("phone"));
        }
        cursor.close();

        recordList=new ArrayList<ArrayList<String>>();
    }

    private void getTime() {
        cal = Calendar.getInstance();
        year = String.valueOf(cal.get(Calendar.YEAR));
        month = String.valueOf(cal.get(Calendar.MONTH)+ 1) ;
        day = String.valueOf(cal.get(Calendar.DATE));
        date = year + "年" + month + "月" + day + "日";
    }
    /**
     * 导出excel
     * @param view
     */
    public void exportExcel(View view) {
        file = new File(getSDPath(this)+"/Record");
        makeDir(file);
        initExcel(file.toString() + "/体温登记表.xls");
        fileName = getSDPath(this) + "/Record/体温登记表.xls";
        tv_pass.setText("Excel表格已导出至："+fileName);
    }
    public static void format() {
        try {
            arial12font = new WritableFont(WritableFont.createFont("宋体"), 12);
            arial12format = new WritableCellFormat(arial12font);
            arial12format.setBorder(jxl.format.Border.ALL, jxl.format.BorderLineStyle.THIN);

            arial12font_ = new WritableFont(WritableFont.createFont("楷体"), 12,WritableFont.BOLD);
            arial12format_ = new WritableCellFormat(arial12font_);
            arial12format_.setBorder(jxl.format.Border.ALL, jxl.format.BorderLineStyle.THIN);

            arial12font_1 = new WritableFont(WritableFont.createFont("黑体"), 12);
            arial12format_1 = new WritableCellFormat(arial12font_1);
            arial12format_1.setBorder(jxl.format.Border.ALL, jxl.format.BorderLineStyle.THIN);
            arial12format_1.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);
            arial12format_1.setWrap(true);

            arial18font = new WritableFont(WritableFont.createFont("宋体"), 18,WritableFont.BOLD);
            arial18format = new WritableCellFormat(arial18font);
            arial18format.setAlignment(jxl.format.Alignment.CENTRE);//对齐格式
            arial18format.setBorder(jxl.format.Border.ALL,jxl.format.BorderLineStyle.THIN); //设置边框
        }
        catch (WriteException e) {
            e.printStackTrace();
        }

    }

    public void initExcel(String fileName) {
            format();
            WritableWorkbook workbook = null;

            try {
                File file = new File(fileName);
                if (!file.exists()) {
                    file.createNewFile();
                }
                workbook = Workbook.createWorkbook(file);
                WritableSheet sheet = workbook.createSheet("体温登记表", 0);
                sheet.mergeCells(0,0,6,0);
                Label header = new Label(0,0,"学生14天健康情况登记表",arial18format);
                sheet.addCell(header);
                sheet.mergeCells(0,1,3,1);
                sheet.addCell(new Label(0,1,"单位名称："+where,arial12format_));

                sheet.mergeCells(4,1,6,1);
                sheet.addCell(new Label(4,1,"填表日期："+date,arial12format_));

                sheet.addCell(new Label(0,2,"姓名",arial12format));
                sheet.addCell(new Label(1,2,username,arial12format));
                sheet.mergeCells(1,2,3,2);
                sheet.addCell(new Label(4,2,"学号：",arial12format));
                sheet.addCell(new Label(5,2,ID,arial12format));
                sheet.mergeCells(5,2,6,2);
                sheet.addCell(new Label(0,3,"目前健康状况：",arial12format));
                sheet.mergeCells(1,3,3,3);
                sheet.addCell(new Label(1,3,"正常",arial12format));
                sheet.addCell(new Label(4,3,"手机号",arial12format));
                sheet.addCell(new Label(5,3,phone,arial12format));
                sheet.mergeCells(5,3,6,3);
                sheet.mergeCells(0,4,6,4);
                sheet.addCell(new Label(0,4,"每日体温、健康状况监测（周期14天）",arial18format));
                String [] colName = {"日期","每日体温℃","健康状况","当日所在地","备注"};
                sheet.mergeCells(3,5,4,5);
                sheet.mergeCells(5,5,6,5);
                for (int col=0;col<3;col++){
                    sheet.addCell(new Label(col, 5, colName[col],arial12format));
                }
                sheet.addCell(new Label(3, 5, colName[3],arial12format));
                sheet.addCell(new Label(5, 5, colName[4],arial12format));

                int j=6;

                Cursor cursor2 = db.query("ALL_information", null, "name=?", new String[]{username}, null, null, null);//读取数据库所有信息
                // Cursor cursor=db.query("tt",null,"专业=?",new String[]{"软件工程"},
                //null,null,null);//读取数据库里面专业是软件工程的所有信息
                if(cursor2.moveToFirst()){
                    do{
                        String date=cursor2.getString(cursor2.getColumnIndex("date"));
                        String temperature=cursor2.getString(cursor2.getColumnIndex("temperature"));
                        String situation=cursor2.getString(cursor2.getColumnIndex("situation"));
                        String location=cursor2.getString(cursor2.getColumnIndex("location"));
                        String tip=cursor2.getString(cursor2.getColumnIndex("tip"));


                        sheet.addCell(new Label(0,j,date,arial12format));
                        sheet.addCell(new Label(1,j,temperature,arial12format));
                        double k = Double.parseDouble(temperature);
                        if (k < 37.3 &&k > 35) {
                            sheet.addCell(new Label(2,j,"正常",arial12format));
                        } else {
                            sheet.addCell(new Label(2,j,"异常",arial12format));
                        }
                        sheet.mergeCells(3,j,4,j);
                        sheet.addCell(new Label(3,j,location,arial12format));
                        sheet.mergeCells(5,j,6,j);
                        sheet.addCell(new Label(5,j,situation+tip,arial12format));
                        j++;
                    }while (cursor2.moveToNext());
                }
                cursor2.close();

                sheet.mergeCells(0,20,6,23);
                sheet.addCell(new Label(0,20,"本人承诺：自觉履行疫情防控责任和义务，保证以上填报信息全部属实，如有隐瞒，自愿承担相应法律后果。",arial12format_1));
                sheet.mergeCells(0,24,3,24);
                sheet.addCell(new Label(0,24,"本人签字：",arial12format));
                sheet.mergeCells(4,24,6,24);
                sheet.addCell(new Label(4,24,"签字日期：",arial12format));
                //sheet.mergeCells(5,24,6,24);
                workbook.write();
                workbook.close();
                Toast.makeText(this, "保存成功", Toast.LENGTH_SHORT).show();

            }
            catch (Exception e) {
                e.printStackTrace();
            }
            finally {
                if (workbook != null) {
                    try {
                        workbook.close();
                    }
                    catch (Exception e) {
                        // TODO Auto-generated catch block
                        e.printStackTrace();
                    }
                }
            }
        }


    /**
     * 将数据集合 转化成ArrayList<ArrayList<String>>
     * @return
     */


    public static String getSDPath(Context context) {
        File sdDir = null;
        boolean sdCardExist = Environment.getExternalStorageState().equals(
                Environment.MEDIA_MOUNTED);// 判断sd卡是否存在

        if (sdCardExist) {
            if (Build.VERSION.SDK_INT>=29){
                //Android10之后
                sdDir = context.getExternalFilesDir(null);
            }else {
                sdDir = Environment.getExternalStorageDirectory();// 获取SD卡根目录

            }
        } else {
            sdDir = Environment.getRootDirectory();// 获取跟目录
        }
        return sdDir.toString();
    }

    public  void makeDir(File dir) {
        if (!dir.getParentFile().exists()) {
            makeDir(dir.getParentFile());
        }
        dir.mkdir();
    }

}

activity_echart.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">

    <WebView
        android:id="@+id/chartshow_web"
        android:layout_width="match_parent"
        android:layout_height="match_parent"/>
</LinearLayout>

activity_out.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"
    android:background="@mipmap/bj3">
    <TextView
        android:id="@+id/out_path"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"/>
    <Button
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="导出到Excel"
        android:textColor="#F2F2F2"
        android:background="#328359"
        android:onClick="exportExcel"
        android:layout_gravity="center"
        android:layout_marginTop="200dp"/>
</LinearLayout>

截图展示：

 下图是在手机上导出表格所截的图：