Mybatis学习之旅(一)--springboot整合mybatis

mybatis是我们日常开发中常用的一款优秀的持久层框架,它支持自定义 SQL、存储过程以及高级映射。
从mybatis的使用到后续mybatis的运行原理等作为自己的学习路线，顺便整理成笔记，一是帮助自己理解、
记忆，二是希望分享给一些需要的小伙伴，一起进步。

一、新建maven项目，在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 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.1.9.RELEASE</version>
        <relativePath/> 
    </parent>
    <groupId>com.yson</groupId>
    <artifactId>springbootModules</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>springbootModules</name>
    <description>Demo project for springbootModules</description>
    <packaging>pom</packaging>

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

    <modules>
        <module>mybatis</module>
    </modules>

    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-thymeleaf</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
            <version>2.1.9.RELEASE</version>
        </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>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.9</version>
        </dependency>
        <dependency>
            <groupId>commons-logging</groupId>
            <artifactId>commons-logging</artifactId>
            <version>1.1.3</version>
        </dependency>
        <!--  添加JPA的支持 -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>fastjson</artifactId>
            <version>1.2.62</version>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <scope>provided</scope>
        </dependency>
    </dependencies>
    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>
</project>

二、新建项目配置文件applictaion.propertites：

#服务端口
server.port=8089

#mysql数据源连接地址
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/test?characterEncoding=utf-8&serverTimezone=UTC&useSSL=false
#数据库登录名
spring.datasource.username=root
#数据库连接密码
spring.datasource.password=root
#数据库连接驱动
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
#指定连接池最大的空闲连接数量
spring.datasource.max-idle=10
#指定连接池等待连接返回的最大等待时间，毫秒单位
spring.datasource.max-wait=10000
#指定必须保持连接的最小值
spring.datasource.min-idle=5
#指定启动连接池时，初始建立的连接数量
spring.datasource.initial-size=5
spring.jpa.database = MYSQL
#是否开启sql的log，默认为: false
spring.jpa.show-sql = true
#指定DDL mode (none, validate, update, create, create-drop). 当使用内嵌数据库时，默认是create-drop，否则为none
spring.jpa.hibernate.ddl-auto = update
#mapper.xml文件扫描地址
mybatis.mapper-locations=classpath:mapper/*.xml
#对应的实体类地址
mybatis.type-aliases-package=com.yson.mybatis.entity
#将带有下划线的表字段映射为驼峰格式的实体类属性
mybatis.configuration.map-underscore-to-camel-case=true

三、新建业务相关类文件：
UserController：

@RestController
@RequestMapping("/user")
public class UserController {

    @Autowired
    private UserService userService;

    @GetMapping("/queryAllUser")
    public void queryAllUser(Integer num){
        List<User> users = userService.queryAllUser();
        System.out.println(users);
    }
}

UserService:

public interface UserService {

    void insertUser(User user);

    List<User> queryAllUser();

    void updateUserById(User user);
}

UserServiceImpl:

@Service
public class UserServiceImpl implements UserService {

    @Autowired
    private UserMapper userMapper;

    @Override
    public List<User> queryAllUser() {
        return userMapper.queryAllUser();
    }
}

UserMapper:

@Mapper
public interface UserMapper{

    List<User> queryAllUser();
}

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="com.yson.mybatis.mapper.UserMapper">
    <select id="queryAllUser" resultType="com.yson.mybatis.entity.User">
        select * from user
    </select>
</mapper>

User：

public class User implements Serializable {

    private String userName;

    private String password;

    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;
    }

    @Override
    public String toString() {
        return "User{" +
                "userName='" + userName + '\'' +
                ", password='" + password + '\'' +
                '}';
    }

新建启动类：MybatisApplication:

@SpringBootApplication
public class MybatisApplication {

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

四、数据库建表及插入数据语句：

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `username` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 54 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, 'Tom', '123456');
INSERT INTO `user` VALUES (2, 'Jerry', '123123');

SET FOREIGN_KEY_CHECKS = 1;

五、项目结构图：

六、启动项目，运行MybatisApplication的main方法：

七、浏览器访问http://localhost:8089/user/queryAllUser，控制台打印出数据即整合成功：