完整版学生学籍管理系统含java源代码

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

2、va;F.查询信息窗口程序：cx.java;G.删除信息窗口程序：sc.java;H.程序数据连接：DatabaseConn.java;（2）程序代码及分析说明A.程序源代码（已提交）B.Student.java是程序的入口。使登录窗口位于窗口中间，并且不可改变窗口大小。C.mainframe.java是程序的登陆窗体。输入用户名和密码（用户名和密码在数据库的password表中）点击“进入系统”，然后登陆界面消失；出现要操作的界面（屏幕左上角）。D.tj.java是添加信息界面。添加基本信息后，点击“添加信息”按钮，将信息加入xinxi表中。E.xg.java是修改信息界面。输入要修改的学号

3、或姓名（两者数其一或全部输入），并输入所有信息，点击“修改信息”按钮（如果数据库中不存在此学号，则弹出对话框“无此学生信息”），若有则修改。F.sc.java是删除信息界面。输入要删除的学生的学号，点击“删除信息”按钮,弹出确认删除对话框，即可删除该生信息。G.cx.java是查询信息界面。输入要查询的学生学号，点击“信息查询”按钮，在相应的文本区里显示查询的信息。H:源代码/student.java:程序的入口。初始化界面，使主界面位于屏幕中间，且用户不能改变大小/功能：完成程序的执行顺序importjavax.swing.UIManager;importjava.awt.*;importj

4、ava.sql.*;/importscreenpublicclassstudentbooleanpackFrame=false;/JFrameframe=newJFrame();publicstudent()mainframeframe=newmainframe();if(packFrame)frame.pack();elseframe.validate();DimensionscreenSize=Toolkit.getDefaultToolkit().getScreenSize();DimensionframeSize=frame.getSize();if(frameSize.heights

5、creenSize.height)(frameSize.height=screenSize.height;if(frameSize.widthscreenSize.width)(frameSize.width=screenSize.width;frame.setLocation(screenSize.width-frameSize.width)/2,(screenSize.height-frameSize.height)/2);frame.setVisible(true);publicstaticvoidmain(Stringargs)(try(UIManager.setLookAndFeel

6、(UIManager.getSystemLookAndFeelClassName();catch(Exceptione)(e.printStackTrace();newstudent();/数据库连接/packagesql.database;importjava.sql.*;publicclassDatabaseConn(privatestaticStringuser=;privatestaticStringpassword=;privateConnectionconn=null;privateStatementstmt=null;privateResultSetrs=null;static(

7、tryClass.forName(sun.jdbc.odbc.JdbcOdbcDriver);/加载驱动catch(ClassNotFoundExceptione)/创建数据库连接对象publicConnectiongetConnection()tryconn=DriverManager.getConnection(jdbc:odbc:stu,user,password);returnconn;catch(SQLExceptione)returnnull;publicStatementcreateStat()tryconn=getConnection();stmt=conn.createSta

8、tement();returnstmt;catch(SQLExceptione)returnnull;publicResultSetgetRs(Stringsql)tryconn=getConnection();/stmt=createStat();rs=stmt.executeQuery(sql);returnrs;catch(SQLExceptione)returnnull;publicvoidclose()tryif(rs!=null)rs.close();if(stmt!=null)stmt.close();if(conn!=null)conn.close();catch(SQLExc

9、eptionex)(ex.printStackTrace();/mainframe.javaimportjava.awt.*;importjava.awt.event.*;importjavax.swing.*;importjava.sql.*;implementsActionListenerpublicclassmainframeextendsJFrame(staticmainframes;staticJPanelpan=newJPanel();staticJLabellabel1=new儿abel(用户)；staticJLabellabel2=new儿abel(密码)；staticJTex

10、tFieldtextField1=newJTextField();staticJPasswordFieldpassword=newJPasswordField();staticJButtonbutton1=newJButton(进入系统);staticJRadioButtonradioButton1=newJRadioButton(管理员,true);/“管理员”初始状态被选中staticJRadioButtonradioButton2=newJRadioButton(学生);staticJRadioButtonradioButton3=newJRadioButton(教师);ButtonGr

11、oupbuttonGroup=newButtonGroup();publicmainframe()(JLabellabel=newJLabel(newImageIcon(图片44.jpg);label.setSize(400,400);pan.add(label);pan.setLayout(null);pan.setSize(400,400);this.setTitle(学籍管理系统);this.setSize(400,400);this.setLayout(null);label1.setBounds(100,25,49,20);textField1.setBounds(155,24,12

12、0,20);label2.setBounds(100,62,49,20);password.setBounds(155,61,120,20);button1.setBounds(150,200,101,22);radioButton1.setBounds(105,120,80,20);radioButton2.setBounds(180,120,60,20);radioButton3.setBounds(240,120,60,20);button1.addActionListener(this);buttonGroup.add(radioButton1);buttonGroup.add(rad

13、ioButton2);buttonGroup.add(radioButton3);this.add(radioButton1);this.add(radioButton2);this.add(radioButton3);this.add(label1);this.add(label2);this.add(textField1);this.add(password);this.add(button1);this.add(pan);this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);this.setVisible(true);publicstat

14、icvoidmain(String口args)newmainframe();publicvoidactionPerformed(ActionEvente)if(radioButton1.isSelected()管理员&if(textField1.getText().equals(syc)password.getText().equals(123)interfacb=newinterfac();this.dispose();/JOptionPane.showMessageDialog(null,登陆成功);elseif(.equals(textField1.getText()|.equals(p

15、assword.getText()JOptionPane.showMessageDialog(null,”用户名或密码不能为空)；elseJOptionPane.showMessageDialog(null,用户名或密码输入有误)if(radioButton2.isSelected()/学生tryClass.forName(sun.jdbc.odbc.JdbcOdbcDriver);catch(ClassNotFoundExceptionce)JOptionPane.showMessageDialog(s,ce.getMessage();tryConnectioncon=DriverManag

16、er.getConnection(jdbc:odbc:stu,sa,);Statementstmt=con.createStatement();ResultSetrs=stmt.executeQuery(select*frompasswordwhere用户名=+textField1.getText()+“and密码=,H+password.getText()+);if(textField1.getText().equals()|password.getText().equals()JOptionPane.showMessageDialog(this,用户名或密码不可为空！);elseif(rs

17、.next()newinterfac();elseJOptionPane.showMessageDialog(this,您的输入有误);/stmt.close();catch(SQLExceptionse)(JOptionPane.showMessageDialog(s,se.getMessage();)/interface.javaimportjava.awt.*;importjava.awt.event.*;importjavax.swing.*;publicclassinterfacextendsJFrameimplementsActionListenerstaticJMenuBarjM

18、enuBar=newJMenuBar();/菜单条staticJMenujMenuFile=newJMenu(文件);/菜单项staticJMenujMenuExit=newJMenu(退出);菜单子项staticJMenuItemjMenuItem1=newJMenuItem(添加信息);/staticJMenuItemjMenuItem2=newJMenuItem(修改信息)；staticJMenuItemjMenuItem3=newJMenuItem(信息查询);staticJMenuItemjMenuItem4=newJMenuItem(删除信息)；static儿abellabel3=

19、newJLabel(staticJLabellabel4=newJLabel(staticJButtonbutton2=newJButton(staticJButtonbutton3=newJButton(staticJButtonbutton4=newJButton(staticJButtonbutton5=newJButton(请选择操作项);学籍管理系统);添加信息)修改信息)信息查询);删除信息)publicinterfac()(this.setTitle(学籍管理系统);this.setLayout(null);this.setSize(400,400);label3.setBoun

20、ds(158,92,98,33);label3.setFont(newFont(Dialog,Font.PLAIN,15);label4.setFont(newFont(Dialog,Font.BOLD,20);label4.setBounds(157,37,280,40);button2.setBounds(74,136,97,33);button3.setBounds(226,136,97,33);button4.setBounds(74,185,97,33);button5.setBounds(226,185,97,33);this.add(button2);this.add(butto

21、n3);this.add(button4);this.add(button5);this.add(label3);this.add(label4);setJMenuBar(jMenuBar);jMenuFile.add(jMenuIteml);/”文件“菜单项中加入子菜单jMenuFile.add(jMenuItem2);jMenuFile.add(jMenuItem3);jMenuFile.add(jMenuItem4);jMenuBar.add(jMenuFile);/将菜单项加入菜单条jMenuBar.add(jMenuExit);button2.addActionListener(th

22、is);/本窗口向按钮事件源注册button3.addActionListener(this);button4.addActionListener(this);button5.addActionListener(this);jMenuItem1.addActionListener(this);/本窗口菜单子项注册jMenuItem2.addActionListener(this);jMenuItem3.addActionListener(this);jMenuItem4.addActionListener(this);jMenuExit.addActionListener(this);this

23、.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);this.setVisible(true);publicstaticvoidmain(String口args)interfaca=newinterfac();publicvoidactionPerformed(ActionEvente)/按钮事件的处理if(e.getSource()=jMenuExit)System.exit(0);elseif(e.getSource()=jMenuItem1|e.getSource()=button2)trytja=newtj();catch(Exception

24、ee)elseif(e.getSource()=jMenuItem2|e.getSource()=button3)(try(xga=newxg();catch(Exceptioned)elseif(e.getSource()=jMenuItem3|e.getSource()=button4)trycxa=newcx();catch(Exceptionec)elseif(e.getSource()=jMenuItem4|e.getSource()=button5)trysca=newsc();catch(Exceptiones)/tj.java添加界面importjavax.swing.*;im

25、portjava.awt.*;importjava.awt.event.*;importjava.sql.*;publicclasstjextendsJFrameimplementsActionListenerstatictjs;staticJLabellabell=new儿abel(学号：)；staticJTextFieldtextFieldl=newJTextField();static儿abellabel2=new儿abel(姓名：);staticJTextFieldtextField2=newJTextField();static儿abellabel3=new儿abel(性别:)；st

26、aticJTextFieldtextField7=newJTextField();static儿abellabel4=new儿abel(出生日期:);staticJTextFieldtextField3=newJTextField();static儿abellabel5=new儿abel(政治面貌:);staticJTextFieldtextField8=newJTextField();static儿abellabel6=new儿abel(籍贯)staticJTextFieldtextField4=newJTextField();static儿abellabel7=new儿abel(系另U：)

27、;staticJTextFieldtextField9=newJTextField();static儿abellabel8=new儿abel(专业:);staticJTextFieldtextField5=newJTextField();staticJButtonbutton1=newJButton(增加);publictj()this.setTitle(增加学生信息)this.setLayout(null);this.setSize(400,400);label1.setBounds(30,11,51,33);textField1.setBounds(86,16,74,22);label2.

28、setBounds(162,11,51,33);textField2.setBounds(192,16,44,22);label3.setBounds(241,11,70,33);textField7.setBounds(275,15,50,25);label4.setBounds(31,53,55,33);textField3.setBounds(86,58,74,22);label5.setBounds(241,53,70,33);textField8.setBounds(296,57,72,25);label6.setBounds(163,53,26,33);textField4.set

29、Bounds(191,58,44,22);label7.setBounds(30,94,50,33);textField9.setBounds(86,94,74,22);label8.setBounds(163,94,51,33);textField5.setBounds(190,99,178,22);button1.setBounds(25,241,80,33);button1.addActionListener(this);this.add(label1);this.add(label2);this.add(label3);this.add(label4);this.add(label5)

30、;this.add(label6);this.add(label7);this.add(label8);this.add(textField1);this.add(textField2);this.add(textField3);this.add(textField4);this.add(textField5);this.add(textField7);this.add(textField8);this.add(textField9);this.add(buttonl);this.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);this.se

31、tVisible(true);publicstaticvoidmain(String口args)throwsExceptiontja=newtj();a.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);publicvoidactionPerformed(ActionEvente)/事件处理程序if(e.getSource()=button1)tryClass.forName(sun.jdbc.odbc.JdbcOdbcDriver);catch(ClassNotFoundExceptionce)JOptionPane.showMessageDial

32、og(s,ce.getMessage();tryConnectioncon=DriverManager.getConnection(jdbc:odbc:stu,sa,);Statementstmt=con.createStatement();ResultSetrs=stmt.executeQuery(select*fromxinxiwhere学号=+textField1.getText()+皿);if(rs.next()JOptionPane.showMessageDialog(null,此学号已经被注册);elsestmt.execute(insertintoxinxi(学号,姓名，性别，出

33、生日期,政治面貌，籍贯,系别,专业)values(+textField1.getText()+,+textField2.getText()+J+textField7.getText()+J+textField3.getText()+J+textField8.getText()+J+textField4.getText()+J+textField9.getText()+J+textField5.getText()+);JOptionPane.showMessageDialog(null,添加信息成功);catch(SQLExceptionse)JOptionPane.showMessageDia

34、log(s,se.getMessage();/xg.java修改界面importjavax.swing.*;importjava.awt.*;importjava.awt.event.*;importjava.sql.*;publicclassxgextendsJFrameimplementsActionListenerstaticxgs;staticJLabellabel1=new儿abel(学号:)；staticJTextFieldtextField1=newJTextField();static儿abellabel2=new儿abel(姓名:);staticJTextFieldtextF

35、ield2=newJTextField();static儿abellabel3=new儿abel(性别:)；staticJTextFieldtextField7=newJTextField();static儿abellabel4=new儿abel(出生日期:);staticJTextFieldtextField3=newJTextField();static儿abellabel5=new儿abel(政治面貌:);staticJTextFieldtextField8=newJTextField();static儿abellabel6=new儿abel(籍贯)staticJTextFieldtex

36、tField4=newJTextField();static儿abellabel7=new儿abel(系另U：);staticJTextFieldtextField9=newJTextField();static儿abellabel8=new儿abel(专业:);staticJTextFieldtextField5=newJTextField();staticJButtonbutton2=newJButton(修改);publicxg()this.setTitle(修改学生信息)this.setLayout(null);this.setSize(400,400);label1.setBound

37、s(30,11,51,33);textField1.setBounds(86,16,74,22);label2.setBounds(162,11,51,33);textField2.setBounds(192,16,44,22);label3.setBounds(241,11,70,33);textField7.setBounds(275,15,50,25);label4.setBounds(31,53,55,33);textField3.setBounds(86,58,74,22);label5.setBounds(241,53,70,33);textField8.setBounds(296

38、,57,72,25);label6.setBounds(163,53,26,33);textField4.setBounds(191,58,44,22);label7.setBounds(30,94,50,33);textField9.setBounds(86,94,74,22);label8.setBounds(163,94,51,33);textField5.setBounds(190,99,178,22);button2.setBounds(115,241,80,33);button2.addActionListener(this);this.add(label1);this.add(l

39、abel2);this.add(label3);this.add(label4);this.add(label5);this.add(label6);this.add(label7);this.add(label8);this.add(textField1);this.add(textField2);this.add(textField3);this.add(textField4);this.add(textField5);this.add(textField7);this.add(textField8);this.add(textField9);this.add(button2);this.

40、setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);this.setVisible(true);publicstaticvoidmain(String口args)throwsExceptionxga=newxg();a.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);一一publicvoidactionPerformed(ActionEvente)/事件处理程序if(e.getSource()=button2)tryClass.forName(sun.jdbc.odbc.JdbcOdbcDriver)

41、;catch(ClassNotFoundExceptionce)JOptionPane.showMessageDialog(s,ce.getMessage();tryConnectioncon=DriverManager.getConnection(jdbc:odbc:stu,sa,);Statementstmt=con.createStatement();ResultSetrs=stmt.executeQuery(select*fromxinxiwhere学号=+textField1.getText()+皿);if(textField1.getText().trim().equals()学号

42、不可为空!JOptionPane.showMessageDialog(this,);elseif(rs.next()updateSql=updatexinxi姓名set学号String=+textField1.getText()+,IIItextField2.getText()+”,=H+textField7.getText()+H,出生日期二+textField3.getText()+,政治面貌=+textField8.getText()+,籍贯=+textField4.getText()+,系别=H+textField9.getText()+H,专业=+textField5.getText

43、()+”;try(stmt.executeQuery(updateSql);catch(SQLExceptionse)(JOptionPane.showMessageDialog(null,”修改成功)；catch(SQLExceptionse)(JOptionPane.showMessageDialog(s,se.getMessage();/sc.java删除界面importjavax.swing.*;importjava.awt.*;importjava.awt.event.*;importjava.sql.*;publicclassscextendsJFrameimplementsAct

44、ionListener(staticscs;staticJLabellabel1=new儿abel(学号:)；staticJTextFieldtextField1=newJTextField();static儿abellabel2=new儿abel(姓名:);staticJTextFieldtextField2=newJTextField();static儿abellabel3=new儿abel(性别:)；staticJTextFieldtextField7=newJTextField();static儿abellabel4=new儿abel(出生日期:);staticJTextFieldte

45、xtField3=newJTextField();static儿abellabel5=new儿abel(政治面貌:);staticJTextFieldtextField8=newJTextField();static儿abellabel6=new儿abel(籍贯)staticJTextFieldtextField4=newJTextField();static儿abellabel7=new儿abel(系另U:);staticJTextFieldtextField9=newJTextField();static儿abellabel8=new儿abel(专业:);staticJTextFieldt

46、extField5=newJTextField();staticJButtonbutton4=newJButton(删除)publicsc()throwsExceptionthis.setTitle(删除学生信息)this.setLayout(null);this.setSize(400,400);label1.setBounds(30,11,51,33);textField1.setBounds(86,16,74,22);label2.setBounds(162,11,51,33);textField2.setBounds(192,16,44,22);label3.setBounds(241

47、,11,70,33);textField7.setBounds(275,15,50,25);label4.setBounds(31,53,55,33);textField3.setBounds(86,58,74,22);label5.setBounds(241,53,70,33);textField8.setBounds(296,57,72,25);label6.setBounds(163,53,26,33);textField4.setBounds(191,58,44,22);label7.setBounds(30,94,50,33);textField9.setBounds(86,94,7

48、4,22);label8.setBounds(163,94,51,33);textField5.setBounds(190,99,178,22);button4.setBounds(295,241,80,33);button4.addActionListener(this);this.add(label1);this.add(label2);this.add(label3);this.add(label4);this.add(label5);this.add(label6);this.add(label7);this.add(label8);this.add(textFieldl);this.

49、add(textField2);this.add(textField3);this.add(textField4);this.add(textField5);this.add(textField7);this.add(textField8);this.add(textField9);this.add(button4);this.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);this.setVisible(true);publicstaticvoidmain(String口args)throwsExceptionsca=newsc();a.s

50、etDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);一一publicvoidactionPerformed(ActionEvente)/scif(e.getSource()=button4)tryClass.forName(sun.jdbc.odbc.JdbcOdbcDriver);catch(ClassNotFoundExceptionce)JOptionPane.showMessageDialog(s,ce.getMessage();tryConnectioncon=DriverManager.getConnection(jdbc:odbc:stu,

51、sa,);Statementstmt=con.createStatement();ResultSetrs=stmt.executeQuery(select*fromxinxiwhere学号二+textField1.getText()+);学号不可为空!if(textField1.getText().trim().equals()JOptionPane.showMessageDialog(this,);elseif(rs.next()(JOptionPane.showConfirmDialog(null,”确定要删除该信息嘛？n删除的信息将不能恢复，继续？,删除确定”,JOptionPane.O

52、K_CANCEL_OPTION);,JOption.QUESTION_MESSAGE)=0;stmt.execute(deletefromxinxiwhere学号=+textField1.getText()+”);JOptionPane.showMessageDialog(null,删除信息成功！)；this.dispose();elseJOptionPane.showMessageDialog(null,无此学号对应信息,警告”,JOptionPane.WARNING_MESSAGE);catch(Exceptioned)(JOptionPane.showMessageDialog(s,ed

53、.getMessage();/cx.java查询界面importjavax.swing.*;importjava.awt.*;importjava.awt.event.*;importjava.sql.*;publicclasscxextendsJFrameimplementsActionListener(staticcxs;staticJLabellabel1=new儿abel(学号:)；staticJTextFieldtextField1=newJTextField();static儿abellabel2=new儿abel(姓名:);staticJTextFieldtextField2=newJTextField();static儿abellabel3=new儿abel(性别:)；staticJTextFieldtextField7=newJTextField();static儿abellabel4=new儿abel(出生日期:);staticJTextFieldtextField3=newJTextField();static儿abellabel5=new儿abel(政治面貌:);staticJTe