- 公司烤箱配件质量信息追溯系统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_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 '',
js varchar(100) comment ''
) comment '员工';
订单表创建语句如下：
create table t_dd(
id int primary key auto_increment comment '主键',
ddName varchar(100) comment '订单号',
cpmc varchar(100) comment '产品名称',
cplx varchar(100) comment '产品类型',
ddsl int comment '订单数量',
jhq varchar(100) comment '交货期',
bz text comment '备注'
) comment '订单';
公告表创建语句如下：
create table t_gonggao(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
content text comment '内容',
insertDate datetime comment '发起日期'
) comment '公告';
合同表创建语句如下：
create table t_ht(
id int primary key auto_increment comment '主键',
htName varchar(100) comment '合同编号',
qsrq datetime comment '签署日期',
gsmc varchar(100) comment '公司名称',
gsdd varchar(100) comment '公司地址',
gsxz varchar(100) comment '公司性质',
fj varchar(100) comment '合同附件'
) comment '合同';
加工过程表创建语句如下：
create table t_jggc(
id int primary key auto_increment comment '主键',
ddName varchar(100) comment '订单号',
fcph varchar(100) comment '父产品号',
gxh varchar(100) comment '工序号',
gxnr text comment '工序内容',
jgz varchar(100) comment '加工者',
jgsl int comment '加工数量',
jgzt varchar(100) comment '',
jyrq datetime comment '检验日期',
cjsl int comment '抽检数量',
hgl varchar(100) comment '合格率',
jyy varchar(100) comment '检验员'
) comment '加工过程';
库存表创建语句如下：
create table t_kc(
id int primary key auto_increment comment '主键',
ddName varchar(100) comment '订单号',
cpbh varchar(100) comment '成品编号',
cpmc varchar(100) comment '产品名称',
jyrq datetime comment '检验日期',
cjsl int comment '抽检数量',
hgl varchar(100) comment '合格率',
jyy varchar(100) comment '检验员',
sfck varchar(100) comment '',
cksl int comment '出库数量',
kc int comment '库存',
cksj datetime comment '出库时间'
) comment '库存';
来料表创建语句如下：
create table t_llgl(
id int primary key auto_increment comment '主键',
ddName varchar(100) comment '订单号',
llrz datetime comment '来料日期',
gys varchar(100) comment '供应商',
wlmc varchar(100) comment '物料名称',
lb varchar(100) comment '类别',
ph varchar(100) comment '品号',
pc varchar(100) comment '批次',
llsl int comment '来料数量',
jyrq datetime comment '检验日期',
cjsl int comment '抽检数量',
hgl varchar(100) comment '合格率',
blxx text comment '不良现象',
jyy varchar(100) comment '检验员',
clfa varchar(100) comment ''
) comment '来料';
留言表创建语句如下：
create table t_ly(
id int primary key auto_increment comment '主键',
customerId int comment '员工',
content text comment '内容',
insertDate datetime comment '发起日期',
back text comment '回复',
status varchar(100) comment '状态'
) comment '留言';
设备表创建语句如下：
create table t_sb(
id int primary key auto_increment comment '主键',
sbName varchar(100) comment '设备编号',
sbmc varchar(100) comment '设备名称',
sbxh varchar(100) comment '设备型号',
sbsl int comment '设备数量',
sbfzd varchar(100) comment '',
gzsj datetime comment '购置时间',
sbpp varchar(100) comment '设备品牌',
sbjg int comment '设备价格',
jysj varchar(100) comment '检验时间'
) comment '设备';
文件表创建语句如下：
create table t_wj(
id int primary key auto_increment comment '主键',
wjName varchar(100) comment '文件编号',
wjlx varchar(100) comment '文件类型',
wjmc varchar(100) comment '文件名称',
fbrq datetime comment '发布日期',
ssrq datetime comment '实施日期',
ssbm varchar(100) comment '实施部门'
) comment '文件';
物料领取表创建语句如下：
create table t_wllq(
id int primary key auto_increment comment '主键',
ddName varchar(100) comment '订单号',
scbz varchar(100) comment '生产班组',
scx varchar(100) comment '',
lywp varchar(100) comment '领用物品',
lb varchar(100) comment '',
ph varchar(100) comment '品号',
pc varchar(100) comment '批次',
lysl int comment '领用数量',
jgsl int comment '加工数量',
lyr 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),
phone varchar(100),
age varchar(100),
sex 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.js is '';
--员工表加注释
comment on table t_customer is '员工';
订单表创建语句如下：
create table t_dd(
id integer,
ddName varchar(100),
cpmc varchar(100),
cplx varchar(100),
ddsl int,
jhq varchar(100),
bz text
);
--订单字段加注释
comment on column t_dd.id is '主键';
comment on column t_dd.ddName is '订单号';
comment on column t_dd.cpmc is '产品名称';
comment on column t_dd.cplx is '产品类型';
comment on column t_dd.ddsl is '订单数量';
comment on column t_dd.jhq is '交货期';
comment on column t_dd.bz is '备注';
--订单表加注释
comment on table t_dd is '订单';
公告表创建语句如下：
create table t_gonggao(
id integer,
title varchar(100),
content text,
insertDate datetime
);
--公告字段加注释
comment on column t_gonggao.id is '主键';
comment on column t_gonggao.title is '标题';
comment on column t_gonggao.content is '内容';
comment on column t_gonggao.insertDate is '发起日期';
--公告表加注释
comment on table t_gonggao is '公告';
合同表创建语句如下：
create table t_ht(
id integer,
htName varchar(100),
qsrq datetime,
gsmc varchar(100),
gsdd varchar(100),
gsxz varchar(100),
fj varchar(100)
);
--合同字段加注释
comment on column t_ht.id is '主键';
comment on column t_ht.htName is '合同编号';
comment on column t_ht.qsrq is '签署日期';
comment on column t_ht.gsmc is '公司名称';
comment on column t_ht.gsdd is '公司地址';
comment on column t_ht.gsxz is '公司性质';
comment on column t_ht.fj is '合同附件';
--合同表加注释
comment on table t_ht is '合同';
加工过程表创建语句如下：
create table t_jggc(
id integer,
ddName varchar(100),
fcph varchar(100),
gxh varchar(100),
gxnr text,
jgz varchar(100),
jgsl int,
jgzt varchar(100),
jyrq datetime,
cjsl int,
hgl varchar(100),
jyy varchar(100)
);
--加工过程字段加注释
comment on column t_jggc.id is '主键';
comment on column t_jggc.ddName is '订单号';
comment on column t_jggc.fcph is '父产品号';
comment on column t_jggc.gxh is '工序号';
comment on column t_jggc.gxnr is '工序内容';
comment on column t_jggc.jgz is '加工者';
comment on column t_jggc.jgsl is '加工数量';
comment on column t_jggc.jgzt is '';
comment on column t_jggc.jyrq is '检验日期';
comment on column t_jggc.cjsl is '抽检数量';
comment on column t_jggc.hgl is '合格率';
comment on column t_jggc.jyy is '检验员';
--加工过程表加注释
comment on table t_jggc is '加工过程';
库存表创建语句如下：
create table t_kc(
id integer,
ddName varchar(100),
cpbh varchar(100),
cpmc varchar(100),
jyrq datetime,
cjsl int,
hgl varchar(100),
jyy varchar(100),
sfck varchar(100),
cksl int,
kc int,
cksj datetime
);
--库存字段加注释
comment on column t_kc.id is '主键';
comment on column t_kc.ddName is '订单号';
comment on column t_kc.cpbh is '成品编号';
comment on column t_kc.cpmc is '产品名称';
comment on column t_kc.jyrq is '检验日期';
comment on column t_kc.cjsl is '抽检数量';
comment on column t_kc.hgl is '合格率';
comment on column t_kc.jyy is '检验员';
comment on column t_kc.sfck is '';
comment on column t_kc.cksl is '出库数量';
comment on column t_kc.kc is '库存';
comment on column t_kc.cksj is '出库时间';
--库存表加注释
comment on table t_kc is '库存';
来料表创建语句如下：
create table t_llgl(
id integer,
ddName varchar(100),
llrz datetime,
gys varchar(100),
wlmc varchar(100),
lb varchar(100),
ph varchar(100),
pc varchar(100),
llsl int,
jyrq datetime,
cjsl int,
hgl varchar(100),
blxx text,
jyy varchar(100),
clfa varchar(100)
);
--来料字段加注释
comment on column t_llgl.id is '主键';
comment on column t_llgl.ddName is '订单号';
comment on column t_llgl.llrz is '来料日期';
comment on column t_llgl.gys is '供应商';
comment on column t_llgl.wlmc is '物料名称';
comment on column t_llgl.lb is '类别';
comment on column t_llgl.ph is '品号';
comment on column t_llgl.pc is '批次';
comment on column t_llgl.llsl is '来料数量';
comment on column t_llgl.jyrq is '检验日期';
comment on column t_llgl.cjsl is '抽检数量';
comment on column t_llgl.hgl is '合格率';
comment on column t_llgl.blxx is '不良现象';
comment on column t_llgl.jyy is '检验员';
comment on column t_llgl.clfa is '';
--来料表加注释
comment on table t_llgl is '来料';
留言表创建语句如下：
create table t_ly(
id integer,
customerId int,
content text,
insertDate datetime,
back text,
status varchar(100)
);
--留言字段加注释
comment on column t_ly.id is '主键';
comment on column t_ly.customerId is '员工';
comment on column t_ly.content is '内容';
comment on column t_ly.insertDate is '发起日期';
comment on column t_ly.back is '回复';
comment on column t_ly.status is '状态';
--留言表加注释
comment on table t_ly is '留言';
设备表创建语句如下：
create table t_sb(
id integer,
sbName varchar(100),
sbmc varchar(100),
sbxh varchar(100),
sbsl int,
sbfzd varchar(100),
gzsj datetime,
sbpp varchar(100),
sbjg int,
jysj varchar(100)
);
--设备字段加注释
comment on column t_sb.id is '主键';
comment on column t_sb.sbName is '设备编号';
comment on column t_sb.sbmc is '设备名称';
comment on column t_sb.sbxh is '设备型号';
comment on column t_sb.sbsl is '设备数量';
comment on column t_sb.sbfzd is '';
comment on column t_sb.gzsj is '购置时间';
comment on column t_sb.sbpp is '设备品牌';
comment on column t_sb.sbjg is '设备价格';
comment on column t_sb.jysj is '检验时间';
--设备表加注释
comment on table t_sb is '设备';
文件表创建语句如下：
create table t_wj(
id integer,
wjName varchar(100),
wjlx varchar(100),
wjmc varchar(100),
fbrq datetime,
ssrq datetime,
ssbm varchar(100)
);
--文件字段加注释
comment on column t_wj.id is '主键';
comment on column t_wj.wjName is '文件编号';
comment on column t_wj.wjlx is '文件类型';
comment on column t_wj.wjmc is '文件名称';
comment on column t_wj.fbrq is '发布日期';
comment on column t_wj.ssrq is '实施日期';
comment on column t_wj.ssbm is '实施部门';
--文件表加注释
comment on table t_wj is '文件';
物料领取表创建语句如下：
create table t_wllq(
id integer,
ddName varchar(100),
scbz varchar(100),
scx varchar(100),
lywp varchar(100),
lb varchar(100),
ph varchar(100),
pc varchar(100),
lysl int,
jgsl int,
lyr varchar(100)
);
--物料领取字段加注释
comment on column t_wllq.id is '主键';
comment on column t_wllq.ddName is '订单号';
comment on column t_wllq.scbz is '生产班组';
comment on column t_wllq.scx is '';
comment on column t_wllq.lywp is '领用物品';
comment on column t_wllq.lb is '';
comment on column t_wllq.ph is '品号';
comment on column t_wllq.pc is '批次';
comment on column t_wllq.lysl is '领用数量';
comment on column t_wllq.jgsl is '加工数量';
comment on column t_wllq.lyr is '领用人';
--物料领取表加注释
comment on table t_wllq is '物料领取';
oracle特有，对应序列如下：
create sequence s_t_customer;
create sequence s_t_dd;
create sequence s_t_gonggao;
create sequence s_t_ht;
create sequence s_t_jggc;
create sequence s_t_kc;
create sequence s_t_llgl;
create sequence s_t_ly;
create sequence s_t_sb;
create sequence s_t_wj;
create sequence s_t_wllq;
公司烤箱配件质量信息追溯系统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),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--
js varchar(100)--
);
订单表创建语句如下：
--订单表注释
create table t_dd(
id int identity(1,1) primary key not null,--主键
ddName varchar(100),--订单号
cpmc varchar(100),--产品名称
cplx varchar(100),--产品类型
ddsl int,--订单数量
jhq varchar(100),--交货期
bz text--备注
);
公告表创建语句如下：
--公告表注释
create table t_gonggao(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
content text,--内容
insertDate datetime--发起日期
);
合同表创建语句如下：
--合同表注释
create table t_ht(
id int identity(1,1) primary key not null,--主键
htName varchar(100),--合同编号
qsrq datetime,--签署日期
gsmc varchar(100),--公司名称
gsdd varchar(100),--公司地址
gsxz varchar(100),--公司性质
fj varchar(100)--合同附件
);
加工过程表创建语句如下：
--加工过程表注释
create table t_jggc(
id int identity(1,1) primary key not null,--主键
ddName varchar(100),--订单号
fcph varchar(100),--父产品号
gxh varchar(100),--工序号
gxnr text,--工序内容
jgz varchar(100),--加工者
jgsl int,--加工数量
jgzt varchar(100),--
jyrq datetime,--检验日期
cjsl int,--抽检数量
hgl varchar(100),--合格率
jyy varchar(100)--检验员
);
库存表创建语句如下：
--库存表注释
create table t_kc(
id int identity(1,1) primary key not null,--主键
ddName varchar(100),--订单号
cpbh varchar(100),--成品编号
cpmc varchar(100),--产品名称
jyrq datetime,--检验日期
cjsl int,--抽检数量
hgl varchar(100),--合格率
jyy varchar(100),--检验员
sfck varchar(100),--
cksl int,--出库数量
kc int,--库存
cksj datetime--出库时间
);
来料表创建语句如下：
--来料表注释
create table t_llgl(
id int identity(1,1) primary key not null,--主键
ddName varchar(100),--订单号
llrz datetime,--来料日期
gys varchar(100),--供应商
wlmc varchar(100),--物料名称
lb varchar(100),--类别
ph varchar(100),--品号
pc varchar(100),--批次
llsl int,--来料数量
jyrq datetime,--检验日期
cjsl int,--抽检数量
hgl varchar(100),--合格率
blxx text,--不良现象
jyy varchar(100),--检验员
clfa varchar(100)--
);
留言表创建语句如下：
--留言表注释
create table t_ly(
id int identity(1,1) primary key not null,--主键
customerId int,--员工
content text,--内容
insertDate datetime,--发起日期
back text,--回复
status varchar(100)--状态
);
设备表创建语句如下：
--设备表注释
create table t_sb(
id int identity(1,1) primary key not null,--主键
sbName varchar(100),--设备编号
sbmc varchar(100),--设备名称
sbxh varchar(100),--设备型号
sbsl int,--设备数量
sbfzd varchar(100),--
gzsj datetime,--购置时间
sbpp varchar(100),--设备品牌
sbjg int,--设备价格
jysj varchar(100)--检验时间
);
文件表创建语句如下：
--文件表注释
create table t_wj(
id int identity(1,1) primary key not null,--主键
wjName varchar(100),--文件编号
wjlx varchar(100),--文件类型
wjmc varchar(100),--文件名称
fbrq datetime,--发布日期
ssrq datetime,--实施日期
ssbm varchar(100)--实施部门
);
物料领取表创建语句如下：
--物料领取表注释
create table t_wllq(
id int identity(1,1) primary key not null,--主键
ddName varchar(100),--订单号
scbz varchar(100),--生产班组
scx varchar(100),--
lywp varchar(100),--领用物品
lb varchar(100),--
ph varchar(100),--品号
pc varchar(100),--批次
lysl int,--领用数量
jgsl int,--加工数量
lyr varchar(100)--领用人
);
登录后主页.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_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 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 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_dd")
public class Dd {
//主键
@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 ddName;
//产品名称
private String cpmc;
//产品类型
private String cplx;
//订单数量
private Integer ddsl;
//交货期
private String jhq;
//备注
private String bz;
public String getDdName() {return ddName;}
public void setDdName(String ddName) {this.ddName = ddName;}
public String getCpmc() {return cpmc;}
public void setCpmc(String cpmc) {this.cpmc = cpmc;}
public String getCplx() {return cplx;}
public void setCplx(String cplx) {this.cplx = cplx;}
public Integer getDdsl() {return ddsl;}
public void setDdsl(Integer ddsl) {this.ddsl = ddsl;}
public String getJhq() {return jhq;}
public void setJhq(String jhq) {this.jhq = jhq;}
public String getBz() {return bz;}
public void setBz(String bz) {this.bz = bz;}
}公告javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//公告
@Table(name = "t_gonggao")
public class Gonggao {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//内容
private String content;
//发起日期
private Date insertDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}合同javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//合同
@Table(name = "t_ht")
public class Ht {
//主键
@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 htName;
//签署日期
private Date qsrq;
//公司名称
private String gsmc;
//公司地址
private String gsdd;
//公司性质
private String gsxz;
//合同附件
private String fj;
public String getHtName() {return htName;}
public void setHtName(String htName) {this.htName = htName;}
public Date getQsrq() {return qsrq;}
public void setQsrq(Date qsrq) {this.qsrq = qsrq;}
public String getGsmc() {return gsmc;}
public void setGsmc(String gsmc) {this.gsmc = gsmc;}
public String getGsdd() {return gsdd;}
public void setGsdd(String gsdd) {this.gsdd = gsdd;}
public String getGsxz() {return gsxz;}
public void setGsxz(String gsxz) {this.gsxz = gsxz;}
public String getFj() {return fj;}
public void setFj(String fj) {this.fj = fj;}
}加工过程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_jggc")
public class Jggc {
//主键
@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 ddName;
//父产品号
private String fcph;
//工序号
private String gxh;
//工序内容
private String gxnr;
//加工者
private String jgz;
//加工数量
private Integer jgsl;
//
private String jgzt;
//检验日期
private Date jyrq;
//抽检数量
private Integer cjsl;
//合格率
private String hgl;
//检验员
private String jyy;
public String getDdName() {return ddName;}
public void setDdName(String ddName) {this.ddName = ddName;}
public String getFcph() {return fcph;}
public void setFcph(String fcph) {this.fcph = fcph;}
public String getGxh() {return gxh;}
public void setGxh(String gxh) {this.gxh = gxh;}
public String getGxnr() {return gxnr;}
public void setGxnr(String gxnr) {this.gxnr = gxnr;}
public String getJgz() {return jgz;}
public void setJgz(String jgz) {this.jgz = jgz;}
public Integer getJgsl() {return jgsl;}
public void setJgsl(Integer jgsl) {this.jgsl = jgsl;}
public String getJgzt() {return jgzt;}
public void setJgzt(String jgzt) {this.jgzt = jgzt;}
public Date getJyrq() {return jyrq;}
public void setJyrq(Date jyrq) {this.jyrq = jyrq;}
public Integer getCjsl() {return cjsl;}
public void setCjsl(Integer cjsl) {this.cjsl = cjsl;}
public String getHgl() {return hgl;}
public void setHgl(String hgl) {this.hgl = hgl;}
public String getJyy() {return jyy;}
public void setJyy(String jyy) {this.jyy = jyy;}
}库存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_kc")
public class Kc {
//主键
@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 ddName;
//成品编号
private String cpbh;
//产品名称
private String cpmc;
//检验日期
private Date jyrq;
//抽检数量
private Integer cjsl;
//合格率
private String hgl;
//检验员
private String jyy;
//
private String sfck;
//出库数量
private Integer cksl;
//库存
private Integer kc;
//出库时间
private Date cksj;
public String getDdName() {return ddName;}
public void setDdName(String ddName) {this.ddName = ddName;}
public String getCpbh() {return cpbh;}
public void setCpbh(String cpbh) {this.cpbh = cpbh;}
public String getCpmc() {return cpmc;}
public void setCpmc(String cpmc) {this.cpmc = cpmc;}
public Date getJyrq() {return jyrq;}
public void setJyrq(Date jyrq) {this.jyrq = jyrq;}
public Integer getCjsl() {return cjsl;}
public void setCjsl(Integer cjsl) {this.cjsl = cjsl;}
public String getHgl() {return hgl;}
public void setHgl(String hgl) {this.hgl = hgl;}
public String getJyy() {return jyy;}
public void setJyy(String jyy) {this.jyy = jyy;}
public String getSfck() {return sfck;}
public void setSfck(String sfck) {this.sfck = sfck;}
public Integer getCksl() {return cksl;}
public void setCksl(Integer cksl) {this.cksl = cksl;}
public Integer getKc() {return kc;}
public void setKc(Integer kc) {this.kc = kc;}
public Date getCksj() {return cksj;}
public void setCksj(Date cksj) {this.cksj = cksj;}
}来料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_llgl")
public class Llgl {
//主键
@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 ddName;
//来料日期
private Date llrz;
//供应商
private String gys;
//物料名称
private String wlmc;
//类别
private String lb;
//品号
private String ph;
//批次
private String pc;
//来料数量
private Integer llsl;
//检验日期
private Date jyrq;
//抽检数量
private Integer cjsl;
//合格率
private String hgl;
//不良现象
private String blxx;
//检验员
private String jyy;
//
private String clfa;
public String getDdName() {return ddName;}
public void setDdName(String ddName) {this.ddName = ddName;}
public Date getLlrz() {return llrz;}
public void setLlrz(Date llrz) {this.llrz = llrz;}
public String getGys() {return gys;}
public void setGys(String gys) {this.gys = gys;}
public String getWlmc() {return wlmc;}
public void setWlmc(String wlmc) {this.wlmc = wlmc;}
public String getLb() {return lb;}
public void setLb(String lb) {this.lb = lb;}
public String getPh() {return ph;}
public void setPh(String ph) {this.ph = ph;}
public String getPc() {return pc;}
public void setPc(String pc) {this.pc = pc;}
public Integer getLlsl() {return llsl;}
public void setLlsl(Integer llsl) {this.llsl = llsl;}
public Date getJyrq() {return jyrq;}
public void setJyrq(Date jyrq) {this.jyrq = jyrq;}
public Integer getCjsl() {return cjsl;}
public void setCjsl(Integer cjsl) {this.cjsl = cjsl;}
public String getHgl() {return hgl;}
public void setHgl(String hgl) {this.hgl = hgl;}
public String getBlxx() {return blxx;}
public void setBlxx(String blxx) {this.blxx = blxx;}
public String getJyy() {return jyy;}
public void setJyy(String jyy) {this.jyy = jyy;}
public String getClfa() {return clfa;}
public void setClfa(String clfa) {this.clfa = clfa;}
}留言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_ly")
public class Ly {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//员工
private Long customerId;
//内容
private String content;
//发起日期
private Date insertDate;
//回复
private String back;
//状态
private String status;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
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_sb")
public class Sb {
//主键
@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 sbName;
//设备名称
private String sbmc;
//设备型号
private String sbxh;
//设备数量
private Integer sbsl;
//
private String sbfzd;
//购置时间
private Date gzsj;
//设备品牌
private String sbpp;
//设备价格
private Integer sbjg;
//检验时间
private String jysj;
public String getSbName() {return sbName;}
public void setSbName(String sbName) {this.sbName = sbName;}
public String getSbmc() {return sbmc;}
public void setSbmc(String sbmc) {this.sbmc = sbmc;}
public String getSbxh() {return sbxh;}
public void setSbxh(String sbxh) {this.sbxh = sbxh;}
public Integer getSbsl() {return sbsl;}
public void setSbsl(Integer sbsl) {this.sbsl = sbsl;}
public String getSbfzd() {return sbfzd;}
public void setSbfzd(String sbfzd) {this.sbfzd = sbfzd;}
public Date getGzsj() {return gzsj;}
public void setGzsj(Date gzsj) {this.gzsj = gzsj;}
public String getSbpp() {return sbpp;}
public void setSbpp(String sbpp) {this.sbpp = sbpp;}
public Integer getSbjg() {return sbjg;}
public void setSbjg(Integer sbjg) {this.sbjg = sbjg;}
public String getJysj() {return jysj;}
public void setJysj(String jysj) {this.jysj = jysj;}
}文件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_wj")
public class Wj {
//主键
@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 wjName;
//文件类型
private String wjlx;
//文件名称
private String wjmc;
//发布日期
private Date fbrq;
//实施日期
private Date ssrq;
//实施部门
private String ssbm;
public String getWjName() {return wjName;}
public void setWjName(String wjName) {this.wjName = wjName;}
public String getWjlx() {return wjlx;}
public void setWjlx(String wjlx) {this.wjlx = wjlx;}
public String getWjmc() {return wjmc;}
public void setWjmc(String wjmc) {this.wjmc = wjmc;}
public Date getFbrq() {return fbrq;}
public void setFbrq(Date fbrq) {this.fbrq = fbrq;}
public Date getSsrq() {return ssrq;}
public void setSsrq(Date ssrq) {this.ssrq = ssrq;}
public String getSsbm() {return ssbm;}
public void setSsbm(String ssbm) {this.ssbm = ssbm;}
}物料领取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_wllq")
public class Wllq {
//主键
@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 ddName;
//生产班组
private String scbz;
//
private String scx;
//领用物品
private String lywp;
//
private String lb;
//品号
private String ph;
//批次
private String pc;
//领用数量
private Integer lysl;
//加工数量
private Integer jgsl;
//领用人
private String lyr;
public String getDdName() {return ddName;}
public void setDdName(String ddName) {this.ddName = ddName;}
public String getScbz() {return scbz;}
public void setScbz(String scbz) {this.scbz = scbz;}
public String getScx() {return scx;}
public void setScx(String scx) {this.scx = scx;}
public String getLywp() {return lywp;}
public void setLywp(String lywp) {this.lywp = lywp;}
public String getLb() {return lb;}
public void setLb(String lb) {this.lb = lb;}
public String getPh() {return ph;}
public void setPh(String ph) {this.ph = ph;}
public String getPc() {return pc;}
public void setPc(String pc) {this.pc = pc;}
public Integer getLysl() {return lysl;}
public void setLysl(Integer lysl) {this.lysl = lysl;}
public Integer getJgsl() {return jgsl;}
public void setJgsl(Integer jgsl) {this.jgsl = jgsl;}
public String getLyr() {return lyr;}
public void setLyr(String lyr) {this.lyr = lyr;}
}公司烤箱配件质量信息追溯系统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 phone;
//年龄
private String age;
//
private String sex;
//
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 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 Dd extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//订单号
private String ddName;
//产品名称
private String cpmc;
//产品类型
private String cplx;
//订单数量
private Integer ddsl;
//交货期
private String jhq;
//备注
private String bz;
public String getDdName() {return ddName;}
public void setDdName(String ddName) {this.ddName = ddName;}
public String getCpmc() {return cpmc;}
public void setCpmc(String cpmc) {this.cpmc = cpmc;}
public String getCplx() {return cplx;}
public void setCplx(String cplx) {this.cplx = cplx;}
public Integer getDdsl() {return ddsl;}
public void setDdsl(Integer ddsl) {this.ddsl = ddsl;}
public String getJhq() {return jhq;}
public void setJhq(String jhq) {this.jhq = jhq;}
public String getBz() {return bz;}
public void setBz(String bz) {this.bz = bz;}
}公告javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//公告
public class Gonggao extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//内容
private String content;
//发起日期
private Date insertDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}合同javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//合同
public class Ht extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//合同编号
private String htName;
//签署日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date qsrq;
//公司名称
private String gsmc;
//公司地址
private String gsdd;
//公司性质
private String gsxz;
//合同附件
private String fj;
public String getHtName() {return htName;}
public void setHtName(String htName) {this.htName = htName;}
public Date getQsrq() {return qsrq;}
public void setQsrq(Date qsrq) {this.qsrq = qsrq;}
public String getGsmc() {return gsmc;}
public void setGsmc(String gsmc) {this.gsmc = gsmc;}
public String getGsdd() {return gsdd;}
public void setGsdd(String gsdd) {this.gsdd = gsdd;}
public String getGsxz() {return gsxz;}
public void setGsxz(String gsxz) {this.gsxz = gsxz;}
public String getFj() {return fj;}
public void setFj(String fj) {this.fj = fj;}
}加工过程javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//加工过程
public class Jggc extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//订单号
private String ddName;
//父产品号
private String fcph;
//工序号
private String gxh;
//工序内容
private String gxnr;
//加工者
private String jgz;
//加工数量
private Integer jgsl;
//
private String jgzt;
//检验日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date jyrq;
//抽检数量
private Integer cjsl;
//合格率
private String hgl;
//检验员
private String jyy;
public String getDdName() {return ddName;}
public void setDdName(String ddName) {this.ddName = ddName;}
public String getFcph() {return fcph;}
public void setFcph(String fcph) {this.fcph = fcph;}
public String getGxh() {return gxh;}
public void setGxh(String gxh) {this.gxh = gxh;}
public String getGxnr() {return gxnr;}
public void setGxnr(String gxnr) {this.gxnr = gxnr;}
public String getJgz() {return jgz;}
public void setJgz(String jgz) {this.jgz = jgz;}
public Integer getJgsl() {return jgsl;}
public void setJgsl(Integer jgsl) {this.jgsl = jgsl;}
public String getJgzt() {return jgzt;}
public void setJgzt(String jgzt) {this.jgzt = jgzt;}
public Date getJyrq() {return jyrq;}
public void setJyrq(Date jyrq) {this.jyrq = jyrq;}
public Integer getCjsl() {return cjsl;}
public void setCjsl(Integer cjsl) {this.cjsl = cjsl;}
public String getHgl() {return hgl;}
public void setHgl(String hgl) {this.hgl = hgl;}
public String getJyy() {return jyy;}
public void setJyy(String jyy) {this.jyy = jyy;}
}库存javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//库存
public class Kc extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//订单号
private String ddName;
//成品编号
private String cpbh;
//产品名称
private String cpmc;
//检验日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date jyrq;
//抽检数量
private Integer cjsl;
//合格率
private String hgl;
//检验员
private String jyy;
//
private String sfck;
//出库数量
private Integer cksl;
//库存
private Integer kc;
//出库时间
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date cksj;
public String getDdName() {return ddName;}
public void setDdName(String ddName) {this.ddName = ddName;}
public String getCpbh() {return cpbh;}
public void setCpbh(String cpbh) {this.cpbh = cpbh;}
public String getCpmc() {return cpmc;}
public void setCpmc(String cpmc) {this.cpmc = cpmc;}
public Date getJyrq() {return jyrq;}
public void setJyrq(Date jyrq) {this.jyrq = jyrq;}
public Integer getCjsl() {return cjsl;}
public void setCjsl(Integer cjsl) {this.cjsl = cjsl;}
public String getHgl() {return hgl;}
public void setHgl(String hgl) {this.hgl = hgl;}
public String getJyy() {return jyy;}
public void setJyy(String jyy) {this.jyy = jyy;}
public String getSfck() {return sfck;}
public void setSfck(String sfck) {this.sfck = sfck;}
public Integer getCksl() {return cksl;}
public void setCksl(Integer cksl) {this.cksl = cksl;}
public Integer getKc() {return kc;}
public void setKc(Integer kc) {this.kc = kc;}
public Date getCksj() {return cksj;}
public void setCksj(Date cksj) {this.cksj = cksj;}
}来料javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//来料
public class Llgl extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//订单号
private String ddName;
//来料日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date llrz;
//供应商
private String gys;
//物料名称
private String wlmc;
//类别
private String lb;
//品号
private String ph;
//批次
private String pc;
//来料数量
private Integer llsl;
//检验日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date jyrq;
//抽检数量
private Integer cjsl;
//合格率
private String hgl;
//不良现象
private String blxx;
//检验员
private String jyy;
//
private String clfa;
public String getDdName() {return ddName;}
public void setDdName(String ddName) {this.ddName = ddName;}
public Date getLlrz() {return llrz;}
public void setLlrz(Date llrz) {this.llrz = llrz;}
public String getGys() {return gys;}
public void setGys(String gys) {this.gys = gys;}
public String getWlmc() {return wlmc;}
public void setWlmc(String wlmc) {this.wlmc = wlmc;}
public String getLb() {return lb;}
public void setLb(String lb) {this.lb = lb;}
public String getPh() {return ph;}
public void setPh(String ph) {this.ph = ph;}
public String getPc() {return pc;}
public void setPc(String pc) {this.pc = pc;}
public Integer getLlsl() {return llsl;}
public void setLlsl(Integer llsl) {this.llsl = llsl;}
public Date getJyrq() {return jyrq;}
public void setJyrq(Date jyrq) {this.jyrq = jyrq;}
public Integer getCjsl() {return cjsl;}
public void setCjsl(Integer cjsl) {this.cjsl = cjsl;}
public String getHgl() {return hgl;}
public void setHgl(String hgl) {this.hgl = hgl;}
public String getBlxx() {return blxx;}
public void setBlxx(String blxx) {this.blxx = blxx;}
public String getJyy() {return jyy;}
public void setJyy(String jyy) {this.jyy = jyy;}
public String getClfa() {return clfa;}
public void setClfa(String clfa) {this.clfa = clfa;}
}留言javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//留言
public class Ly extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//员工
private Long customerId;
//内容
private String content;
//发起日期
private Date insertDate;
//回复
private String back;
//状态
private String status;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
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 Sb extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//设备编号
private String sbName;
//设备名称
private String sbmc;
//设备型号
private String sbxh;
//设备数量
private Integer sbsl;
//
private String sbfzd;
//购置时间
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date gzsj;
//设备品牌
private String sbpp;
//设备价格
private Integer sbjg;
//检验时间
private String jysj;
public String getSbName() {return sbName;}
public void setSbName(String sbName) {this.sbName = sbName;}
public String getSbmc() {return sbmc;}
public void setSbmc(String sbmc) {this.sbmc = sbmc;}
public String getSbxh() {return sbxh;}
public void setSbxh(String sbxh) {this.sbxh = sbxh;}
public Integer getSbsl() {return sbsl;}
public void setSbsl(Integer sbsl) {this.sbsl = sbsl;}
public String getSbfzd() {return sbfzd;}
public void setSbfzd(String sbfzd) {this.sbfzd = sbfzd;}
public Date getGzsj() {return gzsj;}
public void setGzsj(Date gzsj) {this.gzsj = gzsj;}
public String getSbpp() {return sbpp;}
public void setSbpp(String sbpp) {this.sbpp = sbpp;}
public Integer getSbjg() {return sbjg;}
public void setSbjg(Integer sbjg) {this.sbjg = sbjg;}
public String getJysj() {return jysj;}
public void setJysj(String jysj) {this.jysj = jysj;}
}文件javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//文件
public class Wj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//文件编号
private String wjName;
//文件类型
private String wjlx;
//文件名称
private String wjmc;
//发布日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date fbrq;
//实施日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date ssrq;
//实施部门
private String ssbm;
public String getWjName() {return wjName;}
public void setWjName(String wjName) {this.wjName = wjName;}
public String getWjlx() {return wjlx;}
public void setWjlx(String wjlx) {this.wjlx = wjlx;}
public String getWjmc() {return wjmc;}
public void setWjmc(String wjmc) {this.wjmc = wjmc;}
public Date getFbrq() {return fbrq;}
public void setFbrq(Date fbrq) {this.fbrq = fbrq;}
public Date getSsrq() {return ssrq;}
public void setSsrq(Date ssrq) {this.ssrq = ssrq;}
public String getSsbm() {return ssbm;}
public void setSsbm(String ssbm) {this.ssbm = ssbm;}
}物料领取javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//物料领取
public class Wllq extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//订单号
private String ddName;
//生产班组
private String scbz;
//
private String scx;
//领用物品
private String lywp;
//
private String lb;
//品号
private String ph;
//批次
private String pc;
//领用数量
private Integer lysl;
//加工数量
private Integer jgsl;
//领用人
private String lyr;
public String getDdName() {return ddName;}
public void setDdName(String ddName) {this.ddName = ddName;}
public String getScbz() {return scbz;}
public void setScbz(String scbz) {this.scbz = scbz;}
public String getScx() {return scx;}
public void setScx(String scx) {this.scx = scx;}
public String getLywp() {return lywp;}
public void setLywp(String lywp) {this.lywp = lywp;}
public String getLb() {return lb;}
public void setLb(String lb) {this.lb = lb;}
public String getPh() {return ph;}
public void setPh(String ph) {this.ph = ph;}
public String getPc() {return pc;}
public void setPc(String pc) {this.pc = pc;}
public Integer getLysl() {return lysl;}
public void setLysl(Integer lysl) {this.lysl = lysl;}
public Integer getJgsl() {return jgsl;}
public void setJgsl(Integer jgsl) {this.jgsl = jgsl;}
public String getLyr() {return lyr;}
public void setLyr(String lyr) {this.lyr = lyr;}
}