Mybatis中反向生成代码使用的实现

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

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

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

			<!-- 数据库的连接信息 -->
		  <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>
			

	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();
		}
	}