androidstudio個?資料,AndroidStudio制作個?資料界?模塊以及SQ。。。前?SQLite數(shù)據(jù)庫的使?的概述，希望你們喜歡學習?標掌握SQLite數(shù)據(jù)庫的使?，能夠?qū)崿F(xiàn)?數(shù)據(jù)庫來保存?戶的信息；學會運?好個?資料，以及個?資料的修改功能實現(xiàn)；個?資料包括?戶名，昵稱，性別，簽名，QQ號或個?社交賬號的記錄等。數(shù)據(jù)庫的創(chuàng)建數(shù)據(jù)庫類extendsSQLiteOpenHelper//核?代碼privatestaticfinalintDB_VERSION=1;publicstaticStringDB_NAME="bxg.db";publicstaticfinalStringU_USER_INFO="userInfo";publicSQLiteHelper(Contextcontext){super(context,DB_NAME,null,DB_VERSION);}@OverridepublicvoidonCreate(SQLiteDatabasedb){/***當這個SQLiteOpenHelper的?類類被實例化時會創(chuàng)建指定名的數(shù)據(jù)庫，在onCreate中創(chuàng)建個?信息表***/db.execSQL("CREATETABLEIFNOTEXISTS"+U_USER_INFO+"("+"_idINTEGERPRIMARYKEYAUTOINCREMENT,"+"userNameVARCHAR,"+"nickNameVARCHAR,"+"sexVARCHAR,"+"signatureVARCHAR,"+"qqVARCHAR"+")");}/***當數(shù)據(jù)庫版本號增加才會調(diào)?ft?法**/@OverridepublicvoidonUpgrade(SQLiteDatabasedb,intoldVersion,intnewVersion){db.execSQL("DROPTABLEIFEXISTS"+U_USER_INFO);onCreate(db);}創(chuàng)建?個數(shù)據(jù)庫?具類，?于讀取、保存、修改?戶信息/**構造?法，只有當類被實例化時候調(diào)?實例化SQLiteHelper類，從中得到?個讀寫的數(shù)據(jù)庫**/publicDBUtils(Contextcontext){helper=newSQLiteHelper(context);db=helper.getWritableDatabase();}/**得到這個類的實例**/publicstaticDBUtilsgetInstance(Contextcontext){if(instance==null){instance=newDBUtils(context);}returninstance;}//保存?zhèn)€?資料信息publicvoidsaveUserInfo(UserBeanbean){ContentValuescv=newContentValues();cv.put("userName",bean.userName);cv.put("nickName",bean.nickName);cv.put("sex",bean.sex);cv.put("signature",bean.signature);cv.put("qq",bean.qq);//Conveniencemethodforinsertingarowintothedatabase.//注意，我們是從數(shù)據(jù)庫使?插??法，傳?表名和數(shù)據(jù)集完成插?db.insert(SQLiteHelper.U_USER_INFO,null,cv);}//獲取個?資料信息publicUserBeangetUserInfo(StringuserName){Stringsql="SELECT*FROM"+SQLiteHelper.U_USER_INFO+"WHEREuserName=?";//?和下?數(shù)組內(nèi)元素會逐個替換，可以多條件查詢=?and=?//Youmayinclude?sinwhereclauseinthequery,whichwillbereplacedbythevaluesfromselectionArgs.Cursorcursor=db.rawQuery(sql,newString[]{userName});UserBeanbean=null;//Movethecursortothenextrow.while(cursor.moveToNext()){bean=newUserBean();//根據(jù)列索引獲取對應的數(shù)值，因為這?查詢結(jié)果只有?個，我們也不需要對模型UserBean進?修改，//直接將對應?戶名的所有數(shù)據(jù)從表中動態(tài)賦值給beanbean.userName=cursor.getString(cursor.getColumnIndex("userName"));bean.nickName=cursor.getString(cursor.getColumnIndex("nickName"));bean.sex=cursor.getString(cursor.getColumnIndex("sex"));bean.signature=cursor.getString(cursor.getColumnIndex("signature"));bean.qq=cursor.getString(cursor.getColumnIndex("qq"));}cursor.close();returnbean;}//修改個?資料信息,這?的key指代表字段，value表?數(shù)值publicvoidupdateUserInfo(Stringkey,Stringvalue,StringuserName){ContentValuescv=newContentValues();cv.put(key,value);//Conveniencemethodforupdatingrowsinthedatabase.db.update(SQLiteHelper.U_USER_INFO,cv,