數(shù)據(jù)庫課程設(shè)計報告—企業(yè)工資管理系統(tǒng)java版+代碼

1、-PAGE . z得分：課程設(shè)計報告企業(yè)工資管理系統(tǒng)*班級*課程名稱數(shù)據(jù)庫原理及應(yīng)用指導(dǎo)教師201*年*月*日 目 錄一工資管理系統(tǒng)需求分析1.1功能需求1.1.1功能劃分1.1.2功能描述1.2性能需求1.3數(shù)據(jù)流圖二.總體設(shè)計2.1數(shù)據(jù)庫概念設(shè)計2.2功能模塊三.系統(tǒng)詳細(xì)設(shè)計3.1數(shù)據(jù)庫邏輯設(shè)計3.2各模塊功能 3.2.1職工信息管理系統(tǒng) 3.2.2職工工資管理系統(tǒng) 3.2.3職工津貼管理系統(tǒng)四.系統(tǒng)實現(xiàn)4.1界面截圖 4.1.1主界面及工資根本信息界面 4.1.2登錄界面 4.1.3系統(tǒng)主界面 4.1.4信息錄入,修改,刪除,查詢界面4.2設(shè)計代碼五.實驗總結(jié)-. z需求分析功能需求1.

2、1.1功能劃分(1)、員工信息表；及時反映員工的根本信息 (2)、員工津貼表，反映員工津貼 (3)、員工根本工資表 1.1.2 功能描述(1)、根本工資的設(shè)定(2)、津貼的設(shè)定(3)、計算出月工資(4)、錄入員工工資信息 (5、添加員工工資信息 6、更改員工工資信息1.2性能需求此工資管理系統(tǒng)對工資數(shù)據(jù)精度的計算能在默認(rèn)情況之下準(zhǔn)確到小數(shù)點后3位小數(shù)，即是準(zhǔn)確到分的計算。但在用戶使用過程中，能自行根據(jù)實際情況進(jìn)展小數(shù)計算精度的設(shè)定，最大能允許保存小數(shù)點后5位的精度。在時間特性上，當(dāng)用戶發(fā)出命令請求時的效勞器的響應(yīng)時間、對數(shù)據(jù)更新處理、工資數(shù)據(jù)的查詢檢索等上，同樣要求系統(tǒng)響應(yīng)時間不會超過0.5秒

3、時間。系統(tǒng)支持多種操作系統(tǒng)的運行環(huán)境，多不同操作系統(tǒng)，不同文件格式的磁盤上的數(shù)據(jù)均能實現(xiàn)信息的互通，及共享。當(dāng)效勞器移植到其他的系統(tǒng)平臺，如：Linu*平臺下時，同樣能和其他的系統(tǒng)進(jìn)展數(shù)據(jù)存取同步，不會出現(xiàn)系統(tǒng)之間互不兼容的情況，系統(tǒng)支持多系統(tǒng)之間的互連互通，系統(tǒng)有巨大的強(qiáng)健性。本課程設(shè)計是用Java語言編寫，mysql數(shù)據(jù)庫。1.3數(shù)據(jù)流圖根據(jù)工資管理要求及用戶需求調(diào)查分析，得到以下數(shù)據(jù)流圖圖1.1第一層數(shù)據(jù)流圖修改職工信息刪除職工記錄輸入職工根本信息工資表添加操作修改操作刪除操作用戶查詢操作職工號圖1.2職工信息的載入津貼表添加操作修改操作刪除操作查詢操作用戶圖1.4考勤的信息載入2.總體

4、設(shè)計2.1數(shù)據(jù)庫概念設(shè)計有了數(shù)據(jù)流圖，用E-R圖來說明工資信息管理系統(tǒng)的數(shù)據(jù)庫概念模式，如圖*根本工資職工號工資員工職工號領(lǐng)取1 nm影響*津貼領(lǐng)取*津貼密碼職工號圖2.1實體之間關(guān)系E-R圖2.2功能模塊工資管理系統(tǒng) 員工管理模塊 職工登陸模塊 工資管理模塊 系統(tǒng)模塊3系統(tǒng)詳細(xì)設(shè)計3.1數(shù)據(jù)庫邏輯設(shè)計將以上E-R轉(zhuǎn)換成如下關(guān)系模式員工職工號，密碼工資職工號，根本工資，津貼職工號，獎金其中，標(biāo)有下劃線的字段表示為該數(shù)據(jù)表的主碼，即主關(guān)鍵字。在上面的實體以及實體之間關(guān)系的根底上，形成數(shù)據(jù)庫中的表格以及各個表格之間的關(guān)系。工資信息管理系統(tǒng)數(shù)據(jù)庫中各個表格的設(shè)計結(jié)果如下面的幾個表格所示。每個表格表示

5、在數(shù)據(jù)庫中的一個表。表一：員工信息表：列名數(shù)據(jù)類型可否取空備注說明no Char ( 8 )NOT NULL職工號主鍵nameChar10NOT NULL職工miSmallintNOT NULL登錄密碼表二:根本工資表：列名數(shù)據(jù)類型可否取空備注說明noChar ( 8 )NOT NULL職工號主鍵nameChar10NOT NULL職工moneyNOT NULL根本工資表四：津貼信息表列名數(shù)據(jù)類型可否為空備注說明noChar ( 8 )NOT NULL職工號主鍵nameChar10NOT NULL職工JtmoneyNOT NULL津貼3.2各模塊功能3.2.1職工信息管理系統(tǒng) 功能為：財務(wù)部門

6、相關(guān)人員錄入、修改、刪除、查詢員工個人信息3.2.2職工工資管理系統(tǒng)功能為：根據(jù)工資生成公式，按照員工的考勤情況及各種表現(xiàn)按月生成相應(yīng)的工資；財務(wù)部門相關(guān)人員能錄入、修改、刪除、查詢每個月每個員工的工資信息以及工資匯總；員工本人能查詢自己的工資信息以及工資匯總；3.2.3職工登陸查詢系統(tǒng)功能為：員工本人能通過用戶名和密碼查詢自己的信息以及修改自己的密碼；4.系統(tǒng)實現(xiàn)4.1界面截圖主界面登錄界面管理員管理工資界面信息錄入,修改,刪除,查詢界面4.1.5職工信息查詢界面4.1.6職工密碼修改界面4.2設(shè)計代碼DB.javapackage wage_management;import java.aw

7、t.*;import java.awt.event.*;import java*.swing.*;class DB e*tends JFrame implements ActionListener JFrame frame = new JFrame(歡送進(jìn)入企業(yè)工資管理系統(tǒng));JLabel label = new JLabel(, JLabel.CENTER);utton button1 = new utton(進(jìn)入系統(tǒng));utton button2 = new utton(退出系統(tǒng));ImageIcon im = new ImageIcon(1.jpg);JLabel a1 = new JL

8、abel(im);void Create() JPanel pcontentPane = (JPanel) frame.getContentPane();pcontentPane.add(a1);pcontentPane.add(label);pcontentPane.setLayout(new FlowLayout();pcontentPane.add(button1);pcontentPane.add(button2);pcontentPane.setVisible(true);button1.addActionListener(this);button2.addActionListene

9、r(this);frame.setDefaultCloseOperation(JFrame.E*IT_ON_CLOSE);frame.pack();frame.setBounds(200, 100, 550, 180);frame.setVisible(true);public static void main(String args) DB dome = new DB();dome.Create();public void actionPerformed(ActionEvent e) if (button1.equals(e.getSource() DL dl = new DL();dl.c

10、reate();frame.dispose();if (button2.equals(e.getSource() / 退出System.e*it(0);DL.javapackage wage_management;import java.awt.Color;import java.awt.FlowLayout;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql.Connection;import java.sql.DriverManager;import java.sql.

11、ResultSet;import java.sql.Statement;import java*.swing.ImageIcon;import java*.swing.utton;import java*.swing.JFrame;import java*.swing.JLabel;import java*.swing.JOptionPane;import java*.swing.JPanel;import java*.swing.JPasswordField;import java*.swing.JTe*tField;import .mysql.jdbc.PreparedStatement;

12、import Query.Querypad;class DL e*tends JFrame implements ActionListener ImageIcon im = new ImageIcon(2.jpg);JLabel a2 = new JLabel(im);JFrame frame = new JFrame(職工/管理員登陸);JLabel label1 = new JLabel(用戶名);JLabel label2 = new JLabel(密碼);utton logonButton1 = new utton(管理員登錄);utton logonButton2 = new utt

13、on(職工登錄);utton cancelButton = new utton(退出);JTe*tField username = new JTe*tField(9);JPasswordField password = new JPasswordField(9);static String t1;static String t2;void create() JPanel p = (JPanel) frame.getContentPane();JPanel p1 = new JPanel();p.setLayout(new FlowLayout();p.add(a2);p.add(label1)

14、;p.setSize(5, 5);p.setLocation(4, 8);p.add(username);p.setSize(100, 200);p.setLocation(800, 800);p.add(label2);p.setSize(50, 20);p.setLocation(40, 80);p.add(password);p.setSize(100, 20);p.setLocation(80, 120);p.add(logonButton1);p.add(logonButton2);p.add(cancelButton);p.setBackground(Color.cyan);p.s

15、etVisible(true);logonButton1.addActionListener(this);logonButton2.addActionListener(this);cancelButton.addActionListener(this);frame.setDefaultCloseOperation(JFrame.E*IT_ON_CLOSE);frame.pack();frame.setBounds(200, 100, 500, 220);frame.setVisible(true);public void actionPerformed(ActionEvent e) t1 =

16、username.getTe*t();t2 = password.getTe*t();if(e.getSource()=logonButton1)if( username.getTe*t().equals(admin) = true& (password.getTe*t().equals(admin) = true) JOptionPane.showMessageDialog(this, 登錄成功！);GZGLZJM gz = new GZGLZJM();gz.create();frame.dispose(); else JOptionPane.showMessageDialog(null,

17、輸入用戶名或密碼錯誤！);if (e.getSource()=logonButton2)try Connection con;Statement ps;ResultSet rs;String sql = null;Class.forName(org.gjt.mm.mysql.Driver);Class.forName(org.gjt.mm.mysql.Driver).newInstance();con = DriverManager.getConnection( jdbc:mysql:/localhost:3306/wage management,root,j*b); sql=select *

18、 from workerinfo where name=+t1+ and mi=+t2+;ps = (PreparedStatement) con.prepareStatement(sql);rs = ps.e*ecuteQuery(sql);if(rs.ne*t()if(rs.getString(name).equals(t1) & rs.getString(mi).equals(t2)YGDLJM yg = new YGDLJM();yg.create();frame.dispose();JOptionPane.showMessageDialog(this, 登錄成功！);this.dis

19、pose();else JOptionPane.showMessageDialog(this, 輸入用戶名或密碼錯誤！);catch (E*ception e1) / TODO Auto-generated catch blocke1.printStackTrace();if (cancelButton.equals(e.getSource() / 退出System.e*it(0);GZGLZJM.javapackage wage_management;import java.awt.Color;import java.awt.FlowLayout;import java.awt.event.

20、ActionEvent;import java.awt.event.ActionListener;import java*.swing.ImageIcon;import java*.swing.utton;import java*.swing.JFrame;import java*.swing.JLabel;import java*.swing.JPanel;class GZGLZJM e*tends JFrame implements ActionListener JFrame f = new JFrame(工資管理系統(tǒng));utton b1 = new utton(工資管理);utton b

21、2 = new utton(員工信息管理);utton b3 = new utton(返回);ImageIcon im = new ImageIcon(3.jpg);JLabel a1 = new JLabel(im);void create() JPanel p = (JPanel) f.getContentPane();p.setLayout(new FlowLayout();p.add(a1);p.add(b1);p.add(b2);p.add(b3);p.setBackground(Color.cyan);p.setVisible(true);b1.addActionListener(

22、this);b2.addActionListener(this);b3.addActionListener(this);f.setBounds(200, 100, 500, 200);f.setVisible(true);public void actionPerformed(ActionEvent e) if (b3.equals(e.getSource() / 返回DL d = new DL();d.create();f.dispose();if (b2.equals(e.getSource() / 員工信息管理YGGL yg = new YGGL();yg.create();f.disp

23、ose();if (b1.equals(e.getSource() / 工資管理GZGL gz = new GZGL();gz.create();f.dispose();GZGL.javapackage wage_management;import java.awt.Color;import java.awt.FlowLayout;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql.Connection;import java.sql.DriverManager;impor

24、t java.sql.ResultSet;import java.sql.SQLE*ception;import java.sql.Statement;import java*.swing.utton;import java*.swing.JFrame;import java*.swing.JLabel;import java*.swing.JOptionPane;import java*.swing.JPanel;import java*.swing.JScrollPane;import java*.swing.JSplitPane;import java*.swing.JTable;imp

25、ort java*.swing.JTe*tField;public class GZGL e*tends JFrame implements ActionListener JFrame f = new JFrame(工資管理);utton b1 = new utton(錄入);utton b2 = new utton(修改);utton b3 = new utton(刪除);utton b4 = new utton(查詢所有);utton b5 = new utton(返回);JTe*tField tf1 = new JTe*tField(4);JTe*tField tf2 = new JTe

26、*tField(4);JTe*tField tf3 = new JTe*tField(4);JTe*tField tf4 = new JTe*tField(4);JTe*tField tf5 = new JTe*tField(6);JTe*tField tf6 = new JTe*tField(7);String cloum = 職工號, , 津貼, 月根本工資,月薪;Object row = new Object505;JTable table = new JTable(row, cloum);JScrollPane scrollpane = new JScrollPane(table);J

27、SplitPane splitpane = new JSplitPane(JSplitPane.VERTICAL_SPLIT);void create() JPanel p = (JPanel) f.getContentPane();p.setLayout(new FlowLayout();p.add(scrollpane);p.add(splitpane);JPanel p1 = new JPanel();p1.add(b1);p1.add(b2);p1.add(b3);p1.add(b4);p1.add(b5);JPanel p2 = new JPanel();p2.setBackgrou

28、nd(Color.cyan);p2.add(scrollpane);JPanel p3 = new JPanel();p.setLayout(new FlowLayout();p.add(new JLabel();p.add(new JLabel(職工號);p.add(tf1);p.add(new JLabel();p.add(tf2);p.add(new JLabel(津貼);p.add(tf3);p.add(new JLabel(月根本工資);p.add(tf4);p.add(new JLabel(月薪);p.add(tf5);p.add(new JLabel( 在此處輸入職工號點擊查詢刪

29、除);p.add(tf6);splitpane.add(p1, splitpane.TOP);splitpane.add(p2, splitpane.BOTTOM);splitpane.setDividerLocation(50);p.setBackground(Color.CYAN);b1.addActionListener(this);b2.addActionListener(this);b3.addActionListener(this);b4.addActionListener(this);b5.addActionListener(this);f.setBounds(200, 100,

30、 500, 600);f.setResizable(true);/ 可以調(diào)整界面大小f.setVisible(true);public void actionPerformed(ActionEvent e) if (b1.equals(e.getSource() / 錄入Connection con;Statement sql;try Class.forName(org.gjt.mm.mysql.Driver); catch (ClassNotFoundE*ception e1) System.out.println( + e1);try con = DriverManager.getConn

31、ection(jdbc:mysql:/localhost:3306/wage management,root,j*b);sql = con.createStatement();String insertStr = INSERT INTO welfare (no,name,jt)VALUES(+tf1.getTe*t()+,+tf2.getTe*t()+,+tf3.getTe*t()+);sql.e*ecuteUpdate(insertStr);String insertStr1 = INSERT INTO wageinfo (no,name,)VALUES(+tf1.getTe*t()+,+t

32、f2.getTe*t()+,+tf4.getTe*t()+);sql.e*ecuteUpdate(insertStr1);con.close();JOptionPane.showMessageDialog(this, 入錄成功！); catch (SQLE*ception e1) JOptionPane.showMessageDialog(this, 入錄失?。?;if (b2.equals(e.getSource() / 修改Connection con;Statement sql;try Class.forName(org.gjt.mm.mysql.Driver); catch (Clas

33、sNotFoundE*ception e1) System.out.println( + e1);try con = DriverManager.getConnection(jdbc:mysql:/localhost:3306/wage management,root,j*b);sql = con.createStatement();String updateStr = UPDATE welfare SET jt=+tf3.getTe*t()+,name=+tf2.getTe*t()+where no=+tf1.getTe*t()+;sql.e*ecuteUpdate(updateStr);S

34、tring updateStr1 = UPDATE wageinfo SET =+tf4.getTe*t()+,name=+tf2.getTe*t()+where no=+tf1.getTe*t()+;sql.e*ecuteUpdate(updateStr1);JOptionPane.showMessageDialog(this, 修改成功！);con.close(); catch (SQLE*ception e1) JOptionPane.showMessageDialog(this, 信息不存在！);if (b3.equals(e.getSource() / 刪除Connection co

35、n;Statement sql;ResultSet rs;try Class.forName(org.gjt.mm.mysql.Driver); catch (ClassNotFoundE*ception e1) System.out.println( + e1);try con = DriverManager.getConnection(jdbc:mysql:/localhost:3306/wage management,root,j*b);sql = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_R

36、EAD_ONLY);sql.e*ecuteUpdate(DELETE FROM wageinfo where no=+tf6.getTe*t()+;);sql.e*ecuteUpdate(DELETE FROM welfare where no=+tf6.getTe*t()+;);JOptionPane.showMessageDialog(this, 刪除成功！);con.close(); catch (SQLE*ception e1) JOptionPane.showMessageDialog(this, 刪除失??！);if (b4.equals(e.getSource() / 查詢?nèi)緾o

37、nnection con;Statement sql;ResultSet rs;/Vector vector = new Vector();try Class.forName(org.gjt.mm.mysql.Driver); catch (ClassNotFoundE*ception e1) JOptionPane.showMessageDialog(this, 連接數(shù)據(jù)庫失敗！);try con = DriverManager.getConnection(jdbc:mysql:/localhost:3306/wage management,root,j*b);sql = con.creat

38、eStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);if (b4.equals(e.getSource() for (int i = 0; i 50; i+)for (int j = 0; j 4; j+)table.setValueAt(, i, j);rs = sql.e*ecuteQuery(select distinct * from wageinfo ,welfare where =);int k = -1;while (rs.ne*t() +k

39、;String no = rs.getString(1);String name = rs.getString(2);String = rs.getString(3);String jt = rs.getString(6);int sum=rs.getInt(3)+rs.getInt(6);table.setValueAt(no, k, 0);table.setValueAt(name, k, 1);table.setValueAt(, k, 3);table.setValueAt(jt, k, 2);table.setValueAt(sum,k,4); catch (SQLE*ception

40、 e1) JOptionPane.showMessageDialog(this, 查詢失?。?;if (b5.equals(e.getSource() / 返回GZGLZJM gl=new GZGLZJM();gl.create();f.dispose();YGGLZJM.javapackage wage_management;import java.awt.Color;import java.awt.FlowLayout;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql

41、.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLE*ception;import java.sql.Statement;import java*.swing.utton;import java*.swing.JFrame;import java*.swing.JOptionPane;import java*.swing.JPanel;import java*.swing.JScrollPane;import java*.swing.JSplitPane;import j

42、ava*.swing.JTable;public class YGDLJM e*tends DL implements ActionListener JFrame f = new JFrame(工資管理);utton b1 = new utton(查詢個人工資);utton b2 = new utton(修改密碼);utton b3 = new utton(返回);String cloum = 職工號, , 津貼, 月根本工資,月薪;Object row = new Object505;JTable table = new JTable(row, cloum);JScrollPane scro

43、llpane = new JScrollPane(table);JSplitPane splitpane = new JSplitPane(JSplitPane.VERTICAL_SPLIT);void create() JPanel p = (JPanel) f.getContentPane();p.setLayout(new FlowLayout();p.add(scrollpane);p.add(splitpane);JPanel p1 = new JPanel();p1.add(b1);p1.add(b2);p1.add(b3);JPanel p2 = new JPanel();p2.

44、setBackground(Color.cyan);p2.add(scrollpane);JPanel p3 = new JPanel();p.setLayout(new FlowLayout();splitpane.add(p1, splitpane.TOP);splitpane.add(p2, splitpane.BOTTOM);splitpane.setDividerLocation(50);p.setBackground(Color.CYAN);b1.addActionListener(this);b2.addActionListener(this);b3.addActionListe

45、ner(this);f.setBounds(200, 100, 500, 550);f.setResizable(true);/ 可以調(diào)整界面大小f.setVisible(true);public void actionPerformed(ActionEvent e) if (b1.equals(e.getSource() / 查詢個人工資Connection con;Statement sql;ResultSet rs;try Class.forName(org.gjt.mm.mysql.Driver); catch (ClassNotFoundE*ception e1) System.ou

46、t.println( + e1);try con = DriverManager.getConnection(jdbc:mysql:/localhost:3306/wage management,root,j*b);sql = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);if (b1.equals(e.getSource() for (int i = 0; i 50; i+)for (int j = 0; j 4; j+)table.setValueAt(, i, j);/Sys

47、tem.out.println(t1);rs = sql.e*ecuteQuery(select distinct * from wageinfo ,welfare,workerinfo where wageinfo.no=welfare.no and wageinfo.no=workerinfo.no and =+t1+ and workerinfo.mi=+t2+);int k = -1;while (rs.ne*t() +k;String no = rs.getString(1);String name = rs.getString(2);String =

48、rs.getString(3);String jt = rs.getString(6);int sum=rs.getInt(3)+rs.getInt(6);table.setValueAt(no, k, 0);table.setValueAt(name, k, 1);table.setValueAt(, k, 3);table.setValueAt(jt, k, 2);table.setValueAt(sum,k,4); catch (SQLE*ception e1) JOptionPane.showMessageDialog(this, 查詢失?。?;if (b2.equals(e.getS

49、ource() / 修改密碼*GMM *gmm=new *GMM();*gmm.create();if (b3.equals(e.getSource() / 返回DL dl=new DL();dl.create();f.dispose();YGGL.javapackage wage_management;import java.awt.Color;import java.awt.FlowLayout;import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql.Connection;

50、import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLE*ception;import java.sql.Statement;import java*.swing.utton;import java*.swing.JFrame;import java*.swing.JLabel;import java*.swing.JOptionPane;import java*.swing.JPanel;import java*.swing.JScrollPane;import java*.swing.JSpli

51、tPane;import java*.swing.JTable;import java*.swing.JTe*tField;public class YGGL e*tends JFrame implements ActionListener JFrame f = new JFrame(員工信息管理);utton b1 = new utton(添加新員工信息);utton b2 = new utton(修改員工信息);utton b3 = new utton(刪除員工信息);utton b4 = new utton(查詢所有員工信息);utton b5 = new utton(返回);JTe*t

52、Field tf1 = new JTe*tField(4);JTe*tField tf2 = new JTe*tField(4);JTe*tField tf3 = new JTe*tField(4);JTe*tField tf4 = new JTe*tField(4);JTe*tField tf5 = new JTe*tField(6);JTe*tField tf6 = new JTe*tField(7);String cloum = 職工號, , 津貼, 月根本工資,月薪,登陸密碼;Object row = new Object506;JTable table = new JTable(ro

53、w, cloum);JScrollPane scrollpane = new JScrollPane(table);JSplitPane splitpane = new JSplitPane(JSplitPane.VERTICAL_SPLIT);void create() JPanel p = (JPanel) f.getContentPane();p.setLayout(new FlowLayout();p.add(scrollpane);p.add(splitpane);JPanel p1 = new JPanel();p1.add(b1);p1.add(b2);p1.add(b3);p1

54、.add(b4);p1.add(b5);JPanel p2 = new JPanel();p2.setBackground(Color.cyan);p2.add(scrollpane);p.setLayout(new FlowLayout();p.add(new JLabel();p.add(new JLabel(職工號);p.add(tf1);p.add(new JLabel();p.add(tf2);p.add(new JLabel(津貼);p.add(tf3);p.add(new JLabel(月根本工資);p.add(tf4);p.add(new JLabel(登陸密碼);p.add(

55、tf5);p.add(new JLabel( 在此處輸入職工號點擊查詢刪除);p.add(tf6);splitpane.add(p1, splitpane.TOP);splitpane.add(p2, splitpane.BOTTOM);splitpane.setDividerLocation(50);p.setBackground(Color.CYAN);b1.addActionListener(this);b2.addActionListener(this);b3.addActionListener(this);b4.addActionListener(this);b5.addAction

56、Listener(this);f.setBounds(200, 100, 600, 600);f.setResizable(true);/ 可以調(diào)整界面大小f.setVisible(true);public void actionPerformed(ActionEvent e) if (b1.equals(e.getSource() / 添加新員工信息Connection con;Statement sql;try Class.forName(org.gjt.mm.mysql.Driver); catch (ClassNotFoundE*ception e1) JOptionPane.show

57、MessageDialog(this, 連接數(shù)據(jù)庫失敗！);try con = DriverManager.getConnection(jdbc:mysql:/localhost:3306/wage management,root,j*b);sql = con.createStatement();String insertStr = INSERT INTO welfare (no,name,jt)VALUES(+tf1.getTe*t()+,+tf2.getTe*t()+,+tf3.getTe*t()+);sql.e*ecuteUpdate(insertStr);String insertSt

58、r1 = INSERT INTO wageinfo (no,name,)VALUES(+tf1.getTe*t()+,+tf2.getTe*t()+,+tf4.getTe*t()+);sql.e*ecuteUpdate(insertStr1);String insertStr2 = INSERT INTO workerinfo (no,name,mi)VALUES(+tf1.getTe*t()+,+tf2.getTe*t()+,+tf5.getTe*t()+);sql.e*ecuteUpdate(insertStr2);JOptionPane.showMessageDialog(this, 添

59、加成功！);con.close(); catch (SQLE*ception e1) JOptionPane.showMessageDialog(this, 添加失敗！);if (b2.equals(e.getSource() / 修改員工信息Connection con;Statement sql;try Class.forName(org.gjt.mm.mysql.Driver); catch (ClassNotFoundE*ception e1) JOptionPane.showMessageDialog(this, 連接數(shù)據(jù)庫失??！);try con = DriverManager.g

60、etConnection(jdbc:mysql:/localhost:3306/wage management,root,j*b);sql = con.createStatement();con = DriverManager.getConnection(jdbc:mysql:/localhost:3306/wage management,root,j*b);sql = con.createStatement();String updateStr = UPDATE welfare SET jt=+tf3.getTe*t()+,name=+tf2.getTe*t()+where no=+tf1.