springboot（八）：springboot集成mybatis

1、创建maven工程并添加相关依赖

<!-- Import dependency management from Spring Boot -->
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.0.4.RELEASE</version>
    </parent>
    <!-- 统一管理jar包版本 -->
    <properties>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
        <java.version>1.8</java.version>
    </properties>
 
   <dependencies>
        <!--启动器构建web，包括RESTful，使用Spring MVC的应用程序。使用Tomcat作为默认嵌入式容器-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <!-- lombok：用来消除Java类中的大量样板代码，产生干净，简洁且易于维护的Java类 -->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
        </dependency>

        <!-- springboot集成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>
        </dependency>

        <!-- SpingBoot集成junit测试依赖 -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
    </dependencies>

2、添加配置文件application.yml

# DB Configuration
spring:
  datasource:
    driver-class-name: com.mysql.jdbc.Driver
    url: jdbc:mysql://127.0.0.1:3306/test?useSSL=true&useUnicode=true&characterEncoding=utf8
    username: root
    password: 123456
# mybatis Configuration
mybatis:
  # 开启自动驼峰匹配,通用mapper已经开启，不能再配置
  configuration:
    map-underscore-to-camel-case: true
  # 配置mapper.xml文件所在位置,单表操作可以不用配置
  mapper-locations: classpath:mapper/*.xml
  # 配置mybatis的别名扫描包
  type-aliases-package: com.wedu.mybatis.pojo

3、编写启动类

package com.wedu.mybatis;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
@MapperScan("com.wedu.mybatis.mapper")
public class MybatisApplication {

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

4、编写实体类

package com.wedu.mybatis.pojo;

import lombok.Data;
import java.util.Date;

/**
 * 用户信息实体
 */
@Data
public class UserInfo {

    private Integer id;
    private String username;
    private String password;
    private Integer age;
    private Date regtime;
    private String siteaddress;
}

5、编写mapper接口

package com.wedu.mybatis.mapper;

import com.wedu.mybatis.pojo.UserInfo;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**
 * 用户信息的mapper接口
 */
@Mapper //@Mapper标记该类是一个mybatis的mapper接口，可以被spring boot自动扫描到spring上下文中
public interface UserInfoMapper {

	List<UserInfo> queryUserList();
}

6、添加映射文件

<?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.wedu.mybatis.mapper.UserInfoMapper">
    <select id="queryUserList" resultType="userinfo">
        select * from userinfo
    </select>
</mapper>

7、编写测试类测试

package com.wedu.mybatis.mapper;

import com.wedu.mybatis.MybatisApplication;
import com.wedu.mybatis.pojo.UserInfo;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;

import java.util.List;

@RunWith(SpringRunner.class)
@SpringBootTest(classes = MybatisApplication.class)
public class UserInfoMapperTest {

    @Autowired
    private UserInfoMapper userInfoMapper;

    @Test
    public void testFindAll(){
        List<UserInfo> userinfos = userInfoMapper.queryUserList();
        userinfos.forEach(userInfo -> System.out.println(userInfo));
    }
}

8、测试结果如下：