IBATISラベル使用テクニック
CRUE
-------select----------
1 selectはDTOまたはListパラメータDTO,String,HashMap javaを返す.util.Map
2 selectはObject(Long)パラメータDTOを返します
3 selectはHashMapを返します
4 select共通条件クエリー(一般的に記録の表示と記録数を一致させるため)
-------update----------
-------insert----------
-------delete----------
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
条件
1加算条件
-------select----------
1 selectはDTOまたはList
<select id="" parameterClass="" resultClass="" >
<![CDATA[
SELECT
FROM
WHERE
]]>
</select>
2 selectはObject(Long)パラメータDTOを返します
<select id="XXCount" parameterClass="" resultClass="java.lang.Long">
<![CDATA[
SELECT COUNT()
FROM
WHERE
]]>
</select>
3 selectはHashMapを返します
<select id = "testSql" parameterClass = "java.lang.String" resultClass = "java.util.HashMap">
SELECT T.C_NAME AS name,
T.C_CODE AS ID,
T.C_ID as CID,
nvl(C_FIELD, 'no') as d
FROM TB_TABLE T
WHERE T.C_DEL = '0'
AND T.C_ID = #value#
</select >
4 select共通条件クエリー(一般的に記録の表示と記録数を一致させるため)
--
<sql id="queryCommon">
from TB_TEST_ONE A, TB_TEST_TWO B
where A.C_ID=B.C_FK_A_CID
and B.C_DEL='0'
<dynamic prepend="and">
<isNotEmpty property="nme" prepend="and">
<![CDATA[ B.C_NME LIKE '%'||#nme#||'%' ]]>
</isNotEmpty>
</dynamic>
</sql>
-- list
<select id = "queryList">
<![CDATA[
select cid
from (select rownum as rowIndex,
B.C_FK_A_CID as cid
<isParameterPresent >
<include refid="queryTeamCommon"/>
</isParameterPresent> and ROWNUM <= "11") a rowIndex > 1
]]>
</select>
--
<select id = "queryCount">
select count( B.C_FK_A_CID)
isParameterPresent >
<include refid="queryTeamCommon"/>
</isParameterPresent>
</select>
-------update----------
-------insert----------
-------delete----------
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
条件
1加算条件
<isNotEmpty property="flag" prepend=",">
TB_Test teset
</isNotEmpty>