ibatis高级查询技术的使用

在ibatis中使用XML

1）XML参数

<select id="getByXmlId" resultClass="Account" parameterClass="xml">
	select 
		accountId,
		username,
		password,
		firstname,
		lastname,
		address1,
		address2
	from 
		Account
	where accountId = #accountId#
</select>

String parameter = "<parameter><accountId>3</accountId></parameter>";
Account account = sqlMapClient.queryForObject(
	"Account.getXmlId"
	,parameter
);

2)DOM参数

暂时不讲解，不推荐写，别计较麻烦

3）XML结果

<select id="getByIdValue<span style="font-family: Arial, Helvetica, sans-serif;">Xml</span>" resultClass="xml" xmlResultName="account">
	select 
		accountId,
		username,
		password,
	from 
		Account
	where accountId = #accountId#
</select>

String xmlData = (String)sqlMap.queryForObject("Account.getByIdValueXml", new Integer(1));

结果：

<?xml version="1.0" encoding="UTF-8" ?>
<account>
	<accountid>1</accountid>
	<username>lmeadors</username>
	<password>blah</password>
</account>

也可以返回多条记录，详解见《ibatis实战》P109

4）复杂集合

<sqlMap namspace="Ch6">
	<resultMap id="resultAccountInfoMap" class="org.apache.mapper2.examples.bean.AccountInfo">
		<result property ="account.accountId"
				column="accountId"/>
		
		<result property ="orderList"
				select="Ch6.getOrderInfoList"
				column="accountId"
		/>
	</resultMap>

	<select id="getOrderInfoList"  resultMap="ResultOrderInfoMap">
		select orderId from orders where accountId = #value#
	</select>
</sqlMap>

5)映射继承

<resultMap id="document" class="testdomai.Document">
	<result property="id" column="DOCUMENT_ID"/>
	<result property="title" column="TITLE"/>
	<result property="type" column="TYPE"/>
 	<strong><discriminator  column="TYPE" javaType="string">
		<subMap value="Book" resultMap="book"/>
		<subMap value="Newspaper" resultMap="news"/>
	</discriminator  ></strong>
</resultMap>

<resultMap id="book" class="testdomai.Book" extends="document">
	<result property="pages" column="DOCUMENT PAGENUMBER"/>
</resultMap>