sql拼接问题

Question

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 '_utf8'???€??€???????' '%'' at line 1

Answer 1

sql.append(" and DESCRIPTION like '%' + ? + '%'");改成这样试试?

Answer 2

你sql的语句是什么？就是对应这句的sql  sql.append(" and DESCRIPTION like '%' ? '%'");

Answer 3

.................能否把你的sql语句代码贴出来啊，就这个句'_utf8'???€??€???????' '%''周围的代码截图上来

Answer 4

if (command!=null&&!"".equals(command.trim())) {                sql.append(" and COMMAND=? ");                paramerList.add(command);            }准确的查询没问题，模糊查询就报错 if (description!=null&&!"".equals(description.trim())) {            sql.append(" and DESCRIPTION like '%' ? '%'");                paramerList.add(description);            }老师帮忙看一下，哪里出错了