ibatis <sql>和<include>

<sql>和<include>，前者用来创建一个文本片段，这些片段可以组合起来创建完整的SQL语句；后者很显然就是包含的意思

 

<sql id="select-user">  

    select * from users  

</sql>  

<sql id="select-count">  

    select count(*) as value from users  

</sql>  

<sql id="where-age-over-value">  

    <![CDATA[ 

        where age > #value:INT# 

    ]]>  

</sql>  

<select id="getUserAgeOver" resultClass="hashmap">  

    <include refid="select-user" />  

    <include refid="where-age-over-value" />  

</select>  

<select id="getUserCountAgeOver" resultClass="int">  

    <include refid="select-count" />  

    <include refid="where-age-over-value" />  

</select>