第7讲 SpringBoot 整合mybatis提供的逆向工程生成Bean,映射文件,DAO接口

137 阅读1分钟

1、添加mybatis依赖

    

这里查看最新版本号:mybatis.org/spring-boot…

         

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

        <!--mysql jdbc驱动-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>

2、添加插件

<plugin>
  <groupId>org.mybatis.generator</groupId>
  <artifactId>mybatis-generator-maven-plugin</artifactId>
  <version>1.4.0</version>
  <configuration>
    <configurationFile>src/main/resources/GeneratorMapper.xml</configurationFile>
    <verbose>true</verbose>
    <overwrite>true</overwrite>
  </configuration>
</plugin>

3、Mybatis配置文件  GeneratorMapper.xml

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE generatorConfiguration
  PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
  "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
<generatorConfiguration>
  <classPathEntry location="/Users/jay/data/mysql-connector-java-8.0.22.jar" />
  <context id="test" targetRuntime="MyBatis3">
    <jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"
      connectionURL="jdbc:mysql://bj-cdb-9smxilcn.sql.tencentcdb.com:63844/s_business"
      userId="root"
      password="asdf5213volcano">
    </jdbcConnection>

    <javaTypeResolver >
      <property name="forceBigDecimals" value="false" />
    </javaTypeResolver>

    <javaModelGenerator targetPackage="com.drondea.springboot.entity" targetProject="src/main/java">
      <property name="enableSubPackages" value="true" />
      <property name="trimStrings" value="true" />
    </javaModelGenerator>

    <sqlMapGenerator targetPackage="com.drondea.springboot.entity"  targetProject="src/main/java">
      <property name="enableSubPackages" value="true" />
    </sqlMapGenerator>

    <javaClientGenerator type="XMLMAPPER" targetPackage="com.drondea.springboot.dao"  targetProject="src/main/java">
      <property name="enableSubPackages" value="true" />
    </javaClientGenerator>

    <table tableName="admin_user" schema="s_business">
      <property name="useActualColumnNames" value="false"/>
    </table>
  </context>

</generatorConfiguration>

配置文件具体说明查看

mybatis.org/generator/c…

总结:

    非常简单,这样基本上就完成了配置,直接运行就可以生成对应的Bean,映射文件,DAO接口了。