- 哈尔滨市公交驾驶员安全服务管理系统mysql数据库创建语句
- 哈尔滨市公交驾驶员安全服务管理系统oracle数据库创建语句
- 哈尔滨市公交驾驶员安全服务管理系统sqlserver数据库创建语句
- 哈尔滨市公交驾驶员安全服务管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 哈尔滨市公交驾驶员安全服务管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
哈尔滨市公交驾驶员安全服务管理系统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_anquan(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
pic varchar(100) comment '图片',
fileUrl varchar(100) comment '附件',
content text comment '内容'
) comment '安全手册';
司机表创建语句如下：
create table t_driver(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
driverName varchar(100) comment '姓名',
headPic varchar(100) comment '头像',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '',
jl int comment '驾龄',
jzjb varchar(100) comment '驾照级别',
sfz varchar(100) comment '身份证',
jsz varchar(100) comment '驾驶证'
) comment '司机';
公告表创建语句如下：
create table t_gonggao(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
content text comment '内容',
insertDate datetime comment '日期'
) comment '公告';
安全建议表创建语句如下：
create table t_jianyi(
id int primary key auto_increment comment '主键',
driverId int comment '司机',
title varchar(100) comment '标题',
insertDate datetime comment '日期',
content text comment '内容',
status varchar(100) comment '状态',
back text comment '回复'
) comment '安全建议';
普通管理员表创建语句如下：
create table t_ptadmin(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
ptadminName varchar(100) comment '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别'
) comment '普通管理员';
事故表创建语句如下：
create table t_sg(
id int primary key auto_increment comment '主键',
title varchar(100) comment '事故说明',
driverId int comment '司机',
dd varchar(100) comment '地点',
zrf varchar(100) comment '责任方',
bzf varchar(100) comment '被撞方',
sfzfr varchar(100) comment '',
remark text comment '备注',
showDate datetime comment '发生日期'
) comment '事故';
投诉表创建语句如下：
create table t_ts(
id int primary key auto_increment comment '主键',
title varchar(100) comment '投诉标题',
driverId int comment '司机',
dd varchar(100) comment '地点',
showDate datetime comment '发生日期',
tsr varchar(100) comment '投诉人',
lxdh varchar(100) comment '联系方式',
remark text comment '投诉内容',
back text comment '处理结果',
iszr varchar(100) comment ''
) comment '投诉';
违章表创建语句如下：
create table t_wz(
id int primary key auto_increment comment '主键',
title varchar(100) comment '违章说明',
driverId int comment '司机',
lx varchar(100) comment '',
dd varchar(100) comment '地点',
kf int comment '扣分',
fk int comment '罚款',
remark text comment '备注',
showDate datetime 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_anquan(
id integer,
title varchar(100),
pic varchar(100),
fileUrl varchar(100),
content text
);
--安全手册字段加注释
comment on column t_anquan.id is '主键';
comment on column t_anquan.title is '标题';
comment on column t_anquan.pic is '图片';
comment on column t_anquan.fileUrl is '附件';
comment on column t_anquan.content is '内容';
--安全手册表加注释
comment on table t_anquan is '安全手册';
司机表创建语句如下：
create table t_driver(
id integer,
username varchar(100),
password varchar(100),
driverName varchar(100),
headPic varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
jl int,
jzjb varchar(100),
sfz varchar(100),
jsz varchar(100)
);
--司机字段加注释
comment on column t_driver.id is '主键';
comment on column t_driver.username is '账号';
comment on column t_driver.password is '密码';
comment on column t_driver.driverName is '姓名';
comment on column t_driver.headPic is '头像';
comment on column t_driver.phone is '电话';
comment on column t_driver.age is '年龄';
comment on column t_driver.sex is '';
comment on column t_driver.jl is '驾龄';
comment on column t_driver.jzjb is '驾照级别';
comment on column t_driver.sfz is '身份证';
comment on column t_driver.jsz is '驾驶证';
--司机表加注释
comment on table t_driver is '司机';
公告表创建语句如下：
create table t_gonggao(
id integer,
title varchar(100),
content text,
insertDate datetime
);
--公告字段加注释
comment on column t_gonggao.id is '主键';
comment on column t_gonggao.title is '标题';
comment on column t_gonggao.content is '内容';
comment on column t_gonggao.insertDate is '日期';
--公告表加注释
comment on table t_gonggao is '公告';
安全建议表创建语句如下：
create table t_jianyi(
id integer,
driverId int,
title varchar(100),
insertDate datetime,
content text,
status varchar(100),
back text
);
--安全建议字段加注释
comment on column t_jianyi.id is '主键';
comment on column t_jianyi.driverId is '司机';
comment on column t_jianyi.title is '标题';
comment on column t_jianyi.insertDate is '日期';
comment on column t_jianyi.content is '内容';
comment on column t_jianyi.status is '状态';
comment on column t_jianyi.back is '回复';
--安全建议表加注释
comment on table t_jianyi is '安全建议';
普通管理员表创建语句如下：
create table t_ptadmin(
id integer,
username varchar(100),
password varchar(100),
ptadminName varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100)
);
--普通管理员字段加注释
comment on column t_ptadmin.id is '主键';
comment on column t_ptadmin.username is '账号';
comment on column t_ptadmin.password is '密码';
comment on column t_ptadmin.ptadminName is '姓名';
comment on column t_ptadmin.phone is '电话';
comment on column t_ptadmin.age is '年龄';
comment on column t_ptadmin.sex is '性别';
--普通管理员表加注释
comment on table t_ptadmin is '普通管理员';
事故表创建语句如下：
create table t_sg(
id integer,
title varchar(100),
driverId int,
dd varchar(100),
zrf varchar(100),
bzf varchar(100),
sfzfr varchar(100),
remark text,
showDate datetime
);
--事故字段加注释
comment on column t_sg.id is '主键';
comment on column t_sg.title is '事故说明';
comment on column t_sg.driverId is '司机';
comment on column t_sg.dd is '地点';
comment on column t_sg.zrf is '责任方';
comment on column t_sg.bzf is '被撞方';
comment on column t_sg.sfzfr is '';
comment on column t_sg.remark is '备注';
comment on column t_sg.showDate is '发生日期';
--事故表加注释
comment on table t_sg is '事故';
投诉表创建语句如下：
create table t_ts(
id integer,
title varchar(100),
driverId int,
dd varchar(100),
showDate datetime,
tsr varchar(100),
lxdh varchar(100),
remark text,
back text,
iszr varchar(100)
);
--投诉字段加注释
comment on column t_ts.id is '主键';
comment on column t_ts.title is '投诉标题';
comment on column t_ts.driverId is '司机';
comment on column t_ts.dd is '地点';
comment on column t_ts.showDate is '发生日期';
comment on column t_ts.tsr is '投诉人';
comment on column t_ts.lxdh is '联系方式';
comment on column t_ts.remark is '投诉内容';
comment on column t_ts.back is '处理结果';
comment on column t_ts.iszr is '';
--投诉表加注释
comment on table t_ts is '投诉';
违章表创建语句如下：
create table t_wz(
id integer,
title varchar(100),
driverId int,
lx varchar(100),
dd varchar(100),
kf int,
fk int,
remark text,
showDate datetime
);
--违章字段加注释
comment on column t_wz.id is '主键';
comment on column t_wz.title is '违章说明';
comment on column t_wz.driverId is '司机';
comment on column t_wz.lx is '';
comment on column t_wz.dd is '地点';
comment on column t_wz.kf is '扣分';
comment on column t_wz.fk is '罚款';
comment on column t_wz.remark is '备注';
comment on column t_wz.showDate is '发生日期';
--违章表加注释
comment on table t_wz is '违章';
oracle特有，对应序列如下：
create sequence s_t_anquan;
create sequence s_t_driver;
create sequence s_t_gonggao;
create sequence s_t_jianyi;
create sequence s_t_ptadmin;
create sequence s_t_sg;
create sequence s_t_ts;
create sequence s_t_wz;
哈尔滨市公交驾驶员安全服务管理系统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_anquan(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
pic varchar(100),--图片
fileUrl varchar(100),--附件
content text--内容
);
司机表创建语句如下：
--司机表注释
create table t_driver(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
driverName varchar(100),--姓名
headPic varchar(100),--头像
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--
jl int,--驾龄
jzjb varchar(100),--驾照级别
sfz varchar(100),--身份证
jsz varchar(100)--驾驶证
);
公告表创建语句如下：
--公告表注释
create table t_gonggao(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
content text,--内容
insertDate datetime--日期
);
安全建议表创建语句如下：
--安全建议表注释
create table t_jianyi(
id int identity(1,1) primary key not null,--主键
driverId int,--司机
title varchar(100),--标题
insertDate datetime,--日期
content text,--内容
status varchar(100),--状态
back text--回复
);
普通管理员表创建语句如下：
--普通管理员表注释
create table t_ptadmin(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
ptadminName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100)--性别
);
事故表创建语句如下：
--事故表注释
create table t_sg(
id int identity(1,1) primary key not null,--主键
title varchar(100),--事故说明
driverId int,--司机
dd varchar(100),--地点
zrf varchar(100),--责任方
bzf varchar(100),--被撞方
sfzfr varchar(100),--
remark text,--备注
showDate datetime--发生日期
);
投诉表创建语句如下：
--投诉表注释
create table t_ts(
id int identity(1,1) primary key not null,--主键
title varchar(100),--投诉标题
driverId int,--司机
dd varchar(100),--地点
showDate datetime,--发生日期
tsr varchar(100),--投诉人
lxdh varchar(100),--联系方式
remark text,--投诉内容
back text,--处理结果
iszr varchar(100)--
);
违章表创建语句如下：
--违章表注释
create table t_wz(
id int identity(1,1) primary key not null,--主键
title varchar(100),--违章说明
driverId int,--司机
lx varchar(100),--
dd varchar(100),--地点
kf int,--扣分
fk int,--罚款
remark text,--备注
showDate datetime--发生日期
);
登录后主页.jpg?x-oss-process=style/00001)
哈尔滨市公交驾驶员安全服务管理系统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_anquan")
public class Anquan {
//主键
@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 title;
//图片
private String pic;
//附件
private String fileUrl;
//内容
private String content;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}司机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_driver")
public class Driver {
//主键
@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 driverName;
//头像
private String headPic;
//电话
private String phone;
//年龄
private String age;
//
private String sex;
//驾龄
private Integer jl;
//驾照级别
private String jzjb;
//身份证
private String sfz;
//驾驶证
private String jsz;
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 getDriverName() {return driverName;}
public void setDriverName(String driverName) {this.driverName = driverName;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public Integer getJl() {return jl;}
public void setJl(Integer jl) {this.jl = jl;}
public String getJzjb() {return jzjb;}
public void setJzjb(String jzjb) {this.jzjb = jzjb;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getJsz() {return jsz;}
public void setJsz(String jsz) {this.jsz = jsz;}
}公告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_gonggao")
public class Gonggao {
//主键
@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 title;
//内容
private String content;
//日期
private Date insertDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}安全建议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_jianyi")
public class Jianyi {
//主键
@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 Long driverId;
//标题
private String title;
//日期
private Date insertDate;
//内容
private String content;
//状态
private String status;
//回复
private String back;
public Long getDriverId() {return driverId;}
public void setDriverId(Long driverId) {this.driverId = driverId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}普通管理员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_ptadmin")
public class Ptadmin {
//主键
@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 ptadminName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
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 getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
}事故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_sg")
public class Sg {
//主键
@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 title;
//司机
private Long driverId;
//地点
private String dd;
//责任方
private String zrf;
//被撞方
private String bzf;
//
private String sfzfr;
//备注
private String remark;
//发生日期
private Date showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Long getDriverId() {return driverId;}
public void setDriverId(Long driverId) {this.driverId = driverId;}
public String getDd() {return dd;}
public void setDd(String dd) {this.dd = dd;}
public String getZrf() {return zrf;}
public void setZrf(String zrf) {this.zrf = zrf;}
public String getBzf() {return bzf;}
public void setBzf(String bzf) {this.bzf = bzf;}
public String getSfzfr() {return sfzfr;}
public void setSfzfr(String sfzfr) {this.sfzfr = sfzfr;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
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_ts")
public class Ts {
//主键
@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 title;
//司机
private Long driverId;
//地点
private String dd;
//发生日期
private Date showDate;
//投诉人
private String tsr;
//联系方式
private String lxdh;
//投诉内容
private String remark;
//处理结果
private String back;
//
private String iszr;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Long getDriverId() {return driverId;}
public void setDriverId(Long driverId) {this.driverId = driverId;}
public String getDd() {return dd;}
public void setDd(String dd) {this.dd = dd;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getTsr() {return tsr;}
public void setTsr(String tsr) {this.tsr = tsr;}
public String getLxdh() {return lxdh;}
public void setLxdh(String lxdh) {this.lxdh = lxdh;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
public String getIszr() {return iszr;}
public void setIszr(String iszr) {this.iszr = iszr;}
}违章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_wz")
public class Wz {
//主键
@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 title;
//司机
private Long driverId;
//
private String lx;
//地点
private String dd;
//扣分
private Integer kf;
//罚款
private Integer fk;
//备注
private String remark;
//发生日期
private Date showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Long getDriverId() {return driverId;}
public void setDriverId(Long driverId) {this.driverId = driverId;}
public String getLx() {return lx;}
public void setLx(String lx) {this.lx = lx;}
public String getDd() {return dd;}
public void setDd(String dd) {this.dd = dd;}
public Integer getKf() {return kf;}
public void setKf(Integer kf) {this.kf = kf;}
public Integer getFk() {return fk;}
public void setFk(Integer fk) {this.fk = fk;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}哈尔滨市公交驾驶员安全服务管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
安全手册javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//安全手册
public class Anquan extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//图片
private String pic;
//附件
private String fileUrl;
//内容
private String content;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}司机javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//司机
public class Driver 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 driverName;
//头像
private String headPic;
//电话
private String phone;
//年龄
private String age;
//
private String sex;
//驾龄
private Integer jl;
//驾照级别
private String jzjb;
//身份证
private String sfz;
//驾驶证
private String jsz;
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 getDriverName() {return driverName;}
public void setDriverName(String driverName) {this.driverName = driverName;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public Integer getJl() {return jl;}
public void setJl(Integer jl) {this.jl = jl;}
public String getJzjb() {return jzjb;}
public void setJzjb(String jzjb) {this.jzjb = jzjb;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getJsz() {return jsz;}
public void setJsz(String jsz) {this.jsz = jsz;}
}公告javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//公告
public class Gonggao extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//内容
private String content;
//日期
private Date insertDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}安全建议javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//安全建议
public class Jianyi extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//司机
private Long driverId;
//标题
private String title;
//日期
private Date insertDate;
//内容
private String content;
//状态
private String status;
//回复
private String back;
public Long getDriverId() {return driverId;}
public void setDriverId(Long driverId) {this.driverId = driverId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}普通管理员javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//普通管理员
public class Ptadmin 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 ptadminName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
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 getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
}事故javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//事故
public class Sg extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//事故说明
private String title;
//司机
private Long driverId;
//地点
private String dd;
//责任方
private String zrf;
//被撞方
private String bzf;
//
private String sfzfr;
//备注
private String remark;
//发生日期
@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
private Date showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Long getDriverId() {return driverId;}
public void setDriverId(Long driverId) {this.driverId = driverId;}
public String getDd() {return dd;}
public void setDd(String dd) {this.dd = dd;}
public String getZrf() {return zrf;}
public void setZrf(String zrf) {this.zrf = zrf;}
public String getBzf() {return bzf;}
public void setBzf(String bzf) {this.bzf = bzf;}
public String getSfzfr() {return sfzfr;}
public void setSfzfr(String sfzfr) {this.sfzfr = sfzfr;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
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 Ts extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//投诉标题
private String title;
//司机
private Long driverId;
//地点
private String dd;
//发生日期
@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
private Date showDate;
//投诉人
private String tsr;
//联系方式
private String lxdh;
//投诉内容
private String remark;
//处理结果
private String back;
//
private String iszr;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Long getDriverId() {return driverId;}
public void setDriverId(Long driverId) {this.driverId = driverId;}
public String getDd() {return dd;}
public void setDd(String dd) {this.dd = dd;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getTsr() {return tsr;}
public void setTsr(String tsr) {this.tsr = tsr;}
public String getLxdh() {return lxdh;}
public void setLxdh(String lxdh) {this.lxdh = lxdh;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
public String getIszr() {return iszr;}
public void setIszr(String iszr) {this.iszr = iszr;}
}违章javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//违章
public class Wz extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//违章说明
private String title;
//司机
private Long driverId;
//
private String lx;
//地点
private String dd;
//扣分
private Integer kf;
//罚款
private Integer fk;
//备注
private String remark;
//发生日期
@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
private Date showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Long getDriverId() {return driverId;}
public void setDriverId(Long driverId) {this.driverId = driverId;}
public String getLx() {return lx;}
public void setLx(String lx) {this.lx = lx;}
public String getDd() {return dd;}
public void setDd(String dd) {this.dd = dd;}
public Integer getKf() {return kf;}
public void setKf(Integer kf) {this.kf = kf;}
public Integer getFk() {return fk;}
public void setFk(Integer fk) {this.fk = fk;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}