扩展：SpringBoot+MyBatis框架+mysql数据库的整合（注解版）

开发环境：

开发工具：Intellij IDEA 2017.2.3

JDK : 1.8.0_144

spring boot 版本 ： 1.5.10.RELEASE

maven : 3.2.3

SpringBoot集成MyBatis加入基础依赖：

mybatis：

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

MySQL:

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

数据库配置：

application.yml

spring:
  datasource:
     url: jdbc:mysql://192.168.1.59:3306/test?useUnicode=true&characterEncoding=UTF-8
     username: root
     password: 123456
     driver-class-name: com.mysql.jdbc.Driver

在Mysql数据库中创建数据表：

CREATE DATABASE mytest;
 USE mytest; 
CREATE TABLE t_user(
     id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT, 
     name VARCHAR(255) NOT NULL , 
     password VARCHAR(255) NOT NULL ,
     phone VARCHAR(255) NOT NULL ) ENGINE=INNODB AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8;

使用Mybatis：

创建映射对象User

/** * User实体映射类 
    * Created by Administrator on 2017/11/24. 
    */ 
public class User { 
    private Integer id; 
    private String name; 
    private String password; 
    private String phone; 
    //省略 get 和 set ... 
}

创建User映射的操作UserMapper，为了后续单元测试验证，实现插入和查询操作

/**
    * User映射类
    * Created by Administrator on 2017/11/24.
    */
@Mapper
public interface UserMapper {
     @Select("SELECT * FROM T_USER WHERE PHONE = #{phone}")
    User findUserByPhone(@Param("phone") String phone);

     @Insert("INSERT INTO T_USER(NAME, PASSWORD, PHONE) VALUES(#{name}, #{password}, #{phone})")
    int insert(@Param("name") String name, @Param("password") String password, @Param("phone") String phone);
}

创建单元测试：

@RunWith(SpringRunner.class)
@SpringBootTest
public class Demo2ApplicationTests {

   @Autowired
   private UserMapper userMapper;

   @Test
   public void insert(){
      userMapper.insert("hy","123456","123456789");
   }
   @Test
   public void getBYphone(){
      User user =userMapper.findUserByPhone("123456789");
      Assert.assertEquals("hy", user.getName());
      System.out.println(user.getName()+":"+user.getPassword());
   }
}

注解版是最简单的，只需要在mapper接口种直接写sql就可以

注意：配置版、通用mapper版、配置文件版，这三版可以混合使用，