多對多（轉換為2個一對多）
例如：訂單和產品的關系
~~~
public class Sorder {
private int oid;
private Timestamp odate;
private String ostatus;
private String oaddress;
private double totalprice;
private Userinfo u;
private List<Orderdetails> details;
}
public class Product {
private int pid;
private String pname;
private String pdesc;
private double price;
private List<Orderdetails> details;
}
public class Orderdetails {
private int id;
private double price;
private int pcount;
private double ptotalprice;
private Sorder order;
private Product p;
}
~~~
查詢訂單，包含用戶信息，以及訂單下的產品信息
映射關系
~~~
<select id="getOrderById" parameterType="int" resultMap="_orderdetails">
select s.*, od.id, od.price, od.pcount, p.pid, p.pname, p.pdesc, u.id as uid, u.name
from sorder s, orderdetails od, product p,userinfo u
where s.oid = od.oid
and od.pid = p.pid
and s.userid = u.id
and s.oid = 1
</select>
<resultMap type="Sorder" id="_orderdetails">
<id column="oid" property="oid"/>
<result column="odate" property="odate"/>
<result column="ostatus" property="ostatus"/>
<result column="totalprice" property="totalprice"/>
<result column="oaddress" property="oaddress"/>
<association property="u" javaType="Userinfo">
<id column="uid" property="id"></id>
<result column="name" property="name"/>
</association>
<collection property="details" ofType="Orderdetails" column="oid">
<id column="id" property="id"/>
<result column="price" property="price"/>
<result column="pcount" property="pcount"/>
<association property="p" javaType="Product">
<id column="pid" property="pid"></id>
<result column="pname" property="pname"/>
<result column="pdesc" property="pdesc"/>
</association>
</collection>
</resultMap>
~~~
練習：查詢一個商品，以及商品包含在哪些訂單下
