spring boot中 mongdb 多条件复杂查询-CSDN博客

本文介绍了一个基于MongoDB的查询实现案例，通过DAO层接口与Service层业务逻辑相结合，利用Spring Data MongoDB提供的强大查询API，实现了根据日期范围、线路代码、站点名称及区域代码等条件进行复杂的数据筛选。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1.dao层继承MongoRepository

public interface PFlowLineStationHourDao extends MongoRepository<PFlowLineStationHourEntity, Long>{

}

2.service层注入PFlowLineStationHourDao ，MongoTemplate

例：

@Service

public class PFlowLineServiceImpl implements PFlowLineService{

@Autowired

public PFlowLineStationHourDao pFlowLineStationHourDao;

@Autowired

private MongoTemplate mongoTemplate;

public List<?> queryPFlowLineStationHour(PFlowQueryParam param) {
Query query = new Query();
if(param.getDates().size()>0){
query.addCriteria(Criteria.where("yearMonthDate").in(param.getDates()));
}else{
int beginDate = Integer.parseInt(DateUtil.getYearMonthDayFormat(DateUtil.getDayBefore(param.getBegintime())));
int endDate = Integer.parseInt(DateUtil.getYearMonthDayFormat(DateUtil.getDayAfter(param.getEndtime())));
query.addCriteria(Criteria.where("yearMonthDate").gte(beginDate).lte(endDate));
}
if(param.getLineCodes().size()>0){
query.addCriteria(Criteria.where("lineCode").in(param.getLineCodes()));
}
if(param.getStationnames().size()>0){
query.addCriteria(Criteria.where("stationname").in(param.getStationnames()));
}
if(param.getAreacodes().size()>0){
query.addCriteria(Criteria.where("areacode").in(param.getAreacodes()));
}
return mongoTemplate.find(query, PFlowLineStationHourEntity.class);
}