开发语言: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','关于我们','农村现代化药店药物管理系统','
不管你想要怎样的生活,你都要去努力争取,不多尝试一些事情怎么知道自己适合什么、不适合什么呢? 你说你喜欢读书,让我给你列书单,你还问我哪里有那么多时间看书;你说自己梦想的职业是广告文案,问我如何成为一个文案,应该具备哪些素质;你说你计划晨跑,但总是因为学习、工作辛苦或者身体不舒服第二天起不了床;你说你一直梦想一个人去长途旅行,但是没钱,父母觉得危险。其实,我已经厌倦了你这样说说而已的把戏,我觉得就算我告诉你如何去做,你也不会照做,因为你根本什么都不做。
','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 */;