2021年3月8日：
今天修改了提交的代码，增加了跳转导入成功的界面以及导入成功后跳转界面的代码，以及增加了导入的代码，但是现在还没成功
package com.example.myapplication;
import android.content.Intent;
import android.content.res.AssetManager;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.KeyEvent;
import android.view.View;
import android.widget.Button;
import android.widget.Toast;
import androidx.appcompat.app.AppCompatActivity;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import java.io.IOException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.List;
public class Tijiao extends AppCompatActivity {
private shujuku shuju;
public SQLiteDatabase db;
private List<studenttiwen> students=null;
int startRowIndex=9;
private Button daoru;
private long exitTime = 0;
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.tijiao);
shuju=new shujuku(this,"tiwenapp.db",null,1);
db=shuju.getReadableDatabase();
daoru=(Button)findViewById(R.id.daoru);
daoru.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
Cursor cursor = db.rawQuery("select id,app.name,banji,tiwen,date,address,phone,special from student left join app on app.name=student.name" ,null);
if(cursor.moveToFirst()){
students=new ArrayList<>();
do{
studenttiwen student = new studenttiwen();
student.id = cursor.getString(cursor.getColumnIndex("id"));
student.name = cursor.getString(cursor.getColumnIndex("name"));
student.banji = cursor.getString(cursor.getColumnIndex("banji"));
student.tiwen = cursor.getString(cursor.getColumnIndex("tiwen"));
student.date = cursor.getString(cursor.getColumnIndex("date"));
student.address = cursor.getString(cursor.getColumnIndex("address"));
student.phone = cursor.getString(cursor.getColumnIndex("phone"));
student.special = cursor.getString(cursor.getColumnIndex("special"));
students.add(student);
}while(cursor.moveToNext());
}
cursor.close();
if(students!=null){
AssetManager assets = getApplicationContext().getAssets();
InputStream fis1= null;
try {
fis1 = assets.open("信1905-2学生登记表.xls");
} catch (IOException e) {
e.printStackTrace();
}
HSSFWorkbook workbook = null;
try {
workbook = new HSSFWorkbook(fis1);
} catch (IOException e) {
e.printStackTrace();
}
Sheet sheet = workbook.getSheetAt(0);
for(studenttiwen stu:students){
for(int i=1;i<4;i++){
if(i==1){
Row row=sheet.getRow(1);
row.createCell(1).setCellValue(stu.banji);
row.createCell(5).setCellValue(stu.date);
}
if(i==2){
Row row=sheet.getRow(2);
row.createCell(1).setCellValue(stu.name);
row.createCell(3).setCellValue(stu.id);
}
if(i==3)
{
Row row=sheet.getRow(3);
if(stu.special.equals("无")){
row.createCell(1).setCellValue("正常");
}
else
{
row.createCell(1).setCellValue("异常");
}
row.createCell(3).setCellValue(stu.phone);
}
}
Row row=sheet.getRow(startRowIndex++);
row.createCell(1).setCellValue(stu.tiwen);
if(stu.special.equals("无")){
row.createCell(2).setCellValue("目前为止一切正常");
}
else
{
row.createCell(2).setCellValue("出现异常，正在进行诊治");
}
row.createCell(3).setCellValue(stu.address);
row.createCell(4).setCellValue(stu.special);
}
try {
workbook.close();
} catch (IOException e) {
e.printStackTrace();
}
}
Intent intent = new Intent();
intent.setClass(Tijiao.this,Daoru.class);
intent.setFlags(Intent.FLAG_ACTIVITY_CLEAR_TOP);
startActivity(intent);
}
});
}
public boolean onKeyDown(int keyCode, KeyEvent event) {
if (keyCode == KeyEvent.KEYCODE_BACK) {
if ((System.currentTimeMillis() - exitTime) > 2000){
Toast.makeText(getApplicationContext(), "再按一次返回桌面", Toast.LENGTH_SHORT).show();
exitTime = System.currentTimeMillis();
} else{
Intent startMain = new Intent(Intent.ACTION_MAIN);
startMain.addCategory(Intent.CATEGORY_HOME);
startMain.setFlags(Intent.FLAG_ACTIVITY_NEW_TASK);
startActivity(startMain);
System.exit(0);
}
return true;
}
return super.onKeyDown(keyCode, event);
}
}