- packagecom.asc.db;
- importandroid.content.ContentValues;
- importandroid.content.Context;
- importandroid.database.Cursor;
- importandroid.database.sqlite.SQLiteDatabase;
- importandroid.database.sqlite.SQLiteOpenHelper;
- publicclassDBManager{
- privatestaticfinalStringDB_NAME="asc.db";
- privatestaticfinalintDB_VERSION=1;
- privateSQLiteDatabasemSQLiteDatabase=null;
- privateDatabaseHelpermDatabaseHelper=null;
- privateContextmContext=null;
- privatestaticDBManagerdbConn=null;
- privateCursorcursor;
- privatestaticclassDatabaseHelperextendsSQLiteOpenHelper{
- DatabaseHelper(Contextcontext){
- super(context,DB_NAME,null,DB_VERSION);
- }
- @Override
- publicvoidonCreate(SQLiteDatabasedb){
- db.execSQL("CREATETABLEad_record(idPRIMARYKEYNOTNULL,adUrlTEXT,apMacTEXT,createDateDATETIME);");
- }
- @Override
- publicvoidonUpgrade(SQLiteDatabasedb,intoldVersion,intnewVersion){
- db.execSQL("DROPTABLEIFEXISTSad_record");
- onCreate(db);
- }
- }
- privateDBManager(ContextmContext){
- super();
- this.mContext=mContext;
- }
- publicstaticDBManagergetInstance(ContextmContext){
- if(null==dbConn){
- dbConn=newDBManager(mContext);
- }
- returndbConn;
- }
- publicvoidopen(){
- mDatabaseHelper=newDatabaseHelper(mContext);
- mSQLiteDatabase=mDatabaseHelper.getWritableDatabase();
- }
- publicvoidclose(){
- if(null!=mDatabaseHelper){
- mDatabaseHelper.close();
- }
- if(null!=cursor){
- cursor.close();
- }
- }
- publiclonginsert(StringtableName,StringnullColumn,
- ContentValuescontentValues)throwsException{
- try{
- returnmSQLiteDatabase.insert(tableName,nullColumn,contentValues);
- }catch(Exceptione){
- throwe;
- }
- }
- publiclongdelete(StringtableName,Stringkey,intid)throwsException{
- try{
- returnmSQLiteDatabase.delete(tableName,key+"="+id,null);
- }catch(Exceptione){
- throwe;
- }
- }
- publicCursorfindAll(StringtableName,String[]columns)throwsException{
- try{
- cursor=mSQLiteDatabase.query(tableName,columns,null,null);
- cursor.moveToFirst();
- returncursor;
- }catch(Exceptione){
- throwe;
- }
- }
- publicCursorfindById(StringtableName,intid,String[]columns)throwsException{
- try{
- returnmSQLiteDatabase.query(tableName,null);
- }catch(Exceptione){
- throwe;
- }
- }
- publicCursorfind(StringtableName,String[]names,String[]values,String[]columns,StringorderColumn,Stringlimit)throwsException{
- try{
- StringBufferselection=newStringBuffer();
- for(inti=0;i<names.length;i++){
- selection.append(names[i]);
- selection.append("=?");
- if(i!=names.length-1){
- selection.append(",");
- }
- }
- cursor=mSQLiteDatabase.query(true,tableName,selection.toString(),values,orderColumn,limit);
- cursor.moveToFirst();
- returncursor;
- }catch(Exceptione){
- throwe;
- }
- }
- publicbooleanudpate(StringtableName,ContentValuesargs)throwsException{
- try{
- StringBufferselection=newStringBuffer();
- for(inti=0;i<names.length;i++){
- selection.append(names[i]);
- selection.append("=?");
- if(i!=names.length-1){
- selection.append(",");
- }
- }
- returnmSQLiteDatabase.update(tableName,args,values)>0;
- }catch(Exceptione){
- throwe;
- }
- }
- publicvoidexecuteSql(Stringsql){
- mSQLiteDatabase.execSQL(sql);
- }
- } //原文: http://forhope.iteye.com/blog/1461412
(编辑:李大同)
【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!
|