ibatis 配置

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd" >
<sqlMap namespace="XCKINDCATENA" >
<resultMap id="abatorgenerated_XckindcatenaResult" class="com.xcdata.objectm.Xckindcatena" >
<result column="KINDID" property="kindid" jdbcType="DECIMAL" />
<result column="REGID" property="regid" jdbcType="DECIMAL" />
<result column="KIND" property="kind" jdbcType="VARCHAR" />
<result column="REMARK" property="remark" jdbcType="VARCHAR" />
<result column="CATENAID" property="catenaid" jdbcType="DECIMAL" />
<result column="CATENA" property="catena" jdbcType="VARCHAR" />
<result column="COMMUSE" property="commuse" jdbcType="VARCHAR" />
<result column="CREMARK" property="cremark" jdbcType="VARCHAR" />
</resultMap>

<select id="selectByRegid" resultMap="abatorgenerated_XckindcatenaResult" parameterClass="com.xcdata.objectm.Xckindcatena" >
select a.KINDID, a.REGID, a.KIND, a.REMARK, b.CATENAID, b.CATENA, b.COMMUSE, b.REMARK CREMARK
from xckind a, xccatena b
where a.kindid = b.kindid(+)
<dynamic prepend="" >
<isNotNull prepend=" and " property="regid" >
REGID = #regid:DECIMAL#
</isNotNull>
<isNotNull prepend=" and " property="catena" >
CATENA like '%'||#catena:VARCHAR#||'%'
</isNotNull>
</dynamic>
order by a.KINDID
</select>

<select id="selectByKindid" resultMap="abatorgenerated_XckindcatenaResult" parameterClass="java.lang.Integer" >
select a.KINDID, a.REGID, a.KIND, a.REMARK, b.CATENAID, b.CATENA, b.COMMUSE, b.REMARK CREMARK
from xckind a, xccatena b
where a.kindid = b.kindid(+) and a.kindid = #kindid:DECIMAL#
</select>

<select id="selectByCatenaid" resultMap="abatorgenerated_XckindcatenaResult" parameterClass="java.lang.Integer" >
select a.KINDID, a.REGID, a.KIND, a.REMARK, b.CATENAID, b.CATENA, b.COMMUSE, b.REMARK CREMARK
from xckind a, xccatena b
where a.kindid = b.kindid and b.catenaid = #catenaid:DECIMAL#
</select>

<update id="updateKindByPrimary" parameterClass="com.xcdata.objectm.Xckindcatena" >
update XCKIND
<dynamic prepend="set" >
<isNotNull prepend="," property="regid" >
REGID = #regid:DECIMAL#
</isNotNull>
<isNotNull prepend="," property="kind" >
KIND = #kind:VARCHAR#
</isNotNull>
<isNotNull prepend="," property="remark" >
REMARK = #remark:VARCHAR#
</isNotNull>
</dynamic>
where KINDID = #kindid#
</update>

<update id="updateCatenaByPrimary" parameterClass="com.xcdata.objectm.Xckindcatena" >
update XCCATENA
<dynamic prepend="set" >
<isNotNull prepend="," property="kindid" >
KINDID = #kindid:DECIMAL#
</isNotNull>
<isNotNull prepend="," property="catena" >
CATENA = #catena:VARCHAR#
</isNotNull>
<isNotNull prepend="," property="commuse" >
COMMUSE = #commuse:VARCHAR#
</isNotNull>
<isNotNull prepend="," property="cremark" >
CREMARK = #cremark:VARCHAR#
</isNotNull>
</dynamic>
where CATENAID = #catenaid#
</update>

<select id="selectAllKindByRegid" resultMap="SELECTLIST.PagSelect_2" parameterClass="java.lang.Integer" >
select a.KINDID value, a.KIND name
from xckind a
where a.regid = #regid:DECIMAL#
</select>

<insert id="insertKind" parameterClass="com.xcdata.objectm.Xckindcatena" >
<selectKey resultClass="java.lang.Integer" keyProperty="kindid" >
select xckind_seq.nextval as kindid from dual
</selectKey>
insert into XCKIND (KINDID, REGID, KIND, REMARK)
values (#kindid:DECIMAL#, #regid:DECIMAL#, #kind:VARCHAR#, #remark:VARCHAR#)
</insert>

<delete id="deleteByKindPrimaryKey" parameterClass="java.lang.Integer" >
delete from XCKIND
where KINDID = #kindid:DECIMAL#
</delete>

</sqlMap>