docker pull mongo:latest

docker run -d --restart=always -p 27017:27017 --name mymongo -v /data/db:/data/db -d mongo

docker exec -it mymongo /bin/bash 

mongo 

> show databases;
admin   0.000GB
config  0.000GB
local   0.000GB

help

use test

show dbs;

db.dropDatabase();

db.getName();

db,stats();

db.version();

db.getMongo();

db.createCollection( "collName");

db.getCollection("user");

> db.User.save({name:'zhangsan','age':21,sex:true})
WriteResult({ "nInserted" : 1 })
> db.User.find()
{ "_id" : ObjectId("6357ca9078e7935942264275"), "name" : "zhangsan", "age" : 21, "sex" : true }

# select * from User where name = 'zhangsan'
> db.User.find({name:"zhangsan"});
{ "_id" : ObjectId("6357ca9078e7935942264275"), "name" : "zhangsan", "age" : 21, "sex" : true }

# select name from User where age = 21
> db.User.find({age:21},{'name':1,'age':1});
{ "_id" : ObjectId("6357ca9078e7935942264275"), "name" : "zhangsan" }

# select * from User order by age
> db.User.find().sort({age:1})

# select * from User skip 2 limit 3
> db.User.find().skip(0).limit(3)

# select * from User where age in (21, 26, 32)
> db.User.find({age:{$in:[21,26,32]}})

# select count(*) from User where age >20
> db.User.find({age:{$gt:20}}).count()

# select * from User where age = 21 or age = 28
> db.User.find({$or:[{age:21}, {age:28}]})

# update Userset age = 100, sex = 0 where name = 'user1'
> db.User.update({name:"zhangsan"}, {$set:{age:100, sex:0}})

> db.User.remove(id)
//移除对应id的行
> db.User.remove({})
//移除所有

>db.article.insert({
    title: 'MongoDB Overview', 
   description: 'MongoDB is no sql database',
   by_user: 'runoob.com',
   url: 'http://www.runoob.com',
   tags: ['mongodb', 'database', 'NoSQL'],
   likes: 100
})
>db.article.insert({
   title: 'NoSQL Overview', 
   description: 'No sql database is very fast',
   by_user: 'runoob.com',
   url: 'http://www.runoob.com',
   tags: ['mongodb', 'database', 'NoSQL'],
   likes: 10
})
>db.article.insert({
   title: 'Neo4j Overview', 
   description: 'Neo4j is no sql database',
   by_user: 'Neo4j',
   url: 'http://www.neo4j.com',
   tags: ['neo4j', 'database', 'NoSQL'],
   likes: 750
})

# select by_user, count(*) from article group by by_user
> db.article.aggregate([{$group : {_id : "$by_user", num_tutorial : {$sum : 1}}}])

{
"result" : [
      {
"_id" : "runoob.com",
"num_tutorial" : 2
      },
      {
"_id" : "Neo4j",
"num_tutorial" : 1
      }
   ],
"ok" : 1
}

>db.User.createIndex({"name":1})

<dependencies>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-data-mongodb</artifactId>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-web</artifactId>
    </dependency>

    <dependency>
        <groupId>org.projectlombok</groupId>
        <artifactId>lombok</artifactId>
    </dependency>

    <dependency>
        <groupId>joda-time</groupId>
        <artifactId>joda-time</artifactId>
        <version>2.10.1</version>
    </dependency>

    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-test</artifactId>
        <scope>test</scope>
        <exclusions>
            <exclusion>
                <groupId>org.junit.vintage</groupId>
                <artifactId>junit-vintage-engine</artifactId>
            </exclusion>
        </exclusions>
    </dependency>
</dependencies>

spring.data.mongodb.uri=mongodb://192.168.91.166:27017/test

@Data
@Document("User")
public class User {

    @Id
    private String id;
    private String name;
    private Integer age;
    private String email;
    private String createDate;
    
}

@SpringBootTest
class MongodbdemoApplicationTests {

    @Autowired
    private MongoTemplate mongoTemplate;

    //添加操作
    @Test
    public void create(){
        User user = new User();
        user.setAge(20);
        user.setName("test");
        user.setEmail("123@qq.com");
        User user1 = mongoTemplate.insert(user);
        System.out.println(user1);
    }

    //查询所有记录
    @Test
    public void findAll(){
        List<User> users = mongoTemplate.findAll(User.class);
        users.forEach(System.out::println);
    }

    //根据id查询
    @Test
    public void findById(){
        User user = mongoTemplate.findById("6357e057d03cc33fab0a7820", User.class);
        System.out.println(user);
    }

    //条件查询
    @Test
    public void findUserList(){
        //name=test age=20
        Query query = new Query(Criteria.where("name").is("test").and("age").is(20));
        List<User> users = mongoTemplate.find(query, User.class);
        users.forEach(System.out::println);
    }

    //模糊查询
    @Test
    public void findLikeUserList(){

        String name = "est";
        String regex = String.format("%s%s%s", "^.*", name, ".*$");
        Pattern pattern = Pattern.compile(regex, Pattern.CASE_INSENSITIVE);
        Query query = new Query(Criteria.where("name").regex(pattern));
        List<User> users = mongoTemplate.find(query, User.class);
        users.forEach(System.out::println);
    }

    //分页查询
    @Test
    public void findPageUserList(){
        int pageNo = 1;
        int pageSize = 3;
        String name = "est";
        //条件构建
        String regex = String.format("%s%s%s", "^.*", name, ".*$");
        Pattern pattern = Pattern.compile(regex, Pattern.CASE_INSENSITIVE);
        Query query = new Query(
                Criteria.where("name").regex(pattern));
        //分页构建
        //查询记录数
        long count = mongoTemplate.count(query, User.class);
        //分页
        List<User> users =
                mongoTemplate.find(query.skip((pageNo - 1) * pageSize).limit(pageSize), User.class);
        System.out.println(count);
        System.out.println(users);
    }

    //修改
    @Test
    public void updateUser(){

        //根据id查询
        User user = mongoTemplate.findById("6357e057d03cc33fab0a7820", User.class);
        //设置修改值
        user.setName("test-1");
        user.setAge(50);
        user.setEmail("0000@qq.com");

        //调用方法实现修改
        Query query = new Query(Criteria.where("_id").is(user.getId()));
        Update update = new Update();
        update.set("name",user.getName());
        update.set("age",user.getAge());
        update.set("email",user.getEmail());
        UpdateResult upsert = mongoTemplate.upsert(query, update, User.class);
        long modifiedCount = upsert.getModifiedCount();
        System.out.println(modifiedCount>0?"修改成功":"修改失败");
    }

    //删除操作
    @Test
    public void deleteUser(){
        Query query = new Query(Criteria.where("_id").is("6357e057d03cc33fab0a7820"));

        DeleteResult result = mongoTemplate.remove(query, User.class);
        long count = result.getDeletedCount();
        System.out.println(count>0?"删除成功":"删除失败");
    }
}

@Repository
public interface UserRepository extends MongoRepository<User,String>{
    
}

@SpringBootTest
public class MongodbdemoApplicationTests1 {

    //注入UserRepository
    @Autowired
    private UserRepository userRepository;

    //添加操作
    @Test
    public void create(){
        User user = new User();
        user.setAge(30);
        user.setName("Marry");
        user.setEmail("12323@qq.com");
        User u = userRepository.save(user);
        System.out.println(u);
    }

    //查询所有记录
    @Test
    public void findAll(){
        List<User> users = userRepository.findAll();
        users.forEach(System.out::println);
    }

    //根据id查询
    @Test
    public void findId(){
        User user = userRepository.findById("6357fb372236b07efb0287cd").get();
        System.out.println(user);
    }

    //条件查询
    @Test
    public void findUserList(){
        //name=marry and age=30
        User user = new User();
        user.setName("Marry");
        user.setAge(30);
        Example<User> userExample = Example.of(user);
        List<User> users = userRepository.findAll(userExample);
        users.forEach(System.out::println);
    }

    //模糊查询
    @Test
    public void findLikeUserList(){

        //设置模糊查询的匹配规则
        ExampleMatcher matching = ExampleMatcher.matching()
                .withStringMatcher(ExampleMatcher.StringMatcher.CONTAINING)
                .withIgnoreCase(true);

        User user = new User();
        user.setAge(30);
        user.setName("m");

        Example<User> userExample = Example.of(user, matching);
        List<User> users = userRepository.findAll(userExample);
        users.forEach(System.out::println);
    }

    //分页查询
    @Test
    public void findPageUserList(){

        //分页
        //设置分页参数，0代表第一页
        Pageable pageable = PageRequest.of(0, 3);
        User user = new User();
        user.setName("Marry");
        user.setAge(30);
        Example<User> userExample = Example.of(user);
        Page<User> users = userRepository.findAll(userExample, pageable);
        users.forEach(System.out::println);
    }

    //修改
    @Test
    public void updateUser(){
        User user = userRepository.findById("6357fb372236b07efb0287cd").get();
        user.setName("Lucy_11");
        user.setEmail("321@qq.com");
        User user1 = userRepository.save(user);
        System.out.println(user1);
    }

    //删除
    @Test
    public void deleteById(){
        userRepository.deleteById("6357fb372236b07efb0287cd");
    }
}