Spring系列——MyBatis（XML版）

原文链接：http://www.dubby.cn/detail.html?id=9049

我相信读者如果看了《Spring系列——MyBatis》，肯定会不爽，因为习惯了用XML来写SQL，用什么注解？害得我又要重新学习，而且某些特性注解确实没有XML方便。所以，我来了，带来这篇XML版的MyBatis。

访问www.dubby.cn获取更多精彩内容。

1. 你需要准备

如果你看过我之前写的，并且在本地联系过了，那么你的环境已经具备了，如果没有的话，我又要啰嗦一遍了。

• JDK 8 +
• Maven 3.0 +
• MySQL
• 在MySQL中间一个测试库，并创建测试表

CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

2. 项目依赖

pom.xml

<?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">
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>1.5.8.RELEASE</version>
    </parent>
    <modelVersion>4.0.0</modelVersion>

    <artifactId>accessing-mysql-mybatis-xml</artifactId>

    <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>
        <dependency>
            <groupId>com.jayway.jsonpath</groupId>
            <artifactId>json-path</artifactId>
            <scope>test</scope>
        </dependency>

        <!-- MySQL Connector-J -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>

        <!-- MyBatis -->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.1</version>
        </dependency>
    </dependencies>

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

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

</project>

其中，mybatis-spring-boot-starter这个starter不是Spring官方提供的，是由MyBatis提供的，所以这里需要自己指定版本。

3. 开始写代码了

3.1 启动类

hello/Application.java

package hello;

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

和以往一样，没啥特别的。

3.2 实体类

hello/entity/User.java

package hello.entity;

public class User {

    public User(Integer id, String name, String email) {
        this.id = id;
        this.name = name;
        this.email = email;
    }

    public User() {
    }

    public User(String name, String email) {
        this.name = name;
        this.email = email;
    }

    private Integer id;

    private String name;

    private String email;
}

为了篇幅，我删去了getter/setter，请自行补上

3.3 mapper

hello/mapper/UserMapper.java

package hello.mapper;

import hello.entity.User;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.SelectKey;

import java.util.List;

/**
 * Created by teeyoung on 17/10/25.
 */
@Mapper
public interface UserMapper {

    List<User> findAll();

    User findById(int id);

    int insert(User user);

}

发现没？这里就是最基础的接口，SQL不在这里写了，会改到XMl去。

3.4 controller

hello/controller/UserController.java

package hello.controller;

import hello.entity.User;
import hello.mapper.UserMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

/**
 * Created by teeyoung on 17/10/25.
 */
@RestController
public class UserController {

    @Autowired
    private UserMapper userMapper;

    @RequestMapping(value = "user/list")
    public List<User> list() {
        return userMapper.findAll();
    }

    @RequestMapping(value = "user/{id}")
    public User list(@PathVariable("id") int id) {
        return userMapper.findById(id);
    }

    @RequestMapping(value = "user/create")
    public List<User> create(String name, String email) {
        User temp = new User(name, email);
        int result = userMapper.insert(temp);
        System.out.println(temp.toString());
        System.out.println("result:" + result);
        return list();
    }

}

3.5 mybatis-config.xml

mybatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <typeAliases>
        <package name="hello.entity"/>
    </typeAliases>
    <mappers>
        <mapper resource="hello/mapper/UserMapper.xml"/>
    </mappers>
</configuration>

3.6 UserMapper.xml

hello/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="hello.mapper.UserMapper">

    <select id="findAll" resultType="User">
        SELECT * FROM USER
    </select>

    <select id="findById" parameterType="int" resultType="User">
        SELECT * FROM USER WHERE ID = #{id}
    </select>

    <insert id="insert" keyProperty="id" useGeneratedKeys="true">
        INSERT INTO USER(email, name) values(#{email}, #{name})
    </insert>

</mapper>

这里写好了MyBatis相关的配置和SQL，难道Spring可以自动识别吗？不好意思，Spring没那么聪明，需要我们提示它一下。

3.7 application.properties

application.properties

spring.datasource.url=jdbc:mysql://localhost:3306/test?useSSL=false
spring.datasource.username=root
spring.datasource.password=123456


mybatis.config-location=classpath:mybatis-config.xml

这里的mybatis.config-location就指明了MyBatis的配置文件。

4. 测试

代码地址：https://github.com/dubby1994/spring-demo