JAVA-查看MongoDB中的数据(包含List集合)

package com.xinsight.server;

import java.net.UnknownHostException;
import java.util.ArrayList;
import java.util.List;

import com.mongodb.BasicDBObject;
import com.mongodb.DB;
import com.mongodb.DBCollection;
import com.mongodb.DBCursor;
import com.mongodb.DBObject;
import com.mongodb.Mongo;
import com.xinsight.Util.BeanUtil;
import com.xinsight.Util.InitMongodb;
import com.xinsight.Util.Manager;
import com.xinsight.server.model.PhoneEntity;
/**
 *查找Mongodb中列中的List集合 
 */
public class FindMongodbServer {
    public static void main(String args[]){
        try {
            Mongo mg = new Mongo("localhost",27017);
            DB db = mg.getDB("admin");
            if(db.authenticate("aa", "aa".toCharArray())){
                db = mg.getDB("dxtext");
                DBCollection dbc = db.getCollection("zq1");
                DBCursor u = dbc.find();
                while(u.hasNext()){
                    String n = "";
                    BasicDBObject obj = (BasicDBObject)u.next();
                    ArrayList<BasicDBObject> list = (ArrayList<BasicDBObject>)obj.get("l");
                    for(BasicDBObject basi : list){
                        n += basi.getString("n") + "_" + basi.getString("t") + "#";  //将list中的数据拼接
                    }
                    n = n.substring(0, n.length() - 1);
                    System.out.println(n);
                    int sum = 0;  //总共接听电话次数
                    String strs[] = n.split("#");
                    for(int i = 0;i < strs.length;i++){
                        int a = Integer.parseInt(strs[i].split("_")[1]);
                        sum +=a;
                    }
                    System.out.println(obj.get("n") + "  " + sum);  //主叫号码     总共接听次数
                    System.out.println("----------------------");
                    Thread.sleep(1000);
                }
            }
        } catch (UnknownHostException e) {
            e.printStackTrace();
        } catch (InterruptedException e) {
            e.printStackTrace();
        }
    }
}

 

posted @ 2015-09-25 18:10  zqzdong  阅读(9475)  评论(0编辑  收藏  举报