1、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.set

2、Title(工作制類型);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.createVerti

3、calBox();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

4、 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 自動生成的

5、方法存根 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 exte

6、nds JFramepublic 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

7、JLabel(當(dāng)月工時(shí)：);k4=new JLabel(:);k5=new JLabel(當(dāng)月工作天數(shù));k6=new JLabel(當(dāng)月富余：);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.createHori

8、zontalBox();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);box

9、5.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

10、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 JDr

11、iver=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;priv

12、ate static Connection conn = null;private String tableSQL=new String4;public ConnectionDB()try Class.forName(JDriver);connection=DriverManager.getConnection(sqlURL);statement=connection.createStatement(); catch (ClassNotFoundException e) e.printStackTrace();catch (SQLException e) e.printStackTrace()

13、;public Connection getConnection()return connection;public Statement getStatement()return statement;public void breakDB()try statement.close();connection.close(); catch (SQLException e) e.printStackTrace();public void createTable()tableSQL0=create table staff_info(+ Sno char(9) primary key,+ Sname c

14、har(10) not null,+ Sage smallint,+ enter_time char(10) not null,+ position char(10) not null,+ sex char(1),+ password char(6);tableSQL1=create table pz_info(+ arrive_hour char(2),+ arrive_minute char(2),+ leave_hour char(2),+ leave_minute char(2),+ everyday_time char(2);tableSQL2=create table everym

15、onth_statistics(+ Sno char(9) not null,+ Sname char(10) not null,+ remain_time char(4),+ late_times smallint,+ early_leave smallint,+ work_day smallint,+ primary key(Sno),+ foreign key(Sno)+ references staff_info(Sno) on delete cascade);tableSQL3=create table everyday_statistics(+ Sno char(9) not nu

16、ll,+ Sname char(10) not null,+ hour char(2),+ minute char(2),+ action char(6),+ time char(4),+ primary key(Sno),+ foreign key(Sno)+ references staff_info(Sno) on delete cascade); try for(int i=0;i4;i+)statement.executeUpdate(tableSQLi); catch (SQLException e) e.printStackTrace();private static Resul

17、tSet executeQuery(String sql) try if(conn=null)new ConnectionDB();return conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE).executeQuery(sql); catch (SQLException e) e.printStackTrace();return null; finally package kaoqin;import javax.swing.*;import java.awt.*;import ja

18、va.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 Equ_Frame extends JFrame /配置信息public Equ_Frame()this.setTitle(配置信息);this.setSize(400,400);this.setContentPane(new JPanel();

19、this.setVisible(true);this.create();JLabel k1,k2,k3,k4,k5,k6,k7,k8,k9,k10;JLabel f1,f2,f3,f4,f5,f6,f7,f8,f9,f10;Box box1,box2,box3,box4,box5,box6,box7,box;JButton b1,b2;private void create()k1=new JLabel(上班時(shí)間：);k2=new JLabel(:);k3=new JLabel(下班時(shí)間：);k4=new JLabel(:);k5=new JLabel(每月工作總時(shí)間：);k6=new JLa

20、bel(每月工作天數(shù)：);k7=new JLabel(每月工作日期：);k8=new JLabel();k9=new JLabel(每月放假日期：);k10=new JLabel();b1=new JButton(修改);b2=new JButton(返回);f1=new JLabel(08);f2=new JLabel(30);f3=new JLabel(17);f4=new JLabel(30);f5=new JLabel(200);f6=new JLabel(22);f7=new JLabel(星期一);f8=new JLabel(星期五);f9=new JLabel(星期六);f10=

21、new JLabel(星期日);box1=Box.createHorizontalBox();box2=Box.createHorizontalBox();box3=Box.createHorizontalBox();box4=Box.createHorizontalBox();box5=Box.createHorizontalBox();box6=Box.createHorizontalBox();box7=Box.createHorizontalBox();box=Box.createVerticalBox();box1.add(k1);box1.add(f1);box1.add(k2);

22、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(k7);box5.add(f7);box5.add(k8);box5.add(f8);box6.add(k9);box6.add(f9);box6.add(k10);box6.add(f10);box7.add(b1);box7.add(Box.createHorizontalStrut(20);box7.add(b2);box.add(box1

23、);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);box.add(Box.createVerticalStrut(20);box.add(box6);box.add(Box.createVerticalStrut(20);box.add(box7

24、);this.add(box); b1.addActionListener(new ActionListener() /確定 Override public void actionPerformed(ActionEvent e) / TODO 自動生成的方法存根 EquAltFrame frame=new EquAltFrame(); dispose(); ); b2.addActionListener(new ActionListener() /確定 Override public void actionPerformed(ActionEvent e) / TODO 自動生成的方法存根 MF

25、rame 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 EquAltFrame extends JF

26、rame /修改配置信息public EquAltFrame()this.setTitle(修改配置信息);this.setSize(400,400);this.setContentPane(new JPanel();this.setVisible(true);this.create();JLabel k1,k2,k3,k4,k5,k6,k7,k8,k9,k10;JTextField f1,f2,f3,f4,f5,f6,f7,f8,f9,f10;Box box1,box2,box3,box4,box5,box6,box7,box;JButton b1,b2;private void creat

27、e()k1=new JLabel(上班時(shí)間：);k2=new JLabel(:);k3=new JLabel(下班時(shí)間：);k4=new JLabel(:);k5=new JLabel(每月工作總時(shí)間：);k6=new JLabel(每月工作天數(shù)：);k7=new JLabel(每月工作日期：);k8=new JLabel();k9=new JLabel(每月放假日期：);k10=new JLabel();b1=new JButton(保存);b2=new JButton(取消);f1=new JTextField(5);f2=new JTextField(5);f3=new JTextFie

28、ld(5);f4=new JTextField(5);f5=new JTextField(5);f6=new JTextField(5);f7=new JTextField(5);f8=new JTextField(5);f9=new JTextField(5);f10=new JTextField(5);box1=Box.createHorizontalBox();box2=Box.createHorizontalBox();box3=Box.createHorizontalBox();box4=Box.createHorizontalBox();box5=Box.createHorizon

29、talBox();box6=Box.createHorizontalBox();box7=Box.createHorizontalBox();box=Box.createVerticalBox();box1.add(k1);box1.add(f1);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(k7);box5.add(f7);box5.add(k8);box5.a

30、dd(f8);box6.add(k9);box6.add(f9);box6.add(k10);box6.add(f10);box7.add(b1);box7.add(Box.createHorizontalStrut(20);box7.add(b2);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(Bo

31、x.createVerticalStrut(20);box.add(box5);box.add(Box.createVerticalStrut(20);box.add(box6);box.add(Box.createVerticalStrut(20);box.add(box7);this.add(box); b1.addActionListener(new ActionListener() /確定 Override public void actionPerformed(ActionEvent e) / TODO 自動生成的方法存根 Equ_Frame in=new Equ_Frame();

32、EquAltFrame on=new EquAltFrame(); in.f1.setText(on.f1.getText(); in.f2.setText(on.f2.getText(); in.f3.setText(on.f3.getText(); in.f4.setText(on.f4.getText(); in.f5.setText(on.f5.getText(); in.f6.setText(on.f6.getText(); in.f7.setText(on.f7.getText(); in.f8.setText(on.f8.getText(); in.f9.setText(on.f

33、9.getText(); in.f10.setText(on.f10.getText(); ); b2.addActionListener(new ActionListener() /確定 Override public void actionPerformed(ActionEvent e) / TODO 自動生成的方法存根 Equ_Frame frame=new Equ_Frame(); dispose(); );package kaoqin;import javax.swing.*;import java.awt.*;import java.awt.event.*;import java.

34、sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.sql.*;class login extends JFrame /管理員登陸界面 public login() this.setTitle(管理員登陸界面); this.setSize(300,300); this.setContentPane(new JPanel(); this.setVisible(true); i

35、nit(); JTextField jTextField1; JPasswordField jPasswordField1; private void init() JLabel jLabel1=new JLabel(管理員登陸); JLabel jLabel2=new JLabel(用戶名); JLabel jLabel3=new JLabel(密碼); jTextField1=new JTextField(10); jPasswordField1=new JPasswordField(10); JButton button1=new JButton(確定); JButton button2

36、=new JButton(取消); JButton button3=new JButton(修改密碼); Box box,box1,box2,box3,box4,box5; box1=Box.createHorizontalBox(); box1.add(jLabel1); box1.add(Box.createHorizontalStrut(10); box2=Box.createHorizontalBox(); box2.add(jLabel2); box2.add(Box.createHorizontalStrut(20); box2.add(jTextField1); box3=Box

37、.createHorizontalBox(); box3.add(jLabel3); box3.add(Box.createHorizontalStrut(20); box3.add(jPasswordField1); box4=Box.createHorizontalBox(); box4.add(button1); box4.add(Box.createHorizontalStrut(20); box4.add(button2); box5=Box.createHorizontalBox(); box5.add(button3); box=Box.createVerticalBox();

38、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); button1.addActionListener(new ActionListener() Override public

39、 void actionPerformed(ActionEvent e) / TODO 自動生成的方法存根 / login im=new login(); Stringname=jTextField1.getText(),password=jPasswordField1.getText(); if(name.equals(admin)&password.equals() MFrame mi=new MFrame(); dispose(); else JOptionPane.showMessageDialog(new JFrame(WARNING), 用戶名或密碼錯(cuò)誤); ); button2.

40、addActionListener(new ActionListener() Override public void actionPerformed(ActionEvent e) / TODO 自動生成的方法存根 Main_login frame=new Main_login(); dispose(); ); button3.addActionListener(new ActionListener() Override public void actionPerformed(ActionEvent e) / TODO 自動生成的方法存根 MPwd f1=new MPwd(); dispose

41、(); ); 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 login1 extends JFrame /普通用戶登陸界面public login1()this.se

42、tTitle(普通用戶登陸界面);this.setSize(300,300); this.setContentPane(new JPanel();this.setVisible(true); init(); JTextField jTextField1; JPasswordField jPasswordField1; private void init() JLabel jLabel1=new JLabel(員工登陸); JLabel jLabel2=new JLabel(用戶名); JLabel jLabel3=new JLabel(密碼); jTextField1=new JTextFie

43、ld(10); jPasswordField1=new JPasswordField(10); JButton button1=new JButton(確定); JButton button2=new JButton(取消); JButton button3=new JButton(修改密碼); Box box,box1,box2,box3,box4,box5; box1=Box.createHorizontalBox(); box1.add(jLabel1); box1.add(Box.createHorizontalStrut(10); box2=Box.createHorizontalBox(); box2.add(jLabel2); box2.add(Box.createHorizontalStrut(20); box2.add(jTextField1); box3=Box.createHorizontalBox(); box3.add(jLabel3); box3.add(Box.createHorizontalStrut(20); box3.add(j