010基于JSP停车管理系统

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

---

– Records of che

---

INSERT INTO che VALUES (‘1’, ‘辽B8888’, ‘大众宝来’, ‘/upload/1426251805448.jpg’, ‘3312’, ‘1’);
INSERT INTO che VALUES (‘2’, ‘123456’, ‘别克’, null, ‘44’, ‘3’);
INSERT INTO che VALUES (‘5’, ‘辽B777777’, ‘奥迪’, ‘/upload/1479630525909.jpg’, ‘123’, ‘2’);

---

– Table structure for chewei

---

DROP TABLE IF EXISTS chewei;
CREATE TABLE chewei (
id int(11) NOT NULL AUTO_INCREMENT,
hao varchar(255) DEFAULT NULL,
info varchar(255) DEFAULT NULL,
qu varchar(255) DEFAULT NULL,
chepai varchar(255) DEFAULT NULL,
adate varchar(255) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

---

– Records of chewei

---

INSERT INTO chewei VALUES (‘1’, ‘A00’, ‘A00’, ‘A区’, ‘辽B6666’, ‘2017-11-15 23:05:55’);
INSERT INTO chewei VALUES (‘2’, ‘A01’, ‘A01’, ‘A区’, ‘辽B8888’, ‘2016-11-16 21:03:37’);
INSERT INTO chewei VALUES (‘3’, ‘A02’, ‘A02’, ‘A区’, ‘辽B777777’, ‘2018-02-27 14:48:34’);
INSERT INTO chewei VALUES (‘4’, ‘A03’, ‘A03’, ‘A区’, ‘’, ‘’);
INSERT INTO chewei VALUES (‘5’, ‘B01’, ‘B01’, ‘B区’, ‘’, ‘’);
INSERT INTO chewei VALUES (‘6’, ‘B02’, ‘B02’, ‘B区’, ‘’, ‘’);
INSERT INTO chewei VALUES (‘7’, ‘C01’, ‘C01’, ‘C区’, ‘’, ‘’);
INSERT INTO chewei VALUES (‘8’, ‘C02’, ‘大飒飒’, ‘C区’, ‘’, ‘’);
INSERT INTO chewei VALUES (‘9’, ‘A00’, ‘1’, ‘A区’, ‘’, ‘’);

---

– Table structure for fei

---

DROP TABLE IF EXISTS fei;
CREATE TABLE fei (
id int(11) NOT NULL AUTO_INCREMENT,
price varchar(255) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

---

– Records of fei

---

INSERT INTO fei VALUES (‘1’, ‘4’);

---

– Table structure for userinfo

---

DROP TABLE IF EXISTS userinfo;
CREATE TABLE userinfo (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(255) DEFAULT NULL,
pwd varchar(255) DEFAULT NULL,
age varchar(255) DEFAULT NULL,
tel varchar(255) DEFAULT NULL,
jine varchar(255) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

源码下载：http://www.bycxy123.com/
视频演示：https://www.bilibili.com/video/BV1K7411a7i6/