/**
* 定义升级函数
*/
private void upgradeDatabaseToVersion2(SQLiteDatabase db) {
// Add 'new' column to mytable table.
db.execSQL("ALTER TABLE mytable ADD COLUMN new TEXT");
}
/**
* 重写onUpgrade
*/
public void onUpgrade(SQLiteDatabase db, int oldVersion, int currentVersion) {
switch (oldVersion) {
case 1:
if (currentVersion <= 1) {
return;
}
db.beginTransaction();
try {
upgradeDatabaseToVersion2(db);
db.setTransactionSuccessful();
} catch (Throwable ex) {
Log.e(TAG, ex.getMessage(), ex);
break;
} finally {
db.endTransaction();
}
return;
}
dropAll(db);
onCreate(db);
}