jeecgboot集成Mongodb

1、引入jar包依赖

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

2、yml配置文件修改

spring:
  data:
    mongodb:
      uri: mongodb://localhost:27017/springboot-db

3、创建实体类

package org.jeecg.modules.mongodb.entity;

import org.springframework.data.annotation.Id;
 
public class Customer {
 
    @Id
    public String id;
 
    public String firstName;
    public String lastName;
 
    public Customer() {}
 
    public Customer(String firstName, String lastName) {
        this.firstName = firstName;
        this.lastName = lastName;
    }
 
    @Override
    public String toString() {
        return String.format(
                "Customer[id=%s, firstName='%s', lastName='%s']",
                id, firstName, lastName);
    }
 
}

4、创建Repository

package org.jeecg.modules.mongodb.dao;
 
import org.jeecg.modules.mongodb.entity.Customer;
import org.springframework.data.mongodb.repository.MongoRepository;
 
import java.util.List;
 
public interface CustomerRepository extends MongoRepository<Customer, String> {
 
     Customer findByFirstName(String firstName);
     List<Customer> findByLastName(String lastName);
 
}

5、测试用例

用两种方式测试mongoDB，分别为MongoRepository和MongoTemplate

package org.jeecg.modules.mongodb;
 
import org.jeecg.common.api.vo.Result;
import org.jeecg.modules.mongodb.dao.CustomerRepository;
import org.jeecg.modules.mongodb.entity.Customer;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.mongodb.core.MongoTemplate;
import org.springframework.web.bind.annotation.*;
 
import java.util.HashMap;
import java.util.Map;
 
 
/**
 * 测试mongodb
 */
@RestController
@RequestMapping("/mongo")
public class MongoController {
 
    @Autowired
    private MongoTemplate mongoTemplate;
    @Autowired
    private CustomerRepository repository;
 
    @GetMapping("/test1")
    public Result<?> TestMongoDb(){
        Map<String,String> map = new HashMap<>();
        map.put("jeecg","mongodb-jeecg");
        mongoTemplate.insert(map, "testMongoDb");
 
        return Result.OK("存入成功");
    }
 
    @GetMapping("/test2")
    public Result<?> TestMongoDb2(){
        repository.deleteAll();
 
        // save a couple of customers
        repository.save(new Customer("Alice", "Smith"));
        repository.save(new Customer("Bob", "Smith"));
 
        // fetch all customers
        System.out.println("Customers found with findAll():");
        System.out.println("-------------------------------");
        for (Customer customer : repository.findAll()) {
            System.out.println(customer);
        }
        System.out.println();
 
        // fetch an individual customer
        System.out.println("Customer found with findByFirstName('Alice'):");
        System.out.println("--------------------------------");
        System.out.println(repository.findByFirstName("Alice"));
 
        System.out.println("Customers found with findByLastName('Smith'):");
        System.out.println("--------------------------------");
        for (Customer customer : repository.findByLastName("Smith")) {
            System.out.println(customer);
        }
 
        return Result.OK("存入成功");
    }
 
}

下面对mongodb进行简要介绍

1、概念说明

mongodb存储的是json文件

mongodb中的表不叫表，叫集合，Collections

集合中的数据不叫数据，叫文档，Documents

2、下载安装

db下载地址：https://www.mongodb.com/try/download/community

compass下载地址：https://www.mongodb.com/try/download/compass

3、数据查询常用语法

db.day_air.find({"mp_id":"13053400000265"});

db.hour_air.find({"data_time":ISODate("2022-02-04T00:00:00Z")})

db.day_air.find({"data_time": {$gte: ISODate("2022-02-03 15:57:17")}},{"update_time":1,"_id":0}).sort({"data_time":-1}).limit(1)



db.day_air.find({"values.avg_value":"1.#S"});

mongodb详细用法详见:https://blog.csdn.net/muguli2008/article/details/80591256