七、查询全部的书籍
1.BookController
package com.hxl.controller; import com.hxl.pojo.Books; import com.hxl.service.BookService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Qualifier; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.RequestMapping; import java.util.List; @Controller @RequestMapping("/book") public class BookController { //controller调service层 @Autowired @Qualifier("BookServiceImpl") private BookService bookService; //查询全部的书籍，并返回到一个书籍展示页面 @RequestMapping("/allBook") public String list(Model model){ List<Books> list = bookService.queryAllBook(); model.addAttribute("list", list); return "allBook"; } }
2.编写首页index.jsp
<%-- Created by IntelliJ IDEA. User: Administrator Date: 2021/11/8 Time: 16:13 To change this template use File | Settings | File Templates. --%> <%@ page contentType="text/html;charset=UTF-8" language="java" %> <html> <head> <title>$Title$</title> <style type="text/css"> a { text-decoration: none; color: black; font-size: 18px; } h3 { width: 180px; height: 38px; margin: 100px auto; text-align: center; line-height: 38px; background: deepskyblue; border-radius: 4px; } </style> </head> <body> <h3> <a href="${pageContext.request.contextPath}/book/allBook">进入书籍展示页面</a> </h3> </body> </html>
3.书籍列表allBook.jsp
<!--c标签引入,记得引入jstl的jar包和standard的jar包--> <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%> <%@ page contentType="text/html;charset=UTF-8" language="java" %> <html> <head> <title>书籍展示</title> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <!-- 引入 Bootstrap cdn--> <link href="https://cdn.bootcss.com/bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet"> </head> <body> <h1>书籍展示</h1> </body> <div class="container"> <%--清除浮动--%> <div class="row clearfix"> <div class="col-md-12 column"> <div class="page-header"> <h1> <small>书籍列表 —— 显示所有书籍</small> </h1> </div> </div> </div> <div class="row"> <div class="col-md-4 column"> <a class="btn btn-primary" href="${pageContext.request.contextPath}/book/toAddBook">新增书籍</a> </div> <div class="col-md-4 column"> <%--查询书籍--%> <form action="${pageContext.request.contextPath}/book/queryBook" method="post" style="float:right" class="form-inline"> <input type="text" name="queryBookName" class="form-control" placeholder="请输入要查询的书籍名称"> <input type="submit" value="查询" class="btn btn-primary"> </form> </div> </div> <div class="row clearfix"> <div class="col-md-12 column"> <table class="table table-hover table-striped"> <thead> <tr> <th>书籍编号</th> <th>书籍名字</th> <th>书籍数量</th> <th>书籍详情</th> <th>操作</th> </tr> </thead> <%--书籍从数据库中查询出来，从list中遍历出来，--%> <tbody> <c:forEach var="book" items="${list}"> <tr> <td>${book.bookID}</td> <td>${book.bookName}</td> <td>${book.bookCounts}</td> <td>${book.detail}</td> <td> <a href="${pageContext.request.contextPath}/book/toUpdateBook?id=${book.getBookID()}">更改</a> | <a href="${pageContext.request.contextPath}/book/delete/${book.getBookID()}">删除</a> </td> </tr> </c:forEach> </tbody> </table> </div> </div> </div> </html>
注意这里，要引入标签就需要加入一个standard的依赖
<dependency> <groupId>taglibs</groupId> <artifactId>standard</artifactId> <version>1.1.2</version> </dependency>
八、增加书籍
1.allBook.jsp
2.BookController
//跳转到增加书籍页面 @RequestMapping("/toAddBook") public String toAddPaper(){ return "addBook"; }
3.增加addBook.jsp
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <%@ page contentType="text/html;charset=UTF-8" language="java" %> <html> <head> <title>新增书籍</title> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <!-- 引入 Bootstrap --> <link href="https://cdn.bootcss.com/bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet"> </head> <body> <div class="container"> <div class="row clearfix"> <div class="col-md-12 column"> <div class="page-header"> <h1> <small>新增书籍</small> </h1> </div> </div> </div> <form action="${pageContext.request.contextPath}/book/addBook" method="post"> <%--这里的属性要和实体类中的一致--%> 书籍名称：<input type="text" name="bookName"><br><br><br> 书籍数量：<input type="text" name="bookCounts"><br><br><br> 书籍详情：<input type="text" name="detail" required><br><br><br> <input type="submit" value="添加"> </form> </div> </body> </html>
4.BookController
@RequestMapping("/addBook") public String addPaper(Books books) { System.out.println(books); bookService.addBook(books); //重定向到我们的allBook请求 return "redirect:/book/allBook"; }
前端点击按钮需要跳转，在控制层让它跳转到增加页面，在页面中输入相关信息点击提交，提交在控制层中进行操作。结束重定向回allBook请求
这里加上required，这样的话在页面如果没有输入内容就会提示必须要输入内容
