自行车在线租赁管理系统

自行车在线租赁管理系统登录注册界面

自行车在线租赁管理系统mysql数据库版本源码:

超级管理员表创建语句如下:


create table t_admin(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '超级管理员账号',
	password varchar(100) comment '超级管理员密码'
) comment '超级管理员';
insert into t_admin(username,password) values('admin','123456');

自行车借还表创建语句如下:


create table t_borrow(
	id int primary key auto_increment comment '主键',
	bykeId int comment '自行车',
	zjdId int comment '租借点',
	bDate datetime comment '借车时间',
	xm varchar(100) comment '姓名',
	lxfs varchar(100) comment '联系方式',
	sfz varchar(100) comment '身份证',
	tozjdId int comment '还车租借点',
	types varchar(100) comment '状态类型',
	toDate datetime comment '还车日期'
) comment '自行车借还';

自行车表创建语句如下:


create table t_byke(
	id int primary key auto_increment comment '主键',
	bh varchar(100) comment '编号',
	pp varchar(100) comment '品牌',
	xh varchar(100) comment '型号',
	ccrq datetime comment '出厂日期',
	cgrq varchar(100) comment '采购日期',
	remark varchar(100) comment '备注',
	status varchar(100) comment '状态'
) comment '自行车';

自行车分配表创建语句如下:


create table t_fp(
	id int primary key auto_increment comment '主键',
	bykeId int comment '自行车',
	zjdId int comment '租借点'
) comment '自行车分配';

其他管理表创建语句如下:


create table t_wx(
	id int primary key auto_increment comment '主键',
	bykeId int comment '自行车',
	types varchar(100) comment '类型',
	showDate datetime comment '日期'
) comment '其他管理';

租借点表创建语句如下:


create table t_zjd(
	id int primary key auto_increment comment '主键',
	bh varchar(100) comment '编号',
	mc varchar(100) comment '名称',
	dd varchar(100) comment '地点',
	slsj datetime comment '设立时间',
	remark varchar(100) comment '备注',
	glymc varchar(100) comment '管理员名称'
) comment '租借点';

租借点管理员表创建语句如下:


create table t_zjdgly(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	zjdglyName varchar(100) comment '姓名',
	phone varchar(100) comment '电话',
	sex varchar(100) comment '性别',
	address varchar(100) comment '地址',
	insertDate datetime comment '创建时间',
	updateTime datetime comment '更新时间',
	remark varchar(100) comment '备注'
) comment '租借点管理员';

自行车在线租赁管理系统oracle数据库版本源码:

超级管理员表创建语句如下:


create table t_admin(
	id integer,
	username varchar(100),
	password varchar(100)
);
insert into t_admin(id,username,password) values(1,'admin','123456');
--超级管理员字段加注释
comment on column t_admin.id is '主键';
comment on column t_admin.username is '超级管理员账号';
comment on column t_admin.password is '超级管理员密码';
--超级管理员表加注释
comment on table t_admin is '超级管理员';

自行车借还表创建语句如下:


create table t_borrow(
	id integer,
	bykeId int,
	zjdId int,
	bDate datetime,
	xm varchar(100),
	lxfs varchar(100),
	sfz varchar(100),
	tozjdId int,
	types varchar(100),
	toDate datetime
);
--自行车借还字段加注释
comment on column t_borrow.id is '主键';
comment on column t_borrow.bykeId is '自行车';
comment on column t_borrow.zjdId is '租借点';
comment on column t_borrow.bDate is '借车时间';
comment on column t_borrow.xm is '姓名';
comment on column t_borrow.lxfs is '联系方式';
comment on column t_borrow.sfz is '身份证';
comment on column t_borrow.tozjdId is '还车租借点';
comment on column t_borrow.types is '状态类型';
comment on column t_borrow.toDate is '还车日期';
--自行车借还表加注释
comment on table t_borrow is '自行车借还';

自行车表创建语句如下:


create table t_byke(
	id integer,
	bh varchar(100),
	pp varchar(100),
	xh varchar(100),
	ccrq datetime,
	cgrq varchar(100),
	remark varchar(100),
	status varchar(100)
);
--自行车字段加注释
comment on column t_byke.id is '主键';
comment on column t_byke.bh is '编号';
comment on column t_byke.pp is '品牌';
comment on column t_byke.xh is '型号';
comment on column t_byke.ccrq is '出厂日期';
comment on column t_byke.cgrq is '采购日期';
comment on column t_byke.remark is '备注';
comment on column t_byke.status is '状态';
--自行车表加注释
comment on table t_byke is '自行车';

自行车分配表创建语句如下:


create table t_fp(
	id integer,
	bykeId int,
	zjdId int
);
--自行车分配字段加注释
comment on column t_fp.id is '主键';
comment on column t_fp.bykeId is '自行车';
comment on column t_fp.zjdId is '租借点';
--自行车分配表加注释
comment on table t_fp is '自行车分配';

其他管理表创建语句如下:


create table t_wx(
	id integer,
	bykeId int,
	types varchar(100),
	showDate datetime
);
--其他管理字段加注释
comment on column t_wx.id is '主键';
comment on column t_wx.bykeId is '自行车';
comment on column t_wx.types is '类型';
comment on column t_wx.showDate is '日期';
--其他管理表加注释
comment on table t_wx is '其他管理';

租借点表创建语句如下:


create table t_zjd(
	id integer,
	bh varchar(100),
	mc varchar(100),
	dd varchar(100),
	slsj datetime,
	remark varchar(100),
	glymc varchar(100)
);
--租借点字段加注释
comment on column t_zjd.id is '主键';
comment on column t_zjd.bh is '编号';
comment on column t_zjd.mc is '名称';
comment on column t_zjd.dd is '地点';
comment on column t_zjd.slsj is '设立时间';
comment on column t_zjd.remark is '备注';
comment on column t_zjd.glymc is '管理员名称';
--租借点表加注释
comment on table t_zjd is '租借点';

租借点管理员表创建语句如下:


create table t_zjdgly(
	id integer,
	username varchar(100),
	password varchar(100),
	zjdglyName varchar(100),
	phone varchar(100),
	sex varchar(100),
	address varchar(100),
	insertDate datetime,
	updateTime datetime,
	remark varchar(100)
);
--租借点管理员字段加注释
comment on column t_zjdgly.id is '主键';
comment on column t_zjdgly.username is '账号';
comment on column t_zjdgly.password is '密码';
comment on column t_zjdgly.zjdglyName is '姓名';
comment on column t_zjdgly.phone is '电话';
comment on column t_zjdgly.sex is '性别';
comment on column t_zjdgly.address is '地址';
comment on column t_zjdgly.insertDate is '创建时间';
comment on column t_zjdgly.updateTime is '更新时间';
comment on column t_zjdgly.remark is '备注';
--租借点管理员表加注释
comment on table t_zjdgly is '租借点管理员';

oracle特有,对应序列如下:


create sequence s_t_borrow;
create sequence s_t_byke;
create sequence s_t_fp;
create sequence s_t_wx;
create sequence s_t_zjd;
create sequence s_t_zjdgly;

自行车在线租赁管理系统sqlserver数据库版本源码:

超级管理员表创建语句如下:


--超级管理员
create table t_admin(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--超级管理员账号
	password varchar(100)--超级管理员密码
);
insert into t_admin(username,password) values('admin','123456');

自行车借还表创建语句如下:


--自行车借还表注释
create table t_borrow(
	id int identity(1,1) primary key not null,--主键
	bykeId int,--自行车
	zjdId int,--租借点
	bDate datetime,--借车时间
	xm varchar(100),--姓名
	lxfs varchar(100),--联系方式
	sfz varchar(100),--身份证
	tozjdId int,--还车租借点
	types varchar(100),--状态类型
	toDate datetime--还车日期
);

自行车表创建语句如下:


--自行车表注释
create table t_byke(
	id int identity(1,1) primary key not null,--主键
	bh varchar(100),--编号
	pp varchar(100),--品牌
	xh varchar(100),--型号
	ccrq datetime,--出厂日期
	cgrq varchar(100),--采购日期
	remark varchar(100),--备注
	status varchar(100)--状态
);

自行车分配表创建语句如下:


--自行车分配表注释
create table t_fp(
	id int identity(1,1) primary key not null,--主键
	bykeId int,--自行车
	zjdId int--租借点
);

其他管理表创建语句如下:


--其他管理表注释
create table t_wx(
	id int identity(1,1) primary key not null,--主键
	bykeId int,--自行车
	types varchar(100),--类型
	showDate datetime--日期
);

租借点表创建语句如下:


--租借点表注释
create table t_zjd(
	id int identity(1,1) primary key not null,--主键
	bh varchar(100),--编号
	mc varchar(100),--名称
	dd varchar(100),--地点
	slsj datetime,--设立时间
	remark varchar(100),--备注
	glymc varchar(100)--管理员名称
);

租借点管理员表创建语句如下:


--租借点管理员表注释
create table t_zjdgly(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	zjdglyName varchar(100),--姓名
	phone varchar(100),--电话
	sex varchar(100),--性别
	address varchar(100),--地址
	insertDate datetime,--创建时间
	updateTime datetime,--更新时间
	remark varchar(100)--备注
);

自行车在线租赁管理系统登录后主页

自行车在线租赁管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计:

自行车借还javaBean创建语句如下:


package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//自行车借还
@Table(name = "t_borrow")
public class Borrow {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//自行车
private Integer bykeId;
//租借点
private Integer zjdId;
//借车时间
private Date bDate;
//姓名
private String xm;
//联系方式
private String lxfs;
//身份证
private String sfz;
//还车租借点
private Integer tozjdId;
//状态类型
private String types;
//还车日期
private Date toDate;
public Integer getBykeId() {return bykeId;}
public void setBykeId(Integer bykeId) {this.bykeId = bykeId;}
public Integer getZjdId() {return zjdId;}
public void setZjdId(Integer zjdId) {this.zjdId = zjdId;}
public Date getBDate() {return bDate;}
public void setBDate(Date bDate) {this.bDate = bDate;}
public String getXm() {return xm;}
public void setXm(String xm) {this.xm = xm;}
public String getLxfs() {return lxfs;}
public void setLxfs(String lxfs) {this.lxfs = lxfs;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public Integer getTozjdId() {return tozjdId;}
public void setTozjdId(Integer tozjdId) {this.tozjdId = tozjdId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Date getToDate() {return toDate;}
public void setToDate(Date toDate) {this.toDate = toDate;}
}

自行车javaBean创建语句如下:


package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//自行车
@Table(name = "t_byke")
public class Byke {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//编号
private String bh;
//品牌
private String pp;
//型号
private String xh;
//出厂日期
private Date ccrq;
//采购日期
private String cgrq;
//备注
private String remark;
//状态
private String status;
public String getBh() {return bh;}
public void setBh(String bh) {this.bh = bh;}
public String getPp() {return pp;}
public void setPp(String pp) {this.pp = pp;}
public String getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public Date getCcrq() {return ccrq;}
public void setCcrq(Date ccrq) {this.ccrq = ccrq;}
public String getCgrq() {return cgrq;}
public void setCgrq(String cgrq) {this.cgrq = cgrq;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}

自行车分配javaBean创建语句如下:


package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//自行车分配
@Table(name = "t_fp")
public class Fp {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//自行车
private Integer bykeId;
//租借点
private Integer zjdId;
public Integer getBykeId() {return bykeId;}
public void setBykeId(Integer bykeId) {this.bykeId = bykeId;}
public Integer getZjdId() {return zjdId;}
public void setZjdId(Integer zjdId) {this.zjdId = zjdId;}
}

其他管理javaBean创建语句如下:


package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//其他管理
@Table(name = "t_wx")
public class Wx {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//自行车
private Integer bykeId;
//类型
private String types;
//日期
private Date showDate;
public Integer getBykeId() {return bykeId;}
public void setBykeId(Integer bykeId) {this.bykeId = bykeId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}

租借点javaBean创建语句如下:


package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//租借点
@Table(name = "t_zjd")
public class Zjd {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//编号
private String bh;
//名称
private String mc;
//地点
private String dd;
//设立时间
private Date slsj;
//备注
private String remark;
//管理员名称
private String glymc;
public String getBh() {return bh;}
public void setBh(String bh) {this.bh = bh;}
public String getMc() {return mc;}
public void setMc(String mc) {this.mc = mc;}
public String getDd() {return dd;}
public void setDd(String dd) {this.dd = dd;}
public Date getSlsj() {return slsj;}
public void setSlsj(Date slsj) {this.slsj = slsj;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public String getGlymc() {return glymc;}
public void setGlymc(String glymc) {this.glymc = glymc;}
}

租借点管理员javaBean创建语句如下:


package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//租借点管理员
@Table(name = "t_zjdgly")
public class Zjdgly {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//姓名
private String zjdglyName;
//电话
private String phone;
//性别
private String sex;
//地址
private String address;
//创建时间
private Date insertDate;
//更新时间
private Date updateTime;
//备注
private String remark;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getZjdglyName() {return zjdglyName;}
public void setZjdglyName(String zjdglyName) {this.zjdglyName = zjdglyName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Date getUpdateTime() {return updateTime;}
public void setUpdateTime(Date updateTime) {this.updateTime = updateTime;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

自行车在线租赁管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

自行车借还javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//自行车借还
public class Borrow  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//自行车
private Integer bykeId;
//租借点
private Integer zjdId;
//借车时间
private Date bDate;
//姓名
private String xm;
//联系方式
private String lxfs;
//身份证
private String sfz;
//还车租借点
private Integer tozjdId;
//状态类型
private String types;
//还车日期
private Date toDate;
public Integer getBykeId() {return bykeId;}
public void setBykeId(Integer bykeId) {this.bykeId = bykeId;}
public Integer getZjdId() {return zjdId;}
public void setZjdId(Integer zjdId) {this.zjdId = zjdId;}
public Date getBDate() {return bDate;}
public void setBDate(Date bDate) {this.bDate = bDate;}
public String getXm() {return xm;}
public void setXm(String xm) {this.xm = xm;}
public String getLxfs() {return lxfs;}
public void setLxfs(String lxfs) {this.lxfs = lxfs;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public Integer getTozjdId() {return tozjdId;}
public void setTozjdId(Integer tozjdId) {this.tozjdId = tozjdId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Date getToDate() {return toDate;}
public void setToDate(Date toDate) {this.toDate = toDate;}
}

自行车javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//自行车
public class Byke  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//编号
private String bh;
//品牌
private String pp;
//型号
private String xh;
//出厂日期
private Date ccrq;
//采购日期
private String cgrq;
//备注
private String remark;
//状态
private String status;
public String getBh() {return bh;}
public void setBh(String bh) {this.bh = bh;}
public String getPp() {return pp;}
public void setPp(String pp) {this.pp = pp;}
public String getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public Date getCcrq() {return ccrq;}
public void setCcrq(Date ccrq) {this.ccrq = ccrq;}
public String getCgrq() {return cgrq;}
public void setCgrq(String cgrq) {this.cgrq = cgrq;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}

自行车分配javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//自行车分配
public class Fp  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//自行车
private Integer bykeId;
//租借点
private Integer zjdId;
public Integer getBykeId() {return bykeId;}
public void setBykeId(Integer bykeId) {this.bykeId = bykeId;}
public Integer getZjdId() {return zjdId;}
public void setZjdId(Integer zjdId) {this.zjdId = zjdId;}
}

其他管理javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//其他管理
public class Wx  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//自行车
private Integer bykeId;
//类型
private String types;
//日期
private Date showDate;
public Integer getBykeId() {return bykeId;}
public void setBykeId(Integer bykeId) {this.bykeId = bykeId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}

租借点javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//租借点
public class Zjd  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//编号
private String bh;
//名称
private String mc;
//地点
private String dd;
//设立时间
private Date slsj;
//备注
private String remark;
//管理员名称
private String glymc;
public String getBh() {return bh;}
public void setBh(String bh) {this.bh = bh;}
public String getMc() {return mc;}
public void setMc(String mc) {this.mc = mc;}
public String getDd() {return dd;}
public void setDd(String dd) {this.dd = dd;}
public Date getSlsj() {return slsj;}
public void setSlsj(Date slsj) {this.slsj = slsj;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public String getGlymc() {return glymc;}
public void setGlymc(String glymc) {this.glymc = glymc;}
}

租借点管理员javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//租借点管理员
public class Zjdgly  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//姓名
private String zjdglyName;
//电话
private String phone;
//性别
private String sex;
//地址
private String address;
//创建时间
private Date insertDate;
//更新时间
private Date updateTime;
//备注
private String remark;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getZjdglyName() {return zjdglyName;}
public void setZjdglyName(String zjdglyName) {this.zjdglyName = zjdglyName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Date getUpdateTime() {return updateTime;}
public void setUpdateTime(Date updateTime) {this.updateTime = updateTime;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

评论