SpringBoot+Mybatis+Mysql环境简单搭建

记录自己搭建环境的过程，避免以后搭建环境时忘记配置代码，减少找bug时间。

一、搭建简单SpringBoot环境

1.创建Maven项目

修改Maven库配置

2.编写pom.xml文件

	<!--父依赖-->
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.3.4.RELEASE</version>
    </parent>
    <dependencies>
    	<!--支持web-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter</artifactId>
        </dependency>
    </dependencies>

3.配置application.yml文件

server:
  port: 8082
  servlet:
    context-path: /

4.编写启动文件

在项目主包下创建ChargeApplication文件

package com.individual.charge;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
public class ChargeApplication {
    public static void main(String[] args) {
        SpringApplication.run(ChargeApplication.class, args);
    }
}

5.编写测试controller

import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.bind.annotation.RestController;

@RestController
public class TestController {

    @RequestMapping("/test")
    @ResponseBody
    public String test(@RequestParam("name") String name) {
        return name;
    }
}

6.运行启动文件ChargeApplication

在浏览器地址栏输入http://127.0.0.1:8082/test/input?name=myName

7.一个简单的SpringBoot项目启动

二、搭建连接数据库环境

1.添加pom

<!--父依赖-->
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.3.4.RELEASE</version>
    </parent>
    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter</artifactId>
        </dependency>
        <!--集成mmybatis-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.3</version>
        </dependency>
        <!--sql驱动-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <!--连接池-->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.10</version>
        </dependency>
        <!--需要idea安装lombok插件-->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
        </dependency>
    </dependencies>

2.添加application.yml文件

server:
  port: 8082
  servlet:
    context-path: /
spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://127.0.0.1:3306/charge?serverTimezone=UTC
    username: root
    password: root
    type: com.alibaba.druid.pool.DruidDataSource
mybatis:
  mapper-locations: classpath:mapper/*.xml
  type-aliases-package: com.qf.charge.entity
  configuration:
    map-underscore-to-camel-case: true

3.创建Mapper

在mapper包下创建ManageUserMapper接口文件

package com.individual.charge.mapper;

import com.individual.charge.entity.ManageUser;
import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface ManageUserMapper {
    /**
     * 新增用户
     * @param user
     * @return
     */
    public int insertUser(ManageUser user);
}

在resource/mapper下创建ManageUserMapper.xml文件

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.individual.charge.mapper.ManageUserMapper">
    <insert id="insertUser" parameterType="com.individual.charge.entity.ManageUser">
        insert into manage_user (id, account, `name`, room, role_id) values (#{id}, #{account}, #{name}, #{room}, #{roleId})
    </insert>
</mapper>

4.创建Service、Controller，Service透传略过

package com.individual.charge.controller;

import com.individual.charge.entity.ManageUser;
import com.individual.charge.service.ManageUserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

@RestController
@RequestMapping(value = "/test")
public class TestController {
    @Autowired
    private ManageUserService service;

    @GetMapping(value = "/insertUser")
    @ResponseBody
    public String insertUser(@ModelAttribute ManageUser user) {
        if (service.insertUser(user)) {
            return "添加成功！";
        } else {
            return "添加失败！";
        }
    }
}

注意Mapper和Service的@Service注解和@Mapper注解，否则启动SpringBoot时会报
Failed to destroy the filter named [Tomcat WebSocket (JSR356) Filter] of type [org.apache.tomcat.websocket.server.WsFilter]错误