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

2022-05-25 162

版权

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

简介： 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);
  }
}

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

一、系统介绍

二、系统展示

1.登录页

2.主页面

3.添加员工信息

4.修改员工信息

5.计算器

6.记事本

7.导出Execl

三、系统实现

AccountDao.java

DeptDao.java

PersonDao.java

热门文章

最新文章

相关课程

相关电子书

相关实验场景

推荐镜像

热门

活动广场

任务中心

开发者评测

高校计划

乘风者计划

训练营

阿里云MVP

话题

直播

下载

镜像站

技术资料

插件

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

一、系统介绍

二、系统展示

1.登录页

2.主页面

3.添加员工信息

4.修改员工信息

5.计算器

6.记事本

7.导出Execl

三、系统实现

AccountDao.java

DeptDao.java

PersonDao.java

热门文章

最新文章

相关课程

相关电子书

相关实验场景

推荐镜像