XML:
<typeAlias alias="RdsAcct" type="com.aliyun.pcitcAliyun.rds.model.RdsAcct"/>
<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;
}