springboot整合mongodb实现三表联查

一、数据准备：

三张表（user、orders、product）

一个用户有多个订单，一个订单对应一个商品

user表：

orders表：

product表：

二、实体类

@Data
@Accessors(chain = true)
@Document(collection = "user")
public class User {
    @MongoId
    private String id;
    private String name;
    private int age;
    @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
    private Date birthday;
}


@Data
@Accessors(chain = true)
@Document(collection = "orders")
public class Orders {
    private String userId;
    private String productId;
    private int quantity;
}


@Data
@Accessors(chain = true)//允许链式创建对象
@Document(collection = "product")
public class Product {
    @MongoId
    private String id;
    private String name;
    private double price;
}

三、初始化数据

    public void insert() {
        createCollection(MongoCollection.COLL_USER);
        User u1 = new User().setId("01").setName("alex").setAge(18).setBirthday(new Date());
        User u2 = new User().setId("02").setName("bobi").setAge(19).setBirthday(new Date());