162基于springboot宠物管理系统

项目描述

springboot宠物管理系统
本系统共分为三个角色：系统管理员、医生、用户
框架：springboot、mybatis、jsp
数据库：mysql 5.7（注意版本不能为8）
功能模块：系统管理-用户管理、页面管理、角色管理
宠物管理-宠物列表、宠物健康史
预约管理-预约时间、医生时间
日常健康-健康指南、健康监测、健康标准
宠物档案
医院管理

导入数据库

在mysql数据库中创建数据库并执行phms.sql文件，执行成功后，在项目application.properties中修改数据库相关配置文件，包括数据库名称、用户名、密码等；

项目运行

此为springboot项目，无需将项目添加到tomcat中,直接在main方法中右键运行。运行成功后，在浏览器中访问http://localhost:8086/ 注：8086端口为在application.properties中配置，可自行修改；

登录

管理员
账号：admin 密码：123456
医生：
账号：医生1 密码：123456
普通用户：
账号：1 密码：123456

运行环境

tomcat7.0+jdk1.7或以上

eclipse或idea

项目技术

springboot、mybatis、jsp

效果界面：







数据库设计：
/*
Navicat Premium Data Transfer

Source Server : 139.155.39.185
Source Server Type : MySQL
Source Server Version : 50729
Source Host : 139.155.39.185:3306
Source Schema : phms

Target Server Type : MySQL
Target Server Version : 50729
File Encoding : 65001

Date: 15/07/2020 15:46:00
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

---

– Table structure for appointment

---

DROP TABLE IF EXISTS appointment;
CREATE TABLE appointment (
id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
pet_id bigint(20) DEFAULT NULL,
user_id bigint(20) DEFAULT NULL,
doctor_id bigint(20) DEFAULT NULL,
app_time datetime(0) DEFAULT NULL,
info varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
create_time datetime(0) DEFAULT NULL,
status int(5) DEFAULT NULL,
phone varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
address varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 39 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

---

– Records of appointment

---

INSERT INTO appointment VALUES (1, 1, 1, 1, ‘2020-04-23 20:33:08’, ‘555’, ‘2020-04-23 20:33:11’, 4, NULL, NULL);
INSERT INTO appointment VALUES (2, 1, 1, 1, ‘2020-04-25 00:00:00’, ‘hhh’, ‘2020-04-25 20:20:25’, 4, ‘1776222’, ‘555’);
INSERT INTO appointment VALUES (3, 2, 1, 5, ‘2020-04-25 21:23:56’, ‘6666’, ‘2020-04-25 21:23:59’, 4, ‘17788885555’, ‘5555’);
INSERT INTO appointment VALUES (4, 3, 6, 5, ‘2020-04-03 00:00:00’, ‘555’, ‘2020-04-25 22:51:43’, 2, ‘17768583634’, ‘8888’);
INSERT INTO appointment VALUES (6, 3, 6, 9, ‘2020-04-25 00:00:00’, ‘11’, ‘2020-04-25 22:58:15’, 4, ‘18899998888’, ‘1111’);
INSERT INTO appointment VALUES (7, 3, 6, 9, ‘2020-04-25 00:00:00’, ‘111’, ‘2020-04-25 23:03:26’, 4, ‘11’, ‘11’);
INSERT INTO appointment VALUES (10, 6, 13, 5, ‘2020-04-28 00:00:00’, ‘就医’, ‘2020-04-26 08:17:33’, 4, ‘18860887816’, ‘江苏宜兴’);
INSERT INTO appointment VALUES (11, 6, 13, 5, ‘2020-04-26 08:30:40’, ‘宠物异常’, ‘2020-04-26 08:30:43’, 2, ‘18860887816’, ‘江苏宜兴’);
INSERT INTO appointment VALUES (12, 7, 13, 5, ‘2020-04-26 08:40:30’, ‘就医’, ‘2020-04-26 08:40:33’, 2, ‘18860887816’, ‘东北’);
INSERT INTO appointment VALUES (13, 5, 11, 5, ‘2020-04-26 08:50:38’, ‘发烧’, ‘2020-04-26 08:50:40’, 4, ‘18860777777’, ‘天津’);
INSERT INTO appointment VALUES (14, 8, 17, 5, ‘2020-04-26 14:05:52’, ‘热热热’, ‘2020-04-26 14:05:57’, 4, ‘18860887816’, ‘江苏宜兴’);
INSERT INTO appointment VALUES (15, 9, 18, 5, ‘2020-04-26 16:46:36’, ‘发烧’, ‘2020-04-26 16:46:39’, 2, ‘18860887711’, ‘江苏’);
INSERT INTO appointment VALUES (17, 11, 18, 26, ‘2020-04-26 17:20:55’, ‘人人’, ‘2020-04-26 17:20:58’, 3, ‘18860887816’, ‘人人’);
INSERT INTO appointment VALUES (18, 12, 20, 21, ‘2020-04-26 17:34:04’, ‘qq’, ‘2020-04-26 17:34:06’, 4, ‘18860887816’, ‘江苏宜兴’);
INSERT INTO appointment VALUES (19, 12, 20, 26, ‘2020-04-26 17:34:04’, ‘qq’, ‘2020-04-26 17:34:07’, 3, ‘18860887816’, ‘江苏宜兴’);
INSERT INTO appointment VALUES (20, 14, 23, 21, ‘2020-04-26 19:12:33’, ‘发烧’, ‘2020-04-26 19:12:36’, 4, ‘18860887711’, ‘江苏’);
INSERT INTO appointment VALUES (21, 16, 24, 21, ‘2020-04-26 19:42:43’, ‘发烧’, ‘2020-04-26 19:42:46’, 4, ‘18860887711’, ‘江苏’);
INSERT INTO appointment VALUES (22, 17, 24, 26, ‘2020-04-26 21:35:13’, ‘66666’, ‘2020-04-26 21:35:16’, 3, ‘188