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=utf8spring.datasource.username=rootspring.datasource.password=zaq!@wsxspring.datasource.driver-class-name=com.mysql.jdbc.Driverserver.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. */@Mapperpublic 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.xmlmybatis.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. */@Mapperpublic interface UserDao {    @Select("select * from t_user where name = #{name}")    Map getUser(@Param("name") String name);}