SSM实现书籍的增删改查

布满荆棘的人生 2023-07-21 05:46 16阅读 0赞

## 配置文件整合结束以后,进行Controller和视图的编写 ##

#### 1.BookController类编写 ####

@Controller
    @RequestMapping("/book")
    public class BookController { 
        @Autowired
        @Qualifier("BookServiceImpl")
        private BookeService bookService;
    
        @RequestMapping("/allBook")
        public String list(Model model) { 
            List<Books> list = bookService.queryAllBooks();
            model.addAttribute("list", list);
            return "allBook";
        }
    
        //跳转到增加书籍页面
        @RequestMapping("toAddBook")
        public String toAddPaper(){ 
            return "addBook";
        }
    
        //添加书籍的请求
        @RequestMapping("/addBook")
        public String addBook(Books books){ 
            System.out.println("addBook=>"+books);
            bookService.addBook(books);
            //重定向到@RequestMapping("toAddBook")的请求
            return "redirect:/book/allBook";
        }
    
        //跳转到修改页面
        @RequestMapping("toUpdate")
        public String toUpdataPaper(int id,Model model){ 
            Books books = bookService.queryBook(id);
            model.addAttribute("QBooks",books);
            return "updateBook";
        }
    
        //修改书籍
        @RequestMapping("/updateBook")
        public String updateBook(Books books){ 
            System.out.println("updateBook==>"+books);
            int i = bookService.updateBook(books);
            if(i>0){ 
                System.out.println("添加books成功"+books);
            }
            return "redirect:/book/allBook";
        }
    
        //删除书籍
        @RequestMapping("/toDelete/{bookId}")
        public String deleteBook(@PathVariable("bookId") int id){ 
            System.out.println("deleteBook==>"+bookService.queryBook(id));
            int i = bookService.deleteBook(id);
            if (i>0){ 
                System.out.println("执行删除成功");
            }
            return "redirect:/book/allBook";
        }
    
        //查询书籍
        @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.queryAllBooks();
                model.addAttribute("error","未查到相关书籍");
            }
    
            model.addAttribute("list",list);
            return "allBook";
        }
    }

#### 2.编写index.jsp ####

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
    <html>
    <head>
        <title>Title</title>
    
        <style>
            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: 5px;
            }
        </style>
    
    </head>
    <body>
    
    <h3>
        <a href="${pageContext.request.contextPath}/book/allBook">进入书籍页面</a>
    </h3>
    </body>
    </html>

#### 3. allBook.jsp ####

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
    <%--
      Created by IntelliJ IDEA.
      User: 蔡吉
      Date: 2020-4-1
      Time: 15:09
      To change this template use File | Settings | File Templates.
    --%>
    <%@ page contentType="text/html;charset=UTF-8" language="java" %>
    <html>
    <head>
        <title>书籍展示</title>
        <%--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 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-8 column">
                    <%--查询书籍--%>
                    <form action="${pageContext.request.contextPath}/book/queryBook" method="post" style="float: right">
                        <span style="color: red;font-weight: bold">${error}</span>
                        <label>
                            <input type="text" name="queryBookName" placeholder="请输入要查询的书籍名称" class="form-control">
                        </label>
                        <input type="submit" value="查询" class="btn bt-primary">
                    </form>
                </div>
            </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中遍历出来:foreach--%>
                    <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/toUpdate?id=${book.bookID}">修改</a>
                                 | 
                                <a href="${pageContext.request.contextPath}/book/toDelete/${book.bookID}">删除</a>
                            </td>
                        </tr>
                    </c:forEach>
                    </tbody>
                </table>
            </div>
        </div>
    
    </div>
    
    
    </body>
    </html>

#### 4. addBook.jsp ####

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
    <html>
    <head>
        <title>新增书籍</title>
        <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的name的名字应该和实体类中的属性名一致--%>
            <div class="form-group">
                <label >书籍名称</label>
                <input type="text" name="bookName" class="form-control" required>
            </div>
            <div class="form-group">
                <label>书籍数量</label>
                <input type="text" name="bookCounts" class="form-control" required>
            </div>
            <div class="form-group">
                <label >书籍描述</label>
                <input type="text" name="detail" class="form-control" required>
            </div>
            <div class="form-group">
                <input type="submit" class="form-control" value="提交">
            </div>
        </form>
    
    </div>
    
    </body>
    </html>

#### 5. updateBook.jsp ####

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
    <html>
    <head>
        <title>修改书籍</title>
        <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/updateBook" method="post">
            <%--出现的问题,我们提交了sql请求,但是修改失败,初次考虑,是事务的问题,配置事务以后仍旧失败--%>
            <%--检查sql语句,sql语句执行失败,修改未完成--%>
            <%--前端传递隐藏域--%>
            <input type="hidden" name="bookID" value="${QBooks.bookID}">
            <%--input的name的名字应该和实体类中的属性名一致--%>
            <div class="form-group">
                <label>书籍名称</label>
                <input type="text" name="bookName" class="form-control" value="${QBooks.bookName}" required>
            </div>
            <div class="form-group">
                <label>书籍数量</label>
                <input type="text" name="bookCounts" class="form-control" value="${QBooks.bookCounts}" required>
            </div>
            <div class="form-group">
                <label>书籍描述</label>
                <input type="text" name="detail" class="form-control" value="${QBooks.detail}" required>
            </div>
            <div class="form-group">
                <input type="submit" class="form-control" value="修改">
            </div>
        </form>
    
    </div>
    
    </body>
    </html>