java mongodb 高级查询

1. /**
2. *MongoDBTest
3. *MongoDBJAVAAPI的高级查询示例
4. */
5. packagecom.labci.mongodb.test;
6. importjava.net.UnknownHostException;
7. importjava.util.Iterator;
8. importcom.mongodb.BasicDBObject;
9. importcom.mongodb.DB;
10. importcom.mongodb.DBCollection;
11. importcom.mongodb.DBCursor;
12. importcom.mongodb.DBObject;
13. importcom.mongodb.Mongo;
14. importcom.mongodb.MongoException;
15. /**
16. *@authorBillTu(tujiyue/iwtxokhtd)
17. *May21,2011[11:33:34PM]
18. *
19. */
20. publicclassMongoDBAdvancedQuery{
21. privatestaticfinalStringHOST="192.168.1.86";
22. privatestaticfinalintPORT=27017;
23. privatestaticfinalStringUSER="iwtxokhtd";
24. privatestaticfinalStringPASSWORD="123456";
25. privatestaticfinalStringDB_NAME="test";
26. privatestaticfinalStringCOLLECTION="data_test";
27. privatestaticMongoconn=null;
28. privatestaticDBmyDB=null;
29. privatestaticDBCollectionmyCollection=null;
31. static{
32. try{
33. conn=newMongo(HOST,PORT);//建立数据库连接
34. myDB=conn.getDB(DB_NAME);//使用test数据库
35. booleanloginSuccess=myDB.authenticate(USER,PASSWORD.toCharArray());//用户验证
36. if(loginSuccess){
37. myCollection=myDB.getCollection(COLLECTION);
38. }
39. }catch(UnknownHostExceptione){
40. e.printStackTrace();
41. }catch(MongoExceptione){
42. e.printStackTrace();
43. }
44. }
46. /**
47. *查询数据
48. *@paramcollection　“表”名
49. */
50. privatestaticvoidqueryData(DBCollectioncollection){
51. //count查询
52. System.out.println("表的总记录数为：");
53. System.out.println(collection.find().count());
54. //分页查询
55. DBCursorfindAll=collection.find();
56. DBCursorqueryByPage=findAll.skip(3).limit(4);
57. printData("从第3条记录起取４条记录为：",queryByPage);
58. //orderby操作
59. DBObjectorderBy=newBasicDBObject();
60. orderBy.put("userName",-1);//按userName倒序排
61. DBCursororderByResult=collection.find().sort(orderBy);
62. printData("所有记录按userName倒序排为：",orderByResult);
64. //"!="和">"操作
65. DBObjectnotEqual=newBasicDBObject();
66. notEqual.put("$ne","BillTu10");
68. DBObjectgreatThan=newBasicDBObject();
69. greatThan.put("$gt",7);
71. DBObjectnotEqualAndGreatThan=newBasicDBObject();
72. notEqualAndGreatThan.put("userName",notEqual);
73. notEqualAndGreatThan.put("age",greatThan);
75. DBCursornotEqualAndGreatThanResult=collection.find(notEqualAndGreatThan);
76. printData("userName!='BillTu10'andage>7的记录为：",notEqualAndGreatThanResult);
78. //">="和"<="操作
79. DBObjectgreatThanEqualAndLessThanEqual=newBasicDBObject();
80. greatThanEqualAndLessThanEqual.put("$gte",2);
81. greatThanEqualAndLessThanEqual.put("$lte",7);
83. DBObjectageCompare=newBasicDBObject();
84. ageCompare.put("age",greatThanEqualAndLessThanEqual);
86. DBCursorcompareResult=collection.find(ageCompare);
87. printData("age>=2andage<=7的记录为：",compareResult);
89. //all操作
90. DBObjectall=newBasicDBObject();
91. all.put("$all",newObject[]{7,7});
93. DBObjectrankAll=newBasicDBObject();
94. rankAll.put("rank",all);
96. DBCursorrankAllResult=collection.find(rankAll);
97. printData("rankinall(7,7)的记录为：",rankAllResult);
99. //notin操作
100. DBObjectnotIn=newBasicDBObject();
101. notIn.put("$nin",newObject[]{2,3});
103. DBObjectageNotIn=newBasicDBObject();
104. ageNotIn.put("age",notIn);
106. DBCursorageNotInResult=collection.find(ageNotIn);
107. printData("agenotin(2,3)的记录为：",ageNotInResult);
109. //or操作
110. DBObjectorGreatThan=newBasicDBObject("$gt",3);
111. DBObjectorRankAll=newBasicDBObject("$all",newObject[]{1,1});
112. DBObjectageOrGreatThan=newBasicDBObject();
113. ageOrGreatThan.put("age",orGreatThan);
114. DBObjectrankOrAll=newBasicDBObject();
115. rankOrAll.put("rank",orRankAll);
117. DBObjectorOperation=newBasicDBObject();
118. orOperation.put("$or",newObject[]{ageOrGreatThan,rankOrAll});
120. DBCursororResult=collection.find(orOperation);
121. printData("age>3orrankinall(1,1)的记录为：",orResult);
123. //notor操作
124. DBObjectnotOrOperation=newBasicDBObject();
125. notOrOperation.put("$nor",newObject[]{ageOrGreatThan,rankOrAll});
127. DBCursornotOrResult=collection.find(notOrOperation);
128. printData("not(age>3orrankinall(1,1))的记录为：",notOrResult);
130. //size操作
131. DBObjectsize=newBasicDBObject("$size",3);
132. DBObjectrankSize=newBasicDBObject();
133. rankSize.put("rank",size);
135. DBCursorsizeResult=collection.find(rankSize);
136. printData("rank数组大小为３的记录为：",sizeResult);
138. //exists操作
139. DBObjectexists=newBasicDBObject("$exists",false);
140. DBObjectuserNameExists=newBasicDBObject();
141. userNameExists.put("userName",exists);
143. DBCursoruserNameExistsResult=collection.find(userNameExists);
144. printData("userNameexistsfalse的记录为：",userNameExistsResult);
146. //mod取模操作
147. DBObjectmodArray=newBasicDBObject("$mod",newObject[]{2,0});
148. DBObjectageMod=newBasicDBObject();
149. ageMod.put("age",modArray);
151. DBCursorageModResult=collection.find(ageMod);
152. printData("age%2==0的记录为：",ageModResult);
154. }
156. /**
157. *打印结果数据
158. *@paramdescription　结果数据相关描述
159. *@paramrecordResult　结果集
160. */
161. privatestaticvoidprintData(Stringdescription,DBCursorrecordResult){
162. System.out.println(description);
163. for(Iterator<DBObject>iter=recordResult.iterator();iter.hasNext();){
164. System.out.println(iter.next());
165. }
166. }
168. /**
169. *@paramargs
170. */
171. publicstaticvoidmain(String[]args){
172. queryData(myCollection);
173. }
174. }