SpringBoot整合Mybatis
一.注解方式整合Mybatis
1.创建Air的Mapper接口
@ComponentScan
public interface AirMapper {
List<Air> selectAll();
Air selectOneById(Integer id);
}
2.添加Mybatis注解
针对增删改查:@Insert,@Delete,@Update,@Select
还是需要在启动类中添加@MapperScan注解
@ComponentScan
public interface AirMapper {
@Select("select * from air where id =#{id}")
Air selectOneById(@Param("id") Integer id);
}
3.配置日志
// yml文件
logging:
level:
XXX.mapper: DEBUG
# 连接数据库的信息
spring:
datasource:
driver-class-name: com.mysql.jdbc.Driver
url: jdbc:mysql:///air
username: root
password