MyBatis Generator

maven配置 MyBatis Generator

• 引入依赖

  <build>
          <plugins>
              <plugin>
                  <groupId>org.springframework.boot</groupId>
                  <artifactId>spring-boot-maven-plugin</artifactId>
              </plugin>
              <plugin>
                  <groupId>org.mybatis.generator</groupId>
                  <artifactId>mybatis-generator-maven-plugin</artifactId>
                  <version>1.3.7</version>
                  <dependencies>
                      <dependency>
                          <groupId>mysql</groupId>
                          <artifactId>mysql-connector-java</artifactId>
                          <version>5.1.37</version>
                      </dependency>
                  </dependencies>
              </plugin>
          </plugins>
      </build>
  

• 创建generatorConfig.xml src/main/resources/generatorConfig.xml

generatorConfig配置内容如下

<?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>
    <context id="DB2Tables" targetRuntime="MyBatis3">
        
        <!--生成分页代码-->
        <plugin type="org.mybatis.generator.plugins.RowBoundsPlugin"></plugin>

        <!--数据库，配置参数-->
        <jdbcConnection driverClass="org.h2.Driver"
                        connectionURL="jdbc:h2:~/community-my"
                        userId="sa"
                        password="123">
        </jdbcConnection>

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

        <!--指定model位置，配置参数-->
        <javaModelGenerator targetPackage="com.renshen052.community.model" targetProject="src\main\java">
            <property name="enableSubPackages" value="true" />
            <property name="trimStrings" value="true" />
        </javaModelGenerator>

        <!-- 指定 xxx.map位置，配置参数-->
        <sqlMapGenerator targetPackage="mapper"  targetProject="src\main\resources">
            <property name="enableSubPackages" value="true" />
        </sqlMapGenerator>

        <!-- 指定 map接口位置，配置参数-->
        <javaClientGenerator type="XMLMAPPER" targetPackage="com.renshen052.community.mapper"  targetProject="src\main\java">
            <property name="enableSubPackages" value="true" />
        </javaClientGenerator>

        <!-- 指定要生成的表对象 -->
        <table tableName="user" domainObjectName="User" ></table>
        <table tableName="question" domainObjectName="Question" ></table>

    </context>
</generatorConfiguration>

• 配置application.properties 里mybatis部分

  # mybatis
  ## 开启驼峰映射
  mybatis.configuration.map-underscore-to-camel-case=true
  ## mapper接口路径
  mybatis.type-aliases-package=com.renshen052.community.mapper
  ## 底层slq的路径
  mybatis.mapper-locations=classpath:mapper/*.xml
  

• 使用mvn命令

mvn -Dmybatis.generator.overwrite=true mybatis-generator:generate

• 使用方式

  xxxExample的方式

  UserExample userExample = new UserExample();
          userExample.createCriteria()
                  .andAccountIdEqualTo(user.getAccountId());
          List<User> dbUsers = userMapper.selectByExample(userExample);
  

  直接修改xml文件的sql代码，然后userMapper.xxx()