SSM整合拓展

SSM整合拓展

查询书籍功能拓展：

开发流程

修改自下而上进行

  <div class="row">
        <div class="col-md-4 column">
<%--            新增书籍--%>
            <a class="btn btn-primary" href="${pageContext.request.contextPath}/book/toAddBook">新增</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">
<%--            查询书籍--%>
    <form class="form-inline" action="${pageContext.request.contextPath}/book/queryBook" method="post" style="float: right">
        <span style="color: red;font-weight: bold">${error}</span>
        <input type="text" name="queryBookName" class="form-control" placeholder="请输入要查询的书籍名称">
        <input type="submit" class="btn btn-primary" value="查询">
    </form>
        </div>

allBook.jsp页面内新增一查询按钮

class="form-inline"

使用前

Bootstrap可视化布局

BookMapper新增

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

BookMapper.xml新增

<select id="queryBookByName" resultType="Books">
    select * from ssmbuild.books where bookName =#{bookName}
</select>

BookService

Books queryBookByName(@Param("bookName") String bookName);

BookServiceImpl新增

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

Controller新增

//查询书籍
@RequestMapping("/queryBook")
public String queryBook(String queryBookName,Model model){
    Books books = bookService.queryBookByName(queryBookName);
    List<Books> list = new ArrayList<Books>();
    list.add(books);
    if (books==null){
        list = bookService.queryAllBook();
        model.addAttribute("error","未查询到书籍");
    }
    model.addAttribute("list",list);
    return "allBook";
}