mybatis generator使用

csj50

已于 2024-08-02 15:44:25 修改

阅读量324

点赞数

分类专栏：其它文章标签： mybatis

于 2020-06-02 18:23:04 首次发布

本文链接：https://blog.youkuaiyun.com/csj50/article/details/106502188

版权

其它专栏收录该内容

76 篇文章

订阅专栏

1、创建generatorConfig.xml

2、模板

<?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="C:/Users/User/.m2/repository/com/oracle/ojdbc14/10.2.0.4.0/ojdbc14-10.2.0.4.0.jar" />
	<context id="context1" targetRuntime="MyBatis3">
		<commentGenerator>
			<property name="suppressAllComments" value="true" /><!-- 取消生成的注释信息 -->
		</commentGenerator>
		<jdbcConnection driverClass="oracle.jdbc.driver.OracleDriver"
			connectionURL="jdbc:oracle:thin:@192.168.101.101:1522:ORCL" userId="qh_vtas_new"
			password="qh_vtas_new" />
			
		<javaModelGenerator targetPackage="com.create.entity"
			targetProject="accs-bas/src/main/java" />
			
		<sqlMapGenerator targetPackage="com.create.xml"
			targetProject="accs-bas/src/main/resources" />
			
		<javaClientGenerator type="XMLMAPPER"
			targetPackage="com.create.entity" 
			targetProject="accs-bas/src/main/java" >
		</javaClientGenerator>
			
	<table tableName="%" schema="QH_VTAS_NEW" enableCountByExample="false"
		enableUpdateByExample="false" enableDeleteByExample="false"
		enableSelectByExample="false" selectByExampleQueryId="false">
	</table>
	</context>
</generatorConfiguration>

说明：
1）targetRuntime可选MyBatis3和MyBatis3Simple，建议使用MyBatis3
不加默认是生成3个带注解的类，可能是MyBatis4风格？
2）生成某个用户下的所有表，一定要加schema
tableName="%" schema="QH_VTAS_NEW"

3、例子
注意：标签有顺序要求

<?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="C:/Users/xxx/.m2/repository/com/oracle/ojdbc6/11.2.0.3/ojdbc6-11.2.0.3.jar" />
  <context id="context1"  targetRuntime="MyBatis3Simple" >
    <commentGenerator>
		<property name="suppressAllComments" value="true" /><!-- 取消生成的注释信息 -->
	</commentGenerator>
    
    <jdbcConnection connectionURL="jdbc:oracle:thin:@//192.168.10.186:1521/offlcstd" driverClass="oracle.jdbc.driver.OracleDriver" password="okfep" userId="okfep" />
    
    <javaModelGenerator targetPackage="com.thinkgem.jeesite.temp" targetProject="okfep/src/main/java" />
    
    <sqlMapGenerator targetPackage="mappings.modules.temp" targetProject="okfep/src/main/resources"></sqlMapGenerator>
    
    <javaClientGenerator targetPackage="com.thinkgem.jeesite.temp" targetProject="okfep/src/main/java" type="XMLMAPPER" />
    
    <table schema="okfep" tableName="kq_group_chnl_bind">
    </table>
    <table schema="okfep" tableName="kq_group_merc_bind">
    </table>
    <table schema="okfep" tableName="kq_merc_chnl_bind">
    </table>
    <table schema="okfep" tableName="kq_merc_chnl_store_bind">
    </table>
    
  </context>
</generatorConfiguration>