- 基于web的网上企业材料管理信息系统mysql数据库创建语句
- 基于web的网上企业材料管理信息系统oracle数据库创建语句
- 基于web的网上企业材料管理信息系统sqlserver数据库创建语句
- 基于web的网上企业材料管理信息系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 基于web的网上企业材料管理信息系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
基于web的网上企业材料管理信息系统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_bz(
id int primary key auto_increment comment '主键',
bzName varchar(100) comment '班组号',
fzr varchar(100) comment '班组负责人',
ygs varchar(100) comment '员工数'
) comment '班组';
班组管理员表创建语句如下：
create table t_bzgly(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
bzglyName varchar(100) comment '姓名',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
phone varchar(100) comment '电话',
address varchar(100) comment '地址'
) comment '班组管理员';
班组领用表创建语句如下：
create table t_bzly(
id int primary key auto_increment comment '主键',
clId int comment '材料号',
bzId int comment '班组号',
lyh varchar(100) comment '领用号',
lyrq varchar(100) comment '领用日期',
lysl varchar(100) comment '领用数量'
) comment '班组领用';
表创建语句如下：
create table t_ck(
id int primary key auto_increment comment '主键',
cwName varchar(100) comment '仓位号',
cwdd varchar(100) comment '仓位名称',
address varchar(100) comment '地址',
fzr varchar(100) comment '负责人',
num int comment '仓库数量'
) comment '';
仓库管理员表创建语句如下：
create table t_ckgly(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
ckglyName varchar(100) comment '姓名',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
phone varchar(100) comment '电话',
address varchar(100) comment '地址'
) comment '仓库管理员';
材料表创建语句如下：
create table t_cl(
id int primary key auto_increment comment '主键',
clName varchar(100) comment '材料号',
cldd varchar(100) comment '材料名称',
lx varchar(100) comment '类型',
tj varchar(100) comment '体积'
) comment '材料';
仓位表创建语句如下：
create table t_cw(
id int primary key auto_increment comment '主键',
clId int comment '材料号',
ckId int comment '仓位号',
sl int comment '入库数量'
) comment '仓位';
技术员表创建语句如下：
create table t_jsy(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
jsyName varchar(100) comment '姓名',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
phone varchar(100) comment '电话',
address varchar(100) comment '地址'
) comment '技术员';
项目表创建语句如下：
create table t_xm(
id int primary key auto_increment comment '主键',
xmName varchar(100) comment '项目号',
xmdd varchar(100) comment '项目名称',
fzr varchar(100) comment '负责人'
) comment '项目';
项目管理员表创建语句如下：
create table t_xmgly(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
xmglyName varchar(100) comment '姓名',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
phone varchar(100) comment '电话',
address varchar(100) comment '地址'
) comment '项目管理员';
项目申购表创建语句如下：
create table t_xmsg(
id int primary key auto_increment comment '主键',
clId int comment '材料号',
xmId int comment '项目号',
sgh varchar(100) comment '申购号',
sgrq varchar(100) comment '申购日期',
sgsl varchar(100) comment '申购数量',
status varchar(100) comment '状态'
) comment '项目申购';
基于web的网上企业材料管理信息系统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_bz(
id integer,
bzName varchar(100),
fzr varchar(100),
ygs varchar(100)
);
--班组字段加注释
comment on column t_bz.id is '主键';
comment on column t_bz.bzName is '班组号';
comment on column t_bz.fzr is '班组负责人';
comment on column t_bz.ygs is '员工数';
--班组表加注释
comment on table t_bz is '班组';
班组管理员表创建语句如下：
create table t_bzgly(
id integer,
username varchar(100),
password varchar(100),
bzglyName varchar(100),
age varchar(100),
sex varchar(100),
phone varchar(100),
address varchar(100)
);
--班组管理员字段加注释
comment on column t_bzgly.id is '主键';
comment on column t_bzgly.username is '账号';
comment on column t_bzgly.password is '密码';
comment on column t_bzgly.bzglyName is '姓名';
comment on column t_bzgly.age is '年龄';
comment on column t_bzgly.sex is '性别';
comment on column t_bzgly.phone is '电话';
comment on column t_bzgly.address is '地址';
--班组管理员表加注释
comment on table t_bzgly is '班组管理员';
班组领用表创建语句如下：
create table t_bzly(
id integer,
clId int,
bzId int,
lyh varchar(100),
lyrq varchar(100),
lysl varchar(100)
);
--班组领用字段加注释
comment on column t_bzly.id is '主键';
comment on column t_bzly.clId is '材料号';
comment on column t_bzly.bzId is '班组号';
comment on column t_bzly.lyh is '领用号';
comment on column t_bzly.lyrq is '领用日期';
comment on column t_bzly.lysl is '领用数量';
--班组领用表加注释
comment on table t_bzly is '班组领用';
表创建语句如下：
create table t_ck(
id integer,
cwName varchar(100),
cwdd varchar(100),
address varchar(100),
fzr varchar(100),
num int
);
--字段加注释
comment on column t_ck.id is '主键';
comment on column t_ck.cwName is '仓位号';
comment on column t_ck.cwdd is '仓位名称';
comment on column t_ck.address is '地址';
comment on column t_ck.fzr is '负责人';
comment on column t_ck.num is '仓库数量';
--表加注释
comment on table t_ck is '';
仓库管理员表创建语句如下：
create table t_ckgly(
id integer,
username varchar(100),
password varchar(100),
ckglyName varchar(100),
age varchar(100),
sex varchar(100),
phone varchar(100),
address varchar(100)
);
--仓库管理员字段加注释
comment on column t_ckgly.id is '主键';
comment on column t_ckgly.username is '账号';
comment on column t_ckgly.password is '密码';
comment on column t_ckgly.ckglyName is '姓名';
comment on column t_ckgly.age is '年龄';
comment on column t_ckgly.sex is '性别';
comment on column t_ckgly.phone is '电话';
comment on column t_ckgly.address is '地址';
--仓库管理员表加注释
comment on table t_ckgly is '仓库管理员';
材料表创建语句如下：
create table t_cl(
id integer,
clName varchar(100),
cldd varchar(100),
lx varchar(100),
tj varchar(100)
);
--材料字段加注释
comment on column t_cl.id is '主键';
comment on column t_cl.clName is '材料号';
comment on column t_cl.cldd is '材料名称';
comment on column t_cl.lx is '类型';
comment on column t_cl.tj is '体积';
--材料表加注释
comment on table t_cl is '材料';
仓位表创建语句如下：
create table t_cw(
id integer,
clId int,
ckId int,
sl int
);
--仓位字段加注释
comment on column t_cw.id is '主键';
comment on column t_cw.clId is '材料号';
comment on column t_cw.ckId is '仓位号';
comment on column t_cw.sl is '入库数量';
--仓位表加注释
comment on table t_cw is '仓位';
技术员表创建语句如下：
create table t_jsy(
id integer,
username varchar(100),
password varchar(100),
jsyName varchar(100),
age varchar(100),
sex varchar(100),
phone varchar(100),
address varchar(100)
);
--技术员字段加注释
comment on column t_jsy.id is '主键';
comment on column t_jsy.username is '账号';
comment on column t_jsy.password is '密码';
comment on column t_jsy.jsyName is '姓名';
comment on column t_jsy.age is '年龄';
comment on column t_jsy.sex is '性别';
comment on column t_jsy.phone is '电话';
comment on column t_jsy.address is '地址';
--技术员表加注释
comment on table t_jsy is '技术员';
项目表创建语句如下：
create table t_xm(
id integer,
xmName varchar(100),
xmdd varchar(100),
fzr varchar(100)
);
--项目字段加注释
comment on column t_xm.id is '主键';
comment on column t_xm.xmName is '项目号';
comment on column t_xm.xmdd is '项目名称';
comment on column t_xm.fzr is '负责人';
--项目表加注释
comment on table t_xm is '项目';
项目管理员表创建语句如下：
create table t_xmgly(
id integer,
username varchar(100),
password varchar(100),
xmglyName varchar(100),
age varchar(100),
sex varchar(100),
phone varchar(100),
address varchar(100)
);
--项目管理员字段加注释
comment on column t_xmgly.id is '主键';
comment on column t_xmgly.username is '账号';
comment on column t_xmgly.password is '密码';
comment on column t_xmgly.xmglyName is '姓名';
comment on column t_xmgly.age is '年龄';
comment on column t_xmgly.sex is '性别';
comment on column t_xmgly.phone is '电话';
comment on column t_xmgly.address is '地址';
--项目管理员表加注释
comment on table t_xmgly is '项目管理员';
项目申购表创建语句如下：
create table t_xmsg(
id integer,
clId int,
xmId int,
sgh varchar(100),
sgrq varchar(100),
sgsl varchar(100),
status varchar(100)
);
--项目申购字段加注释
comment on column t_xmsg.id is '主键';
comment on column t_xmsg.clId is '材料号';
comment on column t_xmsg.xmId is '项目号';
comment on column t_xmsg.sgh is '申购号';
comment on column t_xmsg.sgrq is '申购日期';
comment on column t_xmsg.sgsl is '申购数量';
comment on column t_xmsg.status is '状态';
--项目申购表加注释
comment on table t_xmsg is '项目申购';
oracle特有，对应序列如下：
create sequence s_t_bz;
create sequence s_t_bzgly;
create sequence s_t_bzly;
create sequence s_t_ck;
create sequence s_t_ckgly;
create sequence s_t_cl;
create sequence s_t_cw;
create sequence s_t_jsy;
create sequence s_t_xm;
create sequence s_t_xmgly;
create sequence s_t_xmsg;
基于web的网上企业材料管理信息系统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_bz(
id int identity(1,1) primary key not null,--主键
bzName varchar(100),--班组号
fzr varchar(100),--班组负责人
ygs varchar(100)--员工数
);
班组管理员表创建语句如下：
--班组管理员表注释
create table t_bzgly(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
bzglyName varchar(100),--姓名
age varchar(100),--年龄
sex varchar(100),--性别
phone varchar(100),--电话
address varchar(100)--地址
);
班组领用表创建语句如下：
--班组领用表注释
create table t_bzly(
id int identity(1,1) primary key not null,--主键
clId int,--材料号
bzId int,--班组号
lyh varchar(100),--领用号
lyrq varchar(100),--领用日期
lysl varchar(100)--领用数量
);
表创建语句如下：
--表注释
create table t_ck(
id int identity(1,1) primary key not null,--主键
cwName varchar(100),--仓位号
cwdd varchar(100),--仓位名称
address varchar(100),--地址
fzr varchar(100),--负责人
num int--仓库数量
);
仓库管理员表创建语句如下：
--仓库管理员表注释
create table t_ckgly(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
ckglyName varchar(100),--姓名
age varchar(100),--年龄
sex varchar(100),--性别
phone varchar(100),--电话
address varchar(100)--地址
);
材料表创建语句如下：
--材料表注释
create table t_cl(
id int identity(1,1) primary key not null,--主键
clName varchar(100),--材料号
cldd varchar(100),--材料名称
lx varchar(100),--类型
tj varchar(100)--体积
);
仓位表创建语句如下：
--仓位表注释
create table t_cw(
id int identity(1,1) primary key not null,--主键
clId int,--材料号
ckId int,--仓位号
sl int--入库数量
);
技术员表创建语句如下：
--技术员表注释
create table t_jsy(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
jsyName varchar(100),--姓名
age varchar(100),--年龄
sex varchar(100),--性别
phone varchar(100),--电话
address varchar(100)--地址
);
项目表创建语句如下：
--项目表注释
create table t_xm(
id int identity(1,1) primary key not null,--主键
xmName varchar(100),--项目号
xmdd varchar(100),--项目名称
fzr varchar(100)--负责人
);
项目管理员表创建语句如下：
--项目管理员表注释
create table t_xmgly(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
xmglyName varchar(100),--姓名
age varchar(100),--年龄
sex varchar(100),--性别
phone varchar(100),--电话
address varchar(100)--地址
);
项目申购表创建语句如下：
--项目申购表注释
create table t_xmsg(
id int identity(1,1) primary key not null,--主键
clId int,--材料号
xmId int,--项目号
sgh varchar(100),--申购号
sgrq varchar(100),--申购日期
sgsl varchar(100),--申购数量
status varchar(100)--状态
);
登录后主页.jpg?x-oss-process=style/00001)
基于web的网上企业材料管理信息系统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_bz")
public class Bz {
//主键
@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 bzName;
//班组负责人
private String fzr;
//员工数
private String ygs;
public String getBzName() {return bzName;}
public void setBzName(String bzName) {this.bzName = bzName;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public String getYgs() {return ygs;}
public void setYgs(String ygs) {this.ygs = ygs;}
}班组管理员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_bzgly")
public class Bzgly {
//主键
@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 bzglyName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//地址
private String address;
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 getBzglyName() {return bzglyName;}
public void setBzglyName(String bzglyName) {this.bzglyName = bzglyName;}
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
}班组领用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_bzly")
public class Bzly {
//主键
@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 clId;
//班组号
private Integer bzId;
//领用号
private String lyh;
//领用日期
private String lyrq;
//领用数量
private String lysl;
public Integer getClId() {return clId;}
public void setClId(Integer clId) {this.clId = clId;}
public Integer getBzId() {return bzId;}
public void setBzId(Integer bzId) {this.bzId = bzId;}
public String getLyh() {return lyh;}
public void setLyh(String lyh) {this.lyh = lyh;}
public String getLyrq() {return lyrq;}
public void setLyrq(String lyrq) {this.lyrq = lyrq;}
public String getLysl() {return lysl;}
public void setLysl(String lysl) {this.lysl = lysl;}
}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 String cwName;
//仓位名称
private String cwdd;
//地址
private String address;
//负责人
private String fzr;
//仓库数量
private Integer num;
public String getCwName() {return cwName;}
public void setCwName(String cwName) {this.cwName = cwName;}
public String getCwdd() {return cwdd;}
public void setCwdd(String cwdd) {this.cwdd = cwdd;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
}仓库管理员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_ckgly")
public class Ckgly {
//主键
@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 ckglyName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//地址
private String address;
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 getCkglyName() {return ckglyName;}
public void setCkglyName(String ckglyName) {this.ckglyName = ckglyName;}
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
}材料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_cl")
public class Cl {
//主键
@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 clName;
//材料名称
private String cldd;
//类型
private String lx;
//体积
private String tj;
public String getClName() {return clName;}
public void setClName(String clName) {this.clName = clName;}
public String getCldd() {return cldd;}
public void setCldd(String cldd) {this.cldd = cldd;}
public String getLx() {return lx;}
public void setLx(String lx) {this.lx = lx;}
public String getTj() {return tj;}
public void setTj(String tj) {this.tj = tj;}
}仓位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 clId;
//仓位号
private Integer ckId;
//入库数量
private Integer sl;
public Integer getClId() {return clId;}
public void setClId(Integer clId) {this.clId = clId;}
public Integer getCkId() {return ckId;}
public void setCkId(Integer ckId) {this.ckId = ckId;}
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_jsy")
public class Jsy {
//主键
@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 jsyName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//地址
private String address;
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 getJsyName() {return jsyName;}
public void setJsyName(String jsyName) {this.jsyName = jsyName;}
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
}项目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_xm")
public class Xm {
//主键
@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 xmName;
//项目名称
private String xmdd;
//负责人
private String fzr;
public String getXmName() {return xmName;}
public void setXmName(String xmName) {this.xmName = xmName;}
public String getXmdd() {return xmdd;}
public void setXmdd(String xmdd) {this.xmdd = xmdd;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
}项目管理员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_xmgly")
public class Xmgly {
//主键
@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 xmglyName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//地址
private String address;
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 getXmglyName() {return xmglyName;}
public void setXmglyName(String xmglyName) {this.xmglyName = xmglyName;}
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
}项目申购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_xmsg")
public class Xmsg {
//主键
@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 clId;
//项目号
private Integer xmId;
//申购号
private String sgh;
//申购日期
private String sgrq;
//申购数量
private String sgsl;
//状态
private String status;
public Integer getClId() {return clId;}
public void setClId(Integer clId) {this.clId = clId;}
public Integer getXmId() {return xmId;}
public void setXmId(Integer xmId) {this.xmId = xmId;}
public String getSgh() {return sgh;}
public void setSgh(String sgh) {this.sgh = sgh;}
public String getSgrq() {return sgrq;}
public void setSgrq(String sgrq) {this.sgrq = sgrq;}
public String getSgsl() {return sgsl;}
public void setSgsl(String sgsl) {this.sgsl = sgsl;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}基于web的网上企业材料管理信息系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
班组javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//班组
public class Bz extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//班组号
private String bzName;
//班组负责人
private String fzr;
//员工数
private String ygs;
public String getBzName() {return bzName;}
public void setBzName(String bzName) {this.bzName = bzName;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public String getYgs() {return ygs;}
public void setYgs(String ygs) {this.ygs = ygs;}
}班组管理员javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//班组管理员
public class Bzgly 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 bzglyName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//地址
private String address;
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 getBzglyName() {return bzglyName;}
public void setBzglyName(String bzglyName) {this.bzglyName = bzglyName;}
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
}班组领用javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//班组领用
public class Bzly extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//材料号
private Integer clId;
//班组号
private Integer bzId;
//领用号
private String lyh;
//领用日期
private String lyrq;
//领用数量
private String lysl;
public Integer getClId() {return clId;}
public void setClId(Integer clId) {this.clId = clId;}
public Integer getBzId() {return bzId;}
public void setBzId(Integer bzId) {this.bzId = bzId;}
public String getLyh() {return lyh;}
public void setLyh(String lyh) {this.lyh = lyh;}
public String getLyrq() {return lyrq;}
public void setLyrq(String lyrq) {this.lyrq = lyrq;}
public String getLysl() {return lysl;}
public void setLysl(String lysl) {this.lysl = lysl;}
}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 String cwName;
//仓位名称
private String cwdd;
//地址
private String address;
//负责人
private String fzr;
//仓库数量
private Integer num;
public String getCwName() {return cwName;}
public void setCwName(String cwName) {this.cwName = cwName;}
public String getCwdd() {return cwdd;}
public void setCwdd(String cwdd) {this.cwdd = cwdd;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
}仓库管理员javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//仓库管理员
public class Ckgly 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 ckglyName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//地址
private String address;
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 getCkglyName() {return ckglyName;}
public void setCkglyName(String ckglyName) {this.ckglyName = ckglyName;}
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
}材料javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//材料
public class Cl extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//材料号
private String clName;
//材料名称
private String cldd;
//类型
private String lx;
//体积
private String tj;
public String getClName() {return clName;}
public void setClName(String clName) {this.clName = clName;}
public String getCldd() {return cldd;}
public void setCldd(String cldd) {this.cldd = cldd;}
public String getLx() {return lx;}
public void setLx(String lx) {this.lx = lx;}
public String getTj() {return tj;}
public void setTj(String tj) {this.tj = tj;}
}仓位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 clId;
//仓位号
private Integer ckId;
//入库数量
private Integer sl;
public Integer getClId() {return clId;}
public void setClId(Integer clId) {this.clId = clId;}
public Integer getCkId() {return ckId;}
public void setCkId(Integer ckId) {this.ckId = ckId;}
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 Jsy 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 jsyName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//地址
private String address;
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 getJsyName() {return jsyName;}
public void setJsyName(String jsyName) {this.jsyName = jsyName;}
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
}项目javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//项目
public class Xm extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//项目号
private String xmName;
//项目名称
private String xmdd;
//负责人
private String fzr;
public String getXmName() {return xmName;}
public void setXmName(String xmName) {this.xmName = xmName;}
public String getXmdd() {return xmdd;}
public void setXmdd(String xmdd) {this.xmdd = xmdd;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
}项目管理员javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//项目管理员
public class Xmgly 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 xmglyName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//地址
private String address;
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 getXmglyName() {return xmglyName;}
public void setXmglyName(String xmglyName) {this.xmglyName = xmglyName;}
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
}项目申购javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//项目申购
public class Xmsg extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//材料号
private Integer clId;
//项目号
private Integer xmId;
//申购号
private String sgh;
//申购日期
private String sgrq;
//申购数量
private String sgsl;
//状态
private String status;
public Integer getClId() {return clId;}
public void setClId(Integer clId) {this.clId = clId;}
public Integer getXmId() {return xmId;}
public void setXmId(Integer xmId) {this.xmId = xmId;}
public String getSgh() {return sgh;}
public void setSgh(String sgh) {this.sgh = sgh;}
public String getSgrq() {return sgrq;}
public void setSgrq(String sgrq) {this.sgrq = sgrq;}
public String getSgsl() {return sgsl;}
public void setSgsl(String sgsl) {this.sgsl = sgsl;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}