springboot整合mybatis

先创建一个springbooot项目
file->new project Spring Initalizr 勾选sql mysql Driver
这里和mybatis-plus一起整合

 
      com.alibaba
      druid
      1.1.23
    
    
      com.baomidou
      mybatis-plus-boot-starter
      3.4.2
    
     
      org.projectlombok
      lombok
      1.18.20
    
  
    org.mybatis.spring.boot
    mybatis-spring-boot-starter
    2.2.0
  
    

yml文件

spring:
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/mybatisplus_db?serverTimezone=UTC
    username: root
    password: root
mybatis:
  mapper-locations: com/itheima/dao*.xml
      
      true
    
  

文件目录

UserDao

@Mapper
public interface UserDao extends BaseMapper {
  public User findOne();
}

UserDao.xml

  
    select *
    from tb_user
    where id=1
  

调用

@SpringBootTest
class MybatisplusQuickstart03ApplicationTests {
  @Autowired
  private UserDao userDao;
 @Test
  void testselect() {
    User all = userDao.findOne();
    System.out.println(all);
  }
}

如果想放到resource下只需修改pom文件 和yml中的
这里路径注意

    
    
      src/main/resources/mapper
      
        *.xml
      
      true
    
  

mybatis:
  mapper-locations: classpath:/mapper/*.xml