2022-10-31学习内容
1.数据库版本升级
1.1UserDBHelper.java
private static final int DB_VERSION = 2; @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { String sql = "ALTER TABLE " + TABLE_NAME + " ADD COLUMN PHONE VARCHAR;"; db.execSQL(sql); sql = "ALTER TABLE " + TABLE_NAME + " ADD COLUMN PASSWORD VARCHAR;"; db.execSQL(sql); }
1.2效果: