Android之SQLite开发（2）—SQLiteOpenHelper类

最新推荐文章于 2019-05-10 09:55:57 发布

huxq17

最新推荐文章于 2019-05-10 09:55:57 发布

阅读量942

点赞数 1

分类专栏： android 文章标签： android android开发 SQLite SQLiteOpenHelper

本文链接：https://blog.csdn.net/footballclub/article/details/42620757

版权

SQLiteOpenHelper是Android用于数据库管理的工具类，涉及构造函数、onCreate、onUpgrade等关键方法。onCreate在数据库首次创建时执行，用于建表和数据初始化；onUpgrade在数据库升级时调用，用于更新表结构。getWritableDatabase和getReadableDatabase分别提供读写和只读数据库，完成操作后记得关闭连接。

摘要由CSDN通过智能技术生成

SQLiteOpenHelper是Android提供的一个管理数据库的工具类，可用于管理数据库的创建和版本更新。SQLiteOpenHelper是一个抽象类，所以我们想要使用它，就必须创建它的子类，并且拓展它的onCreate(SQLiteDatabase db)和onUpdate(SQLiteDatabase db,int oldVersion,int newVersion)方法。

SQLiteOpenHelper包含如下常用方法：

构造函数

/**
     * Create a helper object to create, open, and/or manage a database.
     * This method always returns very quickly.  The database is not actually
     * created or opened until one of {@link #getWritableDatabase} or
     * {@link #getReadableDatabase} is called.
     *
     * @param context to use to open or create the database
     * @param name of the database file, or null for an in-memory database
     * @param factory to use for creating cursor objects, or null for the default
     * @param version number of the database (starting at 1); if the database is older,
     *     {@link #onUpgrade} will be used to upgrade the database; if the database is
     *     newer, {@link #onDowngrade} will be used to downgrade the database
     */
    public SQLiteOpenHelper(Context context, String name, CursorFactory factory, int version) {
        this(context, name, factory, version, null);
    }

    /**
     * Create a helper object to create, open, and/or manage a database.
     * The database is not actually created or opened until one of
     * {@link #getWritableDatabase} or {@link #getReadableDatabase} is called.
     *
     * <p>Accepts input param: a concrete instance of {@link DatabaseErrorHandler} to be
     * used to handle corruption when sqlite reports database corruption.</p>
     *
     * @param context to use to open or create the database
     * @param name of the database file, or null for an in-memory database
     * @param factory to use for creating cursor objects, or null for the default
     * @param version number of the database (starting at 1); if the database is older,
     *     {@link #onUpgrade} will be used to upgrade the database; if the database