<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>
转载于:https://www.cnblogs.com/waiwai1015/p/4609357.html
