Spring data JPA-映射对象从本地查询返回到POJO

Question

我有一个场景，我想把从JPA存储库中的本机查询中提取的数据映射到自定义对象。

我的存储库代码如下：

@Query(nativeQuery = true,name = "TopCouponOffer")
List<TopCouponOffer> findTodayTopOffer(@Param("date") String date, @Param("time") String time);

我的自定义类代码如下：

@NamedNativeQuery(
    name = "TopCouponOffer",
    query =
           "SELECT c.id,c.code\n" +
                   " FROM COUPON c \n" +
                   "JOIN CLICK cl\n" +
                   "ON cl.coupon_id = c.id\n" +
                   "JOIN COUPONS_STATUS cs\n" +
                   "ON cs.id= c.coupons_status_id\n" +
                   "JOIN COUPONS_OFFER_TYPE ct\n" +
                   " ON ct.id= c.coupons_offer_types_id\n" +
                   "WHERE\n" +
                   " c.ongoing_offer = 1 AND\n" +
                   " c.coupons_status_id != 4 AND\n" +
                   "IF(:date < c.end_date,\n" +
                   "             IF(:date < c.start_date,\n" +
                   "                 0,\n" +
                   "                 IF(:date = c.start_date,\n" +
                   "                     IF(:time < c.start_time,\n" +
                   "                         0,\n" +
                   "                         1),\n" +
                   "                     1)),\n" +
                   "             IF(:date = c.end_date || :date = c.start_date, \n" +
                   "                IF(:time > c.end_time || :time < c.start_time,\n" +
                   "                         0,\n" +
                   "                         1), 0)) = 1 ORDER BY cl.count DESC LIMIT 2",
    resultSetMapping = "TopCouponOffer",
    resultClass = TopCouponOffer.class
)
@SqlResultSetMapping(name="TopCouponOffer",
        classes = {
        @ConstructorResult(targetClass = TopCouponOffer.class,columns = {
                @ColumnResult(name = "id"),
                @ColumnResult(name = "code")
        })
        }
)
public class TopCouponOffer {
    Integer id;
    String code;
    public TopCouponOffer(Integer id, String code){
       this.id=id;
       this.code=code;
   }
}

但是我在运行应用程序时遇到了以下错误

原因：org。springframework。数据地图。PropertyReferenceException:找不到类型优惠券的属性FindTodayPoffer！

我应该移动名称查询和sql结果映射到我的实体类吗？问题是我不想污染我的实体类，有什么方法可以通过向我的实体类添加更多代码来实现这一点吗？

Answer 1

我认为存储库中的functionname应该重命名为findByDateAndTime。