how to query mongodb in java

Http://www.cnblogs.com/viprx/archive/2012/09/06/2673693.htmlThe basic syntax for MONGODB conditional queries.Query.all ("name", "a", "B");//match array with multiple elementsQuery.and (Query.eq ("name", "a"), Query.eq ("title", "T"));//satisfy multiple conditions at the same timeQuery.eq ("name", "a");//equalsQuery.exists ("type", true);//Determine if key value existsQUERY.GT ("value", 2);//Greater Than >Query.gte ("Value", 3);//greater than or equal

Java connects to the MongoDB database and javamongodb Database I tried MongoDB during this time, and it is very easy to use and convenient. It has a great advantage over relational databases. So I tried to connect to MongoDB using java and Basic addition, deletion, modificat

The document formats stored in MongoDB are as follows, implementing queries Fromdata data for the specified values under did and Dvid{ "_id": { "$oid":"553f4a9facc494278f5ad1b0" }, "RID":"9eec7fbe8a6f4d17b02756fdbcefcc41", "Rname":"Test Scenario 1", "username":"zhaoptest", "Enable":1, "Fromdata": [ { " did":"AAA", "Dvid":"1", "opt":"3", "value":" -" }, { " did":"BBB", "Dvid":"1", "opt":"3", "v

The simplest query is that MongoDB is an object-oriented one.For example, the simplest query is only three data for the entire data setFirst query for data with name Zhang SanThe condition of the query is relatively good write arbitrary db.collection.find (

({age: {$gt: +}}, {name:1, age:1});Equivalent:select name, age from UserInfo where >25;13. Sort by ageCopy the code code as follows:Ascending:Db.userInfo.find (). Sort ({age:1});Descending:Db.userInfo.find (). Sort ({Age:-1});14. Query name = Zhangsan, age = 22 dataCopy the code code as follows:Db.userInfo.find ({name: ' Zhangsan ', age:22});Equivalent:SELECT * from userInfo where name = ' Zhangsan ' and "age = '";15,

This is a creation in Article, where the information may have evolved or changed. Golang mongodb MgO Insert, query a small example, Golang still give me that feeling, than Nodejs write up comfortable. Package main import ("FMT" "Launchpad.net/mgo" "Launchpad.net/mgo/bson") type Mail struct {Id Bson. ObjectId "_id" Name string Email String} func Main () {//Connect to database session, err: = MgO. Dial ("127.

Tags: DNA tst Day reg ODB ToString Moni CTI MatDb.getcollection (' Rpcmonitor_request '). Find ({"Requeststarttime":{$GT: Isodate ("2018-05-14 02:00"),$LT: Isodate ("2018-05-14 04:00")},"_id": ObjectId ("5af8fc5809d8d057f6a734e4")}) Db.getcollection (' Rpcmonitor_request '). Aggregate ([{$group:{requestcount:{$sum: 1},_ID:{"Requestday": {$dateToString: {format: "%y-%m-%d", Date: "$RequestStartTime"}},"Requesttypename": "$RequestTypeName","Requestmethodname": "$RequestMethodName"}}}]) Db.getcoll

:34:50 GMT-400", "Price": 4.01}); Test the Group program code to be executedDb.runcommand ({"group": { "ns": "Stocks", " Key": "Day", "initial": {"Time": 0}, "$reduce": function ( Doc, prev) { if (Doc.time > Prev.time) { prev.price = Doc.price; Prev.time = Doc.time; } } Results after the execution {" retval": [ { "time": 0 } ], "Count": 5, "keys

Query.all ("name", "a", "B"), or//through multiple elements to match the array Query.and (Query.eq ("name", "a"), Query.eq ("title", "T"));//satisfy multiple conditions at the same time query.eq ("name", "a");//equals Query.exists ("type", true);//Determines whether the key value exists query.gt ("value", 2);//greater Than > Query.gte ("value", 3);//greater than or equal to >= query.in ("name", "a", "B");//Includes all values specified, you can specify different types of conditions and val

The problem I encountered now is the image information stored by others in mongodb. The key is img, and the value is a url array. When I use the mongodb extension of php to query, the img domain returns a string, but what I want to get is the saved array object. Is there any way to get one... the problem I encountered is that MongodbImage Information stored in,

Label:First, the query method that returns the specified field in MongoDB is as follows: Db.person.find ({Name: "Clown"},{age:1,sex:1}) This statement indicates that all data in the person table named Clown is queried, but only the age column and the sex column are returned. (The _id column is returned by default, set to 0 to not return) To manipulate MongoDB in

not easy to find problems, should be based on the actual situation, give a reasonable time-out.Multiple tests found that the maximum execution time was 6 seconds, and the timeout was set to 10000.Socket-timeout= "10000"//10sNote: When MongoDB is consolidating with spring, if you want to configure multiple mongdb sources, only the last The parameter configuration information should be stored in the properties file.threads-allowed-to-block-for-connecti

Db.persons.find ({size:{$gt:3}}) 4. Use the shell to find out the number of books Jim likes to read var persons = Db.persons.find ({name:"Jim"}) while( Persons.hasnext ()) { = persons.next (); Print (obj.books.length) 1.mongodb is a NoSQL database, but he's still very powerful in document queries.2. The query is basically used in curly braces inside the update character is basically outside3.s

15. query Indexes We can query all the indexes: List For (dbobject index: List ){System. Out. println (INDEX );} The console output is similar to the following: {"Name": "I _1", "ns": "mydb. testcollection "," key ": {" I ": 1}," _ ns ":" system. indexes "} MongoDB Management Function1. Obtain all databases Mongo M = new Mongo (); For (string S: M. getdatabasen

In MySQL, the slow query log is often used as our basis for optimizing queries, is there a similar function in MongoDB? The answer is yes, that is to open the profiling function. The tool collects write operations on MongoDB, cursors, database commands, etc. on the running instance, which can be opened at the database level or at the instance level. The tool writ

Tags: number of tables new ROR about localhost property exp str funcCMD notation DB + table name + Find ({property name: {$regex: {/query Contents/}}}) Cases: Db.admins.find (user:{$regex: {/hehe/}}) Suppose to show that multiple items are returned if there are multiple user content about hehe. Express notation Associated Database + Find ({property name: {$regex: Query content},function (Err,datas) { if (e

This article by larrylgq prepared, reproduced please note the Source: http://blog.csdn.net/larrylgq/article/details/7395261 Author: Lu guiqiang Email: larry.lv.word@gmail.com MongoDB adds user authentication: adds users, deletes users, modifies user passwords, reads and writes, and read-only permissions. Note: Adding users is for database operations.Take creating a Java User (whose password is

Read some information, corresponding only need to know how to query and use MongoDB for me, these are enough. On the left is the MONGODB query statement, and the right is the SQL statement. Compared with the use, very convenient. Db.users.find () SELECT * from Usersdb.users.find ({' Age ': +}) SELECT * from users wher

MongoDB Learning Note 03– query expressionNot equal to, greater than, less than ! =: Db.stu.find ({name:{$ne: ' billvsme '}}) name is not ' billvsme ' >: Db.stu.find ({age:{$gt:18}}) older than 18 $lt:18}}) older than 18 >=: $GTE $LTE In/not In/all $in:db.goods.find (stu_id:{$in:[93001,93002,93003]}) study number 93001 or 93002 or 93003 $Nin:not in $All: The sp

Label:1) and (with and when multiple conditions are met) publicvoidtestAnd(){ new BasicDBObject(); //agender=‘female‘ AND age > 27 queryCondition.put("agender""female"); queryCondition.put("age"new BasicDBObject("$gt"27)); DBCursor dbCursor = coll.find(queryCondition); } 2) Or (two conditions satisfy one of them) Public void Testorsinglefield() {DBObject querycondition =NewBasicdbobject ();//ageBasicdblist values =NewBasicdblist (); Values.ad