SpringBoot整合Mybatis（一）

1：导包

        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.17</version>
        </dependency>
<!--        Springboot整合Mybatis-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.4</version>
        </dependency>

2：文件结构

                                      

3：application.yaml配置

#配置数据库
spring:
  datasource:
    url: jdbc:mysql://localhost:3306/book?&serverTimezone=Hongkong
    username: root
    password: "010429"
    driver-class-name: com.mysql.cj.jdbc.Driver
    druid:
      aop-patterns: com.xiaoze.*  #监控SpringBean
      filters: stat,wall     # 底层开启功能，stat（sql监控），wall（防火墙）
      stat-view-servlet:   # 配置监控页功能
        enabled: true
        login-username: admin
        login-password: admin
        resetEnable: false
      web-stat-filter:  # 监控web
        enabled: true
        urlPattern: /*
        exclusions: '*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*'
      filter:
        stat:    # 对上面filters里面的stat的详细配置
          slow-sql-millis: 1000
          logSlowSql: true
          enabled: true
        wall:
          enabled: true
          config:
            drop-table-allow: false

 4：mapper接口编写

@Mapper
public interface BookMapper {

    public Book getBook(String username);
}

 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="com.xiaoze.mapper.BookMapper">
   <select id="getBook" resultType="com.xiaoze.Bean.Book">
      select * from t_user where username = #{username}
   </select>
</mapper>

6：mybatis-config文件编写

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>

</configuration>

7:service层编写

@Service
public class BookServiceImpl {

    @Autowired
    BookMapper bookMapper;

    public Book getBook(String username){
        Book book = bookMapper.getBook(username);
        return book;
    }
}

8：controller编写

@Controller
public class BootController {

    @Autowired
    BookServiceImpl bookService;

    @GetMapping("/book")
    @ResponseBody
    public Book getBook(){
        return bookService.getBook("admin");
    }
}