书城项目第五阶段-图书模块
MVC 概念
<%--
MVC 全称:Model 模型、 View 视图、 Controller 控制器。
MVC 最早出现在 JavaEE 三层中的 Web 层,它可以有效的指导 Web 层的代码如何有效分离,单独工作。
View 视图:只负责数据和界面的显示,不接受任何与显示数据无关的代码,便于程序员和美工的分工合作——JSP/HTML。
Controller 控制器:只负责接收请求,调用业务层的代码处理请求,然后派发页面,是一个“调度者”的角色——Servlet。转到某个页面。或者是重定向到某个页面。
Model 模型:将与业务逻辑相关的数据封装为具体的 JavaBean 类,其中不掺杂任何与数据处理相关的代码——JavaBean/domain/entity/pojo。
MVC 是一种思想
MVC 的理念是将软件代码拆分成为组件,单独开发,组合使用(目的还是为了降低耦合度)。
MVC 的作用还是为了降低耦合。让代码合理分层。方便后期升级和维护。
--%>
图书模块
编写图书模块的数据库表
CREATE TABLE t_book(
`id` INT PRIMARY KEY AUTO_INCREMENT,
`name` VARCHAR(100),
`price` DECIMAL(11,2),
`author` VARCHAR(100),
`sales` INT,
`stock` INT,
`img_path` VARCHAR(200)
);
## 插入初始化测试数据
INSERT INTO t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)
VALUES(NULL , 'java从入门到放弃' , '国哥' , 80 , 9999 , 9 , 'static/img/default.jpg');
INSERT INTO t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)
VALUES(NULL , '数据结构与算法' , '严敏君' , 78.5 , 6 , 13 , 'static/img/default.jpg');
INSERT INTO t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)
VALUES(NULL , '怎样拐跑别人的媳妇' , '龙伍' , 68, 99999 , 52 , 'static/img/default.jpg');
INSERT INTO t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)
VALUES(NULL , '木虚肉盖饭' , '小胖' , 16, 1000 , 50 , 'static/img/default.jpg');
INSERT INTO t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)
VALUES(NULL , 'C++编程思想' , '刚哥' , 45.5 , 14 , 95 , 'static/img/default.jpg');
INSERT INTO t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)
VALUES(NULL , '蛋炒饭' , '周星星' , 9.9, 12 , 53 , 'static/img/default.jpg');
INSERT INTO t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)
VALUES(NULL , '赌神' , '龙伍' , 66.5, 125 , 535 , 'static/img/default.jpg');
INSERT INTO t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)
VALUES(NULL , 'Java编程思想' , '阳哥' , 99.5 , 47 , 36 , 'static/img/default.jpg');
INSERT INTO t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)
VALUES(NULL , 'JavaScript从入门到精通' , '婷姐' , 9.9 , 85 , 95 , 'static/img/default.jpg');
INSERT INTO t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)
VALUES(NULL , 'cocos2d-x游戏编程入门' , '国哥' , 49, 52 , 62 , 'static/img/default.jpg');
INSERT INTO t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)
VALUES(NULL , 'C语言程序设计' , '谭浩强' , 28 , 52 , 74 , 'static/img/default.jpg');
INSERT INTO t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)
VALUES(NULL , 'Lua语言程序设计' , '雷丰阳' , 51.5 , 48 , 82 , 'static/img/default.jpg');
INSERT INTO t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)
VALUES(NULL , '西游记' , '罗贯中' , 12, 19 , 9999 , 'static/img/default.jpg');
INSERT INTO t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)
VALUES(NULL , '水浒传' , '华仔' , 33.05 , 22 , 88 , 'static/img/default.jpg');
INSERT INTO t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)
VALUES(NULL , '操作系统原理' , '刘优' , 133.05 , 122 , 188 , 'static/img/default.jpg');
INSERT INTO t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)
VALUES(NULL , '数据结构 java版' , '封大神' , 173.15 , 21 , 81 , 'static/img/default.jpg');
INSERT INTO t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)
VALUES(NULL , 'UNIX高级环境编程' , '乐天' , 99.15 , 210 , 810 , 'static/img/default.jpg');
INSERT INTO t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)
VALUES(NULL , 'javaScript高级编程' , '国哥' , 69.15 , 210 , 810 , 'static/img/default.jpg');
INSERT INTO t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)
VALUES(NULL , '大话设计模式' , '国哥' , 89.15 , 20 , 10 , 'static/img/default.jpg');
INSERT INTO t_book(`id` , `name` , `author` , `price` , `sales` , `stock` , `img_path`)
VALUES(NULL , '人月神话' , '刚哥' , 88.15 , 20 , 80 , 'static/img/default.jpg');
## 查看表内容
SELECT id,NAME,author,price,sales,stock,img_path FROM t_book;
编写图书模块的 JavaBean
package com. sq. pojo ;
import java. math. BigDecimal ;
public class Book {
private Integer id;
private String name;
private String author;
private BigDecimal price;
private Integer sales;
private Integer stock;
private String imgPath = "static/img/default.jpg" ;
public Book ( ) {
}
public Book ( Integer id, String name, String author, BigDecimal price, Integer sales, Integer stock, String imgPath) {
this . id = id;
this . name = name;
this . author = author;
this . price = price;
this . sales = sales;
this . stock = stock;
if ( imgPath != null && ! "" . equals ( imgPath) ) {
this . imgPath = imgPath;
}
}
public Integer getId ( ) {
return id;
}
public void setId ( Integer id) {
this . id = id;
}
public String getName ( ) {
return name;
}
public void setName ( String name) {
this . name = name;
}
public String getAuthor ( ) {
return author;
}
public void setAuthor ( String author) {
this . author = author;
}
public BigDecimal getPrice ( ) {
return price;
}
public void setPrice ( BigDecimal price) {
this . price = price;
}
public Integer getSales ( ) {
return sales;
}
public void setSales ( Integer sales) {
this . sales = sales;
}
public Integer getStock ( ) {
return stock;
}
public void setStock ( Integer stock) {
this . stock = stock;
}
public String getImgPath ( ) {
return imgPath;
}
public void setImgPath ( String imgPath) {
if ( imgPath != null && ! "" . equals ( imgPath) ) {
this . imgPath = imgPath;
}
}
@Override
public String toString ( ) {
return "book{" +
"id=" + id +
", name='" + name + '\'' +
", author='" + author + '\'' +
", price=" + price +
", sales=" + sales +
", stock=" + stock +
", imgPath='" + imgPath + '\'' +
'}' ;
}
}
编写图书模块的 Dao 和测试 Dao
package com. sq. dao ;
import com. sq. pojo. Book ;
import java. util. List ;
public interface BookDao {
public int addBook ( Book book) ;
public int deleteBookById ( Integer id) ;
public int updateBook ( Book book) ;
public Book queryBookById ( Integer id) ;
public List < Book > queryBooks ( ) ;
}
package com. sq. dao. impl ;
import com. sq. dao. BookDao ;
import com. sq. pojo. Book ;
import java. util. List ;
public class BookDaoImpl extends BaseDao implements BookDao {
@Override
public int addBook ( Book book) {
String sql = "insert into t_book(`name`,`author`,`price`,`sales`,`stock`,`img_path`) values(?,?,?,?,?,?)" ;
return update ( sql, book. getName ( ) , book. getAuthor ( ) , book. getPrice ( ) , book. getSales ( ) , book. getStock ( ) , book. getImgPath ( ) ) ;
}
@Override
public int deleteBookById ( Integer id) {
String sql = "delete from t_book where id = ?" ;
return update ( sql, id) ;
}
@Override
public int updateBook ( Book book) {
String sql = "update t_book set `name`=?,`author`=?,`price`=?,`sales`=?,`stock`=?,`img_path`=? where id = ?" ;
return update ( sql, book. getName ( ) , book. getAuthor ( ) , book. getPrice ( ) , book. getSales ( ) , book. getStock ( ) , book. getImgPath ( ) , book. getId ( ) ) ;
}
@Override
public Book queryBookById ( Integer id) {
String sql = "select `id`,`name`,`author`,`price`,`sales`,`stock`,`img_path` imgPath from t_book where id = ?" ;
return queryForOne ( Book . class , sql, id) ;
}
@Override
public List < Book > queryBooks ( ) {
String sql = "select `id`,`name`,`author`,`price`,`sales`,`stock`,`img_path` imgPath from t_book" ;
return queryForList ( Book . class , sql) ;
}
}
package com. sq. test ;
import com. sq. dao. BookDao ;
import com. sq. dao. impl. BookDaoImpl ;
import com. sq. pojo. Book ;
import org. junit. Test ;
import java. math. BigDecimal ;
public class BookDaoTest {
private BookDao bookDao = new BookDaoImpl ( ) ;
@Test
public void addBook ( ) {
bookDao. addBook ( new Book ( null , "前哥为啥那么帅!" , "191125" , new BigDecimal ( 9999 ) , 11000 , 0 , null ) ) ;
}
@Test
public void deleteBookById ( ) {
bookDao. deleteBookById ( 21 ) ;
}
@Test
public void updateBook ( ) {
bookDao. updateBook ( new Book ( 21 , "都帅!" , "前哥" , new BigDecimal ( 9999 ) , 11000 , 0 , null ) ) ;
}
@Test
public void queryBookById ( ) {
System . out. println ( bookDao. queryBookById ( 21 ) ) ;
}
@Test
public void queryBooks ( ) {
for ( Book queryBook : bookDao. queryBooks ( ) ) {
System . out. println ( queryBook) ;
}
}
}
编写图书模块的 Service 和测试 Service
package com. sq. service ;
import com. sq. pojo. Book ;
import java. util. List ;
public interface BookService {
public void addBook ( Book book) ;
public void deleteBookById ( Integer id) ;
public void updateBook ( Book book) ;
public Book queryBookById ( Integer id) ;
public List < Book > queryBooks ( ) ;
}
package com. sq. service. impl ;
import com. sq. dao. BookDao ;
import com. sq. dao. impl. BookDaoImpl ;
import com. sq. pojo. Book ;
import com. sq. service. BookService ;
import java. util. List ;
public class BookServiceImpl implements BookService {
private BookDao bookDao = new BookDaoImpl ( ) ;
@Override
public void addBook ( Book book) {
bookDao. addBook ( book) ;
}
@Override
public void deleteBookById ( Integer id) {
bookDao. deleteBookById ( id) ;
}
@Override
public void updateBook ( Book book) {
bookDao. updateBook ( book) ;
}
@Override
public Book queryBookById ( Integer id) {
return bookDao. queryBookById ( id) ;
}
@Override
public List < Book > queryBooks ( ) {
return bookDao. queryBooks ( ) ;
}
}
package com. sq. test ;
import com. sq. pojo. Book ;
import com. sq. service. BookService ;
import com. sq. service. impl. BookServiceImpl ;
import org. junit. Test ;
import java. math. BigDecimal ;
import static org. junit. Assert . *;
public class BookServiceTest {
private BookService bookService = new BookServiceImpl ( ) ;
@Test
public void addBook ( ) {
bookService. addBook ( new Book ( null , "前哥在手,天下我有!" , "1125" , new BigDecimal ( 1000000 ) , 100000000 , 0 , null ) ) ;
}
@Test
public void deleteBookById ( ) {
bookService. deleteBookById ( 22 ) ;
}
@Test
public void updateBook ( ) {
bookService. updateBook ( new Book ( 22 , "社会我前哥!" , "1125" , new BigDecimal ( 99999999 ) , 10 , 0 , null ) ) ;
}
@Test
public void queryBookById ( ) {
System . out. println ( bookService. queryBookById ( 22 ) ) ;
}
@Test
public void queryBooks ( ) {
for ( Book queryBook : bookService. queryBooks ( ) ) {
System . out. println ( queryBook) ;
}
}
}
编写图书模块的 Web 层,和页面联调测试
图书列表功能的实现
BookServlet 程序中添加 list 方法
package com. sq. web ;
import com. sq. pojo. Book ;
import com. sq. service. BookService ;
import com. sq. service. impl. BookServiceImpl ;
import com. sq. utils. WebUtils ;
import javax. servlet. ServletException ;
import javax. servlet. http. HttpServletRequest ;
import javax. servlet. http. HttpServletResponse ;
import java. io. IOException ;
import java. util. List ;
public class BookServlet extends BaseServlet {
private BookService bookService = new BookServiceImpl ( ) ;
protected void add ( HttpServletRequest req, HttpServletResponse resp) throws ServletException , IOException {
Book book = WebUtils . copyParamToBean ( req. getParameterMap ( ) , new Book ( ) ) ;
bookService. addBook ( book) ;
resp. sendRedirect ( req. getContextPath ( ) + "/manager/bookServlet?action=list" ) ;
}
protected void delete ( HttpServletRequest req, HttpServletResponse resp) throws ServletException , IOException {
int id = WebUtils . parseInt ( req. getParameter ( "id" ) , 0 ) ;
bookService. deleteBookById ( id) ;
resp. sendRedirect ( req. getContextPath ( ) + "/manager/bookServlet?action=list" ) ;
}
protected void update ( HttpServletRequest req, HttpServletResponse resp) throws ServletException , IOException {
Book book = WebUtils . copyParamToBean ( req. getParameterMap ( ) , new Book ( ) ) ;
bookService. updateBook ( book) ;
resp. sendRedirect ( req. getContextPath ( ) + "/manager/bookServlet?action=list" ) ;
}
protected void getBook ( HttpServletRequest req, HttpServletResponse resp) throws ServletException , IOException {
int id = WebUtils . parseInt ( req. getParameter ( "id" ) , 0 ) ;
Book book = bookService. queryBookById ( id) ;
req. setAttribute ( "book" , book) ;
req. getRequestDispatcher ( "/pages/manager/book_edit.jsp" ) . forward ( req, resp) ;
}
protected void list ( HttpServletRequest req, HttpServletResponse resp) throws ServletException , IOException {
List < Book > books = bookService. queryBooks ( ) ;
req. setAttribute ( "books" , books) ;
req. getRequestDispatcher ( "/pages/manager/book_manager.jsp" ) . forward ( req, resp) ;
}
}
修改【图书管理】请求地址
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<div><%--pages/manager/book_manager.jsp--%>
<a href="manager/bookServlet?action=list">图书管理</a>
<a href="order_manager.jsp">订单管理</a>
<a href="../../index.jsp">返回商城</a>
</div>
修改 pages/manager/book_manager.jsp 页面的数据遍历输出
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>图书管理</title>
<%-- 静态包含 base 标签,css样式,jQuery 文件 --%>
<%@include file="/pages/common/head.jsp"%>
<script type="text/javascript">
$(function (){
// 给删除的 a 标签绑定单击事件,用于删除的确认提示操作
$("a.deleteClass").click(function (){
// 在事件的 function 函数中,有一个 this 对象。这个 this 对象,是当前正在响应事件的 dom 对象。
/**
* confirm 是确认提示框函数
* 参数是它的提示内容
* 它有两个按钮,一个确认,一个取消。
* 返回 true 表示点击了,确认,返回 false 表示点击取消。
*/
return confirm("你确定要删除 [" + $(this).parent().parent().find("td:first").text() + "] ?");
// return false; // 阻止元素的默认行为===不提交请求
});
});
</script>
<%--
<link type="text/css" rel="stylesheet" href="../../static/css/style.css" >
--%>
</head>
<body>
<div id="header">
<img class="logo_img" alt="" src="../../static/img/logo.gif" >
<span class="wel_word">图书管理系统</span>
<%-- 静态包含 manager 管理模块的菜单 --%>
<%@include file="/pages/common/manager_menu.jsp"%>
<%--
<div>
<a href="book_manager.jsp">图书管理</a>
<a href="order_manager.jsp">订单管理</a>
<a href="../../index.jsp">返回商城</a>
</div>
--%>
</div>
<div id="main">
<table>
<tr>
<td>名称</td>
<td>价格</td>
<td>作者</td>
<td>销量</td>
<td>库存</td>
<td colspan="2">操作</td>
</tr>
<--修改部分-->
<c:forEach items="${requestScope.books}" var="book">
<tr>
<td>${book.name}</td>
<td>${book.price}</td>
<td>${book.author}</td>
<td>${book.sales}</td>
<td>${book.price}</td>
<td><a href="manager/bookServlet?action=getBook&id=${book.id}">修改</a></td>
<td><a class="deleteClass" href="manager/bookServlet?action=delete&id=${book.id}">删除</a></td>
</tr>
</c:forEach>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td><a href="pages/manager/book_edit.jsp">添加图书</a></td>
</tr>
</table>
</div>
<%-- 静态包含页脚内容 --%>
<%@include file="/pages/common/footer.jsp"%>
<%--
<div id="bottom">
<span>
尚硅谷书城.Copyright ©2015
</span>
</div>
--%>
</body>
</html>
添加图书功能的实现
问题说明:表单重复提交:
<--
当用户提交完请求,浏览器会记录下最后一次请求的全部信息。当用户按下功能键 F5,就会发起浏览器记录的最后一次请求。
-->
BookServlet 程序中添加 add 方法
package com.sq.web;
import com.sq.pojo.Book;
import com.sq.service.BookService;
import com.sq.service.impl.BookServiceImpl;
import com.sq.utils.WebUtils;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.util.List;
/**
* @author 21115
* @ date 2021/10/7
*/
public class BookServlet extends BaseServlet {
private BookService bookService = new BookServiceImpl();
protected void add(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
// 1.获取请求的参数==封装成为 Book 对象
Book book = WebUtils.copyParamToBean(req.getParameterMap(),new Book());
// 2.调用 BookService.addBook() 保存图书
bookService.addBook(book);
// 3.跳到图书列表页面
// /manager/bookServlet?action=list
// 请求转发: 刷新后出现两次内容添加错误
// req.getRequestDispatcher("/manager/bookServlet?action=list").forward(req,resp);
// "请求转发" 的 "/" 表示工程名,"重定向" 的 "/" 表示端口号
// 重定向: req.getContextPath(): 表示工程名
resp.sendRedirect(req.getContextPath() + "/manager/bookServlet?action=list");
}
protected void delete(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
// 1.获取请求的参数 id,图书编程
// package com.sq.utils.WebUtils 中没有 parseInt 方法时
// String id = req.getParameter("id");
// int i = 0;
// try { // ctrl + alt + t: 调 surround with
// i = Integer.parseInt(id);
// } catch (NumberFormatException e) {
// e.printStackTrace();
// }
int id = WebUtils.parseInt(req.getParameter("id"),0);
// 2.调用 bookService.deleteBookById(); 删除图书
bookService.deleteBookById(id);
// 3.重定向回图书列表管理页面
resp.sendRedirect(req.getContextPath() + "/manager/bookServlet?action=list");
}
protected void update(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
// 1.获取请求的参数==封装成为 Book 对象
Book book = WebUtils.copyParamToBean(req.getParameterMap(),new Book());
// 2.调用 BookService.updateBook( book ); 修改图书
bookService.updateBook(book);
// 3.重定向回图书列表管理页面
// 地址: /工程名/manager/bookServlet?action=list
resp.sendRedirect(req.getContextPath() + "/manager/bookServlet?action=list");
}
protected void getBook(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
// 1.获取请求的参数图书编号
int id = WebUtils.parseInt(req.getParameter("id"),0);
// 2.调用 bookService.queryBookById 查询图书
Book book = bookService.queryBookById(id);
// 3.保存到图书到 Request 域中
req.setAttribute("book",book);
// 4.请求转发到 pages/manager/book_edit.jsp 页面
req.getRequestDispatcher("/pages/manager/book_edit.jsp").forward(req,resp);
}
protected void list(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
// 1.通过 BookService 查询全部图书
List<Book> books = bookService.queryBooks();
// 2.把全部图书保存到 Request 域中
req.setAttribute("books",books);
// 3.请求转发到 /pages/manager/book_manager.jsp 页面
req.getRequestDispatcher("/pages/manager/book_manager.jsp").forward(req,resp);
}
}
修改 book_edit.jsp 页面
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>编辑图书</title>
<%-- 静态包含 base 标签,css样式,jQuery 文件 --%>
<%@include file="/pages/common/head.jsp"%>
<%--
<link type="text/css" rel="stylesheet" href="../../static/css/style.css" >
--%>
<style type="text/css">
h1 {
text-align: center;
margin-top: 200px;
}
h1 a {
color: #ff0000;
}
input {
text-align: center;
}
</style>
</head>
<body>
<%--方案2: 是否是添加操作: ${ empty param.id ? "add" : "update" }--%>
<%--方案3: 是否是添加操作: ${ empty requestScope.book ? "add" : "update" }--%>
<div id="header">
<img class="logo_img" alt="" src="../../static/img/logo.gif" >
<span class="wel_word">编辑图书</span>
<%-- 静态包含 manager 管理模块的菜单 --%>
<%@include file="/pages/common/manager_menu.jsp"%>
<%--
<div>
<a href="book_manager.jsp">图书管理</a>
<a href="order_manager.jsp">订单管理</a>
<a href="../../index.jsp">返回商城</a>
</div>
--%>
</div>
<div id="main">
<form action="manager/bookServlet" method="post">
<input type="hidden" name="action" value="${ empty param.id ? "add" : "update" }" />
<input type="hidden" name="id" value="${ requestScope.book.id }" />
<table>
<tr>
<td>名称</td>
<td>价格</td>
<td>作者</td>
<td>销量</td>
<td>库存</td>
<td colspan="2">操作</td>
</tr>
<tr>
<td><input name="name" type="text" value="${requestScope.book.name}"/></td>
<td><input name="price" type="text" value="${requestScope.book.price}"/></td>
<td><input name="author" type="text" value="${requestScope.book.author}"/></td>
<td><input name="sales" type="text" value="${requestScope.book.sales}"/></td>
<td><input name="stock" type="text" value="${requestScope.book.stock}"/></td>
<td><input type="submit" value="提交"/></td>
</tr>
</table>
</form>
</div>
<%-- 静态包含页脚内容 --%>
<%@include file="/pages/common/footer.jsp"%>
<%--
<div id="bottom">
<span>
尚硅谷书城.Copyright ©2015
</span>
</div>
--%>
</body>
</html>
删除图书功能的实现
BookServlet 程序中的 delete 方法:
package com. sq. web ;
import com. sq. pojo. Book ;
import com. sq. service. BookService ;
import com. sq. service. impl. BookServiceImpl ;
import com. sq. utils. WebUtils ;
import javax. servlet. ServletException ;
import javax. servlet. http. HttpServletRequest ;
import javax. servlet. http. HttpServletResponse ;
import java. io. IOException ;
import java. util. List ;
public class BookServlet extends BaseServlet {
private BookService bookService = new BookServiceImpl ( ) ;
protected void add ( HttpServletRequest req, HttpServletResponse resp) throws ServletException , IOException {
Book book = WebUtils . copyParamToBean ( req. getParameterMap ( ) , new Book ( ) ) ;
bookService. addBook ( book) ;
resp. sendRedirect ( req. getContextPath ( ) + "/manager/bookServlet?action=list" ) ;
}
protected void delete ( HttpServletRequest req, HttpServletResponse resp) throws ServletException , IOException {
int id = WebUtils . parseInt ( req. getParameter ( "id" ) , 0 ) ;
bookService. deleteBookById ( id) ;
resp. sendRedirect ( req. getContextPath ( ) + "/manager/bookServlet?action=list" ) ;
}
protected void update ( HttpServletRequest req, HttpServletResponse resp) throws ServletException , IOException {
Book book = WebUtils . copyParamToBean ( req. getParameterMap ( ) , new Book ( ) ) ;
bookService. updateBook ( book) ;
resp. sendRedirect ( req. getContextPath ( ) + "/manager/bookServlet?action=list" ) ;
}
protected void getBook ( HttpServletRequest req, HttpServletResponse resp) throws ServletException , IOException {
int id = WebUtils . parseInt ( req. getParameter ( "id" ) , 0 ) ;
Book book = bookService. queryBookById ( id) ;
req. setAttribute ( "book" , book) ;
req. getRequestDispatcher ( "/pages/manager/book_edit.jsp" ) . forward ( req, resp) ;
}
protected void list ( HttpServletRequest req, HttpServletResponse resp) throws ServletException , IOException {
List < Book > books = bookService. queryBooks ( ) ;
req. setAttribute ( "books" , books) ;
req. getRequestDispatcher ( "/pages/manager/book_manager.jsp" ) . forward ( req, resp) ;
}
}
给 WebUtils 工具类添加转换 int 类型的工具方法
package com. sq. utils ;
import com. sq. pojo. User ;
import org. apache. commons. beanutils. BeanUtils ;
import javax. servlet. http. HttpServletRequest ;
import java. util. Map ;
public class WebUtils {
public static < T > T copyParamToBean ( Map value, T bean) {
try {
System . out. println ( "注入之前: " + bean) ;
BeanUtils . populate ( bean, value) ;
System . out. println ( "注入之后: " + bean) ;
} catch ( Exception e) {
e. printStackTrace ( ) ;
}
return bean;
}
public static int parseInt ( String strInt, int defaultValue) {
try {
return Integer . parseInt ( strInt) ;
} catch ( Exception e) {
e. printStackTrace ( ) ;
}
return defaultValue;
}
}
修改删除的连接地址:
<--book_manager.jsp-->
<c:forEach items="${requestScope.books}" var="book">
<tr>
<td>${book.name}</td>
<td>${book.price}</td>
<td>${book.author}</td>
<td>${book.sales}</td>
<td>${book.price}</td>
<td><a href="manager/bookServlet?action=getBook&id=${book.id}">修改</a></td>
<td><a class="deleteClass" href="manager/bookServlet?action=delete&id=${book.id}">删除</a> </td>
</tr>
</c:forEach>
给删除添加确认提示操作:
<--book_manager.jsp-->
$(function (){
// 给删除的 a 标签绑定单击事件,用于删除的确认提示操作
$("a.deleteClass").click(function (){
// 在事件的 function 函数中,有一个 this 对象。这个 this 对象,是当前正在响应事件的 dom 对象。
/**
* confirm 是确认提示框函数
* 参数是它的提示内容
* 它有两个按钮,一个确认,一个取消。
* 返回 true 表示点击了,确认,返回 false 表示点击取消。
*/
return confirm("你确定要删除 [" + $(this).parent().parent().find("td:first").text() + "] ?");
// return false; // 阻止元素的默认行为===不提交请求
});
});
修改图书功能的实现
更新【修改】的请求地址:
<--book_manager.jsp-->
<c:forEach items="${requestScope.books}" var="book">
<tr>
<td>${book.name}</td>
<td>${book.price}</td>
<td>${book.author}</td>
<td>${book.sales}</td>
<td>${book.price}</td>
<td><a href="manager/bookServlet?action=getBook&id=${book.id}">修改</a></td>
<td><a class="deleteClass" href="manager/bookServlet?action=delete&id=${book.id}">删除</a> </td>
</tr>
</c:forEach>
BookServlet 程序中添加 getBook 方法:
package com. sq. web ;
import com. sq. pojo. Book ;
import com. sq. service. BookService ;
import com. sq. service. impl. BookServiceImpl ;
import com. sq. utils. WebUtils ;
import javax. servlet. ServletException ;
import javax. servlet. http. HttpServletRequest ;
import javax. servlet. http. HttpServletResponse ;
import java. io. IOException ;
import java. util. List ;
public class BookServlet extends BaseServlet {
private BookService bookService = new BookServiceImpl ( ) ;
protected void add ( HttpServletRequest req, HttpServletResponse resp) throws ServletException , IOException {
Book book = WebUtils . copyParamToBean ( req. getParameterMap ( ) , new Book ( ) ) ;
bookService. addBook ( book) ;
resp. sendRedirect ( req. getContextPath ( ) + "/manager/bookServlet?action=list" ) ;
}
protected void delete ( HttpServletRequest req, HttpServletResponse resp) throws ServletException , IOException {
int id = WebUtils . parseInt ( req. getParameter ( "id" ) , 0 ) ;
bookService. deleteBookById ( id) ;
resp. sendRedirect ( req. getContextPath ( ) + "/manager/bookServlet?action=list" ) ;
}
protected void update ( HttpServletRequest req, HttpServletResponse resp) throws ServletException , IOException {
Book book = WebUtils . copyParamToBean ( req. getParameterMap ( ) , new Book ( ) ) ;
bookService. updateBook ( book) ;
resp. sendRedirect ( req. getContextPath ( ) + "/manager/bookServlet?action=list" ) ;
}
protected void getBook ( HttpServletRequest req, HttpServletResponse resp) throws ServletException , IOException {
int id = WebUtils . parseInt ( req. getParameter ( "id" ) , 0 ) ;
Book book = bookService. queryBookById ( id) ;
req. setAttribute ( "book" , book) ;
req. getRequestDispatcher ( "/pages/manager/book_edit.jsp" ) . forward ( req, resp) ;
}
protected void list ( HttpServletRequest req, HttpServletResponse resp) throws ServletException , IOException {
List < Book > books = bookService. queryBooks ( ) ;
req. setAttribute ( "books" , books) ;
req. getRequestDispatcher ( "/pages/manager/book_manager.jsp" ) . forward ( req, resp) ;
}
}
在 book_edit.jsp 页面中显示修改的数据
<div id="main">
<form action="manager/bookServlet" method="post">
<input type="hidden" name="action" value="${ empty param.id ? "add" : "update" }" />
<input type="hidden" name="id" value="${ requestScope.book.id }" />
<table>
<tr>
<td>名称</td>
<td>价格</td>
<td>作者</td>
<td>销量</td>
<td>库存</td>
<td colspan="2">操作</td>
</tr>
<tr>
<td><input name="name" type="text" value="${requestScope.book.name}"/></td>
<td><input name="price" type="text" value="${requestScope.book.price}"/></td>
<td><input name="author" type="text" value="${requestScope.book.author}"/></td>
<td><input name="sales" type="text" value="${requestScope.book.sales}"/></td>
<td><input name="stock" type="text" value="${requestScope.book.stock}"/></td>
<td><input type="submit" value="提交"/></td>
</tr>
</table>
</form>
</div>
在 BookServlet 程序中添加 update 方法
protected void update(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
// 1.获取请求的参数==封装成为 Book 对象
Book book = WebUtils.copyParamToBean(req.getParameterMap(),new Book());
// 2.调用 BookService.updateBook( book ); 修改图书
bookService.updateBook(book);
// 3.重定向回图书列表管理页面
// 地址: /工程名/manager/bookServlet?action=list
resp.sendRedirect(req.getContextPath() + "/manager/bookServlet?action=list");
}
解决 book_edit.jsp 页面,即要实现添加,又要实现修改操作
<div id="main">
<form action="manager/bookServlet" method="post">
<input type="hidden" name="action" value="${ empty param.id ? "add" : "update" }" />
<input type="hidden" name="id" value="${ requestScope.book.id }" />