尚医通学习笔记 Day10--MongoDB之MongoTemplate的CRUD

MongoTemplate的CRUD

1. 构建实体

package com.zeus.mongodb.demo.entity;

import lombok.Data;
import org.springframework.data.mongodb.core.mapping.Document;

@Data
@Document(“User”)
public class User {

private String id;
private String name;
private String age;
private String email;
private String createDate;

}

2. 配置mongo信息，

spring.data.mongodb.uri=mongodb://192.168.229.129:27017/mongo

3. CRUD具体实现

 package com.zeus.mongodb.demo;

import com.jayway.jsonpath.internal.filter.ValueNode;
import com.mongodb.client.result.DeleteResult;
import com.mongodb.client.result.UpdateResult;
import com.zeus.mongodb.demo.entity.User;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.data.mongodb.core.MongoTemplate;
import org.springframework.data.mongodb.core.query.Criteria;
import org.springframework.data.mongodb.core.query.Query;
import org.springframework.data.mongodb.core.query.Update;
import org.springframework.test.context.TestExecutionListeners;

import java.util.List;
import java.util.regex.Pattern;

@SpringBootTest
class DemoApplicationTests {

   @Autowired
   private MongoTemplate mongoTemplate;

    @Test
    public void  insert(){
        User user = new User();
        user.setAge("12");
        user.setName("niuzai");
        user.setEmail("2131213@qq.com");
        User user1 = mongoTemplate.insert(user);
        System.out.println(user1);

    }

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

    //查询所有
    @Test
    public void findById(){
        User user = mongoTemplate.findById("6094b23e37987c65e6763a1a", User.class);
        System.out.println(user);
    }

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

    }

    //模糊查询
    @Test
    public void findLikeUserList(){
        //构建模糊字段
        String name="niu";
        //构建模糊规则
        String regex= String.format("%s%s%s",".*",name,".*$");
        //使用Pattern构建使用条件
        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);
        System.out.println(users);

    }

    //分页查询
    @Test
    public void findPageUserList(){
       int pageNo =1;
       int pageSize =3;
       String name="niu";
        //构建模糊规则
        String regex= String.format("%s%s%s",".*",name,".*$");
        //使用Pattern构建使用条件
        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(){
        //先查询
        User user = mongoTemplate.findById("6094b23e37987c65e6763a1a", User.class);
        user.setAge("22");
        user.setEmail("213321@qq.com");
        Query query=new Query(Criteria.where("_id").is(user.getId()));
        Update update= new Update();
        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);

    }

    @Test
    //删除
    public void deleteUser(){
        Query query=new Query(Criteria.where("_id").is("6094b23e37987c65e6763a1a"));
        DeleteResult remove =mongoTemplate.remove(query,User.class);
        long deletedCount = remove.getDeletedCount();
        System.out.println(deletedCount);
    }
}