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

思路：

        大体思路与参考类似        

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

页面展示

 

html

<form action="bookManager" method="post">
        <input type="hidden" name="method" value="selectByPrice"/>
        <input type="text" placeholder="10" name = "price1" id="price1">
        <span>元</span>
        <input type="text" placeholder="20" name = "price2" id="price2">
        <span>元</span>
        <button type="search" >查询</button>
 </form>

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<Book> typeList = bookService.selectBookByPrice(price1,price2);
            request.setAttribute("typeList",typeList);
            //查询成功，跳转页面
            processTemplate("type/type",request,response);
        }catch (Exception e){
            e.printStackTrace();
        }
    }

BookDaoImpl

@Override
    public List<Book> 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);
    }