基于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);