EntityWrapper

EntityWrapper<Project> project=new EntityWrapper<>();
        project.eq("status",4);
projectService.selectList(project)

 

 

Project project=new Project();
       project.setStatus(4);
projectService.selectList(new EntityWrapper<>(project));

第二种方法，若project中有属性为int ，则sql 会出现  and 所有int的字段，且默认值为0

有一种猜测：mybatis+ 在拼接sql时，判断字段不为null，则and 上去

而int的默认值是0

 

/**
     * 获取所有员工
     * @return
     */
    @RequestMapping("/staffAdvisoryList")
    public List<StaffInfo> staffAdvisoryList(){
        EntityWrapper<StaffInfo> entityWrapper = new EntityWrapper<>();
        entityWrapper.in("department_id",new Object[]{39,66,68,69});
        entityWrapper.eq(CommonConstant.DEL_FLAG,1);
        List<StaffInfo> staffInfos = staffInfoService.selectList(entityWrapper);
        return staffInfos;
    }