spirngboot整合mybatis

来源:互联网 发布:电梯网络远程视频监控 编辑:程序博客网 时间:2024/05/17 01:07

网上的文章参差不齐,不易读懂,这里写下整合的要点,仅供参考

yml文件中,mybatis:mapper-locations是最低配置要求

配置了config.xml、type-aliases-package就必须正确赋值

type-aliases-package、mapper-locations也可在config.xml文件中定义


1.pom

    <dependency>
      <groupId>org.mybatis.spring.boot</groupId>
      <artifactId>mybatis-spring-boot-starter</artifactId>
      <version>1.3.0</version>
    </dependency>
    <dependency>
      <groupId>org.mybatis.spring.boot</groupId>
      <artifactId>mybatis-spring-boot-starter-test</artifactId>

      <version>1.3.0</version>

  </dependency>

2.application.yml

spring:
 datasource:
   driver-class-name: com.mysql.jdbc.Driver
   username: root
   password: root
   url: jdbc:mysql://localhost:3306/*

mybatis:

  config-location: classpath:/mybatis/mybatis-config.xml
  type-aliases-package: com.aimashi.pojo
  mapper-locations: classpath:/mybatis/mapper/*.xml

3.mybatis-config.xml
<?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>
   <settings>
       <!-- 开启驼峰自动映射 -->
       <setting name="mapUnderscoreToCamelCase" value="true" />
   </settings>
</configuration>

原创粉丝点击