mybatis动态Sql(where)和sql片段

sql片段的定义;

    <sql id="condition">
        <if test="entity.dicttype != null"> and `dicttype` = #{entity.dicttype} </if>
        <if test="entity.dictname != null  and entity.dictname != ''"> and `dictname` LIKE concat(concat('%',#{entity.dictname}),'%')  </if>
        <if test="entity.sortno != null"> and `sortno` = #{entity.sortno} </if>
        <if test="entity.status != null"> and `status` = #{entity.status}</if>
        <if test="entity.dictcode != null and entity.dictcode != '' "> and `dictcode`  LIKE concat(concat('%',#{entity.dictcode}),'%') </if>
        <if test="entity.createTime != null"> and `create_time` = #{entity.createTime} </if>
        <if test="entity.createBy != null"> and `create_by` = #{entity.createBy} </if>
        <if test="entity.lastModifyTime != null"> and `last_modify_time` = #{entity.lastModifyTime} </if>
        <if test="entity.lastModifyBy != null"> and `last_modify_by` = #{entity.lastModifyBy} </if>
    </sql>

sql片段的使用：

        /**mycat:schema=${schemaLabel}*/ select * from t_ac_dictdeta
        <where>
3             <include refid="condition" />
4         </where>
        order by dictid asc
        <if test="entity.offset != null and entity.limit != null">
            limit #{entity.offset}, #{entity.limit}
        </if>