AndroidSQLite數(shù)據(jù)庫操作實(shí)例

AndroidSQLite數(shù)據(jù)庫操作實(shí)例AndroidSQLiteSQL語句去操作數(shù)據(jù)，SQLiteSQLMysql?樣，以下是利?SQL操作SQLite：Java代碼importjava.util.ArrayList;importjava.util.List;3.importandroid.content.Context;importandroid.database.Cursor;importandroid.database.sqlite.SQLiteDatabase;7.publicclassPersonDaoClassic{privateDBOpenHelperhelper;10.publicPersonDaoClassic(Contextcontext){helper=newDBOpenHelper(context);13. }14.publicvoidinsert(Personp){//打開可寫數(shù)據(jù)庫SQLiteDatabasedb=helper.getWritableDatabase();18.//SQL替換占位符INTOperson(name,balance)VALUES(?,?)",newObject[]{p.getName(),p.getBalance()});//釋放資源db.close();24. }25.publicvoiddelete(intid){SQLiteDatabasedb=helper.getWritableDatabase();FROMpersonWHEREid=?",newObject[]{id});db.close();30. }31.publicvoidupdate(Personp){SQLiteDatabasedb=helper.getWritableDatabase(); personSETname=?,balance=?WHEREid=?",newObject[]{p.getName(),p.getBalance(),p.getId()});db.close();36. }37.publicPersonquery(intid){SQLiteDatabasedb=helper.getReadableDatabase();40.//Cursor(ResultSet)Cursorc=db.rawQuery("SELECTname,balanceFROMpersonWHEREid=?",newString[]{String.valueOf(id)});Personp=44.//Cursor是否有下?條記錄if(c.moveToNext())//從CursorPerson對(duì)象pPerson(id,c.getString(0),c.getInt(1));49.//釋放資源c.close();db.close();returnp;54. }55.publicList<Person>queryAll(){SQLiteDatabasedb=helper.getReadableDatabase();Cursorc=db.rawQuery("SELECTid,name,balanceFROMperson",List<Person>persons=newArrayList<Person>();while(c.moveToNext())Person(c.getInt(0),c.getString(1),c.getInt(2)));c.close();db.close();returnpersons;65. }66.publicList<Person>queryPage(intpageNum,intcapacity){//開始索引Stringstart=String.valueOf((pageNum-1)*capacity);69.Stringstart=String.valueOf((pageNum-1)*capacity);70.//查詢的個(gè)數(shù)71.Stringlength=String.valueOf(capacity);72.73.SQLiteDatabasedb=helper.getReadableDatabase();74.75.//翻頁查詢語句,和MySQL中相同76.Cursorc=db.rawQuery("SELECTid,name,balanceFROMpersonLIMIT?,?",newString[]{start,length});77.List<Person>persons=newArrayList<Person>();78.while(c.moveToNext())79.persons.add(newPerson(c.getInt(0),c.getString(1),c.getInt(2)));80.c.close();81.db.close();82.returnpersons;83.}84.85.publicintqueryCount(){86.SQLiteDatabasedb=helper.getReadableDatabase();87.88.//查詢記錄條數(shù)89.Cursorc=db.rawQuery("SELECTCOUNT(*)FROMperson",null);90.c.moveToNext();91.intcount=c.getInt(0);92.c.close();93.db.close();94.returncount;95.}96.97.}除上述?法以外，android還給我們帶來了另外?種更加簡單，也是android推薦使?的?種?式，ft種?式把數(shù)據(jù)封裝在ContentValues中，因?yàn)閍ndroid編程過程中經(jīng)常會(huì)使?到已經(jīng)封裝好了數(shù)據(jù)的ContentValues，所以使?第?種?式在有些時(shí)候更加便捷，以下是代碼：...3.44.45.packagecn.itcast.sqlite;importjava.util.ArrayList;importjava.util.List;importandroid.content.ContentValues;importandroid.content.Context;importandroid.database.Cursor;importandroid.database.sqlite.SQLiteDatabase;publicclassPersonDao{privateDBOpenHelperhelper;publicPersonDao(Contextcontext){helper=newDBOpenHelper(context);}publicvoidremit(intfrom,intto,intamount){SQLiteDatabasedb=helper.getWritableDatabase();//開啟事務(wù)db.beginTransaction();try{personSETbalance=balance-?WHEREid=?",newObject[]{amount,from});personSETbalance=balance+?WHEREid=?",newObject[]{amount,to});db.setTransactionSuccessful();}catch(Exceptione){e.printStackTrace();}//結(jié)束事務(wù),將事務(wù)成功點(diǎn)前?的代碼提交db.endTransaction();db.close();}publicvoidinsert(Personp){SQLiteDatabasedb=helper.getWritableDatabase();//準(zhǔn)備數(shù)據(jù)ContentValuesvalues=newContentValues();values.put("name",p.getName());values.put("balance",p.getBalance());//ContentValuesSQLid為表中的?個(gè)列名db.insert("person","id"values);45.db.insert("person","id",values);46.47.db.close();48.}4.75.76.publicvoiddelete(intid){SQLiteDatabasedb=helper.getWritableDatabase();//執(zhí)?刪除操作,在person表中刪除id為指定值的記錄db.delete("person","id=?",newString[]{String.valueOf(id)});db.close();}publicvoidupdate(Personp){SQLiteDatabasedb=helper.getWritableDatabase();//要更新的數(shù)據(jù)ContentValuesvalues=newContentValues();values.put("name",p.getName());values.put("balance",p.getBalance());//更新person表中id為指定值的記錄db.update("person",values,"id=?",newString[]{String.valueOf(p.getId())});db.close();}publicPersonquery(intid){SQLiteDatabasedb=helper.getReadableDatabase();77.//personname和balanceWhere"id=?"idhaving,不排序,沒有分頁Cursorc=db.query(false,"person",newString[]{"name","balance"},"id=?",newString[]{String.valueOf(id)},null,null,null,null);78.Personp=//Cursor是否有下?條記錄if(c.moveToNext())//從CursorPerson對(duì)象pPerson(id,c.getString(0),c.getInt(1));//釋放資源c.close();db.close();returnp;89. }90.publicList<Person>queryAll(){SQLiteDatabasedb=helper.getReadableDatabase();93.//倒序Cursorc=db.query(false,"person",newString[]{"id","name","balance"},"idDESC",96.List<Person>persons=newArrayList<Person>();while(c.moveToNext())Person(c.getInt(0),c.getString(1),c.getInt(2)));c.close();db.close();returnpersons;103. }104.publicList<Person>queryPage(intpageNum,intcapacity){//開始索引Stringstart=String.valueOf((pageNum-1)*capacity);//查詢的個(gè)數(shù)Stringlength=String.valueOf(capacity);110.111. SQLiteDatabasedb=helper.getReadableDatabase();112.//翻頁查詢 Cursorc=db.query(false,"person",newString[]{"id","name","balance"},start+","+length);List<Person>persons=newArrayList<Person>();while(c.moveToNext())Person(c.getInt(0),c.getString(1),c.getInt(2)));c.close();db.close();returnpersons