.#series.xml.1.11

这个是网络上下载的一个struct框架的程序

<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
    "/WEB-INF/dtd/sql-map-2.dtd">

<sqlMap namespace="Series">
	<typeAlias alias="series" type="com.vodacar.repository.domain.Series" />
	<resultMap id="SeriesResult" class="com.vodacar.repository.domain.Series">
		<result property="id" column="ID" />
		<result property="brandId" column="BrandId" />
		<result property="name" column="Name" />
		<result property="shortName" column="ShortName" />
		<result property="description" column="Description" />
		<result property="pinyin" column="Pinyin" />
		<result property="classId" column="ClassId" />
		<result property="pass" column="pass" />
		<result property="creator" column="creator" />
		<result property="released" column="released" />
		<result property="manuId" column="MANUID" />
	</resultMap>


	<select id="retrieveSeries" resultMap="SeriesResult" parameterClass="long">SELECT "ID", "BrandId", "Name", "ShortName", "Description", "Pinyin", "ClassId", "pass", "creator", "released" FROM "DB2ADMIN"."AUTOWIKI_SERIES" WHERE "ID"=#id#</select>

	<update id="updateSeries" parameterClass="series">
		UPDATE "DB2ADMIN"."AUTOWIKI_SERIES" SET 
		 
		<isNotEmpty property="brandId">"BrandId" = #brandId#, </isNotEmpty>
		<isNotEmpty property="name">"Name" = #name#, </isNotEmpty>
		<isNotEmpty property="shortName">"ShortName" = #shortName#, </isNotEmpty>
		<isNotEmpty property="description">"Description" = #description#, </isNotEmpty>
		<isNotEmpty property="pinyin">"Pinyin" = #pinyin#, </isNotEmpty>
		<isNotEmpty property="classId">"ClassId" = #classId#, </isNotEmpty>
		<isNotEmpty property="pass">"pass" = #pass#, </isNotEmpty>
		<isNotEmpty property="creator">"creator" = #creator#, </isNotEmpty>
		<isNotEmpty property="released">"released" =#released# ,</isNotEmpty>
		<isNotEmpty property="manuId">"MANUID" =#"manuId"# ,</isNotEmpty>
		"ID" = #id#
		WHERE "ID"=#id#

	</update>
	<insert id="insertSeries" parameterClass="series">
		INSERT INTO "DB2ADMIN"."AUTOWIKI_SERIES" 
		( "BrandId","Name","ShortName","Description","Pinyin","ClassId","pass","creator" ,"released" ,"MANUID") VALUES 
		( #brandId#, #name#, #shortName#, #description#, #pinyin#, #classId#,#pass#,#creator#, #released#,#manuId# )
		<selectKey resultClass="java.lang.Long" keyProperty="id">values IDENTITY_VAL_LOCAL()</selectKey>
	</insert>
	<delete id="deleteSeries" parameterClass="long">DELETE FROM "DB2ADMIN"."AUTOWIKI_SERIES" WHERE "ID"= #id#</delete>
	<select id="retrieveSeriesByName" resultMap="SeriesResult" parameterClass="java.lang.String">
		select "ID", "BrandId", "Name", "ShortName", "Description", "Pinyin", "MANUID","ClassId", "pass", "creator", "released" from "DB2ADMIN"."AUTOWIKI_SERIES" where "Name" like '%$name$%'
	</select>
	<select id="retrieveSeriesByShortName" resultMap="SeriesResult" parameterClass="java.lang.String">
		select "ID", "BrandId", "Name", "ShortName", "Description", "Pinyin", "MANUID","ClassId", "pass", "creator", "released" from "DB2ADMIN"."AUTOWIKI_SERIES" where "ShortName" like '%$shortName$%'
	</select>

	<select id="querySeries" resultMap="SeriesResult">
		select "ID", "BrandId", "Name", "ShortName", "Description", "Pinyin","MANUID", "ClassId", "pass", "creator", "released" from "DB2ADMIN"."AUTOWIKI_SERIES"
		<dynamic prepend=" where ">
			<isNotNull prepend=" and " property="brandId">"BrandId" = #brandId#</isNotNull>
			<isNotNull prepend=" and " property="name">"Name" = #name#</isNotNull>
			<isGreaterThan prepend=" and " property="classId" compareValue="0">"ClassId" = #classId#</isGreaterThan>
			<isGreaterThan prepend=" and " property="pass" compareValue="0">"pass" = #pass#</isGreaterThan>
			<isGreaterThan prepend=" and " property="manuId" compareValue="0">"MANUID" = #manuId#</isGreaterThan>

		</dynamic>
	</select>
	
	<select id="searchSeries" resultMap="SeriesResult">
		select "ID", "BrandId", "Name", "ShortName", "Description", "Pinyin", "ClassId", "pass", "creator", "released" from "DB2ADMIN"."AUTOWIKI_SERIES"
		<dynamic prepend=" where ">
			<isNotNull prepend=" or " property="search">"ShortName" = #search#</isNotNull>
			<isNotNull prepend=" or " property="search">"Name" like #search#</isNotNull>
			<isNotNull prepend=" or " property="search">"Description" like #search#</isNotNull>
		</dynamic>
	</select>
	
</sqlMap>