快速搭建Springboot+Mybatis+MySQL环境

1 创建工程

新建一个Maven工程

选择项目路径和信息：

项目目录结构：

2 添加依赖

2.1 添加父工程坐标

spring-boot-starter-parent
Spring Boot提供了一个名为spring-boot-starter-parent的工程，里面已经对各种常用依赖（并非全部）的版本进行了管理，项目需要以这个项目为父工程，这样就不用操心依赖的版本问题，需要什么依赖，直接引入坐标即可！

<parent>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-parent</artifactId>
    <version>2.4.0</version>
</parent>

2.2 添加web启动器

spring-boot-starter-web
为了让Spring Boot帮我们完成各种自动配置，我们必须引入Spring Boot提供的自动配置依赖，我们称为启动器 。因为我们是web项目，这里我们引入web启动器，在 pom.xml 文件中加入如下依赖：

<dependencies>
	<dependency>
	<groupId>org.springframework.boot</groupId>
	<artifactId>spring-boot-starter-web</artifactId>
	</dependency>
</dependencies>

2.3 添加jdk版本

<properties>
	<java.version>1.8</java.version>
</properties>

2.4 Mysql 驱动包

mysql-connector-java

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.39</version>
</dependency>

2.5 Maven插件

spring-boot-maven-plugin

<build>
    <plugins>
        <plugin>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-maven-plugin</artifactId>
        </plugin>
    </plugins>
</build>

2.6 完整pom文件

<?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 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>org.example</groupId>
    <artifactId>springboot-demo</artifactId>
    <version>1.0-SNAPSHOT</version>

    <properties>
        <maven.compiler.source>8</maven.compiler.source>
        <maven.compiler.target>8</maven.compiler.target>
        <java.version>1.8</java.version>
    </properties>

    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.4.0</version>
    </parent>

    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <!--mybatis坐标-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.2</version>
        </dependency>
        <!--mysql驱动坐标-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.6</version>
            <scope>runtime</scope>
        </dependency>
        <!--单元测试坐标-->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
            <scope>test</scope>
        </dependency>
        <!--日志坐标-->
        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.12</version>
        </dependency>
    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>

</project>

3 配置application.yml

src\main\resources\application.yml

server:
  port: 8083
spring:
  datasource:
    username: root
    password: root
    driver-class-name: com.mysql.jdbc.Driver
    url: jdbc:mysql://localhost:3306/springboot-test?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=UTC
mybatis:
  # xml文件所在路径
  mapper-locations: classpath:mapper/*.xml
  # 实体类所在包名
  type-aliases-package: org.example.dao.entity

4 创建启动类

Springboot项目通过main函数启动

编写src\main\java\org\example\Application.java如下：

package org.example;

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

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

5 Controller层

src\main\java\org\example\controller\UserController.java

package org.example.controller;

import cn.hutool.json.JSONUtil;
import org.example.dao.entity.UserEntity;
import org.example.service.UserService;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import javax.annotation.Resource;
import java.util.List;

@RestController
@RequestMapping("user")
public class UserController {
    @Resource
    private UserService userService;

    @RequestMapping("findAllUser")
    public String findAllUser(){
        List<UserEntity> userList = userService.findAllUsers();
        return JSONUtil.toJsonStr(userList);
    }
}

6 Service层

编写Service，src\main\java\org\example\service\UserService.java

package org.example.service;

import org.example.dao.entity.UserEntity;

import java.util.List;

public interface UserService {
    List<UserEntity> findAllUsers();
}

编写ServiceImpl，src\main\java\org\example\service\UserServiceImpl.java

package org.example.service;

import org.example.dao.UserMapper;
import org.example.dao.entity.UserEntity;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;
import java.util.List;

@Service
public class UserServiceImpl implements UserService {
    @Resource
    private UserMapper userMapper;

    @Override
    public List<UserEntity> findAllUsers() {
        return userMapper.findAllUsers();
    }
}

7 Dao层

7.1 创建数据库springboot-test

创建user表

CREATE TABLE user (
  id int(10) NOT NULL COMMENT 'Id',
  username varchar(64) NOT NULL COMMENT '用户名',
  password varchar(64) NOT NULL COMMENT '密码'
) COMMENT='用户表';

7.2 编写User实体类

src\main\java\org\example\dao\entity\UserEntity.java

package org.example.dao.entity;

public class User {
    private int id;
    private String userName;
    private String password;

    public User() {
    }

    public User(int id, String userName, String password) {
        this.id = id;
        this.userName = userName;
        this.password = password;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getUserName() {
        return userName;
    }

    public void setUserName(String userName) {
        this.userName = userName;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }
}

7.3 编写Mapper

src\main\java\org\example\dao\UserMapper.java

package org.example.dao;

import org.apache.ibatis.annotations.Mapper;
import org.example.dao.entity.UserEntity;

import java.util.List;

@Mapper
public interface UserMapper {
    List<UserEntity> findAllUsers();
}

7.4 编写Mapper.xml映射

src\main\resources\mapper\UserMapper.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="org.example.dao.UserMapper">
    <select id="findAllUsers" resultType="org.example.dao.entity.UserEntity">
        select id,username,password
        from user
        where 1=1
    </select>
</mapper>

8 测试

访问http://localhost:8083/user/findAllUser