Spring Boot整合Mybatis

1. 项目所需的依赖

<dependencies>
        <!--thyemfeaf-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-thymeleaf</artifactId>
        </dependency>
        <!--springboot-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <!--实体类更简单-->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>
        <!-- 加载mybatis整合springboot -->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.2</version>
        </dependency>
        <!-- MySQL的jdbc驱动包 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <!-- springboot 开发自动热部署 -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>
            <optional>true</optional>
        </dependency>
        <!-- alibaba的druid数据库连接池 -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.10</version>
        </dependency>
    </dependencies>

2. 在application.properties配置文件中添加下面内容：

#指定mapper文件的位置
mybatis.mapper-locations=classpath:mapper/*.xml
#指定bean的位置
mybatis.type-aliases-package=com.huihui.food.bean

#数据源
spring.datasource.username=root
spring.datasource.password=
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/myshop?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone= Asia/Shanghai 
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource

#查看sql语句日志
logging.level.com.huihui.food.mapper=debug

3. 实体类

@Data
public class User {
    private int id;
    private String username;
    private String email;
    private String password;
}

4. 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.huihui.food.mapper.UserMapper">
    <!--查询多条数据-->
    <select id="selectAll" resultType="user">
        SELECT * FROM user
    </select>
</mapper>

5. mapper层

@Mapper
public interface UserMapper {
    public List<User> selectAll();
}

6. service层

@Transactional
@Service
public class UserServiceImpl implements UserService {
    @Autowired
    UserMapper userMapper;
    @Override
    public List<User> selectAll() {
        return userMapper.selectAll();
    }
}

7. controller层

@Controller
public class UserController {
    @Autowired
    UserService userService;
    @ResponseBody
    @RequestMapping(value = "/user/list",method = RequestMethod.GET)
    public List<User> selectAll(){
        return userService.selectAll();
    }
}

8. 在入口程序添加mapper层的注解扫描和开启事务支持

@SpringBootApplication
@MapperScan("com.huihui.food.mapper")
@EnableTransactionManagement
public class FoodApplication {

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

}

9. 运行入口类，在流浏览器输入 localhost:8080/user/list 可以在浏览器页面看见myshop数据库中user表中的数据。