查詢不出來數(shù)據(jù)
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 'COMMAND='查看'' at line 1 查詢出錯哪里有問題呢
3 回答
舉報
0/150
提交
取消
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 'COMMAND='查看'' at line 1 查詢出錯哪里有問題呢
舉報
2017-09-26
拼接沒有空格
2017-09-16
你下載源碼了嗎？
2017-09-16
應(yīng)該是Message.xml的select標(biāo)簽中間select語句最后沒加where 1=1
正確的sql語句是select ID,COMMAND,DESCRIPTION,CONTENT from MESSAGE where 1=1 and COMMAND=? 。
沒加where 1=1的話拼出來的sql語句是select ID,COMMAND,DESCRIPTION,CONTENT from MESSAGE? and COMMAND=?
所以會有SQL語法錯誤