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

-.z.学生学籍管理详细设计**：____________：____________班级：____________设计题目：学生学籍管理二：设计内容：设计GUI学生学籍管理界面，用户可以参加学生信息，并对根本信息进展修改，添加，查询，删除。三：设计要求：进展简单的学生信息管理。四：总体设计(1)登陆界面的设计〔2〕主窗体的设计〔3〕添加学生信息窗体〔4〕查询学生信息窗体〔5〕修改学生信息窗体〔6〕删除学生信息窗体〔7)事件响应的处理五：具体设计程序构造的说明：入口程序：student.java;登陆界面程序：mainframe.java;主窗体程序：interfac.java;添加信息窗口程序：tj.java;修改信息窗口程序：*g.java;查询信息窗口程序：c*.java;删除信息窗口程序：sc.java;程序数据连接：DatabaseConn.java;程序代码及分析说明A.程序源代码〔已提交〕B.Student.java是程序的入口。使登录窗口位于窗口中间，并且不可改变窗口大小。C.mainframe.java是程序的登陆窗体。输入用户名和密码〔用户名和密码在数据库的password表中〕点击"进入系统〞，然后登陆界面消失；出现要操作的界面〔屏幕左上角〕。D.tj.java是添加信息界面。添加根本信息后，点击"添加信息〞按钮，将信息参加*in*i表中。E.*g.java是修改信息界面。输入要修改的**或姓名〔两者数其一或全部输入〕，并输入所有信息，点击"修改信息〞按钮〔如果数据库中不存在此**，则弹出对话框"无此学生信息〞〕，假设有则修改。F.sc.java是删除信息界面。输入要删除的学生的**，点击"删除信息〞按钮，弹出确认删除对话框，即可删除该生信息。G.c*.java是查询信息界面。输入要查询的学生**，点击"信息查询〞按钮，在相应的文本区里显示查询的信息。H:源代码//student.java:程序的入口。初始化界面，使主界面位于屏幕中间，且用户不能改变大小//功能：完成程序的执行顺序importjava*.swing.UIManager;importjava.awt.*;importjava.sql.*;//importscreenpublicclassstudent{ booleanpackFrame=false; //JFrameframe=newJFrame(); publicstudent() { mainframeframe=newmainframe(); if(packFrame) { frame.pack(); } else { frame.validate(); } DimensionscreenSize=Toolkit.getDefaultToolkit().getScreenSize(); DimensionframeSize=frame.getSize(); if(frameSize.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(String[]args) { try{ UIManager.setLookAndFeel(UIManager.getSystemLookAndFeelClassName()); } catch(E*ceptione) { e.printStackTrace(); } newstudent(); } }//数据库连接//packagesql.database;importjava.sql.*;publicclassDatabaseConn{ privatestaticStringuser=""; privatestaticStringpassword=""; privateConnectionconn=null; privateStatementstmt=null; privateResultSetrs=null; static { try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//加载驱动 } catch(ClassNotFoundE*ceptione){} } //创立数据库连接对象 publicConnectiongetConnection() { try{ conn=DriverManager.getConnection("jdbc:odbc:stu",user,password); returnconn; }catch(SQLE*ceptione) { returnnull; } } publicStatementcreateStat() { try{ conn=getConnection(); stmt=conn.createStatement(); returnstmt; }catch(SQLE*ceptione) {returnnull;} } publicResultSetgetRs(Stringsql) {try{conn=getConnection();//...stmt=createStat();rs=stmt.e*ecuteQuery(sql);returnrs;}catch(SQLE*ceptione){ returnnull; } } publicvoidclose() { try{if(rs!=null)rs.close();if(stmt!=null)stmt.close();if(conn!=null)conn.close();}catch(SQLE*ceptione*){e*.printStackTrace();} } }//mainframe.javaimportjava.awt.*;importjava.awt.event.*;importjava*.swing.*;importjava.sql.*;publicclassmainframee*tendsJFrameimplementsActionListener{ staticmainframes; staticJPanelpan=newJPanel(); staticJLabellabel1=newJLabel("用户");staticJLabellabel2=newJLabel("密码");staticJTe*tFieldte*tField1=newJTe*tField();staticJPasswordFieldpassword=newJPasswordField();staticJButtonbutton1=newJButton("进入系统");staticJRadioButtonradioButton1=newJRadioButton("管理员",true);//"管理员〞初始状态被选中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); this.setTitle("学籍管理系统"); this.setSize(400,400); this.setLayout(null); label1.setBounds(100,25,49,20); te*tField1.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(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(te*tField1); this.add(password); this.add(button1); this.add(pan); this.setDefaultCloseOperation(JFrame.E*IT_ON_CLOSE); this.setVisible(true); } publicstaticvoidmain(String[]args) { newmainframe(); } publicvoidactionPerformed(ActionEvente) { if(radioButton1.isSelected())//管理员 { if(te*tField1.getTe*t().equals("syc")&&password.getTe*t().equals("123")){ interfacb=newinterfac(); this.dispose(); //JOptionPane.showMessageDialog(null,"登陆成功"); }elseif("".equals(te*tField1.getTe*t())||"".equals(password.getTe*t())){ JOptionPane.showMessageDialog(null,"用户名或密码不能为空"); }else{JOptionPane.showMessageDialog(null,"用户名或密码输入有误"); } }if(radioButton2.isSelected())//学生{ try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); } catch(ClassNotFoundE*ceptionce) { JOptionPane.showMessageDialog(s,ce.getMessage()); } try { Connectioncon=DriverManager.getConnection("jdbc:odbc:stu","sa",""); Statementstmt=con.createStatement();ResultSetrs=stmt.e*ecuteQuery("select*frompasswordwhere用户名='"+te*tField1.getTe*t()+"'and密码='"+password.getTe*t()+"'");if(te*tField1.getTe*t().equals("")||password.getTe*t().equals("")){JOptionPane.showMessageDialog(this,"用户名或密码不可为空！");}elseif(rs.ne*t()){newinterfac();} else{JOptionPane.showMessageDialog(this,"您的输入有误");}//stmt.close(); } catch(SQLE*ceptionse) { JOptionPane.showMessageDialog(s,se.getMessage()); } } }}//interface.javaimportjava.awt.*;importjava.awt.event.*;importjava*.swing.*;publicclassinterface*tendsJFrameimplementsActionListener{ staticJMenuBarjMenuBar=newJMenuBar();//菜单条staticJMenujMenuFile=newJMenu("文件");//菜单项staticJMenujMenuE*it=newJMenu("退出");staticJMenuItemjMenuItem1=newJMenuItem("添加信息");//菜单子项staticJMenuItemjMenuItem2=newJMenuItem("修改信息");staticJMenuItemjMenuItem3=newJMenuItem("信息查询");staticJMenuItemjMenuItem4=newJMenuItem("删除信息");staticJLabellabel3=newJLabel("请选择操作项");staticJLabellabel4=newJLabel("学籍管理系统");staticJButtonbutton2=newJButton("添加信息");staticJButtonbutton3=newJButton("修改信息");staticJButtonbutton4=newJButton("信息查询");staticJButtonbutton5=newJButton("删除信息"); publicinterfac() { this.setTitle("学籍管理系统"); this.setLayout(null); this.setSize(400,400); label3.setBounds(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(button3); this.add(button4); this.add(button5); this.add(label3); this.add(label4); setJMenuBar(jMenuBar); jMenuFile.add(jMenuItem1);//〞文件"菜单项中参加子菜单 jMenuFile.add(jMenuItem2); jMenuFile.add(jMenuItem3); jMenuFile.add(jMenuItem4); jMenuBar.add(jMenuFile);//将菜单项参加菜单条jMenuBar.add(jMenuE*it);button2.addActionListener(this);//本窗口向按钮事件源注册button3.addActionListener(this);button4.addActionListener(this);button5.addActionListener(this);jMenuItem1.addActionListener(this);//本窗口菜单子项注册jMenuItem2.addActionListener(this);jMenuItem3.addActionListener(this);jMenuItem4.addActionListener(this);jMenuE*it.addActionListener(this);this.setDefaultCloseOperation(JFrame.E*IT_ON_CLOSE);this.setVisible(true); } publicstaticvoidmain(String[]args) { interfaca=newinterfac(); }publicvoidactionPerformed(ActionEvente)//按钮事件的处理{ if(e.getSource()==jMenuE*it) { System.e*it(0); }elseif(e.getSource()==jMenuItem1||e.getSource()==button2) { try{ tja=newtj(); } catch(E*ceptionee){}} elseif(e.getSource()==jMenuItem2||e.getSource()==button3) { try{ *ga=new*g(); }catch(E*ceptioned) {} } elseif(e.getSource()==jMenuItem3||e.getSource()==button4) { try{ c*a=newc*();} catch(E*ceptionec){} } elseif(e.getSource()==jMenuItem4||e.getSource()==button5) { try{ sca=newsc(); }catch(E*ceptiones){} } }}//tj.java添加界面importjava*.swing.*;importjava.awt.*;importjava.awt.event.*;importjava.sql.*;publicclasstje*tendsJFrameimplementsActionListener{ statictjs;staticJLabellabel1=newJLabel("**:");staticJTe*tFieldte*tField1=newJTe*tField("");staticJLabellabel2=newJLabel(":");staticJTe*tFieldte*tField2=newJTe*tField("");staticJLabellabel3=newJLabel("性别:");staticJTe*tFieldte*tField7=newJTe*tField("");staticJLabellabel4=newJLabel("出生日期:");staticJTe*tFieldte*tField3=newJTe*tField("");staticJLabellabel5=newJLabel("政治面貌:");staticJTe*tFieldte*tField8=newJTe*tField("");staticJLabellabel6=newJLabel("籍贯");staticJTe*tFieldte*tField4=newJTe*tField("");staticJLabellabel7=newJLabel("系别:");staticJTe*tFieldte*tField9=newJTe*tField("");staticJLabellabel8=newJLabel("专业:");staticJTe*tFieldte*tField5=newJTe*tField("");staticJButtonbutton1=newJButton("增加");publictj(){ this.setTitle("增加学生信息"); this.setLayout(null);this.setSize(400,400);label1.setBounds(30,11,51,33);te*tField1.setBounds(86,16,74,22);label2.setBounds(162,11,51,33);te*tField2.setBounds(192,16,44,22);label3.setBounds(241,11,70,33);te*tField7.setBounds(275,15,50,25);label4.setBounds(31,53,55,33);te*tField3.setBounds(86,58,74,22);label5.setBounds(241,53,70,33);te*tField8.setBounds(296,57,72,25);label6.setBounds(163,53,26,33);te*tField4.setBounds(191,58,44,22);label7.setBounds(30,94,50,33);te*tField9.setBounds(86,94,74,22);label8.setBounds(163,94,51,33);te*tField5.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(te*tField1);this.add(te*tField2);this.add(te*tField3);this.add(te*tField4);this.add(te*tField5);this.add(te*tField7);this.add(te*tField8);this.add(te*tField9);this.add(button1);this.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);this.setVisible(true);}publicstaticvoidmain(String[]args)throwsE*ception{tja= newtj();a.setDefaultCloseOperation(JFrame.E*IT_ON_CLOSE); }publicvoidactionPerformed(ActionEvente)//事件处理程序{if(e.getSource()==button1){ try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); } catch(ClassNotFoundE*ceptionce) { JOptionPane.showMessageDialog(s,ce.getMessage()); } try { Connectioncon=DriverManager.getConnection("jdbc:odbc:stu","sa",""); Statementstmt=con.createStatement();ResultSetrs=stmt.e*ecuteQuery("select*from*in*iwhere**='"+te*tField1.getTe*t()+"'");if(rs.ne*t()){ JOptionPane.showMessageDialog(null,"此**已经被注册"); } else { stmt.e*ecute("insertinto*in*i(**,,性别,出生日期,政治面貌,籍贯,系别,专业)values('"+ te*tField1.getTe*t()+"','"+te*tField2.getTe*t()+"','"+te*tField7.getTe*t()+"','"+ te*tField3.getTe*t()+"','"+te*tField8.getTe*t()+"','"+te*tField4.getTe*t()+"','"+ te*tField9.getTe*t()+"','"+te*tField5.getTe*t()+"')"); JOptionPane.showMessageDialog(null,"添加信息成功");}}catch(SQLE*ceptionse) { JOptionPane.showMessageDialog(s,se.getMessage()); }}}}//*g.java修改界面importjava*.swing.*;importjava.awt.*;importjava.awt.event.*;importjava.sql.*;publicclass*ge*tendsJFrameimplementsActionListener{ static*gs;staticJLabellabel1=newJLabel("**:");staticJTe*tFieldte*tField1=newJTe*tField("");staticJLabellabel2=newJLabel(":");staticJTe*tFieldte*tField2=newJTe*tField("");staticJLabellabel3=newJLabel("性别:");staticJTe*tFieldte*tField7=newJTe*tField("");staticJLabellabel4=newJLabel("出生日期:");staticJTe*tFieldte*tField3=newJTe*tField("");staticJLabellabel5=newJLabel("政治面貌:");staticJTe*tFieldte*tField8=newJTe*tField("");staticJLabellabel6=newJLabel("籍贯");staticJTe*tFieldte*tField4=newJTe*tField("");staticJLabellabel7=newJLabel("系别:");staticJTe*tFieldte*tField9=newJTe*tField("");staticJLabellabel8=newJLabel("专业:");staticJTe*tFieldte*tField5=newJTe*tField("");staticJButtonbutton2=newJButton("修改");public*g(){ this.setTitle("修改学生信息"); this.setLayout(null);this.setSize(400,400);label1.setBounds(30,11,51,33);te*tField1.setBounds(86,16,74,22);label2.setBounds(162,11,51,33);te*tField2.setBounds(192,16,44,22);label3.setBounds(241,11,70,33);te*tField7.setBounds(275,15,50,25);label4.setBounds(31,53,55,33);te*tField3.setBounds(86,58,74,22);label5.setBounds(241,53,70,33);te*tField8.setBounds(296,57,72,25);label6.setBounds(163,53,26,33);te*tField4.setBounds(191,58,44,22);label7.setBounds(30,94,50,33);te*tField9.setBounds(86,94,74,22);label8.setBounds(163,94,51,33);te*tField5.setBounds(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(te*tField1);this.add(te*tField2);this.add(te*tField3);this.add(te*tField4);this.add(te*tField5);this.add(te*tField7);this.add(te*tField8);this.add(te*tField9);this.add(button2);this.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);this.setVisible(true);}publicstaticvoidmain(String[]args)throwsE*ception{ *ga=new*g();a.setDefaultCloseOperation(JFrame.E*IT_ON_CLOSE);}publicvoidactionPerformed(ActionEvente)//事件处理程序{if(e.getSource()==button2){ try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); } catch(ClassNotFoundE*ceptionce) { JOptionPane.showMessageDialog(s,ce.getMessage()); } try { Connectioncon=DriverManager.getConnection("jdbc:odbc:stu","sa",""); Statementstmt=con.createStatement();ResultSetrs=stmt.e*ecuteQuery("select*from*in*iwhere**='"+te*tField1.getTe*t()+"'");if(te*tField1.getTe*t().trim().equals("")){JOptionPane.showMessageDialog(this,"**不可为空！");}elseif(rs.ne*t()){ StringupdateSql="update*in*iset**='"+te*tField1.getTe*t()+"',='"+ te*tField2.getTe*t()+"',性别='"+te*tField7.getTe*t()+"',出生日期='"+ te*tField3.getTe*t()+"',政治面貌='"+te*tField8.getTe*t()+"',籍贯='"+ te*tField4.getTe*t()+"',系别='"+te*tField9.getTe*t()+"',专业='"+ te*tField5.getTe*t()+"'"; try{ stmt.e*ecuteQuery(updateSql);} catch(SQLE*ceptionse) { JOptionPane.showMessageDialog(null,"修改成功"); } }} catch(SQLE*ceptionse){JOptionPane.showMessageDialog(s,se.getMessage());}}}}//sc.java删除界面importjava*.swing.*;importjava.awt.*;importjava.awt.event.*;importjava.sql.*;publicclasssce*tendsJFrameimplementsActionListener{ staticscs;staticJLabellabel1=newJLabel("**:");staticJTe*tFieldte*tField1=newJTe*tField("");staticJLabellabel2=newJLabel(":");staticJTe*tFieldte*tField2=newJTe*tField("");staticJLabellabel3=newJLabel("性别:");staticJTe*tFieldte*tField7=newJTe*tField("");staticJLabellabel4=newJLabel("出生日期:");staticJTe*tFieldte*tField3=newJTe*tField("");staticJLabellabel5=newJLabel("政治面貌:");staticJTe*tFieldte*tField8=newJTe*tField("");staticJLabellabel6=newJLabel("籍贯");staticJTe*tFieldte*tField4=newJTe*tField("");staticJLabellabel7=newJLabel("系别:");staticJTe*tFieldte*tField9=newJTe*tField("");staticJLabellabel8=newJLabel("专业:");staticJTe*tFieldte*tField5=newJTe*tField("");staticJButtonbutton4=newJButton("删除");publicsc()throwsE*ception{ this.setTitle("删除学生信息"); this.setLayout(null);this.setSize(400,400);label1.setBounds(30,11,51,33);te*tField1.setBounds(86,16,74,22);label2.setBounds(162,11,51,33);te*tField2.setBounds(192,16,44,22);label3.setBounds(241,11,70,33);te*tField7.setBounds(275,15,50,25);label4.setBounds(31,53,55,33);te*tField3.setBounds(86,58,74,22);label5.setBounds(241,53,70,33);te*tField8.setBounds(296,57,72,25);label6.setBounds(163,53,26,33);te*tField4.setBounds(191,58,44,22);label7.setBounds(30,94,50,33);te*tField9.setBounds(86,94,74,22);label8.setBounds(163,94,51,33);te*tField5.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(te*tField1);this.add(te*tField2);this.add(te*tField3);this.add(te*tField4);this.add(te*tField5);this.add(te*tField7);this.add(te*tField8);this.add(te*tField9);this.add(button4);this.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);this.setVisible(true);}publicstaticvoidmain(String[]args)throwsE*ception{sca= newsc();a.setDefaultCloseOperation(JFrame.E*IT_ON_CLOSE);}publicvoidactionPerformed(ActionEvente)//sc{ if(e.getSource()==button4){ try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); } catch(ClassNotFoundE*ceptionce) { JOptionPane.showMessageDialog(s,ce.getMessage()); } try { Connectioncon=DriverManager.getConnection("jdbc:odbc:stu","sa",""); Statementstmt=con.createStatement();ResultSetrs=stmt.e*ecuteQuery("select*from*in*iwhere**='"+te*tField1.getTe*t()+"'");if(te*tField1.getTe*t().trim().equals("")){JOptionPane.showMessageDialog(this,"**不可为空！");}elseif(rs.ne*t()){ JOptionPane.showConfirmDialog(null,"确定要删除该信息嘛？\n删除的信息将不能恢复，继续？","删除确定",JOptionPane.OK_CANCEL_OPTION);//,JOption.QUESTION_MESSAGE)==0; stmt.e*ecute("deletefrom*in*iwhere**='"+te*tField1.getTe*t()+"'"); JOptionPane.showMessageDialog(null,"删除信息成功！"); this.dispose(); } elseJOptionPane.showMessageDialog(null,"无此**对应信息","警告",JOptionPane.WARNING_MESSAGE);} catch(E*ceptioned) { JOptionPane.showMessageDialog(s,ed.getMessage()); }} }}//c*.java查询界面importjava*.swing.*;importjava.awt.*;importjava.awt.event.*;importjava.sql.*;publicclassc*e*tendsJFrameimplementsActionListener{ staticc*s;staticJLabellabel1=newJLabel("**:");staticJTe*tFieldte*tField1=newJTe*tField("");staticJLabellabel2=newJLabel(":");staticJTe*tFieldte*tField2=newJTe*tField("");staticJLabellabel3=newJLabel("性别:");staticJTe*tFieldte*tField7=newJTe*tField("");staticJLabellabel4=newJLabel("出生日期:");staticJTe*tFieldte*tField3=newJTe*tField("");staticJLabellabel5=newJLabel("政治面貌:");staticJTe*tFieldte*tField8=newJTe*tField("");staticJLabellabel6=newJLabel("籍贯");staticJTe*tFieldte*tField4=newJTe*tField("");staticJLabellabel7=newJLabel("系别:");staticJTe*tFieldte*tField9=newJTe*tField("");staticJLabellabel8=newJLabel("专业:");staticJTe*tFieldte*tField5=newJTe*tField("");staticJButtonbutton3=newJButton("查询");publicc*()throwsE*ception{ this.setTitle("查询学生信息"); this.setLayout(null);this.setSize(400,400);label1.setBounds(30,11,51,33);te*tField1.setBounds(86,16,74,22);label2.setBounds(162,11,51,33);te*tField2.setBounds(192,16,44,22);label3.setBounds(241,11,70,33);te*tField7.setBounds(275,15,50,25);label4.setBounds(31,53,55,33);te*tField3.setBounds(86,58,74,