java mongodb 数组查询条件_java Mongodb 查询数组

有一下数组

{

"FOLDER_ID": "aaa",

"UUID": "zsw",

"_id": ObjectId("4f90c83c5b313c4bd9c271d5"),

"file_list": [

{

"file_id": "2",

"file_name": "歌曲",

"file_size": "34MB",

"last_modified": "2001-3-3",

"thumb_img_uri": "www.google.cn"

}

],

"subfolder_list": [

{

"folder_id": "1",

"label": "我的文档"

"ast_modified": "2001-3-21",

"thumb_img_uri": "www.baidu.com"

}

]

}查询  数组 file_list里全部的元素

BasicDBObject query = new BasicDBObject();

BasicDBObject field = new BasicDBObject();

field.put("file_list", 1);

DBCursor cursor = coll.find(query, field);

while(cursor.hasNext()){

BasicDBObject result = (BasicDBObject) cursor.next();

int i = result.size();

System.out.println("Result Size: "+i);

System.out.println(result);

查询结果

{ "_id" : { "$oid" : "4f90c83c5b313c4bd9c271d5"} , "file_list" : [ { "file_id" : "2" , "file_name" : "歌曲" , "file_size" : "34MB" , "last_modified" : "2001.3-3" , "thumb_img_uri" : "www.google.cn"}]}

查询 file_list 里 file_name的字段

BasicDBObject query = new BasicDBObject();

BasicDBObject field = new BasicDBObject();

field.put("file_list", 1);

DBCursor cursor = coll.find(query, field);

while(cursor.hasNext()){

BasicDBObject result = (BasicDBObject) cursor.next();

int i = result.size();

System.out.println("Result Size: "+i);

System.out.println(result);

ArrayList versi=(ArrayList)result.get("file_list");

for(BasicDBObject embedded:versi){

String file_name = embedded.getString("file_name");

System.out.println("file_name:"+file_name);

}

查询结果

{ "_id" : { "$oid" : "4f90c83c5b313c4bd9c271d5"} , "file_list" : [ { "file_id" : "2" , "file_name" : "歌曲" , "file_size" : "34MB" , "last_modified" : "2001.3-3" , "thumb_img_uri" : "www.google.cn"}]}

file_name:歌曲