You have an error in your SQL syntax; check the manual that corresponds to your

         在项目开发过程中Eclipse出现了这样一个错误，遇到过几次了，感觉这个问题比较常见，所以贴出来与大家分享下

 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 'desc, statusstr, statusdesc, purpose, createdate) values ('201308300001', '?°?è?' at line 1
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
	at com.mysql.jdbc.Util.getInstance(Util.java:381)

 

    解决方案： 检查Mysql数据库中是否使用了关键字，我报这错误是应为使用了 desc关键字，后来改了个字段名,马上好了,看来命名不严谨啊，哈哈~~