ormlite 中的onUpgrade

public class DBHelper extends OrmLiteSqliteOpenHelper {
    public static final String DB_NAME = "yaotuo.db";
    public static final int DB_VERSION = 4;   //更新时候仅仅须要改动这里就能够了
    private static DBHelper mDbHelper;
    private Dao<User, Integer> userDao = null;
    private Dao<Jw, Integer> jwDao = null;
    public DBHelper(Context context) {
        super(context, DB_NAME, null, DB_VERSION);
    }

    public static DBHelper getInstance(Context context){
        if(mDbHelper == null) {
            mDbHelper = new DBHelper(context);
        }
        return mDbHelper;
    }

    @Override
    public void onCreate(SQLiteDatabase sqLiteDatabase, ConnectionSource connectionSource) {
        try {
            System.out.println("create table");
            TableUtils.createTable(connectionSource, User.class);
            TableUtils.createTable(connectionSource, Jw.class);
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    @Override
    public void onUpgrade(SQLiteDatabase sqLiteDatabase, ConnectionSource connectionSource, int i, int i2) {
        try {
            System.out.println("drop jw class");
            TableUtils.dropTable(connectionSource, Jw.class, true);      //全部的表都必须得删除的。 否则在onCreate方法中会出现建表异常
            TableUtils.dropTable(connectionSource, User.class, true);
            onCreate(sqLiteDatabase, connectionSource);
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

当数据库版本号号发生变化的时候的调用onUpdate。就是你曾经的版本号是1,然后升级成为2了。会调用这个。让你做一些操作,例如说将曾经的表删除掉, 或者其它的
posted @ 2017-05-30 16:42  brucemengbm  阅读(438)  评论(0编辑  收藏  举报