where 1=1

关联表

select count(distinct u.id) from t_user u,t_user_department_set s where s.userid=u.id

后面添加逻辑就无需判断之前字段是否为空了。

if (deptId != null) {
query_users.append("and s.departmentid='" + deptId + "' ");
query_total.append("and s.departmentid='" + deptId + "'");
}

if (name != null && deptId != null) {
query_users.append("and u.name like '%" + name + "%' ");
query_total.append("and u.name like '%" + name + "%' ");
}else{
query_users.append("u.name like '%" + name + "%' ");
query_total.append("u.name like '%" + name + "%' ");
}

简化为：

if (deptId != null) {
query_users.append("and s.departmentid='" + deptId + "' ");
query_total.append("and s.departmentid='" + deptId + "'");
}

if (name != null) {
query_users.append("and u.name like '%" + name + "%' ");
query_total.append("and u.name like '%" + name + "%' ");
}