學(xué)生考勤管理系統(tǒng)(JAVA語言)

1、JAVA程序設(shè)計學(xué)生考勤管理系統(tǒng)課程名稱：JAVA程序設(shè)計設(shè)計題目：學(xué)生考勤管理系統(tǒng)（JAVA）指導(dǎo)老師：XXX班級：數(shù)計X級X班姓名： XXX學(xué)號： XXXXXXXXXX時間： 2016年某月某日編程工具：MyEclipse （宣版的）編程電藺：DELL操作系知Windows 7（自己換的）顯卡：NVIDIA編程環(huán)境：JAVA gW設(shè)計功能： 查看學(xué)生信息 學(xué)生考H 增加，M除，修改學(xué)生信息實駛代馬:package manger;import javax.swing.JDialoQ；import javax.swing.JFrame;import javax.swino.JOptionPan

2、e;Import javax.swin0.JPanel;import java.awt.BorderLayout;import java.awt.Dimension;import java.awt.Toolkit;Import javax.swlnaJDesktopPane;import javax.swino.JButton;import java.awt.Rectanole;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;

3、Import javax.swino.JTextField;import javax.swing.JLabel;public class AddForm private JFrame jFrame = null;private J Panel JContentPane = null;private J Desktoppane jDesktopPane = null;private JButton jBirttonOK = null;private JButton jBirttonCancel = null;private JTextField jTextName = null;private

4、JTextField jTextNum = null;private JTextField jTextGrade = null;private JLabel jLabelName = null;private JLabel jLabelNum = null;private JLabel jLabelGrade = null;J Frame getJFrameO if (jFrame = null) jFrame = new JFrameO;jFrame.setTitleCS 加學(xué)生信息,)；jFrame.setSize(new Dimension(242,205);Dimension scre

5、enSize = Toolkit.getDefaultToolkit().getScreenSize()y/n 口居中顯示screenSize = Toolkit.getDefaultToolkft().oetScreenSize();jFrame.setLocation(screenSize.width-jFrame.oetWidth()/2,(screenSize.heiaht-jFrame.oetHeight()/2); jFrame.setContentPane(oetJContentPaneO);)return jFrame;)private J Panel QetJContentP

6、aneO (if OContentPane = null) jContentPane = new JPanelO;jContentPane.setLayout(new BorderLayoutO);jContentPane.add(oetJDesktopPane()f BorderLayout.CENTER);)return jContentPane;)private JDesktopPane getJDesktopPane() If ODesktopPane = null) jLabelGrade = new JLabelO；jLabelGrade.setBounds(new Rectan0

7、le(3Ov 100,38,18);jLabelGrade.setText('S 級:)；jLabelNum = new JLabelO;jLabelNum.setBounds(new Rectangle(30f 60,38,18);ILabelNum.setTextf 號jLabelName = new JLabelO;jLabelName.setBounds(new Rectangle(30,20,38,18);jLabelName.setTextC# 2 ：")；jDesktopPane = new JDesktopPaneO;jDesktopPane.add(QetJ

8、ButtonOK()l null);jDesktopPane.add(getJButtonCancel(), null);jDesktopPane.add(oetJTextName()f null);jDesktopPane.add(aetJTextNum(), null);jDesktopPane.add(getJTextGrade()9 null);jDesktopPane.adddLabelNamev null);jDesktopPane.adddLabelNum, null);JDesktopPane.addOLabelGrade, null);return jDesktopPane;

9、)private JButton geUButtonOKO if OButtonOK = null) jButtonOK = new JButtonO;jButtonOK.setBounds(new Rectangle(20f 135,80,22);jButtonOK. setText(提交)；jButtonOK.addMouseListener(new java.awt.event.MouseAdapter() public void mouseClickeddava.awt.event.MouseEvent e) try(AddSQLQ; catch (Exception e1)/TODO

10、自動生成catch塊e1.printStackTrace();J/TODO Auto-generated Event stub mouseClicked()private void AddSQLO throws Exception String DBDriversun.jdbc.odbc.JdbcOdbcDriver-;String Str=Bjdbc:odbc:driver=Microsoft Access Driver (*.mdb);DBQ=StulnfoB;Connection con=null;Statement stmUnull;ResultSet rs=null;Class.fo

11、rName(DBDriver);con=DriverManagergetConnection(Str);stmt=con.createStatement();String name = jTextName.getTextO;if(name.equalsn)(stmt.close();con.closeO;JOptionPane.showMessageDialog(new JDialog(),姓名不能為空!");return;)String num = JTextNum.oetTextO;if(num.equals(iB)(stmt.closeO；con.closeO;JOptionP

12、ane.showMessageDialog(new JDialogO/ 學(xué)號不能為空!")；return;elsers = stmt.executeQuery('Select * From Stulnfo where Num ="+num+',B);if(rs.next()(stmt.closeO;con.closeO;JOptionPane.showMessageDialog(new JDialogO；學(xué)號重復(fù)!')；return;)String grade = jTextGrade.getText();rf(orade.equalsD)(stmt

13、doseO;con.closeO；JOptionPane.showMessaoeDialoo(new JDialoQ()9aS 級不能為空!)；return;stmtexecuteUpdateflnsert Into Stulnfo Values(,i+name+'lll'+num+'lf,l,+orade+,)ir);stmt.closeO;con.close();MainForm.Reflesh();oetJFrame(),dispose();JOptionPane.showMessaaeDialog(new JDialogO/S 加成曲)；);)return jB

14、uttonOK;)private JButton getJButtonCancelO if OButtonCancel = null) jButtonCancel = new JButtonO;jButtonCancel.setBounds(new Rectanole(137,135,80,22);jButtonCancel.setTextC 取消");jButtonCancel.addMouseListener(new java.awtevent.MouseAdapter() public void mouseCllcked(java.awt.eventMouseEvent e) getJFrame().dispose(););)return jButtonCancel;private JTextFleld oeUTextNameO if (jTextName = null) jTextName = new JTextReldO;jTextName.setBounds(new Rectanale(90,20,120,22);)return jTextName;private JTextFleld oetJTextNumO if GTextNum = null) jTextNum = new JTextfieldO;jTextNum.setBounds