學(xué)生信息管理系統(tǒng)(同名6904)

實驗部分程序如下：主程序：importjavax.swing.*;importjava.awt.*;importjava.awt.event.*;classMyPanelextendsJPanel{Imageimg=Toolkit.getDefaultToolkit().getImage("D:/shiyan3/a.jpg");publicvoidpaint(Graphicsg){g.drawImage(img,0,0,this);}}publicclassMainFormextendsJFrameimplementsActionListener{JMenumSystem=newJMenu("系統(tǒng)");JMenuItemmExit=newJMenuItem("退出");JMenumOperate=newJMenu("數(shù)據(jù)操作");JMenuItemmAdd=newJMenuItem("添加");JMenuItemmDel=newJMenuItem("刪除");JMenuItemmModify=newJMenuItem("修改");JMenumQuery=newJMenu("查詢");JMenuItemmName=newJMenuItem("按姓名查詢");JMenuItemmScore=newJMenuItem("按出生日期查詢");JMenumHelp=newJMenu("幫助");JMenuItemmAbout=newJMenuItem("軟件信息");JMenuBarmBar=newJMenuBar();MainForm(){super("學(xué)生信息管理系統(tǒng)");setSize(875,583);mSystem.add(mExit);mOperate.add(mAdd);mOperate.add(mDel);mOperate.add(mModify);mQuery.add(mName);mQuery.add(mScore);mHelp.add(mAbout);mBar.add(mSystem);mBar.add(mOperate);mBar.add(mQuery);mBar.add(mHelp);setJMenuBar(mBar);mExit.addActionListener(this);mAdd.addActionListener(this);mDel.addActionListener(this);mModify.addActionListener(this);mName.addActionListener(this);mScore.addActionListener(this);mAbout.addActionListener(this);setContentPane(newMyPanel());setVisible(true);}publicvoidactionPerformed(ActionEventae){if(ae.getSource()==mExit)System.exit(0);elseif(ae.getSource()==mAbout)JOptionPane.showMessageDialog(this,"學(xué)生信息管理系統(tǒng)\n\n電院\n\n2012年12月","電子信息",JOptionPane.INFORMATION_MESSAGE);elseif(ae.getSource()==mAdd)newAddForm().setVisible(true);elseif(ae.getSource()==mDel)newDeleteForm().setVisible(true);elseif(ae.getSource()==mModify)newModifyForm().setVisible(true);elseif(ae.getSource()==mName)newNameQueryForm().setVisible(true);elseif(ae.getSource()==mScore)newScoreQueryForm().setVisible(true);}publicstaticvoidmain(String[]args){newMainForm();}}修改部分程序：importjavax.swing.*;importjava.awt.*;importjava.awt.event.*;importjava.sql.*;publicclassModifyFormextendsJFrameimplementsActionListener{JLabellabName=newJLabel("姓名：");JLabellabDate=newJLabel("出生日期：");JLabellabScore=newJLabel("性別：");JTextFieldtxtName=newJTextField(20);JTextFieldtxtDate=newJTextField(18);JTextFieldtxtScore=newJTextField(20);getContentPane().add(pan4,"South");btnAdd.addActionListener(this);btnCancel.addActionListener(this);btnAdd.setEnabled(true);txtDate.setEditable(true);txtScore.setEditable(true);setVisible(true);txtName.requestFocus();}publicvoidactionPerformed(ActionEventae){ Stringrecode,insert1,出生日期,姓名; String性別; if(ae.getSource()==btnCancel) { this.dispose(); } elseif(ae.getSource()==btnAdd){try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); System.out.println("連接數(shù)據(jù)庫成功"); }catch(ClassNotFoundExceptione){ System.out.println("SQLException:"+e.getMessage()); System.out.println("連接數(shù)據(jù)庫不成功"); }try{con=DriverManager.getConnection("jdbc:odbc:St");sql=con.createStatement();insert1="insertinto信息表(姓名,出生日期,性別)values('"+txtName.getText()+"','"+txtDate.getText()+"','"+txtScore.getText()+"')"; sql.executeUpdate(insert1);System.out.println("記錄添加完畢！");btnAdd.setEnabled(false);txtName.setText(""); txtDate.setText("");txtScore.setText("");con.close(); }