SQLite Database判斷是否存在、新建、刪除...

1、SQLite Database判斷是否存在、新建、刪除.Android SQLite Database本打算封裝SQLite的，但是，發(fā)現(xiàn)實際上Android已經(jīng)封裝了一層，尤其是數(shù)據(jù)的增、刪、查、改上，更是如此，所以，我后來只封裝了一個連接層，負(fù)責(zé)打開、建立數(shù)據(jù)庫，并返回一個SQLite的實例用來完成增、刪、插、改等操作。/- DBHelper -package utility.db;import java.io.FileNotFoundException;import android.content.Context;import android.database.sqlite.SQLite

2、Database;import android.database.sqlite.SQLiteDatabase.CursorFactory;public class DBHelperprivate SQLiteDatabase db = null;private Context ctx = null;public DBHelper( Context ctx )this.ctx = ctx;/* 判斷數(shù)據(jù)庫是否存在* param dbName* 數(shù)據(jù)庫名稱* return true存在 false不存在*/public boolean exist( String dbName )Log.log(&

3、quot;called fun : exist()");boolean flag = false;trydb = ctx.openDatabase(dbName, null);Log.log("database/"+dbName+" exist");flag = true;catch (FileNotFoundException e)flag = false;Log.log("database/"+dbName+" not exist");finallyif (db != null)db.close();

4、db = null;return flag;/* 打開數(shù)據(jù)庫* param dbName* 數(shù)據(jù)庫名稱* return true 打開成功 false打開失敗*/public boolean openDatabase( String dbName , boolean created )return openDatabase(dbName, null, created);/* 打開數(shù)據(jù)庫* param dbName* 數(shù)據(jù)庫名稱* param factory* return true 打開成功 false打開失敗*/public boolean openDatabase( String dbNa

5、me , CursorFactory factory ,boolean created )Log.log("called fun : openDatabase()");Log.log("called fun : if not exist then created "+dbName+" ? : "+created);boolean flag = false;if(exist(dbName)trydb = ctx.openDatabase(dbName, factory);Log.log("database/"+dbN

6、ame+" is opened");flag = true;catch (FileNotFoundException e)Log.log("database/"+dbName+" is not opened");flag = false;elseif(created)flag = createDatabase(dbName, 1, 0, factory);elseflag = false;return flag;/* 創(chuàng)建數(shù)據(jù)庫* param dbName* 數(shù)據(jù)庫名稱* param version* 數(shù)據(jù)庫版本* param mod

7、e* 模式* param factory* return true 建立成功 false 建立失敗*/public boolean createDatabase( String dbName , int version , int mode ,CursorFactory factory )Log.log("called fun : createDatabase()");boolean flag = false;trydb = ctx.createDatabase(dbName, version, mode, factory);Log.log("database/&

8、quot;+dbName+" is created successfully!");flag = true;catch (FileNotFoundException e)Log.log("database/"+dbName+" can't be created");flag = true;return flag;/* 建立數(shù)據(jù)庫* param dbName* 數(shù)據(jù)庫名稱* return true 打開成功 false 打開失敗*/public boolean createDatabase( String dbName )ret

9、urn createDatabase(dbName);/* 關(guān)閉數(shù)據(jù)庫*/public void closeDatabase()Log.log("close database");if (db != null)db.close();db = null;ctx = null;/* 刪除表* param tableName 表名* return 成功則返回 表名 失敗則返回null*/public String dropTable( String tableName )Log.log("called fun dropTable()");if (tableNa

10、me = null)Log.log("table name is error! "+tableName+" is null !");return null;String DROP_TABLE = "DROP TABLE IF EXISTS " + tableName;db.execSQL(DROP_TABLE);Log.log("table/"+tableName+" is dropped successfully");return tableName;/* 取得數(shù)據(jù)庫實例* return 返回數(shù)據(jù)庫實例*/public SQLiteDatabase getDBInstance()return db;public boolean execSQL(String SQL)boolean flag = false;Log.log("called fun execSQL()");Log.log("SQL:"+SQL)