springboot整合mongodb增删改查

springboot整合mongodb增删改查

1.导入依赖

<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>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <scope>test</scope>
        </dependency>

配置文件

spring.data.mongodb.host=127.0.0.1
spring.data.mongodb.port=27017
spring.data.mongodb.database=textDatabase

编写User类

//Document指定数据插入到MongoDB数据库里的名字为textCollection的集合中
@Document(collection = "textCollection")
@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {
    private Long id;
    private String password;
    private String name;
    private Integer age;
}

编写UserDao接口

public interface UserDao {
    public void saveUser(User user);    //新增数据

    public void removeUser(Long id);    //删除数据

    public User findUserByName(String name);    //通过名字查找数据

    public int updateUser(User user);           //修改数据
}

编写UserDaoImpl实现类

@Repository
public class UserDaoImpl implements UserDao{
    @Autowired
    private MongoTemplate mongoTemplate;

    @Override
    public void saveUser(User user) {
        mongoTemplate.save(user);
    }

    @Override
    public void removeUser(Long id) {
        Query query = new Query(Criteria.where("id").is(id));//查找其id字段的值与传入参数id相等的数据
        mongoTemplate.remove(query,User.class);
    }

    @Override
    public User findUserByName(String name) {
        Query query = new Query(Criteria.where("name").is(name));
        User user = mongoTemplate.findOne(query,User.class);
        return user;
    }

    @Override
    public int updateUser(User user) {
        Query query = new Query(Criteria.where("id").is(user.getId()));
        Update update = new Update().set("name",user.getName()).set("password",user.getPassword());
        //更新查询返回的结果集的第一条数据
        UpdateResult result = mongoTemplate.updateFirst(query,update,User.class);
        //更新查询到的所有结果集
        //UpdateResult all_result = mongoTemplate.updateMulti(query,update,User.class);
        if(result!= null)
            return (int) result.getModifiedCount();
        else
            return 0;
    }
}

编写CRUD测试

@Test
    public void saveUser(){
        User u = new User();
        u.setId(1L);
        u.setPassword("123456asfa");
        u.setName("xiaoming");
        u.setAge(24);
        userDao.saveUser(u);
    }
    @Test
    public void findUserByName(){
        User u = userDao.findUserByName("xiaoming");
        System.out.println(u);
    }
    @Test
    public void removeUser(){
        userDao.removeUser(2L);
    }

    @Test
    public void updateUser(){
        User u = new User();
        u.setId(1L);
        u.setName("abcedf");
        u.setPassword("qwerttyui");
        int update_num = userDao.updateUser(u);
        System.out.println("update num:"+update_num);
    }