Mybatis 中的一對(duì)一,一對(duì)多,多對(duì)多的配置原則示例代碼

更新時(shí)間：2017年03月02日 15:44:58 作者：manleo0527

這篇文章主要介紹了 Mybatis 中的一對(duì)一,一對(duì)多,多對(duì)多的配置原則示例代碼,需要的朋友可以參考下

什么是 MyBatis ？

MyBatis 是支持定制化 SQL、存儲(chǔ)過(guò)程以及高級(jí)映射的優(yōu)秀的持久層框架。MyBatis 避免了幾乎所有的 JDBC 代碼和手動(dòng)設(shè)置參數(shù)以及獲取結(jié)果集。MyBatis 可以對(duì)配置和原生Map使用簡(jiǎn)單的 XML 或注解，將接口和 Java 的 POJOs(Plain Old Java Objects,普通的 Java對(duì)象)映射成數(shù)據(jù)庫(kù)中的記錄。

表：market_plan(營(yíng)銷計(jì)劃(關(guān)聯(lián)了用戶))

market_plan_product(產(chǎn)品關(guān)聯(lián)營(yíng)銷計(jì)劃)
market_plan_label(標(biāo)簽關(guān)聯(lián)營(yíng)銷計(jì)劃)
market_plan_ideadata(創(chuàng)意素材關(guān)聯(lián)營(yíng)銷計(jì)劃)
user_ideadata_activity(活動(dòng)關(guān)聯(lián)用戶，活動(dòng)關(guān)聯(lián)創(chuàng)意素材表)
user(用戶表)

配置原則：A關(guān)聯(lián)B，將A的resultMap關(guān)聯(lián)(association)到B的resultMap中，這樣才能在寫關(guān)聯(lián)查詢sql語(yǔ)句的時(shí)候，查詢出A,B表中的屬性。多張表的關(guān)聯(lián)也是一樣的道理！

配置xml示例：

<resultMap id="userResultMap" type="com.mchuan.fastmarketplat.b.entity.User">
<id column="USER_ID" property="id" />
<result column="ACCOUNT" property="account" />
<result column="NAME" property="name" />
<result column="MOBILE" property="mobile" />
</resultMap>
<resultMap id="labelResultMap"
type="com.mchuan.fastmarketplat.b.entity.MarketPlanLabel">
<id property="id" column="LABEL_ID" />
<result property="gender" column="GENDER" />
<result property="area" column="AREA" />
<result property="age" column="AGE" />
<result property="deviceType" column="DEVICE_TYPE" />
<result property="communicationFee" column="COMMUNICATION_FEE" />
<result property="actionLabels" column="ACTION_LABELS" />
<result property="netScene" column="NET_SCENE" />
</resultMap>
<resultMap id="productResultMap"
type="com.mchuan.fastmarketplat.b.entity.MarketPlanProduct">
<id property="id" column="PRODUCT_ID" />
<result property="coverAmount" column="COVER_AMOUNT" />
</resultMap>
<resultMap id="activityResultMap"
type="com.mchuan.fastmarketplat.b.entity.UserActivity">
<id column="AC_ID" property="id" />
<result column="ACTIVITY_ID" property="activityId" jdbcType="INTEGER" />
<result column="COVER_URL" property="coverUrl" jdbcType="VARCHAR" />
<result column="ACTIVITY_URL" property="activityUrl" jdbcType="VARCHAR" />
<result column="VIEW_URL" property="viewUrl" jdbcType="VARCHAR" />
<result column="CREATE_TIME" property="createTime" />
<result column="UPDATE_TIME" property="updateTime" />
</resultMap>
<resultMap id="ideaDataResultMap"
type="com.mchuan.fastmarketplat.b.entity.MarketPlanIdeaData">
<id property="id" column="IDEA_DATA_ID" />
<result property="content" column="CONTENT" />
<result property="linkUrl" column="LINK_URL" />
<!-- ideaData關(guān)聯(lián)屬性 -->
<association property="userActivity"
javaType="com.mchuan.fastmarketplat.b.entity.UserActivity" resultMap="activityResultMap" />
</resultMap>
<resultMap id="BaseResultMap" type="com.mchuan.fastmarketplat.b.entity.MarketPlan">
<id column="ID" property="id" jdbcType="INTEGER" />
<result column="PLAN_NAME" property="planName" jdbcType="VARCHAR" />
<result column="BUDGET" property="budget" jdbcType="DECIMAL" />
<result column="ACTUAL_BUDGET" property="actualBudget"
jdbcType="DECIMAL" />
<result column="DEMAND_TYPE" property="demandType" jdbcType="VARCHAR" />
<result column="START_DATE" property="startDate" />
<result column="END_DATE" property="endDate" />
<result column="CREATE_STATUS" property="createStatus"
jdbcType="INTEGER" />
<result column="CREATE_TIME" property="createTime" />
<result column="UPDATE_TIME" property="updateTime" />
<result column="NOTE" property="note" jdbcType="VARCHAR" />
<result column="STATUS" property="status" jdbcType="INTEGER" />
<result column="DESTPAGE_URL" property="destpageUrl" jdbcType="VARCHAR" />
<result column="IS_AWARD" property="isAward" jdbcType="INTEGER" />
<result column="AWARD_MONEY" property="awardMoney" jdbcType="DECIMAL" />
<result column="ADVERTISER" property="advertiser" jdbcType="VARCHAR" />
<result column="INDUSTRY" property="industry" jdbcType="INTEGER" />

<!-- marketPlan關(guān)聯(lián)屬性 -->
<association property="user"
javaType="com.mchuan.fastmarketplat.b.entity.User" resultMap="userResultMap" />
<association property="marketPlanLabel"
javaType="com.mchuan.fastmarketplat.b.entity.MarketPlanLabel"
resultMap="labelResultMap" />
<association property="marketPlanProduct"
javaType="com.mchuan.fastmarketplat.b.entity.MarketPlanProduct"
resultMap="productResultMap" />
<association property="marketPlanIdeaData"
javaType="com.mchuan.fastmarketplat.b.entity.MarketPlanIdeaData"
resultMap="ideaDataResultMap" />
</resultMap>

以上所述是小編給大家介紹的 Mybatis 中的一對(duì)一，一對(duì)多，多對(duì)多的配置原則示例代碼，希望對(duì)大家有所幫助，如果大家有任何疑問(wèn)請(qǐng)給我留言，小編會(huì)及時(shí)回復(fù)大家的。在此也非常感謝大家對(duì)腳本之家網(wǎng)站的支持！

您可能感興趣的文章: