java課程設計匯本(人事管理系統(tǒng))

1、人事管理系統(tǒng)一 系統(tǒng)需求分析：21系統(tǒng)的功能設計 22系統(tǒng)功能構造23數(shù)據(jù)庫設計3二功能模塊開發(fā)41查詢?nèi)藛T信息界面 42添加員工界面53修改員工信息界面 54刪除員工界面65員工考核界面76員工考核歷史記錄界面7三各個類說明8四.程序代碼111Manager112CardEmploy153SelEmploy184AddEmploy215ReviseEmploy26iUpdDialog296DelEmploy357AllEmploy388Examine409History4610EmployModel4911AppraisalModel5312SqlHelper58.系統(tǒng)需求分析：(1 )系統(tǒng)

2、的功能設計i員工信息管理：員工信息管理包括對員工根本信息和情況進展查詢、添加、刪除和修改及部門管理ii員工考核管理：包括對員工的考核情況進展操作，還可以對歷史考核情況進展瀏覽(2)系統(tǒng)功能構造人事管理的系統(tǒng)構造功能構造如下圖：46 / 62員4員P刪員F吊核p考核歷史查詢(3)數(shù)據(jù)庫設計員工根本表Employinfo名稱字段名稱數(shù)據(jù)類型主鍵非空工號Emp novarchar(10)YesYesEn amevarchar(10)Noyes性別Sexvarchar(4)Noyes出生年月BirthdayDatetimeNoYes部門DeptNoChar(10)NoYes職務EjobChar(20)

3、NoYes工資SalfloatNoYes員工考核表Appraisal名稱字段名稱數(shù)據(jù)類型主鍵非空工號Emp novarchar(10)yesyes考核Consequeneevarchar(10)noyes變更日期RegDatedatetimeNoYes考核歷史記錄History名稱字段名稱數(shù)據(jù)類型主鍵非空流水號JourNoIntYesyes工號Emp novarchar(10)noyesEn amevarchar(10)NoYes上次考核Oldl nfovarchar(10)NoYes本次考核Newl nfovarchar(10)NoYes變更日期RegDatedatetimeNoYes二.

4、功能模塊開發(fā)(1)查詢?nèi)藛T信息界面實例一個SelEmploy類，當點擊“查詢時調(diào)用EmployModel 類的queryEmploy 方法實現(xiàn)查詢(2)添加員工界面實例一個AddEmploy 類當點擊“添加時調(diào)用 EmployModel 類 的updEmploy方法實現(xiàn)添加功能(3) 修改員工信息界面亍口茫豐節(jié)豈婪總二-jte«ns 工n陽悴吊二乍修改員匸信息工號8出生年月nun職（Z工L00119'9b06-.主杜35D10匚冋區(qū)至沁體占 C-口/ K考國H詡實例一個ReviseEmploy類當點擊“修改時，先調(diào)用 UpdDialo 彈跳出一個修改信息對話框，信息修改完畢后

5、，調(diào)用EmployModel 類的updEmploy 方法實現(xiàn)修改功能（4）刪除員工界面實例一個DelEmploy 類當點擊“刪除時調(diào)用 EmployModel類的updEmploy方法實現(xiàn)刪除功能(5) 員工考核界面實例一個Examine類當點擊“確認時調(diào)用 AppraisalModel 類 的updAppraisal方法來完成考核功能(6) 員工考核歷史記錄界面口叵區(qū)話空P人爭曽丑爭折總靈工: 丁還也口工: 冷艇區(qū)曲:J TI即員工主QaiWtf' ? 口人帀韋琨言圧'心那類的員工考核歷史記錄實例一個 History 類 當點擊時調(diào)用 AppraisalModel updA

6、ppraisal方法來完成考核功能三. 各個類說明類之間的關系圖1. Manager 類Manager類的一個實例，從而生成了人事管理系統(tǒng)的界面，用JSplitPane 類將整個界面分為左右兩個局部。其中左側實現(xiàn)了人事管理系統(tǒng)的功能樹，采用JTree類構建，同時實現(xiàn)了 TreeSelectionListener 接口，定義了該接 口所必須實現(xiàn)的 valueChanged(TreeSelectionEvent e)方法，JSplitPane右邊參加卡片布局CardEmploy 類。當JTree的TreeSelectionEvent 事件 發(fā)生時，調(diào)用CardEmploy的c.show方法切換不同

7、卡片，實現(xiàn)不同的管理界面。2. CardEmploy 類CardEmploy 為卡片布局類的面板，主要功能是添加各個界面的卡片，當JTree的TreeSelectionEvent 事件發(fā)生時。切換不同的卡片3. EmployModel、AppraisalModel 類這兩個類繼承了AbstractTableModel ，主要實現(xiàn)的功能是，存放調(diào)用sqlhelper類得到的數(shù)據(jù)?？梢酝ㄟ^調(diào)用 sqlhelper實現(xiàn)增刪查改功能4. SqlHelper 類主要就是連接數(shù)據(jù)庫的一些根底操作 是，方便代碼修改，重復使用5. SelEmploy這個類繼承Panel，為“查詢員工"的界面。實現(xiàn)了

8、 Actionlistener 接 口，當ActionEvent 事件發(fā)生時，調(diào)用 EmployModel 類的 queryEmploy 方法實現(xiàn)查詢6. AddEmploy、ReviseEmploy DelEmploy 類這些類繼承Pane,分別為“添加員工信息“修改員工信息“刪除員工信息"的界面，這些類實現(xiàn)了 Actionlistener 接口，當ActionEvent 事件發(fā)生時，調(diào)用EmployModel類的updEmploy 方法實現(xiàn)添 力口、查詢、刪除、功能7. Examine類這個類繼承Panel，為“考核員工"界面。這個類實現(xiàn)了 Actionlistener

9、接口，當ActionEvent事件發(fā)生時，（1）先通過調(diào)用 AppraisalModel的queryAppraisal 獲取上次考核成績，（2）修改Appraisal表的考核成績3丨再把上次考核成績跟本次考核成績加到History表中8. History這個類主要是把History表中的信息顯示到界面上四. 程序代碼(1) Managerpackage .Ma nager;import ;import javax.sw in g.*;import javax.swi ng.eve nt.TreeSelectio nEve nt;import javax.swi ng.eve nt.TreeSe

10、lectio nListe ner;import TreeSelectio nListe ner publicclass Manager extends JFrame implementsJPanel jp;JSplitPane js;JScrollPane jsp ;JTree tree ;DefaultMutableTreeNoderoot , t1 , t2 , t1_1 , t1_2 , t1_3 , t1_4 , t1_5 , t2_1 , t2_2;CardEmploy ae;EmployModel em ;publicstaticvoid main( Stri ng args)

11、Manager manager =new Manager();public Man ager() 人事管理系統(tǒng)“);"根本信息管理");/給樹的各個結點賦值 root = new DefaultMutableTreeNode( t1 = new DefaultMutableTreeNode(t1_1 = newDefaultMutableTreeNode("查詢員工");t1_2 = newDefaultMutableTreeNode("添加員工");t1_3 = newDefaultMutableTreeNode("修改員

12、工信息"t1_4 = newDefaultMutableTreeNode("刪除員工資料“)t1_5 = newDefaultMutableTreeNode("查詢?nèi)w員工“););t2 = new DefaultMutableTreeNode("人員考核管理“)；t2_1 = new DefaultMutableTreeNode("人員考核");t2_2 = new DefaultMutableTreeNode("考核歷史查詢“);t1 .add( t1_1 );t1 .add( t1_2 );t1 .add( t1_3

13、);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 );/對樹進展監(jiān)聽tree .addTreeSelectionListener(this );/實例化CardEmploy 面板并加到jsplitpane 的邊ae = new CardEmploy();js = new JSplitPane();js.setLeftponent( tree );js.setRightp onent( ae);this .get

14、ContentPane().add(js);this .setTitle("人事管理系統(tǒng)");this .setVisible( true );this .setSize(600, 500);this .setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);publicvoidvalueCha nged(TreeSelecti on Eve nt e) /獲取點擊結點名稱treeDefaultMutableTreeNode dpath = (DefaultMutableTreeNode).getLastSelectedPathp on

15、en t();/通過點擊不同結點切換不同界面if (dpath.equals( t1_1 ) elseif (dpath.equals( t1_2 ) elseif (dpath.equals( t1_3 ) elseif (dpath.equals( t1_5 ) elseif (dpath.equals( t2_1 ) elseif (dpath.equals( t2_2 ) (2) CardEmploy/*用卡片布局設置各個界面*/ package .Ma nager;importjavax.swi ng.*;importjava.awt.*;publicclass CardEmploy

16、 exte nds Pan elCardLayout c;/查詢表SelEmploy selE;/添加表AddEmploy addE ;/修改員工信息表ReviseEmploy revE;/刪除員工表格DelEmploy delE ;/所有員工信息AllEmploy allE;/員工考核表Examine exaE ;/歷史記錄界面History His;public CardEmploy()/查詢員工表 selE = new SelEmploy();/添加員工表addE = new AddEmploy();/修改員工信息revE = new ReviseEmploy();/刪除員工表格delE

17、 = new DelEmploy();/所有員工信息allE = new AllEmploy();/員工考核表exaE = new Exam in e();/歷史記錄界面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&quo

18、t;);this .add( delE ,"4");this .add( allE ,"5");this .add( exaE ,"6");this .add( His ,"7");(3) SelEmploy/* SelEmploy 類設置查詢員工界面*/package.Ma nager;import javax.swi ng.*;Acti on Liste ner publicclass SelEmploy extendsPanel implementsEmployModel em ;JLabel jl;JTex

19、tField jtf;utt on ;JTable jt;JScrollPane jsp ;JPanel jp1 ;public SelEmploy() /北部jp1 = new JPanel();jl = new JLabel("輸入員工號：");jtf = new JTextField(20);=new utton("查詢");/對查詢按鈕監(jiān)聽.addActionListener(this );jp1 .add( jl);jp1 .add( jtf);jp1 .add();/中部em = new EmployModel();Str in g para

20、s = "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);publicvoidacti on Performed(Acti on Eve nt e

21、) if (e.getSource() = ) String name =this .jtf .getText().trim();Stri ng sql = "select * from Employi nfo where Emp no = ?"Stri ng paras = n ame ;em = new EmployModel();em .queryEmploy(sql, paras);/查找成功更新表jt.setModel( em);(4) AddEmploypackage .Ma nager;import javax.swi ng.*;Acti on Liste n

22、er publicclass AddEmployextendsPanel implementsJLabel jl, jl1 , jl2 , jl3 , jl4 , jl5 , jl6 , jl7 ;utton 1, 2;JTextField jtf1 , jtf2 , jtf3 , jtf4 , jtf5 , jtf6 , jtf7 ;JPanel jp1 , jp2 , jp3 , jp4 ;EmployModel em ;public AddEmploy() jl1 = new JLabel("工號:");jl2 = new JLabel(":");

23、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 JTextFie

24、ld(20); jtf6 = new JTextField(20); jtf7 = new JTextField(20);1 = new utton("添加”);2 = new utton("取消");/監(jiān)聽添加取消按鈕1. addActionListener(this );2. addActionListener(this );jp1 = new JPanel( new GridLayout(7, 1); jp2 = new JPanel( new GridLayout(7, 1); jp3 = new JPanel();jp1 .add( jl1 );jp1

25、.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( 1);jp3 .add( 2);jp4 = new JPanel( new BorderLayout();jp4 .add( jp1 , BorderLayout.WES

26、T);jp4 .add( jp2 , BorderLayout.EAST);jp4 .setSize(300, 300);this .setLayout( new FlowLayout();this .add( jp4 );this .add( jp3 );publicvoidacti on Performed(Acti on Eve nt e) if (e.getSource() =1) /調(diào)用EmployModel 里的updEmploy方法，實現(xiàn)對表格的添加String sql ="insert into Employinfo values(?,?,?,?,?,?,?)&quo

27、t;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 ,"添加成功")； elseif (! em .updEmploy(sql

28、, paras) JOptionPane. showMessageDialog (this ,"添加失敗");/當新員工參加成功后，要把新參加員工的工號加到考核表AppraisalModel temp = new AppraisalModel();String sqll ="in sert into Appraisal(Emp no) values(?)"String parasl = jtfl .getText() ; temp.updAppraisal(sql1, parasl);else if (e.getSource() = 2)jtfl .se

29、tText("");jtf2 .setText("");jtf3 .setText("");jtf4 .setText("");jtf5 .setText("");jtf6 .setText("");jtf7 .setText("");(5) ReviseEmploypackage .Ma nager;/*修改員工界面*/importjava.awt.*;importjava.awt.eve nt.*import javax.sw in g.*;publi

30、cclass ReviseEmploy exte ndsPanel implementsActi on Liste ner JTable jt;JScrollPane jsp ;utton 1, 2;JPanel jp1 ,jp2 ;EmployModel em ;JLabel jl1 ;public ReviseEmploy() jl1 = new JLabel("修改員工信息",JLabel. CENTER);jl1 .setFo nt( new Fo nt("宋體", Font. BOLD, 28);jp2 = new JPanel();jp2 .

31、add( jl1 );em = new EmployModel();Str in g paras = "1" ;,paras);em .queryEmploy( "select * from Employinfo where 1 = ?" jt = new JTable( em);jsp = new JScrollPane( jt);1 = new utton("修改");2 = new utton("刷新");/對兩個按鈕進展監(jiān)聽1 .addActionListener(this );2.addActionLis

32、tener(this );this .setLayout( new BorderLayout();jp1 = new JPanel();jp1 .add( 1);jp1 .add( 2);this .add( jp2 ,BorderLayout. NORTH );this .add( jsp , BorderLayout.CENTER);this .add( jp1 , BorderLayout. SOUTH );publicvoidacti on Performed(Acti on Eve nt e) if (e.getSource() =1) int rowNum = this .jt .

33、getSelectedRow();if (rowNum = -1) JOptionPane. showMessageDialog (this ,"請選擇一行");return ;/彈出修改對話框 new UpdDialog( em , rowNum); elseif (e.getSource() =2) /刷新修改界面中的表格em = new EmployModel();String paras1 = "1" ;,parasl);em .queryEmploy( "select * from Employinfo where 1 = ?&quo

34、t; jt.setModel( em);i UpdDialogpackage .Ma nager;/*彈出修改界面*/import javax.swi ng.*;Acti on Liste ner publicclass UpdDialog exte nds JDialogimpleme ntsJLabel jl1 , jl2 , jl3 , jl4 , jl5 , jl6 , jl7 ;utton 1, 2;JTextField jtf1 , jtf2 , jtf3 , jtf4 , jtf5 , jtf6 , jtf7 ;JPanel jp1 , jp2 , jp3 ;int rowNum

35、s) public UpdDialog(EmployModel em, 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

36、= newJTextField(30);jtf3 = newJTextField(30);jtf4 = newJTextField(30);jtf5 = newJTextField(30);jtf6 = new JTextField(30);jtf7 = new JTextField(30);/初始化jtextfield 數(shù)據(jù)jtfl .setText(String) em.getValueAt(rowNums, 0);jtfl .setEditable( false );jtf2 .setText(String) em.getValueAt(rowNums, 1);jtf3 .setText

37、(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);1 = new utton("修改");2 = new utton("取消");/對兩個按鈕監(jiān)聽1 .ad

38、dActionListener(this );2.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);jp

39、2 .add( jtf1 );jp2 .add( jtf2 );jp2 .add( jtf3 );jp2 .add( jtf4 );jp2 .add( jtf5 );jp2 .add( jtf6 );jp2 .add( jtf7 );jp3 .add( 1);jp3 .add( 2);this.add( jp1 , BorderLayout.WEST);this.add( jp2 , BorderLayout.CENTER);this.add( jp3 , BorderLayout.SOUTH);this .setSize(300, 250);this .setVisible( true );

40、this .setLocation(200, 200);this .addWindowListener(new WindowAdapter() publicvoidwi ndowClosi ng(Wi ndowEve nt e) dispose(););publicvoidacti on Performed(Acti on Eve nt e) if (e.getSource() =1) /修改員工信息的 sql語句，paras為待注入的值String sql = "update Emplo yinfo set "+ "En ame = ?,Sex = ?,Birt

41、hday = ?, DeptNo = ?, Ejob = ? ,Sal=? where Emp no = ?"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.

42、 showMessageDialog (this ,"修改成功");this .dispose(); elseif (e.getSource() =2) /關閉對話框this .dispose();(6) DelEmploy/*刪除員工*/package .Ma nager;import javax.swi ng.*;Acti on Liste ner publicclass DelEmploy exte nds Panel impleme ntsJTable jt;JScrollPane jsp ;utton 1, 2;JPanel jp1 , jp2 ;JLabel j

43、l1 ;EmployModel em ;public DelEmploy。/北部 jl1 = new JLabel("刪除員工", JLabel. CENTER);jl1 .setFo nt( new Fo nt("黑體", Font. BOLD, 30);jp2 = new JPanel();jp2 .add( jl1 );/中部em = new EmployModel();Str in g paras = "1" ;,paras);em .queryEmploy( "select * from Employinfo wh

44、ere 1 = ?"jt = new JTable( em);jsp = new JScrollPane( jt);/南部jp1 = new JPanel();1 = new utton("刪除");2 = new utton("取消");1 .addActionListener(this );jp1 .add( 1);jp1 .add( 2);this .setLayout( new BorderLayout();this .add( jp2 , BorderLayout. NORTH );this .add( jsp , BorderLay

45、out.CENTER);this .add( jp1 , BorderLayout. SOUTH );publicvoidacti on Performed(Acti on Eve nt e) if (e.getSource() =1) /返回用戶點中的行int rowNum = this .jt .getSelectedRow();if (rowNum = -1) JOptionPane. showMessageDialog (this ,"請選擇一行"); return ;/得到學生編號String Empno = (String)em .getValueAt(rowN

46、um, 0);/刪除記錄的sql語句Stri ng sql = "delete from Employi nfo where Emp no = ?"Stri ng paras = Emp no ;EmployModel temp = new EmployModel();temp.updEmploy(sql, paras);/刪除員工成功后，更新員工表em = new EmployModel();String parasl = "1" ;,parasl);em .queryEmploy( "select * from Employinfo whe

47、re 1 = ?" jt .setModel( em);/*(7) AllEmploy遍歷所有員工*/ package .Ma nager;import javax.sw in g.*;publicclass AllEmploy exte ndsPan elEmployModel em ;JTable jt;JScrollPane jsp ;JLabel jl1 ;JPanel jp ;public AllEmploy()/北部jp = new JPanel();jl1 = new JLabel("全體員工",JLabel. CENTER);jl1 .setFo

48、nt( new Fo nt("黑體", Font. BOLD, 30); jp.add( jl1 );/中部em = new EmployModel();String paras ="1" ;,paras);em .queryEmploy( "select * from Employinfo where 1 = ?" jt = new JTable( em);jsp = new JScrollPane( jt);this .setLayout( new BorderLayout();this .add( jp ,BorderLayou

49、t. NORTH);this .add( jsp ,BorderLayout.CENTER);(8) Examine/*員工考核界面*/package .Ma nager;importjava.awt.*;importjava.awt.eve nt.*;importjava.sql.ResultSet;importjava.util.Vector;importjava.sql.*;importjavax.swi ng.*;Acti on Liste ner publicclass Examine extendsPanel implementsJLabel jl1 , jl2 , jl3 , j

50、l4 ;JTable jt;JScrollPane jsp ;JTextField jtfl , jtf2 ;Choice ch ;utton 1, 2;JPanel jp1 , jp2 , jp3 , jp4 ;AppraisalModel am ;SqlHelper sqh ;public Exam in e() /北部為標題文字jp4 = new JPanel();jl1 = new JLabel("員工考核", JLabel. CENTER);jl1 .setFo nt( new Font("黑體", Font. BOLD, 30); jp4 .

51、add( jl1 );/中部 am = new AppraisalModel();am .queryAppraisal( "select E.Empno,E.Ename,A.Consequence,A.RegDate from "+ "Employi nfo as E,Appraisal as A where E.Emp no=A.Emp no");jt = new JTable( am);jsp = new JScrollPane( jt);/監(jiān)聽jtable點擊表格時獲取點擊的行數(shù)并通過鼠標點擊事件給jtfl , jtf2賦值 jt .addMous

52、eListener( new MouseAdapter() publicvoid mouseClicked(MouseEve nt 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("考核");jt

53、f1 = new JTextField(10);jtf2 = new JTextField(10);jtf1 .setEditable( false );jtf2 .setEditable( false );/實例單項選擇框組件，并賦值ch = new Choice();ch .add("未考核");ch .add("不合格");ch.add("合格");ch.add("優(yōu)秀");jp1 = new JPanel();jp1 .add( jl2);jp1 .add( jtfl );jp1 .add( jl3);jp

54、1 .add( jtf2 );jp1 .add( jl4);jp1 .add( ch);jp2 = new JPanel( new BorderLayout();jp2 .add( jsp , BorderLayout.CENTER);jp2 .add( jp1 , BorderLayout. SOUTH );/南部1 = new utton("確認");2 = new utton("刷新");jp3 = new JPanel();1 .addActionListener(this );2.addActionListener(this );jp3 .ad

55、d( 1);jp3 .add( 2);this .setLayout( new BorderLayout();this.add( jp4 , BorderLayout.NORTH );this.add( jp2 , BorderLayout.CENTER);this.add( jp3 , BorderLayout.SOUTH);publicvoidacti on Performed(Acti on Eve nt e) if (e.getSource() =1) Stri ng Emp no =jtf1 .getText();String Ename =jtf2 .getText();String Consequenee = ch .getSelectedltem();/先獲取上次考核記錄Stri ng sql = "select Con seque nee from Appraisal where Emp no =?"Stri ng paras = Emp no ;Stri ng Oldl nfo =III!try sqh = new SqlHelper();ResultSet rs = sqh .queryExecute(sql, paras);rs.n ext(