Parameter index out of range (1 > number of parameters, which is 0).
来源:互联网 发布:星际争霸 for mac 编辑:程序博客网 时间:2024/05/16 08:11
publicint delSysUser(SysUser sysUser) {
// 添加用户的SQL语句
String sql = "deletefrom table sys_user where id = ‘?’";
// 获取SQL连接
Connection conn = dbUtils.getConn();
PreparedStatement pstm = null;
try {
// 添加字段值 下标从1开始
pstm = conn.prepareStatement(sql);
pstm.setLong(1, sysUser.getId());// 添加ID
// 执行数据库操作
pstm.executeUpdate();
return 0;
} catch (Exception e) {
throw new RuntimeException("SysUserDao-delSysUsererror", e);
} finally {
// 操作完成释放数据库连接
dbUtils.releaseAll(conn, pstm, null);
}
}
报错信息提示sql语句出错,定位在第一行,具体信息是没有找到参数
String sql = "deletefrom table sys_user where id = ?";
Sql语句中?不能加单引号
0 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
- 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).
- Android内存优化
- 51nod oj 1420 数袋鼠好有趣【贪心】
- Java IO系列(五):读写对象ObjectOutputStream和ObjectInputStream
- AlertDialog 错误
- 剑指Offer_35_数组中的逆序对
- Parameter index out of range (1 > number of parameters, which is 0).
- hdu4771 Stealing Harry Potter’s Precious(状态压缩+bfs)
- 交换机相关总结
- 《数据结构与算法》学习笔记13 单链表和双端链表
- hadoop2.X 伪分布安装
- java.net.BindException: Address already in use: JVM_Bind
- 关于性能优化的总结
- Android Studio ADB 环境变量配置
- Linux下添加任务计划,计划内容以sh文件表示