企业人事管理系统java源代码-

1、import java.awt.* ;import java.awt.event.*;import java.sql.*;import java.util.*;import javax.swing.*;import javax.swing.border.*;public class A extends JFrameprotected JPanel p = new JPanel(;protected JPanel p1 = new JPanel(;protected JPanel p2 = new JPanel(;protected JPanel p3= new JPanel(;JMenuBar

2、 M =new JMenuBar(;JMenu m1 = new JMenu("基本信息模块"JMenu m2 = new JMenu("考勤考评信息模块"JMenu m3 = new JMenu("系统维护信息模块"JMenuItem mm1 = new JMenuItem("员工基本信息" JMenuItem mm2 = new JMenuItem("员工家庭成员基本信息" JMenuItem mm3 = new JMenuItem("员工培训信息" JMenuItem

3、mm4 = new JMenuItem("员工考勤信息" JMenuItem mm5 = new JMenuItem("员工考评信息" JMenuItem mm6 = new JMenuItem("普通管理员" JMenuItem mm7 = new JMenuItem("高级管理员" JMenuItem mm8 = new JMenuItem("退出"protected JLabel l1 = new JLabel("员工编号:"protected JLabel l2 =

4、new JLabel("姓名:"protected JLabel l3 = new JLabel("性别:"protected JLabel l4 = new JLabel("年龄:"protected JLabel l5 = new JLabel("部门:"protected JTextField t1 = new JTextField(10;protected JTextField t2 = new JTextField(10;protected JTextField t3 = new JTextField(1

5、0;protected JTextField t4 = new JTextField(10;protected JTextField t5 = new JTextField(10;private JButton b1 = new JButton("查询"private JButton b2 = new JButton("插入"private JButton b3 = new JButton("修改"private JButton b4 = new JButton("删除"private JButton b5 = n

6、ew JButton("清除"private JButton b6 = new JButton("下一条"private Connection c; / jve:decl-index=0:private Statement s; / jve:decl-index=0:private ResultSet r; / jve:decl-index=0:super("人事管理系统"getContentPane(.add(p;setJMenuBar(M;M.add(m1;M.add(m2;M.add(m3;m1.add(mm1;m1.add(m

7、m2;m1.add(mm3;m1.addSeparator(;m1.add(mm8;m2.add(mm4;m2.add(mm5;m3.add(mm6;m3.add(mm7;p.add(p1,BorderLayout.NORTH;p.add(p2,BorderLayout.CENTER;p.add(p3,BorderLayout.SOUTH;p1.setLayout(new GridLayout(5,2,1,3;p1.add(l1;p1.add(t1;p1.add(l2;p1.add(t2;p1.add(l3;p1.add(t3;p1.add(l4;p1.add(t4;p1.add(l5;p1.

8、add(t5;p2.add(b1;p1.add(b2;p2.add(b3;p1.add(b4;p2.add(b5;p3.add(b6;t1.setText(""t2.setText(""t3.setText(""t4.setText(""t5.setText(""setSize(350,300;setVisible(true;tryClass.forName("sun.jdbc.odbc.JdbcOdbcDrive"c=DriverManager.getConnection(

9、"jdbc:odbc:sd","sa",null;s=c.createStatement(;r=s.executeQuery("select * from 员工基本信息表"catch (SQLException eJOptionPane.showMessageDialog(null ,e.getMessage(,"操作错误! ",JOptionPane.ERROR_MESSAGE;System.exit(1;catch(ClassNotFoundException eJOptionPane.showMessageD

10、ialog(null ,e.getMessage(,"驱动程序找不到! ",JOptionPane.ERROR_MESSAGE;System.exit(1;addWindowListener( new WindowAdapter(public void windowClosing(WindowEvent eventtry s.close(;c.close(;catch(SQLException eJOptionPane.showMessageDialog(null,e.getMessage(,"不能关闭! ",JOptionPane.ERROR_MESS

11、AGE;System.exit(1;b1.addActionListener(new ActionListener(public void actionPerformed(ActionEvent eventtryr=s.executeQuery("select * from 员工基本信息表" + "where 员工编号='"+t1.getText(+"'"if(r.next(t1.setText(r.getString(1;t2.setText(r.getString(2;t3.setText(r.getString(

12、3;t4.setText(r.getString(4;t5.setText(r.getString(5;JOptionPane.showMessageDialog(null,"查询成功!","查询操作",JOptionPane.ERROR_MESSAGE;elset2.setText(""t3.setText(""t4.setText(""t5.setText(""JOptionPane.showMessageDialog(null,"查询失败!",&qu

13、ot;查询操作",JOptionPane.ERROR_MESSAGE;catch(NumberFormatException eSystem.out.println(e;catch(SQLException eSystem.out.println(e;b2.addActionListener(new ActionListener(public void actionPerformed(ActionEvent eventString v1,v2,v3,v4,v5;v1=t1.getText(;v2=t2.getText(;v3=t3.getText(;v4=t4.getText(;v5

14、=t5.getText(;if(!v1.equals( "" &&(!v2.equals(""&&(!v3.equals(""&&(!v4.equals(""&&(!v5.equals (""tryint n1 = Integer.parseInt(v4;int r1 = s.executeUpdate("INSERT INTO 员工基本信息表"+ "values('"+v1+&quo

15、t;','"+v2+"','"+v3+"',"+n1+",'"+v5+"'"if(r1!=0t1.setText(""t2.setText(""t3.setText(""t4.setText(""t5.setText(""JOptionPane.showMessageDialog(null,"插入成功!","插入操作&qu

16、ot;,JOptionPane.ERROR_MESSAGE;catch (NumberFormatException e System.out.println(e;catch (SQLException eSystem.out.println(e;elseJOptionPane.showMessageDialog(null,"插入失败!","插入操作",JOptionPane.ERROR_MESSAGE;b3.addActionListener(new ActionListener(public void actionPerformed(ActionEv

17、ent eventtry int r1=s.executeUpdate("update 员工基本信息表set 姓名='"+t2.getText(+"'," +"性别='"+t3.getText(+"'," +"年龄="+Integer.parseInt(t4.getText(+"," +"部门='"+t5.getText(+"'"+"where 员工编号='"+

18、t1.getText(+"'"if(r1!=0JOptionPane.showMessageDialog(null,"修改成功! ","修改操作",JOptionPane.ERROR_MESSAGE;elseJOptionPane.showMessageDialog(null,"修改失败!","修改操作",JOptionPane.ERROR_MESSAGE;catch (NumberFormatException e System.out.println(e;catch (SQLExce

19、ption eSystem.out.println(e;b4.addActionListener(new ActionListener(public void actionPerformed(ActionEvent eventtryint r1=s.executeUpdate("delete from 员工基本信息表"+"where 员工编号='"+t1.getText(+"'"if(r1!=0t1.setText(""t2.setText(""t3.setText("

20、"t4.setText(""t5.setText(""JOptionPane.showMessageDialog(null,"删除成功!","删除操作",JOptionPane.ERROR_MESSAGE;elseJOptionPane.showMessageDialog(null,"删除失败!","删除操作",JOptionPane.ERROR_MESSAGE;catch (NumberFormatException e System.out.println(e;catch (SQLException eSystem.out.println(e;b5.addActionListen