Mybatis配置代码生成脚本

通过配置mybatis-generator.xml。连接DB后，可根据配置项，自动生成modle类，mapper接口文件以及mapper文件，并且自动配置好增删改查代码。

<?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>  

	<properties resource="bidm.properties"></properties> 
      
    <context id="OracleTables"    targetRuntime="MyBatis3">  
        <commentGenerator>  
            <property name="suppressDate" value="true"/>  
            <property name="suppressAllComments" value="true"/>  
        </commentGenerator>  
        <!--数据库链接地址账号密码-->  
        <jdbcConnection driverClass="${com.boe.bidm.db[0][driver]}" connectionURL="${com.boe.bidm.db[0][url]}" userId="${com.boe.bidm.db[0][username]}" password="${com.boe.bidm.db[0][password]}">  
        </jdbcConnection>  
        <javaTypeResolver>  
            <property name="forceBigDecimals" value="false"/>  
        </javaTypeResolver>  
        <!--生成Model类存放位置-->  
        <javaModelGenerator targetPackage="com.boe.bidm.project.model.mybatis" targetProject="src/main/java">  
            <property name="enableSubPackages" value="true"/>  
            <property name="trimStrings" value="true"/>  
        </javaModelGenerator>  
        <!--生成映射文件存放位置 -->
        <sqlMapGenerator targetPackage="com.boe.bidm.project.mapper.xml" targetProject="src/main/java">  
            <property name="enableSubPackages" value="true"/>  
        </sqlMapGenerator>  
        <!--	生成Dao类存放位置-->  
        <!-- 客户端代码，生成易于使用的针对Model对象和XML配置文件 的代码  
                type="ANNOTATEDMAPPER",生成Java Model 和基于注解的Mapper对象  
                type="MIXEDMAPPER",生成基于注解的Java Model 和相应的Mapper对象  
                type="XMLMAPPER",生成SQLMap XML文件和独立的Mapper接口  
        -->  
        <javaClientGenerator type="XMLMAPPER" targetPackage="com.boe.bidm.project.mapper" targetProject="src/main/java">  
            <property name="enableSubPackages" value="true"/>  
        </javaClientGenerator>  
        <table tableName="bidm_SQL" domainObjectName="bidmSql" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"></table> 
    </context>  
</generatorConfiguration> 

在POM文件配置Maven插件

<plugin>  
                <groupId>org.mybatis.generator</groupId>  
                <artifactId>mybatis-generator-maven-plugin</artifactId>  
                <version>1.3.7</version>  
                <!-- 如果不配置这段,在项目package或install时会自动执行generator命令 -->
                <executions>
				  <execution>
					  <id>Generate MyBatis Artifacts</id>
					  <phase>deploy</phase>
					  <goals>
					      <goal>generate</goal>
					  </goals>
				  </execution>
				</executions>
				
                <dependencies>  
                    <dependency>
						<groupId>com.oracle</groupId>
						<artifactId>ojdbc</artifactId>
						<version>7.0.0</version>
						<scope>system</scope>
						<systemPath>${basedir}/lib/ojdbc7.jar</systemPath>
					</dependency>
                    <dependency>  
                        <groupId>org.mybatis.generator</groupId>  
                        <artifactId>mybatis-generator-core</artifactId>  
                        <version>1.3.7</version>  
                    </dependency>  
                </dependencies>  
                <configuration>  
                    <!--允许移动生成的文件 -->  
                    <verbose>true</verbose>  
                    <!-- 是否覆盖 -->  
                    <overwrite>true</overwrite>  
                    <!-- 自动生成的配置 -->  
                    <configurationFile>  
                        src/main/resources/mybatis-generator.xml</configurationFile>  
                </configuration>  
            </plugin> 

Run Configurations

通过 以上配置，就可快速的构建代码