ibatis 一对多查询多条件关联

最新推荐文章于 2019-10-28 14:37:25 发布

DevinW3

最新推荐文章于 2019-10-28 14:37:25 发布

阅读量959

点赞数

分类专栏： ibatis 文章标签： ibatis一对多多条件关联

本文链接：https://blog.csdn.net/iflow/article/details/45220707

版权

ibatis 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

XML:

<typeAlias alias="RdsAcctPrivilege" type="com.aliyun.pcitcAliyun.rds.model.RdsAcctPrivilege"/>
<resultMap id="result" class="RdsAcct">
<result property="id" column="ID"/>
<result property="dbinstanceid" column="DBINSTANCEID"/>
<result property="accountname" column="ACCOUNTNAME"/>
<result property="accountpassword" column="ACCOUNTPASSWORD"/>
<result property="accountdescription" column="ACCOUNTDESCRIPTION"/>
<result property="accountstatus" column="ACCOUNTSTATUS"/>
<result property="acctPrivilegeList" column="{dbinstanceid=DBINSTANCEID,accountname=ACCOUNTNAME}" select="getAcctPrivilegeList"/>
</resultMap>
<resultMap id="resultPrivilege" class="RdsAcctPrivilege">
<result property="id" column="ID"/>
<result property="dbinstanceid" column="DBINSTANCEID"/>
<result property="accountname" column="ACCOUNTNAME"/>
<result property="dbname" column="DBNAME"/>
<result property="accountpprivilege" column="ACCOUNTPPRIVILEGE"/>
</resultMap>

<select id="getAcctPrivilegeList" parameterClass="RdsAcct" resultMap="resultPrivilege">
select * from ali_rds_accountprivilege where dbinstanceid=#dbinstanceid# and accountname=#accountname#

</select>

ENTITY:

public class RdsAcct extends Page {
private Integer id;
private String dbinstanceid;
private String accountname;
private String accountpassword;
private String accountdescription;
private String accountstatus;

//不跟数据库字段对应
private List<RdsAcctPrivilege> acctPrivilegeList;

public List getAcctPrivilegeList() {
return acctPrivilegeList;
}

public void setAcctPrivilegeList(List acctPrivilegeList) {
this.acctPrivilegeList = acctPrivilegeList;
}