- <sql id="selectItem_fragment">
- FROM items
- WHERE parentid = 6
- </sql>
- <select id="selectItemCount" resultClass="int">
- SELECT COUNT(*) AS total
- <include refid="selectItem_fragment"/>
- </select>
- <select id="selectItems" resultClass="Item">
- SELECT id, name
- <include refid="selectItem_fragment"/>
- </select>
IBATIS中的include功能
原文:http://www.cnblogs.com/waiwai1015/p/4609357.html