SpringBoot整合Mybatis

前言

MyBatis 是一款优秀的持久层框架，它支持定制化 SQL、存储过程以及高级映射。MyBatis 避免了几乎所有的 JDBC 代码和手动设置参数以及获取结果集。MyBatis 可以使用简单的 XML 或注解来配置和映射原生信息，将接口和 Java 的 POJOs(Plain Ordinary Java Object,普通的 Java对象)映射成数据库中的记录。

1.新建springboot项目

2.输入项目名

3.选择相关插件

4.Finish完成创建

5.结构如下：

<?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.8.RELEASE</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>com.tt</groupId>
    <artifactId>springboot_mybatis</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>springboot_mybatis</name>
    <description>Demo project for Spring Boot</description>

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

    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jdbc</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.0</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>
    </dependencies>

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

</project>

6.创建application.yml并加入以下配置

server:
  port: 8080

spring:
  datasource:
    username: root
    password: 123456
    driver-class-name: com.mysql.jdbc.Driver
    url: jdbc:mysql://localhost:3306/ml?characterEncoding=UTF8&serverTimezone=UTC

mybatis:
  mapper-locations: classpath:mapper/**/*.xml  #指定mapper路径
 
  configuration:
    map-underscore-to-camel-case: true   #  驼峰匹配
    #    日志输出sql
    logImpl: org.apache.ibatis.logging.stdout.StdOutImpl

9.创建包结构，如下图

8.启动类中添加扫描注解

@MapperScan("com.tt.springboot_mybatis.mapper")

9.在model包下创建Student类

package com.tt.springboot_mybatis.model;



import java.io.Serializable;


public class Student implements Serializable {

    private Integer id;
    private String name;
    private Integer age;
    private String address;

    public Integer getId() {
        return id;
    }

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

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public Integer getAge() {
        return age;
    }

    public void setAge(Integer age) {
        this.age = age;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }
}

10.在mapper包下创建StudentMapper接口

package com.tt.springboot_mybatis.mapper;

import com.tt.springboot_mybatis.model.Student;

import java.util.List;

/**
 * @author 
 * @date 2019/9/30
 */
public interface StudentMapper {

    public List<Student> findAll();
}

11.在mapper报下创建StudentMapper.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.tt.springboot_mybatis.mapper.StudentMapper">
    
    <select id="findAll" resultType="com.tt.springboot_mybatis.model.Student">
        select * from student
    </select>



</mapper>

12.在service包下创建StudentService接口

package com.tt.springboot_mybatis.service;

import com.tt.springboot_mybatis.model.Student;

import java.util.List;

/**
 * @author 
 * @date 2019/9/30
 */
public interface StudentService {
    
    public List<Student> findAll();
}

13.在impl包下创建StudentServiceImpl

package com.tt.springboot_mybatis.impl;

import com.tt.springboot_mybatis.mapper.StudentMapper;
import com.tt.springboot_mybatis.model.Student;
import com.tt.springboot_mybatis.service.StudentService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * @author 
 * @date 2019/9/30
 */
@Service
public class StudentServiceImpl implements StudentService {
    
    @Autowired
    private StudentMapper studentMapper;
    
    @Override
    public List<Student> findAll() {
        return studentMapper.findAll();
    }
}

14.在controller包下创建StudentController

package com.tt.springboot_mybatis.controller;

import com.tt.springboot_mybatis.model.Student;
import com.tt.springboot_mybatis.service.StudentService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

/**
 * @author 
 * @date 2019/9/30
 */
@RestController
@RequestMapping("student")
public class StudentController {

    @Autowired
    private StudentService studentService;

    @RequestMapping("findAll")
    public List<Student> findAll(){
        List<Student> list = null;
        try {
            list = studentService.findAll();
        } catch (Exception e) {
            e.printStackTrace();
        }
        return list;
    }

}

完整的结构如下图：

15.启动访问

16.控制台输出的日志

Mybatis日志插件，可以直接把执行的sql抓取出来
通用Mapper，让sql写的更少

开心一刻

展昭给马汉讲自己的英勇故事：“那天我打探逍遥楼，获得重要情报，却误中机关，身受重伤。我强提一口真气，支撑到开封府，突然眼前一黑。”马汉关切的问：“你昏倒了？”展昭：“不，是包大人出来了。”

上一篇：SpringBoot整合Redis