如何使用LocalDate查询LocalDateTime? [英] How to query LocalDateTime with LocalDate?
问题描述
我有一个包含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 使用LocalDate查询数据库中的MyClass?
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);
// ...
}
这篇关于如何使用LocalDate查询LocalDateTime?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!