Sqlite数据库增删改查

1.应用部分

package com.example.language;
import androidx.appcompat.app.AppCompatActivity;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.TextView;
import com.example.language.data.DataBaseHelper;

public class MainActivity extends AppCompatActivity implements View.OnClickListener {

  	private Button insertBtn, updateBtn, queryBtn, deleteBtn;
    private int uid = 123456;
    private SQLiteDatabase db;
    private TextView tv_content;
    private String tableNameWithSuffix = "originLanguage.db";
    private String tableName = "originLanguage";

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        insertBtn = findViewById(R.id.insert);
        updateBtn = findViewById(R.id.update);
        queryBtn = findViewById(R.id.query);
        deleteBtn = findViewById(R.id.delete);

        insertBtn.setOnClickListener(this);
        updateBtn.setOnClickListener(this);
        queryBtn.setOnClickListener(this);
        deleteBtn.setOnClickListener(this);

        tv_content = findViewById(R.id.tv_content);

        DataBaseHelper dbHelper = new DataBaseHelper(MainActivity.this, tableNameWithSuffix, null, 1);
        db = dbHelper.getWritableDatabase();
    }

    @Override
    public void onClick(View view) {
        switch (view.getId()) {
            case R.id.insert:
                insertDB(db, uid, "en");
                break;
            case R.id.update:
                updateDB(db, uid, "th");
                break;
            case R.id.query:
                queryDB(db, uid, "th");
                break;
            case R.id.delete:
                deleteDB(db, uid, "th");
                break;
        }
    }

    private void insertDB(SQLiteDatabase db, int uid, String code) {
        ContentValues values = new ContentValues();
        values.put("uid", uid);
        values.put("languageCode", code);
        values.put("countryCode", code);
        long num = db.insert(tableName, null, values);
        tv_content.setText("num:"+num);
    }

    private void updateDB(SQLiteDatabase db, int uid, String code) {
        ContentValues values = new ContentValues();
        values.put("languageCode", code);
        db.update(tableName, values, "uid = ?", new String[]{String.valueOf(uid)});
    }

    private String queryDB(SQLiteDatabase db, int uid, String code) {
        Cursor cursor = db.query(tableName, new String[]{"languageCode"}, "uid = ?", new String[]{String.valueOf(uid)}, null, null, null);
        String languageCode = "auto";
        int count = cursor.getCount();
        while (cursor.moveToNext()) {
            languageCode = cursor.getString(cursor.getColumnIndex("languageCode"));
        }
        cursor.close();
        tv_content.setText("count:"+ count + ", code:"+languageCode);
        return languageCode;
    }

    private void insertOrUpdateDB(SQLiteDatabase db, int uid, String code) {
        Cursor cursor = db.query(tableName, new String[]{"languageCode"}, "uid = ?", new String[uid], null, null, null);
        if (cursor.getCount() != 0) {
            updateDB(db, uid, code);
        } else {
            insertDB(db, uid, code);
        }
    }

    private void deleteDB(SQLiteDatabase db, int uid, String code) {
        db.delete(tableName, "uid = ?" , new String[]{String.valueOf(uid)});
    }
}

2.数据库部分

package com.example.language.data;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import androidx.annotation.Nullable;

public class DataBaseHelper extends SQLiteOpenHelper {
    private String name;

    public DataBaseHelper(@Nullable Context context, String name, @Nullable SQLiteDatabase.CursorFactory factory, int version) {
        super(context, name, factory, version);
        this.name = name.split("\\.")[0];
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        String sql = "CREATE Table "+ name +"(uid integer PRIMARY KEY, languageCode text, countryCode text)";
        db.execSQL(sql);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

    }
}