Spring Boot 集成 Mybatis

步骤一： 在POM 文件中添加Mybatis 的依赖包

<dependency>
   <groupId>org.mybatis.spring.boot</groupId>
   <artifactId>mybatis-spring-boot-starter</artifactId>
   <version>1.1.1</version>
</dependency>

<dependency>
   <groupId>mysql</groupId>
   <artifactId>mysql-connector-java</artifactId>
   <version>5.1.21</version>
</dependency>

步骤二：在application.properties 配置文件中添加数据库连接

spring.datasource.url=jdbc:mysql://192.168.0.108:3306/test?useUnicode=true&characterEncoding=utf8&characterSetResults=utf8
spring.datasource.username=root
spring.datasource.password=zaq!@wsx
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
server.port=8082

步骤三：创建数据库表t_user，同时创建实体类，User

package com.demo.entity;

/**
 * Created by Administrator on 2017/11/22 0022.
 */
public class User {
    private String id;
    private String name;
    private int age;

    public User() {
    }

    public User(String id, String name, int age) {
        this.id = id;
        this.name = name;
        this.age = age;
    }

    public String getId() {
        return id;
    }

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

    public String getName() {
        return name;
    }

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

    public int getAge() {
        return age;
    }

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

步骤四：编写接口及Mapper

方法一：

创建UserDao接口：

package com.demo.dao;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.Map;


/**
 * Created by Administrator on 2017/11/22 0022.
 */
@Mapper
public interface UserDao {

    Map getUser(@Param("name") String name);
}

在resources文件夹下面创建mybatis文件夹，存放mapper.xml文件

编写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.demo.dao.UserDao">

    <select id="getUser" parameterType="java.lang.String" resultType="java.util.Map">
        SELECT
        t.id,
        t.age
        FROM
        t_user t
        WHERE
        t.name = #{name}
    </select>
</mapper>

在application.properties 配置文件中添加Mybatis的相关配置，如下：

mybatis.mapper-locations=classpath*:mybatis/*Mapper.xml
mybatis.type-aliases-package=com.demo.entity

方法二：编写Mapper对象

package com.demo.dao;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.Map;


/**
 * Created by Administrator on 2017/11/22 0022.
 */
@Mapper
public interface UserDao {

    @Select("select * from t_user where name = #{name}")
    Map getUser(@Param("name") String name);
}