**# 功能:实现简单的商城交易网站
**# 框架:SSM
**# 数据库:MySQL
截图:
数据库表:
CREATE TABLE collect_table
(
id
int(11) NOT NULL AUTO_INCREMENT,
good_id
int(11) DEFAULT NULL,
good_name
varchar(255) DEFAULT NULL,
user_id
int(11) DEFAULT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of collect_table
– Table structure for first_type_table
DROP TABLE IF EXISTS first_type_table
;
CREATE TABLE first_type_table
(
id
int(11) NOT NULL,
name
varchar(50) DEFAULT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of first_type_table
INSERT INTO first_type_table
VALUES (‘1001’, ‘电子产品’);
INSERT INTO first_type_table
VALUES (‘1002’, ‘衣物’);
INSERT INTO first_type_table
VALUES (‘1003’, ‘运动’);
INSERT INTO first_type_table
VALUES (‘1004’, ‘图书’);
– Table structure for good_table
DROP TABLE IF EXISTS good_table
;
CREATE TABLE good_table
(
id
int(11) NOT NULL AUTO_INCREMENT,
name
varchar(255) DEFAULT NULL,
photo_url
varchar(200) DEFAULT NULL,
first_type_id
int(11) DEFAULT NULL,
second_type_id
int(11) DEFAULT NULL,
describe
varchar(500) DEFAULT NULL,
upload_date
datetime DEFAULT CURRENT_TIMESTAMP,
prise
float DEFAULT NULL,
status_id
int(11) DEFAULT NULL,
user_id
int(11) DEFAULT NULL,
update
datetime DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
– Records of good_table
INSERT INTO good_table
VALUES (‘1’, ‘手机’, ‘/statics/image/goods/test/1.jpg’, ‘1001’, ‘1001001’, ‘手机’, ‘2018-05-22 03:19:33’, ‘1000’, ‘1’, ‘1’, ‘2018-05-22 03:20:01’);
INSERT INTO good_table
VALUES (‘2’, ‘手机’, ‘/statics/image/goods/test/2.jpg’, ‘1001’, ‘1001001’, ‘手机’, ‘2018-05-22 03:19:33’, ‘1000’, ‘1’, ‘1’, ‘2018-05-22 03:20:01’);
INSERT INTO good_table
VALUES (‘3’, ‘电脑’, ‘/statics/image/goods/test/3.jpg’, ‘1001’, ‘1001002’, ‘电脑’, ‘2018-05-22 03:19:33’, ‘1000’, ‘1’, ‘1’, ‘2018-05-22 03:20:01’);
INSERT INTO good_table
VALUES (‘4’, ‘电脑’, ‘/statics/image/goods/test/4.jpg’, ‘1001’, ‘1001002’, ‘电脑’, ‘2018-05-22 03:19:33’, ‘1000’, ‘1’, ‘1’, ‘2018-05-22 03:20:01’);
INSERT INTO good_table
VALUES (‘5’, ‘上衣’, ‘/statics/image/goods/test/5.jpg’, ‘1002’, ‘1002001’, ‘上衣’, ‘2018-05-22 03:19:33’, ‘1000’, ‘1’, ‘1’, ‘2018-05-22 03:20:01’);
INSERT INTO good_table
VALUES (‘6’, ‘上衣’, ‘/statics/image/goods/test/6.jpg’, ‘1002’, ‘1002001’, ‘上衣’, ‘2018-05-22 03:19:33’, ‘1000’, ‘1’, ‘1’, ‘2018-05-22 03:20:01’);
– Table structure for image_table
DROP TABLE IF EXISTS image_table
;
CREATE TABLE image_table
(
id
int(11) NOT NULL AUTO_INCREMENT,
good_id
int(11) DEFAULT NULL,
name
varchar(100) DEFAULT NULL,
url
varchar(500) DEFAULT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;