- 交通事故档案管理系统的设计与实现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_bzjtz(
id int primary key auto_increment comment '主键',
sgxxName varchar(100) comment '事故信息编号',
zrr varchar(100) comment '责任人',
sfz varchar(100) comment '责任人身份证',
phone varchar(100) comment '责任人电话',
types varchar(100) comment '认缴退回',
tjrq datetime comment '操作时间',
mjId int comment '操作民警',
content varchar(100) comment '备注'
) comment '保证金台账';
用户表创建语句如下：
create table t_customer(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
customerName varchar(100) comment '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
gh varchar(100) comment '工号',
bm varchar(100) comment '部门',
js varchar(100) comment '角色'
) comment '用户';
法律法规表创建语句如下：
create table t_flfg(
id int primary key auto_increment comment '主键',
title varchar(100) comment '法律法规标题',
content varchar(100) comment '具体内容'
) comment '法律法规';
公开听证表创建语句如下：
create table t_gktz(
id int primary key auto_increment comment '主键',
sgxxName varchar(100) comment '事故信息编号',
tzdd varchar(100) comment '听证地点',
tzsj datetime comment '听证时间',
fileUrl varchar(100) comment '听证文书记录',
sply varchar(100) comment '视频录音'
) comment '公开听证';
扣放车台账表创建语句如下：
create table t_kfctz(
id int primary key auto_increment comment '主键',
sgxxName varchar(100) comment '事故信息编号',
clpz varchar(100) comment '车辆牌照',
types varchar(100) comment '扣留放归',
tjrq datetime comment '操作时间',
mjId int comment '操作民警',
content varchar(100) comment '备注'
) comment '扣放车台账';
路段表创建语句如下：
create table t_ld(
id int primary key auto_increment comment '主键',
ldName varchar(100) comment '路段',
qyName varchar(100) comment '区域',
fzr varchar(100) comment '负责人',
dh varchar(100) comment '负责人电话'
) comment '路段';
民警信息表创建语句如下：
create table t_mj(
id int primary key auto_increment comment '主键',
mjName varchar(100) comment '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
bh varchar(100) comment '编号',
bm varchar(100) comment '部门',
tx varchar(100) comment '头像'
) comment '民警信息';
区域表创建语句如下：
create table t_qy(
id int primary key auto_increment comment '主键',
qyName varchar(100) comment '区域',
jtwz varchar(100) comment '所属位置',
fzr varchar(100) comment '负责人',
dh varchar(100) comment '负责人电话'
) comment '区域';
事故处理回访表创建语句如下：
create table t_sgclhf(
id int primary key auto_increment comment '主键',
sgxxName varchar(100) comment '事故信息编号',
hfjl varchar(100) comment '回访记录',
ws varchar(100) comment '回访文书',
mjId int comment '操作民警',
tjrq datetime comment '回访时间'
) comment '事故处理回访';
事故调解表创建语句如下：
create table t_sgtj(
id int primary key auto_increment comment '主键',
sgxxName varchar(100) comment '事故信息编号',
zrr varchar(100) comment '责任人',
sfz varchar(100) comment '责任人身份证',
phone varchar(100) comment '责任人电话',
zrr2 varchar(100) comment '被动方',
sfz2 varchar(100) comment '被动方身份证',
phone2 varchar(100) comment '被动方电话',
zrsm varchar(100) comment '调解说明',
ws varchar(100) comment '调解结果文书',
mjId int comment '操作民警',
tjrq datetime comment '调解时间'
) comment '事故调解';
事故信息表创建语句如下：
create table t_sgxx(
id int primary key auto_increment comment '主键',
sgxxName varchar(100) comment '事故信息编号',
qyName varchar(100) comment '区域',
ldName varchar(100) comment '路段',
mjId int comment '民警',
content varchar(100) comment '事故信息记录',
cldj varchar(100) comment '处理单据',
showDate datetime comment '发生日期',
status varchar(100) comment '状态'
) comment '事故信息';
责任认定表创建语句如下：
create table t_zrrd(
id int primary key auto_increment comment '主键',
sgxxName varchar(100) comment '事故信息编号',
zrr varchar(100) comment '责任人',
sfz varchar(100) comment '责任人身份证',
phone varchar(100) comment '责任人电话',
zrsm varchar(100) comment '责任说明',
zrr2 varchar(100) comment '被动方',
sfz2 varchar(100) comment '被动方身份证',
phone2 varchar(100) comment '被动方电话',
ws varchar(100) comment '认定文书',
mjId int 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_bzjtz(
id integer,
sgxxName varchar(100),
zrr varchar(100),
sfz varchar(100),
phone varchar(100),
types varchar(100),
tjrq datetime,
mjId int,
content varchar(100)
);
--保证金台账字段加注释
comment on column t_bzjtz.id is '主键';
comment on column t_bzjtz.sgxxName is '事故信息编号';
comment on column t_bzjtz.zrr is '责任人';
comment on column t_bzjtz.sfz is '责任人身份证';
comment on column t_bzjtz.phone is '责任人电话';
comment on column t_bzjtz.types is '认缴退回';
comment on column t_bzjtz.tjrq is '操作时间';
comment on column t_bzjtz.mjId is '操作民警';
comment on column t_bzjtz.content is '备注';
--保证金台账表加注释
comment on table t_bzjtz is '保证金台账';
用户表创建语句如下：
create table t_customer(
id integer,
username varchar(100),
password varchar(100),
customerName varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
gh varchar(100),
bm varchar(100),
js varchar(100)
);
--用户字段加注释
comment on column t_customer.id is '主键';
comment on column t_customer.username is '账号';
comment on column t_customer.password is '密码';
comment on column t_customer.customerName is '姓名';
comment on column t_customer.phone is '电话';
comment on column t_customer.age is '年龄';
comment on column t_customer.sex is '性别';
comment on column t_customer.gh is '工号';
comment on column t_customer.bm is '部门';
comment on column t_customer.js is '角色';
--用户表加注释
comment on table t_customer is '用户';
法律法规表创建语句如下：
create table t_flfg(
id integer,
title varchar(100),
content varchar(100)
);
--法律法规字段加注释
comment on column t_flfg.id is '主键';
comment on column t_flfg.title is '法律法规标题';
comment on column t_flfg.content is '具体内容';
--法律法规表加注释
comment on table t_flfg is '法律法规';
公开听证表创建语句如下：
create table t_gktz(
id integer,
sgxxName varchar(100),
tzdd varchar(100),
tzsj datetime,
fileUrl varchar(100),
sply varchar(100)
);
--公开听证字段加注释
comment on column t_gktz.id is '主键';
comment on column t_gktz.sgxxName is '事故信息编号';
comment on column t_gktz.tzdd is '听证地点';
comment on column t_gktz.tzsj is '听证时间';
comment on column t_gktz.fileUrl is '听证文书记录';
comment on column t_gktz.sply is '视频录音';
--公开听证表加注释
comment on table t_gktz is '公开听证';
扣放车台账表创建语句如下：
create table t_kfctz(
id integer,
sgxxName varchar(100),
clpz varchar(100),
types varchar(100),
tjrq datetime,
mjId int,
content varchar(100)
);
--扣放车台账字段加注释
comment on column t_kfctz.id is '主键';
comment on column t_kfctz.sgxxName is '事故信息编号';
comment on column t_kfctz.clpz is '车辆牌照';
comment on column t_kfctz.types is '扣留放归';
comment on column t_kfctz.tjrq is '操作时间';
comment on column t_kfctz.mjId is '操作民警';
comment on column t_kfctz.content is '备注';
--扣放车台账表加注释
comment on table t_kfctz is '扣放车台账';
路段表创建语句如下：
create table t_ld(
id integer,
ldName varchar(100),
qyName varchar(100),
fzr varchar(100),
dh varchar(100)
);
--路段字段加注释
comment on column t_ld.id is '主键';
comment on column t_ld.ldName is '路段';
comment on column t_ld.qyName is '区域';
comment on column t_ld.fzr is '负责人';
comment on column t_ld.dh is '负责人电话';
--路段表加注释
comment on table t_ld is '路段';
民警信息表创建语句如下：
create table t_mj(
id integer,
mjName varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
bh varchar(100),
bm varchar(100),
tx varchar(100)
);
--民警信息字段加注释
comment on column t_mj.id is '主键';
comment on column t_mj.mjName is '姓名';
comment on column t_mj.phone is '电话';
comment on column t_mj.age is '年龄';
comment on column t_mj.sex is '性别';
comment on column t_mj.bh is '编号';
comment on column t_mj.bm is '部门';
comment on column t_mj.tx is '头像';
--民警信息表加注释
comment on table t_mj is '民警信息';
区域表创建语句如下：
create table t_qy(
id integer,
qyName varchar(100),
jtwz varchar(100),
fzr varchar(100),
dh varchar(100)
);
--区域字段加注释
comment on column t_qy.id is '主键';
comment on column t_qy.qyName is '区域';
comment on column t_qy.jtwz is '所属位置';
comment on column t_qy.fzr is '负责人';
comment on column t_qy.dh is '负责人电话';
--区域表加注释
comment on table t_qy is '区域';
事故处理回访表创建语句如下：
create table t_sgclhf(
id integer,
sgxxName varchar(100),
hfjl varchar(100),
ws varchar(100),
mjId int,
tjrq datetime
);
--事故处理回访字段加注释
comment on column t_sgclhf.id is '主键';
comment on column t_sgclhf.sgxxName is '事故信息编号';
comment on column t_sgclhf.hfjl is '回访记录';
comment on column t_sgclhf.ws is '回访文书';
comment on column t_sgclhf.mjId is '操作民警';
comment on column t_sgclhf.tjrq is '回访时间';
--事故处理回访表加注释
comment on table t_sgclhf is '事故处理回访';
事故调解表创建语句如下：
create table t_sgtj(
id integer,
sgxxName varchar(100),
zrr varchar(100),
sfz varchar(100),
phone varchar(100),
zrr2 varchar(100),
sfz2 varchar(100),
phone2 varchar(100),
zrsm varchar(100),
ws varchar(100),
mjId int,
tjrq datetime
);
--事故调解字段加注释
comment on column t_sgtj.id is '主键';
comment on column t_sgtj.sgxxName is '事故信息编号';
comment on column t_sgtj.zrr is '责任人';
comment on column t_sgtj.sfz is '责任人身份证';
comment on column t_sgtj.phone is '责任人电话';
comment on column t_sgtj.zrr2 is '被动方';
comment on column t_sgtj.sfz2 is '被动方身份证';
comment on column t_sgtj.phone2 is '被动方电话';
comment on column t_sgtj.zrsm is '调解说明';
comment on column t_sgtj.ws is '调解结果文书';
comment on column t_sgtj.mjId is '操作民警';
comment on column t_sgtj.tjrq is '调解时间';
--事故调解表加注释
comment on table t_sgtj is '事故调解';
事故信息表创建语句如下：
create table t_sgxx(
id integer,
sgxxName varchar(100),
qyName varchar(100),
ldName varchar(100),
mjId int,
content varchar(100),
cldj varchar(100),
showDate datetime,
status varchar(100)
);
--事故信息字段加注释
comment on column t_sgxx.id is '主键';
comment on column t_sgxx.sgxxName is '事故信息编号';
comment on column t_sgxx.qyName is '区域';
comment on column t_sgxx.ldName is '路段';
comment on column t_sgxx.mjId is '民警';
comment on column t_sgxx.content is '事故信息记录';
comment on column t_sgxx.cldj is '处理单据';
comment on column t_sgxx.showDate is '发生日期';
comment on column t_sgxx.status is '状态';
--事故信息表加注释
comment on table t_sgxx is '事故信息';
责任认定表创建语句如下：
create table t_zrrd(
id integer,
sgxxName varchar(100),
zrr varchar(100),
sfz varchar(100),
phone varchar(100),
zrsm varchar(100),
zrr2 varchar(100),
sfz2 varchar(100),
phone2 varchar(100),
ws varchar(100),
mjId int
);
--责任认定字段加注释
comment on column t_zrrd.id is '主键';
comment on column t_zrrd.sgxxName is '事故信息编号';
comment on column t_zrrd.zrr is '责任人';
comment on column t_zrrd.sfz is '责任人身份证';
comment on column t_zrrd.phone is '责任人电话';
comment on column t_zrrd.zrsm is '责任说明';
comment on column t_zrrd.zrr2 is '被动方';
comment on column t_zrrd.sfz2 is '被动方身份证';
comment on column t_zrrd.phone2 is '被动方电话';
comment on column t_zrrd.ws is '认定文书';
comment on column t_zrrd.mjId is '操作民警';
--责任认定表加注释
comment on table t_zrrd is '责任认定';
oracle特有，对应序列如下：
create sequence s_t_bzjtz;
create sequence s_t_customer;
create sequence s_t_flfg;
create sequence s_t_gktz;
create sequence s_t_kfctz;
create sequence s_t_ld;
create sequence s_t_mj;
create sequence s_t_qy;
create sequence s_t_sgclhf;
create sequence s_t_sgtj;
create sequence s_t_sgxx;
create sequence s_t_zrrd;
交通事故档案管理系统的设计与实现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_bzjtz(
id int identity(1,1) primary key not null,--主键
sgxxName varchar(100),--事故信息编号
zrr varchar(100),--责任人
sfz varchar(100),--责任人身份证
phone varchar(100),--责任人电话
types varchar(100),--认缴退回
tjrq datetime,--操作时间
mjId int,--操作民警
content varchar(100)--备注
);
用户表创建语句如下：
--用户表注释
create table t_customer(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
customerName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--性别
gh varchar(100),--工号
bm varchar(100),--部门
js varchar(100)--角色
);
法律法规表创建语句如下：
--法律法规表注释
create table t_flfg(
id int identity(1,1) primary key not null,--主键
title varchar(100),--法律法规标题
content varchar(100)--具体内容
);
公开听证表创建语句如下：
--公开听证表注释
create table t_gktz(
id int identity(1,1) primary key not null,--主键
sgxxName varchar(100),--事故信息编号
tzdd varchar(100),--听证地点
tzsj datetime,--听证时间
fileUrl varchar(100),--听证文书记录
sply varchar(100)--视频录音
);
扣放车台账表创建语句如下：
--扣放车台账表注释
create table t_kfctz(
id int identity(1,1) primary key not null,--主键
sgxxName varchar(100),--事故信息编号
clpz varchar(100),--车辆牌照
types varchar(100),--扣留放归
tjrq datetime,--操作时间
mjId int,--操作民警
content varchar(100)--备注
);
路段表创建语句如下：
--路段表注释
create table t_ld(
id int identity(1,1) primary key not null,--主键
ldName varchar(100),--路段
qyName varchar(100),--区域
fzr varchar(100),--负责人
dh varchar(100)--负责人电话
);
民警信息表创建语句如下：
--民警信息表注释
create table t_mj(
id int identity(1,1) primary key not null,--主键
mjName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--性别
bh varchar(100),--编号
bm varchar(100),--部门
tx varchar(100)--头像
);
区域表创建语句如下：
--区域表注释
create table t_qy(
id int identity(1,1) primary key not null,--主键
qyName varchar(100),--区域
jtwz varchar(100),--所属位置
fzr varchar(100),--负责人
dh varchar(100)--负责人电话
);
事故处理回访表创建语句如下：
--事故处理回访表注释
create table t_sgclhf(
id int identity(1,1) primary key not null,--主键
sgxxName varchar(100),--事故信息编号
hfjl varchar(100),--回访记录
ws varchar(100),--回访文书
mjId int,--操作民警
tjrq datetime--回访时间
);
事故调解表创建语句如下：
--事故调解表注释
create table t_sgtj(
id int identity(1,1) primary key not null,--主键
sgxxName varchar(100),--事故信息编号
zrr varchar(100),--责任人
sfz varchar(100),--责任人身份证
phone varchar(100),--责任人电话
zrr2 varchar(100),--被动方
sfz2 varchar(100),--被动方身份证
phone2 varchar(100),--被动方电话
zrsm varchar(100),--调解说明
ws varchar(100),--调解结果文书
mjId int,--操作民警
tjrq datetime--调解时间
);
事故信息表创建语句如下：
--事故信息表注释
create table t_sgxx(
id int identity(1,1) primary key not null,--主键
sgxxName varchar(100),--事故信息编号
qyName varchar(100),--区域
ldName varchar(100),--路段
mjId int,--民警
content varchar(100),--事故信息记录
cldj varchar(100),--处理单据
showDate datetime,--发生日期
status varchar(100)--状态
);
责任认定表创建语句如下：
--责任认定表注释
create table t_zrrd(
id int identity(1,1) primary key not null,--主键
sgxxName varchar(100),--事故信息编号
zrr varchar(100),--责任人
sfz varchar(100),--责任人身份证
phone varchar(100),--责任人电话
zrsm varchar(100),--责任说明
zrr2 varchar(100),--被动方
sfz2 varchar(100),--被动方身份证
phone2 varchar(100),--被动方电话
ws varchar(100),--认定文书
mjId int--操作民警
);
登录后主页.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_bzjtz")
public class Bzjtz {
//主键
@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 sgxxName;
//责任人
private String zrr;
//责任人身份证
private String sfz;
//责任人电话
private String phone;
//认缴退回
private String types;
//操作时间
private Date tjrq;
//操作民警
private Integer mjId;
//备注
private String content;
public String getSgxxName() {return sgxxName;}
public void setSgxxName(String sgxxName) {this.sgxxName = sgxxName;}
public String getZrr() {return zrr;}
public void setZrr(String zrr) {this.zrr = zrr;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Date getTjrq() {return tjrq;}
public void setTjrq(Date tjrq) {this.tjrq = tjrq;}
public Integer getMjId() {return mjId;}
public void setMjId(Integer mjId) {this.mjId = mjId;}
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_customer")
public class Customer {
//主键
@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 customerName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//工号
private String gh;
//部门
private String bm;
//角色
private String js;
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 getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
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 String getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getBm() {return bm;}
public void setBm(String bm) {this.bm = bm;}
public String getJs() {return js;}
public void setJs(String js) {this.js = js;}
}法律法规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_flfg")
public class Flfg {
//主键
@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;
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;}
}公开听证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_gktz")
public class Gktz {
//主键
@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 sgxxName;
//听证地点
private String tzdd;
//听证时间
private Date tzsj;
//听证文书记录
private String fileUrl;
//视频录音
private String sply;
public String getSgxxName() {return sgxxName;}
public void setSgxxName(String sgxxName) {this.sgxxName = sgxxName;}
public String getTzdd() {return tzdd;}
public void setTzdd(String tzdd) {this.tzdd = tzdd;}
public Date getTzsj() {return tzsj;}
public void setTzsj(Date tzsj) {this.tzsj = tzsj;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public String getSply() {return sply;}
public void setSply(String sply) {this.sply = sply;}
}扣放车台账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_kfctz")
public class Kfctz {
//主键
@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 sgxxName;
//车辆牌照
private String clpz;
//扣留放归
private String types;
//操作时间
private Date tjrq;
//操作民警
private Integer mjId;
//备注
private String content;
public String getSgxxName() {return sgxxName;}
public void setSgxxName(String sgxxName) {this.sgxxName = sgxxName;}
public String getClpz() {return clpz;}
public void setClpz(String clpz) {this.clpz = clpz;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Date getTjrq() {return tjrq;}
public void setTjrq(Date tjrq) {this.tjrq = tjrq;}
public Integer getMjId() {return mjId;}
public void setMjId(Integer mjId) {this.mjId = mjId;}
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_ld")
public class Ld {
//主键
@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 ldName;
//区域
private String qyName;
//负责人
private String fzr;
//负责人电话
private String dh;
public String getLdName() {return ldName;}
public void setLdName(String ldName) {this.ldName = ldName;}
public String getQyName() {return qyName;}
public void setQyName(String qyName) {this.qyName = qyName;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public String getDh() {return dh;}
public void setDh(String dh) {this.dh = dh;}
}民警信息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_mj")
public class Mj {
//主键
@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 mjName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//编号
private String bh;
//部门
private String bm;
//头像
private String tx;
public String getMjName() {return mjName;}
public void setMjName(String mjName) {this.mjName = mjName;}
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 String getBh() {return bh;}
public void setBh(String bh) {this.bh = bh;}
public String getBm() {return bm;}
public void setBm(String bm) {this.bm = bm;}
public String getTx() {return tx;}
public void setTx(String tx) {this.tx = tx;}
}区域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_qy")
public class Qy {
//主键
@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 qyName;
//所属位置
private String jtwz;
//负责人
private String fzr;
//负责人电话
private String dh;
public String getQyName() {return qyName;}
public void setQyName(String qyName) {this.qyName = qyName;}
public String getJtwz() {return jtwz;}
public void setJtwz(String jtwz) {this.jtwz = jtwz;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public String getDh() {return dh;}
public void setDh(String dh) {this.dh = dh;}
}事故处理回访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_sgclhf")
public class Sgclhf {
//主键
@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 sgxxName;
//回访记录
private String hfjl;
//回访文书
private String ws;
//操作民警
private Integer mjId;
//回访时间
private Date tjrq;
public String getSgxxName() {return sgxxName;}
public void setSgxxName(String sgxxName) {this.sgxxName = sgxxName;}
public String getHfjl() {return hfjl;}
public void setHfjl(String hfjl) {this.hfjl = hfjl;}
public String getWs() {return ws;}
public void setWs(String ws) {this.ws = ws;}
public Integer getMjId() {return mjId;}
public void setMjId(Integer mjId) {this.mjId = mjId;}
public Date getTjrq() {return tjrq;}
public void setTjrq(Date tjrq) {this.tjrq = tjrq;}
}事故调解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_sgtj")
public class Sgtj {
//主键
@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 sgxxName;
//责任人
private String zrr;
//责任人身份证
private String sfz;
//责任人电话
private String phone;
//被动方
private String zrr2;
//被动方身份证
private String sfz2;
//被动方电话
private String phone2;
//调解说明
private String zrsm;
//调解结果文书
private String ws;
//操作民警
private Integer mjId;
//调解时间
private Date tjrq;
public String getSgxxName() {return sgxxName;}
public void setSgxxName(String sgxxName) {this.sgxxName = sgxxName;}
public String getZrr() {return zrr;}
public void setZrr(String zrr) {this.zrr = zrr;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getZrr2() {return zrr2;}
public void setZrr2(String zrr2) {this.zrr2 = zrr2;}
public String getSfz2() {return sfz2;}
public void setSfz2(String sfz2) {this.sfz2 = sfz2;}
public String getPhone2() {return phone2;}
public void setPhone2(String phone2) {this.phone2 = phone2;}
public String getZrsm() {return zrsm;}
public void setZrsm(String zrsm) {this.zrsm = zrsm;}
public String getWs() {return ws;}
public void setWs(String ws) {this.ws = ws;}
public Integer getMjId() {return mjId;}
public void setMjId(Integer mjId) {this.mjId = mjId;}
public Date getTjrq() {return tjrq;}
public void setTjrq(Date tjrq) {this.tjrq = tjrq;}
}事故信息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_sgxx")
public class Sgxx {
//主键
@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 sgxxName;
//区域
private String qyName;
//路段
private String ldName;
//民警
private Integer mjId;
//事故信息记录
private String content;
//处理单据
private String cldj;
//发生日期
private Date showDate;
//状态
private String status;
public String getSgxxName() {return sgxxName;}
public void setSgxxName(String sgxxName) {this.sgxxName = sgxxName;}
public String getQyName() {return qyName;}
public void setQyName(String qyName) {this.qyName = qyName;}
public String getLdName() {return ldName;}
public void setLdName(String ldName) {this.ldName = ldName;}
public Integer getMjId() {return mjId;}
public void setMjId(Integer mjId) {this.mjId = mjId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getCldj() {return cldj;}
public void setCldj(String cldj) {this.cldj = cldj;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
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_zrrd")
public class Zrrd {
//主键
@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 sgxxName;
//责任人
private String zrr;
//责任人身份证
private String sfz;
//责任人电话
private String phone;
//责任说明
private String zrsm;
//被动方
private String zrr2;
//被动方身份证
private String sfz2;
//被动方电话
private String phone2;
//认定文书
private String ws;
//操作民警
private Integer mjId;
public String getSgxxName() {return sgxxName;}
public void setSgxxName(String sgxxName) {this.sgxxName = sgxxName;}
public String getZrr() {return zrr;}
public void setZrr(String zrr) {this.zrr = zrr;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getZrsm() {return zrsm;}
public void setZrsm(String zrsm) {this.zrsm = zrsm;}
public String getZrr2() {return zrr2;}
public void setZrr2(String zrr2) {this.zrr2 = zrr2;}
public String getSfz2() {return sfz2;}
public void setSfz2(String sfz2) {this.sfz2 = sfz2;}
public String getPhone2() {return phone2;}
public void setPhone2(String phone2) {this.phone2 = phone2;}
public String getWs() {return ws;}
public void setWs(String ws) {this.ws = ws;}
public Integer getMjId() {return mjId;}
public void setMjId(Integer mjId) {this.mjId = mjId;}
}交通事故档案管理系统的设计与实现spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
保证金台账javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//保证金台账
public class Bzjtz extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//事故信息编号
private String sgxxName;
//责任人
private String zrr;
//责任人身份证
private String sfz;
//责任人电话
private String phone;
//认缴退回
private String types;
//操作时间
private Date tjrq;
//操作民警
private Integer mjId;
//备注
private String content;
public String getSgxxName() {return sgxxName;}
public void setSgxxName(String sgxxName) {this.sgxxName = sgxxName;}
public String getZrr() {return zrr;}
public void setZrr(String zrr) {this.zrr = zrr;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Date getTjrq() {return tjrq;}
public void setTjrq(Date tjrq) {this.tjrq = tjrq;}
public Integer getMjId() {return mjId;}
public void setMjId(Integer mjId) {this.mjId = mjId;}
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 Customer 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 customerName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//工号
private String gh;
//部门
private String bm;
//角色
private String js;
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 getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
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 String getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getBm() {return bm;}
public void setBm(String bm) {this.bm = bm;}
public String getJs() {return js;}
public void setJs(String js) {this.js = js;}
}法律法规javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//法律法规
public class Flfg extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//法律法规标题
private String title;
//具体内容
private String content;
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;}
}公开听证javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//公开听证
public class Gktz extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//事故信息编号
private String sgxxName;
//听证地点
private String tzdd;
//听证时间
private Date tzsj;
//听证文书记录
private String fileUrl;
//视频录音
private String sply;
public String getSgxxName() {return sgxxName;}
public void setSgxxName(String sgxxName) {this.sgxxName = sgxxName;}
public String getTzdd() {return tzdd;}
public void setTzdd(String tzdd) {this.tzdd = tzdd;}
public Date getTzsj() {return tzsj;}
public void setTzsj(Date tzsj) {this.tzsj = tzsj;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public String getSply() {return sply;}
public void setSply(String sply) {this.sply = sply;}
}扣放车台账javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//扣放车台账
public class Kfctz extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//事故信息编号
private String sgxxName;
//车辆牌照
private String clpz;
//扣留放归
private String types;
//操作时间
private Date tjrq;
//操作民警
private Integer mjId;
//备注
private String content;
public String getSgxxName() {return sgxxName;}
public void setSgxxName(String sgxxName) {this.sgxxName = sgxxName;}
public String getClpz() {return clpz;}
public void setClpz(String clpz) {this.clpz = clpz;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Date getTjrq() {return tjrq;}
public void setTjrq(Date tjrq) {this.tjrq = tjrq;}
public Integer getMjId() {return mjId;}
public void setMjId(Integer mjId) {this.mjId = mjId;}
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 Ld extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//路段
private String ldName;
//区域
private String qyName;
//负责人
private String fzr;
//负责人电话
private String dh;
public String getLdName() {return ldName;}
public void setLdName(String ldName) {this.ldName = ldName;}
public String getQyName() {return qyName;}
public void setQyName(String qyName) {this.qyName = qyName;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public String getDh() {return dh;}
public void setDh(String dh) {this.dh = dh;}
}民警信息javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//民警信息
public class Mj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//姓名
private String mjName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//编号
private String bh;
//部门
private String bm;
//头像
private String tx;
public String getMjName() {return mjName;}
public void setMjName(String mjName) {this.mjName = mjName;}
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 String getBh() {return bh;}
public void setBh(String bh) {this.bh = bh;}
public String getBm() {return bm;}
public void setBm(String bm) {this.bm = bm;}
public String getTx() {return tx;}
public void setTx(String tx) {this.tx = tx;}
}区域javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//区域
public class Qy extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//区域
private String qyName;
//所属位置
private String jtwz;
//负责人
private String fzr;
//负责人电话
private String dh;
public String getQyName() {return qyName;}
public void setQyName(String qyName) {this.qyName = qyName;}
public String getJtwz() {return jtwz;}
public void setJtwz(String jtwz) {this.jtwz = jtwz;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public String getDh() {return dh;}
public void setDh(String dh) {this.dh = dh;}
}事故处理回访javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//事故处理回访
public class Sgclhf extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//事故信息编号
private String sgxxName;
//回访记录
private String hfjl;
//回访文书
private String ws;
//操作民警
private Integer mjId;
//回访时间
private Date tjrq;
public String getSgxxName() {return sgxxName;}
public void setSgxxName(String sgxxName) {this.sgxxName = sgxxName;}
public String getHfjl() {return hfjl;}
public void setHfjl(String hfjl) {this.hfjl = hfjl;}
public String getWs() {return ws;}
public void setWs(String ws) {this.ws = ws;}
public Integer getMjId() {return mjId;}
public void setMjId(Integer mjId) {this.mjId = mjId;}
public Date getTjrq() {return tjrq;}
public void setTjrq(Date tjrq) {this.tjrq = tjrq;}
}事故调解javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//事故调解
public class Sgtj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//事故信息编号
private String sgxxName;
//责任人
private String zrr;
//责任人身份证
private String sfz;
//责任人电话
private String phone;
//被动方
private String zrr2;
//被动方身份证
private String sfz2;
//被动方电话
private String phone2;
//调解说明
private String zrsm;
//调解结果文书
private String ws;
//操作民警
private Integer mjId;
//调解时间
private Date tjrq;
public String getSgxxName() {return sgxxName;}
public void setSgxxName(String sgxxName) {this.sgxxName = sgxxName;}
public String getZrr() {return zrr;}
public void setZrr(String zrr) {this.zrr = zrr;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getZrr2() {return zrr2;}
public void setZrr2(String zrr2) {this.zrr2 = zrr2;}
public String getSfz2() {return sfz2;}
public void setSfz2(String sfz2) {this.sfz2 = sfz2;}
public String getPhone2() {return phone2;}
public void setPhone2(String phone2) {this.phone2 = phone2;}
public String getZrsm() {return zrsm;}
public void setZrsm(String zrsm) {this.zrsm = zrsm;}
public String getWs() {return ws;}
public void setWs(String ws) {this.ws = ws;}
public Integer getMjId() {return mjId;}
public void setMjId(Integer mjId) {this.mjId = mjId;}
public Date getTjrq() {return tjrq;}
public void setTjrq(Date tjrq) {this.tjrq = tjrq;}
}事故信息javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//事故信息
public class Sgxx extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//事故信息编号
private String sgxxName;
//区域
private String qyName;
//路段
private String ldName;
//民警
private Integer mjId;
//事故信息记录
private String content;
//处理单据
private String cldj;
//发生日期
private Date showDate;
//状态
private String status;
public String getSgxxName() {return sgxxName;}
public void setSgxxName(String sgxxName) {this.sgxxName = sgxxName;}
public String getQyName() {return qyName;}
public void setQyName(String qyName) {this.qyName = qyName;}
public String getLdName() {return ldName;}
public void setLdName(String ldName) {this.ldName = ldName;}
public Integer getMjId() {return mjId;}
public void setMjId(Integer mjId) {this.mjId = mjId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getCldj() {return cldj;}
public void setCldj(String cldj) {this.cldj = cldj;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
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 Zrrd extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//事故信息编号
private String sgxxName;
//责任人
private String zrr;
//责任人身份证
private String sfz;
//责任人电话
private String phone;
//责任说明
private String zrsm;
//被动方
private String zrr2;
//被动方身份证
private String sfz2;
//被动方电话
private String phone2;
//认定文书
private String ws;
//操作民警
private Integer mjId;
public String getSgxxName() {return sgxxName;}
public void setSgxxName(String sgxxName) {this.sgxxName = sgxxName;}
public String getZrr() {return zrr;}
public void setZrr(String zrr) {this.zrr = zrr;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getZrsm() {return zrsm;}
public void setZrsm(String zrsm) {this.zrsm = zrsm;}
public String getZrr2() {return zrr2;}
public void setZrr2(String zrr2) {this.zrr2 = zrr2;}
public String getSfz2() {return sfz2;}
public void setSfz2(String sfz2) {this.sfz2 = sfz2;}
public String getPhone2() {return phone2;}
public void setPhone2(String phone2) {this.phone2 = phone2;}
public String getWs() {return ws;}
public void setWs(String ws) {this.ws = ws;}
public Integer getMjId() {return mjId;}
public void setMjId(Integer mjId) {this.mjId = mjId;}
}