一、Java链接MongoDB
1. 导入mongo驱动包

2. 获取Mongo链接对象
MongoClient mc = new MongoClient("localhost",27017);
3. 关闭链接
mc.close();
二、查看库,查看集合
1. 获取库对象
MongoDatabase db = mc.getDatabase("myschool");
2. 获取库中表的集合
MongoIterable<string> listCollectionNames = db.listCollectionNames();
MongoCursor<string> iterator = listCollectionNames.iterator();
while (iterator.hasNext()) {
System.out.println(iterator.next());
}</string></string>
三、Java对MongoDB增删改查
1. 添加数据
a. 添加一条数据
//创建对象
Student s = new Student();
s.setSid(1);
s.setSname("王俊凯");
s.setBirthday(new Date());
s.setSsex("男");
s.setClassid(2);
//将数据转换为json格式
Gson gson = new GsonBuilder().setDateFormat("yyyy-MM-dd").create();
String json = gson.toJson(s);
//获取集合对象
MongoCollection<document> collection = db.getCollection("student");
//添加一条数据,将json格式转换为document对象
collection.insertOne(Document.parse(json));</document>
b. 添加多条数据
//存入数据
List<document> dlist=new ArrayList<document>();
for(int i=0; i collection = db.getCollection("student");
//添加多条数据
collection.insertMany(dlist);</document></document>
2. 删除数据
a. 删除一条数据
//获取集合对象
MongoCollection<document> collection = db.getCollection("student");
Student s = new Student();
s.setSid(1);
Gson gson = new GsonBuilder().setDateFormat("yyyy-MM-dd").create();
Bson bson = Document.parse(gson.toJson(s));
DeleteResult deleteOne = collection.deleteOne(bson);</document>
b. 删除多条数据
使用 Husky 将 pre-commit、pre-push 和 commit-msg 检查集成到仓库中,以便代理和开发人员在更改离开工作站之前运行相同的本地防护措施。
//获取集合对象
MongoCollection<document> collection = db.getCollection("student");
Student s = new Student();
s.setSname("王源");
Gson gson = new GsonBuilder().setDateFormat("yyyy-MM-dd").create();
Bson bson = Document.parse(gson.toJson(s));
DeleteResult deleteMany = collection.deleteMany(bson);</document>
3. 修改数据
a. 修改一条数据
MongoCollection<document> collection = db.getCollection("student");
//一个条件对象
Bson eq = Filters.eq("sname","易烊千玺");
//要修改的数据
Document doc = new Document();
doc.put("$set", new Document("age",22));
UpdateResult updateone = collection.updateOne(eq, doc);
System.out.println(updateone);</document>
b. 修改多条数据
MongoCollection<document> collection = db.getCollection("student");
//多条件
Bson bson = Filters.and(Filters.gte("age", 20),Filters.lte("age", 40));
//要修改的数据
Document doc = new Document();
doc.put("$set", new Document("sex","男"));
UpdateResult updateMany = collection.updateMany(bson, doc);
System.out.println(updateMany);</document>
4. 查询数据
a. 全查
MongoCollection<document> collection = db.getCollection("student");
FindIterable<document> findAll = collection.find();
MongoCursor<document> iterator = findAll.iterator();
while(iterator.hasNext()){
System.out.println(iterator.next());
}</document></document></document>
b. 带条件查询
MongoCollection<document> collection = db.getCollection("student");
//一个条件对象
Bson eq = Filters.eq("sname","易烊千玺");
FindIterable<document> findOne = collection.find(eq);
MongoCursor<document> iterator = findOne.iterator();
while(iterator.hasNext()){
System.out.println(iterator.next());
}</document></document></document>
c. 模糊查询
MongoCollection<document> collection = db.getCollection("student");
//使用正则表达式进行模糊查找
Bson eq = Filters.regex("sname","易");
FindIterable<document> find = collection.find(eq);
MongoCursor<document> iterator = find.iterator();
while(iterator.hasNext()){
System.out.println(iterator.next());
}</document></document></document>
d. 分页查询
MongoCollection<document> collection = db.getCollection("student");
//分页查询
FindIterable<document> find = collection.find().skip(2).limit(3);
MongoCursor<document> iterator = find.iterator();
while(iterator.hasNext()){
System.out.println(iterator.next());
}</document></document></document>
e. 排序查询
MongoCollection<document> collection = db.getCollection("student");
//排序查询 1升序 -1降序
Bson bson = new Document("sid",1);
FindIterable<document> find = collection.find().sort(bson);
MongoCursor<document> iterator = find.iterator();
while(iterator.hasNext()){
System.out.println(iterator.next());
}</document></document></document>
Java免费学习笔记:立即使用
解锁 Java 大师之旅:从入门到精通的终极指南










