mybatis+ibatis 自动生成方法

最新推荐文章于 2019-04-15 21:12:55 发布

zwxu_

最新推荐文章于 2019-04-15 21:12:55 发布

阅读量2.1k

点赞数

本文链接：https://blog.csdn.net/xzw_910918/article/details/51218848

版权

1.mybatis自动生成

maven插件生成----mybatis-generator:generate
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="D:\Program Files\maven\respositories\mysql\mysql-connector-java\5.1.38\mysql-connector-java-5.1.38.jar" />
    <context id="DB2Tables"    targetRuntime="MyBatis3">
       

        <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://localhost:3306/shop" userId="root" password="">
        </jdbcConnection>
  	<javaModelGenerator targetPackage="com.ustc.entity" targetProject="D:\Projects\EclipseProjects\shop\src\main\java" />
    <sqlMapGenerator targetPackage="com.ustc.mapper" targetProject="D:\Projects\EclipseProjects\shop\src\main\java" />
    <javaClientGenerator targetPackage="com.ustc.mapper" targetProject="D:\Projects\EclipseProjects\shop\src\main\java" type="XMLMAPPER" />
    
       <table tableName="t_user" domainObjectName="User" enableCountByExample="false" 
       enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" 
       selectByExampleQueryId="false">
       </table>
    </context>
</generatorConfiguration>

pom.xml
 <plugin>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-maven-plugin</artifactId>
                <version>1.3.2</version>
                <configuration>
                    <verbose>true</verbose>
                    <overwrite>true</overwrite>
                </configuration>
            </plugin>

2.ibatis自动生成

eclipse插件
下载地址：http://ibatis.apache.org/tools/ibator
此时会自动生成ibatorConfig.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE ibatorConfiguration PUBLIC "-//Apache Software Foundation//DTD Apache iBATIS Ibator Configuration 1.0//EN" "http://ibatis.apache.org/dtd/ibator-config_1_0.dtd" >
<ibatorConfiguration >
 <classPathEntry location="D:\Program Files\maven\respositories\mysql\mysql-connector-java\5.1.30\mysql-connector-java-5.1.30.jar"/>
 
  <ibatorContext id="context1" >
  
    <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://10.238.145.102:3306/cashbase_lc_aip" userId="root" password="Xiaomi.com#sh" />
     
    <javaModelGenerator targetPackage="com.payment.lc.aip.model" targetProject="lc-aip-task/src/main/java" />
    <sqlMapGenerator targetPackage="com.payment.lc.aip.model" targetProject="lc-aip-task/src/main/java" />
    <daoGenerator targetPackage="com.payment.lc.aip.dao" targetProject="lc-aip-task/src/main/java" type="SPRING" />
    <table schema="cashbase_lc_aip" tableName="t_plan_execute" domainObjectName="PlanExecute">
      <generatedKey column="ID" sqlStatement="MYSQL" identity="true"  />
    </table>
  </ibatorContext>
</ibatorConfiguration>

然后右击ibatorConfig.xml选择“Generate iBATIS Artifacts”即可生成，同理mybatis也可以用此方法--Generate MyBATIS Artifacts