开发语言：Java
框架：springboot
JDK版本：JDK1.8
服务器：tomcat7
数据库：mysql 5.7（一定要5.7版本）
数据库工具：Navicat11
开发软件：eclipse/myeclipse/idea
Maven包：Maven3.3.9
浏览器：谷歌浏览器
数据库：
DROP TABLE IF EXISTS `aboutus`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `aboutus` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`title` varchar(200) NOT NULL COMMENT '标题',
`subtitle` varchar(200) DEFAULT NULL COMMENT '副标题',
`content` longtext NOT NULL COMMENT '内容',
`picture1` longtext COMMENT '图片1',
`picture2` longtext COMMENT '图片2',
`picture3` longtext COMMENT '图片3',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='关于我们';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `aboutus`
--
LOCK TABLES `aboutus` WRITE;
/*!40000 ALTER TABLE `aboutus` DISABLE KEYS */;
INSERT INTO `aboutus` VALUES (1,'2023-03-17 13:42:11','关于我们','农村现代化药店药物管理系统','<p>不管你想要怎样的生活，你都要去努力争取，不多尝试一些事情怎么知道自己适合什么、不适合什么呢? 你说你喜欢读书，让我给你列书单，你还问我哪里有那么多时间看书;你说自己梦想的职业是广告文案，问我如何成为一个文案，应该具备哪些素质;你说你计划晨跑，但总是因为学习、工作辛苦或者身体不舒服第二天起不了床;你说你一直梦想一个人去长途旅行，但是没钱，父母觉得危险。其实，我已经厌倦了你这样说说而已的把戏，我觉得就算我告诉你如何去做，你也不会照做，因为你根本什么都不做。</p>','upload/aboutus_picture1.jpg','upload/aboutus_picture2.jpg','upload/aboutus_picture3.jpg');
/*!40000 ALTER TABLE `aboutus` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `caigoushenqing`
--
DROP TABLE IF EXISTS `caigoushenqing`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `caigoushenqing` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`dingdanbianhao` varchar(200) DEFAULT NULL COMMENT '订单编号',
`yaopinbianhao` varchar(200) DEFAULT NULL COMMENT '药品编号',
`yaopinmingcheng` varchar(200) DEFAULT NULL COMMENT '药品名称',
`yaopinleibie` varchar(200) DEFAULT NULL COMMENT '药品类别',
`guige` varchar(200) DEFAULT NULL COMMENT '规格',
`danwei` varchar(200) DEFAULT NULL COMMENT '单位',
`chandi` varchar(200) DEFAULT NULL COMMENT '产地',
`yaopinshuliang` int(11) DEFAULT NULL COMMENT '药品数量',
`yaopinshoujia` float DEFAULT NULL COMMENT '药品售价',
`jibingmingcheng` varchar(200) DEFAULT NULL COMMENT '疾病名称',
`yonghuming` varchar(200) DEFAULT NULL COMMENT '用户名',
`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
`caigoushijian` datetime DEFAULT NULL COMMENT '采购时间',
`sfsh` varchar(200) DEFAULT '待审核' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
PRIMARY KEY (`id`),
UNIQUE KEY `dingdanbianhao` (`dingdanbianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=1679060978573 DEFAULT CHARSET=utf8 COMMENT='采购申请';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `caigoushenqing`
--
LOCK TABLES `caigoushenqing` WRITE;
/*!40000 ALTER TABLE `caigoushenqing` DISABLE KEYS */;
INSERT INTO `caigoushenqing` VALUES (61,'2023-03-17 13:42:11','1111111111','药品编号1','药品名称1','药品类别1','规格1','单位1','产地1',1,1,'疾病名称1','用户名1','姓名1','联系电话1','2023-03-17 21:42:11','是',''),(62,'2023-03-17 13:42:11','2222222222','药品编号2','药品名称2','药品类别2','规格2','单位2','产地2',2,2,'疾病名称2','用户名2','姓名2','联系电话2','2023-03-17 21:42:11','是',''),(63,'2023-03-17 13:42:11','3333333333','药品编号3','药品名称3','药品类别3','规格3','单位3','产地3',3,3,'疾病名称3','用户名3','姓名3','联系电话3','2023-03-17 21:42:11','是',''),(64,'2023-03-17 13:42:11','4444444444','药品编号4','药品名称4','药品类别4','规格4','单位4','产地4',4,4,'疾病名称4','用户名4','姓名4','联系电话4','2023-03-17 21:42:11','是',''),(65,'2023-03-17 13:42:11','5555555555','药品编号5','药品名称5','药品类别5','规格5','单位5','产地5',5,5,'疾病名称5','用户名5','姓名5','联系电话5','2023-03-17 21:42:11','是',''),(66,'2023-03-17 13:42:11','6666666666','药品编号6','药品名称6','药品类别6','规格6','单位6','产地6',6,6,'疾病名称6','用户名6','姓名6','联系电话6','2023-03-17 21:42:11','是',''),(67,'2023-03-17 13:42:11','7777777777','药品编号7','药品名称7','药品类别7','规格7','单位7','产地7',7,7,'疾病名称7','用户名7','姓名7','联系电话7','2023-03-17 21:42:11','是',''),(68,'2023-03-17 13:42:11','8888888888','药品编号8','药品名称8','药品类别8','规格8','单位8','产地8',8,8,'疾病名称8','用户名8','姓名8','联系电话8','2023-03-17 21:42:11','是',''),(1679060978572,'2023-03-17 13:49:38','1679060965328','1679060806590','感冒灵','内服','10包','g','广州',5,25,'感冒','222','李云','13612512512','2023-03-17 21:49:25','是','同意');
/*!40000 ALTER TABLE `caigoushenqing` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `config`
--
DROP TABLE IF EXISTS `config`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `config` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`name` varchar(100) NOT NULL COMMENT '配置参数名称',
`value` varchar(100) DEFAULT NULL COMMENT '配置参数值',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='配置文件';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `config`
--
LOCK TABLES `config` WRITE;
/*!40000 ALTER TABLE `config` DISABLE KEYS */;
INSERT INTO `config` VALUES (1,'picture1','upload/picture1.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/1679060896785.jpg');
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `gongyingshang`
--
DROP TABLE IF EXISTS `gongyingshang`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gongyingshang` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`gongyingshangmingcheng` varchar(200) NOT NULL COMMENT '供应商名称',
`dizhi` varchar(200) DEFAULT NULL COMMENT '地址',
`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
`fuzerenxingming` varchar(200) NOT NULL COMMENT '负责人姓名',
`zhiwu` varchar(200) DEFAULT NULL COMMENT '职务',
`zhuxiaochanpin` varchar(200) DEFAULT NULL COMMENT '主销产品',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1679060875791 DEFAULT CHARSET=utf8 COMMENT='供应商';
/*!40101 SET character_set_client = @saved_cs_client */;
如需定做或者获取更多资料，请联系QQ：375279829
客服QQ