Android端数据库设计与实现

有注册、登录、创建详细学生信息、长按删除功能

（一）、java文件

1、DbHelper（创建数据库属性文件）

package com.example.midwork;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.widget.Toast;

public class DbHelper extends SQLiteOpenHelper {
    final String create_table="CREATE TABLE Student (_id integer primary key autoincrement,xm text,xh text,bj text,zy text,cj text)";
    final String create_register="CREATE TABLE Register (_id integer primary key autoincrement,xm text,xh text)";
    Context context;
    public DbHelper(Context context,String dbname,int version){
        super(context,dbname,null,version);
        this.context=context;
    }
    @Override
    public void onCreate(SQLiteDatabase db) {db.execSQL(create_table); db.execSQL(create_register);}

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("drop table if exists Student");
        db.execSQL("drop table if exists Register");
        db.execSQL(create_table);
        db.execSQL(create_register);
    }
    public void insert(String tableName, ContentValues values){
        SQLiteDatabase db = getReadableDatabase();
        db.insert(tableName,null,values);
        Toast.makeText(context,"成功插入数据！",Toast.LENGTH_SHORT).show();
    }
    public Cursor queryAll(String tableName){
        SQLiteDatabase db = getReadableDatabase();
        Cursor cursor = db.query(tableName,null,null,null,null,null,null);
        return cursor;
    }
    public Boolean queryByStudentXhAndXm(String tableName,String xm,String xh){
        SQLiteDatabase db = getReadableDatabase();
        Cursor cursor = db.query(tableName,new String[]{"xm,xh"},"xm=? and xh=?",new String[]{xm,xh},null,null,null);
        if (cursor.moveToFirst()) {
            return true;
        }else {
            return false;
        }
    }
    public void delStudent(String id){
        SQLiteDatabase db = getWritableDatabase();
        db.delete("Student","_id=?",new String[]{id});
    }
    public void  updateStudent(String id,ContentValues values){
        SQLiteDatabase db = getWritableDatabase();
        db.update("Student",values,"_id=?",new String[]{id});
    }
}

2 、NewStudent文件（注册登录功能） 

package com.example.midwork;

import androidx.appcompat.app.AppCompatActivity;

import android.content.Intent;
import android.os.Bundle;
import android.text.TextUtils;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;

public class NewStudent extends AppCompatActivity {
    DbHelper dbHelper;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_new_student);
        dbHelper=new DbHelper(NewStudent.this,"MyDataBase",3);
        Intent priIntent = getIntent();

        EditText et_xm = findViewById(R.id.et_xm);
        EditText et_xh = findViewById(R.id.et_xh);
        EditText et_bj = findViewById(R.id.et_bj);
        EditText et_zy = findViewById(R.id.et_zy);
        EditText et_cj = findViewById(R.id.et_cj);
        String priId = priIntent.getStringExtra("id");
        String prixm = priIntent.getStringExtra("xm");
        String prixh = priIntent.getStringExtra("xh");
        String pribj = priIntent.getStringExtra("bj");
        String prizy = priIntent.getStringExtra("zy");
        String pricj = priIntent.getStringExtra("cj");
        et_xm.setText(prixm);
        et_xh.setText(prixh);
        et_bj.setText(pribj);
        et_zy.setText(prizy);
        et_cj.setText(pricj);

        Button btn_confirm = findViewById(R.id.btn_confirm);

        btn_confirm.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                EditText et_xm = findViewById(R.id.et_xm);
                EditText et_xh = findViewById(R.id.et_xh);
                EditText et_bj = findViewById(R.id.et_bj);
                EditText et_zy = findViewById(R.id.et_zy);
                EditText et_cj = findViewById(R.id.et_cj);

                String xm = et_xm.getText().toString();
                String xh = et_xh.getText().toString();
                String bj = et_bj.getText().toString();
                String zy = et_zy.getText().toString();
                String cj = et_cj.getText().toString();
                if (TextUtils.isEmpty(xm)||TextUtils.isEmpty(xh)){
                    Toast.makeText(NewStudent.this,"学号或者姓名不可为空",Toast.LENGTH_SHORT).show();
                    return;
                }
                Intent intent = new Intent();
                intent.putExtra("_id",priId);
                intent.putExtra("xm",xm);
                intent.putExtra("xh",xh);
                intent.putExtra("bj",bj);
                intent.putExtra("zy",zy);