Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException

具体报错：

---

Caused by: 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

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

 

当关键字出现是MySQLSyntaxErrorException,报错地方可以看near '' at line 1，第一反应就是去检查你写的mysql语句或语法有没有写错。

后面我去检查自己的ssm项目,在dao层里，原本我的写法是，id=#（id），改成下面的形式，就不会报错啦！！！

//根据id查询产品
    @Select("select * from product where id=#{id}")
    public Product findById(String id) throws Exception;

以后写代码不要手速太快，，希望能帮到大家！！