标签：scope   only   tee   gen   ogg   javascrip   assert   size   put   

项目地址：gitee github

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.2mysql
        mysql-connector-java
        runtimeorg.projectlombok
        lombok
        trueorg.springframework.boot
        spring-boot-starter-test
        testorg.junit.vintage
                junit-vintage-engine
            

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

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

4. 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

5. 测试数据库连接

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 {

    @Autowired
    DataSource dataSource;

    @Test
    void 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.date
        from employee e,
             department d
        where e.department_id = d.id;
    
        select *
        from employee
        where id = #{id}
    
        insert into employee (id, employee_name, email, gender, department_id, date)
        values (#{id}, #{employeeName}, #{email}, #{gender}, #{departmentId}, #{date})
    
        update employee
        set employee_name=#{employeeName},
            email=#{email},
            gender=#{gender},
            department_id=#{departmentId},
            date=#{date}
        where id = #{id}
    
        delete
        from employee
        where 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();
}

3. 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 {

    @Autowired
    private DepartmentMapper departmentMapper;

    @Override
    public List selectAllDepartment() {
        return departmentMapper.selectAllDepartment();
    }

}

4. 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);
}

5. 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);
    }
}

6. 测试获取数据情况

@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

	
Please sign in
	

	

		
			 [[#{login.remember}]]
		
	
	[[#{login.btn}]]
	
? 2017-2018
	中文
	English

2. 系统管理页 main.html

	











	

		
		
		


		

				

					

				
				

					

				
			
			

				
Dashboard
				

					

						Share
						Export
					
					
						
						This week
					
				
			
			

3. 公共页 /common/commons.html

3. 员工详情页 /emp/list.html

    










    

        


        
员工管理
            
            添加

            

                


序号
                        
姓名
                        
邮箱
                        
性别
                        
部门
                        
入职日期
                        
操作
                    


                        

                        

                        

                        

                        
                        

                        


                            编辑
                            删除
                        
                    


        

4. 添加员工页 /emp/add.html

    










    

        


        
添加员工信息
            

                

                    姓名
                    

                

                    邮箱
                    

                

                    性别
                    

                        男
                    
                    

                        女
                    
                
                

                    部门
                    
                    请选择
1

                

                    入职日期
                    


                提交
            
        

5. 修改员工页 /emp/update.html

    










    

        


        
修改员工信息
            

                

                    姓名
                    

                

                    邮箱
                    

                

                    性别

                        男
                    
                    

                        女
                    
                
                

                    部门
                    
                    1
                        

                

                    时间
                    

                修改
            
        

员工管理系统（SpringBoot+Mybatis+Thymeleaf）

标签：scope   only   tee   gen   ogg   javascrip   assert   size   put   &l