mybatis 动态sql 语句问题
Role role=new Role();
role.setUserId(UserUtils.getUser().getId());
List<Role> dataScope = systemService.getDataScope(role);
boolean flag1=false;
boolean flag2=false;
boolean flag3=false;
for (Role r : dataScope) {
if("1".equals(r.getDataScope())){
flag1=true;
}
if("2".equals(r.getDataScope())){
flag2=true;
}
if("3".equals(r.getDataScope())){
flag3=true;
}
}
if(flag1==false && flag2==false && flag3==true){
sql.append(" AND user_company_id='"+UserUtils.getUser().getOrgCode()+"'");
delivery.setUserCompanyId(UserUtils.getUser().getOrgCode());
}
这样的 语句 怎么写成
<if test=" flag1==false and flag2==false and flag3==true" >
AND user_company_id = #{userCompanyId}
</if>