体温上报APP2.0
1、今日学习进度表:
2、第二阶段任务:
汇总+导出生成excel体温上报表格
3、预计完成时间:
2天
4、今日完成:
汇总情况
根据班级汇总班级上报总人数、体温异常人数、未填报体温人数以及正常上报人数
SumActivity
package com.example.reporttemperature; import androidx.appcompat.app.AppCompatActivity; import android.content.Intent; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; import android.os.Bundle; import android.view.View; import android.widget.AdapterView; import android.widget.Button; import android.widget.EditText; import android.widget.Spinner; import android.widget.Toast; public class SumActivity extends AppCompatActivity { private Spinner spinner; private EditText et_sum, et_normal, et_abnormal, et_unreport; private Button bt_sum_report,bt_start; private String choose; private MyOpenHelper helper = new MyOpenHelper(this); private int []result=new int[4]; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_sum); findById();//获取控件 //spinner监听事件 spinner.setOnItemSelectedListener(new AdapterView.OnItemSelectedListener() { @Override public void onItemSelected(AdapterView<?> parent, View view, int pos, long id) { String[] languages = getResources().getStringArray(R.array.classroom); choose = languages[pos]; Toast.makeText(SumActivity.this, "你点击的是:" + languages[pos], Toast.LENGTH_SHORT).show(); } @Override public void onNothingSelected(AdapterView<?> parent) { // Another interface callback } }); bt_start.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View v) { result =screen(choose);//获取人数数组 //给edit控件赋值 et_sum.setText(result[0]+""); et_normal.setText(result[1]+""); et_abnormal.setText(result[2]+""); et_unreport.setText(result[3]+""); } }); //返回 bt_sum_report.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View v) { //跳转页面 Intent intent = new Intent(SumActivity.this, CatalogActivity.class); finish(); startActivity(intent); } }); } private void findById() { spinner = findViewById(R.id.spinner); et_sum = findViewById(R.id.edit_sum_people); et_normal = findViewById(R.id.editText_normal); et_unreport = findViewById(R.id.editText_unreport); et_abnormal = findViewById(R.id.editText_abnormal); bt_sum_report = findViewById(R.id.button_sum_return); bt_start=findViewById(R.id.button_start_search); } //数据库根据班级筛选 private int[] screen(String str) { int[] Arr = new int[4]; SQLiteDatabase db = helper.getReadableDatabase(); Cursor cursor = db.rawQuery("select * from temperature where class = ? ", new String[]{str}); int i = 0; //记录总人数 int j = 0; //标记体温正常上报的人 int k = 0; //标记体温异常的人 int t = 0; //标记未上报的人 while (cursor.moveToNext()) { double number=1.0; String newTem = cursor.getString(cursor.getColumnIndex("temperature")); if(newTem.equals("")){ ++t; }else { number= Double.parseDouble(newTem); } if (number > 37.2 || number < 35.0) { ++k; } else { ++j; } ++i; } cursor.close(); db.close(); Arr[0]=i;Arr[1]=j;Arr[2]=k;Arr[3]=t; return Arr; } }
activity_sum.xml
<?xml version="1.0" encoding="utf-8"?> <androidx.constraintlayout.widget.ConstraintLayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:app="http://schemas.android.com/apk/res-auto" xmlns:tools="http://schemas.android.com/tools" android:layout_width="match_parent" android:layout_height="match_parent" android:background="@drawable/sum" tools:context=".SumActivity"> <TextView android:id="@+id/EditText_choose" android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_marginStart="120dp" android:layout_marginLeft="120dp" android:layout_marginTop="114dp" android:layout_marginEnd="150dp" android:layout_marginRight="150dp" android:layout_marginBottom="28dp" android:background="#F5684A" android:hint="点击下拉列表选择班级" app:layout_constraintBottom_toTopOf="@+id/spinner" app:layout_constraintEnd_toEndOf="parent" app:layout_constraintStart_toStartOf="parent" app:layout_constraintTop_toTopOf="parent" /> <Spinner android:id="@+id/spinner" android:layout_width="200dp" android:layout_height="wrap_content" android:layout_marginStart="95dp" android:layout_marginLeft="95dp" android:layout_marginEnd="116dp" android:layout_marginRight="116dp" android:layout_marginBottom="546dp" android:entries="@array/classroom" app:layout_constraintBottom_toBottomOf="parent" app:layout_constraintEnd_toEndOf="parent" app:layout_constraintStart_toStartOf="parent"> </Spinner> <TextView android:id="@+id/Text_sum_people" android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_marginStart="88dp" android:layout_marginLeft="88dp" android:layout_marginTop="77dp" android:layout_marginEnd="16dp" android:layout_marginRight="16dp" android:layout_marginBottom="54dp" android:text="班级总人数" android:textSize="20dp" app:layout_constraintBottom_toTopOf="@+id/text_normal" app:layout_constraintEnd_toStartOf="@+id/edit_sum_people" app:layout_constraintStart_toStartOf="parent" app:layout_constraintTop_toBottomOf="@+id/spinner" /> <EditText android:id="@+id/edit_sum_people" android:layout_width="90dp" android:layout_height="wrap_content" android:layout_marginTop="59dp" android:layout_marginEnd="116dp" android:layout_marginRight="116dp" android:layout_marginBottom="35dp" android:ems="10" android:inputType="textPersonName" app:layout_constraintBottom_toTopOf="@+id/editText_normal" app:layout_constraintEnd_toEndOf="parent" app:layout_constraintTop_toBottomOf="@+id/spinner" /> <TextView android:id="@+id/text_normal" android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_marginStart="68dp" android:layout_marginLeft="68dp" android:layout_marginBottom="56dp" android:text="正常上报人数" android:textSize="20dp" app:layout_constraintBottom_toTopOf="@+id/text_abnormal" app:layout_constraintStart_toStartOf="parent" /> <EditText android:id="@+id/editText_normal" android:layout_width="90dp" android:layout_height="wrap_content" android:layout_marginEnd="116dp" android:layout_marginRight="116dp" android:layout_marginBottom="38dp" android:ems="10" android:inputType="textPersonName" app:layout_constraintBottom_toTopOf="@+id/editText_abnormal" app:layout_constraintEnd_toEndOf="parent" /> <TextView android:id="@+id/text_abnormal" android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_marginStart="68dp" android:layout_marginLeft="68dp" android:layout_marginEnd="16dp" android:layout_marginRight="16dp" android:layout_marginBottom="43dp" android:text="体温异常人数" android:textSize="20dp" app:layout_constraintBottom_toTopOf="@+id/text_unreport" app:layout_constraintEnd_toStartOf="@+id/editText_abnormal" app:layout_constraintStart_toStartOf="parent" /> <EditText android:id="@+id/editText_abnormal" android:layout_width="90dp" android:layout_height="wrap_content" android:layout_marginEnd="116dp" android:layout_marginRight="116dp" android:layout_marginBottom="38dp" android:ems="10" android:inputType="textPersonName" app:layout_constraintBottom_toTopOf="@+id/editText_unreport" app:layout_constraintEnd_toEndOf="parent" /> <TextView android:id="@+id/text_unreport" android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_marginStart="48dp" android:layout_marginLeft="48dp" android:layout_marginEnd="14dp" android:layout_marginRight="14dp" android:layout_marginBottom="208dp" android:text="未上报体温人数" android:textSize="20dp" app:layout_constraintBottom_toBottomOf="parent" app:layout_constraintEnd_toStartOf="@+id/editText_unreport" app:layout_constraintStart_toStartOf="parent" /> <EditText android:id="@+id/editText_unreport" android:layout_width="90dp" android:layout_height="wrap_content" android:layout_marginEnd="119dp" android:layout_marginRight="119dp" android:layout_marginBottom="195dp" android:ems="10" android:inputType="textPersonName" app:layout_constraintBottom_toBottomOf="parent" app:layout_constraintEnd_toEndOf="parent" /> <Button android:id="@+id/button_sum_return" android:layout_width="wrap_content" android:layout_height="wrap_content" android:layout_marginStart="155dp" android:layout_marginLeft="155dp" android:layout_marginTop="39dp" android:layout_marginEnd="168dp" android:layout_marginRight="168dp" android:layout_marginBottom="108dp" android:text="返回" app:layout_constraintBottom_toBottomOf="parent" app:layout_constraintEnd_toEndOf="parent" app:layout_constraintStart_toStartOf="parent" app:layout_constraintTop_toBottomOf="@+id/editText_unreport" /> <Button android:id="@+id/button_start_search" android:layout_width="60dp" android:layout_height="40dp" android:layout_marginStart="22dp" android:layout_marginLeft="22dp" android:layout_marginTop="153dp" android:layout_marginEnd="34dp" android:layout_marginRight="34dp" android:layout_marginBottom="538dp" android:text="查询" app:layout_constraintBottom_toBottomOf="parent" app:layout_constraintEnd_toEndOf="parent" app:layout_constraintStart_toEndOf="@+id/spinner" app:layout_constraintTop_toTopOf="parent" /> </androidx.constraintlayout.widget.ConstraintLayout>