亚洲精品高清视频,亚洲精品日韩在线,在线观看中文字幕

Spring Data Jpa實現(xiàn)自定義repository轉(zhuǎn)DTO

2020-08-05 12:22哎喲媽耶 Java教程

這篇文章主要介紹了Spring Data Jpa實現(xiàn)自定義repository轉(zhuǎn)DTO,文中通過示例代碼介紹的非常詳細(xì)，對大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價值,需要的朋友可以參考下

近期項目中需要關(guān)聯(lián) 幾張表再把字段轉(zhuǎn)出來，在這里記錄以下，我感覺網(wǎng)上寫的都不太規(guī)范和清晰。

				?

									@Entity

									@SqlResultSetMapping(

									    name="TestMapping",

									    entities = {

									        @EntityResult(

									            entityClass = com.xxx.xx.data.model.TestEntity.class,

									            fields = {

									                @FieldResult(name="id",column="id"),

									                @FieldResult(name="localTime",column="time"),

									                @FieldResult(name="maximumAppointment",column="maxAppointment"),

									            }

									        )

									    }

									)

									@NamedNativeQuery(name="getTestQuery",

									    query="select tableC.id as id,tableB.time,tableC.maximumAppointment as maxAppointment from tableB " +

									        "               inner join tableA on tableA.id = tableB.tableAId " +

									        "               inner join tableC on tableB.id = tableC.tableBId " +

									        "               inner join custom on custom.id = tableA.customId " +

									        "where " +

									        "  tableA.locationId = :locationId" +

									        "  and custom.id = :customId" +

									        "  and tableB.deleted = false ", resultSetMapping="TestMapping")

									@Data

									public class TestEntity {

									  @Id

									  private String id;

									  private LocalTime localTime;

									  private Integer maximumAppointment;

									}

需要聲明接口：

				?

									@Repository

									public interface TestEntityRepository extends JpaRepository<TestEntity,String> {

									  @Query(name="getTestQuery")

									  List<TestEntity> getTestQuery(String locationId, String customId);

									}