企业工资综合管理系统JavaMySQL

企业工资管理系统（MySQL+Java）本代码仅供初学者参考使用，相互学习，共同进步，让优异成为一个习惯。软件下载：开发语言：Java开发工具：eclipse数据库软件：MySQL数据库驱动：mysql-connector-java-5.1.6-bin驱动下载地址：以下是代码和界面截图，共7个类。DB1欢迎界面importjava.awt.*;importjava.awt.event.*;importjavax.swing.*;classDB1extendsJFrameimplementsActionListener{ privatestaticfinallongserialVersionUID=1L; JFrameframe=newJFrame("欢迎进入工资管理系统"); JLabellabel=newJLabel("",JLabel.CENTER); JButtonbutton1=newJButton("进入系统"); JButtonbutton2=newJButton("退出系统"); voidCreate(){ JPanelpcontentPane=(JPanel)frame.getContentPane(); pcontentPane.add(label); pcontentPane.setLayout(newFlowLayout()); pcontentPane.add(button1); pcontentPane.add(button2); pcontentPane.setBackground(Color.gray); pcontentPane.setVisible(true); button1.addActionListener(this); button2.addActionListener(this); frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); frame.pack(); frame.setBounds(500,300,300,150); frame.setResizable(false); frame.setVisible(true); } publicstaticvoidmain(String[]args){ DB1dome=newDB1(); dome.Create(); } publicvoidactionPerformed(ActionEvente){ if(button1.equals(e.getSource())){ DLdl=newDL(); dl.create(); frame.dispose(); } if(button2.equals(e.getSource())){//退出 System.exit(0); } }}DL登陆界面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.JButton;importjavax.swing.JFrame;importjavax.swing.JLabel;importjavax.swing.JOptionPane;importjavax.swing.JPanel;importjavax.swing.JPasswordField;importjavax.swing.JTextField;importcom.mysql.jdbc.PreparedStatement;@SuppressWarnings("serial")classDLextendsJFrameimplementsActionListener{ 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(); @SuppressWarnings("unused") JPanelp1=newJPanel(); p.setLayout(newFlowLayout()); 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.gray); p.setVisible(true); logonButton1.addActionListener(this); logonButton2.addActionListener(this); cancelButton.addActionListener(this); frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); frame.pack(); frame.setBounds(500,300,500,220); frame.setVisible(true); } @SuppressWarnings("deprecation") 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/management","root","hellomysql"); sql="select*fromworkerwherenum='"+t1+"'andpassword='"+t2+"'"; ps=(PreparedStatement)con.prepareStatement(sql); rs=ps.executeQuery(sql); if(rs.next()) { if(rs.getString("num").equals(t1)&&rs.getString("password").equals(t2)) { YGGLZJMyg=newYGGLZJM(); yg.create(); frame.dispose(); JOptionPane.showMessageDialog(this,"登录成功！"); this.dispose(); } } else{ JOptionPane.showMessageDialog(this,"输入用户名或密码错误！"); } }catch(Exceptione1){ //TODOAuto-generatedcatchblock e1.printStackTrace(); } } if(cancelButton.equals(e.getSource()))//退出 { System.exit(0); } }}GZGL工资管理界面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;@SuppressWarnings("serial")publicclassGZGLextendsJFrameimplementsActionListener{ JFramef=newJFrame("职员工资管理"); JButtonb1=newJButton("录入"); JButtonb2=newJButton("修改"); JButtonb3=newJButton("删除"); JButtonb4=newJButton("查询全部"); JButtonb5=newJButton("返回"); JTextFieldtf1=newJTextField(6); JTextFieldtf2=newJTextField(4); JTextFieldtf3=newJTextField(4); JTextFieldtf4=newJTextField(4); JTextFieldtf5=newJTextField(4); JTextFieldtf6=newJTextField(4); JTextFieldtf7=newJTextField(6); JTextFieldtf8=newJTextField(6); JTextFieldtf9=newJTextField(4); JTextFieldtf10=newJTextField(4); JTextFieldtf11=newJTextField(6); JTextFieldtf12=newJTextField(6); String[]cloum={"职员号","基础工资","津贴","奖金","保险","房贷","总工资"}; Object[][]row=newObject[50][7]; JTabletable=newJTable(row,cloum); JScrollPanescrollpane=newJScrollPane(table); JSplitPanesplitpane=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.gray); p2.add(scrollpane); @SuppressWarnings("unused") 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); p.add(newJLabel("总工资")); p.add(tf7); p.add(newJLabel("姓名")); p.add(tf8); p.add(newJLabel("性别")); p.add(tf9); p.add(newJLabel("年纪")); p.add(tf10); p.add(newJLabel("部门")); p.add(tf11); p.add(newJLabel("职业")); p.add(tf12); splitpane.add(p1,JSplitPane.TOP); splitpane.add(p2,JSplitPane.BOTTOM); splitpane.setDividerLocation(50); p.setBackground(Color.gray); b1.addActionListener(this); b2.addActionListener(this); b3.addActionListener(this); b4.addActionListener(this); b5.addActionListener(this); f.setBounds(500,100,500,600); f.setResizable(false);//能够调整界面大小 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/management","root","hellomysql"); sql=con.createStatement(); StringinsertStr="INSERTINTOsalary(worker_num,basic_pay,welfare,bonus,insurance,housing_fund,payment)VALUES('"+tf1.getText()+"','"+tf2.getText()+"','"+tf3.getText()+"','"+tf4.getText()+"','"+tf5.getText()+"','"+tf6.getText()+"','"+tf7.getText()+"');"; sql.executeUpdate(insertStr); StringinsertStr1="INSERTINTOworker(num,name,sex,age,dep,occup,password)VALUES('"+tf1.getText()+"','"+tf8.getText()+"','"+tf9.getText()+"','"+tf10.getText()+"','"+tf11.getText()+"','"+tf12.getText()+"','"+tf1.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/management","root","hellomysql"); sql=con.createStatement(); StringupdateStr="UPDATEsalarySETbasic_pay='"+tf2.getText()+"',welfare='"+tf3.getText()+"',bonus='"+tf4.getText()+"',insurance='"+tf5.getText()+"',housing_fund='"+tf6.getText()+"',payment='"+tf7.getText()+"'whereworker_num='"+tf1.getText()+"';"; sql.executeUpdate(updateStr); StringupdateStr1="UPDATEworkerSETname='"+tf8.getText()+"',sex='"+tf9.getText()+"',age='"+tf10.getText()+"',dep='"+tf11.getText()+"',occup='"+tf12.getText()+"'wherenum='"+tf1.getText()+"';"; sql.executeUpdate(updateStr1); JOptionPane.showMessageDialog(this,"修改成功！"); con.close(); }catch(SQLExceptione1){ JOptionPane.showMessageDialog(this,"信息不存在！"); } } if(b3.equals(e.getSource())){//删除 Connectioncon; Statementsql; @SuppressWarnings("unused") ResultSetrs; try{ Class.forName("org.gjt.mm.mysql.Driver"); }catch(ClassNotFoundExceptione1){ System.out.println(""+e1); } try{ con=DriverManager.getConnection("jdbc:mysql://localhost:3306/management","root","hellomysql"); sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY); sql.executeUpdate("DELETEFROMsalarywhereworker_num='"+tf1.getText()+"';"); sql.executeUpdate("DELETEFROMworkerwherenum='"+tf1.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/management","root","hellomysql"); 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("select*fromsalary"); intk=-1; while(rs.next()){ ++k; Stringno=rs.getString(1); Stringjb=rs.getString(2); Stringjt=rs.getString(3); Stringjj=rs.getString(4); Stringbx=rs.getString(5); Stringzf=rs.getString(6); Stringsum= rs.getString(7); table.setValueAt(no,k,0); table.setValueAt(jb,k,1); table.setValueAt(jt,k,2); table.setValueAt(jj,k,3); table.setValueAt(bx,k,4); table.setValueAt(zf,k,5); table.setValueAt(sum,k,6); } } }catch(SQLExceptione1){ JOptionPane.showMessageDialog(this,"查询失败！"); } } if(b5.equals(e.getSource())){//返回 GZGLZJMgl=newGZGLZJM(); gl.create(); f.dispose(); } }}GZGLZJM工资管理主界面importjava.awt.Color;importjava.awt.FlowLayout;importjava.awt.event.ActionEvent;importjava.awt.event.ActionListener;importjavax.swing.JButton;importjavax.swing.JFrame;importjavax.swing.JPanel;classGZGLZJMextendsJFrameimplementsActionListener{ privatestaticfinallongserialVersionUID=1L; JFramef=newJFrame("工资管理系统"); JButtonb1=newJButton("工资管理"); JButtonb2=newJButton("职员信息管理"); JButtonb3=newJButton("返回"); voidcreate(){ JPanelp=(JPanel)f.getContentPane(); p.setLayout(newFlowLayout()); p.add(b1); p.add(b2); p.add(b3); p.setBackground(Color.gray); p.setVisible(true); b1.addActionListener(this); b2.addActionListener(this); b3.addActionListener(this); f.setBounds(500,300,500,200); f.setResizable(false); 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(); } }}XGMM修改密码importjava.awt.Color;importjava.awt.FlowLayout;importjava.awt.event.ActionEvent;importjava.awt.event.ActionListener;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.SQLException;importjava.sql.Statement;importjavax.swing.JButton;importjavax.swing.JFrame;importjavax.swing.JLabel;importjavax.swing.JOptionPane;importjavax.swing.JPanel;importjavax.swing.JPasswordField;@SuppressWarnings("serial")classXGMMextendsDLimplementsActionListener{ JFrameframe=newJFrame("密码修改"); JLabellabel1=newJLabel("原密码"); JLabellabel2=newJLabel("新密码"); JButtonButton1=newJButton("确定"); JButtoncancelButton=newJButton("返回"); JPasswordFieldpassword=newJPasswordField(9); JPasswordFieldnewpassword=newJPasswordField(9); voidcreate() { JPanelp=(JPanel)frame.getContentPane(); p.setLayout(newFlowLayout()); p.add(label1); p.setSize(5,5); p.setLocation(4,8); p.add(password); p.setSize(100,200); p.setLocation(600,600); p.add(label2); p.setSize(50,20); p.setLocation(40,80); p.add(newpassword); p.setSize(100,20); p.setLocation(80,120); p.add(Button1); p.add(cancelButton); p.setBackground(Color.cyan); p.setVisible(true); Button1.addActionListener(this); cancelButton.addActionListener(this); frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); frame.pack(); frame.setBounds(200,100,500,220); frame.setVisible(true); } publicvoidactionPerformed(ActionEvente) { if(e.getSource()==Button1) { Connectioncon; Statementsql; try{ Class.forName("org.gjt.mm.mysql.Driver"); }catch(ClassNotFoundExceptione1){ JOptionPane.showMessageDialog(this,"连接数据库失败！"); } try{ con=DriverManager.getConnection("jdbc:mysql://localhost:3306/management","root","hellomysql"); sql=con.createStatement(); @SuppressWarnings("deprecation") StringupdateStr="UPDATEworkerSETpassword='"+newpassword.getText()+"'wherenum='"+t1+"';"; sql.executeUpdate(updateStr); JOptionPane.showMessageDialog(this,"修改成功！"); con.close(); frame.dispose(); }catch(SQLExceptione1){ JOptionPane.showMessageDialog(this,"请输入原密码和新密码！"); } } if(e.getSource()==cancelButton)//返回 { YGGLZJMdl=newYGGLZJM(); dl.create(); frame.dispose(); } }}YGGL职员信息管理界面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;@SuppressWarnings("serial")publicclassYGGLextendsJFrameimplementsActionListener{ JFramef=newJFrame("职员信息管理"); JButtonb2=newJButton("修改职员信息"); JButtonb3=newJButton("删除职员信息"); JButtonb4=newJButton("查询全部职员信息"); JButtonb5=newJButton("返回"); JTextFieldtf1=newJTextField(8); JTextFieldtf2=newJTextField(8); JTextFieldtf3=newJTextField(6); JTextFieldtf4=newJTextField(6); JTextFieldtf5=newJTextField(6); JTextFieldtf6=newJTextField(6); String[]cloum={"职员号","姓名","性别","年纪","部门","职业"}; Object[][]row=newObject[50][6]; JTabletable=newJTable(row,cloum); JScrollPanescrollpane=newJScrollPane(table); JSplitPanesplitpane=newJSplitPane(JSplitPane.VERTICAL_SPLIT); voidcreate(){ JPanelp=(JPanel)f.getContentPane(); p.setLayout(newFlowLayout()); p.add(scrollpane); p.add(splitpane); JPanelp1=newJPanel(); p1.add(b2); p1.add(b3); p1.add(b4); p1.add(b5); JPanelp2=newJPanel(); p2.setBackground(Color.gray); 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,JSplitPane.TOP); splitpane.add(p2,JSplitPane.BOTTOM); splitpane.setDividerLocation(50); p.setBackground(Color.gray); b2.addActionListener(this); b3.addActionListener(this); b4.addActionListener(this); b5.addActionListener(this); f.setBounds(500,100,500,600); f.setResizable(false);//能够调整界面大小 f.setVisible(true); } publicvoidactionPerformed(ActionEvente){ 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/management","root","hellomysql"); sql=con.createStatement(); StringupdateStr="UPDATEworkerSETname='"+tf2.getText()+"',sex='"+tf3.getText()+"',age='"+tf4.getText()+"',dep='"+tf5.getText()+"',occup='"+tf6.getText()+"'wherenum='"+tf1.getText()+"';"; sql.executeUpdate(updateStr); 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/management","root","hellomysql"); sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); sql.executeUpdate("DELETEFROMworkerwherenum='"+tf1.getText()+"';"); sql.executeUpdate("DELETEFROMsalarywhereworker_num='"+tf1.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/management","root","hellomysql"); 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("select*fromworker;"); intk=-1; while(rs.next()){ ++k; Stringno=rs.getString(1); Stringxm=rs.getString(2); Stringxb=rs.getString(3); Stringnl=rs.getString(4); Stringbm=rs.getString(5); Stringzy=rs.getString(6); table.setValueAt(no,k,0); table.setValueAt(xm,k,1); table.setValueAt(xb,k,2); table.setValueAt(nl,k,3); table.setValueAt(bm,k,4); table.setValueAt(zy,k,5); } } }catch(SQLExceptione1){ JOptionPane.showMessageDialog(this,"查询失败！"); } } if(b5.equals(e.getSource())){//返回 GZGLZJMgl=newGZGLZJM(); gl.create(); f.dispose(); } }}YGGLZJM个人工资查询界面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;@SuppressWarnings("serial")publicclassYGGLZJMextendsDLimplementsActionListener{ JFramef=newJFrame("工资管理"); JButtonb1=newJButton("查询个人工资"); JButtonb2=newJButton("修改密码"); JButtonb3=newJButton("返回"); String[]cloum={"职员号","基础工资","津贴","奖金","保险","房贷","总工资"}; Object[][]row=newObject[50][7]; JTabletable=newJTable(row,cloum); JScrollPanescrollpane