大家好,我是全微毕设团队的创始人,本团队擅长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');