/*
Navicat Premium Data Transfer
Source Server : wanghuan
Source Server Type : MySQL
Source Server Version : 80012
Source Host : localhost:3306
Source Schema : db_forest_yh_lovepet
Target Server Type : MySQL
Target Server Version : 80012
File Encoding : 65001
Date: 05/01/2021 15:03:08
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for forest_customer
-- ----------------------------
DROP TABLE IF EXISTS `forest_customer`;
CREATE TABLE `forest_customer` (
`FOREST_Customer_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '客户编号',
`FOREST_Customer_Name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '客户姓名',
`FOREST_Customer_Sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '客户性别',
`FOREST_Customer_Card` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '客户身份证',
`FOREST_Customer_Phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '客户手机号',
`FOREST_Customer_Email` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '客户邮箱',
`FOREST_Customer_Home` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '客户住址',
`FOREST_Customer_Time` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '登记时间',
PRIMARY KEY (`FOREST_Customer_ID`) USING BTREE,
INDEX `FOREST_Customer_ID`(`FOREST_Customer_ID`) USING BTREE,
INDEX `FOREST_Customer_ID_2`(`FOREST_Customer_ID`) USING BTREE,
INDEX `FOREST_Customer_ID_3`(`FOREST_Customer_ID`) USING BTREE,
INDEX `FOREST_Customer_ID_4`(`FOREST_Customer_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of forest_customer
-- ----------------------------
INSERT INTO `forest_customer` VALUES (1, '王欢', '男', '411526195608014517', '15737626784', '508377132@qq.com', '河南省信阳市潢川县', '2020-12-29 11:05:31');
INSERT INTO `forest_customer` VALUES (2, '王欢', '男', '411529199901014517', '15736786628', '508377132@qq.com', '河南省新乡市', '2020-12-29 11:35:54');
INSERT INTO `forest_customer` VALUES (3, '豚豚', '女', '411526499987564156', '15838626593', '888888@qq.com', '河南省信阳市', '2020-12-29 13:42:54');
-- ----------------------------
-- Table structure for forest_customer_pets
-- ----------------------------
DROP TABLE IF EXISTS `forest_customer_pets`;
CREATE TABLE `forest_customer_pets` (
`FOREST_Customer_Pets_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '客宠编号',
`FOREST_Customer_ID` int(11) NULL DEFAULT NULL COMMENT '客户编号',
`FOREST_Pets_ID` int(11) NULL DEFAULT NULL COMMENT '宠物编号',
`FOREST_Customer_Pets_Time` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '登记时间',
PRIMARY KEY (`FOREST_Customer_Pets_ID`) USING BTREE,
INDEX `FOREST_Customer_Pets1`(`FOREST_Customer_ID`) USING BTREE,
INDEX `FOREST_Customer_Pets2`(`FOREST_Pets_ID`) USING BTREE,
CONSTRAINT `FOREST_Customer_Pets1` FOREIGN KEY (`FOREST_Customer_ID`) REFERENCES `forest_customer` (`forest_customer_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `FOREST_Customer_Pets2` FOREIGN KEY (`FOREST_Pets_ID`) REFERENCES `forest_pets` (`forest_pets_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of forest_customer_pets
-- ----------------------------
INSERT INTO `forest_customer_pets` VALUES (1, 1, 6, '2020-12-29 16:04:49');
INSERT INTO `forest_customer_pets` VALUES (2, 1, 2, '2020-12-29 16:05:49');
INSERT INTO `forest_customer_pets` VALUES (3, 1, 1, '2020-12-29 14:04:49');
INSERT INTO `forest_customer_pets` VALUES (4, 3, 7, '2021-01-04 17:21:58');
-- ----------------------------
-- Table structure for forest_diagnosis
-- ----------------------------
DROP TABLE IF EXISTS `forest_diagnosis`;
CREATE TABLE `forest_diagnosis` (
`FOREST_Diagnosis_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '诊断编号',
`FOREST_Diagnosis_Style` int(11) NULL DEFAULT NULL COMMENT '诊断类型\r\n1普通病例\r\n2重症病例\r\n3 无药可治',
`FOREST_Diagnosis_Detail` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '诊断详情',
`FOREST_Pets_ID` int(11) NULL DEFAULT NULL COMMENT '宠物编号',
`FOREST_VetDoctor_ID` int(11) NULL DEFAULT NULL COMMENT '兽医编号',
`FOREST_Diagnosis_Time` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '登记时间',
PRIMARY KEY (`FOREST_Diagnosis_ID`) USING BTREE,
INDEX `FOREST_Diagnosis1`(`FOREST_Pets_ID`) USING BTREE,
INDEX `FOREST_Diagnosis2`(`FOREST_VetDoctor_ID`) USING BTREE,
CONSTRAINT `FOREST_Diagnosis1` FOREIGN KEY (`FOREST_Pets_ID`) REFERENCES `forest_pets` (`forest_pets_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `FOREST_Diagnosis2` FOREIGN KEY (`FOREST_VetDoctor_ID`) REFERENCES `forest_vetdoctor` (`forest_vetdoctor_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of forest_diagnosis
-- ----------------------------
INSERT INTO `forest_diagnosis` VALUES (1, 1, '无药可治', 1, 1, '2020-12-30 11:01:16');
INSERT INTO `forest_diagnosis` VALUES (2, 1, ' 无病', 6, 1, '2020-12-30 15:44:09');
INSERT INTO `forest_diagnosis` VALUES (3, 2, '有病', 7, 1, '2021-01-04 17:24:14');
-- ----------------------------
-- Table structure for forest_historyrecord
-- ----------------------------
DROP TABLE IF EXISTS `forest_historyrecord`;
CREATE TABLE `forest_historyrecord` (
`FOREST_HistoryRecord_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '历史记录编号',
`FOREST_User_ID` int(11) NULL DEFAULT NULL COMMENT '用户编号',
`FOREST_Pets_ID` int(11) NULL DEFAULT NULL COMMENT '宠物编号',
`FOREST_User_Pets_Time` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '登记时间',
PRIMARY KEY (`FOREST_HistoryRecord_ID`) USING BTREE,
INDEX `FOREST_HistoryRecord1`(`FOREST_User_ID`) USING BTREE,
INDEX `FOREST_HistoryRecord2`(`FOREST_Pets_ID`) USING BTREE,
CONSTRAINT `FOREST_HistoryRecord1` FOREIGN KEY (`FOREST_User_ID`) REFERENCES `forest_user` (`forest_user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `FOREST_HistoryRecord2` FOREIGN KEY (`FOREST_Pets_ID`) REFERENCES `forest_pets` (`forest_pets_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 93 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of forest_historyrecord
-- ----------------------------
INSERT INTO `forest_historyrecord` VALUES (1, 1, 1, '2020-12-30 09:16:59');
INSERT INTO `forest_historyrecord` VALUES (2, 2, 2, '2020-12-30 10:02:33');
INSERT INTO `forest_historyrecord` VALUES (3, 2, 2, '2020-12-30 10:03:33');
INSERT INTO `forest_historyrecord` VALUES (4, 2, 2, '2020-12-30 10:12:13');
INSERT INTO `forest_historyrecord` VALUES (5, 2, 2, '2020-12-30 10:41:14');
INSERT INTO `forest_historyrecord` VALUES (6, 2, 2, '2020-12-30 16:54:01');
INSERT INTO `forest_historyrecord` VALUES (7, 2, 1, '2020-12-30 16:54:05');
INSERT INTO `forest_historyrecord` VALUES (8, 2, 6, '2020-12-30 16:54:07');
INSERT INTO `forest_historyrecord` VALUES (9, 2, 1, '2020-12-30 16:54:15');
INSERT INTO `forest_historyrecord` VALUES (10, 2, 1, '2020-12-30 17:33:52');
INSERT INTO `forest_historyrecord` VALUES (11, 2, 6, '2020-12-30 17:33:54');
INSERT INTO `forest_historyrecord` VALUES (12, 2, 2, '2020-12-30 17:33:57');
INSERT INTO `for
没有合适的资源?快使用搜索试试~ 我知道了~
Java项目:宠物医院管理系统设计和实现(java+Springboot+ssm+mysql+jsp+maven)
共1008个文件
js:314个
jpg:212个
xml:126个
1.该资源内容由用户上传,如若侵权请联系客服进行举报
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
版权申诉
5星 · 超过95%的资源 3 下载量 157 浏览量
2022-03-15
08:38:58
上传
评论 4
收藏 17.53MB RAR 举报
温馨提示
一、项目简述 功能描叙: 医生信息,客户信息,宠物管理,浏览管理,诊断管理, 医生管理,用户管理等等模块。 二、项目运行 环境配置: Jdk1.8 + Tomcat8.5 + mysql + Eclispe (IntelliJ IDEA,Eclispe,MyEclispe,Sts 都支持) 项目技术: JSP +Springboot+ SpringMVC + MyBatis + ThymeLeaf + HTML+ JavaScript + JQuery + Ajax + maven等等
资源推荐
资源详情
资源评论
收起资源包目录
Java项目:宠物医院管理系统设计和实现(java+Springboot+ssm+mysql+jsp+maven) (1008个子文件)
Forest_VetDoctorController.class 8KB
Forest_userCongtroller.class 7KB
Forest_userEntity.class 7KB
Forest_PetsController.class 7KB
Forest_VetDoctorEntity.class 7KB
Forest_CustomerController.class 7KB
Forest_DiagnosisEntity.class 6KB
Forest_DiagnosisController.class 6KB
Forest_PetsEntity.class 6KB
Forest_CustomerEntity.class 6KB
ZhiFuMX.class 5KB
zhifu.class 5KB
Forest_HistoryRecordEntity.class 5KB
Forest_HistoryRecordController.class 4KB
Forest_MailService.class 4KB
Forest_Customer_PetsEntity.class 4KB
Forest_fileUploadController.class 4KB
Forest_MailEntity.class 4KB
Forest_dataTreatingUtils.class 3KB
WebMvcConfig.class 3KB
Forest_VetDoctorService.class 3KB
Forest_variable.class 3KB
Forest_MailController.class 2KB
Forest_userService.class 2KB
Forest_PetsService.class 2KB
Forest_DiagnosisService.class 2KB
Forest_CustomerService.class 2KB
Forest_Customer_PetsService.class 2KB
Forest_HistoryRecordService.class 2KB
Forest_tuiChuController.class 1KB
Forest_VetDoctorMapper.class 1KB
Forest_userMapper.class 961B
Forest_Customer_PetsMapper.class 957B
Forest_DiagnosisMapper.class 948B
Forest_CustomerMapper.class 934B
Forest_PetsMapper.class 921B
Forest_HistoryRecordMapper.class 799B
ForestLovePetsApplication.class 761B
variableImpl.class 599B
ForestLovePetsApplicationTests.class 559B
MyWebConfig.class 461B
Forest_global.class 318B
.classpath 1KB
mvnw.cmd 6KB
app.min1.css 271KB
app.min1.css 271KB
icons.min.css 264KB
icons.min.css 264KB
bootstrap.min.css 159KB
bootstrap.min.css 159KB
bootstrap.min.css 107KB
bootstrap.min.css 107KB
app.min.css 67KB
app.min.css 67KB
icons.min1.css 64KB
icons.min1.css 64KB
custombox.min.css 41KB
custombox.min.css 41KB
camera.css 27KB
camera.css 27KB
sweetalert2.min.css 26KB
sweetalert2.min.css 26KB
sweetalert2.min.css 24KB
sweetalert2.min.css 24KB
sweetalert.css 22KB
sweetalert.css 22KB
style.css 21KB
style.css 21KB
summernote-bs4.css 18KB
summernote-bs4.css 18KB
font-awesome.min.css 18KB
font-awesome.min.css 18KB
summernote-bs4.css 17KB
summernote-bs4.css 17KB
fullcalendar.min.css 16KB
fullcalendar.min.css 16KB
fullcalendar.min.css 16KB
fullcalendar.min.css 16KB
bootstrap-datepicker.min.css 15KB
bootstrap-datepicker.min.css 15KB
select2.min.css 15KB
select2.min.css 15KB
ion.rangeSlider.css 13KB
ion.rangeSlider.css 13KB
chartist.min.css 11KB
chartist.min.css 11KB
simplemde.min.css 11KB
simplemde.min.css 11KB
bootstrap-select.min.css 10KB
bootstrap-select.min.css 10KB
sweetalert-old.css 10KB
sweetalert-old.css 10KB
dropzone.min.css 9KB
dropzone.min.css 9KB
bootstrap-colorpicker.min.css 9KB
bootstrap-colorpicker.min.css 9KB
daterangepicker.css 7KB
daterangepicker.css 7KB
dataTables.bootstrap4.css 6KB
dataTables.bootstrap4.css 6KB
共 1008 条
- 1
- 2
- 3
- 4
- 5
- 6
- 11
资源评论
- এ᭄ꦿ꯭梦魇꧔ꦿ2022-11-07资源内容详尽,对我有使用价值,谢谢资源主的分享。
- qq_678659452022-08-15资源内容详细全面,与描述一致,对我很有用,有一定的使用价值。
- Zzpz12023-02-21资源太好了,解决了我当下遇到的难题,抱紧大佬的大腿~
OldWinePot
- 粉丝: 8916
- 资源: 418
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功