<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd">
<sqlMap namespace="City">
<typeAlias alias="City" type="com.cgnw.sns.dbaccess.domain.City" />
<resultMap class="City" id="CityMap">
<result property="cityCd" column="city_cd" />
<result property="stateCd" column="state_cd" />
<result property="cityName" column="city_name" />
<result property="cityClass" column="city_class" />
<result property="parentCity" column="parent_city" />
<result property="cityOrder" column="city_order" />
<result property="cityNote" column="city_note" />
</resultMap>
<!-- INSERT -->
<insert id="insert" parameterClass="City">
INSERT INTO
<dynamic prepend="t_city" open="(" close=")">
city_cd, state_cd, city_name,
<isNotNull prepend="," property="cityClass">
city_class
</isNotNull>
<isNotNull prepend="," property="parentCity">
parent_city
</isNotNull>
<isNotNull prepend="," property="cityOrder">
city_order
</isNotNull>
<isNotNull prepend="," property="cityNote">
city_note
</isNotNull>
</dynamic>
<dynamic open="(" close=")" prepend="VALUES">
s_t_city.nextval, #stateCd#, #cityName#,
<isNotNull prepend="," property="cityClass">
#cityClass#
</isNotNull>
<isNotNull prepend="," property="parentCity">
#parentCity#
</isNotNull>
<isNotNull prepend="," property="cityOrder">
#cityOrder#
</isNotNull>
<isNotNull prepend="," property="cityNote">
#cityNote#
</isNotNull>
</dynamic>
<selectKey resultClass="String">
SELECT s_t_city.CURRVAL FROM DUAL
</selectKey>
</insert>
<!-- UPDATE -->
<update id="update" parameterClass="City">
UPDATE t_city
<dynamic prepend="SET">
<isNotNull prepend="," property="stateCd"
removeFirstPrepend="true">
state_cd=#stateCd#
</isNotNull>
<isNotNull prepend="," property="cityName"
removeFirstPrepend="true">
city_name=#cityName#
</isNotNull>
<isNotNull prepend="," property="cityClass"
removeFirstPrepend="true">
city_class=#cityClass#
</isNotNull>
<isNotNull prepend="," property="parentCity"
removeFirstPrepend="true">
parent_city=#parentCity#
</isNotNull>
<isNotNull prepend="," property="cityOrder"
removeFirstPrepend="true">
city_order=#cityOrder#
</isNotNull>
<isNotNull prepend="," property="cityNote"
removeFirstPrepend="true">
city_note=#cityNote#
</isNotNull>
</dynamic>
WHERE city_cd=#cityCd#
</update>
<!-- select an object by primaryKey -->
<select id="selectByPrimaryKey" resultMap="CityMap"
parameterClass="String">
SELECT * FROM T_CITY WHERE CITY_CD=#cityCd#
</select>
<select id="select" resultMap="CityMap" parameterClass="Map">
SELECT * FROM T_CITY
<dynamic prepend="WHERE">
<isNotNull prepend=" AND " property="stateCd"
removeFirstPrepend="true">
state_cd=#stateCd#
</isNotNull>
<isNotNull prepend=" AND " property="cityName"
removeFirstPrepend="true">
city_name=#cityName#
</isNotNull>
<isNotNull prepend=" AND " property="cityClass"
removeFirstPrepend="true">
city_class=#cityClass#
</isNotNull>
<isNotNull prepend=" AND " property="parentCity"
removeFirstPrepend="true">
parent_city=#parentCity#
</isNotNull>
<isNotNull prepend=" AND " property="cityOrder"
removeFirstPrepend="true">
city_order=#cityOrder#
</isNotNull>
<isNotNull prepend=" AND " property="cityNote"
removeFirstPrepend="true">
city_note=#cityNote#
</isNotNull>
</dynamic>
<dynamic prepend="ORDER BY">
<isNotNull property="orderBy">$orderBy{1}lt;/isNotNull>
</dynamic>
</select>
<select id="count" resultClass="Integer" parameterClass="Map">
SELECT COUNT(*) FROM T_CITY
<dynamic prepend="WHERE">
<isNotNull prepend=" AND " property="stateCd"
removeFirstPrepend="true">
state_cd=#stateCd#
</isNotNull>
<isNotNull prepend=" AND " property="cityName"
removeFirstPrepend="true">
city_name=#cityName#
</isNotNull>
<isNotNull prepend=" AND " property="cityClass"
removeFirstPrepend="true">
city_class=#cityClass#
</isNotNull>
<isNotNull prepend=" AND " property="parentCity"
removeFirstPrepend="true">
parent_city=#parentCity#
</isNotNull>
<isNotNull prepend=" AND " property="cityOrder"
removeFirstPrepend="true">
city_order=#cityOrder#
</isNotNull>
<isNotNull prepend=" AND " property="cityNote"
removeFirstPrepend="true">
city_note=#cityNote#
</isNotNull>
</dynamic>
</select>
<!-- DELETE -->
<delete id="delete" parameterClass="String">
DELETE FROM T_CITY WHERE city_cd=#cityCd#
</delete>
</sqlMap>
ibatis配置文件示例
最新推荐文章于 2021-08-06 18:53:09 发布