【Java】运用servlet实现在特定区间的价格查询功能

思路：

        大体思路与参考类似        

        参考：https://blog.csdn.net/dannnnnnnnnnnn/article/details/122200580

页面展示

html

        
        
        元
        
        元
        查询
 

Servlet

public void selectByPrice(HttpServletRequest request,HttpServletResponse response) throws Exception{
        //从客户端传入的price1,price2
        Double price1,price2;
        price1 = Double.valueOf(request.getParameter("price1"));
        price2 = Double.valueOf(request.getParameter("price2"));
        try{
            List typeList = bookService.selectBookByPrice(price1,price2);
            request.setAttribute("typeList",typeList);
            //查询成功，跳转页面
            processTemplate("type/type",request,response);
        }catch (Exception e){
            e.printStackTrace();
        }
    }

BookDaoImpl

@Override
    public List selectBookByPrice(Double price1,Double price2) throws Exception {
        String sql = "select book_id bookId,book_name bookName,author,price,sales,stock,img_path imgPath from t_book where price between ? and ?";
        return getBeanList(Book.class,sql,price1,price2);
    }