Mybatis逆向工程

Mybatis逆向工程

根据数据库中已经插入的表，生成对应的实体类、增删改查语句

所需工具

mybatis-generator-core-1.3.3.jar
mysql-connector-java-5.1.32.jar
generatorConfig.xml

链接：https://pan.baidu.com/s/1q7SDAZ5m9k9wtxzRbNUtmg 网盘下载
提取码：4tge

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="mysql-connector-java-5.1.32.jar" />
    <context id="write" targetRuntime="MyBatis3">
        <property name="autoDelimitKeywords" value="true"/>
        <property name="beginningDelimiter" value="`"/>
        <property name="endingDelimiter" value="`"/>
        <plugin type="org.mybatis.generator.plugins.SerializablePlugin"/>
        <commentGenerator>
            <property name="suppressDate" value="false"/>
            <property name="suppressAllComments" value="true"/>
        </commentGenerator>
		<!-- 修改要链接的数据库IP、数据库名、连接用户名、密码-->
        <jdbcConnection driverClass="com.mysql.jdbc.Driver"
                        connectionURL="jdbc:mysql://127.0.0.1:3306/dbName?tinyInt1isBit=false"
                        userId="connectName" password="dbpwd"/>
		<!-- 修改实体类生成的位置-->
        <javaModelGenerator targetPackage="com.lxk.front.sync.entity"
                            targetProject="../lxk/src/main/java">
            <property name="enableSubPackages" value="false"/>
            <property name="trimStrings" value="true"/>
        </javaModelGenerator>
		<!-- 修改xml生成的位置-->
        <sqlMapGenerator targetPackage="user.mapper"
                         targetProject="../lxk/src/main/resources">
            <property name="enableSubPackages" value="false"/>
        </sqlMapGenerator>
		<!-- 修改dao生成的位置-->
        <javaClientGenerator targetPackage="com.lxk.front.sync.dao.zhyy"
                             targetProject="../lxk/src/main/java" type="XMLMAPPER">
            <property name="enableSubPackages" value="false"/>
        </javaClientGenerator>
		<!-- 指定表名，生成实体类的类名-->
        <table tableName="user" domainObjectName="User"	enableDeleteByPrimaryKey="false" enableInsert="true"	enableUpdateByPrimaryKey="false" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false"	enableSelectByExample="false" selectByExampleQueryId="false"> 	</table>

    </context>
</generatorConfiguration>

启动

将generatorConfig.xml放入工程根目录下，进入dos下，进入当前工程目录下，或者直接打开终端 执行下面的指令
java -jar mybatis-generator-core-1.3.3.jar -configfile generatorConfig.xml -overwrite