基于ssm整合的Web购物商城

基于ssm整合的Web购物商城
网站分为买家模块和卖家模块 买家模块包括首页，单个商品界面，商品收藏，购物车，下单支付，商品评论，联系卖家等 卖家模块包括商品管理，订单管理，退换管理，库存管理(SKU管理)，销量统计等。 买家模块使用JSP做后端渲染。卖家模块使用 Angular做前端渲染，后端只返回JSON数据。联系卖家的功能通过WebSocket实现。

前台访问路径：http://localhost:8080/YTShop/customer/star.html

测试账号：xueden01 密码：123456

卖家访问路径：http://localhost:8080/YTShop/resources/seller.html

测试账号：xueden 密码：123456

数据库：
CREATE TABLE tb_attr (
id int(11) NOT NULL AUTO_INCREMENT COMMENT ‘自增长主键’,
name varchar(20) DEFAULT NULL COMMENT ‘属性值’,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COMMENT=‘属性值’;

---

– Records of tb_attr

---

INSERT INTO tb_attr VALUES (‘1’, ‘32G’);
INSERT INTO tb_attr VALUES (‘2’, ‘64G’);
INSERT INTO tb_attr VALUES (‘3’, ‘白色’);
INSERT INTO tb_attr VALUES (‘4’, ‘黑色’);
INSERT INTO tb_attr VALUES (‘5’, ‘电信版’);
INSERT INTO tb_attr VALUES (‘6’, ‘移动版’);
INSERT INTO tb_attr VALUES (‘7’, ‘新书’);
INSERT INTO tb_attr VALUES (‘8’, ‘二手书’);
INSERT INTO tb_attr VALUES (‘9’, ‘S号’);
INSERT INTO tb_attr VALUES (‘10’, ’ M号’);
INSERT INTO tb_attr VALUES (‘11’, ‘L号’);
INSERT INTO tb_attr VALUES (‘12’, ‘精装版’);
INSERT INTO tb_attr VALUES (‘13’, ‘普通版’);
INSERT INTO tb_attr VALUES (‘14’, ‘无属性’);

---

– Table structure for tb_chat

---

DROP TABLE IF EXISTS tb_chat;
CREATE TABLE tb_chat (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘自增主键’,
from_user_id int(11) DEFAULT NULL COMMENT ‘发送者的用户id’,
accept_user_id int(11) DEFAULT NULL COMMENT ‘接受者的用户id’,
create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT ‘创建时间’,
content varchar(256) DEFAULT NULL COMMENT ‘消息的内容’,
PRIMARY KEY (id),
KEY from_user_id (from_user_id),
KEY accept_user_id (accept_user_id),
CONSTRAINT tb_chat_ibfk_1 FOREIGN KEY (from_user_id) REFERENCES tb_user (id),
CONSTRAINT tb_chat_ibfk_2 FOREIGN KEY (accept_user_id) REFERENCES tb_user (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=‘聊天表’;

---

– Records of tb_chat

---

---

– Table structure for tb_item

---

DROP TABLE IF EXISTS tb_item;
CREATE TABLE tb_item (
id int(11) NOT NULL AUTO_INCREMENT COMMENT ‘自增长主键’,
name varchar(20) DEFAULT NULL COMMENT ‘商品名称’,
kind_id int(11) DEFAULT NULL COMMENT ‘类别主键’,
seller_id int(11) DEFAULT NULL COMMENT ‘关联卖家id’,
simple_info varchar(100) DEFAULT NULL COMMENT ‘商品简介’,
detailed_info varchar(256) DEFAULT NULL COMMENT ‘商品详细信息’,
old_price float DEFAULT NULL COMMENT ‘旧价格’,
new_price float DEFAULT NULL COMMENT ‘新价格’,
delivery_price float DEFAULT NULL COMMENT ‘运费’,
img_location varchar(256) DEFAULT NULL COMMENT ‘商品的图片,格式为src1|src2|src3 src1为主图’,
on_sale_tag tinyint(1) DEFAULT ‘0’ COMMENT ‘商品是否上架,默认没有上架’,
create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT ‘创建时间’,
PRIMARY KEY (id),
KEY kind_id (kind_id),
KEY seller_id (seller_id),
CONSTRAINT tb_item_ibfk_1 FOREIGN KEY (kind_id) REFERENCES tb_kind (id),
CONSTRAINT tb_item_ibfk_2 FOREIGN KEY (seller_id) REFERENCES tb_user (id)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COMMENT=‘商品表’;

---

– Records of tb_item

---

INSERT INTO tb_item VALUES (‘1’, ‘百年孤独’, ‘2’, ‘32’, ‘简介dsdsdsdsmmmmgg’, ‘百年孤独222222222mmmmmgg’, ‘100.22’, ‘53.22’, ‘21.2’, ‘1-bngd-1.jpg|1-百年孤独-2.jpg|1-bngd-3.jpg’, ‘1’, ‘2020-06-06 20:31:31’);
INSERT INTO tb_item VALUES (‘2’, ‘乱世佳人’, ‘2’, ‘32’, ‘乱世佳人1111’, ‘乱世佳人222222222’, ‘100’, ‘50’, ‘10’, ‘1-乱世佳人-1.jpg|1-乱世佳人-2.jpg|1-乱世佳人-3.jpg’, ‘1’, ‘2020-06-06 20:31:36’);
INSERT INTO tb_item VALUES (‘3’, ‘工程力学’, ‘2’, ‘32’, ‘工程力学1111’, ‘工程力学222222222’, ‘100’, ‘50’, ‘10’, ‘1-工程力学-1.jpg|1-工程力学-2.jpg|1-工程力学-3.jpg’, ‘1’, ‘2020-06-06 20:31:42’);
INSERT INTO tb_item VALUES (‘12’, ‘连衣裙’, ‘3’, ‘32’, ‘连衣裙连衣裙连衣裙连衣裙连衣裙连衣裙’, ‘连衣裙连衣裙连衣裙连衣裙连衣裙连衣裙’, ‘1000’, ‘300’, ‘10’, ‘1520925366172-1.jpg|1520925367980-1.jpg’, ‘1’, ‘2020-06-06 20:31:47’);
INSERT INTO tb_item VALUES (‘17’, ‘红米4A1’, ‘1’, ‘32’, ‘红米手机，非常好用的手机’, ‘红米手机，非常好用的手机 红米手机，非常好用的手机，性价比非常高’, ‘999’, ‘666’, ‘10’, ‘1520994583028-1.jpg|1520994594533-1.jpg’, ‘1’, ‘2020-06-06 20:31:54’);
INSERT INTO tb_item VALUES (‘22’, ‘短裙’, ‘3’, ‘32’, ‘短裙 短裙 短裙 短裙 短裙 短裙’, ‘短裙 短裙 短裙 短裙 短裙 短裙 短裙 短裙 短裙 短裙’, ‘800’, ‘200’, ‘5’, ‘1521057073224-1.jpg’, ‘1’, ‘2020-06-06 20:31:58’);
INSERT INTO tb_item VALUES (‘23’, ‘11’, ‘1’, ‘32’, null, null, ‘12’, ‘13’, ‘1’, ‘’, ‘0’, ‘2020-06-06 20:32:03’);
INSERT INTO tb_item VALUES (‘24’, ‘复古长裙’, ‘3’, ‘32’, ‘复古长裙 复古长裙 复古长裙 复古长裙 复古长裙 复古长裙 复古长裙’, ‘复古长裙 复古长裙 复古长裙 复古长裙 复古长裙 复古长裙 复古长裙\n复古长裙 复古长裙 复古长裙 复古长裙 复古长裙 复古长裙 复古长裙\n复古长裙 复古长裙 复古长裙 复古长裙 复古长裙 复古长裙 复古长裙’, ‘1200’, ‘700’, ‘20’, ‘1521953974977-1.jpg|1521953980010-1.jpg|1521953984288-1.jpg’, ‘1’, ‘2020-06-06 20:32:08’);

---

– Table structure for tb_kind

---

DROP TABLE IF EXISTS tb_kind;
CREATE TABLE tb_kind (
id int(11) NOT NULL AUTO_INCREMENT COMMENT ‘自增主键’,
name varchar(20) DEFAULT NULL COMMENT ‘类别名称’,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT=‘类别表’;

---

– Records of tb_kind

---

INSERT INTO tb_kind VALUES (‘1’, ‘手机’);
INSERT INTO tb_kind VALUES (‘2’, ‘书籍’);
INSERT INTO tb_kind VALUES (‘3’, ‘衣服’);

---

– Table structure for tb_order

---

DROP TABLE IF EXISTS tb_order;
CREATE TABLE tb_order (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘自增主键’,
b_id varchar(14) DEFAULT NULL COMMENT ‘业务主键 即订单号’,
sku_id int(11) DEFAULT NULL COMMENT ‘关联sku_id’,
quantity int(11) DEFAULT NULL COMMENT ‘数量’,
user_id int(11) DEFAULT NULL COMMENT ‘关联买家的主键’,
status enum(‘in_cart’,‘payed’,‘deliverying’,‘return’,‘success’,‘reviewed’,‘end’) DEFAULT NULL COMMENT ‘订单状态’,
payed_money float DEFAULT NULL COMMENT ‘支付的价格’,
review varchar(100) DEFAULT NULL COMMENT ‘评价 订单状态为success才能评价’,
create_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
PRIMARY KEY (id),
UNIQUE KEY b_id (b_id),
UNIQUE KEY b_id_2 (b_id),
KEY sku_id (sku_id),
KEY user_id (user_id),
CONSTRAINT tb_order_ibfk_1 FOREIGN KEY (sku_id) REFERENCES tb_sku (id),
CONSTRAINT tb_order_ibfk_2 FOREIGN KEY (user_id) REFERENCES tb_user (id)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COMMENT=‘订单表’;