IDEA+SpringBoot+Mybatis Generator+MySQL8.0.17自动生成实体类和Mapper

1、搭建SpringBoot项目

2、修改pom.xml文件

添加依赖:

<dependency>  <groupId>mysql</groupId>  <artifactId>mysql-connector-java</artifactId>  <version>8.0.17</version></dependency><!--自动生成mybatis --><dependency>  <groupId>org.mybatis.generator</groupId>  <artifactId>mybatis-generator-core</artifactId>  <version>1.3.5</version></dependency><dependency>  <groupId>tk.mybatis</groupId>  <artifactId>mapper</artifactId>  <version>4.0.0</version></dependency>

添加插件:

<plugin>  <groupId>org.mybatis.generator</groupId>  <artifactId>mybatis-generator-maven-plugin</artifactId>  <version>1.3.5</version>  <configuration>    <verbose>true</verbose>    <overwrite>true</overwrite>    <configurationFile>src/main/resources/generator/generatorConfig.xml</configurationFile>  </configuration>  <dependencies>    <dependency>      <groupId>mysql</groupId>      <artifactId>mysql-connector-java</artifactId>      <version>8.0.17</version>    </dependency>    <dependency>      <groupId>tk.mybatis</groupId>      <artifactId>mapper</artifactId>      <version>4.0.0</version>    </dependency>  </dependencies></plugin>

3、创建generatorConfig.xml文件

<!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="Mysql" targetRuntime="MyBatis3Simple" defaultModelType="flat">    <property name="beginningDelimiter" value="`"/>    <property name="endingDelimiter" value="`"/>    <plugin type="tk.mybatis.mapper.generator.MapperPlugin">      <property name="mappers" value="tk.mybatis.mapper.common.Mapper"/>      <property name="caseSensitive" value="true"/>    </plugin>    <jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"                    connectionURL="jdbc:mysql://localhost:3306/kosi?characterEncoding=utf8&amp;useSSL=false&amp;serverTimezone=GMT%2B8"                    userId="root"                    password="root">    </jdbcConnection>    <javaModelGenerator targetPackage="com.example.klaus.model"                        targetProject="src/main/java"/>    <sqlMapGenerator targetPackage="mapper"                     targetProject="src/main/resources"/>    <javaClientGenerator targetPackage="com.example.klaus.mapper"                         targetProject="src/main/java"                         type="XMLMAPPER"/>    <table tableName="user" domainObjectName="User">      <generatedKey column="id" sqlStatement="JDBC"/>    </table>  </context></generatorConfiguration>

4、启动插件生成代码

评论

暂无评论