帶有l(wèi)ike的拼接出錯(cuò)
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 'description like '%''erer''%'' at line 1 怎么拼接的時(shí)候會(huì)出現(xiàn)這個(gè)錯(cuò)呢
2016-07-26
SELECT ID,COMMAND,DESCRIPTION,CONTENT FROM message WHERE 1=1 AND DESCRIPTION LIKE '%' ? '%';
sql.append(" and DESCRIPTION like '%' ? '%'");
正確拼接
2016-09-11
我也是這個(gè)問題 你怎么解決的