1.首先创建集成SqliteOpenHelper的类
用于创建数据库和表
package com.example.myapplication4;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
public class NewSQLiteOpenHelper extends SQLiteOpenHelper {
public NewSQLiteOpenHelper(Context context){
super(context,"news_db",null,1);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("create table news (_id integer primary key autoincrement,news_title varchar,news_content varchar)");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
}
2.封装后的方法创建
以dapimpl举例
3.编写实体类经行测试
测试结果: