Spring Boot模拟数据库实现CURD

application.properties

#关闭thymeleaf缓存
spring.thymeleaf.cache=false

#配置文件
spring.messages.basename=i18n.login

#日期格式化
spring.mvc.format.date=yyyy-MM-dd

config包

LoginHandlerInterceptor类

package com.yuan.config;
import org.springframework.web.servlet.HandlerInterceptor;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
 * 拦截器
 */
public class LoginHandlerInterceptor implements HandlerInterceptor {
    @Override
    public boolean preHandle(HttpServletRequest request, HttpServletResponse response, Object handler) throws Exception {
        //获取Session
        Object loginUser = request.getSession().getAttribute("LoginUser");
        if (loginUser == null) {
            request.setAttribute("msg","未登录，请先登录");
            request.getRequestDispatcher("/login.html").forward(request, response);
            return false;
        }else {
            return true;
        }
    }
}

MyLocaleResolver类

package com.yuan.config;
import org.springframework.web.servlet.LocaleResolver;
import org.thymeleaf.util.StringUtils;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.util.Locale;
/**
 * 国际化
 */
public class MyLocaleResolver implements LocaleResolver {
    //解析请求
    @Override
    public Locale resolveLocale(HttpServletRequest request) {
       //获取请求的语言的参数
        String language=request.getParameter("1");
        Locale locale=Locale.getDefault();
        //如果请求的连接携带了国际化的参数
        if (!StringUtils.isEmpty(language)){
            //zh_CH
            String[] split = language.split("_");
            //国家，地区
            locale=new Locale(split[0], split[1]);
        }
        return locale;
    }
    @Override
    public void setLocale(HttpServletRequest request, HttpServletResponse response, Locale locale) {

    }
}

MyMvcConfig类

package com.yuan.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;
/**
 * 定制Spring Boot
 */
@Configuration
public class MyMvcConfig implements WebMvcConfigurer {
    @Override
    public void addViewControllers(ViewControllerRegistry registry) {
        registry.addViewController("/").setViewName("login");
        registry.addViewController("/login.html").setViewName("login");
        registry.addViewController("/main.html").setViewName("index");
    }
    //注册
    @Bean
    public LocaleResolver localeResolver() {
        return new MyLocaleResolver();
    }
    //拦截器配置
    public void addInterceptors(InterceptorRegistry registry) {
        registry.addInterceptor(new LoginHandlerInterceptor()).addPathPatterns("/**")//拦截所有请求，包括静态资源文件
                .excludePathPatterns("/login.html","/","/user/login","/assets/**","/Css/**","/front/**","/Images/**","/Js/**");//放行登录页，登陆操作，静态资源
    }
}

controller包

EmployeeController类

package com.yuan.controller;
import com.yuan.mapper.DepartmentMapper;
import com.yuan.mapper.EmployeeMapper;
import com.yuan.pojo.Department;
import com.yuan.pojo.Employee;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.*;
import java.util.Collection;
@Controller
public class EmployeeController {

     @Autowired
     private EmployeeMapper employe;

     @Autowired
     public DepartmentMapper department;
    /**
     * 查询所员工
     * @param model
     * @return
     */
    @RequestMapping("/emps")
    public String Employee(Model model){
        Collection<Employee> allEmployee = employe.getAllEmployee();
        model.addAttribute("employee",allEmployee);
        return "/emp/Employees";
    }

    /**
     * 新增员工
     * @param model
     * @return
     */
    @GetMapping("/empAdd")
    public String empAdds(Model model){
        departments(model);//调用提取的方法
        return "/emp/add";
    }

    /**
     * 提取部门员工部门为一个方法
     * @param model
     */
    private void departments(Model model) {
        //查询员工部门信息
        Collection<Department> departmentSet = department.getDepartmentSet();
        model.addAttribute("departmentSet",departmentSet);
    }

    //新增员工
    @PostMapping("/empAdd")
    public String empAdds(Employee employee){
        employe.save(employee);//保存员工信息
        return "redirect:/emps";
    }
    //查询修改的员工
    @GetMapping("empUpdate{id}")
    public String empUpdate(@PathVariable("id") Integer id,Model model){
        Employee employee= employe.getEmployeeById(id);
        model.addAttribute("emp",employee);
        departments(model);//调用提取的方法
         return "emp/Update";
    }
    //开始执行修改
    @PostMapping("ToUpdate")
   public String ToUpdate(Employee employee){
        employe.save(employee);
        return "redirect:/emps";
   }
   //删除员工
    @RequestMapping("/empDelete{id}")
    public String empDelete(@PathVariable("id") Integer id){
        employe.delete(id);
        return "redirect:/emps";
    }
}

LoginController类

package com.yuan.controller;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import javax.servlet.http.HttpSession;
@Controller
public class LoginController {
    /**
     * 登录
     */
    @RequestMapping("/user/login")
    public String Login(@RequestParam("username") String username,
                        @RequestParam("password") String password,
                        Model model,
                        HttpSession session){
        if(!"".equals(username)&&"123456".equals(password)){
            session.setAttribute("LoginUser",username);
            return "redirect:/main.html";
        }else {
            model.addAttribute("msg","用户名或密码错误");
            return "login";
        }
    }
    /**
     * 注销
     * @param session
     * @return
     */
    @RequestMapping("/user/logout")
    public String logout(HttpSession session){
        session.invalidate();
      return "redirect/login.html";

    }
}

mapper包

DepartmentMapper类

package com.yuan.mapper;
import com.yuan.pojo.Department;
import org.springframework.stereotype.Repository;
import java.util.Collection;
import java.util.HashMap;
import java.util.Map;

//部门mapper
@Repository
public class DepartmentMapper {
  //模拟数据库的数据
    private static Map<Integer, Department> departmentMap=null;//创建一个部门
    static {
        departmentMap = new HashMap<>();
        departmentMap.put(101,new Department(101,"教学部"));
        departmentMap.put(102,new Department(102,"市场部"));
        departmentMap.put(103,new Department(103,"教研部"));
        departmentMap.put(104,new Department(104,"运维部"));
        departmentMap.put(105,new Department(105,"后勤部"));
    }
    //获得部门所有信息
    public Collection<Department> getDepartmentSet(){
        return departmentMap.values();
    }
    //通过id得到部门
    public Department getDepartmentBtId(Integer id) {
         return departmentMap.get(id);
    }
}

EmployeeMapper类

package com.yuan.mapper;
import com.yuan.pojo.Department;
import com.yuan.pojo.Employee;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;
import java.util.Collection;
import java.util.HashMap;
import java.util.Map;
//员工Mapper
@Repository
public class EmployeeMapper {
    //模拟员中的数据
    private static Map<Integer, Employee> employe=null;
    //员工所属的部门
    @Autowired
    private DepartmentMapper departmentMapper;

    static {
        employe = new HashMap<>();
         employe.put(1001,new Employee(1001,"aa","11213342@qq.com",1,new Department(101,"教学部")));
        employe.put(1002,new Employee(1002,"bb","11213343@qq.com",0,new Department(102,"市场部")));
        employe.put(1003,new Employee(1003,"cc","11213312@qq.com",1,new Department(103,"教研部")));
        employe.put(1004,new Employee(1004,"dd","11213312@qq.cm",0,new Department(104,"运维部")));
        employe.put(1005,new Employee(1005,"ee","11213302@qq.com",1,new Department(105,"后勤部")));
    }
     //注解自增
     private static Integer iniId=1006;
    //增加一个员工
    public void save(Employee employee){
        if(employee.getId() == null){
            employee.setId(iniId++);
        }
        employee.setDepartment(departmentMapper.getDepartmentBtId(employee.getDepartment().getId()));
        employe.put(employee.getId(),employee);
    }
    //查询所有员工
    public Collection<Employee> getAllEmployee(){
        return employe.values();
    }

    //通过id查询员工
    public Employee getEmployeeById(Integer id){
        return employe.get(id);
    }
    //通过id删除员工信息
    public void delete(Integer id) {
        employe.remove(id);
    }
}

pojo包

Department类

package com.yuan.pojo;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

//部门表
@Data
@NoArgsConstructor
@AllArgsConstructor
public class Department {
    private Integer id;
    private String DepartmentName;
}

Employee类

package com.yuan.pojo;
import lombok.Data;
import lombok.NoArgsConstructor;
import java.util.Date;
//员工表
@Data
@NoArgsConstructor
public class Employee {
  private  Integer id;
  private String LastName;
  private String email;
  private Integer gender;//0 ：女1：男
   private Department department;
   private Date bility;
    public Employee(Integer id, String lastName, String email, Integer gender, Department department) {
        this.id = id;
        LastName = lastName;
        this.email = email;
        this.gender = gender;
        this.department = department;
        this.bility=new Date();
    }
}

resources下的配置文件

i18n包

login.properties

login.tip=登录系统
login.username=用户名
login.pwd=密码
login.submit=登录

login_en_US.properties

login.tip=Login System
login.username=username
login.pwd=password
login.submit=submit

login_zh_CN.properties

login.tip=登录系统
login.username=用户名
login.pwd=密码
login.submit=登录

templates包

login.html

<!DOCTYPE html>
<html xmlns:th="http://www.thymeleaf.org">
<head>
    <title>后台管理系统</title>
	<meta charset="UTF-8">
   <link rel="stylesheet" type="text/css" th:href="@{../Css/bootstrap.css}"/>
    <link rel="stylesheet" type="text/css" th:href="@{../Css/bootstrap-responsive.css}" />
    <link rel="stylesheet" type="text/css" th:href="@{../Css/style.css}" />
    <script type="text/javascript" th:src="@{../Js/jquery.js}"></script>
    <script type="text/javascript" th:src="@{../Js/jquery.sorted.js}"></script>
    <script type="text/javascript" th:src="@{../Js/bootstrap.js}"></script>
    <script type="text/javascript" th:src="@{../Js/ckform.js}"></script>
    <script type="text/javascript" th:src="@{../Js/common.js}"></script>
    <style type="text/css">
        body {
            padding-top: 40px;
            padding-bottom: 40px;
            background-color: #f5f5f5;
        }
        .form-signin {
            max-width: 300px;
            padding: 19px 29px 29px;
            margin: 0 auto 20px;
            background-color: #fff;
            border: 1px solid #e5e5e5;
            -webkit-border-radius: 5px;
            -moz-border-radius: 5px;
            border-radius: 5px;
            -webkit-box-shadow: 0 1px 2px rgba(0, 0, 0, .05);
            -moz-box-shadow: 0 1px 2px rgba(0, 0, 0, .05);
            box-shadow: 0 1px 2px rgba(0, 0, 0, .05);
        }
        .form-signin .form-signin-heading,
        .form-signin .checkbox {
            margin-bottom: 10px;
        }
        .form-signin input[type="text"],
        .form-signin input[type="password"] {
            font-size: 16px;
            height: auto;
            margin-bottom: 15px;
            padding: 7px 9px;
        }
    </style>  
</head>
<body>
<div class="container">
    <form class="form-signin" method="post" th:action="@{/user/login}">
        <h2 class="form-signin-heading" th:text="#{login.tip}">Login System</h2>
        <!--如果msg不为空输出-->
        <p style="color: red" th:text="${msg}" th:if="${not #strings.isEmpty(msg)}"></p>
        <input type="text" name="username" class="input-block-level" th:placeholder="#{login.username}" required>
        <input type="password" name="password" class="input-block-level" th:placeholder="#{login.pwd}" required>
        <p><button class="btn btn-large btn-primary" type="submit">[[#{login.submit}]]</button></p>
        <p> <a class="" th:href="@{/login.html(1='zh_CN')}">中文</a>
            <a class="" th:href="@{/login.html(1='en_US')}">English</a>
        </p>
    </form>
</div>
</body>
</html>

index.html

<!DOCTYPE HTML>
<html xmlns:th="http://www.thymeleaf.org">
<head>
    <title>后台管理系统</title>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <link href="assets/css/dpl-min.css" rel="stylesheet" type="text/css" />
    <link href="assets/css/bui-min.css" rel="stylesheet" type="text/css" />
    <link href="assets/css/main-min.css" rel="stylesheet" type="text/css" />
</head>
<body>

<div class="header">

    <div class="dl-title">

    </div>
    <div class="dl-log">欢迎您，<span class="dl-log-user">[[${session.LoginUser}]]</span><a href="login.html">[退出]</a><a th:href="@{/user/logout}">注销</a>
    </div>
</div>
<div class="content">
    <div class="dl-main-nav">
        <div class="dl-inform"><div class="dl-inform-title"><s class="dl-inform-icon dl-up"></s></div></div>
        <ul id="J_Nav"  class="nav-list ks-clear">
            <li class="nav-item dl-selected"><div class="nav-item-inner nav-home">系统管理</div></li>		<li class="nav-item dl-selected"><div class="nav-item-inner nav-order">业务管理</div></li>

        </ul>
    </div>
    <ul id="J_NavContent" class="dl-tab-conten">

    </ul>
</div>
<script type="text/javascript" src="assets/js/jquery-1.8.1.min.js"></script>
<script type="text/javascript" src="assets/js/bui-min.js"></script>
<script type="text/javascript" src="assets/js/common/main-min.js"></script>
<script type="text/javascript" src="assets/js/config-min.js"></script>
<script>
    BUI.use('common/main',function(){
        var config = [{id:'1',menu:[{text:'系统管理',items:[
            {id:'12',text:'员工管理',href:'/emps'}
            ]}]}];
        new PageUtil.MainPage({
            modulesConfig : config
        });
    });
</script>
</div>
</body>
</html>

Employees.html

<!DOCTYPE html>
<html xmlns:th="http://www.thymeleaf.org">
<head>
    <title></title>
    <meta charset="UTF-8">
    <link rel="stylesheet" type="text/css" th:href="@{../Css/bootstrap.css}" />
    <link rel="stylesheet" type="text/css" th:href="@{../Css/bootstrap-responsive.css}" />
    <link rel="stylesheet" type="text/css" th:href="@{../Css/style.css}" />
    <script type="text/javascript" th:src="@{../Js/jquery.js}"></script>
    <script type="text/javascript" th:src="@{../Js/jquery.sorted.js}"></script>
    <script type="text/javascript" th:src="@{../Js/bootstrap.js}"></script>
    <script type="text/javascript" th:src="@{../Js/ckform.js}"></script>
    <script type="text/javascript" th:src="@{../Js/common.js}"></script>
    <style type="text/css">
        body {
            padding-bottom: 40px;
        }
        .sidebar-nav {
            padding: 9px 0;
        }
        @media (max-width: 980px) {
            /* Enable use of floated navbar text */
            .navbar-text.pull-right {
                float: none;
                padding-left: 5px;
                padding-right: 5px;
            }
        }
    </style>
</head>
<body>
<form class="form-inline definewidth m20" action="../index.html" method="get">
    用户名称：
    <input type="text" name="username" id="username"class="abc input-default" placeholder="" value="">&nbsp;&nbsp;  
    <button type="submit" class="btn btn-primary">查询</button>&nbsp;&nbsp; <button type="button" class="btn btn-success" ><a th:href="@{../empAdd}" style="color: #FFFFFF">新增用户</a></button>
</form>
<table class="table table-bordered table-hover definewidth m10">
    <thead>
    <tr>
        <th>编号</th>
        <th>姓名</th>
        <th>邮箱</th>
        <th>性别</th>
        <th>部门</th>
        <th>初始日期</th>
        <th>操作</th>
    </tr>
    </thead>
	     <tr th:each="emp:${employee}">
             <td th:text="${emp.getId()}"></td>
             <td th:text="${emp.getLastName()}"></td>
             <td th:text="${emp.getEmail()}"></td>
             <td th:text="${emp.getGender()==1?'男':'女'}"></td>
             <td th:text="${emp.getDepartment().departmentName}"></td>
             <td th:text="${#dates.format(emp.getBility(),'yyyy-MM-dd')}"></td>
            <td>
                <a th:href="@{/empUpdate}+${emp.getId()}">编辑</a>&nbsp;&nbsp;|&nbsp;&nbsp;
                <a th:href="@{/empDelete}+${emp.getId()}">删除</a>
            </td>
        </tr>	
</table>
</body>
</html>

add.html

<!DOCTYPE html>
<html  xmlns:th="http://www.thymeleaf.org">
<head>
    <title></title>
    <link href= "https://cdn.staticfile.org/twitter-bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet">
    <meta charset="UTF-8">
    <style type="text/css">
        body {
            padding-bottom: 40px;
        }
        .sidebar-nav {
            padding: 9px 0;
        }

        @media (max-width: 980px) {
            /* Enable use of floated navbar text */
            .navbar-text.pull-right {
                float: none;
                padding-left: 5px;
                padding-right: 5px;
            }
        }
    </style>
</head>
<body>
<form class="form-horizontal" style="margin: 20px 50px;width: 500px" method="post" action="/empAdd">
    <div class="form-group">
        <label for="" class="col-sm-2 control-label">Name:</label>
        <div class="col-sm-10">
            <input type="text" class="form-control" name="LastName" placeholder="Name" required>
        </div>
    </div>
    <div class="form-group">
        <label for="" class="col-sm-2 control-label">Email:</label>
        <div class="col-sm-10">
            <input type="email" class="form-control" name="email" placeholder="Email" required>
        </div>
    </div>
    <div class="form-group">
        <label for="" class="col-sm-2 control-label">Gender:</label>
        <div class="col-sm-10">
        <label class="radio-inline">
            <input type="radio"  name="gender" value="1"> 男
        </label>
        <label class="radio-inline">
            <input type="radio" name="gender" value="0"> 女
        </label>
        </div>
    </div>
    <div class="form-group">
        <label for="" class="col-sm-2 control-label">Department:</label>
        <div class="col-sm-10">
        <select class="form-control" name="department.id">
            <option th:each="dep:${departmentSet}" th:text="${dep.getDepartmentName()}" th:value="${dep.getId()}"></option>
        </select>
        </div>
    </div>
    <div class="form-group">
        <label for="" class="col-sm-2 control-label">bility:</label>
        <div class="col-sm-10">
            <input type="text" class="form-control" name="bility" placeholder="bility" required>
        </div>
    </div>
    <div class="form-group">
        <div class="col-sm-offset-2 col-sm-10">
            <button type="submit" class="btn btn-primary">submit</button>
        </div>
    </div>
</form>

</body>
</html>

Update.html

<!DOCTYPE html>
<html  xmlns:th="http://www.thymeleaf.org">
<head>
    <title></title>
    <link href= "https://cdn.staticfile.org/twitter-bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet">
    <meta charset="UTF-8">
    <style type="text/css">
        body {
            padding-bottom: 40px;
        }
        .sidebar-nav {
            padding: 9px 0;
        }

        @media (max-width: 980px) {
            /* Enable use of floated navbar text */
            .navbar-text.pull-right {
                float: none;
                padding-left: 5px;
                padding-right: 5px;
            }
        }


    </style>
</head>
<body>

<form class="form-horizontal" style="margin: 20px 50px;width: 500px" method="post" action="/empAdd">
        <input type="hidden" class="form-control" name="id" placeholder="id"  th:value="${emp.getId()}" required >

    <div class="form-group">
        <label for="" class="col-sm-2 control-label">Name:</label>
        <div class="col-sm-10">
            <input type="text" class="form-control" name="LastName" placeholder="Name"  th:value="${emp.getLastName()}" required>
        </div>
    </div>
    <div class="form-group">
        <label for="" class="col-sm-2 control-label">Email:</label>
        <div class="col-sm-10">
            <input type="email" class="form-control" name="email" placeholder="Email" th:value="${emp.getEmail()}" required>
        </div>
    </div>
    <div class="form-group">
        <label for="" class="col-sm-2 control-label">Gender:</label>
        <div class="col-sm-10">
        <label class="radio-inline">
            <input type="radio"  name="gender" value="1" th:checked="${emp.getGender()==1}"> 男
        </label>
        <label class="radio-inline">
            <input type="radio" name="gender" value="0" th:checked="${emp.getGender()==0}"> 女
        </label>
        </div>
    </div>
    <div class="form-group">
        <label for="" class="col-sm-2 control-label">Department:</label>
        <div class="col-sm-10">
        <select class="form-control" name="department.id">
            <option th:selected="${dep.getId()==emp.getDepartment().getId()}" th:each="dep:${departmentSet}"  th:text="${dep.getDepartmentName()}" th:value="${dep.getId()}"></option>
        </select>
        </div>
    </div>
    <div class="form-group">
        <label for="" class="col-sm-2 control-label">bility:</label>
        <div class="col-sm-10">
            <input type="text" class="form-control" name="bility" th:value="${#dates.format(emp.getBility(),'yyyy-MM-dd')}"  placeholder="bility" required>
        </div>
    </div>
    <div class="form-group">
        <div class="col-sm-offset-2 col-sm-10">
            <button type="submit" class="btn btn-primary">submit</button>
        </div>
    </div>
</form>

</body>
</html>