SQLite数据库的增删改查(1) 使用sql语句_a451319296的博客

一、MyOpenhelper 类

package com.hiscene.testsqlite;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;

import androidx.annotation.Nullable;

public class MyOpenhelper extends SQLiteOpenHelper {

    private String TAG="TestSqlite";

    public MyOpenhelper(Context context) {
        super(context, "daliang.db", null, 1);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("create table person(_id integer primary key autoincrement,name text,age integer)");
        Log.d(TAG,"MyOpenhelper/onCreate()");
    }

    @Override
    public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {
        Log.d(TAG,"MyOpenhelper/onUpgrade()");
    }
}
package com.hiscene.testsqli