使用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
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