mac下安装MongoDb

MongoDb初体验

背景：在看了网上N篇教程之后，发现了各种不靠谱，于是开始踏上踩坑Mongo之路。

1. 安装MongoDb3.6 和 Mongod

1.安装
curl -O https://fastdl.mongodb.org/osx/mongodb-osx-ssl-x86_64-3.6.2.tgz

2.解压
/opt/soft/mongo/

3.环境变量
vi ~/.bash_profile

export MONGO_PATH=/opt/soft/mongo/mongodb-osx-x86_64-3.6.2
export PATH=$PATH:$MONGO_PATH/bin

source ~/.bash_profile

4.添加Mongo数据库db

mkdir /opt/soft/mongo/mongodb-osx-x86_64-3.6.2/data/
mkdir /opt/soft/mongo/mongodb-osx-x86_64-3.6.2/data/db
chmod -R 777 /opt/soft/mongo/

5.添加Mongo配置文件

mkdir /opt/soft/mongo/mongodb-osx-x86_64-3.6.2/etc
cd etc && touch mongod.conf

#mongodb config file
dbpath=/opt/soft/mongo/mongodb-osx-x86_64-3.6.2/data/db
logpath=/opt/soft/mongo/mongodb-osx-x86_64-3.6.2/logs/mongodb/mongod.log
logappend = true
bind_ip = 127.0.0.1
journal=true
port = 27017
# fork允许后端子进程启动，终端可以随便关
fork = true
# 安全权限，可以先以非授权模式启动Mongod，添加完用户db.addUser('root','pwd') ，再开启auth = true 后，db.auth('root','pwd')，带密码登陆
auth = true

6.添加log文件

mkdir /opt/soft/mongo/mongodb-osx-x86_64-3.6.2/logs
mkdir /opt/soft/mongo/mongodb-osx-x86_64-3.6.2/logs/mongodb/
touch mongod.log

2. 起飞

1.启动

mongod --config /opt/soft/mongo/mongodb-osx-x86_64-3.6.2/etc/mongod.conf

2.访问数据库

mongo3.x 之后就没有web控制台了，不要网上搜了，各种帖子都是老掉牙的，建议下载一个mongo客户端，作为操作

https://download.studio3t.com/studio-3t/mac/5.7.3/Studio-3T.dmg

也可以手动再开终端，使用 mongo 命令连接上来，show db 等命令手动增删改查数据库。

9.命令

* 1.终端连接 `mongo`
* 2.查看库 `show dbs`
* 3.创建DB `use demoDb` 使用demoDb（无则创建）
* 4.创建表 `db.democollection.insert({name:"jackMa",age:18})` 自动创建表，并插入一条Json
* 5.查看表 `show collections`
* 6.主键 Every document stored in MongoDB must have an "_id" key, and you can have other keys as many as your wish.Mongo会自动插入一列叫 "_id",可以自己在程序里处理这个字段，插入到Mongo中，达到联合主键的目的，Mongo本身不支持联合主键
* 7.查询 `db.democollection.find({}).limit(1000);`
* 8.js查询 
	```
	let mongodb = require("mongodb");
	let client = mongodb.MongoClient;
	let url = "mongodb://host:port/msginfo";
	
	client.connect(url, function (err, db) {
    
    let collection = db.collection("msg_phone");
    
    let query = {};
    let limit = 1000;
    
    let cursor = collection.find(query).limit(limit);
    
    cursor.forEach(
        function(doc) {
            console.log(doc["_id"]);
        },
        function(err) {
            db.close();
        }
    ); 
    });
	```

3.Demo

Pom


<dependency>
	<groupId>org.mongodb</groupId>
	<artifactId>mongo-java-driver</artifactId>
	<version>3.2.0</version>
</dependency>

Test

MongoDb.java

package com.demo.util;

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

import com.mongodb.MongoClient;
import com.mongodb.client.FindIterable;
import com.mongodb.client.MongoCollection;
import com.mongodb.client.MongoCursor;
import com.mongodb.client.MongoDatabase;
import com.mongodb.client.result.UpdateResult;
import org.bson.Document;
import org.bson.conversions.Bson;

/**
 * @author luoyu.lzy
 * @Title: MongoDb.java
 * @Package com.demo.util
 * @Description:
 * @date 2018/1/17.
 */
public class MongoDb {

    private static MongoCollection<Document> collection;

    /**
     * 链接数据库
     *
     * @param databaseName
     *            数据库名称
     * @param collectionName
     *            集合名称
     * @param hostName
     *            主机名
     * @param port
     *            端口号
     */
    public static void connect(String databaseName, String collectionName,
        String hostName, int port) {
        @SuppressWarnings("resource")
        MongoClient client = new MongoClient(hostName, port);
        MongoDatabase db = client.getDatabase(databaseName);
        collection = db.getCollection(collectionName);
        System.out.println(collection);
    }

    /**
     * 插入一个文档
     *
     * @param document
     *            文档
     */
    public static void insert(Document document) {
        collection.insertOne(document);
    }

    /**
     * 查询所有文档
     *
     * @return 所有文档集合
     */
    public static List<Document> findAll() {
        List<Document> results = new ArrayList<Document>();
        FindIterable<Document> iterables = collection.find();
        MongoCursor<Document> cursor = iterables.iterator();
        while (cursor.hasNext()) {
            results.add(cursor.next());
        }

        return results;
    }

    /**
     * 根据条件查询
     *
     * @param filter
     *            查询条件 //注意Bson的几个实现类，BasicDBObject, BsonDocument,
     *            BsonDocumentWrapper, CommandResult, Document, RawBsonDocument
     * @return 返回集合列表
     */
    public static List<Document> findBy(Bson filter) {
        List<Document> results = new ArrayList<Document>();
        FindIterable<Document> iterables = collection.find(filter);
        MongoCursor<Document> cursor = iterables.iterator();
        while (cursor.hasNext()) {
            results.add(cursor.next());
        }

        return results;
    }

    /**
     * 更新查询到的第一个
     *
     * @param filter
     *            查询条件
     * @param update
     *            更新文档
     * @return 更新结果
     */
    public static UpdateResult updateOne(Bson filter, Bson update) {
        UpdateResult result = collection.updateOne(filter, update);

        return result;
    }

    /**
     * 更新查询到的所有的文档
     *
     * @param filter
     *            查询条件
     * @param update
     *            更新文档
     * @return 更新结果
     */
    public static UpdateResult updateMany(Bson filter, Bson update) {
        UpdateResult result = collection.updateMany(filter, update);

        return result;
    }

    /**
     * 更新一个文档, 结果是replacement是新文档，老文档完全被替换
     *
     * @param filter
     *            查询条件
     * @param replacement
     *            跟新文档
     */
    public static void replace(Bson filter, Document replacement) {
        collection.replaceOne(filter, replacement);
    }

    /**
     * 根据条件删除一个文档
     *
     * @param filter
     *            查询条件
     */
    public static void deleteOne(Bson filter) {
        collection.deleteOne(filter);
    }

    /**
     * 根据条件删除多个文档
     *
     * @param filter
     *            查询条件
     */
    public static void deleteMany(Bson filter) {
        collection.deleteMany(filter);
    }
}

MongoTest.java

package com.demo.util;

import java.util.List;

import com.mongodb.client.result.UpdateResult;
import org.bson.Document;
import org.junit.Before;
import org.junit.Test;

/**
 * @author luoyu.lzy
 * @Title: MongoTest.java
 * @Package com.demo.util
 * @Description:
 * @date 2018/1/17.
 */
public class MongoTest {
    @Before
    public void before() {
        MongoDb.connect("dbName", "collectionName", "127.0.0.1", 27017);
    }

    @Test
    public void testInsert() {
        Document document = new Document();
        document.append("name", "wang").append("gender", "female");
        MongoDb.insert(document);
    }

    @Test
    public void testFindAll() {
        List<Document> results = MongoDb.findAll();
        for (Document doc : results) {
            System.out.println(doc.toJson());
        }
    }

    @Test
    public void testFindBy() {
        Document filter = new Document();
        filter.append("name", "li si");
        List<Document> results = MongoDb.findBy(filter);
        for (Document doc : results) {
            System.out.println(doc.toJson());
        }
    }

    @Test
    public void testUpdateOne() {
        Document filter = new Document();
        filter.append("gender", "male");

        //注意update文档里要包含"$set"字段
        Document update = new Document();
        update.append("$set", new Document("gender", "female"));
        UpdateResult result = MongoDb.updateOne(filter, update);
        System.out.println("matched count = " + result.getMatchedCount());
    }

    @Test
    public void testUpdateMany() {
        Document filter = new Document();
        filter.append("gender", "female");

        //注意update文档里要包含"$set"字段
        Document update = new Document();
        update.append("$set", new Document("gender", "male"));
        UpdateResult result = MongoDb.updateMany(filter, update);
        System.out.println("matched count = " + result.getMatchedCount());
    }

    @Test
    public void testReplace() {
        Document filter = new Document();
        filter.append("name", "zhang");

        //注意：更新文档时，不需要使用"$set"
        Document replacement = new Document();
        replacement.append("value", 123);
        MongoDb.replace(filter, replacement);
    }

    @Test
    public void testDeleteOne() {
        Document filter = new Document();
        filter.append("name", "li");
        MongoDb.deleteOne(filter);
    }

    @Test
    public void testDeleteMany() {
        Document filter = new Document();
        filter.append("gender", "male");
        MongoDb.deleteMany(filter);
    }
}

posted @ 2018-01-17 14:41 _落雨阅读(2233) 评论(0) 编辑收藏举报

刷新页面返回顶部

落雨

见贤思齐，见不贤常思自省

mac下安装MongoDb

MongoDb初体验

1. 安装MongoDb3.6 和 Mongod

2. 起飞

3.Demo

公告