記錄一種有趣的JPA的關(guān)聯(lián)對(duì)象查詢方式。
代碼如下：
/*
* 這是一個(gè)dto
*/
public class WorkSeries {
private Integer id;
private String workName;
private String seriesName;
public WorkSeries() {
}
public WorkSeries(Integer id, String workName, String seriesName) {
this.id = id;
this.workName = workName;
this.seriesName = seriesName;
}
//get趟脂、set省略
}
/*
* 然后是兩個(gè)實(shí)體
*/
@Entity
public class Series {
@Id
@GeneratedValue
private Integer id;
private String name;
//get名船、set省略
}
@Entity
public class Work {
@Id
@GeneratedValue
private Integer id;
private String name;
//get挽鞠、set省略
}
/*
* 最后一個(gè)JPA查詢
*/
public interface WorkRepository extends JpaRepository<Work, Integer> {
@Query("SELECT new com.miaostar.dto.WorkSeries(work.id,work.name,series.name) FROM Work work,Series series")
List<WorkSeries> findWorkSeries();
}
參考:
