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