Error querying database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘}’
原因分析:
可能是sql语句有误,导致问题的原因可能出现在’}’ 附近。
将
SELECT COUNT(1) FROM ucenter_member WHERE DATE(gmt_create) = {day}
修改为:
SELECT COUNT(1) FROM ucenter_member WHERE DATE(gmt_create) = #{day}
即可解决问题