造成原因java.sql.SQLException: Parameter index out of range (3 > number of parameters, which is 0).
来源:互联网 发布:社交软件使用调查 编辑:程序博客网 时间:2024/06/05 07:53
今天写代码遇到了
java.sql.SQLException: Parameter index out of range (3 > number of parameters, which is 0).
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:2796)
at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:2827)
at com.mysql.jdbc.PreparedStatement.setInt(PreparedStatement.java:2778)
at com.li.dao.StuDao.update(StuDao.java:53)
at com.li.dao.StuDao.main(StuDao.java:98)
是SQL语句错了,找了半天没有头绪,后来发现原来是
String sql = "update stu set username='?',password='?' where userid='?'";
改成 String sql = "update stu set username=?,password=? where userid=?"; 把?前后的''去掉就可以了。
我想好多人遇到这样的错误,都是这个原因吧。
- 造成原因java.sql.SQLException: Parameter index out of range (3 > number of parameters, which is 0).
- java.sql.SQLException: 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)
- java.sql.SQLException: Parameter index out of range (3 > number of parameters, which is 2).
- java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1).
- java.sql.SQLException Parameter index out of range (9 > number of parameters, which is 8)
- BIRT出现java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0)的问题
- Caused by: java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0
- Caused by: java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0
- Caused by: java.sql.SQLException: Parameter index out of range (3 > number of parameters, which is 2
- Caused by: java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1
- 解决ava.sql.SQLException: 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
- Mybatis java.sql.SQLException: Parameter index of 2 is out of range (1, 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).] with r
- zf缓存cache
- POJ 2008 优先队列 好题 数形结合
- 为数据结构添加setProperty和getProperty
- C++的可移植性和跨平台开发[1]--编译器
- Windows XP下MinGW的安装与配置
- 造成原因java.sql.SQLException: Parameter index out of range (3 > number of parameters, which is 0).
- 实战:没有找到 AUTOBACKUP
- Java网络编程从入门到精通(29):服务端Socket的选项
- C++的可移植性和跨平台开发[2]--语法
- 生成直线的Bresenham算法
- 获取JAVA系统的一些常用参数
- 《Java数据结构和算法》第二版 Robert lafore 编程作业 第六章
- C++的可移植性和跨平台开发[3]--异常处理
- Linux下使用samba服务器实现与Windows的目录文件共享