人事管理系统代码

package rsgl; import java.awt.* import java.awt.event.*; import java.sql.*; import java.util.*; import javax.swing.*; import javax.swing.border.*; public class A extends JFrame { protected JPanel p = new JPanel(); protected JPanel p1 = new JPanel(); protected JPanel p2 = new JPanel(); protected JPanel p3= new JPanel(); JMenuBar 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 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 = 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(10); 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 = new 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:

public A() { super("人事管理系统"); getContentPane().add(p); setJMenuBar(M);M.add(m1);M.add(m2);M.add(m3);m1.add(mm1);

m1.add(mm2);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.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);

try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDrive"); c=DriverManager.getConnection("jdbc:odbc:sd","sa",null); s=c.createStatement(); r=s.executeQuery("select * from 员工基本信息表"); } catch (SQLException e){ JOptionPane.showMessageDialog(null ,e.getMessage(),"操作错误！",JOptionPane.ERROR_MESSAGE); System.exit(1); } catch(ClassNotFoundException e) { JOptionPane.showMessageDialog(null ,e.getMessage(),"驱动程序找不到！",JOptionPane.ERROR_MESSAGE); System.exit(1); } addWindowListener( new WindowAdapter(){ public void windowClosing(WindowEvent event) { try { s.close();c.close();

} catch(SQLException e) { JOptionPane.showMessageDialog(null,e.getMessage(),"不能关闭！",JOptionPane.ERROR_MESSAGE); System.exit(1); } } }); b1.addActionListener( new ActionListener(){ public void actionPerformed(ActionEvent event) { try{ r=s.executeQuery("select *

from 员工基本信息表" + "where 员工编号='"+t1.getText()+"'"); if(r.next()) { t1.setText(r.getString(1)); t2.setText(r.getString(2)); t3.setText(r.getString(3)); t4.setText(r.getString(4)); t5.setText(r.getString(5)); JOptionPane.showMessageDialog(null,"查询成功！","查询操作",JOptionPane.ERROR_MESSAGE); } else{ t2.setText("");t3.setText("");t4.setText("");t5.setText(""); JOptionPane.showMessageDialog(null,"查询失败！","查询操作",JOptionPane.ERROR_MESSAGE); } } catch(NumberFormatException e){ System.out.println(e); } catch(SQLException e){ System.out.println(e); } }

} ); b2.addActionListener( new ActionListener(){ public void actionPerformed(ActionEvent event) { String v1,v2,v3,v4,v5; v1=t1.getText();v2=t2.getText();v3=t3.getText();v4=t4.getText();v5=t5.getText();

if((!v1.equals( "" ))&&(!v2.equals(""))&&(!v3.equals(""))&&(!v4.equals(""))&&(!v5.equals(""))) { try{ int n1 = Integer.parseInt(v4); int r1 = s.executeUpdate("INSERT INTO 员工基本信息表"+ "values('"+v1+"','"+v2+"','"+v3+"',"+n1+",'"+v5+"')");

if(r1!=0){ t1.setText("");t2.setText("");t3.setText("");t4.setText( "");t5.setText(""); JOptionPane.showMessageDialog(null,"插入成功！","插入操作",JOptionPane.ERROR_MESSAGE); } } catch (NumberFormatException e ){System.out.println(e);} catch (SQLException e){System.out.println(e);}} else{JOptionPane.showMessageDialog(null,"插入失败！","插入操作",JOptionPane.ERROR_MESSAGE); } } } ); b3.addActionListener( new ActionListener(){ public void actionPerformed(ActionEvent event) { try { int r1=s.executeUpdate("update 员工基本信息表set 姓名='"+t2.getText()+"'," + "性别='"+t3.getText()+"'," + "年龄="+Integer.parseInt(t4.getText())+"," + "部门='"+t5.getText()+"'"+

"where 员工编号='"+t1.getText()+"'"); if(r1!=0){ JOptionPane.showMessageDial og(null,"修改成功！","修改操作",JOptionPane.ERROR_MESSAGE); } else{JOptionPane.showMessageDialog(null,"修改失败！","修改操作",JOptionPane.ERROR_MESSAGE);}} catch (NumberFormatException e ){System.out.println(e);} catch (SQLException e){System.out.println(e);}}}); b4.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent event) { try{ int r1=s.executeUpdate("delete from 员工基本信息表"+"where 员工编号='"+t1.getText()+"'"); if(r1!=0){ t1.setText("");t2.setText("");t3.setText("");t4.setText("");t5.setText (""); JOptionPane.showMessageDialog(null,"删除成功！","删除操作",JOptionPane.ERROR_MESSAGE); } else{JOptionPane.showMessageDialog(null,"删除失败！","删除操作

",JOptionPane.ERROR_MESSAGE);}} catch (NumberFormatException e ){System.out.println(e);} catch (SQLException e){System.out.println(e);} } } ); b5.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent event) { t1.setText("");t2.setText("");t3.setText("");t4.setText("");t5.setText("");

}

} ); b6.addActionListener(new ActionListener(){ public void actionPerformed(ActionEvent event) { try{ if(r.next()) t1.setText(r.getString(1));t2.setText(r.getString(2));

t3.setText(r.getString(3));t4.setText(""+r.getInt(4));

t5.setText(r.getString(5)); } catch (NumberFormatException e ){System.out.println(e);} catch (SQLException e){System.out.println(e);} } } ); mm8.addActionListener( new ActionListener(){ public void actionPerformed(ActionEvent event) { System.exit(0); } });

} public static void main(String args[]){ new A(); } }