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

	
			<!-- 數(shù)據(jù)庫的連接信息 -->
		  <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:表示保護 -->
            <!-- 如果生成日期，會造成即使修改一個字段，整個實體類所有屬性都會發(fā)生變化，不利于版本控制，所以設置為true -->
            <property name="suppressDate" value="true" />
            <!-- 是否去除自動生成的注釋 true：是 ： false:否 -->
            <property name="suppressAllComments" value="true" />
        </commentGenerator>
        
        <!--數(shù)據(jù)庫鏈接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>

			<!-- 數(shù)據(jù)庫的連接信息 -->
		  <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();
		}
	}