@Entity
@Data
@Table
@ToString
public class Product {

    @Id
    private Long id;

    private String name;

    @OneToMany(mappedBy = "pid", cascade = CascadeType.ALL)
    private List<Attribute> attributes;

}

@Entity
@Data
@Table
@ToString
public class Attribute {

    @Id
    private Long id;

    private Long pid;

    private String info;

    private String date;

}

public class DemoController{

    @RequestMapping(value = "/hibernate")
    public String hibernate() {
        Session session = entityManager.unwrap(SessionImpl.class);
        Criteria criteria = session.createCriteria(Product.class, "pp");
        criteria.setFetchMode("attributes", FetchMode.JOIN);
        criteria.createAlias("attributes", "aat", JoinType.LEFT_OUTER_JOIN);

        criteria.add(Restrictions.ge("aat.date", "2022-01-05"));
        List<Product> list = criteria.list();
        for (Product product : list) {
            System.out.println(product);
        }
        return "ok";
    }

    @RequestMapping(value = "/hibernate2")
    public String hibernate2() {
        Session session = entityManager.unwrap(SessionImpl.class);

        DetachedCriteria criteria = DetachedCriteria.forClass(Product.class);
        //join 会联合成一条sql; 不添加， 那么会形成2条sql
        //criteria.setFetchMode("attributes", FetchMode.JOIN);

        criteria.add(Restrictions.eq("name", "600570"));
        DetachedCriteria dateCriteria = DetachedCriteria.forClass(Attribute.class).add(Restrictions.ge("date", "2022-01-05"));
        DetachedCriteria pidProjection = dateCriteria.setProjection(Projections.property("pid"));
        criteria.add(Subqueries.propertyIn("id", pidProjection));
        Criteria executableCriteria = criteria.getExecutableCriteria(session);
        List<Product> list = executableCriteria.list();
        for (Product product : list) {
            System.out.println(product);
        }
        return "ok";
    }
    
}