更多成品,定做java毕业设计,请咨询管理员qq:2812491287

车辆紧急救援系统

车辆紧急救援系统登录注册界面

车辆紧急救援系统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_customer(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	customerName varchar(100) comment '姓名',
	headPic varchar(100) comment '头像',
	phone varchar(100) comment '电话',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	gh varchar(100) comment '工号',
	zw varchar(100) comment '职位',
	bm varchar(100) comment '部门'
) comment '警察';

管理方案表创建语句如下:


create table t_glfa(
	id int primary key auto_increment comment '主键',
	sgName varchar(100) comment '事故编号',
	glfaName varchar(100) comment '方案名称',
	content varchar(100) comment '方案详细说明',
	pic varchar(100) comment '附件',
	showDate datetime comment '方案日期'
) comment '管理方案';

救援器材表创建语句如下:


create table t_jyqc(
	id int primary key auto_increment comment '主键',
	jyqcName varchar(100) comment '救援器材名称',
	v2 varchar(100) comment '编号',
	v3 varchar(100) comment '图片',
	v4 int comment '库存',
	v5 varchar(100) comment '负责人',
	v6 varchar(100) comment '作用',
	v7 varchar(100) comment '备注'
) comment '救援器材';

救援器材消耗表创建语句如下:


create table t_qcxh(
	id int primary key auto_increment comment '主键',
	jyqcName varchar(100) comment '救援器材名称',
	v2 varchar(100) comment '编号',
	v4 int comment '数量',
	v5 varchar(100) comment '使用人',
	showDate datetime comment '日期',
	v7 varchar(100) comment '备注'
) comment '救援器材消耗';

事故报警表创建语句如下:


create table t_sg(
	id int primary key auto_increment comment '主键',
	sgName varchar(100) comment '事故编号',
	v2 varchar(100) comment '事故位置',
	v3 varchar(100) comment '发生情况',
	v4 varchar(100) comment '伤亡信息',
	v7 varchar(100) comment '现场拍照',
	v5 varchar(100) comment '报警人',
	v6 varchar(100) comment '报警人联系电话',
	v8 datetime comment '事故时间'
) comment '事故报警';

事故记录表创建语句如下:


create table t_sgjl(
	id int primary key auto_increment comment '主键',
	customerId int comment '警察',
	sgName varchar(100) comment '事故编号',
	glfaName varchar(100) comment '管理方案名称',
	jyry varchar(100) comment '救援人员',
	sy varchar(100) comment '伤员',
	qcxhjl varchar(100) comment '器材消耗记录',
	remark varchar(100) comment '救援监控',
	back varchar(100) comment '调度记录',
	status varchar(100) comment '状态'
) comment '事故记录';

伤员表创建语句如下:


create table t_sy(
	id int primary key auto_increment comment '主键',
	syName varchar(100) comment '姓名',
	v2 varchar(100) comment '身份证',
	v3 varchar(100) comment '年龄',
	v4 varchar(100) comment '联系电话',
	v5 varchar(100) comment '性别',
	v6 varchar(100) comment '家庭住址',
	v7 varchar(100) comment '伤情备注',
	pz varchar(100) comment '伤情拍照'
) comment '伤员';

医疗人员表创建语句如下:


create table t_ylry(
	id int primary key auto_increment comment '主键',
	ylryName varchar(100) comment '姓名',
	v2 varchar(100) comment '来自医院',
	v3 varchar(100) comment '年龄',
	v4 varchar(100) comment '联系电话',
	v5 varchar(100) comment '性别',
	v6 varchar(100) comment '职位',
	v7 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_customer(
	id integer,
	username varchar(100),
	password varchar(100),
	customerName varchar(100),
	headPic varchar(100),
	phone varchar(100),
	age varchar(100),
	sex varchar(100),
	gh varchar(100),
	zw varchar(100),
	bm 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.headPic 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.zw is '职位';
comment on column t_customer.bm is '部门';
--警察表加注释
comment on table t_customer is '警察';

管理方案表创建语句如下:


create table t_glfa(
	id integer,
	sgName varchar(100),
	glfaName varchar(100),
	content varchar(100),
	pic varchar(100),
	showDate datetime
);
--管理方案字段加注释
comment on column t_glfa.id is '主键';
comment on column t_glfa.sgName is '事故编号';
comment on column t_glfa.glfaName is '方案名称';
comment on column t_glfa.content is '方案详细说明';
comment on column t_glfa.pic is '附件';
comment on column t_glfa.showDate is '方案日期';
--管理方案表加注释
comment on table t_glfa is '管理方案';

救援器材表创建语句如下:


create table t_jyqc(
	id integer,
	jyqcName varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 int,
	v5 varchar(100),
	v6 varchar(100),
	v7 varchar(100)
);
--救援器材字段加注释
comment on column t_jyqc.id is '主键';
comment on column t_jyqc.jyqcName is '救援器材名称';
comment on column t_jyqc.v2 is '编号';
comment on column t_jyqc.v3 is '图片';
comment on column t_jyqc.v4 is '库存';
comment on column t_jyqc.v5 is '负责人';
comment on column t_jyqc.v6 is '作用';
comment on column t_jyqc.v7 is '备注';
--救援器材表加注释
comment on table t_jyqc is '救援器材';

救援器材消耗表创建语句如下:


create table t_qcxh(
	id integer,
	jyqcName varchar(100),
	v2 varchar(100),
	v4 int,
	v5 varchar(100),
	showDate datetime,
	v7 varchar(100)
);
--救援器材消耗字段加注释
comment on column t_qcxh.id is '主键';
comment on column t_qcxh.jyqcName is '救援器材名称';
comment on column t_qcxh.v2 is '编号';
comment on column t_qcxh.v4 is '数量';
comment on column t_qcxh.v5 is '使用人';
comment on column t_qcxh.showDate is '日期';
comment on column t_qcxh.v7 is '备注';
--救援器材消耗表加注释
comment on table t_qcxh is '救援器材消耗';

事故报警表创建语句如下:


create table t_sg(
	id integer,
	sgName varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100),
	v7 varchar(100),
	v5 varchar(100),
	v6 varchar(100),
	v8 datetime
);
--事故报警字段加注释
comment on column t_sg.id is '主键';
comment on column t_sg.sgName is '事故编号';
comment on column t_sg.v2 is '事故位置';
comment on column t_sg.v3 is '发生情况';
comment on column t_sg.v4 is '伤亡信息';
comment on column t_sg.v7 is '现场拍照';
comment on column t_sg.v5 is '报警人';
comment on column t_sg.v6 is '报警人联系电话';
comment on column t_sg.v8 is '事故时间';
--事故报警表加注释
comment on table t_sg is '事故报警';

事故记录表创建语句如下:


create table t_sgjl(
	id integer,
	customerId int,
	sgName varchar(100),
	glfaName varchar(100),
	jyry varchar(100),
	sy varchar(100),
	qcxhjl varchar(100),
	remark varchar(100),
	back varchar(100),
	status varchar(100)
);
--事故记录字段加注释
comment on column t_sgjl.id is '主键';
comment on column t_sgjl.customerId is '警察';
comment on column t_sgjl.sgName is '事故编号';
comment on column t_sgjl.glfaName is '管理方案名称';
comment on column t_sgjl.jyry is '救援人员';
comment on column t_sgjl.sy is '伤员';
comment on column t_sgjl.qcxhjl is '器材消耗记录';
comment on column t_sgjl.remark is '救援监控';
comment on column t_sgjl.back is '调度记录';
comment on column t_sgjl.status is '状态';
--事故记录表加注释
comment on table t_sgjl is '事故记录';

伤员表创建语句如下:


create table t_sy(
	id integer,
	syName varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100),
	v5 varchar(100),
	v6 varchar(100),
	v7 varchar(100),
	pz varchar(100)
);
--伤员字段加注释
comment on column t_sy.id is '主键';
comment on column t_sy.syName is '姓名';
comment on column t_sy.v2 is '身份证';
comment on column t_sy.v3 is '年龄';
comment on column t_sy.v4 is '联系电话';
comment on column t_sy.v5 is '性别';
comment on column t_sy.v6 is '家庭住址';
comment on column t_sy.v7 is '伤情备注';
comment on column t_sy.pz is '伤情拍照';
--伤员表加注释
comment on table t_sy is '伤员';

医疗人员表创建语句如下:


create table t_ylry(
	id integer,
	ylryName varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100),
	v5 varchar(100),
	v6 varchar(100),
	v7 varchar(100)
);
--医疗人员字段加注释
comment on column t_ylry.id is '主键';
comment on column t_ylry.ylryName is '姓名';
comment on column t_ylry.v2 is '来自医院';
comment on column t_ylry.v3 is '年龄';
comment on column t_ylry.v4 is '联系电话';
comment on column t_ylry.v5 is '性别';
comment on column t_ylry.v6 is '职位';
comment on column t_ylry.v7 is '备注';
--医疗人员表加注释
comment on table t_ylry is '医疗人员';

oracle特有,对应序列如下:


create sequence s_t_customer;
create sequence s_t_glfa;
create sequence s_t_jyqc;
create sequence s_t_qcxh;
create sequence s_t_sg;
create sequence s_t_sgjl;
create sequence s_t_sy;
create sequence s_t_ylry;

车辆紧急救援系统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_customer(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	customerName varchar(100),--姓名
	headPic varchar(100),--头像
	phone varchar(100),--电话
	age varchar(100),--年龄
	sex varchar(100),--性别
	gh varchar(100),--工号
	zw varchar(100),--职位
	bm varchar(100)--部门
);

管理方案表创建语句如下:


--管理方案表注释
create table t_glfa(
	id int identity(1,1) primary key not null,--主键
	sgName varchar(100),--事故编号
	glfaName varchar(100),--方案名称
	content varchar(100),--方案详细说明
	pic varchar(100),--附件
	showDate datetime--方案日期
);

救援器材表创建语句如下:


--救援器材表注释
create table t_jyqc(
	id int identity(1,1) primary key not null,--主键
	jyqcName varchar(100),--救援器材名称
	v2 varchar(100),--编号
	v3 varchar(100),--图片
	v4 int,--库存
	v5 varchar(100),--负责人
	v6 varchar(100),--作用
	v7 varchar(100)--备注
);

救援器材消耗表创建语句如下:


--救援器材消耗表注释
create table t_qcxh(
	id int identity(1,1) primary key not null,--主键
	jyqcName varchar(100),--救援器材名称
	v2 varchar(100),--编号
	v4 int,--数量
	v5 varchar(100),--使用人
	showDate datetime,--日期
	v7 varchar(100)--备注
);

事故报警表创建语句如下:


--事故报警表注释
create table t_sg(
	id int identity(1,1) primary key not null,--主键
	sgName varchar(100),--事故编号
	v2 varchar(100),--事故位置
	v3 varchar(100),--发生情况
	v4 varchar(100),--伤亡信息
	v7 varchar(100),--现场拍照
	v5 varchar(100),--报警人
	v6 varchar(100),--报警人联系电话
	v8 datetime--事故时间
);

事故记录表创建语句如下:


--事故记录表注释
create table t_sgjl(
	id int identity(1,1) primary key not null,--主键
	customerId int,--警察
	sgName varchar(100),--事故编号
	glfaName varchar(100),--管理方案名称
	jyry varchar(100),--救援人员
	sy varchar(100),--伤员
	qcxhjl varchar(100),--器材消耗记录
	remark varchar(100),--救援监控
	back varchar(100),--调度记录
	status varchar(100)--状态
);

伤员表创建语句如下:


--伤员表注释
create table t_sy(
	id int identity(1,1) primary key not null,--主键
	syName varchar(100),--姓名
	v2 varchar(100),--身份证
	v3 varchar(100),--年龄
	v4 varchar(100),--联系电话
	v5 varchar(100),--性别
	v6 varchar(100),--家庭住址
	v7 varchar(100),--伤情备注
	pz varchar(100)--伤情拍照
);

医疗人员表创建语句如下:


--医疗人员表注释
create table t_ylry(
	id int identity(1,1) primary key not null,--主键
	ylryName varchar(100),--姓名
	v2 varchar(100),--来自医院
	v3 varchar(100),--年龄
	v4 varchar(100),--联系电话
	v5 varchar(100),--性别
	v6 varchar(100),--职位
	v7 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_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 headPic;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//工号
private String gh;
//职位
private String zw;
//部门
private String bm;
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 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 String getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getZw() {return zw;}
public void setZw(String zw) {this.zw = zw;}
public String getBm() {return bm;}
public void setBm(String bm) {this.bm = bm;}
}

管理方案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_glfa")
public class Glfa {
//主键
@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 sgName;
//方案名称
private String glfaName;
//方案详细说明
private String content;
//附件
private String pic;
//方案日期
private Date showDate;
public String getSgName() {return sgName;}
public void setSgName(String sgName) {this.sgName = sgName;}
public String getGlfaName() {return glfaName;}
public void setGlfaName(String glfaName) {this.glfaName = glfaName;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
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_jyqc")
public class Jyqc {
//主键
@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 jyqcName;
//编号
private String v2;
//图片
private String v3;
//库存
private Integer v4;
//负责人
private String v5;
//作用
private String v6;
//备注
private String v7;
public String getJyqcName() {return jyqcName;}
public void setJyqcName(String jyqcName) {this.jyqcName = jyqcName;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public Integer getV4() {return v4;}
public void setV4(Integer v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
}

救援器材消耗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_qcxh")
public class Qcxh {
//主键
@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 jyqcName;
//编号
private String v2;
//数量
private Integer v4;
//使用人
private String v5;
//日期
private Date showDate;
//备注
private String v7;
public String getJyqcName() {return jyqcName;}
public void setJyqcName(String jyqcName) {this.jyqcName = jyqcName;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public Integer getV4() {return v4;}
public void setV4(Integer v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
}

事故报警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 sgName;
//事故位置
private String v2;
//发生情况
private String v3;
//伤亡信息
private String v4;
//现场拍照
private String v7;
//报警人
private String v5;
//报警人联系电话
private String v6;
//事故时间
private Date v8;
public String getSgName() {return sgName;}
public void setSgName(String sgName) {this.sgName = sgName;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public Date getV8() {return v8;}
public void setV8(Date v8) {this.v8 = v8;}
}

事故记录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_sgjl")
public class Sgjl {
//主键
@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 customerId;
//事故编号
private String sgName;
//管理方案名称
private String glfaName;
//救援人员
private String jyry;
//伤员
private String sy;
//器材消耗记录
private String qcxhjl;
//救援监控
private String remark;
//调度记录
private String back;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getSgName() {return sgName;}
public void setSgName(String sgName) {this.sgName = sgName;}
public String getGlfaName() {return glfaName;}
public void setGlfaName(String glfaName) {this.glfaName = glfaName;}
public String getJyry() {return jyry;}
public void setJyry(String jyry) {this.jyry = jyry;}
public String getSy() {return sy;}
public void setSy(String sy) {this.sy = sy;}
public String getQcxhjl() {return qcxhjl;}
public void setQcxhjl(String qcxhjl) {this.qcxhjl = qcxhjl;}
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 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_sy")
public class Sy {
//主键
@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 syName;
//身份证
private String v2;
//年龄
private String v3;
//联系电话
private String v4;
//性别
private String v5;
//家庭住址
private String v6;
//伤情备注
private String v7;
//伤情拍照
private String pz;
public String getSyName() {return syName;}
public void setSyName(String syName) {this.syName = syName;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
public String getPz() {return pz;}
public void setPz(String pz) {this.pz = pz;}
}

医疗人员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_ylry")
public class Ylry {
//主键
@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 ylryName;
//来自医院
private String v2;
//年龄
private String v3;
//联系电话
private String v4;
//性别
private String v5;
//职位
private String v6;
//备注
private String v7;
public String getYlryName() {return ylryName;}
public void setYlryName(String ylryName) {this.ylryName = ylryName;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
}

车辆紧急救援系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

警察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 headPic;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//工号
private String gh;
//职位
private String zw;
//部门
private String bm;
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 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 String getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getZw() {return zw;}
public void setZw(String zw) {this.zw = zw;}
public String getBm() {return bm;}
public void setBm(String bm) {this.bm = bm;}
}

管理方案javaBean创建语句如下:


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

//管理方案
public class Glfa  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//事故编号
private String sgName;
//方案名称
private String glfaName;
//方案详细说明
private String content;
//附件
private String pic;
//方案日期
private Date showDate;
public String getSgName() {return sgName;}
public void setSgName(String sgName) {this.sgName = sgName;}
public String getGlfaName() {return glfaName;}
public void setGlfaName(String glfaName) {this.glfaName = glfaName;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
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 Jyqc  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//救援器材名称
private String jyqcName;
//编号
private String v2;
//图片
private String v3;
//库存
private Integer v4;
//负责人
private String v5;
//作用
private String v6;
//备注
private String v7;
public String getJyqcName() {return jyqcName;}
public void setJyqcName(String jyqcName) {this.jyqcName = jyqcName;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public Integer getV4() {return v4;}
public void setV4(Integer v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
}

救援器材消耗javaBean创建语句如下:


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

//救援器材消耗
public class Qcxh  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//救援器材名称
private String jyqcName;
//编号
private String v2;
//数量
private Integer v4;
//使用人
private String v5;
//日期
private Date showDate;
//备注
private String v7;
public String getJyqcName() {return jyqcName;}
public void setJyqcName(String jyqcName) {this.jyqcName = jyqcName;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public Integer getV4() {return v4;}
public void setV4(Integer v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
}

事故报警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 sgName;
//事故位置
private String v2;
//发生情况
private String v3;
//伤亡信息
private String v4;
//现场拍照
private String v7;
//报警人
private String v5;
//报警人联系电话
private String v6;
//事故时间
private Date v8;
public String getSgName() {return sgName;}
public void setSgName(String sgName) {this.sgName = sgName;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public Date getV8() {return v8;}
public void setV8(Date v8) {this.v8 = v8;}
}

事故记录javaBean创建语句如下:


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

//事故记录
public class Sgjl  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//警察
private Integer customerId;
//事故编号
private String sgName;
//管理方案名称
private String glfaName;
//救援人员
private String jyry;
//伤员
private String sy;
//器材消耗记录
private String qcxhjl;
//救援监控
private String remark;
//调度记录
private String back;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getSgName() {return sgName;}
public void setSgName(String sgName) {this.sgName = sgName;}
public String getGlfaName() {return glfaName;}
public void setGlfaName(String glfaName) {this.glfaName = glfaName;}
public String getJyry() {return jyry;}
public void setJyry(String jyry) {this.jyry = jyry;}
public String getSy() {return sy;}
public void setSy(String sy) {this.sy = sy;}
public String getQcxhjl() {return qcxhjl;}
public void setQcxhjl(String qcxhjl) {this.qcxhjl = qcxhjl;}
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 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 Sy  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//姓名
private String syName;
//身份证
private String v2;
//年龄
private String v3;
//联系电话
private String v4;
//性别
private String v5;
//家庭住址
private String v6;
//伤情备注
private String v7;
//伤情拍照
private String pz;
public String getSyName() {return syName;}
public void setSyName(String syName) {this.syName = syName;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
public String getPz() {return pz;}
public void setPz(String pz) {this.pz = pz;}
}

医疗人员javaBean创建语句如下:


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

//医疗人员
public class Ylry  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//姓名
private String ylryName;
//来自医院
private String v2;
//年龄
private String v3;
//联系电话
private String v4;
//性别
private String v5;
//职位
private String v6;
//备注
private String v7;
public String getYlryName() {return ylryName;}
public void setYlryName(String ylryName) {this.ylryName = ylryName;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
}

评论