使用mybatis-generator自动生成mapper和model

1.使用jar包

mybatis-generator-core-1.3.7.jar

https://github.com/mybatis/generator/releases/tag/mybatis-generator-1.3.7

mysql-connector-java

https://mvnrepository.com/artifact/mysql/mysql-connector-java

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="E:\mybatis-genation\mysql-connector-java-5.0.3.jar" />
  <context id="context1" >
    
   <commentGenerator>  
            <property name="suppressDate" value="true" />  
    </commentGenerator> 
    <jdbcConnection driverClass="com.mysql.jdbc.Driver" 
        connectionURL="jdbc:mysql://localhost:3306/chat?characterEncoding=utf8" userId="root" password="root">
    </jdbcConnection>
 
    <javaModelGenerator targetPackage="lcw.model" targetProject="E:\mybatis-genation\src">
            <property name="enableSubPackages" value="true" />  
            <property name="trimStrings" value="true" />  
    </javaModelGenerator>
    <sqlMapGenerator targetPackage="lcw.mapper" targetProject="E:\mybatis-genation\src">
       <property name="enableSubPackages" value="true" />
    </sqlMapGenerator>
    <javaClientGenerator targetPackage="lcw.mapper" targetProject="E:\mybatis-genation\src" type="XMLMAPPER">
       <property name="enableSubPackages" value="true" />
    </javaClientGenerator>
  <table tableName="%" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false"
      enableSelectByExample="false" selectByExampleQueryId="false" >
    </table>
  </context>
</generatorConfiguration>

  <table tableName="%" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false"
      enableSelectByExample="false" selectByExampleQueryId="false" >
    </table>这段表示生成库中的所有表的model,DAO，mapper也可以写成<table tableName="user" domainObjectName="User"

对应你想生成的表名

3.运行

java -jar mybatis-generator-core-1.3.7.jar -configfile generatorConfig.xml -overwrite