mongodb查詢條件設定

標籤：template   record   資料   god   不顯示   pagebean   rect   inf   oar   

        //查詢條件
        Query query = new Query();
        //查詢條件
        Criteria criteria = new Criteria();
        SimpleDateFormat format =  new SimpleDateFormat( "yyyy-MM-dd HH:mm:ss" );

        if (StringUtils.isNotEmpty(type) && !type.equals("-1")) {
            criteria.and("type").is(type);
        }
       
        String contacter=entrustInfoVo.getContacter();
        if (StringUtils.isNotEmpty(contacter)) {
            criteria.and("jsonObj.contacter").is(contacter);
        }
        
        String provinceId=entrustInfoVo.getProvinceId();
        String provinceName=entrustInfoVo.getProvinceName();
        List<Criteria> list = new ArrayList<Criteria>();
        if (StringUtils.isNotEmpty(provinceId) || StringUtils.isNotEmpty(provinceName)) {
            criteria.and("signupRecordHandleVO.provinceId").is(provinceId);
            list.add(Criteria.where("signupRecordHandleVO.provinceName").is(provinceName));
        }
        //賣房委託和租房委託的資料不顯示（1：賣房委託 2：租房委託）
        list.add(Criteria.where("type").in("3","4","5","6","7","8","9","10","11","12","13","14"));
        //處理狀態
        String handleFlag=entrustInfoVo.getHandleFlag();
        if (StringUtils.isNotEmpty(handleFlag)) {
            criteria.and("signupRecordHandleVO.handleFlag").is(Integer.parseInt(handleFlag));
        }
       
        if (list.size() > 0) {
            criterial.orOperator(list.toArray(new Criteria[list.size()]));
            criteria.andOperator(criterial);
        }
        query.addCriteria(criteria);
        //總條數
        long count = mongoTemplate.count(query, EntrustJsonObj.class, TableConstants.STEWARD_ENTRUST_INFO);
        System.out.print(query.toString());
        //分頁
        query.skip((pageNo - 1) * pageSize);// skip相當於從哪條記錄開始
        query.limit(pageSize);// 從skip開始,取多少條記錄

        //排序
        Sort sort = new Sort(Sort.Direction.DESC, "createTime");
        query.with(sort);

        pageBean.setTotalCount(count);

mongodb查詢條件設定