spring data jpa 多表关联查询sql

最新推荐文章于 2024-08-06 00:51:08 发布

白桦栎

最新推荐文章于 2024-08-06 00:51:08 发布

阅读量359

点赞数

分类专栏： sql

本文链接：https://blog.csdn.net/weixin_43126564/article/details/116208071

版权

本文介绍了如何在Spring Data JPA中使用Specification进行多表关联查询，通过Entity关系映射实现复杂SQL操作，提升数据访问效率。

摘要由CSDN通过智能技术生成

entity

@Entity
@Getter
@Setter
@Table(name="v_participant_overview")
public class ParticipantView extends MappingEntity implements Serializable {
    private static final long serialVersionUID = 276431614574466988L;

    @Id
    private Long id;

    @Column(name = "participant_identifier")
    private String participantId;

    @OneToMany(fetch = FetchType.LAZY)
    @JoinColumn(name="participant_id", referencedColumnName = "id", insertable = false, updatable = false)
    private List<PartRoleEntity> roleList;
 }

@Entity
@Getter
@Setter
@Table(name="tb_part_role")
public class PartRoleEntity extends MappingEntity implements Serializable {
    private static final long serialVersionUID = -40757516353908703L;

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    &