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