|
项目类型：JAVA WEB项目项目名称：JavaWeb基于Jsp+Servlet的动物领养网站用户类型：双角色（管理员+爱心人士）设计模式：Jsp+Servlet开发工具：Eclipse 数据库：Mysql+Navicat数据库表：6张适用：软件工程、计算机科学与技术等JAVA课程的学习和实验，可以参考文中的部分代码，实现自己所需要的功能。
项目非开源
咨询获取请关注：那条学长
回复java查看所有项目
演示视频如下：
JavaWeb毕设源码基于Jsp+Servlet的动物领养平台
1.在线领养动物
2.用户注册
3.用户登录
4.领养记录
5.领养转让
选择转让人
接收人审核是否转让，最后由管理员进行审核。
6.管理员端后台首页
7.动物管理
对待领养的动物实现增删改查。
8.收养用户管理
9.转让管理
10.回访管理
11.系统安全
12.项目结构
13.数据库
/*
Navicat Premium Data Transfer
Source Server : project
Source Server Type : MySQL
Source Server Version : 50715
Source Host : localhost:3306
Source Schema : db_dwjz
Target Server Type : MySQL
Target Server Version : 50715
File Encoding : 65001
Date: 20/03/2021 17:02:26
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for animal
-- ----------------------------
DROP TABLE IF EXISTS `animal`;
CREATE TABLE `animal` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键自增',
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '动物名称',
`imgUrl` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '动物照片',
`type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '动物种类',
`state` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '领养状态（0表示未领养，1表示已经领养,',
`createTime` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登记日期',
`nickName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '动物昵称',
`ano` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '动物编号',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '宠物表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of animal
-- ----------------------------
INSERT INTO `animal` VALUES (1, '小狗', '/img/dog.jpg', '哺乳类', '1', '2021-03-02 22:27', '旺財', '001');
INSERT INTO `animal` VALUES (2, '狗子', '/img/dog.jpg', '哺乳类', '1', '2021-03-05 23:47', '黑米', '002');
INSERT INTO `animal` VALUES (7, '大猩猩12', '/img/7aac9840-f022-404e-979d-05a2bb089b8f.jpg', '哺乳类', '1', '2021-03-06 22:45', '黑咪咪12', '003');
INSERT INTO `animal` VALUES (8, '小狗111', '/img/19639f58-196a-4714-aa52-647bda41a758.jpg', '哺乳类', '1', '2021-03-06 22:45', '旺財111', '004');
-- ----------------------------
-- Table structure for animal_save_record
-- ----------------------------
DROP TABLE IF EXISTS `animal_save_record`;
CREATE TABLE `animal_save_record` (
`lyid` int(11) NOT NULL AUTO_INCREMENT COMMENT '领养记录表id',
`animal_id` int(11) NOT NULL COMMENT '领养动物id',
`user_id` int(11) NULL DEFAULT NULL COMMENT '领养人id',
`createTime` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建日期',
`type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '1 饲养中 2 已转让 3转让中，待审核',
PRIMARY KEY (`lyid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '领养记录表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of animal_save_record
-- ----------------------------
INSERT INTO `animal_save_record` VALUES (1, 1, 1, '2021-03-02 22:57', '2');
INSERT INTO `animal_save_record` VALUES (4, 2, 1, '2021-03-07 21:46', '2');
INSERT INTO `animal_save_record` VALUES (5, 1, 21, '2021-03-07 22:55', '1');
INSERT INTO `animal_save_record` VALUES (6, 7, 1, '2021-03-16 16:52', '2');
INSERT INTO `animal_save_record` VALUES (8, 7, 21, '2021-03-16 17:07', '1');
INSERT INTO `animal_save_record` VALUES (9, 8, 1, '2021-03-16 18:10', '1');
INSERT INTO `animal_save_record` VALUES (10, 2, 21, '2021-03-16 18:21', '3');
INSERT INTO `animal_save_record` VALUES (11, 2, 1, '2021-03-17 11:07', '1');
-- ----------------------------
-- Table structure for animal_zr
-- ----------------------------
DROP TABLE IF EXISTS `animal_zr`;
CREATE TABLE `animal_zr` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT '转让表主键id',
`aniaml_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '宠物名称',
`animal_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '宠物种类',
`yzr` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '原主人',
`yzr_phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '原主人电话',
`xzr` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '新主人',
`xzr_phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '新主人电话',
`zr_way` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '转让方式',
`createTime` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '转让日期',
`animal_id` int(10) NULL DEFAULT NULL COMMENT '宠物id',
`yzr_id` int(10) NULL DEFAULT NULL COMMENT '原主人id',
`xzr_id` int(10) NULL DEFAULT NULL COMMENT '现主人id',
`time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建日期',
`state` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '0 审核不通过 1 待被转让用户审核 2待管理员审核 3 审核通过',
`ano` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '宠物编号',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '转让记录表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of animal_zr
-- ----------------------------
INSERT INTO `animal_zr` VALUES (1, '小狗', '哺乳类', '李庆照', '1234567890', '李庆照', '1234567890', '快递邮寄', '2021-03-11', 1, 1, 21, '2021-03-07 21:47', '3', NULL);
INSERT INTO `animal_zr` VALUES (2, '狗子', '哺乳类', '李庆照', '1234567890', '李庆照', '1234567890', '快递邮寄', '2021-03-11', 2, 1, 21, '2021-03-08 21:02', '0', NULL);
INSERT INTO `animal_zr` VALUES (3, '狗子', '哺乳类', '李庆照', '1234567890', '李庆照', '1234567890', '快递邮寄', '2021-03-16', 2, 1, 21, '2021-03-16 16:58', '0', NULL);
INSERT INTO `animal_zr` VALUES (4, '大猩猩12', '哺乳类', '李庆照', '1234567890', '李庆照', '1234567890', '线下转让', '2021-03-16', 7, 1, 21, '2021-03-16 17:02', '0', NULL);
INSERT INTO `animal_zr` VALUES (5, '大猩猩12', '哺乳类', '李庆照', '1234567890', '李庆照', '1234567890', '快递邮寄', '2021-03-16', 7, 1, 21, '2021-03-16 17:06', '3', NULL);
INSERT INTO `animal_zr` VALUES (6, '狗子', '哺乳类', '李庆照', '1234567890', '李庆照', '1234567890', '线下转让', '2021-03-16', 2, 1, 21, '2021-03-16 18:20', '3', NULL);
INSERT INTO `animal_zr` VALUES (7, '狗子', '哺乳类', '霹雳', '1234567890', '霹雳', '1234567890', '快递邮寄', '2021-03-17', 2, 21, 1, '2021-03-17 11:02', '3', '002');
INSERT INTO `animal_zr` VALUES (8, '老虎', '哺乳类', '李庆照', '1234567890', '李庆照', '1234567890', '快递邮寄', '2021-03-21', 9, 1, 21, '2021-03-17 11:13', '3', '005');
-- ----------------------------
-- Table structure for feed
-- ----------------------------
DROP TABLE IF EXISTS `feed`;
CREATE TABLE `feed` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`animal_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '动物姓名',
`wyfs` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '喂养方式',
`animal_id` int(10) NULL DEFAULT NULL COMMENT '动物表id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '喂养方式表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of feed
-- ----------------------------
INSERT INTO `feed` VALUES (1, '小狗', 'feedfeedfeed', 1);
INSERT INTO `feed` VALUES (2, '狗子', '狗粮狗粮狗粮狗粮狗粮狗粮狗粮狗粮', 2);
INSERT INTO `feed` VALUES (3, '小狗', NULL, 1);
INSERT INTO `feed` VALUES (4, '小狗', NULL, 1);
INSERT INTO `feed` VALUES (7, '兔子', '吃草', 10);
INSERT INTO `feed` VALUES (8, '老虎', '吃庆照', 9);
INSERT INTO `feed` VALUES (9, '大猩猩12', '吃水果蔬菜', 7);
INSERT INTO `feed` VALUES (10, '小狗111', '吃肉吃骨头', 8);
-- ----------------------------
-- Table structure for hfjl
-- ----------------------------
DROP TABLE IF EXISTS `hfjl`;
CREATE TABLE `hfjl` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '动物名称',
`category` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '动物类别',
`director` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '主人',
`condation` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '动物状况',
`hfz` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '回访者',
`hfrq` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '回访日期',
`director_id` int(11) NULL DEFAULT NULL COMMENT '主人id',
`animal_id` int(11) NULL DEFAULT NULL COMMENT '动物id',
`imgUrl` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '动物图片地址',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '回访记录表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of hfjl
-- ----------------------------
INSERT INTO `hfjl` VALUES (3, '狗子', '1', '狄玉辉', '测试', '狄玉辉', '2021-03-11', 1, 2, '/img/dog.jpg');
INSERT INTO `hfjl` VALUES (4, '狗子', '哺乳类', '狄玉辉1', '22222', '狄玉辉23232', '2021-03-04', 1, 2, '/img/dog.jpg');
INSERT INTO `hfjl` VALUES (6, '小狗', '哺乳类', '狄玉辉1', '好肥好', '狄玉辉1', '2021-03-13', 21, 1, '/img/dog.jpg');
-- ----------------------------
-- Table structure for user_admin
-- ----------------------------
DROP TABLE IF EXISTS `user_admin`;
CREATE TABLE `user_admin` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`userName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '账号',
`password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
`realName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '昵称',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '管理员表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of user_admin
-- ----------------------------
INSERT INTO `user_admin` VALUES (1, 'admin', '123456', '管理员2');
-- ----------------------------
-- Table structure for user_love_animal
-- ----------------------------
DROP TABLE IF EXISTS `user_love_animal`;
CREATE TABLE `user_love_animal` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
`password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
`realName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '真实姓名',
`sex` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别',
`phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话',
`address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址',
`createTime` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建日期',
`state` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '0表示未通过，1表示已经通过，2表示审核中',
`type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属类别，1表示个人，2表示组织',
`userName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 31 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '爱心人士/收养家庭' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of user_love_animal
-- ----------------------------
INSERT INTO `user_love_animal` VALUES (1, '[email protected]', '123456', '李庆照', '男', '1234567890', '新街口', '2021-02-26 22:36', '1', '1', 'lqz');
INSERT INTO `user_love_animal` VALUES (21, '[email protected]', '123456', '霹雳', '男', '1234567890', '新街口102栋', '2021-03-05 22:22', '1', '1', 'han');
INSERT INTO `user_love_animal` VALUES (28, '[email protected]', '123456', '张淋淋', '女', '1234567890', '新街口1212', '2021-03-10 22:39', '1', '1', 'zhanglinlin');
INSERT INTO `user_love_animal` VALUES (29, '[email protected]', '123456', '张三', '男', '13912345678', '江苏省泰州市泰兴市鼓楼路', '2021-03-17 16:37', '2', '1', 'zhangsan');
INSERT INTO `user_love_animal` VALUES (30, '[email protected]', '123456', '小明', '男', '13912345678', '江苏省泰州市泰兴市鼓楼路', '2021-03-20 16:59', '2', '1', 'xiaoming');
SET FOREIGN_KEY_CHECKS = 1;
|