- 实木门生产流水线管理系统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_cp(
id int primary key auto_increment comment '主键',
cpName varchar(100) comment '',
sl int comment '库存数量',
remark text comment '备注'
) comment '成品';
客户公司表创建语句如下：
create table t_customer(
id int primary key auto_increment comment '主键',
customerName varchar(100) comment '公司名称',
dz varchar(100) comment '地址',
lxr varchar(100) comment '联系人',
phone varchar(100) comment '电话',
remark text comment '备注',
ygId int 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 '主键',
orderNum varchar(100) comment '订单编号',
ygId int comment '销售',
customerId int comment '客户',
cpName varchar(100) comment '',
cjj int comment '成交价',
sl int comment '数量',
dj int comment '定金',
zfk int comment '总付款',
sfjd varchar(100) comment '',
remark text comment '备注',
showDate datetime comment '订单日期',
ht varchar(100) comment '合同'
) comment '订单';
普通管理员表创建语句如下：
create table t_ptadmin(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
ptadminName varchar(100) comment '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment ''
) comment '普通管理员';
生产订单表创建语句如下：
create table t_scdd(
id int primary key auto_increment comment '主键',
orderNum varchar(100) comment '订单编号',
ygId int comment '员工',
cpName varchar(100) comment '',
sl int comment '数量',
status varchar(100) comment '',
remark text comment '备注'
) comment '生产订单';
生产订单记录表创建语句如下：
create table t_scddlist(
id int primary key auto_increment comment '主键',
scddId int comment '生产订单',
jd varchar(100) comment '',
showDate datetime comment '操作时间',
czr varchar(100) comment '负责人',
remark text comment '备注',
yljl text comment '用料记录'
) comment '生产订单记录';
原材料供应表创建语句如下：
create table t_ycl(
id int primary key auto_increment comment '主键',
yclName varchar(100) comment '',
gys varchar(100) comment '供应商',
showDate datetime comment '供应日期',
sl int 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 '',
gh varchar(100) comment '工号',
js 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_cp(
id integer,
cpName varchar(100),
sl int,
remark text
);
--成品字段加注释
comment on column t_cp.id is '主键';
comment on column t_cp.cpName is '';
comment on column t_cp.sl is '库存数量';
comment on column t_cp.remark is '备注';
--成品表加注释
comment on table t_cp is '成品';
客户公司表创建语句如下：
create table t_customer(
id integer,
customerName varchar(100),
dz varchar(100),
lxr varchar(100),
phone varchar(100),
remark text,
ygId int
);
--客户公司字段加注释
comment on column t_customer.id is '主键';
comment on column t_customer.customerName is '公司名称';
comment on column t_customer.dz is '地址';
comment on column t_customer.lxr is '联系人';
comment on column t_customer.phone is '电话';
comment on column t_customer.remark is '备注';
comment on column t_customer.ygId is '所属销售';
--客户公司表加注释
comment on table t_customer 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,
orderNum varchar(100),
ygId int,
customerId int,
cpName varchar(100),
cjj int,
sl int,
dj int,
zfk int,
sfjd varchar(100),
remark text,
showDate datetime,
ht varchar(100)
);
--订单字段加注释
comment on column t_order.id is '主键';
comment on column t_order.orderNum is '订单编号';
comment on column t_order.ygId is '销售';
comment on column t_order.customerId is '客户';
comment on column t_order.cpName is '';
comment on column t_order.cjj is '成交价';
comment on column t_order.sl is '数量';
comment on column t_order.dj is '定金';
comment on column t_order.zfk is '总付款';
comment on column t_order.sfjd is '';
comment on column t_order.remark is '备注';
comment on column t_order.showDate is '订单日期';
comment on column t_order.ht is '合同';
--订单表加注释
comment on table t_order is '订单';
普通管理员表创建语句如下：
create table t_ptadmin(
id integer,
username varchar(100),
password varchar(100),
ptadminName varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100)
);
--普通管理员字段加注释
comment on column t_ptadmin.id is '主键';
comment on column t_ptadmin.username is '账号';
comment on column t_ptadmin.password is '密码';
comment on column t_ptadmin.ptadminName is '姓名';
comment on column t_ptadmin.phone is '电话';
comment on column t_ptadmin.age is '年龄';
comment on column t_ptadmin.sex is '';
--普通管理员表加注释
comment on table t_ptadmin is '普通管理员';
生产订单表创建语句如下：
create table t_scdd(
id integer,
orderNum varchar(100),
ygId int,
cpName varchar(100),
sl int,
status varchar(100),
remark text
);
--生产订单字段加注释
comment on column t_scdd.id is '主键';
comment on column t_scdd.orderNum is '订单编号';
comment on column t_scdd.ygId is '员工';
comment on column t_scdd.cpName is '';
comment on column t_scdd.sl is '数量';
comment on column t_scdd.status is '';
comment on column t_scdd.remark is '备注';
--生产订单表加注释
comment on table t_scdd is '生产订单';
生产订单记录表创建语句如下：
create table t_scddlist(
id integer,
scddId int,
jd varchar(100),
showDate datetime,
czr varchar(100),
remark text,
yljl text
);
--生产订单记录字段加注释
comment on column t_scddlist.id is '主键';
comment on column t_scddlist.scddId is '生产订单';
comment on column t_scddlist.jd is '';
comment on column t_scddlist.showDate is '操作时间';
comment on column t_scddlist.czr is '负责人';
comment on column t_scddlist.remark is '备注';
comment on column t_scddlist.yljl is '用料记录';
--生产订单记录表加注释
comment on table t_scddlist is '生产订单记录';
原材料供应表创建语句如下：
create table t_ycl(
id integer,
yclName varchar(100),
gys varchar(100),
showDate datetime,
sl int,
remark text
);
--原材料供应字段加注释
comment on column t_ycl.id is '主键';
comment on column t_ycl.yclName is '';
comment on column t_ycl.gys is '供应商';
comment on column t_ycl.showDate is '供应日期';
comment on column t_ycl.sl is '库存数量';
comment on column t_ycl.remark is '备注';
--原材料供应表加注释
comment on table t_ycl 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),
gh varchar(100),
js 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.gh is '工号';
comment on column t_yg.js is '';
--员工表加注释
comment on table t_yg is '员工';
oracle特有，对应序列如下：
create sequence s_t_cp;
create sequence s_t_customer;
create sequence s_t_gonggao;
create sequence s_t_order;
create sequence s_t_ptadmin;
create sequence s_t_scdd;
create sequence s_t_scddlist;
create sequence s_t_ycl;
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_cp(
id int identity(1,1) primary key not null,--主键
cpName varchar(100),--
sl int,--库存数量
remark text--备注
);
客户公司表创建语句如下：
--客户公司表注释
create table t_customer(
id int identity(1,1) primary key not null,--主键
customerName varchar(100),--公司名称
dz varchar(100),--地址
lxr varchar(100),--联系人
phone varchar(100),--电话
remark text,--备注
ygId int--所属销售
);
公告表创建语句如下：
--公告表注释
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,--主键
orderNum varchar(100),--订单编号
ygId int,--销售
customerId int,--客户
cpName varchar(100),--
cjj int,--成交价
sl int,--数量
dj int,--定金
zfk int,--总付款
sfjd varchar(100),--
remark text,--备注
showDate datetime,--订单日期
ht varchar(100)--合同
);
普通管理员表创建语句如下：
--普通管理员表注释
create table t_ptadmin(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
ptadminName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100)--
);
生产订单表创建语句如下：
--生产订单表注释
create table t_scdd(
id int identity(1,1) primary key not null,--主键
orderNum varchar(100),--订单编号
ygId int,--员工
cpName varchar(100),--
sl int,--数量
status varchar(100),--
remark text--备注
);
生产订单记录表创建语句如下：
--生产订单记录表注释
create table t_scddlist(
id int identity(1,1) primary key not null,--主键
scddId int,--生产订单
jd varchar(100),--
showDate datetime,--操作时间
czr varchar(100),--负责人
remark text,--备注
yljl text--用料记录
);
原材料供应表创建语句如下：
--原材料供应表注释
create table t_ycl(
id int identity(1,1) primary key not null,--主键
yclName varchar(100),--
gys varchar(100),--供应商
showDate datetime,--供应日期
sl int,--库存数量
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),--
gh varchar(100),--工号
js 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_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 Integer sl;
//备注
private String remark;
public String getCpName() {return cpName;}
public void setCpName(String cpName) {this.cpName = cpName;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
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_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 customerName;
//地址
private String dz;
//联系人
private String lxr;
//电话
private String phone;
//备注
private String remark;
//所属销售
private Long ygId;
public String getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getDz() {return dz;}
public void setDz(String dz) {this.dz = dz;}
public String getLxr() {return lxr;}
public void setLxr(String lxr) {this.lxr = lxr;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public Long getYgId() {return ygId;}
public void setYgId(Long ygId) {this.ygId = ygId;}
}公告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 String orderNum;
//销售
private Long ygId;
//客户
private Long customerId;
//
private String cpName;
//成交价
private Integer cjj;
//数量
private Integer sl;
//定金
private Integer dj;
//总付款
private Integer zfk;
//
private String sfjd;
//备注
private String remark;
//订单日期
private Date showDate;
//合同
private String ht;
public String getOrderNum() {return orderNum;}
public void setOrderNum(String orderNum) {this.orderNum = orderNum;}
public Long getYgId() {return ygId;}
public void setYgId(Long ygId) {this.ygId = ygId;}
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public String getCpName() {return cpName;}
public void setCpName(String cpName) {this.cpName = cpName;}
public Integer getCjj() {return cjj;}
public void setCjj(Integer cjj) {this.cjj = cjj;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
public Integer getDj() {return dj;}
public void setDj(Integer dj) {this.dj = dj;}
public Integer getZfk() {return zfk;}
public void setZfk(Integer zfk) {this.zfk = zfk;}
public String getSfjd() {return sfjd;}
public void setSfjd(String sfjd) {this.sfjd = sfjd;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
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_ptadmin")
public class Ptadmin {
//主键
@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 ptadminName;
//电话
private String phone;
//年龄
private String age;
//
private String sex;
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 getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
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;}
}生产订单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_scdd")
public class Scdd {
//主键
@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 orderNum;
//员工
private Long ygId;
//
private String cpName;
//数量
private Integer sl;
//
private String status;
//备注
private String remark;
public String getOrderNum() {return orderNum;}
public void setOrderNum(String orderNum) {this.orderNum = orderNum;}
public Long getYgId() {return ygId;}
public void setYgId(Long ygId) {this.ygId = ygId;}
public String getCpName() {return cpName;}
public void setCpName(String cpName) {this.cpName = cpName;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
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_scddlist")
public class Scddlist {
//主键
@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 scddId;
//
private String jd;
//操作时间
private Date showDate;
//负责人
private String czr;
//备注
private String remark;
//用料记录
private String yljl;
public Long getScddId() {return scddId;}
public void setScddId(Long scddId) {this.scddId = scddId;}
public String getJd() {return jd;}
public void setJd(String jd) {this.jd = jd;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getCzr() {return czr;}
public void setCzr(String czr) {this.czr = czr;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public String getYljl() {return yljl;}
public void setYljl(String yljl) {this.yljl = yljl;}
}原材料供应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_ycl")
public class Ycl {
//主键
@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 yclName;
//供应商
private String gys;
//供应日期
private Date showDate;
//库存数量
private Integer sl;
//备注
private String remark;
public String getYclName() {return yclName;}
public void setYclName(String yclName) {this.yclName = yclName;}
public String getGys() {return gys;}
public void setGys(String gys) {this.gys = gys;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
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 gh;
//
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 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 getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getJs() {return js;}
public void setJs(String js) {this.js = js;}
}实木门生产流水线管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
成品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 Integer sl;
//备注
private String remark;
public String getCpName() {return cpName;}
public void setCpName(String cpName) {this.cpName = cpName;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
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 Customer extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//公司名称
private String customerName;
//地址
private String dz;
//联系人
private String lxr;
//电话
private String phone;
//备注
private String remark;
//所属销售
private Long ygId;
public String getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getDz() {return dz;}
public void setDz(String dz) {this.dz = dz;}
public String getLxr() {return lxr;}
public void setLxr(String lxr) {this.lxr = lxr;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public Long getYgId() {return ygId;}
public void setYgId(Long ygId) {this.ygId = ygId;}
}公告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 String orderNum;
//销售
private Long ygId;
//客户
private Long customerId;
//
private String cpName;
//成交价
private Integer cjj;
//数量
private Integer sl;
//定金
private Integer dj;
//总付款
private Integer zfk;
//
private String sfjd;
//备注
private String remark;
//订单日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
//合同
private String ht;
public String getOrderNum() {return orderNum;}
public void setOrderNum(String orderNum) {this.orderNum = orderNum;}
public Long getYgId() {return ygId;}
public void setYgId(Long ygId) {this.ygId = ygId;}
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public String getCpName() {return cpName;}
public void setCpName(String cpName) {this.cpName = cpName;}
public Integer getCjj() {return cjj;}
public void setCjj(Integer cjj) {this.cjj = cjj;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
public Integer getDj() {return dj;}
public void setDj(Integer dj) {this.dj = dj;}
public Integer getZfk() {return zfk;}
public void setZfk(Integer zfk) {this.zfk = zfk;}
public String getSfjd() {return sfjd;}
public void setSfjd(String sfjd) {this.sfjd = sfjd;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
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 Ptadmin 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 ptadminName;
//电话
private String phone;
//年龄
private String age;
//
private String sex;
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 getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
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;}
}生产订单javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//生产订单
public class Scdd extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//订单编号
private String orderNum;
//员工
private Long ygId;
//
private String cpName;
//数量
private Integer sl;
//
private String status;
//备注
private String remark;
public String getOrderNum() {return orderNum;}
public void setOrderNum(String orderNum) {this.orderNum = orderNum;}
public Long getYgId() {return ygId;}
public void setYgId(Long ygId) {this.ygId = ygId;}
public String getCpName() {return cpName;}
public void setCpName(String cpName) {this.cpName = cpName;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
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 Scddlist extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//生产订单
private Long scddId;
//
private String jd;
//操作时间
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
//负责人
private String czr;
//备注
private String remark;
//用料记录
private String yljl;
public Long getScddId() {return scddId;}
public void setScddId(Long scddId) {this.scddId = scddId;}
public String getJd() {return jd;}
public void setJd(String jd) {this.jd = jd;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getCzr() {return czr;}
public void setCzr(String czr) {this.czr = czr;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public String getYljl() {return yljl;}
public void setYljl(String yljl) {this.yljl = yljl;}
}原材料供应javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//原材料供应
public class Ycl extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//
private String yclName;
//供应商
private String gys;
//供应日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
//库存数量
private Integer sl;
//备注
private String remark;
public String getYclName() {return yclName;}
public void setYclName(String yclName) {this.yclName = yclName;}
public String getGys() {return gys;}
public void setGys(String gys) {this.gys = gys;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
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 gh;
//
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 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 getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getJs() {return js;}
public void setJs(String js) {this.js = js;}
}