一对多,多对一 多对多
(Order,Customer,News,Category皆为表)
多对一中mapper映射文件
<resultMap id="manyToOne" type="com.zking.ssm.model.Order" >
<id column="order_id" property="orderId" jdbcType="INTEGER" javaType="java.lang.Integer" />
<result column="order_no" property="orderNo" jdbcType="VARCHAR" javaType="java.lang.String" />
<result column="cid" property="cid" jdbcType="INTEGER" javaType="java.lang.Integer" />
<!--多对一-->
<association property="customer" javaType="com.zking.ssm.model.Customer">
<id column="customer_id" property="customerId" javaType="java.lang.Integer"/>
<result column="customer_name" property="customerName" javaType="java.lang.String"/>
</association>
</resultMap>
一对多mapper映射文件
<resultMap id="oneToMany" type="com.zking.ssm.model.Customer">
<id column="customer_id" property="customerId" javaType="java.lang.Integer"/>
<result column="customer_name" property="customerName" javaType="java.lang.String"/>
<!--一对多-->
<collection property="orders" ofType="com.zking.ssm.model.Order">
<id column="order_id" property="orderId" javaType="java.lang.Integer"/>
<result column="order_no" property="orderNo" jdbcType="VARCHAR" javaType="java.lang.String" />
<result column="cid" property="cid" jdbcType="INTEGER" javaType="java.lang.Integer" />
</collection>
</resultMap>
多对多mapper映射文件
注意:在这多对多中category表的mapper映射文件也需要配置
<resultMap id="ManyToMany" type="com.zking.ssm.model.News">
<id property="newsId" javaType="java.lang.Integer" column="news_id" />
<result property="title" javaType="java.lang.String" column="title"/>
<!--多对多-->
<collection property="category" ofType="com.zking.ssm.model.Category">
<id property="categoryId" column="category_id"/>
<result property="categoryName" column="category_name"/>
</collection>
</resultMap>
collection :一对多、多对多
association:多对一