英文:
jpa and hibernate compare timestamp to a certain number of day
问题
我想在jpa中的某些天后删除一些行。@Query("DELETE FROM TABLE t WHERE lastChange > :numberOfDays")void delete(@Param("numberOfDays") int numberOfDays);`numberOfDays`可能是10天。虽然`numberOfDays`是一个整数，`lastChange`是一个时间戳（日期时间）。@Entity(name = "Table")public class TableEntity{@Idprivate String id;@UpdateTimestampprivate Timestamp lastChange;}
英文:
I want to delete some rows after some days in jpa.
@Repositorypublic interface JpaTableRepository extends JpaRepository<TableEntity, String>{@Query("DELETE FROM TABLE t WHERE lastChange > :numberOfDays")void delete(@Param("numberOfDays") int numberOfDays);}
numberOfDays may be 10 Days. While numberOfDaysis a int, lastChange is a TimeStamp (datetime).
@Entity(name = "Table")public class TableEntity{@Idprivate String id;@UpdateTimestampprivate Timestamp lastChange;}
答案1
得分: 1
日期操作在JPA中受到限制，但您可以使用Java方法。
服务：
int numberOfDays = 10;LocalDateTime dateTimeMinusTenDays = LocalDateTime.now().minusDays(numberOfDays);repository.delete(dateTimeMinusTenDays);
存储库：
@Query("DELETE FROM TABLE t WHERE lastChange > :startingLimitDateTime")void delete(@Param("startingLimitDateTime") LocalDateTime startingLimitDateTime);
（需要将lastChange的类型更改为java.time.LocalDateTime）
英文:
Date operations is limited in JPA, but you could use Java methods.
Service :
int numberOfDays = 10;LocalDateTime dateTimeMinusTenDays = LocalDateTime.now().minusDays(numberOfDays);repository.delete(dateTimeMinusTenDays);
Repository :
@Query("DELETE FROM TABLE t WHERE lastChange > :startingLimitDateTime")void delete(@Param("startingLimitDateTime") LocalDateTime startingLimitDateTime);
(It requires to change lastChange type to a java.time.LocalDateTime)
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论