占位符？ 語法問題
StringBuilder sql = new StringBuilder("select ID,COMMAND,DESCRIPTION,CONTENT from message where 1=1");
List<String> paramList = new ArrayList<String>();
if(command != null && !"".equals(command.trim())){
?sql.append(" and COMMAND=?");
?paramList.add(command); }?
?報錯：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 '? '%'' at line 1?
寫這個的時候報語法錯誤，請問要怎么改呢
2016-03-05
占位符沒賦值
ps.setString(i + 1, paramList.get(i));