SpringBoot：整合MyBatis

一，maven依赖

<?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>com.test</groupId>
    <artifactId>MySpringBoot</artifactId>
    <version>1.0-SNAPSHOT</version>

    <name>MySpringBoot</name>

    <properties>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <maven.compiler.source>1.8</maven.compiler.source>
        <maven.compiler.target>1.8</maven.compiler.target>
    </properties>

    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.1.1.RELEASE</version>
        <relativePath/>
    </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-test</artifactId>
            <scope>test</scope>
        </dependency>
        <!-- mybatis -->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.1.1</version>
        </dependency>
        <!-- mysql -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
    </dependencies>

    <build>
        <pluginManagement><!-- lock down plugins versions to avoid using Maven defaults (may be moved to parent pom) -->
            <plugins>
                <!-- clean lifecycle, see https://maven.apache.org/ref/current/maven-core/lifecycles.html#clean_Lifecycle -->
                <plugin>
                    <artifactId>maven-clean-plugin</artifactId>
                    <version>3.1.0</version>
                </plugin>
                <!-- default lifecycle, jar packaging: see https://maven.apache.org/ref/current/maven-core/default-bindings.html#Plugin_bindings_for_jar_packaging -->
                <plugin>
                    <artifactId>maven-resources-plugin</artifactId>
                    <version>3.0.2</version>
                </plugin>
                <plugin>
                    <artifactId>maven-compiler-plugin</artifactId>
                    <version>3.8.0</version>
                </plugin>
                <plugin>
                    <artifactId>maven-surefire-plugin</artifactId>
                    <version>2.22.1</version>
                </plugin>
                <plugin>
                    <artifactId>maven-jar-plugin</artifactId>
                    <version>3.0.2</version>
                </plugin>
                <plugin>
                    <artifactId>maven-install-plugin</artifactId>
                    <version>2.5.2</version>
                </plugin>
                <plugin>
                    <artifactId>maven-deploy-plugin</artifactId>
                    <version>2.8.2</version>
                </plugin>
                <!-- site lifecycle, see https://maven.apache.org/ref/current/maven-core/lifecycles.html#site_Lifecycle -->
                <plugin>
                    <artifactId>maven-site-plugin</artifactId>
                    <version>3.7.1</version>
                </plugin>
                <plugin>
                    <artifactId>maven-project-info-reports-plugin</artifactId>
                    <version>3.0.0</version>
                </plugin>
                <plugin>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-maven-plugin</artifactId>
                </plugin>
            </plugins>
        </pluginManagement>
    </build>
</project>

二，application.properties配置文件

### MYSQL数据源配置
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/mybatis
spring.datasource.username=root
spring.datasource.password=123456

### mapper存储路径, 注意文件夹之间用.分割
mybatis.mapper-locations=classpath:com.gupao.springboot.*.mapper/*.xml

三，项目结构

四，简单实现代码

    * 启动类

package com.gupao.springboot;

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

@SpringBootApplication
@EnableAsync
// 配置mapper包扫描路径, 默认扫描每一个子模块下的mapper包
@MapperScan(basePackages = {"com.gupao.springboot.*.mapper"})
public class GupaoSpringbootApplication {

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

}

    * Controller

package com.gupao.springboot.test.controller;

import com.alibaba.fastjson.JSONObject;
import com.gupao.springboot.test.entitys.UserVO;
import com.gupao.springboot.test.service.IUserService;
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 pj_zhang
 * @create 2018-12-25 22:47
 **/
@RestController
public class UserController {
    @Autowired
    private IUserService userService;

    @RequestMapping("/findUser")
    public String findUser() {
        List<UserVO> lstUser = userService.findUser();
        return JSONObject.toJSONString(lstUser);
    }

}

    * Service

package com.gupao.springboot.test.service;

import com.gupao.springboot.test.entitys.UserVO;

import java.util.List;

/**
 * @author pj_zhang
 * @create 2018-12-25 22:46
 **/
public interface IUserService {
    /**
     * 查找用户信息
     * @return
     */
    List<UserVO> findUser();
}

    * Service.Impl

package com.gupao.springboot.test.service.impl;

import com.gupao.springboot.test.entitys.UserVO;
import com.gupao.springboot.test.mapper.IUserMapper;
import com.gupao.springboot.test.service.IUserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * @author pj_zhang
 * @create 2018-12-25 22:46
 **/
@Service
public class UserService implements IUserService {

    @Autowired
    private IUserMapper userMapper;

    @Override
    public List<UserVO> findUser() {
        return userMapper.findUser();
    }
}

    * Mapper.java

package com.gupao.springboot.test.mapper;

import com.gupao.springboot.test.entitys.UserVO;

import java.util.List;

/**
 * @author pj_zhang
 * @create 2018-12-25 22:47
 **/
public interface IUserMapper {

    List<UserVO> findUser();
}

    * Mapper.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.gupao.springboot.test.mapper.IUserMapper">
    <select id="findUser" resultType="com.gupao.springboot.test.entitys.UserVO">
        SELECT
            USERNAME AS userName,
            PASSWORD AS PASSWORD,
            AGE AS age
        FROM
            user_t
    </select>
</mapper>

五，运行结果