- 某钢材水泥销售公司业务管理系统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_cg(
id int primary key auto_increment comment '主键',
cgsp varchar(100) comment '采购商品',
cgsl varchar(100) comment '采购数量',
cgje varchar(100) comment '采购金额',
fzr varchar(100) comment '负责人',
lxdh varchar(100) comment '联系电话',
showDate datetime comment '采购时间'
) comment '采购';
采购退货表创建语句如下：
create table t_cgth(
id int primary key auto_increment comment '主键',
cgsp varchar(100) comment '采购退货商品',
cgsl varchar(100) comment '采购退货数量',
fzr varchar(100) comment '负责人',
lxdh varchar(100) comment '联系电话',
remark text comment '备注'
) comment '采购退货';
出库表创建语句如下：
create table t_ck(
id int primary key auto_increment comment '主键',
productId int comment '商品',
sl int comment '数量',
showDate datetime comment '出库日期',
fzr varchar(100) comment '负责人',
lxdh varchar(100) comment '联系电话'
) comment '出库';
财务表创建语句如下：
create table t_cw(
id int primary key auto_increment comment '主键',
ysk int comment '应收款',
yfk int comment '应付款',
fyzc int comment '费用支出',
gdzc int comment '固定资产',
yf varchar(100) comment '月份'
) comment '财务';
供应商表创建语句如下：
create table t_gys(
id int primary key auto_increment comment '主键',
gysName varchar(100) comment '供应商名称',
gycp varchar(100) comment '供应产品',
dz varchar(100) comment '地址',
fzr varchar(100) comment '负责人',
lxdh varchar(100) comment '联系电话'
) comment '供应商';
入库表创建语句如下：
create table t_rk(
id int primary key auto_increment comment '主键',
productId int comment '商品',
sl int comment '数量',
showDate datetime comment '入库日期',
fzr varchar(100) comment '负责人',
lxdh varchar(100) comment '联系电话'
) comment '入库';
销售订单表创建语句如下：
create table t_xs(
id int primary key auto_increment comment '主键',
xssp varchar(100) comment '销售商品',
xssl varchar(100) comment '销售数量',
xsje varchar(100) comment '销售金额',
fzr varchar(100) comment '负责人',
lxdh varchar(100) comment '联系电话',
showDate datetime comment '销售时间'
) comment '销售订单';
销售退货表创建语句如下：
create table t_xsth(
id int primary key auto_increment comment '主键',
xssp varchar(100) comment '销售退货商品',
xssl varchar(100) comment '销售退货数量',
fzr varchar(100) comment '负责人',
lxdh varchar(100) comment '联系电话',
remark text 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 '',
zw varchar(100) comment '职务',
xs 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_cg(
id integer,
cgsp varchar(100),
cgsl varchar(100),
cgje varchar(100),
fzr varchar(100),
lxdh varchar(100),
showDate datetime
);
--采购字段加注释
comment on column t_cg.id is '主键';
comment on column t_cg.cgsp is '采购商品';
comment on column t_cg.cgsl is '采购数量';
comment on column t_cg.cgje is '采购金额';
comment on column t_cg.fzr is '负责人';
comment on column t_cg.lxdh is '联系电话';
comment on column t_cg.showDate is '采购时间';
--采购表加注释
comment on table t_cg is '采购';
采购退货表创建语句如下：
create table t_cgth(
id integer,
cgsp varchar(100),
cgsl varchar(100),
fzr varchar(100),
lxdh varchar(100),
remark text
);
--采购退货字段加注释
comment on column t_cgth.id is '主键';
comment on column t_cgth.cgsp is '采购退货商品';
comment on column t_cgth.cgsl is '采购退货数量';
comment on column t_cgth.fzr is '负责人';
comment on column t_cgth.lxdh is '联系电话';
comment on column t_cgth.remark is '备注';
--采购退货表加注释
comment on table t_cgth is '采购退货';
出库表创建语句如下：
create table t_ck(
id integer,
productId int,
sl int,
showDate datetime,
fzr varchar(100),
lxdh varchar(100)
);
--出库字段加注释
comment on column t_ck.id is '主键';
comment on column t_ck.productId is '商品';
comment on column t_ck.sl is '数量';
comment on column t_ck.showDate is '出库日期';
comment on column t_ck.fzr is '负责人';
comment on column t_ck.lxdh is '联系电话';
--出库表加注释
comment on table t_ck is '出库';
财务表创建语句如下：
create table t_cw(
id integer,
ysk int,
yfk int,
fyzc int,
gdzc int,
yf varchar(100)
);
--财务字段加注释
comment on column t_cw.id is '主键';
comment on column t_cw.ysk is '应收款';
comment on column t_cw.yfk is '应付款';
comment on column t_cw.fyzc is '费用支出';
comment on column t_cw.gdzc is '固定资产';
comment on column t_cw.yf is '月份';
--财务表加注释
comment on table t_cw is '财务';
供应商表创建语句如下：
create table t_gys(
id integer,
gysName varchar(100),
gycp varchar(100),
dz varchar(100),
fzr varchar(100),
lxdh varchar(100)
);
--供应商字段加注释
comment on column t_gys.id is '主键';
comment on column t_gys.gysName is '供应商名称';
comment on column t_gys.gycp is '供应产品';
comment on column t_gys.dz is '地址';
comment on column t_gys.fzr is '负责人';
comment on column t_gys.lxdh is '联系电话';
--供应商表加注释
comment on table t_gys is '供应商';
入库表创建语句如下：
create table t_rk(
id integer,
productId int,
sl int,
showDate datetime,
fzr varchar(100),
lxdh varchar(100)
);
--入库字段加注释
comment on column t_rk.id is '主键';
comment on column t_rk.productId is '商品';
comment on column t_rk.sl is '数量';
comment on column t_rk.showDate is '入库日期';
comment on column t_rk.fzr is '负责人';
comment on column t_rk.lxdh is '联系电话';
--入库表加注释
comment on table t_rk is '入库';
销售订单表创建语句如下：
create table t_xs(
id integer,
xssp varchar(100),
xssl varchar(100),
xsje varchar(100),
fzr varchar(100),
lxdh varchar(100),
showDate datetime
);
--销售订单字段加注释
comment on column t_xs.id is '主键';
comment on column t_xs.xssp is '销售商品';
comment on column t_xs.xssl is '销售数量';
comment on column t_xs.xsje is '销售金额';
comment on column t_xs.fzr is '负责人';
comment on column t_xs.lxdh is '联系电话';
comment on column t_xs.showDate is '销售时间';
--销售订单表加注释
comment on table t_xs is '销售订单';
销售退货表创建语句如下：
create table t_xsth(
id integer,
xssp varchar(100),
xssl varchar(100),
fzr varchar(100),
lxdh varchar(100),
remark text
);
--销售退货字段加注释
comment on column t_xsth.id is '主键';
comment on column t_xsth.xssp is '销售退货商品';
comment on column t_xsth.xssl is '销售退货数量';
comment on column t_xsth.fzr is '负责人';
comment on column t_xsth.lxdh is '联系电话';
comment on column t_xsth.remark is '备注';
--销售退货表加注释
comment on table t_xsth 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),
zw varchar(100),
xs 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.zw is '职务';
comment on column t_yg.xs is '薪水';
--员工表加注释
comment on table t_yg is '员工';
oracle特有，对应序列如下：
create sequence s_t_cg;
create sequence s_t_cgth;
create sequence s_t_ck;
create sequence s_t_cw;
create sequence s_t_gys;
create sequence s_t_rk;
create sequence s_t_xs;
create sequence s_t_xsth;
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_cg(
id int identity(1,1) primary key not null,--主键
cgsp varchar(100),--采购商品
cgsl varchar(100),--采购数量
cgje varchar(100),--采购金额
fzr varchar(100),--负责人
lxdh varchar(100),--联系电话
showDate datetime--采购时间
);
采购退货表创建语句如下：
--采购退货表注释
create table t_cgth(
id int identity(1,1) primary key not null,--主键
cgsp varchar(100),--采购退货商品
cgsl varchar(100),--采购退货数量
fzr varchar(100),--负责人
lxdh varchar(100),--联系电话
remark text--备注
);
出库表创建语句如下：
--出库表注释
create table t_ck(
id int identity(1,1) primary key not null,--主键
productId int,--商品
sl int,--数量
showDate datetime,--出库日期
fzr varchar(100),--负责人
lxdh varchar(100)--联系电话
);
财务表创建语句如下：
--财务表注释
create table t_cw(
id int identity(1,1) primary key not null,--主键
ysk int,--应收款
yfk int,--应付款
fyzc int,--费用支出
gdzc int,--固定资产
yf varchar(100)--月份
);
供应商表创建语句如下：
--供应商表注释
create table t_gys(
id int identity(1,1) primary key not null,--主键
gysName varchar(100),--供应商名称
gycp varchar(100),--供应产品
dz varchar(100),--地址
fzr varchar(100),--负责人
lxdh varchar(100)--联系电话
);
入库表创建语句如下：
--入库表注释
create table t_rk(
id int identity(1,1) primary key not null,--主键
productId int,--商品
sl int,--数量
showDate datetime,--入库日期
fzr varchar(100),--负责人
lxdh varchar(100)--联系电话
);
销售订单表创建语句如下：
--销售订单表注释
create table t_xs(
id int identity(1,1) primary key not null,--主键
xssp varchar(100),--销售商品
xssl varchar(100),--销售数量
xsje varchar(100),--销售金额
fzr varchar(100),--负责人
lxdh varchar(100),--联系电话
showDate datetime--销售时间
);
销售退货表创建语句如下：
--销售退货表注释
create table t_xsth(
id int identity(1,1) primary key not null,--主键
xssp varchar(100),--销售退货商品
xssl varchar(100),--销售退货数量
fzr varchar(100),--负责人
lxdh varchar(100),--联系电话
remark text--备注
);
员工表创建语句如下：
--员工表注释
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),--
zw varchar(100),--职务
xs 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_cg")
public class Cg {
//主键
@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 cgsp;
//采购数量
private String cgsl;
//采购金额
private String cgje;
//负责人
private String fzr;
//联系电话
private String lxdh;
//采购时间
private Date showDate;
public String getCgsp() {return cgsp;}
public void setCgsp(String cgsp) {this.cgsp = cgsp;}
public String getCgsl() {return cgsl;}
public void setCgsl(String cgsl) {this.cgsl = cgsl;}
public String getCgje() {return cgje;}
public void setCgje(String cgje) {this.cgje = cgje;}
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;}
}采购退货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_cgth")
public class Cgth {
//主键
@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 cgsp;
//采购退货数量
private String cgsl;
//负责人
private String fzr;
//联系电话
private String lxdh;
//备注
private String remark;
public String getCgsp() {return cgsp;}
public void setCgsp(String cgsp) {this.cgsp = cgsp;}
public String getCgsl() {return cgsl;}
public void setCgsl(String cgsl) {this.cgsl = cgsl;}
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 String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}出库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_ck")
public class Ck {
//主键
@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 productId;
//数量
private Integer sl;
//出库日期
private Date showDate;
//负责人
private String fzr;
//联系电话
private String lxdh;
public Long getProductId() {return productId;}
public void setProductId(Long productId) {this.productId = productId;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
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;}
}财务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_cw")
public class Cw {
//主键
@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 ysk;
//应付款
private Integer yfk;
//费用支出
private Integer fyzc;
//固定资产
private Integer gdzc;
//月份
private String yf;
public Integer getYsk() {return ysk;}
public void setYsk(Integer ysk) {this.ysk = ysk;}
public Integer getYfk() {return yfk;}
public void setYfk(Integer yfk) {this.yfk = yfk;}
public Integer getFyzc() {return fyzc;}
public void setFyzc(Integer fyzc) {this.fyzc = fyzc;}
public Integer getGdzc() {return gdzc;}
public void setGdzc(Integer gdzc) {this.gdzc = gdzc;}
public String getYf() {return yf;}
public void setYf(String yf) {this.yf = yf;}
}供应商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_gys")
public class Gys {
//主键
@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 gysName;
//供应产品
private String gycp;
//地址
private String dz;
//负责人
private String fzr;
//联系电话
private String lxdh;
public String getGysName() {return gysName;}
public void setGysName(String gysName) {this.gysName = gysName;}
public String getGycp() {return gycp;}
public void setGycp(String gycp) {this.gycp = gycp;}
public String getDz() {return dz;}
public void setDz(String dz) {this.dz = dz;}
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;}
}入库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_rk")
public class Rk {
//主键
@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 productId;
//数量
private Integer sl;
//入库日期
private Date showDate;
//负责人
private String fzr;
//联系电话
private String lxdh;
public Long getProductId() {return productId;}
public void setProductId(Long productId) {this.productId = productId;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
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;}
}销售订单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_xs")
public class Xs {
//主键
@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 xssp;
//销售数量
private String xssl;
//销售金额
private String xsje;
//负责人
private String fzr;
//联系电话
private String lxdh;
//销售时间
private Date showDate;
public String getXssp() {return xssp;}
public void setXssp(String xssp) {this.xssp = xssp;}
public String getXssl() {return xssl;}
public void setXssl(String xssl) {this.xssl = xssl;}
public String getXsje() {return xsje;}
public void setXsje(String xsje) {this.xsje = xsje;}
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;}
}销售退货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_xsth")
public class Xsth {
//主键
@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 xssp;
//销售退货数量
private String xssl;
//负责人
private String fzr;
//联系电话
private String lxdh;
//备注
private String remark;
public String getXssp() {return xssp;}
public void setXssp(String xssp) {this.xssp = xssp;}
public String getXssl() {return xssl;}
public void setXssl(String xssl) {this.xssl = xssl;}
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 String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}员工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 zw;
//薪水
private String xs;
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 getZw() {return zw;}
public void setZw(String zw) {this.zw = zw;}
public String getXs() {return xs;}
public void setXs(String xs) {this.xs = xs;}
}某钢材水泥销售公司业务管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
采购javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//采购
public class Cg extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//采购商品
private String cgsp;
//采购数量
private String cgsl;
//采购金额
private String cgje;
//负责人
private String fzr;
//联系电话
private String lxdh;
//采购时间
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
public String getCgsp() {return cgsp;}
public void setCgsp(String cgsp) {this.cgsp = cgsp;}
public String getCgsl() {return cgsl;}
public void setCgsl(String cgsl) {this.cgsl = cgsl;}
public String getCgje() {return cgje;}
public void setCgje(String cgje) {this.cgje = cgje;}
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;}
}采购退货javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//采购退货
public class Cgth extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//采购退货商品
private String cgsp;
//采购退货数量
private String cgsl;
//负责人
private String fzr;
//联系电话
private String lxdh;
//备注
private String remark;
public String getCgsp() {return cgsp;}
public void setCgsp(String cgsp) {this.cgsp = cgsp;}
public String getCgsl() {return cgsl;}
public void setCgsl(String cgsl) {this.cgsl = cgsl;}
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 String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}出库javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//出库
public class Ck extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//商品
private Long productId;
//数量
private Integer sl;
//出库日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
//负责人
private String fzr;
//联系电话
private String lxdh;
public Long getProductId() {return productId;}
public void setProductId(Long productId) {this.productId = productId;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
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;}
}财务javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//财务
public class Cw extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//应收款
private Integer ysk;
//应付款
private Integer yfk;
//费用支出
private Integer fyzc;
//固定资产
private Integer gdzc;
//月份
@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
private String yf;
public Integer getYsk() {return ysk;}
public void setYsk(Integer ysk) {this.ysk = ysk;}
public Integer getYfk() {return yfk;}
public void setYfk(Integer yfk) {this.yfk = yfk;}
public Integer getFyzc() {return fyzc;}
public void setFyzc(Integer fyzc) {this.fyzc = fyzc;}
public Integer getGdzc() {return gdzc;}
public void setGdzc(Integer gdzc) {this.gdzc = gdzc;}
public String getYf() {return yf;}
public void setYf(String yf) {this.yf = yf;}
}供应商javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//供应商
public class Gys extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//供应商名称
private String gysName;
//供应产品
private String gycp;
//地址
private String dz;
//负责人
private String fzr;
//联系电话
private String lxdh;
public String getGysName() {return gysName;}
public void setGysName(String gysName) {this.gysName = gysName;}
public String getGycp() {return gycp;}
public void setGycp(String gycp) {this.gycp = gycp;}
public String getDz() {return dz;}
public void setDz(String dz) {this.dz = dz;}
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;}
}入库javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//入库
public class Rk extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//商品
private Long productId;
//数量
private Integer sl;
//入库日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
//负责人
private String fzr;
//联系电话
private String lxdh;
public Long getProductId() {return productId;}
public void setProductId(Long productId) {this.productId = productId;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
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;}
}销售订单javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//销售订单
public class Xs extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//销售商品
private String xssp;
//销售数量
private String xssl;
//销售金额
private String xsje;
//负责人
private String fzr;
//联系电话
private String lxdh;
//销售时间
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
public String getXssp() {return xssp;}
public void setXssp(String xssp) {this.xssp = xssp;}
public String getXssl() {return xssl;}
public void setXssl(String xssl) {this.xssl = xssl;}
public String getXsje() {return xsje;}
public void setXsje(String xsje) {this.xsje = xsje;}
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;}
}销售退货javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//销售退货
public class Xsth extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//销售退货商品
private String xssp;
//销售退货数量
private String xssl;
//负责人
private String fzr;
//联系电话
private String lxdh;
//备注
private String remark;
public String getXssp() {return xssp;}
public void setXssp(String xssp) {this.xssp = xssp;}
public String getXssl() {return xssl;}
public void setXssl(String xssl) {this.xssl = xssl;}
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 String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}员工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 zw;
//薪水
private String xs;
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 getZw() {return zw;}
public void setZw(String zw) {this.zw = zw;}
public String getXs() {return xs;}
public void setXs(String xs) {this.xs = xs;}
}