技术:jsp+servlet+mysql+tomcat
角色:管理员,普通用户
主要功能:
管理员管理
用户管理
车位管理
车费标准
停车缴费
车位状态
停车记录查询
部分数据库:
CREATE TABLE admin
(id
int(11) NOT NULL AUTO_INCREMENT,userName
varchar(255) DEFAULT NULL,userPw
varchar(255) DEFAULT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
– Records of admin
INSERT INTO admin
VALUES (‘1’, ‘admin’, ‘admin’);
INSERT INTO admin
VALUES (‘2’, ‘xia’, ‘329864’);
– Table structure for cfei
DROP TABLE IF EXISTS cfei
;
CREATE TABLE cfei
(id
int(11) NOT NULL AUTO_INCREMENT,hao
varchar(255) DEFAULT NULL,jdate
varchar(255) DEFAULT NULL,ldate
varchar(255) DEFAULT NULL,jine
varchar(255) DEFAULT NULL,adate
varchar(255) DEFAULT NULL,shijian
varchar(255) DEFAULT NULL,biao
varchar(255) DEFAULT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
– Records of cfei
INSERT INTO cfei
VALUES (‘1’, ‘辽B6666’, ‘2018-01-13 11:56:20’, ‘2018-01-14 20:13:24’, ‘21’, ‘2018-01-11 20:13:25’, ‘7’, ‘3’);
INSERT INTO cfei
VALUES (‘2’, ‘辽B77777’, ‘2018-01-13 11:56:20’, ‘2016-01-14 20:13:24’, ‘24’, ‘2018-01-11 20:13:25’, ‘8’, ‘3’);
– Table structure for che
DROP TABLE IF EXISTS che
;
CREATE TABLE che
(id
int(11) NOT NULL AUTO_INCREMENT,hao
varchar(255) DEFAULT NULL,leixing
varchar(255) DEFAULT NULL,pic
varchar(255) DEFAULT NULL,info
varchar(255) DEFAULT NULL,uid
int(11) DEFAULT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;