主要功能介绍：本宠物领养系统主要用于宠物领养，此外，还具备了宠物周边商城购买的功能。主要通过管理员和用户来进行宠物领养。针对待领养的宠物数据，系统主要需要记录宠物信息、宠物领养数据等等。系统使用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 ***MENT 'id',
`nickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ***MENT '账号',
`username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ***MENT '姓名',
`pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ***MENT '密码',
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 ***MENT '宠物类型id',
`***ame` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ***MENT '类型名称',
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 ***MENT '领养记录id',
`uid` int(11) DEFAULT NULL ***MENT '领养人id',
`uname` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ***MENT '领养人姓名',
`uphone` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ***MENT '领养人手机',
`uaddress` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ***MENT '领养人地址',
`pid` int(11) DEFAULT NULL ***MENT '宠物id',
`pname` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ***MENT '宠物名称',
`ctime` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ***MENT '领养时间',
`state` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ***MENT '审核状态（0 待审核 1 同意领养 2 拒绝领养）',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 41 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = ***pact;
-- ----------------------------
-- 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 ***MENT '购买订单di',
`uid` int(11) DEFAULT NULL ***MENT '下单人id',
`pid` int(11) DEFAULT NULL ***MENT '商品id',
`ctime` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ***MENT '下单时间',
`rno` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ***MENT '订单号',
`num` int(11) DEFAULT NULL ***MENT '数量',
`uname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ***MENT '收件人姓名',
`phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ***MENT '收件人手机',
`address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ***MENT '收件人地址',
`pay` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ***MENT '下单方式（1货到付款，2支付宝，3微信）',
`state` int(255) DEFAULT NULL ***MENT '订单状态',
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 ***MENT '宠物id',
`name` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ***MENT '宠物名称',
`type` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ***MENT '宠物类型',
`sex` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ***MENT '宠物性别',
`birthday` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ***MENT '宠物出生日期',
`photo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ***MENT '宠物图片',
`state` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ***MENT '领养状态',
`ctime` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ***MENT '录入时间',
`detail` varchar(2555) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ***MENT '宠物介绍',
`description` text CHARACTER SET utf8 COLLATE utf8_general_ci ***MENT '宠物描述',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 31 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = ***pact;
-- ----------------------------
-- Records of pet
-- ----------------------------
INSERT INTO `pet` VALUES (23, '小黑黑', '犬类', '公', '2022-6-7', '933d7f36-92db-46b0-8c04-fe44e463191f.png', '0', '2022-03-18 00:24', '小黑黑是一只拉布拉多的狗子，性格温顺，不到处拉屎！', '<p>小黑黑是一只拉布拉多的狗子，性格温顺，不到处拉屎！</p><p><img src=\"/pet/ueditor/jsp/upload/image/20221110/1668082051749041503.png\" title=\"1668082051749041503.png\" alt=\"18482c63-4c29-40d0-995d-7ed87c7f3a84.png\"/></p>');
INSERT INTO `pet` VALUES (24, '小黑黑', '犬类', '公', '2022-6-7', '933d7f36-92db-46b0-8c04-fe44e463191f.png', '0', '2022-03-18 00:24', '小黑黑是一只拉布拉多的狗子，性格温顺，不到处拉屎！', '<p>小黑黑是一只拉布拉多的狗子，性格温顺，不到处拉屎！</p><p><img src=\"/pet/ueditor/jsp/upload/image/20221110/1668082051749041503.png\" title=\"1668082051749041503.png\" alt=\"18482c63-4c29-40d0-995d-7ed87c7f3a84.png\"/></p>');
INSERT INTO `pet` VALUES (25, '小黑黑', '犬类', '公', '2022-6-7', '933d7f36-92db-46b0-8c04-fe44e463191f.png', '0', '2022-03-18 00:24', '小黑黑是一只拉布拉多的狗子，性格温顺，不到处拉屎！', '<p>小黑黑是一只拉布拉多的狗子，性格温顺，不到处拉屎！</p><p><img src=\"/pet/ueditor/jsp/upload/image/20221110/1668082051749041503.png\" title=\"1668082051749041503.png\" alt=\"18482c63-4c29-40d0-995d-7ed87c7f3a84.png\"/></p>');
INSERT INTO `pet` VALUES (26, '小黑黑', '犬类', '公', '2022-6-7', '933d7f36-92db-46b0-8c04-fe44e463191f.png', '0', '2022-11-09 17:25', '小黑黑是一只拉布拉多的狗子，性格温顺，不到处拉屎！', '<p>小黑黑是一只拉布拉多的狗子，性格温顺，不到处拉屎！</p><p><img src=\"/pet/ueditor/jsp/upload/image/20221110/1668082051749041503.png\" title=\"1668082051749041503.png\" alt=\"18482c63-4c29-40d0-995d-7ed87c7f3a84.png\"/></p>');
INSERT INTO `pet` VALUES (27, '咪咪', '犬类', '公', '2022-6-7', '2236f580-6e4b-49de-be9e-546591323b4d.jpeg', '0', '2022-11-09 17:26', '小黑黑是一只拉布拉多的狗子，性格温顺，不到处拉屎！', '<p>小黑黑是一只拉布拉多的狗子，性格温顺，不到处拉屎！</p><p><img src=\"/pet/ueditor/jsp/upload/image/20221110/1668082051749041503.png\" title=\"1668082051749041503.png\" alt=\"18482c63-4c29-40d0-995d-7ed87c7f3a84.png\"/></p>');
INSERT INTO `pet` VALUES (28, '虎子', '犬类', '公', '2022-6-7', '04ec8d4e-28a8-4e94-a362-2148a2d3456a.jpeg', '0', '2022-11-09 17:26', '小黑黑是一只拉布拉多的狗子，性格温顺，不到处拉屎！', '<p>小黑黑是一只拉布拉多的狗子，性格温顺，不到处拉屎！</p><p><img src=\"/pet/ueditor/jsp/upload/image/20221110/1668082051749041503.png\" title=\"1668082051749041503.png\" alt=\"18482c63-4c29-40d0-995d-7ed87c7f3a84.png\"/></p>');
INSERT INTO `pet` VALUES (29, '猫咪', '犬类', '公', '2022-6-7', '7b09562a-a39f-445c-abd5-fbd81086db6a.jpeg', '11', '2022-11-09 17:26', '小黑黑是一只拉布拉多的狗子，性格温顺，不到处拉屎！', '<p>小黑黑是一只拉布拉多的狗子，性格温顺，不到处拉屎！</p><p><img src=\"/pet/ueditor/jsp/upload/image/20221110/1668082051749041503.png\" title=\"1668082051749041503.png\" alt=\"18482c63-4c29-40d0-995d-7ed87c7f3a84.png\"/></p>');
INSERT INTO `pet` VALUES (30, '小黑黑1', '猫科类', '公', '2022-6-7', '9953cb99-77b4-4fa4-a494-167659522d91.jpeg', '1', '2022-11-09 18:08', '小黑黑是一只拉布拉多的狗子，性格温顺，不到处拉屎！', '<p>小黑黑是一只拉布拉多的狗子，性格温顺，不到处拉屎！</p><p><img src=\"/pet/ueditor/jsp/upload/image/20221110/1668082051749041503.png\" title=\"1668082051749041503.png\" alt=\"18482c63-4c29-40d0-995d-7ed87c7f3a84.png\"/></p>');
-- ----------------------------
-- Table structure for pinglun
-- ----------------------------
DROP TABLE IF EXISTS `pinglun`;
CREATE TABLE `pinglun` (
`id` int(11) NOT NULL AUTO_INCREMENT ***MENT '评论id',
`order` int(11) DEFAULT NULL ***MENT '领养记录id',
`content` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ***MENT '评论内容',
`pid` int(11) DEFAULT NULL ***MENT '对应宠物id',
`pname` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ***MENT '宠物名称',
`uid` int(11) DEFAULT NULL ***MENT '领养人id',
`uname` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ***MENT '领养人姓名',
`utime` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ***MENT '发布时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = ***pact;
-- ----------------------------
-- 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 ***MENT '商品id',
`pname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ***MENT '名称',
`pid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ***MENT '类型，对应宠物类型',
`price` double(10, 2) DEFAULT NULL ***MENT '价格',
`title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ***MENT '标题',
`detail` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ***MENT '详情',
`ctime` varchar(223) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ***MENT '录入时间',
`pno` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ***MENT '商品编号',
`weight` double(22, 0) DEFAULT NULL ***MENT '重量',
`type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ***MENT '包装方式',
`img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ***MENT '图片',
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这是一件适用狗狗的用品', '<p>小黑黑是一只拉布拉多的狗子，性格温顺，不到处拉屎！</p><p><img src=\"/pet/ueditor/jsp/upload/image/20221110/1668082051749041503.png\" title=\"1668082051749041503.png\" alt=\"18482c63-4c29-40d0-995d-7ed87c7f3a84.png\"/></p>', '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这是一件适用狗狗的用品', '<p>小黑黑是一只拉布拉多的狗子，性格温顺，不到处拉屎！</p><p><img src=\"/pet/ueditor/jsp/upload/image/20221110/1668082051749041503.png\" title=\"1668082051749041503.png\" alt=\"18482c63-4c29-40d0-995d-7ed87c7f3a84.png\"/></p>', '2022-11-10 00:00', '002', 3, '盒', '34bde658-a5bd-4f2c-8086-853c1af77359.jpg');
INSERT INTO `product` VALUES (3, '猫用猫薄荷', '2', 4.00, '猫薄荷', '<p>小黑黑是一只拉布拉多的狗子，性格温顺，不到处拉屎！</p><p><img src=\"/pet/ueditor/jsp/upload/image/20221110/1668082051749041503.png\" title=\"1668082051749041503.png\" alt=\"18482c63-4c29-40d0-995d-7ed87c7f3a84.png\"/></p>', '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 ***MENT '用户id',
`realname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ***MENT '用户名',
`sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ***MENT '用户性别',
`phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ***MENT '手机号',
`address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ***MENT '住址',
`pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ***MENT '密码',
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;
