基于SSM开发的校园二手商城响应式网站源码+sql数据库+项目说明(高分毕设).zip

/* Navicat MySQL Data Transfer Source Server : localhost_3306 Source Server Version : 50051 Source Host : localhost:3306 Source Database : product_db Target Server Type : MYSQL Target Server Version : 50051 File Encoding : 65001 Date: 2017-12-21 02:04:01 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `admin` -- ---------------------------- DROP TABLE IF EXISTS `admin`; CREATE TABLE `admin` ( `username` varchar(20) NOT NULL default '', `password` varchar(32) default NULL, PRIMARY KEY (`username`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of admin -- ---------------------------- INSERT INTO `admin` VALUES ('a', 'a'); -- ---------------------------- -- Table structure for `t_comment` -- ---------------------------- DROP TABLE IF EXISTS `t_comment`; CREATE TABLE `t_comment` ( `commentId` int(11) NOT NULL auto_increment COMMENT '评论id', `productObj` int(11) NOT NULL COMMENT '被评商品', `content` varchar(1000) NOT NULL COMMENT '评论内容', `userObj` varchar(30) NOT NULL COMMENT '评论用户', `commentTime` varchar(20) default NULL COMMENT '评论时间', PRIMARY KEY (`commentId`), KEY `productObj` (`productObj`), KEY `userObj` (`userObj`), CONSTRAINT `t_comment_ibfk_1` FOREIGN KEY (`productObj`) REFERENCES `t_product` (`productId`), CONSTRAINT `t_comment_ibfk_2` FOREIGN KEY (`userObj`) REFERENCES `t_userinfo` (`user_name`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of t_comment -- ---------------------------- INSERT INTO `t_comment` VALUES ('1', '1', '非常好看的手机', 'user2', '2017-12-20 14:15:13'); INSERT INTO `t_comment` VALUES ('2', '1', '我下次还会来买的！', 'user2', '2017-12-20 23:34:04'); -- ---------------------------- -- Table structure for `t_notice` -- ---------------------------- DROP TABLE IF EXISTS `t_notice`; CREATE TABLE `t_notice` ( `noticeId` int(11) NOT NULL auto_increment COMMENT '公告id', `title` varchar(80) NOT NULL COMMENT '标题', `content` varchar(5000) NOT NULL COMMENT '公告内容', `publishDate` varchar(20) default NULL COMMENT '发布时间', PRIMARY KEY (`noticeId`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of t_notice -- ---------------------------- INSERT INTO `t_notice` VALUES ('1', '二手购物网站成立了', '<p>以后同学们可以来这里淘到你们心意的宝贝了！</p>', '2017-12-20 00:31:10'); -- ---------------------------- -- Table structure for `t_orderinfo` -- ---------------------------- DROP TABLE IF EXISTS `t_orderinfo`; CREATE TABLE `t_orderinfo` ( `orderNo` varchar(30) NOT NULL COMMENT 'orderNo', `userObj` varchar(30) NOT NULL COMMENT '下单用户', `totalMoney` float NOT NULL COMMENT '订单总金额', `payWay` varchar(20) NOT NULL COMMENT '支付方式', `orderStateObj` varchar(20) NOT NULL COMMENT '订单状态', `orderTime` varchar(20) default NULL COMMENT '下单时间', `receiveName` varchar(20) NOT NULL COMMENT '收货人', `telephone` varchar(20) NOT NULL COMMENT '收货人电话', `address` varchar(80) NOT NULL COMMENT '收货地址', `orderMemo` varchar(500) default NULL COMMENT '订单备注', `sellObj` varchar(30) NOT NULL COMMENT '商家', PRIMARY KEY (`orderNo`), KEY `userObj` (`userObj`), KEY `sellObj` (`sellObj`), CONSTRAINT `t_orderinfo_ibfk_1` FOREIGN KEY (`userObj`) REFERENCES `t_userinfo` (`user_name`), CONSTRAINT `t_orderinfo_ibfk_2` FOREIGN KEY (`sellObj`) REFERENCES `t_userinfo` (`user_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of t_orderinfo -- ---------------------------- INSERT INTO `t_orderinfo` VALUES ('user2201712210141291', 'user2', '3373', '支付宝', '待付款', '2017-12-21 01:41:29', '李倩', '13589834234', '福建福州滨海路', '尽快发货吧！', 'user1'); INSERT INTO `t_orderinfo` VALUES ('user2201712210141292', 'user2', '1299', '支付宝', '待付款', '2017-12-21 01:41:29', '李倩', '13589834234', '福建福州滨海路', '尽快发货吧！', 'user3'); -- ---------------------------- -- Table structure for `t_orderitem` -- ---------------------------- DROP TABLE IF EXISTS `t_orderitem`; CREATE TABLE `t_orderitem` ( `itemId` int(11) NOT NULL auto_increment COMMENT '条目id', `orderObj` varchar(30) NOT NULL COMMENT '所属订单', `productObj` int(11) NOT NULL COMMENT '订单商品', `price` float NOT NULL COMMENT '商品单价', `orderNumer` int(11) NOT NULL COMMENT '购买数量', PRIMARY KEY (`itemId`), KEY `orderObj` (`orderObj`), KEY `productObj` (`productObj`), CONSTRAINT `t_orderitem_ibfk_1` FOREIGN KEY (`orderObj`) REFERENCES `t_orderinfo` (`orderNo`), CONSTRAINT `t_orderitem_ibfk_2` FOREIGN KEY (`productObj`) REFERENCES `t_product` (`productId`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of t_orderitem -- ---------------------------- INSERT INTO `t_orderitem` VALUES ('2', 'user2201712210141291', '1', '800', '2'); INSERT INTO `t_orderitem` VALUES ('3', 'user2201712210141291', '4', '1773', '1'); INSERT INTO `t_orderitem` VALUES ('4', 'user2201712210141292', '2', '1299', '1'); -- ---------------------------- -- Table structure for `t_product` -- ---------------------------- DROP TABLE IF EXISTS `t_product`; CREATE TABLE `t_product` ( `productId` int(11) NOT NULL auto_increment COMMENT '商品编号', `productClassObj` int(11) NOT NULL COMMENT '商品类别', `productName` varchar(50) NOT NULL COMMENT '商品名称', `mainPhoto` varchar(60) NOT NULL COMMENT '商品主图', `price` float NOT NULL COMMENT '商品价格', `productDesc` varchar(5000) NOT NULL COMMENT '商品描述', `userObj` varchar(30) NOT NULL COMMENT '发布用户', `addTime` varchar(20) default NULL COMMENT '发布时间', PRIMARY KEY (`productId`), KEY `productClassObj` (`productClassObj`), KEY `userObj` (`userObj`), CONSTRAINT `t_product_ibfk_1` FOREIGN KEY (`productClassObj`) REFERENCES `t_productclass` (`classId`), CONSTRAINT `t_product_ibfk_2` FOREIGN KEY (`userObj`) REFERENCES `t_userinfo` (`user_name`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of t_product -- ---------------------------- INSERT INTO `t_product` VALUES ('1', '1', '9成新苹果5s', 'upload/049477b5-1fcb-419c-8df2-5813acea0423.jpg', '800', '<p>品牌名称：Apple/苹果</p><p>更多参数产品参数：</p><p>证书编号：2013011606639987证书状态：有效申请人名称：美国苹果公司制造商名称：美国苹果公司产品名称：TD-LTE 数字移动电话机3C产品型号：A1530（电源适配器：A1443,输出:5.0VDC,1.0A）（电源适配器为可选部件）3C规格型号：A1530（电源适配器：A1443,输出:5.0VDC,1.0A）（电源适配器为可选部件）产品名称：Apple/苹果 iPhone 5sCPU型号: A7Apple型号: iPhone 5s机身颜色: 金色运行内存RAM: 1GB存储容量: 16GB网络模式: 单卡多模</p><p><br/></p>', 'user1', '2017-12-20 00:11:18'); INSERT INTO `t_product` VALUES ('2', '1', '小米5X 变焦双摄拍照智能手机', 'upload/b0169c8b-4851-41eb-97c2-2b0fda10cba8.jpg', '1299', '<p>证书编号：2017011606972569证书状态：有效产品名称：TD-LTE数字移动电话机3C规格型号：MDE2（电源适配器：MDY-08-EV 输出：5VDC 2.0A）产品名称：Xiaomi/小米 小米5XCPU型号: 骁龙625 型号: 小米5X机身颜色: 金色 玫瑰金 黑色 红色运行内存RAM: 4GB存储容量: 32GB 64GB网络模式: 双卡多模</p>', 'user3', '2017-12-20 23:54:05'); INSERT INTO `t_product` VALUES ('3', '2', 'Dell/戴尔 成就Vostro 15.6英寸四核笔记本', 'upload/e3e51