关于 mongodb 的内嵌关联查询

最新推荐文章于 2024-08-14 02:18:29 发布

原创最新推荐文章于 2024-08-14 02:18:29 发布 · 3.1k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mongodb

关于学习专栏收录该内容

19 篇文章

订阅专栏

本文介绍了一个使用MongoDB进行复杂查询的Java方法实现。该方法通过输入分页参数、日期、起始地、目的地及运输组织等信息，实现对订单集合中特定运输记录的模糊搜索，并返回匹配结果的数量与列表。

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

public Object[] searchTrans(int pageNumber,int pageSize,String godates,String wherefrom,String whereto,String transorg){
		if(godates==null)godates = "\\w*"+godates+"\\w*";
		if(wherefrom==null)wherefrom = "\\w*"+wherefrom+"\\w*";
		if(whereto==null)whereto = "\\w*"+whereto+"\\w*";
		if(transorg==null)transorg = "\\w*"+transorg+"\\w*";
		
		try {
			BuguConnection conn = BuguConnection.getInstance();  
			DB db = conn.getDB();
			DBCollection order = db.getCollection("order");
			
			BasicDBObject bdbo2 = new BasicDBObject();
			bdbo2.put("godates",Pattern.compile(godates));
			bdbo2.put("wherefrom",Pattern.compile(wherefrom));
			bdbo2.put("whereto",Pattern.compile(whereto));
			bdbo2.put("transorg",Pattern.compile(transorg));
			BasicDBObject bdbo1 = new BasicDBObject();
			bdbo1.put("$elemMatch", bdbo2);
			BasicDBObject bdbo = new BasicDBObject();
			bdbo.put("trans", bdbo1);
			
			BasicDBObject paymethod1 = new BasicDBObject();
			paymethod1.put("$gte", "0");
			BasicDBObject paymethod2 = new BasicDBObject();
			paymethod2.put("paymethod", paymethod1);
			
			int count = order.find(paymethod2,bdbo).count();
			DBCursor cur = order.find(paymethod2,bdbo).limit(pageSize).skip(pageNumber).sort(new BasicDBObject("trans.godates","-1"));
			List<Object[]> transList = new ArrayList<Object[]>();
			while (cur.hasNext()) {
				DBObject dbo = cur.next();
				if(dbo.get("trans")!=null){
					BasicDBList bson = (BasicDBList) dbo.get("trans");
					for (Object oo : bson) {
						BasicDBObject bson1 = (BasicDBObject)oo;
						transList.add(new Object[]{dbo.get("_id"),bson1});
					}
				}
			}
			return new Object[]{count,transList};
		}catch (MongoException e) {
			e.printStackTrace();
			return null;
		}
	}