(1)、java文件
1、DbHelper
package com.example.cl4;
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 Users (_id integer primary key autoincrement,phone_number text,userpassword 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);
}
@Override
public void onUpgrade(SQLiteDatabase db,int oldVersion,int newVersion){
db.execSQL("drop table Users if exists Users");
db.execSQL(create_table);
}
public void insert(ContentValues values){
SQLiteDatabase db = getWritableDatabase();
db.insert("Users",null,values);
Toast.makeText(context,"插入数据完成",Toast.LENGTH_SHORT).show();
}
public Cursor queryAll(){
SQLiteDatabase db = getWritableDatabase();
Cursor cursor = db.query("Users",null,null,null,null,null,null);
return cursor;
}
public Boolean queryUser (String userPhone){
SQLiteDatabase db = getWritableDatabase();
Cursor cursor = db.query("Users", new String[]{"phone_number"},"phone_number=?",new String[]{userPhone},null,null,null);
if (cursor.moveToFirst())
return true;
else
return false;
}
public Boolean query(String userpassword){
SQLiteDatabase db = getWritableDatabase();
Cursor cursor = db.query("Users", new String[]{"userpassword"},"userpassword=?",new String[]{userpassword},null,null,null);
if (cursor.moveToFirst())
return true;
else
return false;
}
public void delUser(String userPhone){
SQLiteDatabase db = getWritableDatabase();
db.delete("Users","phone_number=?",new String[]{userPhone});
}
}
2、MainActivity
package com.example.cl4;
import androidx.appcompat.app.AlertDialog;
import androidx.appcompat.app.AppCompatActivity;
import android.content.ContentValues;
import android.content.DialogInterface;
import android.content.Intent;
import android.database.Cursor;