IBATIS中的include功能

  1. <sql id="selectItem_fragment">  
  2.     FROM items  
  3.     WHERE parentid = 6  
  4. </sql>  
  5. <select id="selectItemCount" resultClass="int">  
  6.     SELECT COUNT(*) AS total  
  7.     <include refid="selectItem_fragment"/>  
  8. </select>  
  9. <select id="selectItems" resultClass="Item">  
  10.     SELECT id, name  
  11.     <include refid="selectItem_fragment"/>  
  12. </select>
原文地址:https://www.cnblogs.com/waiwai1015/p/4609357.html