当前位置: 代码迷 >> Java Web开发 >> "貌似sql语句有关问题"求助~
  详细解决方案

"貌似sql语句有关问题"求助~

热度:864   发布时间:2016-04-17 12:32:40.0
"貌似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.daimami.com/search?q=317
代码迷推荐解决方案:org.apache.jasper.JasperException: Unable to compile class,http://www.daimami.com/search?q=2308
  相关解决方案