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

– 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

【一线大厂Java面试题解析+后端开发学习笔记+最新架构讲解视频+实战项目源码讲义】
浏览器打开：qq.cn.hn/FTf 免费领取

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 (