数据库课程设计报告-企业工资管理系统java版+代码

....word教育资料word教育资料word教育资料课程设计报告企业工资管理系统..得分： XXX 班级 XXXXX 学号 XXXXXX 课程名称 数据库原理及应用 指导教师 201X年X月X日目录一．工资管理系统需求分析…………………1.1功能需求…………………1.1.1功能划分………1.1.2功能描述……………1.2性能需求…………………1.3数据流图………………二.总体设计…………………2.1数据库概念设计…………2.2功能模块…………………三.系统详细设计……………3.1数据库逻辑设计…………3.2各模块功能………………3.2.1职工信息管理系统…………………3.2.2职工工资管理系统…………………3.2.3职工津贴管理系统…………………四.系统实现…………………4.1界面截图…………………4.1.1主界面及工资基本信息界面……4.1.2登录界面…………4.1.3系统主界面………4.1.4信息录入,修改,删除,查询界面…………4.2设计代码…………………五.实验总结…………………

需求分析功能需求1.1.1功能划分(1)、员工信息表；及时反映员工的基本信息(2)、员工津贴表，反映员工津贴(3)、员工基本工资表1.1.2功能描述(1)、基本工资的设定(2)、津贴的设定(3)、计算出月工资(4)、录入员工工资信息(5）、添加员工工资信息（6）、更改员工工资信息1.2性能需求此工资管理系统对工资数据精度的计算能在默认情况之下精确到小数点后3位小数，即是精确到分的计算。但在用户使用过程中，能自行根据实际情况进行小数计算精度的设定，最大能允许保留小数点后5位的精度。在时间特性上，当用户发出命令请求时的服务器的响应时间、对数据更新处理、工资数据的查询检索等上，同样要求系统响应时间不会超过0.5秒时间。系统支持多种操作系统的运行环境，多不同操作系统，不同文件格式的磁盘上的数据均能实现信息的互通，及共享。当服务器移植到其他的系统平台，如：Linux平台下时，同样能和其他的系统进行数据存取同步，不会出现系统之间互不兼容的情况，系统支持多系统之间的互连互通，系统有巨大的强健性。本课程设计是用Java语言编写，mysql数据库。1.3数据流图根据工资管理要求及用户需求调查分析，得到以下数据流图图1.1第一层数据流图修改职工信息修改职工信息删除职工记录输入职工基本信息工资表添加操作修改操作删除操作用户查询操作职工号图1.2职工信息的载入津贴表添加操作修改操作删除操作查询操作用户图1.4考勤的信息载入2.总体设计2.1数据库概念设计有了数据流图，用E-R图来说明工资信息管理系统的数据库概念模式，如图11nm员工领取工资领取津贴影响职工号姓名职工号基本工资职工号津贴姓名密码姓名图2.1实体之间关系E-R图2.2功能模块工资管理系统系统模块工资管理模块职工登陆模块员工管理模块3．系统详细设计3.1数据库逻辑设计将以上E-R转换成如下关系模式员工（职工号，，密码）工资（职工号，，基本工资，）津贴（职工号，，奖金）其中，标有下划线的字段表示为该数据表的主码，即主关键字。在上面的实体以及实体之间关系的基础上，形成数据库中的表格以及各个表格之间的关系。工资信息管理系统数据库中各个表格的设计结果如下面的几个表格所示。每个表格表示在数据库中的一个表。表一：员工信息表：列名列名数据类型可否取空备注说明noChar(8)NOTNULL职工号（主键）nameChar（10）NOTNULL职工miSmallintNOTNULL登录密码表二:基本工资表：列名列名数据类型可否取空备注说明noChar(8)NOTNULL职工号（主键）nameChar（10）NOTNULL职工JbmoneyNOTNULL基本工资表四：津贴信息表....word教育资料word教育资料..word教育资料列名列名数据类型可否为空备注说明noChar(8)NOTNULL职工号（主键）nameChar（10）NOTNULL职工JtmoneyNOTNULL津贴3.2各模块功能3.2.1职工信息管理系统功能为：财务部门相关人员录入、修改、删除、查询员工个人信息3.2.2职工工资管理系统功能为：根据工资生成公式，按照员工的考勤情况及各种表现按月生成相应的工资；财务部门相关人员能录入、修改、删除、查询每个月每个员工的工资信息以及工资汇总；员工本人能查询自己的工资信息以及工资汇总；2.3职工登陆查询系统功能为：员工本人能通过用户名和密码查询自己的信息以及修改自己的密码；4.系统实现4.1界面截图1.1主界面4.1.2登录界面4.1.3管理员管理工资界面4.1.4信息录入,修改,删除,查询界面4.1.5职工信息查询界面4.1.6职工密码修改界面4.2设计代码DB.javapackagewage_management;importjava.awt.*;importjava.awt.event.*;importjavax.swing.*;classDBextendsJFrameimplementsActionListener{JFrameframe=newJFrame("欢迎进入企业工资管理系统");JLabellabel=newJLabel("",JLabel.CENTER);JButtonbutton1=newJButton("进入系统");JButtonbutton2=newJButton("退出系统");ImageIconim=newImageIcon("1.jpg");....word教育资料word教育资料..word教育资料JLabela1=newJLabel(im);voidCreate(){JPanelpcontentPane=(JPanel)frame.getContentPane();pcontentPane.add(a1);pcontentPane.add(label);pcontentPane.setLayout(newFlowLayout());pcontentPane.add(button1);pcontentPane.add(button2);pcontentPane.setVisible(true);button1.addActionListener(this);button2.addActionListener(this);frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);frame.pack();frame.setBounds(200,100,550,180);frame.setVisible(true);}publicstaticvoidmain(String[]args){DBdome=newDB();dome.Create();}publicvoidactionPerformed(ActionEvente){if(button1.equals(e.getSource())){DLdl=newDL();dl.create();frame.dispose();}if(button2.equals(e.getSource())){//退出System.exit(0);}}}登陆DL.javapackagewage_management;importjava.awt.Color;importjava.awt.FlowLayout;importjava.awt.event.ActionEvent;importjava.awt.event.ActionListener;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.Statement;importjavax.swing.ImageIcon;importjavax.swing.JButton;importjavax.swing.JFrame;importjavax.swing.JLabel;importjavax.swing.JOptionPane;importjavax.swing.JPanel;importjavax.swing.JPasswordField;importjavax.swing.JTextField;import.mysql.jdbc.PreparedStatement;importQuery.Querypad;classDLextendsJFrameimplementsActionListener{ImageIconim=newImageIcon("2.jpg");JLabela2=newJLabel(im);JFrameframe=newJFrame("职工/管理员登陆");JLabellabel1=newJLabel("用户名");JLabellabel2=newJLabel("密码");JButtonlogonButton1=newJButton("管理员登录");JButtonlogonButton2=newJButton("职工登录");JButtoncancelButton=newJButton("退出");JTextFieldusername=newJTextField(9);JPasswordFieldpassword=newJPasswordField(9);staticStringt1;staticStringt2;voidcreate(){JPanelp=(JPanel)frame.getContentPane();JPanelp1=newJPanel();p.setLayout(newFlowLayout());p.add(a2);p.add(label1);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.setVisible(true);logonButton1.addActionListener(this);logonButton2.addActionListener(this);cancelButton.addActionListener(this);frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);frame.pack();frame.setBounds(200,100,500,220);frame.setVisible(true);}publicvoidactionPerformed(ActionEvente){t1=username.getText();t2=password.getText();if(e.getSource()==logonButton1){if(username.getText().equals("admin")==true&&(password.getText().equals("admin")==true)){JOptionPane.showMessageDialog(this,"登录成功！");GZGLZJMgz=newGZGLZJM();gz.create();frame.dispose();}else{JOptionPane.showMessageDialog(null,"输入用户名或密码错误！");}}if(e.getSource()==logonButton2){try{Connectioncon;Statementps;ResultSetrs;Stringsql=null;Class.forName("org.gjt.mm.mysql.Driver");Class.forName("org.gjt.mm.mysql.Driver").newInstance();con=DriverManager.getConnection("jdbc:mysql://localhost:3306/wagemanagement","root","jxb");sql="select*fromworkerinfowherename='"+t1+"'andmi='"+t2+"'";ps=(PreparedStatement)con.prepareStatement(sql);rs=ps.executeQuery(sql);if(rs.next()){if(rs.getString("name").equals(t1) &&rs.getString("mi").equals(t2)){YGDLJMyg=newYGDLJM();yg.create();frame.dispose();JOptionPane.showMessageDialog(this,"登录成功！");this.dispose();}}else{JOptionPane.showMessageDialog(this,"输入用户名或密码错误！");}}catch(Exceptione1){//TODOAuto-generatedcatchblocke1.printStackTrace();}}if(cancelButton.equals(e.getSource()))//退出{System.exit(0);}}}GZGLZJM.java//工资管理主界面packagewage_management;importjava.awt.Color;importjava.awt.FlowLayout;importjava.awt.event.ActionEvent;importjava.awt.event.ActionListener;importjavax.swing.ImageIcon;importjavax.swing.JButton;importjavax.swing.JFrame;importjavax.swing.JLabel;importjavax.swing.JPanel;classGZGLZJMextendsJFrameimplementsActionListener{JFramef=newJFrame("工资管理系统");JButtonb1=newJButton("工资管理");JButtonb2=newJButton("员工信息管理");JButtonb3=newJButton("返回");ImageIconim=newImageIcon("3.jpg");JLabela1=newJLabel(im);voidcreate(){JPanelp=(JPanel)f.getContentPane();p.setLayout(newFlowLayout());p.add(a1);p.add(b1);p.add(b2);p.add(b3);p.setBackground(Color.cyan);p.setVisible(true);b1.addActionListener(this);b2.addActionListener(this);b3.addActionListener(this);f.setBounds(200,100,500,200);f.setVisible(true);}publicvoidactionPerformed(ActionEvente){if(b3.equals(e.getSource())){//返回DLd=newDL();d.create();f.dispose();}if(b2.equals(e.getSource())){//员工信息管理YGGLyg=newYGGL();yg.create();f.dispose();}if(b1.equals(e.getSource())){//工资管理GZGLgz=newGZGL();gz.create();f.dispose();}}}//////工资管理GZGL.javapackagewage_management;importjava.awt.Color;importjava.awt.FlowLayout;importjava.awt.event.ActionEvent;importjava.awt.event.ActionListener;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;importjavax.swing.JButton;importjavax.swing.JFrame;importjavax.swing.JLabel;importjavax.swing.JOptionPane;importjavax.swing.JPanel;importjavax.swing.JScrollPane;importjavax.swing.JSplitPane;importjavax.swing.JTable;importjavax.swing.JTextField;publicclassGZGLextendsJFrameimplementsActionListener{JFramef=newJFrame("工资管理");JButtonb1=newJButton("录入");JButtonb2=newJButton("修改");JButtonb3=newJButton("删除");JButtonb4=newJButton("查询所有");JButtonb5=newJButton("返回");JTextFieldtf1=newJTextField(4);JTextFieldtf2=newJTextField(4);JTextFieldtf3=newJTextField(4);JTextFieldtf4=newJTextField(4);JTextFieldtf5=newJTextField(6);JTextFieldtf6=newJTextField(7);String[]cloum={"职工号","","津贴","月基本工资","月薪"};Object[][]row=newObject[50][5];JTabletable=newJTable(row,cloum);JScrollPanescrollpane=newJScrollPane(table);JSplitPane splitpane = newJSplitPane(JSplitPane.VERTICAL_SPLIT);voidcreate(){JPanelp=(JPanel)f.getContentPane();p.setLayout(newFlowLayout());p.add(scrollpane);p.add(splitpane);JPanelp1=newJPanel();p1.add(b1);p1.add(b2);p1.add(b3);p1.add(b4);p1.add(b5);JPanelp2=newJPanel();p2.setBackground(Color.cyan);p2.add(scrollpane);JPanelp3=newJPanel();p.setLayout(newFlowLayout());p.add(newJLabel(""));p.add(newJLabel("职工号"));p.add(tf1);p.add(newJLabel(""));p.add(tf2);p.add(newJLabel("津贴"));p.add(tf3);p.add(newJLabel("月基本工资"));p.add(tf4);p.add(newJLabel("月薪"));p.add(tf5);p.add(newJLabel("在此处输入职工号点击查询删除"));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,500,600);f.setResizable(true);//可以调整界面大小f.setVisible(true);}publicvoidactionPerformed(ActionEvente){if(b1.equals(e.getSource())){//录入Connectioncon;Statementsql;try{Class.forName("org.gjt.mm.mysql.Driver");}catch(ClassNotFoundExceptione1){System.out.println(""+e1);}try{con=DriverManager.getConnection("jdbc:mysql://localhost:3306/wagemanagement","root","jxb");sql=con.createStatement();StringinsertStr="INSERTINTOwelfare(no,name,jt)VALUES('"+tf1.getText()+"','"+tf2.getText()+"','"+tf3.getText()+"');";sql.executeUpdate(insertStr);StringinsertStr1="INSERTINTOwageinfo(no,name,jb)VALUES('"+tf1.getText()+"','"+tf2.getText()+"','"+tf4.getText()+"');";sql.executeUpdate(insertStr1);con.close();");JOptionPane.showMessageDialog(this,"入录成功！}catch(SQLExceptione1){");JOptionPane.showMessageDialog(this,"入录失败！}}if(b2.equals(e.getSource())){//修改Connectioncon;Statementsql;try{Class.forName("org.gjt.mm.mysql.Driver");}catch(ClassNotFoundExceptione1){System.out.println(""+e1);}try{con =DriverManager.getConnection("jdbc:mysql://localhost:3306/wagemanagement","root","jxb");sql=con.createStatement();StringupdateStr="UPDATEwelfareSETjt='"+tf3.getText()+"',name='"+tf2.getText()+"'whereno='"+tf1.getText()+"';";sql.executeUpdate(updateStr);StringupdateStr1="UPDATEwageinfoSETjb='"+tf4.getText()+"',name='"+tf2.getText()+"'whereno='"+tf1.getText()+"';";sql.executeUpdate(updateStr1);JOptionPane.showMessageDialog(this,"修改成功！");con.close();}catch(SQLExceptione1){JOptionPane.showMessageDialog(this,"信息不存在！");}}if(b3.equals(e.getSource())){//删除Connectioncon;Statementsql;ResultSetrs;try{Class.forName("org.gjt.mm.mysql.Driver");}catch(ClassNotFoundExceptione1){System.out.println(""+e1);}try{con =DriverManager.getConnection("jdbc:mysql://localhost:3306/wagemanagement","root","jxb");sql =con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);sql.executeUpdate("DELETEFROMwageinfowhereno='"+tf6.getText()+"';");sql.executeUpdate("DELETEFROMwelfarewhereno='"+tf6.getText()+"';");");JOptionPane.showMessageDialog(this,"删除成功！con.close();}catch(SQLExceptione1){");JOptionPane.showMessageDialog(this,"删除失败！}}if(b4.equals(e.getSource())){//查询全部Connectioncon;Statementsql;ResultSetrs;//Vectorvector=newVector();try{Class.forName("org.gjt.mm.mysql.Driver");}catch(ClassNotFoundExceptione1){JOptionPane.showMessageDialog(this,"连接数据库失败！");}try{con =DriverManager.getConnection("jdbc:mysql://localhost:3306/wagemanagement","root","jxb");sql =con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);if(b4.equals(e.getSource())){for(inti=0;i<50;i++)for(intj=0;j<4;j++)table.setValueAt("",i,j);rs=sql.executeQuery("selectdistinct*fromwageinfo,=");intk=-1;while(rs.next()){++k;Stringno=rs.getString(1);Stringname=rs.getString(2);Stringjb=rs.getString(3);Stringjt=rs.getString(6);intsum=rs.getInt(3)+rs.getInt(6);table.setValueAt(no,k,0);table.setValueAt(name,k,1);table.setValueAt(jb,k,3);table.setValueAt(jt,k,2);table.setValueAt(sum,k,4);}}}catch(SQLExceptione1){JOptionPane.showMessageDialog(this,"查询失败！");}}if(b5.equals(e.getSource())){//返回GZGLZJMgl=newGZGLZJM();gl.create();f.dispose();}}}////////修改管理主界面YGGLZJM.javapackagewage_management;importjava.awt.Color;importjava.awt.FlowLayout;importjava.awt.event.ActionEvent;importjava.awt.event.ActionListener;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;importjavax.swing.JButton;importjavax.swing.JFrame;importjavax.swing.JOptionPane;importjavax.swing.JPanel;importjavax.swing.JScrollPane;importjavax.swing.JSplitPane;importjavax.swing.JTable;publicclassYGDLJMextendsDLimplementsActionListener{JFramef=newJFrame("工资管理");JButtonb1=newJButton("查询个人工资");JButtonb2=newJButton("修改密码");JButtonb3=newJButton("返回");String[]cloum={"职工号","","津贴","月基本工资","月薪"};Object[][]row=newObject[50][5];JTabletable=newJTable(row,cloum);JScrollPanescrollpane=newJScrollPane(table);JSplitPane splitpane = newJSplitPane(JSplitPane.VERTICAL_SPLIT);voidcreate(){JPanelp=(JPanel)f.getContentPane();p.setLayout(newFlowLayout());p.add(scrollpane);p.add(splitpane);JPanelp1=newJPanel();p1.add(b1);p1.add(b2);p1.add(b3);JPanelp2=newJPanel();p2.setBackground(Color.cyan);p2.add(scrollpane);JPanelp3=newJPanel();p.setLayout(newFlowLayout());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);f.setBounds(200,100,500,550);f.setResizable(true);//可以调整界面大小f.setVisible(true);}publicvoidactionPerformed(ActionEvente){if(b1.equals(e.getSource())){//查询个人工资Connectioncon;Statementsql;ResultSetrs;try{Class.forName("org.gjt.mm.mysql.Driver");}catch(ClassNotFoundExceptione1){System.out.println(""+e1);}try{con =DriverManager.getConnection("jdbc:mysql://localhost:3306/wagemanagement","root","jxb");sql =con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);if(b1.equals(e.getSource())){for(inti=0;i<50;i++)for(intj=0;j<4;j++)table.setValueAt("",i,j);//System.out.println(t1);rs=sql.executeQuery("selectdistinct*fromwageinfo ,welfare,workerinfo wherewageinfo.no=welfare.noandwageinfo.no=='"+t1+"'andworkerinfo.mi='"+t2+"'");intk=-1;while(rs.next()){++k;Stringno=rs.getString(1);Stringname=rs.getString(2);Stringjb=rs.getString(3);Stringjt=rs.getString(6);intsum=rs.getInt(3)+rs.getInt(6);table.setValueAt(no,k,0);table.setValueAt(name,k,1);table.setValueAt(jb,k,3);table.setValueAt(jt,k,2);table.setValueAt(sum,k,4);}}}catch(SQLExceptione1){JOptionPane.showMessageDialog(this,"查询失败！");}}if(b2.equals(e.getSource())){//修改密码XGMMxgmm=newXGMM();xgmm.create();}if(b3.equals(e.getSource())){//返回DLdl=newDL();dl.create();f.dispose();}}}///修改管理YGGL.javapackagewage_management;importjava.awt.Color;importjava.awt.FlowLayout;importjava.awt.event.ActionEvent;importjava.awt.event.ActionListener;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;importjavax.swing.JButton;importjavax.swing.JFrame;importjavax.swing.JLabel;importjavax.swing.JOptionPane;importjavax.swing.JPanel;importjavax.swing.JScrollPane;importjavax.swing.JSplitPane;importjavax.swing.JTable;importjavax.swing.JTextField;publicclassYGGLextendsJFrameimplementsActionListener{JFramef=newJFrame("员工信息管理");JButtonb1=newJButton("添加新员工信息");JButtonb2=newJButton("修改员工信息");JButtonb3=newJButton("删除员工信息");JButtonb4=newJButton("查询所有员工信息");JButtonb5=newJButton("返回");JTextFieldtf1=newJTextField(4);JTextFieldtf2=newJTextField(4);JTextFieldtf3=newJTextField(4);JTextFieldtf4=newJTextField(4);JTextFieldtf5=newJTextField(6);JTextFieldtf6=newJTextField(7);String[]cloum={"职工号","","津贴","月基本工资","月薪","登陆密码"};Object[][]row=newObject[50][6];JTabletable=newJTable(row,cloum);JScrollPanescrollpane=newJScrollPane(table);JSplitPane splitpane = newJSplitPane(JSplitPane.VERTICAL_SPLIT);voidcreate(){JPanelp=(JPanel)f.getContentPane();p.setLayout(newFlowLayout());p.add(scrollpane);p.add(splitpane);JPanelp1=newJPanel();p1.add(b1);p1.add(b2);p1.add(b3);p1.add(b4);p1.add(b5);JPanelp2=newJPanel();p2.setBackground(Color.cyan);p2.add(scrollpane);p.setLayout(newFlowLayout());p.add(newJLabel(""));p.add(newJLabel("职工号"));p.add(tf1);p.add(newJLabel(""));p.add(tf2);p.add(newJLabel("津贴"));p.add(tf3);p.add(newJLabel("月基本工资"));p.add(tf4);p.add(newJLabel("登陆密码"));p.add(tf5);p.add(newJLabel("在此处输入职工号点击查询删除"));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,600,600);f.setResizable(true);//可以调整界面大小f.setVisible(true);}publicvoidactionPerformed(ActionEvente){if(b1.equals(e.getSource())){//添加新员工信息Connectioncon;Statementsql;try{Class.forName("org.gjt.mm.mysql.Driver");}catch(ClassNotFoundExceptione1){JOptionPane.showMessageDialog(this,"连接数据库失败！");}try{con =DriverManager.getConnection("jdbc:mysql://localhost:3306/wagemanagement","root","jxb");sql=con.createStatement();StringinsertStr="INSERTINTOwelfare(no,name,jt)VALUES('"+tf1.getText()+"','"+tf2.getText()+"','"+tf3.getText()+"');";sql.executeUpdate(insertStr);StringinsertStr1="INSERTINTOwageinfo(no,name,jb)VALUES('"+tf1.getText()+"','"+tf2.getText()+"','"+tf4.getText()+"');";sql.executeUpdate(insertStr1);StringinsertStr2="INSERTINTOworkerinfo(no,name,mi)VALUES('"+tf1.getText()+"','"+tf2.getText()+"','"+tf5.getText()+"');";sql.executeUpdate(insertStr2);");JOptionPane.showMessageDialog(this,"添加成功！con.close();}catch(SQLExceptione1){");JOptionPane.showMessageDialog(this,"添加失败！}}if(b2.equals(e.getSource())){//修改员工信息Connectioncon;Statementsql;try{Class.forName("org.gjt.mm.mysql.Driver");}catch(ClassNotFoundExceptione1){JOptionPane.showMessageDialog(this,"连接数据库失败！");}try{con =DriverManager.getConnection("jdbc:mysql://localhost:3306/wagemanagement","root","jxb");sql=con.createStatement();con =DriverManager.getConnection("jdbc:mysql://localhost:3306/wagemanagement","root","jxb");sql=con.createStatement();StringupdateStr="UPDATEwelfareSETjt='"+tf3.getText()+"',name='"+tf2.getText()+"'whereno='"+tf1.getText()+"';";sql.executeUpdate(updateStr);StringupdateStr1="UPDATEwageinfoSETjb='"+tf4.getText()+"',name='"+tf2.getText()+"'whereno='"+tf1.getText()+"';";sql.executeUpdate(updateStr1);sql.executeUpdate(updateStr1);StringupdateStr2="UPDATEworkerinfoSETname='"+tf2.getText()+"',mi='"+tf5.getText()+"'whereno='"+tf1.getText()+"';";sql.executeUpdate(updateStr2);");JOptionPane.showMessageDialog(this,"修改成功！con.close();}catch(SQLExceptione1){");JOptionPane.showMessageDialog(this,"修改失败！}}if(b3.equals(e.getSource())){//删除员工信息Connectioncon;Statementsql;try{Class.forName("org.gjt.mm.mysql.Driver");}catch(ClassNotFoundExceptione1){JOptionPane.showMessageDialog(this,"连接数据库失败！");}try{ con =DriverManager.getConnection("jdbc:mysql://localhost:3306/wagemanagement","root","jxb");sql =con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);sql.executeUpdate("DELETEFROMwageinfowhereno='"+tf6.getText()+"';");sql.executeUpdate("DELETEFROMwelfarewhereno='"+tf6.getText()+"';");sql.executeUpdate("DELETE FROM workerinfowhereno='"+tf6.getText()+"';");");JOptionPane.showMessageDialog(this,"删除成功！con.close();}catch(SQLExceptione1){");JOptionPane.showMessageDialog(this,"删除失败！}}if(b4.equals(e.getSource())){//查询全部员工信息Connectioncon;Statementsql;ResultSetrs;try{Class.forName("org.gjt.mm.mysql.Driver");}catch(ClassNotFoundExceptione1){JOptionPane.showMessageDialog(this,"连接数据库失败！");}try{con =DriverManager.getConnection("jdbc:mysql://localhost:3306/wagemanagement","root","jxb");sql =con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);if(b4.equals(e.getSource())){for(inti=0;i<50;i++)for(intj=0;j<4;j++)table.setValueAt("",i,j);rs=sql.executeQuery("selectdistinct*fromwageinfo ,welfare,workerinfo wherewageinfo.no=welfare.noandwageinfo.no=workerinfo.no;");intk=-1;while(rs.next()){++k;Stringno=rs.getString(1);Stringname=rs.getString(2);Stringjb=rs.getString(3);Stringjt=rs.getString(6);intsum=rs.getInt(3)+rs.getInt(6);Stringmi=rs.getString(9);table.setValueAt(no,k,0);table.setValueAt(name,k,1);table.setValueAt(jb,k,3);table.setValueAt(jt,k,2);table.setValueAt(sum,k,4);