课程设计考勤管理系统源代码

《课程设计考勤管理系统源代码》由会员分享，可在线阅读，更多相关《课程设计考勤管理系统源代码（51页珍藏版）》请在装配图网上搜索。

1、package kaoqin;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(返回

2、 );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()/Overridep

3、ublic void actionPerformed(ActionEvent e)/ TODO自动生成的方法存根UBoundFrame frame=new UBoundFrame();dispose(););b2.addActionListener(new ActionListener()/Overridepublic void actionPerformed(ActionEvent e)/ TODO自动生成的方法存根BoundFrame frame=new BoundFrame();dispose(););b3.addActionListener(new ActionListener()/O

4、verridepublic void actionPerformed(ActionEvent e)/ TODO自动生成的方法存根MFrame frame=new MFrame();dispose(););package kaoqin;class BoundFrame extends JFramepublic BoundFrame()this.setTitle(弹性工作制 );this.setVisible(true);this.setContentPane(new JPanel();this.setSize(400,400);create();JLabel k1,k2,k3,k4,k5,k6;

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

6、=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.createHorizontalS

7、trut(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

8、);box.add(box4);box.add(Box.createVerticalStrut(20);box.add(box5);this.add(box);b1.addActionListener(new ActionListener()/确定Overridepublic void actionPerformed(ActionEvent e)/ TODO自动生成的方法存根AttendFrame frame=new AttendFrame();dispose(););package kaoqin;public class ConnectionDB private String sqlURL=

9、jdbc:odbc:bobo;/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 String4;public ConnectionDB()try Class.forName(JDriver);connect

10、ion=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

11、statement.close();connection.close(); catch (SQLException e) e.printStackTrace();public void createTable()tableSQL0=create table staff_info(+Sno char(9) primary key,+Sname char(10) not null,+Sage smallint,+enter_time char(10) not null,+position char(10) not null,+sex char(1),+password char(6);tableS

12、QL1=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=createtable everymonth_statistics(+Sno char(9) not null,+Sname char(10) not null,+remain_time char(4),+late_times smallint,+early_leave smallint,+work_day s

13、mallint,+primary key(Sno),+foreign key(Sno)+references staff_info(Sno) on delete cascade); tableSQL3=create table everyday_statistics(+Sno char(9) not null,+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(S

14、no) on delete cascade);try for(int i=0;i4;i+)statement.executeUpdate(tableSQLi); catch (SQLException e) e.printStackTrace();private static ResultSet executeQuery(String sql) try if(conn=null)new ConnectionDB();returnconn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR _UPDATABLE).ex

15、ecuteQuery(sql); catch (SQLException e) e.printStackTrace(); return null; finally package kaoqin;class Equ_Frame extends JFrame /配置信息public Equ_Frame()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

16、;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(上班时间： );k2=new JLabel(:);k3=new JLabel(下班时间： );k4=new JLabel(:);k5=new JLabel(每月工作总时间：);k6=new JLabel(每月工作天数：);k7=new JLabel(每月工作日期：);k8=new JLabel();k9=new JLabel(每月放假日

17、期：);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=new JLabel(星期日 );box1=Box.createHorizontalBox();box2=Box.createHor

18、izontalBox();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);box1.add(f2);box2.add(k3);box2.add(f3);box2.add(k4);box2.add(f4);

19、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);box.add(Box.createVerticalStrut(20);box.add(box2);box.add(Box.c

20、reateVerticalStrut(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);this.add(box);b1.addActionListener(new ActionListener()/确定Overr

21、idepublic void actionPerformed(ActionEvent e)/ TODO自动生成的方法存根EquAltFrame frame=new EquAltFrame();dispose(););b2.addActionListener(new ActionListener()/确定Overridepublic void actionPerformed(ActionEvent e)/ TODO自动生成的方法存根MFrame frame=new MFrame();dispose(););package kaoqin;class EquAltFrame extends JFra

22、me/修改配置信息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 create()

23、k1=new JLabel(上班时间： );k2=new JLabel(:);k3=new JLabel(下班时间： );k4=new JLabel(:);k5=new JLabel(每月工作总时间：);k6=new JLabel(每月工作天数：);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 JTextFi

24、eld(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.createHorizo

25、ntalBox();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.

26、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);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(B

27、ox.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()/确定Overridepublic void actionPerformed(ActionEvent e)/ TODO自动生成的方法存根Equ_Frame in=new Equ_Frame();EquAltF

28、rame on=new EquAltFrame(););b2.addActionListener(new ActionListener()/确定Overridepublic void actionPerformed(ActionEvent e)/ TODO自动生成的方法存根Equ_Frame frame=new Equ_Frame();dispose(););package kaoqin;class login extends JFrame /管理员登陆界面public login()this.setTitle(管理员登陆界面);this.setSize(300,300);this.setCo

29、ntentPane(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 JTextField(10);jPasswordField1=new JPasswordField(10);JButton

30、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);b

31、ox2.add(jTextField1);box3=Box.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.cr

32、eateVerticalBox();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()Overri

33、depublic void actionPerformed(ActionEvent e) / TODO自动生成的方法存根/ login im=new login(); Stringname=jTextField1.getText(),password=jPasswordField1.getText();if(name.equals(admin)&password.equals(123456)MFrame mi=new MFrame();dispose();elseJOptionPane.showMessageDialog(new JFrame(WARNING),用户名或密码错误););butt

34、on2.addActionListener(new ActionListener()Overridepublic void actionPerformed(ActionEvent e) / TODO自动生成的方法存根Main_login frame=new Main_login();dispose(););button3.addActionListener(new ActionListener()Overridepublic void actionPerformed(ActionEvent e) / TODO自动生成的方法存根MPwd f1=new MPwd();dispose(););pac

35、kage kaoqin;class login1 extends JFrame /普通用户登陆界面public login1()this.setTitle(普通用户登陆界面);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 JLa

36、bel(用户名 );JLabel jLabel3=new JLabel(密码 );jTextField1=new JTextField(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(

37、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(jPasswordField1);box4=Box.createHorizontalBox();box4.add(butt

38、on1);box4.add(Box.createHorizontalStrut(20);box4.add(button2);box5=Box.createHorizontalBox();box5.add(button3);box=Box.createVerticalBox();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(box

39、4);box.add(Box.createVerticalStrut(20);box.add(box5);this.add(box);button1.addActionListener(new ActionListener()Overridepublic void actionPerformed(ActionEvent e) / TODO自动生成的方法存根Stringname=jTextField1.getText(),password=jPasswordField1.getText();if(name.equals(user)&password.equals(123456)WoSerFram

40、e2 mi=new WoSerFrame2();dispose();elseJOptionPane.showMessageDialog(new JFrame(WARNING),用户名或密码错误););button2.addActionListener(new ActionListener()Overridepublic void actionPerformed(ActionEvent e) / TODO自动生成的方法存根Main_login frame=new Main_login();dispose(););button3.addActionListener(new ActionListen

41、er()Overridepublic void actionPerformed(ActionEvent e) / TODO自动生成的方法存根MPwd f1=new MPwd();dispose(););package kaoqin;public class Main_login extends JFrame implements ActionListener public Main_login()super( 选择用户类型);this.setSize(300,300);this.setContentPane(new JPanel();create();private void create()

42、JButton b1,b2,b3;Box box1,box2,box3,box;b1=new JButton(系统管理员 );b2=new JButton(普通用户 );b3=new JButton(退出登陆 );b1.addActionListener(this);b2.addActionListener(this);b3.addActionListener(this);box1=Box.createHorizontalBox();box2=Box.createHorizontalBox();box3=Box.createHorizontalBox();box1.add(b1);box2.a

43、dd(b2);box3.add(b3);box=Box.createVerticalBox();box.add(box1);box.add(Box.createVerticalStrut(20);box.add(box2);box.add(Box.createVerticalStrut(40);box.add(box3);this.add(box);public void actionPerformed(ActionEvent e)if(e.getActionCommand()=系统管理员 )login frame=new login();dispose();else if(e.getActi

44、onCommand()=普通用户 )login1 frame=new login1();dispose();else if(e.getActionCommand()=退出登陆 )System.exit(0);public static void main(String args)/ConnectionDB myDB=new ConnectionDB();int flag=0; /判断是否创建过数据库的标志File file=new File(SQL.txt);try / 读入标志FileReader in=new FileReader(file);int len;if(len=in.read(

45、)!=-1)flag=1; /已创建了数据库，置1in.close(); catch (FileNotFoundException e) e.printStackTrace(); catch (IOException e) e.printStackTrace();/ 没有创建过数据库if(flag=0)ConnectionDB myDB=new ConnectionDB();myDB.createTable();myDB.breakDB();try / 写入标志FileWriter out=new FileWriter(file);out.write(1);out.close(); catch

46、 (IOException e) e.printStackTrace();Main_login frame1=new Main_login();frame1.setVisible(true);package kaoqin;class MFrame extends JFrame /主功能界面public MFrame()this.setTitle(主要功能 );this.setContentPane(new JPanel();this.setSize(350,200);this.setVisible(true);init();private void init()JButton button1=

47、new JButton(JButton button2=new JButton(JButton button3=new JButton(JButton button4=new JButton(员工信息管理员工出勤信息配置信息 );退出登陆 );););Box box1=Box.createHorizontalBox();Box box2=Box.createHorizontalBox();Box box3=Box.createVerticalBox();box1.add(button1);box1.add(Box.createHorizontalStrut(10);box1.add(butto

48、n2);box1.add(Box.createHorizontalStrut(10);box1.add(button3);box2.add(button4);box3.add(box1);box3.add(Box.createVerticalStrut(30);box3.add(box2);this.add(box3);button1.addActionListener(new ActionListener()/Overridepublic void actionPerformed(ActionEvent e)/ TODO自动生成的方法存根Worker_Frame frame=new Work

49、er_Frame();dispose(););button2.addActionListener(new ActionListener()/Overridepublic void actionPerformed(ActionEvent e)/ TODO自动生成的方法存根AttendFrame frame=new AttendFrame();dispose(););button3.addActionListener(new ActionListener()/Overridepublic void actionPerformed(ActionEvent e)/ TODO自动生成的方法存根Equ_F

50、rame frame=new Equ_Frame();dispose(););button4.addActionListener(new ActionListener()/Overridepublic void actionPerformed(ActionEvent e)/ TODO自动生成的方法存根Main_login frame=new Main_login();dispose(););package kaoqin;class MPwd extends JFrame /管理员密码修改public MPwd()this.setTitle(修改密码 );this.setVisible(true);this.setSize(300,200);this.setContentPane(new JPanel();init();JLabel L1,L2,L3;JPasswordField p1,p2,p3;