An example of the <sql> and <include> tags

最新推荐文章于 2024-09-14 18:42:05 发布

yql1986

最新推荐文章于 2024-09-14 18:42:05 发布

阅读量419

点赞数

文章标签： include sql tags

ibatis_code_example 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

<sql id="select-order"> select * from order </sql>
<sql id="select-count"> select count(*) as value from order </sql>
<sql id="where-shipped-after-value">
    <![CDATA[
    where shipDate > #value:DATE#
    ]]>
</sql>

<select id="getOrderShippedAfter" resultClass="map">
    <include refid="select-order" />
    <include refid="where-shipped-after-value" />
</select>

<select id="getOrderCountShippedAfter" resultClass="int">
    <include refid="select-count" />
    <include refid="where-shipped-after-value" />
</select>