（考勤管理）课程设计考勤管理系统源代码（DOC51页）.doc
51页
package kaoqin;import javax.swing.*;import java.awt.*;import java.awt.event.*;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.sql.*;class AttendFrame extends JFrame//工作制类型{ public AttendFrame() { this.setTitle("工作制类型"); this.setVisible(true); this.setContentPane(new JPanel()); this.setSize(300,200); create(); } private void create() { JButton b1,b2,b3; Box box1,box2,box; b1=new JButton("非弹性工作制"); b2=new JButton("弹性工作制"); b3=new JButton("返回"); box1=Box.createHorizontalBox(); box2=Box.createHorizontalBox(); box=Box.createVerticalBox(); box1.add(b1); box1.add(Box.createHorizontalStrut(20)); box1.add(b2); box2.add(b3); box.add(box1); box.add(Box.createVerticalStrut(30)); box.add(box2); this.add(box); b1.addActionListener(new ActionListener() // { @Override public void actionPerformed(ActionEvent e) { // TODO 自动生成的方法存根 UBoundFrame frame=new UBoundFrame(); dispose(); } }); b2.addActionListener(new ActionListener() // { @Override public void actionPerformed(ActionEvent e) { // TODO 自动生成的方法存根 BoundFrame frame=new BoundFrame(); dispose(); } }); b3.addActionListener(new ActionListener() // { @Override public void actionPerformed(ActionEvent e) { // TODO 自动生成的方法存根 MFrame frame=new MFrame(); dispose(); } }); }}package kaoqin;import javax.swing.*;import java.awt.*;import java.awt.event.*;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.sql.*;class BoundFrame extends JFrame{ public BoundFrame() { this.setTitle("弹性工作制"); this.setVisible(true); this.setContentPane(new JPanel()); this.setSize(400,400); create(); } JLabel k1,k2,k3,k4,k5,k6; JTextField f1,f2,f3,f4,f5,f6; Box box1,box2,box3,box4,box5,box; JButton b1; private void create() { k1=new JLabel("工号："); k2=new JLabel("姓名："); k3=new JLabel("当月工时："); k4=new JLabel(":"); k5=new JLabel("当月工作天数"); k6=new JLabel("当月富余："); b1=new JButton("返回"); f1=new JTextField(5); f2=new JTextField(5); f3=new JTextField(5); f4=new JTextField(5); f5=new JTextField(5); f6=new JTextField(5); box1=Box.createHorizontalBox(); box2=Box.createHorizontalBox(); box3=Box.createHorizontalBox(); box4=Box.createHorizontalBox(); box5=Box.createHorizontalBox(); box=Box.createVerticalBox(); box1.add(k1); box1.add(f1); box1.add(Box.createHorizontalStrut(20)); box1.add(k2); box1.add(f2); box2.add(k3); box2.add(f3); box2.add(k4); box2.add(f4); box3.add(k5); box3.add(f5); box4.add(k6); box4.add(f6); box5.add(b1); box.add(box1); box.add(Box.createVerticalStrut(20)); box.add(box2); box.add(Box.createVerticalStrut(20)); box.add(box3); box.add(Box.createVerticalStrut(20)); box.add(box4); box.add(Box.createVerticalStrut(20)); box.add(box5); this.add(box); b1.addActionListener(new ActionListener() //确定 { @Override public void actionPerformed(ActionEvent e) { // TODO 自动生成的方法存根 AttendFrame frame=new AttendFrame(); dispose(); } }); }}package kaoqin;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class ConnectionDB { private String JDriver="sun.jdbc.odbc.JdbcOdbcDriver"; private String sqlURL="jdbc:odbc:bobo"; //private String JDriver="com.microsoft.sqlserver.jdbc.SQLServerDriver"; //private String sqlURL="jdbc:sqlserver://localhost:1433;DatabaseName=MyTest;integratedSecurity=TRUE;"; private Connection connection; private Statement statement; private static Connection conn = null; private String[] tableSQL=new String[4]; public ConnectionDB(){ try { Class.forName(JDriver); connection=DriverManager.getConnection(sqlURL); statement=connection.createStatement(); } catch (ClassNotFoundException e) { e.printStackTrace(); }catch (SQLException e) { e.printStackTrace(); } } public Connection getConnection(){ return connection; } public Statement getStatement(){ return statement; } public void breakDB(){ try { statement.close(); connection.。
