java - 在 java spring boot 中使用 Mysql 函数

Question

我的存储库中的自定义查询有点问题:

@Query("select v from Visit v where YEARWEEK('date') = YEARWEEK(curdate())")

在 YEARWEEK('date') 左括号之前显示错误:

<expression>, <operator>, AND, GROUP, HAVING, IS, OR or ORDER expected, got '('

Answer 1

你有两个选择:

对于 HQL，您需要以下内容:

@Query("select * from Visit v where YEARWEEK('v.date') = YEARWEEK(curdate())")

你也可以有本地查询，在这种情况下你需要遵循(不是 Spring 应用程序的最佳方式，但可以用于某些情况)

@Query(value = "select * from Visit where YEARWEEK('date') = YEARWEEK(curdate())", nativeQuery = true)