your MySQL server version for the right syntax to use near 'COMMAND='??''
照著視頻拔下來的代碼，怎么就提示這里錯了呢
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);
}
if(description!=null && !"".equals(description.trim())){
sql.append("and DESCRIPTION like '%' ? '%'");
paramList.add(description);
}
PreparedStatement statement = conn.prepareStatement(sql.toString());
2016-01-18
buffer.append(" and description like '%'||?||'%'");用這個形式。
2016-01-15
我自己知道了，少了個空格sql.append(" and COMMAND=?");