orders類(lèi)（com.changez.sm.base.bean.Orders）主要屬性：

	PRivate String id;	private String userId;	private String orderNum;	private Date createTime;	private String note;	private User user;	private Set<Ordertail> ordertails;
User類(lèi)（com.changez.sm.base.bean.User）主要屬性：
	private String id;	private String username;	private Date birthday;	private String sex;	private String address;
ordertail類(lèi)（com.changez.sm.base.bean.Ordertail）主要屬性：
	private int id;	private int orderId;	private int itemId;	private int itemNum;
一對(duì)多查詢(xún)：
collection： 
property：bean中集合的屬性名，
ofType：集合類(lèi)型全限定名
select語(yǔ)句：其中的resultMap有以下兩種選擇： queryOrderAndDetailResultMapExtends或者queryOrderAndDetailResultMap
	<!-- 一對(duì)多查詢(xún) :查詢(xún)訂單及訂單明細(xì)的信息 -->	<select id="queryOrderAndDetail" resultMap="queryOrderAndDetailResultMap">		SELECT 			tco.id ordersid, tco.user_id, tco.order_num, tco.create_time, 			tcd.id ordertailid, tcd.order_id, tcd.item_id, tcd.item_num, 			tcu.id userid, tcu.username, tcu.birthday, tcu.sex, tcu.address 		from 			temp_changez_orders tco, temp_changez_ordertail tcd, temp_changez_user tcu 		WHERE 			tco.id=tcd.order_id AND tco.user_id=tcu.id	</select>resultMap語(yǔ)句（方式一，將一對(duì)一， 一對(duì)多關(guān)系都寫(xiě)完整）：
<resultMap type="com.changez.sm.base.bean.Orders" id="queryOrderAndDetailResultMap">		<id column="ordersid" property="id"/>		<result column="user_id" property="userId"/>		<result column="order_num" property="orderNum"/>		<result column="create_time" property="createTime"/>		<result column="note" property="note"/>		<!-- 一對(duì)一的關(guān)系配置， 此處可以刪掉，不影響一對(duì)多的配置  -->		<association property="user" javaType="com.changez.sm.base.bean.User">			<id column="userid" property="id"/>			<result column="username" property="username"/>			<result column="birthday" property="birthday"/>			<result column="address" property="address"/>			<result column="sex" property="sex"/>		</association>		<!-- 一對(duì)多的關(guān)系配置 -->		<collection property="ordertails" ofType="com.changez.sm.base.bean.Ordertail">			<id column="ordertailid" property="id"/>			<result column="order_id" property="orderId"/>			<result column="item_id" property="itemId"/>			<result column="item_num" property="itemNum"/>		</collection>	</resultMap>
resultMap語(yǔ)句（方式二，在一對(duì)一的關(guān)系中已經(jīng)配置了orders和user的一對(duì)一關(guān)系， 可以使用extends關(guān)鍵字引用已有的對(duì)照關(guān)系）：
	<!-- 使用extends -->	<resultMap type="com.changez.sm.base.bean.Orders" id="queryOrderAndDetailResultMapExtends" extends="queryOrderAndUserResultMap">		<collection property="ordertails" ofType="com.changez.sm.base.bean.Ordertail">			<id column="ordertailid" property="id"/>			<result column="order_id" property="orderId"/>			<result column="item_id" property="itemId"/>			<result column="item_num" property="itemNum"/>		</collection>	</resultMap>orders和user的一對(duì)一關(guān)系配置：
	<resultMap type="com.changez.sm.base.bean.Orders" id="queryOrderAndUserResultMap">		<id column="ordersid" property="id"/>		<result column="user_id" property="userId"/>		<result column="order_num" property="orderNum"/>		<result column="create_time" property="createTime"/>		<result column="note" property="note"/>				<association property="user" javaType="com.changez.sm.base.bean.User">			<id column="userid" property="id"/>			<result column="username" property="username"/>			<result column="birthday" property="birthday"/>			<result column="address" property="address"/>			<result column="sex" property="sex"/>		</association>	</resultMap>