Skip to content

Instantly share code, notes, and snippets.

@user20161119
Created April 2, 2015 08:32
Show Gist options
  • Save user20161119/9ab1ed3aa7ff49b6dc0b to your computer and use it in GitHub Desktop.
Save user20161119/9ab1ed3aa7ff49b6dc0b to your computer and use it in GitHub Desktop.
<?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用于设置MBG的classPath,location可以等于只包含了数据库驱动的jar或zip路经 也可以是一个包含驱动的目录。它是一个可选的元素。 -->
<classPathEntry location="c:/ojdbc14.jar" />
<!-- targetRuntime代码生成目标,默认是MyBatis3,可以是Ibatis2Java2或者Ibatis2Java5 -->
<context id="DB2Tables" targetRuntime="MyBatis3">
<!-- 数据库连接属性,没什么好说 -->
<jdbcConnection driverClass="oracle.jdbc.driver.OracleDriver"
connectionURL="jdbc:oracle:thin:@127.0.0.1:1521:ZFGJJ" userId="hr"
password="hr">
</jdbcConnection>
<!-- 解决数字转换问题 -->
<javaTypeResolver>
<!-- 只有一个属于forceBigDecimals,默认false。如果字段精确超过0,生成BigDecimal 如果字段精确是0,总长度10-18生成Long;
如果字段精确是0,总长5-9生成Integer; 如果字段精确是0,总长小于5生成Short; 如果forceBigDecimals为true,统一生成BigDecimal -->
<property name="forceBigDecimals" value="false" />
</javaTypeResolver>
<!-- Model生成配置 targetPackage:生成包路径,可自己生成目录 targetProject:项目路经,我试过写成"\mybatis",但总是报找不到,不知原因。
我换成写绝对目录,行的通。 -->
<javaModelGenerator targetPackage="test.model"
targetProject="D:\Workspace\mylearn\mybatis\">
<property name="enableSubPackages" value="true" />
<property name="trimStrings" value="true" />
</javaModelGenerator>
<!-- sqlMap配置 重复配置,不再提示,下同 -->
<sqlMapGenerator targetPackage="test.xml"
targetProject="D:\Workspace\mylearn\mybatis\">
<property name="enableSubPackages" value="true" />
</sqlMapGenerator>
<!-- DAO接口的生成 -->
<javaClientGenerator type="XMLMAPPER"
targetPackage="test.dao" targetProject="D:\Workspace\mylearn\mybatis\">
<property name="enableSubPackages" value="true" />
</javaClientGenerator>
<!-- table 数据库table的用户配置,用于配置哪些表需要。 domainObjectName:生成表前缀 -->
<table schema="hr" tableName="countries" domainObjectName="Customer">
<!-- 下面是不同数据库表特性 参见 mybatis-generator-core.**.jar 里面的 Database Specific
Information -->
<property name="ignoreQualifiersAtRuntime" value="true" />
<property name="runtimeTableName" value="FRED" />
<!-- 主键生成 如果用了这个 generatedKey ,MBG将在sqlmpper.xml里生成一个 selectKey元素在用在<insert>元素里 。 -->
<generatedKey column="COUNTRY_ID" sqlStatement="JDBC"
identity="true" />
</table>
</context>
</generatorConfiguration>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment