基于jsp+springboot的易卖网商城源码

最新推荐文章于 2024-05-11 20:08:31 发布

qq_1406299528

最新推荐文章于 2024-05-11 20:08:31 发布

阅读量989

点赞数

分类专栏： java 计算机毕业设计 springboot 文章标签： eclipse spring maven java tomcat

本文链接：https://blog.csdn.net/qq_1406299528/article/details/118885757

版权

java 同时被 3 个专栏收录

1094 篇文章 18 订阅

订阅专栏

计算机毕业设计

540 篇文章 131 订阅

订阅专栏

springboot

99 篇文章 6 订阅

订阅专栏

技术：jsp，springboot，mysql
账号admin 密码123456

首页地址：http://localhost:8080/Home?action=index

效果图：

请添加图片描述

数据库设计：

/*
Navicat MySQL Data Transfer

Source Server : 阶段4
Source Server Version : 50549
Source Host : localhost:3306
Source Database : easybuy

Target Server Type : MYSQL
Target Server Version : 50549
File Encoding : 65001

Date: 2018-11-11 20:15:52
*/

SET FOREIGN_KEY_CHECKS=0;

– Table structure for easybuy_news

DROP TABLE IF EXISTS easybuy_news;
CREATE TABLE easybuy_news (
id int(10) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
title varchar(40) NOT NULL COMMENT ‘标题’,
content varchar(1000) NOT NULL COMMENT ‘内容’,
createTime varchar(10) NOT NULL COMMENT ‘创建时间’,
PRIMARY KEY (id),
UNIQUE KEY PK__EASYBUY___C63B5EE724927208 (id),
UNIQUE KEY UQ__EASYBUY___C12AD09D276EDEB3 (title)
) ENGINE=InnoDB AUTO_INCREMENT=704 DEFAULT CHARSET=utf8;

– Records of easybuy_news

INSERT INTO easybuy_news VALUES (‘531’, ‘会员特惠月开始了’, ‘会员特惠月开始了,亲们赶快下单啊,不到剁手誓不罢休啊,不到离婚誓不清空购物车啊。更多优惠，尽在易买网。’, ‘2010-12-22’);
INSERT INTO easybuy_news VALUES (‘597’, ‘迎双旦促销大酬宾’, ‘迎双旦促销大酬宾’, ‘2010-12-24’);
INSERT INTO easybuy_news VALUES (‘649’, ‘加入会员，赢千万大礼包’, ‘加入会员，赢千万大礼包’, ‘2010-12-22’);
INSERT INTO easybuy_news VALUES (‘650’, ‘新年不夜天，通宵也是开张了’, ‘新年不夜天，通宵也是开张了’, ‘2011-05-22’);
INSERT INTO easybuy_news VALUES (‘651’, ‘积分兑换开始了’, ‘积分兑换开始了’, ‘2010-12-22’);
INSERT INTO easybuy_news VALUES (‘653’, ‘团购阿迪1折起’, ‘团购阿迪1折起’, ‘2010-12-22’);
INSERT INTO easybuy_news VALUES (‘664’, ‘最新酷睿笔记本’, ‘IBME系列全场促销中，最新酷睿双核处理器，保证CPU更高效的运转。’, ‘2013-08-05’);
INSERT INTO easybuy_news VALUES (‘675’, ‘aa’, ‘012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789’, ‘2013-08-14’);
INSERT INTO easybuy_news VALUES (‘676’, ‘ResultR’, ‘ResultResultResultResultResu’, ‘2016-03-28’);
INSERT INTO easybuy_news VALUES (‘677’, ‘会员特惠月开始了1’, ‘会员特惠月开始了’, ‘2010-12-22’);
INSERT INTO easybuy_news VALUES (‘678’, ‘迎双旦促销大酬宾2’, ‘迎双旦促销大酬宾’, ‘2010-12-24’);
INSERT INTO easybuy_news VALUES (‘679’, ‘加入会员，赢千万大礼包3’, ‘加入会员，赢千万大礼包’, ‘2010-12-22’);
INSERT INTO easybuy_news VALUES (‘680’, ‘新年不夜天，通宵也是开张了4’, ‘新年不夜天，通宵也是开张了’, ‘2011-05-22’);
INSERT INTO easybuy_news VALUES (‘681’, ‘积分兑换开始了5’, ‘积分兑换开始了’, ‘2010-12-22’);
INSERT INTO easybuy_news VALUES (‘682’, ‘团购阿迪1折起6’, ‘团购阿迪1折起’, ‘2010-12-22’);
INSERT INTO easybuy_news VALUES (‘683’, ‘最新酷睿笔记本7’, ‘IBME系列全场促销中，最新酷睿双核处理器，保证CPU更高效的运转。’, ‘2013-08-05’);
INSERT INTO easybuy_news VALUES (‘684’, ‘aa8’, ‘012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789’, ‘2013-08-14’);
INSERT INTO easybuy_news VALUES (‘685’, ‘ResultR9’, ‘ResultResultResultResultResu’, ‘2016-03-28’);
INSERT INTO easybuy_news VALUES (‘686’, ‘会员特惠月开始了11’, ‘会员特惠月开始了’, ‘2010-12-22’);
INSERT INTO easybuy_news VALUES (‘687’, ‘迎双旦促销大酬宾21’, ‘迎双旦促销大酬宾’, ‘2010-12-24’);
INSERT INTO easybuy_news VALUES (‘688’, ‘加入会员，赢千万大礼包31’, ‘加入会员，赢千万大礼包’, ‘2010-12-22’);
INSERT INTO easybuy_news VALUES (‘689’, ‘新年不夜天，通宵也是开张了41’, ‘新年不夜天，通宵也是开张了’, ‘2011-05-22’);
INSERT INTO easybuy_news VALUES (‘690’, ‘积分兑换开始了51’, ‘积分兑换开始了’, ‘2010-12-22’);
INSERT INTO easybuy_news VALUES (‘691’, ‘团购阿迪1折起61’, ‘团购阿迪1折起’, ‘2010-12-22’);
INSERT INTO easybuy_news VALUES (‘692’, ‘最新酷睿笔记本71’, ‘IBME系列全场促销中，最新酷睿双核处理器，保证CPU更高效的运转。’, ‘2013-08-05’);
INSERT INTO easybuy_news VALUES (‘693’, ‘aa81’, ‘012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789’, ‘2013-08-14’);
INSERT INTO easybuy_news VALUES (‘694’, ‘ResultR91’, ‘ResultResultResultResultResu’, ‘2016-03-28’);
INSERT INTO easybuy_news VALUES (‘695’, ‘会员特惠月开始了111’, ‘会员特惠月开始了’, ‘2010-12-22’);
INSERT INTO easybuy_news VALUES (‘696’, ‘迎双旦促销大酬宾211’, ‘迎双旦促销大酬宾’, ‘2010-12-24’);
INSERT INTO easybuy_news VALUES (‘697’, ‘加入会员，赢千万大礼包311’, ‘加入会员，赢千万大礼包’, ‘2010-12-22’);
INSERT INTO easybuy_news VALUES (‘698’, ‘新年不夜天，通宵也是开张了411’, ‘新年不夜天，通宵也是开张了’, ‘2011-05-22’);
INSERT INTO easybuy_news VALUES (‘699’, ‘积分兑换开始了511’, ‘积分兑换开始了’, ‘2010-12-22’);
INSERT INTO easybuy_news VALUES (‘700’, ‘团购阿迪1折起611’, ‘团购阿迪1折起’, ‘2010-12-22’);
INSERT INTO easybuy_news VALUES (‘701’, ‘最新酷睿笔记本711’, ‘IBME系列全场促销中，最新酷睿双核处理器，保证CPU更高效的运转。’, ‘2013-08-05’);
INSERT INTO easybuy_news VALUES (‘702’, ‘aa811’, ‘012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789’, ‘2013-08-14’);
INSERT INTO easybuy_news VALUES (‘703’, ‘ResultR911’, ‘ResultResultResultResultResu’, ‘2016-03-28’);

– Table structure for easybuy_order

DROP TABLE IF EXISTS easybuy_order;
CREATE TABLE easybuy_order (
id int(11) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
userId int(255) DEFAULT NULL COMMENT ‘用户主键’,
loginName varchar(255) DEFAULT NULL,
userAddress varchar(255) DEFAULT NULL COMMENT ‘用户地址’,
createTime datetime DEFAULT NULL COMMENT ‘创建时间’,
cost float DEFAULT NULL COMMENT ‘总消费’,
serialNumber varchar(255) DEFAULT NULL COMMENT ‘订单号’,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8;

– Records of easybuy_order

INSERT INTO easybuy_order VALUES (‘1’, ‘18’, ‘shangzezhong’, ‘北京市花园路小区’, ‘2016-06-02 14:51:46’, ‘1721’, ‘60B7487F47F9434EAA5FD1D9E22CB06C’);
INSERT INTO easybuy_order VALUES (‘2’, ‘18’, ‘shangzezhong’, ‘北京市海淀区成府路’, ‘2016-06-02 14:52:49’, ‘8596’, ‘8EF5E1557D55413781658A65FC301B8A’);
INSERT INTO easybuy_order VALUES (‘3’, ‘2’, ‘admin’, ‘北京市海淀区大有庄’, ‘2016-06-03 11:41:09’, ‘456’, ‘51718726C1274CC59504AB4E6FD64BA0’);
INSERT INTO easybuy_order VALUES (‘6’, ‘2’, ‘admin’, ‘123’, ‘2018-11-10 03:17:02’, ‘456’, null);
INSERT INTO easybuy_order VALUES (‘7’, ‘2’, ‘admin’, ‘123’, ‘2018-11-10 03:17:06’, ‘456’, null);
INSERT INTO easybuy_order VALUES (‘8’, ‘2’, ‘admin’, ‘123’, ‘2018-11-10 03:17:08’, ‘456’, null);
INSERT INTO easybuy_order VALUES (‘10’, ‘2’, ‘admin’, ‘123’, ‘2018-11-10 03:17:24’, ‘456’, null);
INSERT INTO easybuy_order VALUES (‘11’, ‘2’, ‘admin’, ‘123’, ‘2018-11-10 03:17:24’, ‘456’, null);
INSERT INTO easybuy_order VALUES (‘12’, ‘2’, ‘admin’, ‘123’, ‘2018-11-10 03:17:24’, ‘456’, null);
INSERT INTO easybuy_order VALUES (‘13’, ‘2’, ‘admin’, ‘123’, ‘2018-11-10 03:17:24’, ‘456’, null);
INSERT INTO easybuy_order VALUES (‘14’, ‘2’, ‘admin’, ‘123’, ‘2018-11-10 03:17:25’, ‘456’, null);
INSERT INTO easybuy_order VALUES (‘38’, ‘2’, ‘admin’, ‘123’, ‘2018-11-10 03:43:58’, ‘304’, null);
INSERT INTO easybuy_order VALUES (‘39’, ‘2’, ‘admin’, ‘123’, ‘2018-11-10 03:53:28’, ‘304’, null);
INSERT INTO easybuy_order VALUES (‘40’, ‘2’, ‘admin’, ‘weq’, ‘2018-11-10 03:57:56’, ‘608’, null);
INSERT INTO easybuy_order VALUES (‘41’, ‘2’, ‘admin’, ‘asdfd’, ‘2018-11-10 04:03:12’, ‘304’, null);
INSERT INTO easybuy_order VALUES (‘42’, ‘2’, ‘admin’, ‘asdfd’, ‘2018-11-10 04:03:15’, ‘304’, null);
INSERT INTO easybuy_order VALUES (‘43’, ‘2’, ‘admin’, ‘zxcvzxcv’, ‘2018-11-10 04:04:55’, ‘152’, null);
INSERT INTO easybuy_order VALUES (‘44’, ‘2’, ‘admin’, ‘23423’, ‘2018-11-10 06:38:17’, ‘912’, ‘34e6dd23-e4b3-11e8-8eba-089e0140db8a’);
INSERT INTO easybuy_order VALUES (‘45’, ‘2’, ‘admin’, ‘213’, ‘2018-11-10 07:00:58’, ‘308’, ‘60129552-e4b6-11e8-8eba-089e0140db8a’);
INSERT INTO easybuy_order VALUES (‘46’, ‘2’, ‘admin’, ‘213’, ‘2018-11-10 07:07:13’, ‘304’, ‘3fd7b5d7-e4b7-11e8-8eba-089e0140db8a’);
INSERT INTO easybuy_order VALUES (‘47’, ‘2’, ‘admin’, ‘123’, ‘2018-11-10 07:09:44’, ‘152’, null);
INSERT INTO easybuy_order VALUES (‘48’, ‘2’, ‘admin’, ‘123asdf’, ‘2018-11-10 07:13:33’, ‘589’, null);
INSERT INTO easybuy_order VALUES (‘49’, ‘2’, ‘admin’, ‘123’, ‘2018-11-10 07:17:38’, ‘158’, null);
INSERT INTO easybuy_order VALUES (‘50’, ‘2’, ‘admin’, ‘123’, ‘2018-11-10 07:17:38’, ‘158’, ‘b437d747e4b811e88eba089e0140db8a’);
INSERT INTO easybuy_order VALUES (‘51’, ‘2’, ‘admin’, ‘123’, ‘2018-11-10 07:57:15’, ‘152’, ‘3cb15fed-e4be-11e8-8eba-089e0140db8a’);
INSERT INTO easybuy_order VALUES (‘52’, ‘2’, ‘admin’, ‘123’, ‘2018-11-11 11:51:30’, ‘152’, ‘12fd2175-e565-11e8-a1f1-089e0140db8a’);
INSERT INTO easybuy_order VALUES (‘53’, ‘2’, ‘admin’, ‘2312’, ‘2018-11-11 20:11:47’, ‘11028’, ‘f5b66747-e5aa-11e8-a1f1-089e0140db8a’);

– Table structure for easybuy_order_detail

DROP TABLE IF EXISTS easybuy_order_detail;
CREATE TABLE easybuy_order_detail (
id int(10) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
orderId int(10) NOT NULL COMMENT ‘订单主键’,
productId int(10) NOT NULL COMMENT ‘商品主键’,
quantity int(10) NOT NULL COMMENT ‘数量’,
cost float NOT NULL COMMENT ‘消费’,
PRIMARY KEY (id),
UNIQUE KEY PK__EASYBUY___66E1BD8E2F10007B (id)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

– Records of easybuy_order_detail

INSERT INTO easybuy_order_detail VALUES (‘1’, ‘1’, ‘733’, ‘5’, ‘760’);
INSERT INTO easybuy_order_detail VALUES (‘2’, ‘1’, ‘734’, ‘4’, ‘608’);
INSERT INTO easybuy_order_detail VALUES (‘3’, ‘1’, ‘735’, ‘1’, ‘152’);
INSERT INTO easybuy_order_detail VALUES (‘4’, ‘1’, ‘738’, ‘1’, ‘45’);
INSERT INTO easybuy_order_detail VALUES (‘5’, ‘1’, ‘739’, ‘1’, ‘156’);
INSERT INTO easybuy_order_detail VALUES (‘6’, ‘2’, ‘755’, ‘1’, ‘8596’);
INSERT INTO easybuy_order_detail VALUES (‘7’, ‘3’, ‘733’, ‘1’, ‘152’);
INSERT INTO easybuy_order_detail VALUES (‘8’, ‘3’, ‘734’, ‘1’, ‘152’);
INSERT INTO easybuy_order_detail VALUES (‘9’, ‘3’, ‘735’, ‘1’, ‘152’);

– Table structure for easybuy_product

DROP TABLE IF EXISTS easybuy_product;
CREATE TABLE easybuy_product (
id int(10) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
name varchar(20) NOT NULL COMMENT ‘名称’,
description varchar(1024) DEFAULT NULL COMMENT ‘描述’,
price float NOT NULL COMMENT ‘价格’,
stock int(10) NOT NULL COMMENT ‘库存’,
categoryLevel1Id int(10) DEFAULT NULL COMMENT ‘分类1’,
categoryLevel2Id int(10) DEFAULT NULL COMMENT ‘分类2’,
categoryLevel3Id int(10) DEFAULT NULL COMMENT ‘分类3’,
fileName varchar(200) DEFAULT NULL COMMENT ‘文件名称’,
isDelete int(1) DEFAULT ‘0’ COMMENT ‘是否删除(1：删除 0：未删除)’,
PRIMARY KEY (id),
UNIQUE KEY PK__EASYBUY___94F6E55132E0915F (id)
) ENGINE=InnoDB AUTO_INCREMENT=772 DEFAULT CHARSET=utf8;

– Records of easybuy_product

INSERT INTO easybuy_product VALUES (‘733’, ‘香奈儿’, ‘订单’, ‘152’, ‘94’, ‘548’, ‘654’, ‘655’, ‘27A1789ED5764D82A5506DF3DC3933F9.jpg’, ‘0’);
INSERT INTO easybuy_product VALUES (‘734’, ‘洗面奶’, ‘’, ‘152’, ‘995’, ‘548’, ‘654’, ‘655’, ‘D6C9BD438C5643D6B1A6C52E5426FE22.jpg’, ‘0’);
INSERT INTO easybuy_product VALUES (‘735’, ‘啫喱水’, ‘’, ‘152’, ‘998’, ‘548’, ‘654’, ‘655’, ‘1A836D2B3A3348DDAB19807E6CEA8028.jpg’, ‘0’);
INSERT INTO easybuy_product VALUES (‘736’, ‘香水5852’, ‘’, ‘152’, ‘1000’, ‘548’, ‘654’, ‘655’, ‘4D9499BAD92A42D291094E797BA2EA3F.jpg’, ‘0’);
INSERT INTO easybuy_product VALUES (‘737’, ‘香水’, ‘’, ‘152’, ‘111’, ‘548’, ‘654’, ‘655’, ‘A9924F9DB68B4DF99FDBF05902075AF0.jpg’, ‘0’);
INSERT INTO easybuy_product VALUES (‘738’, ‘润肤露’, ‘’, ‘45’, ‘109’, ‘548’, ‘654’, ‘655’, ‘3B059EDB5237407980458CE9EA9D3204.jpg’, ‘0’);
INSERT INTO easybuy_product VALUES (‘739’, ‘洁面装’, ‘’, ‘156’, ‘99’, ‘548’, ‘654’, ‘655’, ‘A62C6DF55116440CA3DE9DB37901ED4F.jpg’, ‘0’);
INSERT INTO easybuy_product VALUES (‘740’, ‘电饭锅’, ‘’, ‘158’, ‘100’, ‘628’, ‘656’, ‘659’, ‘40C3B76BA31246618E3CFC8723D33517.jpg’, ‘0’);
INSERT INTO easybuy_product VALUES (‘741’, ‘婴儿喂奶装’, ‘’, ‘569’, ‘100’, ‘632’, ‘637’, ‘653’, ‘401004B3D47C4C6FB1BC5EF19C21FC77.jpg’, ‘0’);
INSERT INTO easybuy_product VALUES (‘742’, ‘坚果套餐’, ‘’, ‘158’, ‘1000’, ‘660’, ‘661’, ‘662’, ‘E03D74145A034F6D909879829CB99D80.jpg’, ‘0’);
INSERT INTO easybuy_product VALUES (‘743’, ‘超甜蜜崭’, ‘’, ‘589’, ‘1000’, ‘660’, ‘661’, ‘663’, ‘7121E55099FC477680B1229205CE3D29.jpg’, ‘0’);
INSERT INTO easybuy_product VALUES (‘744’, ‘华为2566’, ‘’, ‘589’, ‘1000’, ‘670’, ‘671’, ‘672’, ‘F24B4140A2284B3788A38F3B5AD1809A.jpg’, ‘0’);
INSERT INTO easybuy_product VALUES (‘745’, ‘荣耀3C’, ‘’, ‘589’, ‘100’, ‘670’, ‘671’, ‘672’, ‘F3921E12552A4D0AA3F75467B146A959.jpg’, ‘0’);
INSERT INTO easybuy_product VALUES (‘746’, ‘小米手环’, ‘’, ‘963’, ‘100’, ‘670’, ‘674’, ‘675’, ‘72F75A371B0B4C26A7F72FAAEF96FC68.jpg’, ‘0’);
INSERT INTO easybuy_product VALUES (‘747’, ‘华为2265’, ‘’, ‘896’, ‘1000’, ‘670’, ‘671’, ‘673’, ‘161F355A8A8549BA8F7F4CE3B4F07E40.jpg’, ‘0’);
INSERT INTO easybuy_product VALUES (‘748’, ‘越南坚果’, ‘’, ‘520’, ‘1000’, ‘660’, ‘661’, ‘662’, ‘CBC98D3C9E544830821632F5C313D93E.jpg’, ‘0’);
INSERT INTO easybuy_product VALUES (‘749’, ‘日本进口马桶’, ‘’, ‘5866’, ‘100’, ‘628’, ‘657’, ‘0’, ‘A5AF40825E6940B2A59A040100E181A8.jpg’, ‘0’);
INSERT INTO easybuy_product VALUES (‘750’, ‘联想Y系列’, ‘’, ‘569’, ‘1000’, ‘670’, ‘690’, ‘691’, ‘956DB0BEC41B41B8A06C05C950130E23.jpg’, ‘0’);
INSERT INTO easybuy_product VALUES (‘751’, ‘脑白金1号’, ‘’, ‘589’, ‘1000’, ‘676’, ‘677’, ‘680’, ‘66E96AF9E9714A5C9EA901811173D662.jpg’, ‘0’);
INSERT INTO easybuy_product VALUES (‘752’, ‘莫里斯按’, ‘’, ‘589’, ‘1000’, ‘676’, ‘678’, ‘0’, ‘A7436BC607E74C81B392DCFE69D4AEAB.jpg’, ‘0’);
INSERT INTO easybuy_product VALUES (‘753’, ‘三鹿好奶粉’, ‘’, ‘859’, ‘100’, ‘676’, ‘679’, ‘0’, ‘3C465E7B8A324A8DA2A2EEE202E36166.jpg’, ‘0’);
INSERT INTO easybuy_product VALUES (‘754’, ‘儿童牛奶’, ‘’, ‘5896’, ‘100’, ‘676’, ‘679’, ‘0’, ‘D1AC9AE71ED348FA8D880FD4279D3422.jpg’, ‘0’);
INSERT INTO easybuy_product VALUES (‘755’, ‘软沙发’, ‘’, ‘8596’, ‘99’, ‘628’, ‘696’, ‘0’, ‘ED7921DE40FC47E18365754709A21194.jpg’, ‘0’);
INSERT INTO easybuy_product VALUES (‘756’, ‘收纳盒’, ‘’, ‘5966’, ‘100’, ‘628’, ‘696’, ‘0’, ‘DB86CA25CA4F4B4AA906F46BE542C6A6.jpg’, ‘0’);
INSERT INTO easybuy_product VALUES (‘757’, ‘洗衣液’, ‘’, ‘58’, ‘1000’, ‘628’, ‘696’, ‘0’, ‘E6CCDC343ACC471C908E9748776C6421.jpg’, ‘0’);
INSERT INTO easybuy_product VALUES (‘758’, ‘红短沙发’, ‘’, ‘596’, ‘123’, ‘628’, ‘696’, ‘0’, ‘BD5C77465DC2466BBCE7F95FB9764392.jpg’, ‘0’);
INSERT INTO easybuy_product VALUES (‘759’, ‘新西兰奶粉’, ‘’, ‘5896’, ‘100’, ‘676’, ‘679’, ‘0’, ‘9ED375098D42497B8FC33167E06D0EE8.jpg’, ‘0’);
INSERT INTO easybuy_product VALUES (‘760’, ‘婴儿车’, ‘’, ‘11000’, ‘100’, ‘681’, ‘682’, ‘687’, ‘1DBC0930641D43C29D74A9E1B40FEEBB.jpg’, ‘0’);
INSERT INTO easybuy_product VALUES (‘761’, ‘夏款婴儿车’, ‘’, ‘963’, ‘100’, ‘681’, ‘682’, ‘688’, ‘16290C4DBEAC4F00A636667019621468.jpg’, ‘0’);
INSERT INTO easybuy_product VALUES (‘762’, ‘抗压旅行箱’, ‘12’, ‘569’, ‘1000’, ‘660’, ‘661’, ‘662’, ‘c4ca4238a0b923820dcc509a6f75849b.jpg’, ‘0’);
INSERT INTO easybuy_product VALUES (‘763’, ‘透明手提箱’, ‘’, ‘8596’, ‘1000’, ‘681’, ‘683’, ‘684’, ‘EAA8E66259BF4239B4A2237B62520EF1.jpg’, ‘0’);
INSERT INTO easybuy_product VALUES (‘764’, ‘婴儿果粉’, ‘’, ‘5896’, ‘1000’, ‘660’, ‘661’, ‘662’, ‘08BE30BF7B5F4930B0093D8CC4056057.jpg’, ‘0’);
INSERT INTO easybuy_product VALUES (‘765’, ‘椰子粉’, ‘’, ‘5963’, ‘1000’, ‘660’, ‘661’, ‘662’, ‘9C006B8BD1AD45398F474A8471ADC50B.jpg’, ‘0’);
INSERT INTO easybuy_product VALUES (‘766’, ‘坚果蛋糕’, ‘’, ‘200’, ‘100’, ‘660’, ‘661’, ‘663’, ‘2E5A16E21E0640E0BAE03E9B995DCD28.jpg’, ‘0’);
INSERT INTO easybuy_product VALUES (‘767’, ‘编制手提箱’, ‘’, ‘5896’, ‘1000’, ‘681’, ‘682’, ‘688’, ‘2E1D2A5E65A94FEEA17C72E47C530057.jpg’, ‘0’);
INSERT INTO easybuy_product VALUES (‘768’, ‘去玩儿无若’, ‘空间规划局’, ‘126’, ‘100’, ‘660’, ‘661’, ‘662’, ‘c4ca4238a0b923820dcc509a6f75849b.jpg’, ‘0’);
INSERT INTO easybuy_product VALUES (‘769’, ‘健胃液’, ‘’, ‘152’, ‘1000’, ‘676’, ‘679’, ‘0’, ‘30B5547CD7384DAA8A2F4F4D8C0BBF89.jpg’, ‘0’);
INSERT INTO easybuy_product VALUES (‘770’, ‘联想NTC’, ‘’, ‘8596’, ‘100’, ‘670’, ‘671’, ‘673’, ‘48BC371A85A548B7A7589E3F542D911D.jpg’, ‘0’);
INSERT INTO easybuy_product VALUES (‘771’, ‘123’, ‘123’, ‘12’, ‘123’, ‘670’, ‘674’, ‘675’, ‘c4ca4238a0b923820dcc509a6f75849b.jpg’, null);

– Table structure for easybuy_product_category

DROP TABLE IF EXISTS easybuy_product_category;
CREATE TABLE easybuy_product_category (
id int(10) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
name varchar(20) NOT NULL COMMENT ‘名称’,
parentId int(10) DEFAULT NULL COMMENT ‘父级目录id’,
type int(11) DEFAULT NULL COMMENT ‘级别(1:一级 2：二级 3：三级)’,
iconClass varchar(255) DEFAULT NULL COMMENT ‘图标’,
PRIMARY KEY (id),
UNIQUE KEY PK__EASYBUY___9EC2A4E236B12243 (id)
) ENGINE=InnoDB AUTO_INCREMENT=698 DEFAULT CHARSET=utf8;

– Records of easybuy_product_category

INSERT INTO easybuy_product_category VALUES (‘548’, ‘化妆品’, ‘0’, ‘1’, ‘’);
INSERT INTO easybuy_product_category VALUES (‘628’, ‘家用商品’, ‘0’, ‘1’, ‘’);
INSERT INTO easybuy_product_category VALUES (‘654’, ‘面部护理’, ‘548’, ‘2’, ‘’);
INSERT INTO easybuy_product_category VALUES (‘655’, ‘少女派’, ‘654’, ‘3’, ‘’);
INSERT INTO easybuy_product_category VALUES (‘656’, ‘餐具’, ‘628’, ‘2’, ‘’);
INSERT INTO easybuy_product_category VALUES (‘657’, ‘卫具’, ‘628’, ‘2’, ‘’);
INSERT INTO easybuy_product_category VALUES (‘658’, ‘叉子’, ‘656’, ‘3’, ‘’);
INSERT INTO easybuy_product_category VALUES (‘659’, ‘锅’, ‘656’, ‘3’, ‘’);
INSERT INTO easybuy_product_category VALUES (‘660’, ‘进口食品,生鲜’, ‘0’, ‘1’, ‘’);
INSERT INTO easybuy_product_category VALUES (‘661’, ‘零食/糖果/巧克力’, ‘660’, ‘2’, ‘’);
INSERT INTO easybuy_product_category VALUES (‘662’, ‘坚果’, ‘661’, ‘3’, ‘’);
INSERT INTO easybuy_product_category VALUES (‘663’, ‘蜜饯’, ‘661’, ‘3’, ‘’);
INSERT INTO easybuy_product_category VALUES (‘669’, ‘孕期教育’, ‘546’, ‘3’, ‘’);
INSERT INTO easybuy_product_category VALUES (‘670’, ‘电子商品’, ‘0’, ‘1’, ‘’);
INSERT INTO easybuy_product_category VALUES (‘671’, ‘手机’, ‘670’, ‘2’, ‘’);
INSERT INTO easybuy_product_category VALUES (‘672’, ‘华为手机’, ‘671’, ‘3’, ‘’);
INSERT INTO easybuy_product_category VALUES (‘673’, ‘联想手机’, ‘671’, ‘3’, ‘’);
INSERT INTO easybuy_product_category VALUES (‘674’, ‘手环’, ‘670’, ‘2’, ‘’);
INSERT INTO easybuy_product_category VALUES (‘675’, ‘小米手环’, ‘674’, ‘3’, ‘’);
INSERT INTO easybuy_product_category VALUES (‘676’, ‘保健食品’, ‘0’, ‘1’, ‘’);
INSERT INTO easybuy_product_category VALUES (‘677’, ‘老年保健品’, ‘676’, ‘2’, ‘’);
INSERT INTO easybuy_product_category VALUES (‘678’, ‘中年营养品’, ‘676’, ‘2’, ‘’);
INSERT INTO easybuy_product_category VALUES (‘679’, ‘儿童保健品’, ‘676’, ‘2’, ‘’);
INSERT INTO easybuy_product_category VALUES (‘680’, ‘脑白金’, ‘677’, ‘3’, ‘’);
INSERT INTO easybuy_product_category VALUES (‘681’, ‘箱包’, ‘0’, ‘1’, ‘’);
INSERT INTO easybuy_product_category VALUES (‘682’, ‘旅行箱’, ‘681’, ‘2’, ‘’);
INSERT INTO easybuy_product_category VALUES (‘683’, ‘手提箱’, ‘681’, ‘2’, ‘’);
INSERT INTO easybuy_product_category VALUES (‘684’, ‘大型’, ‘683’, ‘3’, ‘’);
INSERT INTO easybuy_product_category VALUES (‘685’, ‘小型’, ‘683’, ‘3’, ‘’);
INSERT INTO easybuy_product_category VALUES (‘686’, ‘中型’, ‘683’, ‘3’, ‘’);
INSERT INTO easybuy_product_category VALUES (‘687’, ‘大型’, ‘682’, ‘3’, ‘’);
INSERT INTO easybuy_product_category VALUES (‘688’, ‘中型’, ‘682’, ‘3’, ‘’);
INSERT INTO easybuy_product_category VALUES (‘689’, ‘小型’, ‘682’, ‘3’, ‘’);
INSERT INTO easybuy_product_category VALUES (‘690’, ‘电脑’, ‘670’, ‘2’, ‘’);
INSERT INTO easybuy_product_category VALUES (‘691’, ‘联想电脑’, ‘690’, ‘3’, ‘’);
INSERT INTO easybuy_product_category VALUES (‘692’, ‘刀叉’, ‘656’, ‘3’, null);
INSERT INTO easybuy_product_category VALUES (‘693’, ‘碗筷’, ‘656’, ‘3’, null);
INSERT INTO easybuy_product_category VALUES (‘697’, ‘as’, null, ‘628’, null);

– Table structure for easybuy_user

DROP TABLE IF EXISTS easybuy_user;
CREATE TABLE easybuy_user (
id int(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
loginName varchar(255) NOT NULL COMMENT ‘登录名’,
userName varchar(255) NOT NULL COMMENT ‘用户名’,
password varchar(255) NOT NULL COMMENT ‘密码’,
sex int(2) NOT NULL DEFAULT ‘1’ COMMENT ‘性别(1:男 0：女)’,
identityCode varchar(60) DEFAULT NULL COMMENT ‘身份证号’,
email varchar(80) DEFAULT NULL COMMENT ‘邮箱’,
mobile varchar(11) DEFAULT NULL COMMENT ‘手机’,
type int(2) DEFAULT ‘0’ COMMENT ‘类型（1：后台 0:前台）’,
PRIMARY KEY (id),
UNIQUE KEY PK__EASYBUY___C96109CC3A81B327 (loginName)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8;

– Records of easybuy_user

INSERT INTO easybuy_user VALUES (‘2’, ‘admin’, ‘系统管理员’, ‘e10adc3949ba59abbe56e057f20f883e’, ‘1’, ‘130406198302141869’, ‘hello11@bdqn.com’, ‘1583233515’, ‘1’);
INSERT INTO easybuy_user VALUES (‘10’, ‘cgn’, ‘程广宁’, ‘e10adc3949ba59abbe56e057f20f883e’, ‘1’, ‘140225189987854589’, ‘1044732267@qq.com’, ‘13366055011’, ‘0’);
INSERT INTO easybuy_user VALUES (‘11’, ‘hyl’, ‘韩语良’, ‘e10adc3949ba59abbe56e057f20f883e’, ‘1’, ‘140225198874584539’, ‘1044732267@qq.com’, ‘13366055010’, ‘0’);
INSERT INTO easybuy_user VALUES (‘12’, ‘ck’, ‘陈康’, ‘e10adc3949ba59abbe56e057f20f883e’, ‘1’, ‘140225189987854589’, ‘1044732267@qq.com’, ‘13366055010’, ‘0’);
INSERT INTO easybuy_user VALUES (‘13’, ‘kys’, ‘康有沈’, ‘e10adc3949ba59abbe56e057f20f883e’, ‘1’, ‘1402251985512541525’, ‘1044732267@qq.com’, ‘13366055010’, ‘0’);
INSERT INTO easybuy_user VALUES (‘14’, ‘sb’, ‘沈白’, ‘e10adc3949ba59abbe56e057f20f883e’, ‘1’, ‘140225158987854589’, ‘1044732267@qq.com’, ‘13366055010’, ‘0’);
INSERT INTO easybuy_user VALUES (‘15’, ‘lb’, ‘李白’, ‘e10adc3949ba59abbe56e057f20f883e’, ‘1’, ‘140225189987854589’, ‘10447322658@qq.com’, ‘1336998554’, ‘0’);
INSERT INTO easybuy_user VALUES (‘16’, ‘lgw’, ‘zxc’, ‘e10adc3949ba59abbe56e057f20f883e’, ‘1’, ‘140225189987854589’, ‘1011322658@qq.com’, ‘1336998554’, ‘0’);
INSERT INTO easybuy_user VALUES (‘18’, ‘shangzezhong’, ‘尚泽忠’, ‘4297f44b13955235245b2497399d7a93’, ‘1’, ‘140225198810013745’, ‘1044888844@qq.com’, ‘13366528458’, ‘0’);
INSERT INTO easybuy_user VALUES (‘19’, ‘liguangliang’, ‘李光亮’, ‘25f9e794323b453885f5181f1b624d0b’, ‘1’, ‘140225198841547785’, ‘1047777@qq.com’, ‘13366055048’, ‘0’);
INSERT INTO easybuy_user VALUES (‘20’, ‘szz’, ‘李光亮’, ‘e10adc3949ba59abbe56e057f20f883e’, ‘1’, ‘140225198810013748’, ‘1044732267@qq.com’, ‘13366555010’, ‘1’);
INSERT INTO easybuy_user VALUES (‘22’, ‘qwertyu’, ‘张晨’, ‘123456’, ‘1’, ‘123456789123456789’, ‘123456789@qq.com’, ‘13512345678’, ‘0’);
INSERT INTO easybuy_user VALUES (‘23’, ‘qweqwe’, ‘asdf’, ‘qwerty’, ‘1’, ‘123456789123456789’, ‘123456789@qq.com’, ‘13512345678’, ‘0’);
INSERT INTO easybuy_user VALUES (‘24’, ‘qwer’, ‘admin’, ‘admin’, ‘1’, ‘123456789123456789’, ‘12345678@qq.com’, ‘13512345678’, ‘0’);
INSERT INTO easybuy_user VALUES (‘25’, ‘aaaaaaaaaaaa’, ‘admin’, ‘admin’, ‘1’, ‘123456789123456789’, ‘12345678@qq.com’, ‘13512345678’, ‘0’);
INSERT INTO easybuy_user VALUES (‘27’, ‘sssssssssss’, ‘admin’, ‘admin’, ‘1’, ‘123456789123456789’, ‘12345678@qq.com’, ‘13512345678’, ‘1’);
INSERT INTO easybuy_user VALUES (‘30’, ‘KKK’, ‘admin’, ‘admin’, ‘1’, ‘123456789123456789’, ‘12345678@qq.com’, ‘13512345678’, ‘0’);
INSERT INTO easybuy_user VALUES (‘31’, ‘ZZZZZZZZZZZ’, ‘admin’, ‘admin’, ‘1’, ‘’, ‘’, ‘’, ‘1’);
INSERT INTO easybuy_user VALUES (‘32’, ‘’, ‘admin’, ‘admin’, ‘1’, ‘’, ‘’, ‘’, ‘1’);
INSERT INTO easybuy_user VALUES (‘33’, ‘fdgdfgdf’, ‘admin’, ‘admin’, ‘1’, ‘123456789123456789’, ‘12345678@qq.com’, ‘13512345678’, ‘0’);
INSERT INTO easybuy_user VALUES (‘38’, ‘wqeqweq’, ‘admin’, ‘admin’, ‘1’, ‘123456789123456789’, ‘12345678@qq.com’, ‘13512345678’, ‘0’);
INSERT INTO easybuy_user VALUES (‘39’, ‘asdfg’, ‘admin’, ‘qwerty’, ‘1’, ‘123456789123456789’, ‘12345678@qq.com’, ‘13512345678’, ‘1’);

– Table structure for easybuy_user_address

DROP TABLE IF EXISTS easybuy_user_address;
CREATE TABLE easybuy_user_address (
id int(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键id’,
userId int(255) DEFAULT NULL COMMENT ‘用户主键’,
address varchar(255) DEFAULT NULL COMMENT ‘地址’,
createTime datetime DEFAULT NULL COMMENT ‘创建时间’,
isDefault int(2) DEFAULT ‘0’ COMMENT ‘是否是默认地址（1:是 0否）’,
remark varchar(255) DEFAULT NULL COMMENT ‘备注’,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

– Records of easybuy_user_address

INSERT INTO easybuy_user_address VALUES (‘11’, ‘2’, ‘北京市海淀区大有庄’, null, ‘0’, ‘朋友家’);
INSERT INTO easybuy_user_address VALUES (‘12’, ‘2’, ‘北京市海淀区大有庄’, null, ‘0’, ‘女朋友公司’);
INSERT INTO easybuy_user_address VALUES (‘13’, ‘9’, ‘北京市西直门大桥芬兰国际大厦’, null, ‘0’, ‘女朋友地址’);
INSERT INTO easybuy_user_address VALUES (‘14’, ‘18’, ‘北京市花园路小区’, null, ‘0’, ‘家里’);
INSERT INTO easybuy_user_address VALUES (‘15’, ‘18’, ‘北京市海淀区成府路’, null, ‘0’, ‘公司’);

qq_1406299528

关注

0
点赞
踩
2

收藏

觉得还不错? 一键收藏
打赏
0
评论
基于jsp+springboot的易卖网商城源码

技术：jsp，springboot，mysql账号admin 密码123456首页地址：http://localhost:8080/Home?action=index效果图：数据库设计：/*Navicat MySQL Data TransferSource Server : 阶段4Source Server Version : 50549Source Host : localhost:3306Source Database
复制链接

扫一扫