Android学生信息管理系统APP

《Android学生信息管理系统APP》由会员分享，可在线阅读，更多相关《Android学生信息管理系统APP（26页珍藏版）》请在装配图网上搜索。

1、wordAndroid学生信息管理系统APP一、 需求分析为了方便的进展对学生数据库的操作，本app可在android设备上进展对学生信息数据库的信息管理功能，具体功能如下：1.对数据库中所有学生某某进展显示，对各个条目进展点击可展开具体信息2. 查询数据：查询数据是根据某某与学号两个条件进展查询，两者满足任一条件如此进展模糊查询，两个条件同时满足如此进展准确查询，查询结果界面与功能一中一样，以某某排列，点击展开所有信息3. 增加数据：在数据库中增添条目，包括某某字符串，学号数字，主键，性别单项选择框，年龄数字，专业字符串。每个条目均有误输入设定，且主键可检查重复性，所有数据可检查完整性，假如

2、插入成功如此会显示一条消息提示成功，假如失败如此会提示检查主键重复或者数据不完整4. 修改数据：根据某某学号进展准确查找，查找成功后转入修改界面，为了防止漏填与便捷修改界面会默认填充之前的数据除学号，修改完毕即可更新，同样会检查数据完整性5. 删除数据：根据某某学号进展准确查找，查找成功如此会进展删除，并显示一条删除成功的提示，假如失败，也会进展提示二、 概念结构设计 ER图：三、 逻辑结构设计学生：某某字符串学号数字，主码性别单项选择框年龄数字专业字符串create table student(name TEXT,NO TEXT Primary Key,sex TEXT,profession

3、 TEXT,age TEXT)四、 具体实现1.主界面：主界面显示所有功能，每个按钮点击后，跳转进入相应功能核心代码：publicclass Main extends Activity SQLiteDatabase db;Button btn_search;Button btn_modify;Button btn_add;Button btn_delete;Button btn_quit;Button btn_show;Overrideprotectedvoid onCreate(Bundle savedInstanceState) requestWindowFeature(Window.FE

4、ATURE_NO_TITLE);getWindow().setFlags(WindowManager.LayoutParams.FLAG_FULLSCREEN, WindowManager.LayoutParams.FLAG_FULLSCREEN);super.onCreate(savedInstanceState);setContentView(R.layout.layout_main);/打开数据库，假如不存在，如此创建db = SQLiteDatabase.openOrCreateDatabase(this.getFilesDir().toString()+/Student.db3, n

5、ull);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_sho

6、w);tryCursor cursor = db.rawQuery(select * from student, null);cursor.close();catch(SQLiteException e)db.execSQL(create table student+ (+ name TEXT,+ NO TEXT Primary Key,+ sex TEXT,+ profession TEXT,+ age TEXT+ );/显示所有数据按钮的功能实现btn_show.setOnClickListener(new OnClickListener()publicvoid onClick(View

7、source) /获取指针Cursor cursor = db.rawQuery(select * from student, null);/判断数据库是否不存在任何数据if(cursor.moveToFirst() = false)Toast.makeText(Main.this, 不存在记录, Toast.LENGTH_SHORT).show();elseList p = new ArrayList();List re_name = new ArrayList();List info = new ArrayList();/保存搜索出的所有数据for(cursor.moveToFirst()

8、 ; !cursor.isAfterLast() ; cursor.moveToNext()int nameColume = cursor.getColumnIndex(name);int NOColume = cursor.getColumnIndex(NO);int proColume = cursor.getColumnIndex(profession);int sexColume = cursor.getColumnIndex(sex);int ageColume = cursor.getColumnIndex(age);Student student = new Student();

9、student.name = 某某:+cursor.getString(nameColume);student.NO = 学号:+cursor.getString(NOColume);student.sex = 性别:+cursor.getString(sexColume);student.profession = 专业:+cursor.getString(proColume);student.age = 年龄:+cursor.getString(ageColume);p.add(student);String temp = student.MakeString();info.add(temp

10、);String newname = cursor.getString(nameColume);re_name.add(newname);/对保存的数据进展封装String Cur_name = new Stringre_name.size();Cur_name = re_name.toArray(Cur_name);String Cur_info = new Stringinfo.size();Cur_info = info.toArray(Cur_info);Bundle bundle = new Bundle();bundle.putStringArray(name, Cur_name)

11、;Student data = new Student();data.info = Cur_info;/将封装的数据传递给结果界面的activityIntent intent = new Intent(Main.this,SearchResult.class);intent.putExtras(bundle);intent.putExtra(data, data);startActivity(intent);cursor.close(););/为剩下的按钮绑定监听器实现跳转功能btn_search.setOnClickListener(new OnClickListener()publicvo

12、id onClick(View source) Intent intent = new Intent(Main.this,Search.class);startActivity(intent););btn_modify.setOnClickListener(new OnClickListener()publicvoid onClick(View source) Intent intent = new Intent(Main.this,Modify.class);startActivity(intent););btn_add.setOnClickListener(new OnClickListe

13、ner()publicvoid onClick(View source) Intent intent = new Intent(Main.this,Add.class);startActivity(intent););btn_delete.setOnClickListener(new OnClickListener()publicvoid onClick(View source) Intent intent = new Intent(Main.this,Delete.class);startActivity(intent););btn_quit.setOnClickListener(new O

14、nClickListener()publicvoid onClick(View source) db.close();finish(););2. 数据显示界面：按某某排列，点击条目展开具体信息核心代码：publicclass SearchResult extends ActivitySuppressLint(RtlHardcoded)publicvoid onCreate(Bundle savedInstanceState)requestWindowFeature(Window.FEATURE_NO_TITLE);getWindow().setFlags(WindowManager.Layou

15、tParams.FLAG_FULLSCREEN, WindowManager.LayoutParams.FLAG_FULLSCREEN);/获取传送来的数据super.onCreate(savedInstanceState);setContentView(R.layout.layout_result);final Intent intent = getIntent();BaseExpandableListAdapter adapter = new BaseExpandableListAdapter()/提取数据Bundle bundle = intent.getExtras();Student

16、 mem_data = (Student) getIntent().getExtras().get(data);String people = (String) bundle.getSerializable(name);String data = mem_data.info;public Object getChild(int groupPosition,int childPosition)returndatagroupPositionchildPosition;publiclong getChildId(int groupPosition,int childPosition)return c

17、hildPosition;publicint getChildrenCount(int groupPosition)returndatagroupPosition.length;/设定每个子选项每行的显示方式private TextView getTextView()AbsListView.LayoutParams lp = new AbsListView.LayoutParams(ViewGroup.LayoutParams.MATCH_PARENT, ViewGroup.LayoutParams.MATCH_PARENT);TextView textView = new TextView(

18、SearchResult.this);textView.setLayoutParams(lp);textView.setGravity(Gravity.CENTER_VERTICAL | Gravity.LEFT);textView.setPadding(36, 0, 0, 0);textView.setTextSize(20);return textView;/设定每个子选项显示内容public View getChildView(int groupPosition , int childPosition,boolean isLastChild,View convertView,ViewGr

19、oup Parent)TextView textView = getTextView();textView.setText( +getChild(groupPosition,childPosition).toString();return textView;public Object getGroup(int groupPosition)returnpeoplegroupPosition;publicint getGroupCount()returnpeople.length;publiclong getGroupId(int groupPosition)return groupPositio

20、n;/设定每个组选项显示内容public View getGroupView(int groupPosition, boolean isExpanded ,View convertView , ViewGroup parnet)LinearLayout ll = new LinearLayout(SearchResult.this);ll.setOrientation(0);TextView textView = getTextView();textView.setText( +getGroup(groupPosition).toString();ll.addView(textView);re

21、turn ll;ExpandableListView expandListView = (ExpandableListView) findViewById(R.id.list);expandListView.setAdapter(adapter);3. 增添数据界面：根据文本框输入内容进展数据的插入，且具有完整性和重复性的判断，插入成功失败均会产生提示核心代码：publicclass Add extends Activity SQLiteDatabase db;Button btn_Accept;Button btn_Cancle;TextView ET_name;TextView ET_NO

22、;TextView ET_Pro;TextView ET_Age;RadioGroup rg;String radio_sex = 男;Overrideprotectedvoid onCreate(Bundle savedInstanceState) requestWindowFeature(Window.FEATURE_NO_TITLE);getWindow().setFlags(WindowManager.LayoutParams.FLAG_FULLSCREEN, WindowManager.LayoutParams.FLAG_FULLSCREEN);super.onCreate(save

23、dInstanceState);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) findViewBy

24、Id(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(new OnCheckedChangeListener()publicvoid onCheckedChanged(Radi

25、oGroup group, int CheckedId)radio_sex = CheckedId = R.id.rad_male ? 男 : 女;);/提交操作btn_Accept.setOnClickListener(new OnClickListener()publicvoid onClick(View source) String name = ET_name.getText().toString();String NO = ET_NO.getText().toString();String sex = radio_sex;String pro = ET_Pro.getText().t

26、oString();String age = ET_Age.getText().toString();/规X性与完整性判断try/插入数据db.execSQL(insert into student values( ?, ?, ?, ?, ?),new String name, NO, sex, pro, age);/规X性与完整性判断catch(SQLiteException e)Toast.makeText(Add.this, 插入数据失败，请检查数据规X性与学号的唯一性, Toast.LENGTH_SHORT).show();return;Toast.makeText(Add.this,

27、 成功插入一条数据:+n+name+n+NO+n+sex+n+pro+n+age, Toast.LENGTH_SHORT).show(););btn_Cancle.setOnClickListener(new OnClickListener()publicvoid onClick(View source) db.close();finish(););4. 修改数据界面：查找界面：对文本框内输入的数据进展准确查找，成功后转入修改界面修改界面：文本框内默认显示之前的数据，修改完成点击确定以文本框内的信息对数据进展更新核心代码：查找：btn_Accept.setOnClickListener(new

28、 OnClickListener()publicvoid onClick(View source) String name = ET_Modify_Name.getText().toString();String NO = ET_Modify_No.getText().toString();Cursor cursor = db.rawQuery(select * from student where + name=?+ and NO=?, new String name, NO);/判断查找结果是否为空if(cursor.moveToFirst() = false)Toast.makeText

29、(Modify.this, 记录不存在, Toast.LENGTH_SHORT).show();elseString mem_name = null;String mem_No = null;String mem_profession = null;String mem_sex = null;String mem_age = null;/保存所有数据for(cursor.moveToFirst() ; !cursor.isAfterLast() ; cursor.moveToNext()int nameColume = cursor.getColumnIndex(name);int NoCol

30、ume = cursor.getColumnIndex(NO);int proColume = cursor.getColumnIndex(profession);int sexColume = cursor.getColumnIndex(sex);int ageColume = cursor.getColumnIndex(age);mem_name = cursor.getString(nameColume);mem_No = cursor.getString(NoColume);mem_profession = cursor.getString(proColume);mem_sex = c

31、ursor.getString(sexColume);mem_age = cursor.getString(ageColume);/封装所有数据Bundle bundle = new Bundle();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);/传递数据Intent intent = new Inten

32、t(Modify.this,ModifyResult.class);intent.putExtras(bundle);startActivity(intent);cursor.close(););btn_Cancle.setOnClickListener(new OnClickListener()publicvoid onClick(View source) / TODO Auto-generated method stubdb.close();finish(););修改：publicclass ModifyResult extends ActivitySQLiteDatabase db;Bu

33、tton btn_accept;Button btn_cancle;TextView TextView_ModifyResult_No;EditText ET_ModifyResult_Name;EditText ET_ModifyResult_pro;EditText ET_ModifyResult_age;RadioGroup rg;String radio_sex;protectedvoid onCreate(Bundle savedInstanceState)super.onCreate(savedInstanceState);setContentView(R.layout.layou

34、t_modifyresult);/获取数据final Intent intent = getIntent();Bundle bundle = 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) findViewBy

35、Id(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) findVi

36、ewById(R.id.ET_ModifyResult_age);rg = (RadioGroup) findViewById(R.id.modify_rg);/设定默认数据String name = bundle.getString(name);final String No = bundle.getString(No);String pro = bundle.getString(profession);String age = bundle.getString(age);radio_sex = bundle.getString(sex);TextView_ModifyResult_No.s

37、etText(No);ET_ModifyResult_Name.setText(name);ET_ModifyResult_pro.setText(pro);ET_ModifyResult_age.setText(age);rg.setOnCheckedChangeListener(new OnCheckedChangeListener()publicvoid onCheckedChanged(RadioGroup group, int CheckedId)radio_sex = CheckedId = R.id.rad_male ? 男 : 女;);btn_accept.setOnClick

38、Listener(new OnClickListener()publicvoid onClick(View source) String new_name = ET_ModifyResult_Name.getText().toString();String new_profession = ET_ModifyResult_pro.getText().toString();String new_age = ET_ModifyResult_age.getText().toString();String new_sex = radio_sex;/更新数据trydb.execSQL(UPDATE st

39、udent + SET name=? ,NO=? ,sex=? ,profession=? ,age=? + WHERE NO=?,new String new_name , No , new_sex , new_profession , new_age , No);catch(SQLiteException e)Toast.makeText(ModifyResult.this, 更新数据失败, Toast.LENGTH_SHORT).show();return;Toast.makeText(ModifyResult.this, 更新数据成功, Toast.LENGTH_SHORT).show

40、();finish(););btn_cancle.setOnClickListener(new OnClickListener()publicvoid onClick(View source) db.close();finish(););5. 查找数据界面：对文本框内的数据进展模糊查询，查询成功如此跳转只查询结果界面，查询失败如此产生相应提示核心代码：publicclass Search extends Activity SQLiteDatabase db;Button btn_Accept;Button btn_Cancle;EditText ET_name;EditText ET_NO;O

41、verrideprotectedvoid onCreate(Bundle savedInstanceState) requestWindowFeature(Window.FEATURE_NO_TITLE);getWindow().setFlags(WindowManager.LayoutParams.FLAG_FULLSCREEN, WindowManager.LayoutParams.FLAG_FULLSCREEN);super.onCreate(savedInstanceState);setContentView(R.layout.layout_search);db = SQLiteDat

42、abase.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_Se

43、arch_NO);btn_Accept.setOnClickListener(new OnClickListener()publicvoid onClick(View source) String name = ET_name.getText().toString();String NO = ET_NO.getText().toString();/获取指针Cursor cursor = db.rawQuery(select * from student where + name=?/+ or + name=?+ or NO=?/+ or + NO=?, new String name, NO)

44、;/检验查找是否为空if(cursor.moveToFirst() = false)Toast.makeText(Search.this, 记录不存在, Toast.LENGTH_SHORT).show();elseToast.makeText(Search.this, 成功, Toast.LENGTH_SHORT).show();/return;List p = new ArrayList();List re_name = new ArrayList();List info = new ArrayList();/保存数据for(cursor.moveToFirst() ; !cursor.i

45、sAfterLast() ; cursor.moveToNext()int nameColume = cursor.getColumnIndex(name);int NOColume = cursor.getColumnIndex(NO);int proColume = cursor.getColumnIndex(profession);int sexColume = cursor.getColumnIndex(sex);int ageColume = cursor.getColumnIndex(age);Student student = new Student();student.name

46、 = 某某:+cursor.getString(nameColume);student.NO = 学号:+cursor.getString(NOColume);student.sex = 性别:+cursor.getString(sexColume);student.profession = 专业:+cursor.getString(proColume);student.age = 年龄:+cursor.getString(ageColume);p.add(student);String temp = student.MakeString();info.add(temp);String new

47、name = cursor.getString(nameColume);re_name.add(newname);/封装数据String Cur_name = new Stringre_name.size();Cur_name = re_name.toArray(Cur_name);String Cur_info = new Stringinfo.size();Cur_info = info.toArray(Cur_info);Bundle bundle = new Bundle();bundle.putStringArray(name, Cur_name);Student data = ne

48、w Student();data.info = Cur_info;/传递数据Intent intent = new Intent(Search.this,SearchResult.class);intent.putExtras(bundle);intent.putExtra(data, data);startActivity(intent);cursor.close(););btn_Cancle.setOnClickListener(new OnClickListener()publicvoid onClick(View source) db.close();finish(););6. 删除数

49、据界面：对文本框内输入的内容进展准确查询，假如查询成功如此对对应的条目进展删除，并提示删除成功，假如失败，如此提示删除失败核心代码：/确定按钮点击后的监听事件btn_Accept.setOnClickListener(new OnClickListener()publicvoid onClick(View source) String name = ET_Modify_Name.getText().toString();String NO = ET_Modify_No.getText().toString();/查询数据Cursor cursor = db.rawQuery(select *

50、from student where + name=?+ and NO=?, new String name, NO);if(cursor.moveToFirst() = false)Toast.makeText(Delete.this, 记录不存在, Toast.LENGTH_SHORT).show();elsetrydb.execSQL(delete from student + where name=?+ and NO=?,new String name, NO);/假如查询失败如此提示删除失败catch(SQLiteException e)Toast.makeText(Delete.t

51、his, 删除失败, Toast.LENGTH_SHORT).show();return;/假如查询成功，如此提示记录已经删除Toast.makeText(Delete.this, 一条记录已删除, Toast.LENGTH_SHORT).show();cursor.close();finish(););/取消按钮点击后的监听事件btn_Cancle.setOnClickListener(new OnClickListener()publicvoid onClick(View source) db.close();finish(););附：student类的定义publicclass Stud

52、ent implements SerializableprivatestaticfinallongserialVersionUID = 1L;public String name;public String NO;public String sex;public String profession;public String age;public String MakeString()String s = name,NO,sex,profession,age;return s;public String info;五、 总结这个安卓app实现了对数据库操作的根本功能，使用起来简便性强，轻便直接

53、，因为是可视化编程，所以对于界面也进展了一定程度的美化，对应的编写平台是手机，所以实现的功能都是以简单实用美观为根底，并且同时保证健壮性为目标，但是同样因为这个原因在查询功能上，功能比拟简单，比如查询操作，只能在满足根本的查询功能上添加简易的模糊查询，并且查找条件比拟单一，因此，仍然可以在此方面做出改良1 / 26计算机科学与技术学院课程设计成绩单课程名称：数据库系统原理课程设计 某某詹博策性别男学号201312237055班级DB1302综合成绩成绩等级程序运行情况占总成绩20%能正确运行 根本能正确运行 能运行但结果不完善20分 15分 10分程序功能完善程度占总成绩10%完善 根本完善

54、不完善10分 8分 5分程序结构的合理性占总成绩10%合理 根本合理 不太合理10分 8分 5分对问题的辩论情况占总成绩40%概念正确有创新 40分能正确回答所有问题 35分根本能正确回答 30分 局部问题回答概念不清晰 20分学生的工作态度与独立工作能力占总成绩10%工作态度认真能独立完成任务 10分工作态度根本认真，独立性尚可 8分工作态度和独立性较差 5分设计报告的规X性占总成绩10%符合规X 根本符合规X 规X性较差10分 8分 5分A：90100分 A-：8589分 B+：8284分 B：7881分 B-：7577分 C+：7274分 C：6871分 C-：6467分 D：6063分 F：60分 某某科技大学计算机科学与技术学院制表