我的SQL报异常:java.sql.SQLException: Parameter index out of range (3 > number of parameters, which is 2).
下面是我的SQL语句:String sql="select * from product where mprice bettwean ? and ? , cname like '%?%' ";请高手帮下忙看看哪里错了!
------解决方案--------------------
select * from product where mprice bettwean ? and ? , cname like '%?%'
like 写法错误
select * from product where mprice bettwean ? and ? , cname like ?
like的值要写成ps.setString("%查询值%")