Parameter index out of range (1 > number of parameters, which is 0).] with r
来源:互联网 发布:淘宝商店怎么刷信用? 编辑:程序博客网 时间:2024/05/16 08:43
遇到Parameter index out of range (1 > number of parameters, which is 0)怎么办?
2011年05月12日 星期四 23:45
遇到了Parameter index out of range (1 > number of parameters, which is 0) ,检查了很多遍错误。最后终于发现,原来PreparedStatement的sql中?是不能带有’单引号的。谢天谢地…一个很简单的失误,我折腾了4个钟头,忘大家引以为戒啊…
// 查询指定用户public User_table selOperation(String id) { String sql = "select * from user_table where Id='?' "; User_table user = null; try { PreparedStatement pst = (PreparedStatement) AdoOpen.openConn() .prepareStatement(sql); pst.setString(1, id); ResultSet rs = pst.executeQuery(); if (rs.next()) { user = new User_table(); user.setId(rs.getString(1)); user.setName(rs.getString(2)); user.setPassword(rs.getString(3)); user.setOnline(rs.getInt(4)); user.setQita(rs.getString(5)); } rs.close(); pst.close(); //AdoOpen.CloseConn(); } catch (SQLException e) { e.printStackTrace(); } return user;}java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)at com.mysql.jdbc.PreparedStatement.checkBounds(PreparedStatement.java:3326)at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3310)at com.mysql.jdbc.PreparedStatement.setString(PreparedStatement.java:4146)at ado.User_ADO.selOperation(User_ADO.java:60)at unit.ProssSeverl.rundom(ProssSeverl.java:95)at unit.ProssSeverl.regidit(ProssSeverl.java:71)at unit.ProssSeverl.Dealwith(ProssSeverl.java:43)at unit.ProssSeverl.service(ProssSeverl.java:36)at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)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:128)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:286)at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)at java.lang.Thread.run(Unknown Source)原来:String sql = "select * from user_table where Id='?' ";?不可以加单引号 改为String sql = "select * from user_table where Id=? ";
0 0
- Parameter index out of range (1 > number of parameters, which is 0).] with r
- Parameter index out of range (1 > number of parameters, which is 0)
- Parameter index out of range (1 > number of parameters, which is 0)
- java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
- ibatis Parameter index out of range (1 > number of parameters, which is 0)
- mybatis Parameter index out of range (1 > number of parameters, which is 0)
- Parameter index out of range (1 > number of parameters, which is 0).
- sql异常之Parameter index out of range (1 > number of parameters, which is 0)
- java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0)
- Parameter index out of range (1 > number of parameters,which is 0).
- Parameter index out of range (1 > number of parameters, which is 0)
- Parameter index out of range (1 > number of parameters, which is 0).
- Parameter index out of range (1 > number of parameters, which is 0).
- mybatis错误Parameter index out of range (1 > number of parameters, which is 0)
- Parameter index out of range (1 > number of parameters, which is 0)
- Parameter index out of range (1 > number of parameters, which is 0).
- 关于ibatis的parameter index out of range (1 > number parameters which is 0).异常
- java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1).
- 树莓派2中webiopi项目的适配
- 网络编程--UDP相关
- 面试算法——2.双栈实现队列
- 监听器
- 第六周实践项目4—数制转换
- Parameter index out of range (1 > number of parameters, which is 0).] with r
- Hive 动态分区 & 静态分区
- android以application/json流的方式提交数据
- 异或加密算法之后nsstring成nil
- Linux下获取虚拟地址对应的物理地址的方法
- Java streamtool
- Leetcode #292 Nim Game
- Zookeeper入门:基本概念、5项配置、启动
- 控制UI布局的方式