學(xué)生學(xué)籍管理系統(tǒng)含java源代碼樣本

學(xué)生學(xué)籍管理詳細(xì)設(shè)計(jì)學(xué)號(hào)：____________姓名：____________班級(jí)：____________設(shè)計(jì)題目：學(xué)生學(xué)籍管理二：設(shè)計(jì)內(nèi)容：設(shè)計(jì)GUI學(xué)生學(xué)籍管理界面，顧客可以加入學(xué)生信息，并對(duì)基本信息進(jìn)行修改，添加，查詢，刪除。三：設(shè)計(jì)規(guī)定：進(jìn)行簡(jiǎn)樸學(xué)生信息管理。四：總體設(shè)計(jì)(1)登陸界面設(shè)計(jì)（2）主窗體設(shè)計(jì)（3）添加學(xué)生信息窗體（4）查詢學(xué)生信息窗體（5）修改學(xué)生信息窗體（6）刪除學(xué)生信息窗體（7)事件響應(yīng)解決五：詳細(xì)設(shè)計(jì)程序構(gòu)造闡明：入口程序：student.java;登陸界面程序：mainframe.java;主窗體程序：interfac.java;添加信息窗口程序：tj.java;修改信息窗口程序：xg.java;查詢信息窗口程序：cx.java;刪除信息窗口程序：sc.java;程序數(shù)據(jù)連接：DatabaseConn.java;程序代碼及分析闡明A.程序源代碼（已提交）B.Student.java是程序入口。使登錄窗口位于窗口中間，并且不可變化窗口大小。C.mainframe.java是程序登陸窗體。輸入顧客名和密碼（顧客名和密碼在數(shù)據(jù)庫(kù)password表中）點(diǎn)擊“進(jìn)入系統(tǒng)”，然后登陸界面消失；浮現(xiàn)要操作界面（屏幕左上角）。D.tj.java是添加信息界面。添加基本信息后，點(diǎn)擊“添加信息”按鈕，將信息加入xinxi表中。E.xg.java是修改信息界面。輸入要修改學(xué)號(hào)或姓名（兩者數(shù)其一或所有輸入），并輸入所有信息，點(diǎn)擊“修改信息”按鈕（如果數(shù)據(jù)庫(kù)中不存在此學(xué)號(hào)，則彈出對(duì)話框“無(wú)此學(xué)生信息”），若有則修改。F.sc.java是刪除信息界面。輸入要?jiǎng)h除學(xué)生學(xué)號(hào)，點(diǎn)擊“刪除信息”按鈕，彈出確認(rèn)刪除對(duì)話框，即可刪除該生信息。G.cx.java是查詢信息界面。輸入要查詢學(xué)生學(xué)號(hào)，點(diǎn)擊“信息查詢”按鈕，在相應(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ù)庫(kù)連接//packagesql.database;importjava.sql.*;publicclassDatabaseConn{ privatestaticStringuser=""; privatestaticStringpassword=""; privateConnectionconn=null; privateStatementstmt=null; privateResultSetrs=null; static { try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//加載驅(qū)動(dòng) } catch(ClassNotFoundExceptione){} } //創(chuàng)立數(shù)據(jù)庫(kù)連接對(duì)象 publicConnectiongetConnection() { try{ conn=DriverManager.getConnection("jdbc:odbc:stu",user,password); returnconn; }catch(SQLExceptione) { returnnull; } } publicStatementcreateStat() { try{ 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("進(jìn)入系統(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(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); } 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("文獻(xiàn)");//菜單項(xiàng)staticJMenujMenuExit=newJMenu("退出");staticJMenuItemjMenuItem1=newJMenuItem("添加信息");//菜單子項(xiàng)staticJMenuItemjMenuItem2=newJMenuItem("修改信息");staticJMenuItemjMenuItem3=newJMenuItem("信息查詢");staticJMenuItemjMenuItem4=newJMenuItem("刪除信息");staticJLabellabel3=newJLabel("請(qǐng)選取操作項(xiàng)");staticJLabellabel4=newJLabel("學(xué)籍管理系統(tǒng)");staticJButtonbutton2=newJButton("添加信息");staticJButtonbutton3=newJButton("修改信息");staticJButtonbutton4=newJButton("信息查詢");staticJButtonbutton5=newJButton("刪除信息"); 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(jMenuItem1);//”文獻(xiàn)“菜單項(xiàng)中加入子菜單 jMenuFile.add(jMenuItem2); jMenuFile.add(jMenuItem3); jMenuFile.add(jMenuItem4); jMenuBar.add(jMenuFile);//將菜單項(xiàng)加入菜單條jMenuBar.add(jMenuExit);button2.addActionListener(this);//本窗口向按鈕事件源注冊(cè)button3.addActionListener(this);button4.addActionListener(this);button5.addActionListener(this);jMenuItem1.addActionListener(this);//本窗口菜單子項(xiàng)注冊(cè)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é)號(hào):");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("增長(zhǎng)");publictj(){ this.setTitle("增長(zhǎng)學(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(button1);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é)號(hào)='"+textField1.getText()+"'");if(rs.next()){ JOptionPane.showMessageDialog(null,"此學(xué)號(hào)已經(jīng)被注冊(cè)"); } else { stmt.execute("insertintoxinxi(學(xué)號(hào),姓名,性別,出生日期,政治面貌,籍貫,系別,專業(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é)號(hào):");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(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(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é)號(hào)='"+textField1.getText()+"'");if(textField1.getText().trim().equals("")){JOptionPane.showMessageDialog(this,"學(xué)號(hào)不可為空！");}elseif(rs.next()){ StringupdateSql="updatexinxiset學(xué)號(hào)='"+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é)號(hào):");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(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(String[]args)throwsException{sca= newsc();a.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE)；}publicvoidactionPerformed(ActionEvente)//sc{ if(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é)號(hào)='"+textField1.getText()+"'");if(textField1.getText().trim().equals("")){JOptionPane.showMessageDialog(this,"學(xué)號(hào)不可為空！");}elseif(rs.next()){ JOptionPane.showConfirmDialog(null,"擬定要?jiǎng)h除該信息嘛？\n刪除信息將不能恢復(fù)，繼續(xù)？","刪除擬定",JOptionPane.OK_CANCEL_OPTION);//,JOption.QUESTION_MESSAGE)==0; stmt.execute("deletefromxinxiwhere學(xué)號(hào)='"+textField1.getText()+"'"); JOptionPane.showMessageDialog(null,"刪除信息成功！"); this.dispose()； } elseJOptionPane.showMessageDialog(null,"無(wú)此學(xué)號(hào)相應(yīng)信息","警告",JOptionPane.WARNING_MESSAGE);} catch(Exceptioned) { JOptionPane.showMessageDialog(s,ed.getMessage()); } } }}//cx.java查詢界面importjavax.swing.*;importjava.awt.*;importjava.awt.event.*;importjava.sql.*;publicclasscxextendsJFrameimplementsActionListener{ staticcxs;staticJLabellabel1=newJLabel("學(xué)號(hào):");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("");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，74，22);label5.s