Android Sqlite資料庫中基礎的增刪改查操作

1.創建一個類MyUserlogDBHelper去繼承SQLiteOpenHelper，在該類里面創建表，

package com.example.demo;

import android.content.ContentValues;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

import androidx.annotation.Nullable;

public class MyUserlogDBHelper extends SQLiteOpenHelper {

    public MyUserlogDBHelper db;
    //對外提供引數，單例模式
    private static SQLiteOpenHelper mHelper;
    public static synchronized SQLiteOpenHelper getInstance(Context context){
        if (mHelper==null){
            mHelper=new MyUserlogDBHelper(context,"user_log",null,1);
        }
        return mHelper;
    }

    private MyUserlogDBHelper(@Nullable Context context, @Nullable String name, @Nullable SQLiteDatabase.CursorFactory factory, int version) {
        super(context, name, factory, version);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        //創建表
        String sql="create table user_log (_id integer primary key autoincrement,name text)";
        //拿到db執行sql陳述句即可
        db.execSQL(sql);
    }

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

    }
}

2.在Activity中寫查詢，增加，修改，洗掉資料的操作，

package com.example.demo;

import androidx.appcompat.app.AppCompatActivity;

import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.os.Bundle;
import android.util.Log;
import android.view.View;

public class MainActivity extends AppCompatActivity {

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
    }

    public void create(View view) {
        SQLiteOpenHelper helper = MyUserlogDBHelper.getInstance(this);
        SQLiteDatabase readableDatabase = helper.getReadableDatabase();
    }
    //查詢陳述句
    public void query(View view) {
        SQLiteOpenHelper instance = MyUserlogDBHelper.getInstance(this);
        SQLiteDatabase db = instance.getReadableDatabase();

        if (db.isOpen()){
            //查詢陳述句
            String sql="select * from user_log";
            //獲取游標
            Cursor cursor = db.rawQuery(sql, null);
            while(cursor.moveToNext()){
                //不規范的寫法
                /*int _id=cursor.getColumnIndex("0");
                int name=cursor.getColumnIndex("1");
                */
                //規范的寫法
                int _id=cursor.getInt(cursor.getColumnIndex("_id"));
    	        String name=cursor.getString(cursor.getColumnIndex("name"));

                Log.d("資料庫", "_id: "+_id+"，name:"+name);
            }

            //關閉游標
            cursor.close();
            //關閉資料庫
            db.close();
        }
    }

    //插入陳述句
    public void insert(View view) {
        SQLiteOpenHelper instance = MyUserlogDBHelper.getInstance(this);
        SQLiteDatabase db = instance.getWritableDatabase();

        //判斷資料庫是否開啟
        if (db.isOpen()){
            String sql="insert into user_log(name) values('路宇')";

            db.execSQL(sql);
        }
        db.close();
    }

    //修改
    public void update(View view) {
        SQLiteOpenHelper instance = MyUserlogDBHelper.getInstance(this);
        SQLiteDatabase db = instance.getWritableDatabase();
        if (db.isOpen()){
            String sql="update user_log set name=? where _id=?";
            db.execSQL(sql,new Object[]{"成龍","5"});
        }
        //關閉資料庫
        db.close();
    }
    //洗掉資料
    public void delete(View view) {
        SQLiteOpenHelper instance = MyUserlogDBHelper.getInstance(this);
        SQLiteDatabase db = instance.getWritableDatabase();
        //判斷資料是否是打開狀態
        if (db.isOpen()){
            String sql="delete from user_log where _id=?";
            db.execSQL(sql,new Object[]{6});
        }
    }
}

3.布局檔案，

<?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:layout_width="match_parent"
    android:layout_height="match_parent"
    tools:context=".MainActivity"
    android:orientation="vertical"
    >

    <Button
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="創建表"
        android:onClick="create" />

    <Button
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="查詢"
        android:onClick="query" />
    <Button
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="插入"
        android:onClick="insert" />
    <Button
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="修改"
        android:onClick="update" />
    <Button
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="洗掉"
        android:onClick="delete" />



</LinearLayout>

以上就是SQLite資料庫中，最簡單的增刪改查操作，想深入學習SQLite在專案中的實際應用，請持續關注后面博文！