JDBC实现模糊查询

下面为dao层内容,视线模糊查询,

1
2
3
4
5
public List<paper> Select_paper(String theme,String author,String coming) {
        String sql = "select * from paper where title like '%"+theme+"%' and author like '%"+author+"%'";
        List<paper> query = template.query(sql, new BeanPropertyRowMapper<>(paper.class));
        return query;
    }

  

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("utf-8");
        String theme = request.getParameter("theme");
        String author = request.getParameter("author");
        String coming = request.getParameter("coming");
/*        System.out.println(theme);
        System.out.println(author);
        System.out.println(coming);*/
 
        paperdao dao=new paperdao();
        List<paper> papers = dao.Select_paper(theme, author, coming);
//        System.out.println(papers);
        request.setAttribute("papers",papers);
        request.getRequestDispatcher("index.jsp").forward(request,response);
    }
posted @ 2022-04-26 07:59  一个小弱鸡  阅读(128)  评论(0)    收藏  举报