SQL:SELECT * FROM User where xl='1' and (Zt = '待审核' or Zt = '已驳回') and xh='2'
需要用mybatisplus实现:
User user = new User().selectOne(new QueryWrapper<User>().eq("xl", xl) .and(wrapper -> wrapper.eq("Zt", "待审核").or().eq("Zt", "已驳回")) .eq("xh",user.getXh())); |