大家好，我是全微毕设团队的创始人，本团队擅长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 : 50160 Source Host : localhost:3306 Source Database : phpjyqqxswzrza364 Target Server Type : MYSQL Target Server Version : 50160 File Encoding : 65001 Date: 2017-11-29 21:12:15 */ 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=11 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of allusers -- ---------------------------- INSERT INTO `allusers` VALUES ('2', 'hsg', 'hsg', '超级管理员', '2017-05-01 07:46:56'); INSERT INTO `allusers` VALUES ('9', 'aa', 'aa', '普通管理员', '2017-05-01 01:20:02'); INSERT INTO `allusers` VALUES ('10', 'bb', 'bb', '普通管理员', '2017-05-01 23:47:50'); -- ---------------------------- -- Table structure for `cheliangxinxi` -- ---------------------------- DROP TABLE IF EXISTS `cheliangxinxi`; CREATE TABLE `cheliangxinxi` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `qichebianhao` VARCHAR(50) DEFAULT NULL, `qichepinpai` VARCHAR(50) DEFAULT NULL, `qicheleixing` VARCHAR(50) DEFAULT NULL, `shangshishijian` VARCHAR(50) DEFAULT NULL, `xiaoshoujiage` VARCHAR(50) DEFAULT NULL, `qichetupian` VARCHAR(50) DEFAULT NULL, `canshujianjie` VARCHAR(500) DEFAULT NULL, `addtime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=gb2312; -- ---------------------------- -- 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; -- ---------------------------- -- Table structure for `gouwuche` -- ---------------------------- DROP TABLE IF EXISTS `gouwuche`; CREATE TABLE `gouwuche` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `qichebianhao` VARCHAR(50) DEFAULT NULL, `qichepinpai` VARCHAR(50) DEFAULT NULL, `qicheleixing` VARCHAR(50) DEFAULT NULL, `shangshishijian` VARCHAR(50) DEFAULT NULL, `xiaoshoujiage` VARCHAR(50) DEFAULT NULL, `goucheren` VARCHAR(50) DEFAULT NULL, `xingming` VARCHAR(50) DEFAULT NULL, `goucheshuliang` VARCHAR(50) DEFAULT NULL, `zongjine` VARCHAR(50) DEFAULT NULL, `beizhu` VARCHAR(500) DEFAULT NULL, `issh` VARCHAR(10) DEFAULT '否', `iszf` VARCHAR(10) DEFAULT '否', `addtime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of gouwuche -- ---------------------------- INSERT INTO `gouwuche` VALUES ('2', '15119551754703', '大众', '越野车', '2015-11-19', '200000', '555', '李媛', '1', '200000', '人大法国代购', '是', '否', '2017-11-29 19:35:44'); INSERT INTO `gouwuche` VALUES ('3', '15119551226430', '朗博基尼', '跑车', '2017-11-14', '350000', '555', '陈忠', '2', '700000', '会发光的', '是', '否', '2017-11-29 19:36:03'); -- ---------------------------- -- 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=18 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of liuyanban -- ---------------------------- INSERT INTO `liuyanban` VALUES ('1', '555', 'uploadfile/13392103902z4y.jpg', '何升高', 'gewew', '2017-05-01 05:57:10', NULL); INSERT INTO `liuyanban` VALUES ('3', '555', 'uploadfile/13392103902z4y.jpg', '何升高', '', '2017-05-01 11:32:47', NULL); INSERT INTO `liuyanban` VALUES ('17', 'fwfw', 'uploadfile/149365359831mk.jpg', '张三', 'wegwegew', '2017-05-01 23:47:05', 'fewfwe'); -- ---------------------------- -- 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=4 DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of pinglun -- ---------------------------- -- ---------------------------- -- Table structure for `qicheleixing` -- ---------------------------- DROP TABLE IF EXISTS `qicheleixing`; CREATE TABLE `qicheleixing` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `leixing` VARCHAR(50) DEFAULT NULL, `addtime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of qicheleixing -- ---------------------------- INSERT INTO `qicheleixing` VALUES ('2', '越野车', '2017-11-29 19:29:45'); INSERT INTO `qicheleixing` VALUES ('4', '跑车', '2017-11-29 19:29:57'); INSERT INTO `qicheleixing` VALUES ('5', '微型车', '2017-11-29 19:30:13'); INSERT INTO `qicheleixing` VALUES ('6', '奔驰', '2017-11-29 20:08:33'); -- ---------------------------- -- Table structure for `shangpinleibie` -- ---------------------------- DROP TABLE IF EXISTS `shangpinleibie`; CREATE TABLE `shangpinleibie` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `leibie` VARCHAR(50) DEFAULT NULL, `addtime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of shangpinleibie -- ---------------------------- INSERT INTO `shangpinleibie` VALUES ('20', '青铜陶瓷', '2017-05-01 12:29:34'); INSERT INTO `shangpinleibie` VALUES ('22', '纺织陶瓷', '2017-05-01 12:29:45'); INSERT INTO `shangpinleibie` VALUES ('23', '化工陶瓷', '2017-05-01 12:34:25'); INSERT INTO `shangpinleibie` VALUES ('24', '电器陶瓷', '2017-05-01 12:34:30'); -- ---------------------------- -- Table structure for `shangpinxinxi` -- ---------------------------- DROP TABLE IF EXISTS `shangpinxinxi`; CREATE TABLE `shangpinxinxi` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `shangpinbianhao` VARCHAR(50) DEFAULT NULL, `shangpinmingcheng` VARCHAR(300) DEFAULT NULL, `leibie` VARCHAR(50) DEFAULT NULL, `jiage` VARCHAR(50) DEFAULT NULL, `faburen` VARCHAR(50) DEFAULT NULL, `tupian` VARCHAR(50) DEFAULT NULL, `kucun` VARCHAR(50) DEFAULT NULL, `xiaoliang` VARCHAR(50) DEFAULT NULL, `jianjie` VARCHAR(500) DEFAULT NULL, `addtime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `issh` VARCHAR(10) DEFAULT '否', `chicun` VARCHAR(50) DEFAULT NULL, `yanse` VARCHAR(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=gb2312; -- ---------------------------- -- 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 -- ---------------------------- -- ---------------------------- -- 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=257 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=38 DEFAULT CHARSET=gb2312; -- ---------------------------- -- 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', '2017-05-01 07:46:56', 'uploadfile/baidu.gif'); INSERT INTO `youqinglianjie` VALUES ('17', '谷歌', 'http://www.google.cn', '2017-05-01 07:46:56', 'uploadfile/google.png'); INSERT INTO `youqinglianjie` VALUES ('18', '新浪', 'http://www.sina.com', '2017-05-01 07:46:56', 'uploadfile/sina.gif'); INSERT INTO `youqinglianjie` VALUES ('19', 'QQ', 'http://www.qq.com', '2017-05-01 07:46:56', 'uploadfile/qq.jpg'); INSERT INTO `youqinglianjie` VALUES ('20', '网易', 'http://www.163.com', '2017-05-01 07:46:56', 'uploadfile/163.png');
系统界面