新增查询功能（SSM整合七）

dao层

1、编写接口代码 

    //根据书名查询书籍
    Books queryBookByName(@Param("bookName")String bookName);

2、sql语句（在mapper.xml文件中）

    <!--根据书名查询书籍sql语句-->
    <select id="queryBookByName" resultType="books">
        select * from ssmbuild.books where bookName = #{bookName};
    </select>

service层

1、编写接口代码和上面dao层一样

    //根据书名查询书籍
    Books queryBookByName(@Param("bookName")String bookName);

 2、编写service实现类

    @Override
    public Books queryBookByName(String bookName) {
        return bookMapper.queryBookByName(bookName);
    }
}

前端代码-有点乱，自己看源码

controller层 

1、编写请求语句

    //查询书籍
    @RequestMapping("/queryBook")
    public String queryBook(String queryBookName,Model model){
        Books books = bookService.queryBookByName(queryBookName);
        List<Books> list = new ArrayList<>();
        list.add(books);
        //如果查询结果为空，则显示全部书籍
        if (books == null){
            list = bookService.queryAllBook();
            model.addAttribute("error","未查到");
        }
        model.addAttribute("list",list);
        return "allBook";
    }