Java项目:网上家具商城平台设计和实现(java+springboot+mysql+ssm)

/* Navicat MySQL Data Transfer Source Server : test Source Server Version : 50560 Source Host : localhost:3306 Source Database : mall Target Server Type : MYSQL Target Server Version : 50560 File Encoding : 65001 Date: 2021-02-26 09:52:08 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for admin_user -- ---------------------------- DROP TABLE IF EXISTS `admin_user`; CREATE TABLE `admin_user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `password` varchar(255) DEFAULT NULL, `username` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of admin_user -- ---------------------------- INSERT INTO `admin_user` VALUES ('1', 'admin', 'admin'); INSERT INTO `admin_user` VALUES ('2', 'hfb', 'hfb'); -- ---------------------------- -- Table structure for classification -- ---------------------------- DROP TABLE IF EXISTS `classification`; CREATE TABLE `classification` ( `id` int(11) NOT NULL AUTO_INCREMENT, `cname` varchar(255) DEFAULT NULL, `parent_id` int(11) DEFAULT NULL, `type` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of classification -- ---------------------------- INSERT INTO `classification` VALUES ('41', '床类', '0', '1'); INSERT INTO `classification` VALUES ('42', '床垫类', '0', '1'); INSERT INTO `classification` VALUES ('43', '柜类', '0', '1'); INSERT INTO `classification` VALUES ('44', '实木床', '41', '2'); INSERT INTO `classification` VALUES ('45', '布艺', '41', '2'); INSERT INTO `classification` VALUES ('46', '乳胶床垫', '42', '2'); INSERT INTO `classification` VALUES ('47', '棕垫', '42', '2'); INSERT INTO `classification` VALUES ('48', '沙发', '0', '1'); INSERT INTO `classification` VALUES ('49', '软沙发', '48', '2'); -- ---------------------------- -- Table structure for order -- ---------------------------- DROP TABLE IF EXISTS `order`; CREATE TABLE `order` ( `id` int(11) NOT NULL AUTO_INCREMENT, `addr` varchar(255) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `order_time` datetime DEFAULT NULL, `phone` varchar(255) DEFAULT NULL, `state` int(11) DEFAULT NULL, `total` double DEFAULT NULL, `user_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of order -- ---------------------------- INSERT INTO `order` VALUES ('9', '北京朝阳区1111', 'cookie', '2019-02-20 10:55:14', '18322221111', '4', '7900', '6'); INSERT INTO `order` VALUES ('10', '11', '11', '2021-02-25 21:03:38', '11111111111', '3', '2342', '7'); -- ---------------------------- -- Table structure for order_item -- ---------------------------- DROP TABLE IF EXISTS `order_item`; CREATE TABLE `order_item` ( `id` int(11) NOT NULL AUTO_INCREMENT, `count` int(11) DEFAULT NULL, `order_id` int(11) DEFAULT NULL, `product_id` int(11) DEFAULT NULL, `sub_total` double DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of order_item -- ---------------------------- INSERT INTO `order_item` VALUES ('11', '1', '9', '53', '3400'); INSERT INTO `order_item` VALUES ('12', '1', '9', '62', '4500'); INSERT INTO `order_item` VALUES ('13', '1', '10', '56', '2342'); -- ---------------------------- -- Table structure for product -- ---------------------------- DROP TABLE IF EXISTS `product`; CREATE TABLE `product` ( `id` int(11) NOT NULL AUTO_INCREMENT, `csid` int(11) DEFAULT NULL, `desc` varchar(1000) DEFAULT NULL, `image` varchar(255) DEFAULT NULL, `is_hot` int(11) DEFAULT NULL, `market_price` double DEFAULT NULL, `pdate` datetime DEFAULT NULL, `shop_price` bigint(20) DEFAULT NULL, `title` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of product -- ---------------------------- INSERT INTO `product` VALUES ('53', '44', '三年质保服务，是指商家承诺当消费者购买其店铺内含有“三年质保”服务的商品后，若该商品在指定三年内出现质量问题，则商家将根据商品的实际故障情况，在规定时间内向消费者提供维修或补寄零配件或更换全新商品，以确保消费者可再正常使用该商品的附加服务', '/mall/admin/product/img/B157F93A5DC48CF30E0E5EB50BD585.jpg', '1', '6790', '2021-02-25 21:04:26', '3400', '天然椰棕床垫1.8米1.5米双面床垫软硬两用床垫'); INSERT INTO `product` VALUES ('54', '45', '沙发简约客厅皮布艺沙发可拆洗小户型整装沙发1111', '/mall/admin/product/img/E6199BB338446E5239C6DB3F980D08.png', '1', '7890', '2021-02-25 21:04:33', '5690', '沙发简约客厅皮布艺沙发可拆洗小户型整装沙发'); INSERT INTO `product` VALUES ('55', '45', '韩式田园双人床 卧室家具1.5米1.8m板式床架子床舒服舒服给首付GV首付', '/mall/admin/product/img/5F7127CD2E21126C6DA021341EADD6.jpg', '1', '4590', '2021-02-25 20:53:34', '3488', '韩式田园双人床 卧室家具1.5米1.8m板式床架子床'); INSERT INTO `product` VALUES ('56', '45', '1.8韩式床主卧家具1.5m高箱储物床是的法规的双方各地方规定对该公司工会', '/mall/admin/product/img/4BBD4149FD6F5027018F2B249E5B33.jpg', '1', '4545', '2021-02-25 20:53:34', '2342', '1.8韩式床主卧家具1.5m高箱储物床'); INSERT INTO `product` VALUES ('57', '44', '双人床现代简约主卧板式床 北欧卧室成套家具大床首付vdsfgvsvdvd', '/mall/admin/product/img/241DB289B79426ECA7068973C18996.jpg', '1', '45456', '2021-02-25 20:53:34', '64644', '双人床现代简约主卧板式床 北欧卧室成套家具大床'); INSERT INTO `product` VALUES ('58', '44', '私简约现代板式床卧室家具舒服舒服公司发的鬼地方的', '/mall/admin/product/img/08523F74969EB25ED6CCDD041E1F04.jpg', '1', '4564', '2021-02-25 20:53:34', '646', '私简约现代板式床卧室家具'); INSERT INTO `product` VALUES ('59', '44', '实木双人床1.8米橡木1.5米卧室家具中式全友高箱中式储物婚床多个法国恢复的功能', '/mall/admin/product/img/481A51191606382FBD13EF934BEA2B.jpg', '1', '4564', '2021-02-25 20:53:34', '5464', '实木双人床1.8米橡木1.5米卧室家具中式全友高箱中式储物婚床'); INSERT INTO `product` VALUES ('60', '44', '布艺沙发组合 客厅家具现代简约布艺转角沙发复合肥积分换积分', '/mall/admin/product/img/6B9F3ACC7FE2F82A14C686DD2B6024.jpg', '1', '456', '2021-02-25 20:53:34', '234', '布艺沙发组合 客厅家具现代简约布艺转角沙发'); INSERT INTO `product` VALUES ('61', '45', '56758', '/mall/admin/product/img/DB3C0F67CC8A39EE2F94914668500D.jpg', '1', '678', '2021-02-25 20:53:34', '68', '家具 家居正品 北欧印象 68903 白色板式双人'); INSERT INTO `product` VALUES ('62', '49', '软沙发描述测试，软沙发描述测试，软沙发描述测试，软沙发描述测试，11111', '/mall/admin/product/img/23A4F41ACD1A9A89B747A6B3BA14D2.jpg', '1', '6900', '2021-02-25 20:53:34', '4500', '软沙发测试'); -- ---------------------------- -- Table structure for user -- ---------------------------- DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `addr` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `password` varchar(255) DEFAULT NULL, `phone` varchar(255) DEFAULT NULL, `username` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of user -- ------------------------