一个表中的两个外键都关联同一个表,mybatis写法
列如:
table user{员工表
uid;
uname;
uage;
usalary;
}
table lend{借款表
lid;
luserid;借款人id
lmoney;
ldate;
lwarrant_userid;担保人id
}
查询一个借款单
(借款单的详细信息、借款人的姓名、借款担保人的姓名)
在mybatis中怎么写映射文件
[解决办法]
<typeAlias alias="User" type="xxx.User" /> <typeAlias alias="Lend" type="xxx.Lend" /> <resultMap id="get-user-result" class="User"> <result property="uid" column="UID" /> <result property="uname" column="UNAME" /> <result property="uage" column="UAGE" /> <result property="usalary" column="USALARY" /> </resultMap> <resultMap id="get-lend-result" class="Lend"> <result property="lid" column="LID" /> <result property="luserid" column="LUSERID" select="getUserById"/> <result property="lmoney" column="LMONEY" /> <result property="lwarrant_userid" column="LWARRANT_USERID" select="getUserById"/> </resultMap> <select id="selectLendById" parameterClass="int" resultMap="get-lend-result"> select * from LEND where ID = #id# </select> <select id="getUserById" parameterClass="int" resultMap="get-user-result"> select * from USER where ID = #id# </select>