SpringBoot 简单整合mybatis小demo

学习时 springboot整合mybatis小demo

1、导入依赖

<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>2.1.2</version>
</dependency>
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <!--<scope>runtime</scope>-->
</dependency>

2、配置文件

spring:
  datasource:
    url: jdbc:mysql:///springboot?serverTimezone=UTC
    username: root
    password: root
    driver-class-name: com.mysql.cj.jdbc.Driver

mybatis:
#指定mapper映射文件位置
  mapper-locations: classpath:mapper/*Mapper.xml
#别名
  type-aliases-package: com.wang.boot_04_mybatis_redis.entity

3、mapper

@Mapper
@Repository
public interface UserMapper {
    //    @Select("select * from tb_user")
    public List<User> findAll();
}

4、映射文件

<?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.wang.boot_04_mybatis_redis.mapper.UserMapper">

    <select id="findAll" resultType="com.wang.boot_04_mybatis_redis.entity.User">
        select * from tb_user
    </select>
</mapper>

5、实体类

@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {
    private Integer id;
    private String name;
    private String gender;
    private Integer age;
    private String address;
    private String qq;
    private String email;
    private String username;
    private String password;
}

6、测试

@SpringBootTest(classes = Boot04MybatisRedisApplication.class)
class Boot04MybatisRedisApplicationTests {

    @Autowired
    private UserMapper userMapper;

    @Autowired
    private RedisTemplate redisTemplate;

    @Test
    void contextLoads() {
        List<User> all = userMapper.findAll();
        for (User user : all) {
            System.out.println("user = " + user);
        }
    }