日本一区二区在线不卡,在线免费一区二区,精品欧美一区二区在线看片

近期項目中需要關聯幾張表再把字段轉出來，在這里記錄以下，我感覺網上寫的都不太規范和清晰。

				?

									@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);

									}