SpringBoot 整合MyBatis

整合MyBatis

 

<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis‐spring‐boot‐starter</artifactId>
<version>1.3.1</version>
</dependency>

步骤：
1）、配置数据源相关属性（见上一节Druid）
2）、给数据库建表
3）、创建JavaBean

4）、注解版

//指定这是一个操作数据库的mapper
@Mapper
public interface DepartmentMapper {


   @Select("select * from department where id=#{id}")
    public Department getDeptById(Integer id);

   @Delete("delete from department where id=#{id}")
   public int deleteDeptById(Integer id);


   @Options(useGeneratedKeys = true,keyProperty = "id")
   @Insert("insert into department(departmentName) values(#{departmentName})")
   public int insertDept(Department department);

   @Update("update department set departmentName=#{departmentName} where id=#{id}")
   public int updateDept(Department department);
}

问题：
自定义MyBatis的配置规则；给容器中添加一个ConfigurationCustomizer；

@org.springframework.context.annotation.Configuration
public class MyBatisConfig {

  @Bean
  public ConfigurationCustomizer configurationCustomizer(){
    return new ConfigurationCustomizer(){

      @Override
      public void customize(Configuration configuration) {
           //开启驼峰命名法
          configuration.setMapUnderscoreToCamelCase(true);
      }
  };
 }
}

使用MapperScan批量扫描所有的Mapper接口；
@MapperScan(value = "com.atguigu.springboot.mapper")
@SpringBootApplication
public class SpringBoot06DataMybatisApplication {
public static void main(String[] args) {
SpringApplication.run(SpringBoot06DataMybatisApplication.class, args);
}
}

5）、配置文件版

mybatis:
    config‐location: classpath:mybatis/mybatis‐config.xml 指定全局配置文件的位置
    mapper‐locations: classpath:mybatis/mapper/*.xml 指定sql映射文件的位置