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:数据库的JDBC驱动,换成自己的驱动位置 --> <classPathEntry location="D:\APP\maven\apache-maven-3.8.2\repository\mysql\mysql-connector-java\5.1.47\mysql-connector-java-5.1.47.jar" /> <!-- 一个数据库一个context --> <!--defaultModelType="flat" 大数据字段,不分表 --> <context id="MysqlTables" targetRuntime="MyBatis3" defaultModelType="flat"> <property name="autoDelimitKeywords" value="true"/> <property name="beginningDelimiter" value="`"/> <property name="endingDelimiter" value="`"/> <property name="javaFileEncoding" value="utf-8"/> <plugin type="org.mybatis.generator.plugins.SerializablePlugin"/> <plugin type="org.mybatis.generator.plugins.ToStringPlugin"/> <!-- 注释 --> <commentGenerator> <property name="suppressAllComments" value="true"/><!-- 是否取消注释 --> <property name="suppressDate" value="true"/> <!-- 是否生成注释代时间戳--> </commentGenerator> <!-- jdbc连接 --> <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://localhost:3306/test_mybatis" userId="root" password=""/> <!-- 类型转换 --> <javaTypeResolver> <!-- 是否使用bigDecimal, false可自动转化以下类型(Long, Integer, Short, etc.) --> <property name="forceBigDecimals" value="false"/> </javaTypeResolver> <javaModelGenerator targetPackage="com.yingxue.lesson.entity" targetProject="D:\APP\IDEA\workspace\mybatis-demo\mybatis-dao\src\main\java"> <property name="enableSubPackages" value="false"/> <property name="trimStrings" value="true"/> </javaModelGenerator> <sqlMapGenerator targetPackage="mapper" targetProject="D:\APP\IDEA\workspace\mybatis-demo\mybatis-dao\src\main\resources"> <property name="enableSubPackages" value="false"/> </sqlMapGenerator> <!-- 生成mapxml对应client,也就是接口dao --> <javaClientGenerator targetPackage="com.yingxue.lesson.mapper" targetProject="D:\APP\IDEA\workspace\mybatis-demo\mybatis-dao\src\main\java" type="XMLMAPPER"> <property name="enableSubPackages" value="false"/> </javaClientGenerator> <table tableName="sys_user" domainObjectName="SysUser" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="true"> <columnOverride column="sex" javaType="java.lang.Integer"/> <columnOverride column="status" javaType="java.lang.Integer"/> <columnOverride column="create_where" javaType="java.lang.Integer"/> <columnOverride column="deleted" javaType="java.lang.Integer"/> </table> </context> </generatorConfiguration>
在各项配置做好之后,在项目处双击该配置,即可生成实体类和mapper接口和mapper.xml文件
供自己学习~~~