androidstudio個(gè)人資料,AndroidStudio制作個(gè)人資料界面模塊以及SQ

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