ssm整合——设置搜索书籍功能

allbook.jsp

<div class="row">
            <div class="col-md-4 column">
                <%--toaddbooks--%>
                <a class="btn btn-primary" href="${pageContext.request.contextPath}/book/addBook">新增书籍</a>
                <a class="btn btn-primary" href="${pageContext.request.contextPath}/book/allBook">显示全部书籍</a>
            </div>
                <div class="col-md-4 column"></div>
                <div class="col-md-4 column">
                <%--toaddbooks--%>
               <%--查询书籍--%>
                <form class="form-inline" action="${pageContext.request.contextPath}/book/selectBookName" method="post" style="float: right">
                    <span style="color: red;font-weight:bold">${error}</span>
                    <input type="text" name="selectBooks" class="form-control" placeholder="请输入书籍查询名称">
                    <input type="submit" value="查询" class="btn btn-primary">

                </form>
            </div>
        </div>
    </div>

BookMapper.java

//查询某一本书籍的名字
List<Books> selectBookName(@Param("bookname") String bookname);

BookMapper.xml

<select id="selectBookName" resultType="com.zy.pojo.Books">
    select * from books where bookname=#{bookname}
</select >

BookService.java

//查询某一本书籍的名字
List<Books> selectBookName(String bookname);

BookServiceImpl.java

@Override
public List<Books> selectBookName(String bookname) {
    return bookMapper.selectBookName(bookname);
}

BookController.java

//查询书籍
@RequestMapping("/selectBookName")
public String selectBooks(String selectBooks,Model model){
    List<Books> list = bookService.selectBookName(selectBooks);
    //设置如果没有查询到该书籍，点击显示全部书籍
    if (list==null){
        list=bookService.allbook();
        model.addAttribute("error", "未查到");
    }
    model.addAttribute("list", list);
    return "allBook";
}

显示结果：