MVC \u7684\u7406\u5ff5\u662f\u5c06\u8f6f\u4ef6\u4ee3\u7801\u62c6\u5206\u6210\u4e3a\u7ec4\u4ef6\uff0c\u5355\u72ec\u5f00\u53d1\uff0c\u7ec4\u5408\u4f7f\u7528\uff08\u76ee\u7684\u8fd8\u662f\u4e3a\u4e86\u964d\u4f4e\u8026\u5408\u5ea6\uff09\u3002<\/p>\n\n\n\n
![\"\"](\"https:\/\/qaqaq.top\/wp-content\/uploads\/2022\/12\/image-181.png\")
<\/div><\/figure>\n\n\n\nMVC \u7684\u4f5c\u7528\u8fd8\u662f\u4e3a\u4e86\u964d\u4f4e\u8026\u5408\u3002\u8ba9\u4ee3\u7801\u5408\u7406\u5206\u5c42\u3002\u65b9\u4fbf\u540e\u671f\u5347\u7ea7\u548c\u7ef4\u62a4\u3002<\/p>\n\n\n\n
\u4e66\u57ce\u7b2c\u4e94\u9636\u6bb5<\/h2>\n\n\n\n1\u3001\u56fe\u4e66\u6a21\u5757<\/h2>\n\n\n\n1.1\u3001\u7f16\u5199\u56fe\u4e66\u6a21\u5757\u7684\u6570\u636e\u5e93\u8868<\/h3>\n\n\n\n# P233 \u4e66\u57ce\u9879\u76ee-\u521b\u5efa\u56fe\u4e66\u6a21\u5757\u7684\u6570\u636e\u5e93\u8868\n\nCREATE TABLE t_book(\n id INT PRIMARY KEY AUTO_INCREMENT,\n name VARCHAR(100), #\u540d\u79f0\n price DECIMAL(11,2), #\u4ef7\u683c\n author VARCHAR(100), #\u4f5c\u8005\n sales INT, #\u9500\u91cf\n stock INT, #\u5e93\u5b58\n img_path VARCHAR(200) #\u56fe\u7247\n);\n\n# \u63d2\u5165\u521d\u59cb\u5316\u6d4b\u8bd5\u6570\u636e\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , 'java\u4ece\u5165\u95e8\u5230\u653e\u5f03' , '\u56fd\u54e5' , 80 , 9999 , 9 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , '\u6570\u636e\u7ed3\u6784\u4e0e\u7b97\u6cd5' , '\u4e25\u654f\u541b' , 78.5 , 6 , 13 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , '\u600e\u6837\u62d0\u8dd1\u522b\u4eba\u7684\u5ab3\u5987' , '\u9f99\u4f0d' , 68, 99999 , 52 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , '\u6728\u865a\u8089\u76d6\u996d' , '\u5c0f\u80d6' , 16, 1000 , 50 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , 'C++\u7f16\u7a0b\u601d\u60f3' , '\u521a\u54e5' , 45.5 , 14 , 95 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , '\u86cb\u7092\u996d' , '\u5468\u661f\u661f' , 9.9, 12 , 53 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , '\u8d4c\u795e' , '\u9f99\u4f0d' , 66.5, 125 , 535 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , 'Java\u7f16\u7a0b\u601d\u60f3' , '\u9633\u54e5' , 99.5 , 47 , 36 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , 'JavaScript\u4ece\u5165\u95e8\u5230\u7cbe\u901a' , '\u5a77\u59d0' , 9.9 , 85 , 95 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , 'cocos2d-x\u6e38\u620f\u7f16\u7a0b\u5165\u95e8' , '\u56fd\u54e5' , 49, 52 , 62 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , 'C\u8bed\u8a00\u7a0b\u5e8f\u8bbe\u8ba1' , '\u8c2d\u6d69\u5f3a' , 28 , 52 , 74 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , 'Lua\u8bed\u8a00\u7a0b\u5e8f\u8bbe\u8ba1' , '\u96f7\u4e30\u9633' , 51.5 , 48 , 82 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , '\u897f\u6e38\u8bb0' , '\u7f57\u8d2f\u4e2d' , 12, 19 , 9999 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , '\u6c34\u6d52\u4f20' , '\u534e\u4ed4' , 33.05 , 22 , 88 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , '\u64cd\u4f5c\u7cfb\u7edf\u539f\u7406' , '\u5218\u4f18' , 133.05 , 122 , 188 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , '\u6570\u636e\u7ed3\u6784 java\u7248' , '\u5c01\u5927\u795e' , 173.15 , 21 , 81 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , 'UNIX\u9ad8\u7ea7\u73af\u5883\u7f16\u7a0b' , '\u4e50\u5929' , 99.15 , 210 , 810 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , 'javaScript\u9ad8\u7ea7\u7f16\u7a0b' , '\u56fd\u54e5' , 69.15 , 210 , 810 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , '\u5927\u8bdd\u8bbe\u8ba1\u6a21\u5f0f' , '\u56fd\u54e5' , 89.15 , 20 , 10 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , '\u4eba\u6708\u795e\u8bdd' , '\u521a\u54e5' , 88.15 , 20 , 80 , 'static\/img\/default.jpg');\n\n# \u67e5\u770b\u8868\u5185\u5bb9\nselect id,name,author,price,sales,stock,img_path from t_book;\n<\/code><\/pre>\n\n\n\n1.2\u3001\u7f16\u5199\u56fe\u4e66\u6a21\u5757\u7684 JavaBean<\/h3>\n\n\n\npackage top.qaqaq.pojo;\n\nimport java.math.BigDecimal;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-10 \u4e0b\u5348 5:22\n *\/\npublic class Book {\n\n private Integer id;\n private String name; \/\/\u540d\u79f0\n private String author; \/\/\u4f5c\u8005\n private BigDecimal price; \/\/\u4ef7\u683c\n private Integer sales; \/\/\u9500\u91cf\n private Integer stock; \/\/\u5e93\u5b58\n private String imgpath = \"static\/img\/default.jpg\"; \/\/\u56fe\u7247\n\n public Book() {\n }\n\n public Book(Integer id, String name, String author, BigDecimal price, Integer sales, Integer stock, String imgpath) {\n this.id = id;\n this.name = name;\n this.author = author;\n this.price = price;\n this.sales = sales;\n this.stock = stock;\n \/\/ \u8981\u6c42\u7ed9\u5b9a\u7684\u56fe\u4e66\u5c01\u9762\u56fe\u4e66\u8def\u5f84\u4e0d\u80fd\u4e3a\u7a7a\n if (imgpath != null && !\"\".equals(imgpath)){\n this.imgpath = imgpath;\n }\n }\n\n public Integer getId() {\n return id;\n }\n\n public void setId(Integer id) {\n this.id = id;\n }\n\n public String getName() {\n return name;\n }\n\n public void setName(String name) {\n this.name = name;\n }\n\n public String getAuthor() {\n return author;\n }\n\n public void setAuthor(String author) {\n this.author = author;\n }\n\n public BigDecimal getPrice() {\n return price;\n }\n\n public void setPrice(BigDecimal price) {\n this.price = price;\n }\n\n public Integer getSales() {\n return sales;\n }\n\n public void setSales(Integer sales) {\n this.sales = sales;\n }\n\n public Integer getStock() {\n return stock;\n }\n\n public void setStock(Integer stock) {\n this.stock = stock;\n }\n\n public String getImgpath() {\n return imgpath;\n }\n\n public void setImgpath(String imgpath) {\n \/\/ \u8981\u6c42\u7ed9\u5b9a\u7684\u56fe\u4e66\u5c01\u9762\u56fe\u4e66\u8def\u5f84\u4e0d\u80fd\u4e3a\u7a7a\n if (imgpath != null && !\"\".equals(imgpath)){\n this.imgpath = imgpath;\n }\n }\n\n @Override\n public String toString() {\n return \"Book{\" +\n \"id=\" + id +\n \", name='\" + name + '\\'' +\n \", author='\" + author + '\\'' +\n \", price=\" + price +\n \", sales=\" + sales +\n \", stock=\" + stock +\n \", imgpath='\" + imgpath + '\\'' +\n '}';\n }\n}\n<\/code><\/pre>\n\n\n\n1.3\u3001\u7f16\u5199\u56fe\u4e66\u6a21\u5757\u7684 Dao \u548c\u6d4b\u8bd5 Dao<\/h3>\n\n\n\n
Dao \u63a5\u53e3<\/p>\n\n\n\n
package top.qaqaq.dao;\n\nimport top.qaqaq.pojo.Book;\n\nimport java.util.List;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-10 \u4e0b\u5348 5:36\n *\/\npublic interface BookDao {\n\n \/**\n * \u6dfb\u52a0\u56fe\u4e66\n * @param book\n * @return\n *\/\n public int addBook(Book book);\n\n \/**\n * \u6839\u636e\u56fe\u4e66id\u5220\u9664\u56fe\u4e66\n * @param id\n * @return\n *\/\n public int deleteBookById(Integer id);\n\n \/**\n * \u6839\u636e\u56fe\u4e66id\u66f4\u65b0\u56fe\u4e66\n * @param book\n * @return\n *\/\n public int updateBook(Book book);\n\n \/**\n * \u6839\u636e\u56fe\u4e66id\u67e5\u8be2\u56fe\u4e66\n * @param id\n * @return\n *\/\n public Book queryBookById(Integer id);\n\n \/**\n * \u67e5\u8be2\u5168\u90e8\u56fe\u4e66\n * @return\n *\/\n public List<Book> queryBooks();\n\n\n}\n<\/code><\/pre>\n\n\n\nBookDaoImpl \u5b9e\u73b0\u7c7b\uff1a<\/p>\n\n\n\n
package top.qaqaq.dao.impl;\n\nimport top.qaqaq.dao.BookDao;\nimport top.qaqaq.pojo.Book;\n\nimport java.util.List;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-10 \u4e0b\u5348 5:40\n *\/\npublic class BookDaoImpl extends BaseDao implements BookDao {\n @Override\n public int addBook(Book book) {\n\n String sql = \"insert into t_book(name,author,price,sales,stock,img_path) values(?,?,?,?,?,?)\";\n\n return update(sql, book.getName(), book.getAuthor(), book.getPrice(), book.getSales(), book.getStock(), book.getImgpath());\n }\n\n @Override\n public int deleteBookById(Integer id) {\n\n String sql = \"delete from t_book where id = ?\";\n\n return update(sql, id);\n }\n\n @Override\n public int updateBook(Book book) {\n\n String sql = \"update t_book set name=?,author=?,price=?,sales=?,stock=?,img_path=? where id = ?\";\n\n return update(sql, book.getName(), book.getAuthor(), book.getPrice(), book.getSales(), book.getStock(), book.getImgpath(), book.getId());\n }\n\n @Override\n public Book queryBookById(Integer id) {\n\n String sql = \"select id,name,author,price,sales,stock,img_path imgpath from t_book where id = ?\";\n\n return queryForOne(Book.class, sql, id);\n }\n\n @Override\n public List<Book> queryBooks() {\n\n String sql = \"select id,name,author,price,sales,stock,img_path imgpath from t_book\";\n\n return queryForList(Book.class, sql);\n }\n}\n<\/code><\/pre>\n\n\n\nBookDao \u7684\u6d4b\u8bd5\uff1a<\/p>\n\n\n\n
package top.qaqaq.test;\n\nimport org.junit.Test;\nimport top.qaqaq.dao.BookDao;\nimport top.qaqaq.dao.impl.BookDaoImpl;\nimport top.qaqaq.pojo.Book;\n\nimport java.math.BigDecimal;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-10 \u4e0b\u5348 5:54\n *\/\npublic class BookDaoTest {\n\n private BookDao bookDao = new BookDaoImpl();\n\n @Test\n public void addBook() {\n bookDao.addBook(new Book(null,\"\u6211\u4e3a\u4ec0\u4e48\u8fd9\u4e48\u5e05\uff01\",\"191125\",new BigDecimal(9999),1100000,0,null));\n }\n\n @Test\n public void deleteBookById() {\n bookDao.deleteBookById(21);\n }\n\n @Test\n public void updateBook() {\n bookDao.updateBook(new Book(21,\"\u5927\u5bb6\u90fd\u53ef\u4ee5\u8fd9\u4e48\u5e05\uff01\",\"\u81ea\u5df1\",new BigDecimal(9999),1100000,0,null));\n }\n\n @Test\n public void queryBookById() {\n System.out.println(bookDao.queryBookById(21));\n }\n\n @Test\n public void queryBooks() {\n bookDao.queryBooks().forEach(System.out::println);\n }\n}<\/code><\/pre>\n\n\n\n1.4\u3001\u7f16\u5199\u56fe\u4e66\u6a21\u5757\u7684 Service \u548c\u6d4b\u8bd5 Service<\/h3>\n\n\n\n
BookService \u63a5\u53e3<\/p>\n\n\n\n
package top.qaqaq.service;\n\nimport top.qaqaq.pojo.Book;\n\nimport java.util.List;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-10 \u4e0b\u5348 7:37\n *\/\npublic interface BookService {\n\n \/**\n * \u6dfb\u52a0\u56fe\u4e66\n * @param book\n *\/\n public void addBook(Book book);\n\n \/**\n * \u6839\u636e\u56fe\u4e66id\u5220\u9664\u56fe\u4e66\n * @param id\n *\/\n public void deleteBookById(Integer id);\n\n \/**\n * \u6839\u636e\u56fe\u4e66id\u66f4\u65b0\u56fe\u4e66\n * @param book\n *\/\n public void updateBook(Book book);\n\n \/**\n * \u6839\u636e\u56fe\u4e66id\u67e5\u8be2\u56fe\u4e66\n * @param id\n * @return\n *\/\n public Book queryBookById(Integer id);\n\n \/**\n * \u67e5\u8be2\u5168\u90e8\u56fe\u4e66\n * @return\n *\/\n public List<Book> queryBooks();\n}\n<\/code><\/pre>\n\n\n\nBookServiceImpl \u5b9e\u73b0\u7c7b\uff1a<\/p>\n\n\n\n
package top.qaqaq.service.impl;\n\nimport top.qaqaq.dao.BookDao;\nimport top.qaqaq.dao.impl.BookDaoImpl;\nimport top.qaqaq.pojo.Book;\nimport top.qaqaq.service.BookService;\n\nimport java.util.List;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-10 \u4e0b\u5348 7:42\n *\/\npublic class BookServiceImpl implements BookService {\n\n private BookDao bookDao = new BookDaoImpl();\n\n @Override\n public void addBook(Book book) {\n bookDao.addBook(book);\n }\n\n @Override\n public void deleteBookById(Integer id) {\n bookDao.deleteBookById(id);\n }\n\n @Override\n public void updateBook(Book book) {\n bookDao.updateBook(book);\n }\n\n @Override\n public Book queryBookById(Integer id) {\n return bookDao.queryBookById(id);\n }\n\n @Override\n public List<Book> queryBooks() {\n return bookDao.queryBooks();\n }\n}\n<\/code><\/pre>\n\n\n\nBookService \u7684\u6d4b\u8bd5\uff1a<\/p>\n\n\n\n
package top.qaqaq.test;\n\nimport org.junit.Test;\nimport top.qaqaq.pojo.Book;\nimport top.qaqaq.service.BookService;\nimport top.qaqaq.service.impl.BookServiceImpl;\n\nimport java.math.BigDecimal;\n\nimport static org.junit.Assert.*;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-10 \u4e0b\u5348 7:45\n *\/\npublic class BookServiceTest {\n\n private BookService bookService = new BookServiceImpl();\n\n @Test\n public void addBook() {\n bookService.addBook(new Book(null,\"\u4f60\u597d\u6211\u597d\u5927\u5bb6\u597d\",\"1125\",new BigDecimal(100000),10000000,0,null));\n }\n\n @Test\n public void deleteBookById() {\n bookService.deleteBookById(22);\n }\n\n @Test\n public void updateBook() {\n bookService.updateBook(new Book(22,\"\u5927\u5bb6\u597d\",\"1125\",new BigDecimal(999999),10,1000000,null));\n }\n\n @Test\n public void queryBookById() {\n System.out.println(bookService.queryBookById(22));\n }\n\n @Test\n public void queryBooks() {\n bookService.queryBooks().forEach(System.out::println);\n }\n}<\/code><\/pre>\n\n\n\n1.5\u3001\u7f16\u5199\u56fe\u4e66\u6a21\u5757\u7684 Web \u5c42\uff0c\u548c\u9875\u9762\u8054\u8c03\u6d4b\u8bd5<\/h3>\n\n\n\n1.5.1\u3001\u56fe\u4e66\u5217\u8868\u529f\u80fd\u7684\u5b9e\u73b0<\/h4>\n\n\n\n
1\u3001\u56fe\u89e3\u5217\u8868\u529f\u80fd\u6d41\u7a0b\uff1a<\/p>\n\n\n\n![\"\"](\"data:image\/svg+xml;base64,PCEtLUFyZ29uTG9hZGluZy0tPgo8c3ZnIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgc3Ryb2tlPSIjZmZmZmZmMDAiPjxnPjwvZz4KPC9zdmc+\")
<\/div><\/figure>\n\n\n\n2\u3001BookServlet \u7a0b\u5e8f\u4e2d\u6dfb\u52a0 list \u65b9\u6cd5<\/p>\n\n\n\n
package top.qaqaq.web;\n\nimport jakarta.servlet.ServletException;\nimport jakarta.servlet.http.HttpServletRequest;\nimport jakarta.servlet.http.HttpServletResponse;\nimport top.qaqaq.pojo.Book;\nimport top.qaqaq.service.BookService;\nimport top.qaqaq.service.impl.BookServiceImpl;\n\nimport java.io.IOException;\nimport java.util.List;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-10 \u4e0b\u5348 7:51\n *\/\npublic class BookServlet extends BaseServlet {\n\n private BookService bookService = new BookServiceImpl();\n\n protected void add(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n }\n\n protected void delete(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n }\n\n protected void update(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n }\n\n protected void list(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u901a\u8fc7BookService\u67e5\u8be2\u5168\u90e8\u56fe\u4e66\n List<Book> books = bookService.queryBooks();\n \/\/ 2. \u628a\u5168\u90e8\u56fe\u4e66\u4fdd\u5b58\u5230Request\u57df\u4e2d\n req.setAttribute(\"books\", books);\n \/\/ 3. \u8bf7\u6c42\u8f6c\u53d1\u5230\/pages\/manager\/book_manager.jsp\u9875\u9762\n req.getRequestDispatcher(\"\/pages\/manager\/book_manager.jsp\").forward(req,resp);\n\n }\n}\n<\/code><\/pre>\n\n\n\n3\u3001\u4fee\u6539\u3010\u56fe\u4e66\u7ba1\u7406\u3011\u8bf7\u6c42\u5730\u5740<\/p>\n\n\n\n
<%--\n Created by IntelliJ IDEA.\n User: ZRich\n Date: 2022\/12\/9\n Time: \u4e0b\u5348 5:33\n To change this template use File | Settings | File Templates.\n--%>\n<%@ page contentType=\"text\/html;charset=UTF-8\" language=\"java\" %>\n\n<div>\n <%-- action=list\u8868\u793a\u8c03\u7528BookServlet.java\u91cc\u7684list\u65b9\u6cd5 --%>\n <a href=\"manager\/bookServlet?action=list\">\u56fe\u4e66\u7ba1\u7406<\/a>\n <a href=\"pages\/manager\/order_manager.jsp\">\u8ba2\u5355\u7ba1\u7406<\/a>\n <a href=\"index.jsp\">\u8fd4\u56de\u5546\u57ce<\/a>\n<\/div>\n<\/code><\/pre>\n\n\n\n4\u3001\u4fee\u6539 pages\/manager\/book_manager.jsp \u9875\u9762\u7684\u6570\u636e\u904d\u5386\u8f93\u51fa<\/p>\n\n\n\n
<%@ taglib prefix=\"c\" uri=\"http:\/\/java.sun.com\/jsp\/jstl\/core\" %>\n<%@ page contentType=\"text\/html;charset=UTF-8\" language=\"java\" %>\n<!DOCTYPE html>\n<html>\n<head>\n<meta charset=\"UTF-8\">\n<title>\u56fe\u4e66\u7ba1\u7406<\/title>\n\n\t<%-- \u9759\u6001\u5305\u542b base\u6807\u7b7e\uff0ccss\u6837\u5f0f\uff0cjQuery\u6587\u4ef6 --%>\n\t<%@ include file=\"\/pages\/common\/head.jsp\"%>\n\n<\/head>\n<body>\n\t\n\t<div id=\"header\">\n\t\t\t<img class=\"logo_img\" alt=\"\" src=\"..\/..\/static\/img\/logo.gif\" >\n\t\t\t<span class=\"wel_word\">\u56fe\u4e66\u7ba1\u7406\u7cfb\u7edf<\/span>\n\n\t\t\t<%-- \u9759\u6001\u5305\u542b manager \u7ba1\u7406\u6a21\u5757\u7684\u83dc\u5355 --%>\n\t\t\t<%@include file=\"\/pages\/common\/manager_menu.jsp\"%>\n\n\t<\/div>\n\t\n\t<div id=\"main\">\n\t\t<table>\n\t\t\t<tr>\n\t\t\t\t<td>\u540d\u79f0<\/td>\n\t\t\t\t<td>\u4ef7\u683c<\/td>\n\t\t\t\t<td>\u4f5c\u8005<\/td>\n\t\t\t\t<td>\u9500\u91cf<\/td>\n\t\t\t\t<td>\u5e93\u5b58<\/td>\n\t\t\t\t<td colspan=\"2\">\u64cd\u4f5c<\/td>\n\t\t\t<\/tr>\n\n\t\t\t<c:forEach items=\"${requestScope.books}\" var=\"book\">\n\t\t\t\t<tr>\n\t\t\t\t\t<td>${book.name}<\/td>\n\t\t\t\t\t<td>${book.price}<\/td>\n\t\t\t\t\t<td>${book.author}<\/td>\n\t\t\t\t\t<td>${book.sales}<\/td>\n\t\t\t\t\t<td>${book.stock}<\/td>\n\t\t\t\t\t<td><a href=\"book_edit.jsp\">\u4fee\u6539<\/a><\/td>\n\t\t\t\t\t<td><a href=\"#\">\u5220\u9664<\/a><\/td>\n\t\t\t\t<\/tr>\n\t\t\t<\/c:forEach>\n\n\t\t\t<tr>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><a href=\"book_edit.jsp\">\u6dfb\u52a0\u56fe\u4e66<\/a><\/td>\n\t\t\t<\/tr>\t\n\t\t<\/table>\n\t<\/div>\n\n\t<%-- \u9759\u6001\u5305\u542b\u9875\u811a\u5185\u5bb9 --%>\n\t<%@include file=\"\/pages\/common\/footer.jsp\"%>\n\n<\/body>\n<\/html><\/code><\/pre>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.2\u3001\u524d\u540e\u53f0\u7684\u7b80\u5355\u4ecb\u7ecd<\/h4>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.3\u3001\u6dfb\u52a0\u56fe\u4e66\u529f\u80fd\u7684\u5b9e\u73b0<\/h4>\n\n\n\n
1.5.3.1\u3001\u6dfb\u52a0\u56fe\u4e66\u6d41\u7a0b\u7ec6\u8282\uff1a<\/p>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.3.2\u3001\u95ee\u9898\u8bf4\u660e\uff1a\u8868\u5355\u91cd\u590d\u63d0\u4ea4\uff1a<\/p>\n\n\n\n
\u5f53\u7528\u6237\u63d0\u4ea4\u5b8c\u8bf7\u6c42\uff0c\u6d4f\u89c8\u5668\u4f1a\u8bb0\u5f55\u4e0b\u6700\u540e\u4e00\u6b21\u8bf7\u6c42\u7684\u5168\u90e8\u4fe1\u606f\u3002\u5f53\u7528\u6237\u6309\u4e0b\u529f\u80fd\u952e F5\uff0c\u5c31\u4f1a\u53d1\u8d77\u6d4f\u89c8\u5668\u8bb0\u5f55\u7684\u6700\u540e\u4e00\u6b21\u8bf7\u6c42\u3002<\/p>\n\n\n\n
1.5.3.3\u3001BookServlet \u7a0b\u5e8f\u4e2d\u6dfb\u52a0 add \u65b9\u6cd5<\/p>\n\n\n\n
package top.qaqaq.web;\n\nimport jakarta.servlet.ServletException;\nimport jakarta.servlet.http.HttpServletRequest;\nimport jakarta.servlet.http.HttpServletResponse;\nimport top.qaqaq.pojo.Book;\nimport top.qaqaq.service.BookService;\nimport top.qaqaq.service.impl.BookServiceImpl;\nimport top.qaqaq.utils.WebUtils;\n\nimport java.io.IOException;\nimport java.util.List;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-10 \u4e0b\u5348 7:51\n *\/\npublic class BookServlet extends BaseServlet {\n\n private BookService bookService = new BookServiceImpl();\n\n \/**\n * \u8d1f\u8d23\u6dfb\u52a0\u56fe\u4e66\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void add(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570==\u5c01\u88c5\u6210\u4e3aBook\u5bf9\u8c61\n Book book = WebUtils.copyParamToBean(req.getParameterMap(), new Book());\n \/\/ 2. \u8c03\u7528BookService.addBook()\u4fdd\u5b58\u56fe\u4e66\n bookService.addBook(book);\n \/\/ 3. \u8df3\u5230\u56fe\u4e66\u5217\u8868\u9875\u9762\n \/\/ \/manager\/bookServlet?action=list\n\n \/\/ \u5982\u679c\u4f7f\u7528\u8bf7\u6c42\u8f6c\u53d1\uff0c\u5219\u4e3a\u4e00\u6b21\u8bf7\u6c42\uff0c\u5237\u65b0\u4f1a\u91cd\u590d\u63d0\u4ea4\u6570\u636e\n\/\/ req.getRequestDispatcher(\"\/manager\/bookServlet?action=list\").forward(req,resp);\n \/\/ \u6240\u4ee5\u4f7f\u7528\u8bf7\u6c42\u91cd\u5b9a\u5411\n resp.sendRedirect(req.getContextPath() + \"\/manager\/bookServlet?action=list\");\n\n }\n\n \/**\n * \u8d1f\u8d23\u5220\u9664\u56fe\u4e66\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void delete(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570id\uff0c\u56fe\u4e66\u7f16\u7a0b\n int id = WebUtils.parseInt(req.getParameter(\"id\"),0);\n\n \/\/ 2. \u8c03\u7528bookService.deleteBookById();\u5220\u9664\u56fe\u4e66\n bookService.deleteBookById(id);\n \/\/ 3. \u91cd\u5b9a\u5411\u56de\u56fe\u4e66\u5217\u8868\u7ba1\u7406\u9875\u9762\n \/\/ \/book\/manager\/bookServlet?action=list\n resp.sendRedirect(req.getContextPath() + \"\/manager\/bookServlet?action=list\");\n }\n\n \/**\n * \u4fdd\u5b58\u4fee\u6539\u56fe\u4e66\u7684\u64cd\u4f5c\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void update(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570==\u5c01\u88c5\u6210\u4e3aBook\u5bf9\u8c61\n Book book = WebUtils.copyParamToBean(req.getParameterMap(), new Book());\n \/\/ 2. \u8c03\u7528BookService.updateBook( book );\u4fee\u6539\u56fe\u4e66\n bookService.updateBook(book);\n \/\/ 3. \u91cd\u5b9a\u5411\u56de\u56fe\u4e66\u5217\u8868\u7ba1\u7406\u9875\u9762\n \/\/ \u5730\u5740\uff1a\/\u5de5\u7a0b\u540d\/manager\/bookServlet?action=list\n resp.sendRedirect(req.getContextPath() + \"\/manager\/bookServlet?action=list\");\n\n }\n\n \/**\n * \u83b7\u53d6\u8981\u4fee\u6539\u7684\u56fe\u4e66\u4fe1\u606f\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void getBook(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570\u56fe\u4e66\u7f16\u53f7\n int id = WebUtils.parseInt(req.getParameter(\"id\"),0);\n \/\/ 2. \u8c03\u7528bookService.queryBookById\u67e5\u8be2\u56fe\u4e66\n Book book = bookService.queryBookById(id);\n \/\/ 3. \u4fdd\u5b58\u56fe\u4e66\u5230Request\u57df\u4e2d\n req.setAttribute(\"book\",book);\n \/\/ 4. \u8bf7\u6c42\u8f6c\u53d1\u5230\u3002pages\/manager\/book_edit.jsp\u9875\u9762\n req.getRequestDispatcher(\"\/pages\/manager\/book_edit.jsp\").forward(req,resp);\n }\n\n \/**\n * \u8d1f\u8d23\u904d\u5386\u56fe\u4e66\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void list(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u901a\u8fc7BookService\u67e5\u8be2\u5168\u90e8\u56fe\u4e66\n List<Book> books = bookService.queryBooks();\n \/\/ 2. \u628a\u5168\u90e8\u56fe\u4e66\u4fdd\u5b58\u5230Request\u57df\u4e2d\n req.setAttribute(\"books\", books);\n \/\/ 3. \u8bf7\u6c42\u8f6c\u53d1\u5230\/pages\/manager\/book_manager.jsp\u9875\u9762\n req.getRequestDispatcher(\"\/pages\/manager\/book_manager.jsp\").forward(req,resp);\n\n }\n}\n<\/code><\/pre>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.3.4\u3001\u4fee\u6539 book_edit.jsp \u9875\u9762<\/p>\n\n\n\n
<%@ page contentType=\"text\/html;charset=UTF-8\" language=\"java\" %>\n<!DOCTYPE html>\n<html>\n<head>\n<meta charset=\"UTF-8\">\n<title>\u7f16\u8f91\u56fe\u4e66<\/title>\n\n\t<%-- \u9759\u6001\u5305\u542b base\u6807\u7b7e\uff0ccss\u6837\u5f0f\uff0cjQuery\u6587\u4ef6 --%>\n\t<%@ include file=\"\/pages\/common\/head.jsp\"%>\n\n\t<style type=\"text\/css\">\n\th1 {\n\t\ttext-align: center;\n\t\tmargin-top: 200px;\n\t}\n\t\n\th1 a {\n\t\tcolor:red;\n\t}\n\t\n\tinput {\n\t\ttext-align: center;\n\t}\n<\/style>\n<\/head>\n<body>\n<!--\n\t\u9047\u5230\u7684\u95ee\u9898\uff1a\n\tbook_edit.jsp\u9875\u9762\uff0c\u65e2\u8981\u505a\u6dfb\u52a0\u64cd\u4f5c\u3002\u53c8\u8981\u505a\u4fee\u6539\u64cd\u4f5c\uff0c\u800c\u5230\u5e95\u662f\u6dfb\u52a0\uff0c\u8fd8\u662f\u4fee\u6539\u662f\u7531\u4e00\u4e2a\u9690\u85cf\u57df\u6765\u51b3\u5b9a\u7684\u3002\n\t\u5982\u4f55\u52a8\u6001\u4fee\u6539\u9690\u85cf\u57df<input type=\"hidden\" name=\"action\" value=\"xxx\" \/> \u8ba9\u5b83\u7684\u503c\u65e2\u53ef\u4ee5\u5b9e\u73b0\u6dfb\u52a0\uff0c\u53c8\u53ef\u4ee5\u5b9e\u73b0\u4fee\u6539\u64cd\u4f5c\uff1f\n\n\t\/\/\u65b9\u6848\u4e00\uff1a\n\t\u53ef\u4ee5\u5f53\u8bf7\u6c42\u53d1\u8d77\u65f6\uff0c\u9644\u5e26\u4e0a\u5f53\u524d\u8981\u64cd\u4f5c\u7684\u503c\u3002\u5e76\u6ce8\u5165\u5230\u9690\u85cf\u57df\u4e2d\u3002\n\n\t\/\/\u65b9\u6848\u4e8c\uff1a\n\t\u53ef\u4ee5\u901a\u8fc7\u5224\u65ad\u5f53\u524d\u8bf7\u6c42\u53c2\u6570\u4e2d\u662f\u5426\u5305\u542b\u6709id\u53c2\u6570\u3002\u5982\u679c\u6709\u8bf4\u660e\u662f\u4fee\u6539\u64cd\u4f5c\u3002\u5982\u679c\u6ca1\u6709\u8bf4\u660e\u662f\u6dfb\u52a0\u64cd\u4f5c\u3002\n\t\u662f\u5426\u662f\u6dfb\u52a0\u64cd\u4f5c\uff1a\n<%--\t${ empty param.id ? \"add\" : \"update\"}--%>\n\n\t\/\/\u65b9\u6848\u4e09\uff1a\n\t\u53ef\u4ee5\u901a\u8fc7\u5224\u65ad\uff0cRequest\u57df\u4e2d\u662f\u5426\u5305\u542b\u6709\u4fee\u6539\u7684\u56fe\u4e66\u4fe1\u606f\u5bf9\u8c61\uff0c\u5982\u679c\u6ca1\u6709\u8bf4\u660e\u662f\u6dfb\u52a0\u64cd\u4f5c\u3002\u5982\u679c\u6709\u8bf4\u660e\u662f\u4fee\u6539\u64cd\u4f5c\u3002\n\t\u662f\u5426\u662f\u6dfb\u52a0\u64cd\u4f5c\uff1a\n<%--\t${ empty requestScope.book ? \"add\" : \"update\"}--%>\n-->\n\n\t\t<div id=\"header\">\n\t\t\t<img class=\"logo_img\" alt=\"\" src=\"..\/..\/static\/img\/logo.gif\" >\n\t\t\t<span class=\"wel_word\">\u7f16\u8f91\u56fe\u4e66<\/span>\n\n\t\t\t<%-- \u9759\u6001\u5305\u542b manager \u7ba1\u7406\u6a21\u5757\u7684\u83dc\u5355 --%>\n\t\t\t<%@include file=\"\/pages\/common\/manager_menu.jsp\"%>\n\n\t\t<\/div>\n\t\t\n\t\t<div id=\"main\">\n\t\t\t<form action=\"manager\/bookServlet\" method=\"get\">\n\t\t\t\t<input type=\"hidden\" name=\"action\" value=\"${ empty param.id ? \"add\" : \"update\"}\" \/>\n\t\t\t\t<input type=\"hidden\" name=\"id\" value=\"${requestScope.book.id}\" \/>\n\t\t\t\t<table>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td>\u540d\u79f0<\/td>\n\t\t\t\t\t\t<td>\u4ef7\u683c<\/td>\n\t\t\t\t\t\t<td>\u4f5c\u8005<\/td>\n\t\t\t\t\t\t<td>\u9500\u91cf<\/td>\n\t\t\t\t\t\t<td>\u5e93\u5b58<\/td>\n\t\t\t\t\t\t<td colspan=\"2\">\u64cd\u4f5c<\/td>\n\t\t\t\t\t<\/tr>\t\t\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td><input name=\"name\" type=\"text\" value=\"${requestScope.book.name}\"\/><\/td>\n\t\t\t\t\t\t<td><input name=\"price\" type=\"text\" value=\"${requestScope.book.price}\"\/><\/td>\n\t\t\t\t\t\t<td><input name=\"author\" type=\"text\" value=\"${requestScope.book.author}\"\/><\/td>\n\t\t\t\t\t\t<td><input name=\"sales\" type=\"text\" value=\"${requestScope.book.sales}\"\/><\/td>\n\t\t\t\t\t\t<td><input name=\"stock\" type=\"text\" value=\"${requestScope.book.stock}\"\/><\/td>\n\t\t\t\t\t\t<td><input type=\"submit\" value=\"\u63d0\u4ea4\"\/><\/td>\n\t\t\t\t\t<\/tr>\t\n\t\t\t\t<\/table>\n\t\t\t<\/form>\n\t\t\t\n\t\n\t\t<\/div>\n\n\t\t<%-- \u9759\u6001\u5305\u542b\u9875\u811a\u5185\u5bb9 --%>\n\t\t<%@include file=\"\/pages\/common\/footer.jsp\"%>\n\n<\/body>\n<\/html><\/code><\/pre>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.4\u3001\u5220\u9664\u56fe\u4e66\u529f\u80fd\u7684\u5b9e\u73b0<\/h3>\n\n\n\n
1.5.4.1\u3001\u56fe\u89e3\u5220\u9664\u6d41\u7a0b\uff1a<\/p>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.4.2\u3001BookServlet \u7a0b\u5e8f\u4e2d\u7684 delete \u65b9\u6cd5\uff1a<\/p>\n\n\n\n
package top.qaqaq.web;\n\nimport jakarta.servlet.ServletException;\nimport jakarta.servlet.http.HttpServletRequest;\nimport jakarta.servlet.http.HttpServletResponse;\nimport top.qaqaq.pojo.Book;\nimport top.qaqaq.service.BookService;\nimport top.qaqaq.service.impl.BookServiceImpl;\nimport top.qaqaq.utils.WebUtils;\n\nimport java.io.IOException;\nimport java.util.List;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-10 \u4e0b\u5348 7:51\n *\/\npublic class BookServlet extends BaseServlet {\n\n private BookService bookService = new BookServiceImpl();\n\n \/**\n * \u8d1f\u8d23\u6dfb\u52a0\u56fe\u4e66\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void add(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570==\u5c01\u88c5\u6210\u4e3aBook\u5bf9\u8c61\n Book book = WebUtils.copyParamToBean(req.getParameterMap(), new Book());\n \/\/ 2. \u8c03\u7528BookService.addBook()\u4fdd\u5b58\u56fe\u4e66\n bookService.addBook(book);\n \/\/ 3. \u8df3\u5230\u56fe\u4e66\u5217\u8868\u9875\u9762\n \/\/ \/manager\/bookServlet?action=list\n\n \/\/ \u5982\u679c\u4f7f\u7528\u8bf7\u6c42\u8f6c\u53d1\uff0c\u5219\u4e3a\u4e00\u6b21\u8bf7\u6c42\uff0c\u5237\u65b0\u4f1a\u91cd\u590d\u63d0\u4ea4\u6570\u636e\n\/\/ req.getRequestDispatcher(\"\/manager\/bookServlet?action=list\").forward(req,resp);\n \/\/ \u6240\u4ee5\u4f7f\u7528\u8bf7\u6c42\u91cd\u5b9a\u5411\n resp.sendRedirect(req.getContextPath() + \"\/manager\/bookServlet?action=list\");\n\n }\n\n \/**\n * \u8d1f\u8d23\u5220\u9664\u56fe\u4e66\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void delete(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570id\uff0c\u56fe\u4e66\u7f16\u7a0b\n int id = WebUtils.parseInt(req.getParameter(\"id\"),0);\n\n \/\/ 2. \u8c03\u7528bookService.deleteBookById();\u5220\u9664\u56fe\u4e66\n bookService.deleteBookById(id);\n \/\/ 3. \u91cd\u5b9a\u5411\u56de\u56fe\u4e66\u5217\u8868\u7ba1\u7406\u9875\u9762\n \/\/ \/book\/manager\/bookServlet?action=list\n resp.sendRedirect(req.getContextPath() + \"\/manager\/bookServlet?action=list\");\n }\n\n \/**\n * \u4fdd\u5b58\u4fee\u6539\u56fe\u4e66\u7684\u64cd\u4f5c\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void update(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570==\u5c01\u88c5\u6210\u4e3aBook\u5bf9\u8c61\n Book book = WebUtils.copyParamToBean(req.getParameterMap(), new Book());\n \/\/ 2. \u8c03\u7528BookService.updateBook( book );\u4fee\u6539\u56fe\u4e66\n bookService.updateBook(book);\n \/\/ 3. \u91cd\u5b9a\u5411\u56de\u56fe\u4e66\u5217\u8868\u7ba1\u7406\u9875\u9762\n \/\/ \u5730\u5740\uff1a\/\u5de5\u7a0b\u540d\/manager\/bookServlet?action=list\n resp.sendRedirect(req.getContextPath() + \"\/manager\/bookServlet?action=list\");\n\n }\n\n \/**\n * \u83b7\u53d6\u8981\u4fee\u6539\u7684\u56fe\u4e66\u4fe1\u606f\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void getBook(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570\u56fe\u4e66\u7f16\u53f7\n int id = WebUtils.parseInt(req.getParameter(\"id\"),0);\n \/\/ 2. \u8c03\u7528bookService.queryBookById\u67e5\u8be2\u56fe\u4e66\n Book book = bookService.queryBookById(id);\n \/\/ 3. \u4fdd\u5b58\u56fe\u4e66\u5230Request\u57df\u4e2d\n req.setAttribute(\"book\",book);\n \/\/ 4. \u8bf7\u6c42\u8f6c\u53d1\u5230\u3002pages\/manager\/book_edit.jsp\u9875\u9762\n req.getRequestDispatcher(\"\/pages\/manager\/book_edit.jsp\").forward(req,resp);\n }\n\n \/**\n * \u8d1f\u8d23\u904d\u5386\u56fe\u4e66\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void list(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u901a\u8fc7BookService\u67e5\u8be2\u5168\u90e8\u56fe\u4e66\n List<Book> books = bookService.queryBooks();\n \/\/ 2. \u628a\u5168\u90e8\u56fe\u4e66\u4fdd\u5b58\u5230Request\u57df\u4e2d\n req.setAttribute(\"books\", books);\n \/\/ 3. \u8bf7\u6c42\u8f6c\u53d1\u5230\/pages\/manager\/book_manager.jsp\u9875\u9762\n req.getRequestDispatcher(\"\/pages\/manager\/book_manager.jsp\").forward(req,resp);\n\n }\n}\n<\/code><\/pre>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.4.3\u3001\u7ed9 WebUtils \u5de5\u5177\u7c7b\u6dfb\u52a0\u8f6c\u6362 int \u7c7b\u578b\u7684\u5de5\u5177\u65b9\u6cd5<\/p>\n\n\n\n
package top.qaqaq.utils;\n\nimport org.apache.commons.beanutils.BeanUtils;\n\nimport java.lang.reflect.InvocationTargetException;\nimport java.util.Map;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-10 \u4e0b\u5348 2:11\n *\/\npublic class WebUtils {\n\n \/**\n * \u628aMap\u4e2d\u7684\u503c\u6ce8\u5165\u5230\u5bf9\u5e94\u7684JavaBean\u5c5e\u6027\u4e2d\u3002\n * @param value\n * @param bean\n * \u5982\u679c\u5f62\u53c2\u5199\u6210HttpServletRequest DAO\u5c42\u548cService\u5c42\u6ca1\u6709\u8fd9\u4e2aAPI \u4e14web\u5c42\u8026\u5408\u5ea6\u9ad8\uff0c\u4ee3\u7801\u4e0d\u4f18\u96c5\n * DAO\u5c42\n * Service\u5c42\n * Web\u5c42\n *\/\n public static <T> T copyParamToBean(Map value, T bean) {\n try {\n System.out.println(\"\u6ce8\u5165\u4e4b\u524d\uff1a\" + bean);\n BeanUtils.populate(bean,value);\n System.out.println(\"\u6ce8\u5165\u4e4b\u540e\uff1a\" + bean);\n } catch (IllegalAccessException e) {\n e.printStackTrace();\n } catch (InvocationTargetException e) {\n e.printStackTrace();\n }\n return bean;\n }\n\n \/**\n * \u5c06\u5b57\u7b26\u4e32\u8f6c\u6362\u6210\u4e3aint\u7c7b\u578b\n * @param strInt\n * @param defaultValue\n * @return\n *\/\n public static int parseInt(String strInt, int defaultValue){\n try {\n return Integer.parseInt(strInt);\n } catch (NumberFormatException e) {\n e.printStackTrace();\n }\n return defaultValue;\n }\n}\n<\/code><\/pre>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.4.4\u3001\u4fee\u6539\u5220\u9664\u7684\u8fde\u63a5\u5730\u5740\uff1a<\/p>\n\n\n\n
book_manager.jsp<\/p>\n\n\n\n
<%@ taglib prefix=\"c\" uri=\"http:\/\/java.sun.com\/jsp\/jstl\/core\" %>\n<%@ page contentType=\"text\/html;charset=UTF-8\" language=\"java\" %>\n<!DOCTYPE html>\n<html>\n<head>\n<meta charset=\"UTF-8\">\n<title>\u56fe\u4e66\u7ba1\u7406<\/title>\n\n\t<%-- \u9759\u6001\u5305\u542b base\u6807\u7b7e\uff0ccss\u6837\u5f0f\uff0cjQuery\u6587\u4ef6 --%>\n\t<%@ include file=\"\/pages\/common\/head.jsp\"%>\n\t<script type=\"text\/javascript\">\n\t\t$(function () {\n\t\t\t\/\/ \u7ed9\u5220\u9664\u7684a\u6807\u7b7e\u7ed1\u5b9a\u5355\u51fb\u4e8b\u4ef6\uff0c\u7528\u4e8e\u5220\u9664\u7684\u786e\u8ba4\u63d0\u793a\u64cd\u4f5c\n\t\t\t$(\"a.deleteClass\").click(function () {\n\t\t\t\t\/\/\u5728\u4e8b\u4ef6\u7684function\u51fd\u6570\u4e2d\uff0c\u6709\u4e00\u4e2athis\u5bf9\u8c61\u3002\u8fd9\u4e2athis\u5bf9\u8c61\uff0c\u662f\u5f53\u524d\u6b63\u5728\u54cd\u5e94\u4e8b\u4ef6\u7684dom\u5bf9\u8c61\u3002\n\n\t\t\t\t\/**\n\t\t\t\t * confirm\u662f\u786e\u8ba4\u63d0\u793a\u6846\u51fd\u6570\n\t\t\t\t * \u53c2\u6570\u662f\u5b83\u7684\u63d0\u793a\u5185\u5bb9\n\t\t\t\t * \u5b83\u6709\u4e24\u4e2a\u6309\u94ae\uff0c\u4e00\u4e2a\u786e\u8ba4\uff0c\u4e00\u4e2a\u53d6\u6d88\u3002\n\t\t\t\t * \u8fd4\u56detrue\u8868\u793a\u70b9\u51fb\u4e86\uff0c\u786e\u8ba4\uff0c\u8fd4\u56defalse\u8868\u793a\u70b9\u51fb\u53d6\u6d88\n\t\t\t\t *\/\n\t\t\t\treturn confirm(\"\u4f60\u786e\u5b9a\u8981\u5220\u9664\u3010\" + $(this).parent().parent().find(\"td:first\").text() + \"\u3011\uff1f\")\n\n\t\t\t\t\/\/return false\/\/ \u963b\u6b62\u5143\u7d20\u7684\u9ed8\u8ba4\u884c\u4e3a===\u4e0d\u63d0\u4ea4\u8bf7\u6c42\n\t\t\t})\n\n\t\t})\n\t<\/script>\n\n<\/head>\n<body>\n\t\n\t<div id=\"header\">\n\t\t\t<img class=\"logo_img\" alt=\"\" src=\"..\/..\/static\/img\/logo.gif\" >\n\t\t\t<span class=\"wel_word\">\u56fe\u4e66\u7ba1\u7406\u7cfb\u7edf<\/span>\n\n\t\t\t<%-- \u9759\u6001\u5305\u542b manager \u7ba1\u7406\u6a21\u5757\u7684\u83dc\u5355 --%>\n\t\t\t<%@include file=\"\/pages\/common\/manager_menu.jsp\"%>\n\n\t<\/div>\n\t\n\t<div id=\"main\">\n\t\t<table>\n\t\t\t<tr>\n\t\t\t\t<td>\u540d\u79f0<\/td>\n\t\t\t\t<td>\u4ef7\u683c<\/td>\n\t\t\t\t<td>\u4f5c\u8005<\/td>\n\t\t\t\t<td>\u9500\u91cf<\/td>\n\t\t\t\t<td>\u5e93\u5b58<\/td>\n\t\t\t\t<td colspan=\"2\">\u64cd\u4f5c<\/td>\n\t\t\t<\/tr>\n\n\t\t\t<c:forEach items=\"${requestScope.books}\" var=\"book\">\n\t\t\t\t<tr>\n\t\t\t\t\t<td>${book.name}<\/td>\n\t\t\t\t\t<td>${book.price}<\/td>\n\t\t\t\t\t<td>${book.author}<\/td>\n\t\t\t\t\t<td>${book.sales}<\/td>\n\t\t\t\t\t<td>${book.stock}<\/td>\n\t\t\t\t\t<td><a href=\"manager\/bookServlet?action=getBook&id=${book.id}\">\u4fee\u6539<\/a><\/td>\n\t\t\t\t\t<td><a class=\"deleteClass\" href=\"manager\/bookServlet?action=delete&id=${book.id}\">\u5220\u9664<\/a><\/td>\n\t\t\t\t<\/tr>\n\t\t\t<\/c:forEach>\n\n\t\t\t<tr>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><a href=\"pages\/manager\/book_edit.jsp\">\u6dfb\u52a0\u56fe\u4e66<\/a><\/td>\n\t\t\t<\/tr>\t\n\t\t<\/table>\n\t<\/div>\n\n\t<%-- \u9759\u6001\u5305\u542b\u9875\u811a\u5185\u5bb9 --%>\n\t<%@include file=\"\/pages\/common\/footer.jsp\"%>\n\n<\/body>\n<\/html><\/code><\/pre>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.4.5\u3001\u7ed9\u5220\u9664\u6dfb\u52a0\u786e\u8ba4\u63d0\u793a\u64cd\u4f5c\uff1a<\/p>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.5\u3001\u4fee\u6539\u56fe\u4e66\u529f\u80fd\u7684\u5b9e\u73b0<\/h3>\n\n\n\n
1.5.5.1\uff1a\u56fe\u89e3\u4fee\u6539\u56fe\u4e66\u7ec6\u8282\uff1a<\/p>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.5.2\u3001\u66f4\u65b0\u3010\u4fee\u6539\u3011\u7684\u8bf7\u6c42\u5730\u5740\uff1a<\/p>\n\n\n\n
book_manager.jsp<\/p>\n\n\n\n
<%@ taglib prefix=\"c\" uri=\"http:\/\/java.sun.com\/jsp\/jstl\/core\" %>\n<%@ page contentType=\"text\/html;charset=UTF-8\" language=\"java\" %>\n<!DOCTYPE html>\n<html>\n<head>\n<meta charset=\"UTF-8\">\n<title>\u56fe\u4e66\u7ba1\u7406<\/title>\n\n\t<%-- \u9759\u6001\u5305\u542b base\u6807\u7b7e\uff0ccss\u6837\u5f0f\uff0cjQuery\u6587\u4ef6 --%>\n\t<%@ include file=\"\/pages\/common\/head.jsp\"%>\n\t<script type=\"text\/javascript\">\n\t\t$(function () {\n\t\t\t\/\/ \u7ed9\u5220\u9664\u7684a\u6807\u7b7e\u7ed1\u5b9a\u5355\u51fb\u4e8b\u4ef6\uff0c\u7528\u4e8e\u5220\u9664\u7684\u786e\u8ba4\u63d0\u793a\u64cd\u4f5c\n\t\t\t$(\"a.deleteClass\").click(function () {\n\t\t\t\t\/\/\u5728\u4e8b\u4ef6\u7684function\u51fd\u6570\u4e2d\uff0c\u6709\u4e00\u4e2athis\u5bf9\u8c61\u3002\u8fd9\u4e2athis\u5bf9\u8c61\uff0c\u662f\u5f53\u524d\u6b63\u5728\u54cd\u5e94\u4e8b\u4ef6\u7684dom\u5bf9\u8c61\u3002\n\n\t\t\t\t\/**\n\t\t\t\t * confirm\u662f\u786e\u8ba4\u63d0\u793a\u6846\u51fd\u6570\n\t\t\t\t * \u53c2\u6570\u662f\u5b83\u7684\u63d0\u793a\u5185\u5bb9\n\t\t\t\t * \u5b83\u6709\u4e24\u4e2a\u6309\u94ae\uff0c\u4e00\u4e2a\u786e\u8ba4\uff0c\u4e00\u4e2a\u53d6\u6d88\u3002\n\t\t\t\t * \u8fd4\u56detrue\u8868\u793a\u70b9\u51fb\u4e86\uff0c\u786e\u8ba4\uff0c\u8fd4\u56defalse\u8868\u793a\u70b9\u51fb\u53d6\u6d88\n\t\t\t\t *\/\n\t\t\t\treturn confirm(\"\u4f60\u786e\u5b9a\u8981\u5220\u9664\u3010\" + $(this).parent().parent().find(\"td:first\").text() + \"\u3011\uff1f\")\n\n\t\t\t\t\/\/return false\/\/ \u963b\u6b62\u5143\u7d20\u7684\u9ed8\u8ba4\u884c\u4e3a===\u4e0d\u63d0\u4ea4\u8bf7\u6c42\n\t\t\t})\n\n\t\t})\n\t<\/script>\n\n<\/head>\n<body>\n\t\n\t<div id=\"header\">\n\t\t\t<img class=\"logo_img\" alt=\"\" src=\"..\/..\/static\/img\/logo.gif\" >\n\t\t\t<span class=\"wel_word\">\u56fe\u4e66\u7ba1\u7406\u7cfb\u7edf<\/span>\n\n\t\t\t<%-- \u9759\u6001\u5305\u542b manager \u7ba1\u7406\u6a21\u5757\u7684\u83dc\u5355 --%>\n\t\t\t<%@include file=\"\/pages\/common\/manager_menu.jsp\"%>\n\n\t<\/div>\n\t\n\t<div id=\"main\">\n\t\t<table>\n\t\t\t<tr>\n\t\t\t\t<td>\u540d\u79f0<\/td>\n\t\t\t\t<td>\u4ef7\u683c<\/td>\n\t\t\t\t<td>\u4f5c\u8005<\/td>\n\t\t\t\t<td>\u9500\u91cf<\/td>\n\t\t\t\t<td>\u5e93\u5b58<\/td>\n\t\t\t\t<td colspan=\"2\">\u64cd\u4f5c<\/td>\n\t\t\t<\/tr>\n\n\t\t\t<c:forEach items=\"${requestScope.books}\" var=\"book\">\n\t\t\t\t<tr>\n\t\t\t\t\t<td>${book.name}<\/td>\n\t\t\t\t\t<td>${book.price}<\/td>\n\t\t\t\t\t<td>${book.author}<\/td>\n\t\t\t\t\t<td>${book.sales}<\/td>\n\t\t\t\t\t<td>${book.stock}<\/td>\n\t\t\t\t\t<td><a href=\"manager\/bookServlet?action=getBook&id=${book.id}\">\u4fee\u6539<\/a><\/td>\n\t\t\t\t\t<td><a class=\"deleteClass\" href=\"manager\/bookServlet?action=delete&id=${book.id}\">\u5220\u9664<\/a><\/td>\n\t\t\t\t<\/tr>\n\t\t\t<\/c:forEach>\n\n\t\t\t<tr>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><a href=\"pages\/manager\/book_edit.jsp\">\u6dfb\u52a0\u56fe\u4e66<\/a><\/td>\n\t\t\t<\/tr>\t\n\t\t<\/table>\n\t<\/div>\n\n\t<%-- \u9759\u6001\u5305\u542b\u9875\u811a\u5185\u5bb9 --%>\n\t<%@include file=\"\/pages\/common\/footer.jsp\"%>\n\n<\/body>\n<\/html><\/code><\/pre>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.5.3\u3001BookServlet \u7a0b\u5e8f\u4e2d\u6dfb\u52a0 getBook \u65b9\u6cd5\uff1a<\/p>\n\n\n\n
package top.qaqaq.web;\n\nimport jakarta.servlet.ServletException;\nimport jakarta.servlet.http.HttpServletRequest;\nimport jakarta.servlet.http.HttpServletResponse;\nimport top.qaqaq.pojo.Book;\nimport top.qaqaq.service.BookService;\nimport top.qaqaq.service.impl.BookServiceImpl;\nimport top.qaqaq.utils.WebUtils;\n\nimport java.io.IOException;\nimport java.util.List;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-10 \u4e0b\u5348 7:51\n *\/\npublic class BookServlet extends BaseServlet {\n\n private BookService bookService = new BookServiceImpl();\n\n \/**\n * \u8d1f\u8d23\u6dfb\u52a0\u56fe\u4e66\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void add(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570==\u5c01\u88c5\u6210\u4e3aBook\u5bf9\u8c61\n Book book = WebUtils.copyParamToBean(req.getParameterMap(), new Book());\n \/\/ 2. \u8c03\u7528BookService.addBook()\u4fdd\u5b58\u56fe\u4e66\n bookService.addBook(book);\n \/\/ 3. \u8df3\u5230\u56fe\u4e66\u5217\u8868\u9875\u9762\n \/\/ \/manager\/bookServlet?action=list\n\n \/\/ \u5982\u679c\u4f7f\u7528\u8bf7\u6c42\u8f6c\u53d1\uff0c\u5219\u4e3a\u4e00\u6b21\u8bf7\u6c42\uff0c\u5237\u65b0\u4f1a\u91cd\u590d\u63d0\u4ea4\u6570\u636e\n\/\/ req.getRequestDispatcher(\"\/manager\/bookServlet?action=list\").forward(req,resp);\n \/\/ \u6240\u4ee5\u4f7f\u7528\u8bf7\u6c42\u91cd\u5b9a\u5411\n resp.sendRedirect(req.getContextPath() + \"\/manager\/bookServlet?action=list\");\n\n }\n\n \/**\n * \u8d1f\u8d23\u5220\u9664\u56fe\u4e66\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void delete(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570id\uff0c\u56fe\u4e66\u7f16\u7a0b\n int id = WebUtils.parseInt(req.getParameter(\"id\"),0);\n\n \/\/ 2. \u8c03\u7528bookService.deleteBookById();\u5220\u9664\u56fe\u4e66\n bookService.deleteBookById(id);\n \/\/ 3. \u91cd\u5b9a\u5411\u56de\u56fe\u4e66\u5217\u8868\u7ba1\u7406\u9875\u9762\n \/\/ \/book\/manager\/bookServlet?action=list\n resp.sendRedirect(req.getContextPath() + \"\/manager\/bookServlet?action=list\");\n }\n\n \/**\n * \u4fdd\u5b58\u4fee\u6539\u56fe\u4e66\u7684\u64cd\u4f5c\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void update(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570==\u5c01\u88c5\u6210\u4e3aBook\u5bf9\u8c61\n Book book = WebUtils.copyParamToBean(req.getParameterMap(), new Book());\n \/\/ 2. \u8c03\u7528BookService.updateBook( book );\u4fee\u6539\u56fe\u4e66\n bookService.updateBook(book);\n \/\/ 3. \u91cd\u5b9a\u5411\u56de\u56fe\u4e66\u5217\u8868\u7ba1\u7406\u9875\u9762\n \/\/ \u5730\u5740\uff1a\/\u5de5\u7a0b\u540d\/manager\/bookServlet?action=list\n resp.sendRedirect(req.getContextPath() + \"\/manager\/bookServlet?action=list\");\n\n }\n\n \/**\n * \u83b7\u53d6\u8981\u4fee\u6539\u7684\u56fe\u4e66\u4fe1\u606f\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void getBook(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570\u56fe\u4e66\u7f16\u53f7\n int id = WebUtils.parseInt(req.getParameter(\"id\"),0);\n \/\/ 2. \u8c03\u7528bookService.queryBookById\u67e5\u8be2\u56fe\u4e66\n Book book = bookService.queryBookById(id);\n \/\/ 3. \u4fdd\u5b58\u56fe\u4e66\u5230Request\u57df\u4e2d\n req.setAttribute(\"book\",book);\n \/\/ 4. \u8bf7\u6c42\u8f6c\u53d1\u5230\u3002pages\/manager\/book_edit.jsp\u9875\u9762\n req.getRequestDispatcher(\"\/pages\/manager\/book_edit.jsp\").forward(req,resp);\n }\n\n \/**\n * \u8d1f\u8d23\u904d\u5386\u56fe\u4e66\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void list(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u901a\u8fc7BookService\u67e5\u8be2\u5168\u90e8\u56fe\u4e66\n List<Book> books = bookService.queryBooks();\n \/\/ 2. \u628a\u5168\u90e8\u56fe\u4e66\u4fdd\u5b58\u5230Request\u57df\u4e2d\n req.setAttribute(\"books\", books);\n \/\/ 3. \u8bf7\u6c42\u8f6c\u53d1\u5230\/pages\/manager\/book_manager.jsp\u9875\u9762\n req.getRequestDispatcher(\"\/pages\/manager\/book_manager.jsp\").forward(req,resp);\n\n }\n}\n<\/code><\/pre>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.5.4\u3001\u5728 book_edit.jsp \u9875\u9762\u4e2d\u663e\u793a\u4fee\u6539\u7684\u6570\u636e<\/p>\n\n\n\n
<%@ page contentType=\"text\/html;charset=UTF-8\" language=\"java\" %>\n<!DOCTYPE html>\n<html>\n<head>\n<meta charset=\"UTF-8\">\n<title>\u7f16\u8f91\u56fe\u4e66<\/title>\n\n\t<%-- \u9759\u6001\u5305\u542b base\u6807\u7b7e\uff0ccss\u6837\u5f0f\uff0cjQuery\u6587\u4ef6 --%>\n\t<%@ include file=\"\/pages\/common\/head.jsp\"%>\n\n\t<style type=\"text\/css\">\n\th1 {\n\t\ttext-align: center;\n\t\tmargin-top: 200px;\n\t}\n\t\n\th1 a {\n\t\tcolor:red;\n\t}\n\t\n\tinput {\n\t\ttext-align: center;\n\t}\n<\/style>\n<\/head>\n<body>\n<!--\n\t\u9047\u5230\u7684\u95ee\u9898\uff1a\n\tbook_edit.jsp\u9875\u9762\uff0c\u65e2\u8981\u505a\u6dfb\u52a0\u64cd\u4f5c\u3002\u53c8\u8981\u505a\u4fee\u6539\u64cd\u4f5c\uff0c\u800c\u5230\u5e95\u662f\u6dfb\u52a0\uff0c\u8fd8\u662f\u4fee\u6539\u662f\u7531\u4e00\u4e2a\u9690\u85cf\u57df\u6765\u51b3\u5b9a\u7684\u3002\n\t\u5982\u4f55\u52a8\u6001\u4fee\u6539\u9690\u85cf\u57df<input type=\"hidden\" name=\"action\" value=\"xxx\" \/> \u8ba9\u5b83\u7684\u503c\u65e2\u53ef\u4ee5\u5b9e\u73b0\u6dfb\u52a0\uff0c\u53c8\u53ef\u4ee5\u5b9e\u73b0\u4fee\u6539\u64cd\u4f5c\uff1f\n\n\t\/\/\u65b9\u6848\u4e00\uff1a\n\t\u53ef\u4ee5\u5f53\u8bf7\u6c42\u53d1\u8d77\u65f6\uff0c\u9644\u5e26\u4e0a\u5f53\u524d\u8981\u64cd\u4f5c\u7684\u503c\u3002\u5e76\u6ce8\u5165\u5230\u9690\u85cf\u57df\u4e2d\u3002\n\n\t\/\/\u65b9\u6848\u4e8c\uff1a\n\t\u53ef\u4ee5\u901a\u8fc7\u5224\u65ad\u5f53\u524d\u8bf7\u6c42\u53c2\u6570\u4e2d\u662f\u5426\u5305\u542b\u6709id\u53c2\u6570\u3002\u5982\u679c\u6709\u8bf4\u660e\u662f\u4fee\u6539\u64cd\u4f5c\u3002\u5982\u679c\u6ca1\u6709\u8bf4\u660e\u662f\u6dfb\u52a0\u64cd\u4f5c\u3002\n\t\u662f\u5426\u662f\u6dfb\u52a0\u64cd\u4f5c\uff1a\n<%--\t${ empty param.id ? \"add\" : \"update\"}--%>\n\n\t\/\/\u65b9\u6848\u4e09\uff1a\n\t\u53ef\u4ee5\u901a\u8fc7\u5224\u65ad\uff0cRequest\u57df\u4e2d\u662f\u5426\u5305\u542b\u6709\u4fee\u6539\u7684\u56fe\u4e66\u4fe1\u606f\u5bf9\u8c61\uff0c\u5982\u679c\u6ca1\u6709\u8bf4\u660e\u662f\u6dfb\u52a0\u64cd\u4f5c\u3002\u5982\u679c\u6709\u8bf4\u660e\u662f\u4fee\u6539\u64cd\u4f5c\u3002\n\t\u662f\u5426\u662f\u6dfb\u52a0\u64cd\u4f5c\uff1a\n<%--\t${ empty requestScope.book ? \"add\" : \"update\"}--%>\n-->\n\n\t\t<div id=\"header\">\n\t\t\t<img class=\"logo_img\" alt=\"\" src=\"..\/..\/static\/img\/logo.gif\" >\n\t\t\t<span class=\"wel_word\">\u7f16\u8f91\u56fe\u4e66<\/span>\n\n\t\t\t<%-- \u9759\u6001\u5305\u542b manager \u7ba1\u7406\u6a21\u5757\u7684\u83dc\u5355 --%>\n\t\t\t<%@include file=\"\/pages\/common\/manager_menu.jsp\"%>\n\n\t\t<\/div>\n\t\t\n\t\t<div id=\"main\">\n\t\t\t<form action=\"manager\/bookServlet\" method=\"get\">\n\t\t\t\t<input type=\"hidden\" name=\"action\" value=\"${ empty param.id ? \"add\" : \"update\"}\" \/>\n\t\t\t\t<input type=\"hidden\" name=\"id\" value=\"${requestScope.book.id}\" \/>\n\t\t\t\t<table>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td>\u540d\u79f0<\/td>\n\t\t\t\t\t\t<td>\u4ef7\u683c<\/td>\n\t\t\t\t\t\t<td>\u4f5c\u8005<\/td>\n\t\t\t\t\t\t<td>\u9500\u91cf<\/td>\n\t\t\t\t\t\t<td>\u5e93\u5b58<\/td>\n\t\t\t\t\t\t<td colspan=\"2\">\u64cd\u4f5c<\/td>\n\t\t\t\t\t<\/tr>\t\t\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td><input name=\"name\" type=\"text\" value=\"${requestScope.book.name}\"\/><\/td>\n\t\t\t\t\t\t<td><input name=\"price\" type=\"text\" value=\"${requestScope.book.price}\"\/><\/td>\n\t\t\t\t\t\t<td><input name=\"author\" type=\"text\" value=\"${requestScope.book.author}\"\/><\/td>\n\t\t\t\t\t\t<td><input name=\"sales\" type=\"text\" value=\"${requestScope.book.sales}\"\/><\/td>\n\t\t\t\t\t\t<td><input name=\"stock\" type=\"text\" value=\"${requestScope.book.stock}\"\/><\/td>\n\t\t\t\t\t\t<td><input type=\"submit\" value=\"\u63d0\u4ea4\"\/><\/td>\n\t\t\t\t\t<\/tr>\t\n\t\t\t\t<\/table>\n\t\t\t<\/form>\n\t\t\t\n\t\n\t\t<\/div>\n\n\t\t<%-- \u9759\u6001\u5305\u542b\u9875\u811a\u5185\u5bb9 --%>\n\t\t<%@include file=\"\/pages\/common\/footer.jsp\"%>\n\n<\/body>\n<\/html><\/code><\/pre>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.5.5\u3001\u5728 BookServlet \u7a0b\u5e8f\u4e2d\u6dfb\u52a0 update \u65b9\u6cd5\uff1a<\/p>\n\n\n\n
package top.qaqaq.web;\n\nimport jakarta.servlet.ServletException;\nimport jakarta.servlet.http.HttpServletRequest;\nimport jakarta.servlet.http.HttpServletResponse;\nimport top.qaqaq.pojo.Book;\nimport top.qaqaq.service.BookService;\nimport top.qaqaq.service.impl.BookServiceImpl;\nimport top.qaqaq.utils.WebUtils;\n\nimport java.io.IOException;\nimport java.util.List;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-10 \u4e0b\u5348 7:51\n *\/\npublic class BookServlet extends BaseServlet {\n\n private BookService bookService = new BookServiceImpl();\n\n \/**\n * \u8d1f\u8d23\u6dfb\u52a0\u56fe\u4e66\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void add(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570==\u5c01\u88c5\u6210\u4e3aBook\u5bf9\u8c61\n Book book = WebUtils.copyParamToBean(req.getParameterMap(), new Book());\n \/\/ 2. \u8c03\u7528BookService.addBook()\u4fdd\u5b58\u56fe\u4e66\n bookService.addBook(book);\n \/\/ 3. \u8df3\u5230\u56fe\u4e66\u5217\u8868\u9875\u9762\n \/\/ \/manager\/bookServlet?action=list\n\n \/\/ \u5982\u679c\u4f7f\u7528\u8bf7\u6c42\u8f6c\u53d1\uff0c\u5219\u4e3a\u4e00\u6b21\u8bf7\u6c42\uff0c\u5237\u65b0\u4f1a\u91cd\u590d\u63d0\u4ea4\u6570\u636e\n\/\/ req.getRequestDispatcher(\"\/manager\/bookServlet?action=list\").forward(req,resp);\n \/\/ \u6240\u4ee5\u4f7f\u7528\u8bf7\u6c42\u91cd\u5b9a\u5411\n resp.sendRedirect(req.getContextPath() + \"\/manager\/bookServlet?action=list\");\n\n }\n\n \/**\n * \u8d1f\u8d23\u5220\u9664\u56fe\u4e66\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void delete(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570id\uff0c\u56fe\u4e66\u7f16\u7a0b\n int id = WebUtils.parseInt(req.getParameter(\"id\"),0);\n\n \/\/ 2. \u8c03\u7528bookService.deleteBookById();\u5220\u9664\u56fe\u4e66\n bookService.deleteBookById(id);\n \/\/ 3. \u91cd\u5b9a\u5411\u56de\u56fe\u4e66\u5217\u8868\u7ba1\u7406\u9875\u9762\n \/\/ \/book\/manager\/bookServlet?action=list\n resp.sendRedirect(req.getContextPath() + \"\/manager\/bookServlet?action=list\");\n }\n\n \/**\n * \u4fdd\u5b58\u4fee\u6539\u56fe\u4e66\u7684\u64cd\u4f5c\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void update(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570==\u5c01\u88c5\u6210\u4e3aBook\u5bf9\u8c61\n Book book = WebUtils.copyParamToBean(req.getParameterMap(), new Book());\n \/\/ 2. \u8c03\u7528BookService.updateBook( book );\u4fee\u6539\u56fe\u4e66\n bookService.updateBook(book);\n \/\/ 3. \u91cd\u5b9a\u5411\u56de\u56fe\u4e66\u5217\u8868\u7ba1\u7406\u9875\u9762\n \/\/ \u5730\u5740\uff1a\/\u5de5\u7a0b\u540d\/manager\/bookServlet?action=list\n resp.sendRedirect(req.getContextPath() + \"\/manager\/bookServlet?action=list\");\n\n }\n\n \/**\n * \u83b7\u53d6\u8981\u4fee\u6539\u7684\u56fe\u4e66\u4fe1\u606f\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void getBook(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570\u56fe\u4e66\u7f16\u53f7\n int id = WebUtils.parseInt(req.getParameter(\"id\"),0);\n \/\/ 2. \u8c03\u7528bookService.queryBookById\u67e5\u8be2\u56fe\u4e66\n Book book = bookService.queryBookById(id);\n \/\/ 3. \u4fdd\u5b58\u56fe\u4e66\u5230Request\u57df\u4e2d\n req.setAttribute(\"book\",book);\n \/\/ 4. \u8bf7\u6c42\u8f6c\u53d1\u5230\u3002pages\/manager\/book_edit.jsp\u9875\u9762\n req.getRequestDispatcher(\"\/pages\/manager\/book_edit.jsp\").forward(req,resp);\n }\n\n \/**\n * \u8d1f\u8d23\u904d\u5386\u56fe\u4e66\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void list(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u901a\u8fc7BookService\u67e5\u8be2\u5168\u90e8\u56fe\u4e66\n List<Book> books = bookService.queryBooks();\n \/\/ 2. \u628a\u5168\u90e8\u56fe\u4e66\u4fdd\u5b58\u5230Request\u57df\u4e2d\n req.setAttribute(\"books\", books);\n \/\/ 3. \u8bf7\u6c42\u8f6c\u53d1\u5230\/pages\/manager\/book_manager.jsp\u9875\u9762\n req.getRequestDispatcher(\"\/pages\/manager\/book_manager.jsp\").forward(req,resp);\n\n }\n}\n<\/code><\/pre>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.5.6\u3001\u89e3\u51b3 book_edit.jsp \u9875\u9762\uff0c\u5373\u8981\u5b9e\u73b0\u6dfb\u52a0\uff0c\u53c8\u8981\u5b9e\u73b0\u4fee\u6539\u64cd\u4f5c\u3002<\/p>\n\n\n\n<\/div><\/figure>\n\n\n\nweb.xml<\/h2>\n\n\n\n<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<web-app xmlns=\"https:\/\/jakarta.ee\/xml\/ns\/jakartaee\"\n xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\"\n xsi:schemaLocation=\"https:\/\/jakarta.ee\/xml\/ns\/jakartaee https:\/\/jakarta.ee\/xml\/ns\/jakartaee\/web-app_5_0.xsd\"\n version=\"5.0\">\n\n<!-- <servlet>-->\n<!-- <servlet-name>RegistServlet<\/servlet-name>-->\n<!-- <servlet-class>top.qaqaq.web.RegistServlet<\/servlet-class>-->\n<!-- <\/servlet>-->\n<!-- <servlet-mapping>-->\n<!-- <servlet-name>RegistServlet<\/servlet-name>-->\n<!-- <url-pattern>\/registServlet<\/url-pattern>-->\n<!-- <\/servlet-mapping>-->\n\n<!-- <servlet>-->\n<!-- <servlet-name>LoginServlet<\/servlet-name>-->\n<!-- <servlet-class>top.qaqaq.web.LoginServlet<\/servlet-class>-->\n<!-- <\/servlet>-->\n<!-- <servlet-mapping>-->\n<!-- <servlet-name>LoginServlet<\/servlet-name>-->\n<!-- <url-pattern>\/loginServlet<\/url-pattern>-->\n<!-- <\/servlet-mapping>-->\n\n <servlet>\n <servlet-name>UserServlet<\/servlet-name>\n <servlet-class>top.qaqaq.web.UserServlet<\/servlet-class>\n <\/servlet>\n <servlet-mapping>\n <servlet-name>UserServlet<\/servlet-name>\n <url-pattern>\/userServlet<\/url-pattern>\n <\/servlet-mapping>\n\n <servlet>\n <servlet-name>BookServlet<\/servlet-name>\n <servlet-class>top.qaqaq.web.BookServlet<\/servlet-class>\n <\/servlet>\n <servlet-mapping>\n <servlet-name>BookServlet<\/servlet-name>\n <url-pattern>\/manager\/bookServlet<\/url-pattern>\n <\/servlet-mapping>\n\n<\/web-app><\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"\u4e66\u57ce\u9879\u76ee-\u7b2c\u4e94\u9636\u6bb5\uff1a\u5185\u5bb9\u4ecb\u7ecd\u3001\u4e66\u57ce\u9879\u76ee-MVC\u6982\u5ff5\u7684\u4ecb\u7ecd\u3001\u4e66\u57ce\u9879\u76ee-\u521b\u5efa\u56fe\u4e66\u6a21\u5757\u7684\u6570\u636e\u5e93\u8868\u3001\u4e66\u57ce\u9879\u76ee-\u7f16\u5199\u56fe\u4e66 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[59],"tags":[61],"class_list":["post-2459","post","type-post","status-publish","format-standard","hentry","category-javaweb-code","tag-javaweb"],"_links":{"self":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/2459"}],"collection":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2459"}],"version-history":[{"count":7,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/2459\/revisions"}],"predecessor-version":[{"id":2718,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/2459\/revisions\/2718"}],"wp:attachment":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2459"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2459"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2459"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
1.1\u3001\u7f16\u5199\u56fe\u4e66\u6a21\u5757\u7684\u6570\u636e\u5e93\u8868<\/h3>\n\n\n\n# P233 \u4e66\u57ce\u9879\u76ee-\u521b\u5efa\u56fe\u4e66\u6a21\u5757\u7684\u6570\u636e\u5e93\u8868\n\nCREATE TABLE t_book(\n id INT PRIMARY KEY AUTO_INCREMENT,\n name VARCHAR(100), #\u540d\u79f0\n price DECIMAL(11,2), #\u4ef7\u683c\n author VARCHAR(100), #\u4f5c\u8005\n sales INT, #\u9500\u91cf\n stock INT, #\u5e93\u5b58\n img_path VARCHAR(200) #\u56fe\u7247\n);\n\n# \u63d2\u5165\u521d\u59cb\u5316\u6d4b\u8bd5\u6570\u636e\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , 'java\u4ece\u5165\u95e8\u5230\u653e\u5f03' , '\u56fd\u54e5' , 80 , 9999 , 9 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , '\u6570\u636e\u7ed3\u6784\u4e0e\u7b97\u6cd5' , '\u4e25\u654f\u541b' , 78.5 , 6 , 13 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , '\u600e\u6837\u62d0\u8dd1\u522b\u4eba\u7684\u5ab3\u5987' , '\u9f99\u4f0d' , 68, 99999 , 52 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , '\u6728\u865a\u8089\u76d6\u996d' , '\u5c0f\u80d6' , 16, 1000 , 50 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , 'C++\u7f16\u7a0b\u601d\u60f3' , '\u521a\u54e5' , 45.5 , 14 , 95 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , '\u86cb\u7092\u996d' , '\u5468\u661f\u661f' , 9.9, 12 , 53 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , '\u8d4c\u795e' , '\u9f99\u4f0d' , 66.5, 125 , 535 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , 'Java\u7f16\u7a0b\u601d\u60f3' , '\u9633\u54e5' , 99.5 , 47 , 36 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , 'JavaScript\u4ece\u5165\u95e8\u5230\u7cbe\u901a' , '\u5a77\u59d0' , 9.9 , 85 , 95 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , 'cocos2d-x\u6e38\u620f\u7f16\u7a0b\u5165\u95e8' , '\u56fd\u54e5' , 49, 52 , 62 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , 'C\u8bed\u8a00\u7a0b\u5e8f\u8bbe\u8ba1' , '\u8c2d\u6d69\u5f3a' , 28 , 52 , 74 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , 'Lua\u8bed\u8a00\u7a0b\u5e8f\u8bbe\u8ba1' , '\u96f7\u4e30\u9633' , 51.5 , 48 , 82 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , '\u897f\u6e38\u8bb0' , '\u7f57\u8d2f\u4e2d' , 12, 19 , 9999 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , '\u6c34\u6d52\u4f20' , '\u534e\u4ed4' , 33.05 , 22 , 88 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , '\u64cd\u4f5c\u7cfb\u7edf\u539f\u7406' , '\u5218\u4f18' , 133.05 , 122 , 188 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , '\u6570\u636e\u7ed3\u6784 java\u7248' , '\u5c01\u5927\u795e' , 173.15 , 21 , 81 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , 'UNIX\u9ad8\u7ea7\u73af\u5883\u7f16\u7a0b' , '\u4e50\u5929' , 99.15 , 210 , 810 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , 'javaScript\u9ad8\u7ea7\u7f16\u7a0b' , '\u56fd\u54e5' , 69.15 , 210 , 810 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , '\u5927\u8bdd\u8bbe\u8ba1\u6a21\u5f0f' , '\u56fd\u54e5' , 89.15 , 20 , 10 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , '\u4eba\u6708\u795e\u8bdd' , '\u521a\u54e5' , 88.15 , 20 , 80 , 'static\/img\/default.jpg');\n\n# \u67e5\u770b\u8868\u5185\u5bb9\nselect id,name,author,price,sales,stock,img_path from t_book;\n<\/code><\/pre>\n\n\n\n1.2\u3001\u7f16\u5199\u56fe\u4e66\u6a21\u5757\u7684 JavaBean<\/h3>\n\n\n\npackage top.qaqaq.pojo;\n\nimport java.math.BigDecimal;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-10 \u4e0b\u5348 5:22\n *\/\npublic class Book {\n\n private Integer id;\n private String name; \/\/\u540d\u79f0\n private String author; \/\/\u4f5c\u8005\n private BigDecimal price; \/\/\u4ef7\u683c\n private Integer sales; \/\/\u9500\u91cf\n private Integer stock; \/\/\u5e93\u5b58\n private String imgpath = \"static\/img\/default.jpg\"; \/\/\u56fe\u7247\n\n public Book() {\n }\n\n public Book(Integer id, String name, String author, BigDecimal price, Integer sales, Integer stock, String imgpath) {\n this.id = id;\n this.name = name;\n this.author = author;\n this.price = price;\n this.sales = sales;\n this.stock = stock;\n \/\/ \u8981\u6c42\u7ed9\u5b9a\u7684\u56fe\u4e66\u5c01\u9762\u56fe\u4e66\u8def\u5f84\u4e0d\u80fd\u4e3a\u7a7a\n if (imgpath != null && !\"\".equals(imgpath)){\n this.imgpath = imgpath;\n }\n }\n\n public Integer getId() {\n return id;\n }\n\n public void setId(Integer id) {\n this.id = id;\n }\n\n public String getName() {\n return name;\n }\n\n public void setName(String name) {\n this.name = name;\n }\n\n public String getAuthor() {\n return author;\n }\n\n public void setAuthor(String author) {\n this.author = author;\n }\n\n public BigDecimal getPrice() {\n return price;\n }\n\n public void setPrice(BigDecimal price) {\n this.price = price;\n }\n\n public Integer getSales() {\n return sales;\n }\n\n public void setSales(Integer sales) {\n this.sales = sales;\n }\n\n public Integer getStock() {\n return stock;\n }\n\n public void setStock(Integer stock) {\n this.stock = stock;\n }\n\n public String getImgpath() {\n return imgpath;\n }\n\n public void setImgpath(String imgpath) {\n \/\/ \u8981\u6c42\u7ed9\u5b9a\u7684\u56fe\u4e66\u5c01\u9762\u56fe\u4e66\u8def\u5f84\u4e0d\u80fd\u4e3a\u7a7a\n if (imgpath != null && !\"\".equals(imgpath)){\n this.imgpath = imgpath;\n }\n }\n\n @Override\n public String toString() {\n return \"Book{\" +\n \"id=\" + id +\n \", name='\" + name + '\\'' +\n \", author='\" + author + '\\'' +\n \", price=\" + price +\n \", sales=\" + sales +\n \", stock=\" + stock +\n \", imgpath='\" + imgpath + '\\'' +\n '}';\n }\n}\n<\/code><\/pre>\n\n\n\n1.3\u3001\u7f16\u5199\u56fe\u4e66\u6a21\u5757\u7684 Dao \u548c\u6d4b\u8bd5 Dao<\/h3>\n\n\n\n
Dao \u63a5\u53e3<\/p>\n\n\n\n
package top.qaqaq.dao;\n\nimport top.qaqaq.pojo.Book;\n\nimport java.util.List;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-10 \u4e0b\u5348 5:36\n *\/\npublic interface BookDao {\n\n \/**\n * \u6dfb\u52a0\u56fe\u4e66\n * @param book\n * @return\n *\/\n public int addBook(Book book);\n\n \/**\n * \u6839\u636e\u56fe\u4e66id\u5220\u9664\u56fe\u4e66\n * @param id\n * @return\n *\/\n public int deleteBookById(Integer id);\n\n \/**\n * \u6839\u636e\u56fe\u4e66id\u66f4\u65b0\u56fe\u4e66\n * @param book\n * @return\n *\/\n public int updateBook(Book book);\n\n \/**\n * \u6839\u636e\u56fe\u4e66id\u67e5\u8be2\u56fe\u4e66\n * @param id\n * @return\n *\/\n public Book queryBookById(Integer id);\n\n \/**\n * \u67e5\u8be2\u5168\u90e8\u56fe\u4e66\n * @return\n *\/\n public List<Book> queryBooks();\n\n\n}\n<\/code><\/pre>\n\n\n\nBookDaoImpl \u5b9e\u73b0\u7c7b\uff1a<\/p>\n\n\n\n
package top.qaqaq.dao.impl;\n\nimport top.qaqaq.dao.BookDao;\nimport top.qaqaq.pojo.Book;\n\nimport java.util.List;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-10 \u4e0b\u5348 5:40\n *\/\npublic class BookDaoImpl extends BaseDao implements BookDao {\n @Override\n public int addBook(Book book) {\n\n String sql = \"insert into t_book(name,author,price,sales,stock,img_path) values(?,?,?,?,?,?)\";\n\n return update(sql, book.getName(), book.getAuthor(), book.getPrice(), book.getSales(), book.getStock(), book.getImgpath());\n }\n\n @Override\n public int deleteBookById(Integer id) {\n\n String sql = \"delete from t_book where id = ?\";\n\n return update(sql, id);\n }\n\n @Override\n public int updateBook(Book book) {\n\n String sql = \"update t_book set name=?,author=?,price=?,sales=?,stock=?,img_path=? where id = ?\";\n\n return update(sql, book.getName(), book.getAuthor(), book.getPrice(), book.getSales(), book.getStock(), book.getImgpath(), book.getId());\n }\n\n @Override\n public Book queryBookById(Integer id) {\n\n String sql = \"select id,name,author,price,sales,stock,img_path imgpath from t_book where id = ?\";\n\n return queryForOne(Book.class, sql, id);\n }\n\n @Override\n public List<Book> queryBooks() {\n\n String sql = \"select id,name,author,price,sales,stock,img_path imgpath from t_book\";\n\n return queryForList(Book.class, sql);\n }\n}\n<\/code><\/pre>\n\n\n\nBookDao \u7684\u6d4b\u8bd5\uff1a<\/p>\n\n\n\n
package top.qaqaq.test;\n\nimport org.junit.Test;\nimport top.qaqaq.dao.BookDao;\nimport top.qaqaq.dao.impl.BookDaoImpl;\nimport top.qaqaq.pojo.Book;\n\nimport java.math.BigDecimal;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-10 \u4e0b\u5348 5:54\n *\/\npublic class BookDaoTest {\n\n private BookDao bookDao = new BookDaoImpl();\n\n @Test\n public void addBook() {\n bookDao.addBook(new Book(null,\"\u6211\u4e3a\u4ec0\u4e48\u8fd9\u4e48\u5e05\uff01\",\"191125\",new BigDecimal(9999),1100000,0,null));\n }\n\n @Test\n public void deleteBookById() {\n bookDao.deleteBookById(21);\n }\n\n @Test\n public void updateBook() {\n bookDao.updateBook(new Book(21,\"\u5927\u5bb6\u90fd\u53ef\u4ee5\u8fd9\u4e48\u5e05\uff01\",\"\u81ea\u5df1\",new BigDecimal(9999),1100000,0,null));\n }\n\n @Test\n public void queryBookById() {\n System.out.println(bookDao.queryBookById(21));\n }\n\n @Test\n public void queryBooks() {\n bookDao.queryBooks().forEach(System.out::println);\n }\n}<\/code><\/pre>\n\n\n\n1.4\u3001\u7f16\u5199\u56fe\u4e66\u6a21\u5757\u7684 Service \u548c\u6d4b\u8bd5 Service<\/h3>\n\n\n\n
BookService \u63a5\u53e3<\/p>\n\n\n\n
package top.qaqaq.service;\n\nimport top.qaqaq.pojo.Book;\n\nimport java.util.List;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-10 \u4e0b\u5348 7:37\n *\/\npublic interface BookService {\n\n \/**\n * \u6dfb\u52a0\u56fe\u4e66\n * @param book\n *\/\n public void addBook(Book book);\n\n \/**\n * \u6839\u636e\u56fe\u4e66id\u5220\u9664\u56fe\u4e66\n * @param id\n *\/\n public void deleteBookById(Integer id);\n\n \/**\n * \u6839\u636e\u56fe\u4e66id\u66f4\u65b0\u56fe\u4e66\n * @param book\n *\/\n public void updateBook(Book book);\n\n \/**\n * \u6839\u636e\u56fe\u4e66id\u67e5\u8be2\u56fe\u4e66\n * @param id\n * @return\n *\/\n public Book queryBookById(Integer id);\n\n \/**\n * \u67e5\u8be2\u5168\u90e8\u56fe\u4e66\n * @return\n *\/\n public List<Book> queryBooks();\n}\n<\/code><\/pre>\n\n\n\nBookServiceImpl \u5b9e\u73b0\u7c7b\uff1a<\/p>\n\n\n\n
package top.qaqaq.service.impl;\n\nimport top.qaqaq.dao.BookDao;\nimport top.qaqaq.dao.impl.BookDaoImpl;\nimport top.qaqaq.pojo.Book;\nimport top.qaqaq.service.BookService;\n\nimport java.util.List;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-10 \u4e0b\u5348 7:42\n *\/\npublic class BookServiceImpl implements BookService {\n\n private BookDao bookDao = new BookDaoImpl();\n\n @Override\n public void addBook(Book book) {\n bookDao.addBook(book);\n }\n\n @Override\n public void deleteBookById(Integer id) {\n bookDao.deleteBookById(id);\n }\n\n @Override\n public void updateBook(Book book) {\n bookDao.updateBook(book);\n }\n\n @Override\n public Book queryBookById(Integer id) {\n return bookDao.queryBookById(id);\n }\n\n @Override\n public List<Book> queryBooks() {\n return bookDao.queryBooks();\n }\n}\n<\/code><\/pre>\n\n\n\nBookService \u7684\u6d4b\u8bd5\uff1a<\/p>\n\n\n\n
package top.qaqaq.test;\n\nimport org.junit.Test;\nimport top.qaqaq.pojo.Book;\nimport top.qaqaq.service.BookService;\nimport top.qaqaq.service.impl.BookServiceImpl;\n\nimport java.math.BigDecimal;\n\nimport static org.junit.Assert.*;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-10 \u4e0b\u5348 7:45\n *\/\npublic class BookServiceTest {\n\n private BookService bookService = new BookServiceImpl();\n\n @Test\n public void addBook() {\n bookService.addBook(new Book(null,\"\u4f60\u597d\u6211\u597d\u5927\u5bb6\u597d\",\"1125\",new BigDecimal(100000),10000000,0,null));\n }\n\n @Test\n public void deleteBookById() {\n bookService.deleteBookById(22);\n }\n\n @Test\n public void updateBook() {\n bookService.updateBook(new Book(22,\"\u5927\u5bb6\u597d\",\"1125\",new BigDecimal(999999),10,1000000,null));\n }\n\n @Test\n public void queryBookById() {\n System.out.println(bookService.queryBookById(22));\n }\n\n @Test\n public void queryBooks() {\n bookService.queryBooks().forEach(System.out::println);\n }\n}<\/code><\/pre>\n\n\n\n1.5\u3001\u7f16\u5199\u56fe\u4e66\u6a21\u5757\u7684 Web \u5c42\uff0c\u548c\u9875\u9762\u8054\u8c03\u6d4b\u8bd5<\/h3>\n\n\n\n1.5.1\u3001\u56fe\u4e66\u5217\u8868\u529f\u80fd\u7684\u5b9e\u73b0<\/h4>\n\n\n\n
1\u3001\u56fe\u89e3\u5217\u8868\u529f\u80fd\u6d41\u7a0b\uff1a<\/p>\n\n\n\n<\/div><\/figure>\n\n\n\n2\u3001BookServlet \u7a0b\u5e8f\u4e2d\u6dfb\u52a0 list \u65b9\u6cd5<\/p>\n\n\n\n
package top.qaqaq.web;\n\nimport jakarta.servlet.ServletException;\nimport jakarta.servlet.http.HttpServletRequest;\nimport jakarta.servlet.http.HttpServletResponse;\nimport top.qaqaq.pojo.Book;\nimport top.qaqaq.service.BookService;\nimport top.qaqaq.service.impl.BookServiceImpl;\n\nimport java.io.IOException;\nimport java.util.List;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-10 \u4e0b\u5348 7:51\n *\/\npublic class BookServlet extends BaseServlet {\n\n private BookService bookService = new BookServiceImpl();\n\n protected void add(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n }\n\n protected void delete(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n }\n\n protected void update(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n }\n\n protected void list(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u901a\u8fc7BookService\u67e5\u8be2\u5168\u90e8\u56fe\u4e66\n List<Book> books = bookService.queryBooks();\n \/\/ 2. \u628a\u5168\u90e8\u56fe\u4e66\u4fdd\u5b58\u5230Request\u57df\u4e2d\n req.setAttribute(\"books\", books);\n \/\/ 3. \u8bf7\u6c42\u8f6c\u53d1\u5230\/pages\/manager\/book_manager.jsp\u9875\u9762\n req.getRequestDispatcher(\"\/pages\/manager\/book_manager.jsp\").forward(req,resp);\n\n }\n}\n<\/code><\/pre>\n\n\n\n3\u3001\u4fee\u6539\u3010\u56fe\u4e66\u7ba1\u7406\u3011\u8bf7\u6c42\u5730\u5740<\/p>\n\n\n\n
<%--\n Created by IntelliJ IDEA.\n User: ZRich\n Date: 2022\/12\/9\n Time: \u4e0b\u5348 5:33\n To change this template use File | Settings | File Templates.\n--%>\n<%@ page contentType=\"text\/html;charset=UTF-8\" language=\"java\" %>\n\n<div>\n <%-- action=list\u8868\u793a\u8c03\u7528BookServlet.java\u91cc\u7684list\u65b9\u6cd5 --%>\n <a href=\"manager\/bookServlet?action=list\">\u56fe\u4e66\u7ba1\u7406<\/a>\n <a href=\"pages\/manager\/order_manager.jsp\">\u8ba2\u5355\u7ba1\u7406<\/a>\n <a href=\"index.jsp\">\u8fd4\u56de\u5546\u57ce<\/a>\n<\/div>\n<\/code><\/pre>\n\n\n\n4\u3001\u4fee\u6539 pages\/manager\/book_manager.jsp \u9875\u9762\u7684\u6570\u636e\u904d\u5386\u8f93\u51fa<\/p>\n\n\n\n
<%@ taglib prefix=\"c\" uri=\"http:\/\/java.sun.com\/jsp\/jstl\/core\" %>\n<%@ page contentType=\"text\/html;charset=UTF-8\" language=\"java\" %>\n<!DOCTYPE html>\n<html>\n<head>\n<meta charset=\"UTF-8\">\n<title>\u56fe\u4e66\u7ba1\u7406<\/title>\n\n\t<%-- \u9759\u6001\u5305\u542b base\u6807\u7b7e\uff0ccss\u6837\u5f0f\uff0cjQuery\u6587\u4ef6 --%>\n\t<%@ include file=\"\/pages\/common\/head.jsp\"%>\n\n<\/head>\n<body>\n\t\n\t<div id=\"header\">\n\t\t\t<img class=\"logo_img\" alt=\"\" src=\"..\/..\/static\/img\/logo.gif\" >\n\t\t\t<span class=\"wel_word\">\u56fe\u4e66\u7ba1\u7406\u7cfb\u7edf<\/span>\n\n\t\t\t<%-- \u9759\u6001\u5305\u542b manager \u7ba1\u7406\u6a21\u5757\u7684\u83dc\u5355 --%>\n\t\t\t<%@include file=\"\/pages\/common\/manager_menu.jsp\"%>\n\n\t<\/div>\n\t\n\t<div id=\"main\">\n\t\t<table>\n\t\t\t<tr>\n\t\t\t\t<td>\u540d\u79f0<\/td>\n\t\t\t\t<td>\u4ef7\u683c<\/td>\n\t\t\t\t<td>\u4f5c\u8005<\/td>\n\t\t\t\t<td>\u9500\u91cf<\/td>\n\t\t\t\t<td>\u5e93\u5b58<\/td>\n\t\t\t\t<td colspan=\"2\">\u64cd\u4f5c<\/td>\n\t\t\t<\/tr>\n\n\t\t\t<c:forEach items=\"${requestScope.books}\" var=\"book\">\n\t\t\t\t<tr>\n\t\t\t\t\t<td>${book.name}<\/td>\n\t\t\t\t\t<td>${book.price}<\/td>\n\t\t\t\t\t<td>${book.author}<\/td>\n\t\t\t\t\t<td>${book.sales}<\/td>\n\t\t\t\t\t<td>${book.stock}<\/td>\n\t\t\t\t\t<td><a href=\"book_edit.jsp\">\u4fee\u6539<\/a><\/td>\n\t\t\t\t\t<td><a href=\"#\">\u5220\u9664<\/a><\/td>\n\t\t\t\t<\/tr>\n\t\t\t<\/c:forEach>\n\n\t\t\t<tr>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><a href=\"book_edit.jsp\">\u6dfb\u52a0\u56fe\u4e66<\/a><\/td>\n\t\t\t<\/tr>\t\n\t\t<\/table>\n\t<\/div>\n\n\t<%-- \u9759\u6001\u5305\u542b\u9875\u811a\u5185\u5bb9 --%>\n\t<%@include file=\"\/pages\/common\/footer.jsp\"%>\n\n<\/body>\n<\/html><\/code><\/pre>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.2\u3001\u524d\u540e\u53f0\u7684\u7b80\u5355\u4ecb\u7ecd<\/h4>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.3\u3001\u6dfb\u52a0\u56fe\u4e66\u529f\u80fd\u7684\u5b9e\u73b0<\/h4>\n\n\n\n
1.5.3.1\u3001\u6dfb\u52a0\u56fe\u4e66\u6d41\u7a0b\u7ec6\u8282\uff1a<\/p>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.3.2\u3001\u95ee\u9898\u8bf4\u660e\uff1a\u8868\u5355\u91cd\u590d\u63d0\u4ea4\uff1a<\/p>\n\n\n\n
\u5f53\u7528\u6237\u63d0\u4ea4\u5b8c\u8bf7\u6c42\uff0c\u6d4f\u89c8\u5668\u4f1a\u8bb0\u5f55\u4e0b\u6700\u540e\u4e00\u6b21\u8bf7\u6c42\u7684\u5168\u90e8\u4fe1\u606f\u3002\u5f53\u7528\u6237\u6309\u4e0b\u529f\u80fd\u952e F5\uff0c\u5c31\u4f1a\u53d1\u8d77\u6d4f\u89c8\u5668\u8bb0\u5f55\u7684\u6700\u540e\u4e00\u6b21\u8bf7\u6c42\u3002<\/p>\n\n\n\n
1.5.3.3\u3001BookServlet \u7a0b\u5e8f\u4e2d\u6dfb\u52a0 add \u65b9\u6cd5<\/p>\n\n\n\n
package top.qaqaq.web;\n\nimport jakarta.servlet.ServletException;\nimport jakarta.servlet.http.HttpServletRequest;\nimport jakarta.servlet.http.HttpServletResponse;\nimport top.qaqaq.pojo.Book;\nimport top.qaqaq.service.BookService;\nimport top.qaqaq.service.impl.BookServiceImpl;\nimport top.qaqaq.utils.WebUtils;\n\nimport java.io.IOException;\nimport java.util.List;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-10 \u4e0b\u5348 7:51\n *\/\npublic class BookServlet extends BaseServlet {\n\n private BookService bookService = new BookServiceImpl();\n\n \/**\n * \u8d1f\u8d23\u6dfb\u52a0\u56fe\u4e66\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void add(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570==\u5c01\u88c5\u6210\u4e3aBook\u5bf9\u8c61\n Book book = WebUtils.copyParamToBean(req.getParameterMap(), new Book());\n \/\/ 2. \u8c03\u7528BookService.addBook()\u4fdd\u5b58\u56fe\u4e66\n bookService.addBook(book);\n \/\/ 3. \u8df3\u5230\u56fe\u4e66\u5217\u8868\u9875\u9762\n \/\/ \/manager\/bookServlet?action=list\n\n \/\/ \u5982\u679c\u4f7f\u7528\u8bf7\u6c42\u8f6c\u53d1\uff0c\u5219\u4e3a\u4e00\u6b21\u8bf7\u6c42\uff0c\u5237\u65b0\u4f1a\u91cd\u590d\u63d0\u4ea4\u6570\u636e\n\/\/ req.getRequestDispatcher(\"\/manager\/bookServlet?action=list\").forward(req,resp);\n \/\/ \u6240\u4ee5\u4f7f\u7528\u8bf7\u6c42\u91cd\u5b9a\u5411\n resp.sendRedirect(req.getContextPath() + \"\/manager\/bookServlet?action=list\");\n\n }\n\n \/**\n * \u8d1f\u8d23\u5220\u9664\u56fe\u4e66\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void delete(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570id\uff0c\u56fe\u4e66\u7f16\u7a0b\n int id = WebUtils.parseInt(req.getParameter(\"id\"),0);\n\n \/\/ 2. \u8c03\u7528bookService.deleteBookById();\u5220\u9664\u56fe\u4e66\n bookService.deleteBookById(id);\n \/\/ 3. \u91cd\u5b9a\u5411\u56de\u56fe\u4e66\u5217\u8868\u7ba1\u7406\u9875\u9762\n \/\/ \/book\/manager\/bookServlet?action=list\n resp.sendRedirect(req.getContextPath() + \"\/manager\/bookServlet?action=list\");\n }\n\n \/**\n * \u4fdd\u5b58\u4fee\u6539\u56fe\u4e66\u7684\u64cd\u4f5c\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void update(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570==\u5c01\u88c5\u6210\u4e3aBook\u5bf9\u8c61\n Book book = WebUtils.copyParamToBean(req.getParameterMap(), new Book());\n \/\/ 2. \u8c03\u7528BookService.updateBook( book );\u4fee\u6539\u56fe\u4e66\n bookService.updateBook(book);\n \/\/ 3. \u91cd\u5b9a\u5411\u56de\u56fe\u4e66\u5217\u8868\u7ba1\u7406\u9875\u9762\n \/\/ \u5730\u5740\uff1a\/\u5de5\u7a0b\u540d\/manager\/bookServlet?action=list\n resp.sendRedirect(req.getContextPath() + \"\/manager\/bookServlet?action=list\");\n\n }\n\n \/**\n * \u83b7\u53d6\u8981\u4fee\u6539\u7684\u56fe\u4e66\u4fe1\u606f\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void getBook(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570\u56fe\u4e66\u7f16\u53f7\n int id = WebUtils.parseInt(req.getParameter(\"id\"),0);\n \/\/ 2. \u8c03\u7528bookService.queryBookById\u67e5\u8be2\u56fe\u4e66\n Book book = bookService.queryBookById(id);\n \/\/ 3. \u4fdd\u5b58\u56fe\u4e66\u5230Request\u57df\u4e2d\n req.setAttribute(\"book\",book);\n \/\/ 4. \u8bf7\u6c42\u8f6c\u53d1\u5230\u3002pages\/manager\/book_edit.jsp\u9875\u9762\n req.getRequestDispatcher(\"\/pages\/manager\/book_edit.jsp\").forward(req,resp);\n }\n\n \/**\n * \u8d1f\u8d23\u904d\u5386\u56fe\u4e66\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void list(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u901a\u8fc7BookService\u67e5\u8be2\u5168\u90e8\u56fe\u4e66\n List<Book> books = bookService.queryBooks();\n \/\/ 2. \u628a\u5168\u90e8\u56fe\u4e66\u4fdd\u5b58\u5230Request\u57df\u4e2d\n req.setAttribute(\"books\", books);\n \/\/ 3. \u8bf7\u6c42\u8f6c\u53d1\u5230\/pages\/manager\/book_manager.jsp\u9875\u9762\n req.getRequestDispatcher(\"\/pages\/manager\/book_manager.jsp\").forward(req,resp);\n\n }\n}\n<\/code><\/pre>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.3.4\u3001\u4fee\u6539 book_edit.jsp \u9875\u9762<\/p>\n\n\n\n
<%@ page contentType=\"text\/html;charset=UTF-8\" language=\"java\" %>\n<!DOCTYPE html>\n<html>\n<head>\n<meta charset=\"UTF-8\">\n<title>\u7f16\u8f91\u56fe\u4e66<\/title>\n\n\t<%-- \u9759\u6001\u5305\u542b base\u6807\u7b7e\uff0ccss\u6837\u5f0f\uff0cjQuery\u6587\u4ef6 --%>\n\t<%@ include file=\"\/pages\/common\/head.jsp\"%>\n\n\t<style type=\"text\/css\">\n\th1 {\n\t\ttext-align: center;\n\t\tmargin-top: 200px;\n\t}\n\t\n\th1 a {\n\t\tcolor:red;\n\t}\n\t\n\tinput {\n\t\ttext-align: center;\n\t}\n<\/style>\n<\/head>\n<body>\n<!--\n\t\u9047\u5230\u7684\u95ee\u9898\uff1a\n\tbook_edit.jsp\u9875\u9762\uff0c\u65e2\u8981\u505a\u6dfb\u52a0\u64cd\u4f5c\u3002\u53c8\u8981\u505a\u4fee\u6539\u64cd\u4f5c\uff0c\u800c\u5230\u5e95\u662f\u6dfb\u52a0\uff0c\u8fd8\u662f\u4fee\u6539\u662f\u7531\u4e00\u4e2a\u9690\u85cf\u57df\u6765\u51b3\u5b9a\u7684\u3002\n\t\u5982\u4f55\u52a8\u6001\u4fee\u6539\u9690\u85cf\u57df<input type=\"hidden\" name=\"action\" value=\"xxx\" \/> \u8ba9\u5b83\u7684\u503c\u65e2\u53ef\u4ee5\u5b9e\u73b0\u6dfb\u52a0\uff0c\u53c8\u53ef\u4ee5\u5b9e\u73b0\u4fee\u6539\u64cd\u4f5c\uff1f\n\n\t\/\/\u65b9\u6848\u4e00\uff1a\n\t\u53ef\u4ee5\u5f53\u8bf7\u6c42\u53d1\u8d77\u65f6\uff0c\u9644\u5e26\u4e0a\u5f53\u524d\u8981\u64cd\u4f5c\u7684\u503c\u3002\u5e76\u6ce8\u5165\u5230\u9690\u85cf\u57df\u4e2d\u3002\n\n\t\/\/\u65b9\u6848\u4e8c\uff1a\n\t\u53ef\u4ee5\u901a\u8fc7\u5224\u65ad\u5f53\u524d\u8bf7\u6c42\u53c2\u6570\u4e2d\u662f\u5426\u5305\u542b\u6709id\u53c2\u6570\u3002\u5982\u679c\u6709\u8bf4\u660e\u662f\u4fee\u6539\u64cd\u4f5c\u3002\u5982\u679c\u6ca1\u6709\u8bf4\u660e\u662f\u6dfb\u52a0\u64cd\u4f5c\u3002\n\t\u662f\u5426\u662f\u6dfb\u52a0\u64cd\u4f5c\uff1a\n<%--\t${ empty param.id ? \"add\" : \"update\"}--%>\n\n\t\/\/\u65b9\u6848\u4e09\uff1a\n\t\u53ef\u4ee5\u901a\u8fc7\u5224\u65ad\uff0cRequest\u57df\u4e2d\u662f\u5426\u5305\u542b\u6709\u4fee\u6539\u7684\u56fe\u4e66\u4fe1\u606f\u5bf9\u8c61\uff0c\u5982\u679c\u6ca1\u6709\u8bf4\u660e\u662f\u6dfb\u52a0\u64cd\u4f5c\u3002\u5982\u679c\u6709\u8bf4\u660e\u662f\u4fee\u6539\u64cd\u4f5c\u3002\n\t\u662f\u5426\u662f\u6dfb\u52a0\u64cd\u4f5c\uff1a\n<%--\t${ empty requestScope.book ? \"add\" : \"update\"}--%>\n-->\n\n\t\t<div id=\"header\">\n\t\t\t<img class=\"logo_img\" alt=\"\" src=\"..\/..\/static\/img\/logo.gif\" >\n\t\t\t<span class=\"wel_word\">\u7f16\u8f91\u56fe\u4e66<\/span>\n\n\t\t\t<%-- \u9759\u6001\u5305\u542b manager \u7ba1\u7406\u6a21\u5757\u7684\u83dc\u5355 --%>\n\t\t\t<%@include file=\"\/pages\/common\/manager_menu.jsp\"%>\n\n\t\t<\/div>\n\t\t\n\t\t<div id=\"main\">\n\t\t\t<form action=\"manager\/bookServlet\" method=\"get\">\n\t\t\t\t<input type=\"hidden\" name=\"action\" value=\"${ empty param.id ? \"add\" : \"update\"}\" \/>\n\t\t\t\t<input type=\"hidden\" name=\"id\" value=\"${requestScope.book.id}\" \/>\n\t\t\t\t<table>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td>\u540d\u79f0<\/td>\n\t\t\t\t\t\t<td>\u4ef7\u683c<\/td>\n\t\t\t\t\t\t<td>\u4f5c\u8005<\/td>\n\t\t\t\t\t\t<td>\u9500\u91cf<\/td>\n\t\t\t\t\t\t<td>\u5e93\u5b58<\/td>\n\t\t\t\t\t\t<td colspan=\"2\">\u64cd\u4f5c<\/td>\n\t\t\t\t\t<\/tr>\t\t\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td><input name=\"name\" type=\"text\" value=\"${requestScope.book.name}\"\/><\/td>\n\t\t\t\t\t\t<td><input name=\"price\" type=\"text\" value=\"${requestScope.book.price}\"\/><\/td>\n\t\t\t\t\t\t<td><input name=\"author\" type=\"text\" value=\"${requestScope.book.author}\"\/><\/td>\n\t\t\t\t\t\t<td><input name=\"sales\" type=\"text\" value=\"${requestScope.book.sales}\"\/><\/td>\n\t\t\t\t\t\t<td><input name=\"stock\" type=\"text\" value=\"${requestScope.book.stock}\"\/><\/td>\n\t\t\t\t\t\t<td><input type=\"submit\" value=\"\u63d0\u4ea4\"\/><\/td>\n\t\t\t\t\t<\/tr>\t\n\t\t\t\t<\/table>\n\t\t\t<\/form>\n\t\t\t\n\t\n\t\t<\/div>\n\n\t\t<%-- \u9759\u6001\u5305\u542b\u9875\u811a\u5185\u5bb9 --%>\n\t\t<%@include file=\"\/pages\/common\/footer.jsp\"%>\n\n<\/body>\n<\/html><\/code><\/pre>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.4\u3001\u5220\u9664\u56fe\u4e66\u529f\u80fd\u7684\u5b9e\u73b0<\/h3>\n\n\n\n
1.5.4.1\u3001\u56fe\u89e3\u5220\u9664\u6d41\u7a0b\uff1a<\/p>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.4.2\u3001BookServlet \u7a0b\u5e8f\u4e2d\u7684 delete \u65b9\u6cd5\uff1a<\/p>\n\n\n\n
package top.qaqaq.web;\n\nimport jakarta.servlet.ServletException;\nimport jakarta.servlet.http.HttpServletRequest;\nimport jakarta.servlet.http.HttpServletResponse;\nimport top.qaqaq.pojo.Book;\nimport top.qaqaq.service.BookService;\nimport top.qaqaq.service.impl.BookServiceImpl;\nimport top.qaqaq.utils.WebUtils;\n\nimport java.io.IOException;\nimport java.util.List;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-10 \u4e0b\u5348 7:51\n *\/\npublic class BookServlet extends BaseServlet {\n\n private BookService bookService = new BookServiceImpl();\n\n \/**\n * \u8d1f\u8d23\u6dfb\u52a0\u56fe\u4e66\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void add(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570==\u5c01\u88c5\u6210\u4e3aBook\u5bf9\u8c61\n Book book = WebUtils.copyParamToBean(req.getParameterMap(), new Book());\n \/\/ 2. \u8c03\u7528BookService.addBook()\u4fdd\u5b58\u56fe\u4e66\n bookService.addBook(book);\n \/\/ 3. \u8df3\u5230\u56fe\u4e66\u5217\u8868\u9875\u9762\n \/\/ \/manager\/bookServlet?action=list\n\n \/\/ \u5982\u679c\u4f7f\u7528\u8bf7\u6c42\u8f6c\u53d1\uff0c\u5219\u4e3a\u4e00\u6b21\u8bf7\u6c42\uff0c\u5237\u65b0\u4f1a\u91cd\u590d\u63d0\u4ea4\u6570\u636e\n\/\/ req.getRequestDispatcher(\"\/manager\/bookServlet?action=list\").forward(req,resp);\n \/\/ \u6240\u4ee5\u4f7f\u7528\u8bf7\u6c42\u91cd\u5b9a\u5411\n resp.sendRedirect(req.getContextPath() + \"\/manager\/bookServlet?action=list\");\n\n }\n\n \/**\n * \u8d1f\u8d23\u5220\u9664\u56fe\u4e66\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void delete(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570id\uff0c\u56fe\u4e66\u7f16\u7a0b\n int id = WebUtils.parseInt(req.getParameter(\"id\"),0);\n\n \/\/ 2. \u8c03\u7528bookService.deleteBookById();\u5220\u9664\u56fe\u4e66\n bookService.deleteBookById(id);\n \/\/ 3. \u91cd\u5b9a\u5411\u56de\u56fe\u4e66\u5217\u8868\u7ba1\u7406\u9875\u9762\n \/\/ \/book\/manager\/bookServlet?action=list\n resp.sendRedirect(req.getContextPath() + \"\/manager\/bookServlet?action=list\");\n }\n\n \/**\n * \u4fdd\u5b58\u4fee\u6539\u56fe\u4e66\u7684\u64cd\u4f5c\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void update(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570==\u5c01\u88c5\u6210\u4e3aBook\u5bf9\u8c61\n Book book = WebUtils.copyParamToBean(req.getParameterMap(), new Book());\n \/\/ 2. \u8c03\u7528BookService.updateBook( book );\u4fee\u6539\u56fe\u4e66\n bookService.updateBook(book);\n \/\/ 3. \u91cd\u5b9a\u5411\u56de\u56fe\u4e66\u5217\u8868\u7ba1\u7406\u9875\u9762\n \/\/ \u5730\u5740\uff1a\/\u5de5\u7a0b\u540d\/manager\/bookServlet?action=list\n resp.sendRedirect(req.getContextPath() + \"\/manager\/bookServlet?action=list\");\n\n }\n\n \/**\n * \u83b7\u53d6\u8981\u4fee\u6539\u7684\u56fe\u4e66\u4fe1\u606f\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void getBook(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570\u56fe\u4e66\u7f16\u53f7\n int id = WebUtils.parseInt(req.getParameter(\"id\"),0);\n \/\/ 2. \u8c03\u7528bookService.queryBookById\u67e5\u8be2\u56fe\u4e66\n Book book = bookService.queryBookById(id);\n \/\/ 3. \u4fdd\u5b58\u56fe\u4e66\u5230Request\u57df\u4e2d\n req.setAttribute(\"book\",book);\n \/\/ 4. \u8bf7\u6c42\u8f6c\u53d1\u5230\u3002pages\/manager\/book_edit.jsp\u9875\u9762\n req.getRequestDispatcher(\"\/pages\/manager\/book_edit.jsp\").forward(req,resp);\n }\n\n \/**\n * \u8d1f\u8d23\u904d\u5386\u56fe\u4e66\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void list(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u901a\u8fc7BookService\u67e5\u8be2\u5168\u90e8\u56fe\u4e66\n List<Book> books = bookService.queryBooks();\n \/\/ 2. \u628a\u5168\u90e8\u56fe\u4e66\u4fdd\u5b58\u5230Request\u57df\u4e2d\n req.setAttribute(\"books\", books);\n \/\/ 3. \u8bf7\u6c42\u8f6c\u53d1\u5230\/pages\/manager\/book_manager.jsp\u9875\u9762\n req.getRequestDispatcher(\"\/pages\/manager\/book_manager.jsp\").forward(req,resp);\n\n }\n}\n<\/code><\/pre>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.4.3\u3001\u7ed9 WebUtils \u5de5\u5177\u7c7b\u6dfb\u52a0\u8f6c\u6362 int \u7c7b\u578b\u7684\u5de5\u5177\u65b9\u6cd5<\/p>\n\n\n\n
package top.qaqaq.utils;\n\nimport org.apache.commons.beanutils.BeanUtils;\n\nimport java.lang.reflect.InvocationTargetException;\nimport java.util.Map;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-10 \u4e0b\u5348 2:11\n *\/\npublic class WebUtils {\n\n \/**\n * \u628aMap\u4e2d\u7684\u503c\u6ce8\u5165\u5230\u5bf9\u5e94\u7684JavaBean\u5c5e\u6027\u4e2d\u3002\n * @param value\n * @param bean\n * \u5982\u679c\u5f62\u53c2\u5199\u6210HttpServletRequest DAO\u5c42\u548cService\u5c42\u6ca1\u6709\u8fd9\u4e2aAPI \u4e14web\u5c42\u8026\u5408\u5ea6\u9ad8\uff0c\u4ee3\u7801\u4e0d\u4f18\u96c5\n * DAO\u5c42\n * Service\u5c42\n * Web\u5c42\n *\/\n public static <T> T copyParamToBean(Map value, T bean) {\n try {\n System.out.println(\"\u6ce8\u5165\u4e4b\u524d\uff1a\" + bean);\n BeanUtils.populate(bean,value);\n System.out.println(\"\u6ce8\u5165\u4e4b\u540e\uff1a\" + bean);\n } catch (IllegalAccessException e) {\n e.printStackTrace();\n } catch (InvocationTargetException e) {\n e.printStackTrace();\n }\n return bean;\n }\n\n \/**\n * \u5c06\u5b57\u7b26\u4e32\u8f6c\u6362\u6210\u4e3aint\u7c7b\u578b\n * @param strInt\n * @param defaultValue\n * @return\n *\/\n public static int parseInt(String strInt, int defaultValue){\n try {\n return Integer.parseInt(strInt);\n } catch (NumberFormatException e) {\n e.printStackTrace();\n }\n return defaultValue;\n }\n}\n<\/code><\/pre>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.4.4\u3001\u4fee\u6539\u5220\u9664\u7684\u8fde\u63a5\u5730\u5740\uff1a<\/p>\n\n\n\n
book_manager.jsp<\/p>\n\n\n\n
<%@ taglib prefix=\"c\" uri=\"http:\/\/java.sun.com\/jsp\/jstl\/core\" %>\n<%@ page contentType=\"text\/html;charset=UTF-8\" language=\"java\" %>\n<!DOCTYPE html>\n<html>\n<head>\n<meta charset=\"UTF-8\">\n<title>\u56fe\u4e66\u7ba1\u7406<\/title>\n\n\t<%-- \u9759\u6001\u5305\u542b base\u6807\u7b7e\uff0ccss\u6837\u5f0f\uff0cjQuery\u6587\u4ef6 --%>\n\t<%@ include file=\"\/pages\/common\/head.jsp\"%>\n\t<script type=\"text\/javascript\">\n\t\t$(function () {\n\t\t\t\/\/ \u7ed9\u5220\u9664\u7684a\u6807\u7b7e\u7ed1\u5b9a\u5355\u51fb\u4e8b\u4ef6\uff0c\u7528\u4e8e\u5220\u9664\u7684\u786e\u8ba4\u63d0\u793a\u64cd\u4f5c\n\t\t\t$(\"a.deleteClass\").click(function () {\n\t\t\t\t\/\/\u5728\u4e8b\u4ef6\u7684function\u51fd\u6570\u4e2d\uff0c\u6709\u4e00\u4e2athis\u5bf9\u8c61\u3002\u8fd9\u4e2athis\u5bf9\u8c61\uff0c\u662f\u5f53\u524d\u6b63\u5728\u54cd\u5e94\u4e8b\u4ef6\u7684dom\u5bf9\u8c61\u3002\n\n\t\t\t\t\/**\n\t\t\t\t * confirm\u662f\u786e\u8ba4\u63d0\u793a\u6846\u51fd\u6570\n\t\t\t\t * \u53c2\u6570\u662f\u5b83\u7684\u63d0\u793a\u5185\u5bb9\n\t\t\t\t * \u5b83\u6709\u4e24\u4e2a\u6309\u94ae\uff0c\u4e00\u4e2a\u786e\u8ba4\uff0c\u4e00\u4e2a\u53d6\u6d88\u3002\n\t\t\t\t * \u8fd4\u56detrue\u8868\u793a\u70b9\u51fb\u4e86\uff0c\u786e\u8ba4\uff0c\u8fd4\u56defalse\u8868\u793a\u70b9\u51fb\u53d6\u6d88\n\t\t\t\t *\/\n\t\t\t\treturn confirm(\"\u4f60\u786e\u5b9a\u8981\u5220\u9664\u3010\" + $(this).parent().parent().find(\"td:first\").text() + \"\u3011\uff1f\")\n\n\t\t\t\t\/\/return false\/\/ \u963b\u6b62\u5143\u7d20\u7684\u9ed8\u8ba4\u884c\u4e3a===\u4e0d\u63d0\u4ea4\u8bf7\u6c42\n\t\t\t})\n\n\t\t})\n\t<\/script>\n\n<\/head>\n<body>\n\t\n\t<div id=\"header\">\n\t\t\t<img class=\"logo_img\" alt=\"\" src=\"..\/..\/static\/img\/logo.gif\" >\n\t\t\t<span class=\"wel_word\">\u56fe\u4e66\u7ba1\u7406\u7cfb\u7edf<\/span>\n\n\t\t\t<%-- \u9759\u6001\u5305\u542b manager \u7ba1\u7406\u6a21\u5757\u7684\u83dc\u5355 --%>\n\t\t\t<%@include file=\"\/pages\/common\/manager_menu.jsp\"%>\n\n\t<\/div>\n\t\n\t<div id=\"main\">\n\t\t<table>\n\t\t\t<tr>\n\t\t\t\t<td>\u540d\u79f0<\/td>\n\t\t\t\t<td>\u4ef7\u683c<\/td>\n\t\t\t\t<td>\u4f5c\u8005<\/td>\n\t\t\t\t<td>\u9500\u91cf<\/td>\n\t\t\t\t<td>\u5e93\u5b58<\/td>\n\t\t\t\t<td colspan=\"2\">\u64cd\u4f5c<\/td>\n\t\t\t<\/tr>\n\n\t\t\t<c:forEach items=\"${requestScope.books}\" var=\"book\">\n\t\t\t\t<tr>\n\t\t\t\t\t<td>${book.name}<\/td>\n\t\t\t\t\t<td>${book.price}<\/td>\n\t\t\t\t\t<td>${book.author}<\/td>\n\t\t\t\t\t<td>${book.sales}<\/td>\n\t\t\t\t\t<td>${book.stock}<\/td>\n\t\t\t\t\t<td><a href=\"manager\/bookServlet?action=getBook&id=${book.id}\">\u4fee\u6539<\/a><\/td>\n\t\t\t\t\t<td><a class=\"deleteClass\" href=\"manager\/bookServlet?action=delete&id=${book.id}\">\u5220\u9664<\/a><\/td>\n\t\t\t\t<\/tr>\n\t\t\t<\/c:forEach>\n\n\t\t\t<tr>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><a href=\"pages\/manager\/book_edit.jsp\">\u6dfb\u52a0\u56fe\u4e66<\/a><\/td>\n\t\t\t<\/tr>\t\n\t\t<\/table>\n\t<\/div>\n\n\t<%-- \u9759\u6001\u5305\u542b\u9875\u811a\u5185\u5bb9 --%>\n\t<%@include file=\"\/pages\/common\/footer.jsp\"%>\n\n<\/body>\n<\/html><\/code><\/pre>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.4.5\u3001\u7ed9\u5220\u9664\u6dfb\u52a0\u786e\u8ba4\u63d0\u793a\u64cd\u4f5c\uff1a<\/p>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.5\u3001\u4fee\u6539\u56fe\u4e66\u529f\u80fd\u7684\u5b9e\u73b0<\/h3>\n\n\n\n
1.5.5.1\uff1a\u56fe\u89e3\u4fee\u6539\u56fe\u4e66\u7ec6\u8282\uff1a<\/p>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.5.2\u3001\u66f4\u65b0\u3010\u4fee\u6539\u3011\u7684\u8bf7\u6c42\u5730\u5740\uff1a<\/p>\n\n\n\n
book_manager.jsp<\/p>\n\n\n\n
<%@ taglib prefix=\"c\" uri=\"http:\/\/java.sun.com\/jsp\/jstl\/core\" %>\n<%@ page contentType=\"text\/html;charset=UTF-8\" language=\"java\" %>\n<!DOCTYPE html>\n<html>\n<head>\n<meta charset=\"UTF-8\">\n<title>\u56fe\u4e66\u7ba1\u7406<\/title>\n\n\t<%-- \u9759\u6001\u5305\u542b base\u6807\u7b7e\uff0ccss\u6837\u5f0f\uff0cjQuery\u6587\u4ef6 --%>\n\t<%@ include file=\"\/pages\/common\/head.jsp\"%>\n\t<script type=\"text\/javascript\">\n\t\t$(function () {\n\t\t\t\/\/ \u7ed9\u5220\u9664\u7684a\u6807\u7b7e\u7ed1\u5b9a\u5355\u51fb\u4e8b\u4ef6\uff0c\u7528\u4e8e\u5220\u9664\u7684\u786e\u8ba4\u63d0\u793a\u64cd\u4f5c\n\t\t\t$(\"a.deleteClass\").click(function () {\n\t\t\t\t\/\/\u5728\u4e8b\u4ef6\u7684function\u51fd\u6570\u4e2d\uff0c\u6709\u4e00\u4e2athis\u5bf9\u8c61\u3002\u8fd9\u4e2athis\u5bf9\u8c61\uff0c\u662f\u5f53\u524d\u6b63\u5728\u54cd\u5e94\u4e8b\u4ef6\u7684dom\u5bf9\u8c61\u3002\n\n\t\t\t\t\/**\n\t\t\t\t * confirm\u662f\u786e\u8ba4\u63d0\u793a\u6846\u51fd\u6570\n\t\t\t\t * \u53c2\u6570\u662f\u5b83\u7684\u63d0\u793a\u5185\u5bb9\n\t\t\t\t * \u5b83\u6709\u4e24\u4e2a\u6309\u94ae\uff0c\u4e00\u4e2a\u786e\u8ba4\uff0c\u4e00\u4e2a\u53d6\u6d88\u3002\n\t\t\t\t * \u8fd4\u56detrue\u8868\u793a\u70b9\u51fb\u4e86\uff0c\u786e\u8ba4\uff0c\u8fd4\u56defalse\u8868\u793a\u70b9\u51fb\u53d6\u6d88\n\t\t\t\t *\/\n\t\t\t\treturn confirm(\"\u4f60\u786e\u5b9a\u8981\u5220\u9664\u3010\" + $(this).parent().parent().find(\"td:first\").text() + \"\u3011\uff1f\")\n\n\t\t\t\t\/\/return false\/\/ \u963b\u6b62\u5143\u7d20\u7684\u9ed8\u8ba4\u884c\u4e3a===\u4e0d\u63d0\u4ea4\u8bf7\u6c42\n\t\t\t})\n\n\t\t})\n\t<\/script>\n\n<\/head>\n<body>\n\t\n\t<div id=\"header\">\n\t\t\t<img class=\"logo_img\" alt=\"\" src=\"..\/..\/static\/img\/logo.gif\" >\n\t\t\t<span class=\"wel_word\">\u56fe\u4e66\u7ba1\u7406\u7cfb\u7edf<\/span>\n\n\t\t\t<%-- \u9759\u6001\u5305\u542b manager \u7ba1\u7406\u6a21\u5757\u7684\u83dc\u5355 --%>\n\t\t\t<%@include file=\"\/pages\/common\/manager_menu.jsp\"%>\n\n\t<\/div>\n\t\n\t<div id=\"main\">\n\t\t<table>\n\t\t\t<tr>\n\t\t\t\t<td>\u540d\u79f0<\/td>\n\t\t\t\t<td>\u4ef7\u683c<\/td>\n\t\t\t\t<td>\u4f5c\u8005<\/td>\n\t\t\t\t<td>\u9500\u91cf<\/td>\n\t\t\t\t<td>\u5e93\u5b58<\/td>\n\t\t\t\t<td colspan=\"2\">\u64cd\u4f5c<\/td>\n\t\t\t<\/tr>\n\n\t\t\t<c:forEach items=\"${requestScope.books}\" var=\"book\">\n\t\t\t\t<tr>\n\t\t\t\t\t<td>${book.name}<\/td>\n\t\t\t\t\t<td>${book.price}<\/td>\n\t\t\t\t\t<td>${book.author}<\/td>\n\t\t\t\t\t<td>${book.sales}<\/td>\n\t\t\t\t\t<td>${book.stock}<\/td>\n\t\t\t\t\t<td><a href=\"manager\/bookServlet?action=getBook&id=${book.id}\">\u4fee\u6539<\/a><\/td>\n\t\t\t\t\t<td><a class=\"deleteClass\" href=\"manager\/bookServlet?action=delete&id=${book.id}\">\u5220\u9664<\/a><\/td>\n\t\t\t\t<\/tr>\n\t\t\t<\/c:forEach>\n\n\t\t\t<tr>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><a href=\"pages\/manager\/book_edit.jsp\">\u6dfb\u52a0\u56fe\u4e66<\/a><\/td>\n\t\t\t<\/tr>\t\n\t\t<\/table>\n\t<\/div>\n\n\t<%-- \u9759\u6001\u5305\u542b\u9875\u811a\u5185\u5bb9 --%>\n\t<%@include file=\"\/pages\/common\/footer.jsp\"%>\n\n<\/body>\n<\/html><\/code><\/pre>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.5.3\u3001BookServlet \u7a0b\u5e8f\u4e2d\u6dfb\u52a0 getBook \u65b9\u6cd5\uff1a<\/p>\n\n\n\n
package top.qaqaq.web;\n\nimport jakarta.servlet.ServletException;\nimport jakarta.servlet.http.HttpServletRequest;\nimport jakarta.servlet.http.HttpServletResponse;\nimport top.qaqaq.pojo.Book;\nimport top.qaqaq.service.BookService;\nimport top.qaqaq.service.impl.BookServiceImpl;\nimport top.qaqaq.utils.WebUtils;\n\nimport java.io.IOException;\nimport java.util.List;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-10 \u4e0b\u5348 7:51\n *\/\npublic class BookServlet extends BaseServlet {\n\n private BookService bookService = new BookServiceImpl();\n\n \/**\n * \u8d1f\u8d23\u6dfb\u52a0\u56fe\u4e66\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void add(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570==\u5c01\u88c5\u6210\u4e3aBook\u5bf9\u8c61\n Book book = WebUtils.copyParamToBean(req.getParameterMap(), new Book());\n \/\/ 2. \u8c03\u7528BookService.addBook()\u4fdd\u5b58\u56fe\u4e66\n bookService.addBook(book);\n \/\/ 3. \u8df3\u5230\u56fe\u4e66\u5217\u8868\u9875\u9762\n \/\/ \/manager\/bookServlet?action=list\n\n \/\/ \u5982\u679c\u4f7f\u7528\u8bf7\u6c42\u8f6c\u53d1\uff0c\u5219\u4e3a\u4e00\u6b21\u8bf7\u6c42\uff0c\u5237\u65b0\u4f1a\u91cd\u590d\u63d0\u4ea4\u6570\u636e\n\/\/ req.getRequestDispatcher(\"\/manager\/bookServlet?action=list\").forward(req,resp);\n \/\/ \u6240\u4ee5\u4f7f\u7528\u8bf7\u6c42\u91cd\u5b9a\u5411\n resp.sendRedirect(req.getContextPath() + \"\/manager\/bookServlet?action=list\");\n\n }\n\n \/**\n * \u8d1f\u8d23\u5220\u9664\u56fe\u4e66\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void delete(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570id\uff0c\u56fe\u4e66\u7f16\u7a0b\n int id = WebUtils.parseInt(req.getParameter(\"id\"),0);\n\n \/\/ 2. \u8c03\u7528bookService.deleteBookById();\u5220\u9664\u56fe\u4e66\n bookService.deleteBookById(id);\n \/\/ 3. \u91cd\u5b9a\u5411\u56de\u56fe\u4e66\u5217\u8868\u7ba1\u7406\u9875\u9762\n \/\/ \/book\/manager\/bookServlet?action=list\n resp.sendRedirect(req.getContextPath() + \"\/manager\/bookServlet?action=list\");\n }\n\n \/**\n * \u4fdd\u5b58\u4fee\u6539\u56fe\u4e66\u7684\u64cd\u4f5c\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void update(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570==\u5c01\u88c5\u6210\u4e3aBook\u5bf9\u8c61\n Book book = WebUtils.copyParamToBean(req.getParameterMap(), new Book());\n \/\/ 2. \u8c03\u7528BookService.updateBook( book );\u4fee\u6539\u56fe\u4e66\n bookService.updateBook(book);\n \/\/ 3. \u91cd\u5b9a\u5411\u56de\u56fe\u4e66\u5217\u8868\u7ba1\u7406\u9875\u9762\n \/\/ \u5730\u5740\uff1a\/\u5de5\u7a0b\u540d\/manager\/bookServlet?action=list\n resp.sendRedirect(req.getContextPath() + \"\/manager\/bookServlet?action=list\");\n\n }\n\n \/**\n * \u83b7\u53d6\u8981\u4fee\u6539\u7684\u56fe\u4e66\u4fe1\u606f\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void getBook(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570\u56fe\u4e66\u7f16\u53f7\n int id = WebUtils.parseInt(req.getParameter(\"id\"),0);\n \/\/ 2. \u8c03\u7528bookService.queryBookById\u67e5\u8be2\u56fe\u4e66\n Book book = bookService.queryBookById(id);\n \/\/ 3. \u4fdd\u5b58\u56fe\u4e66\u5230Request\u57df\u4e2d\n req.setAttribute(\"book\",book);\n \/\/ 4. \u8bf7\u6c42\u8f6c\u53d1\u5230\u3002pages\/manager\/book_edit.jsp\u9875\u9762\n req.getRequestDispatcher(\"\/pages\/manager\/book_edit.jsp\").forward(req,resp);\n }\n\n \/**\n * \u8d1f\u8d23\u904d\u5386\u56fe\u4e66\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void list(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u901a\u8fc7BookService\u67e5\u8be2\u5168\u90e8\u56fe\u4e66\n List<Book> books = bookService.queryBooks();\n \/\/ 2. \u628a\u5168\u90e8\u56fe\u4e66\u4fdd\u5b58\u5230Request\u57df\u4e2d\n req.setAttribute(\"books\", books);\n \/\/ 3. \u8bf7\u6c42\u8f6c\u53d1\u5230\/pages\/manager\/book_manager.jsp\u9875\u9762\n req.getRequestDispatcher(\"\/pages\/manager\/book_manager.jsp\").forward(req,resp);\n\n }\n}\n<\/code><\/pre>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.5.4\u3001\u5728 book_edit.jsp \u9875\u9762\u4e2d\u663e\u793a\u4fee\u6539\u7684\u6570\u636e<\/p>\n\n\n\n
<%@ page contentType=\"text\/html;charset=UTF-8\" language=\"java\" %>\n<!DOCTYPE html>\n<html>\n<head>\n<meta charset=\"UTF-8\">\n<title>\u7f16\u8f91\u56fe\u4e66<\/title>\n\n\t<%-- \u9759\u6001\u5305\u542b base\u6807\u7b7e\uff0ccss\u6837\u5f0f\uff0cjQuery\u6587\u4ef6 --%>\n\t<%@ include file=\"\/pages\/common\/head.jsp\"%>\n\n\t<style type=\"text\/css\">\n\th1 {\n\t\ttext-align: center;\n\t\tmargin-top: 200px;\n\t}\n\t\n\th1 a {\n\t\tcolor:red;\n\t}\n\t\n\tinput {\n\t\ttext-align: center;\n\t}\n<\/style>\n<\/head>\n<body>\n<!--\n\t\u9047\u5230\u7684\u95ee\u9898\uff1a\n\tbook_edit.jsp\u9875\u9762\uff0c\u65e2\u8981\u505a\u6dfb\u52a0\u64cd\u4f5c\u3002\u53c8\u8981\u505a\u4fee\u6539\u64cd\u4f5c\uff0c\u800c\u5230\u5e95\u662f\u6dfb\u52a0\uff0c\u8fd8\u662f\u4fee\u6539\u662f\u7531\u4e00\u4e2a\u9690\u85cf\u57df\u6765\u51b3\u5b9a\u7684\u3002\n\t\u5982\u4f55\u52a8\u6001\u4fee\u6539\u9690\u85cf\u57df<input type=\"hidden\" name=\"action\" value=\"xxx\" \/> \u8ba9\u5b83\u7684\u503c\u65e2\u53ef\u4ee5\u5b9e\u73b0\u6dfb\u52a0\uff0c\u53c8\u53ef\u4ee5\u5b9e\u73b0\u4fee\u6539\u64cd\u4f5c\uff1f\n\n\t\/\/\u65b9\u6848\u4e00\uff1a\n\t\u53ef\u4ee5\u5f53\u8bf7\u6c42\u53d1\u8d77\u65f6\uff0c\u9644\u5e26\u4e0a\u5f53\u524d\u8981\u64cd\u4f5c\u7684\u503c\u3002\u5e76\u6ce8\u5165\u5230\u9690\u85cf\u57df\u4e2d\u3002\n\n\t\/\/\u65b9\u6848\u4e8c\uff1a\n\t\u53ef\u4ee5\u901a\u8fc7\u5224\u65ad\u5f53\u524d\u8bf7\u6c42\u53c2\u6570\u4e2d\u662f\u5426\u5305\u542b\u6709id\u53c2\u6570\u3002\u5982\u679c\u6709\u8bf4\u660e\u662f\u4fee\u6539\u64cd\u4f5c\u3002\u5982\u679c\u6ca1\u6709\u8bf4\u660e\u662f\u6dfb\u52a0\u64cd\u4f5c\u3002\n\t\u662f\u5426\u662f\u6dfb\u52a0\u64cd\u4f5c\uff1a\n<%--\t${ empty param.id ? \"add\" : \"update\"}--%>\n\n\t\/\/\u65b9\u6848\u4e09\uff1a\n\t\u53ef\u4ee5\u901a\u8fc7\u5224\u65ad\uff0cRequest\u57df\u4e2d\u662f\u5426\u5305\u542b\u6709\u4fee\u6539\u7684\u56fe\u4e66\u4fe1\u606f\u5bf9\u8c61\uff0c\u5982\u679c\u6ca1\u6709\u8bf4\u660e\u662f\u6dfb\u52a0\u64cd\u4f5c\u3002\u5982\u679c\u6709\u8bf4\u660e\u662f\u4fee\u6539\u64cd\u4f5c\u3002\n\t\u662f\u5426\u662f\u6dfb\u52a0\u64cd\u4f5c\uff1a\n<%--\t${ empty requestScope.book ? \"add\" : \"update\"}--%>\n-->\n\n\t\t<div id=\"header\">\n\t\t\t<img class=\"logo_img\" alt=\"\" src=\"..\/..\/static\/img\/logo.gif\" >\n\t\t\t<span class=\"wel_word\">\u7f16\u8f91\u56fe\u4e66<\/span>\n\n\t\t\t<%-- \u9759\u6001\u5305\u542b manager \u7ba1\u7406\u6a21\u5757\u7684\u83dc\u5355 --%>\n\t\t\t<%@include file=\"\/pages\/common\/manager_menu.jsp\"%>\n\n\t\t<\/div>\n\t\t\n\t\t<div id=\"main\">\n\t\t\t<form action=\"manager\/bookServlet\" method=\"get\">\n\t\t\t\t<input type=\"hidden\" name=\"action\" value=\"${ empty param.id ? \"add\" : \"update\"}\" \/>\n\t\t\t\t<input type=\"hidden\" name=\"id\" value=\"${requestScope.book.id}\" \/>\n\t\t\t\t<table>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td>\u540d\u79f0<\/td>\n\t\t\t\t\t\t<td>\u4ef7\u683c<\/td>\n\t\t\t\t\t\t<td>\u4f5c\u8005<\/td>\n\t\t\t\t\t\t<td>\u9500\u91cf<\/td>\n\t\t\t\t\t\t<td>\u5e93\u5b58<\/td>\n\t\t\t\t\t\t<td colspan=\"2\">\u64cd\u4f5c<\/td>\n\t\t\t\t\t<\/tr>\t\t\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td><input name=\"name\" type=\"text\" value=\"${requestScope.book.name}\"\/><\/td>\n\t\t\t\t\t\t<td><input name=\"price\" type=\"text\" value=\"${requestScope.book.price}\"\/><\/td>\n\t\t\t\t\t\t<td><input name=\"author\" type=\"text\" value=\"${requestScope.book.author}\"\/><\/td>\n\t\t\t\t\t\t<td><input name=\"sales\" type=\"text\" value=\"${requestScope.book.sales}\"\/><\/td>\n\t\t\t\t\t\t<td><input name=\"stock\" type=\"text\" value=\"${requestScope.book.stock}\"\/><\/td>\n\t\t\t\t\t\t<td><input type=\"submit\" value=\"\u63d0\u4ea4\"\/><\/td>\n\t\t\t\t\t<\/tr>\t\n\t\t\t\t<\/table>\n\t\t\t<\/form>\n\t\t\t\n\t\n\t\t<\/div>\n\n\t\t<%-- \u9759\u6001\u5305\u542b\u9875\u811a\u5185\u5bb9 --%>\n\t\t<%@include file=\"\/pages\/common\/footer.jsp\"%>\n\n<\/body>\n<\/html><\/code><\/pre>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.5.5\u3001\u5728 BookServlet \u7a0b\u5e8f\u4e2d\u6dfb\u52a0 update \u65b9\u6cd5\uff1a<\/p>\n\n\n\n
package top.qaqaq.web;\n\nimport jakarta.servlet.ServletException;\nimport jakarta.servlet.http.HttpServletRequest;\nimport jakarta.servlet.http.HttpServletResponse;\nimport top.qaqaq.pojo.Book;\nimport top.qaqaq.service.BookService;\nimport top.qaqaq.service.impl.BookServiceImpl;\nimport top.qaqaq.utils.WebUtils;\n\nimport java.io.IOException;\nimport java.util.List;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-10 \u4e0b\u5348 7:51\n *\/\npublic class BookServlet extends BaseServlet {\n\n private BookService bookService = new BookServiceImpl();\n\n \/**\n * \u8d1f\u8d23\u6dfb\u52a0\u56fe\u4e66\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void add(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570==\u5c01\u88c5\u6210\u4e3aBook\u5bf9\u8c61\n Book book = WebUtils.copyParamToBean(req.getParameterMap(), new Book());\n \/\/ 2. \u8c03\u7528BookService.addBook()\u4fdd\u5b58\u56fe\u4e66\n bookService.addBook(book);\n \/\/ 3. \u8df3\u5230\u56fe\u4e66\u5217\u8868\u9875\u9762\n \/\/ \/manager\/bookServlet?action=list\n\n \/\/ \u5982\u679c\u4f7f\u7528\u8bf7\u6c42\u8f6c\u53d1\uff0c\u5219\u4e3a\u4e00\u6b21\u8bf7\u6c42\uff0c\u5237\u65b0\u4f1a\u91cd\u590d\u63d0\u4ea4\u6570\u636e\n\/\/ req.getRequestDispatcher(\"\/manager\/bookServlet?action=list\").forward(req,resp);\n \/\/ \u6240\u4ee5\u4f7f\u7528\u8bf7\u6c42\u91cd\u5b9a\u5411\n resp.sendRedirect(req.getContextPath() + \"\/manager\/bookServlet?action=list\");\n\n }\n\n \/**\n * \u8d1f\u8d23\u5220\u9664\u56fe\u4e66\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void delete(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570id\uff0c\u56fe\u4e66\u7f16\u7a0b\n int id = WebUtils.parseInt(req.getParameter(\"id\"),0);\n\n \/\/ 2. \u8c03\u7528bookService.deleteBookById();\u5220\u9664\u56fe\u4e66\n bookService.deleteBookById(id);\n \/\/ 3. \u91cd\u5b9a\u5411\u56de\u56fe\u4e66\u5217\u8868\u7ba1\u7406\u9875\u9762\n \/\/ \/book\/manager\/bookServlet?action=list\n resp.sendRedirect(req.getContextPath() + \"\/manager\/bookServlet?action=list\");\n }\n\n \/**\n * \u4fdd\u5b58\u4fee\u6539\u56fe\u4e66\u7684\u64cd\u4f5c\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void update(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570==\u5c01\u88c5\u6210\u4e3aBook\u5bf9\u8c61\n Book book = WebUtils.copyParamToBean(req.getParameterMap(), new Book());\n \/\/ 2. \u8c03\u7528BookService.updateBook( book );\u4fee\u6539\u56fe\u4e66\n bookService.updateBook(book);\n \/\/ 3. \u91cd\u5b9a\u5411\u56de\u56fe\u4e66\u5217\u8868\u7ba1\u7406\u9875\u9762\n \/\/ \u5730\u5740\uff1a\/\u5de5\u7a0b\u540d\/manager\/bookServlet?action=list\n resp.sendRedirect(req.getContextPath() + \"\/manager\/bookServlet?action=list\");\n\n }\n\n \/**\n * \u83b7\u53d6\u8981\u4fee\u6539\u7684\u56fe\u4e66\u4fe1\u606f\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void getBook(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570\u56fe\u4e66\u7f16\u53f7\n int id = WebUtils.parseInt(req.getParameter(\"id\"),0);\n \/\/ 2. \u8c03\u7528bookService.queryBookById\u67e5\u8be2\u56fe\u4e66\n Book book = bookService.queryBookById(id);\n \/\/ 3. \u4fdd\u5b58\u56fe\u4e66\u5230Request\u57df\u4e2d\n req.setAttribute(\"book\",book);\n \/\/ 4. \u8bf7\u6c42\u8f6c\u53d1\u5230\u3002pages\/manager\/book_edit.jsp\u9875\u9762\n req.getRequestDispatcher(\"\/pages\/manager\/book_edit.jsp\").forward(req,resp);\n }\n\n \/**\n * \u8d1f\u8d23\u904d\u5386\u56fe\u4e66\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void list(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u901a\u8fc7BookService\u67e5\u8be2\u5168\u90e8\u56fe\u4e66\n List<Book> books = bookService.queryBooks();\n \/\/ 2. \u628a\u5168\u90e8\u56fe\u4e66\u4fdd\u5b58\u5230Request\u57df\u4e2d\n req.setAttribute(\"books\", books);\n \/\/ 3. \u8bf7\u6c42\u8f6c\u53d1\u5230\/pages\/manager\/book_manager.jsp\u9875\u9762\n req.getRequestDispatcher(\"\/pages\/manager\/book_manager.jsp\").forward(req,resp);\n\n }\n}\n<\/code><\/pre>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.5.6\u3001\u89e3\u51b3 book_edit.jsp \u9875\u9762\uff0c\u5373\u8981\u5b9e\u73b0\u6dfb\u52a0\uff0c\u53c8\u8981\u5b9e\u73b0\u4fee\u6539\u64cd\u4f5c\u3002<\/p>\n\n\n\n<\/div><\/figure>\n\n\n\nweb.xml<\/h2>\n\n\n\n<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<web-app xmlns=\"https:\/\/jakarta.ee\/xml\/ns\/jakartaee\"\n xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\"\n xsi:schemaLocation=\"https:\/\/jakarta.ee\/xml\/ns\/jakartaee https:\/\/jakarta.ee\/xml\/ns\/jakartaee\/web-app_5_0.xsd\"\n version=\"5.0\">\n\n<!-- <servlet>-->\n<!-- <servlet-name>RegistServlet<\/servlet-name>-->\n<!-- <servlet-class>top.qaqaq.web.RegistServlet<\/servlet-class>-->\n<!-- <\/servlet>-->\n<!-- <servlet-mapping>-->\n<!-- <servlet-name>RegistServlet<\/servlet-name>-->\n<!-- <url-pattern>\/registServlet<\/url-pattern>-->\n<!-- <\/servlet-mapping>-->\n\n<!-- <servlet>-->\n<!-- <servlet-name>LoginServlet<\/servlet-name>-->\n<!-- <servlet-class>top.qaqaq.web.LoginServlet<\/servlet-class>-->\n<!-- <\/servlet>-->\n<!-- <servlet-mapping>-->\n<!-- <servlet-name>LoginServlet<\/servlet-name>-->\n<!-- <url-pattern>\/loginServlet<\/url-pattern>-->\n<!-- <\/servlet-mapping>-->\n\n <servlet>\n <servlet-name>UserServlet<\/servlet-name>\n <servlet-class>top.qaqaq.web.UserServlet<\/servlet-class>\n <\/servlet>\n <servlet-mapping>\n <servlet-name>UserServlet<\/servlet-name>\n <url-pattern>\/userServlet<\/url-pattern>\n <\/servlet-mapping>\n\n <servlet>\n <servlet-name>BookServlet<\/servlet-name>\n <servlet-class>top.qaqaq.web.BookServlet<\/servlet-class>\n <\/servlet>\n <servlet-mapping>\n <servlet-name>BookServlet<\/servlet-name>\n <url-pattern>\/manager\/bookServlet<\/url-pattern>\n <\/servlet-mapping>\n\n<\/web-app><\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"\u4e66\u57ce\u9879\u76ee-\u7b2c\u4e94\u9636\u6bb5\uff1a\u5185\u5bb9\u4ecb\u7ecd\u3001\u4e66\u57ce\u9879\u76ee-MVC\u6982\u5ff5\u7684\u4ecb\u7ecd\u3001\u4e66\u57ce\u9879\u76ee-\u521b\u5efa\u56fe\u4e66\u6a21\u5757\u7684\u6570\u636e\u5e93\u8868\u3001\u4e66\u57ce\u9879\u76ee-\u7f16\u5199\u56fe\u4e66 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[59],"tags":[61],"class_list":["post-2459","post","type-post","status-publish","format-standard","hentry","category-javaweb-code","tag-javaweb"],"_links":{"self":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/2459"}],"collection":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2459"}],"version-history":[{"count":7,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/2459\/revisions"}],"predecessor-version":[{"id":2718,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/2459\/revisions\/2718"}],"wp:attachment":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2459"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2459"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2459"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
# P233 \u4e66\u57ce\u9879\u76ee-\u521b\u5efa\u56fe\u4e66\u6a21\u5757\u7684\u6570\u636e\u5e93\u8868\n\nCREATE TABLE t_book(\n id INT PRIMARY KEY AUTO_INCREMENT,\n name VARCHAR(100), #\u540d\u79f0\n price DECIMAL(11,2), #\u4ef7\u683c\n author VARCHAR(100), #\u4f5c\u8005\n sales INT, #\u9500\u91cf\n stock INT, #\u5e93\u5b58\n img_path VARCHAR(200) #\u56fe\u7247\n);\n\n# \u63d2\u5165\u521d\u59cb\u5316\u6d4b\u8bd5\u6570\u636e\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , 'java\u4ece\u5165\u95e8\u5230\u653e\u5f03' , '\u56fd\u54e5' , 80 , 9999 , 9 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , '\u6570\u636e\u7ed3\u6784\u4e0e\u7b97\u6cd5' , '\u4e25\u654f\u541b' , 78.5 , 6 , 13 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , '\u600e\u6837\u62d0\u8dd1\u522b\u4eba\u7684\u5ab3\u5987' , '\u9f99\u4f0d' , 68, 99999 , 52 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , '\u6728\u865a\u8089\u76d6\u996d' , '\u5c0f\u80d6' , 16, 1000 , 50 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , 'C++\u7f16\u7a0b\u601d\u60f3' , '\u521a\u54e5' , 45.5 , 14 , 95 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , '\u86cb\u7092\u996d' , '\u5468\u661f\u661f' , 9.9, 12 , 53 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , '\u8d4c\u795e' , '\u9f99\u4f0d' , 66.5, 125 , 535 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , 'Java\u7f16\u7a0b\u601d\u60f3' , '\u9633\u54e5' , 99.5 , 47 , 36 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , 'JavaScript\u4ece\u5165\u95e8\u5230\u7cbe\u901a' , '\u5a77\u59d0' , 9.9 , 85 , 95 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , 'cocos2d-x\u6e38\u620f\u7f16\u7a0b\u5165\u95e8' , '\u56fd\u54e5' , 49, 52 , 62 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , 'C\u8bed\u8a00\u7a0b\u5e8f\u8bbe\u8ba1' , '\u8c2d\u6d69\u5f3a' , 28 , 52 , 74 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , 'Lua\u8bed\u8a00\u7a0b\u5e8f\u8bbe\u8ba1' , '\u96f7\u4e30\u9633' , 51.5 , 48 , 82 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , '\u897f\u6e38\u8bb0' , '\u7f57\u8d2f\u4e2d' , 12, 19 , 9999 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , '\u6c34\u6d52\u4f20' , '\u534e\u4ed4' , 33.05 , 22 , 88 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , '\u64cd\u4f5c\u7cfb\u7edf\u539f\u7406' , '\u5218\u4f18' , 133.05 , 122 , 188 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , '\u6570\u636e\u7ed3\u6784 java\u7248' , '\u5c01\u5927\u795e' , 173.15 , 21 , 81 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , 'UNIX\u9ad8\u7ea7\u73af\u5883\u7f16\u7a0b' , '\u4e50\u5929' , 99.15 , 210 , 810 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , 'javaScript\u9ad8\u7ea7\u7f16\u7a0b' , '\u56fd\u54e5' , 69.15 , 210 , 810 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , '\u5927\u8bdd\u8bbe\u8ba1\u6a21\u5f0f' , '\u56fd\u54e5' , 89.15 , 20 , 10 , 'static\/img\/default.jpg');\n\ninsert into t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)\nvalues(null , '\u4eba\u6708\u795e\u8bdd' , '\u521a\u54e5' , 88.15 , 20 , 80 , 'static\/img\/default.jpg');\n\n# \u67e5\u770b\u8868\u5185\u5bb9\nselect id,name,author,price,sales,stock,img_path from t_book;\n<\/code><\/pre>\n\n\n\n1.2\u3001\u7f16\u5199\u56fe\u4e66\u6a21\u5757\u7684 JavaBean<\/h3>\n\n\n\npackage top.qaqaq.pojo;\n\nimport java.math.BigDecimal;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-10 \u4e0b\u5348 5:22\n *\/\npublic class Book {\n\n private Integer id;\n private String name; \/\/\u540d\u79f0\n private String author; \/\/\u4f5c\u8005\n private BigDecimal price; \/\/\u4ef7\u683c\n private Integer sales; \/\/\u9500\u91cf\n private Integer stock; \/\/\u5e93\u5b58\n private String imgpath = \"static\/img\/default.jpg\"; \/\/\u56fe\u7247\n\n public Book() {\n }\n\n public Book(Integer id, String name, String author, BigDecimal price, Integer sales, Integer stock, String imgpath) {\n this.id = id;\n this.name = name;\n this.author = author;\n this.price = price;\n this.sales = sales;\n this.stock = stock;\n \/\/ \u8981\u6c42\u7ed9\u5b9a\u7684\u56fe\u4e66\u5c01\u9762\u56fe\u4e66\u8def\u5f84\u4e0d\u80fd\u4e3a\u7a7a\n if (imgpath != null && !\"\".equals(imgpath)){\n this.imgpath = imgpath;\n }\n }\n\n public Integer getId() {\n return id;\n }\n\n public void setId(Integer id) {\n this.id = id;\n }\n\n public String getName() {\n return name;\n }\n\n public void setName(String name) {\n this.name = name;\n }\n\n public String getAuthor() {\n return author;\n }\n\n public void setAuthor(String author) {\n this.author = author;\n }\n\n public BigDecimal getPrice() {\n return price;\n }\n\n public void setPrice(BigDecimal price) {\n this.price = price;\n }\n\n public Integer getSales() {\n return sales;\n }\n\n public void setSales(Integer sales) {\n this.sales = sales;\n }\n\n public Integer getStock() {\n return stock;\n }\n\n public void setStock(Integer stock) {\n this.stock = stock;\n }\n\n public String getImgpath() {\n return imgpath;\n }\n\n public void setImgpath(String imgpath) {\n \/\/ \u8981\u6c42\u7ed9\u5b9a\u7684\u56fe\u4e66\u5c01\u9762\u56fe\u4e66\u8def\u5f84\u4e0d\u80fd\u4e3a\u7a7a\n if (imgpath != null && !\"\".equals(imgpath)){\n this.imgpath = imgpath;\n }\n }\n\n @Override\n public String toString() {\n return \"Book{\" +\n \"id=\" + id +\n \", name='\" + name + '\\'' +\n \", author='\" + author + '\\'' +\n \", price=\" + price +\n \", sales=\" + sales +\n \", stock=\" + stock +\n \", imgpath='\" + imgpath + '\\'' +\n '}';\n }\n}\n<\/code><\/pre>\n\n\n\n1.3\u3001\u7f16\u5199\u56fe\u4e66\u6a21\u5757\u7684 Dao \u548c\u6d4b\u8bd5 Dao<\/h3>\n\n\n\n
Dao \u63a5\u53e3<\/p>\n\n\n\n
package top.qaqaq.dao;\n\nimport top.qaqaq.pojo.Book;\n\nimport java.util.List;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-10 \u4e0b\u5348 5:36\n *\/\npublic interface BookDao {\n\n \/**\n * \u6dfb\u52a0\u56fe\u4e66\n * @param book\n * @return\n *\/\n public int addBook(Book book);\n\n \/**\n * \u6839\u636e\u56fe\u4e66id\u5220\u9664\u56fe\u4e66\n * @param id\n * @return\n *\/\n public int deleteBookById(Integer id);\n\n \/**\n * \u6839\u636e\u56fe\u4e66id\u66f4\u65b0\u56fe\u4e66\n * @param book\n * @return\n *\/\n public int updateBook(Book book);\n\n \/**\n * \u6839\u636e\u56fe\u4e66id\u67e5\u8be2\u56fe\u4e66\n * @param id\n * @return\n *\/\n public Book queryBookById(Integer id);\n\n \/**\n * \u67e5\u8be2\u5168\u90e8\u56fe\u4e66\n * @return\n *\/\n public List<Book> queryBooks();\n\n\n}\n<\/code><\/pre>\n\n\n\nBookDaoImpl \u5b9e\u73b0\u7c7b\uff1a<\/p>\n\n\n\n
package top.qaqaq.dao.impl;\n\nimport top.qaqaq.dao.BookDao;\nimport top.qaqaq.pojo.Book;\n\nimport java.util.List;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-10 \u4e0b\u5348 5:40\n *\/\npublic class BookDaoImpl extends BaseDao implements BookDao {\n @Override\n public int addBook(Book book) {\n\n String sql = \"insert into t_book(name,author,price,sales,stock,img_path) values(?,?,?,?,?,?)\";\n\n return update(sql, book.getName(), book.getAuthor(), book.getPrice(), book.getSales(), book.getStock(), book.getImgpath());\n }\n\n @Override\n public int deleteBookById(Integer id) {\n\n String sql = \"delete from t_book where id = ?\";\n\n return update(sql, id);\n }\n\n @Override\n public int updateBook(Book book) {\n\n String sql = \"update t_book set name=?,author=?,price=?,sales=?,stock=?,img_path=? where id = ?\";\n\n return update(sql, book.getName(), book.getAuthor(), book.getPrice(), book.getSales(), book.getStock(), book.getImgpath(), book.getId());\n }\n\n @Override\n public Book queryBookById(Integer id) {\n\n String sql = \"select id,name,author,price,sales,stock,img_path imgpath from t_book where id = ?\";\n\n return queryForOne(Book.class, sql, id);\n }\n\n @Override\n public List<Book> queryBooks() {\n\n String sql = \"select id,name,author,price,sales,stock,img_path imgpath from t_book\";\n\n return queryForList(Book.class, sql);\n }\n}\n<\/code><\/pre>\n\n\n\nBookDao \u7684\u6d4b\u8bd5\uff1a<\/p>\n\n\n\n
package top.qaqaq.test;\n\nimport org.junit.Test;\nimport top.qaqaq.dao.BookDao;\nimport top.qaqaq.dao.impl.BookDaoImpl;\nimport top.qaqaq.pojo.Book;\n\nimport java.math.BigDecimal;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-10 \u4e0b\u5348 5:54\n *\/\npublic class BookDaoTest {\n\n private BookDao bookDao = new BookDaoImpl();\n\n @Test\n public void addBook() {\n bookDao.addBook(new Book(null,\"\u6211\u4e3a\u4ec0\u4e48\u8fd9\u4e48\u5e05\uff01\",\"191125\",new BigDecimal(9999),1100000,0,null));\n }\n\n @Test\n public void deleteBookById() {\n bookDao.deleteBookById(21);\n }\n\n @Test\n public void updateBook() {\n bookDao.updateBook(new Book(21,\"\u5927\u5bb6\u90fd\u53ef\u4ee5\u8fd9\u4e48\u5e05\uff01\",\"\u81ea\u5df1\",new BigDecimal(9999),1100000,0,null));\n }\n\n @Test\n public void queryBookById() {\n System.out.println(bookDao.queryBookById(21));\n }\n\n @Test\n public void queryBooks() {\n bookDao.queryBooks().forEach(System.out::println);\n }\n}<\/code><\/pre>\n\n\n\n1.4\u3001\u7f16\u5199\u56fe\u4e66\u6a21\u5757\u7684 Service \u548c\u6d4b\u8bd5 Service<\/h3>\n\n\n\n
BookService \u63a5\u53e3<\/p>\n\n\n\n
package top.qaqaq.service;\n\nimport top.qaqaq.pojo.Book;\n\nimport java.util.List;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-10 \u4e0b\u5348 7:37\n *\/\npublic interface BookService {\n\n \/**\n * \u6dfb\u52a0\u56fe\u4e66\n * @param book\n *\/\n public void addBook(Book book);\n\n \/**\n * \u6839\u636e\u56fe\u4e66id\u5220\u9664\u56fe\u4e66\n * @param id\n *\/\n public void deleteBookById(Integer id);\n\n \/**\n * \u6839\u636e\u56fe\u4e66id\u66f4\u65b0\u56fe\u4e66\n * @param book\n *\/\n public void updateBook(Book book);\n\n \/**\n * \u6839\u636e\u56fe\u4e66id\u67e5\u8be2\u56fe\u4e66\n * @param id\n * @return\n *\/\n public Book queryBookById(Integer id);\n\n \/**\n * \u67e5\u8be2\u5168\u90e8\u56fe\u4e66\n * @return\n *\/\n public List<Book> queryBooks();\n}\n<\/code><\/pre>\n\n\n\nBookServiceImpl \u5b9e\u73b0\u7c7b\uff1a<\/p>\n\n\n\n
package top.qaqaq.service.impl;\n\nimport top.qaqaq.dao.BookDao;\nimport top.qaqaq.dao.impl.BookDaoImpl;\nimport top.qaqaq.pojo.Book;\nimport top.qaqaq.service.BookService;\n\nimport java.util.List;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-10 \u4e0b\u5348 7:42\n *\/\npublic class BookServiceImpl implements BookService {\n\n private BookDao bookDao = new BookDaoImpl();\n\n @Override\n public void addBook(Book book) {\n bookDao.addBook(book);\n }\n\n @Override\n public void deleteBookById(Integer id) {\n bookDao.deleteBookById(id);\n }\n\n @Override\n public void updateBook(Book book) {\n bookDao.updateBook(book);\n }\n\n @Override\n public Book queryBookById(Integer id) {\n return bookDao.queryBookById(id);\n }\n\n @Override\n public List<Book> queryBooks() {\n return bookDao.queryBooks();\n }\n}\n<\/code><\/pre>\n\n\n\nBookService \u7684\u6d4b\u8bd5\uff1a<\/p>\n\n\n\n
package top.qaqaq.test;\n\nimport org.junit.Test;\nimport top.qaqaq.pojo.Book;\nimport top.qaqaq.service.BookService;\nimport top.qaqaq.service.impl.BookServiceImpl;\n\nimport java.math.BigDecimal;\n\nimport static org.junit.Assert.*;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-10 \u4e0b\u5348 7:45\n *\/\npublic class BookServiceTest {\n\n private BookService bookService = new BookServiceImpl();\n\n @Test\n public void addBook() {\n bookService.addBook(new Book(null,\"\u4f60\u597d\u6211\u597d\u5927\u5bb6\u597d\",\"1125\",new BigDecimal(100000),10000000,0,null));\n }\n\n @Test\n public void deleteBookById() {\n bookService.deleteBookById(22);\n }\n\n @Test\n public void updateBook() {\n bookService.updateBook(new Book(22,\"\u5927\u5bb6\u597d\",\"1125\",new BigDecimal(999999),10,1000000,null));\n }\n\n @Test\n public void queryBookById() {\n System.out.println(bookService.queryBookById(22));\n }\n\n @Test\n public void queryBooks() {\n bookService.queryBooks().forEach(System.out::println);\n }\n}<\/code><\/pre>\n\n\n\n1.5\u3001\u7f16\u5199\u56fe\u4e66\u6a21\u5757\u7684 Web \u5c42\uff0c\u548c\u9875\u9762\u8054\u8c03\u6d4b\u8bd5<\/h3>\n\n\n\n1.5.1\u3001\u56fe\u4e66\u5217\u8868\u529f\u80fd\u7684\u5b9e\u73b0<\/h4>\n\n\n\n
1\u3001\u56fe\u89e3\u5217\u8868\u529f\u80fd\u6d41\u7a0b\uff1a<\/p>\n\n\n\n<\/div><\/figure>\n\n\n\n2\u3001BookServlet \u7a0b\u5e8f\u4e2d\u6dfb\u52a0 list \u65b9\u6cd5<\/p>\n\n\n\n
package top.qaqaq.web;\n\nimport jakarta.servlet.ServletException;\nimport jakarta.servlet.http.HttpServletRequest;\nimport jakarta.servlet.http.HttpServletResponse;\nimport top.qaqaq.pojo.Book;\nimport top.qaqaq.service.BookService;\nimport top.qaqaq.service.impl.BookServiceImpl;\n\nimport java.io.IOException;\nimport java.util.List;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-10 \u4e0b\u5348 7:51\n *\/\npublic class BookServlet extends BaseServlet {\n\n private BookService bookService = new BookServiceImpl();\n\n protected void add(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n }\n\n protected void delete(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n }\n\n protected void update(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n }\n\n protected void list(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u901a\u8fc7BookService\u67e5\u8be2\u5168\u90e8\u56fe\u4e66\n List<Book> books = bookService.queryBooks();\n \/\/ 2. \u628a\u5168\u90e8\u56fe\u4e66\u4fdd\u5b58\u5230Request\u57df\u4e2d\n req.setAttribute(\"books\", books);\n \/\/ 3. \u8bf7\u6c42\u8f6c\u53d1\u5230\/pages\/manager\/book_manager.jsp\u9875\u9762\n req.getRequestDispatcher(\"\/pages\/manager\/book_manager.jsp\").forward(req,resp);\n\n }\n}\n<\/code><\/pre>\n\n\n\n3\u3001\u4fee\u6539\u3010\u56fe\u4e66\u7ba1\u7406\u3011\u8bf7\u6c42\u5730\u5740<\/p>\n\n\n\n
<%--\n Created by IntelliJ IDEA.\n User: ZRich\n Date: 2022\/12\/9\n Time: \u4e0b\u5348 5:33\n To change this template use File | Settings | File Templates.\n--%>\n<%@ page contentType=\"text\/html;charset=UTF-8\" language=\"java\" %>\n\n<div>\n <%-- action=list\u8868\u793a\u8c03\u7528BookServlet.java\u91cc\u7684list\u65b9\u6cd5 --%>\n <a href=\"manager\/bookServlet?action=list\">\u56fe\u4e66\u7ba1\u7406<\/a>\n <a href=\"pages\/manager\/order_manager.jsp\">\u8ba2\u5355\u7ba1\u7406<\/a>\n <a href=\"index.jsp\">\u8fd4\u56de\u5546\u57ce<\/a>\n<\/div>\n<\/code><\/pre>\n\n\n\n4\u3001\u4fee\u6539 pages\/manager\/book_manager.jsp \u9875\u9762\u7684\u6570\u636e\u904d\u5386\u8f93\u51fa<\/p>\n\n\n\n
<%@ taglib prefix=\"c\" uri=\"http:\/\/java.sun.com\/jsp\/jstl\/core\" %>\n<%@ page contentType=\"text\/html;charset=UTF-8\" language=\"java\" %>\n<!DOCTYPE html>\n<html>\n<head>\n<meta charset=\"UTF-8\">\n<title>\u56fe\u4e66\u7ba1\u7406<\/title>\n\n\t<%-- \u9759\u6001\u5305\u542b base\u6807\u7b7e\uff0ccss\u6837\u5f0f\uff0cjQuery\u6587\u4ef6 --%>\n\t<%@ include file=\"\/pages\/common\/head.jsp\"%>\n\n<\/head>\n<body>\n\t\n\t<div id=\"header\">\n\t\t\t<img class=\"logo_img\" alt=\"\" src=\"..\/..\/static\/img\/logo.gif\" >\n\t\t\t<span class=\"wel_word\">\u56fe\u4e66\u7ba1\u7406\u7cfb\u7edf<\/span>\n\n\t\t\t<%-- \u9759\u6001\u5305\u542b manager \u7ba1\u7406\u6a21\u5757\u7684\u83dc\u5355 --%>\n\t\t\t<%@include file=\"\/pages\/common\/manager_menu.jsp\"%>\n\n\t<\/div>\n\t\n\t<div id=\"main\">\n\t\t<table>\n\t\t\t<tr>\n\t\t\t\t<td>\u540d\u79f0<\/td>\n\t\t\t\t<td>\u4ef7\u683c<\/td>\n\t\t\t\t<td>\u4f5c\u8005<\/td>\n\t\t\t\t<td>\u9500\u91cf<\/td>\n\t\t\t\t<td>\u5e93\u5b58<\/td>\n\t\t\t\t<td colspan=\"2\">\u64cd\u4f5c<\/td>\n\t\t\t<\/tr>\n\n\t\t\t<c:forEach items=\"${requestScope.books}\" var=\"book\">\n\t\t\t\t<tr>\n\t\t\t\t\t<td>${book.name}<\/td>\n\t\t\t\t\t<td>${book.price}<\/td>\n\t\t\t\t\t<td>${book.author}<\/td>\n\t\t\t\t\t<td>${book.sales}<\/td>\n\t\t\t\t\t<td>${book.stock}<\/td>\n\t\t\t\t\t<td><a href=\"book_edit.jsp\">\u4fee\u6539<\/a><\/td>\n\t\t\t\t\t<td><a href=\"#\">\u5220\u9664<\/a><\/td>\n\t\t\t\t<\/tr>\n\t\t\t<\/c:forEach>\n\n\t\t\t<tr>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><a href=\"book_edit.jsp\">\u6dfb\u52a0\u56fe\u4e66<\/a><\/td>\n\t\t\t<\/tr>\t\n\t\t<\/table>\n\t<\/div>\n\n\t<%-- \u9759\u6001\u5305\u542b\u9875\u811a\u5185\u5bb9 --%>\n\t<%@include file=\"\/pages\/common\/footer.jsp\"%>\n\n<\/body>\n<\/html><\/code><\/pre>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.2\u3001\u524d\u540e\u53f0\u7684\u7b80\u5355\u4ecb\u7ecd<\/h4>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.3\u3001\u6dfb\u52a0\u56fe\u4e66\u529f\u80fd\u7684\u5b9e\u73b0<\/h4>\n\n\n\n
1.5.3.1\u3001\u6dfb\u52a0\u56fe\u4e66\u6d41\u7a0b\u7ec6\u8282\uff1a<\/p>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.3.2\u3001\u95ee\u9898\u8bf4\u660e\uff1a\u8868\u5355\u91cd\u590d\u63d0\u4ea4\uff1a<\/p>\n\n\n\n
\u5f53\u7528\u6237\u63d0\u4ea4\u5b8c\u8bf7\u6c42\uff0c\u6d4f\u89c8\u5668\u4f1a\u8bb0\u5f55\u4e0b\u6700\u540e\u4e00\u6b21\u8bf7\u6c42\u7684\u5168\u90e8\u4fe1\u606f\u3002\u5f53\u7528\u6237\u6309\u4e0b\u529f\u80fd\u952e F5\uff0c\u5c31\u4f1a\u53d1\u8d77\u6d4f\u89c8\u5668\u8bb0\u5f55\u7684\u6700\u540e\u4e00\u6b21\u8bf7\u6c42\u3002<\/p>\n\n\n\n
1.5.3.3\u3001BookServlet \u7a0b\u5e8f\u4e2d\u6dfb\u52a0 add \u65b9\u6cd5<\/p>\n\n\n\n
package top.qaqaq.web;\n\nimport jakarta.servlet.ServletException;\nimport jakarta.servlet.http.HttpServletRequest;\nimport jakarta.servlet.http.HttpServletResponse;\nimport top.qaqaq.pojo.Book;\nimport top.qaqaq.service.BookService;\nimport top.qaqaq.service.impl.BookServiceImpl;\nimport top.qaqaq.utils.WebUtils;\n\nimport java.io.IOException;\nimport java.util.List;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-10 \u4e0b\u5348 7:51\n *\/\npublic class BookServlet extends BaseServlet {\n\n private BookService bookService = new BookServiceImpl();\n\n \/**\n * \u8d1f\u8d23\u6dfb\u52a0\u56fe\u4e66\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void add(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570==\u5c01\u88c5\u6210\u4e3aBook\u5bf9\u8c61\n Book book = WebUtils.copyParamToBean(req.getParameterMap(), new Book());\n \/\/ 2. \u8c03\u7528BookService.addBook()\u4fdd\u5b58\u56fe\u4e66\n bookService.addBook(book);\n \/\/ 3. \u8df3\u5230\u56fe\u4e66\u5217\u8868\u9875\u9762\n \/\/ \/manager\/bookServlet?action=list\n\n \/\/ \u5982\u679c\u4f7f\u7528\u8bf7\u6c42\u8f6c\u53d1\uff0c\u5219\u4e3a\u4e00\u6b21\u8bf7\u6c42\uff0c\u5237\u65b0\u4f1a\u91cd\u590d\u63d0\u4ea4\u6570\u636e\n\/\/ req.getRequestDispatcher(\"\/manager\/bookServlet?action=list\").forward(req,resp);\n \/\/ \u6240\u4ee5\u4f7f\u7528\u8bf7\u6c42\u91cd\u5b9a\u5411\n resp.sendRedirect(req.getContextPath() + \"\/manager\/bookServlet?action=list\");\n\n }\n\n \/**\n * \u8d1f\u8d23\u5220\u9664\u56fe\u4e66\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void delete(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570id\uff0c\u56fe\u4e66\u7f16\u7a0b\n int id = WebUtils.parseInt(req.getParameter(\"id\"),0);\n\n \/\/ 2. \u8c03\u7528bookService.deleteBookById();\u5220\u9664\u56fe\u4e66\n bookService.deleteBookById(id);\n \/\/ 3. \u91cd\u5b9a\u5411\u56de\u56fe\u4e66\u5217\u8868\u7ba1\u7406\u9875\u9762\n \/\/ \/book\/manager\/bookServlet?action=list\n resp.sendRedirect(req.getContextPath() + \"\/manager\/bookServlet?action=list\");\n }\n\n \/**\n * \u4fdd\u5b58\u4fee\u6539\u56fe\u4e66\u7684\u64cd\u4f5c\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void update(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570==\u5c01\u88c5\u6210\u4e3aBook\u5bf9\u8c61\n Book book = WebUtils.copyParamToBean(req.getParameterMap(), new Book());\n \/\/ 2. \u8c03\u7528BookService.updateBook( book );\u4fee\u6539\u56fe\u4e66\n bookService.updateBook(book);\n \/\/ 3. \u91cd\u5b9a\u5411\u56de\u56fe\u4e66\u5217\u8868\u7ba1\u7406\u9875\u9762\n \/\/ \u5730\u5740\uff1a\/\u5de5\u7a0b\u540d\/manager\/bookServlet?action=list\n resp.sendRedirect(req.getContextPath() + \"\/manager\/bookServlet?action=list\");\n\n }\n\n \/**\n * \u83b7\u53d6\u8981\u4fee\u6539\u7684\u56fe\u4e66\u4fe1\u606f\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void getBook(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570\u56fe\u4e66\u7f16\u53f7\n int id = WebUtils.parseInt(req.getParameter(\"id\"),0);\n \/\/ 2. \u8c03\u7528bookService.queryBookById\u67e5\u8be2\u56fe\u4e66\n Book book = bookService.queryBookById(id);\n \/\/ 3. \u4fdd\u5b58\u56fe\u4e66\u5230Request\u57df\u4e2d\n req.setAttribute(\"book\",book);\n \/\/ 4. \u8bf7\u6c42\u8f6c\u53d1\u5230\u3002pages\/manager\/book_edit.jsp\u9875\u9762\n req.getRequestDispatcher(\"\/pages\/manager\/book_edit.jsp\").forward(req,resp);\n }\n\n \/**\n * \u8d1f\u8d23\u904d\u5386\u56fe\u4e66\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void list(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u901a\u8fc7BookService\u67e5\u8be2\u5168\u90e8\u56fe\u4e66\n List<Book> books = bookService.queryBooks();\n \/\/ 2. \u628a\u5168\u90e8\u56fe\u4e66\u4fdd\u5b58\u5230Request\u57df\u4e2d\n req.setAttribute(\"books\", books);\n \/\/ 3. \u8bf7\u6c42\u8f6c\u53d1\u5230\/pages\/manager\/book_manager.jsp\u9875\u9762\n req.getRequestDispatcher(\"\/pages\/manager\/book_manager.jsp\").forward(req,resp);\n\n }\n}\n<\/code><\/pre>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.3.4\u3001\u4fee\u6539 book_edit.jsp \u9875\u9762<\/p>\n\n\n\n
<%@ page contentType=\"text\/html;charset=UTF-8\" language=\"java\" %>\n<!DOCTYPE html>\n<html>\n<head>\n<meta charset=\"UTF-8\">\n<title>\u7f16\u8f91\u56fe\u4e66<\/title>\n\n\t<%-- \u9759\u6001\u5305\u542b base\u6807\u7b7e\uff0ccss\u6837\u5f0f\uff0cjQuery\u6587\u4ef6 --%>\n\t<%@ include file=\"\/pages\/common\/head.jsp\"%>\n\n\t<style type=\"text\/css\">\n\th1 {\n\t\ttext-align: center;\n\t\tmargin-top: 200px;\n\t}\n\t\n\th1 a {\n\t\tcolor:red;\n\t}\n\t\n\tinput {\n\t\ttext-align: center;\n\t}\n<\/style>\n<\/head>\n<body>\n<!--\n\t\u9047\u5230\u7684\u95ee\u9898\uff1a\n\tbook_edit.jsp\u9875\u9762\uff0c\u65e2\u8981\u505a\u6dfb\u52a0\u64cd\u4f5c\u3002\u53c8\u8981\u505a\u4fee\u6539\u64cd\u4f5c\uff0c\u800c\u5230\u5e95\u662f\u6dfb\u52a0\uff0c\u8fd8\u662f\u4fee\u6539\u662f\u7531\u4e00\u4e2a\u9690\u85cf\u57df\u6765\u51b3\u5b9a\u7684\u3002\n\t\u5982\u4f55\u52a8\u6001\u4fee\u6539\u9690\u85cf\u57df<input type=\"hidden\" name=\"action\" value=\"xxx\" \/> \u8ba9\u5b83\u7684\u503c\u65e2\u53ef\u4ee5\u5b9e\u73b0\u6dfb\u52a0\uff0c\u53c8\u53ef\u4ee5\u5b9e\u73b0\u4fee\u6539\u64cd\u4f5c\uff1f\n\n\t\/\/\u65b9\u6848\u4e00\uff1a\n\t\u53ef\u4ee5\u5f53\u8bf7\u6c42\u53d1\u8d77\u65f6\uff0c\u9644\u5e26\u4e0a\u5f53\u524d\u8981\u64cd\u4f5c\u7684\u503c\u3002\u5e76\u6ce8\u5165\u5230\u9690\u85cf\u57df\u4e2d\u3002\n\n\t\/\/\u65b9\u6848\u4e8c\uff1a\n\t\u53ef\u4ee5\u901a\u8fc7\u5224\u65ad\u5f53\u524d\u8bf7\u6c42\u53c2\u6570\u4e2d\u662f\u5426\u5305\u542b\u6709id\u53c2\u6570\u3002\u5982\u679c\u6709\u8bf4\u660e\u662f\u4fee\u6539\u64cd\u4f5c\u3002\u5982\u679c\u6ca1\u6709\u8bf4\u660e\u662f\u6dfb\u52a0\u64cd\u4f5c\u3002\n\t\u662f\u5426\u662f\u6dfb\u52a0\u64cd\u4f5c\uff1a\n<%--\t${ empty param.id ? \"add\" : \"update\"}--%>\n\n\t\/\/\u65b9\u6848\u4e09\uff1a\n\t\u53ef\u4ee5\u901a\u8fc7\u5224\u65ad\uff0cRequest\u57df\u4e2d\u662f\u5426\u5305\u542b\u6709\u4fee\u6539\u7684\u56fe\u4e66\u4fe1\u606f\u5bf9\u8c61\uff0c\u5982\u679c\u6ca1\u6709\u8bf4\u660e\u662f\u6dfb\u52a0\u64cd\u4f5c\u3002\u5982\u679c\u6709\u8bf4\u660e\u662f\u4fee\u6539\u64cd\u4f5c\u3002\n\t\u662f\u5426\u662f\u6dfb\u52a0\u64cd\u4f5c\uff1a\n<%--\t${ empty requestScope.book ? \"add\" : \"update\"}--%>\n-->\n\n\t\t<div id=\"header\">\n\t\t\t<img class=\"logo_img\" alt=\"\" src=\"..\/..\/static\/img\/logo.gif\" >\n\t\t\t<span class=\"wel_word\">\u7f16\u8f91\u56fe\u4e66<\/span>\n\n\t\t\t<%-- \u9759\u6001\u5305\u542b manager \u7ba1\u7406\u6a21\u5757\u7684\u83dc\u5355 --%>\n\t\t\t<%@include file=\"\/pages\/common\/manager_menu.jsp\"%>\n\n\t\t<\/div>\n\t\t\n\t\t<div id=\"main\">\n\t\t\t<form action=\"manager\/bookServlet\" method=\"get\">\n\t\t\t\t<input type=\"hidden\" name=\"action\" value=\"${ empty param.id ? \"add\" : \"update\"}\" \/>\n\t\t\t\t<input type=\"hidden\" name=\"id\" value=\"${requestScope.book.id}\" \/>\n\t\t\t\t<table>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td>\u540d\u79f0<\/td>\n\t\t\t\t\t\t<td>\u4ef7\u683c<\/td>\n\t\t\t\t\t\t<td>\u4f5c\u8005<\/td>\n\t\t\t\t\t\t<td>\u9500\u91cf<\/td>\n\t\t\t\t\t\t<td>\u5e93\u5b58<\/td>\n\t\t\t\t\t\t<td colspan=\"2\">\u64cd\u4f5c<\/td>\n\t\t\t\t\t<\/tr>\t\t\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td><input name=\"name\" type=\"text\" value=\"${requestScope.book.name}\"\/><\/td>\n\t\t\t\t\t\t<td><input name=\"price\" type=\"text\" value=\"${requestScope.book.price}\"\/><\/td>\n\t\t\t\t\t\t<td><input name=\"author\" type=\"text\" value=\"${requestScope.book.author}\"\/><\/td>\n\t\t\t\t\t\t<td><input name=\"sales\" type=\"text\" value=\"${requestScope.book.sales}\"\/><\/td>\n\t\t\t\t\t\t<td><input name=\"stock\" type=\"text\" value=\"${requestScope.book.stock}\"\/><\/td>\n\t\t\t\t\t\t<td><input type=\"submit\" value=\"\u63d0\u4ea4\"\/><\/td>\n\t\t\t\t\t<\/tr>\t\n\t\t\t\t<\/table>\n\t\t\t<\/form>\n\t\t\t\n\t\n\t\t<\/div>\n\n\t\t<%-- \u9759\u6001\u5305\u542b\u9875\u811a\u5185\u5bb9 --%>\n\t\t<%@include file=\"\/pages\/common\/footer.jsp\"%>\n\n<\/body>\n<\/html><\/code><\/pre>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.4\u3001\u5220\u9664\u56fe\u4e66\u529f\u80fd\u7684\u5b9e\u73b0<\/h3>\n\n\n\n
1.5.4.1\u3001\u56fe\u89e3\u5220\u9664\u6d41\u7a0b\uff1a<\/p>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.4.2\u3001BookServlet \u7a0b\u5e8f\u4e2d\u7684 delete \u65b9\u6cd5\uff1a<\/p>\n\n\n\n
package top.qaqaq.web;\n\nimport jakarta.servlet.ServletException;\nimport jakarta.servlet.http.HttpServletRequest;\nimport jakarta.servlet.http.HttpServletResponse;\nimport top.qaqaq.pojo.Book;\nimport top.qaqaq.service.BookService;\nimport top.qaqaq.service.impl.BookServiceImpl;\nimport top.qaqaq.utils.WebUtils;\n\nimport java.io.IOException;\nimport java.util.List;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-10 \u4e0b\u5348 7:51\n *\/\npublic class BookServlet extends BaseServlet {\n\n private BookService bookService = new BookServiceImpl();\n\n \/**\n * \u8d1f\u8d23\u6dfb\u52a0\u56fe\u4e66\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void add(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570==\u5c01\u88c5\u6210\u4e3aBook\u5bf9\u8c61\n Book book = WebUtils.copyParamToBean(req.getParameterMap(), new Book());\n \/\/ 2. \u8c03\u7528BookService.addBook()\u4fdd\u5b58\u56fe\u4e66\n bookService.addBook(book);\n \/\/ 3. \u8df3\u5230\u56fe\u4e66\u5217\u8868\u9875\u9762\n \/\/ \/manager\/bookServlet?action=list\n\n \/\/ \u5982\u679c\u4f7f\u7528\u8bf7\u6c42\u8f6c\u53d1\uff0c\u5219\u4e3a\u4e00\u6b21\u8bf7\u6c42\uff0c\u5237\u65b0\u4f1a\u91cd\u590d\u63d0\u4ea4\u6570\u636e\n\/\/ req.getRequestDispatcher(\"\/manager\/bookServlet?action=list\").forward(req,resp);\n \/\/ \u6240\u4ee5\u4f7f\u7528\u8bf7\u6c42\u91cd\u5b9a\u5411\n resp.sendRedirect(req.getContextPath() + \"\/manager\/bookServlet?action=list\");\n\n }\n\n \/**\n * \u8d1f\u8d23\u5220\u9664\u56fe\u4e66\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void delete(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570id\uff0c\u56fe\u4e66\u7f16\u7a0b\n int id = WebUtils.parseInt(req.getParameter(\"id\"),0);\n\n \/\/ 2. \u8c03\u7528bookService.deleteBookById();\u5220\u9664\u56fe\u4e66\n bookService.deleteBookById(id);\n \/\/ 3. \u91cd\u5b9a\u5411\u56de\u56fe\u4e66\u5217\u8868\u7ba1\u7406\u9875\u9762\n \/\/ \/book\/manager\/bookServlet?action=list\n resp.sendRedirect(req.getContextPath() + \"\/manager\/bookServlet?action=list\");\n }\n\n \/**\n * \u4fdd\u5b58\u4fee\u6539\u56fe\u4e66\u7684\u64cd\u4f5c\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void update(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570==\u5c01\u88c5\u6210\u4e3aBook\u5bf9\u8c61\n Book book = WebUtils.copyParamToBean(req.getParameterMap(), new Book());\n \/\/ 2. \u8c03\u7528BookService.updateBook( book );\u4fee\u6539\u56fe\u4e66\n bookService.updateBook(book);\n \/\/ 3. \u91cd\u5b9a\u5411\u56de\u56fe\u4e66\u5217\u8868\u7ba1\u7406\u9875\u9762\n \/\/ \u5730\u5740\uff1a\/\u5de5\u7a0b\u540d\/manager\/bookServlet?action=list\n resp.sendRedirect(req.getContextPath() + \"\/manager\/bookServlet?action=list\");\n\n }\n\n \/**\n * \u83b7\u53d6\u8981\u4fee\u6539\u7684\u56fe\u4e66\u4fe1\u606f\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void getBook(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570\u56fe\u4e66\u7f16\u53f7\n int id = WebUtils.parseInt(req.getParameter(\"id\"),0);\n \/\/ 2. \u8c03\u7528bookService.queryBookById\u67e5\u8be2\u56fe\u4e66\n Book book = bookService.queryBookById(id);\n \/\/ 3. \u4fdd\u5b58\u56fe\u4e66\u5230Request\u57df\u4e2d\n req.setAttribute(\"book\",book);\n \/\/ 4. \u8bf7\u6c42\u8f6c\u53d1\u5230\u3002pages\/manager\/book_edit.jsp\u9875\u9762\n req.getRequestDispatcher(\"\/pages\/manager\/book_edit.jsp\").forward(req,resp);\n }\n\n \/**\n * \u8d1f\u8d23\u904d\u5386\u56fe\u4e66\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void list(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u901a\u8fc7BookService\u67e5\u8be2\u5168\u90e8\u56fe\u4e66\n List<Book> books = bookService.queryBooks();\n \/\/ 2. \u628a\u5168\u90e8\u56fe\u4e66\u4fdd\u5b58\u5230Request\u57df\u4e2d\n req.setAttribute(\"books\", books);\n \/\/ 3. \u8bf7\u6c42\u8f6c\u53d1\u5230\/pages\/manager\/book_manager.jsp\u9875\u9762\n req.getRequestDispatcher(\"\/pages\/manager\/book_manager.jsp\").forward(req,resp);\n\n }\n}\n<\/code><\/pre>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.4.3\u3001\u7ed9 WebUtils \u5de5\u5177\u7c7b\u6dfb\u52a0\u8f6c\u6362 int \u7c7b\u578b\u7684\u5de5\u5177\u65b9\u6cd5<\/p>\n\n\n\n
package top.qaqaq.utils;\n\nimport org.apache.commons.beanutils.BeanUtils;\n\nimport java.lang.reflect.InvocationTargetException;\nimport java.util.Map;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-10 \u4e0b\u5348 2:11\n *\/\npublic class WebUtils {\n\n \/**\n * \u628aMap\u4e2d\u7684\u503c\u6ce8\u5165\u5230\u5bf9\u5e94\u7684JavaBean\u5c5e\u6027\u4e2d\u3002\n * @param value\n * @param bean\n * \u5982\u679c\u5f62\u53c2\u5199\u6210HttpServletRequest DAO\u5c42\u548cService\u5c42\u6ca1\u6709\u8fd9\u4e2aAPI \u4e14web\u5c42\u8026\u5408\u5ea6\u9ad8\uff0c\u4ee3\u7801\u4e0d\u4f18\u96c5\n * DAO\u5c42\n * Service\u5c42\n * Web\u5c42\n *\/\n public static <T> T copyParamToBean(Map value, T bean) {\n try {\n System.out.println(\"\u6ce8\u5165\u4e4b\u524d\uff1a\" + bean);\n BeanUtils.populate(bean,value);\n System.out.println(\"\u6ce8\u5165\u4e4b\u540e\uff1a\" + bean);\n } catch (IllegalAccessException e) {\n e.printStackTrace();\n } catch (InvocationTargetException e) {\n e.printStackTrace();\n }\n return bean;\n }\n\n \/**\n * \u5c06\u5b57\u7b26\u4e32\u8f6c\u6362\u6210\u4e3aint\u7c7b\u578b\n * @param strInt\n * @param defaultValue\n * @return\n *\/\n public static int parseInt(String strInt, int defaultValue){\n try {\n return Integer.parseInt(strInt);\n } catch (NumberFormatException e) {\n e.printStackTrace();\n }\n return defaultValue;\n }\n}\n<\/code><\/pre>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.4.4\u3001\u4fee\u6539\u5220\u9664\u7684\u8fde\u63a5\u5730\u5740\uff1a<\/p>\n\n\n\n
book_manager.jsp<\/p>\n\n\n\n
<%@ taglib prefix=\"c\" uri=\"http:\/\/java.sun.com\/jsp\/jstl\/core\" %>\n<%@ page contentType=\"text\/html;charset=UTF-8\" language=\"java\" %>\n<!DOCTYPE html>\n<html>\n<head>\n<meta charset=\"UTF-8\">\n<title>\u56fe\u4e66\u7ba1\u7406<\/title>\n\n\t<%-- \u9759\u6001\u5305\u542b base\u6807\u7b7e\uff0ccss\u6837\u5f0f\uff0cjQuery\u6587\u4ef6 --%>\n\t<%@ include file=\"\/pages\/common\/head.jsp\"%>\n\t<script type=\"text\/javascript\">\n\t\t$(function () {\n\t\t\t\/\/ \u7ed9\u5220\u9664\u7684a\u6807\u7b7e\u7ed1\u5b9a\u5355\u51fb\u4e8b\u4ef6\uff0c\u7528\u4e8e\u5220\u9664\u7684\u786e\u8ba4\u63d0\u793a\u64cd\u4f5c\n\t\t\t$(\"a.deleteClass\").click(function () {\n\t\t\t\t\/\/\u5728\u4e8b\u4ef6\u7684function\u51fd\u6570\u4e2d\uff0c\u6709\u4e00\u4e2athis\u5bf9\u8c61\u3002\u8fd9\u4e2athis\u5bf9\u8c61\uff0c\u662f\u5f53\u524d\u6b63\u5728\u54cd\u5e94\u4e8b\u4ef6\u7684dom\u5bf9\u8c61\u3002\n\n\t\t\t\t\/**\n\t\t\t\t * confirm\u662f\u786e\u8ba4\u63d0\u793a\u6846\u51fd\u6570\n\t\t\t\t * \u53c2\u6570\u662f\u5b83\u7684\u63d0\u793a\u5185\u5bb9\n\t\t\t\t * \u5b83\u6709\u4e24\u4e2a\u6309\u94ae\uff0c\u4e00\u4e2a\u786e\u8ba4\uff0c\u4e00\u4e2a\u53d6\u6d88\u3002\n\t\t\t\t * \u8fd4\u56detrue\u8868\u793a\u70b9\u51fb\u4e86\uff0c\u786e\u8ba4\uff0c\u8fd4\u56defalse\u8868\u793a\u70b9\u51fb\u53d6\u6d88\n\t\t\t\t *\/\n\t\t\t\treturn confirm(\"\u4f60\u786e\u5b9a\u8981\u5220\u9664\u3010\" + $(this).parent().parent().find(\"td:first\").text() + \"\u3011\uff1f\")\n\n\t\t\t\t\/\/return false\/\/ \u963b\u6b62\u5143\u7d20\u7684\u9ed8\u8ba4\u884c\u4e3a===\u4e0d\u63d0\u4ea4\u8bf7\u6c42\n\t\t\t})\n\n\t\t})\n\t<\/script>\n\n<\/head>\n<body>\n\t\n\t<div id=\"header\">\n\t\t\t<img class=\"logo_img\" alt=\"\" src=\"..\/..\/static\/img\/logo.gif\" >\n\t\t\t<span class=\"wel_word\">\u56fe\u4e66\u7ba1\u7406\u7cfb\u7edf<\/span>\n\n\t\t\t<%-- \u9759\u6001\u5305\u542b manager \u7ba1\u7406\u6a21\u5757\u7684\u83dc\u5355 --%>\n\t\t\t<%@include file=\"\/pages\/common\/manager_menu.jsp\"%>\n\n\t<\/div>\n\t\n\t<div id=\"main\">\n\t\t<table>\n\t\t\t<tr>\n\t\t\t\t<td>\u540d\u79f0<\/td>\n\t\t\t\t<td>\u4ef7\u683c<\/td>\n\t\t\t\t<td>\u4f5c\u8005<\/td>\n\t\t\t\t<td>\u9500\u91cf<\/td>\n\t\t\t\t<td>\u5e93\u5b58<\/td>\n\t\t\t\t<td colspan=\"2\">\u64cd\u4f5c<\/td>\n\t\t\t<\/tr>\n\n\t\t\t<c:forEach items=\"${requestScope.books}\" var=\"book\">\n\t\t\t\t<tr>\n\t\t\t\t\t<td>${book.name}<\/td>\n\t\t\t\t\t<td>${book.price}<\/td>\n\t\t\t\t\t<td>${book.author}<\/td>\n\t\t\t\t\t<td>${book.sales}<\/td>\n\t\t\t\t\t<td>${book.stock}<\/td>\n\t\t\t\t\t<td><a href=\"manager\/bookServlet?action=getBook&id=${book.id}\">\u4fee\u6539<\/a><\/td>\n\t\t\t\t\t<td><a class=\"deleteClass\" href=\"manager\/bookServlet?action=delete&id=${book.id}\">\u5220\u9664<\/a><\/td>\n\t\t\t\t<\/tr>\n\t\t\t<\/c:forEach>\n\n\t\t\t<tr>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><a href=\"pages\/manager\/book_edit.jsp\">\u6dfb\u52a0\u56fe\u4e66<\/a><\/td>\n\t\t\t<\/tr>\t\n\t\t<\/table>\n\t<\/div>\n\n\t<%-- \u9759\u6001\u5305\u542b\u9875\u811a\u5185\u5bb9 --%>\n\t<%@include file=\"\/pages\/common\/footer.jsp\"%>\n\n<\/body>\n<\/html><\/code><\/pre>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.4.5\u3001\u7ed9\u5220\u9664\u6dfb\u52a0\u786e\u8ba4\u63d0\u793a\u64cd\u4f5c\uff1a<\/p>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.5\u3001\u4fee\u6539\u56fe\u4e66\u529f\u80fd\u7684\u5b9e\u73b0<\/h3>\n\n\n\n
1.5.5.1\uff1a\u56fe\u89e3\u4fee\u6539\u56fe\u4e66\u7ec6\u8282\uff1a<\/p>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.5.2\u3001\u66f4\u65b0\u3010\u4fee\u6539\u3011\u7684\u8bf7\u6c42\u5730\u5740\uff1a<\/p>\n\n\n\n
book_manager.jsp<\/p>\n\n\n\n
<%@ taglib prefix=\"c\" uri=\"http:\/\/java.sun.com\/jsp\/jstl\/core\" %>\n<%@ page contentType=\"text\/html;charset=UTF-8\" language=\"java\" %>\n<!DOCTYPE html>\n<html>\n<head>\n<meta charset=\"UTF-8\">\n<title>\u56fe\u4e66\u7ba1\u7406<\/title>\n\n\t<%-- \u9759\u6001\u5305\u542b base\u6807\u7b7e\uff0ccss\u6837\u5f0f\uff0cjQuery\u6587\u4ef6 --%>\n\t<%@ include file=\"\/pages\/common\/head.jsp\"%>\n\t<script type=\"text\/javascript\">\n\t\t$(function () {\n\t\t\t\/\/ \u7ed9\u5220\u9664\u7684a\u6807\u7b7e\u7ed1\u5b9a\u5355\u51fb\u4e8b\u4ef6\uff0c\u7528\u4e8e\u5220\u9664\u7684\u786e\u8ba4\u63d0\u793a\u64cd\u4f5c\n\t\t\t$(\"a.deleteClass\").click(function () {\n\t\t\t\t\/\/\u5728\u4e8b\u4ef6\u7684function\u51fd\u6570\u4e2d\uff0c\u6709\u4e00\u4e2athis\u5bf9\u8c61\u3002\u8fd9\u4e2athis\u5bf9\u8c61\uff0c\u662f\u5f53\u524d\u6b63\u5728\u54cd\u5e94\u4e8b\u4ef6\u7684dom\u5bf9\u8c61\u3002\n\n\t\t\t\t\/**\n\t\t\t\t * confirm\u662f\u786e\u8ba4\u63d0\u793a\u6846\u51fd\u6570\n\t\t\t\t * \u53c2\u6570\u662f\u5b83\u7684\u63d0\u793a\u5185\u5bb9\n\t\t\t\t * \u5b83\u6709\u4e24\u4e2a\u6309\u94ae\uff0c\u4e00\u4e2a\u786e\u8ba4\uff0c\u4e00\u4e2a\u53d6\u6d88\u3002\n\t\t\t\t * \u8fd4\u56detrue\u8868\u793a\u70b9\u51fb\u4e86\uff0c\u786e\u8ba4\uff0c\u8fd4\u56defalse\u8868\u793a\u70b9\u51fb\u53d6\u6d88\n\t\t\t\t *\/\n\t\t\t\treturn confirm(\"\u4f60\u786e\u5b9a\u8981\u5220\u9664\u3010\" + $(this).parent().parent().find(\"td:first\").text() + \"\u3011\uff1f\")\n\n\t\t\t\t\/\/return false\/\/ \u963b\u6b62\u5143\u7d20\u7684\u9ed8\u8ba4\u884c\u4e3a===\u4e0d\u63d0\u4ea4\u8bf7\u6c42\n\t\t\t})\n\n\t\t})\n\t<\/script>\n\n<\/head>\n<body>\n\t\n\t<div id=\"header\">\n\t\t\t<img class=\"logo_img\" alt=\"\" src=\"..\/..\/static\/img\/logo.gif\" >\n\t\t\t<span class=\"wel_word\">\u56fe\u4e66\u7ba1\u7406\u7cfb\u7edf<\/span>\n\n\t\t\t<%-- \u9759\u6001\u5305\u542b manager \u7ba1\u7406\u6a21\u5757\u7684\u83dc\u5355 --%>\n\t\t\t<%@include file=\"\/pages\/common\/manager_menu.jsp\"%>\n\n\t<\/div>\n\t\n\t<div id=\"main\">\n\t\t<table>\n\t\t\t<tr>\n\t\t\t\t<td>\u540d\u79f0<\/td>\n\t\t\t\t<td>\u4ef7\u683c<\/td>\n\t\t\t\t<td>\u4f5c\u8005<\/td>\n\t\t\t\t<td>\u9500\u91cf<\/td>\n\t\t\t\t<td>\u5e93\u5b58<\/td>\n\t\t\t\t<td colspan=\"2\">\u64cd\u4f5c<\/td>\n\t\t\t<\/tr>\n\n\t\t\t<c:forEach items=\"${requestScope.books}\" var=\"book\">\n\t\t\t\t<tr>\n\t\t\t\t\t<td>${book.name}<\/td>\n\t\t\t\t\t<td>${book.price}<\/td>\n\t\t\t\t\t<td>${book.author}<\/td>\n\t\t\t\t\t<td>${book.sales}<\/td>\n\t\t\t\t\t<td>${book.stock}<\/td>\n\t\t\t\t\t<td><a href=\"manager\/bookServlet?action=getBook&id=${book.id}\">\u4fee\u6539<\/a><\/td>\n\t\t\t\t\t<td><a class=\"deleteClass\" href=\"manager\/bookServlet?action=delete&id=${book.id}\">\u5220\u9664<\/a><\/td>\n\t\t\t\t<\/tr>\n\t\t\t<\/c:forEach>\n\n\t\t\t<tr>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><\/td>\n\t\t\t\t<td><a href=\"pages\/manager\/book_edit.jsp\">\u6dfb\u52a0\u56fe\u4e66<\/a><\/td>\n\t\t\t<\/tr>\t\n\t\t<\/table>\n\t<\/div>\n\n\t<%-- \u9759\u6001\u5305\u542b\u9875\u811a\u5185\u5bb9 --%>\n\t<%@include file=\"\/pages\/common\/footer.jsp\"%>\n\n<\/body>\n<\/html><\/code><\/pre>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.5.3\u3001BookServlet \u7a0b\u5e8f\u4e2d\u6dfb\u52a0 getBook \u65b9\u6cd5\uff1a<\/p>\n\n\n\n
package top.qaqaq.web;\n\nimport jakarta.servlet.ServletException;\nimport jakarta.servlet.http.HttpServletRequest;\nimport jakarta.servlet.http.HttpServletResponse;\nimport top.qaqaq.pojo.Book;\nimport top.qaqaq.service.BookService;\nimport top.qaqaq.service.impl.BookServiceImpl;\nimport top.qaqaq.utils.WebUtils;\n\nimport java.io.IOException;\nimport java.util.List;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-10 \u4e0b\u5348 7:51\n *\/\npublic class BookServlet extends BaseServlet {\n\n private BookService bookService = new BookServiceImpl();\n\n \/**\n * \u8d1f\u8d23\u6dfb\u52a0\u56fe\u4e66\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void add(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570==\u5c01\u88c5\u6210\u4e3aBook\u5bf9\u8c61\n Book book = WebUtils.copyParamToBean(req.getParameterMap(), new Book());\n \/\/ 2. \u8c03\u7528BookService.addBook()\u4fdd\u5b58\u56fe\u4e66\n bookService.addBook(book);\n \/\/ 3. \u8df3\u5230\u56fe\u4e66\u5217\u8868\u9875\u9762\n \/\/ \/manager\/bookServlet?action=list\n\n \/\/ \u5982\u679c\u4f7f\u7528\u8bf7\u6c42\u8f6c\u53d1\uff0c\u5219\u4e3a\u4e00\u6b21\u8bf7\u6c42\uff0c\u5237\u65b0\u4f1a\u91cd\u590d\u63d0\u4ea4\u6570\u636e\n\/\/ req.getRequestDispatcher(\"\/manager\/bookServlet?action=list\").forward(req,resp);\n \/\/ \u6240\u4ee5\u4f7f\u7528\u8bf7\u6c42\u91cd\u5b9a\u5411\n resp.sendRedirect(req.getContextPath() + \"\/manager\/bookServlet?action=list\");\n\n }\n\n \/**\n * \u8d1f\u8d23\u5220\u9664\u56fe\u4e66\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void delete(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570id\uff0c\u56fe\u4e66\u7f16\u7a0b\n int id = WebUtils.parseInt(req.getParameter(\"id\"),0);\n\n \/\/ 2. \u8c03\u7528bookService.deleteBookById();\u5220\u9664\u56fe\u4e66\n bookService.deleteBookById(id);\n \/\/ 3. \u91cd\u5b9a\u5411\u56de\u56fe\u4e66\u5217\u8868\u7ba1\u7406\u9875\u9762\n \/\/ \/book\/manager\/bookServlet?action=list\n resp.sendRedirect(req.getContextPath() + \"\/manager\/bookServlet?action=list\");\n }\n\n \/**\n * \u4fdd\u5b58\u4fee\u6539\u56fe\u4e66\u7684\u64cd\u4f5c\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void update(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570==\u5c01\u88c5\u6210\u4e3aBook\u5bf9\u8c61\n Book book = WebUtils.copyParamToBean(req.getParameterMap(), new Book());\n \/\/ 2. \u8c03\u7528BookService.updateBook( book );\u4fee\u6539\u56fe\u4e66\n bookService.updateBook(book);\n \/\/ 3. \u91cd\u5b9a\u5411\u56de\u56fe\u4e66\u5217\u8868\u7ba1\u7406\u9875\u9762\n \/\/ \u5730\u5740\uff1a\/\u5de5\u7a0b\u540d\/manager\/bookServlet?action=list\n resp.sendRedirect(req.getContextPath() + \"\/manager\/bookServlet?action=list\");\n\n }\n\n \/**\n * \u83b7\u53d6\u8981\u4fee\u6539\u7684\u56fe\u4e66\u4fe1\u606f\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void getBook(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570\u56fe\u4e66\u7f16\u53f7\n int id = WebUtils.parseInt(req.getParameter(\"id\"),0);\n \/\/ 2. \u8c03\u7528bookService.queryBookById\u67e5\u8be2\u56fe\u4e66\n Book book = bookService.queryBookById(id);\n \/\/ 3. \u4fdd\u5b58\u56fe\u4e66\u5230Request\u57df\u4e2d\n req.setAttribute(\"book\",book);\n \/\/ 4. \u8bf7\u6c42\u8f6c\u53d1\u5230\u3002pages\/manager\/book_edit.jsp\u9875\u9762\n req.getRequestDispatcher(\"\/pages\/manager\/book_edit.jsp\").forward(req,resp);\n }\n\n \/**\n * \u8d1f\u8d23\u904d\u5386\u56fe\u4e66\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void list(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u901a\u8fc7BookService\u67e5\u8be2\u5168\u90e8\u56fe\u4e66\n List<Book> books = bookService.queryBooks();\n \/\/ 2. \u628a\u5168\u90e8\u56fe\u4e66\u4fdd\u5b58\u5230Request\u57df\u4e2d\n req.setAttribute(\"books\", books);\n \/\/ 3. \u8bf7\u6c42\u8f6c\u53d1\u5230\/pages\/manager\/book_manager.jsp\u9875\u9762\n req.getRequestDispatcher(\"\/pages\/manager\/book_manager.jsp\").forward(req,resp);\n\n }\n}\n<\/code><\/pre>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.5.4\u3001\u5728 book_edit.jsp \u9875\u9762\u4e2d\u663e\u793a\u4fee\u6539\u7684\u6570\u636e<\/p>\n\n\n\n
<%@ page contentType=\"text\/html;charset=UTF-8\" language=\"java\" %>\n<!DOCTYPE html>\n<html>\n<head>\n<meta charset=\"UTF-8\">\n<title>\u7f16\u8f91\u56fe\u4e66<\/title>\n\n\t<%-- \u9759\u6001\u5305\u542b base\u6807\u7b7e\uff0ccss\u6837\u5f0f\uff0cjQuery\u6587\u4ef6 --%>\n\t<%@ include file=\"\/pages\/common\/head.jsp\"%>\n\n\t<style type=\"text\/css\">\n\th1 {\n\t\ttext-align: center;\n\t\tmargin-top: 200px;\n\t}\n\t\n\th1 a {\n\t\tcolor:red;\n\t}\n\t\n\tinput {\n\t\ttext-align: center;\n\t}\n<\/style>\n<\/head>\n<body>\n<!--\n\t\u9047\u5230\u7684\u95ee\u9898\uff1a\n\tbook_edit.jsp\u9875\u9762\uff0c\u65e2\u8981\u505a\u6dfb\u52a0\u64cd\u4f5c\u3002\u53c8\u8981\u505a\u4fee\u6539\u64cd\u4f5c\uff0c\u800c\u5230\u5e95\u662f\u6dfb\u52a0\uff0c\u8fd8\u662f\u4fee\u6539\u662f\u7531\u4e00\u4e2a\u9690\u85cf\u57df\u6765\u51b3\u5b9a\u7684\u3002\n\t\u5982\u4f55\u52a8\u6001\u4fee\u6539\u9690\u85cf\u57df<input type=\"hidden\" name=\"action\" value=\"xxx\" \/> \u8ba9\u5b83\u7684\u503c\u65e2\u53ef\u4ee5\u5b9e\u73b0\u6dfb\u52a0\uff0c\u53c8\u53ef\u4ee5\u5b9e\u73b0\u4fee\u6539\u64cd\u4f5c\uff1f\n\n\t\/\/\u65b9\u6848\u4e00\uff1a\n\t\u53ef\u4ee5\u5f53\u8bf7\u6c42\u53d1\u8d77\u65f6\uff0c\u9644\u5e26\u4e0a\u5f53\u524d\u8981\u64cd\u4f5c\u7684\u503c\u3002\u5e76\u6ce8\u5165\u5230\u9690\u85cf\u57df\u4e2d\u3002\n\n\t\/\/\u65b9\u6848\u4e8c\uff1a\n\t\u53ef\u4ee5\u901a\u8fc7\u5224\u65ad\u5f53\u524d\u8bf7\u6c42\u53c2\u6570\u4e2d\u662f\u5426\u5305\u542b\u6709id\u53c2\u6570\u3002\u5982\u679c\u6709\u8bf4\u660e\u662f\u4fee\u6539\u64cd\u4f5c\u3002\u5982\u679c\u6ca1\u6709\u8bf4\u660e\u662f\u6dfb\u52a0\u64cd\u4f5c\u3002\n\t\u662f\u5426\u662f\u6dfb\u52a0\u64cd\u4f5c\uff1a\n<%--\t${ empty param.id ? \"add\" : \"update\"}--%>\n\n\t\/\/\u65b9\u6848\u4e09\uff1a\n\t\u53ef\u4ee5\u901a\u8fc7\u5224\u65ad\uff0cRequest\u57df\u4e2d\u662f\u5426\u5305\u542b\u6709\u4fee\u6539\u7684\u56fe\u4e66\u4fe1\u606f\u5bf9\u8c61\uff0c\u5982\u679c\u6ca1\u6709\u8bf4\u660e\u662f\u6dfb\u52a0\u64cd\u4f5c\u3002\u5982\u679c\u6709\u8bf4\u660e\u662f\u4fee\u6539\u64cd\u4f5c\u3002\n\t\u662f\u5426\u662f\u6dfb\u52a0\u64cd\u4f5c\uff1a\n<%--\t${ empty requestScope.book ? \"add\" : \"update\"}--%>\n-->\n\n\t\t<div id=\"header\">\n\t\t\t<img class=\"logo_img\" alt=\"\" src=\"..\/..\/static\/img\/logo.gif\" >\n\t\t\t<span class=\"wel_word\">\u7f16\u8f91\u56fe\u4e66<\/span>\n\n\t\t\t<%-- \u9759\u6001\u5305\u542b manager \u7ba1\u7406\u6a21\u5757\u7684\u83dc\u5355 --%>\n\t\t\t<%@include file=\"\/pages\/common\/manager_menu.jsp\"%>\n\n\t\t<\/div>\n\t\t\n\t\t<div id=\"main\">\n\t\t\t<form action=\"manager\/bookServlet\" method=\"get\">\n\t\t\t\t<input type=\"hidden\" name=\"action\" value=\"${ empty param.id ? \"add\" : \"update\"}\" \/>\n\t\t\t\t<input type=\"hidden\" name=\"id\" value=\"${requestScope.book.id}\" \/>\n\t\t\t\t<table>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td>\u540d\u79f0<\/td>\n\t\t\t\t\t\t<td>\u4ef7\u683c<\/td>\n\t\t\t\t\t\t<td>\u4f5c\u8005<\/td>\n\t\t\t\t\t\t<td>\u9500\u91cf<\/td>\n\t\t\t\t\t\t<td>\u5e93\u5b58<\/td>\n\t\t\t\t\t\t<td colspan=\"2\">\u64cd\u4f5c<\/td>\n\t\t\t\t\t<\/tr>\t\t\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td><input name=\"name\" type=\"text\" value=\"${requestScope.book.name}\"\/><\/td>\n\t\t\t\t\t\t<td><input name=\"price\" type=\"text\" value=\"${requestScope.book.price}\"\/><\/td>\n\t\t\t\t\t\t<td><input name=\"author\" type=\"text\" value=\"${requestScope.book.author}\"\/><\/td>\n\t\t\t\t\t\t<td><input name=\"sales\" type=\"text\" value=\"${requestScope.book.sales}\"\/><\/td>\n\t\t\t\t\t\t<td><input name=\"stock\" type=\"text\" value=\"${requestScope.book.stock}\"\/><\/td>\n\t\t\t\t\t\t<td><input type=\"submit\" value=\"\u63d0\u4ea4\"\/><\/td>\n\t\t\t\t\t<\/tr>\t\n\t\t\t\t<\/table>\n\t\t\t<\/form>\n\t\t\t\n\t\n\t\t<\/div>\n\n\t\t<%-- \u9759\u6001\u5305\u542b\u9875\u811a\u5185\u5bb9 --%>\n\t\t<%@include file=\"\/pages\/common\/footer.jsp\"%>\n\n<\/body>\n<\/html><\/code><\/pre>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.5.5\u3001\u5728 BookServlet \u7a0b\u5e8f\u4e2d\u6dfb\u52a0 update \u65b9\u6cd5\uff1a<\/p>\n\n\n\n
package top.qaqaq.web;\n\nimport jakarta.servlet.ServletException;\nimport jakarta.servlet.http.HttpServletRequest;\nimport jakarta.servlet.http.HttpServletResponse;\nimport top.qaqaq.pojo.Book;\nimport top.qaqaq.service.BookService;\nimport top.qaqaq.service.impl.BookServiceImpl;\nimport top.qaqaq.utils.WebUtils;\n\nimport java.io.IOException;\nimport java.util.List;\n\n\/**\n * @author RichieZhang\n * @create 2022-12-10 \u4e0b\u5348 7:51\n *\/\npublic class BookServlet extends BaseServlet {\n\n private BookService bookService = new BookServiceImpl();\n\n \/**\n * \u8d1f\u8d23\u6dfb\u52a0\u56fe\u4e66\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void add(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570==\u5c01\u88c5\u6210\u4e3aBook\u5bf9\u8c61\n Book book = WebUtils.copyParamToBean(req.getParameterMap(), new Book());\n \/\/ 2. \u8c03\u7528BookService.addBook()\u4fdd\u5b58\u56fe\u4e66\n bookService.addBook(book);\n \/\/ 3. \u8df3\u5230\u56fe\u4e66\u5217\u8868\u9875\u9762\n \/\/ \/manager\/bookServlet?action=list\n\n \/\/ \u5982\u679c\u4f7f\u7528\u8bf7\u6c42\u8f6c\u53d1\uff0c\u5219\u4e3a\u4e00\u6b21\u8bf7\u6c42\uff0c\u5237\u65b0\u4f1a\u91cd\u590d\u63d0\u4ea4\u6570\u636e\n\/\/ req.getRequestDispatcher(\"\/manager\/bookServlet?action=list\").forward(req,resp);\n \/\/ \u6240\u4ee5\u4f7f\u7528\u8bf7\u6c42\u91cd\u5b9a\u5411\n resp.sendRedirect(req.getContextPath() + \"\/manager\/bookServlet?action=list\");\n\n }\n\n \/**\n * \u8d1f\u8d23\u5220\u9664\u56fe\u4e66\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void delete(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570id\uff0c\u56fe\u4e66\u7f16\u7a0b\n int id = WebUtils.parseInt(req.getParameter(\"id\"),0);\n\n \/\/ 2. \u8c03\u7528bookService.deleteBookById();\u5220\u9664\u56fe\u4e66\n bookService.deleteBookById(id);\n \/\/ 3. \u91cd\u5b9a\u5411\u56de\u56fe\u4e66\u5217\u8868\u7ba1\u7406\u9875\u9762\n \/\/ \/book\/manager\/bookServlet?action=list\n resp.sendRedirect(req.getContextPath() + \"\/manager\/bookServlet?action=list\");\n }\n\n \/**\n * \u4fdd\u5b58\u4fee\u6539\u56fe\u4e66\u7684\u64cd\u4f5c\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void update(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570==\u5c01\u88c5\u6210\u4e3aBook\u5bf9\u8c61\n Book book = WebUtils.copyParamToBean(req.getParameterMap(), new Book());\n \/\/ 2. \u8c03\u7528BookService.updateBook( book );\u4fee\u6539\u56fe\u4e66\n bookService.updateBook(book);\n \/\/ 3. \u91cd\u5b9a\u5411\u56de\u56fe\u4e66\u5217\u8868\u7ba1\u7406\u9875\u9762\n \/\/ \u5730\u5740\uff1a\/\u5de5\u7a0b\u540d\/manager\/bookServlet?action=list\n resp.sendRedirect(req.getContextPath() + \"\/manager\/bookServlet?action=list\");\n\n }\n\n \/**\n * \u83b7\u53d6\u8981\u4fee\u6539\u7684\u56fe\u4e66\u4fe1\u606f\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void getBook(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u83b7\u53d6\u8bf7\u6c42\u7684\u53c2\u6570\u56fe\u4e66\u7f16\u53f7\n int id = WebUtils.parseInt(req.getParameter(\"id\"),0);\n \/\/ 2. \u8c03\u7528bookService.queryBookById\u67e5\u8be2\u56fe\u4e66\n Book book = bookService.queryBookById(id);\n \/\/ 3. \u4fdd\u5b58\u56fe\u4e66\u5230Request\u57df\u4e2d\n req.setAttribute(\"book\",book);\n \/\/ 4. \u8bf7\u6c42\u8f6c\u53d1\u5230\u3002pages\/manager\/book_edit.jsp\u9875\u9762\n req.getRequestDispatcher(\"\/pages\/manager\/book_edit.jsp\").forward(req,resp);\n }\n\n \/**\n * \u8d1f\u8d23\u904d\u5386\u56fe\u4e66\n * @param req\n * @param resp\n * @throws ServletException\n * @throws IOException\n *\/\n protected void list(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {\n\/\/ super.doPost(req, resp);\n\n \/\/ 1. \u901a\u8fc7BookService\u67e5\u8be2\u5168\u90e8\u56fe\u4e66\n List<Book> books = bookService.queryBooks();\n \/\/ 2. \u628a\u5168\u90e8\u56fe\u4e66\u4fdd\u5b58\u5230Request\u57df\u4e2d\n req.setAttribute(\"books\", books);\n \/\/ 3. \u8bf7\u6c42\u8f6c\u53d1\u5230\/pages\/manager\/book_manager.jsp\u9875\u9762\n req.getRequestDispatcher(\"\/pages\/manager\/book_manager.jsp\").forward(req,resp);\n\n }\n}\n<\/code><\/pre>\n\n\n\n<\/div><\/figure>\n\n\n\n1.5.5.6\u3001\u89e3\u51b3 book_edit.jsp \u9875\u9762\uff0c\u5373\u8981\u5b9e\u73b0\u6dfb\u52a0\uff0c\u53c8\u8981\u5b9e\u73b0\u4fee\u6539\u64cd\u4f5c\u3002<\/p>\n\n\n\n<\/div><\/figure>\n\n\n\nweb.xml<\/h2>\n\n\n\n<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<web-app xmlns=\"https:\/\/jakarta.ee\/xml\/ns\/jakartaee\"\n xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\"\n xsi:schemaLocation=\"https:\/\/jakarta.ee\/xml\/ns\/jakartaee https:\/\/jakarta.ee\/xml\/ns\/jakartaee\/web-app_5_0.xsd\"\n version=\"5.0\">\n\n<!-- <servlet>-->\n<!-- <servlet-name>RegistServlet<\/servlet-name>-->\n<!-- <servlet-class>top.qaqaq.web.RegistServlet<\/servlet-class>-->\n<!-- <\/servlet>-->\n<!-- <servlet-mapping>-->\n<!-- <servlet-name>RegistServlet<\/servlet-name>-->\n<!-- <url-pattern>\/registServlet<\/url-pattern>-->\n<!-- <\/servlet-mapping>-->\n\n<!-- <servlet>-->\n<!-- <servlet-name>LoginServlet<\/servlet-name>-->\n<!-- <servlet-class>top.qaqaq.web.LoginServlet<\/servlet-class>-->\n<!-- <\/servlet>-->\n<!-- <servlet-mapping>-->\n<!-- <servlet-name>LoginServlet<\/servlet-name>-->\n<!-- <url-pattern>\/loginServlet<\/url-pattern>-->\n<!-- <\/servlet-mapping>-->\n\n <servlet>\n <servlet-name>UserServlet<\/servlet-name>\n <servlet-class>top.qaqaq.web.UserServlet<\/servlet-class>\n <\/servlet>\n <servlet-mapping>\n <servlet-name>UserServlet<\/servlet-name>\n <url-pattern>\/userServlet<\/url-pattern>\n <\/servlet-mapping>\n\n <servlet>\n <servlet-name>BookServlet<\/servlet-name>\n <servlet-class>top.qaqaq.web.BookServlet<\/servlet-class>\n <\/servlet>\n <servlet-mapping>\n <servlet-name>BookServlet<\/servlet-name>\n <url-pattern>\/manager\/bookServlet<\/url-pattern>\n <\/servlet-mapping>\n\n<\/web-app><\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"\u4e66\u57ce\u9879\u76ee-\u7b2c\u4e94\u9636\u6bb5\uff1a\u5185\u5bb9\u4ecb\u7ecd\u3001\u4e66\u57ce\u9879\u76ee-MVC\u6982\u5ff5\u7684\u4ecb\u7ecd\u3001\u4e66\u57ce\u9879\u76ee-\u521b\u5efa\u56fe\u4e66\u6a21\u5757\u7684\u6570\u636e\u5e93\u8868\u3001\u4e66\u57ce\u9879\u76ee-\u7f16\u5199\u56fe\u4e66 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[59],"tags":[61],"class_list":["post-2459","post","type-post","status-publish","format-standard","hentry","category-javaweb-code","tag-javaweb"],"_links":{"self":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/2459"}],"collection":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2459"}],"version-history":[{"count":7,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/2459\/revisions"}],"predecessor-version":[{"id":2718,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/2459\/revisions\/2718"}],"wp:attachment":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2459"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2459"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2459"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"\"](\"https:\/\/qaqaq.top\/wp-content\/uploads\/2022\/12\/image-182-1024x489.png\")
<\/div><\/figure>\n\n\n\n![\"\"](\"https:\/\/qaqaq.top\/wp-content\/uploads\/2022\/12\/image-183.png\")
<\/div><\/figure>\n\n\n\n![\"\"](\"https:\/\/qaqaq.top\/wp-content\/uploads\/2022\/12\/image-184.png\")
<\/div><\/figure>\n\n\n\n![\"\"](\"https:\/\/qaqaq.top\/wp-content\/uploads\/2022\/12\/image-185.png\")
<\/div><\/figure>\n\n\n\n![\"\"](\"https:\/\/qaqaq.top\/wp-content\/uploads\/2022\/12\/image-186.png\")
<\/div><\/figure>\n\n\n\n![\"\"](\"https:\/\/qaqaq.top\/wp-content\/uploads\/2022\/12\/image-187.png\")
<\/div><\/figure>\n\n\n\n![\"\"](\"https:\/\/qaqaq.top\/wp-content\/uploads\/2022\/12\/image-188-1024x368.png\")
<\/div><\/figure>\n\n\n\n![\"\"](\"https:\/\/qaqaq.top\/wp-content\/uploads\/2022\/12\/image-189-1024x410.png\")
<\/div><\/figure>\n\n\n\n![\"\"](\"https:\/\/qaqaq.top\/wp-content\/uploads\/2022\/12\/image-190.png\")
<\/div><\/figure>\n\n\n\n![\"\"](\"https:\/\/qaqaq.top\/wp-content\/uploads\/2022\/12\/image-191.png\")
<\/div><\/figure>\n\n\n\n![\"\"](\"https:\/\/qaqaq.top\/wp-content\/uploads\/2022\/12\/image-192-1024x425.png\")
<\/div><\/figure>\n\n\n\n![\"\"](\"https:\/\/qaqaq.top\/wp-content\/uploads\/2022\/12\/image-193-1024x507.png\")
<\/div><\/figure>\n\n\n\n![\"\"](\"https:\/\/qaqaq.top\/wp-content\/uploads\/2022\/12\/image-194.png\")
<\/div><\/figure>\n\n\n\n![\"\"](\"https:\/\/qaqaq.top\/wp-content\/uploads\/2022\/12\/image-195-1024x405.png\")
<\/div><\/figure>\n\n\n\n![\"\"](\"https:\/\/qaqaq.top\/wp-content\/uploads\/2022\/12\/image-196.png\")
<\/div><\/figure>\n\n\n\n![\"\"](\"https:\/\/qaqaq.top\/wp-content\/uploads\/2022\/12\/image-197-1024x386.png\")
<\/div><\/figure>\n\n\n\n![\"\"](\"https:\/\/qaqaq.top\/wp-content\/uploads\/2022\/12\/image-198.png\")
<\/div><\/figure>\n\n\n\n