看了评论才解决了问题,"jdbc:mysql://localhost:3306/micro_message?characterEncoding=utf8"
,"select ID,COMMAND,DESCRIPTION,CONTENT from message where 1=1 ","and DESCRIPTION like '%' ? '%' "最后一句模糊查询我也是在'%'后加了空格后才不报错,这种错误真的很伤
,"select ID,COMMAND,DESCRIPTION,CONTENT from message where 1=1 ","and DESCRIPTION like '%' ? '%' "最后一句模糊查询我也是在'%'后加了空格后才不报错,这种错误真的很伤
最新回答 / 董五
我的也是,拼接的SQL语句结果是 SELECT idmessage,COMMAND,DESCRIPTION,CONTENT from MESSAGE where 1 = 1 and COMMAND='??'
2016-10-25
最新回答 / 模棱0
req.setCharacterEncoding("utf-8"); try { String command = req.getParameter("command"); String description = req.getParameter("description"); req.setAttribute("command", command); req.setAttribute("description", description); Class.forName("com....
2016-10-24
老师使用的缓存思想挺好的!但是建议使用字符串拼接符:
sql.append(" and description like '%' '"+description+"' '%' ");
sql.append(" and command='"+command+"' ");
sql.append(" and description like '%' '"+description+"' '%' ");
sql.append(" and command='"+command+"' ");