mongodb api 使用小结

1.字段模糊查询

collname = collname+"-"+table;
DB db = mongoconn.getDb_con();
BasicDBList condList = new BasicDBList();
DBCollection users = db.getCollection(collname);
BasicDBObject dbo = new BasicDBObject();
String mode = rectime.split(" ")[0];
Pattern pattern = Pattern.compile("^.*" + mode + ".*$", Pattern.CASE_INSENSITIVE);
dbo.put("MONITORTIME", pattern);
condList.add(dbo);
BasicDBObject condition = new BasicDBObject();
condition.put("$and", condList);
DBCursor cursor = users.find(condition);


while (cursor.hasNext()) {

}

2.区间查询

DB db = rawmc.getDb_con();
BasicDBList condList = new BasicDBList();
DBCollection users = db.getCollection(colName);
SimpleDateFormat sd = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");


String t2 = sd.format(endtime);
String t3 = sd.format(startime);
BasicDBObject dbo = new BasicDBObject("receiveTime", new BasicDBObject("$gte", t2));// >=
BasicDBObject dbo1 = new BasicDBObject("receiveTime", new BasicDBObject("$lte", t3));// <=


condList.add(dbo);
condList.add(dbo1);


BasicDBObject condition = new BasicDBObject();
condition.put("$and", condList);
DBCursor cursor = users.find(condition);
paravals = new HashMap<>();
while (cursor.hasNext()) {

}

3.in查询

BasicDBList values = new BasicDBList();  
    values.add(13);  
    values.add(47);  
    queryCondition.put("age", new BasicDBObject("$in", values));