springboot集成Mybatis

1.修改pom.xml,增加依赖

<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>
</dependency>

2.mysql的连接配置

application.properties：

spring.datasource.url=jdbc:mysql://localhost:3306/spring
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

3.创建表t_user

CREATE TABLE `t_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(40) DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  `address` varchar(100) DEFAULT NULL,
  `phone` varchar(40) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

4.创建User.java文件

包名为：com.example.boot.bean

public class User {
    private Integer id;
    private String name;
    private Integer age;
    private String address;
    private String phone;
    // getter,setter省略
}

5.创建UserMapper.java接口文件

包名为：com.example.boot.mybatis

@Mapper
public interface UserMapper {
/**根据id查询用户*/
@Select("SELECT * FROM T_USER WHERE ID = #{id}")
    User findById(@Param("id") String id);
/**新增用户*/
    @Insert("INSERT INTO T_USER(NAME, AGE, ADDRESS, PHONE) VALUES(#{name}, #{age}, #{address}, #{phone})")
    int insert(@Param("name") String name, @Param("age") Integer age,@Param("address") String address,@Param("phone") String phone);
}

6.测试

@RunWith(SpringJUnit4ClassRunner.class)
@SpringBootTest(classes = SpringBootMain.class)
public class MybatisTest {
    @Autowired
    private UserMapper userMapper;
    @Test
    public void testInsert() throws Exception {
        int num = userMapper.insert("zhangsan", 20,"河北沧州","13100000000");
        TestCase.assertEquals(num,1);
    }
    @Test
    public void testFindById() throws Exception {
        User u = userMapper.findById(14);
        TestCase.assertNotNull(u);
        System.out.println(u.getName());
    }
}

更多springboot相关知识参见[持续更新]

springboot教程目录