安卓开发——sqlite数据库增删查改输入信息

MainActivity.java

import androidx.appcompat.app.AlertDialog;
import androidx.appcompat.app.AppCompatActivity;

import android.content.ContentValues;
import android.content.DialogInterface;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.TextView;
import android.widget.Toast;

public class MainActivity extends AppCompatActivity {

    DBHelper dbHelper;
    EditText editText;
    TextView textView;
    EditText editText_username;
    EditText editText_pass;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        dbHelper=new DBHelper(this,"MyDatabase.db",1);
        textView=(TextView)findViewById(R.id.text_view);
        editText_username=(EditText)findViewById(R.id.et_username);
        editText_pass=(EditText)findViewById(R.id.et_password);
        Button btn_create=(Button)findViewById(R.id.btn_create);
        Button btn_insert=(Button)findViewById(R.id.btn_insert);
        Button btn_show=(Button)findViewById(R.id.btn_show);
        Button btn_delete=(Button)findViewById(R.id.btn_delete);
        Button btn_update=(Button)findViewById(R.id.btn_update);
        btn_create.setOnClickListener(new myClass());
        btn_insert.setOnClickListener(new myClass());
        btn_show.setOnClickListener(new myClass());
        btn_delete.setOnClickListener(new myClass());
        btn_update.setOnClickListener(new myClass());

    }






    class myClass implements View.OnClickListener{
        @Override
        public void onClick(View v){
            int key=v.getId();
            switch (key){
                case R.id.btn_create:
                    dbHelper.getWritableDatabase();
                    break;

                case R.id.btn_insert:
                    ContentValues values=new ContentValues();
                    values.put("name",editText_username.getText().toString());
                    values.put("pass",editText_pass.getText().toString());
                    dbHelper.insert(values);
                    show();
                    break;
                case R.id.btn_show:
                    show();
                    break;
                case R.id.btn_delete:
                    AlertDialog.Builder builder=new AlertDialog.Builder(MainActivity.this);
                    final String name=editText_username.getText().toString();
                    builder.setTitle("确认删除").setMessage("是否确认删除用户"+name+"?");
                    builder.setPositiveButton("确认",new DialogInterface.OnClickListener(){
                        @Override
                        public void onClick(DialogInterface dialogInterface,int i){
                            dbHelper.delete(name);
                            show();
                        }
                    });

                    builder.setNegativeButton("取消", new DialogInterface.OnClickListener() {
                        @Override
                        public void onClick(DialogInterface dialogInterface, int i) {
                            dialogInterface.dismiss();
                        }
                    });
                    builder.show();
                    break;
                case R.id.btn_update:
                    ContentValues values1=new ContentValues();
                    values1.put("put",editText_pass.getText().toString());
                    dbHelper.update(editText_username.getText().toString(),values1);

                    show();

            }
        }
    }



















    public void show(){
        Cursor cs=dbHelper.queryAll();
       // SQLiteDatabase db=getWritableDatabase();
       // Cursor cs=db.query("Users",null,null,null,null,null,null);
        String str="ID\tname\tpassword\n";
        if(cs.moveToFirst()){
            do{
                str+=cs.getString(0)+"\t";
                str+=cs.getString(1)+"\t";
                str+=cs.getString(2)+"\n";
            }while (cs.moveToNext());
            textView.setText(str);
        }
    }



}

 

DBHelper.java

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,name text,pass 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);
        Toast.makeText(context,"创建成功",Toast.LENGTH_SHORT).show();
    }
    @Override
    public void onUpgrade(SQLiteDatabase db,int oldVersion,int newVersion){
        db.execSQL("drop table if exists Users");
        onCreate(db);
    }


    public void insert(ContentValues data){
        SQLiteDatabase db=getWritableDatabase();
        db.insert("Users",null,data);
        Toast.makeText(context,"插入成功",Toast.LENGTH_SHORT).show();
    }

    /*
    public void show(){
        Cursor cs=queryAll();
        //SQLiteDatabase db=getWritableDatabase();
      //  Cursor cs=db.query("Users",null,null,null,null,null,null);
        String str="ID\tname\tpassword\n";
        if(cs.moveToFirst()){
            do{
                str+=cs.getString(0)+"\t";
                str+=cs.getString(1)+"\t";
                str+=cs.getString(2)+"\n";
            }while (cs.moveToNext());
        }
    }*/

    public Cursor queryAll(){
        SQLiteDatabase db=getWritableDatabase();
        Cursor cs=db.query("Users",null,null,null,null,null,null);
        return cs;
    }


    public void delete(String name){
        SQLiteDatabase db=getWritableDatabase();
        db.delete("Users","name=?",new String[]{name});
        Toast.makeText(context,"insert successed!",Toast.LENGTH_SHORT).show();
    }


    public void update(String name,ContentValues data){
        SQLiteDatabase db=getWritableDatabase();
        db.update("Users",data,"name=?",new String[]{name});
        Toast.makeText(context,"insert successed!",Toast.LENGTH_SHORT).show();
    }


}

 

 

activity_main.xml

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout 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:orientation="vertical"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    tools:context=".MainActivity">

    <EditText
        android:id="@+id/et_username"
        android:hint="请输入用户名"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"/>


    <EditText
        android:id="@+id/et_password"
        android:hint="请输入密码"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"/>


    <Button
        android:id="@+id/btn_create"
        android:text="创建数据库"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"/>

    <Button
        android:id="@+id/btn_insert"
        android:text="插入"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"/>

    <Button
        android:id="@+id/btn_show"
        android:text="显示全部"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"/>

    <Button
        android:id="@+id/btn_delete"
        android:text="删除"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"/>

    <Button
        android:id="@+id/btn_update"
        android:text="修改"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"/>

    <TextView
        android:id="@+id/text_view"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text=""
        android:minLines="3"/>

</LinearLayout>