(完整word版)学生考勤管理系统(JAVA语言)

1、JAVA程序设计学生考勤管理系统课程名称：JAVA程序设计设计题目：学生考勤管理系统（JAVA）指导老师：XXX班级：数计X级X班姓名： XXX学号： XXXXXXXXXX时间： 2016年某月某日编程工具：MyEclipse （宣版的）编程电蔺：DELL操作系知Windows 7（自己换的）显卡：NVIDIA编程环境：JAVA gW设计功能： 查看学生信息 学生考H 增加，M除，修改学生信息实驶代马: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 加学生信息,)；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/ 学号不能为空!")；return;elsers = stmt.executeQuery('Select * From Stulnfo where Num ="+num+',B);if(rs.next()(stmt.closeO;con.closeO;JOptionPane.showMessageDialog(new JDialogO；学号重复!')；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