java操作MongoDB

Mongo-Java-3.X的jar包

1、连接数据库：(用户名/密码:hello/happy；mldn是数据库名)
MongoClientURI uri = new MongoClientURI("mongodb://hello:happy@localhost:27001mldn");
MongoClient client = new MongoClient(uri);//设置连连的参数
MongoDatabase db = client.getDatabase("mldn");//连接数据库
System.out.println(db.getCollection("dept").count());//计数集合名为dept个数
client.close();//关闭数据库连接


2、数据的插入
import org.bson.Document;
MongoClientURI uri = new MongoClientURI("mongodb://hello:happy@localhost:27001/mldn");
MongoClient client = new MongoClient(uri);//设置连连的参数
MongoDatabase db = client.getDatabase("mldn");//连接数据库
MongoCollection col = db.getCollection("stu");
List<Document> list = new ArrayList<Document>();
for(int x = 0; x < 100; i++)
{
Document doc = new Document();
doc.append("id", x);
doc.append("name", tom);
doc.append("sex", "男");
list.add(doc);
}
col.insertMany(list);//插入数据库
client.close();


3、数据的全部查询
import org.bson.Document;
MongoClientURI uri = new MongoClientURI("mongodb://hello:happy@localhost:27001/mldn");
MongoClient client = new MongoClient(uri);//设置连连的参数
MongoDatabase db = client.getDatabase("mldn");//连接数据库
MongoCollection col = db.getCollection("stu");
MongoCursor<Document> cursor = col.find().iterator();
while(cursor.hasNext)
{
System.out.println(cursor.next());
}
client.close();


4、范围查询
import org.bson.Document;
MongoClientURI uri = new MongoClientURI("mongodb://hello:happy@localhost:27001/mldn");
MongoClient client = new MongoClient(uri);//设置连连的参数
MongoDatabase db = client.getDatabase("mldn");//连接数据库
MongoCollection col = db.getCollection("stu");
BasicDBObject cond = new BasicDBObject();
//设置查询的条件
cond.put("id", new BasicDBObject("$gt", 5).append("$lt",10));
MongoCursor<Document> cursor = col.find(cond).iterator();
while(cursor.hasNext)
{
System.out.println(cursor.next());
}
client.close();


5、模糊查询
MongoClientURI uri = new MongoClientURI("mongodb://hello:happy@localhost:27001/mldn");
MongoClient client = new MongoClient(uri);//设置连连的参数
MongoDatabase db = client.getDatabase("mldn");//连接数据库
MongoCollection col = db.getCollection("stu");
Pattern pattern = Pattern.compile("10");//模糊的
BasicDBObject cond = new BasicDBObject();
//设置查询的条件
cond.put("id", new BasicDBObject("$regex", pattern).append("$options", "i"));//不区分大小写的模糊查询
MongoCursor<Document> cursor = col.find(cond).iterator();
while(cursor.hasNext)
{
System.out.println(cursor.next());
}
client.close();


6、分页显示
MongoClientURI uri = new MongoClientURI("mongodb://hello:happy@localhost:27001/mldn");
MongoClient client = new MongoClient(uri);//设置连连的参数
MongoDatabase db = client.getDatabase("mldn");//连接数据库
MongoCollection col = db.getCollection("stu");
Pattern pattern = Pattern.compile("10");//模糊的
BasicDBObject cond = new BasicDBObject();
//设置查询的条件
cond.put("id", new BasicDBObject("$regex", pattern).append("$options", "i"));//不区分大小写的模糊查询
MongoCursor<Document> cursor = col.find(cond).skip(5).limit(10).iterator(); //分页显示
while(cursor.hasNext)
{
System.out.println(cursor.next());
}
client.close();


7、修改数据
MongoClientURI uri = new MongoClientURI("mongodb://hello:happy@localhost:27001/mldn");
MongoClient client = new MongoClient(uri);//设置连连的参数
MongoDatabase db = client.getDatabase("mldn");//连接数据库
MongoCollection col = db.getCollection("stu");
BasicDBObject condA = new BasicDBObject("id",0);//数据查询条件
BasicDBObject condB = new BasicDBObject("$set",new BasicDBObject("name","superMan"));
UpdateResult result = col.updateMany(condA,condB);//修改数据
System.out.println(result);
client.close();


8、删除数据
MongoClientURI uri = new MongoClientURI("mongodb://hello:happy@localhost:27001/mldn");
MongoClient client = new MongoClient(uri);//设置连连的参数
MongoDatabase db = client.getDatabase("mldn");//连接数据库
MongoCollection col = db.getCollection("stu");
BasicDBObject cond = new BasicDBObject("id",0);//数据查询条件
DeleteResult result = col.deleteOne(cond);//删除数据
System.out.println(result.getDeletedCount());
client.close();


9、统计查询
MongoClientURI uri = new MongoClientURI("mongodb://hello:happy@localhost:27001/mldn");
MongoClient client = new MongoClient(uri);//设置连连的参数
MongoDatabase db = client.getDatabase("mldn");//连接数据库
MongoCollection col = db.getCollection("emps");//操作emps集合(表)
BasicDBObject cond = new BasicDBObject("$group",new BasicDBObject("_id","$sex").append("count", new BasicDBObject("sum",1)).append("avg", new BasicDBObject("$avg","$salary")));

List<BasicDBObject> all = new ArrayList<BasicDBObject>();
all.add(cond);//保存条件
MongoCursor<Document> cursor = col.aggregate(all).iterator();
while(cursor.hasNext)
{
Document doc = cursor.next();
System.out.println(doc.getString("_id")+","+doc.getInteger("count"));
}

client.close();