【原创】JavaWeb的宠物领养系统（Web宠物领养系统毕业设计）

主要功能介绍：本宠物领养系统主要用于宠物领养，此外，还具备了宠物周边商城购买的功能。主要通过管理员和用户来进行宠物领养。针对待领养的宠物数据，系统主要需要记录宠物信息、宠物领养数据等等。系统使用B/S架构技术去实现，以MVC模式开发整个Web应用。宠物信息则是使用MySQL数据库存储。系统共由管理员、用户组成。其中管理员具有最高权限，能够查看平台的所有数据。用户使用，主要是查看自己需要的宠物，并可以提交领养信息。除了宠物领养模块，本系统还具备宠物周边商城购买功能。对于宠物日用品、宠物零食等都可以通过该系统进行购买。用户能够提交购买订单，并由管理员发货。

项目类型：JavaWeb源码
用户类型：2个角色（管理员+用户）
主要技术：Jsp+Servlet+MySQL+Jquery(前端Bootstrap)
开发工具：Eclipse/Idea均可使用，有两个不同的版本
数据库：MySQL
数据库表：8张

演示视频在底部
文末获取联系

01管理员功能

1.0用户管理模块

1.1宠物类别管理模块

1.2宠物信息管理模块

1.3课程管理模块

1.4宠物商品管理模块

1.5周边商场订单管理模块

1.6宠物领养管理模块

1.7评论管理模块

02用户端

2.1用户端首页

2.2宠物搜索页面

2.3宠物领养页面

2.4周边商城

2.5领养记录模块

2.6商城订单模块

2.7评论模块

03项目结构

04数据库设计

05演示视频

01管理员功能

1.0用户管理模块

1.1宠物类别管理模块

1.2宠物信息管理模块

1.3课程管理模块

1.4宠物商品管理模块

1.5周边商场订单管理模块

1.6宠物领养管理模块

1.7评论管理模块

02用户端

2.1用户端首页

2.2宠物搜索页面

2.3宠物领养页面

2.4周边商城

2.5领养记录模块

2.6商城订单模块

2.7评论模块

03项目结构

04数据库设计

05演示视频

【原创】基于JavaWeb的宠物领养系统

SET NAMES utf8mb4;SET FOREIGN_KEY_CHECKS = 0;-- ------------------------------ Table structure for admin-- ----------------------------DROP TABLE IF EXISTS `admin`;CREATE TABLE `admin`(`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',`nickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '账号',`username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '姓名',`pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '密码',PRIMARY KEY (`id`) USING BTREE) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ------------------------------ Records of admin-- ----------------------------INSERT INTO `admin` VALUES (1, '超管', '1', '1');-- ------------------------------ Table structure for category-- ----------------------------DROP TABLE IF EXISTS `category`;CREATE TABLE `category`(`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '宠物类型id',`cname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '类型名称',PRIMARY KEY (`id`) USING BTREE) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ------------------------------ Records of category-- ----------------------------INSERT INTO `category` VALUES (1, '犬类');INSERT INTO `category` VALUES (2, '猫科类');INSERT INTO `category` VALUES (4, '仓鼠');-- ------------------------------ Table structure for orders-- ----------------------------DROP TABLE IF EXISTS `orders`;CREATE TABLE `orders`(`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '领养记录id',`uid` int(11) DEFAULT NULL COMMENT '领养人id',`uname` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '领养人姓名',`uphone` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '领养人手机',`uaddress` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '领养人地址',`pid` int(11) DEFAULT NULL COMMENT '宠物id',`pname` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '宠物名称',`ctime` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '领养时间',`state` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '审核状态（0 待审核 1 同意领养 2 拒绝领养）',PRIMARY KEY (`id`) USING BTREE) ENGINE = InnoDB AUTO_INCREMENT = 41 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;-- ------------------------------ Records of orders-- ----------------------------INSERT INTO `orders` VALUES (37, 20, '1', '1', '1', 25, '4455', '2022-03-18 00:25', '2');INSERT INTO `orders` VALUES (38, 20, '1', '1', '1', 25, '4455', '2022-03-18 00:26', '0');INSERT INTO `orders` VALUES (39, 20, '狄', '18020187141', '123123', 30, '小黑黑1', '2022-11-10 20:10', '1');INSERT INTO `orders` VALUES (40, 15, 'zhangsan5', '15526101205', '湖南长沙5', 29, '猫咪', '2023-08-08 20:44', '0');-- ------------------------------ Table structure for payrecord-- ----------------------------DROP TABLE IF EXISTS `payrecord`;CREATE TABLE `payrecord`(`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '购买订单di',`uid` int(11) DEFAULT NULL COMMENT '下单人id',`pid` int(11) DEFAULT NULL COMMENT '商品id',`ctime` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '下单时间',`rno` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '订单号',`num` int(11) DEFAULT NULL COMMENT '数量',`uname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '收件人姓名',`phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '收件人手机',`address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '收件人地址',`pay` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '下单方式（1货到付款，2支付宝，3微信）',`state` int(255) DEFAULT NULL COMMENT '订单状态',PRIMARY KEY (`id`) USING BTREE) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ------------------------------ Records of payrecord-- ----------------------------INSERT INTO `payrecord` VALUES (7, 15, 3, '2023-08-08 20:37', '20230808203713839', 1, '张三', '18020185141', '南京', '微信支付', 0);INSERT INTO `payrecord` VALUES (8, 15, 2, '2023-08-08 20:40', '20230808204006258', 2, '张三', '18020185141', '无锡', '微信支付', 0);INSERT INTO `payrecord` VALUES (9, 15, 1, '2023-08-08 20:44', '20230808204420509', 3, '张三', '18020185141', '无锡', '微信支付', 1);-- ------------------------------ Table structure for pet-- ----------------------------DROP TABLE IF EXISTS `pet`;CREATE TABLE `pet`(`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '宠物id',`name` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '宠物名称',`type` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '宠物类型',`sex` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '宠物性别',`birthday` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '宠物出生日期',`photo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '宠物图片',`state` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '领养状态',`ctime` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '录入时间',`detail` varchar(2555) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '宠物介绍',`description` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '宠物描述',PRIMARY KEY (`id`) USING BTREE) ENGINE = InnoDB AUTO_INCREMENT = 31 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;-- ------------------------------ Records of pet-- ----------------------------INSERT INTO `pet` VALUES (23, '小黑黑', '犬类', '公', '2022-6-7', '933d7f36-92db-46b0-8c04-fe44e463191f.png', '0', '2022-03-18 00:24', '小黑黑是一只拉布拉多的狗子，性格温顺，不到处拉屎！', '小黑黑是一只拉布拉多的狗子，性格温顺，不到处拉屎！
');INSERT INTO `pet` VALUES (24, '小黑黑', '犬类', '公', '2022-6-7', '933d7f36-92db-46b0-8c04-fe44e463191f.png', '0', '2022-03-18 00:24', '小黑黑是一只拉布拉多的狗子，性格温顺，不到处拉屎！', '小黑黑是一只拉布拉多的狗子，性格温顺，不到处拉屎！
');INSERT INTO `pet` VALUES (25, '小黑黑', '犬类', '公', '2022-6-7', '933d7f36-92db-46b0-8c04-fe44e463191f.png', '0', '2022-03-18 00:24', '小黑黑是一只拉布拉多的狗子，性格温顺，不到处拉屎！', '小黑黑是一只拉布拉多的狗子，性格温顺，不到处拉屎！
');INSERT INTO `pet` VALUES (26, '小黑黑', '犬类', '公', '2022-6-7', '933d7f36-92db-46b0-8c04-fe44e463191f.png', '0', '2022-11-09 17:25', '小黑黑是一只拉布拉多的狗子，性格温顺，不到处拉屎！', '小黑黑是一只拉布拉多的狗子，性格温顺，不到处拉屎！
');INSERT INTO `pet` VALUES (27, '咪咪', '犬类', '公', '2022-6-7', '2236f580-6e4b-49de-be9e-546591323b4d.jpeg', '0', '2022-11-09 17:26', '小黑黑是一只拉布拉多的狗子，性格温顺，不到处拉屎！', '小黑黑是一只拉布拉多的狗子，性格温顺，不到处拉屎！
');INSERT INTO `pet` VALUES (28, '虎子', '犬类', '公', '2022-6-7', '04ec8d4e-28a8-4e94-a362-2148a2d3456a.jpeg', '0', '2022-11-09 17:26', '小黑黑是一只拉布拉多的狗子，性格温顺，不到处拉屎！', '小黑黑是一只拉布拉多的狗子，性格温顺，不到处拉屎！
');INSERT INTO `pet` VALUES (29, '猫咪', '犬类', '公', '2022-6-7', '7b09562a-a39f-445c-abd5-fbd81086db6a.jpeg', '11', '2022-11-09 17:26', '小黑黑是一只拉布拉多的狗子，性格温顺，不到处拉屎！', '小黑黑是一只拉布拉多的狗子，性格温顺，不到处拉屎！
');INSERT INTO `pet` VALUES (30, '小黑黑1', '猫科类', '公', '2022-6-7', '9953cb99-77b4-4fa4-a494-167659522d91.jpeg', '1', '2022-11-09 18:08', '小黑黑是一只拉布拉多的狗子，性格温顺，不到处拉屎！', '小黑黑是一只拉布拉多的狗子，性格温顺，不到处拉屎！
');-- ------------------------------ Table structure for pinglun-- ----------------------------DROP TABLE IF EXISTS `pinglun`;CREATE TABLE `pinglun`(`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '评论id',`order` int(11) DEFAULT NULL COMMENT '领养记录id',`content` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '评论内容',`pid` int(11) DEFAULT NULL COMMENT '对应宠物id',`pname` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '宠物名称',`uid` int(11) DEFAULT NULL COMMENT '领养人id',`uname` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '领养人姓名',`utime` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '发布时间',PRIMARY KEY (`id`) USING BTREE) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;-- ------------------------------ Records of pinglun-- ----------------------------INSERT INTO `pinglun` VALUES (9, 5, '湖南长沙5', 4, '柯基猫', 15, 'zhangsan', '2022-03-12 14:31');INSERT INTO `pinglun` VALUES (10, 5, '222', 4, '柯基猫', 15, 'zhangsan', '2022-03-12 21:45');INSERT INTO `pinglun` VALUES (11, 13, '222', 6, '小六1', 18, '22', '2022-03-12 21:46');INSERT INTO `pinglun` VALUES (12, 17, '123asdasd\nasdasd', 19, '444', 20, '1', '2022-03-13 11:34');INSERT INTO `pinglun` VALUES (13, 17, '222', 19, '444', 20, '1', '2022-03-13 11:54');INSERT INTO `pinglun` VALUES (14, 17, '333', 19, '444', 20, '1', '2022-03-13 11:55');INSERT INTO `pinglun` VALUES (15, 17, '222', 19, '444', 20, '1', '2022-03-17 21:19');INSERT INTO `pinglun` VALUES (16, 17, '2222', 19, '444', 20, '1', '2022-03-17 21:19');INSERT INTO `pinglun` VALUES (17, 17, '111', 19, '444', 20, '1', '2022-03-17 21:19');INSERT INTO `pinglun` VALUES (18, 21, '222', 22, '4444', 20, '1', '2022-03-17 22:41');INSERT INTO `pinglun` VALUES (19, 21, '22222', 22, '4444', 20, '1', '2022-03-17 22:41');INSERT INTO `pinglun` VALUES (20, 21, '3333', 22, '4444', 20, '1', '2022-03-17 22:41');INSERT INTO `pinglun` VALUES (21, 38, '2020\n', 25, '4455', 20, '1', '2022-03-18 00:27');INSERT INTO `pinglun` VALUES (22, 38, '222', 25, '4455', 20, '1', '2022-03-18 00:27');INSERT INTO `pinglun` VALUES (23, 38, '444', 25, '4455', 20, '1', '2022-03-18 00:27');INSERT INTO `pinglun` VALUES (24, 37, '20', 25, '4455', 20, '1', '2022-11-09 17:45');INSERT INTO `pinglun` VALUES (25, 39, '123123', 30, '小黑黑1', 20, '狄', '2022-11-10 20:12');INSERT INTO `pinglun` VALUES (26, 39, '可爱小狗', 30, '小黑黑1', 20, '狄', '2022-11-10 20:12');-- ------------------------------ Table structure for product-- ----------------------------DROP TABLE IF EXISTS `product`;CREATE TABLE `product`(`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '商品id',`pname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '名称',`pid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '类型，对应宠物类型',`price` double(10, 2) DEFAULT NULL COMMENT '价格',`title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '标题',`detail` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '详情',`ctime` varchar(223) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '录入时间',`pno` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '商品编号',`weight` double(22, 0) DEFAULT NULL COMMENT '重量',`type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '包装方式',`img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '图片',PRIMARY KEY (`id`) USING BTREE) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ------------------------------ Records of product-- ----------------------------INSERT INTO `product` VALUES (1, '火腿肠', '1', 2.00, '4这是一件适用狗狗的用品4这是一件适用狗狗的用品4这是一件适用狗狗的用品4这是一件适用狗狗的用品4这是一件适用狗狗的用品4这是一件适用狗狗的用品', '小黑黑是一只拉布拉多的狗子，性格温顺，不到处拉屎！
', '2022-11-09 23:55', 'A-002', 5, '2', '57cbdea3-b664-49b6-a1eb-1f9ba34a2bc2.jpg');INSERT INTO `product` VALUES (2, '苹果', '1', 3.00, '4这是一件适用狗狗的用品4这是一件适用狗狗的用品4这是一件适用狗狗的用品4这是一件适用狗狗的用品4这是一件适用狗狗的用品4这是一件适用狗狗的用品', '小黑黑是一只拉布拉多的狗子，性格温顺，不到处拉屎！
', '2022-11-10 00:00', '002', 3, '盒', '34bde658-a5bd-4f2c-8086-853c1af77359.jpg');INSERT INTO `product` VALUES (3, '猫用猫薄荷', '2', 4.00, '猫薄荷', '小黑黑是一只拉布拉多的狗子，性格温顺，不到处拉屎！
', '2022-11-10 00:01', '001', 4, '颗', '528e2237-0ce6-4055-9c6f-06f51b215f98.jpeg');-- ------------------------------ Table structure for user-- ----------------------------DROP TABLE IF EXISTS `user`;CREATE TABLE `user`(`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户id',`realname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '用户名',`sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '用户性别',`phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '手机号',`address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '住址',`pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '密码',PRIMARY KEY (`id`) USING BTREE) ENGINE = InnoDB AUTO_INCREMENT = 24 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ------------------------------ Records of user-- ----------------------------INSERT INTO `user` VALUES (15, 'zhangsan5', '男', '15526101205', '湖南长沙5', '123456');INSERT INTO `user` VALUES (16, '李四', '男', '13397649345', '湖南长沙', '123123');INSERT INTO `user` VALUES (17, '王五1', '男', '15526101203', '湖南长沙1', '123123');SET FOREIGN_KEY_CHECKS = 1;

【原创】JavaWeb的宠物领养系统（Web宠物领养系统毕业设计）