Hello, I am the founder of QuanWeiBi team, which is good at JAVA(SSM,SSH,SPRINGBOOT), PYTHON, PHP, C#, Android and other technologies.
Today, we will analyze a parking lot management system. The design of the system is based on php+apache+mysql, using zendstudio and MySQL 5.1.2 as development tools, and using Photoshop CS6 technology to beautify the interface, supplemented by CSS technology. This system is a web application based on object-oriented programming.
Up to now, more and more parking lot management business has achieved the software management function, which improves the operational efficiency of the business. Whether the parking lot can manage the entrance and exit of vehicles in an orderly manner is very important for a community or a shopping mall. Parking lot management system is a business process that is very necessary.Now computerized and information-based, the traditional manual management of parking lots in the past is prone to problems such as race for parking spaces, random parking of vehicles, and inefficient management, which makes it difficult to query and organize data, so I implement a parking space management system in accordance with this demand.
The purpose of this system is to free managers from the tedious manual operation, so that managers can manage scientifically and efficiently without the influence of other factors. Simple operation and data display let managers know at a glance, thus improving managers'work efficiency, and adapting to the needs of contemporary social development.It also reduces the waste of resources.
sql table building statement
/* Navicat MySQL Data Transfer Source Server : localhost_3306 Source Server Version : 50160 Source Host : localhost:3306 Source Database : phptcccwglxt Target Server Type : MYSQL Target Server Version : 50160 File Encoding : 65001 Date: 2018-04-05 23:09:43 */ 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 'General Administrator', `addtime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of allusers -- ---------------------------- INSERT INTO `allusers` VALUES ('2', 'hsg', 'hsg', 'Super Administrator', '2018-04-04 07:46:56'); INSERT INTO `allusers` VALUES ('4', 'aa', 'aa', 'General Administrator', '2018-04-04 07:46:56'); INSERT INTO `allusers` VALUES ('5', 'bb', 'bb', 'General Administrator', '2018-04-04 07:46:56'); INSERT INTO `allusers` VALUES ('6', '1', '1', 'General Administrator', '2018-04-05 01:16:29'); INSERT INTO `allusers` VALUES ('7', '2', '2', 'General Administrator', '2018-04-05 01:25:20'); -- ---------------------------- -- Table structure for `cheliangchurujilu` -- ---------------------------- DROP TABLE IF EXISTS `cheliangchurujilu`; CREATE TABLE `cheliangchurujilu` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `chepai` VARCHAR(50) DEFAULT NULL, `chexing` VARCHAR(50) DEFAULT NULL, `tingkaochewei` VARCHAR(50) DEFAULT NULL, `chezhudianhua` VARCHAR(50) DEFAULT NULL, `shenfenzheng` VARCHAR(50) DEFAULT NULL, `beizhu` VARCHAR(50) DEFAULT NULL, `tingcheshichang` VARCHAR(50) DEFAULT NULL, `tingchefeiyong` VARCHAR(50) DEFAULT NULL, `issh` VARCHAR(10) DEFAULT 'no', `addtime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `shichushijian` VARCHAR(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of cheliangchurujilu -- ---------------------------- INSERT INTO `cheliangchurujilu` VALUES ('2', 'Zhejiang B35263', 'Small sedan car', '005', '2552323', '23626232372', 'gewgewhewh', '7', '21', 'yes', '2018-04-04 07:46:56', '2018-04-04 07:46:56'); INSERT INTO `cheliangchurujilu` VALUES ('3', 'Beijing B23445', 'Small sedan car', '005', '437437347', '74584585484', 'egewhewhw', '1', '3', 'yes', '2018-04-04 07:46:56', '2018-04-04 07:46:56'); INSERT INTO `cheliangchurujilu` VALUES ('4', 'Zhejiang B35263', 'Small sedan car', '005', '3262362', '63473733', 'hrehre', '1', '3', 'yes', '2018-04-04 07:46:56', '2018-04-04 07:46:56'); INSERT INTO `cheliangchurujilu` VALUES ('5', 'Zhejiang B35263', 'Small sedan car', '005', '2552323', '23626232372', 'gewwe', '1', '3', 'yes', '2018-04-04 07:46:56', '2018-04-04 07:46:56'); INSERT INTO `cheliangchurujilu` VALUES ('6', 'Zhejiang B35263', 'Small sedan car', '005', '2552323', '23626232372', '', '1', '3', 'yes', '2018-04-04 07:46:56', '2018-04-04 07:46:56'); INSERT INTO `cheliangchurujilu` VALUES ('7', 'Zhejiang B35261', 'Small sedan car', '002', '4373734', '745845754', 'hrhrehe', '1', '3', 'yes', '2018-04-04 07:46:56', '2018-04-04 07:46:56'); INSERT INTO `cheliangchurujilu` VALUES ('8', 'Zhejiang C45879', 'Small sedan car', '002', '63262323', '210212548210212548', 'ewggwe', '25', '75', 'yes', '2018-04-04 07:46:56', '2018-04-04 07:46:56'); INSERT INTO `cheliangchurujilu` VALUES ('9', '1233232', 'cross-country', '006', '323213123', '3233232323', '12312312', '1', '3', 'yes', '2018-04-05 01:15:15', '2018-04-05 1:15:21'); INSERT INTO `cheliangchurujilu` VALUES ('10', '32313123', 'Small sedan car', '008', '123123', '3321321321321', '3123123123123', '1', '3', 'yes', '2018-04-05 01:16:08', '2018-04-05 1:16:13'); INSERT INTO `cheliangchurujilu` VALUES ('11', '22222', 'Small sedan car', '008', '231312', '3123123', '123123123', '1', '3', 'yes', '2018-04-05 01:24:28', '2018-04-05 1:24:33'); INSERT INTO `cheliangchurujilu` VALUES ('12', '23231323', 'Small sedan car', '23232', '123123123123', '123123123123', '1231231232', '1', '3', 'yes', '2018-04-05 01:25:03', '2018-04-05 1:25:10'); -- ---------------------------- -- Table structure for `cheweixiaoshoujilu` -- ---------------------------- DROP TABLE IF EXISTS `cheweixiaoshoujilu`; CREATE TABLE `cheweixiaoshoujilu` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `cheweihao` VARCHAR(50) DEFAULT NULL, `weizhi` VARCHAR(50) DEFAULT NULL, `chezhuxingming` VARCHAR(50) DEFAULT NULL, `chezhudianhua` VARCHAR(50) DEFAULT NULL, `chepaihao` VARCHAR(50) DEFAULT NULL, `shenfenzheng` VARCHAR(50) DEFAULT NULL, `dianhua` VARCHAR(50) DEFAULT NULL, `shoujia` VARCHAR(50) DEFAULT NULL, `beizhu` VARCHAR(50) DEFAULT NULL, `addtime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of cheweixiaoshoujilu -- ---------------------------- INSERT INTO `cheweixiaoshoujilu` VALUES ('2', '002', 'Backalley', 'Zhang San', '2552323', 'Zhejiang C46342', '23626232372', '53262362', '120000', 'gwgiowgow', '2018-04-04 07:46:56'); INSERT INTO `cheweixiaoshoujilu` VALUES ('3', '003', 'Lawn', 'Li Si', '62236326', 'Beijing A44888', '6232722632', '34623623', '120000', 'quite gwhwehh', '2018-04-04 07:46:56'); INSERT INTO `cheweixiaoshoujilu` VALUES ('4', '006', 'Basement', 'htrjtr', '437734743', 'Zhejiang C46345', '773473436', '437457574', '120000', 'gewgewhw', '2018-04-04 07:46:56'); INSERT INTO `cheweixiaoshoujilu` VALUES ('5', '005', 'Basement', 'wgwewe', '63262323', 'Zhejiang C23526', '433473733463', '25235223', '25000', 'gewg', '2018-04-04 07:46:56'); INSERT INTO `cheweixiaoshoujilu` VALUES ('6', '004', 'Basement', '12313', '3123123', '32321', '3232333333333333', '333212331', '20000', '123213', '2018-04-05 01:14:40'); INSERT INTO `cheweixiaoshoujilu` VALUES ('7', '008', '008', '12313', '123123', '312312', '12312312312323', '123123', '123123', '213213123213213', '2018-04-05 01:24:12'); -- ---------------------------- -- Table structure for `cheweixinxi` -- ---------------------------- DROP TABLE IF EXISTS `cheweixinxi`; CREATE TABLE `cheweixinxi` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `cheweihao` VARCHAR(50) DEFAULT NULL, `weizhi` VARCHAR(300) DEFAULT NULL, `daxiao` VARCHAR(50) DEFAULT NULL, `zhuangtai` VARCHAR(50) DEFAULT NULL, `beizhu` VARCHAR(50) DEFAULT NULL, `issh` VARCHAR(10) DEFAULT 'no', `addtime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=gb2312; -- ---------------------------- -- Records of cheweixinxi -- ---------------------------- INSERT INTO `cheweixinxi` VALUES ('2', '001', 'Basement', 'Car', 'free', 'gewgew', 'no', '2018-04-04 07:46:56'); INSERT INTO `cheweixinxi` VALUES ('3', '002', 'Backalley', 'Van', 'free', 'ewgwgew', 'yes', '2018-04-04 07:46:56'); INSERT INTO `cheweixinxi` VALUES ('4', '003', 'Lawn', 'Car', 'free', 'rehwhw', 'yes', '2018-04-04 07:46:56'); INSERT INTO `cheweixinxi` VALUES ('5', '004', 'Basement', 'Bus', 'free', 'heherhr', 'yes', '2018-04-04 07:46:56'); INSERT INTO `cheweixinxi` VALUES ('6', '005', 'Basement', 'Car', 'free', 'gwehehw', 'yes', '2018-04-04 07:46:56'); INSERT INTO `cheweixinxi` VALUES ('7', '006', 'Basement', 'Van', 'free', 'gewgewh', 'yes', '2018-04-04 07:46:56'); INSERT INTO `cheweixinxi` VALUES ('8', '007', 'gweeh', 'Van', 'Occupy', 'wgwewe', 'yes', '2018-04-04 07:46:56'); INSERT INTO `cheweixinxi` VALUES ('9', '008', '008', 'Car', 'free', '2313123', 'yes', '2018-04-05 01:15:50'); INSERT INTO `cheweixinxi` VALUES ('10', '23232', '32323232323', 'Car', 'free', '23232323232323', 'no', '2018-04-05 01:24:46'); -- ---------------------------- -- Table structure for `danjia` -- ---------------------------- DROP TABLE IF EXISTS `danjia`; CREATE TABLE `danjia` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `dj` DOUBLE DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of danjia -- ---------------------------- INSERT INTO `danjia` VALUES ('1', '3');