java swing工资管理系统（源码+数据库+视频）

【实例简介】

本程序为一个基本的工资管理系统，系统中对公司员工的工资情况进行管理。本系统通过管理员实现了对员工工龄工资、职务工资、出勤奖惩和津贴等项目的统计与管理，以及对职务、出勤、津贴等项目的增添与修改，普通用户可以使用本系统查询自己的各项工资情况。系统界面简洁有条，操作方便，基本满足了普通公司对员工工资的管理需求。

【实例截图】

【核心代码】

//数据库连接

private Connection getConnection() {

       String url = "jdbc:mysql://127.0.0.1:3306/salary";

       try {

           Class.forName("com.mysql.jdbc.Driver");

           return (Connection) DriverManager.getConnection(url, "root",

                  "mysql");

       } catch (ClassNotFoundException e) {

           e.printStackTrace();

       } catch (SQLException e) {

           e.printStackTrace();

       }

       return null;

    }

    public static void main(String args[]) {

       new adminUser();

               }

// 添加职工信息监听

if (e.getSource() == enterInsert8) {

           try {

              con = getConnection();

              con.setAutoCommit(false);

              sql = con.createStatement();

              int k = sql.executeUpdate("INSERT INTO employees VALUES('"

                     a8[0][0] "','" a8[0][1] "','" a8[0][2]

                     "','" a8[0][3] "','" a8[0][4] "','"

                     a8[0][5] "','" a8[0][6] "','" a8[0][7]

                     "','" a8[0][8] "')");

              System.out.println("k = " k);

              int m = sql

                     .executeUpdate("INSERT INTO EmpandSal(emp_salEmpNO,emp_salTimeLev,emp_salTechLev) VALUES('"

                            a8[0][0]

                            "',"

                            a8[0][8]

                            ","

                            a8[0][10]

                            ")");

              int n = sql.executeUpdate("INSERT INTO DepAndEmp VALUES('"

                     a8[0][0] "'," a8[0][9] ")");

              int l = sql

                     .executeUpdate("INSERT INTO EmpAndRSal(emp_rsalEmpNo) VALUES('"

                            a8[0][0] "')");

              if (k == 1 && m == 1 && n == 1 && l == 1)

                  JOptionPane.showMessageDialog(this, "插入成功", "成功",

                         JOptionPane.PLAIN_MESSAGE);

              con.commit();

              con.close();

           } catch (SQLException ee) {

              try {

                  con.rollback();

                  JOptionPane.showMessageDialog(this, "插入失败" ee, "失败",

                         JOptionPane.ERROR_MESSAGE);

              } catch (SQLException e1) {

                  e1.printStackTrace();

              }

           }

       }

// 添加出勤信息监听

       if (e.getSource() == enterInsert9) {

           try {

              con = getConnection();

              sql = con.createStatement();

              int k = sql.executeUpdate("INSERT INTO EmpAndPre VALUES('"

                     a9[0][0] "'," a9[0][1] "," a9[0][2] ")");

              if (k == 1)

                  JOptionPane.showMessageDialog(this, "插入成功", "成功",

                         JOptionPane.PLAIN_MESSAGE);

              con.close();

           } catch (SQLException ee) {

              JOptionPane.showMessageDialog(this, "插入失败" ee, "失败",

                     JOptionPane.ERROR_MESSAGE);

           }

       }

       //

       if (e.getSource() == enterInsert10) {

           try {

              con = getConnection();

              sql = con.createStatement();

              int k = sql.executeUpdate("INSERT INTO EmpAndJintie VALUES('"

                     a10[0][0] "'," a10[0][1] ")");

              if (k == 1)

                  JOptionPane.showMessageDialog(this, "插入成功", "成功",

                         JOptionPane.PLAIN_MESSAGE);

              con.close();

           } catch (SQLException ee) {

              JOptionPane.showMessageDialog(this, "插入失败" ee, "失败",

                     JOptionPane.ERROR_MESSAGE);

           }

       }