mybatis扩展联合查询条件

在实际开发，一般都用mybatis generator插件，还有谁自己一行一行的写的吗？
业务逻辑最重要mybatis generator插件生成的mapper文件，不过mybatis generator插件生成针对单表的比较适合，但是联表查询就有些麻烦了。
1 自动生成的Example_Where_Clause

<sql id="Example_Where_Clause">
    <!--
      WARNING - @mbggenerated
      This element is automatically generated by MyBatis Generator, do not modify.
      This element was generated on Fri Sep 18 12:09:11 CST 2015.
    -->
    <where>
      <foreach collection="oredCriteria" item="criteria" separator="or">
        <if test="criteria.valid">
          <trim prefix="(" prefixOverrides="and" suffix=")">
            <foreach collection="criteria.criteria" item="criterion">
              <choose>
                <when test="criterion.noValue">
                  and ${criterion.condition}
                </when>
                <when test="criterion.singleValue">
                  and ${criterion.condition} #{criterion.value}
                </when>
                <when test="criterion.betweenValue">
                  and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}
                </when>
                <when test="criterion.listValue">
                  and ${criterion.condition}
                  <foreach close=")" collection="criterion.value" item="listItem" open="(" separator=",">
                    #{listItem}
                  </foreach>
                </when>
              </choose>
            </foreach>
          </trim>
        </if>
      </foreach>
    </where>
  </sql>

2 扩展的Example_Where_Clause_Udf
增加一个扩展的查询条件，扩展规则：1.将注释去掉,去掉注释，是因为mybatis generator插件可以重复生成，去掉注释后就不会覆盖你自己定义的代码。2.讲where去掉。3.将trim去掉。4.增加别名，ucsPermission是表别名。

<sql id="Example_Where_Clause_Complex">
		<foreach collection="ucsPermissionExample.oredCriteria" item="criteria" separator="or">
			<if test="criteria.valid">
				<foreach collection="criteria.criteria" item="criterion">
					<choose>
						<when test="criterion.noValue">
                  and ucsPermission.${criterion.condition}
						</when>
						<when test="criterion.singleValue">
                  and ucsPermission.${criterion.condition} #{criterion.value}
						</when>
						<when test="criterion.betweenValue">
                  and ucsPermission.${criterion.condition} #{criterion.value} and #{criterion.secondValue}
						</when>
						<when test="criterion.listValue">
                  and ucsPermission.${criterion.condition}
							<foreach close=")" collection="criterion.value" item="listItem" open="(" separator=",">
                    #{listItem}
							</foreach>
						</when>
					</choose>
				</foreach>
			</if>
		</foreach>
	</sql>

3 联表自定义的example实例
其中UcsUserExample 和UcsPermissionExample 就是mybatis generator自动生成的example。

public class UcsUserPermissionExample {
	private UcsUserExample ucsUserExample;
	private UcsPermissionExample ucsPermissionExample;
	
	public UcsUserPermissionExample(){
		this.ucsUserExample = new UcsUserExample();
		this.ucsPermissionExample = new UcsPermissionExample();
	}
	
	public UcsUserExample getUcsUserExample() {
		return ucsUserExample;
	}
	public void setUcsUserExample(UcsUserExample ucsUserExample) {
		this.ucsUserExample = ucsUserExample;
	}
	public UcsPermissionExample getUcsPermissionExample() {
		return ucsPermissionExample;
	}
	public void setUcsPermissionExample(UcsPermissionExample ucsPermissionExample) {
		this.ucsPermissionExample = ucsPermissionExample;
	}
}