springboot 整合 mongodb

环境准备

mongodb 已安装并启动

新建springboot项目

1、pom 引入mongodb 依赖

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

2、application 配置文件更改

# MongoDB数据库
spring.data.mongodb.uri=mongodb://127.0.0.1:27017/testMongoDB

# 设置了密码的MongoDB配置方式
# MongoDB服务器连接地址
#spring.data.mongodb.host=127.0.0.1
# MongoDB服务器连接端口
#spring.data.mongodb.port=27017
# MongoDB的验证数据库
#spring.data.mongodb.authentication-database=admin
# MongoDB数据库用户
#spring.data.mongodb.username=root
# MongoDB数据库密码
#spring.data.mongodb.password=123456
# 带连接的数据库
#spring.data.mongodb.database=testMongoDB

3、MongoDBConfig

去掉保存时的_class 属性

@Configuration
public class MongoDBConfig {
    @Resource
    private MongoDatabaseFactory mongoDatabaseFactory;

    @Bean
    public MappingMongoConverter mappingMongoConverter(MongoMappingContext mongoMappingContext) {
        DefaultDbRefResolver dbRefResolver = new DefaultDbRefResolver(mongoDatabaseFactory);
        MappingMongoConverter converter = new MappingMongoConverter(dbRefResolver, mongoMappingContext);
        // 去除写入mongodb时的_class字段
        converter.setTypeMapper(new DefaultMongoTypeMapper(null));
        return converter;
    }
}

4、demo

Constants 定义存储的集合

public interface Constants {
    public static final String MONGODB_COLLECTION_TEST = "test_data";
}

存储实体类
MongoData

@Document(collection = Constants.MONGODB_COLLECTION_TEST)
@Data  //lombok
public class MongoData {

    @Id
    //查询mongodb返回id序列化
    @JsonSerialize(using = ToStringSerializer.class)
    private ObjectId id;

    private String userName;

    private String describe;

    private Date createTime;

    private Long collectTime;
    
}

controller

@RestController
@RequestMapping("/mongodb")
public class MongoController {

    @Autowired
    private MongoTemplate mongoTemplate;

    private static int PAGE_SIZE_NUM = 5;

    @GetMapping("/insert")
    public String insertMongo(){
        MongoData mongodb = new MongoData();
        mongodb.setUserName("土豆");
        mongodb.setCreateTime(new Date());
        mongodb.setCollectTime(System.currentTimeMillis());
        MongoData result = mongoTemplate.save(mongodb);
        return result.toString();
    }
    @GetMapping("/getOne")
    public String queryMongoOne(){
        MongoData mongo = new MongoData();
        mongo.setUserName("test");
        Query query = new Query(Criteria.where("userName").is(mongo.getUserName()));

        MongoData one = mongoTemplate.findOne(query, MongoData.class);

        return "mongodb get ok";
    }

    @GetMapping("/getAll")
    public String queryMongoAll(){
        Query query = new Query();
        query.addCriteria(new Criteria().andOperator(
//                Criteria.where("vehicleId").is(queryData.getVehicleId()),
                Criteria.where("collectTime").gte(1652932800000L),
                Criteria.where("collectTime").lte(1652954400000L)
        )).with(Sort.by(Sort.Order.asc("collectTime")));

        List<MongoData> mongoList = mongoTemplate.find(query, MongoData.class, Constants.MONGODB_COLLECTION_TEST);

        return "mongodb get all is ok";
    }
    @GetMapping("/getAllByPage")
    public String queryMongoAllByPage(){
        Query vehicleReportQuery = new Query();
        vehicleReportQuery.addCriteria(new Criteria().andOperator(
                Criteria.where("collectTime").gte(1652932800000L),
                Criteria.where("collectTime").lte(1652954400000L)
        )).with(Sort.by(Sort.Order.asc("collectTime")));
        List<MongoData> result = new ArrayList<>();
        long total = this.mongoTemplate.count(vehicleReportQuery, MongoData.class,Constants.MONGODB_COLLECTION_TEST);
        for (int i = 0; i < total / PAGE_SIZE_NUM + 1; i++) {
            int pageIndex = i * PAGE_SIZE_NUM;
            vehicleReportQuery.skip(pageIndex).limit(PAGE_SIZE_NUM);
            List<MongoData> mongoList = mongoTemplate.find(vehicleReportQuery, MongoData.class, Constants.MONGODB_COLLECTION_TEST);
            System.out.println("mongodb 查询第 "+ i+1 +"次 数量 "+ mongoList.size());
            result.addAll(mongoList);
        }

        System.out.println("mongodb 查询数量 "+ result.size());
        return "mongodb get all by page is ok";
    }
}

新增

查询