开发者

How to check existing database before creating new database on android 2.2?

I need开发者_JS百科 to check existing database before creating new database on android 2.2. How to check it?


use openOrCreateDatabase method

Read here

----- EDIT ------

public boolean checkDataBase(){

    SQLiteDatabase checkDB = null;

    try{
        String myPath = DB_PATH + DB_NAME;
        checkDB = SQLiteDatabase.openDatabase(myPath, null, SQLiteDatabase.OPEN_READONLY | SQLiteDatabase.NO_LOCALIZED_COLLATORS);

    }catch(SQLiteException e){

        //database does't exist yet.
    }

    if(checkDB != null){
        checkDB.close();
    }

    return checkDB != null ? true : false;
}


Doesn't it work with the DatabaseHelper ? If you haven't tried here is code I posted before...

Android - Sqlite database method undefined fot type


You should need to check database already exists or not, if not than create database else not create database. Please you can use below query.

CREATE TABLE if not exists TABLE_NAME (key data_type);

Call this query inside onCreate method.


To check if your database was created you can use the following code and it will not be recreated every time you open the application. dbName = is the name of you DB

public static boolean doesDatabaseExist(Context context, String dbName) {
        File dbFile = context.getDatabasePath(dbName);
        return dbFile.exists();
    }
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜