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(); } } }