数据库版本更新和数据备份

最新推荐文章于 2023-01-01 16:53:37 发布

文韬_武略

最新推荐文章于 2023-01-01 16:53:37 发布

阅读量461

点赞数

分类专栏：安卓开发

本文链接：https://blog.csdn.net/fwt336/article/details/52042915

版权

安卓开发专栏收录该内容

284 篇文章 3 订阅

订阅专栏

<span style="font-size:18px;">public class DBservice extends SQLiteOpenHelper {
    private String CREATE_BOOK = "create table book(bookId integer primarykey,bookName text);";
    private String CREATE_TEMP_BOOK = "alter table book rename to _temp_book";
    private String INSERT_DATA = "insert into book select *,'' from _temp_book";
    private String DROP_BOOK = "drop table _temp_book";
    public DBservice(Context context, String name, CursorFactory factory,int version) {
        super(context, name, factory, version);
    }
    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL(CREATE_BOOK);
    }
    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        switch (newVersion) {
            case 2:
                db.execSQL(CREATE_TEMP_BOOK);
                db.execSQL(CREATE_BOOK);
                db.execSQL(INSERT_DATA);
                db.execSQL(DROP_BOOK);
                break;
        }
    }
}</span>