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>?