springboot整合mybatis

1.引入依赖

<dependency>
	<groupId>org.mybatis.spring.boot</groupId>
	<artifactId>mybatis-spring-boot-starter</artifactId>
	<version>2.0.1</version>
</dependency>
<dependency>
	<groupId>com.alibaba</groupId>
	<artifactId>druid-spring-boot-starter</artifactId>
	<version>1.1.14</version>
</dependency>
<dependency>
	<groupId>mysql</groupId>
	<artifactId>mysql-connector-java</artifactId>
	<scope>runtime</scope>
</dependency>

2.修改application.yml配置文件

spring:
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    driver-class-name: com.mysql.jdbc.Driver
    url: jdbc:mysql://localhost:3306/admin?useUnicode=true&characterEncoding=UTF-8&useSSL=false
    username: root
    password: root

mybatis:
  #加载mapper文件
  mapper-locations: classpath:mapper/*.xml
  #设置实体类别名
  #type-aliases-package: demo.springboot.mybatis.domain
  #加载mybatis全局配置文件
  #config-location: classpath:mybatis/SqlMapConfig.xml

3.创建实体类

//使用lombok注解生成getter setter等
@Data
public class SysUser {
    private Long id;
    private String username;
    private String nickname;
    private Integer age;
}

4.创建mapper接口

public interface SysUserMapper {
    SysUser selectById(long id);
}

5.创建mapper文件

<?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="demo.springboot.mybatis.dao.SysUserMapper" >
  <resultMap id="BaseResultMap" type="demo.springboot.mybatis.domain.SysUser" >
    <id column="id" property="id" jdbcType="BIGINT" />
    <result column="username" property="username" jdbcType="VARCHAR" />
    <result column="nickname" property="nickname" jdbcType="VARCHAR" />
    <result column="age" property="age" jdbcType="INTEGER" />
  </resultMap>

  <select id="selectById" parameterType="long" resultMap="BaseResultMap">
    select
      *
    from
      sys_user
    where id = #{id}
  </select>
</mapper>

6.在启动类加上mapper接口扫描注解

@SpringBootApplication
//此注解可以扫描多个包
//@MapperScan({"demo.dao", "test.dao"})
@MapperScan("demo.springboot.mybatis.dao")
public class MybatisApplication {

    public static void main(String[] args) {
        SpringApplication.run(MybatisApplication.class, args);
    }

}

7.测试

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

    @Autowired
    private SysUserMapper userMapper;

    @Test
    public void testMybatis() {
        SysUser sysUser = userMapper.selectById(1L);
        System.out.println(sysUser);
    }

}

控制台输出：SysUser(id=1, username=admin, nickname=admin, age=10)

项目路径

作者博客

作者公众号