控制臺報的SQL語法錯誤，很奇怪
自己在DEBUG模式下運行，程序執(zhí)行到MaintainService下的deleteBatch下的dao.deleteBatch(idList)就報錯
下面是報錯的部分信息：
<==????? Total: 3
==>? Preparing: delete form MESSAGE where ID in( ? , ? )
==> Parameters: 2(Integer), 3(Integer)
二月 07, 2017 3:38:37 下午 org.apache.catalina.core.StandardWrapperValve invoke
嚴(yán)重: Servlet.service() for servlet [com.sgu.tj.servlet.DeleteBatch] in context with path [/MyBatis] threw exception
org.apache.ibatis.exceptions.PersistenceException:
### Error updating database.? Cause: 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 'MESSAGE where ID in(? 2 , 3 )' at line 1
### The error may involve Message.deleteBatch-Inline
### The error occurred while setting parameters
### SQL: delete form MESSAGE where ID in(? ? , ? )
### Cause: 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 'MESSAGE where ID in(? 2 , 3 )' at line 1
2017-02-07
找到問題所在了，原因是sql語句寫錯了應(yīng)該是from 寫成了 form
總結(jié)3點想分享給一起努力小伙伴：1.學(xué)會使用DEBUG，這是個好東西
2.心細(xì)
3.遇到一時解決不了的問題，學(xué)會像別人求助或者放一下，讓自己休息一下再來看，效率會高很多。