我使用的开发工具时idea
pom文件:
<build> <plugins> <plugin> <groupId>org.mybatis.generator</groupId> <artifactId>mybatis-generator-maven-plugin</artifactId> <version>1.3.6</version> <configuration> <configurationFile> mybatis-generator/generatorConfig.xml </configurationFile> <overwrite>true</overwrite> <verbose>true</verbose> </configuration> <dependencies> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.44</version> </dependency> <dependency> <groupId>com.itfsw</groupId> <artifactId>mybatis-generator-plugin</artifactId> <version>1.1.2</version> </dependency> </dependencies> </plugin> </plugins> </build>
项目目录:
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> <context id="mysqlgenerator" targetRuntime="MyBatis3"> <property name="autoDelimitKeywords" value="true" /> <!--可以使用``包括字段名,避免字段名与sql保留字冲突报错 --> <property name="beginningDelimiter" value="`" /> <property name="endingDelimiter" value="`" /> <!-- 自动生成toString方法 --> <plugin type="org.mybatis.generator.plugins.ToStringPlugin" /> <!-- 自动生成equals方法和hashcode方法 --> <plugin type="org.mybatis.generator.plugins.EqualsHashCodePlugin" /> <!-- 非官方插件 https://github.com/itfsw/mybatis-generator-plugin --> <!-- 查询单条数据插件 --> <plugin type="com.itfsw.mybatis.generator.plugins.SelectOneByExamplePlugin" /> <!-- 查询结果选择性返回插件 --> <plugin type="com.itfsw.mybatis.generator.plugins.SelectSelectivePlugin" /> <!-- Example Criteria 增强插件 --> <plugin type="com.itfsw.mybatis.generator.plugins.ExampleEnhancedPlugin" /> <!-- 数据Model属性对应Column获取插件 --> <plugin type="com.itfsw.mybatis.generator.plugins.ModelColumnPlugin" /> <!--去掉注解--> <commentGenerator> <property name="suppressDate" value="true"/> <property name="suppressAllComments" value="true"/> </commentGenerator> <!--数据库连接信息 --> <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://127.0.0.1:3306/heizhu?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC&verifyServerCertificate=false&useSSL=false" userId="root" password="root" /> <javaModelGenerator targetPackage="com.datbc.pig360.db.domain" targetProject="src/main/java" /> <sqlMapGenerator targetPackage="com.datbc.pig360.db.dao" targetProject="src/main/resources" /> <javaClientGenerator type="XMLMAPPER" targetPackage="com.datbc.pig360.db.dao" targetProject="src/main/java" /> <!--表名 --> <!--上链日志--> <table tableName="manager_bc_log"> <generatedKey column="id" sqlStatement="MySql" identity="true" /> <columnOverride javaType="java.time.LocalDateTime" column="add_time" /> </table> </context> </generatorConfiguration>
使用步骤:
然后每次添加新表后,就可以直接点击这里生成了