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();
}
精彩评论