java考勤管理系统数据库实现.docx

1、java考勤管理系统数据库实现4.2设计代码Java源程序：import java.awt.*;import java.awt.event.*;import javax.swing.*;import java.awt.*;import java.sql.*;import java.lang.*; import java.util.*; import javax.swing.table.*;import java.math.*; class DB_LS implements ActionListener JFrame frame=new JFrame(欢迎进入LS工资管理系统); JLabel

2、label=new JLabel(09网络2_54_李胜,JLabel.CENTER); JButton button1=new JButton(进入系统); JButton button2=new JButton(退出系统); ImageIcon im=new ImageIcon(1.jpg); JLabel a1=new JLabel(im); void Create() JPanel pcontentPane=(JPanel)frame.getContentPane(); JPanel pcontentPane1=new JPanel(); pcontentPane.add(label)

3、; pcontentPane.setLayout(new FlowLayout(); pcontentPane.add(button1); pcontentPane.add(button2); pcontentPane.add(new Label( ); pcontentPane.add(a1); pcontentPane.setBackground(Color.green); pcontentPane.setVisible(true); button1.addActionListener(this); button2.addActionListener(this); frame.setDef

4、aultCloseOperation(JFrame.EXIT_ON_CLOSE); frame.pack(); frame.setBounds(200,100,550,600); frame.setVisible(true); public static void main(String args) DB_LS dome=new DB_LS(); dome.Create(); public void actionPerformed(ActionEvent e) if(button1.equals(e.getSource() DL dl=new DL(); dl.create(); if(but

5、ton2.equals(e.getSource()/退出 System.exit(0); class DL implements ActionListener JFrame frame=new JFrame(职工/管理员登陆); JLabel label1=new JLabel(用户名); JLabel label2=new JLabel(密码); JButton logonButton1=new JButton(管理员登录); JButton logonButton2=new JButton(职工登录); JButton cancelButton=new JButton(退出); JText

6、Field t1=new JTextField(0); JTextField t2=new JTextField(0); ImageIcon im=new ImageIcon(2.jpg); JLabel a2=new JLabel(im); JTextField username=new JTextField(9); JPasswordField password=new JPasswordField(9); void create() JPanel p=(JPanel)frame.getContentPane(); JPanel p1=new JPanel(); p.setLayout(n

7、ew FlowLayout(); p.add(label1); p.setSize(5,5); p.setLocation(4,8); p.add(username); p.setSize(100,200); p.setLocation(800,800); p.add(label2); p.setSize(50,20); p.setLocation(40,80); p.add(password); p.setSize(100,20); p.setLocation(80,120); p.add(logonButton1); p.add(new JLabel( ); p.add(logonButt

8、on2); p.add(new JLabel( ); p.add(cancelButton); p.add(new JLabel( ); p.add(a2); p.add(t1); p.add(t2); p.setBackground(Color.blue); p.setVisible(true); logonButton1.addActionListener(this); logonButton2.addActionListener(this); cancelButton.addActionListener(this); frame.setDefaultCloseOperation(JFra

9、me.EXIT_ON_CLOSE); frame.pack(); frame.setBounds(200,100,750,550); frame.setVisible(true); public void actionPerformed(ActionEvent e) if(logonButton1.equals(e.getSource()&(username.getText().equals(123)=true)&(password.getText().equals(123)=true) GZGLZJM gz=new GZGLZJM(); gz.create(); elseJOptionPan

10、e.showMessageDialog(null,对不起,你输入的密码错误!); ; if(logonButton2.equals(e.getSource()&(username.getText().equals(t1.getText()=true)&(password.getText().equals(t2.getText()=true) XK xk=new XK(); xk.create(); Connection con; Statement sql; ResultSet rs; Vector vector=new Vector(); try Class.forName(sun.jdbc

11、.odbc.JdbcOdbcDriver); catch (ClassNotFoundException e1) System.out.println( + e1); try con = DriverManager.getConnection(jdbc:odbc:123, , ); sql = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); sql.executeQuery(SELECT Gno,mm FROM Y WHERE Gno=+t1.getText() +AND mm=+

12、t2.getText(); catch (SQLException e1) System.out.println(e1); if(cancelButton.equals(e.getSource() System.exit(0); class GZGLZJM extends JFrame implements ActionListener JFrame f=new JFrame(工资管理系统); JButton b1=new JButton(津贴管理); JButton b2=new JButton(总查询); JButton b3=new JButton(工资管理); JButton b4=n

13、ew JButton(后勤管理); JButton b6=new JButton(员工个人信息管理); JButton b5=new JButton(返回); ImageIcon im=new ImageIcon(3.jpg); JLabel a3=new JLabel(im); void create() JPanel p=(JPanel)f.getContentPane(); JPanel p1=new JPanel(); p.setLayout(new FlowLayout(); p.add(b1); p.add(new JLabel( ); p.add(b6); p.add(new J

14、Label( ); p.add(b3); p.add(new JLabel( ); p.add(b4); p.add(new JLabel( ); p.add(b2); p.add(new JLabel( ); p.add(b5); p.add(a3); p.setBackground(Color.red); p.setVisible(true); b1.addActionListener(this); b2.addActionListener(this); b3.addActionListener(this); b4.addActionListener(this); b5.addAction

15、Listener(this); b6.addActionListener(this); f.setBounds(200,100,800,600); f.setVisible(true); public void actionPerformed(ActionEvent e) if(b5.equals(e.getSource()/返回 DL d=new DL(); f.dispose(); if(b1.equals(e.getSource()/津贴管理 JTGL jt=new JTGL(); jt.create(); if(b6.equals(e.getSource()/员工个人信息管理 YGGL

16、 yg=new YGGL(); yg.create(); if(b2.equals(e.getSource()/查询 XK xk=new XK(); xk.create(); if(b4.equals(e.getSource()/后勤管理 KQGL kq=new KQGL(); kq.create(); if(b3.equals(e.getSource()/工资管理 GZGL gz=new GZGL(); gz.create(); class KQGL implements ActionListener JFrame f=new JFrame(录入修改删除考勤信息); JButton b1=n

17、ew JButton(录入); JButton b2=new JButton(修改); JButton b3=new JButton(删除); JButton b4=new JButton(查询所有); JButton b5=new JButton(返回); JTextField tf1=new JTextField(4); JTextField tf2=new JTextField(4); JTextField tf3=new JTextField(4); JTextField tf4=new JTextField(4); JTextField tf5=new JTextField(6);

18、JButton b6=new JButton(查询单人考勤); String cloum=职工号,缺勤天数,缺勤类别,缺勤时间; Object row=new Object504; JTable table=new JTable(row,cloum); JScrollPane scrollpane=new JScrollPane(table); JSplitPane splitpane=new JSplitPane(JSplitPane.VERTICAL_SPLIT); void create() JPanel p=(JPanel)f.getContentPane(); p.setLayout

19、(new FlowLayout(); /p.add(scrollpane); p.add(splitpane); JPanel p1=new JPanel(); p1.add(b1); p1.add(b2); p1.add(b3); p1.add(b4); p1.add(b6); p1.add(b5); JPanel p2=new JPanel(); p2.setBackground(Color.red); p2.add(scrollpane); JPanel p3=new JPanel(); p.setLayout(new FlowLayout(); p.add(new JLabel();

20、p.add(new JLabel(职工号); p.add(tf1); p.add(new JLabel(缺勤天数); p.add(tf2); p.add(new JLabel(缺勤类别); p.add(tf3); p.add(new JLabel(); p.add(new JLabel(缺勤时间); p.add(tf4); p.add(new JLabel( 在此处输入职工号点击查询删除); p.add(tf5); splitpane.add(p1,splitpane.TOP); splitpane.add(p2,splitpane.BOTTOM); splitpane.setDividerL

21、ocation(50); p.setBackground(Color.CYAN); b1.addActionListener(this); b2.addActionListener(this); b3.addActionListener(this); b4.addActionListener(this); b5.addActionListener(this); b6.addActionListener(this); f.setBounds(200,100,500,600); f.setResizable(true);/可以调整界面大小 f.setVisible(true); public vo

22、id actionPerformed(ActionEvent e) if(b1.equals(e.getSource() /添加 Connection con; Statement sql; ResultSet rs; try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); catch (ClassNotFoundException e1) System.out.println( + e1); try con = DriverManager.getConnection(jdbc:odbc:123, , ); sql = con.createStatem

23、ent(); String insertStr = INSERT INTO K VALUES + ( + + tf1.getText() + + , + tf2.getText()+, + +tf3.getText()+ + ,+tf4.getText()+); sql.executeUpdate(insertStr); con.close(); catch (SQLException e1) System.out.println(e1); if(b2.equals(e.getSource()/修改 Connection con; Statement sql; ResultSet rs; tr

24、y Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); catch (ClassNotFoundException e1) System.out.println( + e1); try con = DriverManager.getConnection(jdbc:odbc:123, , ); sql = con.createStatement(); sql.executeUpdate(UPDATE K SET ts=+tf2.getText()+WHERE Kno=+tf1.getText()+); sql.executeUpdate(UPDATE K S

25、ET lb=+tf3.getText()+WHERE Kno=+tf1.getText()+); sql.executeUpdate(UPDATE K SET sj=+tf4.getText()+WHERE Kno=+tf1.getText()+); con.close(); catch (SQLException e1) System.out.println(e1); if(b3.equals(e.getSource()/删除 Connection con; Statement sql; ResultSet rs; try Class.forName(sun.jdbc.odbc.JdbcOd

26、bcDriver); catch (ClassNotFoundException e1) System.out.println( + e1); try con = DriverManager.getConnection(jdbc:odbc:123, , ); sql = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); sql.executeUpdate(DELETE FROM K WHERE Kno=+tf5.getText(); con.close(); catch (SQLEx

27、ception e1) System.out.println(e1); if(b4.equals(e.getSource()/查询全部 Connection con; Statement sql; ResultSet rs; Vector vector=new Vector(); try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); catch (ClassNotFoundException e1) System.out.println( + e1); try con = DriverManager.getConnection(jdbc:odbc:123, sa, ); sql = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); if(b4.equals(e.getSource() for(int i=0;i50;i+) for(int j=0;j4;j+) table.setValueAt(,i,j) ; rs = sql.executeQuery(SELECT * FROM K ORD