jsp的错,请问这里怎么错了:where rec_id='"+recId+"'and att_code='"+ATT_CODE+"';

Question

org.apache.jasper.JasperException: Unable to compile class for JSPAn error occurred between lines: 48 and 52 in the jsp file: /detail_info.jspGenerated servlet error:
C:\Program Files\Apache Tomcat 4.0\work\localhost\new\detail_0005finfo$jsp.java:199: String not terminated at end of line.
                sql="select id,att_code,pro_b,pro_a,content,oper_id,(to_char(stor_date,'YYYY')||'年'||to_char(stor_date,'MM')||'月'||to_char(stor_date,'DD')||'日') as stor_date from storage_table where rec_id='"+recId+"'and att_code='"+ATT_CODE+"';
                                                                                                                                                                                                                                                  ^
1 error at org.apache.jasper.compiler.Compiler.compile(Compiler.java:285)
at org.apache.jasper.servlet.JspServlet.loadJSP(JspServlet.java:552)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.loadIfNecessary(JspServlet.java:177)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:189)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:382)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:474)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

Answer 1

字符串recId，ATT_CODE没有定义，再仔细检查

Answer 2

1.你檢查recId和ATT_CODE是不是為null.方法;將sql執行語句//掉.然後將sql語句out.println()出來.
2.檢查你的connection是不是已經關掉了.或者曾經不正常了.你是不是用的sql server.如果是,你可能在前一個頁面的connection出現異常,但你有沒有關掉.所以在這個頁面會出現這種錯誤.如果還沒有解決.你可以留言給我.

Answer 3

String not terminated at end of line.
字符串未结束! sql="select id,att_code,pro_b,pro_a,content,oper_id,(to_char(stor_date,'YYYY')||'年'||to_char(stor_date,'MM')||'月'||to_char(stor_date,'DD')||'日') as stor_date from storage_table where rec_id='"+recId+"'and att_code='"+ATT_CODE+"'";