1、學號：姓名：班級：一、設計題目：學生學籍管理 二：設計內容：設計GUI學生學籍管理界面，用戶可以加入學生信息，并對基本信息進行修改，添加， 查詢，刪除。 三：設計要求：進行簡單的學生信息管理。四：總體設計主窗體的設計 添加學生信息窗體 查詢學生信息窗體 修改學生信息窗體 刪除學生信息窗體（1）登陸界面的設計（2）（3）（4）（5）（6）（7）事件響應的處理五：具體設計（1）程序結構的說明：入口程序：student.java;登陸界面程序：main frame.java;主窗體程序：in terfac.java;添加信息窗口程序：修改信息窗口程序：查詢信息窗口程序：刪除信息窗口程序：A B C

2、D E FGHtj.java; xg.java; cx.java; sc.java;程序數據連接：DatabaseCo nn .java;（2）程序代碼及分析說明 A.程序源代碼（已提交）“進入系統”“添加信息”“修改信息” 有則修改。“刪除信息”“信息查詢”H:源代碼，然后登陸界面消失；出現要操作的界面（屏幕左上角）。 按鈕，將信息加入 xinxi表中。按鈕（如果數據庫中不存在此學號，則彈出對話框“無此學生信息”），若按鈕，彈出確認刪除對話框，即可刪除該生信息。 按鈕，在相應的文本區里顯示查詢的信息。/stude nt.java:程序的入口。初始化界面，使主界面位于屏幕中間，且用戶不能改變大

3、小/功能：完成程序的執行順序import java.awt.*;import java.sql.*;/import scree np ublic class stude ntboolea n p ackFrame=false;/JFrame frame=new JFrame();p ublic stude nt()mai nframe frame=new main frame();if(p ackFrame)frame. pack();elseframe.validate();Dime nsio n scree nSize=Toolkit.getDefaultToolkit().getScre

4、e nSize();Dime nsion frameSize=frame.getSize();if(frameSize.height>scree nSize.height)frameSize.height=scree nSize.height;if(frameSize.width>scree nSize.width)frameSize.width=scree nSize.width;frame.setLocatio n(scree nSize.width-frameSize.width)/2,(scree nSize.height- frameSize.height)/2);fra

5、me.setVisible(true);p ublic static void main( Stri ng args) tryUlMa nager.setLookA ndFeel(UIMa nager.getSystemLookA ndFeelClassName();catch(Exce pti on e)e.prin tStackTrace();new stude nt();/數據庫連接/p ackage sql.database; import java.sql.*;p ublic class DatabaseC onnp rivate static String user="&

6、quot;p rivate static Stri ng p assword-"： p rivate Conn ecti on conn=nu II;p rivate Stateme nt stmt=n ull; p rivate ResultSet rs=n ull; static/ catch(ClassNotF oun dExce pti on e)創建數據庫連接對象p ublic Connection getC onn ectio n()tryconn-DriverMa nager.getCo nn ecti on ("jdbc:odbc:stu",use

7、r, password); retur n conn;catch(SQLExce pti on e)return n ull;p ublic Stateme nt createStat()tryconn-getCo nn ecti on();stmt=c onn .createStateme nt();return stmt;catch(SQLExce pti on e) return n ull;p ublic ResultSet getRs(Stri ng sql)tryconn=getC onn ecti on(); /. stmt=createStat(); rs=stmt.execu

8、teQuery(sql); return rs;catch(SQLExce ptio n e)return n ull;p ublic void close() tryif(rs!=null)rs.closeO;if(stmt!=null) stmt.close();if(conn!=n ull)conn. close();catch(SQLExce ptio n ex)ex. prin tStackTrace();/main frame.javaimport java.awt.*;import javax.swi ng.*;import java.sql.*;p ublic class ma

9、i nframe exte nds JFrame static mai nframe s;static JPanel pan=new JPan el();static JLabel label1 = new JLabel("static JLabel label2 = new JLabel("imp leme nts Actio nListe ner用戶"）； 密碼"）;static JTextField textField1 = new JTextField();static JP asswordField p assword = new JP ass

10、wordField(); static JButton button1 = new JButton("進入系統");static JRadioButt on radioButto n仁new JRadioButto n("初始狀態被選中static JRadioButt on radioButt on2=new JRadioButt on (" static JRadioButt on radioButt on3=new JRadioButt on (" Butt onGroup butt onGroup=new Butt onGroup();

11、 p ublic mai nframe()JLabel label=new JLabel( new ImageIc on ("圖片label.setSize(400,400);pan. add(label);pan. setLayout (nu II);pan. setSize(400,400);this.setTitle("學籍管理系統");this.setSize(400,400);this.setLayout (n ull);label1.setBou nds(100,25,49,20); textField1.setBou nds(155,24,120,2

12、0);管理員",true）;/“管理員”學生"）；教師"）；44.jp g");label2.setBou nds(100,62,49,20);p assword.setBou nds(155,61,120,20);butt on l.setBou nds(150,200,101,22);radioButt on 1.setBou nds(105,120,80,20);radioButt on 2.setBou nds(180,120,60,20);radioButt on 3.setBou nds(240,120,60,20);butt on 1.ad

13、dActi on Liste ner(this);butt onGroup .add(radioButt on 1);butt onGroup .add(radioButt on 2);butt onGroup .add(radioButt on 3);this.add(radioButto n1);this.add(radioButto n2);this.add(radioButto n3);this.add(label1);this.add(label2);this.add(textField1);this.add( password);this.add(butto n1);this.ad

14、d( pan);this.setDefaultCloseO perati on (JFrame.EXIT_ON_CLOSE); this.setVisible(true);p ublic static void main( Stri ng args)new mai nframe();p ublic void acti onP erformed(Act ion Eve nt e)管理員if(radioButto n1.isSelected()/if(textField1.getText().equals("syc") password.getText().equals(&qu

15、ot;123")in terfac b=new in terfac();this.dis pose();/JOptionPane.showMessageDialog(null,"登陸成功");elseif("".equals(textField1.getText()"".equals( password.getText() )JOptionPane.showMessageDialog(null,"用戶名或密碼不能為空"); elseJOp ti onPan e.showMessageDialog( nul

16、l,"if(radioButt on 2.isSelected()/用戶名或密碼輸入有誤");&&II學生trycatch (ClassNotF oun dExce pti on ce)JOp tio nPan e.showMessageDialog(s,ce.getMessage();tryConnection con = DriverMa nager.getCo nn ectio n("jdbc:odbc:stu","sa",""); Stateme nt stmt = con .createS

17、tateme nt();ResultSet rs = stmt.executeQuery("select * from password where 用戶名 '"+textField1.getText()+"' and密碼='"+password.getText()+"”');if(textField1.getText().equals("")| password.getText().equals("")用戶名或密碼不可為空!您的輸入有誤")；JOp tio nP

18、an e.showMessageDialog(this,"")；else if(rs. next() new in terfac();elseJO pti onPan e.showMessageDialog(this,"/stmt.close();catch (SQLExce pti on se)JOp tio nPan e.showMessageDialog(s,se.getMessage();/in terface.javaimport java.awt.*;import javax.swi ng.*;p ublic class in terfac exte

19、nds JFrame imp leme nts Actio nListe ner static JMe nuBar jMen uBar = new JMe nuBar();/ static JMe nu jMe nuFile = new JMe nu(”文件");/static JMe nu jMe nuExit = new JMe nu(”退出");static JMe nultem jMe nultem1 = new JMe nultem(" static JMe nultem jMe nultem2 = new JMe nultem(" stati

20、c JMe nultem jMen ultem3 = new JMe nultem(” static JMe nultem jMe nultem4 = new JMe nultem(” static JLabel label3 = new JLabel(" static JLabel label4 = new JLabel(" static JButton butt on2 = new JButto n("菜單條菜單項添加信息");/菜單子項 修改信息")； 信息查詢");刪除信息")；請選擇操作項");學籍管理系

21、統");添加信息")；修改信息"); 信息查詢"); 刪除信息");static JButton butt on3 = new JButto n("static JButton butt on4 = new JButto n("static JButt on butt on5 = new JButt on ("p ublic in terfac()this.setTitle("學籍管理系統");this.setLayout (n ull);this.setSize(400,400);label3

22、.setBou nds(158,92,98,33); label3.setFo nt(new Fon t("Dialog",Fo nt.P LAIN,15);label4.setFo nt(new Fon t("Dialog",Fo nt.BOLD,20); label4.setBou nds(157,37,280,40);butto n2.setBou nds(74,136,97,33);butto n3.setBou nds(226,136,97,33);butto n4.setBou nds(74,185,97,33);butto n5.setBo

23、u nds(226,185,97,33);this.add(butto n2);this.add(butto n3);this.add(butto n4);this.add(butto n5);this.add(label3);this.add(label4);setJMe nuBar(jMe nuBar);jMe nuFile.add(jMe nultem1);/”文件“菜單項中加入子菜單jMe nuFile.add(jMe nultem2);jMe nuFile.add(jMe nultem3);jMe nuFile.add(jMe nultem4);jMe nuBar.add(jMe n

24、uFile);/將菜單項加入菜單條jMe nuBar.add(jMe nuExit);本窗口向按鈕事件源注冊butt on 2.addActio nListe ner(this);/butt on 3.addActi on Liste ner(this);butt on4 .addActi on Liste ner(this);butt on 5.addActi on Liste ner(this);本窗口菜單子項注冊jMe nultem1.addAct ion Liste ner(this);/jMe nultem2.addActio nListe ner(this);jMe nultem3

25、.addActio nListe ner(this);jMe nultem4.addActio nListe ner(this);jMe nuExit.addActi on Liste ner(this);this.setDefaultCloseO peratio n( JFrame.EXIT_ON_CLOSE); this.setVisible(true);p ublic static void main( Stri ng args)in terfac a=new in terfac();按鈕事件的處理p ublic void actionP erformed(Acti on Eve nt

26、e) /if(e.getSource()=jMe nuExit)System.exit(0);else if(e.getSource()=jMe nultem1|e.getSource()=butt on2) trytj a=new tj();catch(Exce pti on ee) else if(e.getSource()=jMe nultem2|e.getSource()=butt on3) tryxg a=new xgO;catch(Exce pti on ed)else if(e.getSource()=jMe nultem3|e.getSource()=butt on4) try

27、cx a=new cx(); catch(Exce pti on ec)elseif(e.getSource()=jMe nultem4|e.getSource()=butt on5) trysc a=new sc();catch(Exce pti on es)添加界面/tj.javaimport javax.swi ng.*;import java.awt.*;import java.sql.*;p ublic class tj exte nds JFrame imp leme nts Actio nListe ner static tj s;static JLabel label1 = n

28、ew JLabel("學號:");static JTextField textField1 = new JTextField("");static JLabel label2 = new JLabel("姓名:");static JTextField textField2 = new JTextField("");static JLabel Iabel3 = new JLabel("性別:")；static JTextField textField7=n ew JTextField("

29、");static JLabel label4 = new JLabel("出生日期:");static JTextField textField3 = new JTextField("");static JLabel label5 = new JLabel("政治面貌:");static JTextField textField8=n ew JTextField("");static JLabel label6 = new JLabel("籍貫");static JTextField

30、 textField4 = new JTextField("");static JLabel label7 = new JLabel("系別:");static JTextField textField9 = new JTextField("");static JLabel label8 = new JLabel("專業:");static JTextField textField5 = new JTextField("");static JButton butt on1 = new JButt

31、o n("增加");p ublic tj()this.setTitle(" 增加學生信息")；this.setLayout (nu II);this.setSize(400,400);label1.setBou nds(30, 11,51,33);textField1.setBou nds(86, 16, 74, 22);label2.setBou nds(162, 11, 51, 33);textField2.setBou nds(192, 16, 44, 22);label3.setBou nds(241, 11, 70, 33);textField

32、7.setBou nds(275, 15, 50, 25);label4.setBou nds(31,53, 55, 33);textField3.setBou nds(86, 58, 74, 22);label5.setBou nds(241, 53, 70, 33);textField8.setBou nds(296, 57, 72, 25);label6.setBou nds(163, 53, 26, 33);textField4.setBou nds(191, 58, 44, 22);label7.setBou nds(30, 94, 50, 33);textField9.setBou

33、 nds(86,94,74,22);label8.setBou nds(163, 94, 51, 33);textField5.setBou nds(190, 99, 178, 22);butto n1.setBou nds(25,241,80,33);butt on 1.addActi on Liste ner(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);

34、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(butto n1);this.setDefaultCloseO peratio n( JFrame.DIS POSE_ON_CLOSE); this.setVisible(true);p ublic static void main( Stri

35、ng args) throws Exce pti ontj a= new tj();a.setDefaultCloseO peratio n(JFrame.EXIT_ON_CLOSE);事件處理程序p ublic void actio nP erformed(Actio nEve nt e)/if (e.getSource() = butt on1)trycatch (ClassNotF oun dExce pti on ce)JOp tio nPan e.showMessageDialog(s,ce.getMessage();tryConn ecti on con = DriverMa na

36、ger.getC onn ectio n("jdbc:odbc:stu","sa","");Stateme nt stmt = con. createStateme nt();from xinxi where 學號ResultSet rs=stmt.executeQuery("select ='"+textField1.getText()+"”');if(rs. next()JOptionPane.showMessageDialog(null,"此學號已經被注冊");

37、else學號,姓名,性別，出生日期，政治面stmt.execute("i nsert into xinxi (貌，籍貫，系別，專業)values ('"+textField1.getText()+"','"+textField2.getText()+"T"+textField7.getText()+"T"+textField3.getText()+"T"+textField8.getText()+"T"+textField4.getText()+&qu

38、ot;T"+ textField9.getText()+"','"+textField5.getText()+"')");JOptionPane.showMessageDialog(null,"添加信息成功");catch (SQLExce pti on se)JOp tio nPan e.showMessageDialog(s,se.getMessage(); 修改界面/xg.java import javax.swi ng.*;import java.awt.*;import java.sql.*

39、;p ublic class xg exte nds JFrame imp leme nts Action Liste ner static xg s;static JLabel label1 = new JLabel("學號:");static JTextField textField1 = new JTextField("");static JLabel label2 = new JLabel("姓名:");static JTextField textField2 = new JTextField("");st

40、atic JLabel label3 = new JLabel("性別:");static JTextField textField7=n ew JTextField("");static JLabel label4 = new JLabel("出生日期:");static JTextField textField3 = new JTextField("");static JLabel label5 = new JLabel("政治面貌:");static JTextField textFiel

41、d8=n ew JTextField("");static JLabel label6 = new JLabel("籍貫");static JTextField textField4 = new JTextField("");static JLabel label7 = new JLabel("系別:");static JTextField textField9 = new JTextField("");static JLabel label8 = new JLabel("專業:&qu

42、ot;);static JTextField textField5 = new JTextField("");static JButton butto n2=new JButto n("修改");p ublic xg()this.setTitle("修改學生信息")；this.setLayout (nu II);this.setSize(400,400);label1.setBou nds(30, 11,51,33);textField1.setBou nds(86, 16, 74, 22);label2.setBou nds(162

43、, 11, 51, 33);textField2.setBou nds(192, 16, 44, 22); label3.setBou nds(241, 11, 70, 33);textField7.setBou nds(275, 15, 50, 25); label4.setBou nds(31,53, 55, 33);textField3.setBou nds(86, 58, 74, 22); label5.setBou nds(241, 53, 70, 33);textField8.setBou nds(296, 57, 72, 25); label6.setBou nds(163, 5

44、3, 26, 33);textField4.setBou nds(191, 58, 44, 22); label7.setBou nds(30, 94, 50, 33);textField9.setBou nds(86,94,74,22); label8.setBou nds(163, 94, 51, 33);textField5.setBou nds(190, 99, 178, 22);butto n2.setBou nds(115,241,80,33);butt on 2.addActi on Liste ner(this);this.add(label1);this.add(label2

45、);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(butto n2);this.setD

46、efaultCloseO peratio n( JFrame.DIS POSE_ON_CLOSE); this.setVisible(true);p ublic static void main( Stri ng args) throws Exce pti onxg a=new xg();a.setDefaultCloseO peratio n(JFrame.EXIT_ON_CLOSE);事件處理程序 ""p ublic void actio nP erformed(Actio nEve nt e)/if(e.getSource()=butt on2)try catch (

47、ClassNotF oun dExce pti on ce)JOp tio nPan e.showMessageDialog(s,ce.getMessage(); try Conn ecti on con = DriverMa nager.getC onn ecti on("jdbc:odbc:stu","sa","");Stateme nt stmt = con .createStateme nt();xinxi where 學fromResultSet rs=stmt.executeQuery("select ='

48、;"+textField1.getText()+"”');if(textField1.getText().trim().equals("")學號不可為空!")；JOp tio nPan e.showMessageDialog(this,"else if(rs. next()Stri ng='"+textField1.getText()+"', ='"+up dateSql=" up date姓名xi nxiset='"+textField7.ge

49、tText()+"', 生日期='"+textField2.getText()+"',出textField3.getText()+"',='"+textField8.getText()+"',籍貫='"+='"+textField9.getText()+"', 業='"+textField4.getText()+"',專textField5.getText()+ "”' tryst

50、mt.executeQuery(u pdateSql); catch(SQLExce pti on se)JOp tio nPan e.showMessageDialog( nu II,"改成 功");catch(SQLExce ptio n se)JOp tio nPan e.showMessageDialog(s,se.getMessage();/sc.java 刪除界面import javax.swi ng.*;import java.awt.*;import java.sql.*;p ublic class sc exte nds JFrame imp leme n

51、ts Actio nListe ner static sc s;static JLabel label1 = new JLabel("學號:");static JTextField textField1 = new JTextField("");static JLabel label2 = new JLabel("姓名:");static JTextField textField2 = new JTextField("");static JLabel label3 = new JLabel("性別:&qu

52、ot;);static JTextField textField7=n ew JTextField("");static JLabel label4 = new JLabel("出生日期:");static JTextField textField3 = new JTextField("");static JLabel label5 = new JLabel("政治面貌:");static JTextField textField8=n ew JTextField("");static JLab

53、el label6 = new JLabel("籍貫");static JTextField textField4 = new JTextField("");static JLabel label7 = new JLabel("系別:");static JTextField textField9 = new JTextField("");static JLabel label8 = new JLabel("專業:");static JTextField textField5 = new JTex

54、tField("");static JButton butto n4=new JButto n("刪除");p ublic sc() throws Exce pti onthis.setTitle(" 刪除學生信息")；this.setLayout (nu II);this.setSize(400,400);label1.setBou nds(30, 11,51,33);textField1.setBou nds(86, 16, 74, 22);label2.setBou nds(162, 11, 51, 33);textField2

55、.setBou nds(192, 16, 44, 22);label3.setBou nds(241, 11, 70, 33);textField7.setBou nds(275, 15, 50, 25);label4.setBou nds(31,53, 55, 33);textField3.setBou nds(86, 58, 74, 22);label5.setBou nds(241, 53, 70, 33);textField8.setBou nds(296, 57, 72, 25);label6.setBou nds(163, 53, 26, 33);textField4.setBou

56、 nds(191, 58, 44, 22);label7.setBou nds(30, 94, 50, 33);textField9.setBou nds(86,94,74,22);label8.setBou nds(163, 94, 51, 33);textField5.setBou nds(190, 99, 178, 22);butto n4.setBou nds(295,241,80,33);butt on4 .addActi on Liste ner(this);this.add(label1);this.add(label2);this.add(label3);this.add(la

57、bel4);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(butto n4);this.setDefaultCloseO peratio n( JFrame

58、.DIS POSE_ON_CLOSE); this.setVisible(true);p ublic static void main( Stri ng args) throws Exce pti onsc a= new sc();a.setDefaultCloseO peratio n(JFrame.EXIT_ON_CLOSE);p ublic void acti onP erformed(Act ion Eve nt e)/scif (e.getSource() = butt on4)trycatch (ClassNotF oun dExce pti on ce)JOp tio nPan

59、e.showMessageDialog(s,ce.getMessage(); tryconConnectionDriverMa nager.getCo nn ectio n("jdbc:odbc:stu","sa","");from xinxi where 學學號不可為空！"）；Stateme nt stmt = con. createStateme nt();ResultSetrs=stmt.executeQuery("select=”'+textField1.getText()+"”');if(textField1.getText().trim().equals("")JOp tio nPan e.showMessageDialog(thi