mongodb and 和 or 查询

余劲峰 發表於 2019-10-8 14:51:00

db.getCollection('gxyWarnEntity').find({ "schoolId" : "f11c8ea12f457dbc19c768a8bb6357f8", "batchId" : "594f724d6974c107bd702cc6ef39183a", "$or" : [{ "studentName" : { "$regex" : "小", "$options" : "" } }, { "teacherName" : { "$regex" : "小", "$options" : "" } }] })
 
java：
<div class="cnblogs_code">
<pre> public List<GxyWarnEntity>selectWarnPage(GxyWarnEntitygxyWarnEntity){

 Criteria cri =Criteria.where("schoolId").is(gxyWarnEntity.getSchoolId());

 if(gxyWarnEntity.getBatchId()!=null) {
 cri.and("batchId").is(gxyWarnEntity.getBatchId());
 }
 if(gxyWarnEntity.getDepId()!=null){
 cri.and("depId").is(gxyWarnEntity.getDepId());
 }
 if(gxyWarnEntity.getWarningType()!=null){
 cri.and("warningType").is(gxyWarnEntity.getWarningType());
 }
 if(gxyWarnEntity.getStudentName()!=null){
 cri.orOperator(Criteria.where("studentName").regex(gxyWarnEntity.getStudentName()),
 Criteria.where("teacherName").regex(gxyWarnEntity.getStudentName())
 //,Criteria.where("classTeacherName").regex(gxyWarnEntity.getStudentName())
 );
 }

 Query query = new Query(cri);
 if (gxyWarnEntity.getCurrPage() != null && gxyWarnEntity.getPageSize() != null) {
 query.skip((gxyWarnEntity.getCurrPage()-1)*gxyWarnEntity.getPageSize())
 .limit(gxyWarnEntity.getPageSize());
 }

 return template.find(query, GxyWarnEntity.class);
}</pre>
</div>
 
 
and:   
db.getCollection('gxyWarnEntity').find({ "schoolId" : "f11c8ea12f457dbc19c768a8bb6357f8", "batchId" : "", "$and" : [{ "warningType" : { "$gte" : 1 } }, { "warningType" : { "$ne" : 4 } }], "$or" : [{ "studentName" : { "$regex" : "小", "$options" : "" } }, { "teacherName" : { "$regex" : "小", "$options" : "" } }] })
 
{ "schoolId" : "f11c8ea12f457dbc19c768a8bb6357f8", "batchId" : "", "$and" : [{ "warningType" : { "$gte" : 1 } }, { "warningType" : { "$ne" : 4 } }], "$or" : [{ "studentName" : { "$regex" : "小", "$options" : "" } }, { "teacherName" : { "$regex" : "小", "$options" : "" } }] } fields: Document{{}} for class: class com.zhangtao.moguding.practiceservice.entity.GxyWarnEntity in collection: gxyWarnEntity 2019-10-15 09:52:17.819 DEBUG 13028 --- o.s.data.mongodb.core.MongoTemplate : Executing count: { "schoolId" : "f11c8ea12f457dbc19c768a8bb6357f8", "batchId" : "", "$and" : [{ "warningType" : { "$gte" : 1 } }, { "warningType" : { "$ne" : 4 } }], "$or" : [{ "studentName" : { "$regex" : "小", "$options" : "" } }, { "teacherName" : { "$regex" : "小", "$options" : "" } }] } in collection: gxyWarnEntity
<div class="cnblogs_code">
<pre> public List<GxyWarnEntity>selectWarnPage(GxyWarnEntitygxyWarnEntity){

 Criteria cri =Criteria.where("schoolId").is(gxyWarnEntity.getSchoolId());

 if(gxyWarnEntity.getBatchId()!=null) {
 cri.and("batchId").is(gxyWarnEntity.getBatchId());
 }
 if(gxyWarnEntity.getDepId()!=null){
 cri.and("depId").is(gxyWarnEntity.getDepId());
 }
 if(gxyWarnEntity.getWarningType()!=null && gxyWarnEntity.getWarningType() != EnumUnsignType.UNSIGNONE.getType()){
 cri.andOperator(
 Criteria.where("warningType").gte(gxyWarnEntity.getWarningType()),
 Criteria.where("warningType").ne(EnumUnsignType.UNSIGNONE.getType())
 );
 }
 if(gxyWarnEntity.getStudentName()!=null){
 cri.orOperator(Criteria.where("studentName").regex(gxyWarnEntity.getStudentName()),
 Criteria.where("teacherName").regex(gxyWarnEntity.getStudentName())
 //,Criteria.where("classTeacherName").regex(gxyWarnEntity.getStudentName())
 );
 }

 Query query = new Query(cri);
 if (gxyWarnEntity.getCurrPage() != null && gxyWarnEntity.getPageSize() != null) {
 query.skip((gxyWarnEntity.getCurrPage()-1)*gxyWarnEntity.getPageSize())
 .limit(gxyWarnEntity.getPageSize());
 }

 return template.find(query, GxyWarnEntity.class);
}</pre>
</div>
  
来源：https://www.cnblogs.com/z360519549/p/11635366.html

頁: [1]

琼殿技术论坛's Archiver

mongodb and 和 or 查询