Spring Boot 如何使用内部连接查询处理列get

kdfy810k 于 5个月前发布在 Spring

关注(0)|答案(1)|浏览(76)

我想在同一个实体类中使用内部连接处理从另一个表中获取的列
我的实体类

@Entity
@Table(name="EMP")
public class Employee{
    @Id
    @Column(name="EmpId",length = 2, nullable = false)
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long EmpId;

    @Column(name="EmpName", nullable = false)
    private Long EmpName;

    @Column(name="EmpSalary", nullable = false)
    private Long EmpSalary;
    
    @Column(name="EmpPf", nullable = true)
    private Long EmpPf;

    /*also have getter setter*/
}

个字符
我的疑问是

select e.name,e.salary,ep.EmpPfInfo as EmpPf from EMP e inner join EMPPF ep on e.EmpId = ep.EmpId

型
如何在Employee实体类中MapEmpPf列，以便在“emp”表上运行简单查询时不会出现任何错误？

spring-boot

来源：https://stackoverflow.com/questions/77678468/how-to-handle-columns-get-using-inner-join-query

1条答案

按热度按时间

mpbci0fu1#

你可以用@SecondaryTable功能：来写

@Entity
@Table(name="EMP")
@SecondaryTable(name = "EMPPF", pkJoinColumns = @PrimaryKeyJoinColumn(name = "EmpId"))
public class Employee{
    @Id
    @Column(name="EmpId",length = 2, nullable = false)
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long EmpId;

    @Column(name="EmpName", nullable = false)
    private Long EmpName;

    @Column(name="EmpSalary", nullable = false)
    private Long EmpSalary;
    
    @Column(name="EmpPfInfo", table = "EMPPF")
    private Long EmpPf;

    /*also have getter setter*/
}

字符串

赞(0）回复(0）举报 5个月前

我来回答

Spring Boot 如何使用内部连接查询处理列get

1条答案

相关问题

热门标签

最新问答