mongoTemplate查询
2024-09-21 03:05:43
1、精确查询用“is”
Criteria criteria=new Criteria("namespaceName");
criteria.is(namespaceName);
Query query = new Query(criteria);
return mongoTemplate.find(query,StorageBO.class,StorageConstant.STORAGE_COLLECTION_NAME);
2、模糊查询用“regex”
Criteria criteria=new Criteria("storageName");
criteria.regex(storageName);
Query query = new Query(criteria);
return mongoTemplate.find(query,StorageBO.class,StorageConstant.STORAGE_COLLECTION_NAME);
3、模糊查询示例2
//完全匹配
Pattern pattern = Pattern.compile("^hzb$", Pattern.CASE_INSENSITIVE);
//右匹配
Pattern pattern = Pattern.compile("^.*hzb$", Pattern.CASE_INSENSITIVE);
//左匹配
Pattern pattern = Pattern.compile("^hzb.*$", Pattern.CASE_INSENSITIVE);
//模糊匹配
Pattern pattern = Pattern.compile("^.*hzb.*$", Pattern.CASE_INSENSITIVE);
Query query = Query.query(Criteria.where(fieldName).regex(pattern));
List<StorageBO> storages = mongoTemplate.find(query, StorageBO.class, collectionName);
return storages;
4、按createTime降序排序
以下红色部分是排序设置
Criteria criteria=new Criteria("namespaceName");
criteria.is(namespaceName);
criteria.and("tenantName").is(tenantName);
Query query = new Query(criteria);
query.with(new Sort(Sort.Direction.DESC, "createTime"));
return mongoTemplate.find(query,StorageBO.class,StorageConstant.STORAGE_COLLECTION_NAME);
最新文章
- Spring-----定时任务Quartz配置
- JavaScript的chapterII
- 详解;(function ($,window,document,undefined){...})(jQuery,window,document);
- 【转】asp.net Cookie值中文乱码问题解决方法
- jdbc操作数据库返回结果集的注意事项
- 理解KMP
- 读书笔记:7个示例科普CPU Cache
- PTA 5-15 PAT Judge (25分)
- 在ASP.NET中使用一般处理程序生成验证码
- Egret --视觉编程,显示对象,事件
- 转:KVC与KVO机制
- JS Event事件流(冒泡机制、捕获机制、事件绑定)
- JAVA_SE基础——68.RunTime类
- HEOI2019退役总结
- day03运算符 逻辑运算符
- LCA&;最小生成树
- 有序广播和标准广播 --Android开发
- Test传送门(更新中)
- 【spring boot】【elasticsearch】spring boot整合elasticsearch,启动报错Caused by: java.lang.IllegalStateException: availableProcessors is already set to [8], rejecting [8
- android之卸载反馈的功能