基于SpringBoot+Mybatis+Thymeleaf架构实现的员工管理系统(源码+数据库)

完整项目地址:https://download.csdn.net/download/lijunhcn/88430276

基于SpringBoot+Mybatis+Thymeleaf架构实现的员工管理系统(源码+数据库)

SpringBoot整合CRUD实现员工管理案例,将Mybatis整合到原项目中,加入了数据库,添加了日期选项的控件。

环境要求
  • JDK8以上
  • IDEA
  • MySQL8
  • Maven3
  • 需要熟练掌握MySQL数据库,SpringBoot及MyBatis知识,简单的前端知识;
数据库环境

创建案例所使用的数据库

CREATE DATABASE `employee`;USE `employee`;

创建登陆用户数据表

DROP TABLE IF EXISTS `user`;CREATE TABLE `user` (`id` int(10) NOT NULL,`user_name` varchar(255)NOT NULL COMMENT '用户名',`password` varchar(255)NOT NULL COMMENT '密码',PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;INSERT INTO `user` VALUES (1, 'admin', '123456');

创建部门信息的数据库表

DROP TABLE IF EXISTS `department`;CREATE TABLE `department` (`id` int(10) NOT NULL,`department_name` varchar(255)NOT NULL COMMENT '部门名称',PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;BEGIN;INSERT INTO `department` VALUES (1, '市场部');INSERT INTO `department` VALUES (2, '技术部');INSERT INTO `department` VALUES (3, '销售部');INSERT INTO `department` VALUES (4, '客服部');INSERT INTO `department` VALUES (5, '公关部');COMMIT;

创建存放员工信息的数据库表

DROP TABLE IF EXISTS `employee`;CREATE TABLE `employee` (`id` int(10) NOT NULL AUTO_INCREMENT,`employee_name` varchar(255)NOT NULL COMMENT '员工姓名',`email` varchar(255)NOT NULL COMMENT '员工邮箱',`gender` int(2) NOT NULL COMMENT '员工性别',`department_id` int(10) NOT NULL COMMENT '部门编号',`date` date NOT NULL COMMENT '入职日期',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;BEGIN;INSERT INTO `employee` VALUES (1, '张三', 'zhangsan@gmail.com', 0, 1, '2020-05-12');INSERT INTO `employee` VALUES (2, '李四', 'lisi@qq.com', 1, 2, '2020-05-05');INSERT INTO `employee` VALUES (3, '王五', 'wangwu@126.com', 0, 3, '2020-05-15');INSERT INTO `employee` VALUES (4, '赵六', 'zhaoliu@163.com', 1, 4, '2020-04-21');INSERT INTO `employee` VALUES (5, '田七', 'tianqi@foxmail.com', 0, 3, '2020-05-14');INSERT INTO `employee` VALUES (10, '王伟', 'wangwei@gmail.com', 1, 3, '2020-05-08');INSERT INTO `employee` VALUES (11, '张伟', 'zhangwei@gmail.com', 1, 2, '2020-05-11');INSERT INTO `employee` VALUES (12, '李伟', 'liwei@gmail.com', 1, 3, '2020-05-18');COMMIT;
基本环境搭建
  1. 新建Spring项目, 添加Lombok,Spring Web,Thymeleaf,Mybatis,MySQL Driver的支持

  2. 相关的pom依赖

    org.springframework.boot spring-boot-starter-thymeleaf org.springframework.boot spring-boot-starter-web org.mybatis.spring.boot mybatis-spring-boot-starter 2.1.2 mysql mysql-connector-java runtime org.projectlombok lombok true org.springframework.boot spring-boot-starter-test test org.junit.vintage junit-vintage-engine

  3. 建立基本结构和配置框架

com/
|-- godfrey |-- config |-- controller |-- dto |-- mapper |-- pojo |-- service

  1. application.yml里配置数据库连接信息及Mapper映射文件信息

    spring:
    datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/employee?useSSL=true&useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8
    username: employee
    password: employee123
    thymeleaf:
    cache: false
    messages:
    basename: i18n.login

    mybatis:
    type-aliases-package: com.godfrey.pojo
    mapper-locations: classpath:com.godfrey.mapper/*Mapper.xml
    configuration:
    map-underscore-to-camel-case: true
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

  2. 测试数据库连接

    package com.godfrey;

    import org.junit.jupiter.api.Test;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.boot.test.context.SpringBootTest;

    import javax.sql.DataSource;
    import java.sql.Connection;
    import java.sql.SQLException;

    @SpringBootTest
    class ApplicationTests {

    @AutowiredDataSource dataSource;@Testvoid contextLoads() throws SQLException {System.out.println("数据源>>>>>>" + dataSource.getClass());Connection connection = dataSource.getConnection();System.out.println("连接>>>>>>>>>" + connection);System.out.println("连接地址>>>>>" + connection.getMetaData().getURL());connection.close();}

    }

查看输出结果,数据库配置ok

创建pojo实体类
  1. 创建User实体

    package com.godfrey.pojo;

    import lombok.Data;

    /**

    • description : 登录验证实体类
    • @author godfrey
    • @since 2020-05-26
      */
      @Data
      public class User {
      private Integer id;
      private String userName;
      private String password;
      }
  2. 创建Department实体

    package com.godfrey.pojo;

    import lombok.Data;

    /**

    • description : 部门实体类
    • @author godfrey
    • @since 2020-05-26
      */
      @Data
      public class Department {
      private Integer id;
      private String departmentName;
      }
  3. 创建Employee实体

    package com.godfrey.pojo;

    import lombok.Data;

    import java.sql.Date;

    /**

    • description : 员工实体类
    • @author godfrey
    • @since 2020-05-26
      */
      @Data
      public class Employee {
      private Integer id;
      private String employeeName;
      private String email;
      private Integer gender; //0:女 1:男
      private Date date;
      private Integer departmentId;
      }
  4. 创建EmployeeDTO实体

    package com.godfrey.dto;

    import lombok.Data;

    import java.sql.Date;

    /**

    • description : EmployeeDTO
    • @author godfrey
    • @since 2020-05-26
      */
      @Data
      public class EmployeeDTO {
      private Integer id;
      private String employeeName;
      private String email;
      private Integer gender;
      private String departmentName;
      private Date date;
      }
Mapper层

文件存放目录:

com.godfrey.mapper 相关接口

resources/com.godfrey.mapper 相关mapper.xml

  1. 编写User的Mapper接口:UserMapper

    package com.godfrey.mapper;

    import com.godfrey.pojo.User;
    import org.apache.ibatis.annotations.Mapper;
    import org.apache.ibatis.annotations.Param;
    import org.springframework.stereotype.Repository;

    /**

    • description : 登录验证查询Mapper
    • @author godfrey
    • @since 2020-05-26
      */
      @Mapper
      @Repository
      public interface UserMapper {
      User selectPasswordByName(@Param(“userName”) String userName, @Param(“password”) String password);
      }
  2. 编写接口对应的Mapper.xml文件:UserMapper.xml

    select * from employee.user where user_name = #{userName} and password = #{password};

  3. 编写Department的Mapper接口:DepaertmentMapper

    package com.godfrey.mapper;

    import com.godfrey.pojo.Department;
    import org.apache.ibatis.annotations.Mapper;
    import org.springframework.stereotype.Repository;

    import java.util.List;

    /**

    • description : 部门Mapper

    • @author godfrey

    • @since 2020-05-26
      */
      @Mapper
      @Repository
      public interface DepartmentMapper {

      List selectAllDepartment();
      }

  4. 编写接口对应的Mapper.xml文件:DepaertmentMapper.xml

    select * from department;

  5. 编写Employee的Mapper接口:EmployeeMapper

    package com.godfrey.mapper;

    import com.godfrey.dto.EmployeeDTO;
    import com.godfrey.pojo.Employee;
    import org.apache.ibatis.annotations.Mapper;
    import org.apache.ibatis.annotations.Param;
    import org.springframework.stereotype.Repository;

    import java.util.List;

    /**

    • description : 员工Mapper

    • @author godfrey

    • @since 2020-05-26
      */
      @Mapper
      @Repository
      public interface EmployeeMapper {
      //查询全部员工信息
      List selectAllEmployeeDTO();

      //根据id查询员工信息
      Employee selectEmployeeById(@Param(“id”) Integer id);

      //添加一个员工信息
      int addEmployee(Employee employee);

      //修改一个员工信息
      int updateEmployee(Employee employee);

      //根据id删除员工信息
      int deleteEmployee(@Param(“id”) Integer id);
      }

  6. 编写接口对应的Mapper.xml文件:EmployeeMapper.xml

    select e.id, e.employee_name, e.email, e.gender, d.department_name, e.datefrom employee e, department dwhere e.department_id = d.id;select *from employeewhere id = #{id}insert into employee (id, employee_name, email, gender, department_id, date)values (#{id}, #{employeeName}, #{email}, #{gender}, #{departmentId}, #{date})update employeeset employee_name=#{employeeName},email=#{email},gender=#{gender},department_id=#{departmentId},date=#{date}where id = #{id}deletefrom employeewhere id = #{id}
Service层

com.wangqiang.service

  1. EmployeeService接口:

    package com.godfrey.service;

    import com.godfrey.dto.EmployeeDTO;
    import com.godfrey.pojo.Employee;

    import java.util.List;

    /**

    • description : 员工业务层接口
    • @author godfrey
    • @since 2020-05-26
      */
      public interface EmployeeService {
      //查询全部员工信息
      List selectAllEmployeeDTO();
      //根据id查询员工信息
      Employee selectEmployeeById(int id);
      //添加一个员工信息
      int addEmployee(Employee employee);
      //修改一个员工信息
      int updateEmployee(Employee employee);
      //根据id删除员工信息
      int deleteEmployee(int id);
      }
  2. EmployeeServiceImpl实现类:

    package com.godfrey.service.impl;

    import com.godfrey.dto.EmployeeDTO;
    import com.godfrey.mapper.EmployeeMapper;
    import com.godfrey.pojo.Employee;
    import com.godfrey.service.EmployeeService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;

    import java.util.List;

    /**

    • description : 员工业务层实现类

    • @author godfrey

    • @since 2020-05-26
      */
      @Service
      public class EmployeeServiceImpl implements EmployeeService {
      @Autowired
      private EmployeeMapper employeeMapper;

      @Override
      public List selectAllEmployeeDTO() {
      return employeeMapper.selectAllEmployeeDTO();
      }

      @Override
      public Employee selectEmployeeById(int id) {
      return employeeMapper.selectEmployeeById(id);
      }

      @Override
      public int addEmployee(Employee employee) {
      return employeeMapper.addEmployee(employee);
      }

      @Override
      public int updateEmployee(Employee employee) {
      return employeeMapper.updateEmployee(employee);
      }

      @Override
      public int deleteEmployee(int id) {
      return employeeMapper.deleteEmployee(id);
      }
      }

  3. DepartmentService接口

    package com.godfrey.service;

    import com.godfrey.pojo.Department;

    import java.util.List;

    /**

    • description : DepartmentService
    • @author godfrey
    • @since 2020-05-27
      */
      public interface DepartmentService {
      List selectAllDepartment();
      }
  4. DepartmentImpl实现类:

    package com.godfrey.service.impl;

    /**

    • description : DepartmentServiceImpl
    • @author godfrey
    • @since 2020-05-27
      */

    import com.godfrey.mapper.DepartmentMapper;
    import com.godfrey.pojo.Department;
    import com.godfrey.service.DepartmentService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;

    import java.util.List;

    @Service
    public class DepartmentServiceImpl implements DepartmentService {

    @Autowiredprivate DepartmentMapper departmentMapper;@Overridepublic List selectAllDepartment() {return departmentMapper.selectAllDepartment();}

    }

  5. UserService接口

    package com.godfrey.service;

    import com.godfrey.pojo.User;

    /**

    • description : User业务层
    • @author godfrey
    • @since 2020-05-26
      */
      public interface UserService {
      User selectPasswordByName(String userName, String password);
      }
  6. UserServiceImpl实现类

    package com.godfrey.service.impl;

    import com.godfrey.mapper.UserMapper;
    import com.godfrey.pojo.User;
    import com.godfrey.service.UserService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;

    /**

    • description : UserServiceImpl

    • @author godfrey

    • @since 2020-05-26
      */
      @Service
      public class UserServiceImpl implements UserService {
      @Autowired
      private UserMapper userMapper;

      @Override
      public User selectPasswordByName(String userName, String password) {
      return userMapper.selectPasswordByName(userName, password);
      }
      }

  7. 测试获取数据情况

    @Autowired
    EmployeeService employeeService;

    @Test
    public void test(){
    List employees = employeeService.selectAllEmployeeDTO();
    for (EmployeeDTO employee : employees) {
    System.out.println(employee);
    }
    }
    @Test
    public void test2(){
    Employee employee = employeeService.selectEmployeeById(1);
    System.out.println(employee);
    //Employee(id=1, employeeName=张三, email=zhangsan@gmail.com, gender=0, departmentId=1, date=2020-02-12)
    }

    @Test
    public void test3(){
    Employee employee = new Employee();
    employee.setId(6);
    employee.setEmployeeName(“test”);
    employee.setEmail(“123@qq.com”);
    employee.setDepartmentId(2);
    Date date = new Date(2020-02-02);
    employee.setDate(date);
    employeeService.addEmployee(employee);
    Employee employee1 = employeeService.selectEmployeeById(6);
    System.out.println(employee1);
    //Employee(id=6, employeeName=test, email=123@qq.com, gender=0, departmentId=2, date=1970-01-01)
    }

    @Test
    public void test4(){
    Employee employee = new Employee();
    employee.setId(6);
    employee.setEmployeeName(“test”);
    employee.setEmail(“123@qq.com”);
    employee.setDepartmentId(3);
    Date date = new Date(2020-02-02);
    employee.setDate(date);
    employeeService.updateEmployee(employee);
    Employee employee1 = employeeService.selectEmployeeById(6);
    System.out.println(employee1);
    //Employee(id=6, employeeName=test, email=123@qq.com, gender=0, departmentId=3, date=1970-01-01)
    }

    @Test
    public void test05(){
    employeeService.deleteEmployee(6);
    }

    @Autowired
    private UserService userService;
    @Test
    public void test06(){
    User admin = userService.selectPasswordByName(“admin”,“123456”);
    System.out.println(admin);
    //User(id=1, name=admin, password=123456)
    }

    @Autowired
    private DepartmentService departmentService;
    @Test
    public void test07(){
    List departments = departmentService.selectAllDepartment();
    for (Department department : departments) {
    System.out.println(department);
    }
    }

Controller层
  1. 登陆页LoginController

    package com.godfrey.controller;

    import com.godfrey.pojo.User;
    import com.godfrey.service.UserService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Controller;
    import org.springframework.ui.Model;
    import org.springframework.web.bind.annotation.GetMapping;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.RequestParam;

    import javax.servlet.http.HttpSession;

    /**

    • description : 登录Controller

    • @author godfrey

    • @since 2020-05-26
      */
      @Controller
      public class LoginController {

      @Autowired
      private UserService userService;

      @RequestMapping(“/login”)
      public String login(@RequestParam(“username”)String username,
      @RequestParam(“password”)String password,
      HttpSession session,
      Model model){
      User user = userService.selectPasswordByName(username, password);
      if ( user != null){
      //登录成功!
      session.setAttribute(“username”,user.getUserName());
      //登录成功!防止表单重复提交,我们重定向
      return “redirect:/main.html”;
      }else {
      //登录失败!存放错误信息
      model.addAttribute(“msg”,“用户名或密码错误”);
      return “index”;
      }
      }

      @GetMapping(“/user/loginOut”)
      public String loginOut(HttpSession session){
      session.invalidate();
      return “redirect:/index.html”;
      }
      }

  2. 员工信息Controller

    package com.godfrey.controller;

    import com.godfrey.dto.EmployeeDTO;
    import com.godfrey.pojo.Department;
    import com.godfrey.pojo.Employee;
    import com.godfrey.service.DepartmentService;
    import com.godfrey.service.EmployeeService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Controller;
    import org.springframework.ui.Model;
    import org.springframework.web.bind.annotation.GetMapping;
    import org.springframework.web.bind.annotation.PathVariable;
    import org.springframework.web.bind.annotation.PostMapping;

    import java.util.Collection;

    /**

    • description : EmployeeController

    • @author godfrey

    • @since 2020-05-26
      */
      @Controller
      public class EmployeeController {

      @Autowired
      private EmployeeService employeeService;

      @Autowired
      private DepartmentService departmentService;

      //查询所有员工,返回列表页面
      @GetMapping(“/emp”)
      public String list(Model model){
      Collection employees = employeeService.selectAllEmployeeDTO();
      // 将结果放在请求中
      model.addAttribute(“emps”,employees);
      return “emp/list.html”;
      }

      //to员工添加页面
      @GetMapping(“/add”)
      public String toAdd(Model model){
      //查出所有的部门,提供选择
      Collection departments = departmentService.selectAllDepartment();
      model.addAttribute(“departments”,departments);
      return “emp/add.html”;
      }

      //员工添加功能,使用post接收
      @PostMapping(“/add”)
      public String add(Employee employee){
      //保存员工信息
      employeeService.addEmployee(employee);
      //回到员工列表页面,可以使用redirect或者forward
      return “redirect:/emp”;
      }

      //to员工修改页面
      @GetMapping(“/emp/{id}”)
      public String toUpdateEmp(@PathVariable(“id”) Integer id, Model model){
      //根据id查出来员工
      Employee employee = employeeService.selectEmployeeById(id);
      //将员工信息返回页面
      model.addAttribute(“emp”,employee);
      //查出所有的部门,提供修改选择
      Collection departments = departmentService.selectAllDepartment();
      model.addAttribute(“departments”,departments);

       return "emp/update.html";

      }

      @PostMapping(“/updateEmp”)
      public String updateEmp(Employee employee){
      employeeService.updateEmployee(employee);
      //回到员工列表页面
      return “redirect:/emp”;
      }

      @GetMapping(“/delEmp/{id}”)
      public String deleteEmp(@PathVariable(“id”)Integer id){
      //根据id删除员工
      employeeService.deleteEmployee(id);
      return “redirect:/emp”;
      }
      }

完善Config文件
  1. 编写Interceptor拦截器配置

    package com.godfrey.config;

    import org.springframework.web.servlet.HandlerInterceptor;

    import javax.servlet.http.HttpServletRequest;
    import javax.servlet.http.HttpServletResponse;

    /**

    • description : Interceptor登录拦截器
    • @author godfrey
    • @since 2020-05-26
      */
      public class MyHandlerInterceptor implements HandlerInterceptor {
      @Override
      public boolean preHandle(HttpServletRequest request, HttpServletResponse response, Object handler) throws Exception {
      Object username = request.getSession().getAttribute(“username”);
      if (username == null) {//未登录,返回登录页面
      request.setAttribute(“msg”, “没有权限,请先登录”);
      request.getRequestDispatcher(“/index.html”).forward(request, response);
      return false;
      } else {//登录,放行
      return true;
      }
      }
      }
  2. 编写国际化配置文件

    package com.godfrey.config;

    import org.springframework.util.StringUtils;
    import org.springframework.web.servlet.LocaleResolver;

    import javax.servlet.http.HttpServletRequest;
    import javax.servlet.http.HttpServletResponse;
    import java.util.Locale;

    /**

    • description : 国际化语言解析器

    • @author godfrey

    • @since 2020-05-26
      */
      public class MyLocaleResolver implements LocaleResolver {
      //解析请求
      @Override
      public Locale resolveLocale(HttpServletRequest httpServletRequest) {
      //获取请求中的语言参数
      String language = httpServletRequest.getParameter(“lang”);
      Locale locale = Locale.getDefault();//如果没有就使用默认的
      if(!StringUtils.isEmpty(language)){
      String[] split = language.split(“_”);
      locale = new Locale(split[0],split[1]);
      }
      return locale;
      }

      @Override
      public void setLocale(HttpServletRequest httpServletRequest, HttpServletResponse httpServletResponse, Locale locale) {

      }
      }

  3. 编写WebMvc文件,将上述配置到MvcConfiguration中

    package com.godfrey.config;

    import org.springframework.context.annotation.Bean;
    import org.springframework.context.annotation.Configuration;
    import org.springframework.web.servlet.LocaleResolver;
    import org.springframework.web.servlet.config.annotation.InterceptorRegistry;
    import org.springframework.web.servlet.config.annotation.ViewControllerRegistry;
    import org.springframework.web.servlet.config.annotation.WebMvcConfigurer;

    /**

    • description : 扩展MVC配置

    • @author godfrey

    • @since 2020-05-26
      */
      @Configuration
      public class MyWebMvcConfig implements WebMvcConfigurer {
      @Override
      public void addViewControllers(ViewControllerRegistry registry) {
      registry.addViewController(“/”).setViewName(“index”);
      registry.addViewController(“/index.html”).setViewName(“index”);
      registry.addViewController(“/main.html”).setViewName(“main”);
      }

      //自定义国际化组件
      @Bean
      public LocaleResolver localeResolver(){
      return new MyLocaleResolver();
      }

      @Override
      public void addInterceptors(InterceptorRegistry registry) {
      registry.addInterceptor(new MyHandlerInterceptor())
      .addPathPatterns(“/“)
      .excludePathPatterns(”/“,”/index.html”,“/login”,”/css/
      ”,“/js/“,”/img/”);
      }
      }

前端视图
  1. 登陆页index.html

    Signin Template for Bootstrap

    Please sign in

    © 2017-2018

    中文English
  2. 系统管理页 main.html

    Dashboard Template for Bootstrap/* Chart.js */@-webkit-keyframes chartjs-render-animation {from {opacity: 0.99}to {opacity: 1}}@keyframes chartjs-render-animation {from {opacity: 0.99}to {opacity: 1}}.chartjs-render-monitor {-webkit-animation: chartjs-render-animation 0.001s;animation: chartjs-render-animation 0.001s;}

    Dashboard