職工工資管理系統(tǒng)設(shè)計與實(shí)現(xiàn)

1、JA V A程序設(shè)計課程設(shè)計報告設(shè)計題目:職工工資管理系統(tǒng)設(shè)計與實(shí)現(xiàn)學(xué)院名稱:專業(yè)班級:姓名:學(xué)號:目錄一需求分析。3二概要設(shè)計。3 三詳細(xì)設(shè)計。53.1 數(shù)據(jù)庫設(shè)計。33.2 模塊及窗體設(shè)計。33.2.1 數(shù)據(jù)庫模塊設(shè)計。53.2.2 用戶登錄識別模塊。63.2.3管理員模塊。8職工基本信息管理。9職工工資管理。203.2.4 普通用戶模塊。28職工信息。283.2.5 系統(tǒng)管理模塊。153.2.5 主窗體菜單設(shè)計。15四軟件測試。36 五總結(jié)。36 參考資料:.。.17一需求分析本系統(tǒng)的主要目的就是實(shí)現(xiàn)職工工資管理系統(tǒng)設(shè)計與實(shí)現(xiàn),使職工工資管理工作更加容易, 高效地管理企業(yè)職工工資,從而提

2、高工作效率,降低管理成本.二概要設(shè)計/* 概要設(shè)計階段主要是粗略描述整個軟件的框架,并從業(yè)務(wù)的角度描述軟件的模塊、工作流程等。項(xiàng)目的成功取決于設(shè)計的好壞,而概要設(shè)計則是整個設(shè)計的關(guān)鍵部分。概要設(shè)計的主要任務(wù)是將用戶的需求劃分為不同的功能,然后將這些功能細(xì)分成模塊,并給模塊一些規(guī)則約束,以達(dá)到各個模塊之間可以相互交流的目的。概要設(shè)計關(guān)乎到系統(tǒng)的整體架構(gòu),因此想做好一個概要設(shè)計,不僅僅要熟悉用戶的業(yè)務(wù)流程,還要具備相當(dāng)豐富的設(shè)計經(jīng)驗(yàn)。2.1 概要設(shè)計的原則概要設(shè)計是根據(jù)系統(tǒng)分析的需求和工作環(huán)境的情況對整個軟件的總體結(jié)構(gòu)進(jìn)行大致的設(shè)計。概要設(shè)計要堅(jiān)持以下幾個原則。(1細(xì)分原則:軟件系統(tǒng)都是由很多不同

3、的模塊組成,當(dāng)設(shè)計一套軟件時,要先將所有的功能分解。解決復(fù)雜問題的方法是將其分解成幾個小問題,一個個來解決。(2提高代碼重用性:在面向?qū)ο笤O(shè)計中,首先考慮的就是代碼的重用,一個好的設(shè)計,將來在升級換代時不需要太大的改動,節(jié)省了人力物力。(3從上而下層層分析:概要設(shè)計要從整體出發(fā),逐個剖析軟件的功能,從上而下,先分析系統(tǒng)總的功能,然后一步步細(xì)分,直到最小的功能模塊。(4一致性原則:概要設(shè)計要求所有功能模塊在定義時使用統(tǒng)一的規(guī)范。(5提高獨(dú)立性,減少耦合:各個模塊與模塊之間盡量減少關(guān)聯(lián),否則修改一個地方就會引起其他多處的變動,不符合面向?qū)ο蟮脑瓌t。一般情況下,對類封裝后,只允許對類進(jìn)行擴(kuò)展,而不能

4、修改,而封裝的類必須具有單一職責(zé),既理論情況下不允許兩個類共同完成一個功能。(6模塊的大小要盡量適中:不是結(jié)構(gòu)算法越復(fù)雜的模塊越好,模塊的大小要根據(jù)實(shí)際工作目標(biāo)和其他類的耦合緊密程度來決定。經(jīng)驗(yàn)表明,一個模塊的規(guī)模不應(yīng)過大,模塊的總行數(shù)應(yīng)控制在10100行的范圍內(nèi),最好為3060行,這樣理解和閱讀都較方便。過長的模塊往往是分解不充分的表現(xiàn),會增加閱讀理解的難度;但小規(guī)模太多也會使模塊之間聯(lián)系變得復(fù)雜,增大系統(tǒng)在模塊調(diào)用時傳遞信息所花費(fèi)的開銷。由于概要設(shè)計是整個設(shè)計的重中之重,牽一發(fā)而動全身,所以要努力做一個好的概要設(shè)計,才能在今后軟件開發(fā)過程中不再反復(fù)?，F(xiàn)在軟件行業(yè)流行模式化驅(qū)動設(shè)計,將一些市

5、場上比較成功的模式拿來用在自己的設(shè)計中。2.2 將用戶需求模塊化根據(jù)概要設(shè)計的原則來分析一下本項(xiàng)目的用戶需求,并最終轉(zhuǎn)化成用程序語言描述的模塊。什么樣的需求才是一個模塊?模塊應(yīng)該具備如下3個特征。(1輸入和輸出:模塊必須能被調(diào)用并且正確的返回調(diào)用,而且調(diào)用都是相對一個對象而言,這是模塊獨(dú)立性的一個體現(xiàn)。(2處理功能:模塊必須可以對調(diào)用的輸入數(shù)據(jù)進(jìn)行靈活的處理,并為輸出準(zhǔn)備好處理結(jié)果。(3程序代碼:用來實(shí)現(xiàn)模塊功能的源代碼。2.3 確定系統(tǒng)最終模塊概要設(shè)計中最重要的就是確定此項(xiàng)目包括哪些模塊。根據(jù)上兩節(jié)講述的設(shè)計原則和模塊特征,將用戶需求轉(zhuǎn)化為下面的模塊。*/ (1流程圖設(shè)計 2.2 模塊設(shè)計1

6、 數(shù)據(jù)庫設(shè)計模塊2 用戶登錄識別模塊3 用戶信息管理模塊4 職工信息管理模塊2.2.1 程序功能描述1.程序運(yùn)行之后首先彈出歡迎窗口,繼而進(jìn)入登陸界面2.登陸界面的通過用戶密碼驗(yàn)證進(jìn)入操作3.密碼輸入正確后轉(zhuǎn)入管理員主菜單,就可以選擇對職工基本信息和工資進(jìn)行計算、修改、添加或者查詢或退出后回到主菜單。4.密碼輸入正確后轉(zhuǎn)入普通用戶主菜單,就可以選擇對自身基本信息和工資進(jìn)行計算或者查詢或退出后回到主菜單。5.每個功能模塊都有退出的功能,回到主菜單。6.點(diǎn)擊主菜單的退出按鈕,退出系統(tǒng)。三詳細(xì)設(shè)計3.1 數(shù)據(jù)庫設(shè)計數(shù)據(jù)庫名稱:employee 表名:user, employ,salary表user:

7、存放登陸用戶的用戶名和密碼表employ:存放職工基本信息 3.2 模塊及窗體設(shè)計3.2.1 數(shù)據(jù)庫模塊設(shè)計將數(shù)據(jù)庫的連接包裝在一個DBConnect類中,以便其他模塊能夠輕松調(diào)用,避免每次重寫數(shù)據(jù)庫連接代碼。下表是他的基本屬性 /創(chuàng)建數(shù)據(jù)庫連接類DBConnectpackage Java_Design;import java.sql.*;public class JDBConnect/靜態(tài)方法提高數(shù)據(jù)庫的連接效率public static Connection getConn( throws Exception/加載JDBC驅(qū)動Class.forName("com.microsof

8、t.sqlserver.jdbc.SQLServerDriver"return DriverManager.getConnection("jdbc:sqlserver:/localhost:1433;" +"databasename=SalaryManagement","sa","1sjk"/關(guān)閉連接public static void closeConn(Connection connif(conn != nulltry conn.close(; catch (Exception e e.printSt

9、ackTrace(; /關(guān)閉執(zhí)行對象public static void closeStatement(Statement stmtif(stmt != nulltry stmt.close(; catch (Exception e e.printStackTrace(; /關(guān)閉結(jié)果集public static void closeResultSet(ResultSet rsif(rs != nulltry rs.close(; catch (Exception e e.printStackTrace(; 3.2.2 用戶登錄識別模塊 下表其他的基本屬性 private class BHand

10、ler implements ActionListenerpublic void actionPerformed(ActionEvent ename=text1.getText(;if (e.getSource(=button1if(text1.getText(.trim(.equals(""| text2.getText(.trim(.equals(""JOptionPane.showMessageDialog(null,"信息不能為空!"tryResultSet rs1=st.executeQuery("select *

11、 from Employee where EmployID='"+text1.getText(+"'"if(rs1.next( Name=rs1.getString("EmployName".trim(;if(text2.getText(.equals(rs1.getString("EmployPassword".trim(if(mana.isSelected(if(rs1.getString("EmployJob".trim(.equals("管理員"dispose(

12、;Management Management1 = new Management(rs1.getString("EmployName".trim(;Management1.setVisible(true;else JOptionPane.showMessageDialog(null,"非管理員!"else if(pers.isSelected(/j普通用戶dispose(;Person Person1 = new Person(rs1.getString("EmployName".trim(,rs1.getString("E

13、mployID".trim(;Person1.setVisible(true;else JOptionPane.showMessageDialog(landing1.this,"password error!"else JOptionPane.showMessageDialog(landing1.this,"登錄超時!沒有這個用戶!"catch(Exception ex/利用消息對話框提示失敗JOptionPane.showMessageDialog(landing1.this,"登錄超時!沒有這個用戶!"text1.set

14、Text(""text2.setText(""else if (e.getSource(=button2text1.setText(" "text2.setText(" "else if(e.getSource(=jMenuItem1/上頁dispose(;index m= new index(;m.setVisible(true;else if(e.getSource(=jMenuItem4/退出System.exit(0;3.2.3 管理員模塊 代碼:public Management(String name/

15、傳過來管理員的nameName=name;setTitle("Welcome Management_"+Name;/ 設(shè)置窗體標(biāo)題setSize(800, 600;setBounds(100, 100, 550, 340;/ 設(shè)置窗體位置setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE;setResizable(false;setContentPane(contentPane;/ 設(shè)置窗體內(nèi)容面板BHandler h=new BHandler(;/為組件注冊監(jiān)聽器indexBackgroundP backgroundPanel =

16、new indexBackgroundP(;/ 創(chuàng)建背景面板backgroundPanel.setImage(getToolkit(.getImage( getClass(.getResource("3.jpg"/ 設(shè)置面板背景圖片contentPane.setBorder(new EmptyBorder(5, 5, 5, 5;contentPane.setLayout(new BorderLayout(0, 0;/BorderLayout是用東西南北和中央Button1.setToolTipText("查看所有職工資料"/用來設(shè)置鼠標(biāo)停留時顯示提示信息

17、的Button1.setIcon(new ImageIcon(Management.class.getResource("5.png"addButton.setToolTipText("增添職員"/用來設(shè)置鼠標(biāo)停留時顯示提示信息的addButton.setIcon(new ImageIcon(Management.class.getResource("add.jpg"toolBar.add(addButton;subButton.setToolTipText("刪除資料"subButton.setIcon(new

18、ImageIcon(Management.class.getResource("sub.png"toolBar.add(subButton;resetButton.setToolTipText("修改信息"resetButton.setIcon(new ImageIcon(Management.class.getResource("reset.png"toolBar.add(resetButton;findButton.setToolTipText("查找職員"findButton.setIcon(new Imag

19、eIcon(Management.class.getResource("find1.jpg"toolBar.add(findButton;jMenuBar1.add(jMenu0;jMenu0.add(jMenuItem1;/主頁jMenu0.add(jMenuItem3;/退出jMenu0.add(jMenuItem2;/幫助setJMenuBar(jMenuBar1;setIconImage(Toolkit.getDefaultToolkit(.getImage("4.png"contentPane.add(toolBar, BorderLayout

20、.NORTH;contentPane.add(Button1,BorderLayout.WEST;contentPane.add(backgroundPanel;jMenuItem1.addActionListener(h;jMenuItem2.addActionListener(h;jMenuItem3.addActionListener(h;Button1.addActionListener(h;subButton.addActionListener(h;findButton.addActionListener(h;addButton.addActionListener(h;resetBu

21、tton.addActionListener(h;private class BHandler implements ActionListenerpublic void actionPerformed(ActionEvent eif(e.getSource(=jMenuItem1/主頁dispose(;index h= new index(;h.setVisible(true;/ frame.dispose(;else if(e.getSource(=jMenuItem2/幫助int i=0;dispose(;help h1= new help(Name,i,""/姓名權(quán)限

22、編號h1.setVisible(true;else if(e.getSource(=jMenuItem3/退出System.exit(0;else if(e.getSource(=Button1/dispose(;M_reset rese=new M_reset(Name;rese.setVisible(true;else if(e.getSource(=addButton /增dispose(;Add_person fram1= new Add_person(Name;fram1.setVisible(true;else if(e.getSource(=subButton/刪dispose(

23、;Sub_person su=new Sub_person(Name;su.setVisible(true;else if(e.getSource(=resetButton/改dispose(;Reset_person re= new Reset_person(Name;re.setVisible(true;else if(e.getSource(=findButton/查dispose(;Find_person2 fin= new Find_person2(Name;fin.setVisible(true; 3.2.3.1 下表其他的基本屬性 public Add_person(String

24、 NName=N;setTitle("Welcome Person_Reset_"+Name;/ 設(shè)置窗體標(biāo)題setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE;setBounds(100, 100, 450, 350;/ 設(shè)置窗體位置setContentPane(contentPane;/ 設(shè)置窗體內(nèi)容面板contentPane.setLayout(new BorderLayout(0, 0;indexBackgroundP backgroundPanel = new indexBackgroundP(;/ 創(chuàng)建背景面板backgr

25、oundPanel.setImage(getToolkit(.getImage( getClass(.getResource("666.jpg"/ 設(shè)置面板背景圖片jlabel1.setBounds(10,-20,300,120;jlabel2.setBounds(30,65,80,60; text1.setBounds(80,80,120,30;jlabel3.setBounds(220,65,80,60; man.setBounds(270,80,60,30;women.setBounds(325,80,60,30;jlabel7.setBounds(30,105,80

26、,60; text7.setBounds(80,120,120,30;/姓名jlabel8.setBounds(220,105,80,60; text8.setBounds(270,120,120,30;/年齡jlabel4.setBounds(30,145,80,60; text3.setBounds(80,160,120,30;/住址jlabel5.setBounds(220,145,80,60; text4.setBounds(270,160,120,30;/聯(lián)系電話jlabel6.setBounds(30,190,80,60; text2.setBounds(80,205,120,30

27、;/部門jlabel10.setBounds(220,190,80,60; text10.setBounds(270,205,120,30;jlabel9.setBounds(30,235,80,60; text9.setBounds(80,245,120,30;/職務(wù)button2.setBounds(355,10,70,30;button2.setToolTipText("返回上頁!"button1.setBounds(270,245,120,30;jlabel1.setFont(new Font("Serif",Font.PLAIN,30;jlab

28、el2.setFont(new Font("Serif",Font.PLAIN,20;jlabel3.setFont(new Font("Serif",Font.PLAIN,20;jlabel4.setFont(new Font("Serif",Font.PLAIN,20;jlabel5.setFont(new Font("Serif",Font.PLAIN,20;jlabel6.setFont(new Font("Serif",Font.PLAIN,20;jlabel7.setFont(new

29、 Font("Serif",Font.PLAIN,20;jlabel8.setFont(new Font("Serif",Font.PLAIN,20;jlabel9.setFont(new Font("Serif",Font.PLAIN,20;jlabel10.setFont(new Font("Serif",Font.PLAIN,20;button1.addActionListener(h;button2.addActionListener(h; /button4.addActionListener(h;cont

30、entPane.add(jlabel1;contentPane.add(jlabel2;contentPane.add(jlabel3;contentPane.add(jlabel4;contentPane.add(jlabel5;contentPane.add(jlabel6;contentPane.add(jlabel7;contentPane.add(jlabel8;contentPane.add(jlabel9;contentPane.add(jlabel10;contentPane.add(button2;contentPane.add(text1;contentPane.add(t

31、ext2;contentPane.add(text3;contentPane.add(text4;contentPane.add(text7;contentPane.add(text8;contentPane.add(text9;contentPane.add(text10;buttonGroup.add(man;buttonGroup.add(women;contentPane.add(man;contentPane.add(women;contentPane.add(button1;contentPane.add(backgroundPanel;/ 把背景面板添加到窗體內(nèi)容面板/ cont

32、entPane.setOpaque(true;contentPane.add(button4;try/調(diào)用初始化方法Init(;catch(Exception exceptionexception.printStackTrace(;private class BHandler implements ActionListenerpublic void actionPerformed(ActionEvent eif(e.getSource(=button1/獲取用戶輸入的信息String EmployID=text1.getText(;String EmployName=text7.getText

33、(;String EmploySex=""if(man.isSelected(EmploySex+="男"if(women.isSelected(EmploySex+="女"String EmployAge=text8.getText(;String EmployAd=text4.getText(;String EmployPhone=text2.getText(;String EmployPassword=text10.getText(;String EmployDept=text3.getText(;String EmployJo

34、b=text9.getText(;text11=new JTextField(text1.getText(;try/設(shè)置日期格式st.execute("set dateformat ymd"/利用st對象執(zhí)行SQL語句,進(jìn)行插入操作st.executeUpdate("insert into Employee values('"+EmployID+"','"+EmployName+"','"+EmploySex+"','"+EmployAge

35、+"','"+EmployDept+"','"+EmployAd +"','"+EmployJob+"','"+EmployPhone+"','"+EmployPassword+"'"dispose(;Add_Salary frame=new Add_Salary(text11.getText(,Name;frame.setVisible(true;catch(Exception ex/利

36、用消息對話框提示異常的信息JOptionPane.showMessageDialog(Add_person.this,"職工添加失敗!"ex.printStackTrace(;else if(e.getSource(=button2/String EmployID=;dispose(;Management frame=new Management(Name;frame.setVisible(true; 代碼:public class Find_person2 extends JFrameConnection con;/聲明連接數(shù)據(jù)庫對象Statement st;/聲明SQL

37、語句對象JPanel contentPane;JMenuBar jMenuBar1=new JMenuBar(;/菜單條BHandler h=new BHandler(;/為組件注冊監(jiān)聽器JMenu jMenu0=new JMenu("系統(tǒng)"/菜單JMenuItem jMenuItem1=new JMenuItem("回到上頁"/子菜單JMenuItem jMenuItem2=new JMenuItem("回到主頁"/子菜單JMenuItem jMenuItem3=new JMenuItem("幫助"/子菜單JMe

38、nuItem jMenuItem4=new JMenuItem("退出"/子菜單String select,Name;JButton FINDButton=new JButton(;JScrollPane scrollPane1 = new JScrollPane(;JPanel panel1 = new JPanel(;JPanel panel2 = new JPanel(;JPanel panel3 = new JPanel(;JComboBox jcomboBox;ButtonGroup buttongroup=new ButtonGroup(;JRadioButto

39、n person=new JRadioButton("個人信息"JRadioButton salary=new JRadioButton("薪水"JTextField text1 = new JTextField("輸入查找信息"String selects="職工編號","姓名","職務(wù)","薪水"JTable table1 = new JTable(;Find_person2(String s1Name=s1;setTitle("Welcom

40、e Find_person_"+Name;/ 設(shè)置窗體標(biāo)題setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE;setBounds(100, 100, 690, 400;/ 設(shè)置窗體位置contentPane = new JPanel(;/ 創(chuàng)建內(nèi)容面板setContentPane(contentPane;/ 設(shè)置窗體內(nèi)容面板contentPane.setLayout(new BorderLayout(0, 0;contentPane.setBorder(new EmptyBorder(5, 5, 5, 5;contentPane.setLayo

41、ut(new GridLayout(3, 1, 5, 5;jcomboBox=new JComboBox(selects;jcomboBox.setMaximumRowCount(4;jcomboBox.setSelectedIndex(0;jcomboBox.addItemListener(new Handler(;jcomboBox.setSize(300, 20;buttongroup.add(salary;buttongroup.add(person;/ panel1.setLayout(new BorderLayout(0, 0;panel2.setLayout(new Border

42、Layout(0, 0;panel1.setLayout(new GridLayout(2, 2, 5, 5;JLabel label1 = new JLabel("職工基本資料表"label1.setFont(new Font("微軟雅黑", Font.PLAIN, 16;jcomboBox.setFont(new Font("微軟雅黑", Font.PLAIN, 20;FINDButton.setToolTipText("查找信息"FINDButton.setIcon(new ImageIcon(help.cl

43、ass.getResource("14.png"panel1.add(text1;panel1.add(jcomboBox;panel1.add(person;panel1.add(salary;/ panel1.add(label2, BorderLayout.NORTH;panel2.add(label1, BorderLayout.NORTH;table1.setGridColor(Color.pink;table1.setRowHeight(20;table1.setSelectionBackground(Color.black;table1.setSelectio

44、nForeground(Color.white;scrollPane1.setViewportView(table1;panel2.add(scrollPane1, BorderLayout.CENTER;jMenuBar1.add(jMenu0;jMenu0.add(jMenuItem1;/子菜單jMenu0.add(jMenuItem2;/子菜單jMenu0.add(jMenuItem3;/子菜單jMenu0.add(jMenuItem4;/子菜單setJMenuBar(jMenuBar1;jMenuItem1.addActionListener(h;jMenuItem2.addActio

45、nListener(h;jMenuItem3.addActionListener(h;jMenuItem4.addActionListener(h; FINDButton.addActionListener(h;contentPane.add(panel1; contentPane.add(panel2;contentPane.add(FINDButton;/ contentPane.add(backgroundPanel;try/調(diào)用初始化方法Init(;catch(Exception exceptionexception.printStackTrace(;private void Init

46、( throws Exceptioncon=JDBConnect.getConn(;st=con.createStatement(;private class Handler implements ItemListenerpublic void itemStateChanged(ItemEvent eif(e.getStateChange( = e.SELECTEDselect=selectsjcomboBox.getSelectedIndex(;private class BHandler implements ActionListenerpublic void actionPerforme

47、d(ActionEvent eif(e.getSource(=jMenuItem1/上頁dispose(;Management m= new Management(Name;m.setVisible(true;else if(e.getSource(=jMenuItem2/主頁dispose(;index i= new index(;i.setVisible(true;else if(e.getSource(=jMenuItem3/幫助int i=0;dispose(;help help1= new help("",i,Name;help1.setVisible(true;

48、else if(e.getSource(=jMenuItem4/退出System.exit(0;else if(e.getSource(=FINDButton /顯示數(shù)據(jù)查詢數(shù)據(jù)庫tryif(person.isSelected(ResultSet RS = null;ResultSet RS1 = null;if(select.equals("職工編號"RS=st.executeQuery("select * from Employee where EmployID='"+text1.getText(+"'"else

49、if(select.equals("姓名"RS=st.executeQuery("select * from Employee where EmployName='"+text1.getText(+"'"else if(select.equals("職務(wù)"RS=st.executeQuery("select * from Employee where EmployJob='"+text1.getText(+"'"else if(select.e

50、quals("薪水"RS1=st.executeQuery("select * from Salary where BaseSalary='"+text1.getText(+"'"if(RS1.next(RS=st.executeQuery("select * from Employee where EmployID='"+RS1.getString("EmployID"+"'"if(RS.next(String columnNames = &

51、quot;編號", "姓名","性別","年齡","部門","住址","職務(wù)","電話","密碼"DefaultTableModel model = new DefaultTableModel(columnNames, 9;table1.setModel(model;/ 設(shè)置表格數(shù)據(jù)模型table1.setValueAt(RS.getString("EmployID",0,0;table1.setValue

52、At(RS.getString("EmployName",0,1;table1.setValueAt(RS.getString("EmploySex",0,2;table1.setValueAt(RS.getInt("EmployAge",0,3;table1.setValueAt(RS.getString("EmployDept",0,4;table1.setValueAt(RS.getString("EmployAd",0,5;table1.setValueAt(RS.getString(&

53、quot;EmployJob",0,6;table1.setValueAt(RS.getString("EmployPhone",0,7;table1.setValueAt(RS.getString("EmployPassword",0,8;else JOptionPane.showMessageDialog(null, "查找失敗"else if(salary.isSelected(ResultSet RS = null;ResultSet RS1 = null;String columnNames = "編號&

54、quot;, "基本薪水","獎金","罰金","工資卡","總工資"DefaultTableModel model = new DefaultTableModel(columnNames, 6;table1.setModel(model;/ 設(shè)置表格數(shù)據(jù)模型if(select.equals("薪水"RS=st.executeQuery("select * from Salary where BaseSalary='"+text1.getText(

55、+"'"else if(select.equals("編號"RS=st.executeQuery("select * from Salary where EmployID='"+text1.getText(+"'"else if(select.equals("姓名"RS1=st.executeQuery("select * from Employee where EmployName='"+text1.getText(+"'&

56、quot;if(RS1.next(RS=st.executeQuery("select * from Salary where EmployID='"+RS1.getString("EmployID"+"'"else if(select.equals("職務(wù)"RS1=st.executeQuery("select * from Employee where EmployJob='"+text1.getText(+"'"if(RS1.next(

57、RS=st.executeQuery("select * from Salary where EmployID='"+RS1.getString("EmployID"+"'" if(RS.next(table1.setValueAt(RS.getString("EmployID",0,0;table1.setValueAt(RS.getString("BaseSalary",0,1;table1.setValueAt(RS.getString("AddSalary",0,2;table1.setValueAt(RS.getInt("SubSalary",0,3;table1.setValueAt(RS.getString("SalaryCard",0,4;table1.setValueAt(RS.getString("RealSalary",0,5;else JOptionPane.show