Android學(xué)生信息標(biāo)準(zhǔn)管理系統(tǒng)APP

Android學(xué)生信息管理系統(tǒng)APP需求分析為了方便進(jìn)行對(duì)學(xué)生數(shù)據(jù)庫(kù)操作，本app可在android設(shè)備上進(jìn)行對(duì)學(xué)生信息數(shù)據(jù)庫(kù)信息管理功效，具體功效以下：

1.對(duì)數(shù)據(jù)庫(kù)中全部學(xué)生姓名進(jìn)行顯示，對(duì)各個(gè)條目進(jìn)行點(diǎn)擊可展開具體信息查詢數(shù)據(jù)：查詢數(shù)據(jù)是依據(jù)姓名和學(xué)號(hào)兩個(gè)條件進(jìn)行查詢，二者滿足任一條件則進(jìn)行模糊查詢，兩個(gè)條件同時(shí)滿足則進(jìn)行正確查詢，查詢結(jié)果界面和功效一中相同，以姓名排列，點(diǎn)擊展開全部信息增加數(shù)據(jù)：在數(shù)據(jù)庫(kù)中增添?xiàng)l目，包含姓名（字符串），學(xué)號(hào)（數(shù)字，主鍵），性別（單選框），年紀(jì)（數(shù)字），專業(yè)（字符串）。每個(gè)條目全部有誤輸入設(shè)定，且主鍵可檢驗(yàn)反復(fù)性，全部數(shù)據(jù)可檢驗(yàn)完整性，若插入成功則會(huì)顯示一條消息提醒成功，若失敗則會(huì)提醒檢驗(yàn)主鍵反復(fù)或數(shù)據(jù)不完整修改數(shù)據(jù)：依據(jù)姓名學(xué)號(hào)進(jìn)行正確查找，查找成功后轉(zhuǎn)入修改界面，為了預(yù)防漏填和便捷修改界面會(huì)默認(rèn)填充之前數(shù)據(jù)（除學(xué)號(hào)），修改完成即可更新，一樣會(huì)檢驗(yàn)數(shù)據(jù)完整性刪除數(shù)據(jù)：依據(jù)姓名學(xué)號(hào)進(jìn)行正確查找，查找成功則會(huì)進(jìn)行刪除，并顯示一條刪除成功提醒，若失敗，也會(huì)進(jìn)行提醒概念結(jié)構(gòu)設(shè)計(jì)ER圖：邏輯結(jié)構(gòu)設(shè)計(jì)學(xué)生：姓名（字符串）學(xué)號(hào)（數(shù)字，主碼）性別（單選框）年紀(jì)（數(shù)字）專業(yè)（字符串）createtablestudent( nameTEXT, NOTEXTPrimaryKey, sexTEXT, professionTEXT, ageTEXT)具體實(shí)現(xiàn)1.主界面：主界面顯示全部功效，每個(gè)按鈕點(diǎn)擊后，跳轉(zhuǎn)進(jìn)入對(duì)應(yīng)功效關(guān)鍵代碼：publicclassMainextendsActivity{ SQLiteDatabasedb; Buttonbtn_search; Buttonbtn_modify; Buttonbtn_add; Buttonbtn_delete; Buttonbtn_quit; Buttonbtn_show; @Override protectedvoidonCreate(BundlesavedInstanceState){ requestWindowFeature(Window.FEATURE_NO_TITLE); getWindow().setFlags(WindowManager.LayoutParams.FLAG_FULLSCREEN,WindowManager.LayoutParams.FLAG_FULLSCREEN); super.onCreate(savedInstanceState); setContentView(R.layout.layout_main); //打開數(shù)據(jù)庫(kù)，若不存在，則創(chuàng)建 db=SQLiteDatabase.openOrCreateDatabase(this.getFilesDir().toString()+"/Student.db3",null); btn_search=(Button)findViewById(R.id.btn_search); btn_modify=(Button)findViewById(R.id.btn_modify); btn_add=(Button)findViewById(R.id.btn_add); btn_delete=(Button)findViewById(R.id.btn_delete); btn_quit=(Button)findViewById(R.id.btn_quit); btn_show=(Button)findViewById(R.id.Btn_show); try { Cursorcursor=db.rawQuery("select*fromstudent",null); cursor.close(); } catch(SQLiteExceptione) { db.execSQL("createtablestudent" +"(" +" nameTEXT," +" NOTEXTPrimaryKey," +" sexTEXT," +" professionTEXT," +" ageTEXT" +")"); } //顯示全部數(shù)據(jù)按鈕功效實(shí)現(xiàn) btn_show.setOnClickListener(newOnClickListener() { publicvoidonClick(Viewsource){//獲取指針 Cursorcursor=db.rawQuery("select*fromstudent",null); //判定數(shù)據(jù)庫(kù)是否不存在任何數(shù)據(jù) if(cursor.moveToFirst()==false) { Toast.makeText(Main.this,"不存在統(tǒng)計(jì)",Toast.LENGTH_SHORT).show(); } else { List<Student>p=newArrayList<Student>(); List<String>re_name=newArrayList<String>(); List<String[]>info=newArrayList<String[]>(); //保留搜索出全部數(shù)據(jù) for(cursor.moveToFirst();!cursor.isAfterLast();cursor.moveToNext()) { intnameColume=cursor.getColumnIndex("name"); intNOColume=cursor.getColumnIndex("NO"); intproColume=cursor.getColumnIndex("profession"); intsexColume=cursor.getColumnIndex("sex"); intageColume=cursor.getColumnIndex("age"); Studentstudent=newStudent(); ="姓名:"+cursor.getString(nameColume); student.NO="學(xué)號(hào):"+cursor.getString(NOColume); student.sex="性別:"+cursor.getString(sexColume); fession="專業(yè):"+cursor.getString(proColume); student.age="年紀(jì):"+cursor.getString(ageColume); p.add(student); String[]temp=student.MakeString(); info.add(temp); Stringnewname=cursor.getString(nameColume); re_name.add(newname); }//對(duì)保留數(shù)據(jù)進(jìn)行封裝 String[]Cur_name=newString[re_name.size()]; Cur_name=re_name.toArray(Cur_name); String[][]Cur_info=newString[info.size()][]; Cur_info=info.toArray(Cur_info); Bundlebundle=newBundle(); bundle.putStringArray("name",Cur_name); Studentdata=newStudent(); =Cur_info; //將封裝數(shù)據(jù)傳輸給結(jié)果界面activity Intentintent=newIntent(Main.this,SearchResult.class); intent.putExtras(bundle); intent.putExtra("data",data); startActivity(intent); cursor.close(); } } }); //為剩下按鈕綁定監(jiān)聽器實(shí)現(xiàn)跳轉(zhuǎn)功效 btn_search.setOnClickListener(newOnClickListener() { publicvoidonClick(Viewsource){ Intentintent=newIntent(Main.this,Search.class); startActivity(intent); } }); btn_modify.setOnClickListener(newOnClickListener() { publicvoidonClick(Viewsource){ Intentintent=newIntent(Main.this,Modify.class); startActivity(intent); } }); btn_add.setOnClickListener(newOnClickListener() { publicvoidonClick(Viewsource){ Intentintent=newIntent(Main.this,Add.class); startActivity(intent); } }); btn_delete.setOnClickListener(newOnClickListener() { publicvoidonClick(Viewsource){ Intentintent=newIntent(Main.this,Delete.class); startActivity(intent); } }); btn_quit.setOnClickListener(newOnClickListener() { publicvoidonClick(Viewsource){ db.close(); finish(); } }); }}數(shù)據(jù)顯示界面：按姓名排列，點(diǎn)擊條目展開具體信息關(guān)鍵代碼：publicclassSearchResultextendsActivity{ @SuppressLint("RtlHardcoded") publicvoidonCreate(BundlesavedInstanceState) { requestWindowFeature(Window.FEATURE_NO_TITLE); getWindow().setFlags(WindowManager.LayoutParams.FLAG_FULLSCREEN,WindowManager.LayoutParams.FLAG_FULLSCREEN); //獲取傳送來數(shù)據(jù) super.onCreate(savedInstanceState); setContentView(R.layout.layout_result); finalIntentintent=getIntent(); BaseExpandableListAdapteradapter=newBaseExpandableListAdapter() {//提取數(shù)據(jù) Bundlebundle=intent.getExtras(); Studentmem_data=(Student)getIntent().getExtras().get("data"); String[]people=(String[])bundle.getSerializable("name"); String[][]data=mem_; publicObjectgetChild(intgroupPosition,intchildPosition) { returndata[groupPosition][childPosition]; } publiclonggetChildId(intgroupPosition,intchildPosition) { returnchildPosition; } publicintgetChildrenCount(intgroupPosition) { returndata[groupPosition].length; } //設(shè)定每個(gè)子選項(xiàng)每行顯示方法 privateTextViewgetTextView() { AbsListView.LayoutParamslp=newAbsListView.LayoutParams( ViewGroup.LayoutParams.MATCH_PARENT,ViewGroup.LayoutParams.MATCH_PARENT); TextViewtextView=newTextView(SearchResult.this); textView.setLayoutParams(lp); textView.setGravity(Gravity.CENTER_VERTICAL|Gravity.LEFT); textView.setPadding(36,0,0,0); textView.setTextSize(20); returntextView; } //設(shè)定每個(gè)子選項(xiàng)顯示內(nèi)容 publicViewgetChildView(intgroupPosition,intchildPosition,booleanisLastChild,ViewconvertView,ViewGroupParent) { TextViewtextView=getTextView(); textView.setText(""+getChild(groupPosition,childPosition).toString()); returntextView; } publicObjectgetGroup(intgroupPosition) { returnpeople[groupPosition]; } publicintgetGroupCount() { returnpeople.length; } publiclonggetGroupId(intgroupPosition) { returngroupPosition; } //設(shè)定每個(gè)組選項(xiàng)顯示內(nèi)容 publicViewgetGroupView(intgroupPosition,booleanisExpanded,ViewconvertView,ViewGroupparnet) { LinearLayoutll=newLinearLayout(SearchResult.this); ll.setOrientation(0); TextViewtextView=getTextView(); textView.setText(""+getGroup(groupPosition).toString()); ll.addView(textView); returnll; } }; ExpandableListViewexpandListView=(ExpandableListView)findViewById(R.id.list); expandListView.setAdapter(adapter); }}增添數(shù)據(jù)界面：依據(jù)文本框輸入內(nèi)容進(jìn)行數(shù)據(jù)插入，且含有完整性和反復(fù)性判定，插入成功失敗均會(huì)產(chǎn)生提醒關(guān)鍵代碼：publicclassAddextendsActivity{ SQLiteDatabasedb; Buttonbtn_Accept; Buttonbtn_Cancle; TextViewET_name; TextViewET_NO; TextViewET_Pro; TextViewET_Age; RadioGrouprg; Stringradio_sex="男"; @Override protectedvoidonCreate(BundlesavedInstanceState){ requestWindowFeature(Window.FEATURE_NO_TITLE); getWindow().setFlags(WindowManager.LayoutParams.FLAG_FULLSCREEN,WindowManager.LayoutParams.FLAG_FULLSCREEN); super.onCreate(savedInstanceState); setContentView(R.layout.layout_add); db=SQLiteDatabase.openDatabase(this.getFilesDir().toString()+"/Student.db3",null,SQLiteDatabase.OPEN_READWRITE); btn_Accept=(Button)findViewById(R.id.btn_Accept); btn_Cancle=(Button)findViewById(R.id.btn_Cancle); ET_name=(TextView)findViewById(R.id.ET_Add_name); ET_NO=(TextView)findViewById(R.id.ET_Add_NO); ET_Pro=(TextView)findViewById(R.id.ET_Add_Pro); ET_Age=(TextView)findViewById(R.id.ET_Add_Age); rg=(RadioGroup)findViewById(R.id.rg); rg.setOnCheckedChangeListener(newOnCheckedChangeListener(){ publicvoidonCheckedChanged(RadioGroupgroup,intCheckedId){ radio_sex=CheckedId==R.id.rad_male?"男":"女"; } }); //提交操作 btn_Accept.setOnClickListener(newOnClickListener() { publicvoidonClick(Viewsource){ Stringname=ET_name.getText().toString(); StringNO=ET_NO.getText().toString(); Stringsex=radio_sex; Stringpro=ET_Pro.getText().toString(); Stringage=ET_Age.getText().toString(); //規(guī)范性和完整性判定 try { //插入數(shù)據(jù) db.execSQL("insertintostudentvalues(?,?,?,?,?)",newString[]{name,NO,sex,pro,age}); } //規(guī)范性和完整性判定 catch(SQLiteExceptione) { Toast.makeText(Add.this,"插入數(shù)據(jù)失敗，請(qǐng)檢驗(yàn)數(shù)據(jù)規(guī)范性和學(xué)號(hào)唯一性",Toast.LENGTH_SHORT).show(); return; } Toast.makeText(Add.this,"成功插入一條數(shù)據(jù):"+"\n"+name+"\n"+NO+"\n"+sex+"\n"+pro+"\n"+age,Toast.LENGTH_SHORT).show(); } }); btn_Cancle.setOnClickListener(newOnClickListener() { publicvoidonClick(Viewsource){ db.close(); finish(); } }); }}修改數(shù)據(jù)界面：查找界面：對(duì)文本框內(nèi)輸入數(shù)據(jù)進(jìn)行正確查找，成功后轉(zhuǎn)入修改界面修改界面：文本框內(nèi)默認(rèn)顯示之前數(shù)據(jù)，修改完成點(diǎn)擊確定以文本框內(nèi)信息對(duì)數(shù)據(jù)進(jìn)行更新關(guān)鍵代碼：查找：btn_Accept.setOnClickListener(newOnClickListener() { publicvoidonClick(Viewsource){ Stringname=ET_Modify_Name.getText().toString(); StringNO=ET_Modify_No.getText().toString(); Cursorcursor=db.rawQuery("select*fromstudentwhere" +"name=?" +"andNO=?" ,newString[]{name,NO}); //判定查找結(jié)果是否為空 if(cursor.moveToFirst()==false) { Toast.makeText(Modify.this,"統(tǒng)計(jì)不存在",Toast.LENGTH_SHORT).show(); } else { Stringmem_name=null; Stringmem_No=null; Stringmem_profession=null; Stringmem_sex=null; Stringmem_age=null; //保留全部數(shù)據(jù) for(cursor.moveToFirst();!cursor.isAfterLast();cursor.moveToNext()) { intnameColume=cursor.getColumnIndex("name"); intNoColume=cursor.getColumnIndex("NO"); intproColume=cursor.getColumnIndex("profession"); intsexColume=cursor.getColumnIndex("sex"); intageColume=cursor.getColumnIndex("age"); mem_name=cursor.getString(nameColume); mem_No=cursor.getString(NoColume); mem_profession=cursor.getString(proColume); mem_sex=cursor.getString(sexColume); mem_age=cursor.getString(ageColume); } //封裝全部數(shù)據(jù) Bundlebundle=newBundle(); bundle.putString("name",mem_name); bundle.putString("No",mem_No); bundle.putString("profession",mem_profession); bundle.putString("sex",mem_sex); bundle.putString("age",mem_age); //傳輸數(shù)據(jù) Intentintent=newIntent(Modify.this,ModifyResult.class); intent.putExtras(bundle); startActivity(intent); cursor.close(); } } }); btn_Cancle.setOnClickListener(newOnClickListener() { publicvoidonClick(Viewsource){ //TODOAuto-generatedmethodstub db.close(); finish(); } });修改：publicclassModifyResultextendsActivity{ SQLiteDatabasedb; Buttonbtn_accept; Buttonbtn_cancle; TextViewTextView_ModifyResult_No; EditTextET_ModifyResult_Name; EditTextET_ModifyResult_pro; EditTextET_ModifyResult_age; RadioGrouprg; Stringradio_sex; protectedvoidonCreate(BundlesavedInstanceState){ super.onCreate(savedInstanceState); setContentView(R.layout.layout_modifyresult); //獲取數(shù)據(jù) finalIntentintent=getIntent(); Bundlebundle=intent.getExtras(); db=SQLiteDatabase.openDatabase(this.getFilesDir().toString()+"/Student.db3",null,SQLiteDatabase.OPEN_READWRITE); btn_accept=(Button)findViewById(R.id.btn_modifyresult_accept); btn_cancle=(Button)findViewById(R.id.btn_modifyresult_cancle); TextView_ModifyResult_No=(TextView)findViewById(R.id.TextView_ModifyResult_No); ET_ModifyResult_Name=(EditText)findViewById(R.id.ET_ModifyResult_Name); ET_ModifyResult_pro=(EditText)findViewById(R.id.ET_ModifyResult_pro); ET_ModifyResult_age=(EditText)findViewById(R.id.ET_ModifyResult_age); rg=(RadioGroup)findViewById(R.id.modify_rg); //設(shè)定默認(rèn)數(shù)據(jù) Stringname=bundle.getString("name"); finalStringNo=bundle.getString("No"); Stringpro=bundle.getString("profession"); Stringage=bundle.getString("age"); radio_sex=bundle.getString("sex"); TextView_ModifyResult_No.setText(No); ET_ModifyResult_Name.setText(name); ET_ModifyResult_pro.setText(pro); ET_ModifyResult_age.setText(age); rg.setOnCheckedChangeListener(newOnCheckedChangeListener(){ publicvoidonCheckedChanged(RadioGroupgroup,intCheckedId){ radio_sex=CheckedId==R.id.rad_male?"男":"女"; } }); btn_accept.setOnClickListener(newOnClickListener() { publicvoidonClick(Viewsource){ Stringnew_name=ET_ModifyResult_Name.getText().toString(); Stringnew_profession=ET_ModifyResult_pro.getText().toString(); Stringnew_age=ET_ModifyResult_age.getText().toString(); Stringnew_sex=radio_sex; //更新數(shù)據(jù) try { db.execSQL("UPDATEstudent" +"SETname=?,NO=?,sex=?,profession=?,age=?" +"WHERENO=?", newString[]{new_name,No,new_sex,new_profession,new_age,No}); } catch(SQLiteExceptione) { Toast.makeText(ModifyResult.this,"更新數(shù)據(jù)失敗",Toast.LENGTH_SHORT).show(); return; } Toast.makeText(ModifyResult.this,"更新數(shù)據(jù)成功",Toast.LENGTH_SHORT).show(); finish(); } }); btn_cancle.setOnClickListener(newOnClickListener() { publicvoidonClick(Viewsource){ db.close(); finish(); } }); }}查找數(shù)據(jù)界面：對(duì)文本框內(nèi)數(shù)據(jù)進(jìn)行模糊查詢，查詢成功則跳轉(zhuǎn)只查詢結(jié)果界面，查詢失敗則產(chǎn)生對(duì)應(yīng)提醒關(guān)鍵代碼：publicclassSearchextendsActivity{ SQLiteDatabasedb; Buttonbtn_Accept; Buttonbtn_Cancle; EditTextET_name; EditTextET_NO; @Override protectedvoidonCreate(BundlesavedInstanceState){ requestWindowFeature(Window.FEATURE_NO_TITLE); getWindow().setFlags(WindowManager.LayoutParams.FLAG_FULLSCREEN,WindowManager.LayoutParams.FLAG_FULLSCREEN); super.onCreate(savedInstanceState); setContentView(R.layout.layout_search); db=SQLiteDatabase.openDatabase(this.getFilesDir().toString()+"/Student.db3",null,SQLiteDatabase.OPEN_READWRITE); btn_Accept=(Button)findViewById(R.id.btn_Accept); btn_Cancle=(Button)findViewById(R.id.btn_Cancle); ET_name=(EditText)findViewById(R.id.ET_Search_name); ET_NO=(EditText)findViewById(R.id.ET_Search_NO); btn_Accept.setOnClickListener(newOnClickListener() { publicvoidonClick(Viewsource){ Stringname=ET_name.getText().toString(); StringNO=ET_NO.getText().toString(); //獲取指針 Cursorcursor=db.rawQuery("select*fromstudentwhere" +"name=?"http://+"or"+"name=?" +"orNO=?"http://+"or"+"NO=?" ,newString[]{name,NO}); //檢驗(yàn)查找是否為空 if(cursor.moveToFirst()==false) { Toast.makeText(Search.this,"統(tǒng)計(jì)不存在",Toast.LENGTH_SHORT).show(); } else { Toast.makeText(Search.this,"成功",Toast.LENGTH_SHORT).show(); //return; List<Student>p=newArrayList<Student>(); List<String>re_name=newArrayList<String>(); List<String[]>info=newArrayList<String[]>(); //保留數(shù)據(jù) for(cursor.moveToFirst();!cursor.isAfterLast();cursor.moveToNext()) { intnameColume=cursor.getColumnIndex("name"); intNOColume=cursor.getColumnIndex("NO"); intproColume=cursor.getColumnIndex("profession"); intsexColume=cursor.getColumnIndex("sex"); intageColume=cursor.getColumnIndex("age"); Studentstudent=newStudent(); ="姓名:"+cursor.getString(nameColume); student.NO="學(xué)號(hào):"+cursor.getString(NOColume); student.sex="性別:"+cursor.getString(sexColume); fession="專業(yè):"+cursor.getString(proColume); student.age="年紀(jì):"+cursor.getString(ageColume); p.add(student); String[]temp=student.MakeString(); info.add(temp); Stringnewname=cursor.getString(nameColume); re_name.add(newname); } //封裝數(shù)據(jù) String[]Cur_name=newString[re_name.size()]; Cur_name=re_name.toArray(Cur_name); String[][]Cur_info=newString[info.size()][]; Cur_info=info.toArray(Cur_info); Bundlebundle=newBundle(); bundle.putStringArray("name",Cur_name); Studentdata=newStudent(); =Cur_info; //傳輸數(shù)據(jù) Intentintent=newIntent(Search.this,SearchResult.class); intent.putExtras(bundle); intent.putExtra("data",data); startActivity(intent); cursor.close(); } } }); btn_Cancle.setOnClickListener(newOnClickListener() { publicvoidonClick(Viewsource){ db.close(); finish(); } }); }}刪除數(shù)據(jù)界面：對(duì)文本框內(nèi)輸入內(nèi)容進(jìn)行正確查詢，若查詢成功則對(duì)對(duì)應(yīng)條目進(jìn)行刪除，并提醒刪除成功，若失敗，則提醒刪除失敗關(guān)鍵代碼：//確定按鈕點(diǎn)擊后監(jiān)聽事件 btn_Accept.setOnClickListener(newOnClickListener() { publicvoidonClick(Viewsource){ Stringname=ET_Modify_Name.getText().toString(); StringNO=ET_Modify_No.getText().toString(); //查詢數(shù)據(jù) Cursorcursor=db.rawQuery("select*fromstudentwhere" +"name=?" +"andNO=?" ,newString[]{name,NO}); if(cursor.moveToFirst()==false) { Toas