JavaEE8案例模糊查询

JSP 中 JQuery方法

<script type="text/javascript">
   $(function(){
    $("#word").keyup(function(){
     $.get(
      "${pageContext.request.contextPath}/FindProductsByword",
      {
       "word":$("#word").val()
      },
      function(data){
       $("#list").empty();
       for(var i=0;i<data.length;i++){
        if(i>7){
         break;
        }
        $("#list").append("<div>"+data[i].pname+"</div>");
       }
       $("#list").css("display","block");
      },
      "json"
     );
    });
    $("#list").blur(function(){
     console.log(1);
     $("#list").css("display","none");
    });
   });
  </script>

Servlet中doGet方法

public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  SearchProduct spi=new SearchProductImpl();
  String word =request.getParameter("word");
  List<Product> products = spi.SearchProductByWord(word);
//  System.out.println(products)；
  Object json = JSON.toJSON(products);
  String json1=String.valueOf(json);
//  System.out.println(json);
  response.setContentType("text/plain;charset=utf-8");
  response.getWriter().write(json1);
 }

数据库中模糊查询

public List<Product> SelectProductLike(String str) {
//  System.out.println(str);
  //select * from product where pname like %?%
  String sql="select * from product where pname like ?";
  try {
   List<Product> list = qr.query(sql, new BeanListHandler<Product>(Product.class),"%"+str+"%");
   //System.out.println(list);
   return list;
  } catch (SQLException e) {
   e.printStackTrace();
  }
  return null;
 }