Project type: JAVA WEB project
Project name: JavaWeb animal adoption website based on Jsp + Servlet
User type: dual roles (administrator + caring person)
Design pattern: Jsp + Servlet
Development Tools: Eclipse
Database: Mysql + Navicat
Database table: 6 sheets
Applicable: When studying and experimenting with JAVA courses such as software engineering, computer science and technology, etc., you can refer to some of the codes in the article to realize the functions you need.
1. Adopt animals online
2. User registration
3. User login
4.Adoption records
5. Adoption transfer
Select transferor
The recipient reviews whether to transfer, and the administrator finally reviews it.
6.Administrator backend homepage
7.Animal Management
Add, delete, modify and check adopted animals.
8.Adopted user management
9. Transfer management
10. Return visit management
11. System security
12. Project structure
13. Database
?
/* 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 animals ---------------------------- DROP TABLE IF EXISTS `animal`; CREATE TABLE `animal` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Primary key auto-increment', `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'animal name', `imgUrl` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'animal photos', `type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'animal species', `state` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'Adoption status (0 means not adopted, 1 means adopted,', `createTime` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'Registration Date', `nickName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'animal nickname', `ano` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'animal number', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'Pet Table' ROW_FORMAT = Dynamic; ---------------------------- -- Records of animals ---------------------------- INSERT INTO `animal` VALUES (1, 'puppy', '/img/dog.jpg', 'mammal', '1', '2021-03-02 22:27 ', 'Wangcai', '001'); INSERT INTO `animal` VALUES (2, 'dog', '/img/dog.jpg', 'mammalian', '1', '2021-03-05 23:47 ', 'Black Rice', '002'); INSERT INTO `animal` VALUES (7, 'gorilla12', '/img/7aac9840-f022-404e-979d-05a2bb089b8f.jpg', 'mammals', '1', \ '2021-03-06 22:45', 'Black Mimi 12', '003'); INSERT INTO `animal` VALUES (8, 'puppy111', '/img/19639f58-196a-4714-aa52-647bda41a758.jpg', 'mammals', '1', \ '2021-03-06 22:45', 'Wangcai 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 'Adoption record table id', `animal_id` int(11) NOT NULL COMMENT 'Adopted animal id', `user_id` int(11) NULL DEFAULT NULL COMMENT 'Adopter id', `createTime` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'Creation Date', `type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '1 Raising 2 Transferred 3 Transferring, pending review', PRIMARY KEY (`lyid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'Adoption record table' 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 'Transfer table primary key id', `aniaml_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'pet name', `animal_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'Pet type', `yzr` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'original owner', `yzr_phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'Original owner's phone number', `xzr` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'new owner', `xzr_phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'New owner phone', `zr_way` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'Transfer method', `createTime` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'Transfer Date', `animal_id` int(10) NULL DEFAULT NULL COMMENT 'pet id', `yzr_id` int(10) NULL DEFAULT NULL COMMENT 'original owner id', `xzr_id` int(10) NULL DEFAULT NULL COMMENT 'Current owner id', `time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'Creation date', `state` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '0 Failed to pass the review 1 Pending review by the transferred user 2 Pending review by the administrator 3 Passed the review', `ano` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'pet number', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'Transfer record table' ROW_FORMAT = Dynamic; ---------------------------- -- Records of animal_zr ---------------------------- INSERT INTO `animal_zr` VALUES (1, 'Puppies', 'Mammals', 'Li Qingzhao', '1234567890', 'Li Qingzhao', '1234567890', 'Express Mail', '2021-03-11', 1, 1, 21, '2021-03-07 21:47', '3', NULL); INSERT INTO `animal_zr` VALUES (2, 'dog', 'mammal', 'Li Qingzhao', '1234567890', 'Li Qingzhao', '1234567890', 'Express Mail', '2021-03-11', 2, 1, 21, '2021-03-08 21:02', '0', NULL); INSERT INTO `animal_zr` VALUES (3, 'dog', 'mammal', 'Li Qingzhao', '1234567890', 'Li Qingzhao', '1234567890', 'Express Mail', '2021-03-16', 2, 1, 21, '2021-03-16 16:58', '0', NULL); INSERT INTO `animal_zr` VALUES (4, 'Gorilla 12', 'Mammals', 'Li Qingzhao', '1234567890', 'Li Qingzhao', '1234567890', ' Offline transfer', '2021-03-16', 7, 1, 21, '2021-03-16 17:02', '0', NULL); INSERT INTO `animal_zr` VALUES (5, 'Gorilla 12', 'Mammals', 'Li Qingzhao', '1234567890', 'Li Qingzhao', '1234567890', ' Express mail', '2021-03-16', 7, 1, 21, '2021-03-16 17:06', '3', NULL); INSERT INTO `animal_zr` VALUES (6, 'Gouzi', 'Mammals', 'Li Qingzhao', '1234567890', 'Li Qingzhao', '1234567890', 'LINE Transfer down', '2021-03-16', 2, 1, 21, '2021-03-16 18:20', '3', NULL); INSERT INTO `animal_zr` VALUES (7, 'dog', 'mammal', 'Thunderbolt', '1234567890', 'Thunderbolt', '1234567890', 'Express Mail', '2021-03-17', 2, 21, 1, '2021-03-17 11:02', '3', '002'); INSERT INTO `animal_zr` VALUES (8, 'tiger', 'mammal', '李清智', '1234567890', '李清智', '1234567890', 'Express mail ', '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 'primary key id', `animal_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'animal name', `wyfs` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'feeding method', `animal_id` int(10) NULL DEFAULT NULL COMMENT 'animal table id', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'Feeding method table' ROW_FORMAT = Dynamic; ---------------------------- -- Records of feed ---------------------------- INSERT INTO `feed` VALUES (1, 'puppy', 'feedfeedfeed', 1); INSERT INTO `feed` VALUES (2, 'dog', 'dog food dog food dog food dog food dog food dog food dog food dog food', 2); INSERT INTO `feed` VALUES (3, 'puppy', NULL, 1); INSERT INTO `feed` VALUES (4, 'puppy', NULL, 1); INSERT INTO `feed` VALUES (7, 'rabbit', 'eating grass', 10); INSERT INTO `feed` VALUES (8, 'Tiger', 'Chiqingzhao', 9); INSERT INTO `feed` VALUES (9, 'Gorilla 12', 'Eat fruits and vegetables', 7); INSERT INTO `feed` VALUES (10, 'Puppy 111', 'Eat meat and bones', 8); ---------------------------- -- Table structure for hfjl ---------------------------- DROP TABLE IF EXISTS `hfjl`; CREATE TABLE `hfjl` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'primary key id', `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'animal name', `category` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'Animal Category', `director` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'master', `condation` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'animal condition', `hfz` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'Returning Visitor', `hfrq` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'Return visit date', `director_id` int(11) NULL DEFAULT NULL COMMENT 'master id', `animal_id` int(11) NULL DEFAULT NULL COMMENT 'animal_id', `imgUrl` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'Animal picture address', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'Return visit record table' ROW_FORMAT = Dynamic; ---------------------------- -- Records of hfjl ---------------------------- INSERT INTO `hfjl` VALUES (3, 'Gouzi', '1', 'Di Yuhui', 'Test', 'Di Yuhui', '2021-03- 11', 1, 2, '/img/dog.jpg'); INSERT INTO `hfjl` VALUES (4, 'Gouzi', 'Mammals', 'Di Yuhui1', '22222', 'Di Yuhui23232', '2021 -03-04', 1, 2, '/img/dog.jpg'); INSERT INTO `hfjl` VALUES (6, 'puppy', 'mammal', 'Di Yuhui1', 'very fat and good', 'Di Yuhui1', \ '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 'primary key id', `userName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'Account', `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'password', `realName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'nickname', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'Administrator table' ROW_FORMAT = Dynamic; ---------------------------- -- Records of user_admin ---------------------------- INSERT INTO `user_admin` VALUES (1, 'admin', '123456', 'admin2'); ---------------------------- -- 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 'primary key id', `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'Mailbox', `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'password', `realName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'real name', `sex` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'gender', `phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'phone', `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'address', `createTime` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'Creation Date', `state` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '0 means failed, 1 means passed, 2 means under review', `type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'Category, 1 represents an individual, 2 represents an organization', `userName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'username', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 31 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'Caring People/Adoptive Families' ROW_FORMAT = Dynamic; ---------------------------- -- Records of user_love_animal ---------------------------- INSERT INTO `user_love_animal` VALUES (1, '[email protected]', '123456', 'Li Qingzhao', 'Male', '1234567890', 'Xinjiekou' , '2021-02-26 22:36', '1', '1', 'lqz'); INSERT INTO `user_love_animal` VALUES (21, '[email protected]', '123456', 'PILI', 'Male', '1234567890', 'Building 102, Xinjiekou ', '2021-03-05 22:22', '1', '1', 'han'); INSERT INTO `user_love_animal` VALUES (28, '[email protected]', '123456', 'Zhang Linlin', 'Female', '1234567890', 'Xinjiekou 1212 ', '2021-03-10 22:39', '1', '1', 'zhanglinlin'); INSERT INTO `user_love_animal` VALUES (29, '[email protected]', '123456', 'Zhang San', 'Male', '13912345678', 'Taizhou City, Jiangsu Province Gulou Road, Taixing City', '2021-03-17 16:37', '2', '1', 'zhangsan'); INSERT INTO `user_love_animal` VALUES (30, '[email protected]', '123456', 'Xiao Ming', 'Male', '13912345678', 'Taixing, Taizhou City, Jiangsu Province Gulou Road, City', '2021-03-20 16:59', '2', '1', 'xiaoming'); SET FOREIGN_KEY_CHECKS = 1;
Project acquisition:
https://gitee.com/sinonfin/L-javaWebSha/tree/master