基于SSM的美食網(wǎng)站設(shè)計(jì)設(shè)計(jì)與實(shí)現(xiàn)-計(jì)算機(jī)畢業(yè)設(shè)計(jì)源碼+LW文檔
-- ----------------------------
-- Table structure for `caipinfenlei`
-- ----------------------------
DROP TABLE IF EXISTS `caipinfenlei`;
CREATE TABLE `caipinfenlei` (
? `id` int(11) NOT NULL auto_increment,
? `caipinleixing` varchar(50) default NULL,
? `addtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
? PRIMARY KEY? (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Records of caipinfenlei
-- ----------------------------
INSERT INTO `caipinfenlei` VALUES ('2', '素食', '2022-03-03 15:53:17');
INSERT INTO `caipinfenlei` VALUES ('3', '葷菜', '2022-03-03 15:53:17');
INSERT INTO `caipinfenlei` VALUES ('4', '多油', '2022-03-03 15:53:17');
INSERT INTO `caipinfenlei` VALUES ('5', '多汁', '2022-03-03 15:53:17');
-- ----------------------------
-- Table structure for `caipinxinxi`
-- ----------------------------
DROP TABLE IF EXISTS `caipinxinxi`;
CREATE TABLE `caipinxinxi` (
? `id` int(11) NOT NULL auto_increment,
? `caipinmingcheng` varchar(50) default NULL,
? `suoshucanting` varchar(50) default NULL,
? `caipinleixing` varchar(50) default NULL,
? `jiage` varchar(50) default NULL,
? `tupian` varchar(50) default NULL,
? `caipinjieshao` varchar(500) default NULL,
? `tianjiashijian` datetime default NULL,
? `dianzan_d` int(11) default '0',
? `dianzan_c` int(11) default '0',
? `addtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
? PRIMARY KEY? (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Records of caipinxinxi
-- ----------------------------
INSERT INTO `caipinxinxi` VALUES ('2', '紅燒肉', '北京大酒店', '多油', '75', 'upload/caipinxinxi4.jpg', '好好吃', '2022-02-28 12:26:00', '0', '0', '2022-03-03 15:53:21');
INSERT INTO `caipinxinxi` VALUES ('3', '炒田螺', '北京大酒店', '多油', '46', 'upload/caipinxinxi2.jpg', '好好吃', '2022-02-14 15:33:00', '0', '0', '2022-03-03 15:53:21');
INSERT INTO `caipinxinxi` VALUES ('4', '麻婆豆腐', '北京大酒店', '多油', '30', 'upload/caipinxinxi3.jpg', '好好吃', '2022-03-19 03:14:00', '0', '0', '2022-03-03 15:53:21');
INSERT INTO `caipinxinxi` VALUES ('5', '水煮肉片', '北京大酒店', '多油', '75', 'upload/caipinxinxi3.jpg', '好好吃', '2022-03-19 03:14:00', '0', '0', '2022-03-03 15:53:21');
INSERT INTO `caipinxinxi` VALUES ('6', '清蒸水蛋', '北京大酒店', '多油', '75', 'upload/caipinxinxi1.jpg', '好好吃', '2022-03-19 03:14:00', '0', '0', '2022-03-03 15:53:21');
INSERT INTO `caipinxinxi` VALUES ('7', '麻辣水煮魚(yú)', '上海大酒店', '多汁', '34', 'upload/caipinxinxi4.jpg', '好好吃', '2022-02-14 15:33:00', '0', '0', '2022-03-03 15:53:21');
INSERT INTO `caipinxinxi` VALUES ('8', '糖醋里脊', '北京大酒店', '多汁', '77', 'upload/caipinxinxi3.jpg', '好好吃', '2022-03-26 15:28:00', '0', '0', '2022-03-03 15:53:21');
INSERT INTO `caipinxinxi` VALUES ('9', '豆腐鯽魚(yú)', '北京大酒店', '多汁', '46', 'upload/caipinxinxi7.jpg', '好好吃', '2022-02-05 06:15:00', '0', '0', '2022-03-03 15:53:21');
INSERT INTO `caipinxinxi` VALUES ('10', '紅燒肉', '上海大酒店', '多汁', '75', 'upload/caipinxinxi4.jpg', '好好吃', '2022-02-28 12:26:00', '0', '0', '2022-03-03 15:53:41');
INSERT INTO `caipinxinxi` VALUES ('11', '炒田螺', '上海大酒店', '多汁', '46', 'upload/caipinxinxi2.jpg', '好好吃', '2022-02-14 15:33:00', '0', '0', '2022-03-03 15:53:41');
INSERT INTO `caipinxinxi` VALUES ('12', '麻婆豆腐', '上海大酒店', '素食', '30', 'upload/caipinxinxi3.jpg', '好好吃', '2022-03-19 03:14:00', '0', '0', '2022-03-03 15:53:41');
INSERT INTO `caipinxinxi` VALUES ('13', '水煮肉片', '上海大酒店', '素食', '75', 'upload/caipinxinxi3.jpg', '好好吃', '2022-03-19 03:14:00', '0', '0', '2022-03-03 15:53:41');
INSERT INTO `caipinxinxi` VALUES ('14', '清蒸水蛋', '廣州大酒店', '素食', '75', 'upload/caipinxinxi1.jpg', '好好吃', '2022-03-19 03:14:00', '0', '0', '2022-03-03 15:53:41');
INSERT INTO `caipinxinxi` VALUES ('15', '麻辣水煮魚(yú)', '廣州大酒店', '素食', '34', 'upload/caipinxinxi4.jpg', '好好吃', '2022-02-14 15:33:00', '0', '0', '2022-03-03 15:53:41');
INSERT INTO `caipinxinxi` VALUES ('16', '糖醋里脊', '廣州大酒店', '葷菜', '77', 'upload/caipinxinxi3.jpg', '好好吃', '2022-03-26 15:28:00', '0', '0', '2022-03-03 15:53:41');
INSERT INTO `caipinxinxi` VALUES ('17', '豆腐鯽魚(yú)', '深圳大酒店', '葷菜', '46', 'upload/caipinxinxi7.jpg', '好好吃', '2022-02-05 06:15:00', '0', '0', '2022-03-03 15:53:41');
-- ----------------------------
-- Table structure for `cantingyuyue`
-- ----------------------------
DROP TABLE IF EXISTS `cantingyuyue`;
CREATE TABLE `cantingyuyue` (
? `id` int(11) NOT NULL auto_increment,
? `suoshucanting` varchar(50) default NULL,
? `caipinmingcheng` varchar(50) default NULL,
? `jiage` varchar(50) default NULL,
? `yuyueshuliang` varchar(50) default NULL,
? `zongjiage` varchar(50) default NULL,
? `yuyueren` varchar(50) default NULL,
? `yuyueshijian` datetime default NULL,
? `issh` varchar(10) default '否',
? `iszf` varchar(10) default '否',
? `addtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
? PRIMARY KEY? (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Records of cantingyuyue
-- ----------------------------
INSERT INTO `cantingyuyue` VALUES ('2', '上海大酒店', '麻辣水煮魚(yú)', '34', '27', '918', '004', '2022-02-17 20:33:00', '是', '是', '2022-03-03 16:39:32');
INSERT INTO `cantingyuyue` VALUES ('3', '北京大酒店', '炒田螺', '46', '27', '1242', '008', '2022-02-17 20:33:00', '是', '是', '2022-03-03 16:39:32');
INSERT INTO `cantingyuyue` VALUES ('4', '廣州大酒店', '清蒸水蛋', '75', '37', '2775', '029', '2022-03-26 20:03:00', '是', '是', '2022-03-03 16:39:32');
INSERT INTO `cantingyuyue` VALUES ('5', '深圳大酒店', '豆腐鯽魚(yú)', '46', '89', '4094', '011', '2022-04-02 06:20:00', '是', '是', '2022-03-03 16:39:32');
INSERT INTO `cantingyuyue` VALUES ('6', '北京大酒店', '糖醋里脊', '77', '23', '1771', '020', '2022-04-02 06:20:00', '是', '是', '2022-03-03 16:39:32');
INSERT INTO `cantingyuyue` VALUES ('7', '北京大酒店', '糖醋里脊', '77', '89', '6853', '019', '2022-03-26 20:03:00', '是', '是', '2022-03-03 16:39:32');
INSERT INTO `cantingyuyue` VALUES ('8', '北京大酒店', '豆腐鯽魚(yú)', '46', '23', '1058', '030', '2022-03-25 06:50:00', '是', '是', '2022-03-03 16:39:32');
INSERT INTO `cantingyuyue` VALUES ('9', '北京大酒店', '紅燒肉', '75', '97', '7275', '001', '2022-02-17 20:33:00', '是', '是', '2022-03-03 16:39:32');
-- ----------------------------
-- Table structure for `dx`
-- ----------------------------
DROP TABLE IF EXISTS `dx`;
CREATE TABLE `dx` (
? `ID` int(11) NOT NULL auto_increment,
? `leibie` varchar(50) default NULL,
? `content` longtext,
? PRIMARY KEY? (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `huiyuan`;
CREATE TABLE `huiyuan` (
? `id` int(11) NOT NULL auto_increment,
? `yonghuming` varchar(50) default NULL,
? `mima` varchar(50) default NULL,
? `xingming` varchar(50) default NULL,
? `xingbie` varchar(50) default NULL,
? `dianhua` varchar(50) default NULL,
? `shenfenzheng` varchar(50) default NULL,
? `zhaopian` varchar(50) default NULL,
? `jifen` varchar(50) default NULL,
? `yue` varchar(50) default NULL,
? `beizhu` varchar(500) default NULL,
? `dianzan_d` int(11) default '0',
? `dianzan_c` int(11) default '0',
? `addtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
? PRIMARY KEY? (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Records of huiyuan
-- ----------------------------
INSERT INTO `huiyuan` VALUES ('2', '016', '001', '官小芝', '男', '13748589658', '33032719900723568X', 'upload/huiyuan5.jpg', '87', '80', '無(wú)', '0', '0', '2022-03-03 15:53:29');
INSERT INTO `huiyuan` VALUES ('3', '008', '001', '余少慶', '女', '13910215489', '330327198406150488', 'upload/huiyuan4.jpg', '11', '61', '無(wú)', '0', '0', '2022-03-03 15:53:29');
INSERT INTO `huiyuan` VALUES ('4', '021', '001', '陳明希', '女', '18759640002', '330327198501020300', 'upload/huiyuan1.jpg', '59', '22', '暫無(wú)', '0', '0', '2022-03-03 15:53:29');
INSERT INTO `huiyuan` VALUES ('5', '013', '001', '王永民', '女', '13052154877', '330327199504059511', 'upload/huiyuan3.jpg', '89', '15', '沒(méi)問(wèn)題', '0', '0', '2022-03-03 15:53:29');
INSERT INTO `huiyuan` VALUES ('6', '007', '001', '鄧超', '女', '13623256544', '330327198811020456', 'upload/huiyuan2.jpg', '62', '10', '沒(méi)問(wèn)題', '0', '0', '2022-03-03 15:53:29');
INSERT INTO `huiyuan` VALUES ('7', '015', '001', '易建聯(lián)', '男', '13544655202', '330327198615482633', 'upload/huiyuan8.jpg', '62', '15', '暫無(wú)', '0', '0', '2022-03-03 15:53:29');
INSERT INTO `huiyuan` VALUES ('8', '020', '001', '喬維', '男', '13025896548', '330327198708070789', 'upload/huiyuan6.jpg', '89', '80', '無(wú)', '0', '0', '2022-03-03 15:53:29');
INSERT INTO `huiyuan` VALUES ('9', '001', '001', '楊穎', '男', '17706641413', '330327198805060222', 'upload/huiyuan7.jpg', '59', '48', '沒(méi)問(wèn)題', '0', '0', '2022-03-03 15:53:29');
-- ----------------------------
-- Table structure for `huiyuanyonghu`
-- ----------------------------
DROP TABLE IF EXISTS `huiyuanyonghu`;
CREATE TABLE `huiyuanyonghu` (
? `id` int(11) NOT NULL auto_increment,
? `yonghuming` varchar(50) default NULL,
? `mima` varchar(50) default NULL,
? `xingming` varchar(50) default NULL,
? `xingbie` varchar(50) default NULL,
? `dianhua` varchar(50) default NULL,
? `zhaopian` varchar(50) default NULL,
? `beizhu` varchar(500) default NULL,
? `addtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
? PRIMARY KEY? (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Records of huiyuanyonghu
-- ----------------------------
INSERT INTO `huiyuanyonghu` VALUES ('2', '007', '001', '伍兆斌', '女', '13159863241', 'upload/huiyuanyonghu1.jpg', 'abc', '2022-03-03 15:53:32');
INSERT INTO `huiyuanyonghu` VALUES ('3', '032', '001', '李中國(guó)', '女', '17706641413', 'upload/huiyuanyonghu4.jpg', 'abc', '2022-03-03 15:53:32');
INSERT INTO `huiyuanyonghu` VALUES ('4', '012', '001', '李大漢', '男', '13186835580', 'upload/huiyuanyonghu8.jpg', 'abc', '2022-03-03 15:53:32');
INSERT INTO `huiyuanyonghu` VALUES ('5', '011', '001', '孫儷', '男', '17505772420', 'upload/huiyuanyonghu6.jpg', 'abc', '2022-03-03 15:53:32');
INSERT INTO `huiyuanyonghu` VALUES ('6', '006', '001', '郭依潔', '男', '13910215489', 'upload/huiyuanyonghu2.jpg', 'abc', '2022-03-03 15:53:32');
INSERT INTO `huiyuanyonghu` VALUES ('7', '033', '001', '吳亦凡', '女', '13587835380', 'upload/huiyuanyonghu7.jpg', '沒(méi)問(wèn)題', '2022-03-03 15:53:32');
INSERT INTO `huiyuanyonghu` VALUES ('8', '024', '001', '溫宗達(dá)', '男', '18956482221', 'upload/huiyuanyonghu3.jpg', '暫無(wú)', '2022-03-03 15:53:32');
INSERT INTO `huiyuanyonghu` VALUES ('9', '001', '001', '陳明希', '男', '13623256544', 'upload/huiyuanyonghu5.jpg', 'abc', '2022-03-03 15:53:32');
INSERT INTO `huiyuanyonghu` VALUES ('10', '007', '001', '伍兆斌', '女', '13159863241', 'upload/huiyuanyonghu1.jpg', 'abc', '2022-03-03 15:53:41');
INSERT INTO `huiyuanyonghu` VALUES ('11', '032', '001', '李中國(guó)', '女', '17706641413', 'upload/huiyuanyonghu4.jpg', 'abc', '2022-03-03 15:53:41');
INSERT INTO `huiyuanyonghu` VALUES ('12', '012', '001', '李大漢', '男', '13186835580', 'upload/huiyuanyonghu8.jpg', 'abc', '2022-03-03 15:53:41');
INSERT INTO `huiyuanyonghu` VALUES ('13', '011', '001', '孫儷', '男', '17505772420', 'upload/huiyuanyonghu6.jpg', 'abc', '2022-03-03 15:53:41');
INSERT INTO `huiyuanyonghu` VALUES ('14', '006', '001', '郭依潔', '男', '13910215489', 'upload/huiyuanyonghu2.jpg', 'abc', '2022-03-03 15:53:41');
INSERT INTO `huiyuanyonghu` VALUES ('15', '033', '001', '吳亦凡', '女', '13587835380', 'upload/huiyuanyonghu7.jpg', '沒(méi)問(wèn)題', '2022-03-03 15:53:41');
INSERT INTO `huiyuanyonghu` VALUES ('16', '024', '001', '溫宗達(dá)', '男', '18956482221', 'upload/huiyuanyonghu3.jpg', '暫無(wú)', '2022-03-03 15:53:41');
INSERT INTO `huiyuanyonghu` VALUES ('17', '001', '001', '陳明希', '男', '13623256544', 'upload/huiyuanyonghu5.jpg', 'abc', '2022-03-03 15:53:41');
-- ----------------------------
-- Table structure for `liuyanban`
-- ----------------------------
DROP TABLE IF EXISTS `liuyanban`;
CREATE TABLE `liuyanban` (
? `id` int(11) NOT NULL auto_increment,
? `cheng` varchar(50) default NULL,
? `xingbie` varchar(50) default NULL,
? `QQ` varchar(50) default NULL,
? `youxiang` varchar(50) default NULL,
? `shouji` varchar(50) default NULL,
? `neirong` varchar(500) default NULL,
? `huifuneirong` varchar(500) default NULL,
? `addtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
? PRIMARY KEY? (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Records of liuyanban
-- ----------------------------
-- ----------------------------
-- Table structure for `pinglun`
-- ----------------------------
DROP TABLE IF EXISTS `pinglun`;
CREATE TABLE `pinglun` (
? `ID` int(11) NOT NULL auto_increment,
? `xinwenID` varchar(10) default NULL,
? `pinglunneirong` varchar(500) default NULL,
? `pinglunren` varchar(20) default NULL,
? `pingfen` varchar(4) default NULL,
? `biao` varchar(20) default NULL,
? `addtime` timestamp NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
? PRIMARY KEY? (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of pinglun
-- ----------------------------
-- ----------------------------
-- Table structure for `shoucangjilu`
-- ----------------------------
DROP TABLE IF EXISTS `shoucangjilu`;
CREATE TABLE `shoucangjilu` (
? `id` int(11) NOT NULL auto_increment,
? `username` varchar(50) default NULL,
? `xwid` varchar(50) default NULL,
? `ziduan` varchar(50) default NULL,
? `biao` varchar(50) default NULL,
? `addtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
? `biaoj` varchar(255) default NULL,
? PRIMARY KEY? (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gb2312;
-- ----------------------------
-- Records of shoucangjilu
-- ----------------------------
INSERT INTO `shoucangjilu` VALUES ('1', '007', '4', 'caipinmingcheng', 'caipinxinxi', '2022-03-03 16:11:49', 'cpxx');
-- ----------------------------
-- Table structure for `xinwentongzhi`
-- ----------------------------
DROP TABLE IF EXISTS `xinwentongzhi`;
CREATE TABLE `xinwentongzhi` (
? `id` int(11) NOT NULL auto_increment,
? `biaoti` varchar(50) default NULL,
? `leibie` varchar(50) default NULL,
? `neirong` text,
? `shouyetupian` varchar(50) default NULL,
? `dianjilv` varchar(50) default NULL,
? `tianjiaren` varchar(50) default NULL,
? `addtime` timestamp NOT NULL default CURRENT_TIMESTAMP,
? `zhaiyao` text,
? PRIMARY KEY? (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=207 DEFAULT CHARSET=gb2312;
?
-- ----------------------------
-- Records of xinwentongzhi
-- ----------------------------
INSERT INTO `xinwentongzhi` VALUES ('1', '變幻圖1', '變幻圖', '變幻圖', 'upload/1.jpg', '3', 'hsg', '2022-03-03 15:53:35', null);
INSERT INTO `xinwentongzhi` VALUES ('2', '變幻圖2', '變幻圖', '變幻圖', 'upload/2.jpg', '32', 'hsg', '2022-03-03 15:53:35', null);
INSERT INTO `xinwentongzhi` VALUES ('3', '變幻圖3', '變幻圖', '變幻圖', 'upload/3.jpg', '33', 'hsg', '2022-03-03 15:53:35', null);
INSERT INTO `xinwentongzhi` VALUES ('4', '變幻圖4', '變幻圖', '變幻圖', 'upload/4.jpg', '35', 'hsg', '2022-03-03 15:53:35', null);
INSERT INTO `xinwentongzhi` VALUES ('5', '變幻圖5', '變幻圖', '變幻圖', 'upload/5.jpg', '13', 'hsg', '2022-03-03 15:53:35', null);
