- 基于spring法兰产品质量检验管理系统的设计与实现mysql数据库创建语句
- 基于spring法兰产品质量检验管理系统的设计与实现oracle数据库创建语句
- 基于spring法兰产品质量检验管理系统的设计与实现sqlserver数据库创建语句
- 基于spring法兰产品质量检验管理系统的设计与实现spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 基于spring法兰产品质量检验管理系统的设计与实现spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
基于spring法兰产品质量检验管理系统的设计与实现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_cpmc(
id int primary key auto_increment comment '主键',
cpmcName varchar(100) comment '产品名称',
v1 varchar(100) comment '备注'
) comment '产品名称';
检验分发表创建语句如下：
create table t_jyff(
id int primary key auto_increment comment '主键',
xxdjId int comment '产品名称',
v1 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 '检验结论',
ywyId int comment '业务员',
jyyId int comment '检验员',
shrId int comment '审核员',
status varchar(100) comment '状态',
v11 varchar(100) comment '报告编号',
v12 varchar(100) comment '材质',
v13 varchar(100) comment '检验类别',
v14 varchar(100) comment '材料护号',
v15 varchar(100) comment '委托单位',
v16 varchar(100) comment '规格型号',
v17 varchar(100) comment '委托单位地址',
v18 varchar(100) comment '样品数量'
) comment '检验分发';
检验项目表创建语句如下：
create table t_jyxm(
id int primary key auto_increment comment '主键',
jyxmName varchar(100) comment '项目名称',
v1 varchar(100) comment '性质',
v2 varchar(100) comment '参数',
v3 varchar(100) comment '备注'
) comment '检验项目';
检验员表创建语句如下：
create table t_jyy(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
jjyName varchar(100) comment '姓名',
sex varchar(100) comment '性别',
phone varchar(100) comment '电话'
) comment '检验员';
企业表创建语句如下：
create table t_qyxx(
id int primary key auto_increment comment '主键',
qyxxName varchar(100) comment '企业名称',
v1 varchar(100) comment '法人代表',
v2 varchar(100) comment '地址',
v3 varchar(100) comment '联系电话',
v4 varchar(100) comment '主营',
v5 varchar(100) comment '备注'
) comment '企业';
审核员表创建语句如下：
create table t_shy(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
shName varchar(100) comment '姓名',
sex varchar(100) comment '性别',
phone varchar(100) comment '电话'
) comment '审核员';
信息登记表创建语句如下：
create table t_xxdj(
id int primary key auto_increment comment '主键',
xxdjName varchar(100) comment '产品名称',
v1 varchar(100) comment '年龄',
v2 varchar(100) comment '电话',
v3 varchar(100) comment '住址'
) comment '信息登记';
用户表创建语句如下：
create table t_yh(
id int primary key auto_increment comment '主键',
ynName varchar(100) comment '用户名称',
v1 varchar(100) comment '年龄',
v2 varchar(100) comment '电弧',
v3 varchar(100) comment '住址'
) comment '用户';
业务员表创建语句如下：
create table t_ywy(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
ywyName varchar(100) comment '姓名',
sex varchar(100) comment '性别',
phone varchar(100) comment '电话'
) comment '业务员';
基于spring法兰产品质量检验管理系统的设计与实现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_cpmc(
id integer,
cpmcName varchar(100),
v1 varchar(100)
);
--产品名称字段加注释
comment on column t_cpmc.id is '主键';
comment on column t_cpmc.cpmcName is '产品名称';
comment on column t_cpmc.v1 is '备注';
--产品名称表加注释
comment on table t_cpmc is '产品名称';
检验分发表创建语句如下：
create table t_jyff(
id integer,
xxdjId int,
v1 varchar(100),
v2 varchar(100),
v3 varchar(100),
v4 varchar(100),
v5 varchar(100),
v6 varchar(100),
v7 varchar(100),
ywyId int,
jyyId int,
shrId int,
status varchar(100),
v11 varchar(100),
v12 varchar(100),
v13 varchar(100),
v14 varchar(100),
v15 varchar(100),
v16 varchar(100),
v17 varchar(100),
v18 varchar(100)
);
--检验分发字段加注释
comment on column t_jyff.id is '主键';
comment on column t_jyff.xxdjId is '产品名称';
comment on column t_jyff.v1 is '检验项目一';
comment on column t_jyff.v2 is '检验项目二';
comment on column t_jyff.v3 is '检验项目三';
comment on column t_jyff.v4 is '检验项目一结果';
comment on column t_jyff.v5 is '检验项目二结果';
comment on column t_jyff.v6 is '检验项目三结果';
comment on column t_jyff.v7 is '检验结论';
comment on column t_jyff.ywyId is '业务员';
comment on column t_jyff.jyyId is '检验员';
comment on column t_jyff.shrId is '审核员';
comment on column t_jyff.status is '状态';
comment on column t_jyff.v11 is '报告编号';
comment on column t_jyff.v12 is '材质';
comment on column t_jyff.v13 is '检验类别';
comment on column t_jyff.v14 is '材料护号';
comment on column t_jyff.v15 is '委托单位';
comment on column t_jyff.v16 is '规格型号';
comment on column t_jyff.v17 is '委托单位地址';
comment on column t_jyff.v18 is '样品数量';
--检验分发表加注释
comment on table t_jyff is '检验分发';
检验项目表创建语句如下：
create table t_jyxm(
id integer,
jyxmName varchar(100),
v1 varchar(100),
v2 varchar(100),
v3 varchar(100)
);
--检验项目字段加注释
comment on column t_jyxm.id is '主键';
comment on column t_jyxm.jyxmName is '项目名称';
comment on column t_jyxm.v1 is '性质';
comment on column t_jyxm.v2 is '参数';
comment on column t_jyxm.v3 is '备注';
--检验项目表加注释
comment on table t_jyxm is '检验项目';
检验员表创建语句如下：
create table t_jyy(
id integer,
username varchar(100),
password varchar(100),
jjyName varchar(100),
sex varchar(100),
phone varchar(100)
);
--检验员字段加注释
comment on column t_jyy.id is '主键';
comment on column t_jyy.username is '账号';
comment on column t_jyy.password is '密码';
comment on column t_jyy.jjyName is '姓名';
comment on column t_jyy.sex is '性别';
comment on column t_jyy.phone is '电话';
--检验员表加注释
comment on table t_jyy is '检验员';
企业表创建语句如下：
create table t_qyxx(
id integer,
qyxxName varchar(100),
v1 varchar(100),
v2 varchar(100),
v3 varchar(100),
v4 varchar(100),
v5 varchar(100)
);
--企业字段加注释
comment on column t_qyxx.id is '主键';
comment on column t_qyxx.qyxxName is '企业名称';
comment on column t_qyxx.v1 is '法人代表';
comment on column t_qyxx.v2 is '地址';
comment on column t_qyxx.v3 is '联系电话';
comment on column t_qyxx.v4 is '主营';
comment on column t_qyxx.v5 is '备注';
--企业表加注释
comment on table t_qyxx is '企业';
审核员表创建语句如下：
create table t_shy(
id integer,
username varchar(100),
password varchar(100),
shName varchar(100),
sex varchar(100),
phone varchar(100)
);
--审核员字段加注释
comment on column t_shy.id is '主键';
comment on column t_shy.username is '账号';
comment on column t_shy.password is '密码';
comment on column t_shy.shName is '姓名';
comment on column t_shy.sex is '性别';
comment on column t_shy.phone is '电话';
--审核员表加注释
comment on table t_shy is '审核员';
信息登记表创建语句如下：
create table t_xxdj(
id integer,
xxdjName varchar(100),
v1 varchar(100),
v2 varchar(100),
v3 varchar(100)
);
--信息登记字段加注释
comment on column t_xxdj.id is '主键';
comment on column t_xxdj.xxdjName is '产品名称';
comment on column t_xxdj.v1 is '年龄';
comment on column t_xxdj.v2 is '电话';
comment on column t_xxdj.v3 is '住址';
--信息登记表加注释
comment on table t_xxdj is '信息登记';
用户表创建语句如下：
create table t_yh(
id integer,
ynName varchar(100),
v1 varchar(100),
v2 varchar(100),
v3 varchar(100)
);
--用户字段加注释
comment on column t_yh.id is '主键';
comment on column t_yh.ynName is '用户名称';
comment on column t_yh.v1 is '年龄';
comment on column t_yh.v2 is '电弧';
comment on column t_yh.v3 is '住址';
--用户表加注释
comment on table t_yh is '用户';
业务员表创建语句如下：
create table t_ywy(
id integer,
username varchar(100),
password varchar(100),
ywyName varchar(100),
sex varchar(100),
phone varchar(100)
);
--业务员字段加注释
comment on column t_ywy.id is '主键';
comment on column t_ywy.username is '账号';
comment on column t_ywy.password is '密码';
comment on column t_ywy.ywyName is '姓名';
comment on column t_ywy.sex is '性别';
comment on column t_ywy.phone is '电话';
--业务员表加注释
comment on table t_ywy is '业务员';
oracle特有，对应序列如下：
create sequence s_t_cpmc;
create sequence s_t_jyff;
create sequence s_t_jyxm;
create sequence s_t_jyy;
create sequence s_t_qyxx;
create sequence s_t_shy;
create sequence s_t_xxdj;
create sequence s_t_yh;
create sequence s_t_ywy;
基于spring法兰产品质量检验管理系统的设计与实现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_cpmc(
id int identity(1,1) primary key not null,--主键
cpmcName varchar(100),--产品名称
v1 varchar(100)--备注
);
检验分发表创建语句如下：
--检验分发表注释
create table t_jyff(
id int identity(1,1) primary key not null,--主键
xxdjId int,--产品名称
v1 varchar(100),--检验项目一
v2 varchar(100),--检验项目二
v3 varchar(100),--检验项目三
v4 varchar(100),--检验项目一结果
v5 varchar(100),--检验项目二结果
v6 varchar(100),--检验项目三结果
v7 varchar(100),--检验结论
ywyId int,--业务员
jyyId int,--检验员
shrId int,--审核员
status varchar(100),--状态
v11 varchar(100),--报告编号
v12 varchar(100),--材质
v13 varchar(100),--检验类别
v14 varchar(100),--材料护号
v15 varchar(100),--委托单位
v16 varchar(100),--规格型号
v17 varchar(100),--委托单位地址
v18 varchar(100)--样品数量
);
检验项目表创建语句如下：
--检验项目表注释
create table t_jyxm(
id int identity(1,1) primary key not null,--主键
jyxmName varchar(100),--项目名称
v1 varchar(100),--性质
v2 varchar(100),--参数
v3 varchar(100)--备注
);
检验员表创建语句如下：
--检验员表注释
create table t_jyy(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
jjyName varchar(100),--姓名
sex varchar(100),--性别
phone varchar(100)--电话
);
企业表创建语句如下：
--企业表注释
create table t_qyxx(
id int identity(1,1) primary key not null,--主键
qyxxName varchar(100),--企业名称
v1 varchar(100),--法人代表
v2 varchar(100),--地址
v3 varchar(100),--联系电话
v4 varchar(100),--主营
v5 varchar(100)--备注
);
审核员表创建语句如下：
--审核员表注释
create table t_shy(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
shName varchar(100),--姓名
sex varchar(100),--性别
phone varchar(100)--电话
);
信息登记表创建语句如下：
--信息登记表注释
create table t_xxdj(
id int identity(1,1) primary key not null,--主键
xxdjName varchar(100),--产品名称
v1 varchar(100),--年龄
v2 varchar(100),--电话
v3 varchar(100)--住址
);
用户表创建语句如下：
--用户表注释
create table t_yh(
id int identity(1,1) primary key not null,--主键
ynName varchar(100),--用户名称
v1 varchar(100),--年龄
v2 varchar(100),--电弧
v3 varchar(100)--住址
);
业务员表创建语句如下：
--业务员表注释
create table t_ywy(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
ywyName varchar(100),--姓名
sex varchar(100),--性别
phone varchar(100)--电话
);
登录后主页.jpg?x-oss-process=style/00001)
基于spring法兰产品质量检验管理系统的设计与实现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_cpmc")
public class Cpmc {
//主键
@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 cpmcName;
//备注
private String v1;
public String getCpmcName() {return cpmcName;}
public void setCpmcName(String cpmcName) {this.cpmcName = cpmcName;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
}检验分发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_jyff")
public class Jyff {
//主键
@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 xxdjId;
//检验项目一
private String v1;
//检验项目二
private String v2;
//检验项目三
private String v3;
//检验项目一结果
private String v4;
//检验项目二结果
private String v5;
//检验项目三结果
private String v6;
//检验结论
private String v7;
//业务员
private Integer ywyId;
//检验员
private Integer jyyId;
//审核员
private Integer shrId;
//状态
private String status;
//报告编号
private String v11;
//材质
private String v12;
//检验类别
private String v13;
//材料护号
private String v14;
//委托单位
private String v15;
//规格型号
private String v16;
//委托单位地址
private String v17;
//样品数量
private String v18;
public Integer getXxdjId() {return xxdjId;}
public void setXxdjId(Integer xxdjId) {this.xxdjId = xxdjId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
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 Integer getYwyId() {return ywyId;}
public void setYwyId(Integer ywyId) {this.ywyId = ywyId;}
public Integer getJyyId() {return jyyId;}
public void setJyyId(Integer jyyId) {this.jyyId = jyyId;}
public Integer getShrId() {return shrId;}
public void setShrId(Integer shrId) {this.shrId = shrId;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getV11() {return v11;}
public void setV11(String v11) {this.v11 = v11;}
public String getV12() {return v12;}
public void setV12(String v12) {this.v12 = v12;}
public String getV13() {return v13;}
public void setV13(String v13) {this.v13 = v13;}
public String getV14() {return v14;}
public void setV14(String v14) {this.v14 = v14;}
public String getV15() {return v15;}
public void setV15(String v15) {this.v15 = v15;}
public String getV16() {return v16;}
public void setV16(String v16) {this.v16 = v16;}
public String getV17() {return v17;}
public void setV17(String v17) {this.v17 = v17;}
public String getV18() {return v18;}
public void setV18(String v18) {this.v18 = v18;}
}检验项目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_jyxm")
public class Jyxm {
//主键
@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 jyxmName;
//性质
private String v1;
//参数
private String v2;
//备注
private String v3;
public String getJyxmName() {return jyxmName;}
public void setJyxmName(String jyxmName) {this.jyxmName = jyxmName;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
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;}
}检验员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_jyy")
public class Jyy {
//主键
@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 jjyName;
//性别
private String sex;
//电话
private String phone;
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 getJjyName() {return jjyName;}
public void setJjyName(String jjyName) {this.jjyName = jjyName;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}企业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_qyxx")
public class Qyxx {
//主键
@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 qyxxName;
//法人代表
private String v1;
//地址
private String v2;
//联系电话
private String v3;
//主营
private String v4;
//备注
private String v5;
public String getQyxxName() {return qyxxName;}
public void setQyxxName(String qyxxName) {this.qyxxName = qyxxName;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
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;}
}审核员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_shy")
public class Shy {
//主键
@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 shName;
//性别
private String sex;
//电话
private String phone;
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 getShName() {return shName;}
public void setShName(String shName) {this.shName = shName;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}信息登记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_xxdj")
public class Xxdj {
//主键
@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 xxdjName;
//年龄
private String v1;
//电话
private String v2;
//住址
private String v3;
public String getXxdjName() {return xxdjName;}
public void setXxdjName(String xxdjName) {this.xxdjName = xxdjName;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
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;}
}用户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_yh")
public class Yh {
//主键
@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 ynName;
//年龄
private String v1;
//电弧
private String v2;
//住址
private String v3;
public String getYnName() {return ynName;}
public void setYnName(String ynName) {this.ynName = ynName;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
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;}
}业务员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_ywy")
public class Ywy {
//主键
@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 ywyName;
//性别
private String sex;
//电话
private String phone;
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 getYwyName() {return ywyName;}
public void setYwyName(String ywyName) {this.ywyName = ywyName;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}基于spring法兰产品质量检验管理系统的设计与实现spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
产品名称javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//产品名称
public class Cpmc extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//产品名称
private String cpmcName;
//备注
private String v1;
public String getCpmcName() {return cpmcName;}
public void setCpmcName(String cpmcName) {this.cpmcName = cpmcName;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
}检验分发javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//检验分发
public class Jyff extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//产品名称
private Integer xxdjId;
//检验项目一
private String v1;
//检验项目二
private String v2;
//检验项目三
private String v3;
//检验项目一结果
private String v4;
//检验项目二结果
private String v5;
//检验项目三结果
private String v6;
//检验结论
private String v7;
//业务员
private Integer ywyId;
//检验员
private Integer jyyId;
//审核员
private Integer shrId;
//状态
private String status;
//报告编号
private String v11;
//材质
private String v12;
//检验类别
private String v13;
//材料护号
private String v14;
//委托单位
private String v15;
//规格型号
private String v16;
//委托单位地址
private String v17;
//样品数量
private String v18;
public Integer getXxdjId() {return xxdjId;}
public void setXxdjId(Integer xxdjId) {this.xxdjId = xxdjId;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
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 Integer getYwyId() {return ywyId;}
public void setYwyId(Integer ywyId) {this.ywyId = ywyId;}
public Integer getJyyId() {return jyyId;}
public void setJyyId(Integer jyyId) {this.jyyId = jyyId;}
public Integer getShrId() {return shrId;}
public void setShrId(Integer shrId) {this.shrId = shrId;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getV11() {return v11;}
public void setV11(String v11) {this.v11 = v11;}
public String getV12() {return v12;}
public void setV12(String v12) {this.v12 = v12;}
public String getV13() {return v13;}
public void setV13(String v13) {this.v13 = v13;}
public String getV14() {return v14;}
public void setV14(String v14) {this.v14 = v14;}
public String getV15() {return v15;}
public void setV15(String v15) {this.v15 = v15;}
public String getV16() {return v16;}
public void setV16(String v16) {this.v16 = v16;}
public String getV17() {return v17;}
public void setV17(String v17) {this.v17 = v17;}
public String getV18() {return v18;}
public void setV18(String v18) {this.v18 = v18;}
}检验项目javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//检验项目
public class Jyxm extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//项目名称
private String jyxmName;
//性质
private String v1;
//参数
private String v2;
//备注
private String v3;
public String getJyxmName() {return jyxmName;}
public void setJyxmName(String jyxmName) {this.jyxmName = jyxmName;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
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;}
}检验员javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//检验员
public class Jyy 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 jjyName;
//性别
private String sex;
//电话
private String phone;
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 getJjyName() {return jjyName;}
public void setJjyName(String jjyName) {this.jjyName = jjyName;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}企业javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//企业
public class Qyxx extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//企业名称
private String qyxxName;
//法人代表
private String v1;
//地址
private String v2;
//联系电话
private String v3;
//主营
private String v4;
//备注
private String v5;
public String getQyxxName() {return qyxxName;}
public void setQyxxName(String qyxxName) {this.qyxxName = qyxxName;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
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;}
}审核员javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//审核员
public class Shy 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 shName;
//性别
private String sex;
//电话
private String phone;
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 getShName() {return shName;}
public void setShName(String shName) {this.shName = shName;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}信息登记javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//信息登记
public class Xxdj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//产品名称
private String xxdjName;
//年龄
private String v1;
//电话
private String v2;
//住址
private String v3;
public String getXxdjName() {return xxdjName;}
public void setXxdjName(String xxdjName) {this.xxdjName = xxdjName;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
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;}
}用户javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//用户
public class Yh extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户名称
private String ynName;
//年龄
private String v1;
//电弧
private String v2;
//住址
private String v3;
public String getYnName() {return ynName;}
public void setYnName(String ynName) {this.ynName = ynName;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
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;}
}业务员javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//业务员
public class Ywy 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 ywyName;
//性别
private String sex;
//电话
private String phone;
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 getYwyName() {return ywyName;}
public void setYwyName(String ywyName) {this.ywyName = ywyName;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}