学生学籍管理系统(含java源代码)

1、学生学籍管理详细设计一、设计题目：学生学籍管理二：设计内容：设计GUI学生学籍管理界面，用户可以加入学生信息，并对基本信息进行修改，添加，查询，删除。三二设计要求二进行简单的学生信息管理。四：总体设计登陆界面的设计2)主窗体的设计3)添加学生信息查询学生信息修改学生信息(6)删除学生信息事件响应的处理五：具体设计程序结构的说明:A. 入口程序：student, java；B.登陆界面程序：mainframe.java；C.主窗体程序：interfac.java；D.添加信息窗口程序：tj.java；E.修改信息窗口程序:xg.java；F.查询信息窗口程序：ex.java；G.删除信息窗口型序

2、：sc.java；H.程序数据连才妥：DatabaseConn.java；程序代码及分析说明A.程序源代码（已提交）B. Student.java是程序的入口。使登录窗口位于窗口中间，并且不可改变窗口大小。C. mainframe.java是程序的登陆窗体。输入用户名和密码（用户名和密码在数据库的password表中）点击“进入系统”，然后登陆界面消失；出现要操作的界面（屏幕左上角）。D.tj.java是添加信息界面。添加基本信息后，钮，点击“添加信息”按将信息加入xinxi表中。E.xgjava是修改信息界面。输入要修改的学号或姓名（两者数其一或全部输入）5并输入所有信息，点击存在此学号，则

3、弹出对话框“无此学生信息八F.sc.java是删除信息界面。V参改信息”按钮（如果数据库中不学号，点击弹出最认删除对话框，即可删除该生），若有则修改。信息。输入要删除的学生的G.ex.java是查询信息界面。输入要查“删除信息”按钮，询的学生学号，点击“信息查询”按钮，在相应的文本区里显示查询的信息。H：源代码/student,java：程序的入口。初始化界面，使主界面位于屏幕中间，且用户不能改变大小/功能：完成程序的执行顺序importjavax.swing.UlManager；importjava.awt.*；importjava.sql./importscreenpub I i c cl

4、 ass studentbooleanpackFrame=false；/JFrameframe二newJFrame()：pubIicstudent()mainframeframe二newmainframe()：if(packFrame)frame,pack()；eIseframe,vaIidate()；Dimensionscreensize二TooIkit.getDefauItTooIkit().getScreenSize()；Dimensionframesize=frame.getsize()；if(framesize.heightscreenSize.height)framesize.he

5、ight二screensize.height；if(frameSize.widthscreenSize.width)framesize.width二screensize.width；frame.setLocation(screensize.width-frameSize.width)/2,(screensize.height-frameSize.height)/2)；frame.setVisib|e(true)；pubIicstaticvoidmain(Stringargs)tryUIManager.setLookAndFeel(UIManager.getSystemLookAndFeelCl

6、assName();catch(Exceptione)e.printStackTrace()；newstudent()；/数据库连接/packagesql.database；importjava.sql.pubIicclassDatabaseConnprivatestaticStringuser=l111-privatestaticStringpassword11l,H：privateConnectionconn二null；privateStatementstmt二null；privateResultSetrs二null；statictryClass.forName(sun.jdbc.odbc

7、.JdbcOdbcDriver)；/加载驱动catch(ClassNotFoundExceptione)/创建数据库连接对象pubIicConnectiongetConnectionOtryconn二DriverManager.getConnection(jdbc:odbc:stu,user,password)；returnconn；catch(SQLExceptione)returnnulI；pubIicStatementcreateStat()tryconn二getConnection()；strut二conn.createStatement()；returnstmt；catch(SQLE

8、xceptione)returnnu|I；pubIicResultSetgetRs(Stringsql)tryconn二getConnection()；/.stmt=createStat()；rs二stnrt.executeQuery(sqI)；returnrs；catch(SQLExceptione)returnnull；pubIicvoidclose()tryif(rs!=null)rs.cIose()；if(stmt!=nuII)stmt,cIose()；if(conn!二nuII)conn,cIose()；catch(SQLExceptionex)ex.printStackTrace(

9、)；/mainframe,javaimportjava,awt.*；importjava,awt.event.*；importjavax.swing.*；importjava.sql.pubIicclassmainframeextendsJFrameimplementsActionListenerstaticmainframes：staticJPanelpan二newJPanel()；staticJLabellabel1二newJLabel(用户”);staticJLabellabel2二newJLabel(密码):staticJTextFieldtextFieldl二newJTextFiel

10、dO：staticJPasswordFieldpassword二newJPasswordField()：staticJButtonbuttonl二newJButton(H进入系统”)；staticJRadioButtonradioButton仁newJRadioButton(staticJRadioButtonradioButton2二new官理贝,true)；/JRadioButton(staticJRadioButtonradioButton3二newJRadioButton(ButtonGroupbuttonGroup=newButtonGroup()；学生学pubIicmainfram

11、e()JLabeIlabel二newJLabeI(newImageIcon(H图片44.jpg11)；label,setsize(400,400)；pan.add(label)；pan.setLayout(null)；pan.setsize(400,400)；this.setTitle(H学籍管理系统”)；this.setsize(400,400)；this.setLayout(nuII)；Iabe11.setBounds(100,25,49,20)；textFieId1.setBounds(155,24,120,20)；Iabe12.setBounds(100,62,49,20)；passw

12、ord,setBounds(155,61,120,20)；buttonl.setBounds(150,200,101,22)；radioButtonl.setBounds(105,120,80,20)；radioButton2.setBounds(180,120,60,20)；radioButton3.setBounds(240,120,60,20)；buttord.addActionListener(this)；buttonGroup,add(radioButtord)；buttonGroup.add(radioButton2)；buttonGroup,add(radioButton3)；t

13、his.add(radioButtonl)；this.add(radioButton2)；this.add(radioButton3)；this.add(Iabe11)；this.add(Iabe12)；this.add(textFieldl)；this.add(password)；this.add(buttord)；this.add(pan)；this.setDefaultCloseOperation(JFrame.EXIT_0N_CL0SE)；this.setVisibIe(true)；pubIicstaticvoidmain(Stringargs)newmainframe()；pubIi

14、cvoidactionPerformed(ActionEvente)if(radioButtonl.isSeIected0)/管理员if(textFieldl.getText().equals(syc)&password.getText().equaIs(123)interfacb=newinterfac()：this.dispose()；/JOptionPane.showMessageDiaIog(nuII,登陆成功)；e i se(Hl1,equaIs(textFieldl.getText(),n.equaIs(password.getText()JOptionPane.showMessa

15、geDiaIog(nuII,用户名或密码不能为空”)；elseJOptionPane.showMessageDiaIog(nuII,用户名或密码输人有误“)；)if(radioButton2.isSelectedO)/学生(tryClass.forName(sun.jdbc.odbc.JdbcOdbcDriver11)；catch(ClassNotFoundExceptionce)JOptionPane.showMessageDialog(s,ce.getMessageO)；tryConnectioncon二DriveManagegetConnection(jdbc：odbc：stiT,sa,

16、；Statementstmt二con.createStatementO；ResultSetrs二stmt.executeQuery(select*frompasswordwhere用户名二1n+textField1,getText0+H,and密码二in+password.getText()+111)；if(textFie|cH.getText().equaIs(lin)|password,getText().equaIs()JOptionPane.showMessageDiaIog(this,用户名或密码不可为空！”)；elseif(rs.next()newinterfac():eIseJO

17、ptionPane.showMessageDialog(this,您的输入有误，/stmt,cIose()；catch(SQLExceptionse)JOptionPane.showMessageDialog(s,se.getMessage()；/interface.javaimportjava.awt.*；importjava.awt.event.*；importjavax.swing.*；pubIicclassinterfacextendsJFrameimpIementsActionListenerstaticJMenuBarjMenuBar二newJMenuBar()；/staticJM

18、enujMenuFiIe二newJMenu(文件菜单条菜单项“)；/staticJMenujMenuExit二newJMenu(退出staticJMenultemstaticJMenultemstaticJMenultemjMenultem4二newjMenulteml一.jMenultem2二jMenultem3二JMenultemC1newJMenultemC1添加信息”）；/菜单pt百newnewJMenultemC1JMenultemCstaticJMenultemstatJLabelstatJLabellabel3newJLabel(nIabel4newJLabel(n请选择操作项s

19、tatJButtonnew_new二new二newstatJButtonstatJButtonstatJButton忡.setTitle(学籍管理系统”)；修改倍息学籍管理系统添加信息pubIcInterfac()IfWthis.setLayout(nuII)：this.setsize(400,400)；缶息查询Iabe13,setBounds(15&92,9&33)；少)；Iabe13,setFont(newFont(DiaIog,除倚属15)；label4.setFont(newFont(Dialog,Font.BOLD720)；Iabe14.setBounds(157,37,280,40

20、)；button2.setBounds(74,136,97,33)；buttons.setBounds(226,136,97,33)；button4.setBounds(74,185,97,33)；button5.setBounds(226,185,97,33)；this.add(button2)；this.add(buttons)；this.add(button；this.add(button5)；this.add(Iabe13)；this.add(Iabe14)；setJMenuBar(jMenuBar)；jMenuFiIe.add(jMenulteml)；/乃文件菜单项中加入子菜单jMe

21、nuFiIe.add(jMenultem2)；jMenuFiIe.add(jMenultem3)；jMenuFiIe.add(jMenultem4)；jMenuBar.add(jMenuFiIe);将菜单项加入菜单条jMenuBar.add(jMenuExit)；button2.addActionListener(this)；/本窗口向按钮事件源注册buttons.addActionListener(this)；button4.addActionListener(this)；button5.addActionListener(this)；jMenulteml.addActionListener

22、(this)；/本窗口菜单子项注册、jMenul1em2.addActionListener(this)；jMenul1em3.addActionListener(this)；jMenul1em4.addActionListener(this)；jMenuExit.addActionListener(this)；this.setDefaultCloseOperation(JFrame.EXIT_0N_CL0SE)；this.setVisibIe(true)；pubIicstaticvoidmain(Stringargs)interfaca二newinterfac()：pubIicvoidact

23、ionPerformed(ActionEvente)/按钮事件的处理if(e.getSource()二二jMenuExit)System,exit(0)；eIseif(e.getSource()二二jMenuItem1|e.getSource()二二button2)trytja二newtj()；catch(Exceptionee)eIseif(e.getSource()二二jMenu11em2|e.getSource()=button3)tryxga二newxgO;catch(Exceptioned)eIseif(e.getSource()jMenu11em31|e.getSource()=b

24、utton4)(tryexa=newex()；catch(Exceptionec)eIseif(e.getSource()二二jMenu11em41|e.getSource()=button5)trysca二newsc()；catch(Exceptiones)tj.java添加界面importjavax.swing.*；importjava.awt.*；importjava.awt.event.*；importjava,sql.*；pubIicclasstjextendsJFrameimplementsActionListenerstatictjs：staticJLabeIIabe11二new

25、JLabeI(学号：”);staticJTextFieldtextFieldl二newJTextField(l,H)：staticJLabeIIabe12二newJLabeI(姓名：；staticJTextFieldtextField2二newJTextField()：static儿abeIIabe13二new儿abeI,性另J:“)；staticJTextFieldtextField7=newJTextField(小)：staticJLabeIIabe14二newJLabeI(出生日期：”);staticJTextFieldtextField3二newJTextField()：staticJ

26、LabeIIabe15二newJLabeI(政治面貌：；staticJTextFieldtextField8=newJTextField（Hl1）；staticJLabeIIabe16二newJLabeI（籍贯”）；staticJTextFieldtextField4=newJTextField（,）；51, 33)；16, 74, 22)；51, 33)：16, 44, 22)；70. 33)：15, 50, 25)；55, 33)；5& 74, 22)；70. 33)：57, 72, 25)；26, 33) 5& 44, 22)；50, 33)；4 74 22)51, 33) ,99, 1

27、78,22)staticJLabeIIabe17二newJLabeI(系另！:)；staticJTextFieldtextField9二newJTextField()：staticJLabeIIabe18=newJLabeI(专业：”)；staticJTextFieldtextField5二newJTextField()：staticJButtonbuttonl二newJButton(土曾加)；pubIictj()this.setTitIe(增力口学：this.setLayout(nulI)；this.setsize(400,400)；label1.setBounds(30,11,textFi

28、eldl.setBounds(86,1abe12.setBounds(162,11,textFieId2.setBounds(192,Iabe13,setBounds(241,11,textField7.setBounds(275,Iabe14,setBounds(31,53,textFieId3.setBounds(86,Iabe15,setBounds(241,53,textField8.setBounds(296,Iabe16.setBounds(163,53,textField4.setBounds(191,Iabe17,setBounds(30,94,textField9.setBo

29、unds(86,9Iabe18,setBounds(163,94,textField5.setBounds(190,buttonl.setBounds(25,241,80,33)；buttord.addActionListener(this)；this.add(Iabe11)；this.add(Iabe12)；this.add(Iabe13)；this.add(Iabe14)；this.add(Iabe15)；this.add(Iabe16)；this.add(Iabe17)；this.add(Iabe18)；this.add(textFieldl)；this.add(textFieId2)；

30、this.add(textFieId3)；this.add(textFieId4)；this.add(textFieId5)；this.add(textFieId7)；this.add(textFieId8)；this.add(textFieId9)；this.add(buttord)；this.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE)；this.setVisibIe(true)；pubIicstaticvoidmain(Stringargs)throwsExceptiontja=newj()；a.setDefaultCloseOper

31、ation(JFrame.EXIT_ON_CLOSE)；pubIicvoidactionPerformed(ActionEvente)/事件处理程序if(e.getSourceO二二buttonl)tryClass.forName(Hsun.jdbc.odbc.JdbcOdbcDrive)；catch(ClassNotFoundExceptionce)JOptionPane.showMessageDialog(s,ce.getMessage(J)；tryConnectionconDriverManager.getConnection(njdbc：odbc：stuH,Hsa,Statements

32、tmt二con.createStatement()；ResultSetAs=stmt.executeQueryCse|ect*fromxinxiwhere学号二fH+textField1.getText0+);if(rs.next()JOptionPane.showMessageDialog(nuII,11此学号已经被注册);elsestmt.execute(irisertintoxinxi(学号，姓名，性别，出生日期政治面貌，籍贯，系别专业)valuestextFieId1.getText(),+textFieId2.getText()+n,H+textField7.getText()+,i

33、n+textFieId3.getText()1+textFieId8,getText()+H,H+textField4.getText()+textFieId9.getText(),+textFieId5.getText()+)；JOptionPane.showMessageDiaIog(nuI1,5忝力口信息成功)；)catch(SQLExceptionse)JOptionPane.showMessageDialog(s,se.getMessageO)；/xg.java修改界面importjavax.swing.*；importjava.awt.*；importjava,awt.event.

34、*；importjava.sql.pubIicclassxgextendsJFrameimplementsActionListenerstaticxgs：staticJLabeIIabe11二newJLabeI(学号：”);staticJTextFieldtextField1二newJTextField()：staticJLabeIIabe12二newJLabeI(姓名:);staticJTextFieldtextField2二newJTextField()staticJLabeIIabe13二newJLabeI(性别:)；staticJTextFieldtextField?二newJText

35、Field()：staticJLabellabel4二newJLabel(出生日期：“)；staticJTextFieldtextField3二newJTextField()static儿abeIIabe15=newJLabeI(政治面貌：”)；staticJTextFieldtextField8=newJTextField()；static儿abeIIabe16二newJLabeI(籍贯)；staticJTextFieldtextField4二newJTextField()：static儿abeIIabe17二new儿abeI(系另J:”)；staticJTextFieldtextField

36、9二newJTextField()staticJLabeIIabe18二newJLabeI(专业：”)；staticJTextFieldtextField5二newJTextField()staticJButtonbutton2=newJButton(彳彦改”)；pubIicxg()n)；this.setTitle(修改学生信息this.setLayout(nulI)：this.setsize(400,400)；label 1 .setBounds (30, 11, textF ieldl.setBounds (86,1 abe 12. setBounds (162, 11, textF i

37、e I d2. setBounds (192, label3.setBounds (241, 11, textF i eld7. setBounds(275, label4. setBounds(31, 53, textF i eld3. setBounds(86, I abe15,setBounds(241, 53, textF i eld8. setBounds(296, I abe 16. setBounds (163, 53, textF i eld4. setBounds(191, I abe 17. se旧ounds (30, 94, textF i eld9.setBounds

38、(86,9 I abe 18, setBounds (163, 94, textF i eld5. setBounds(190, button2.setBounds(115, 241 button2.addAct i onL i stener51,16,51,16,70,15,55,58,70,57,26,5&50,33)； 74,33)44, 33)50, 33)；74,33)72, 33)44,33)；4, 74,22)51,99,33)22)；22)；*25)；22)；25)；*22)；,80,(thi178,22)33)；s)；this.add(Iabe11)；this.add(Iab

39、e12)；this.add(Iabe13)；this.add(Iabe14)；this.add(Iabe15)；this.add(Iabe16)；this.add(Iabe17)；this.add(Iabe18)；this.add(textFieldl)；this.add (textF i e (textF i e (textF i e (textF i e (textF i e (textF i ed2)； th i s. add d3)； th i s. add d4)； th i s. add d5)； th i s. add cP)； th i s. add d8)； th i s.

40、add (textF i e I d9)；this.add(button2)；this.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE)；this.setVisibIe(true)；pubIicstaticvoidmain(Stringargs)throwsException(xga=newxg()；a.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE)；pubIicvoidactionPerformed(ActionEvente)/事件处理程序if(e.getSource()二二button2)try

41、Class.forNameCsun.jdbc.odbc.JdbcOdbcDriver)；catch(ClassNotFoundExceptionce)JOptionPane.showMessageDialog(s,ce.getMessageO)；tryConnectioncon-.DriverManager.getConnection/fiIIIIinnnirn(jdbc：odbc：stu,sa,)；Statementstmt二con.createStatementO；ResultSetrsstmt.executeQuery(select*fromxinxiwhere字号=,r+textFie

42、Id1,getText()+)；学号不可为空!if(textFieId1.getText().trim().equaIs()JOptionPane.showMessageDialog(this,n)；updateSql 二update x i nx iset学号eIseif(rs.next()String+textFieId1.cretText姓名H+textF i e I d7. getText () 生日期八+= lH+textF i e I d8. getText ()藉贝二+=1+textF i e I d9, getText () 专 业J ”+textFie1d3.getText(

43、)+Hl,政j台面貌textFie1d4.getText()+Hl,系另textFie1d5.getText()+Hl；trystmt.executeQuery(updateSql)；catch(SQLExceptionse)JOptionPane.showMessageDiaIog(nuII,彳I参改成功n)；catch(SQLExceptionse)JOptionPane.showMessageDiaIog(s,se.getMessage()；/sc.java删除界面importjavax.swing.*；importjava,awt.*；importjava.awt.event.impo

44、rtjava.sq|pubIicclassscextendsJFrameimplementsActionListenerstaticscs：staticJLabeIlabel1二newJLabeI(学号：);staticJTextFieldtextFieldl二newJTextField(HH)：static儿abeIIabe12二newJLabeI(姓名：”)；staticJTextFieldtextField2二newJTextField()：staticJLabellabel3二newJLabel(性别:“)staticJTextFieldtextField?二newJTextField

45、()：staticJLabellabel4二newJLabel(出生日期：)；staticJTextFieldtextField3二newJTextField(，：staticJLabeIIabe15二newJLabeI(政治面貌);staticJTextFieldtextField8=newJTextField()：staticJLabeIIabe16二newJLabeI(籍贯)；staticJTextFieldtextField4二newJTextField(HH)：staticJLabeIIabe17二newJLabeI(H系别：”)；staticJTextFieldtextField9

46、二newJTextFieldClH)：staticJLabeIIabe18=newJLabeI(专业：”)；staticJTextFieldtextField5二newJTextFieldstaticJButtonbutton4=newJButton(删除)；pubIicsc()throwsExceptionthis.setTitled除学fthis.setLayout(nulI)：this.setsize(400,400)；label1.setBounds(30,11,textField1.setBounds(86,Iabe12.setBounds(162,11,textFieId2.set

47、Bounds(192,label3.setBounds(241,11,textField7.setBounds(275,label4.setBounds(31,53,textField3.setBounds(86,Iabe15,setBounds(241,53,textField8.setBounds(296,Iabe16.setBounds(163,53,textField4.setBounds(191,Iabe17.setBounds(30,94,textField9.setBounds(86,9Iabe18.setBounds(163,94,生息H）：51,33)；16,74,22)；5

48、1,33)：16,44,22)；70,33):15,50,25)；55,33)；58,74,22)；70,33):57,72,25)；26,33)：5&44,22)；50,33)；474.二、51,33)*textField5.setBounds(190,99,178,22)button4.setBounds(295,241,80,33)；button4.addActionListener(this)；this.add(label1)；this.add(Iabe12)；this.add(Iabe13)；this.add(label4)；this.add(label5)；this.add(Iab

49、e16)；this.add(Iabe17)；this.add(Iabe18)；this.add(textFieldl)；th i s. add(textF ith i s. add(textF ith i s. add(textF ith i s. add(textF ith i s. add(textF ith i s. add(textF ith i s. add(textF id2)；d3)；d4)；d5)；d7)；d8)；d9)；this.add(button4)；this.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE)；this.s

50、etVisibIe(true)；pubIicstaticvoidmain(Stringargs)throwsException(sca=newsc()；a.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE)；pubIicvoidactionPerformed(ActionEvente)/sc1 f(e.getSource0二二button4)tryClass.forNameCsun.jdbc.odbc.JdbcOdbcDriver)；catch(ClassNotFoundExceptionce)JOptionPane.showMessageDialog

51、(s,ce.getMessageO)；)tryconConnectionDriverManager.getConnection(njdbc：odbc：stu,sa,)；Statementstmt二con.createStatement()；ResultSetrs=stmt.executeQueryCse|ect*fromxinxiwhere学号二+textField1.getText()+)；if(textFiecM.getText().trim().equaIs()学号不可为空!JOptionPane.showMessageDialog(this,eIseif(rs.next()JOptio

52、nPane.showConfirmDialog(01|1,确定要删除该彳言?Wn删虞的信息将不能恢复,继续？删定自除确h,JOptionPane.OK_CANCEL_OPTION)；/,JOption.QUESTION_MESSAGE)二二0；stmt,execute(de|etefromxinxiwhere学号二H+textFieId1.getText()+)；JOptionPane.showMessageDialog(nullJ册J除彳言息、成this.dispose()；eIseJOptionPane.showMessageDialog(nuII/无任匕学号又寸应信息“，”警告h,JOptionPane.WARNING_MESSAGE)：catch(Exceptioned)JOptionPane.showMessageDialog(s,ed.getMessage()；/ex.java查询界面importjavax.swing.*；importjava,awt.*；importjava.awt.event.*；importjava.sql.pubIicclassexextendsJFrameimpl