java考勤管理系統(tǒng)數(shù)據(jù)庫實現(xiàn)

1、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 ActionListenerJFrame frame=new JFrame("歡迎進入LS工資管理系統(tǒng)");JLabel label

2、=new JLabel("09網絡2_54_李勝",JLabel.CENTER);JButton button1=new JButton("進入系統(tǒng)");JButton button2=new JButton("退出系統(tǒng)");ImageIcon im=new ImageIcon("1.jpg"); JLabel a1=new JLabel(im);void Create()JPanel pcontentPane=(JPanel)frame.getContentPane();JPanel pcontentPane1=

3、new JPanel();pcontentPane.add(label);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); butto

4、n2.addActionListener(this);frame.setDefaultCloseOperation(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

5、 dl=new DL(); dl.create(); if(button2.equals(e.getSource()/退出System.exit(0); class DL implements ActionListenerJFrame frame=new JFrame("職工/管理員登陸");JLabel label1=new JLabel("用戶名");JLabel label2=new JLabel("密碼");JButton logonButton1=new JButton("管理員登錄");JButton

6、logonButton2=new JButton("職工登錄");JButton cancelButton=new JButton("退出");JTextField 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 JPassw

7、ordField(9);void create()JPanel p=(JPanel)frame.getContentPane();JPanel p1=new JPanel();p.setLayout(new 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

8、(100,20);p.setLocation(80,120);p.add(logonButton1);p.add(new JLabel(" ");p.add(logonButton2);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)

9、;logonButton2.addActionListener(this); cancelButton.addActionListener(this); frame.setDefaultCloseOperation(JFrame.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.

10、getText().equals("123")=true)&&(password.getText().equals("123")=true)GZGLZJM gz=new GZGLZJM();gz.create();elseJOptionPane.showMessageDialog(null,"對不起,你輸入的密碼錯誤!");if(logonButton2.equals(e.getSource()&&(username.getText().equals(t1.getText()=true)&&am

11、p;(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.odbc.JdbcOdbcDriver"); catch (ClassNotFoundException e1) System.out.println("" + e1);try con = DriverMan

12、ager.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="+t2.getText();catch (SQLException e1) System.

13、out.println(e1); if(cancelButton.equals(e.getSource()System.exit(0); class GZGLZJM extends JFrame implements ActionListener JFrame f=new JFrame("工資管理系統(tǒng)"); JButton b1=new JButton("津貼管理"); JButton b2=new JButton("總查詢"); JButton b3=new JButton("工資管理"); JButton b4

14、=new 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.ad

15、d(b1); p.add(new JLabel(" "); p.add(b6); p.add(new JLabel(" "); 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.addActionLi

16、stener(this); b2.addActionListener(this); b3.addActionListener(this); b4.addActionListener(this); b5.addActionListener(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.dispos

17、e(); if(b1.equals(e.getSource()/津貼管理 JTGL jt=new JTGL(); jt.create(); if(b6.equals(e.getSource()/員工個人信息管理 YGGL 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

18、gz=new GZGL(); gz.create(); class KQGL implements ActionListener JFrame f=new JFrame("錄入修改刪除考勤信息"); JButton b1=new JButton("錄入"); JButton b2=new JButton("修改"); JButton b3=new JButton("刪除"); JButton b4=new JButton("查詢所有"); JButton b5=new JButton("

19、;返回"); 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); JButton b6=new JButton("查詢單人考勤"); String cloum="職工號","缺勤天數(shù)","缺勤類別","缺勤時間&

20、quot; 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(new FlowLayout(); /p.add(scrollpane); p.add(splitpane); JP

21、anel 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(""); p.add(new JLabel("職工號"); p.add(tf1);

22、p.add(new JLabel("缺勤天數(shù)"); 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.BOTTO

23、M); splitpane.setDividerLocation(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.se

24、tVisible(true); public void 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.getConnecti

25、on("jdbc:odbc:123", "", ""); sql = con.createStatement(); String insertStr = "INSERT INTO K VALUES " + "(" + "'" + tf1.getText() + "'" + "," + tf2.getText()+"," + "'" +tf3.getText()+"

26、'" + ","+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;try Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); catch (ClassNotFoundE

27、xception 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.executeUp

28、date("UPDATE K SET 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()

29、/刪除 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.createStatement(R

30、esultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); sql.executeUpdate("DELETE FROM K WHERE Kno="+tf5.getText(); con.close(); catch (SQLException e1) System.out.println(e1); if(b4.equals(e.getSource()/查詢全部 Connection con; Statement sql; ResultSet rs; Vector vector=new Vector(); try

31、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_

32、READ_ONLY); if(b4.equals(e.getSource()for(int i=0;i<50;i+) for(int j=0;j<4;j+) table.setValueAt("",i,j); rs = sql.executeQuery("SELECT * FROM K ORDER BY Kno DESC"); int k=-1; while(rs.next() +k; String Kno = rs.getString(1); String ts = rs.getString(2); String lb = rs.getString(3); String sj = rs.getString(4); table.setValueAt(Kno,k,0); table.setValueAt(ts,k,