출처 : http://happy2ni.egloos.com/9609765
[iBatis] 주요 태그 Tag
1] Alias
<typeAlias alias="asName" type="package.SampleClassName"/>
2] 기본 태그
Select : <select id="test" parameterClass="package.ClassName" resultClass="package.ClassName" >
Insert : <insert id="test" parameterClass="package.ClassName" >
Update: <update id="test" parameterClass="package.ClassName" >
Delete : <delete id="test" parameterClass="package.ClassName" >
Statement : <statement id="test" parameterClass="package.ClassName" >
3] 프로퍼티 존재여부
존재할때 : <isPropertyAvailable property="a"></isPropertyAvailable>
존재하지 않을때 : <isNotPropertyAvailable property="a"></isNotPropertyAvailable>
4] 프로퍼티 Null 체크
Null 일때 : <isNull property="a"></isNull>
Null 아닐때 : <isNotNull property="a"></isNotNull>
5] 프로퍼티 Empty 체크
Empty 일때 : <isEmpty property="a"></isEmpty>
Empty 아닐때 : <isNotEmpty property="a"></isNotEmpty>
6] 프로퍼티 값비교
같을때 : <isEqual property="a" compareValue="K"></isEqual>
같지 않을때 : <isNotEqual property="a" compareValue="K"></isNotEqual>
7] ParameterMap
<parameterMap id="paramMap" class="package.ClassName">
<parameter property="id" />
<parameter property="name" javaType="java.lang.String" jdbcType="VARCHAR" mode="IN"/>
<parameter property="msg" javaType="java.lang.String" jdbcType="VARCHAR" mode="OUT"/>
</parameterMap>
8] ResultMap
<resultMap id="reMap" class="package.ClassName">
<result property="id" column="test_id" />
</resultMap>
9] Dynamic
<select>
select a from test
<dynamic prepend="where">
<isNotNull property="a" >id = #a#</isNotNull>
<isNotNull property="b" prepend="AND">name = #b#</isNotNull>
<isNotNull property="c" prepend="AND" open="(" close=")">
<isNotNull property="c" > no = #c#</isNotNull>
</isNotNull property="c" prepend="OR">no_as = #d#</isNotNull>
</isNotNull>
</dynamic>
</select>
[출처] [본문스크랩] ibatis 태그. 자주 쓰는 것들.|작성자 세직사
