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

kdfy810k  于 2024-01-06  发布在  Spring
关注(0)|答案(1)|浏览(190)

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

  1. @Entity
  2. @Table(name="EMP")
  3. public class Employee{
  4. @Id
  5. @Column(name="EmpId",length = 2, nullable = false)
  6. @GeneratedValue(strategy = GenerationType.IDENTITY)
  7. private Long EmpId;
  8. @Column(name="EmpName", nullable = false)
  9. private Long EmpName;
  10. @Column(name="EmpSalary", nullable = false)
  11. private Long EmpSalary;
  12. @Column(name="EmpPf", nullable = true)
  13. private Long EmpPf;
  14. /*also have getter setter*/
  15. }

个字符
我的疑问是

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


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

mpbci0fu

mpbci0fu1#

你可以用@SecondaryTable功能:来写

  1. @Entity
  2. @Table(name="EMP")
  3. @SecondaryTable(name = "EMPPF", pkJoinColumns = @PrimaryKeyJoinColumn(name = "EmpId"))
  4. public class Employee{
  5. @Id
  6. @Column(name="EmpId",length = 2, nullable = false)
  7. @GeneratedValue(strategy = GenerationType.IDENTITY)
  8. private Long EmpId;
  9. @Column(name="EmpName", nullable = false)
  10. private Long EmpName;
  11. @Column(name="EmpSalary", nullable = false)
  12. private Long EmpSalary;
  13. @Column(name="EmpPfInfo", table = "EMPPF")
  14. private Long EmpPf;
  15. /*also have getter setter*/
  16. }

字符串

展开查看全部

相关问题