首页 > 编程学习 > 基于ssm jsp超市在线销售平台的设计与实现

近年来,网络信息技术的迅猛发展,互联网逐渐渗透到人们日常生活中的方 方面面,而给我们的生活带来巨大变化的电子商务正在以前所未有的速度蓬勃发 展,电子商务也成为网络研究与应用的热点之一。网上商店是电子商务的重要方 面,使得人们的购物更轻松、快捷、方便,并且随着网络与电子商务的发展越来 越多的人选择在线购物。现在各行各业都纷纷进入电子商务领域,与此同时,各 高校也认识到将电子商务引入校园的必要性。

首先从安全性高、易于维护以及可以跨平台运行的角度考虑,对系统开发中 采用的体系结构和开发工具进行了认真筛选和可行性分析,最终选择了安全性较 高,可以跨平台运行的JSP作为前台开发语言。并选择了易于维护的B/S体系作 为本超市系统的基本架构。在HTML语言的基础上,结合JSP技术,利用经典的 MVC框架,设计并实现了一个易于操作的稳定高效的网上超市购物系统。

本论文详细描述了超市在线销售平台的各部分功能模块及其实现。本系统使用 JSP作为WEB服务器端开发语言,采用Tomcat作为WEB服务器,以IDEA 作为开发平台,用MYSQL作为后台数控管理系统,系统是一个基于 Browser/ Server的三层应用体系结构的Java Web应用。

通过对本超市购物系统的用户管理、商品搜索、销售订单査询等功能模块的 运行测试,论文最后得出结论,采用可以跨平台运行的、安全性高的Java技术、 JSP技术和MAX技术开发的高校超市在线销售平台是成功的,证明了采用JSP技术 和SSM技术在MVC框架下开发B/S购物系统的可行性。

关键词:电子商务,网上超市,JSP, MYSQL, SSM, 超市在线销售平台

项目演示视频(点击视频):

基于ssm jsp在线超市销售系统

项目结构:

基于ssm jsp 不是maven项目,数据库使用mysql

 

 

 

 

数据库文件sql:



SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for account
-- ----------------------------
DROP TABLE IF EXISTS `account`;
CREATE TABLE `account` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `password` varchar(32) NOT NULL,
  `email` varchar(32) DEFAULT NULL,
  `trueName` varchar(32) DEFAULT NULL,
  `sex` int(2) DEFAULT '0',
  `status` int(2) DEFAULT '1',
  `createTime` datetime DEFAULT NULL,
  `balance` float DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of account
-- ----------------------------
INSERT INTO `account` VALUES ('2', '李白', '1', 'llq@qq.com', '李白', '1', '1', '2021-12-16 22:38:03', null);
INSERT INTO `account` VALUES ('8', 'test', '11', 'test@qq.com', '张三', '1', '1', '2021-12-29 20:44:10', null);
INSERT INTO `account` VALUES ('9', '王金库', '123456', '115432031@qq.com', null, '0', '1', '2021-12-17 14:29:08', '303');
INSERT INTO `account` VALUES ('10', '王金库s', '123456', '115432031@qq.com', null, '0', '1', '2021-12-19 16:38:27', '0');
INSERT INTO `account` VALUES ('11', '李白1', '123', '132@qq.com', '李白', '1', '1', '2021-12-20 16:06:43', '2520.6');
INSERT INTO `account` VALUES ('12', '15255403527', '15255403527', '1176948057@qq.com', null, '0', '1', '2021-12-17 10:28:56', '50');
INSERT INTO `account` VALUES ('13', '12', '12', '1', null, '0', '1', '2021-12-17 15:31:56', '649');
INSERT INTO `account` VALUES ('14', '123', '123456', 'xiagaoxin@163.com', null, '0', '1', '2021-12-07 22:51:05', '10.6');
INSERT INTO `account` VALUES ('15', 'aaaaaa', 'aaaaaa', '2630663675@qq.com', '李四', '0', '1', '2021-12-07 17:01:16', '652');
INSERT INTO `account` VALUES ('16', 'java', '123456', '2630663675@qq.com', 'java程序猿', '0', '1', '2021-12-11 10:16:38', '1760');

-- ----------------------------
-- Table structure for address
-- ----------------------------
DROP TABLE IF EXISTS `address`;
CREATE TABLE `address` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NOT NULL,
  `name` varchar(128) NOT NULL,
  `address` varchar(128) NOT NULL,
  `phone` varchar(32) NOT NULL DEFAULT '',
  `createTime` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `userId` (`userId`) USING BTREE,
  CONSTRAINT `address_ibfk_1` FOREIGN KEY (`userId`) REFERENCES `account` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of address
-- ----------------------------
INSERT INTO `address` VALUES ('16', '9', '超级1', '河南周口', '13909367108', '2021-12-19 18:45:14');
INSERT INTO `address` VALUES ('17', '11', '李白', '上海市浦东新区', '13998893839', '2021-12-20 16:11:04');
INSERT INTO `address` VALUES ('18', '12', '夏高兴', '222', '111', '2021-12-17 10:30:35');
INSERT INTO `address` VALUES ('19', '13', '12', '12', '12', '2021-12-17 16:27:08');
INSERT INTO `address` VALUES ('20', '8', 'wrw', 'wr', 'wr', '2021-12-11 16:47:08');
INSERT INTO `address` VALUES ('21', '14', '小白', '222', '12121212', '2021-12-22 19:23:22');
INSERT INTO `address` VALUES ('22', '15', '张三', '北京市天安门11号', '17666666666', '2021-11-29 17:01:53');
INSERT INTO `address` VALUES ('23', '16', '张三', 'aa小区11号', '18777777777', '2021-12-11 10:19:48');

-- ----------------------------
-- Table structure for authority
-- ----------------------------
DROP TABLE IF EXISTS `authority`;
CREATE TABLE `authority` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `roleId` int(11) NOT NULL,
  `menuId` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `roleId` (`roleId`) USING BTREE,
  KEY `menuId` (`menuId`) USING BTREE,
  CONSTRAINT `authority_ibfk_1` FOREIGN KEY (`roleId`) REFERENCES `role` (`id`),
  CONSTRAINT `authority_ibfk_2` FOREIGN KEY (`menuId`) REFERENCES `menu` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=662 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of authority
-- ----------------------------
INSERT INTO `authority` VALUES ('148', '2', '35');
INSERT INTO `authority` VALUES ('149', '2', '36');
INSERT INTO `authority` VALUES ('150', '2', '25');
INSERT INTO `authority` VALUES ('151', '2', '1');
INSERT INTO `authority` VALUES ('152', '2', '14');
INSERT INTO `authority` VALUES ('153', '2', '15');
INSERT INTO `authority` VALUES ('612', '1', '1');
INSERT INTO `authority` VALUES ('613', '1', '5');
INSERT INTO `authority` VALUES ('614', '1', '17');
INSERT INTO `authority` VALUES ('615', '1', '18');
INSERT INTO `authority` VALUES ('616', '1', '19');
INSERT INTO `authority` VALUES ('617', '1', '20');
INSERT INTO `authority` VALUES ('618', '1', '13');
INSERT INTO `authority` VALUES ('619', '1', '21');
INSERT INTO `authority` VALUES ('620', '1', '22');
INSERT INTO `authority` VALUES ('621', '1', '23');
INSERT INTO `authority` VALUES ('622', '1', '35');
INSERT INTO `authority` VALUES ('623', '1', '36');
INSERT INTO `authority` VALUES ('624', '1', '14');
INSERT INTO `authority` VALUES ('625', '1', '15');
INSERT INTO `authority` VALUES ('626', '1', '24');
INSERT INTO `authority` VALUES ('627', '1', '25');
INSERT INTO `authority` VALUES ('628', '1', '26');
INSERT INTO `authority` VALUES ('633', '1', '37');
INSERT INTO `authority` VALUES ('634', '1', '38');
INSERT INTO `authority` VALUES ('635', '1', '39');
INSERT INTO `authority` VALUES ('636', '1', '40');
INSERT INTO `authority` VALUES ('637', '1', '41');
INSERT INTO `authority` VALUES ('638', '1', '42');
INSERT INTO `authority` VALUES ('639', '1', '43');
INSERT INTO `authority` VALUES ('640', '1', '44');
INSERT INTO `authority` VALUES ('641', '1', '45');
INSERT INTO `authority` VALUES ('642', '1', '46');
INSERT INTO `authority` VALUES ('643', '1', '47');
INSERT INTO `authority` VALUES ('644', '1', '48');
INSERT INTO `authority` VALUES ('645', '1', '49');
INSERT INTO `authority` VALUES ('646', '1', '50');
INSERT INTO `authority` VALUES ('647', '1', '51');
INSERT INTO `authority` VALUES ('648', '1', '52');
INSERT INTO `authority` VALUES ('649', '1', '53');
INSERT INTO `authority` VALUES ('650', '1', '54');
INSERT INTO `authority` VALUES ('651', '1', '55');
INSERT INTO `authority` VALUES ('652', '1', '56');
INSERT INTO `authority` VALUES ('653', '1', '57');
INSERT INTO `authority` VALUES ('654', '1', '58');
INSERT INTO `authority` VALUES ('655', '1', '59');
INSERT INTO `authority` VALUES ('656', '1', '60');
INSERT INTO `authority` VALUES ('657', '1', '61');
INSERT INTO `authority` VALUES ('658', '1', '62');
INSERT INTO `authority` VALUES ('659', '1', '63');
INSERT INTO `authority` VALUES ('660', '1', '65');
INSERT INTO `authority` VALUES ('661', '1', '66');

-- ----------------------------
-- Table structure for c3p0testtable
-- ----------------------------
DROP TABLE IF EXISTS `c3p0testtable`;
CREATE TABLE `c3p0testtable` (
  `a` char(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of c3p0testtable
-- ----------------------------

-- ----------------------------
-- Table structure for cart
-- ----------------------------
DROP TABLE IF EXISTS `cart`;
CREATE TABLE `cart` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NOT NULL,
  `productId` int(11) NOT NULL,
  `name` varchar(128) NOT NULL,
  `imageUrl` varchar(128) NOT NULL,
  `price` float(8,2) NOT NULL DEFAULT '0.00',
  `num` int(8) NOT NULL DEFAULT '0',
  `money` double(8,2) NOT NULL DEFAULT '0.00',
  `createTime` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `productCategoryId` (`productId`) USING BTREE,
  KEY `userId` (`userId`) USING BTREE,
  CONSTRAINT `cart_ibfk_1` FOREIGN KEY (`userId`) REFERENCES `account` (`id`),
  CONSTRAINT `cart_ibfk_2` FOREIGN KEY (`productId`) REFERENCES `product` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of cart
-- ----------------------------

-- ----------------------------
-- Table structure for comment
-- ----------------------------
DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `productId` int(11) NOT NULL,
  `userId` int(11) NOT NULL,
  `type` int(2) NOT NULL DEFAULT '1',
  `content` varchar(512) NOT NULL,
  `createTime` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `productId` (`productId`) USING BTREE,
  KEY `userId` (`userId`) USING BTREE,
  CONSTRAINT `comment_ibfk_1` FOREIGN KEY (`productId`) REFERENCES `product` (`id`),
  CONSTRAINT `comment_ibfk_2` FOREIGN KEY (`userId`) REFERENCES `account` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of comment
-- ----------------------------
INSERT INTO `comment` VALUES ('2', '21', '16', '1', '不错,送的很快', '2021-12-11 10:20:50');

-- ----------------------------
-- Table structure for favorite
-- ----------------------------
DROP TABLE IF EXISTS `favorite`;
CREATE TABLE `favorite` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userId` int(11) NOT NULL,
  `productId` int(11) NOT NULL,
  `name` varchar(128) NOT NULL,
  `imageUrl` varchar(128) NOT NULL,
  `price` float(8,2) NOT NULL DEFAULT '0.00',
  `createTime` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `productCategoryId` (`productId`) USING BTREE,
  KEY `userId` (`userId`) USING BTREE,
  CONSTRAINT `favorite_ibfk_1` FOREIGN KEY (`userId`) REFERENCES `account` (`id`),
  CONSTRAINT `favorite_ibfk_2` FOREIGN KEY (`productId`) REFERENCES `product` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of favorite
-- ----------------------------
INSERT INTO `favorite` VALUES ('12', '2', '5', '施华洛世奇 LIFELONG手镯 扭结设计气质手', '/OnlineShop/resources/upload/1558249319805.png', '1498.00', '2021-12-25 21:01:50');
INSERT INTO `favorite` VALUES ('13', '2', '3', 'NIKE耐克男鞋板鞋2019新款系列高帮小白鞋', '/OnlineShop/resources/upload/1558249017645.png', '559.00', '2021-12-25 21:02:05');
INSERT INTO `favorite` VALUES ('14', '8', '11', '羿萱19年夏新款高跟凉鞋女欧美真皮一字绑带性感细跟防水台高跟鞋', '/OnlineShop/resources/upload/1559133484283.jpg', '248.00', '2021-12-29 20:48:55');
INSERT INTO `favorite` VALUES ('15', '8', '2', '女士上衣夏季最新款式冰丝凉爽', '/OnlineShop/resources/upload/1558012737181.jpg', '399.00', '2021-12-29 20:49:01');
INSERT INTO `favorite` VALUES ('16', '8', '6', 'Crocs女靴子保暖 秋季卡骆驰阿瑞安娜反绒平底中筒时装靴', '/OnlineShop/resources/upload/1559132898198.png', '256.00', '2021-12-29 20:52:09');
INSERT INTO `favorite` VALUES ('18', '11', '3', '白梨瓜当季现摘甜瓜新鲜香瓜时令水果蜜瓜小脆瓜', '/FruitShop/resources/upload/1592735487229.jpg', '559.00', '2021-12-21 19:40:28');
INSERT INTO `favorite` VALUES ('19', '11', '8', '夏黑无核葡萄重庆香甜提子无子新鲜绿色草莓香味6月25日起售', '/FruitShop/resources/upload/1592736065920.jpg', '138.00', '2021-12-21 19:40:31');
INSERT INTO `favorite` VALUES ('20', '11', '6', '青木瓜 新鲜 农家自种 番木瓜 产妇下奶 凉拌 腌酸 生木瓜8斤包邮', '/FruitShop/resources/upload/1592735950346.jpg', '256.00', '2021-12-21 19:40:35');
INSERT INTO `favorite` VALUES ('21', '11', '11', '万丰园广西小台农芒新鲜采摘应季水果包邮带箱10斤鸡蛋芒果', '/FruitShop/resources/upload/1592736344669.jpg', '248.00', '2021-12-21 19:40:40');
INSERT INTO `favorite` VALUES ('22', '15', '11', '万丰园广西小台农芒新鲜采摘应季水果包邮带箱10斤鸡蛋芒果', '/FruitShop/resources/upload/1638175249965.jpg', '248.00', '2021-11-29 17:04:52');
INSERT INTO `favorite` VALUES ('23', '15', '5', '加州无籽葡萄干免洗无添加儿童营养零食369g/罐', '/FruitShop/resources/upload/1638174942377.jpg', '148.00', '2021-11-29 17:05:01');

-- ----------------------------
-- Table structure for log
-- ----------------------------
DROP TABLE IF EXISTS `log`;
CREATE TABLE `log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content` varchar(255) NOT NULL,
  `createTime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=200 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of log
-- ----------------------------
INSERT INTO `log` VALUES ('38', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-15 19:23:03');
INSERT INTO `log` VALUES ('40', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-15 19:33:06');
INSERT INTO `log` VALUES ('41', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-15 20:41:21');
INSERT INTO `log` VALUES ('42', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-15 21:04:28');
INSERT INTO `log` VALUES ('43', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-15 21:05:49');
INSERT INTO `log` VALUES ('44', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-15 22:05:41');
INSERT INTO `log` VALUES ('45', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-15 22:14:42');
INSERT INTO `log` VALUES ('46', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-15 22:16:23');
INSERT INTO `log` VALUES ('47', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-15 22:21:00');
INSERT INTO `log` VALUES ('48', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-15 22:36:01');
INSERT INTO `log` VALUES ('49', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-16 19:24:56');
INSERT INTO `log` VALUES ('50', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-16 19:40:45');
INSERT INTO `log` VALUES ('53', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-16 21:34:36');
INSERT INTO `log` VALUES ('55', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-16 22:21:34');
INSERT INTO `log` VALUES ('56', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-16 22:24:09');
INSERT INTO `log` VALUES ('57', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-16 22:36:53');
INSERT INTO `log` VALUES ('58', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-17 22:40:24');
INSERT INTO `log` VALUES ('59', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 11:58:57');
INSERT INTO `log` VALUES ('60', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 12:09:15');
INSERT INTO `log` VALUES ('61', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 12:14:11');
INSERT INTO `log` VALUES ('62', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 12:26:37');
INSERT INTO `log` VALUES ('63', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 12:27:52');
INSERT INTO `log` VALUES ('64', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 13:07:54');
INSERT INTO `log` VALUES ('65', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 14:27:55');
INSERT INTO `log` VALUES ('66', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 15:19:48');
INSERT INTO `log` VALUES ('67', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 15:23:44');
INSERT INTO `log` VALUES ('68', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 15:46:50');
INSERT INTO `log` VALUES ('69', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 17:29:48');
INSERT INTO `log` VALUES ('70', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 17:33:18');
INSERT INTO `log` VALUES ('71', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 20:06:23');
INSERT INTO `log` VALUES ('72', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-19 12:05:18');
INSERT INTO `log` VALUES ('73', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-19 12:26:59');
INSERT INTO `log` VALUES ('74', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-19 14:50:48');
INSERT INTO `log` VALUES ('75', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-26 19:55:02');
INSERT INTO `log` VALUES ('76', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-26 20:07:40');
INSERT INTO `log` VALUES ('77', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-28 20:16:59');
INSERT INTO `log` VALUES ('78', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-28 21:20:18');
INSERT INTO `log` VALUES ('79', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-28 21:30:27');
INSERT INTO `log` VALUES ('80', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-29 19:48:21');
INSERT INTO `log` VALUES ('81', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-29 19:50:37');
INSERT INTO `log` VALUES ('82', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-29 19:55:26');
INSERT INTO `log` VALUES ('83', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-29 19:57:26');
INSERT INTO `log` VALUES ('84', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-29 20:01:38');
INSERT INTO `log` VALUES ('85', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-29 20:05:04');
INSERT INTO `log` VALUES ('86', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-29 20:10:43');
INSERT INTO `log` VALUES ('87', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-29 20:19:45');
INSERT INTO `log` VALUES ('88', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-29 20:21:31');
INSERT INTO `log` VALUES ('89', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-29 20:43:39');
INSERT INTO `log` VALUES ('90', '用户名为admin的用户登录时输入验证码错误!', '2021-12-29 20:50:06');
INSERT INTO `log` VALUES ('91', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-29 20:50:14');
INSERT INTO `log` VALUES ('92', '用户名为admin的用户登录时输入密码错误!', '2021-12-17 21:29:43');
INSERT INTO `log` VALUES ('93', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-17 21:29:51');
INSERT INTO `log` VALUES ('94', '用户名为admin的用户登录时输入密码错误!', '2021-12-17 21:35:25');
INSERT INTO `log` VALUES ('95', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-17 21:35:30');
INSERT INTO `log` VALUES ('96', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-17 21:39:40');
INSERT INTO `log` VALUES ('97', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-17 22:23:39');
INSERT INTO `log` VALUES ('98', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-17 22:28:44');
INSERT INTO `log` VALUES ('99', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-17 22:30:31');
INSERT INTO `log` VALUES ('100', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-17 22:32:41');
INSERT INTO `log` VALUES ('101', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-17 22:34:34');
INSERT INTO `log` VALUES ('102', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-17 22:34:49');
INSERT INTO `log` VALUES ('103', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-17 22:36:39');
INSERT INTO `log` VALUES ('104', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-17 22:39:31');
INSERT INTO `log` VALUES ('105', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-17 22:40:42');
INSERT INTO `log` VALUES ('106', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-17 22:42:29');
INSERT INTO `log` VALUES ('107', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 12:03:07');
INSERT INTO `log` VALUES ('108', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 14:12:56');
INSERT INTO `log` VALUES ('109', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 14:28:48');
INSERT INTO `log` VALUES ('110', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 14:30:53');
INSERT INTO `log` VALUES ('111', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 14:34:07');
INSERT INTO `log` VALUES ('112', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 14:36:55');
INSERT INTO `log` VALUES ('113', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 14:44:51');
INSERT INTO `log` VALUES ('114', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 14:49:06');
INSERT INTO `log` VALUES ('115', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 14:55:53');
INSERT INTO `log` VALUES ('116', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 15:03:39');
INSERT INTO `log` VALUES ('117', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 15:13:00');
INSERT INTO `log` VALUES ('118', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 15:50:10');
INSERT INTO `log` VALUES ('119', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 16:37:38');
INSERT INTO `log` VALUES ('120', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 17:01:34');
INSERT INTO `log` VALUES ('121', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 17:18:13');
INSERT INTO `log` VALUES ('122', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 17:25:42');
INSERT INTO `log` VALUES ('123', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 20:27:00');
INSERT INTO `log` VALUES ('124', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 20:55:05');
INSERT INTO `log` VALUES ('125', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 20:56:07');
INSERT INTO `log` VALUES ('126', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 20:57:23');
INSERT INTO `log` VALUES ('127', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 20:58:43');
INSERT INTO `log` VALUES ('128', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 21:20:42');
INSERT INTO `log` VALUES ('129', '用户名为admin的用户登录时输入验证码错误!', '2021-12-18 21:26:32');
INSERT INTO `log` VALUES ('130', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 21:26:37');
INSERT INTO `log` VALUES ('131', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 21:29:26');
INSERT INTO `log` VALUES ('132', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 21:41:06');
INSERT INTO `log` VALUES ('133', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 21:43:58');
INSERT INTO `log` VALUES ('134', '用户名为admin的用户登录时输入验证码错误!', '2021-12-18 21:47:54');
INSERT INTO `log` VALUES ('135', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 21:48:00');
INSERT INTO `log` VALUES ('136', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 21:51:14');
INSERT INTO `log` VALUES ('137', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-18 21:55:32');
INSERT INTO `log` VALUES ('138', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-19 09:59:03');
INSERT INTO `log` VALUES ('139', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-19 10:03:30');
INSERT INTO `log` VALUES ('140', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-19 10:04:48');
INSERT INTO `log` VALUES ('141', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-19 10:54:47');
INSERT INTO `log` VALUES ('142', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-19 11:05:57');
INSERT INTO `log` VALUES ('143', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-19 14:09:20');
INSERT INTO `log` VALUES ('144', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-19 17:03:35');
INSERT INTO `log` VALUES ('145', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-19 17:05:08');
INSERT INTO `log` VALUES ('146', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-19 17:19:39');
INSERT INTO `log` VALUES ('147', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-19 17:48:24');
INSERT INTO `log` VALUES ('148', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-19 17:49:59');
INSERT INTO `log` VALUES ('149', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-19 17:53:18');
INSERT INTO `log` VALUES ('150', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-19 17:58:45');
INSERT INTO `log` VALUES ('151', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-19 18:00:37');
INSERT INTO `log` VALUES ('152', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-19 18:02:47');
INSERT INTO `log` VALUES ('153', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-19 18:04:03');
INSERT INTO `log` VALUES ('154', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-19 18:18:04');
INSERT INTO `log` VALUES ('155', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-19 18:20:10');
INSERT INTO `log` VALUES ('156', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-20 12:00:50');
INSERT INTO `log` VALUES ('157', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-20 16:19:50');
INSERT INTO `log` VALUES ('158', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-20 16:30:33');
INSERT INTO `log` VALUES ('159', '用户名为admin的用户登录时输入验证码错误!', '2021-12-20 16:37:46');
INSERT INTO `log` VALUES ('160', '用户名为admin的用户登录时输入验证码错误!', '2021-12-20 16:37:54');
INSERT INTO `log` VALUES ('161', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-20 16:38:01');
INSERT INTO `log` VALUES ('162', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-20 16:52:22');
INSERT INTO `log` VALUES ('163', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-20 16:57:56');
INSERT INTO `log` VALUES ('164', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-20 21:51:50');
INSERT INTO `log` VALUES ('165', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-21 14:10:20');
INSERT INTO `log` VALUES ('166', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-21 18:22:29');
INSERT INTO `log` VALUES ('167', '登录时,用户名为adimin的用户不存在!', '2021-12-17 10:41:44');
INSERT INTO `log` VALUES ('168', '登录时,用户名为ademin的用户不存在!', '2021-12-17 10:43:50');
INSERT INTO `log` VALUES ('169', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-17 13:40:36');
INSERT INTO `log` VALUES ('170', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-17 14:31:05');
INSERT INTO `log` VALUES ('171', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-17 15:08:36');
INSERT INTO `log` VALUES ('172', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-17 16:24:20');
INSERT INTO `log` VALUES ('173', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-17 17:04:44');
INSERT INTO `log` VALUES ('174', '登录时,用户名为ademin的用户不存在!', '2021-04-01 20:15:50');
INSERT INTO `log` VALUES ('175', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-04-01 20:16:19');
INSERT INTO `log` VALUES ('176', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-04-02 14:27:59');
INSERT INTO `log` VALUES ('177', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-04-02 15:57:19');
INSERT INTO `log` VALUES ('178', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-11 16:50:13');
INSERT INTO `log` VALUES ('179', '用户名为admin的用户登录时输入验证码错误!', '2021-12-22 19:12:20');
INSERT INTO `log` VALUES ('180', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-22 19:12:26');
INSERT INTO `log` VALUES ('181', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-22 19:22:04');
INSERT INTO `log` VALUES ('182', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-22 20:11:03');
INSERT INTO `log` VALUES ('183', '用户名为admin的用户登录时输入密码错误!', '2021-11-29 15:55:13');
INSERT INTO `log` VALUES ('184', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-11-29 15:55:31');
INSERT INTO `log` VALUES ('185', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-11-29 16:26:57');
INSERT INTO `log` VALUES ('186', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-11-29 16:29:21');
INSERT INTO `log` VALUES ('187', '用户名为admin的用户登录时输入验证码错误!', '2021-11-29 17:00:11');
INSERT INTO `log` VALUES ('188', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-11-29 17:00:26');
INSERT INTO `log` VALUES ('189', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-06 22:16:02');
INSERT INTO `log` VALUES ('190', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-06 22:50:16');
INSERT INTO `log` VALUES ('191', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-06 23:20:07');
INSERT INTO `log` VALUES ('192', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-07 21:17:28');
INSERT INTO `log` VALUES ('193', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-07 22:20:38');
INSERT INTO `log` VALUES ('194', '用户名为admin的用户登录时输入验证码错误!', '2021-12-07 22:46:41');
INSERT INTO `log` VALUES ('195', '用户名为admin的用户登录时输入验证码错误!', '2021-12-07 22:46:48');
INSERT INTO `log` VALUES ('196', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-07 22:47:03');
INSERT INTO `log` VALUES ('197', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-09 21:52:25');
INSERT INTO `log` VALUES ('198', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-11 10:15:20');
INSERT INTO `log` VALUES ('199', '用户名为{admin},角色为{超级管理员}的用户登录成功!', '2021-12-11 10:41:44');

-- ----------------------------
-- Table structure for menu
-- ----------------------------
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parentId` int(11) NOT NULL DEFAULT '-1',
  `name` varchar(32) NOT NULL,
  `url` varchar(128) DEFAULT NULL,
  `icon` varchar(32) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of menu
-- ----------------------------
INSERT INTO `menu` VALUES ('1', '0', '系统设置', '', 'icon-advancedsettings');
INSERT INTO `menu` VALUES ('5', '1', '菜单管理', '../admin/menu/list', 'icon-chart-organisation');
INSERT INTO `menu` VALUES ('13', '1', '角色管理', '../admin/role/list', 'icon-group-key');
INSERT INTO `menu` VALUES ('14', '0', '用户管理', '', 'icon-group-gear');
INSERT INTO `menu` VALUES ('15', '14', '用户列表', '../admin/user/list', 'icon-group');
INSERT INTO `menu` VALUES ('17', '5', '添加', 'openAdd()', 'icon-add');
INSERT INTO `menu` VALUES ('18', '5', '编辑', 'openEdit()', 'icon-bullet-edit');
INSERT INTO `menu` VALUES ('19', '5', '删除', 'remove()', 'icon-cross');
INSERT INTO `menu` VALUES ('20', '5', '添加按钮', 'openAddMenu()', 'icon-add');
INSERT INTO `menu` VALUES ('21', '13', '添加', 'openAdd()', 'icon-add');
INSERT INTO `menu` VALUES ('22', '13', '编辑', 'openEdit()', 'icon-bullet-edit');
INSERT INTO `menu` VALUES ('23', '13', '删除', 'remove()', 'icon-cross');
INSERT INTO `menu` VALUES ('24', '15', '添加', 'openAdd()', 'icon-add');
INSERT INTO `menu` VALUES ('25', '15', '编辑', 'openEdit()', 'icon-bullet-edit');
INSERT INTO `menu` VALUES ('26', '15', '删除', 'remove()', 'icon-cross');
INSERT INTO `menu` VALUES ('35', '1', '修改密码', 'edit_password', 'icon-lock-edit');
INSERT INTO `menu` VALUES ('36', '35', '修改密码', 'openAdd()', 'icon-lock-edit');
INSERT INTO `menu` VALUES ('37', '0', '商品分类', '', 'icon-sitemap-color');
INSERT INTO `menu` VALUES ('38', '37', '分类列表', '../admin/product_category/list', 'icon-sitemap');
INSERT INTO `menu` VALUES ('39', '38', '添加', 'openAdd()', 'icon-chart-organisation-add');
INSERT INTO `menu` VALUES ('40', '38', '编辑', 'openEdit()', 'icon-bullet-edit');
INSERT INTO `menu` VALUES ('41', '38', '删除', 'remove()', 'icon-chart-organisation-delete');
INSERT INTO `menu` VALUES ('42', '0', '商品管理', '', 'icon-cart-full');
INSERT INTO `menu` VALUES ('43', '42', '商品列表', '../admin/product/list', 'icon-cart');
INSERT INTO `menu` VALUES ('44', '43', '添加', 'openAdd()', 'icon-cart-add');
INSERT INTO `menu` VALUES ('45', '43', '编辑', 'openEdit()', 'icon-cart-edit');
INSERT INTO `menu` VALUES ('46', '43', '删除', 'remove()', 'icon-cart-delete');
INSERT INTO `menu` VALUES ('47', '0', '客户管理', '', 'icon-users');
INSERT INTO `menu` VALUES ('48', '47', '客户列表', '../admin/account/list', 'icon-user-group');
INSERT INTO `menu` VALUES ('49', '48', '添加', 'openAdd()', 'icon-user-add');
INSERT INTO `menu` VALUES ('50', '48', '编辑', 'openEdit()', 'icon-user-edit');
INSERT INTO `menu` VALUES ('51', '48', '删除', 'remove()', 'icon-user-cross');
INSERT INTO `menu` VALUES ('52', '0', '订单管理', '', 'icon-database');
INSERT INTO `menu` VALUES ('53', '52', '订单列表', '../admin/order/list', 'icon-database-gear');
INSERT INTO `menu` VALUES ('54', '53', '编辑订单', 'openEdit()', 'icon-database-edit');
INSERT INTO `menu` VALUES ('55', '53', '查看订单', 'openView()', 'icon-eye');
INSERT INTO `menu` VALUES ('56', '0', '评论管理', '', 'icon-comment');
INSERT INTO `menu` VALUES ('57', '56', '评论列表', '../admin/comment/list', 'icon-comments');
INSERT INTO `menu` VALUES ('58', '57', '编辑', 'openEdit()', 'icon-comment-edit');
INSERT INTO `menu` VALUES ('59', '57', '删除', 'remove()', 'icon-comment-delete');
INSERT INTO `menu` VALUES ('60', '0', '销售统计', '', 'icon-chart-curve');
INSERT INTO `menu` VALUES ('61', '60', '统计图表', '../admin/stats/stats', 'icon-chart-line');
INSERT INTO `menu` VALUES ('62', '0', '充值管理', '', 'icon-money-yen');
INSERT INTO `menu` VALUES ('63', '62', '充值列表', '../admin/purse/lists', 'icon-money-dollar');
INSERT INTO `menu` VALUES ('65', '63', '通过', 'verify(1)', 'icon-ok');
INSERT INTO `menu` VALUES ('66', '63', '驳回', 'verify(2)', 'icon-DeleteRed');

-- ----------------------------
-- Table structure for orders
-- ----------------------------
DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sn` varchar(32) NOT NULL,
  `userId` int(11) NOT NULL,
  `address` varchar(128) NOT NULL,
  `money` double(8,2) NOT NULL DEFAULT '0.00',
  `productNum` int(5) NOT NULL DEFAULT '0',
  `status` int(2) NOT NULL DEFAULT '0',
  `remark` varchar(128) DEFAULT NULL,
  `createTime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `userId` (`userId`) USING BTREE,
  CONSTRAINT `orders_ibfk_1` FOREIGN KEY (`userId`) REFERENCES `account` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of orders
-- ----------------------------
INSERT INTO `orders` VALUES ('1', 'O1639189197226', '16', 'aa小区11号 张三(收) 18777777777', '240.00', '2', '2', '', '2021-12-11 10:19:57');

-- ----------------------------
-- Table structure for order_item
-- ----------------------------
DROP TABLE IF EXISTS `order_item`;
CREATE TABLE `order_item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `productId` int(11) NOT NULL,
  `orderId` int(11) NOT NULL,
  `name` varchar(128) NOT NULL,
  `imageUrl` varchar(128) NOT NULL,
  `price` float(8,2) NOT NULL,
  `num` int(8) NOT NULL DEFAULT '0',
  `money` double(8,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `productCategoryId` (`orderId`) USING BTREE,
  KEY `productId` (`productId`) USING BTREE,
  CONSTRAINT `order_item_ibfk_1` FOREIGN KEY (`productId`) REFERENCES `product` (`id`),
  CONSTRAINT `order_item_ibfk_2` FOREIGN KEY (`orderId`) REFERENCES `orders` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of order_item
-- ----------------------------
INSERT INTO `order_item` VALUES ('1', '21', '1', '丰庄园原生冷榨高油酸花生油', '/FruitShop/resources/upload/1638887076032.jpg', '120.00', '2', '240.00');

-- ----------------------------
-- Table structure for product
-- ----------------------------
DROP TABLE IF EXISTS `product`;
CREATE TABLE `product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `productCategoryId` int(11) NOT NULL,
  `name` varchar(128) NOT NULL,
  `tags` varchar(32) NOT NULL,
  `imageUrl` varchar(128) NOT NULL,
  `price` float(8,2) NOT NULL,
  `stock` int(8) NOT NULL DEFAULT '0',
  `sellNum` int(8) NOT NULL DEFAULT '0',
  `viewNum` int(8) NOT NULL DEFAULT '0',
  `commentNum` int(8) NOT NULL DEFAULT '0',
  `content` text,
  `createTime` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `productCategoryId` (`productCategoryId`) USING BTREE,
  CONSTRAINT `product_ibfk_1` FOREIGN KEY (`productCategoryId`) REFERENCES `product_category` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of product
-- ----------------------------
INSERT INTO `product` VALUES ('1', '346', '雅客天天棒什锦口味棒棒糖', '345,346', '/FruitShop/resources/upload/1638884919420.jpg', '1.50', '1000', '11', '4', '0', '<p>商品描述</p><p><img src=\"/FruitShop/resources/upload/image/20211207/1638884943308036830.jpg\"/></p><p style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin-top: 0px; margin-bottom: 6px; padding: 0px; outline: none; font-size: 12px; line-height: 1.4;\"><br/><img src=\"/FruitShop/resources/upload/image/20211207/1638884943426043454.jpg\"/><br/><br/><img src=\"/FruitShop/resources/upload/image/20211207/1638884943506070737.jpg\"/><br/><br/><img src=\"/FruitShop/resources/upload/image/20211207/1638884943559031066.jpg\"/><br/><br/><img src=\"/FruitShop/resources/upload/image/20211207/1638884943639012902.jpg\"/></p><p><br/></p>', '2021-12-07 21:49:13');
INSERT INTO `product` VALUES ('2', '2', '新鲜採摘水果甜桂圆肉多 泰国龙眼 包邮 净重5斤 坏果包赔', '1,2', '/FruitShop/resources/upload/1638804189942.jpg', '39.00', '32', '0', '4', '2', '<p style=\"margin-top: 1.12em; margin-bottom: 1.12em; padding: 0px; font-family: tahoma, arial, 宋体, sans-serif; font-size: 14px; white-space: normal; background-color: rgb(255, 255, 255);\"><span style=\"color: rgb(255, 0, 0); font-size: 24pt;\">泰国金标龙眼 新鲜水果包邮</span></p><p style=\"margin-top: 1.12em; margin-bottom: 1.12em; padding: 0px; font-family: tahoma, arial, 宋体, sans-serif; font-size: 14px; white-space: normal; background-color: rgb(255, 255, 255);\"><span style=\"color: rgb(255, 0, 0); font-size: 24pt;\">5颗内不售后,超出1颗赔付0.2元!</span></p><p style=\"margin-top: 1.12em; margin-bottom: 1.12em; padding: 0px; font-family: tahoma, arial, 宋体, sans-serif; font-size: 14px; white-space: normal; background-color: rgb(255, 255, 255);\"><span style=\"color: rgb(255, 0, 0); font-size: 24pt;\">新疆、西藏、青海不发货!</span></p><p><img src=\"/FruitShop/resources/upload/image/20211129/1638174762346068845.jpg\" title=\"1638174762346068845.jpg\" alt=\"2.jpg\"/></p>', '2021-12-07 21:19:37');
INSERT INTO `product` VALUES ('3', '2', '白梨瓜当季现摘甜瓜新鲜香瓜时令水果蜜瓜小脆瓜', '1,2', '/FruitShop/resources/upload/1638804222726.jpg', '559.00', '97', '1', '1', '0', '<p style=\"margin-top: 1.12em; margin-bottom: 1.12em; padding: 0px; font-family: tahoma, arial, 宋体, sans-serif; font-size: 14px; white-space: normal; background-color: rgb(255, 255, 255); text-align: center;\"><strong><span style=\"color: rgb(255, 0, 0);\"><span style=\"font-size: 36px;\"><span style=\"background-color: rgb(240, 255, 240);\">湖北受疫情影响,好多农产品销不出去</span></span></span></strong></p><p style=\"margin-top: 1.12em; margin-bottom: 1.12em; padding: 0px; font-family: tahoma, arial, 宋体, sans-serif; font-size: 14px; white-space: normal; background-color: rgb(255, 255, 255); text-align: center;\"><strong><span style=\"color: rgb(255, 0, 0);\"><span style=\"font-size: 36px;\"><span style=\"background-color: rgb(240, 255, 240);\">帮帮我们!</span></span></span></strong></p><p><img src=\"/FruitShop/resources/upload/image/20211129/1638174817868063395.jpg\" title=\"1638174817868063395.jpg\" alt=\"3.jpg\"/><img src=\"/FruitShop/resources/upload/image/20211129/1638174823829037366.jpg\" title=\"1638174823829037366.jpg\" alt=\"4.jpg\"/></p><p><br/></p>', '2021-12-19 14:57:29');
INSERT INTO `product` VALUES ('5', '2', '加州无籽葡萄干免洗无添加儿童营养零食369g/罐', '1,2', '/FruitShop/resources/upload/1638804258235.jpg', '148.00', '2', '7', '1', '0', '<p><img src=\"/FruitShop/resources/upload/image/20211206/1638804265185077230.jpg\" title=\"1638804265185077230.jpg\" alt=\"33.jpg\"/></p>', '2021-12-05 15:02:56');
INSERT INTO `product` VALUES ('6', '2', '青木瓜 新鲜 农家自种 番木瓜 产妇下奶 凉拌 腌酸 生木瓜8斤包邮', '1,2', '/FruitShop/resources/upload/1638804331567.jpg', '256.00', '64', '2', '4', '1', '<p><img src=\"/FruitShop/resources/upload/image/20211206/1638804337479006345.jpg\" title=\"1638804337479006345.jpg\" alt=\"444.jpg\"/></p>', '2021-12-29 20:28:50');
INSERT INTO `product` VALUES ('7', '2', '新鲜巨峰葡萄孕妇水果现摘4斤整箱当天采摘不催熟', '1,2', '/FruitShop/resources/upload/1638804367191.jpg', '66.00', '76', '2', '3', '0', '<p><img src=\"/FruitShop/resources/upload/image/20211206/1638804373120060874.jpg\" title=\"1638804373120060874.jpg\" alt=\"55.jpg\"/></p>', '2021-12-06 20:30:39');
INSERT INTO `product` VALUES ('8', '2', '夏黑无核葡萄重庆香甜提子无子新鲜绿色草莓香味6月25日起售', '1,2', '/FruitShop/resources/upload/1638804404692.jpg', '138.00', '99', '0', '3', '0', '<p><img src=\"/FruitShop/resources/upload/image/20211206/1638804410335016041.jpg\" title=\"1638804410335016041.jpg\" alt=\"66.jpg\"/></p>', '2021-12-04 20:32:33');
INSERT INTO `product` VALUES ('9', '2', '新疆超大绿香妃王葡萄干500g吐鲁番无核葡萄干特产', '1,2', '/FruitShop/resources/upload/1638804449142.jpg', '79.00', '99', '0', '2', '0', '<p><img src=\"/FruitShop/resources/upload/image/20211206/1638804455755055935.jpg\" title=\"1638804455755055935.jpg\" alt=\"7.jpg\"/></p>', '2021-12-05 20:34:03');
INSERT INTO `product` VALUES ('10', '2', '河北皇冠梨10斤包邮新鲜梨子水果鸭梨雪花梨现摘现发整箱包邮', '1,2', '/FruitShop/resources/upload/1638804579067.jpg', '79.00', '65', '1', '1', '0', '<p><img src=\"/FruitShop/resources/upload/image/20211206/1638804584976030426.jpg\" title=\"1638804584976030426.jpg\" alt=\"1111.jpg\"/></p>', '2021-12-29 20:36:28');
INSERT INTO `product` VALUES ('11', '2', '万丰园广西小台农芒新鲜采摘应季水果包邮带箱10斤鸡蛋芒果', '1,2', '/FruitShop/resources/upload/1638804544055.jpg', '248.00', '53', '3', '2', '1', '<p><img src=\"/FruitShop/resources/upload/image/20211206/1638804549753099849.jpg\" title=\"1638804549753099849.jpg\" alt=\"q.jpg\"/></p>', '2021-12-05 20:38:34');
INSERT INTO `product` VALUES ('12', '2', '现摘冰糖麒麟西瓜5-6斤一个包邮薄皮当季新鲜水果爆汁甜脆大西瓜', '1,2', '/FruitShop/resources/upload/1638804602959.jpg', '16.80', '690', '6', '6', '0', '<p><img src=\"/FruitShop/resources/upload/image/20211206/1638804609168002603.jpg\" title=\"1638804609168002603.jpg\" alt=\"2222.jpg\"/></p>', '2021-12-21 18:48:15');
INSERT INTO `product` VALUES ('13', '345', '俄罗斯风味糯米糕', 'null,345', '/FruitShop/resources/upload/1638883477428.jpg', '85.00', '100', '0', '0', '0', '<p style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin-top: 0px; margin-bottom: 6px; padding: 0px; outline: none; font-size: 12px; line-height: 1.4; color: rgb(51, 51, 51); font-family: &quot;pingfang SC&quot;, &quot;helvetica neue&quot;, arial, &quot;hiragino sans gb&quot;, &quot;microsoft yahei ui&quot;, &quot;microsoft yahei&quot;, simsun, sans-serif; white-space: normal; background-color: rgb(255, 255, 255);\"><span style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px; outline: none;\"><span style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px; outline: none; font-size: 26pt; background-color: rgb(255, 0, 0); color: rgb(255, 255, 255);\">(每箱10袋*500克 每袋10个)订单式生产 工厂最新日期出货~小包装联系客服</span></span></p><p style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin-top: 0px; margin-bottom: 6px; padding: 0px; outline: none; font-size: 12px; line-height: 1.4; color: rgb(51, 51, 51); font-family: &quot;pingfang SC&quot;, &quot;helvetica neue&quot;, arial, &quot;hiragino sans gb&quot;, &quot;microsoft yahei ui&quot;, &quot;microsoft yahei&quot;, simsun, sans-serif; white-space: normal; background-color: rgb(255, 255, 255);\"><img src=\"/FruitShop/resources/upload/image/20211207/1638883507137051644.jpg\" height=\"790\" width=\"790\"/><br/><img src=\"/FruitShop/resources/upload/image/20211207/1638883507392019279.jpg\" height=\"790\" width=\"790\"/><img src=\"/FruitShop/resources/upload/image/20211207/1638883507493032537.jpg\" height=\"790\" width=\"790\"/><br/><br/><img src=\"/FruitShop/resources/upload/image/20211207/1638883507626048858.jpg\" height=\"790\" width=\"790\"/><img src=\"/FruitShop/resources/upload/image/20211207/1638883507681009018.jpg\" height=\"790\" width=\"790\"/><br/><br/><img src=\"/FruitShop/resources/upload/image/20211207/1638883507774070800.jpg\" height=\"790\" width=\"790\"/><br/><br/></p><p><br/></p>', '2021-12-07 21:25:19');
INSERT INTO `product` VALUES ('14', '2', '泰国榴莲新鲜金枕头现摘现发特产带壳水果包邮', '1,2', '/FruitShop/resources/upload/1638804127501.png', '256.00', '92', '7', '1', '2', '<p>递四方速递割发代首撒旦打撒<br/></p><p><img src=\"http://img.baidu.com/hi/jx2/j_0016.gif\"/><img src=\"http://img.baidu.com/hi/jx2/j_0013.gif\"/></p><p><br/></p>', '2021-12-02 22:21:53');
INSERT INTO `product` VALUES ('16', '346', '雅客天天棒什锦口味棒棒糖', '345,346', '/FruitShop/resources/upload/1638884919420.jpg', '1.50', '1000', '0', '0', '0', '<p>商品描述</p><p><img src=\"/FruitShop/resources/upload/image/20211207/1638884943308036830.jpg\"/></p><p style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin-top: 0px; margin-bottom: 6px; padding: 0px; outline: none; font-size: 12px; line-height: 1.4;\"><br/><img src=\"/FruitShop/resources/upload/image/20211207/1638884943426043454.jpg\"/><br/><br/><img src=\"/FruitShop/resources/upload/image/20211207/1638884943506070737.jpg\"/><br/><br/><img src=\"/FruitShop/resources/upload/image/20211207/1638884943559031066.jpg\"/><br/><br/><img src=\"/FruitShop/resources/upload/image/20211207/1638884943639012902.jpg\"/></p><p><br/></p>', '2021-12-07 21:49:13');
INSERT INTO `product` VALUES ('17', '348', '山东生姜1.2每斤', '348', '/FruitShop/resources/upload/1638885487471.jpg', '1.20', '10000', '22', '0', '0', '<p><span style=\"font-family: &quot;Microsoft YaHei&quot;; font-size: 14px; background-color: rgb(255, 255, 255);\">【</span><a href=\"http://www.nongnet.com/tag_3974.aspx\" target=\"_blank\" class=\"distag\" style=\"text-decoration-line: none; color: rgb(0, 0, 0); font-family: &quot;Microsoft YaHei&quot;; font-size: 14px; white-space: normal; background-color: rgb(255, 255, 255);\">大黄姜</a><span style=\"font-family: &quot;Microsoft YaHei&quot;; font-size: 14px; background-color: rgb(255, 255, 255);\">,</span><a href=\"http://www.nongnet.com/tag_2231.aspx\" target=\"_blank\" class=\"distag\" style=\"text-decoration-line: none; color: rgb(0, 0, 0); font-family: &quot;Microsoft YaHei&quot;; font-size: 14px; white-space: normal; background-color: rgb(255, 255, 255);\">小黄姜</a><span style=\"font-family: &quot;Microsoft YaHei&quot;; font-size: 14px; background-color: rgb(255, 255, 255);\">,鲜姜,姜母,</span><a href=\"http://www.nongnet.com/tag_17817.aspx\" target=\"_blank\" class=\"distag\" style=\"text-decoration-line: none; color: rgb(0, 0, 0); font-family: &quot;Microsoft YaHei&quot;; font-size: 14px; white-space: normal; background-color: rgb(255, 255, 255);\">水洗姜</a><span style=\"font-family: &quot;Microsoft YaHei&quot;; font-size: 14px; background-color: rgb(255, 255, 255);\">等】货源充足,品质有保障。我地所产生姜色泽鲜黄,辣味浓厚,姜块肥大</span></p>', '2021-12-07 21:58:30');
INSERT INTO `product` VALUES ('19', '348', '上好花椒', '348', '/FruitShop/resources/upload/1638885559022.jpg', '60.00', '1000', '0', '3', '0', '<p><span style=\"font-family: &quot;Microsoft YaHei&quot;; font-size: 14px; background-color: rgb(255, 255, 255);\">花椒500克/袋,1000克/袋</span></p>', '2021-12-17 21:59:58');
INSERT INTO `product` VALUES ('21', '352', '丰庄园原生冷榨高油酸花生油', 'null,352', '/FruitShop/resources/upload/1638887076032.jpg', '120.00', '98', '2', '2', '1', '<p><span style=\"font-family: &quot;Microsoft YaHei&quot;; font-size: 14px; background-color: rgb(255, 255, 255);\">该</span><a href=\"http://www.nongnet.com/tag_223.aspx\" target=\"_blank\" class=\"distag\" style=\"text-decoration-line: none; color: rgb(0, 0, 0); font-family: &quot;Microsoft YaHei&quot;; font-size: 14px; white-space: normal; background-color: rgb(255, 255, 255);\">花生油</a><span style=\"font-family: &quot;Microsoft YaHei&quot;; font-size: 14px; background-color: rgb(255, 255, 255);\">与</span><a href=\"http://www.nongnet.com/tag_1766.aspx\" target=\"_blank\" class=\"distag\" style=\"text-decoration-line: none; color: rgb(0, 0, 0); font-family: &quot;Microsoft YaHei&quot;; font-size: 14px; white-space: normal; background-color: rgb(255, 255, 255);\">橄榄油</a><span style=\"font-family: &quot;Microsoft YaHei&quot;; font-size: 14px; background-color: rgb(255, 255, 255);\">一样具有75%以上的油酸含量,原料花生产自东北,降低黄曲霉的风险,先进德国冷榨工艺,原滋原味,无仼何添加,最大程度地保留了营养。</span></p><p><span style=\"font-family: &quot;Microsoft YaHei&quot;; font-size: 14px; background-color: rgb(255, 255, 255);\"><img src=\"/FruitShop/resources/upload/image/20211207/1638887094220065434.jpg\" title=\"1638887094220065434.jpg\" alt=\"111.jpg\"/></span></p>', '2021-12-07 22:24:56');
INSERT INTO `product` VALUES ('23', '352', '花生米8元每斤', 'null,352', '/FruitShop/resources/upload/1638888504302.jpg', '8.00', '1000', '22', '0', '0', '<p>花生米8元每斤花生米8元每斤花生米8元每斤花生米8元每斤花生米8元每斤花生米8元每斤花生米8元每斤花生米8元每斤</p><p><img src=\"/FruitShop/resources/upload/image/20211207/1638888527094034964.jpg\" title=\"1638888527094034964.jpg\" alt=\"xx_d6ughnygqv4d39e53.jpg\"/></p>', '2021-12-07 22:48:49');
INSERT INTO `product` VALUES ('24', '349', '熟冻海螺头肉鲜活新鲜去壳冷冻大海螺肉去内脏贝类', 'null,349', '/FruitShop/resources/upload/1639057976352.jpg', '12.00', '111', '0', '0', '0', '<p>商品属性</p><p><span class=\"next-icon next-icon-arrow-down next-xxs\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px -4px; padding: 0px; outline: none; display: inline-block; font-family: NextIcon; -webkit-font-smoothing: antialiased; transform: scale(0.5);\"></span></p><p><span class=\"offer-attr-item-name\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; width: 150px; font-size: 12px; color: rgb(153, 153, 153);\">品种</span><span class=\"offer-attr-item-value\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; flex: 1 1 0%; font-size: 12px; overflow: hidden; text-overflow: ellipsis;\">海螺</span></p><p><span class=\"offer-attr-item-name\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; width: 150px; font-size: 12px; color: rgb(153, 153, 153);\">是否进口</span><span class=\"offer-attr-item-value\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; flex: 1 1 0%; font-size: 12px; overflow: hidden; text-overflow: ellipsis;\">否</span></p><p><span class=\"offer-attr-item-name\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; width: 150px; font-size: 12px; color: rgb(153, 153, 153);\">品牌</span><span class=\"offer-attr-item-value\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; flex: 1 1 0%; font-size: 12px; overflow: hidden; text-overflow: ellipsis;\">其他</span></p><p><span class=\"offer-attr-item-name\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; width: 150px; font-size: 12px; color: rgb(153, 153, 153);\">用途</span><span class=\"offer-attr-item-value\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; flex: 1 1 0%; font-size: 12px; overflow: hidden; text-overflow: ellipsis;\">食用</span></p><p><span class=\"offer-attr-item-name\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; width: 150px; font-size: 12px; color: rgb(153, 153, 153);\">生长方式</span><span class=\"offer-attr-item-value\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; flex: 1 1 0%; font-size: 12px; overflow: hidden; text-overflow: ellipsis;\">野生</span></p><p><span class=\"offer-attr-item-name\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; width: 150px; font-size: 12px; color: rgb(153, 153, 153);\">生长环境</span><span class=\"offer-attr-item-value\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; flex: 1 1 0%; font-size: 12px; overflow: hidden; text-overflow: ellipsis;\">海水</span></p><p><span class=\"offer-attr-item-name\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; width: 150px; font-size: 12px; color: rgb(153, 153, 153);\">生产率</span><span class=\"offer-attr-item-value\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; flex: 1 1 0%; font-size: 12px; overflow: hidden; text-overflow: ellipsis;\">99(%)</span></p><p><span class=\"offer-attr-item-name\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; width: 150px; font-size: 12px; color: rgb(153, 153, 153);\">成活率≥</span><span class=\"offer-attr-item-value\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; flex: 1 1 0%; font-size: 12px; overflow: hidden; text-overflow: ellipsis;\">0(%)</span></p><p><span class=\"offer-attr-item-name\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; width: 150px; font-size: 12px; color: rgb(153, 153, 153);\">食品工艺</span><span class=\"offer-attr-item-value\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; flex: 1 1 0%; font-size: 12px; overflow: hidden; text-overflow: ellipsis;\">冷冻水产</span></p><p><span class=\"offer-attr-item-name\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; width: 150px; font-size: 12px; color: rgb(153, 153, 153);\">原产地</span><span class=\"offer-attr-item-value\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; flex: 1 1 0%; font-size: 12px; overflow: hidden; text-overflow: ellipsis;\">山东</span></p><p><span class=\"offer-attr-item-name\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; width: 150px; font-size: 12px; color: rgb(153, 153, 153);\">有无中文标签</span><span class=\"offer-attr-item-value\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; flex: 1 1 0%; font-size: 12px; overflow: hidden; text-overflow: ellipsis;\">无</span></p><p><span class=\"offer-attr-item-name\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; width: 150px; font-size: 12px; color: rgb(153, 153, 153);\">包装方式</span><span class=\"offer-attr-item-value\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; flex: 1 1 0%; font-size: 12px; overflow: hidden; text-overflow: ellipsis;\">食用农产品</span></p><p><span class=\"offer-attr-item-name\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; width: 150px; font-size: 12px; color: rgb(153, 153, 153);\">储藏方法</span><span class=\"offer-attr-item-value\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; flex: 1 1 0%; font-size: 12px; overflow: hidden; text-overflow: ellipsis;\">冷冻</span></p><p><span class=\"offer-attr-item-name\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; width: 150px; font-size: 12px; color: rgb(153, 153, 153);\">净重(规格)</span><span class=\"offer-attr-item-value\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; flex: 1 1 0%; font-size: 12px; overflow: hidden; text-overflow: ellipsis;\">500(g)</span></p><p><span class=\"offer-attr-item-name\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; width: 150px; font-size: 12px; color: rgb(153, 153, 153);\">货号</span><span class=\"offer-attr-item-value\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; flex: 1 1 0%; font-size: 12px; overflow: hidden; text-overflow: ellipsis;\">U877878</span></p><p><br/></p>', '2021-12-09 21:53:30');
INSERT INTO `product` VALUES ('26', '349', '海虾海鲜基围虾青虾整箱', 'null,349', '/FruitShop/resources/upload/1639058058774.jpg', '89.00', '111', '0', '0', '0', '<p>商品属性</p><p><span class=\"next-icon next-icon-arrow-down next-xxs\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px -4px; padding: 0px; outline: none; display: inline-block; font-family: NextIcon; -webkit-font-smoothing: antialiased; transform: scale(0.5);\"></span></p><p><span class=\"offer-attr-item-name\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; width: 150px; font-size: 12px; color: rgb(153, 153, 153);\">品种</span><span class=\"offer-attr-item-value\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; flex: 1 1 0%; font-size: 12px; overflow: hidden; text-overflow: ellipsis;\">大虾</span></p><p><span class=\"offer-attr-item-name\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; width: 150px; font-size: 12px; color: rgb(153, 153, 153);\">货号</span><span class=\"offer-attr-item-value\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; flex: 1 1 0%; font-size: 12px; overflow: hidden; text-overflow: ellipsis;\">010</span></p><p><span class=\"offer-attr-item-name\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; width: 150px; font-size: 12px; color: rgb(153, 153, 153);\">是否进口</span><span class=\"offer-attr-item-value\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; flex: 1 1 0%; font-size: 12px; overflow: hidden; text-overflow: ellipsis;\">否</span></p><p><span class=\"offer-attr-item-name\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; width: 150px; font-size: 12px; color: rgb(153, 153, 153);\">品牌</span><span class=\"offer-attr-item-value\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; flex: 1 1 0%; font-size: 12px; overflow: hidden; text-overflow: ellipsis;\">其他</span></p><p><span class=\"offer-attr-item-name\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; width: 150px; font-size: 12px; color: rgb(153, 153, 153);\">用途</span><span class=\"offer-attr-item-value\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; flex: 1 1 0%; font-size: 12px; overflow: hidden; text-overflow: ellipsis;\">食用</span></p><p><span class=\"offer-attr-item-name\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; width: 150px; font-size: 12px; color: rgb(153, 153, 153);\">规格</span><span class=\"offer-attr-item-value\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; flex: 1 1 0%; font-size: 12px; overflow: hidden; text-overflow: ellipsis;\">31~40</span></p><p><span class=\"offer-attr-item-name\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; width: 150px; font-size: 12px; color: rgb(153, 153, 153);\">成活率</span><span class=\"offer-attr-item-value\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; flex: 1 1 0%; font-size: 12px; overflow: hidden; text-overflow: ellipsis;\">10(%)</span></p><p><span class=\"offer-attr-item-name\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; width: 150px; font-size: 12px; color: rgb(153, 153, 153);\">生长方式</span><span class=\"offer-attr-item-value\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; flex: 1 1 0%; font-size: 12px; overflow: hidden; text-overflow: ellipsis;\">野生</span></p><p><span class=\"offer-attr-item-name\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; width: 150px; font-size: 12px; color: rgb(153, 153, 153);\">生长环境</span><span class=\"offer-attr-item-value\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; flex: 1 1 0%; font-size: 12px; overflow: hidden; text-overflow: ellipsis;\">海水</span></p><p><span class=\"offer-attr-item-name\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; width: 150px; font-size: 12px; color: rgb(153, 153, 153);\">体长</span><span class=\"offer-attr-item-value\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; flex: 1 1 0%; font-size: 12px; overflow: hidden; text-overflow: ellipsis;\">12(cm)</span></p><p><span class=\"offer-attr-item-name\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; width: 150px; font-size: 12px; color: rgb(153, 153, 153);\">挥发性盐基氮</span><span class=\"offer-attr-item-value\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; flex: 1 1 0%; font-size: 12px; overflow: hidden; text-overflow: ellipsis;\">10(mg/kg)</span></p><p><span class=\"offer-attr-item-name\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; width: 150px; font-size: 12px; color: rgb(153, 153, 153);\">食品工艺</span><span class=\"offer-attr-item-value\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; flex: 1 1 0%; font-size: 12px; overflow: hidden; text-overflow: ellipsis;\">冷冻水产</span></p><p><br/></p>', '2021-12-09 21:54:38');
INSERT INTO `product` VALUES ('27', '349', '海虾海鲜基围虾青虾整箱', 'null,349', '/FruitShop/resources/upload/1639058058774.jpg', '89.00', '111', '0', '0', '0', '<p>商品属性</p><p><span class=\"next-icon next-icon-arrow-down next-xxs\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px -4px; padding: 0px; outline: none; display: inline-block; font-family: NextIcon; -webkit-font-smoothing: antialiased; transform: scale(0.5);\"></span></p><p><span class=\"offer-attr-item-name\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; width: 150px; font-size: 12px; color: rgb(153, 153, 153);\">品种</span><span class=\"offer-attr-item-value\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; flex: 1 1 0%; font-size: 12px; overflow: hidden; text-overflow: ellipsis;\">大虾</span></p><p><span class=\"offer-attr-item-name\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; width: 150px; font-size: 12px; color: rgb(153, 153, 153);\">货号</span><span class=\"offer-attr-item-value\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; flex: 1 1 0%; font-size: 12px; overflow: hidden; text-overflow: ellipsis;\">010</span></p><p><span class=\"offer-attr-item-name\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; width: 150px; font-size: 12px; color: rgb(153, 153, 153);\">是否进口</span><span class=\"offer-attr-item-value\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; flex: 1 1 0%; font-size: 12px; overflow: hidden; text-overflow: ellipsis;\">否</span></p><p><span class=\"offer-attr-item-name\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; width: 150px; font-size: 12px; color: rgb(153, 153, 153);\">品牌</span><span class=\"offer-attr-item-value\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; flex: 1 1 0%; font-size: 12px; overflow: hidden; text-overflow: ellipsis;\">其他</span></p><p><span class=\"offer-attr-item-name\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; width: 150px; font-size: 12px; color: rgb(153, 153, 153);\">用途</span><span class=\"offer-attr-item-value\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; flex: 1 1 0%; font-size: 12px; overflow: hidden; text-overflow: ellipsis;\">食用</span></p><p><span class=\"offer-attr-item-name\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; width: 150px; font-size: 12px; color: rgb(153, 153, 153);\">规格</span><span class=\"offer-attr-item-value\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; flex: 1 1 0%; font-size: 12px; overflow: hidden; text-overflow: ellipsis;\">31~40</span></p><p><span class=\"offer-attr-item-name\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; width: 150px; font-size: 12px; color: rgb(153, 153, 153);\">成活率</span><span class=\"offer-attr-item-value\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; flex: 1 1 0%; font-size: 12px; overflow: hidden; text-overflow: ellipsis;\">10(%)</span></p><p><span class=\"offer-attr-item-name\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; width: 150px; font-size: 12px; color: rgb(153, 153, 153);\">生长方式</span><span class=\"offer-attr-item-value\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; flex: 1 1 0%; font-size: 12px; overflow: hidden; text-overflow: ellipsis;\">野生</span></p><p><span class=\"offer-attr-item-name\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; width: 150px; font-size: 12px; color: rgb(153, 153, 153);\">生长环境</span><span class=\"offer-attr-item-value\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; flex: 1 1 0%; font-size: 12px; overflow: hidden; text-overflow: ellipsis;\">海水</span></p><p><span class=\"offer-attr-item-name\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; width: 150px; font-size: 12px; color: rgb(153, 153, 153);\">体长</span><span class=\"offer-attr-item-value\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; flex: 1 1 0%; font-size: 12px; overflow: hidden; text-overflow: ellipsis;\">12(cm)</span></p><p><span class=\"offer-attr-item-name\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; width: 150px; font-size: 12px; color: rgb(153, 153, 153);\">挥发性盐基氮</span><span class=\"offer-attr-item-value\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; flex: 1 1 0%; font-size: 12px; overflow: hidden; text-overflow: ellipsis;\">10(mg/kg)</span></p><p><span class=\"offer-attr-item-name\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; width: 150px; font-size: 12px; color: rgb(153, 153, 153);\">食品工艺</span><span class=\"offer-attr-item-value\" style=\"box-sizing: border-box; text-size-adjust: 100%; -webkit-tap-highlight-color: transparent; margin: 0px; padding: 0px 20px 0px 0px; outline: none; flex: 1 1 0%; font-size: 12px; overflow: hidden; text-overflow: ellipsis;\">冷冻水产</span></p><p><br/></p>', '2021-12-09 21:54:38');

-- ----------------------------
-- Table structure for product_category
-- ----------------------------
DROP TABLE IF EXISTS `product_category`;
CREATE TABLE `product_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parentId` int(11) DEFAULT NULL,
  `name` varchar(128) NOT NULL,
  `tags` varchar(32) DEFAULT NULL,
  `remark` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=355 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of product_category
-- ----------------------------
INSERT INTO `product_category` VALUES ('1', null, '当季水果', null, '当季水果');
INSERT INTO `product_category` VALUES ('2', '1', '当季水果', '1', '');
INSERT INTO `product_category` VALUES ('13', '10', '当季水果', '10', '高热量');
INSERT INTO `product_category` VALUES ('14', '13', '当季水果', '1,13', '当季水果');
INSERT INTO `product_category` VALUES ('345', null, '食品', null, '食品/粮油/酒类/茶饮');
INSERT INTO `product_category` VALUES ('346', '345', '零食', '345', '');
INSERT INTO `product_category` VALUES ('347', '345', '干货', '345', '');
INSERT INTO `product_category` VALUES ('348', null, '蔬菜', null, '');
INSERT INTO `product_category` VALUES ('349', null, '鲜活水产', null, '');
INSERT INTO `product_category` VALUES ('350', null, '家禽肉类', null, '');
INSERT INTO `product_category` VALUES ('351', null, '自制熟食', null, '');
INSERT INTO `product_category` VALUES ('352', null, '粮油茶酒', null, '');
INSERT INTO `product_category` VALUES ('353', null, '办公用具', null, '');
INSERT INTO `product_category` VALUES ('354', null, '生活调料', null, '');

-- ----------------------------
-- Table structure for purse
-- ----------------------------
DROP TABLE IF EXISTS `purse`;
CREATE TABLE `purse` (
  `id` int(50) NOT NULL AUTO_INCREMENT,
  `userId` int(50) NOT NULL,
  `recharge` double(10,0) DEFAULT NULL,
  `state` int(10) NOT NULL,
  `createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of purse
-- ----------------------------
INSERT INTO `purse` VALUES ('16', '9', '500', '1', '2021-12-09 16:57:51');
INSERT INTO `purse` VALUES ('17', '9', '500', '1', '2021-12-09 17:18:43');
INSERT INTO `purse` VALUES ('18', '9', '500', '1', '2021-12-09 18:23:25');
INSERT INTO `purse` VALUES ('19', '9', '500', '1', '2021-12-20 12:00:32');
INSERT INTO `purse` VALUES ('20', '11', '4343', '1', '2021-12-20 16:19:08');
INSERT INTO `purse` VALUES ('21', '11', '1', '1', '2021-12-20 16:45:04');
INSERT INTO `purse` VALUES ('22', '11', '1', '1', '2021-12-20 16:52:02');
INSERT INTO `purse` VALUES ('23', '11', '10', '1', '2021-12-20 16:57:39');
INSERT INTO `purse` VALUES ('24', '12', '50', '1', '2021-12-09 10:31:09');
INSERT INTO `purse` VALUES ('25', '13', '600', '1', '2021-12-09 15:32:41');
INSERT INTO `purse` VALUES ('26', '13', '600', '1', '2021-12-09 16:54:16');
INSERT INTO `purse` VALUES ('27', '8', '10000', '0', '2021-12-11 16:47:32');
INSERT INTO `purse` VALUES ('28', '14', '100', '1', '2021-12-09 19:23:45');
INSERT INTO `purse` VALUES ('29', '15', '900', '1', '2021-12-09 17:02:00');
INSERT INTO `purse` VALUES ('30', '16', '2000', '1', '2021-12-11 10:17:19');

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `remark` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of role
-- ----------------------------
INSERT INTO `role` VALUES ('1', '超级管理员', '超级管理员拥有一切权限!');
INSERT INTO `role` VALUES ('2', '普通用户', '普通用户,请自由授权!');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(32) NOT NULL,
  `password` varchar(32) NOT NULL,
  `roleId` int(11) NOT NULL,
  `photo` varchar(128) DEFAULT NULL,
  `sex` int(1) NOT NULL DEFAULT '0',
  `age` int(3) NOT NULL DEFAULT '0',
  `address` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `roleId` (`roleId`) USING BTREE,
  CONSTRAINT `user_ibfk_1` FOREIGN KEY (`roleId`) REFERENCES `role` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', 'admin', 'admin', '1', '/FruitShop/resources/upload/1638176819944.jpg', '1', '1', '南京');
INSERT INTO `user` VALUES ('13', '孙自钱', '123456', '2', '/FruitShop/resources/upload/1592739987974.png', '1', '1', '哈哈');

选题背景:

进入21世纪以来,世界经济正在发生令人瞩目的变革。科学技术的进步使 人类社会、经济、文化生活不断出现新的事物和变化。Internet正以其强大的 优势进入到日常生活的各个角落,使人类的经济生活方式发生了深刻变革。随 着互联网以及各项相关技术的日趋成熟,电子商务在社会经济领域得到了广泛 的应用叫

在过去的十几年里,由于信息网络技术快速的发展,电子商务发展迅速, 并迅速占领了上万亿美金的市场份额。电子商务的发展推动了商业、贸易、营 销、金融、广告运输、教育等社会经济领域的创新冋。网上购物系统随着电子 商务的发展而迅速在互联网上广泛应用,其迅速、高效和低成本的优点为企业 提高了工作效率和经济效益。网上购物系统正成为许多传统商业企业改变自己 经营模式的一个平台⑷。

以****科技学院为例,校园占地2000亩,目前常住在校学生人数大概 20000人左右,临时专训人员及校内的教职工,常住人数超过2万。学生公寓 南区和北区分别有一个150平米的小型超市。由于学生日常学习生活比较繁 忙,购物时间相对集中在课间和休息时间,所以每次去超市选购商品及结账都 需要排队,浪费的时间较多,根据师生员工的实际需求以及响应校园的信息化 建设工程,很需要搭建一个网上购物的电子商务平台。

 

Copyright © 2010-2022 dgrt.cn 版权所有 |关于我们| 联系方式