XXX.xml (SQL)

１．<, >, <>, <=, >=这几个要做以下处理
　　<![CDATA[ < ]]>　

２．ＸＸＸ.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "http://www.ibatis.com/dtd/sql-map-2.dtd">

<sqlMap namespace="AAA">
<typeAlias alias="BB" type="xxx.vo.imp.xxImp" />

<resultMap id="CC" class="AAA">
<result property="xx" column="xx" />
......
</resultMap>

<select id="methodName" resultMap="CC" parameterClass="AAA">
select xx,... from SYN_HSM_HSE_RGN
</select>

<insert id="methodName" parameterClass="AAA">
<selectKey resultClass="java.lang.String" keyProperty="xx">
SELECT SEQ_PMR_EXCLD_ENTRY.NEXTVAL as excldEntryKey FROM DUAL
</selectKey>
insert into PMR_EXCLD_ENTRY(
EXCLD_ENTRY_KEY,
RTN_TYPE_KEY,
HSE_RGN_KEY,
HSE_DSTR_KEY,
HSE_EST_TYPE_CODE,
HSE_EST_CODE,
EXCLD_DATE,
LAST_REC_TXN_TYPE_CODE,
LAST_REC_TXN_DATE,
LAST_REC_TXN_USER_ID
)values(
#excldEntryKey:VARCHAR#,
#rtnTypeKey:VARCHAR#,
#hseRgnKey:VARCHAR#,
#hseDstrKey:VARCHAR#,
#hseEstTypeCode:VARCHAR#,
#hseEstCode:VARCHAR#,
to_timestamp(to_char(sysdate,'DD-MM-YYYY HH24:MI:SS'),'DD-MM-YYYY HH24:MI:SS'),
'I',
to_timestamp(to_char(sysdate,'DD-MM-YYYY HH24:MI:SS'),'DD-MM-YYYY HH24:MI:SS'),
#lastUpdateUser:VARCHAR#
)
</insert>

<update id="updateExcludeGroup" parameterClass="excludeGroup">
update PMR_EXCLD_ENTRY set
HSE_RGN_KEY=#hseRgnKey:VARCHAR#,
HSE_DSTR_KEY=#hseDstrKey:VARCHAR#,
HSE_EST_TYPE_CODE=#hseEstTypeCode:VARCHAR#,
HSE_EST_CODE=#hseEstCode:VARCHAR#,
EXCLD_DATE=to_timestamp(to_char(sysdate,'DD-MM-YYYY HH24:MI:SS'),'DD-MM-YYYY HH24:MI:SS'),
LAST_REC_TXN_TYPE_CODE='U',
LAST_REC_TXN_DATE=to_timestamp(to_char(sysdate,'DD-MM-YYYY HH24:MI:SS'),'DD-MM-YYYY HH24:MI:SS'),
LAST_REC_TXN_USER_ID=#lastUpdateUser:VARCHAR#
where EXCLD_ENTRY_KEY=#excldEntryKey:VARCHAR#
</update>

<delete id="deleteExcludeGroup" parameterClass="excludeGroup">
delete from PMR_EXCLD_ENTRY
where EXCLD_ENTRY_KEY=#excldEntryKey:VARCHAR#
</delete>
</sqlMap>