Mybatis中反向生成代码使用

9.Mybatis中的代码反向生成器

反向生成核心配置文件generatorConfig.xml (eclipse)

<?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 >
<!-- 本地电脑的  mysql驱动位置  一定需要加  jar名称 -->
	<classPathEntry location="" />
	<context id="context1" defaultModelType="flat">
		
		<!-- PO序列化 -->
		<plugin type="org.mybatis.generator.plugins.SerializablePlugin">
		</plugin>

		<commentGenerator>
			<!-- 是否去除自动生成的注释 true：是 ： false:否 -->
			<property name="suppressAllComments" value="false" />
		</commentGenerator>

	
			<!-- 数据库的连接信息 -->
		  <jdbcConnection driverClass="com.mysql.jdbc.Driver" 
		          connectionURL="jdbc:mysql://localhost:3306/no4" 
		          userId="root" 
		          password="root"> 
			</jdbcConnection>
			
		<javaTypeResolver>
			<property name="forceBigDecimals" value="false"/>
		</javaTypeResolver> 

		<!--生成Model类存放位置  targetPackage="实体包位置"-->
		<javaModelGenerator targetPackage="com.oracle.pojo"
			targetProject="">
			<property name="trimStrings" value="true" />
		</javaModelGenerator>

		<!--生成映射文件存放位置 -->
		<sqlMapGenerator targetPackage="com.oracle.mapper"
			targetProject="">
			<property name="trimStrings" value="true" />
		</sqlMapGenerator>

		<!--生成Dao类存放位置 -->
		<javaClientGenerator targetPackage="com.oracle.mapper"
			targetProject="" type="XMLMAPPER" />

		<!--生成对应表及类名-->
		<table schema=""  tableName="" domainObjectName="" enableCountByExample="true" enableUpdateByExample="true"
			enableDeleteByExample="true" enableSelectByExample="true"
			selectByExampleQueryId="true">
		</table> 

       
    
	</context>
</generatorConfiguration>

反向生成核心配置文件generatorConfig.xml (idea)

<?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>
    <context id="test" targetRuntime="MyBatis3">
        <plugin type="org.mybatis.generator.plugins.EqualsHashCodePlugin"></plugin>
          
        <plugin type="org.mybatis.generator.plugins.SerializablePlugin"></plugin>
         
        <plugin type="org.mybatis.generator.plugins.ToStringPlugin"></plugin>
         
        <commentGenerator>
            <!-- 这个元素用来去除指定生成的注释中是否包含生成的日期 false:表示保护 -->
            <!-- 如果生成日期，会造成即使修改一个字段，整个实体类所有属性都会发生变化，不利于版本控制，所以设置为true -->
            <property name="suppressDate" value="true" />
            <!-- 是否去除自动生成的注释 true：是 ： false:否 -->
            <property name="suppressAllComments" value="true" />
        </commentGenerator>
        
        <!--数据库链接URL，用户名、密码 -->
        <jdbcConnection driverClass="com.mysql.jdbc.Driver"
            connectionURL="jdbc:mysql://192.168.25.100:3306/authority" userId="root" password="xxx.">
            <!-- 解决table schema中有多个重名的表生成表结构不一致问题 -->
            <property name="nullCatalogMeansCurrent" value="true"/>
        </jdbcConnection>
        
        <javaTypeResolver>
            <!-- This property is used to specify whether MyBatis Generator should 
                force the use of java.math.BigDecimal for DECIMAL and NUMERIC fields, -->
            <property name="forceBigDecimals" value="false" />
        </javaTypeResolver>
        
        <!-- 生成模型的包名和位置 -->
        <javaModelGenerator targetPackage="com.li.pojo"
            targetProject="src/main/java">
            <property name="enableSubPackages" value="true" />
            <property name="trimStrings" value="true" />
        </javaModelGenerator>
        
        <!-- 生成映射文件的包名和位置 -->
        <sqlMapGenerator targetPackage="/mapper"
            targetProject="src/main/resources">
            <property name="enableSubPackages" value="true" />
        </sqlMapGenerator>
        
        <!-- 生成DAO的包名和位置 -->
        <javaClientGenerator type="XMLMAPPER"
            targetPackage="com.li.mapper" implementationPackage="com.li.mapper"  targetProject="src/main/java">
            <property name="enableSubPackages" value="true" />
        </javaClientGenerator>
        
         <table tableName="categorys" domainObjectName="Category"
            enableCountByExample="true" enableUpdateByExample="true"
            enableDeleteByExample="true" enableSelectByExample="true"
            selectByExampleQueryId="true">
        </table>


        
      
    </context>
</generatorConfiguration>

导入maven

            <plugin>
                    <groupId>org.mybatis.generator</groupId>
                    <artifactId>mybatis-generator-maven-plugin</artifactId>
                    <version>1.3.2</version>
                    <dependencies>
                        <dependency>
                            <groupId>mysql</groupId>
                            <artifactId>mysql-connector-java</artifactId>
                            <version>5.1.46</version>
                        </dependency>
                    </dependencies>
                    <configuration>
                        <!--配置文件的路径 -->
                        <configurationFile>${basedir}/src/main/resources/generatorConfig.xml</configurationFile>
                        <overwrite>true</overwrite>
                    </configuration>
              </plugin>

注意：mysql8.0版本需要添加以下语句，否则实体类中生成字段不一致

			<!-- 数据库的连接信息 -->
		  <jdbcConnection driverClass="com.mysql.cj.jdbc.Driver" 
		          connectionURL="jdbc:mysql://localhost:3306/test?serverTimezone=UTC" 
		          userId="root" 
		          password="xxx"> 
		       <!-- 解决table schema中有多个重名的表生成表结构不一致问题 -->
			<property name="nullCatalogMeansCurrent" value="true"/>
			</jdbcConnection>
			

关于反向生成多条件查询代码的使用

1.创建对应的实体类example对象

2.创建Criteria对象

3.向Criteria对象中封装对应参数的各种条件

4.将example对象交给selectByExample方法进行查询

	public List<Cities> findCityByProId(String provinceId) {
		SqlSession sqlSession = DBUtils.createDbUtils().getSQLSession();
		CitiesMapper mapper = sqlSession.getMapper(CitiesMapper.class);
		try {
			CitiesExample citiesExample = new CitiesExample();
			Criteria criteria = citiesExample.createCriteria();
			criteria.andProvinceidEqualTo(provinceId);
			List<Cities> citiesList = mapper.selectByExample(citiesExample);
			return citiesList;
		}finally {
			sqlSession.close();
		}
	}