展示近10天的数据JAVA遇到的bug

需求是展示近10天的数据

// 修改后的代码
String AAA_QUERY = "select u FROM AAAAA u where (to_days(now()) 
- to_days(from_unixtime(u.mEndTime/1000,\'%Y-%m-%d\'))) <= 9";
@Query(value = AAA_QUERY)
    Iterable<AAAAA> getData();

// 注：AAA是引入该@table（'tb名称'）的类名
// u是该table的别名

遇到问题：
1、antlr.NoViableAltException: unexpected token: )
因为我输入的Sql语句少了 括号

String AAA_QUERY = "select u FROM AAAAA u where 缺(   to_days(now()) 
- to_days(from_unixtime(u.mEndTime/1000,\'%Y-%m-%d\'))   缺) <= 9";

2、# [org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: * near line 1]

String AAA_QUERY = "select * (应该修改为 u ，这是 table的别名) 
   FROM AAAAA u where (to_days(now()) - to_days(from_unixtime(u.mEndTime/1000,\'%Y-%m-%d\'))) <= 9";

参考：https://stackoverflow.com/questions/40927513/querysyntaxexception-unexpected-token?rq=1
3、Caused by: java.lang.IllegalArgumentException: org.hibernate.QueryException: unexpected char: '"' [s
Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: Unable to locate appropriate constructor on class

// 该问题是因为，sql语句中 有"，我改为'即可
from_unixtime(u.mEndTime/1000,\'%Y-%m-%d\')

4、Error creating bean with name 'AAAAAA': Unsatisfied dependency expressed through field 'BBBBBBB'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'BBBBBBB': Invocation of init method failed

解决完上面sql语句的bug之后，该问题解决，