基于SSM框架开发的校园二手商城源码+sql数据库(毕设源码).zip

/* Navicat MySQL Data Transfer Source Server : localhost_3306 Source Server Version : 50620 Source Host : localhost:3306 Source Database : ssm_ershou_market Target Server Type : MYSQL Target Server Version : 50620 File Encoding : 65001 Date: 2020-01-31 22:57:14 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `admin` -- ---------------------------- DROP TABLE IF EXISTS `admin`; CREATE TABLE `admin` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(25) DEFAULT NULL COMMENT '账号', `phone` bigint(25) NOT NULL, `password` varchar(25) NOT NULL COMMENT '密码', `userRole` varchar(25) DEFAULT NULL COMMENT '角色', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of admin -- ---------------------------- INSERT INTO `admin` VALUES ('1', 'admin', '123456', '123456', '超级管理员'); -- ---------------------------- -- Table structure for `catelog` -- ---------------------------- DROP TABLE IF EXISTS `catelog`; CREATE TABLE `catelog` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键', `name` varchar(30) DEFAULT NULL COMMENT '分类名', `number` int(11) DEFAULT '0' COMMENT '该分类下的商品数量', `status` tinyint(10) DEFAULT '0' COMMENT '分类状态，0正常，1暂用', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of catelog -- ---------------------------- INSERT INTO `catelog` VALUES ('1', '闲置数码', '10', '1'); INSERT INTO `catelog` VALUES ('2', '校园代步', '5', '1'); INSERT INTO `catelog` VALUES ('3', '电器日用', '6', '1'); INSERT INTO `catelog` VALUES ('4', '图书教材', '7', '1'); INSERT INTO `catelog` VALUES ('5', '美妆衣物', '11', '1'); INSERT INTO `catelog` VALUES ('6', '运动棋牌', '5', '1'); INSERT INTO `catelog` VALUES ('7', '票券小物', '5', '1'); -- ---------------------------- -- Table structure for `comments` -- ---------------------------- DROP TABLE IF EXISTS `comments`; CREATE TABLE `comments` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '评论主键', `user_id` int(11) DEFAULT NULL COMMENT '用户，外键', `goods_id` int(11) DEFAULT NULL COMMENT '商品，外键', `content` varchar(255) DEFAULT NULL COMMENT '评论内容', `create_at` varchar(250) DEFAULT NULL COMMENT '评论时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of comments -- ---------------------------- INSERT INTO `comments` VALUES ('120', '8', '97', '厉害厉害~', '2020-04-17 04:36:10'); INSERT INTO `comments` VALUES ('121', '3', '77', '1212', '2020-04-18 12:02:27'); INSERT INTO `comments` VALUES ('122', '6', '90', '111', '2020-04-20 11:37:45'); INSERT INTO `comments` VALUES ('123', '23', '103', '喜欢排球', '2020-04-27 10:05:36'); INSERT INTO `comments` VALUES ('124', '23', '20', '不知道用了多久了', '2020-05-16 01:11:46'); INSERT INTO `comments` VALUES ('125', '23', '110', '自己看过，很不错的一本书 。', '2020-05-16 01:12:21'); INSERT INTO `comments` VALUES ('126', '23', '107', 'HHH', '2020-05-16 02:49:59'); -- ---------------------------- -- Table structure for `focus` -- ---------------------------- DROP TABLE IF EXISTS `focus`; CREATE TABLE `focus` ( `id` int(11) NOT NULL AUTO_INCREMENT, `goods_id` int(11) DEFAULT NULL COMMENT '外键 商品id', `user_id` int(11) DEFAULT NULL COMMENT '外键 用户id', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of focus -- ---------------------------- INSERT INTO `focus` VALUES ('1', '77', '5'); INSERT INTO `focus` VALUES ('4', '94', '4'); INSERT INTO `focus` VALUES ('5', '94', '4'); INSERT INTO `focus` VALUES ('6', '94', '4'); INSERT INTO `focus` VALUES ('8', '90', '9'); INSERT INTO `focus` VALUES ('9', '90', '22'); INSERT INTO `focus` VALUES ('18', '5', '23'); INSERT INTO `focus` VALUES ('19', '85', '23'); INSERT INTO `focus` VALUES ('20', '106', '25'); INSERT INTO `focus` VALUES ('21', '108', '25'); -- ---------------------------- -- Table structure for `goods` -- ---------------------------- DROP TABLE IF EXISTS `goods`; CREATE TABLE `goods` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '商品主键', `catelog_id` int(11) DEFAULT NULL COMMENT '商品分类，外键', `user_id` int(11) DEFAULT NULL COMMENT '用户外键', `name` varchar(50) DEFAULT NULL COMMENT '商品名称', `price` float(11,2) DEFAULT NULL COMMENT '出售价格', `real_price` float(11,2) DEFAULT NULL COMMENT '真实价格', `start_time` varchar(25) DEFAULT NULL COMMENT '发布时间', `polish_time` varchar(30) DEFAULT NULL COMMENT '擦亮时间，按该时间进行查询，精确到时分秒', `end_time` varchar(25) DEFAULT NULL COMMENT '下架时间', `describle` text COMMENT '详细信息', `status` int(11) DEFAULT '1' COMMENT '状态 上架1 下架0', PRIMARY KEY (`id`), KEY `catelog_id` (`catelog_id`) USING BTREE, KEY `user_id` (`user_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=121 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of goods -- ---------------------------- INSERT INTO `goods` VALUES ('1', '6', '1', '精美吉他', '130.00', '160.00', '2019-05-13', '2019-05-13', '2019-05-23', '自用二手吉他，9成新，低价出售，有意者联系。', '1'); INSERT INTO `goods` VALUES ('2', '2', '1', '山地车', '1520.00', '890.00', '2019-05-13', '2019-05-13', '2019-05-23', '八成新山地车，无损坏，喜欢Call我。', '1'); INSERT INTO `goods` VALUES ('3', '3', '1', '无线鼠标', '23.00', '48.00', '2019-05-13', '2019-05-13', '2019-05-23', '罗技无线鼠标，自用一个月，9成新，手感好，反应灵敏。', '1'); INSERT INTO `goods` VALUES ('5', '1', '2', '数码相机', '580.00', '1350.00', '2019-05-14', '2019-05-14', '2019-05-24', '自用的数码相机，一年前购买，非常爱好，无磕碰。可议价。', '1'); INSERT INTO `goods` VALUES ('6', '1', '2', '笔记本电脑', '690.00', '2300.00', '2019-05-14', '2019-05-14', '2019-05-24', '7成新14寸笔记本电脑，商务本，适合办公，2G内存。', '1'); INSERT INTO `goods` VALUES ('7', '3', '2', '收纳盒', '15.00', '36.00', '2019-05-14', '2019-05-14', '2019-05-24', '3层塑料物品收纳盒，毕业了，低价出售。', '0'); INSERT INTO `goods` VALUES ('8', '3', '1', '台灯', '32.00', '58.00', '2019-05-14', '2019-05-14', '2019-05-24', '考研时购买的台灯，可插USB接口。', '1'); INSERT INTO `goods` VALUES ('9', '5', '2', '女鞋', '35.00', '86.00', '2019-05-14', '2019-05-14', '2019-05-24', '学生女鞋', '0'); INSERT INTO `goods` VALUES ('11', '1', '3', '无线传呼机', '230.00', '370.00', '2019-05-14', '2020-04-14', '2019-05-24', '一对无线传呼机，带有充电器，可以传呼2公里。', '1'); INSERT INTO `goods` VALUES ('12', '1', '3', '手提女包', '36.00', '89.00', '2019-05-14', '2020-04-14', '2019-05-24', '手提女包，自用了几天。', '1'); INSERT INTO `goods` VALUES ('13', '5', '1', '手提包', '15.00', '23.00', '2019-05-14', '2019-05-14', '2019-05-24', '自用手提包，8成新，便宜出。', '1'); INSERT INTO `goods` VALUES ('16', '6', '2', '耐克运动书包', '56.00', '198.00', '2019-05-14', '2019-05-14', '2019-05-24', '去年年底购买的耐克书包，8成新，无损坏，可以装电脑，很漂亮，有意者联系。', '1'); INSERT INTO `goods` VALUES ('17', '4', '2', '二手小说', '10.00', '65.00', '2019-05-14', '2019-05-14', '2019-05-24', '毕业季，一书架小说，便宜出售。', '1'); INSERT INTO `goods` VALUES ('18', '4', '2', '公务员考试资料', '35.00', '79.00', '2019-05-14', '2019-05-14', '2019-05-24', '�