需要查询sponsor id为传入的id时 id字段查询失败
public R<Page<Challenge>> list(@PathVariable("id") String id, @RequestParam("from") int from, @RequestParam("size") int size){
Query query = new Query(Criteria.where("sponsor").is(id));
Page page=new Page(from,size);
challengeService.list(page,query);
return R.success(page);
}
因为设计数据库时,id的默认值为系统自动生成的objectid,所以查询时,需要用字符串生成objectid类型的id
Query query = new Query(Criteria.where("sponsor").is(new ObjectId(id)));