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" result/> ?
? ? <include refid="where-age-over-value" /> ?
</select> ?
<select id="getUserCountAgeOver" result/> ?
? ? <include refid="where-age-over-value" /> ?
</select>?
