"貌似sql语句问题"求助~急
HTTP Status 500 -
--------------------------------------------
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: Unable to compile class for JSP
An error occurred at line: 12 in the jsp file: /up.jsp
Generated servlet error:
C:\Tomcat 5.0\work\Catalina\localhost\caigou\org\apache\jsp\up_jsp.java:89: 未结束的字符串字面值
sql="SELECT month("+t_date+") AS Expr1, SUM("+t_amount+" * "+t_price+") AS Expr2
^
An error occurred at line: 12 in the jsp file: /up.jsp
Generated servlet error:
C:\Tomcat 5.0\work\Catalina\localhost\caigou\org\apache\jsp\up_jsp.java:93: 未结束的字符串字面值
HAVING (SUM("+t_amount+" * "+t_price+") > 100000)";
^
2 错误
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:84)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:332)
org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:412)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:472)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:451)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:439)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:511)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:295)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
[解决办法]
C:\Tomcat 5.0\work\Catalina\localhost\caigou\org\apache\jsp\up_jsp.java:93
這個文件看看，編譯的文件有沒有問題
[解决办法]
sql="SELECT month("+t_date+") AS Expr1, SUM("+t_amount+" * "+t_price+") AS Expr2
这句赋值语句完整的是这样吗，如果是的，它的语法有问题，编译通不过
[解决办法]
语句的问题，是不是换行没有加引号？
[解决办法]
把你写的sql拿出来吧
我的异常网推荐解决方案：The server encountered an internal error () that prevented it from fulfilling this request.,http://www.myexception.cn/java-web/317.html
我的异常网推荐解决方案：org.apache.jasper.JasperException: Unable to compile class,http://www.myexception.cn/j2ee/2308.html
