mybatis一对多sql语句：

1. <mapper namespace="com.zdp.domain.Person">  
2.     <resultMap type="Person" id="personBean">  
3.         <id column="personId" property="id"/>  
4.         <result column="personName" property="name"/>  
5.         <result column="personAddress" property="address"/>  
6.         <result column="personTel" property="tel"/>  
7.           
8.         <!-- 一对多的关系 -->  
9.         <!-- property: 指的是集合属性的值, ofType：指的是集合中元素的类型 -->  
10.         <collection property="orders" ofType="Order">  
11.             <id column="orderId" property="id"/>  
12.             <result column="orderNumber" property="number"/>  
13.             <result column="orderPrice" property="price"/>  
14.         </collection>  
15.     </resultMap>  
16.       
17.     <!-- 根据id查询Person, 关联将Orders查询出来 -->  
18.     <select id="selectPersonById" parameterType="string" resultMap="personBean">  
19.         select p.*, o.* from person p, orders o where p.personId  = o.pid and p.personId = #{id}  
20.     </select>  
21.       
22. </mapper>