IBATIS提取共用的SQL

在实际编写 <sqlMap> 的时候， 有些查询条件是共用的， 比如：

计算分页数量和查询分页数据的SQL Where 条件，那么，我们可以把它使用一个SQL标记起来提取成一个公用语句块。

 

 比如：查询

 

    <select id="listMessItemWithPage" resultMap="messResult" parameterClass="map">
	select * from information_content_item
        <include refid="MessItem_Where_Condition" />
        order by id limit #start#,#rowsPerPage#
    </select>

    <select id="countMessItem" resultClass="int" parameterClass="map">
	select count(*) from information_content_item
        <include refid="MessItem_Where_Condition" />
    </select>
    

 

共用SQL模块：

 

<sql id="MessItem_Where_Condition" >
        <dynamic prepend=" WHERE ">
            <isPropertyAvailable property="typeId">
                <isNotEmpty property="typeId" prepend=" and ">
                    type_id = '$typeId$'
                </isNotEmpty>
            </isPropertyAvailable>
            <isPropertyAvailable property="articleTitle">
                <isNotNull property="articleTitle" prepend=" and ">
                    article_title like '%$articleTitle$%'
                </isNotNull>
            </isPropertyAvailable>
            <isPropertyAvailable property="beginDate">
                <isPropertyAvailable property="endDate">
                    <isNotNull property="beginDate" prepend="">
                        <isNotNull property="endDate" prepend=" and ">
                            (release_date between '$beginDate$' and '$endDate$')
                        </isNotNull>
                    </isNotNull>
                </isPropertyAvailable>
            </isPropertyAvailable>
            <isPropertyAvailable property="releaseStatusTag">
                <isNotEmpty property="releaseStatusTag" prepend=" and ">
                    release_status_tag = $releaseStatusTag$
                </isNotEmpty>
            </isPropertyAvailable>
            <isPropertyAvailable property="beginHit">
                <isPropertyAvailable property="endHit">
                    <isNotNull property="beginHit" prepend="">
                        <isNotNull property="endHit" prepend=" and ">
                            (visits between $beginHit$ and $endHit$)
                        </isNotNull>
                    </isNotNull>
                </isPropertyAvailable>
            </isPropertyAvailable>
        </dynamic>
    </sql>