sql="select * from counter where date='"+time+'";
或者sql="select * from counter where date=\'"+time+"\'";
或者sql="select * from counter where date=\'"+time+"\'";
解决方案 »
- 求助大神:类似于淘宝发布商品那种功能
- JSP+ACCESS数据增删改查代码问题?
- 有关门户网站压力测试的问题,请各位专家解答!
- 帮忙看看错在哪 !
- 图片交替显示问题
- 为我的 web os 开发的第一个应用web erp系统预览版,欢迎大家观摩指正!
- jsp可以制作树状菜单吗
- Cannot create JDBC driver of class '' for connect URL 'null'????????????????
- jsp调用Bean出问题
- 求大神帮忙,c3p0连接不了mysql8.0
- java.io.CharConversionException: EOF这个错误是怎么引起的呀?
- 向大家问个关于用jstl的问题
上面漏了一个分号。
sql="select * from counter where date='"+time+'";
还有不知楼主的time是不是只有时间的意思?如果是那样的话,前面的date要转换才行,sqlserver用convert函数,oracle用to_char函数
该成sql="select * from counter where date='"+time+"'";
不行,他报错
javax.servlet.ServletException: Can not issue data manipulation statements with executeQuery().
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.count_jsp._jspService(count_jsp.java:193)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
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)
root cause java.sql.SQLException: Can not issue data manipulation statements with executeQuery().
com.mysql.jdbc.Statement.checkForDml(Statement.java:1429)
com.mysql.jdbc.Statement.executeQuery(Statement.java:1094)
org.apache.jsp.count_jsp._jspService(count_jsp.java:85)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
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)
sql="select * from counter where date='2005-1-2'";这样的形式,你的是这样的吗?
System.out.println(sql)出来并复制到查询分析器里运行一下试试吧先
sql="select * from counter where date='"+time+"'"
sql="select * from counter where to_char(date,'yyyy-mm-dd')='"+time+"'"
sql="select * from counter where CONVERT(DATETIME, '"+time+"',102)";
如果是ACCESS数据库
sql="select * from counter where #'"+time+"'#";
如:
String sql="select * from counter where date=?";
PreparedStatement pre=con.prepareStatement(sql);
pre.setDate(1,time); //time就是那个问号的参数值,这样你就不用去管什么引问的问题了。
ResultSet res=pre.executeQuery();
我的time是String
我的date 是char time="m"+String.valueOf(month)+"d"+String.valueOf(day);
sql="select * from counter where date='"+time+"'";//我想这句有错的
rs=smt.executeQuery(sql);
Oracle应该是:(time是字符串):sql="select * from counter where date=to_date('"+time+"','yyyy-MM-dd')";