jasp报错_JSP报错！ 说是日期语法错误！！急！

org.apache.jasper.JasperException:AnexceptionoccurredprocessingJSPpage/deng/light_update.jspatline5148:

org.apache.jasper.JasperException: An exception occurred processing JSP page /deng/light_update.jsp at line 51

48:

49: String time=request.getParameter("time");

50: String sql="select * from shoppinginfo where customer='"+session.getAttribute("loginname")+"' and time=#"+time+"#";

51: ResultSet rs=stmt.executeQuery(sql);

52: while (rs.next()){

53: %>

54:

javax.servlet.ServletException: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] 日期的语法错误 在查询表达式 'customer='zz' and time=#null#' 中。

org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:911)

org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:840)

org.apache.jsp.deng.light_005fupdate_jsp._jspService(light_005fupdate_jsp.java:201)

org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)

javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)

org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)

org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)

javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

展开