![](https://img-blog.csdnimg.cn/img_convert/722dfaa4b7b50bab7a1f4f1b19d5b499.png)
继承SQLiteOpenHelper重写方法
public class MyDbHelper extends SQLiteOpenHelper {
public MyDbHelper(@Nullable Context context) {
super(context, "user.db", null, 1);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("CREATE TABLE userInfo(uid integer PRIMARY KEY autoincrement,uname varchar(8),age INT,sex int,birthday date);");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
}
SQLite-常用类及方法
Exposes methods to manage a sQLite database.相关方法
方式一
· execSQL(String SQL):执行增、删、改的操作. rawQuery(String SQL):执行查的操作
方式二
. insert().delete(). update(). query()