SQLiteOpenHelper数据库操作辅助类,本身是一个抽象类,抽象类无法直接实例化,所以通常都会自定义类,去继承抽象类,然后再实例化自定义的类。
public class MyHelper extends SQLiteOpenHelper {
public MyHelper(@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 mytest(id integer"
+" primary key autoincrement,"
+" myusername varchar(10),"
+" mypwd varchar(6))";
db.execSQL(sql);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
Log.i("【数据库升级】", "onUpgrade: 数据库升级了");
}
}
继承SQLiteOpenHelper抽象类后,必须要重新两个方法,onCreate和onUpgrade,第一个方法主要用于创建数据