现在有人没啊,帮我看看这句sql错在哪里?
jsp:
String bookName = request.getParameter("bookName").trim();
String author = request.getParameter("author").trim();
String nameSelect = "";
String authorSelect = "";
if (bookName.compareTo("")!=0)nameSelect = "bookName like '%" + bookName + "%'";
if (author.compareTo("")!=0)authorSelect="author like '%" + author + "%'";
tomcat报错:
在关键字'like'附近有语法错误.
有吗?郁闷找了好久了......