PreparedStatement 模糊匹配 结果却:Parameter index out of range (1 > number of parameters, which is 0)
来源:互联网 发布:python3书籍推荐 知乎 编辑:程序博客网 时间:2024/06/05 03:30
数据库查询中,我们是这样进行模糊匹配的:
select * from user where 1=1 and username like '%林%' limit 0,20
理所当然的,在java代码中你会这么写:
select * from user where 1=1 and username like '%?%' limit 0,20
ps.setString(1, userCondition.getUsername());
如果真这么写,你就等着扑街吧:Parameter index out of range (1 > number of parameters, which is 0)
这时候怎么破?
select * from user where 1=1 and username like ? limit 0,20
ps.setString(1, "%"+userCondition.getUsername()+"%");
0 0
- PreparedStatement 模糊匹配 结果却: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).] 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).异常
- JDBC基础-连接池(数据源)
- es6笔记6^_^generator
- 10.4.3
- 矩阵特征值
- Deep learning Reading List
- PreparedStatement 模糊匹配 结果却:Parameter index out of range (1 > number of parameters, which is 0)
- python 7-7 如何在环状数据结构中管理内存,标准库中的weakref,创建一种能访问对象但不能增加引用计数的对象
- HttpClient4.5请求时出现Cookie rejected警告的解决方法
- Flash入门基础实践-制作基础的动画效果
- Javascript迭代数组
- Linux下文件/文件夹 创建/拷贝/删除/剪切 小记
- 类和对象
- CF 251D Two Sets
- es6笔记6^_^generator_0