String sql = "select * from products where PRICE between" + Price1+ "and" + Price2;
rs = stm.executeQuery(sql);
if(rs.next()){
price = rs.getFloat("PRICE");
}
为什么不能查询出来呢? 为什么会在这里if(rs.next())报错? 我该如何实现?请给出个例子,谢谢了!!!
rs = stm.executeQuery(sql);
if(rs.next()){
price = rs.getFloat("PRICE");
}
为什么不能查询出来呢? 为什么会在这里if(rs.next())报错? 我该如何实现?请给出个例子,谢谢了!!!
org.apache.jasper.JasperException: An exception occurred processing JSP page /checkPRICE.jsp at line 3330: String sql = "select * from products where PRICE between" + Price1
31: + "and" + Price2;
32: rs = db.executeQuery(sql);
33: if(rs.next()){
34: id = rs.getLong("PRODUCT_ID");
35: product_name = rs.getString("PRODUCT_NAME");
36: price = rs.getFloat("PRICE");
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:505)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:416)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
String sql = "select * from products where PRICE between " + Price1+ " and " + Price2; between 后的空格。
and 前后的空格
2、看看你PRICE 的类型,
"select * from products where PRICE >=" + Price1+ " and PRICE <=" + Price2;
看看