1、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 JFrameprotected JPanel p = new JPanel();protected JPanel p1 = new JPanel();protected JPanel p2 = new JPanel();protected JPanel p3= new

2、JPanel();JMenuBar M =new JMenuBar();JMenu m1 = new JMenu(基本信息模塊);JMenu m2 = new JMenu(考勤考評(píng)信息模塊);JMenu m3 = new JMenu(系統(tǒng)維護(hù)信息模塊);JMenuItem mm1 = new JMenuItem(員工基本信息);JMenuItem mm2 = new JMenuItem(員工家庭成員基本信息);JMenuItem mm3 = new JMenuItem(員工培訓(xùn)信息);JMenuItem mm4 = new JMenuItem(員工考勤信息);JMenuItem mm5 = n

3、ew JMenuItem(員工考評(píng)信息);JMenuItem mm6 = new JMenuItem(普通管理員);JMenuItem mm7 = new JMenuItem(高級(jí)管理員);JMenuItem mm8 = new JMenuItem(退出);protected JLabel l1 = new JLabel(員工編號(hào)：);protected JLabel l2 = new JLabel(姓 名：);protected JLabel l3 = new JLabel(性 別：);protected JLabel l4 = new JLabel(年 齡：);protected JLab

4、el l5 = new JLabel(部 門(mén)：);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(查詢(xún));private JButt

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

6、 A()super(人事管理系統(tǒng));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.setLayou

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

8、); 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(),操作錯(cuò)誤！,JOptionPane.ERROR_MESSAGE); System.exit(1); catch(Cl

9、assNotFoundException e) JOptionPane.showMessageDialog(null ,e.getMessage(),驅(qū)動(dòng)程序找不到！,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.getM

10、essage(),不能關(guān)閉！,JOptionPane.ERROR_MESSAGE); System.exit(1); ); b1.addActionListener( new ActionListener() public void actionPerformed(ActionEvent event) try r=s.executeQuery(select * from 員工基本信息表 + where 員工編號(hào)=+t1.getText()+); if(r.next() t1.setText(r.getString(1); t2.setText(r.getString(2); t3.setTex

11、t(r.getString(3); t4.setText(r.getString(4); t5.setText(r.getString(5); JOptionPane.showMessageDialog(null,查詢(xún)成功！,查詢(xún)操作,JOptionPane.ERROR_MESSAGE); else t2.setText();t3.setText();t4.setText();t5.setText(); JOptionPane.showMessageDialog(null,查詢(xún)失敗！,查詢(xún)操作,JOptionPane.ERROR_MESSAGE); catch(NumberFormatExce

12、ption 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.equa

13、ls()&(!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.ERRO

14、R_MESSAGE); catch (NumberFormatException e )System.out.println(e); catch (SQLException e)System.out.println(e); elseJOptionPane.showMessageDialog(null,插入失敗！,插入操作,JOptionPane.ERROR_MESSAGE); ); b3.addActionListener( new ActionListener() public void actionPerformed(ActionEvent event) try int r1=s.exec

15、uteUpdate(update 員工基本信息表 set 姓名=+t2.getText()+, + 性別=+t3.getText()+, + 年齡=+Integer.parseInt(t4.getText()+, + 部門(mén)=+t5.getText()+ where 員工編號(hào)=+t1.getText()+); if(r1!=0) JOptionPane.showMessageDialog(null,修改成功！,修改操作,JOptionPane.ERROR_MESSAGE); elseJOptionPane.showMessageDialog(null,修改失?。?修改操作,JOptionPane

16、.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 員工編號(hào)=+t1.getText()+); if(r1!=0) t1.setT

17、ext();t2.setText();t3.setText();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 e)System.out.p

18、rintln(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