out.println(book+"<br>");
ResultSet rs=stat.executeQuery("select * from Mytable WHERE NAME in('"+book+"','课本') order by TIME desc");
这两条语句,上面那个out.println是为了验证book是不是能够输出一个词而已,可以去掉的,验证了是正确的,但下面那条语句总是报错,是不是不能够这么写呢???麻烦各位高手解答一下,谢谢了
下面是错误提示
org.apache.jasper.JasperException: Unable to compile class for JSP:
An error occurred at line: 72 in the jsp file: /aaa2.jsp
book cannot be resolved
69:
70:
71:
72: ResultSet rs=stat.executeQuery("select * from Mytable WHERE NAME in('"+book+"','课本') order by TIME desc");
73:
74:
75:
没看出问题。。。
先试试
ResultSet rs=stat.executeQuery("select * from Mytable WHERE NAME in('"+"xxxx"+"','课本') order by TIME desc");
或者你尝试把sql语句打印出来试试。。你的book是什么类型