哦对了,补充一下
如果把
rs=produce.executeQuery("select * from produce where
sub_time>'res_begin'");
改为
rs=produce.executeQuery("select * from produce where
sub_time>'2002-05-30'");
就一点问题都没有,但我需要它是可变的
如果把
rs=produce.executeQuery("select * from produce where
sub_time>'res_begin'");
改为
rs=produce.executeQuery("select * from produce where
sub_time>'2002-05-30'");
就一点问题都没有,但我需要它是可变的
解决方案 »
- org.apache.jasper.JasperException: Unable to compile class for JSP
- onSubmit
- sql 读取 image 类型数据丢失
- 连接ACCESS 用getRow() 得到返回结果为 0 怎么回事?
- 关于rich:dataList
- 请问,有人用过echo2吗?怎么在界面里做个链接,弹出一个IE窗口连接到另外一个网站上?
- 求教一个关于权限设计的问题
- <FORM ENCTYPE="multipart/form-data"中ENCTYPE="multipart/form-data"是什么意思?
- 如何获取到jsp中一张表单中多条记录
- 谁有分页的JavaBean程序,共享一下,谢谢啦?!
- linux下没有图形窗口如何在servlet中绘制图象?
- 有关forward的疑问?
sub_time>'res_begin'");
改为:
rs=produce.executeQuery("select * from produce where
sub_time>'"+res_begin+"'");你把变量res_begin放到""里面,就变成字符串的一部分了。
还是同样的错误
Error: 500
Location: /shichang/summoney_2.jsp
Internal Servlet Error:javax.servlet.ServletException
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:460)
at shichang.summoney_2_3._jspService(summoney_2_3.java:199)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
at javax.servlet.http.HttpServlet.service(HttpServlet.java)
at org.apache.tomcat.facade.ServletHandler.doService(ServletHandler.java:574)
at org.apache.tomcat.core.Handler.invoke(Handler.java:322)
at org.apache.tomcat.core.Handler.service(Handler.java:235)
at org.apache.tomcat.facade.ServletHandler.service(ServletHandler.java:485)
at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:917)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:833)
at org.apache.tomcat.modules.server.Http10Interceptor.processConnection(Http10Interceptor.java:176)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:494)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:516)
at java.lang.Thread.run(Thread.java:536)
Root cause:
java.lang.NullPointerException
at shichang.summoney_2_3._jspService(summoney_2_3.java:139)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
at javax.servlet.http.HttpServlet.service(HttpServlet.java)
at org.apache.tomcat.facade.ServletHandler.doService(ServletHandler.java:574)
at org.apache.tomcat.core.Handler.invoke(Handler.java:322)
at org.apache.tomcat.core.Handler.service(Handler.java:235)
at org.apache.tomcat.facade.ServletHandler.service(ServletHandler.java:485)
at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:917)
at org.apache.tomcat.core.ContextManager.service(ContextManager.java:833)
at org.apache.tomcat.modules.server.Http10Interceptor.processConnection(Http10Interceptor.java:176)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:494)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:516)
at java.lang.Thread.run(Thread.java:536)
String queryStr=select * from produce where
sub_time>'"+res_begin+"'";然后用 out.print(queryStr);把字符串打印出来,然后把它帖到数据库的”查询分析器“运行看看能不能查处数据,如果能,就代表有其他的错误。把数据库访问的语句用 /* */先屏蔽掉,这是我检测错误的方法。
数据库中执行不了
服务器: 消息 295,级别 16,状态 3,行 1
从字符串转换为 smalldatetime 数据类型时发生语法错误。
看来的确不是yyyy-MM-dd格式
那我该怎么办?
如下:String year=request.getParameter("year");
String month=request.getParameter("month");
String day=request.getParameter("day");数据库连接与Statement对象建立部分省略
...String queryStr="select * from 你的表名 where year(时间字段)='"+year+"' and month(时间字段)='"+month+"' and day(时间字段)='"+day_"'";ResultSet rs=executeQuery(queryStr);试试看吧,要结合sql server 提供的日期函数
java.util.Date d = new java.util.Date();
String date = "";
date = "" + (1900 + d.getYear()) + (1 + d.getMonth()) + d.getDate();
rs=produce.executeQuery("select * from produce where sub_time>'date'");就不行了。((rs=produce.executeQuery("select * from produce where sub_time>date");也不行)怎么办?