还是不对呀 Error: 500 Location: /testdir/jsp/search.jsp Internal Servlet Error:org.apache.jasper.JasperException: Unable to compile class for JSP???sun.tools.javac.Main ???? D:\jakarta-tomcat\work\localhost_8080%2Ftestdir\_0002fjsp_0002fsearch_0002ejspsearch_jsp_0.java:76: ??????java.beans.Statement ? java.sql.Statement Statement stmt; ^ 1 ???, 1 ??? at org.apache.jasper.compiler.Compiler.compile(Compiler.java:247) at org.apache.jasper.runtime.JspServlet.loadJSP(JspServlet.java:413) at org.apache.jasper.runtime.JspServlet$JspServletWrapper.loadIfNecessary(JspServlet.java:149) at org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServlet.java:161) at org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java:261) at org.apache.jasper.runtime.JspServlet.service(JspServlet.java:369) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:503) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:559) at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:160) at org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java:338) at java.lang.Thread.run(Unknown Source)
Error: 500 Location: /testdir/jsp/search.jsp Internal Servlet Error:org.apache.jasper.JasperException: Unable to compile class for JSP???sun.tools.javac.Main ???? D:\jakarta-tomcat\work\localhost_8080%2Ftestdir\_0002fjsp_0002fsearch_0002ejspsearch_jsp_0.java:76: ??????java.beans.Statement ? java.sql.Statement Statement stmt= conn.createStatement(); ^ 1 ???, 1 ??? at org.apache.jasper.compiler.Compiler.compile(Compiler.java:247) at org.apache.jasper.runtime.JspServlet.loadJSP(JspServlet.java:413) at org.apache.jasper.runtime.JspServlet$JspServletWrapper.loadIfNecessary(JspServlet.java:149) at org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServlet.java:161) at org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java:261) at org.apache.jasper.runtime.JspServlet.service(JspServlet.java:369) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:503) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:559) at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:160) at org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java:338) at java.lang.Thread.run(Unknown Source)
谢谢 可以是可以了 就是查询结果是这样的: select * from mp3wheresinger='jackson'andname='black or white' [Microsoft][ODBC SQL Server Driver][SQL Server]? 1 ?: '=' ???????? 能解释一下吗
你的sql语句写的有问题吧,怎么都没有空格中间? select * from mp3wheresinger='jackson'andname='black or white' 改为 select * from mp3 where singer='jackson' and name='black or white'
queryMessage= queryMessage+mywhere+"singer='"+singer+"'";
你在 singer后面少了一个 = 号
在查询时数据库会报错
Error: 500
Location: /testdir/jsp/search.jsp
Internal Servlet Error:org.apache.jasper.JasperException: Unable to compile class for JSP???sun.tools.javac.Main ????
D:\jakarta-tomcat\work\localhost_8080%2Ftestdir\_0002fjsp_0002fsearch_0002ejspsearch_jsp_0.java:76: ??????java.beans.Statement ? java.sql.Statement
Statement stmt;
^
1 ???, 1 ??? at org.apache.jasper.compiler.Compiler.compile(Compiler.java:247)
at org.apache.jasper.runtime.JspServlet.loadJSP(JspServlet.java:413)
at org.apache.jasper.runtime.JspServlet$JspServletWrapper.loadIfNecessary(JspServlet.java:149)
at org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServlet.java:161)
at org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java:261)
at org.apache.jasper.runtime.JspServlet.service(JspServlet.java:369)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:503)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:559)
at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:160)
at org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java:338)
at java.lang.Thread.run(Unknown Source)
Location: /testdir/jsp/search.jsp
Internal Servlet Error:org.apache.jasper.JasperException: Unable to compile class for JSP???sun.tools.javac.Main ????
D:\jakarta-tomcat\work\localhost_8080%2Ftestdir\_0002fjsp_0002fsearch_0002ejspsearch_jsp_0.java:76: ??????java.beans.Statement ? java.sql.Statement
Statement stmt= conn.createStatement();
^
1 ???, 1 ??? at org.apache.jasper.compiler.Compiler.compile(Compiler.java:247)
at org.apache.jasper.runtime.JspServlet.loadJSP(JspServlet.java:413)
at org.apache.jasper.runtime.JspServlet$JspServletWrapper.loadIfNecessary(JspServlet.java:149)
at org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServlet.java:161)
at org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java:261)
at org.apache.jasper.runtime.JspServlet.service(JspServlet.java:369)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:503)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:559)
at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:160)
at org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java:338)
at java.lang.Thread.run(Unknown Source)
Statement stmt;
stmt= conn.createStatement();
改成:
java.sql.Statement stmt;
stmt= conn.createStatement();
可以是可以了
就是查询结果是这样的:
select * from mp3wheresinger='jackson'andname='black or white' [Microsoft][ODBC SQL Server Driver][SQL Server]? 1 ?: '=' ????????
能解释一下吗
select * from mp3wheresinger='jackson'andname='black or white'
改为
select * from mp3 where singer='jackson' and name='black or white'