JPA没有自带的接口只可以用Query注入sql语句来实现
格式:
select * from 表名 where TO_DAYS(字段名) = TO_DAYS(NOW()),nativeQuery = true(加上这个,意为采用原生sql语句)
上代码:
//找出当天订单采用sql语句实现
@Query(value = "select * from order_master where TO_DAYS(pay_date) = TO_DAYS(NOW())",nativeQuery = true)
List<OrderMaster> findAllByPayDate();
//查找七天内的数据
@Query(value = "select * from order_master where DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= date(pay_date)",nativeQuery = true)
List<OrderMaster> findAllByPayDateWeek();
//查找30天内的数据
@Query(value = "select * from order_master where DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= date(pay_date)",nativeQuery = true)
List<OrderMaster> findAllByPayDateMonth();
注:此为mysql数据库的SQL语句写法,不同数据库sql语句写法不尽相同