项目描述:
系统以JSP为主开发的在线购书系统,实现了用户注册、登陆、验证身份及书籍的预览查询、包含管理端和用户端、对书籍的购买通过购物车实现等功能。
功能模块:
管理端 – 用户管理、图书管理、分类管理
用户端 – 用户信息、图书浏览、购物车、订单
技术栈:
JSP、Servlet、dbcp 连接池、Bootstrap
数据库设计:
部分数据库表设计如下, 其他参见源码包
用户表:
DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `LoginId` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `LoginPwd` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `Name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `Address` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `Phone` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `Mail` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `UserRoleId` int(11) NOT NULL, `UserStateId` int(11) NOT NULL, PRIMARY KEY (`Id`) USING BTREE, INDEX `UserRoleId`(`UserRoleId`) USING BTREE, INDEX `UserStateId`(`UserStateId`) USING BTREE, CONSTRAINT `users_ibfk_1` FOREIGN KEY (`UserRoleId`) REFERENCES `userroles` (`Id`) ON DELETE CASCADE ON UPDATE RESTRICT, CONSTRAINT `users_ibfk_2` FOREIGN KEY (`UserStateId`) REFERENCES `userstates` (`Id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 2104 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
订单表
DROP TABLE IF EXISTS `orders`; CREATE TABLE `orders` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `OrderDate` datetime(0) NOT NULL, `UserId` int(11) NOT NULL, `TotalPrice` decimal(10, 2) NOT NULL, PRIMARY KEY (`Id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 92 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
书籍表
DROP TABLE IF EXISTS `books`; CREATE TABLE `books` ( `Id` int(8) NOT NULL AUTO_INCREMENT, `Title` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `Author` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `PublisherId` int(8) NOT NULL, `PublishDate` datetime(0) NOT NULL, `ISBN` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `WordsCount` int(11) NULL DEFAULT NULL, `UnitPrice` decimal(10, 0) NOT NULL, `ContentDescription` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `AuthorDescription` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `EditorComment` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `TOC` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `CategoryId` int(11) NOT NULL, `Clicks` int(11) NULL DEFAULT NULL, `Pic` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`Id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 6094 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
运行环境:
- 本地测试
- 操作系统:Win11
- 浏览器:Chrome浏览器
- 开发工具:IDEA
- 数据库:MySQL5.6
Eclipse EE、JDK 1.8+、Tomcat 8.5+、Mysql 5.7+
测试账号:
会员账号密码:user/user
管理员账号密码:admin/admin
部分截图:
测试只展示部分截图,需要更多详细内容请下载源代码
基于JSP开发在线购书系统-用户登录
基于JSP开发在线购书系统-首页
基于JSP开发在线购书系统-购物车
基于JSP开发在线购书系统-后台-图书分类管理
基于JSP开发在线购书系统-后台-图书列表
注意事项:
本站所有源码仅供参考学习,请勿用于违法用途,否侧因此造成的一切后果本站不承担!
本站所发布的全部内容源于互联网搬运,仅限于小范围内传播学习和案例参考!
请在下载后24小时内删除,如果有侵权之处请第一时间联系我们删除!