首页分享基于微信小程序的鲜花销售商城系统+后台管理系统(SSM+mysql)

基于微信小程序的鲜花销售商城系统+后台管理系统(SSM+mysql)

来源：花匠小妙招时间：2024-11-14 13:32

功能介绍

管理员：首页，个人中心，用户管理，鲜花分类管理，鲜花信息管理，系统管理，订单管理等

普通用户：首页，公告信息，地图，购物车，我的等

数据库脚本

-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64) -- -- Host: localhost Database: ssmge25c -- ------------------------------------------------------ -- Server version5.7.31 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Current Database: `ssmge25c` -- /*!40000 DROP DATABASE IF EXISTS `ssmge25c`*/; CREATE DATABASE /*!32312 IF NOT EXISTS*/ `ssmge25c` /*!40100 DEFAULT CHARACTER SET utf8mb4 */; USE `ssmge25c`; -- -- Table structure for table `address` -- 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-21 15:59:42',11,'宇宙银河系金星1号','金某','13823888881','是'),(2,'2022-04-21 15:59:42',12,'宇宙银河系木星1号','木某','13823888882','是'),(3,'2022-04-21 15:59:42',13,'宇宙银河系水星1号','水某','13823888883','是'),(4,'2022-04-21 15:59:42',14,'宇宙银河系火星1号','火某','13823888884','是'),(5,'2022-04-21 15:59:42',15,'宇宙银河系土星1号','土某','13823888885','是'),(6,'2022-04-21 15:59:42',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 'xianhuaxinxi' 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 '会员价', 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 `discussxianhuaxinxi` -- DROP TABLE IF EXISTS `discussxianhuaxinxi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `discussxianhuaxinxi` ( `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=87 DEFAULT CHARSET=utf8 COMMENT='鲜花信息评论表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `discussxianhuaxinxi` -- LOCK TABLES `discussxianhuaxinxi` WRITE; /*!40000 ALTER TABLE `discussxianhuaxinxi` DISABLE KEYS */; INSERT INTO `discussxianhuaxinxi` VALUES (81,'2022-04-21 15:59:42',1,1,'用户名1','评论内容1','回复内容1'),(82,'2022-04-21 15:59:42',2,2,'用户名2','评论内容2','回复内容2'),(83,'2022-04-21 15:59:42',3,3,'用户名3','评论内容3','回复内容3'),(84,'2022-04-21 15:59:42',4,4,'用户名4','评论内容4','回复内容4'),(85,'2022-04-21 15:59:42',5,5,'用户名5','评论内容5','回复内容5'),(86,'2022-04-21 15:59:42',6,6,'用户名6','评论内容6','回复内容6'); /*!40000 ALTER TABLE `discussxianhuaxinxi` 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 'xianhuaxinxi' 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 '物流', 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 `storeup` -- DROP TABLE IF EXISTS `storeup`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `storeup` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `userid` bigint(20) NOT NULL COMMENT '用户id', `refid` bigint(20) DEFAULT NULL COMMENT '收藏id', `tablename` varchar(200) DEFAULT NULL COMMENT '表名', `name` varchar(200) NOT NULL COMMENT '收藏名称', `picture` varchar(200) NOT NULL COMMENT '收藏图片', `type` varchar(200) DEFAULT '1' COMMENT '类型(1:收藏,21:赞,22:踩)', `inteltype` 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 `storeup` -- LOCK TABLES `storeup` WRITE; /*!40000 ALTER TABLE `storeup` DISABLE KEYS */; /*!40000 ALTER TABLE `storeup` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `token` -- DROP TABLE IF EXISTS `token`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `token` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `userid` bigint(20) NOT NULL COMMENT '用户id', `username` varchar(100) NOT NULL COMMENT '用户名', `tablename` varchar(100) DEFAULT NULL COMMENT '表名', `role` varchar(100) DEFAULT NULL COMMENT '角色', `token` varchar(200) NOT NULL COMMENT '密码', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间', `expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '过期时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='token表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `token` -- LOCK TABLES `token` WRITE; /*!40000 ALTER TABLE `token` DISABLE KEYS */; INSERT INTO `token` VALUES (1,11,'用户账号1','yonghu','用户','gukulb2x96m0uyd4859rwewkalnbetsf','2022-04-21 16:01:42','2022-04-21 17:01:43'),(2,1,'abo','users','管理员','v4861r876ekbvgswsr7x26cta3j7vyhy','2022-04-21 16:04:00','2022-04-21 17:04:00'); /*!40000 ALTER TABLE `token` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `users` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `username` varchar(100) NOT NULL COMMENT '用户名', `password` varchar(100) NOT NULL COMMENT '密码', `role` varchar(100) DEFAULT '管理员' COMMENT '角色', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` VALUES (1,'abo','abo','管理员','2022-04-21 15:59:42'); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `xianhuafenlei` -- DROP TABLE IF EXISTS `xianhuafenlei`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `xianhuafenlei` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `xianhuafenlei` varchar(200) DEFAULT NULL COMMENT '鲜花分类', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COMMENT='鲜花分类'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `xianhuafenlei` -- LOCK TABLES `xianhuafenlei` WRITE; /*!40000 ALTER TABLE `xianhuafenlei` DISABLE KEYS */; INSERT INTO `xianhuafenlei` VALUES (21,'2022-04-21 15:59:42','鲜花分类1'),(22,'2022-04-21 15:59:42','鲜花分类2'),(23,'2022-04-21 15:59:42','鲜花分类3'),(24,'2022-04-21 15:59:42','鲜花分类4'),(25,'2022-04-21 15:59:42','鲜花分类5'),(26,'2022-04-21 15:59:42','鲜花分类6'); /*!40000 ALTER TABLE `xianhuafenlei` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `xianhuaxinxi` -- DROP TABLE IF EXISTS `xianhuaxinxi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `xianhuaxinxi` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `xianhuabianhao` varchar(200) DEFAULT NULL COMMENT '鲜花编号', `xianhuamingcheng` varchar(200) DEFAULT NULL COMMENT '鲜花名称', `xianhuafenlei` varchar(200) DEFAULT NULL COMMENT '鲜花分类', `xianhuatupian` varchar(200) DEFAULT NULL COMMENT '鲜花图片', `xianhuayanse` varchar(200) DEFAULT NULL COMMENT '鲜花颜色', `xianhuaguige` varchar(200) DEFAULT NULL COMMENT '鲜花规格', `xianhuaxiangqing` longtext 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 `xianhuabianhao` (`xianhuabianhao`) ) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COMMENT='鲜花信息'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `xianhuaxinxi` -- LOCK TABLES `xianhuaxinxi` WRITE; /*!40000 ALTER TABLE `xianhuaxinxi` DISABLE KEYS */; INSERT INTO `xianhuaxinxi` VALUES (31,'2022-04-21 15:59:42','1111111111','鲜花名称1','鲜花分类1','upload/xianhuaxinxi_xianhuatupian1.jpg','鲜花颜色1','鲜花规格1','鲜花详情1','2022-04-21 23:59:42',1,99.9,1,99),(32,'2022-04-21 15:59:42','2222222222','鲜花名称2','鲜花分类2','upload/xianhuaxinxi_xianhuatupian2.jpg','鲜花颜色2','鲜花规格2','鲜花详情2','2022-04-21 23:59:42',2,99.9,2,99),(33,'2022-04-21 15:59:42','3333333333','鲜花名称3','鲜花分类3','upload/xianhuaxinxi_xianhuatupian3.jpg','鲜花颜色3','鲜花规格3','鲜花详情3','2022-04-21 23:59:42',3,99.9,3,99),(34,'2022-04-21 15:59:42','4444444444','鲜花名称4','鲜花分类4','upload/xianhuaxinxi_xianhuatupian4.jpg','鲜花颜色4','鲜花规格4','鲜花详情4','2022-04-21 23:59:42',4,99.9,4,99),(35,'2022-04-21 15:59:42','5555555555','鲜花名称5','鲜花分类5','upload/xianhuaxinxi_xianhuatupian5.jpg','鲜花颜色5','鲜花规格5','鲜花详情5','2022-04-21 23:59:42',5,99.9,5,99),(36,'2022-04-21 15:59:42','6666666666','鲜花名称6','鲜花分类6','upload/xianhuaxinxi_xianhuatupian6.jpg','鲜花颜色6','鲜花规格6','鲜花详情6','2022-04-22 00:03:49',8,99.9,6,99); /*!40000 ALTER TABLE `xianhuaxinxi` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `yonghu` -- DROP TABLE IF EXISTS `yonghu`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `yonghu` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `yonghuzhanghao` varchar(200) NOT NULL COMMENT '用户账号', `mima` varchar(200) NOT NULL COMMENT '密码', `yonghuxingming` varchar(200) NOT NULL COMMENT '用户姓名', `xingbie` varchar(200) DEFAULT NULL COMMENT '性别', `lianxifangshi` varchar(200) DEFAULT NULL COMMENT '联系方式', `touxiang` varchar(200) DEFAULT NULL COMMENT '头像', `money` float DEFAULT '0' COMMENT '余额', PRIMARY KEY (`id`), UNIQUE KEY `yonghuzhanghao` (`yonghuzhanghao`) ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='用户'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `yonghu` -- LOCK TABLES `yonghu` WRITE; /*!40000 ALTER TABLE `yonghu` DISABLE KEYS */; INSERT INTO `yonghu` VALUES (11,'2022-04-21 15:59:42','用户账号1','123456','用户姓名1','男','13823888881','upload/yonghu_touxiang1.jpg',100),(12,'2022-04-21 15:59:42','用户账号2','123456','用户姓名2','男','13823888882','upload/yonghu_touxiang2.jpg',100),(13,'2022-04-21 15:59:42','用户账号3','123456','用户姓名3','男','13823888883','upload/yonghu_touxiang3.jpg',100),(14,'2022-04-21 15:59:42','用户账号4','123456','用户姓名4','男','13823888884','upload/yonghu_touxiang4.jpg',100),(15,'2022-04-21 15:59:42','用户账号5','123456','用户姓名5','男','13823888885','upload/yonghu_touxiang5.jpg',100),(16,'2022-04-21 15:59:42','用户账号6','123456','用户姓名6','男','13823888886','upload/yonghu_touxiang6.jpg',100); /*!40000 ALTER TABLE `yonghu` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2022-04-23 16:20:14 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376