springboot mybatis 自动生成代码(maven+IntelliJ IDEA)
1.在pom文件中加入需要的依赖(mybatis-generator-core) 和 插件(mybatis-generator-maven-plugin)
<dependency>
<groupId>org.mybatis.generatorgroupId>
<artifactId>mybatis-generator-coreartifactId>
<version>1.3.2version>
dependency>
<plugin>
<groupId>org.mybatis.generatorgroupId>
<artifactId>mybatis-generator-maven-pluginartifactId>
<version>1.3.2version>
<configuration>
<configurationFile>src/main/resources/configXml/generatorConfig.xmlconfigurationFile>
<verbose>trueverbose>
<overwrite>trueoverwrite>
configuration>
plugin>
2.配置自动生成代码的文件 generatorConfig.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="D:\workProjects\springBootMybatis\src\main\resources\lib\mysql-connector-java-5.1.9.jar"/>
<context id="MysqlTables" targetRuntime="MyBatis3">
<commentGenerator>
<property name="suppressAllComments" value="true" />
commentGenerator>
<jdbcConnection driverClass="com.mysql.jdbc.Driver"
connectionURL="jdbc:mysql://localhost:3306/test_mybatis"
userId="root" password="123456">
jdbcConnection>
<javaTypeResolver>
<property name="forceBigDecimals" value="false" />
javaTypeResolver>
<javaModelGenerator targetPackage="com.example.springmybatis.entity"
targetProject="D:\workProjects\springBootMybatis\src\main\java">
<property name="enableSubPackages" value="true" />
<property name="trimStrings" value="true" />
javaModelGenerator>
<sqlMapGenerator targetPackage="mapper"
targetProject="D:\workProjects\springBootMybatis\src\main\resources">
<property name="enableSubPackages" value="true" />
sqlMapGenerator>
<javaClientGenerator targetPackage="com.example.springmybatis.dao"
targetProject="D:\workProjects\springBootMybatis\src\main\java"
type="XMLMAPPER">
<property name="enableSubPackages" value="true" />
javaClientGenerator>
<table tableName="order_info" domainObjectName="OrderInfo"
enableInsert="true" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false"
enableSelectByExample="false" selectByExampleQueryId="false">
table>
context>
generatorConfiguration>
注意事项:
- mysql驱动jar包加载,location=“必须是绝对路径”
- 配置文件中 context 节点下的内容,一定要按照以下顺序来(没有的可以不写,有的一定要按照顺序)
- 生成文件路径配置
- 执行生成代码操作(IntelliJ IDEA) 涉及的命令:mybatis-generator:generate -e
- 表结构与生成实体
如有什么不合适的地,烦请个位大佬指出纠正!