基于SSM的美食网站设计设计与实现-计算机毕业设计源码+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', '麻辣水煮鱼', '上海大酒店', '多汁', '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', '豆腐鲫鱼', '北京大酒店', '多汁', '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', '麻辣水煮鱼', '广州大酒店', '素食', '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', '豆腐鲫鱼', '深圳大酒店', '荤菜', '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', '上海大酒店', '麻辣水煮鱼', '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', '深圳大酒店', '豆腐鲫鱼', '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', '北京大酒店', '豆腐鲫鱼', '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', '无', '0', '0', '2022-03-03 15:53:29'); INSERT INTO ​​huiyuan​​ VALUES ('3', '008', '001', '余少庆', '女', '13910215489', '330327198406150488', 'upload/huiyuan4.jpg', '11', '61', '无', '0', '0', '2022-03-03 15:53:29'); INSERT INTO ​​huiyuan​​ VALUES ('4', '021', '001', '陈明希', '女', '18759640002', '330327198501020300', 'upload/huiyuan1.jpg', '59', '22', '暂无', '0', '0', '2022-03-03 15:53:29'); INSERT INTO ​​huiyuan​​ VALUES ('5', '013', '001', '王永民', '女', '13052154877', '330327199504059511', 'upload/huiyuan3.jpg', '89', '15', '没问题', '0', '0', '2022-03-03 15:53:29'); INSERT INTO ​​huiyuan​​ VALUES ('6', '007', '001', '邓超', '女', '13623256544', '330327198811020456', 'upload/huiyuan2.jpg', '62', '10', '没问题', '0', '0', '2022-03-03 15:53:29'); INSERT INTO ​​huiyuan​​ VALUES ('7', '015', '001', '易建联', '男', '13544655202', '330327198615482633', 'upload/huiyuan8.jpg', '62', '15', '暂无', '0', '0', '2022-03-03 15:53:29'); INSERT INTO ​​huiyuan​​ VALUES ('8', '020', '001', '乔维', '男', '13025896548', '330327198708070789', 'upload/huiyuan6.jpg', '89', '80', '无', '0', '0', '2022-03-03 15:53:29'); INSERT INTO ​​huiyuan​​ VALUES ('9', '001', '001', '杨颖', '男', '17706641413', '330327198805060222', 'upload/huiyuan7.jpg', '59', '48', '没问题', '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', '李中国', '女', '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', '没问题', '2022-03-03 15:53:32'); INSERT INTO ​​huiyuanyonghu​​ VALUES ('8', '024', '001', '温宗达', '男', '18956482221', 'upload/huiyuanyonghu3.jpg', '暂无', '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', '李中国', '女', '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', '没问题', '2022-03-03 15:53:41'); INSERT INTO ​​huiyuanyonghu​​ VALUES ('16', '024', '001', '温宗达', '男', '18956482221', 'upload/huiyuanyonghu3.jpg', '暂无', '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);