jdbc在模糊搜索时候报错:Parameter index out of range

来源:互联网 发布:网络的安全机制有哪些 编辑:程序博客网 时间:2024/05/21 16:59

jdbc在模糊搜索时候报错:Parameter index out of range 

源代码如下

String sql = "select g.id,g.goodsname,g.price,g.offset,g.time,g.counts,g.cid  from goods g,(select g1.id, concat(g1.goodsname,c1.cname) words  "+ "from goods g1,category c1) t where words like '%?%' and  t.id = g.id  order by g.id limit ?,? ;";

报错问题如下

 Parameter index out of range (3 > number of parameters, which is 2).
修改如下

String sql = "select g.id,g.goodsname,g.price,g.offset,g.time,g.counts,g.cid  from goods g,(select g1.id, concat(g1.goodsname,c1.cname) words  "+ "from goods g1,category c1) t where words like concat('%',?,'%') and  t.id = g.id  order by g.id limit ?,? ;";



阅读全文
0 0
原创粉丝点击