带有可选参数的Springboot动态查询

Question

在下面的代码中，我有时会将modifeddate设置为null。此时，它抛出错误为“could not extract resultset；SQL[n/a]；嵌套异常为org.hibernate.exception.sqlgrammarexception：could not extract resultset”

即使modifieddate为空，我如何获取数据。总有一天约会就要来了。这是怎么做的？

null

@Repository
public interface AdminRepository extends JpaRepository<AdminEntity, Long> {

@Query(
     value="SELECT * from admin_entity where status=:adminStatus and modified_tsz>=:modifedDate:", 
    nativeQuery=true)
  List<AdminEntity> getAdmins(String adminStatus, Date modifedDate)
}

Answer 1

试试这个

@Repository
public interface AdminRepository extends JpaRepository<AdminEntity, Long> {

@Query(
     value="SELECT * from admin_entity where status=:adminStatus
           AND  (modified_tsz>=:modifedDate OR :modifedDate is null)", 
    nativeQuery=true)
  List<AdminEntity> getAdmins(String adminStatus, Date modifedDate)
}