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

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

2、：xg.java;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.*

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

5、.height>screenSize.height)frameSize.height=screenSize.height;if(frameSize.width>screenSize.width)frameSize.width=screenSize.width;frame.setLocation(screenSize.width-frameSize.width)/2,(screenSize.height-frameSize.height)/2);frame.setVisible(true);publicstaticvoidmain(Stringargs)tryUIManager.se

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

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

8、createStat()tryconn=getConnection();stmt=conn.createStatement();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!=n

9、ull)stmt.close();if(conn!=null)conn.close();catch(SQLExceptionex)ex.printStackTrace();/mainframe.javaimportjava.awt.*;importjava.awt.event.*;importjavax.swing.*;implements ActionListenerimportjava.sql.*;publicclassmainframeextendsJFramestaticmainframes;staticJPanelpan=newJPanel();staticJLabellabel1=

10、newJLabel("用户");staticJLabellabel2=newJLabel("密码");staticJTextFieldtextField1=newJTextField();staticJPasswordFieldpassword=newJPasswordField();staticJButtonbutton1=newJButton("进入系统");管理员 ",true);/学生");教师");staticJRadioButtonradioButton1=newJRadioButton(“管

11、理员”初始状态被选中staticJRadioButtonradioButton2=newJRadioButton(staticJRadioButtonradioButton3=newJRadioButton(ButtonGroupbuttonGroup=newButtonGroup();publicmainframe()JLabellabel=newJLabel(newImageIcon("图片44.jpg");label.setSize(400,400);pan.add(label);pan.setLayout(null);pan.setSize(400,400);thi

12、s.setTitle("学籍管理系统");this.setSize(400,400);this.setLayout(null);label1.setBounds(100,25,49,20);textField1.setBounds(155,24,120,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

13、(180,120,60,20);radioButton3.setBounds(240,120,60,20);button1.addActionListener(this);buttonGroup.add(radioButton1);buttonGroup.add(radioButton2);buttonGroup.add(radioButton3);this.add(radioButton1);this.add(radioButton2);this.add(radioButton3);this.add(label1);this.add(label2);this.add(textField1);

14、this.add(password);this.add(button1);this.add(pan);this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);this.setVisible(true);publicstaticvoidmain(Stringargs)newmainframe();publicvoidactionPerformed(ActionEvente)&&if(radioButton1.isSelected()/管理员if(textField1.getText().equals("syc")

15、password.getText().equals("123")interfacb=newinterfac();this.dispose();/JOptionPane.showMessageDialog(null,"登陆成功");elseif("".equals(textField1.getText()|"".equals(password.getText()JOptionPane.showMessageDialog(null,"用户名或密码不能为空");elseJOptionPane.show

16、MessageDialog(null,"用户名或密码输入有误");if(radioButton2.isSelected()/学生tryClass.forName("sun.jdbc.odbc.JdbcOdbcDriver");catch(ClassNotFoundExceptionce)JOptionPane.showMessageDialog(s,ce.getMessage();tryConnectioncon=DriverManager.getConnection("jdbc:odbc:stu","sa",&q

17、uot;");Statementstmt=con.createStatement();ResultSetrs=stmt.executeQuery("select*frompasswordwhere用户名='"+textField1.getText()+"'and密码='"+password.getText()+"'");if(textField1.getText().equals("")|password.getText().equals("")JOpt

18、ionPane.showMessageDialog(this,"用户名或密码不可为空！");elseif(rs.next()newinterfac();elseJOptionPane.showMessageDialog(this,"您的输入有误");/stmt.close();catch(SQLExceptionse)JOptionPane.showMessageDialog(s,se.getMessage();/interface.javaimportjava.awt.*;importjava.awt.event.*;importjavax.swing

19、.*;publicclassinterfacextendsJFrameimplementsActionListener菜单条菜单项添加信息");/菜单子项修改信息");信息查询 ");删除信息");staticJMenuBarjMenuBar=newJMenuBar();/staticJMenujMenuFile=newJMenu("文件");/staticJMenujMenuExit=newJMenu("退出");staticJMenuItemjMenuItem1=newJMenuItem("stati

20、cJMenuItemjMenuItem2=newJMenuItem("staticJMenuItemjMenuItem3=newJMenuItem("staticJMenuItemjMenuItem4=newJMenuItem("staticJLabellabel3=newJLabel("staticJLabellabel4=newJLabel("staticJButtonbutton2=newJButton("staticJButtonbutton3=newJButton("staticJButtonbutton4=new

21、JButton("staticJButtonbutton5=newJButton("请选择操作项");学籍管理系统");添加信息");修改信息");信息查询");删除信息");publicinterfac()this.setTitle("学籍管理系统");this.setLayout(null);this.setSize(400,400);label3.setBounds(158,92,98,33);label3.setFont(newFont("Dialog",Font.P

22、LAIN,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(button3);this.add(button4);this.add(button5);t

23、his.add(label3);this.add(label4);setJMenuBar(jMenuBar);jMenuFile.add(jMenuItem1);/”文件“菜单项中加入子菜单jMenuFile.add(jMenuItem2);jMenuFile.add(jMenuItem3);jMenuFile.add(jMenuItem4);jMenuBar.add(jMenuFile);/将菜单项加入菜单条jMenuBar.add(jMenuExit);button2.addActionListener(this);/本窗口向按钮事件源注册button3.addActionListener

24、(this);button4.addActionListener(this);button5.addActionListener(this);jMenuItem1.addActionListener(this);/本窗口菜单子项注册jMenuItem2.addActionListener(this);jMenuItem3.addActionListener(this);jMenuItem4.addActionListener(this);jMenuExit.addActionListener(this);this.setDefaultCloseOperation(JFrame.EXIT_ON_

25、CLOSE);this.setVisible(true);publicstaticvoidmain(Stringargs)interfaca=newinterfac();publicvoidactionPerformed(ActionEvente)/按钮事件的处理if(e.getSource()=jMenuExit)System.exit(0);elseif(e.getSource()=jMenuItem1|e.getSource()=button2)trytja=newtj();catch(Exceptionee)elseif(e.getSource()=jMenuItem2|e.getSo

26、urce()=button3)tryxga=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.*;importjava.awt.*;importjava.awt.event.*;import

27、java.sql.*;publicclasstjextendsJFrameimplementsActionListenerstatictjs;staticJLabellabel1=newJLabel("学号:");staticJTextFieldtextField1=newJTextField("");staticJLabellabel2=newJLabel("姓名:");staticJTextFieldtextField2=newJTextField("");staticJLabellabel3=newJLabe

28、l("性别:");staticJTextFieldtextField7=newJTextField("");staticJLabellabel4=newJLabel("出生日期:");staticJTextFieldtextField3=newJTextField("");staticJLabellabel5=newJLabel("政治面貌:");staticJTextFieldtextField8=newJTextField("");staticJLabellabel6=n

29、ewJLabel("籍贯");staticJTextFieldtextField4=newJTextField("");staticJLabellabel7=newJLabel("系别:");staticJTextFieldtextField9=newJTextField("");staticJLabellabel8=newJLabel("专业:");staticJTextFieldtextField5=newJTextField("");staticJButtonbutto

30、n1=newJButton("增加");publictj()this.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,11,70,33);textField7.setBounds(2

31、75,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,74,22);label8.setBounds(163,94,51,

32、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);this.add(label6);this.add(label7);this.add(label8);this.add(textField1);this.add(textField2);this.add(textField

33、3);this.add(textField4);this.add(textField5);this.add(textField7);this.add(textField8);this.add(textField9);this.add(button1);this.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);this.setVisible(true);publicstaticvoidmain(Stringargs)throwsExceptiontja=newtj();a.setDefaultCloseOperation(JFrame.EXIT

34、_ON_CLOSE);publicvoidactionPerformed(ActionEvente)/事件处理程序if(e.getSource()=button1)tryClass.forName("sun.jdbc.odbc.JdbcOdbcDriver");catch(ClassNotFoundExceptionce)JOptionPane.showMessageDialog(s,ce.getMessage();tryConnectioncon=DriverManager.getConnection("jdbc:odbc:stu","sa&

35、quot;,"");Statementstmt=con.createStatement();ResultSetrs=stmt.executeQuery("select*fromxinxiwhere学号='"+textField1.getText()+"'");if(rs.next()JOptionPane.showMessageDialog(null,"此学号已经被注册");elsestmt.execute("insertintoxinxi(学号,姓名,性别,出生日期,政治面貌,籍贯,系别

36、,专业)values('"+textField1.getText()+"','"+textField2.getText()+"','"+textField7.getText()+"','"+textField3.getText()+"','"+textField8.getText()+"','"+textField4.getText()+"','"+textFie

37、ld9.getText()+"','"+textField5.getText()+"')");JOptionPane.showMessageDialog(null,"添加信息成功");catch(SQLExceptionse)JOptionPane.showMessageDialog(s,se.getMessage();/xg.java修改界面importjavax.swing.*;importjava.awt.*;importjava.awt.event.*;importjava.sql.*;publiccl

38、assxgextendsJFrameimplementsActionListenerstaticxgs;staticJLabellabel1=newJLabel("学号:");staticJTextFieldtextField1=newJTextField("");staticJLabellabel2=newJLabel("姓名:");staticJTextFieldtextField2=newJTextField("");staticJLabellabel3=newJLabel("性别:");

39、staticJTextFieldtextField7=newJTextField("");staticJLabellabel4=newJLabel("出生日期:");staticJTextFieldtextField3=newJTextField("");staticJLabellabel5=newJLabel("政治面貌:");staticJTextFieldtextField8=newJTextField("");staticJLabellabel6=newJLabel("籍贯&q

40、uot;);staticJTextFieldtextField4=newJTextField("");staticJLabellabel7=newJLabel("系别:");staticJTextFieldtextField9=newJTextField("");staticJLabellabel8=newJLabel("专业:");staticJTextFieldtextField5=newJTextField("");staticJButtonbutton2=newJButton("

41、;修改");publicxg()this.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,11,70,33);textField7.setBounds(275,15,50,25);label4

42、.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,74,22);label8.setBounds(163,94,51,33);textField5.setB

43、ounds(190,99,178,22);button2.setBounds(115,241,80,33);button2.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(textField1);this.add(textField2);this.add(textField3);this.add(textFi

44、eld4);this.add(textField5);this.add(textField7);this.add(textField8);this.add(textField9);this.add(button2);this.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);this.setVisible(true);publicstaticvoidmain(Stringargs)throwsExceptionxga=newxg();a.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);publicv

45、oidactionPerformed(ActionEvente)/事件处理程序if(e.getSource()=button2)tryClass.forName("sun.jdbc.odbc.JdbcOdbcDriver");catch(ClassNotFoundExceptionce)JOptionPane.showMessageDialog(s,ce.getMessage();tryConnectioncon=DriverManager.getConnection("jdbc:odbc:stu","sa",""

46、);Statementstmt=con.createStatement();ResultSetrs=stmt.executeQuery("select*fromxinxiwhere学号='"+textField1.getText()+"'");if(textField1.getText().trim().equals("")学号不可为空！JOptionPane.showMessageDialog(this,"");else if(rs.next()String='"+textFie

47、ld1.getText()+"',updateSql="update xinxi 姓名set 学 号textField2.getText()+"',性别='"+textField7.getText()+"',生日期='"+textField3.getText()+"',政治面貌='"+textField8.getText()+"',籍贯='"+textField4.getText()+"',系别='

48、"+textField9.getText()+"',专业='"+textField5.getText()+"'"trystmt.executeQuery(updateSql);catch(SQLExceptionse)JOptionPane.showMessageDialog(null,"修改成功");catch(SQLExceptionse)JOptionPane.showMessageDialog(s,se.getMessage();/sc.java删除界面importjavax.swing.*;

49、importjava.awt.*;importjava.awt.event.*;importjava.sql.*;publicclassscextendsJFrameimplementsActionListenerstaticscs;staticJLabellabel1=newJLabel("学号:");staticJTextFieldtextField1=newJTextField("");staticJLabellabel2=newJLabel("姓名:");staticJTextFieldtextField2=newJTextF

50、ield("");staticJLabellabel3=newJLabel("性别:");staticJTextFieldtextField7=newJTextField("");staticJLabellabel4=newJLabel("出生日期:");staticJTextFieldtextField3=newJTextField("");staticJLabellabel5=newJLabel("政治面貌:");staticJTextFieldtextField8=ne

51、wJTextField("");staticJLabellabel6=newJLabel("籍贯");staticJTextFieldtextField4=newJTextField("");staticJLabellabel7=newJLabel("系别:");staticJTextFieldtextField9=newJTextField("");staticJLabellabel8=newJLabel("专业:");staticJTextFieldtextField5=

52、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

53、,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.setBounds(191,58,44,22);label7.setBounds(30,94,50,33);

54、textField9.setBounds(86,94,74,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

55、);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(button4);this.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);this.setVisible(true);publicstaticvoidmain(Stringargs)thr

56、owsExceptionsca=newsc();a.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);publicvoidactionPerformed(ActionEvente)/scif(e.getSource()=button4)tryClass.forName("sun.jdbc.odbc.JdbcOdbcDriver");catch(ClassNotFoundExceptionce)JOptionPane.showMessageDialog(s,ce.getMessage();tryConnectioncon=Drive

57、rManager.getConnection("jdbc:odbc:stu","sa","");Statementstmt=con.createStatement();ResultSetrs=stmt.executeQuery("select*fromxinxiwhere学号='"+textField1.getText()+"'");if(textField1.getText().trim().equals("")学号不可为空！JOptionPane.show

58、MessageDialog(this,");elseif(rs.next()JOptionPane.showConfirmDialog(null,"确定要删除该信息嘛？n删除的信息将不能恢复，继续？","删除确定",JOptionPane.OK_CANCEL_OPTION);/,JOption.QUESTION_MESSAGE)=0;stmt.execute("deletefromxinxiwhere学号='"+textField1.getText()+"'");JOptionPane.s

59、howMessageDialog(null,"删除信息成功！");this.dispose();elseJOptionPane.showMessageDialog(null,"无此学号对应信息","警告",JOptionPane.WARNING_MESSAGE);catch(Exceptioned)JOptionPane.showMessageDialog(s,ed.getMessage();/cx.java查询界面importjavax.swing.*;importjava.awt.*;importjava.awt.event.*;importjava.sql.*;publicclasscxextendsJFrameimplementsActionListenerstaticcxs;staticJLabellabel1=newJLabel("学号:");staticJTextFieldtextField1=newJTextField("");staticJLabellabel2=newJLabel("姓名:");staticJTextFieldtextField2=newJTextField("&q