改了一条查询语句结果返回的查询结果是重复的
改的内容:查询条件:private String isAudit;改成private Long[] isAudit;
也就是数组查询,查询条件由单选变成多选
改的数据库查询语句mybaitis:
<!-- 查询条件:是否通过审核 -->
<if test="queryAudit != null and queryAudit.length != 0">
AND A.ISAUDIT IN
<foreach collection="queryAudit" item="item" open="(" separator="," close=")">
#{item}
</foreach>
</if>
改的serviceImpl实现类:
if (!CheckUtils.isEmpty(form.getQueryAudit())) { //验证非空
Long[] queryAudits = form.getQueryAudit();
List<Long> queryAuditList = new ArrayList<Long>();
for (Long queryAudit : queryAudits) {
if (!CheckUtils.isEmpty(queryAudit)) {
queryAuditList.add(queryAudit);
}
}
form.setQueryAudit(queryAuditList.toArray(new Long[0]));
}
返回的页面:
太多就不贴了,反正就是查的每一件商品都要重复6条