技术: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;