一、MVC
1. 概念介绍
V : JSP/HTML 只负责数据和界面的显示,不接受其他任何代码。便于程序员和美工分工合作;
C : controller : 控制器。 Servlet 只负责接收请求, 调用业务层的代码处理请求,然后派发页面,是一个调度者的角色。eg: 转到某个页面,或者重定向到某个页面。
M: 模型。 JavaBean/ domain/ entity/pojo 将与业务逻辑相关的数据封装成具体的JavaBean类,其中不参杂任何与数据处理相关的代码。
二、 图书模块
1. 图书模块
1.1 编写图书模块的数据库表
- 创建book的数据库表
CREATE TABLE IF NOT EXISTS t_book(
`id` INT PRIMARY KEY AUTO_INCREMENT,
`name` VARCHAR(120),
`price` DECIMAL(11,2),
`author` VARCHAR(40),
`sales` INT,
`stock` INT,
`img_path` VARCHAR(200)
);
- 创建book的数据库表
- 填充数据库,创建一些实例
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');
- 填充数据库,创建一些实例
1.3 编写图书模块的Dao和测试Dao
- 增删改查:
- ![image.png](https://cdn.nlark.com/yuque/0/2021/png/22435741/1630674210567-018cb4d2-1627-4a06-a7b7-7c03c1bb5bd8.png#clientId=udb1c34be-777e-4&from=paste&height=885&id=u880cf6ba&margin=%5Bobject%20Object%5D&name=image.png&originHeight=885&originWidth=1883&originalType=binary&ratio=1&size=153283&status=done&style=none&taskId=uc5f21e74-0640-47b4-9aef-d8f1c83d405&width=1883)
- <br />
1.4 编写图书模块的Service和测试Service
service依赖Dao来操作数据库
1.5 编写图书模块的Web层,和页面联调测试
- 1. 首先通过点击首页(localhost:8080/book/)中的“后台管理”,进入“后台管理系统”(localhost:8080/book/manager/manager.jsp)
- 2. 在“后台管理系统”页面中点击“图书管理”,展示所有的图书信息
- 实现步骤:
- 在web层目录的web.xml中注册BookServlet:
- ![image.png](https://cdn.nlark.com/yuque/0/2021/png/22435741/1630678620337-29f3810a-1230-4dac-9532-ea81d05a85a8.png#clientId=udb1c34be-777e-4&from=paste&height=763&id=u3d73be98&margin=%5Bobject%20Object%5D&name=image.png&originHeight=763&originWidth=1588&originalType=binary&ratio=1&size=115958&status=done&style=none&taskId=uaa7be4c2-8d41-413d-82ea-8a0108e5333&width=1588)
- 在web层目录的web.xml中注册BookServlet:
- 修改“图书管理”的链接地址:
- ![image.png](https://cdn.nlark.com/yuque/0/2021/png/22435741/1630679205739-43752a55-bf3f-4a73-8cfa-988aa0c4acf7.png#clientId=udb1c34be-777e-4&from=paste&height=557&id=u09af65a8&margin=%5Bobject%20Object%5D&name=image.png&originHeight=557&originWidth=1124&originalType=binary&ratio=1&size=83640&status=done&style=none&taskId=u0c73a34e-1b45-4115-bcf9-0c91c57e7b1&width=1124)
- 修改“图书管理”的链接地址:
- 调用BookServlet.java中的list():
- ![image.png](https://cdn.nlark.com/yuque/0/2021/png/22435741/1630679919524-db27630c-e119-4446-9c3d-7917bb1bd568.png#clientId=udb1c34be-777e-4&from=paste&height=704&id=u00ff4ab1&margin=%5Bobject%20Object%5D&name=image.png&originHeight=704&originWidth=1571&originalType=binary&ratio=1&size=118392&status=done&style=none&taskId=u1a9b215c-63b1-41d1-ab56-cf33f65e842&width=1571)
- 调用BookServlet.java中的list():
- 完善book_manager.jsp,使book相关的内容可以展示出来:
- ![image.png](https://cdn.nlark.com/yuque/0/2021/png/22435741/1630680530681-42d18860-b80d-4dec-8ea0-37ca54f86007.png#clientId=udb1c34be-777e-4&from=paste&height=505&id=u5e499e14&margin=%5Bobject%20Object%5D&name=image.png&originHeight=505&originWidth=1592&originalType=binary&ratio=1&size=116250&status=done&style=none&taskId=u78cc6106-4c61-4ed4-a308-e458bf93b02&width=1592)
- 完善book_manager.jsp,使book相关的内容可以展示出来: