springboot整合mybatis

基于搭建好的springcloud项目

https://blog.csdn.net/jdbcmeng/article/details/125423022

maven依赖

        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.3</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.6</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.20</version>
        </dependency>

application.yml

# Database base configuration
spring:
  datasource:
      driverClassName: com.mysql.jdbc.Driver
      url: jdbc:mysql://192.168.233.129:3306/mydata?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf8&allowMultiQueries=true
      username: root
      password: 123456
mybatis:
    mapperLocations: classpath*:mapper/*Mapper.xml

# 打印sql语句
logging:
    level:
        com.meng.user: debug

扫描Dao

@SpringBootApplication
@MapperScan(value = "com.meng")
public class MyApplication {
    public static void main(String[] args) {
        SpringApplication.run(MyApplication.class , args);
    }
}

打印日志

@Slf4j
@RestController
@RequestMapping("/user")
public class UserController {

    @Resource
    private UserService userService;

    @GetMapping("/findAll")
    public List<User> findAll(){
        log.info("finall bei diao yong le -----------");
        return userService.findAll();
    }

    @GetMapping("/find/{id}")
    public User find(@PathVariable(value = "id")Integer id){
        log.info("find bei diao yong le ----------params-{}" , id);
        return userService.findById(id);
    }
}