大家好,我是全微毕设团队的创始人,本团队擅长JAVA(SSM,SSH,SPRINGBOOT)、PYTHON、PHP、C#、安卓等多项技术。

今天将为大家分析一个幕仇美食网站,本项目是通过MVC框架技术来进行设计和实现的,项目主要用到的技术有php,javascript,html/css等,数据库使用的是MySQL。

现如今先进科学技术高速发展,计算机技术已经被社会的各个领域广泛应用。随着计算机技术和通信技术的迅猛发展,互联网的规模也逐步增大,互联网的元素也随之逐渐增加,可以利用其发展通信,也可以利用其进行商业用途,可以在互联网上进行出售、收购、宣传等操作,从而使得互联网逐渐成为当今社会上必不可少的元素,而网站就是这个里很庞大的元素之一。

现如今,美食网站是商业贸易中的一条非常重要的道路,可以把其从传统的实体模式中解放中来,网上购买美食可以为消费者提供巨大的便利。通过幕仇美食网站这个平台,可以使用户足不出户就可以了解现今丰富的美食信息,为用户提供了极大的方便,幕仇美食网站的主要功能包含:美食的类别管理、美食的信息管理、订单管理、用户的管理等。网站分为管理员、会员用户这二种用户平台。幕仇美食网站主要使用MySQL作为数据库管理系统,开发环境是WampServer,这是一个基于Web技术的B/S结构的电子商务网站。实现了一个幕仇美食网站。能够让广大消费者体验到网上平台购买美食的乐趣,为网上购买美食提供了一个管理高效的、决策科学化、安全有效的电子商务平台。

sql建表语句

/*
Navicat MySQL Data Transfer

Source Server : localhost_3306
Source Server Version : 50146
Source Host : localhost:3306
Source Database : php0107mswzxj04a5

Target Server Type : MYSQL
Target Server Version : 50146
File Encoding : 65001

Date: 2017-04-13 14:48:32
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `allusers`
-- ----------------------------
DROP TABLE IF EXISTS `allusers`;
CREATE TABLE `allusers` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`username` VARCHAR(50) DEFAULT NULL,
`pwd` VARCHAR(50) DEFAULT NULL,
`cx` VARCHAR(50) DEFAULT '普通管理员',
`addtime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records of allusers
-- ----------------------------
INSERT INTO `allusers` VALUES ('2', 'hsg', 'hsg', '超级管理员', '2016-03-25 07:46:56');

-- ----------------------------
-- Table structure for `dingdan`
-- ----------------------------
DROP TABLE IF EXISTS `dingdan`;
CREATE TABLE `dingdan` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`dingdanhao` VARCHAR(50) DEFAULT NULL,
`jine` VARCHAR(50) DEFAULT NULL,
`dingdanneirong` VARCHAR(500) DEFAULT NULL,
`yonghuming` VARCHAR(50) DEFAULT NULL,
`xingming` VARCHAR(50) DEFAULT NULL,
`youjidizhi` VARCHAR(300) DEFAULT NULL,
`youbian` VARCHAR(50) DEFAULT NULL,
`dianhua` VARCHAR(50) DEFAULT NULL,
`kuaidileixing` VARCHAR(50) DEFAULT NULL,
`kuaidifeiyong` VARCHAR(50) DEFAULT NULL,
`addtime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`issh` VARCHAR(255) DEFAULT '',
`iszf` VARCHAR(2) DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records of dingdan
-- ----------------------------
INSERT INTO `dingdan` VALUES ('1', '14912055509167', '84', '美食编号:14912039881591,件数:2;\r\n美食编号:14912040209648,件数:1;\r\n', '555', '何升高', '浙江', '325000', '13888888888', '邮政EMS15', '15', '2017-04-03 15:46:03', '', '');
INSERT INTO `dingdan` VALUES ('2', '14912057278155', '81', '美食编号:14912040209648,件数:2;\r\n美食编号:14912039693018,件数:1;\r\n', '555', '何升高', '浙江温州XXX', '325000', '13888888888', '快递送货10', '10', '2017-04-03 15:49:00', '', '');

-- ----------------------------
-- Table structure for `dx`
-- ----------------------------
DROP TABLE IF EXISTS `dx`;
CREATE TABLE `dx` (
`ID` INT(11) NOT NULL AUTO_INCREMENT,
`leibie` VARCHAR(255) CHARACTER SET utf8 DEFAULT NULL,
`content` text CHARACTER SET utf8,
`addtime` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of dx
-- ----------------------------

-- ----------------------------
-- Table structure for `goumaijilu`
-- ----------------------------
DROP TABLE IF EXISTS `goumaijilu`;
CREATE TABLE `goumaijilu` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`meishibianhao` VARCHAR(50) DEFAULT NULL,
`meishimingcheng` VARCHAR(50) DEFAULT NULL,
`meishileibie` VARCHAR(50) DEFAULT NULL,
`jiage` VARCHAR(50) DEFAULT NULL,
`goumaishuliang` VARCHAR(50) DEFAULT NULL,
`jine` VARCHAR(50) DEFAULT NULL,
`beizhu` VARCHAR(500) DEFAULT NULL,
`goumairen` VARCHAR(50) DEFAULT NULL,
`issh` VARCHAR(10) DEFAULT '',
`addtime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records of goumaijilu
-- ----------------------------
INSERT INTO `goumaijilu` VALUES ('2', '14912039881591', 'gegwewg', '类别A', '28', '2', '56', 'afdaf', 'hsg', '', '2017-04-03 15:27:14');
INSERT INTO `goumaijilu` VALUES ('3', '14912039881591', 'gegwewg', '类别A', '28', '2', '56', '', '555', '', '2017-04-03 15:40:46');
INSERT INTO `goumaijilu` VALUES ('4', '14912040209648', 'wyehddhdhd', '类别A', '28', '1', '28', '', '555', '', '2017-04-03 15:45:43');
INSERT INTO `goumaijilu` VALUES ('5', '14912040209648', 'wyehddhdhd', '类别A', '28', '2', '56', '', '555', '', '2017-04-03 15:47:40');
INSERT INTO `goumaijilu` VALUES ('6', '14912039693018', 'wrefadf', '类别B', '25', '1', '25', '', '555', '', '2017-04-03 15:47:56');

-- ----------------------------
-- Table structure for `liuyanban`
-- ----------------------------
DROP TABLE IF EXISTS `liuyanban`;
CREATE TABLE `liuyanban` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`zhanghao` VARCHAR(50) DEFAULT NULL,
`zhaopian` VARCHAR(50) DEFAULT NULL,
`xingming` VARCHAR(50) DEFAULT NULL,
`liuyan` VARCHAR(50) DEFAULT NULL,
`addtime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`huifu` VARCHAR(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records of liuyanban
-- ----------------------------
INSERT INTO `liuyanban` VALUES ('1', '555', 'uploadfile/13392103902z4y.jpg', '何升高', 'afdadf', '2017-04-03 15:49:55', 'afdafd');

-- ----------------------------
-- Table structure for `meishileibie`
-- ----------------------------
DROP TABLE IF EXISTS `meishileibie`;
CREATE TABLE `meishileibie` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`meishileibie` VARCHAR(50) DEFAULT NULL,
`addtime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records of meishileibie
-- ----------------------------
INSERT INTO `meishileibie` VALUES ('2', '类别A', '2017-04-03 15:17:46');
INSERT INTO `meishileibie` VALUES ('3', '类别B', '2017-04-03 15:17:50');
INSERT INTO `meishileibie` VALUES ('4', '类别C', '2017-04-03 15:50:47');

-- ----------------------------
-- Table structure for `meishixinxi`
-- ----------------------------
DROP TABLE IF EXISTS `meishixinxi`;
CREATE TABLE `meishixinxi` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`meishibianhao` VARCHAR(50) DEFAULT NULL,
`meishimingcheng` VARCHAR(50) DEFAULT NULL,
`meishileibie` VARCHAR(50) DEFAULT NULL,
`zhutu` VARCHAR(50) DEFAULT NULL,
`xiangqingmiaoshu` text,
`jiage` VARCHAR(50) DEFAULT NULL,
`pingfen` VARCHAR(50) DEFAULT NULL,
`faburen` VARCHAR(50) DEFAULT NULL,
`issh` VARCHAR(10) DEFAULT '',
`addtime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records of meishixinxi
-- ----------------------------
INSERT INTO `meishixinxi` VALUES ('2', '14912038745118', 'fafdafd', '类别B', 'uploadfile/1491203945fk2i.jpg', '<img src="uploadfile/1491203945fk2i.jpg" alt="" />', '25', '0', 'hsg', '', '2017-04-03 15:19:28');
INSERT INTO `meishixinxi` VALUES ('3', '14912039693018', 'wrefadf', '类别B', 'uploadfile/14912039820i8g.jpg', '<img src="uploadfile/1491203945fk2i.jpg" alt="" />', '25', '5', 'hsg', '', '2017-04-03 15:19:47');
INSERT INTO `meishixinxi` VALUES ('4', '14912039881591', 'gegwewg', '类别A', 'uploadfile/1491204001j14q.jpg', '<img src="uploadfile/1491204001j14q.jpg" alt="" />', '28', '0', 'hsg', '', '2017-04-03 15:20:19');
INSERT INTO `meishixinxi` VALUES ('5', '14912040209648', 'wyehddhdhd', '类别A', 'uploadfile/149120403115qc.jpg', '<img src="uploadfile/149120403115qc.jpg" alt="" />', '28', '5', 'hsg', '', '2017-04-03 15:20:40');
INSERT INTO `meishixinxi` VALUES ('6', '14912058521742', 'adffadfa', '类别C', 'uploadfile/1491205869qawx.jpg', '<img src="uploadfile/1491205869qawx.jpg" alt="" />', '5', '0', 'hsg', '', '2017-04-03 15:51:20');

-- ----------------------------
-- Table structure for `pinglun`
-- ----------------------------
DROP TABLE IF EXISTS `pinglun`;
CREATE TABLE `pinglun` (
`ID` INT(11) NOT NULL AUTO_INCREMENT,
`wenzhangID` VARCHAR(255) CHARACTER SET gb2312 DEFAULT NULL,
`pinglunneirong` VARCHAR(1000) CHARACTER SET gb2312 DEFAULT NULL,
`pinglunren` VARCHAR(255) CHARACTER SET gb2312 DEFAULT NULL,
`addtime` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`biao` VARCHAR(50) CHARACTER SET gb2312 DEFAULT NULL,
`pingfen` INT(11) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of pinglun
-- ----------------------------
INSERT INTO `pinglun` VALUES ('1', '3', 'fdafd', 'hsg', '2017-04-03 15:25:04', 'meishixinxi', '5');
INSERT INTO `pinglun` VALUES ('2', '5', 'adfafd', '555', '2017-04-03 15:47:29', 'meishixinxi', '5');

-- ----------------------------
-- Table structure for `shoucangjilu`
-- ----------------------------
DROP TABLE IF EXISTS `shoucangjilu`;
CREATE TABLE `shoucangjilu` (
`ID` INT(11) NOT NULL AUTO_INCREMENT,
`username` VARCHAR(255) CHARACTER SET gb2312 DEFAULT NULL,
`xwid` VARCHAR(255) CHARACTER SET gb2312 DEFAULT NULL,
`biao` VARCHAR(100) CHARACTER SET gb2312 DEFAULT NULL,
`addtime` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`ziduan` VARCHAR(255) CHARACTER SET gb2312 DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of shoucangjilu
-- ----------------------------
INSERT INTO `shoucangjilu` VALUES ('1', 'hsg', '3', 'meishixinxi', '2017-04-03 15:24:37', 'meishimingcheng');
INSERT INTO `shoucangjilu` VALUES ('2', '555', '5', 'meishixinxi', '2017-04-03 15:47:33', 'meishimingcheng');

-- ----------------------------
-- Table structure for `xinwentongzhi`
-- ----------------------------
DROP TABLE IF EXISTS `xinwentongzhi`;
CREATE TABLE `xinwentongzhi` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`biaoti` VARCHAR(500) CHARACTER SET gb2312 DEFAULT NULL,
`leibie` VARCHAR(50) CHARACTER SET gb2312 DEFAULT NULL,
`neirong` text CHARACTER SET gb2312,
`tianjiaren` VARCHAR(50) CHARACTER SET gb2312 DEFAULT NULL,
`addtime` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
`shouyetupian` VARCHAR(50) DEFAULT NULL,
`dianjilv` INT(11) DEFAULT '1',
`zhaiyao` VARCHAR(800) CHARACTER SET gb2312 DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=latin1; 



-- ----------------------------
-- Table structure for `yonghuzhuce`
-- ----------------------------
DROP TABLE IF EXISTS `yonghuzhuce`;
CREATE TABLE `yonghuzhuce` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`zhanghao` VARCHAR(50) DEFAULT NULL,
`mima` VARCHAR(50) DEFAULT NULL,
`xingming` VARCHAR(50) DEFAULT NULL,
`xingbie` VARCHAR(50) DEFAULT NULL,
`diqu` VARCHAR(50) DEFAULT NULL,
`Email` VARCHAR(50) DEFAULT NULL,
`zhaopian` VARCHAR(50) DEFAULT NULL,
`addtime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`issh` VARCHAR(10) DEFAULT '',
`shouji` VARCHAR(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records of yonghuzhuce
-- ----------------------------
INSERT INTO `yonghuzhuce` VALUES ('26', '555', '555', '何升高', '', '浙江', '[email protected]', 'uploadfile/13392103902z4y.jpg', '2016-02-19 07:46:56', '', '32235643');
INSERT INTO `yonghuzhuce` VALUES ('27', 'leejie', 'leejie', '李龙', '', '湖北', '[email protected]', 'uploadfile/1339211863x4s3.jpg', '2016-02-19 07:46:56', '', '65754745');
INSERT INTO `yonghuzhuce` VALUES ('28', 'mygod', 'mygod', '陈德才', '', '河南', '[email protected]', 'uploadfile/1339211824lezl.gif', '2016-02-19 07:46:56', '', '53464373');
INSERT INTO `yonghuzhuce` VALUES ('29', 'xwxxmx', 'xwxxmx', '吴江', '', '北京', '[email protected]', 'uploadfile/1339211786gts3.jpg', '2016-02-19 07:46:56', '', '52356474');
INSERT INTO `yonghuzhuce` VALUES ('30', '888', '888', '张三', '', '北京', '[email protected]', 'uploadfile/1491205710bedo.jpg', '2017-04-03 15:48:32', '', NULL);

-- ----------------------------
-- Table structure for `youqinglianjie`
-- ----------------------------
DROP TABLE IF EXISTS `youqinglianjie`;
CREATE TABLE `youqinglianjie` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`wangzhanmingcheng` VARCHAR(50) DEFAULT NULL,
`wangzhi` VARCHAR(50) DEFAULT NULL,
`addtime` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
`logo` VARCHAR(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Records of youqinglianjie
-- ----------------------------
INSERT INTO `youqinglianjie` VALUES ('16', '百度', 'http://www.baidu.com', '2016-02-19 07:46:56', 'uploadfile/baidu.gif');
INSERT INTO `youqinglianjie` VALUES ('17', '谷歌', 'http://www.google.cn', '2016-02-19 07:46:56', 'uploadfile/google.png');
INSERT INTO `youqinglianjie` VALUES ('18', '新浪', 'http://www.sina.com', '2016-02-19 07:46:56', 'uploadfile/sina.gif');
INSERT INTO `youqinglianjie` VALUES ('19', 'QQ', 'http://www.qq.com', '2016-02-19 07:46:56', 'uploadfile/qq.jpg');
INSERT INTO `youqinglianjie` VALUES ('20', '网易', 'http://www.163.com', '2016-02-19 07:46:56', 'uploadfile/163.png');

源码下载

02-11 03:44