Spring JPA中实体类使用@EmbeddedId注解之后，如何根据主键进行条件查询？

最新推荐文章于 2023-02-21 09:28:13 发布

Keson Z

最新推荐文章于 2023-02-21 09:28:13 发布

阅读量1.6k

点赞数

分类专栏： Java后台文章标签： Spring JPA

本文链接：https://blog.csdn.net/weixin_44009447/article/details/121385769

版权

Java后台专栏收录该内容

42 篇文章

订阅专栏

1.Student实体类如下：

@Builder
@NoArgsConstructor
@AllArgsConstructor
@Data
@Entity
@Table(name = "student", schema = "FOS")
public class Student implements Serializable {

    @EmbeddedId
    private StudentKey id;

    @Column(name = "SEX")
    private String sex;

    @Column(name = "CREATE_TIME")
    private LocalDateTime createTime;

    @Column(name = "CREATE_BY")
    private String createBy;

    @Column(name = "UPDATE_TIME")
    private LocalDateTime updateTime;

    @Column(name = "UPDATE_BY")
    private String updateBy;

}

2.StudentKey主键类如下：

@Builder
@NoArgsConstructor
@AllArgsConstructor
@Data
@Embeddable
public class StudentKey implements Serializable {
    
    @Column(name = "NUMBER")
    private String number;

    @Column(name = "NAME")
    private String name;
    
    @Column(name = "AGE")
    private Integer age;
}

3.根据主键number以及name查找学生信息方法：

public interface StudentRepository extends JpaRepository<Student, StudentKey> {

    //根据number以及name查找学生信息
    List<Student> findByIdNumberAndIdName(String number, String name);
}