MongoDB增删改查

MongoDB使用UserRepository简单测试增删改查

@SpringBootTest
public class MongoRepositoryTest {

    @Autowired
    private UserRepository userRepository;

    //添加
    @Test
    public void testSave(){
        User user = new User();
        user.setAge(20);
        user.setName("test1");
        user.setEmail("33432420@qq.com");
        User save = userRepository.save(user);
        System.out.println(user);
    }


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

    //id查询
    @Test
    public void testfindById(){
        User user = userRepository.findById("609cbc07c80e7a79d311b9b7").get();
        System.out.println(user);
    }

    //条件查询
    @Test
    public void testFindByCondition(){
        User user = new User();
        //user.setName("张三");
        user.setAge(20);
        Example<User> userExample = Example.of(user);
        List<User> userList = userRepository.findAll(userExample);
        System.out.println(userList);
    }

    //模糊查询
    @Test
    public void testLikeFind(){
        User user = new User();
        user.setName("t");
        //创建匹配器，即如何使用查询条件
        ExampleMatcher matcher = ExampleMatcher.matching()                   //构建对象
                .withStringMatcher(ExampleMatcher.StringMatcher.CONTAINING); //改变默认字符串匹配方式：模糊查询
        Example<User> userExample = Example.of(user, matcher);
        List<User> userList = userRepository.findAll(userExample);
        System.out.println(userList);
    }

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

        PageRequest pageable = PageRequest.of(0, 3);
        ExampleMatcher matcher = ExampleMatcher.matching()
                .withStringMatcher(ExampleMatcher.StringMatcher.CONTAINING)
                .withIgnoreCase(true);
        User user = new User();
        //user.setName("三");
        Example<User> pageExample = Example.of(user, matcher);
        Page<User> userPage = userRepository.findAll(pageExample, pageable);
        System.out.println(userPage.getContent());

    }

    //分页查询
    @Test
    public void findUsersPage() {
        Sort sort = Sort.by(Sort.Direction.DESC, "age");
        //0为第一页
        Pageable pageable = PageRequest.of(0, 10, sort);
        //创建匹配器，即如何使用查询条件
        ExampleMatcher matcher = ExampleMatcher.matching() //构建对象
                .withStringMatcher(ExampleMatcher.StringMatcher.CONTAINING) //改变默认字符串匹配方式：模糊查询
                .withIgnoreCase(true); //改变默认大小写忽略方式：忽略大小写
        User user = new User();
        user.setName("三");
        Example<User> userExample = Example.of(user, matcher);
        //创建实例
        Example<User> example = Example.of(user, matcher);
        Page<User> pages = userRepository.findAll(example, pageable);
        System.out.println(pages.getContent());
    }


    //修改
    @Test
    public void testUpdate(){
        User user = userRepository.findById("609cbc07c80e7a79d311b9b7").get();
        user.setName("李四");

        User user1 = userRepository.save(user);
        System.out.println(user1);
    }

    //删除
    @Test
    public void testDeleteById(){
        userRepository.deleteById("609cc0d5a6379538547c532e");
    }

}