jsp+ssm+mysql实现的校园二手市场交易平台源码

**# 功能:实现简单的商城交易网站
**# 框架: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;

源码下载:http://www.bycxy123.com/
视频演示:https://www.bilibili.com/video/BV1a7411h7xF/

©️2020 CSDN 皮肤主题: 大白 设计师:CSDN官方博客 返回首页