java课程设计(人事管理系统)

人事管理系统（1）系统的功能设计3（2）系统功能结构3（3）数据库设计3二.功能模块开发 (4)（1）查询人员信息界面4（2）添加员工界面5（3）修改员工信息界面5（4）删除员工界面6（5）员工考核界面7（6）员工考核历史记录界面7三.各个类说明 (8)四.程序代码 (11)（1）................................................................................................................ M anager 11（2）........................................................................................................... CardEmploy 14（3）.............................................................................................................. S elEmploy 16（4）............................................................................................................ AddEmploy 17（5）........................................................................................................ ReviseEmploy 21i UpdDialog (23)（6）............................................................................................................. DelEmploy 27（7）.............................................................................................................. AllEmploy 29（8）................................................................................................................. E xamine 30（9）................................................................................................................... H istory 34（10）...................................................................................................... EmployModel 37（11）................................................................................................... AppraisalModel 39（12）............................................................................................................. S qlHelper 42一.系统需求分析：（1）系统的功能设计i员工信息管理：员工信息管理包括对员工基本信息和情况进行查询、添加、删除和修改及部门管理ii员工考核管理：包括对员工的考核情况进行操作，还可以对历史考核情况进行浏览（2）系统功能结构人事管理的系统结构功能结构如图所示：（3）数据库设计员工基本表（Employinfo）名称字段名称数据类型主键非空Yes Yes 工号Empno varchar(10)No yes 姓名Ename varchar(10)性别Sex varchar(4)No yes出生年月Birthday Datetime No Yes部门DeptNo Char(10)No Yes员工考核表（Appraisal）考核历史记录（History）二.功能模块开发（1）查询人员信息界面实例一个SelEmploy类，当点击“查询”时调用EmployModel类的queryEmploy方法实现查询（2）添加员工界面实例一个AddEmploy类当点击“添加”时调用EmployModel类的updEmploy方法实现添加功能（3）修改员工信息界面实例一个ReviseEmploy类当点击“修改”时，先调用UpdDialo 弹跳出一个修改信息对话框，信息修改完毕后，调用EmployModel类的updEmploy方法实现修改功能（4）删除员工界面实例一个DelEmploy类当点击“删除”时调用EmployModel类的updEmploy方法实现删除功能（5）员工考核界面实例一个Examine类当点击“确认”时调用AppraisalModel 类的updAppraisal方法来完成考核功能（6）员工考核历史记录界面实例一个History类当点击时调用AppraisalModel类的updAppraisal方法来完成考核功能三.各个类说明类之间的关系图:1.Manager类Manager类的一个实例，从而生成了人事管理系统的界面,用JSplitPane 类将整个界面分为左右两个部分。

其中左侧实现了人事管理系统的功能树，采用JTree类构建，同时实现了TreeSelectionListener接口，定义了该接口所必须实现的valueChanged(TreeSelectionEvent e)方法，JSplitPane右边加入卡片布局CardEmploy类。

当JTree的TreeSelectionEvent事件发生时，调用CardEmploy的c.show方法切换不同卡片，实现不同的管理界面。

2.CardEmploy类CardEmploy为卡片布局类的面板，主要功能是添加各个界面的卡片，当JTree的TreeSelectionEvent事件发生时。

切换不同的卡片3.EmployModel、AppraisalModel类这两个类继承了AbstractTableModel，主要实现的功能是，存放调用sqlhelper 类得到的数据。

可以通过调用sqlhelper实现增删查改功能4.SqlHelpe r类主要就是连接数据库的一些基础操作是，方便代码修改，重复使用5.SelEmplo y这个类继承Panel，为“查询员工”的界面。

实现了Actionlistener 接口，当ActionEvent 事件发生时，调用EmployModel类的queryEmploy方法实现查询6.AddEmploy、ReviseEmploy、DelEmploy类这些类继承Pane，分别为“添加员工信息”“修改员工信息”“删除员工信息”的界面，这些类实现了Actionlistener 接口，当ActionEvent 事件发生时，调用EmployModel类的updEmploy方法实现添加、查询、删除、功能7.Examine类这个类继承Panel，为“考核员工”界面。

这个类实现了Actionlistener 接口，当ActionEvent 事件发生时，(1)先通过调用AppraisalModel的queryAppraisal获取上次考核成绩，(2)修改Appraisal表的考核成绩（3）再把上次考核成绩跟本次考核成绩加到History表中8.History这个类主要是把History表中的信息显示到界面上。

四.程序代码（1）Managerpackage com.Manager;import java.awt.*;import javax.swing.*;import javax.swing.event.TreeSelectionEvent;import javax.swing.event.TreeSelectionListener;import javax.swing.tree.*;import java.awt.event.*;public class Manager extends JFrame implements TreeSelectionListener { J Panel jp;J SplitPane js;J ScrollPane jsp;J Tree tree;D efaultMutableTreeNode root, t1, t2, t1_1, t1_2, t1_3, t1_4, t1_5, t2_1,t2_2;C ardEmploy ae;E mployModel em;p ublic static void main(String[] args) {Manager manager = new Manager();}p ublic Manager() {// 给树的各个结点赋值root = new DefaultMutableTreeNode("人事管理系统");t1 = new DefaultMutableTreeNode("基本信息管理");t1_1 = new DefaultMutableTreeNode("查询员工");t1_2 = new DefaultMutableTreeNode("添加员工");t1_3 = new DefaultMutableTreeNode("修改员工信息"); t1_4 = new DefaultMutableTreeNode("删除员工资料"); t1_5 = new DefaultMutableTreeNode("查询全体员工");t2 = new DefaultMutableTreeNode("人员考核管理"); t2_1 = new DefaultMutableTreeNode("人员考核");t2_2 = new DefaultMutableTreeNode("考核历史查询");t1.add(t1_1);t1.add(t1_2);t1.add(t1_3);t1.add(t1_4);t1.add(t1_5);t2.add(t2_1);t2.add(t2_2);root.add(t1);root.add(t2);tree = new JTree(root);// 对树进行监听tree.addTreeSelectionListener(this);// 实例化CardEmploy面板并加到jsplitpane的边ae = new CardEmploy();js = new JSplitPane();js.setLeftComponent(tree);js.setRightComponent(ae);this.getContentPane().add(js);this.setTitle("人事管理系统");this.setVisible(true);this.setSize(600, 500);this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);}p ublic void valueChanged(TreeSelectionEvent e) {// 获取点击结点名称DefaultMutableTreeNode dpath = (DefaultMutableTreeNode) tree .getLastSelectedPathComponent();// 通过点击不同结点切换不同界面if (dpath.equals(t1_1)) {ae.c.show(ae, "1");} else if (dpath.equals(t1_2)) {ae.c.show(ae, "2");} else if (dpath.equals(t1_3)) {ae.c.show(ae, "3");} else if (dpath.equals(t1_4)) {ae.c.show(ae, "4");} else if (dpath.equals(t1_5)) {ae.c.show(ae, "5");} else if (dpath.equals(t2_1)) {ae.c.show(ae, "6");} else if (dpath.equals(t2_2)) {ae.c.show(ae, "7");}}}（2）CardEmploy /*** 用卡片布局设置各个界面*/package com.Manager;import javax.swing.*;import java.awt.*;public class CardEmploy extends Panel{C ardLayout c;//查询表S elEmploy selE;//添加表A ddEmploy addE;//修改员工信息表ReviseEmploy revE;//删除员工表格DelEmploy delE;//所有员工信息AllEmploy allE;//员工考核表Examine exaE;//历史记录界面History His;public CardEmploy(){//查询员工表selE = new SelEmploy();//添加员工表addE = new AddEmploy();//修改员工信息revE = new ReviseEmploy();//删除员工表格delE = new DelEmploy();//所有员工信息allE =new AllEmploy();//员工考核表exaE = new Examine();//历史记录界面His = new History();JPanel jp = new JPanel();//定义cardemploy面板为卡片布局//把各个面板加入到C的卡片布局中c = new CardLayout();this.setLayout(c);this.add(selE,"1");this.add(addE,"2");this.add(revE,"3");this.add(delE,"4");this.add(allE,"5");this.add(exaE,"6");this.add(His,"7");}}（3）SelEmploy/*** SelEmploy 类设置查询员工界面*/package com.Manager;import java.awt.*;import javax.swing.*;import java.awt.event.*;public class SelEmploy extends Panel implements ActionListener { E mployModel em;J Label jl;J TextField jtf;J Button jb;J Table jt;J ScrollPane jsp;J Panel jp1;p ublic SelEmploy() {// 北部jp1 = new JPanel();jl = new JLabel("输入员工号：");jtf = new JTextField(20);jb = new JButton("查询");// 对查询按钮监听jb.addActionListener(this);jp1.add(jl);jp1.add(jtf);jp1.add(jb);// 中部em = new EmployModel();String[] paras = { "1" };em.queryEmploy("select * from Employinfo where 1 = ?", paras);jt = new JTable(em);jsp = new JScrollPane(jt);this.setLayout(new BorderLayout());this.add(jp1, BorderLayout.NORTH);this.add(jsp, BorderLayout.CENTER);}p ublic void actionPerformed(ActionEvent e) {if (e.getSource() == jb) {String name = this.jtf.getText().trim();String sql = "select * from Employinfo where Empno = ?";String[] paras = { name };em = new EmployModel();em.queryEmploy(sql, paras);// 查找成功更新表jt.setModel(em);}}}（4）AddEmploy package com.Manager;import java.awt.*;import javax.swing.*;import java.awt.event.*;public class AddEmploy extends Panel implements ActionListener { J Label jl, jl1, jl2, jl3, jl4, jl5, jl6, jl7;J Button jb1, jb2;J TextField jtf1, jtf2, jtf3, jtf4, jtf5, jtf6, jtf7;J Panel jp1, jp2, jp3, jp4;E mployModel em;p ublic AddEmploy() {jl1 = new JLabel("工号:");jl2 = new JLabel("姓名:");jl3 = new JLabel("性别:");jl4 = new JLabel("出生年月:");jl5 = new JLabel("部门:");jl6 = new JLabel("职位:");jl7 = new JLabel("工资:");jtf1 = new JTextField(20);jtf2 = new JTextField(20);jtf3 = new JTextField(20);jtf4 = new JTextField(20);jtf5 = new JTextField(20);jtf6 = new JTextField(20);jtf7 = new JTextField(20);jb1 = new JButton("添加");jb2 = new JButton("取消");// 监听‘添加’ ‘取消’按钮jb1.addActionListener(this);jb2.addActionListener(this);jp1 = new JPanel(new GridLayout(7, 1)); jp2 = new JPanel(new GridLayout(7, 1)); jp3 = new JPanel();jp1.add(jl1);jp1.add(jl2);jp1.add(jl3);jp1.add(jl4);jp1.add(jl5);jp1.add(jl6);jp1.add(jl7);jp2.add(jtf1);jp2.add(jtf2);jp2.add(jtf3);jp2.add(jtf4);jp2.add(jtf5);jp2.add(jtf6);jp2.add(jtf7);jp3.add(jb1);jp3.add(jb2);jp4 = new JPanel(new BorderLayout());jp4.add(jp1, BorderLayout.WEST);jp4.add(jp2, BorderLayout.EAST);jp4.setSize(300, 300);this.setLayout(new FlowLayout());this.add(jp4);this.add(jp3);}p ublic void actionPerformed(ActionEvent e) {if (e.getSource() == jb1) {// 调用EmployModel 里的updEmploy 方法，实现对表格的添加String sql = "insert into Employinfo values(?,?,?,?,?,?,?)";String[] paras = { jtf1.getText(), jtf2.getText(), jtf3.getText(),jtf4.getText(), jtf5.getText(), jtf6.getText(),jtf7.getText() };em = new EmployModel();if (em.updEmploy(sql, paras)) {// 当添加新员工成功时，则弹出”添加成功“的对话框JOptionPane.showMessageDialog(this, "添加成功");} else if (!em.updEmploy(sql, paras)) {JOptionPane.showMessageDialog(this, "添加失败");}// 当新员工加入成功后，要把新加入员工的工号加到考核表AppraisalModel temp = new AppraisalModel();String sql1 = "insert into Appraisal(Empno) values(?)";String[] paras1 = { jtf1.getText() };temp.updAppraisal(sql1, paras1);}else if(e.getSource() == jb2){jtf1.setText("");jtf2.setText("");jtf3.setText("");jtf4.setText("");jtf5.setText("");jtf6.setText("");jtf7.setText("");}}}（5）ReviseEmploy package com.Manager;/*** 修改员工界面*/import java.awt.*;import java.awt.event.*;import javax.swing.*;public class ReviseEmploy extends Panel implements ActionListener { J Table jt;J ScrollPane jsp;J Button jb1, jb2;J Panel jp1,jp2;E mployModel em;JLabel jl1;p ublic ReviseEmploy() {jl1 = new JLabel("修改员工信息",JLabel.CENTER);jl1.setFont(new Font("宋体", Font.BOLD, 28));jp2 = new JPanel();jp2.add(jl1);em = new EmployModel();String[] paras = { "1" };em.queryEmploy("select * from Employinfo where 1 = ?", paras);jt = new JTable(em);jsp = new JScrollPane(jt);jb1 = new JButton("修改");jb2 = new JButton("刷新");// 对两个按钮进行监听jb1.addActionListener(this);jb2.addActionListener(this);this.setLayout(new BorderLayout());jp1 = new JPanel();jp1.add(jb1);jp1.add(jb2);this.add(jp2,BorderLayout.NORTH);this.add(jsp, BorderLayout.CENTER);this.add(jp1, BorderLayout.SOUTH);}p ublic void actionPerformed(ActionEvent e) {if (e.getSource() == jb1) {int rowNum = this.jt.getSelectedRow();if (rowNum == -1) {JOptionPane.showMessageDialog(this, "请选择一行");return;}// 弹出修改对话框new UpdDialog(em, rowNum);} else if (e.getSource() == jb2) {// 刷新修改界面中的表格em = new EmployModel();String[] paras1 = { "1" };em.queryEmploy("select * from Employinfo where 1 = ?", paras1);jt.setModel(em);}}}i UpdDialogpackage com.Manager;/*** 弹出修改界面*/import javax.swing.*;import java.awt.*;import java.awt.event.*;public class UpdDialog extends JDialog implements ActionListener {J Label jl1, jl2, jl3, jl4, jl5, jl6, jl7;J Button jb1, jb2;J TextField jtf1, jtf2, jtf3, jtf4, jtf5, jtf6, jtf7;J Panel jp1, jp2, jp3;p ublic UpdDialog(EmployModel em, int rowNums) {jl1 = new JLabel("工号:");jl2 = new JLabel("姓名:");jl3 = new JLabel("性别:");jl4 = new JLabel("出生年月:");jl5 = new JLabel("部门:");jl6 = new JLabel("职位:");jl7 = new JLabel("工资:");jtf1 = new JTextField(20);jtf2 = new JTextField(30);jtf3 = new JTextField(30);jtf4 = new JTextField(30);jtf5 = new JTextField(30);jtf6 = new JTextField(30);jtf7 = new JTextField(30);// 初始化jtextfield数据jtf1.setText((String) em.getValueAt(rowNums, 0)); jtf1.setEditable(false);jtf2.setText((String) em.getValueAt(rowNums, 1)); jtf3.setText((String) em.getValueAt(rowNums, 2)); jtf4.setText((String) em.getValueAt(rowNums, 3)); jtf5.setText((String) em.getValueAt(rowNums, 4)); jtf6.setText((String) em.getValueAt(rowNums, 5)); jtf7.setText((String) em.getValueAt(rowNums, 6));jb1 = new JButton("修改");jb2 = new JButton("取消");// 对两个按钮监听jb1.addActionListener(this);jb2.addActionListener(this);jp1 = new JPanel();jp2 = new JPanel();jp3 = new JPanel();// 设置布局jp1.setLayout(new GridLayout(7, 1));jp2.setLayout(new GridLayout(7, 1));// 添加组件jp1.add(jl1);jp1.add(jl2);jp1.add(jl3);jp1.add(jl4);jp1.add(jl5);jp1.add(jl6);jp1.add(jl7);jp2.add(jtf1);jp2.add(jtf2);jp2.add(jtf3);jp2.add(jtf4);jp2.add(jtf5);jp2.add(jtf6);jp2.add(jtf7);jp3.add(jb1);jp3.add(jb2);this.add(jp1, BorderLayout.WEST);this.add(jp2, BorderLayout.CENTER);this.add(jp3, BorderLayout.SOUTH);this.setSize(300, 250);this.setVisible(true);this.setLocation(200, 200);this.addWindowListener(new WindowAdapter() { public void windowClosing(WindowEvent e) {dispose();}});}p ublic void actionPerformed(ActionEvent e) {if (e.getSource() == jb1) {// 修改员工信息的sql 语句，paras 为待注入的值String sql = "update Employinfo set "+ "Ename = ?,Sex = ?,Birthday = ?, DeptNo = ?, Ejob = ? ,Sal=? where Empno = ?";String[] paras = { jtf2.getText(), jtf3.getText(), jtf4.getText(),jtf5.getText(), jtf6.getText(), jtf7.getText(),jtf1.getText() };EmployModel temp = new EmployModel();// 如果修改语句运行成功则弹出“修改成功”对话框if (temp.updEmploy(sql, paras)) {JOptionPane.showMessageDialog(this, "修改成功");}this.dispose();} else if (e.getSource() == jb2) {// 关闭对话框this.dispose();}}}（6）DelEmploy/*** 删除员工*/package com.Manager;import javax.swing.*;import java.awt.*;import java.awt.event.*;public class DelEmploy extends Panel implements ActionListener {J Table jt;J ScrollPane jsp;J Button jb1, jb2;J Panel jp1, jp2;J Label jl1;E mployModel em;p ublic DelEmploy() {// 北部jl1 = new JLabel("删除员工", JLabel.CENTER);jl1.setFont(new Font("黑体", Font.BOLD, 30));jp2 = new JPanel();jp2.add(jl1);// 中部em = new EmployModel();String[] paras = { "1" };em.queryEmploy("select * from Employinfo where 1 = ?", paras);jt = new JTable(em);jsp = new JScrollPane(jt);// 南部jp1 = new JPanel();jb1 = new JButton("删除");jb2 = new JButton("取消");jb1.addActionListener(this);jp1.add(jb1);jp1.add(jb2);this.setLayout(new BorderLayout());this.add(jp2, BorderLayout.NORTH);this.add(jsp, BorderLayout.CENTER);this.add(jp1, BorderLayout.SOUTH);}p ublic void actionPerformed(ActionEvent e) {if (e.getSource() == jb1) {// 返回用户点中的行int rowNum = this.jt.getSelectedRow();if (rowNum == -1) {JOptionPane.showMessageDialog(this, "请选择一行");return;}// 得到学生编号String Empno = (String) em.getValueAt(rowNum, 0);// 删除记录的sql语句String sql = "delete from Employinfo where Empno = ?";String[] paras = { Empno };EmployModel temp = new EmployModel();temp.updEmploy(sql, paras);// 删除员工成功后，更新员工表em = new EmployModel();String[] paras1 = { "1" };em.queryEmploy("select * from Employinfo where 1 = ?", paras1);jt.setModel(em);}}}（7）AllEmploy/*** 遍历所有员工*/package com.Manager;import java.awt.*;import javax.swing.*;public class AllEmploy extends Panel{E mployModel em;J Table jt;J ScrollPane jsp;JLabel jl1;JPanel jp;p ublic AllEmploy(){//北部jp = new JPanel();jl1 = new JLabel("全体员工",JLabel.CENTER);jl1.setFont(new Font("黑体", Font.BOLD, 30));jp.add(jl1);//中部em = new EmployModel();String []paras ={"1"};em.queryEmploy("select * from Employinfo where 1 = ?", paras);jt = new JTable(em);jsp = new JScrollPane(jt);this.setLayout(new BorderLayout());this.add(jp,BorderLayout.NORTH);this.add(jsp,BorderLayout.CENTER);}}（8）Examine/*** 员工考核界面*/package com.Manager;import java.awt.*;import java.awt.event.*;import java.sql.ResultSet;import java.util.Vector;import java.sql.*;import javax.swing.*;public class Examine extends Panel implements ActionListener {J Label jl1, jl2, jl3, jl4;J Table jt;J ScrollPane jsp;J TextField jtf1, jtf2;C hoice ch;J Button jb1, jb2;J Panel jp1, jp2, jp3, jp4;A ppraisalModel am;S qlHelper sqh;p ublic Examine() {// 北部为标题文字jp4 = new JPanel();jl1 = new JLabel("员工考核", JLabel.CENTER);jl1.setFont(new Font("黑体", Font.BOLD, 30));jp4.add(jl1);// 中部am = new AppraisalModel();am.queryAppraisal("select E.Empno,E.Ename,A.Consequence,A.RegDate from "+ "Employinfo as E,Appraisal as A where E.Empno=A.Empno");jt = new JTable(am);jsp = new JScrollPane(jt);// 监听jtable 点击表格时获取点击的行数并通过鼠标点击事件给jtf1，jtf2 赋值jt.addMouseListener(new MouseAdapter() {public void mouseClicked(MouseEvent e) {int rowNum = jt.getSelectedRow();jtf1.setText((String) am.getValueAt(rowNum, 0));jtf2.setText((String) am.getValueAt(rowNum, 1));}});jl2 = new JLabel("工号：");jl3 = new JLabel("姓名：");jl4 = new JLabel("考核");jtf1 = new JTextField(10);jtf2 = new JTextField(10);jtf1.setEditable(false);jtf2.setEditable(false);// 实例单选框组件，并赋值ch = new Choice();ch.add("未考核");ch.add("不合格");ch.add("合格");ch.add("优秀");jp1 = new JPanel();jp1.add(jl2);jp1.add(jtf1);jp1.add(jl3);jp1.add(jtf2);jp1.add(jl4);jp1.add(ch);jp2 = new JPanel(new BorderLayout()); jp2.add(jsp, BorderLayout.CENTER);jp2.add(jp1, BorderLayout.SOUTH);// 南部jb1 = new JButton("确认");jb2 = new JButton("刷新");jp3 = new JPanel();jb1.addActionListener(this);jb2.addActionListener(this);jp3.add(jb1);jp3.add(jb2);this.setLayout(new BorderLayout());this.add(jp4, BorderLayout.NORTH);this.add(jp2, BorderLayout.CENTER);this.add(jp3, BorderLayout.SOUTH);}p ublic void actionPerformed(ActionEvent e) {if (e.getSource() == jb1) {String Empno = jtf1.getText();String Ename = jtf2.getText();String Consequence = ch.getSelectedItem();// 先获取上次考核记录String sql = "select Consequence from Appraisal where Empno =?";String[] paras = { Empno };String OldInfo = "";try {sqh = new SqlHelper();ResultSet rs = sqh.queryExecute(sql, paras);rs.next();OldInfo = rs.getString(1);} catch (Exception e1) {e1.printStackTrace();} finally {sqh.close();}// 对考核表进行修改修改考核记录的sql语句String sql1 = "update Appraisal set Consequence = ? where Empno =?";String[] paras1 = { Consequence, Empno };AppraisalModel temp = new AppraisalModel();if (temp.updAppraisal(sql1, paras1)) {JOptionPane.showMessageDialog(this, "考核成功");}// 再把"上次考核记录"以及"本次操作记录" 插入到history表中String sql2 = "insert into History(Empno,Ename,OldInfo,NewInfo) values(?,?,?,?)";String[] paras2 = { Empno, Ename, OldInfo, Consequence };AppraisalModel temp1 = new AppraisalModel();temp1.updAppraisal(sql2, paras2);} else if (e.getSource() == jb2) {// 刷新员工考核表am = new AppraisalModel();String[] paras3 = { "1" };am.queryAppraisal("select E.Empno,E.Ename,A.Consequence,A.RegDate from "+ "Employinfo as E,Appraisal as A where E.Empno=A.Empno");this.jt.setModel(am);}}}（9）History/*** 历史记录界面*/package com.Manager;import java.awt.*;import java.awt.event.*;import javax.swing.*;public class History extends Panel implements ActionListener {A ppraisalModel am;J Table jt;J ScrollPane jsp;J Label jl1;J Panel jp, jp1, jp2;J Button jb1, jb2;p ublic History() {// 北部jp = new JPanel();jl1 = new JLabel("员工考核历史记录", JLabel.CENTER);jl1.setFont(new Font("黑体", Font.BOLD, 30));jp.add(jl1);// 中部am = new AppraisalModel();String[] paras = { "1" };am.queryHistory("select * from History where 1 = ?", paras);jt = new JTable(am);jsp = new JScrollPane(jt);// 南部jp2 = new JPanel();jb1 = new JButton("清空");jb2 = new JButton("刷新");jb1.addActionListener(this);jb2.addActionListener(this);jp2.add(jb1);jp2.add(jb2);this.setLayout(new BorderLayout());this.add(jp, BorderLayout.NORTH);this.add(jsp, BorderLayout.CENTER);this.add(jp2, BorderLayout.SOUTH);}p ublic void actionPerformed(ActionEvent e) {if (e.getSource() == jb1) {// 删除历史记录并更新表am = new AppraisalModel();String[] paras = { "1" };am.updAppraisal("delete History where 1 = ?", paras);am.queryHistory("select * from History where 1 = ?", paras);this.jt.setModel(am);} else if (e.getSource() == jb2) {// 刷新表格am = new AppraisalModel();String[] paras = { "1" };am.queryHistory("select * from History where 1 = ?", paras);this.jt.setModel(am);}}}（10）E mployModel /*** 重写TableModel*/package com.Manager;import javax.swing.table.*;import java.sql.*;import java.util.*;public class EmployModel extends AbstractTableModel{V ector rowData,columnNames;//实现查询p ublic void queryEmploy(String sql,String []paras){SqlHelper sqh = null;//用columnNames 存放表的列名columnNames = new Vector();columnNames.add("工号");columnNames.add("姓名");columnNames.add("性别");columnNames.add("出生年月");columnNames.add("部门");columnNames.add("职位");columnNames.add("工资");//rowData 存放表格的各行数据rowData = new Vector();try {sqh = new SqlHelper();ResultSet rs = sqh.queryExecute(sql, paras);while(rs.next()){Vector hang = new Vector();hang.add(rs.getString(1));hang.add(rs.getString(2));hang.add(rs.getString(3));hang.add(rs.getString(4));hang.add(rs.getString(5));hang.add(rs.getString(6));hang.add(rs.getString(7));rowData.add(hang);}} catch (Exception e) {e.printStackTrace();}finally{sqh.close();}}//实现表格增修改功能p ublic boolean updEmploy(String sql,String []paras) {SqlHelper sqh = new SqlHelper();return sqh.updExecute(sql, paras);}p ublic int getRowCount() {return this.rowData.size();}p ublic String getColumnName(int column) {return (String)this.columnNames.get(column);}p ublic int getColumnCount() {return this.columnNames.size();}p ublic Object getValueAt(int row, int column) {//获得某一个单元格的数值return ((Vector)this.rowData.get(row)).get(column);}}（11）A ppraisalModel /*** 重写TableModel 为考核类的table模板*/package com.Manager;import javax.swing.table.*;import java.sql.*;import java.util.*;public class AppraisalModel extends AbstractTableModel {V ector rowData, columnNames;// 实现查询p ublic void queryAppraisal(String sql) {SqlHelper sqh = null;// 用columnNames 存放表的列名columnNames = new Vector();columnNames.add("工号");columnNames.add("姓名");columnNames.add("上次考核");columnNames.add("考核时间");// rowData 存放表格的各行数据rowData = new Vector();try {sqh = new SqlHelper();ResultSet rs = sqh.queryExecute(sql);while (rs.next()) {Vector hang = new Vector();hang.add(rs.getString(1));hang.add(rs.getString(2));hang.add(rs.getString(3));hang.add(rs.getString(4));rowData.add(hang);}} catch (Exception e) {e.printStackTrace();} finally {sqh.close();}}// 查询员工考核历史记录方法p ublic void queryHistory(String sql, String[] paras) {SqlHelper sqh = null;// 用columnNames 存放表的列名columnNames = new Vector(); columnNames.add("流水号"); columnNames.add("工号"); columnNames.add("姓名"); columnNames.add("上次考核"); columnNames.add("本次考核"); columnNames.add("更改时间");// rowData 存放表格的各行数据rowData = new Vector();try {sqh = new SqlHelper();ResultSet rs = sqh.queryExecute(sql, paras);while (rs.next()) {Vector hang = new Vector();hang.add(rs.getString(1));hang.add(rs.getString(2));hang.add(rs.getString(3));hang.add(rs.getString(4));hang.add(rs.getString(5));hang.add(rs.getString(6));rowData.add(hang);}} catch (Exception e) {e.printStackTrace();} finally {sqh.close();}}// 实现表格增修改功能p ublic boolean updAppraisal(String sql, String[] paras) {SqlHelper sqh = new SqlHelper();return sqh.updExecute(sql, paras);}p ublic int getRowCount() {return this.rowData.size();}p ublic String getColumnName(int column) {return (String) this.columnNames.get(column);}p ublic int getColumnCount() {return this.columnNames.size();}p ublic Object getValueAt(int row, int column) {// 获得某一个单元格的数值return ((Vector) this.rowData.get(row)).get(column);}}（12）S qlHelper /*** 后台通过调用SqlHelper实现对sql数据库的各个操作*/package com.Manager;import java.sql.*;public class SqlHelper {C onnection ct = null;PreparedStatement ps = null;R esultSet rs = null;S tring driver = "sun.jdbc.odbc.JdbcOdbcDriver";S tring url = "jdbc:odbc:Manager";// 查询数据库操作p ublic ResultSet queryExecute(String sql, String[] paras) { try {Class.forName(driver);ct = DriverManager.getConnection(url);ps = ct.prepareStatement(sql);for (int i = 0; i < paras.length; i++) {ps.setString(i + 1, paras[i]);}rs = ps.executeQuery();} catch (Exception e) {e.printStackTrace();}return rs;}//没注入式查询数据库操作p ublic ResultSet queryExecute(String sql) {try {Class.forName(driver);ct = DriverManager.getConnection(url);ps = ct.prepareStatement(sql);。