[ibatis] 공용으로 조건문 사용하기, WHERE 공동사용

<!--  테이블 구조와 where 구조를 블럭화 한다 -->

<sql id="selectItem_fragment">

FROM items

WHERE parentid = 6

</sql>
<!-- 셀렉트 문 밑에 iclude 를 이용하여 붙여 넣기했다 -->
<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>

---

<!-- 파라메타 있는 구분도 가능 하다 -->

<sql id="selectItem_fragment">
FROM items
WHERE parentid = #value#
</sql>
<select id="selectItemCount" parameterClass="int" resultClass="int">
SELECT COUNT(*) AS total
<include refid="selectItem_fragment"/>
</select>
<select id="selectItems" parameterClass="int" resultClass="Item">
SELECT id, name
<include refid="selectItem_fragment"/>
</select>