maven web项目下mybatis generator的使用

时间：2019-09-07 15:14:02 阅读：120 评论：0 收藏：0 [点我收藏+]

idea中新建maven web项目，完善java,resources目录：

技术分享图片

pom.xml中添加jdbc依赖，mybatis generator的依赖和插件：

<dependencies>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.11</version>
      <scope>test</scope>
    </dependency>

    <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>8.0.17</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/org.mybatis.generator/mybatis-generator-core -->
    <dependency>
      <groupId>org.mybatis.generator</groupId>
      <artifactId>mybatis-generator-core</artifactId>
      <version>1.3.7</version>
    </dependency>

  </dependencies>

  <build>
    <plugins>
      <plugin>
        <!-- https://mvnrepository.com/artifact/org.mybatis.generator/mybatis-generator-maven-plugin -->
        <groupId>org.mybatis.generator</groupId>
        <artifactId>mybatis-generator-maven-plugin</artifactId>
        <version>1.3.7</version>
      </plugin>
    </plugins>
  </build>

resources目录下创建mybatis generator的配置文件generatorConfig.xml（mybatis generator配置文件默认名），内容大致如下：

<?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/yanguobin/.m2/repository/mysql/mysql-connector-java/8.0.17/mysql-connector-java-8.0.17.jar"/>

    <context id="mygenerator">

        <jdbcConnection
                driverClass="com.mysql.cj.jdbc.Driver"
                connectionURL="jdbc:mysql://localhost:3306/mybatisgeneratordemodb"
                userId="root"
                password="123">

            <!-- 避免同时生成 *Example类 -->
            <property name="nullCatalogMeansCurrent" value="true"></property>

        </jdbcConnection>

        <!-- 包名不存在时会自动生成 -->
        <javaModelGenerator targetPackage="com.yanguobin.pojo" targetProject="src/main/java"></javaModelGenerator>

        <sqlMapGenerator targetPackage="mapper" targetProject="src/main/resources"></sqlMapGenerator>

        <javaClientGenerator type="XMLMAPPER" targetPackage="com.yanguobin.dao" targetProject="src/main/java"></javaClientGenerator>

        <!-- enable* 属性设为false，避免把其他数据库下的同名表也给生成下来 -->
        <table tableName="book" domainObjectName="Book" enableCountByExample="false" enableDeleteByExample="false" enableSelectByExample="false" enableUpdateByExample="false" selectByPrimaryKeyQueryId="false"></table>
    </context>

</generatorConfiguration>