学步园

<!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>