基于SSM的宠物领养系统源码+数据库（毕业设计）.zip

/* Navicat Premium Data Transfer Source Server : localhost_3306 Source Server Type : MySQL Source Server Version : 50730 Source Host : localhost:3306 Source Schema : adopt Target Server Type : MySQL Target Server Version : 50730 File Encoding : 65001 Date: 19/11/2022 15:07:38 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for admins -- ---------------------------- DROP TABLE IF EXISTS `admins`; CREATE TABLE `admins` ( `id` int(11) NOT NULL AUTO_INCREMENT, `adminName` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '管理员的名字', `adminPwd` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码', `realName` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '真实的名字', `telephone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '电话', `Email` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `birthday` date NOT NULL, `sex` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `pic` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'a.png', `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of admins -- ---------------------------- INSERT INTO `admins` VALUES (1, '牌牌琦', 'yi123', '杨一', '13902193927', '3268483030@qq.com', '2001-08-22', '男', 'a1.png', '外号 玄宗。这位可是我们团队的玄学的代表。由他在似乎任何困难都能解决。'); INSERT INTO `admins` VALUES (2, '卡瓦哈尔', 'wemz123', '王二麻子', '14402193927', '3268483030@qq.com', '2001-08-22', '男', 'a2.png', '外号 大傻；他是我们团队中最热心的人。他积极参加团队活动，并且在团队需要他的时候总是全力完成 '); INSERT INTO `admins` VALUES (3, '瓦拉内', 'zs123', '张三', '14495893927', '3268483030@qq.com', '2001-08-22', '男', 'a3.png', '外号 学霸。这是为真正的学霸，他平时热心团队活动，并且负责团队的财务管理，认真严谨。'); INSERT INTO `admins` VALUES (4, '拉莫斯', 'ls123', '李四', '14495893012', '3268483030@qq.com', '2001-08-22', '男', 'a4.png', '外号 水爷。这位团队外号虽然有水，但是一点也不水，他是我们的队长，为了团队他付出了最多的精力，而且他经常保护队员的安全.'); INSERT INTO `admins` VALUES (5, '纳乔', 'ww123', '王五', '14495890112', '3268483030@qq.com', '2001-08-22', '女', 'a5.png', '外号 万金油。这位队员人如其名，是我们团队的万金油，当我们团队成员，紧急有事的时候，他都能顶上去，是一个很可靠的人。'); INSERT INTO `admins` VALUES (6, '马塞洛', 'zl123', '赵六', '13195890112', '3268483030@qq.com', '2001-08-22', '男', 'a6.png', '外号 队宠。这位是我们的副队长，他是我们团队的开心果，在平常的活动中，他总能带给我们快乐。'); INSERT INTO `admins` VALUES (7, '阿扎尔', 'sql1234', '孙七', '13195890081', '3268483030@qq.com', '2001-08-22', '男', 'a7.png', '外号 杨坤。这位不仅是团队中的颜值代表，而且是技术代表，他对小动物的保护知识是专家。他总能在保护小动物的方面给出正确的建议。'); INSERT INTO `admins` VALUES (9, '本泽马', '342', '342', '342', '3268483030@qq.com', '2001-08-22', '女', 'a9.png', '外号 背锅侠。这位是我们团队中的冲锋者，勇敢。但由于一些事，就造就了背锅侠的名号。'); INSERT INTO `admins` VALUES (10, '莫德里奇', '111', '卢卡', '15797959509', '3268483030@qq.com', '2001-08-22', '男', 'a10.png', '外号 魔笛。这位和我们团队中的杨坤都是技术与颜值的代表，而且他总是保持一颗冷静的心，在面对困难的时候，总是临危不惧。'); INSERT INTO `admins` VALUES (11, '贝尔', '1111', '孙悟空', '15797959509', '3268483030@qq.com', '2001-08-22', '女', 'a11.png', '号称孙悟空，无敌的存在！！'); -- ---------------------------- -- Table structure for adoptanimal -- ---------------------------- DROP TABLE IF EXISTS `adoptanimal`; CREATE TABLE `adoptanimal` ( `id` int(11) NOT NULL AUTO_INCREMENT, `userId` int(11) NOT NULL COMMENT '用户表id的外键', `petId` int(11) NOT NULL COMMENT '宠物表id的外键', `adoptTime` date NOT NULL, `state` int(11) NULL DEFAULT 1 COMMENT '是否同意被领养 0 是不同意 1 还在审核 2 是同意', PRIMARY KEY (`id`) USING BTREE, INDEX `fk3`(`userId`) USING BTREE, INDEX `fk4`(`petId`) USING BTREE, CONSTRAINT `fk3` FOREIGN KEY (`userId`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk4` FOREIGN KEY (`petId`) REFERENCES `pet` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE = InnoDB AUTO_INCREMENT = 23 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of adoptanimal -- ---------------------------- INSERT INTO `adoptanimal` VALUES (1, 1, 1, '2022-11-24', 2); INSERT INTO `adoptanimal` VALUES (2, 5, 2, '2022-11-24', 0); INSERT INTO `adoptanimal` VALUES (3, 3, 3, '2022-11-24', 1); INSERT INTO `adoptanimal` VALUES (4, 4, 4, '2022-11-24', 0); INSERT INTO `adoptanimal` VALUES (5, 2, 5, '2019-08-17', 0); INSERT INTO `adoptanimal` VALUES (6, 6, 6, '2019-08-16', 2); INSERT INTO `adoptanimal` VALUES (7, 7, 7, '2019-08-15', 2); INSERT INTO `adoptanimal` VALUES (8, 2, 8, '2019-08-14', 0); INSERT INTO `adoptanimal` VALUES (9, 9, 9, '2019-08-13', 2); INSERT INTO `adoptanimal` VALUES (10, 9, 1, '2019-08-09', 0); INSERT INTO `adoptanimal` VALUES (13, 1, 5, '2019-09-01', 0); INSERT INTO `adoptanimal` VALUES (14, 30, 5, '2019-09-09', 0); INSERT INTO `adoptanimal` VALUES (15, 30, 2, '2019-09-09', 0); INSERT INTO `adoptanimal` VALUES (16, 30, 2, '2019-09-09', 0); INSERT INTO `adoptanimal` VALUES (17, 30, 10, '2019-09-09', 1); INSERT INTO `adoptanimal` VALUES (18, 33, 1, '2022-11-10', 1); INSERT INTO `adoptanimal` VALUES (19, 33, 1, '2022-11-10', 1); INSERT INTO `adoptanimal` VALUES (20, 33, 2, '2022-11-10', 1); INSERT INTO `adoptanimal` VALUES (21, 34, 9, '2022-11-11', 1); INSERT INTO `adoptanimal` VALUES (22, 33, 8, '2022-11-15', 1); -- ---------------------------- -- Table structure for answer -- ---------------------------- DROP TABLE IF EXISTS `answer`; CREATE TABLE `answer` ( `id` int(11) NOT NULL AUTO_INCREMENT, `userId` int(11) NULL DEFAULT NULL, `replayId` int(11) NULL DEFAULT NULL, `commentId` int(11) NOT NULL, `answerTime` date NOT NULL, `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `fk8`(`userId`) USING BTREE, INDEX `fk11`(`commentId`) USING BTREE, INDEX `fk10`(`replayId`) USING BTREE, CONSTRAINT `fk10` FOREIGN KEY (`replayId`) REFERENCES `answer` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk11` FOREIGN KEY (`commentId`) REFERENCES `comment` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `fk8` FOREIGN KEY (`userId`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of answer -- ---------------------------- INSERT INTO `answer` VALUES (1, 2, NULL, 8, '2022-11-19', '这条狗很好动。 '); INSERT INTO `answer` VALUES (2, 5, 1, 8, '2022-11-19', '这只宠物很乖。'); INSERT INTO `answer` VALUES (3, 3, 2, 8, '2022-11-19', '我也喜欢这样的宠物。'); INSERT INTO `answer` VALUES (5, 1, NULL, 8, '2022-11-19', '我也喜欢这样的宠物。'); INSERT INTO `answer` VALUES (6, 1, NULL, 8, '2022-11-19', '我也喜欢这样的宠物。'); IN