基于java+jsp的汽车租赁系统

介绍：
jsp，servlet，mysql，eclipse，javaweb。

项目截图：








数据库表：
CREATE TABLE admin (
id int(4) NOT NULL AUTO_INCREMENT,
username varchar(50) DEFAULT NULL,
password varchar(50) DEFAULT NULL,
realname varchar(50) DEFAULT NULL,
sex varchar(50) DEFAULT NULL,
age varchar(50) DEFAULT NULL,
address varchar(50) DEFAULT NULL,
tel varchar(50) DEFAULT NULL,
addtime varchar(50) DEFAULT NULL,
sf varchar(50) DEFAULT ‘员工’,
UNIQUE KEY id (id)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

---

– Records of admin

---

INSERT INTO admin VALUES (‘1’, ‘admin’, ‘123’, ‘陈道明’, ‘男’, ‘22’, ‘成都市金牛区’, ‘admin’, ‘2017-09-28 17:50:31’, ‘管理员’);
INSERT INTO admin VALUES (‘9’, ‘yg’, ‘123’, ‘张三’, ‘男’, ‘22’, ‘测试’, ‘13888888888’, ‘2017-09-28 17:50:31’, ‘员工’);

---

– Table structure for gg

---

DROP TABLE IF EXISTS gg;
CREATE TABLE gg (
id int(4) NOT NULL AUTO_INCREMENT,
title varchar(500) DEFAULT NULL,
content text,
sj varchar(500) DEFAULT NULL,
UNIQUE KEY id (id)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

---

– Records of gg

---

INSERT INTO gg VALUES (‘1’, ‘那些超期的赶紧还车了否则罚款’, ‘那些超期的赶紧还车了否则罚款那些超期的赶紧还车了否则罚款那些超期的赶紧还车了否则罚款那些超期的赶紧还车了否则罚款那些超期的赶紧还车了否则罚款那些超期的赶紧还车了否则罚款那些超期的赶紧还车了否则罚款那些超期的赶紧还车了否则罚款那些超期的赶紧还车了否则罚款那些超期的赶紧还车了否则罚款那些超期的赶紧还车了否则罚款那些超期的赶紧还车了否则罚款那些超期的赶紧还车了否则罚款那些超期的赶紧还车了否则罚款那些超期的赶紧还车了否则罚款那些超期的赶紧还车了否则罚款那些超期的赶紧还车了否则罚款那些超期的赶紧还车了否则罚款那些超期的赶紧还车了否则罚款那些超期的赶紧还车了否则罚款那些超期的赶紧还车了否则罚款那些超期的赶紧还车了否则罚款那些超期的赶紧还车了否则罚款那些超期的赶紧还车了否则罚款那些超期的赶紧还车了否则罚款’, ‘2017-09-28’);

---

– Table structure for member

---

DROP TABLE IF EXISTS member;
CREATE TABLE member (
id int(4) NOT NULL AUTO_INCREMENT,
username varchar(500) DEFAULT NULL,
password varchar(500) DEFAULT NULL,
realname varchar(500) DEFAULT NULL,
sex varchar(500) DEFAULT NULL,
age varchar(500) DEFAULT NULL,
address varchar(500) DEFAULT NULL,
email varchar(500) DEFAULT NULL,
regtime varchar(500) DEFAULT NULL,
ifuse varchar(500) DEFAULT ‘在用’,
yue int(11) DEFAULT ‘0’,
UNIQUE KEY id (id)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

---

– Records of member

---

INSERT INTO member VALUES (‘3’, ‘zhangsan’, ‘123’, ‘张三’, ‘男’, ‘1111155’, ‘1111222555’, ‘11155@126.com’, ‘2017-09-28 17:50:31’, ‘已审核’, ‘250’);
INSERT INTO member VALUES (‘6’, ‘lisi’, ‘123’, ‘李四’, ‘男’, ‘22’, ‘22’, ‘22@126.com’, ‘2017-09-28 14:20:49’, ‘已审核’, ‘1998’);
INSERT INTO member VALUES (‘8’, ‘a’, ‘a’, ‘a’, ‘男’, ‘23’, ‘das’, ‘sad@qq.com’, ‘2019-12-04 21:20:30’, ‘已审核’, ‘-3’);
INSERT INTO member VALUES (‘9’, ‘……’, ‘123’, ‘郭丛’, ‘女’, ‘23’, ‘das’, ‘111@qq.com’, ‘2019-12-10 18:36:42’, ‘未审核’, ‘0’);

---

– Table structure for pl

---

DROP TABLE IF EXISTS pl;
CREATE TABLE pl (
id int(4) NOT NULL AUTO_INCREMENT,
nid varchar(500) DEFAULT NULL,
content varchar(500) DEFAULT NULL,
member varchar(500) DEFAULT NULL,
addtime varchar(500) DEFAULT NULL,
UNIQUE KEY id (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

---

– Records of pl

---

---

– Table structure for product

---

DROP TABLE IF EXISTS product;
CREATE TABLE product (
id int(4) NOT NULL AUTO_INCREMENT,
title varchar(500) DEFAULT NULL,
fid varchar(500) DEFAULT NULL,
pic varchar(500) DEFAULT NULL,
content text,
sj varchar(500) DEFAULT NULL,
lx varchar(500) DEFAULT NULL,
zt varchar(500) DEFAULT NULL,
zjhour int(11) DEFAULT NULL,
sl int(11) DEFAULT NULL,
dd varchar(250) DEFAULT NULL,
zjsl int(11) DEFAULT ‘0’,
UNIQUE KEY id (id)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;