java mongodb 高级查询

1. /** 
2.  * MongoDBTest 
3.  * MongoDB JAVA API的高级查询示例 
4.  */  
5. package com.labci.mongodb.test;  
6. import java.net.UnknownHostException;  
7. import java.util.Iterator;  
8. import com.mongodb.BasicDBObject;  
9. import com.mongodb.DB;  
10. import com.mongodb.DBCollection;  
11. import com.mongodb.DBCursor;  
12. import com.mongodb.DBObject;  
13. import com.mongodb.Mongo;  
14. import com.mongodb.MongoException;  
15. /** 
16.  * @author Bill Tu(tujiyue/iwtxokhtd) 
17.  * May 21, 2011[11:33:34 PM] 
18.  * 
19.  */  
20. public class MongoDBAdvancedQuery {  
21.     private static final String HOST = "192.168.1.86";  
22.     private static final int PORT = 27017;  
23.     private static final String USER = "iwtxokhtd";  
24.     private static final String PASSWORD = "123456";  
25.     private static final String DB_NAME = "test";  
26.     private static final String COLLECTION = "data_test";  
27.     private static Mongo conn=null;  
28.     private static DB myDB=null;  
29.     private static DBCollection myCollection=null;  
30.       
31.     static{  
32.         try {  
33.             conn=new Mongo(HOST,PORT);//建立数据库连接  
34.             myDB=conn.getDB(DB_NAME);//使用test数据库  
35.             boolean loginSuccess=myDB.authenticate(USER, PASSWORD.toCharArray());//用户验证  
36.             if(loginSuccess){  
37.                 myCollection=myDB.getCollection(COLLECTION);  
38.             }  
39.         } catch (UnknownHostException e) {  
40.             e.printStackTrace();  
41.         } catch (MongoException e) {  
42.             e.printStackTrace();  
43.         }  
44.     }  
45.       
46.     /** 
47.      * 查询数据 
48.      * @param collection　“表”名 
49.      */  
50.     private static void queryData(DBCollection collection){  
51.         //count查询  
52.         System.out.println("表的总记录数为：");  
53.         System.out.println(collection.find().count());  
54.         //分页查询  
55.         DBCursor findAll=collection.find();  
56.         DBCursor queryByPage=findAll.skip(3).limit(4);  
57.         printData("从第3条记录起取４条记录为：",queryByPage);  
58.         //order by操作  
59.         DBObject orderBy = new BasicDBObject();  
60.         orderBy.put("userName", -1);//按userName倒序排  
61.         DBCursor orderByResult=collection.find().sort(orderBy);  
62.         printData("所有记录按userName倒序排为：",orderByResult);  
63.           
64.         // "!=" 和 ">" 操作  
65.         DBObject notEqual=new BasicDBObject();  
66.         notEqual.put("$ne", "Bill Tu10");  
67.           
68.         DBObject greatThan=new BasicDBObject();  
69.         greatThan.put("$gt", 7);  
70.           
71.         DBObject notEqualAndGreatThan=new BasicDBObject();  
72.         notEqualAndGreatThan.put("userName", notEqual);  
73.         notEqualAndGreatThan.put("age", greatThan);  
74.           
75.         DBCursor notEqualAndGreatThanResult=collection.find(notEqualAndGreatThan);  
76.         printData("userName!='Bill Tu10' and age>7的记录为：",notEqualAndGreatThanResult);  
77.           
78.         // ">=" 和"<="操作  
79.         DBObject greatThanEqualAndLessThanEqual=new BasicDBObject();  
80.         greatThanEqualAndLessThanEqual.put("$gte", 2);  
81.         greatThanEqualAndLessThanEqual.put("$lte", 7);  
82.           
83.         DBObject ageCompare=new BasicDBObject();  
84.         ageCompare.put("age",greatThanEqualAndLessThanEqual);  
85.           
86.         DBCursor compareResult=collection.find(ageCompare);  
87.         printData("age>=2 and age<=7的记录为：",compareResult);  
88.           
89.         // all操作  
90.         DBObject all=new BasicDBObject();  
91.         all.put("$all", new Object[]{7,7});  
92.           
93.         DBObject rankAll=new BasicDBObject();  
94.         rankAll.put("rank", all);  
95.           
96.         DBCursor rankAllResult=collection.find(rankAll);  
97.         printData("rank in all(7,7)的记录为：",rankAllResult);  
98.           
99.         //not in操作  
100.         DBObject notIn=new BasicDBObject();  
101.         notIn.put("$nin", new Object[]{2,3});  
102.           
103.         DBObject ageNotIn=new BasicDBObject();  
104.         ageNotIn.put("age", notIn);  
105.           
106.         DBCursor ageNotInResult=collection.find(ageNotIn);  
107.         printData("age not in (2,3)的记录为：",ageNotInResult);  
108.           
109.         //or操作  
110.         DBObject orGreatThan=new BasicDBObject("$gt",3);  
111.         DBObject orRankAll=new BasicDBObject("$all",new Object[]{1,1});  
112.         DBObject ageOrGreatThan=new BasicDBObject();  
113.         ageOrGreatThan.put("age", orGreatThan);  
114.         DBObject rankOrAll=new BasicDBObject();  
115.         rankOrAll.put("rank", orRankAll);  
116.           
117.         DBObject orOperation=new BasicDBObject();  
118.         orOperation.put("$or", new Object[]{ageOrGreatThan,rankOrAll});  
119.           
120.         DBCursor orResult=collection.find(orOperation);  
121.         printData("age>3 or rank in all(1,1)的记录为：",orResult);  
122.           
123.         //not or操作  
124.         DBObject notOrOperation=new BasicDBObject();  
125.         notOrOperation.put("$nor", new Object[]{ageOrGreatThan,rankOrAll});  
126.           
127.         DBCursor notOrResult=collection.find(notOrOperation);  
128.         printData("not(age>3 or rank in all(1,1))的记录为：",notOrResult);  
129.           
130.         //size 操作  
131.         DBObject size=new BasicDBObject("$size",3);  
132.         DBObject rankSize=new BasicDBObject();  
133.         rankSize.put("rank", size);  
134.           
135.         DBCursor sizeResult=collection.find(rankSize);  
136.         printData("rank数组大小为３的记录为：",sizeResult);  
137.           
138.         //exists操作  
139.         DBObject exists=new BasicDBObject("$exists",false);  
140.         DBObject userNameExists=new BasicDBObject();  
141.         userNameExists.put("userName", exists);  
142.           
143.         DBCursor userNameExistsResult=collection.find(userNameExists);  
144.         printData("userName exists false的记录为：",userNameExistsResult);  
145.           
146.         //mod 取模操作  
147.         DBObject modArray=new BasicDBObject("$mod",new Object[]{2,0});  
148.         DBObject ageMod=new BasicDBObject();  
149.         ageMod.put("age", modArray);  
150.           
151.         DBCursor ageModResult=collection.find(ageMod);  
152.         printData("age%2==0的记录为：",ageModResult);  
153.           
154.     }  
155.       
156.     /** 
157.      * 打印结果数据 
158.      * @param description　结果数据相关描述 
159.      * @param recordResult　结果集 
160.      */  
161.     private static void printData(String description,DBCursor recordResult){  
162.         System.out.println(description);  
163.         for(Iterator<DBObject> iter=recordResult.iterator();iter.hasNext();){  
164.             System.out.println(iter.next());  
165.         }  
166.     }  
167.       
168.     /** 
169.      * @param args 
170.      */  
171.     public static void main(String[] args) {  
172.         queryData(myCollection);  
173.     }  
174. }