问题描述
我有一个包含 java.time.LocalDateTime 类型属性的类.
I've got a class which contains an atttribute of java.time.LocalDateTime type.
public class MyClass{ // ... private LocalDateTime fecha; // ... }
我正在使用 Spring Data 存储库.我想要完成的是根据日期查询实体:
I'm using Spring Data repositories. What I want to accomplish is to query entities according to a date:
@Service public interface IRepository extends CrudRepository<MyClass, UUID> { // ... public void deleteByFecha(LocalDate fecha); // ... }
但这不起作用,因为抛出了异常:
But this does not work, as an exception is thrown:
org.springframework.dao.InvalidDataAccessApiUsageException: 参数值 [2016-10-05] 与预期类型不匹配 [java.time.LocalDateTime (n/a)];
org.springframework.dao.InvalidDataAccessApiUsageException: Parameter value [2016-10-05] did not match expected type [java.time.LocalDateTime (n/a)];
所以问题是如何通过 fecha 查询数据库中的 MyClass 但使用 LocalDate?
So the question is how can I query MyClass in database by fecha but with a LocalDate?
编辑万一有人遇到同样的问题,我想出了一个解决方案:修改存储库的方法,使其如下所示:
EDIT Just in case somebody faces the same issue, I've come up with one solution: modify the Repository's method so that it looks as follows:
import org.springframework.transaction.annotation.Transactional; import org.springframework.data.jpa.repository.Modifying; import org.springframework.data.jpa.repository.Query; // ... @Service public interface IRepository extends CrudRepository<MyClass, UUID> { @Transactional @Modifying @Query("DELETE FROM MyClass mtc WHERE YEAR(mtc.fecha)=?1 AND MONTH(mtc.fecha)=?2 AND DAY(mtc.fecha)=?3") public void deleteByFecha(Integer year, Integer month, Integer day); }
推荐答案
试试这个(未测试):
public interface IRepository extends CrudRepository<MyClass, UUID> { // ... default void delByFecha(LocalDate fecha) { deleteByFechaBetween(fecha.atStartOfDay(), fecha.plusDays(1).atStartOfDay()); } void deleteByFechaBetween(LocalDateTime from, LocalDateTime to); // ... }