com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 ” at line 1
我的这种错误,是sql语句有错误,
SELECT * FROM agenda WHERE 1=1 and aId={aId}
仔细看就能看出
正确的语句为:
SELECT * FROM agenda WHERE 1=1 and aId=#{aId}