<?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="generator.properties"></properties>
    <!-- 配置数据库的context -->
    <context id="MysqlContext" targetRuntime="MyBatis3" defaultModelType="flat">
    	<!-- 设置文件编码 -->
        <property name="javaFileEncoding" value="UTF-8"/>
        <!-- 由于beginningDelimiter和endingDelimiter的默认值为双引号(")，在Mysql中不能这么写，所以还要将这两个默认值改为`  -->
        <property name="beginningDelimiter" value="`"/>
        <property name="endingDelimiter" value="`"/>

        <!-- 为生成的Java模型创建一个toString方法 -->
        <plugin type="org.mybatis.generator.plugins.ToStringPlugin"></plugin>

        <!-- 为生成的Java模型类添加序列化接口，并生成serialVersionUID字段 -->
        <plugin type="com.tudou.common.plugin.SerializablePlugin">
            <property name="suppressJavaInterface" value="false"/>
        </plugin>

        <!-- 生成在XML中的<cache>元素 -->
        <plugin type="org.mybatis.generator.plugins.CachePlugin">
            <!-- 使用ehcache -->
            <property name="cache_type" value="org.mybatis.caches.ehcache.LoggingEhcache" />
            <!-- 内置cache配置 -->
            <!--
            <property name="cache_eviction" value="LRU" />
            <property name="cache_flushInterval" value="60000" />
            <property name="cache_readOnly" value="true" />
            <property name="cache_size" value="1024" />
            -->
        </plugin>

        <!-- Java模型生成equals和hashcode方法 -->
        <plugin type="org.mybatis.generator.plugins.EqualsHashCodePlugin"></plugin>

        <!-- 生成的代码去掉注释 -->
        <commentGenerator type="com.tudou.common.plugin.CommentGenerator">
            <property name="suppressAllComments" value="true" />
            <property name="suppressDate" value="true"/>
        </commentGenerator>

        <!-- 数据库连接 -->
        <jdbcConnection driverClass="${generator.jdbc.driver}"
                        connectionURL="${generator.jdbc.url}"
                        userId="${generator.jdbc.username}"
                        password="123456" />

        <!-- model生成 -->
        <javaModelGenerator targetPackage="com.tudou.dao.model" targetProject="tudou/tudou-dao/src/main/java" />

        <!-- MapperXML生成 -->
        <sqlMapGenerator targetPackage="com.tudou.dao.mapper" targetProject="tudou/tudou-service/src/main/java" />

        <!-- Mapper接口生成 -->
        <javaClientGenerator targetPackage="com.tudou.dao.mapper" targetProject="tudou/tudou-dao/src/main/java" type="XMLMAPPER" />

        <!-- 需要映射的表 -->
        <table tableName="view_class_data" domainObjectName="ViewClassData">
        	<!-- 同表字段生成 -->
			<property name="useActualColumnNames" value="true"/>
        </table>
	</context>
</generatorConfiguration>

public class Users { 
    private int id;  
    private String userName;  
    private int userAge;  
    private String userAddress;  
}  

public class Article {  
     private int id;  
     private Users user;//外键  
     private String title;  
     private String content;  
}  

public class Blog {  
    private int id;  
    private String title;  
    private List<Article> articles;  
}  

<resultMap type="User" id="userResultMap">  
    <!-- 属性名和数据库列名映射 -->  
    <id property="id" column="user_id"  />  
    <result property="userName" column="user_userName"  />  
    <result property="userAge" column="user_userAge"  />  
    <result property="userAddress" column="user_userAddress"  />  
</resultMap>  
  
<!-- User join Article进行联合查询  (一对一)-->      
<resultMap id="articleResultMap" type="Article">  
    <id property="id" column="article_id" />  
    <result property="title" column="article_title" />  
    <result property="content" column="article_content" />  
    <!-- 将article的user属性映射到userResultMap -->  
    <association property="user" javaType="User" resultMap="userResultMap"/>    
</resultMap>  

<!-- 使用别名来映射匹配 -->  
<select id="getUserArticles" parameterType="int" resultMap="articleResultMap">  
   select user.id user_id,user.userName user_userName,user.userAddress user_userAddress,  
   article.id article_id,article.title article_title,article.content article_content   
   from users user,article   
   where user.id=article.userid and user.id=#{id}  
</select>  

<resultMap id="blogResultMap" type="Blog">  
    <id property="id" column="blog_id" />  
    <result property="title" column="blog_title" />  
    <!-- 将article list属性映射到collection -->  
    <collection property="articles" ofType="Article" resultMap="articleResultMap"/>  
</resultMap> 

<!-- select语句 -->  
<select id="getBlogByID" parameterType="int" resultMap="blogResultMap">  
   select user.id user_id,user.userName user_userName,user.userAddress user_userAddress,  
   article.id article_id,article.title article_title,article.content article_content,   
   blog.id blog_id, blog.title blog_title  
   from users user,article,blog   
   where user.id=article.userid and blog.id=article.blogid and blog.id=#{id}  
</select>  

<settings>
   <!-- 对在此配置文件下的所有cache 进行全局性开/关设置  默认值为true -->
   <setting name="cacheEnabled" value="true"/>
</settings>

<!-- 在UserMapper.xml中开启二缓存，UserMapper.xml下的任意sql执行完成后，都会存储到它的缓存区域(HashMap) -->
<mapper namespace="twm.mybatisdemo.mapper.UserMapper">
<!-- 开启本mapper namespace下的二级缓存 -->
<cache></cache>

<cache  eviction="FIFO" flushInterval="60000"  size="512" readOnly="true"/>

<select id="selectById" parameterType="int" resultType="User" useCache="true">
    select * from user where id=#{id}  
</select>

public class User implements Serializable{
    private static final long serialVersionUID = 1L;
    Integer id;
    ....
}

<selectid="findOrderListResultMap" resultMap="ordersUserMap" useCache="false">