SpringBoot-Web项目跟做（Web01）

随便贴一贴，跟着狂神的B站“SpringBoot”视频做的项目，期间许多细节问题，终究是学艺不精。

文件结构

• pojo层定义对象的基本属性
• service层定义并实现各种方法（函数）
• dao层（xxxMapper.java）提供"方法->SQL"的接口
  • mapper目录下xxxMapper.xml是各种方法的SQL实现
• controller层负责
  • 接收前端 请求/请求+数据
  • 调用service方法处理
  • 处理完成后给前端返回结果

个人理解：dao层的接口和SQL实现使得我们的数据能够保存在数据库中&从数据库中读取数据

文件目录

依赖

二话不说先导依赖

pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.5.6</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>com</groupId>
    <artifactId>web01</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>web01</name>
    <description>web01</description>
    <properties>
        <java.version>1.8</java.version>
    </properties>
    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-thymeleaf</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.1</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
                <configuration>
                    <excludes>
                        <exclude>
                            <groupId>org.projectlombok</groupId>
                            <artifactId>lombok</artifactId>
                        </exclude>
                    </excludes>
                </configuration>
            </plugin>
        </plugins>
    </build>

</project>

配置文件

application.properties

#我们的配置文件的真实位置
spring.messages.basename=i18n.login

spring.thymeleaf.cache=false

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

#整合数据库
spring.datasource.username=root
spring.datasource.password=095810
#添加时区信息以及编码信息
spring.datasource.url=jdbc:mysql://localhost:3306/mydatabase?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
#mybatis
mybatis.type-aliases-package=com.pojo
mybatis.mapper-locations=classpath:mybatis/mapper/*.xml

测试类

测试数据库是否连接成功，成功了再继续，当然要用到数据库还得先完成底层代码并写好接口等等

Web01ApplicationTests

package com;

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 Web01ApplicationTests {
    //DI注入数据源
    @Autowired
    DataSource dataSource;

    @Test
    public void contextLoads() throws SQLException {
        //看一下默认数据源
        System.out.println(dataSource.getClass());
        //获得连接
        Connection connection = dataSource.getConnection();
        System.out.println(connection);
        //关闭连接
        connection.close();
    }
}

pojo层

Department.java

package com.pojo;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

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

Employee.java

package com.pojo;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.util.Date;

//员工表
@Data
//@AllArgsConstructor
@NoArgsConstructor
public class Employee {
    private Integer id;
    private String lastName;
    private String email;
    private Integer gender;
    private Department department;
    private Date birth;

    public Employee(Integer id, String lastName ,String email,Integer gender, Department department){
        this.id = id;
        this.lastName = lastName;
        this.email = email;
        this.gender = gender;
        this.department = department;
        this.birth = new Date();
    }


}

service层

DepartmentService.java

package com.service;

import com.dao.DepartmentMapper;
import com.pojo.Department;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.Collection;

@Service
public class DepartmentService {

    @Autowired
    private DepartmentMapper departmentMapper;//报红不用管

    //获取所有部门
    public Collection<Department> getDepartments(){
        return departmentMapper.getDepartments();
    }
    //通过ID获取部门
    public Department getDepartmentById(Integer id){
        return departmentMapper.getDepartmentById(id);
    }
}

EmployeeService.java

package com.service;

import com.dao.EmployeeMapper;
import com.pojo.Employee;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.Collection;

@Service
public class EmployeeService {

    @Autowired
    private EmployeeMapper employeeMapper; //报红不用管
    //增加一位员工
    public void save(Employee employee){
        employeeMapper.save(employee);
    }

    //更新员工信息
    public void update(Employee employee){
        employeeMapper.update(employee);
    }

    //查询全部员工
    public Collection<Employee> getAll(){
        return employeeMapper.getAll();
    }

    //通过ID查询员工
    public Employee getEmployeeById(Integer id){
        return employeeMapper.getEmployeeById(id);
    }

    //通过ID删除一位员工
    public void deleteEmployeeById(Integer id){
        employeeMapper.deleteEmployeeById(id);
    }
}

dao层

两类mapper一起食用

DepartmentMapper.java

package com.dao;

import com.pojo.Department;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

//@Mapper : 表示本类是一个 MyBatis 的 Mapper
@Mapper
public interface DepartmentMapper {

    // 获取所有部门信息
    List<Department> getDepartments();

    // 通过id获得部门
    Department getDepartmentById(Integer id);

}

EmployeeMapper.java

package com.dao;

import com.pojo.Employee;
import org.apache.ibatis.annotations.Mapper;

import java.util.Collection;

@Mapper
public interface EmployeeMapper {

    //增加一位员工
    void save(Employee employee);

    //更新员工信息
    void update(Employee employee);

    //查询全部员工
    Collection<Employee> getAll();

    //通过ID查询员工
    Employee getEmployeeById(Integer id);

    //通过ID删除一位员工
    void deleteEmployeeById(Integer id);
}

DepartmentMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.dao.DepartmentMapper" >

    <select id="getDepartments" resultType="com.pojo.Department">
        SELECT * FROM department
    </select>

    <select id="getDepartmentById" resultType="com.pojo.Department" parameterType="int">
        SELECT * FROM department WHERE id=#{id}
    </select>
</mapper>

EmployeeMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.dao.EmployeeMapper" >

    <sql id="BASE_COLUMN">
        lastname,email,gender,departmentId,birth
    </sql>

    <!--×××× 结果映射   -->
    <resultMap id="EmployeeResultMap" type="Employee">
        <id property="id" column="id"/>
        <result property="lastName" column="lastname"/>
        <result property="email" column="email"/>
        <result property="gender" column="gender"/>
        <result property="department.id" column="departmentId"/>
        <result property="department.departmentName" column="departmentName"/>
        <result property="birth" column="birth"/>
    </resultMap>

    <select id="getAll" resultMap="EmployeeResultMap">
        SELECT * FROM employee,department WHERE employee.departmentId=department.id
    </select>

    <insert id="save" parameterType="Employee">
        INSERT INTO employee
        <trim prefix="(" suffix=")">
            <include refid="BASE_COLUMN"/>
        </trim>
        <trim prefix="VALUES(" suffix=")">
            #{lastName},#{email},#{gender},#{department.id},#{birth}
        </trim>
    </insert>

    <update id="update" parameterType="Employee">
        UPDATE employee
        <set>
            <if test="lastName != null">
                lastname = #{lastName},
            </if>
            <if test="email != null">
                email = #{email},
            </if>
            <if test="gender != null">
                gender = #{gender},
            </if>
            <if test="department.id != null">
                departmentId = #{department.id},
            </if>
            <if test="birth != null">
                birth = #{birth},
            </if>
        </set>
        <where>
            id=#{id}
        </where>
    </update>

    <select id="getEmployeeById" parameterType="int" resultMap="EmployeeResultMap">
        SELECT * FROM employee WHERE id=#{id}
    </select>

    <delete id="deleteEmployeeById" parameterType="int">
        DELETE FROM employee WHERE id=#{id}
    </delete>
</mapper>

controller层

DepartmentController.java

package com.controller;

import com.dao.DepartmentMapper;
import com.pojo.Department;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

@RestController
public class DepartmentController {

    @Autowired
    DepartmentMapper departmentMapper;

    // 查询全部部门
    @GetMapping("/getDepartments")
    public List<Department> getDepartments(){
        return departmentMapper.getDepartments();
    }

    // 查询全部部门
    @GetMapping("/getDepartment/{id}")
    public Department getDepartment(@PathVariable("id") Integer id){
        return departmentMapper.getDepartmentById(id);
    }
}

EmployeeController.java

package com.controller;


import com.dao.DepartmentMapper;
import com.pojo.Department;
import com.pojo.Employee;
import com.service.DepartmentService;
import com.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 org.springframework.web.bind.annotation.RequestMapping;

import javax.servlet.http.HttpSession;
import java.util.Collection;


@Controller
public class EmployeeController {

    @Autowired
    private DepartmentService departmentService;
    @Autowired
    private EmployeeService employeeService;

    @RequestMapping("/emps")
    public String list(Model model){
        Collection<Employee> employees = employeeService.getAll();
        model.addAttribute("emps",employees);
        return "emp/list";
    }

    @GetMapping("/emp")
    public String toAddpage(Model model){
        //查出所有部门
        Collection<Department> departments = departmentService.getDepartments();
        model.addAttribute("departments",departments);
        return "emp/add";
    }

    @PostMapping("/emp")
    public String Add(Employee employee){
        //添加操作
        System.out.println("save====>"+employee.toString());
        employeeService.save(employee);
        return "redirect:/emps";
    }

    @GetMapping("/emp/{id}")
    public String toUpdate(@PathVariable("id") Integer id,Model model){
        //查出原来的数据
        Employee employee = employeeService.getEmployeeById(id);
        model.addAttribute("emp",employee);
        //查出所有部门
        Collection<Department> departments = departmentService.getDepartments();
        System.out.println(departments.toString());
        model.addAttribute("departments",departments);
        return "emp/update";
    }

    @PostMapping("/emp/updateEmp")
    public String Update(Employee employee){
        employeeService.update(employee);
        return "redirect:/emps";
    }

    @RequestMapping("/delete/{id}")
    public String Delete(@PathVariable("id") Integer id){
        employeeService.deleteEmployeeById(id);
        return "redirect:/emps";
    }

    @RequestMapping("/out")
    public String loginOut(HttpSession session){
        session.removeAttribute("loginUser");
        return "redirect:/";
    }
}

LoginController.java

package com.controller;

import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
import org.thymeleaf.util.StringUtils;

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){

        //具体业务
        //登录名非空且密码为“123456”即可
        if (!StringUtils.isEmpty(username) && "123456".equals(password)){
            session.setAttribute("loginUser",username);
            return "redirect:/main.html";
        }else {
            //登陆失败
            model.addAttribute("msg","用户名或者密码错误");
            return "index";
        }
    }
    @RequestMapping("/user/logout")
    public String logout(HttpSession session){
        session.invalidate();
        return "redirect:/index.html";
    }
}

config

该目录下基本是前端的东西

LoginHandlerInterceptor.java

package com.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 {

        Object loginUser = request.getSession().getAttribute("loginUser");
        if (loginUser == null){
            request.setAttribute("msg","没有权限，请先登录");
            request.getRequestDispatcher("/index.html").forward(request,response);
            return false;
        }else {
            return true;
        }
    }
}

MylocaleResolver.java

package com.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 langue = request.getParameter("l");

        Locale locale = Locale.getDefault();
        if (!StringUtils.isEmpty(langue)){
            //字符串分割方法
            String[] split = langue.split("_");
            locale = new Locale(split[0], split[1]);
        }
        return locale;
    }

    @Override
    public void setLocale(HttpServletRequest request, HttpServletResponse response, Locale locale) {

    }
}

MymvcConfig.java

package com.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;


@Configuration
public class MymvcConfig implements WebMvcConfigurer{
    @Override
    public void addViewControllers(ViewControllerRegistry registry) {
        registry.addViewController("/").setViewName("index");
        registry.addViewController("index.html").setViewName("index");
        registry.addViewController("main.html").setViewName("dashboard");
    }

    @Bean
    //在配置文件中注册自己的重写组件
    public LocaleResolver localeResolver(){
        return new MylocaleResolver();
    }
    //为测试方便可暂时关闭拦截器
    @Override
    public void addInterceptors(InterceptorRegistry registry) {
        registry.addInterceptor(new LoginHandlerInterceptor())
                //拦截路径
                .addPathPatterns("/**")
                //排除以下路径
                .excludePathPatterns("/index.html","/","/user/login","/css/*","/img/*","/js/*");
    }
}

静态资源部分

略

链接：https://pan.baidu.com/s/18ECtCSXJcAA__MhLYAxyGQ
提取码：sy68

运行测试

用户：登录+注销

员工：增删改+List （未添加查找功能）