67,515
社区成员
发帖
与我相关
我的任务
分享
...
private PageModel page = new PageModel();
...
tSyseMaintainAccount.setIdList(idList);
tSyseMaintainAccount.setId(loginId);
page.setParams(tSyseMaintainAccount);
page = iTSyseMaintainAccountService.queryListByUnitIdPage(page);
<select id="queryListByUnitIdPage" parameterType="TSyseMaintainAccount" resultMap="TSyseMaintainAccountResultMap">
select a.*,b.UNIT_NAME linkUnitName from T_SYSE_MAINTAIN_ACCOUNT a
left JOIN T_SYSE_OPER_UNIT b
on a.UNIT_ID=b.ID
where a.STATUS_FLAG in ('1','2')
AND a.UNIT_ID in
<foreach item="item" index="index" collection="params.idList" open="(" separator="," close=")">
#{item}
</foreach>
AND a.ID != #{params.id}
</select>
public class TSyseMaintainAccount implements java.io.Serializable {
// Fields
private Long id;
private String name;
...
private List idList;
public List getIdList() {
return idList;
}
public void setIdList(List idList) {
this.idList = idList;
}
}
public class PageModel {
...
private Object params;
public Object getParams() {
return params;
}
public void setParams(Object params) {
this.params = params;
}
...
}
<foreach item="item" index="index" collection="params.idList" open="(" separator="," close=")">
#{params.idList[${index}]}
</foreach>
<parameterMap type="TSyseMaintainAccount" id="TSyseMaintainAccount">
<parameter property="id" />
<parameter property="name" />
<parameter property="male" />
<parameter property="logAcc" />
<parameter property="passwd" />
<parameter property="birthDate" />
<parameter property="unitId" />
<parameter property="begDate" />
<parameter property="endDate" />
<parameter property="curTime" />
<parameter property="cOptId" />
<parameter property="optDeviceCode" />
<parameter property="statusFlag" />
???
</parameterMap>
???处是否要加上<parameter property="idList" />呢?但是这么加上肯定不对啊。