contentmapper.xml

来自「利用iBatis架构开发Web应用程序的初学实例。」· XML 代码 · 共 35 行

<?xml version="1.0" encoding="utf-8" ?>
<sqlMap namespace="Account" 
xmlns="http://ibatis.apache.org/mapping" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" >
	<alias>
		<typeAlias alias="ContentObject" type="DaoProvider.ContentObject,DaoProvider"/>
	</alias>
	<resultMaps>
		<resultMap class="ContentObject" id="ContentObject_DefaultResult">
			<result column="Title" property="Title"/>
			<result column="ContentText" property="ContentText"/>
			<result column="Creator" property="Creator"/>
		</resultMap>
	</resultMaps>
	<statements>
		<insert id="ContentObject_DefaultInsert" parameterClass="ContentObject">
			INSERT INTO Content(Title,ContentText,Creator) VALUES(#Title#,#ContentText#,#Creator#)
			<selectKey property="ID" resultClass="int" type="post">
				SELECT @@IDENTITY AS #value#
			</selectKey>
		</insert>
		<select id="Content_DefaultSelect" listClass="ArrayList" resultMap="ContentObject_DefaultResult" >
			SELECT ID ,Title,ContentText,Creator AS Creator FROM Content
		</select>
	</statements>
	<parameterMaps>
		<parameterMap class="ContentObject" id="ContentObject_DefaultParameter">
			<parameter column="Title" direction="Input" property="Title"/>
			<parameter column="ContentText" direction="Input" property="ContentText"/>
			<parameter column="Creator" direction="Input" property="Creator"/>
		</parameterMap>
	</parameterMaps>
	
</sqlMap>