java中setstring什么意思
java中setstring什么意思
08-12-11 &匿名提问
请登录后再发表评论!
去设置成String类型吧
请登录后再发表评论!
Java中应该是createPreparedStatement(), 然后setString(),
请登录后再发表评论!一个根据时间范围检索的问题！在pstmt.setString()时，不会写【java吧】_百度贴吧
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&签到排名：今日本吧第个签到，本吧因你更精彩，明天继续来努力！
本吧签到人数：0成为超级会员，使用一键签到本月漏签0次！成为超级会员，赠送8张补签卡连续签到：天&&累计签到：天超级会员单次开通12个月以上，赠送连续签到卡3张
关注：670,449贴子：
一个根据时间范围检索的问题！在pstmt.setString()时，不会写收藏
public List selectdate(Date time1,Date time2) {Reservation r =new Reservation();List &Reservation&list=new ArrayList();con=db.getCon();String sql="select * from table_reservation where date between ? and ?";try {pstmt=con.prepareStatement(sql);pstmt.setDate(1, "?"+KeyWord+"?");pstmt.setDate(2, new java.sql.Date());
rs=pstmt.executeQuery();//数据库查询完成while(rs.next()){Date date1=rs.getDate(1);String begintime=rs.getString(2);String endtime=rs.getString(3);String office=rs.getString(4);String content=rs.getString(5);String partment=rs.getString(6);String name=rs.getString(7);String phone=rs.getString(8);String email=rs.getString(9);String color=rs.getString(10);r.setDate(date1);r.setBegintime(begintime);r.setEndtime(endtime);r.setOffice(office);r.setCotent(content);r.setPartment(partment);r.setName(name);r.setPhone(phone);r.setEmail(email);r.setColor(color);list.add(r);//list添加了新数据System.out.println(r.getColor());}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}pstmt.setDate(1, "?"+KeyWord+"?");pstmt.setDate(2, new java.sql.Date());这里不知道怎么写，而且sql语句也不知道写的对不对
2017java学习来上市公司博为峰学java,入学即签就业协议,不就业不收费,查看java课程!java好学吗?java课程来博为峰学,java工程师就业年薪十几万!
时间范围 可以用between吗，我也不晓得，我都是todate（￥%￥……*……）
登录百度帐号推荐应用本帖子已过去太久远了，不再提供回复功能。下次自动登录
现在的位置:
& 综合 & 正文
Oracle试用PreparedStatement出现java.sql.SQLException: 无效的列索引
sql语句如下：select bu.deptno,count(bu.hiredate) StartMonthCount from userinfo bu,dept d where bu.deptno=d.deptno and bu.hiredate&to_date(‘?’,'yyyy-mm-dd') group by bu.deptno
java程序中调用：pstmt.setString(1, firstDay);
出现如下异常
java.sql.SQLException: 无效的列索引
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)at oracle.jdbc.driver.OraclePreparedStatement.setStringInternal(OraclePreparedStatement.java:5329)at oracle.jdbc.driver.OraclePreparedStatement.setString(OraclePreparedStatement.java:5321)at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:135)at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.setString(DelegatingPreparedStatement.java:135)at com.neusoft.hr.model.dao.impl.ReportDaoImpl.findStartMonthCount(ReportDaoImpl.java:258)at com.neusoft.hr.model.service.ReportService.findMonthReportList(ReportService.java:77)at com.neusoft.hr.controller.ReportAction.monthReport(ReportAction.java:98)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)at java.lang.reflect.Method.invoke(Method.java:597)at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:269)at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:170)at org.apache.mands.servlet.ExecuteAction.execute(ExecuteAction.java:58)at org.apache.mands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)at org.apache.mands.ActionCommandBase.execute(ActionCommandBase.java:51)at mons.chain.impl.ChainBase.execute(ChainBase.java:190)at mons.chain.generic.LookupCommand.execute(LookupCommand.java:304)at mons.chain.impl.ChainBase.execute(ChainBase.java:190)at org.apache.posableRequestProcessor.process(ComposableRequestProcessor.java:283)at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)at com.neusoft.hr.utils.EncodingFilter.doFilter(EncodingFilter.java:29)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:861)at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1584)
at java.lang.Thread.run(Thread.java:619)
经过仔细排查，原来是日期转换的时候出问题了
将select bu.deptno,count(bu.hiredate) StartMonthCount from userinfo bu,dept d where bu.deptno=d.deptno and bu.hiredate&to_date(‘?’,'yyyy-mm-dd') group by bu.deptno
改为select bu.deptno,count(bu.hiredate) StartMonthCount from userinfo bu,dept d where bu.deptno=d.deptno and bu.hiredate&to_date(?,'yyyy-mm-dd') group by bu.deptno
问题随之解决了。
&&&&推荐文章:
【上篇】【下篇】