Eclipse+Java+Swing实现企业人事管理系统（上）

2022-05-25 124

版权

本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。

简介： Eclipse+Java+Swing实现企业人事管理系统

一、系统介绍

本系统实现的功能：用户登录、员工信息的增删改查、导出Execl、计算器、记事本、信息排序。采用AES加密算法，数据库使用Mysql8.0.13，界面良好。

二、系统展示

1.登录页

2.主页面

3.添加员工信息

4.修改员工信息

5.计算器

6.记事本

7.导出Execl

三、系统实现

AccountDao.java

package com.sjsq.dao;
import java.util.List;
import com.sjsq.model.TbAccount;
import com.sjsq.model.TbDept;
import com.sjsq.model.TbPerson;
import org.springframework.dao.DataAccessException;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import com.sjsq.tools.JDBCUtils;
public class AccountDao {
  private static JdbcTemplate template = new JdbcTemplate(JDBCUtils.getDataSource());
  public static List<TbAccount> findAllAccount() {
    try {
      String sql = "select * from tb_account";
      List<TbAccount> a = template.query(sql, new BeanPropertyRowMapper<TbAccount>(TbAccount.class));
      return a;
    } catch (DataAccessException e) {
      e.printStackTrace();
      return null;
    }
  }
  public static String findAccountMoneyById(int i) {
    try {
      String sql = "select * from tb_account where timecard_id=?";
      TbAccount tbAccount = template.queryForObject(sql, new BeanPropertyRowMapper<TbAccount>(TbAccount.class),
          i);
      return tbAccount.getMoney();
    } catch (DataAccessException e) {
      e.printStackTrace();
      return null;
    }
  }
}

DeptDao.java

package com.sjsq.dao;
import java.util.List;
import com.sjsq.model.TbDept;
import org.springframework.dao.DataAccessException;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import com.sjsq.tools.JDBCUtils;
public class DeptDao {
  private static JdbcTemplate template = new JdbcTemplate(JDBCUtils.getDataSource());
  public static TbDept findDeptById(int deptId) {
    String sql = "select * from tb_dept where id=?";
    TbDept dept = template.queryForObject(sql, new BeanPropertyRowMapper<TbDept>(TbDept.class), deptId);
    return dept;
  }
  public static List<TbDept> findAllDept() {
    try {
      String sql = "select * from tb_dept";
      List<TbDept> tbDept = template.query(sql, new BeanPropertyRowMapper<TbDept>(TbDept.class));
      return tbDept;
    } catch (DataAccessException e) {
      e.printStackTrace();
      return null;
    }
  }
  public static int findDeptIdByName(String item) {
    String sql = "select * from tb_dept where name=?";
    TbDept dept = template.queryForObject(sql, new BeanPropertyRowMapper<TbDept>(TbDept.class), item);
    return dept.getId();
  }
  public static List<TbDept> findAllDeptExceptZero() {
    try {
      String sql = "select * from tb_dept where id<>0";
      List<TbDept> tbDept = template.query(sql, new BeanPropertyRowMapper<TbDept>(TbDept.class));
      return tbDept;
    } catch (DataAccessException e) {
      e.printStackTrace();
      return null;
    }
  }
  public static TbDept findDeptByName(String name) {
    try {
      String sql = "select * from tb_dept where name=?";
      TbDept dept = template.queryForObject(sql, new BeanPropertyRowMapper<TbDept>(TbDept.class), name);
      return dept;
    } catch (DataAccessException e) {
      e.printStackTrace();
      return null;
    }
  }
  public static void addDept(TbDept d2) {
    try {
      String sql = "insert into tb_dept(name) values (?)";
      template.update(sql, d2.getName());
    } catch (DataAccessException e) {
      e.printStackTrace();
    }
  }
  public static void deleteDeptById(int id) {
    try {
      String sql = "delete from tb_dept where id=?";
      template.update(sql, id);
    } catch (DataAccessException e) {
      e.printStackTrace();
    }
  }
  public static void updateDept(int id, String input) {
    try {
      String sql = "update tb_dept set name = ? where id = ?";
      template.update(sql, input, id);
    } catch (Exception e) {
      e.printStackTrace();
    }
  }
}

PersonDao.java

package com.sjsq.dao;
import java.util.List;
import com.sjsq.model.TbPerson;
import org.springframework.dao.DataAccessException;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import com.sjsq.tools.JDBCUtils;
import com.sjsq.tools.PwEncryption;
public class PersonDao {
  private static JdbcTemplate template = new JdbcTemplate(JDBCUtils.getDataSource());
  public static TbPerson queryRecordByNum(String num) {
    try {
      String sql = "select * from tb_person where record_number=?";
      TbPerson tbRecord = template.queryForObject(sql, new BeanPropertyRowMapper<TbPerson>(TbPerson.class), num);
      return tbRecord;
    } catch (DataAccessException e) {
      e.printStackTrace();
      return null;
    }
  }
  public static List<TbPerson> findAllPerson() {
    try {
      String sql = "select * from tb_person";
      List<TbPerson> tbPerson = template.query(sql, new BeanPropertyRowMapper<TbPerson>(TbPerson.class));
      return tbPerson;
    } catch (DataAccessException e) {
      e.printStackTrace();
      return null;
    }
  }
  public static List<TbPerson> likePersonByRecordNumber(String recordNumber) {
    try {
      String sql = "select * from tb_person where record_number like '%' ? '%'";
      List<TbPerson> tbPerson = template.query(sql, new BeanPropertyRowMapper<TbPerson>(TbPerson.class),
          recordNumber);
      return tbPerson;
    } catch (DataAccessException e) {
      e.printStackTrace();
      return null;
    }
  }
  public static List<TbPerson> findPersonByDeptId(int i) {
    try {
      String sql = "select * from tb_person where dept_id=?";
      List<TbPerson> tbPerson = template.query(sql, new BeanPropertyRowMapper<TbPerson>(TbPerson.class), i);
      return tbPerson;
    } catch (DataAccessException e) {
      e.printStackTrace();
      return null;
    }
  }
  public static TbPerson findPersonByRecordNumber(String recordNumber) {
    try {
      String sql = "select * from tb_person where record_number=?";
      TbPerson tbPerson = template.queryForObject(sql, new BeanPropertyRowMapper<TbPerson>(TbPerson.class),
          recordNumber);
      return tbPerson;
    } catch (DataAccessException e) {
      System.out.println("查找员工为空数据");
      e.printStackTrace();
      return null;
    }
  }
  public static void updatePerson(TbPerson person) {
    try {
      String sql = "update tb_person set dept_id=?,duty_id=?,name=?,sex=?,"
          + "birthday=?,photo=?,id_card=?,marriaged=?,native_place_id=?,"
          + "party_member=?,school_age=?,specialty=?,foreign_language=?,"
          + "grade=?,state=?,role_id=? where record_number=?";
      template.update(sql, person.getDeptId(), person.getDutyId(), person.getName(), person.getSex(),
          person.getBirthday(), person.getPhoto(), person.getIdCard(), person.getMarriaged(),
          person.getNativePlaceId(), person.getPartyMember(), person.getSchoolAge(), person.getSpecialty(),
          person.getForeignLanguage(), person.getGrade(), person.getState(), person.getRoleId(),
          person.getRecordNumber());
    } catch (Exception e) {
      e.printStackTrace();
    }
  }
  public static void addPerson(TbPerson person) {
    try {
      String sql = "insert into tb_person(record_number,dept_id,duty_id,name,sex,"
          + "birthday,photo,id_card,marriaged,native_place_id,"
          + "party_member,school_age,specialty,foreign_language,"
          + "grade,state,role_id) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
      template.update(sql, person.getRecordNumber(), person.getDeptId(), person.getDutyId(), person.getName(),
          person.getSex(), person.getBirthday(), person.getPhoto(), person.getIdCard(), person.getMarriaged(),
          person.getNativePlaceId(), person.getPartyMember(), person.getSchoolAge(), person.getSpecialty(),
          person.getForeignLanguage(), person.getGrade(), person.getState(), person.getRoleId());
    } catch (DataAccessException e) {
      e.printStackTrace();
    }
  }
  public static void deletePersonByrecordNumber(String recordNumber) {
    try {
      String sql = "delete from tb_person where record_number=?";
      template.update(sql, recordNumber);
    } catch (DataAccessException e) {
      e.printStackTrace();
    }
  }
  public static TbPerson login(TbPerson person) {
    try {
      String sql = "select * from tb_person where record_number=? and password=?";
      TbPerson tbPerson = template.queryForObject(sql, new BeanPropertyRowMapper<TbPerson>(TbPerson.class),
          person.getRecordNumber(), person.getPassword());
      return tbPerson;
    } catch (DataAccessException e) {
      System.out.println("空结果数据访问异常");
      e.printStackTrace();
      return null;
    }
  }
  public static void updatePersonPassword(TbPerson person) {
    try {
      String sql = "update tb_person set password = ? where record_number= ?";
      template.update(sql, person.getPassword(), person.getRecordNumber());
    } catch (Exception e) {
      e.printStackTrace();
    }
  }
  public static List<TbPerson> likePersonByName(String name) {
    try {
      String sql = "select * from tb_person where name like '%' ? '%'";
      List<TbPerson> tbPerson = template.query(sql, new BeanPropertyRowMapper<TbPerson>(TbPerson.class), name);
      return tbPerson;
    } catch (DataAccessException e) {
      e.printStackTrace();
      return null;
    }
  }
  public static void main(String args[]) {
    String userName = "T00001";
    String password = "123456";
    TbPerson person = new TbPerson(userName, PwEncryption.encrypt(password, "key"));
    login(person);
  }
}