参考来源: http://www.cnblogs.com/LvLoveYuForever/p/6689577.html
<resultMap id="BaseResultMap" type="com.icss.ys.pojo.Customer" >
<id column="customer_id" property="customerId" jdbcType="INTEGER" />
<result column="customer_name" property="customerName" jdbcType="VARCHAR" />
<result column="customer_card" property="customerCard" jdbcType="VARCHAR" />
<!-- 关联一对多关系 column="customer_id" 此处customer_id作为参数传给select嵌套查询 -->
<collection property="tickets" ofType="com.icss.ys.pojo.Ticket"
select="selectTicket" column="customer_id" ></collection>
</resultMap>
<select id="selectTicket" resultMap="com.icss.ys.dao.TicketMapper.BaseResultMap">
select *
from ticket
where customer_id = #{customer_id}
</select>
<select id="selectCustomerByName" resultMap="BaseResultMap" >
select *
from customer where customer_name=#{customer_name}
</select>