【J019】基于JSP开发在线购书系统

项目描述：

系统以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开发在线购书系统-后台-图书列表