基于ssm的视力保养连锁预约系统设计与实现-计算机毕业设计源码+LW文档 - 码农知识堂

基于ssm的视力保养连锁预约系统设计与实现-计算机毕业设计源码+LW文档

开发语言：Java
框架：ssm
JDK版本：JDK1.8
服务器：tomcat7
数据库：mysql 5.7（一定要5.7版本）
数据库工具：Navicat11
开发软件：eclipse/myeclipse/idea
Maven包：Maven3.3.9
浏览器：谷歌浏览器

数据库脚本：

DROP TABLE IF EXISTS `address`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `address` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`address` varchar(200) NOT NULL COMMENT '地址',
`name` varchar(200) NOT NULL COMMENT '收货人',
`phone` varchar(200) NOT NULL COMMENT '电话',
`isdefault` varchar(200) NOT NULL COMMENT '是否默认地址[是/否]',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='地址';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `address`
--

LOCK TABLES `address` WRITE;
/*!40000 ALTER TABLE `address` DISABLE KEYS */;
INSERT INTO `address` VALUES (1,'2022-04-12 07:54:21',11,'宇宙银河系金星1号','金某','13823888881','是'),(2,'2022-04-12 07:54:21',12,'宇宙银河系木星1号','木某','13823888882','是'),(3,'2022-04-12 07:54:21',13,'宇宙银河系水星1号','水某','13823888883','是'),(4,'2022-04-12 07:54:21',14,'宇宙银河系火星1号','火某','13823888884','是'),(5,'2022-04-12 07:54:21',15,'宇宙银河系土星1号','土某','13823888885','是'),(6,'2022-04-12 07:54:21',16,'宇宙银河系月球1号','月某','13823888886','是');
/*!40000 ALTER TABLE `address` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cart`
--

DROP TABLE IF EXISTS `cart`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cart` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`tablename` varchar(200) DEFAULT 'shangpinxinxi' COMMENT '商品表名',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`goodid` bigint(20) NOT NULL COMMENT '商品id',
`goodname` varchar(200) DEFAULT NULL COMMENT '商品名称',
`picture` varchar(200) DEFAULT NULL COMMENT '图片',
`buynumber` int(11) NOT NULL COMMENT '购买数量',
`price` float DEFAULT NULL COMMENT '单价',
`discountprice` float DEFAULT NULL COMMENT '会员价',
`mendianzhanghao` varchar(200) DEFAULT NULL COMMENT '商户名称',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='购物车表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cart`
--

LOCK TABLES `cart` WRITE;
/*!40000 ALTER TABLE `cart` DISABLE KEYS */;
/*!40000 ALTER TABLE `cart` 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/picture3.jpg');
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `discussfuwuxiangmu`
--

DROP TABLE IF EXISTS `discussfuwuxiangmu`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discussfuwuxiangmu` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`refid` bigint(20) NOT NULL COMMENT '关联表id',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`nickname` varchar(200) DEFAULT NULL COMMENT '用户名',
`content` longtext NOT NULL COMMENT '评论内容',
`reply` longtext COMMENT '回复内容',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=137 DEFAULT CHARSET=utf8 COMMENT='服务项目评论表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `discussfuwuxiangmu`
--

LOCK TABLES `discussfuwuxiangmu` WRITE;
/*!40000 ALTER TABLE `discussfuwuxiangmu` DISABLE KEYS */;
INSERT INTO `discussfuwuxiangmu` VALUES (131,'2022-04-12 07:54:21',1,1,'用户名1','评论内容1','回复内容1'),(132,'2022-04-12 07:54:21',2,2,'用户名2','评论内容2','回复内容2'),(133,'2022-04-12 07:54:21',3,3,'用户名3','评论内容3','回复内容3'),(134,'2022-04-12 07:54:21',4,4,'用户名4','评论内容4','回复内容4'),(135,'2022-04-12 07:54:22',5,5,'用户名5','评论内容5','回复内容5'),(136,'2022-04-12 07:54:22',6,6,'用户名6','评论内容6','回复内容6');
/*!40000 ALTER TABLE `discussfuwuxiangmu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `discussshangpinxinxi`
--

DROP TABLE IF EXISTS `discussshangpinxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discussshangpinxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`refid` bigint(20) NOT NULL COMMENT '关联表id',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`nickname` varchar(200) DEFAULT NULL COMMENT '用户名',
`content` longtext NOT NULL COMMENT '评论内容',
`reply` longtext COMMENT '回复内容',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=147 DEFAULT CHARSET=utf8 COMMENT='商品信息评论表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `discussshangpinxinxi`
--

LOCK TABLES `discussshangpinxinxi` WRITE;
/*!40000 ALTER TABLE `discussshangpinxinxi` DISABLE KEYS */;
INSERT INTO `discussshangpinxinxi` VALUES (141,'2022-04-12 07:54:22',1,1,'用户名1','评论内容1','回复内容1'),(142,'2022-04-12 07:54:22',2,2,'用户名2','评论内容2','回复内容2'),(143,'2022-04-12 07:54:22',3,3,'用户名3','评论内容3','回复内容3'),(144,'2022-04-12 07:54:22',4,4,'用户名4','评论内容4','回复内容4'),(145,'2022-04-12 07:54:22',5,5,'用户名5','评论内容5','回复内容5'),(146,'2022-04-12 07:54:22',6,6,'用户名6','评论内容6','回复内容6');
/*!40000 ALTER TABLE `discussshangpinxinxi` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `fuwuxiangmu`
--

DROP TABLE IF EXISTS `fuwuxiangmu`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fuwuxiangmu` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`xiangmubianhao` varchar(200) DEFAULT NULL COMMENT '项目编号',
`xiangmumingcheng` varchar(200) DEFAULT NULL COMMENT '项目名称',
`xiangmuleixing` varchar(200) DEFAULT NULL COMMENT '项目类型',
`jiage` float DEFAULT NULL COMMENT '价格',
`fengmian` varchar(200) DEFAULT NULL COMMENT '封面',
`xiangxijieshao` longtext COMMENT '详细介绍',
`mendianzhanghao` varchar(200) DEFAULT NULL COMMENT '门店账号',
`mendianmingcheng` varchar(200) DEFAULT NULL COMMENT '门店名称',
`thumbsupnum` int(11) DEFAULT '0' COMMENT '赞',
`crazilynum` int(11) DEFAULT '0' COMMENT '踩',
`clicktime` datetime DEFAULT NULL COMMENT '最近点击时间',
`clicknum` int(11) DEFAULT '0' COMMENT '点击次数',
PRIMARY KEY (`id`),
UNIQUE KEY `xiangmubianhao` (`xiangmubianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT='服务项目';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `fuwuxiangmu`
--

LOCK TABLES `fuwuxiangmu` WRITE;
/*!40000 ALTER TABLE `fuwuxiangmu` DISABLE KEYS */;
INSERT INTO `fuwuxiangmu` VALUES (41,'2022-04-12 07:54:21','1111111111','项目名称1','项目类型1',1,'upload/fuwuxiangmu_fengmian1.jpg','详细介绍1','门店账号1','门店名称1',1,1,'2022-04-12 15:54:21',1),(42,'2022-04-12 07:54:21','2222222222','项目名称2','项目类型2',2,'upload/fuwuxiangmu_fengmian2.jpg','详细介绍2','门店账号2','门店名称2',2,2,'2022-04-12 15:54:21',2),(43,'2022-04-12 07:54:21','3333333333','项目名称3','项目类型3',3,'upload/fuwuxiangmu_fengmian3.jpg','详细介绍3','门店账号3','门店名称3',3,3,'2022-04-12 15:54:21',3),(44,'2022-04-12 07:54:21','4444444444','项目名称4','项目类型4',4,'upload/fuwuxiangmu_fengmian4.jpg','详细介绍4','门店账号4','门店名称4',4,4,'2022-04-12 15:54:21',4),(45,'2022-04-12 07:54:21','5555555555','项目名称5','项目类型5',5,'upload/fuwuxiangmu_fengmian5.jpg','详细介绍5','门店账号5','门店名称5',5,5,'2022-04-12 15:54:21',5),(46,'2022-04-12 07:54:21','6666666666','项目名称6','项目类型6',6,'upload/fuwuxiangmu_fengmian6.jpg','详细介绍6','门店账号6','门店名称6',6,6,'2022-04-12 15:54:21',6);
/*!40000 ALTER TABLE `fuwuxiangmu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mendian`
--

DROP TABLE IF EXISTS `mendian`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mendian` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`mendianzhanghao` varchar(200) NOT NULL COMMENT '门店账号',
`mima` varchar(200) NOT NULL COMMENT '密码',
`mendianmingcheng` varchar(200) NOT NULL COMMENT '门店名称',
`fuzeren` varchar(200) DEFAULT NULL COMMENT '负责人',
`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
`dianputupian` varchar(200) DEFAULT NULL COMMENT '店铺图片',
`dianpudizhi` varchar(200) DEFAULT NULL COMMENT '店铺地址',
`money` float DEFAULT '0' COMMENT '余额',
PRIMARY KEY (`id`),
UNIQUE KEY `mendianzhanghao` (`mendianzhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COMMENT='门店';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mendian`
--

LOCK TABLES `mendian` WRITE;
/*!40000 ALTER TABLE `mendian` DISABLE KEYS */;
INSERT INTO `mendian` VALUES (21,'2022-04-12 07:54:21','门店账号1','123456','门店名称1','负责人1','13823888881','upload/mendian_dianputupian1.jpg','店铺地址1',100),(22,'2022-04-12 07:54:21','门店账号2','123456','门店名称2','负责人2','13823888882','upload/mendian_dianputupian2.jpg','店铺地址2',100),(23,'2022-04-12 07:54:21','门店账号3','123456','门店名称3','负责人3','13823888883','upload/mendian_dianputupian3.jpg','店铺地址3',100),(24,'2022-04-12 07:54:21','门店账号4','123456','门店名称4','负责人4','13823888884','upload/mendian_dianputupian4.jpg','店铺地址4',100),(25,'2022-04-12 07:54:21','门店账号5','123456','门店名称5','负责人5','13823888885','upload/mendian_dianputupian5.jpg','店铺地址5',100),(26,'2022-04-12 07:54:21','门店账号6','123456','门店名称6','负责人6','13823888886','upload/mendian_dianputupian6.jpg','店铺地址6',100);
/*!40000 ALTER TABLE `mendian` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `orders`
--

DROP TABLE IF EXISTS `orders`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `orders` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`orderid` varchar(200) NOT NULL COMMENT '订单编号',
`tablename` varchar(200) DEFAULT 'shangpinxinxi' COMMENT '商品表名',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`goodid` bigint(20) NOT NULL COMMENT '商品id',
`goodname` varchar(200) DEFAULT NULL COMMENT '商品名称',
`picture` varchar(200) DEFAULT NULL COMMENT '商品图片',
`buynumber` int(11) NOT NULL COMMENT '购买数量',
`price` float NOT NULL DEFAULT '0' COMMENT '价格/积分',
`discountprice` float DEFAULT '0' COMMENT '折扣价格',
`total` float NOT NULL DEFAULT '0' COMMENT '总价格/总积分',
`discounttotal` float DEFAULT '0' COMMENT '折扣总价格',
`type` int(11) DEFAULT '1' COMMENT '支付类型',
`status` varchar(200) DEFAULT NULL COMMENT '状态',
`address` varchar(200) DEFAULT NULL COMMENT '地址',
`tel` varchar(200) DEFAULT NULL COMMENT '电话',
`consignee` varchar(200) DEFAULT NULL COMMENT '收货人',
`logistics` longtext COMMENT '物流',
`mendianzhanghao` varchar(200) DEFAULT NULL COMMENT '商户名称',
PRIMARY KEY (`id`),
UNIQUE KEY `orderid` (`orderid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `orders`
--

LOCK TABLES `orders` WRITE;
/*!40000 ALTER TABLE `orders` DISABLE KEYS */;
/*!40000 ALTER TABLE `orders` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `shangpinfenlei`
--

DROP TABLE IF EXISTS `shangpinfenlei`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shangpinfenlei` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`shangpinfenlei` varchar(200) DEFAULT NULL COMMENT '商品分类',
PRIMARY KEY (`id`),
UNIQUE KEY `shangpinfenlei` (`shangpinfenlei`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COMMENT='商品分类';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `shangpinfenlei`
--

LOCK TABLES `shangpinfenlei` WRITE;
/*!40000 ALTER TABLE `shangpinfenlei` DISABLE KEYS */;
INSERT INTO `shangpinfenlei` VALUES (61,'2022-04-12 07:54:21','商品分类1'),(62,'2022-04-12 07:54:21','商品分类2'),(63,'2022-04-12 07:54:21','商品分类3'),(64,'2022-04-12 07:54:21','商品分类4'),(65,'2022-04-12 07:54:21','商品分类5'),(66,'2022-04-12 07:54:21','商品分类6');
/*!40000 ALTER TABLE `shangpinfenlei` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `shangpinxinxi`
--

DROP TABLE IF EXISTS `shangpinxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shangpinxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`shangpinbianhao` varchar(200) DEFAULT NULL COMMENT '商品编号',
`shangpinmingcheng` varchar(200) DEFAULT NULL COMMENT '商品名称',
`shangpinfenlei` varchar(200) DEFAULT NULL COMMENT '商品分类',
`pinpai` varchar(200) DEFAULT NULL COMMENT '品牌',
`guige` varchar(200) DEFAULT NULL COMMENT '规格',
`tupian` varchar(200) DEFAULT NULL COMMENT '图片',
`shangjiariqi` date DEFAULT NULL COMMENT '上架日期',
`shangpinjieshao` longtext COMMENT '商品介绍',
`mendianzhanghao` varchar(200) DEFAULT NULL COMMENT '门店账号',
`mendianmingcheng` varchar(200) DEFAULT NULL COMMENT '门店名称',
`thumbsupnum` int(11) DEFAULT '0' COMMENT '赞',
`crazilynum` int(11) DEFAULT '0' COMMENT '踩',
`clicktime` datetime DEFAULT NULL COMMENT '最近点击时间',
`clicknum` int(11) DEFAULT '0' COMMENT '点击次数',
`price` float DEFAULT NULL COMMENT '价格',
`onelimittimes` int(11) DEFAULT '-1' COMMENT '单限',
`alllimittimes` int(11) DEFAULT '-1' COMMENT '库存',
PRIMARY KEY (`id`),
UNIQUE KEY `shangpinbianhao` (`shangpinbianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8 COMMENT='商品信息';
/*!40101 SET character_set_client = @saved_cs_client */;
相关阅读:
YOLO V7源码解析
 pytorch 笔记：validation ，model.eval V.S torch.no_grad
奶粉市场陷入尴尬局面，飞鹤何去何从？
记录一个cpu彪高的BUG处理--jvm调优
 25.STM32光传感器
 Cookie与Session的区别
 【HTML期末学生大作业】制作一个简单HTML宠物网页（HTML+CSS）
FPGA-VGA成像原理与时序
 SpringMvc内置的九大组件
 C++ 取近似值
原文地址：https://blog.csdn.net/qq_375279829/article/details/126943421