读书人

java 错误

发布时间: 2012-01-06 22:55:18 作者: rapoo

java 异常
我的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("%查询值%")

读书人网 >J2EE开发

热点推荐