java学生成绩管理系统

1、一、设计目的2二、功能介绍2三、程序流程23.1总流程2流程图3四、设计步骤34.1数据库设计34.1.1学生信息表34.1.2教师表4课程表4成绩表44.2功能描述5登录54.2.2教师端8学生端9五、设计总结10六、程序活单10七、参考文献22、设计目的1具有新用户注册功能。2具有注册用户登录功能。3具有学生成绩的录入功能，要求只录入各科成绩，自动计算每个学生的总绩。4具有数据查询功能，可以实现查询全部信息和按条件执行查询。5具有按条件删除数据功能。、功能介绍学生信息管理系统分为两个模块，教师端和学生端，（1）教师端包括的子模块有：教师注册，教师添加学生成绩，教师修改学生成绩，教师删除学生

2、成绩，教师修改登录密码等主要功能。（2）学生端：本模块的功能较少，只有学生查询本人成绩，和修改学生登录密码的功能三、程序流程N四、设计步骤4.1数据库设计本次设计数据库使用SQLSever2005,一共四张表，分别为学生信息表，教师信息表，还有学生成绩表，教师所教的课程表学生信息表学生信息表包括学生姓名，学号，登录密码，性别，年龄，还有一个没有关系的主键，如图_数据类型允许空希!IntBnamevarchar(SO)pwdvarctiarpO)numvardiar50)sexvanar(5O)圜agevardnar(50)ffl图4-1教师表教师信息表包括教师姓名，教师编号，教师登录密码和所教

3、授的课程，和一个没有关系的主键，用来自动增长。如图4-2。列名数据类型允许空卜Ndnintnamevarchar(5O)pwdvardiarfO)numvarchar(5O)ctassesvardir(5O)图4-2课程表课程表为教师所教的课程，其中包括课程编号，课程名，课程学分等。如图4-3列名教据类型id_-”一!nrilllrvilliivi|jj|IHfJintBHUMvarchar(EO)0namevarcharfSO)EJxuefenvarchar(5&)0图4-3成绩表成绩表是教师上成绩之后，所有成绩储存在成绩表中，其中包括课程，学分，学生编号，学期等。如图4-4顶坦_教据类型元

4、许空质jid_IbitEkemuvarcharfSU)SscorevarchdrM0numvarchrfSO)囹xueqivardiar(5(J)0图4-44.2功能描述登录当程序运行的时候，会出现如图4-5的登录，然后根据提示进行选择操作,输入账号和密码，选择登录的类型，登录界面还有注册新用户和修还密码等功能图4-5登录代码如下:if(!name.equals()ifandpwd=(!pwd.equals()if(!type.equals(if(type.equals(sql=Select;选择类型)学生)*fromstudentwherenumiftry(type.equals(教师”)s

5、ql=Select*fromteacherwherenum=+name+andpwd=+rs=db.Query(sql);while(rs.next()pwd;+pwd+name);num);教师)name1=rs.getString(num=rs.getString(if(type.equals(+name+classes=rs.getString(classes);catch(SQLExceptione1)e1.printStackTrace();if(!namel.equals()if(type.equals(学生）Login.this.close();tryDisplaydisplay

6、=Display.getDefault();studentshell=newstudent(display);shell.open();shell.layout();while(!shell.isDisposed()if(!display.readAndDispatch()display.sleep();)catch(Exceptione1)(e1.printStackTrace();)if(type.equals(教师)Login.this.close();tryDisplaydisplay=Display.getDefault();AddChengshell=newAddCheng(dis

7、play);shell.open();shell.layout();while(!shell.isDisposed()if(!display.readAndDispatch()display.sleep();)catch(Exceptione1)e1.printStackTrace();)elseMessageDialog.openError(getShell(),提示，用户名密码错误)；)elseMessageDialog.openWarning(getShell(),提示，你还没选择登录类型)；)elseMessageDialog.openWarning(getShell(),提示，密码不

8、能为空)；)elseMessageDialog.openWarning(getShell(),提示，用户名为空)；)修改密码功能修改在此登录的用户，修改密码的用户必须输入原密码，和新密码才能进行密码的修改。如图4-6修改密码4-6修改密码代码如下:.getText()+where(getShell(),提示提示,修改密码Stringsql=updateteachersetpwd=+text_1num=+Login.num+;booleanb=MessageDialog.openQuestion,是否修改密码)；if(b)db.Update(sql);MessageDialog.openWarn

9、ing(getShell(),成功);注册用户功能点击进入注册用户的功能后，进行相应的提示进行操作，填入对应的教师的信息后点击添加就可以成功的注册一个新的用户了，在进行相关的操作，如图4-7注册图4-7注册新用户代码如下:if(!text(iin+text+text.getText().equals()if(!text_1.getText().equals(if(!text_2.getText().equals(!text_3.getText().equals(Stringsql=+text2.getText()+3.getText()+HlIIIMessageDialog.提示，注册成功if

10、)openQuestion);)insertintoteachervalues.getText()+,+text_1.getText()+Jbooleanb=(getShell(),(b)db.Update(sql);MessageDialog.openWarning(getShell(),提示,是否注册);if教师端登录类型选择教师，进入教师端，此处含有增加，删除，修改和教师修还密码等功能，每一步都有相应的校验。选择功能进行操作。增加学生成绩功能进入之后会有提示，输入学号，成绩，学年等信息，点击确定完成添加学生成绩的操作。如图4-8教师端图4-8教师端代码如下：if(!num.equals(

11、)(if(!fenshu.equals()(if(!xueqi.equals()(Stringsql=insertinto分数values(+kemu+,+fenshu+,+num+,+xueqi+);db.Update(sql);num=;fenshu=;fenye();MessageDialog.openWarning(getShell(),提示,添加成功);)else(MessageDialog.openError(getShell(),提示,学期不能为空);)else(MessageDialog.openError(getShell(),提示，分数不能为空)；)else(Message

12、Dialog.openError(getShell(),提示，学号不能为空);)选择某个人后点击鼠标右键，会出现修改和删除功能。如图4-9鼠标右键功能图4-9鼠标右键功能修改学生成绩选择某个人之后，右键选择修改功能，就会出现如图4-10的界面，修改学号和成绩后点击确定，即可修改学生成绩图4-10修改学生成绩代码如下：Stringsql=updateteachersetpwd=+text_1.getText()+wherenum=+Login.num+openQuestion,是否修改密码ifbooleanb=MessageDialog.);(b)(db.Update(sql);MessageD

13、ialog.openWarning(getShell(),(getShell(),成功);删除学生成绩右键选择删除学生成绩功能，会出现如图4-11的询问框，选择确认，删除此学生的成绩，点击否即为取消删除图4-11删除学生信息代码如下：Stringsql=booleandeletefromtag=MessageDialog.if成绩wherenum=+text_1openQuestion(getShell(),.getText()提示，是否删);(tag)(db.Update(sql);MessageDialog.openWarning(getShell(),);学生端学生端查询学生信息的功能，

14、该功能含有按学年查询，按科目和查询全部等功能，选择功能进行操作，如图4-12图4-12学生查询Select*fromstudentwherenum=+name+andpwd=代码如下：Stringsql=+pwd+;rs=db.Query(sql);try(while(rs.next()(Tableitemtableitem=newTableitem(table,SWT.tableItem.setText(0,+rs.getString(1);tableitem.setText(1,+rs.getString(2);tableitem.setText(2,+rs.getString(3);ta

15、bleitem.setText(3,+rs.getString(4);tableitem.setText(4,+rs.getString(5);tableitem.setText(4,+rs.getString(6);NONE);)catch(SQLExceptione)(e.printStackTrace();)五、设计总结通过几天的课程设计使我懂得了理论与实际相结合是很重要的，只有理论知识是远远不够的，只有把所学的理论知识与实践相结合起来，从理论中得出结论，才能真正为社会效劳，从而提高自己的实际动手能力和独立思考的能力。在设计的过程中遇到问题，可以说得是困难重重，这毕竟第一次真真的做程序设

16、计，难免会遇到过各种各样的问题，同时在设计的过程中发现了自己的缺乏之处，对一些前面学过的知识理解得不够深刻，掌握得不够牢固，比方说结构体，通过这次课程设计之后，我们把前面所学过的知识乂重新温故了一遍。六、程序清单packageStudent;importjava.sql.ResultSet;publicclassAddChengextendsShellprivateTexttext_1;privateTexttext_2;privateTabletable;privateTexttext;publicintstart=0;publicintpage=1;publicintrow_number=

17、0;publicintmaxPage=0;publicintpageSize=5;Stringxueqi;Stringkemu;Combocombo;DBHelperdb=newDBHelper();ResultSetrs;Stringnum;Labellabel_4;* Launchtheapplication.* paramargs*/publicstaticvoidmain(Stringargs)(try(Displaydisplay=Display.getDefault();AddChengshell=newAddCheng(display);shell.open();shell.la

18、yout();while(!shell.isDisposed()if(!display.readAndDispatch()display.sleep();)catch(Exceptione)e.printStackTrace();)* /*Createtheshell.paramdisplay*/publicAddCheng(Displaydisplay)(super(display,SWT.SHELL_TRIM);Labellabel_8=newLabel(this,SWT.BORDER);label_8.setBounds(223,5,94,17);label_8.setText(Logi

19、1);Labellabel_10=newLabel(this,SWT.NONE);label_10.setBounds(352,294,61,17);label_10.setText(u9875);label_4=newLabel(this,SWT.NONE);label_4.setBounds(325,294,21,17);Labellabel=newLabel(this,SWT.NONE);label.setBounds(21,39,35,17);label.setText(u79D1u76EE);Labellabel_1=newLabel(this,SWT.NONE);lab

20、el_1.setBounds(146,39,30,17);label_1.setText(u5B66u53F7);texttexttext=newText(this,SWT.BORDER|SWT.READ_ONLY);.setBounds(60,39,80,23);.setText(Login.classes);texttext11=newText(this,SWT.BORDER);.setBounds(182,39,94,23);Labellabel_2=newLabel(this,SWT.NONE);label_2.setBounds(282,39,35,17);label_2.setTe

21、xt(u6210u7EE9);text_2text2=newText(this,SWT.setBounds(325,39,94,23);BORDER);combocombo2021-2021-1combocombo=newCombo(this,SWT.setItems(newString(,2021-2021-2);.setBounds(466,39,100,25);.select(1);NONE);2021-2021-12021-2021-2kemu=text.getText();xueqi=combo.getText();values(Buttonbutton=newButton(butt

22、on.addSelectionListener(OverridepublicvoidwidgetSelected(SelectionEvente)(Stringnum=text_1.getText();Stringfenshu=text_2.getText();if(!num.equals()(-if(!fenshu.equals(if(!xueqi.equals(Stringsql=+kemu+,+fenshu+,+num+db.Update(sql);num=;fenshu=;this,SWT.NONE);newSelectionAdapter()()()(insertinto分数,+xu

23、eqi+);提示,添fenye();MessageDialog.openWarning(getShell(),加成功);elseMessageDialog.openError(getShell(),提示”，学期不能为空);空)；);elseMessageDialog.openError(getShell(),提示”，分数不能为elseMessageDialog.openError(getShell(),提示，学号不能为空);button.setBounds(572,39,80,27);button.setText(u6DFBu52A0);table=newTable(this,SWT.BORD

24、ER|SWT.FULL_SELECTION);table.addSelectionListener(newSelectionAdapter()OverridepublicvoidwidgetSelected(SelectionEvente)TableItemit=table.getSelection();Tableitemi=it0;num=i.getText(O););table.setBounds(61,82,571,193);table.setHeaderVisible(true);table.setLinesVisible(true);TableColumntblclmnNewColu

25、mn_1=newTableColumn(table,SWT.NONE);tblclmnNewColumn_1.setWidth(109);tblclmnNewColumn_1.setText(u7F16u53F7);TableColumntableColumn=newTableColumn(table,SWT.NONE);tableColumn.setWidth(112);tableColumn.setText(u5B66u53F7);Menumenu=newMenu(table);table.setMenu(menu);MenuItemmenuItem=newMenuItem(menu,SW

26、T.NONE);menuitem.setText(u4FEEu6539);MenuItemmenuItem_1=newMenuItem(menu,SWT.NONE);menuitem_1.addSelectionListener(newSelectionAdapter()OverridepublicvoidwidgetSelected(SelectionEvente)booleantag=MessageDialog.openQuestion(getShell(),提示是否删除)；if(tag);newTableColumn(table,SWT.NONE);menuitem_1.setText(

27、u5220u9664);TableColumntblclmnNewColumn=tblclmnNewColumn.setWidth(108);tblclmnNewColumn.setText(u79D1u76EE）；table,SWT.NONE);table,SWT.NONE);TableColumntableColumn_1=tableColumn_1.setWidth(112);tableColumn_1.setText(TableColumntableColumn_2=tableColumn_2.setWidth(118);tableColumn_2.setText(newTableCo

28、lumn(u6210u7EE9);newTableColumn(u5B66u5E74);+kemu+andxueqi=Stringsql=select*from分数wherekemu=,+xueqi+;rs=db.Query(sql);try(while(rs.next()(row_number+;)catch(SQLExceptione)(e.printStackTrace();if(row_numbermaxPage=else(maxPage=%pageSizerownumberrownumber=0)(pageSizepageSize+1;Buttonbutton_1=newButton

29、(this,SWT.NONE);button_1.addSelectionListener(newSelectionAdapter()(OverridepublicvoidwidgetSelected(SelectionEvente)(if(page-1!=0)(page-;fenye();else(MessageDialog.openError(getShell(),提示，已经是第一页););button_1.setBounds(114,289,80,27);button_1.setText(u4E0Au4E00u9875);Buttonbutton_2=newButton(this,SWT

30、.NONE);button_2.addSelectionListener(newSelectionAdapter()(OverridepublicvoidwidgetSelected(SelectionEvente)(if(pagemaxPage)(page+;fenye();else(MessageDialog.openError(getShell(),提示，已经是最后一页););button_2.setBounds(466,289,80,27);button_2.setText(u4E0Bu4E00u9875);Labellabel_3=newLabel(thislabel_3.setBo

31、unds(425,39,35,17);label_3.setText(u5B66u5E74,SWT.);NONE);Labellabel_5=newLabel(this,SWT.NONE);label_5.setBounds(21,5,61,17);label_5.setText(u6559u5E08u7F16u53F7);Labellabel_6=newLabel(this,SWT.BORDER);label_6.setBounds(88,5,61,17);label_6.setText(Login.num);Labellabel_7=newLabel(this,SWT.NONE);labe

32、l_7.setBounds(167,5,61,17);label_7.setText(u6559u5E08u59D3u540D);Linklink=newLink(this,SWT.NONE);link.addSelectionListener(newSelectionAdapter()OverridepublicvoidwidgetSelected(SelectionEvente)tryDisplaydisplay=Display.getDefault();Changpwdshell=newChangpwd(display);shell.open();shell.layout();while

33、(!shell.isDisposed()if(!display.readAndDispatch()display.sleep();catch(Exceptione1)e1.printStackTrace(););link.setBounds(534,5,53,17);link.setText(u4FEEu6539u5BC6u7801);Linklink_1=newLink(this,SWT.NONE);link_1.addSelectionListener(newSelectionAdapter()OverridepublicvoidwidgetSelected(SelectionEvente

34、)AddCheng.this.close(););link_1.setBounds(611,5,53,17);link_1.setText(u6CE8u9500);Labellabel_9=newLabel(this,SWT.NONE);label_9.setBounds(285,294,61,17);label_9.setText(u7B2C);System.out.println(1);fenye();System.out.println(1);createContents();/*Createcontentsoftheshell.*/protectedtablelabelvoidfeny

35、e().removeAll();4.setText(String.);valueOf(page)+);label_4.setText(page+startStringasc)ask,*fromwheres.k=(page-1)*sql=select分数wherekemu=pageSize;*from(selectrow_number()+kemu+andxueqi=over(orderby+xueqi+)assid+start+ands.k=+(start+pageSize)+System.out.println(sql);rs=db.Query(sql);trywhile(rs.next()

36、Tableitemtableitem=newTableitem(table,SWT.NONE);tableItem.setText(0,+rs.getString(id);tableitem.setText(l,+rs.getString(num);tableitem.setText(2,+rs.getString(kemu);tableitem.setText(3,+rs.getString(score);tableitem.setText(4,+rs.getString(xueqi);* catch(SQLExceptione)e.printStackTrace();protectedvo

37、idcreateContents()setText(u6DFBu52A0u5B66u751Fu6210u7EE9);setSize(690,377);OverrideprotectedvoidcheckSubclass()packageStudent;importorg.eclipse.swt.SWT;publicclassstudentextendsShellprivateTabletable;privateTexttext;privateTexttext_1;/*Launchtheapplication.* paramargs*/publicstaticvoidmain(Stringarg

38、s)tryDisplaydisplay=Display.getDefault();studentshell=newstudent(display);shell.open();shell.layout();while(!shell.isDisposed()if(!display.readAndDispatch()display.sleep();catch(Exceptione)e.printStackTrace();Createtheshell.paramdisplay*/publicstudent(Displaydisplay)super(display,SWT.SHELL_TRIM);tex

39、t_1=newText(this,SWT.BORDER);text_1.setBounds(182,47,89,23);text_1.setText(Ll);Combocombo_1=newCombo(this,SWT.NONE);combo_1.setItems(newStringu5168u90E8u5B66u5E74”2021-2021-1-,2021-2021-2,2021-2021-1,2021-2021-2);combo_1.setBounds(331,47,88,25);combo_1.select(0);Combocombo=newCombo(this,SWT

40、.NONE);combo.setItems(newStringu5168u90E8u79D1u76EEu672Au901Au8FC7,u5DF2u901Au8FC7);combo.setBounds(459,47,88,17);combo.select(0);table=newTable(this,SWT.BORDER|SWT.table.setBounds(40,94,605,222);table.setHeaderVisible(true);table.setLinesVisible(true);newTableColumn(FULL_SELECTION);TableColumntable

41、Column_2=tableColumn_2.setWidth(100);tableColumn_2.setText(TableColumntableColumn_3=tableColumn_3.setWidth(100);tableColumn_3.setText(TableColumntableColumn=tableColumn.setWidth(100);tableColumn.setText(TableColumntableColumn_1=tableColumn_1.setWidth(100);tableColumn_1.setText(u5B66u53F7);newTableCo

42、lumn(u59D3u540D);newTableColumn(u79D1u76EE);newTableColumn(u5206u6570);TableColumntblclmnNewColumn=tblclmnNewColumn.setWidth(100);tblclmnNewColumn.setText(TableColumntableColumn_4=tableColumn_4.setWidth(100);tableColumn_4.setText(table,SWT.NONE);table,SWT.NONE);table,SWT.NONE);table,SWT.NONE);newTab

43、leColumn(table,SWT.NONE);u5B66u5206);newTableColumn(table,SWT.NONE);u5B66u5E74););table,SWT.NONE);TableItemtableItem=tableItem.setText(0,tableItem.setText(1,tableItem.setText(2,tableItem.setText(3,tableItem.setText(4,tableItem.setText(5,newTableItem(041040421);李兴国)；java);90);5);2021-2021-2NONE);Labe

44、l(this,SWT.Labellabel=newlabel.setBounds(24,50,33,17);label.setText(u5B66u53F7);Labellabel_2=newLabel(thislabel_2.setBounds(153,50,61,17);label_2.setText(u59D3u540D,SWT.NONE););Labellabel_4=newLabel(thislabel_4.setBounds(425,50,61,17);label_4.setText(u79D1u76EE”,SWT.NONE););Labellabel_5=newLabel(lab

45、el_5.setBounds(287,50,61,17);this,SWT.NONE);label_5.setText(u5B66u5E74）；Buttonbutton=newButton(this,SWT.NONE);button.setBounds(553,45,80,27);button.setText(u67E5u8BE2);Buttonbutton_1=newButton(this,SWT.NONE);button_1.setBounds(140,339,80,27);button_1.setText(u4E0Au4E00u9875);Labellabel_6=newLabel(th

46、is,SWT.NONE);label_6.setBounds(304,344,26,17);label_6.setText(1);ButtonbtnNewButton=newButton(this,SWT.NONE);btnNewButton.setBounds(416,339,80,27);btnNewButton.setText(u4E0Bu4E00u9875);Linklink=newLink(this,SWT.NONE);link.setBounds(533,10,53,17);link.setText(u4FEEu6539u5BC6u7801);Linklink_1=newLink(

47、this,SWT.NONE);link_1.setBounds(603,10,53,17);link_1.setText(u6CE8u9500);text=newText(this,SWT.BORDER);text.setBounds(59,47,88,23);text.setText(Login.num);createContents();*Createcontentsoftheshell.*/protectedvoidcreateContents()(setText(u5B66u751Fu67E5u8BE2);setSize(687,436);Overrideprotectedvoidch

48、eckSubclass()(/DisablethecheckthatpreventssubclassingofSWTcomponentspackageStudent;importorg.eclipse.jface.dialogs.MessageDialog;publicclassregisextendsShell(privateTexttext;privateTexttext_1;privateTexttext_2;privateTexttext_3;DBHelperdb=newDBHelper();* Launchtheapplication.* paramargs*/publicstati

49、cvoidmain(Stringargs)(try(Displaydisplay=Display.getDefault();regisshell=newregis(display);IIIshell.open();shell.layout();while(!shell.isDisposed()if(!display.readAndDispatch()display.sleep();)catch(Exceptione)e.printStackTrace();)/*Createtheshell.paramdisplay*/publicsuperregis(Displaydisplay)(displ

50、ay,SWT.text_3text3text_2text2text_1text1textSHELL_TRIM);=newText(this,SWT.setBounds(166,184,114,23);=newText(this,SWT.setBounds(166,148,114,23);=newText(this,SWT.setBounds(166,109,114,23);BORDER);BORDER|SWT.PASSWORD);BORDER);newText(this,SWT.BORDER);text.setBounds(166,67,114,23);Labellabel_1=newLabe

51、l(thislabel_1.setBounds(85,70,61,17);label_1.setText(u59D3u540DLabellabel_2=newLabel(thislabel_2.setBounds(85,112,61,17);label_2.setText(u7F16u53F7Labellabel_3=newLabel(label_3.setBounds(85,151,61,17);label_3.setText(u5BC6u7801thisLabellabel=newLabel(thislabel.setBounds(85,187,61,17);label.setText(u

52、79D1u76EE,SWT.NONE););,SWT.NONE););,SWT.NONE););,SWT.NONE)；);Labellabel_4=newLabel(this,SWT.CENTER);label_4.setFont(SWTResourceManager.getFont(隶书”，21,SWT.NORMAL);label_4.setBounds(146,10,195,36);label_4.setText(u6CE8u518Cu65B0u7528u6237);Buttonbutton=newButton(this,SWT.NONE);button.addSelectionListe

53、ner(newSelectionAdapter()Overridepublicif(!voidtextif(!widgetSelected(SelectionEvente).getText().equals()text_1if(+text.getText()+xt_3.getText()+)HIIII.getText().equals(!text_2.getText().equals(if(!text_3.getText().equals(Stringsql=+text_2.getText()+)insertintoteachervalues,+text_1.getText()+booleanb=MessageDialog.MessageDialog.openWarning(getShell(),“提openQuestion(g