學(xué)生學(xué)籍管理系統(tǒng)

資料范本本資料為word版本，可以直接編輯和打印，感謝您的下載學(xué)生學(xué)籍管理系統(tǒng)（含java源代碼）地點： 時間： 說明：本資料適用于約定雙方經(jīng)過談判，協(xié)商而共同承認(rèn)，共同遵守的責(zé)任與義務(wù)，僅供參考，文檔可直接下載或修改，不需要的部分可直接刪除，使用時請詳細閱讀內(nèi)容學(xué)生學(xué)籍管理詳細設(shè)計學(xué)號： 姓名： 班級： 設(shè)計題目：學(xué)生學(xué)籍管理二：設(shè)計內(nèi)容：設(shè)計GUI學(xué)生學(xué)籍管理界面，用戶可以加入學(xué)生信息，并對基本信息進行修改，添加，查詢，刪除。三：設(shè)計要求：進行簡單的學(xué)生信息管理。四：總體設(shè)計（1）登陸界面的設(shè)計（2） 主窗體的設(shè)計（3） 添加學(xué)生信息窗體（4） 查詢學(xué)生信息窗體（5） 修改學(xué)生信息窗體（6） 刪除學(xué)生信息窗體（7） 事件響應(yīng)的處理五：具體設(shè)計程序結(jié)構(gòu)的說明：入口程序：student.java;登陸界面程序：mainframe.java;主窗體程序：interfac.java;添加信息窗口程序：tj.java;修改信息窗口程序：xg.java;查詢信息窗口程序：cx.java;刪除信息窗口程序：sc.java;程序數(shù)據(jù)連接：DatabaseConn.java;程序代碼及分析說明程序源代碼（已提交）Student.java是程序的入口。使登錄窗口位于窗口中間，并且不可改變窗口大小。mainframe.java是程序的登陸窗體。輸入用戶名和密碼（用戶名和密碼在數(shù)據(jù)庫的password表中）點擊“進入系統(tǒng)”，然后登陸界面消失；出現(xiàn)要操作的界面（屏幕左上角）。tj.java是添加信息界面。添加基本信息后，點擊“添加信息”按鈕，將信息加入xinxi表中。xg.java是修改信息界面。輸入要修改的學(xué)號或姓名（兩者數(shù)其一或全部輸入），并輸入所有信息，點擊“修改信息”按鈕（如果數(shù)據(jù)庫中不存在此學(xué)號，則彈出對話框“無此學(xué)生信息”），若有則修改。sc.java是刪除信息界面。輸入要刪除的學(xué)生的學(xué)號，點擊“刪除信息”按鈕，彈出確認(rèn)刪除對話框，即可刪除該生信息。cx.java是查詢信息界面。輸入要查詢的學(xué)生學(xué)號，點擊“信息查詢”按鈕，在相應(yīng)的文本區(qū)里顯示查詢的信息。H:源代碼//student.java:程序的入口。初始化界面，使主界面位于屏幕中間，且用戶不能改變大小//功能：完成程序的執(zhí)行順序importjavax.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(Exceptione)(e.printStackTrace();}newstudent();}}〃數(shù)據(jù)庫連接//packagesql.database;importjava.sql.*;publicclassDatabaseConn(privatestaticStringuser=〃〃；privatestaticStringpassword=〃〃；privateConnectionconn=null;privateStatementstmt=null;privateResultSetrs=null;static(try{Class.forName(〃sun.jdbc.odbc.JdbcOdbcDriver〃)；//加載驅(qū)動}catch(ClassNotFoundExceptione)(}}//創(chuàng)建數(shù)據(jù)庫連接對象publicConnectiongetConnection()(try(conn二DriverManager.getConnection(〃jdbc:odbc:stu〃，user,password);returnconn;}catch(SQLExceptione)(returnnull;}}publicStatementcreateStat()(conn二getConnection();stmt二conn.createStatement();returnstmt;}catch(SQLExceptione)(returnnull;}}publicResultSetgetRs(Stringsql)(try(conn二getConnection();//...stmt二createStat();rs二stmt.executeQuery(sql);returnrs;}catch(SQLExceptione)(returnnull;}}publicvoidclose()(try(if(rs!=null)rs.close();if(stmt!=null)stmt.close();if(conn!二null)conn.close();}catch(SQLExceptionex)(ex.printStackTrace();}}}//mainframe.javaimportjava.awt.*;importjava.awt.event.*;importjavax.swing.*;importjava.sql.*;publicclassmainframeextendsJFrameimplementsActionListener(staticmainframes;staticJPanelpan=newJPanel();staticJLabellabel1=newJLabel("用戶”)；staticJLabellabel2=newJLabel("密碼”)；staticJTextFieldtextField1=newJTextField();staticJPasswordFieldpassword=newJPasswordField();staticJButtonbutton1=newJButton(〃進入系統(tǒng)")；staticJRadioButtonradioButton1=newJRadioButton(〃管理員〃,true);//“管理員”初始狀態(tài)被選中staticJRadioButtonradioButton2=newJRadioButton(〃學(xué)生〃)；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("學(xué)籍管理系統(tǒng)")；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(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(labell);this.add(label2);this.add(textFieldl);this.add(password);this.add(buttonl);this.add(pan);this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);this.setVisible(true);}publicstaticvoidmain(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(password.getText()))(JOptionPane.showMessageDialog(null,"用戶名或密碼不能為空")；}else(JOptionPane.showMessageDialog(null,"用戶名或密碼輸入有誤")；}}if(radioButton2.isSelected())//學(xué)生(try{Class.forName(〃sun.jdbc.odbc.JdbcOdbcDriver〃)；}catch(ClassNotFoundExceptionce)(JOptionPane.showMessageDialog(s,ce.getMessage());}try(Connectioncon=DriverManager.getConnection(〃jdbc:odbc:stu〃，〃sa〃，〃〃)；Statementstmt=con.createStatement();ResultSetrs=stmt.executeQuery("select*frompasswordwhere用戶名二'〃+textField1.getText()+〃'and密碼二'〃+password.getText()+〃'〃)；if(textField1.getText().equals(〃〃)||password.getText().equals(〃〃))JOptionPane.showMessageDialog(this,"用戶名或密碼不可為空！")；}elseif(rs.next())(newinterfac();}else{JOptionPane.showMessageDialog(this,〃您的輸入有誤")；}//stmt.close();}catch(SQLExceptionse)(JOptionPane.showMessageDialog(s,se.getMessage());}}}}//interface.javaimportjava.awt.*;importjava.awt.event.*;importjavax.swing.*;publicclassinterfacextendsJFrameimplementsActionListener(staticJMenuBarjMenuBar=newJMenuBar();//菜單條staticJMenujMenuFile=newJMenu(〃文件”)；//菜單項staticJMenujMenuExit=newJMenu(〃退出");staticJMenuItemjMenuIteml=newJMenuItem(〃添加信息")；//菜單子staticJMenuItemjMenuItem2=newJMenuItem(〃修改信息")；staticJMenuItemjMenuItem3=newJMenuItem(〃信息查詢");staticJMenuItemjMenuItem4=newJMenuItem(〃刪除信息")；staticJLabellabel3=newJLabel("請選擇操作項")；staticJLabellabel4=newJLabel("學(xué)籍管理系統(tǒng)")；static JButton button2 = new JButton(〃添加信息")；static JButton button3 = new JButton(〃修改信息")；static JButton button4 = new JButton(〃信息查詢")；static JButton button5 = new JButton(〃刪除信息")；publicinterfac()(this.setTitle("學(xué)籍管理系統(tǒng)")；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(jMenuIteml);//”文件“菜單項中加入子菜單jMenuFile.add(jMenuItem2);jMenuFile.add(jMenuItem3);jMenuFile.add(jMenuItem4);jMenuBar.add(jMenuFile);//將菜單項加入菜單條jMenuBar.add(jMenuExit);button2.addActionListener(this);//本窗口向按鈕事件源注冊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.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)(try(tja=newtj();}catch(Exceptionee)(}}elseif(e.getSource()==jMenuItem2||e.getSource()==button3)(try(xga=newxg();}catch(Exceptioned)(}}elseif(e.getSource()==jMenuItem3||e.getSource()==button4)(try(cxa=newcx();}catch(Exceptionec)(}}elseif(e.getSource()==jMenuItem4||e.getSource()==button5)(try(sca=newsc();}catch(Exceptiones)(}}}}//tj.java添加界面importjavax.swing.*;importjava.awt.*;importjava.awt.event.*;importjava.sql.*;publicclasstjextendsJFrameimplementsActionListener(statictjs;staticJLabellabel1=newJLabel(〃學(xué)號:")；staticJTextFieldtextField1=newJTextField("");staticJLabellabel2=newJLabel("姓名：")；staticJTextFieldtextField2=newJTextField("");staticJLabellabel3=newJLabel("性別：”)；staticJTextFieldtextField7=newJTextField("");staticJLabellabel4=newJLabel("出生日期：")；staticJTextFieldtextField3=newJTextField(〃〃);staticJLabellabel5=newJLabel("政治面貌：")；staticJTextFieldtextField8二newJTextField("");staticJLabellabel6=newJLabel(〃籍貫")；staticJTextFieldtextField4=newJTextField("");staticJLabellabel7=newJLabel(〃系別:")；staticJTextFieldtextField9=newJTextField("");staticJLabellabel8=newJLabel(〃專業(yè):")；staticJTextFieldtextField5=newJTextField("");staticJButtonbutton1=newJButton(〃增^口")；publictj()(this.setTitle(〃增加學(xué)生信息")；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.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.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(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.setVisible(true);}publicstaticvoidmain(String[]args)throwsException(tja=newtj();a.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);}publicvoidactionPerformed(ActionEvente)//事件處理程序(if(e.getSource()==button1)(try(Class.forName(〃sun.jdbc.odbc.JdbcOdbcDriver〃)；}catch(ClassNotFoundExceptionce)(JOptionPane.showMessageDialog(s,ce.getMessage());}try(Connectioncon=DriverManager.getConnection(〃jdbc:odbc:stu〃，〃sa〃，〃");Statementstmt=con.createStatement();ResultSetrs=stmt.executeQuery("select*fromxinxiwhere學(xué)號='"+textField1.getText()+〃'〃)；if(rs.next())(JOptionPane.showMessageDialog(null,"此學(xué)號已經(jīng)被注冊")；}else(stmt.execute("insertintoxinxi(學(xué)號，姓名，性別，出生日期，政治面貌,籍貫，系別，專業(yè))values('〃+textField1.getText()+〃’，’〃+textField2.getText()+〃'，’〃+textField7.getText()+〃'，’〃+textField3.getText()+〃’，’〃+textField8.getText()+〃'，’〃+textField4.getText()+〃'，’〃+textField9.getText()+〃’，’〃+textField5.getText()+〃’)〃)；JOptionPane.showMessageDialog(null,"添加信息成功")；}}catch(SQLExceptionse)(JOptionPane.showMessageDialog(s,se.getMessage());}}}//xg.java修改界面importjavax.swing.*;importjava.awt.*;importjava.awt.event.*;importjava.sql.*;publicclassxgextendsJFrameimplementsActionListener（staticxgs;staticJLabellabel1=newJLabel（〃學(xué)號:"）；staticJTextFieldtextField1=newJTextField（""）;staticJLabellabel2=newJLabel（"姓名："）；staticJTextFieldtextField2=newJTextField（""）;staticJLabellabel3=newJLabel（"性別：”）；staticJTextFieldtextField7=newJTextField（""）;staticJLabellabel4=newJLabel（"出生日期："）；staticJTextFieldtextField3=newJTextField（""）;staticJLabellabel5=newJLabel（"政治面貌："）；staticJTextFieldtextField8=newJTextField（""）;staticJLabellabel6=newJLabel（〃籍貫"）；staticJTextFieldtextField4=newJTextField（""）;staticJLabellabel7=newJLabel（〃系別:"）；staticJTextFieldtextField9=newJTextField（""）;staticJLabellabel8=newJLabel（〃專業(yè):"）;staticJTextFieldtextField5=newJTextField(〃〃)；staticJButtonbutton2二newJButton(〃修改");publicxg()(this.setTitle(〃修改學(xué)生信息")；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.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.setBounds(190,99,178,22);button2.setBounds(115,241,80,33);button2.addActionListener(this);this.add(labell);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.add(textField2);this.add(textField3);this.add(textField4);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(String[]args)throwsException(xga=newxg();a.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);publicvoidactionPerformed(ActionEvente)//事件處理程序(if(e.getSource()==button2)(try(Class.forName(〃sun.jdbc.odbc.JdbcOdbcDriver〃)；}catch(ClassNotFoundExceptionce)(JOptionPane.showMessageDialog(s,ce.getMessage());}try(Connectioncon=DriverManager.getConnection(〃jdbc:odbc:stu〃,〃sa〃,〃〃)；Statementstmt=con.createStatement();ResultSetrs=stmt.executeQuery("select*fromxinxiwhere學(xué)號='"+textField1.getText()+〃'〃)；if(textField1.getText().trim().equals(〃〃))(JOptionPane.showMessageDialog(this,"學(xué)號不可為空！")；}elseif(rs.next())(StringupdateSql="updatexinxiset學(xué)號二'〃+textField1.getText()+〃'，姓名二'"+textField2.getText()+"',性別二'"+textField7.getText()+"',出生日期二，"+textField3.getText()+"',政治面貌二，"+textField8.getText()+"，,籍貫=，"+textField4.getText()+"，,系別二，"+textField9.getText()+"，,專業(yè)=，"+textField5.getText()+"，";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.*;publicclassscextendsJFrameimplementsActionListener(staticscs;staticJLabellabel1=newJLabel(〃學(xué)號:")；staticJTextFieldtextField1=newJTextField("");staticJLabellabel2=newJLabel("姓名：")；staticJTextFieldtextField2=newJTextField("");staticJLabellabel3=newJLabel("性別：”)；staticJTextFieldtextField7=newJTextField("");staticJLabellabel4=newJLabel("出生日期：")；staticJTextFieldtextField3=newJTextField("");staticJLabellabel5=newJLabel("政治面貌：")；staticJTextFieldtextField8=newJTextField("");staticJLabellabel6=newJLabel(〃籍貫")；staticJTextFieldtextField4=newJTextField("");staticJLabellabel7=newJLabel(〃系別:")；staticJTextFieldtextField9=newJTextField("");staticJLabellabel8=newJLabel(〃專業(yè):")；staticJTextFieldtextField5=newJTextField("");staticJButtonbutton4二newJButton(〃刪除");publicsc()throwsException(this.setTitle(〃刪除學(xué)生信息")；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.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.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.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)throwsException(sca=newsc();a.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);}publicvoidactionPerformed(ActionEvente)//scif(e.getSource()==button4)(try(Class.forName(〃sun.jdbc.odbc.JdbcOdbcDriver〃)；}catch(ClassNotFoundExceptionce)(JOptionPane.showMessageDialog(s,ce.getMessage());}try(Connectioncon=DriverManager.getConnection(〃jdbc:odbc:stu〃，〃sa〃，〃〃)；Statementstmt=con.createStatement();ResultSetrs=stmt.executeQuery("select*fromxinxiwhere學(xué)號二'〃+textField1.getText()+〃'〃)；if(textField1.getText().trim().equals(〃〃))(JOptionPane.showMessageDialog(this,"學(xué)號不可為空！")；}elseif(rs.next())JOptionPane.showConfirmDialog(null,"確定要刪除該信息嘛？\n刪除的信息將不能恢復(fù)，繼續(xù)？〃,〃刪除確定”,JOptionPane.OK_CANCEL_OPTION);//,JOption.QUESTION_MESSAGE)==0;stmt.execute("deletefromxinxiwhere學(xué)號二'〃+textField1.getText()+〃'〃)；JOptionPane.showMessageDialog(null,"刪除信息成功！")；this.dispose();}elseJOptionPane.showMessageDialog(null,"無此學(xué)號對應(yīng)信息〃，〃警告〃，JOptionPane.WARNING_MESSAGE);}catch(Exceptioned)(JOptionPane.showMessageDialog(s,ed.getMessage());}}}}//cx.java查詢界面importjavax.swing.*;importjava.awt.*;importjava.awt.event.*;importjava.sql.*;publicclasscxextendsJFrameimplementsActionListenerstaticcxs;staticJLabellabell=newJLabel(〃學(xué)號:")；staticJTextFieldtextFieldl=newJTextField(〃〃)；staticJLabellabel2=newJLabel("姓名：")；staticJTextFieldtextField2=newJTextField("");staticJLabellabel3=newJLabel("性別：”)；staticJTextFieldtextField7二newJTextField("");staticJLabellabel4=newJLabel("出生日期：")；staticJTextFieldtextField3=newJTextField("");staticJLabellabel5=newJLabel("政治面貌：")；staticJTextFieldtextField8=newJTextField("");staticJLabellabel6=newJLabel(〃籍貫")；staticJTextFieldtextField4=newJTextField("");staticJLabellabel7=newJLabel(〃系別:")；staticJTextFieldtextField9=newJTextField("");staticJLabellabel8=newJLabel(〃專業(yè):")；staticJTextFieldtextField5=newJTextField("");staticJButtonbutton3=newJButton(〃查詢")；publiccx()throwsException(this.setTitle(〃查詢學(xué)生信息")；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.setBounds(31,53,55,33);textField3.setBounds(86,58