MongoDB常用操作命令

Java API操作增删改查

pom.xml 依赖：

<dependency>
    <groupId>org.mongodb</groupId>
     <artifactId>mongodb-driver</artifactId>
     <version>3.2.2</version>
</dependency>

java代码：

import com.mongodb.MongoClient;
import com.mongodb.MongoCredential;
import com.mongodb.ServerAddress;
import com.mongodb.client.FindIterable;
import com.mongodb.client.MongoCollection;
import com.mongodb.client.MongoDatabase;
import com.mongodb.client.model.Filters;
import org.bson.Document;
import org.bson.conversions.Bson;
import org.bson.types.ObjectId;

import java.util.ArrayList;
import java.util.List;

public class MogodbApp {
    public static void main(String[] args) {
        //设置mongoDB数据库库地址和端口
        ServerAddress serverAddress = new ServerAddress("192.168.206.129",27017);
        List<ServerAddress> addrs = new ArrayList<>();
        addrs.add(serverAddress);
        //设置MongoDB 用户和密码
        MongoCredential credential = MongoCredential
                .createScramSha1Credential("gree","test","gree".toCharArray());
        List<MongoCredential> credentials = new ArrayList<>();
        credentials.add(credential);

        MongoClient mongoClient = new MongoClient(addrs,credentials);
        //System.out.println(mongoClient);

        MongoDatabase testDB = mongoClient.getDatabase("test");
        //System.out.println(testDB);

        //创建学生表
//        testDB.createCollection("students");

        //删表
//        testDB.getCollection("students").drop();

        //插入数据
        MongoCollection<Document> students = testDB.getCollection("students");
//        List<Document> list = new ArrayList<>();
//
//        Document doc1 = new Document();
//        doc1.append("id",1).append("name","zhangsan").append("age",21).append("sex","男");
//        list.add(doc1);
//
//        Document doc2 = new Document();
//        doc2.append("id",1).append("name","lisi").append("age",22).append("sex","女");
//        list.add(doc2);
//
//        Document doc3 = new Document();
//        doc3.append("id",1).append("name","wangwu").append("age",23).append("sex","男");
//        list.add(doc3);
//
//        Document doc4 = new Document();
//        doc4.append("id",1).append("name","zhaoliu").append("age",24).append("sex","女");
//        list.add(doc4);
//
//        students.insertMany(list);

        //遍历查看
//        FindIterable<Document> documents = students.find();
//        for(Document doc:documents){
//            System.out.println(doc.toJson());
//        }
//        System.out.println("success");

        //多条件查询
//        Bson eq = Filters.eq("name","lisi");
//        Bson bson1 = Filters.eq("sex","女");
//        Bson bson3 = Filters.gte("age",19);
//        Bson bson2 = Filters.and(eq,bson1,bson3);
//
//        FindIterable<Document> documents = students.find(bson2);
//        for(Document doc:documents){
//            System.out.println(doc.toJson());
//        }

        //更新
//        Bson id = Filters.eq("name","lisi");
//        Document document = new Document("$set", new Document("age", 34));
//        students.updateMany(id,document);

        //删除
//        ObjectId objectId = new ObjectId("5f8012c6dd4a9a3790a99973");
//        Bson bson = Filters.eq("_id",objectId);
//        students.deleteMany(bson);

        //多条一起删除
        Bson gt = Filters.gte("age",21);
        Bson lt = Filters.lte("age",35);
        Bson and = Filters.and(gt,lt);
        students.deleteMany(and);

    }
}