mongoTemplate使用总结

@RequestMapping(value = "/query1", method = RequestMethod.GET)
@ApiOperation("and 的 用法1")
public Object query1(String unified_social_credit_code) { // ✔
    Query query = new Query();
    query.addCriteria(Criteria.where("unified_social_credit_code").is(unified_social_credit_code));
    query.addCriteria(Criteria.where("business_types").is("1"));
    IndustrialBusiness one = mongoTemplate.findOne(query, IndustrialBusiness.class);
    return one;

}


@RequestMapping(value = "/query2", method = RequestMethod.GET)
@ApiOperation("and 的 用法2")
public Object query2(String unified_social_credit_code) { // ✔
    Query query = new Query();
    query.addCriteria(Criteria.where("unified_social_credit_code").is(unified_social_credit_code).andOperator(Criteria.where("business_types").is("1")));
    IndustrialBusiness one = mongoTemplate.findOne(query, IndustrialBusiness.class);
    return one;

}

@RequestMapping(value = "/query8", method = RequestMethod.GET)
@ApiOperation("and 的 用法4")
public Object query8(String unified_social_credit_code) { // ✔
    Query query = new Query();
    query.addCriteria(new Criteria().andOperator(Criteria.where("unified_social_credit_code").is(unified_social_credit_code), Criteria.where("business_types").is("高级工程师")));
    List<IndustrialBusiness> industrialBusinesses = mongoTemplate.find(query, IndustrialBusiness.class);
    return industrialBusinesses;

}


@RequestMapping(value = "/query3", method = RequestMethod.GET)
@ApiOperation("or 的 用法1")
public Object query3(String unified_social_credit_code) {// ✔
    Query query = new Query();
    query.addCriteria(new Criteria().orOperator(Criteria.where("unified_social_credit_code").is(unified_social_credit_code), Criteria.where("unified_social_credit_code").is("111")));
    List<IndustrialBusiness> industrialBusinesses = mongoTemplate.find(query, IndustrialBusiness.class);
    return industrialBusinesses;
}

@RequestMapping(value = "/query10", method = RequestMethod.GET)
@ApiOperation("or 的 用法2")
public Object query10(String unified_social_credit_code) {// ✔
    Query query = new Query();
    query.addCriteria(new Criteria().orOperator(Criteria.where("unified_social_credit_code").is(unified_social_credit_code), Criteria.where("unified_social_credit_code").is("1234"), Criteria.where("business_types").is("高级工程师")));
    List<IndustrialBusiness> industrialBusinesses = mongoTemplate.find(query, IndustrialBusiness.class);
    return industrialBusinesses;
}

@RequestMapping(value = "/query11", method = RequestMethod.GET)
@ApiOperation("or 的 用法3")
public Object query11(String unified_social_credit_code) {// x 第二行和第三行当成and 执行了
    Query query = new Query();
    query.addCriteria(new Criteria().orOperator(Criteria.where("unified_social_credit_code").is(unified_social_credit_code), Criteria.where("unified_social_credit_code").is("11221")));
    query.addCriteria(Criteria.where("business_types").is("高级工程师"));
    List<IndustrialBusiness> industrialBusinesses = mongoTemplate.find(query, IndustrialBusiness.class);
    return industrialBusinesses;
}

@RequestMapping(value = "/query4", method = RequestMethod.GET)
@ApiOperation("and 的 用法3")
public Object query4(String unified_social_credit_code) { // ×
    Query query = new Query();
    query.addCriteria(Criteria.where("unified_social_credit_code").is(unified_social_credit_code).andOperator(Criteria.where("unified_social_credit_code").is("string")));
    IndustrialBusiness one = mongoTemplate.findOne(query, IndustrialBusiness.class);
    return one;

}


@RequestMapping(value = "/query5", method = RequestMethod.GET)
@ApiOperation("返回指定字段的查询")
public Object query5(String unified_social_credit_code) {// ✔
    DBObject obj = new BasicDBObject();
    //添加条件
    obj.put("unified_social_credit_code", new BasicDBObject("$eq", unified_social_credit_code));

    BasicDBObject fieldsObject = new BasicDBObject();

    //返回普通字段
    fieldsObject.put("business_types", true);
    fieldsObject.put("_id", false);

    Query query = new BasicQuery(obj.toString(), fieldsObject.toString());
    String base_technicalinput = mongoTemplate.findOne(query, String.class, "base_industrial_business");
    JSONObject jsonObject = JSON.parseObject(base_technicalinput);
    Object business_types = jsonObject.get("business_types");// 技术投入金额
    return business_types;
}


@RequestMapping(value = "/query6", method = RequestMethod.GET)
@ApiOperation("正则的 用法")
public Object query6(String unified_social_credit_code) { // ✔
    Query query2 = new Query();
    query2.addCriteria(Criteria.where("unified_social_credit_code").is(unified_social_credit_code));
    query2.addCriteria(Criteria.where("business_types").regex(pattern));
    List<IndustrialBusiness> industrialBusinesses = mongoTemplate.find(query2, IndustrialBusiness.class);// 高级职称的人数
    return industrialBusinesses;

}

@RequestMapping(value = "/query7", method = RequestMethod.GET)
@ApiOperation("and 和 or一起的用法")
public Object query7(String unified_social_credit_code) { // ✔
    Query query2 = new Query();
    query2.addCriteria(new Criteria().orOperator(Criteria.where("enterprises_types").is("string11"), new Criteria().andOperator(Criteria.where("unified_social_credit_code").is(unified_social_credit_code), Criteria.where("business_types").is("1"))));
    List<IndustrialBusiness> industrialBusinesses = mongoTemplate.find(query2, IndustrialBusiness.class);// 高级职称的人数
    return industrialBusinesses;

}

@RequestMapping(value = "/query9", method = RequestMethod.GET)
@ApiOperation("年份")
public Object query9() { // ✔
    String s = DateUtil.getYearForNum(0).toString();
    return s;

}


@RequestMapping(value = "/query12", method = RequestMethod.GET)
@ApiOperation("排序测试")
public Object query12(String unified_social_credit_code) { // ✔
    Query query = new Query();
    query.addCriteria(Criteria.where("unified_social_credit_code").is(unified_social_credit_code));
    query.with(new Sort(Sort.Direction.DESC,"management_state"));
    List<IndustrialBusiness> industrialBusinesses = mongoTemplate.find(query, IndustrialBusiness.class);
    return industrialBusinesses;