- 企业生产销售运营管理系统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_cipinck(
id int primary key auto_increment comment '主键',
cpId int comment '商品名称',
cksl int comment '出库数量',
showDate datetime comment '出库日期'
) comment '次品出库';
次品入库表创建语句如下：
create table t_cipinrk(
id int primary key auto_increment comment '主键',
cpId int comment '商品名称',
rksl int comment '次品入库数量',
showDate datetime comment '入库日期'
) comment '次品入库';
产品表创建语句如下：
create table t_cp(
id int primary key auto_increment comment '主键',
cpName varchar(100) comment '商品名称',
gg varchar(100) comment '规格',
sl int comment '数量'
) comment '产品';
成品出库表创建语句如下：
create table t_cpck(
id int primary key auto_increment comment '主键',
cpId int comment '商品名称',
cksl int comment '出库数量',
showDate datetime comment '出库日期'
) comment '成品出库';
成品入库表创建语句如下：
create table t_cprk(
id int primary key auto_increment comment '主键',
cpId int comment '商品名称',
rksl int comment '入库数量',
showDate datetime comment '入库日期'
) comment '成品入库';
产品生产表创建语句如下：
create table t_cpsc(
id int primary key auto_increment comment '主键',
cpId int comment '商品名称',
scsl int comment '生产数量',
showDate datetime 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_order(
id int primary key auto_increment comment '主键',
cpId int comment '商品名称',
cj varchar(100) comment '厂家',
cjdz varchar(100) comment '厂家地址',
sl int comment '数量',
zje int comment '总金额',
fzr varchar(100) comment '负责人',
lxdh varchar(100) comment '联系电话',
showDate datetime comment '销售日期',
ht varchar(100) comment '合同'
) comment '销售订单';
市场部需求表创建语句如下：
create table t_scxq(
id int primary key auto_increment comment '主键',
cpId int comment '商品名称',
dq varchar(100) comment '地区',
xq int comment '需求数量',
showDate datetime comment '记录日期'
) comment '市场部需求';
物料采购表创建语句如下：
create table t_wlcg(
id int primary key auto_increment comment '主键',
wlmc varchar(100) comment '物料名称',
gys varchar(100) comment '供应商',
kcsl int comment '库存数量',
showDate datetime comment '入库日期'
) comment '物料采购';
市场需求总结表创建语句如下：
create table t_xqzj(
id int primary key auto_increment comment '主键',
cpId int comment '商品名称',
dq varchar(100) comment '需求地点',
xq int comment '数量',
showDate datetime comment '记录日期'
) comment '市场需求总结';
员工表创建语句如下：
create table t_yg(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
ygName varchar(100) comment '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '',
bmName 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_cipinck(
id integer,
cpId int,
cksl int,
showDate datetime
);
--次品出库字段加注释
comment on column t_cipinck.id is '主键';
comment on column t_cipinck.cpId is '商品名称';
comment on column t_cipinck.cksl is '出库数量';
comment on column t_cipinck.showDate is '出库日期';
--次品出库表加注释
comment on table t_cipinck is '次品出库';
次品入库表创建语句如下：
create table t_cipinrk(
id integer,
cpId int,
rksl int,
showDate datetime
);
--次品入库字段加注释
comment on column t_cipinrk.id is '主键';
comment on column t_cipinrk.cpId is '商品名称';
comment on column t_cipinrk.rksl is '次品入库数量';
comment on column t_cipinrk.showDate is '入库日期';
--次品入库表加注释
comment on table t_cipinrk is '次品入库';
产品表创建语句如下：
create table t_cp(
id integer,
cpName varchar(100),
gg varchar(100),
sl int
);
--产品字段加注释
comment on column t_cp.id is '主键';
comment on column t_cp.cpName is '商品名称';
comment on column t_cp.gg is '规格';
comment on column t_cp.sl is '数量';
--产品表加注释
comment on table t_cp is '产品';
成品出库表创建语句如下：
create table t_cpck(
id integer,
cpId int,
cksl int,
showDate datetime
);
--成品出库字段加注释
comment on column t_cpck.id is '主键';
comment on column t_cpck.cpId is '商品名称';
comment on column t_cpck.cksl is '出库数量';
comment on column t_cpck.showDate is '出库日期';
--成品出库表加注释
comment on table t_cpck is '成品出库';
成品入库表创建语句如下：
create table t_cprk(
id integer,
cpId int,
rksl int,
showDate datetime
);
--成品入库字段加注释
comment on column t_cprk.id is '主键';
comment on column t_cprk.cpId is '商品名称';
comment on column t_cprk.rksl is '入库数量';
comment on column t_cprk.showDate is '入库日期';
--成品入库表加注释
comment on table t_cprk is '成品入库';
产品生产表创建语句如下：
create table t_cpsc(
id integer,
cpId int,
scsl int,
showDate datetime
);
--产品生产字段加注释
comment on column t_cpsc.id is '主键';
comment on column t_cpsc.cpId is '商品名称';
comment on column t_cpsc.scsl is '生产数量';
comment on column t_cpsc.showDate is '生产日期';
--产品生产表加注释
comment on table t_cpsc 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_order(
id integer,
cpId int,
cj varchar(100),
cjdz varchar(100),
sl int,
zje int,
fzr varchar(100),
lxdh varchar(100),
showDate datetime,
ht varchar(100)
);
--销售订单字段加注释
comment on column t_order.id is '主键';
comment on column t_order.cpId is '商品名称';
comment on column t_order.cj is '厂家';
comment on column t_order.cjdz is '厂家地址';
comment on column t_order.sl is '数量';
comment on column t_order.zje is '总金额';
comment on column t_order.fzr is '负责人';
comment on column t_order.lxdh is '联系电话';
comment on column t_order.showDate is '销售日期';
comment on column t_order.ht is '合同';
--销售订单表加注释
comment on table t_order is '销售订单';
市场部需求表创建语句如下：
create table t_scxq(
id integer,
cpId int,
dq varchar(100),
xq int,
showDate datetime
);
--市场部需求字段加注释
comment on column t_scxq.id is '主键';
comment on column t_scxq.cpId is '商品名称';
comment on column t_scxq.dq is '地区';
comment on column t_scxq.xq is '需求数量';
comment on column t_scxq.showDate is '记录日期';
--市场部需求表加注释
comment on table t_scxq is '市场部需求';
物料采购表创建语句如下：
create table t_wlcg(
id integer,
wlmc varchar(100),
gys varchar(100),
kcsl int,
showDate datetime
);
--物料采购字段加注释
comment on column t_wlcg.id is '主键';
comment on column t_wlcg.wlmc is '物料名称';
comment on column t_wlcg.gys is '供应商';
comment on column t_wlcg.kcsl is '库存数量';
comment on column t_wlcg.showDate is '入库日期';
--物料采购表加注释
comment on table t_wlcg is '物料采购';
市场需求总结表创建语句如下：
create table t_xqzj(
id integer,
cpId int,
dq varchar(100),
xq int,
showDate datetime
);
--市场需求总结字段加注释
comment on column t_xqzj.id is '主键';
comment on column t_xqzj.cpId is '商品名称';
comment on column t_xqzj.dq is '需求地点';
comment on column t_xqzj.xq is '数量';
comment on column t_xqzj.showDate is '记录日期';
--市场需求总结表加注释
comment on table t_xqzj is '市场需求总结';
员工表创建语句如下：
create table t_yg(
id integer,
username varchar(100),
password varchar(100),
ygName varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
bmName varchar(100)
);
--员工字段加注释
comment on column t_yg.id is '主键';
comment on column t_yg.username is '账号';
comment on column t_yg.password is '密码';
comment on column t_yg.ygName is '姓名';
comment on column t_yg.phone is '电话';
comment on column t_yg.age is '年龄';
comment on column t_yg.sex is '';
comment on column t_yg.bmName is '';
--员工表加注释
comment on table t_yg is '员工';
oracle特有，对应序列如下：
create sequence s_t_cipinck;
create sequence s_t_cipinrk;
create sequence s_t_cp;
create sequence s_t_cpck;
create sequence s_t_cprk;
create sequence s_t_cpsc;
create sequence s_t_gonggao;
create sequence s_t_order;
create sequence s_t_scxq;
create sequence s_t_wlcg;
create sequence s_t_xqzj;
create sequence s_t_yg;
企业生产销售运营管理系统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_cipinck(
id int identity(1,1) primary key not null,--主键
cpId int,--商品名称
cksl int,--出库数量
showDate datetime--出库日期
);
次品入库表创建语句如下：
--次品入库表注释
create table t_cipinrk(
id int identity(1,1) primary key not null,--主键
cpId int,--商品名称
rksl int,--次品入库数量
showDate datetime--入库日期
);
产品表创建语句如下：
--产品表注释
create table t_cp(
id int identity(1,1) primary key not null,--主键
cpName varchar(100),--商品名称
gg varchar(100),--规格
sl int--数量
);
成品出库表创建语句如下：
--成品出库表注释
create table t_cpck(
id int identity(1,1) primary key not null,--主键
cpId int,--商品名称
cksl int,--出库数量
showDate datetime--出库日期
);
成品入库表创建语句如下：
--成品入库表注释
create table t_cprk(
id int identity(1,1) primary key not null,--主键
cpId int,--商品名称
rksl int,--入库数量
showDate datetime--入库日期
);
产品生产表创建语句如下：
--产品生产表注释
create table t_cpsc(
id int identity(1,1) primary key not null,--主键
cpId int,--商品名称
scsl int,--生产数量
showDate datetime--生产日期
);
公告表创建语句如下：
--公告表注释
create table t_gonggao(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
content text,--内容
insertDate datetime--发起日期
);
销售订单表创建语句如下：
--销售订单表注释
create table t_order(
id int identity(1,1) primary key not null,--主键
cpId int,--商品名称
cj varchar(100),--厂家
cjdz varchar(100),--厂家地址
sl int,--数量
zje int,--总金额
fzr varchar(100),--负责人
lxdh varchar(100),--联系电话
showDate datetime,--销售日期
ht varchar(100)--合同
);
市场部需求表创建语句如下：
--市场部需求表注释
create table t_scxq(
id int identity(1,1) primary key not null,--主键
cpId int,--商品名称
dq varchar(100),--地区
xq int,--需求数量
showDate datetime--记录日期
);
物料采购表创建语句如下：
--物料采购表注释
create table t_wlcg(
id int identity(1,1) primary key not null,--主键
wlmc varchar(100),--物料名称
gys varchar(100),--供应商
kcsl int,--库存数量
showDate datetime--入库日期
);
市场需求总结表创建语句如下：
--市场需求总结表注释
create table t_xqzj(
id int identity(1,1) primary key not null,--主键
cpId int,--商品名称
dq varchar(100),--需求地点
xq int,--数量
showDate datetime--记录日期
);
员工表创建语句如下：
--员工表注释
create table t_yg(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
ygName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--
bmName 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_cipinck")
public class Cipinck {
//主键
@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 cpId;
//出库数量
private Integer cksl;
//出库日期
private Date showDate;
public Long getCpId() {return cpId;}
public void setCpId(Long cpId) {this.cpId = cpId;}
public Integer getCksl() {return cksl;}
public void setCksl(Integer cksl) {this.cksl = cksl;}
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_cipinrk")
public class Cipinrk {
//主键
@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 cpId;
//次品入库数量
private Integer rksl;
//入库日期
private Date showDate;
public Long getCpId() {return cpId;}
public void setCpId(Long cpId) {this.cpId = cpId;}
public Integer getRksl() {return rksl;}
public void setRksl(Integer rksl) {this.rksl = rksl;}
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_cp")
public class Cp {
//主键
@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 cpName;
//规格
private String gg;
//数量
private Integer sl;
public String getCpName() {return cpName;}
public void setCpName(String cpName) {this.cpName = cpName;}
public String getGg() {return gg;}
public void setGg(String gg) {this.gg = gg;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
}成品出库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_cpck")
public class Cpck {
//主键
@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 cpId;
//出库数量
private Integer cksl;
//出库日期
private Date showDate;
public Long getCpId() {return cpId;}
public void setCpId(Long cpId) {this.cpId = cpId;}
public Integer getCksl() {return cksl;}
public void setCksl(Integer cksl) {this.cksl = cksl;}
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_cprk")
public class Cprk {
//主键
@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 cpId;
//入库数量
private Integer rksl;
//入库日期
private Date showDate;
public Long getCpId() {return cpId;}
public void setCpId(Long cpId) {this.cpId = cpId;}
public Integer getRksl() {return rksl;}
public void setRksl(Integer rksl) {this.rksl = rksl;}
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_cpsc")
public class Cpsc {
//主键
@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 cpId;
//生产数量
private Integer scsl;
//生产日期
private Date showDate;
public Long getCpId() {return cpId;}
public void setCpId(Long cpId) {this.cpId = cpId;}
public Integer getScsl() {return scsl;}
public void setScsl(Integer scsl) {this.scsl = scsl;}
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_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_order")
public class Order {
//主键
@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 cpId;
//厂家
private String cj;
//厂家地址
private String cjdz;
//数量
private Integer sl;
//总金额
private Integer zje;
//负责人
private String fzr;
//联系电话
private String lxdh;
//销售日期
private Date showDate;
//合同
private String ht;
public Long getCpId() {return cpId;}
public void setCpId(Long cpId) {this.cpId = cpId;}
public String getCj() {return cj;}
public void setCj(String cj) {this.cj = cj;}
public String getCjdz() {return cjdz;}
public void setCjdz(String cjdz) {this.cjdz = cjdz;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
public Integer getZje() {return zje;}
public void setZje(Integer zje) {this.zje = zje;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public String getLxdh() {return lxdh;}
public void setLxdh(String lxdh) {this.lxdh = lxdh;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getHt() {return ht;}
public void setHt(String ht) {this.ht = ht;}
}市场部需求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_scxq")
public class Scxq {
//主键
@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 cpId;
//地区
private String dq;
//需求数量
private Integer xq;
//记录日期
private Date showDate;
public Long getCpId() {return cpId;}
public void setCpId(Long cpId) {this.cpId = cpId;}
public String getDq() {return dq;}
public void setDq(String dq) {this.dq = dq;}
public Integer getXq() {return xq;}
public void setXq(Integer xq) {this.xq = xq;}
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_wlcg")
public class Wlcg {
//主键
@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 wlmc;
//供应商
private String gys;
//库存数量
private Integer kcsl;
//入库日期
private Date showDate;
public String getWlmc() {return wlmc;}
public void setWlmc(String wlmc) {this.wlmc = wlmc;}
public String getGys() {return gys;}
public void setGys(String gys) {this.gys = gys;}
public Integer getKcsl() {return kcsl;}
public void setKcsl(Integer kcsl) {this.kcsl = kcsl;}
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_xqzj")
public class Xqzj {
//主键
@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 cpId;
//需求地点
private String dq;
//数量
private Integer xq;
//记录日期
private Date showDate;
public Long getCpId() {return cpId;}
public void setCpId(Long cpId) {this.cpId = cpId;}
public String getDq() {return dq;}
public void setDq(String dq) {this.dq = dq;}
public Integer getXq() {return xq;}
public void setXq(Integer xq) {this.xq = xq;}
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_yg")
public class Yg {
//主键
@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 ygName;
//电话
private String phone;
//年龄
private String age;
//
private String sex;
//
private String bmName;
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 getYgName() {return ygName;}
public void setYgName(String ygName) {this.ygName = ygName;}
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 getBmName() {return bmName;}
public void setBmName(String bmName) {this.bmName = bmName;}
}企业生产销售运营管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
次品出库javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//次品出库
public class Cipinck extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//商品名称
private Long cpId;
//出库数量
private Integer cksl;
//出库日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
public Long getCpId() {return cpId;}
public void setCpId(Long cpId) {this.cpId = cpId;}
public Integer getCksl() {return cksl;}
public void setCksl(Integer cksl) {this.cksl = cksl;}
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 Cipinrk extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//商品名称
private Long cpId;
//次品入库数量
private Integer rksl;
//入库日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
public Long getCpId() {return cpId;}
public void setCpId(Long cpId) {this.cpId = cpId;}
public Integer getRksl() {return rksl;}
public void setRksl(Integer rksl) {this.rksl = rksl;}
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 Cp extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//商品名称
private String cpName;
//规格
private String gg;
//数量
private Integer sl;
public String getCpName() {return cpName;}
public void setCpName(String cpName) {this.cpName = cpName;}
public String getGg() {return gg;}
public void setGg(String gg) {this.gg = gg;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
}成品出库javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//成品出库
public class Cpck extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//商品名称
private Long cpId;
//出库数量
private Integer cksl;
//出库日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
public Long getCpId() {return cpId;}
public void setCpId(Long cpId) {this.cpId = cpId;}
public Integer getCksl() {return cksl;}
public void setCksl(Integer cksl) {this.cksl = cksl;}
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 Cprk extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//商品名称
private Long cpId;
//入库数量
private Integer rksl;
//入库日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
public Long getCpId() {return cpId;}
public void setCpId(Long cpId) {this.cpId = cpId;}
public Integer getRksl() {return rksl;}
public void setRksl(Integer rksl) {this.rksl = rksl;}
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 Cpsc extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//商品名称
private Long cpId;
//生产数量
private Integer scsl;
//生产日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
public Long getCpId() {return cpId;}
public void setCpId(Long cpId) {this.cpId = cpId;}
public Integer getScsl() {return scsl;}
public void setScsl(Integer scsl) {this.scsl = scsl;}
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 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 Order extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//商品名称
private Long cpId;
//厂家
private String cj;
//厂家地址
private String cjdz;
//数量
private Integer sl;
//总金额
private Integer zje;
//负责人
private String fzr;
//联系电话
private String lxdh;
//销售日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
//合同
private String ht;
public Long getCpId() {return cpId;}
public void setCpId(Long cpId) {this.cpId = cpId;}
public String getCj() {return cj;}
public void setCj(String cj) {this.cj = cj;}
public String getCjdz() {return cjdz;}
public void setCjdz(String cjdz) {this.cjdz = cjdz;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
public Integer getZje() {return zje;}
public void setZje(Integer zje) {this.zje = zje;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public String getLxdh() {return lxdh;}
public void setLxdh(String lxdh) {this.lxdh = lxdh;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getHt() {return ht;}
public void setHt(String ht) {this.ht = ht;}
}市场部需求javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//市场部需求
public class Scxq extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//商品名称
private Long cpId;
//地区
private String dq;
//需求数量
private Integer xq;
//记录日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
public Long getCpId() {return cpId;}
public void setCpId(Long cpId) {this.cpId = cpId;}
public String getDq() {return dq;}
public void setDq(String dq) {this.dq = dq;}
public Integer getXq() {return xq;}
public void setXq(Integer xq) {this.xq = xq;}
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 Wlcg extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//物料名称
private String wlmc;
//供应商
private String gys;
//库存数量
private Integer kcsl;
//入库日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
public String getWlmc() {return wlmc;}
public void setWlmc(String wlmc) {this.wlmc = wlmc;}
public String getGys() {return gys;}
public void setGys(String gys) {this.gys = gys;}
public Integer getKcsl() {return kcsl;}
public void setKcsl(Integer kcsl) {this.kcsl = kcsl;}
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 Xqzj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//商品名称
private Long cpId;
//需求地点
private String dq;
//数量
private Integer xq;
//记录日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
public Long getCpId() {return cpId;}
public void setCpId(Long cpId) {this.cpId = cpId;}
public String getDq() {return dq;}
public void setDq(String dq) {this.dq = dq;}
public Integer getXq() {return xq;}
public void setXq(Integer xq) {this.xq = xq;}
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 Yg 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 ygName;
//电话
private String phone;
//年龄
private String age;
//
private String sex;
//
private String bmName;
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 getYgName() {return ygName;}
public void setYgName(String ygName) {this.ygName = ygName;}
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 getBmName() {return bmName;}
public void setBmName(String bmName) {this.bmName = bmName;}
}