连接两个表并在thymeleaf中显示检索到的信息

Question

我使用Spring MVC和JPA。我想通过thymeleaf HTML连接两个类（表）中的数据，并显示两个表中的数据。

@Entity
@Table(name = "package_aud")
public class PackageAudited {

@Column(name="id")
private Integer id;

@Id
@GeneratedValue
@Column(name="rev")
private Integer rev;

@Column(name="revtype")
private Integer revtype;

@OneToOne
@JoinColumn(name = "rev", nullable=true)
private RevisionInfo info;

... more attributes and getters/setters

@Entity
@RevisionEntity(RevListener.class)
@Table(name = "revinfo")
public class RevisionInfo {

@Id
@RevisionNumber
@GeneratedValue
@Column(name="rev")
private Integer rev;

@RevisionTimestamp
@Column(name="revtstmp")
private Date revtstmp;

@Column(name="revuser")
private String revuser;

... getters/setters

public interface PackageAuditedRepository extends 
CrudRepository<PackageAudited, Long> {

@Query("SELECT p, c FROM PackageAudited p join p.info c WHERE p.id =:id AND p.rev = c.rev")
List<PackageAudited> findById(@Param("id") Integer id);

@PostMapping("/listSelectedPackage")
public String selectedPackage(@RequestParam("packageId") Integer packageId, Model model) {
        Iterable<PackageAudited> specificPackageHistory = this.packageAuditedRepository.findById(packageId);
        model.addAttribute("specificPackageHistory", specificPackageHistory);
        return "/package/listSelectedPackage";
}

<table class ="center">
<thead>
    <tr>
        ...
    </tr>
</thead>
<tbody>
    <tr th:each="package : ${specificPackageHistory}">
        <td th:text="${package.rev}"> </td>
        <td th:text="${package.id}"> </td>
        <td th:text="${package.revuser}"></td>
        <td th:text="${package.revtstmp}"></td>
    </tr>
</tbody>
</table>

Answer 1

仅将PackageAudit作为查询结果：

@Query("SELECT p FROM PackageAudited p join fetch p.info c WHERE p.id =:id")
List<PackageAudited> findById(@Param("id") Integer id);

然后更改页面上的引用方式：

<tr th:each="package : ${specificPackageHistory}">
    <td th:text="${package.info.rev}"> </td>
    <td th:text="${package.id}"> </td>
    <td th:text="${package.info.revuser}"></td>
    <td th:text="${package.info.revtstmp}"></td>
</tr>