基于web的学生用品采购系统，javaweb毕业设计

• 基于web的学生用品采购系统mysql数据库创建语句
• 基于web的学生用品采购系统oracle数据库创建语句
• 基于web的学生用品采购系统sqlserver数据库创建语句
• 基于web的学生用品采购系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
• 基于web的学生用品采购系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计

基于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_cgs(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	cgsName varchar(100) comment '采购商名称',
	phone varchar(100) comment '电话',
	address varchar(100) comment '地址'
) comment '采购商';

采购申请表创建语句如下：

create table t_cgsq(
	id int primary key auto_increment comment '主键',
	cgsId int comment '采购商',
	cgsqName varchar(100) comment '采购信息标题',
	bs varchar(100) comment '标书',
	content varchar(100) comment '具体内容',
	status varchar(100) comment '状态',
	gysId int comment '供应商'
) comment '采购申请';

申请投标表创建语句如下：

create table t_cgsqlist(
	id int primary key auto_increment comment '主键',
	gysId int comment '供应商',
	cgsqId int comment '采购信息',
	content varchar(100) comment '说明',
	status varchar(100) comment '状态',
	bs varchar(100) comment '标书',
	insertDate datetime comment '日期'
) comment '申请投标';

供应商表创建语句如下：

create table t_gys(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	gysName varchar(100) comment '供应商名称',
	phone varchar(100) comment '电话',
	address varchar(100) comment '地址',
	cpName varchar(100) comment '产品名称',
	pic varchar(100) comment '图片',
	bj varchar(100) comment '报价',
	xy int comment '信誉评分',
	zl int comment '质量评分'
) comment '供应商';

合同表创建语句如下：

create table t_ht(
	id int primary key auto_increment comment '主键',
	cgsqId int comment '采购申请',
	gysId int comment '供应商',
	cgsId int comment '采购信息',
	htName varchar(100) comment '状态',
	content varchar(100) comment '内容修订',
	fileurl 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_cgs(
	id integer,
	username varchar(100),
	password varchar(100),
	cgsName varchar(100),
	phone varchar(100),
	address varchar(100)
);
--采购商字段加注释
comment on column t_cgs.id is '主键';
comment on column t_cgs.username is '账号';
comment on column t_cgs.password is '密码';
comment on column t_cgs.cgsName is '采购商名称';
comment on column t_cgs.phone is '电话';
comment on column t_cgs.address is '地址';
--采购商表加注释
comment on table t_cgs is '采购商';

采购申请表创建语句如下：

create table t_cgsq(
	id integer,
	cgsId int,
	cgsqName varchar(100),
	bs varchar(100),
	content varchar(100),
	status varchar(100),
	gysId int
);
--采购申请字段加注释
comment on column t_cgsq.id is '主键';
comment on column t_cgsq.cgsId is '采购商';
comment on column t_cgsq.cgsqName is '采购信息标题';
comment on column t_cgsq.bs is '标书';
comment on column t_cgsq.content is '具体内容';
comment on column t_cgsq.status is '状态';
comment on column t_cgsq.gysId is '供应商';
--采购申请表加注释
comment on table t_cgsq is '采购申请';

申请投标表创建语句如下：

create table t_cgsqlist(
	id integer,
	gysId int,
	cgsqId int,
	content varchar(100),
	status varchar(100),
	bs varchar(100),
	insertDate datetime
);
--申请投标字段加注释
comment on column t_cgsqlist.id is '主键';
comment on column t_cgsqlist.gysId is '供应商';
comment on column t_cgsqlist.cgsqId is '采购信息';
comment on column t_cgsqlist.content is '说明';
comment on column t_cgsqlist.status is '状态';
comment on column t_cgsqlist.bs is '标书';
comment on column t_cgsqlist.insertDate is '日期';
--申请投标表加注释
comment on table t_cgsqlist is '申请投标';

供应商表创建语句如下：

create table t_gys(
	id integer,
	username varchar(100),
	password varchar(100),
	gysName varchar(100),
	phone varchar(100),
	address varchar(100),
	cpName varchar(100),
	pic varchar(100),
	bj varchar(100),
	xy int,
	zl int
);
--供应商字段加注释
comment on column t_gys.id is '主键';
comment on column t_gys.username is '账号';
comment on column t_gys.password is '密码';
comment on column t_gys.gysName is '供应商名称';
comment on column t_gys.phone is '电话';
comment on column t_gys.address is '地址';
comment on column t_gys.cpName is '产品名称';
comment on column t_gys.pic is '图片';
comment on column t_gys.bj is '报价';
comment on column t_gys.xy is '信誉评分';
comment on column t_gys.zl is '质量评分';
--供应商表加注释
comment on table t_gys is '供应商';

合同表创建语句如下：

create table t_ht(
	id integer,
	cgsqId int,
	gysId int,
	cgsId int,
	htName varchar(100),
	content varchar(100),
	fileurl varchar(100),
	status varchar(100)
);
--合同字段加注释
comment on column t_ht.id is '主键';
comment on column t_ht.cgsqId is '采购申请';
comment on column t_ht.gysId is '供应商';
comment on column t_ht.cgsId is '采购信息';
comment on column t_ht.htName is '状态';
comment on column t_ht.content is '内容修订';
comment on column t_ht.fileurl is '合同';
comment on column t_ht.status is '状态';
--合同表加注释
comment on table t_ht is '合同';

oracle特有，对应序列如下：

create sequence s_t_cgs;
create sequence s_t_cgsq;
create sequence s_t_cgsqlist;
create sequence s_t_gys;
create sequence s_t_ht;

基于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_cgs(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	cgsName varchar(100),--采购商名称
	phone varchar(100),--电话
	address varchar(100)--地址
);

采购申请表创建语句如下：

--采购申请表注释
create table t_cgsq(
	id int identity(1,1) primary key not null,--主键
	cgsId int,--采购商
	cgsqName varchar(100),--采购信息标题
	bs varchar(100),--标书
	content varchar(100),--具体内容
	status varchar(100),--状态
	gysId int--供应商
);

申请投标表创建语句如下：

--申请投标表注释
create table t_cgsqlist(
	id int identity(1,1) primary key not null,--主键
	gysId int,--供应商
	cgsqId int,--采购信息
	content varchar(100),--说明
	status varchar(100),--状态
	bs varchar(100),--标书
	insertDate datetime--日期
);

供应商表创建语句如下：

--供应商表注释
create table t_gys(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	gysName varchar(100),--供应商名称
	phone varchar(100),--电话
	address varchar(100),--地址
	cpName varchar(100),--产品名称
	pic varchar(100),--图片
	bj varchar(100),--报价
	xy int,--信誉评分
	zl int--质量评分
);

合同表创建语句如下：

--合同表注释
create table t_ht(
	id int identity(1,1) primary key not null,--主键
	cgsqId int,--采购申请
	gysId int,--供应商
	cgsId int,--采购信息
	htName varchar(100),--状态
	content varchar(100),--内容修订
	fileurl varchar(100),--合同
	status varchar(100)--状态
);

基于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_cgs")
public class Cgs {
//主键
@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 cgsName;
//电话
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 getCgsName() {return cgsName;}
public void setCgsName(String cgsName) {this.cgsName = cgsName;}
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_cgsq")
public class Cgsq {
//主键
@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 cgsId;
//采购信息标题
private String cgsqName;
//标书
private String bs;
//具体内容
private String content;
//状态
private String status;
//供应商
private Integer gysId;
public Integer getCgsId() {return cgsId;}
public void setCgsId(Integer cgsId) {this.cgsId = cgsId;}
public String getCgsqName() {return cgsqName;}
public void setCgsqName(String cgsqName) {this.cgsqName = cgsqName;}
public String getBs() {return bs;}
public void setBs(String bs) {this.bs = bs;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Integer getGysId() {return gysId;}
public void setGysId(Integer gysId) {this.gysId = gysId;}
}

申请投标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_cgsqlist")
public class Cgsqlist {
//主键
@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 gysId;
//采购信息
private Integer cgsqId;
//说明
private String content;
//状态
private String status;
//标书
private String bs;
//日期
private Date insertDate;
public Integer getGysId() {return gysId;}
public void setGysId(Integer gysId) {this.gysId = gysId;}
public Integer getCgsqId() {return cgsqId;}
public void setCgsqId(Integer cgsqId) {this.cgsqId = cgsqId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBs() {return bs;}
public void setBs(String bs) {this.bs = bs;}
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_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 username;
//密码
private String password;
//供应商名称
private String gysName;
//电话
private String phone;
//地址
private String address;
//产品名称
private String cpName;
//图片
private String pic;
//报价
private String bj;
//信誉评分
private Integer xy;
//质量评分
private Integer zl;
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 getGysName() {return gysName;}
public void setGysName(String gysName) {this.gysName = gysName;}
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;}
public String getCpName() {return cpName;}
public void setCpName(String cpName) {this.cpName = cpName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getBj() {return bj;}
public void setBj(String bj) {this.bj = bj;}
public Integer getXy() {return xy;}
public void setXy(Integer xy) {this.xy = xy;}
public Integer getZl() {return zl;}
public void setZl(Integer zl) {this.zl = zl;}
}

合同javaBean创建语句如下：

package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//合同
@Table(name = "t_ht")
public class Ht {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//采购申请
private Integer cgsqId;
//供应商
private Integer gysId;
//采购信息
private Integer cgsId;
//状态
private String htName;
//内容修订
private String content;
//合同
private String fileurl;
//状态
private String status;
public Integer getCgsqId() {return cgsqId;}
public void setCgsqId(Integer cgsqId) {this.cgsqId = cgsqId;}
public Integer getGysId() {return gysId;}
public void setGysId(Integer gysId) {this.gysId = gysId;}
public Integer getCgsId() {return cgsId;}
public void setCgsId(Integer cgsId) {this.cgsId = cgsId;}
public String getHtName() {return htName;}
public void setHtName(String htName) {this.htName = htName;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getFileurl() {return fileurl;}
public void setFileurl(String fileurl) {this.fileurl = fileurl;}
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 Cgs  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 cgsName;
//电话
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 getCgsName() {return cgsName;}
public void setCgsName(String cgsName) {this.cgsName = cgsName;}
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 Cgsq  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//采购商
private Integer cgsId;
//采购信息标题
private String cgsqName;
//标书
private String bs;
//具体内容
private String content;
//状态
private String status;
//供应商
private Integer gysId;
public Integer getCgsId() {return cgsId;}
public void setCgsId(Integer cgsId) {this.cgsId = cgsId;}
public String getCgsqName() {return cgsqName;}
public void setCgsqName(String cgsqName) {this.cgsqName = cgsqName;}
public String getBs() {return bs;}
public void setBs(String bs) {this.bs = bs;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Integer getGysId() {return gysId;}
public void setGysId(Integer gysId) {this.gysId = gysId;}
}

申请投标javaBean创建语句如下：

package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//申请投标
public class Cgsqlist  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//供应商
private Integer gysId;
//采购信息
private Integer cgsqId;
//说明
private String content;
//状态
private String status;
//标书
private String bs;
//日期
private Date insertDate;
public Integer getGysId() {return gysId;}
public void setGysId(Integer gysId) {this.gysId = gysId;}
public Integer getCgsqId() {return cgsqId;}
public void setCgsqId(Integer cgsqId) {this.cgsqId = cgsqId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBs() {return bs;}
public void setBs(String bs) {this.bs = bs;}
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 Gys  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 gysName;
//电话
private String phone;
//地址
private String address;
//产品名称
private String cpName;
//图片
private String pic;
//报价
private String bj;
//信誉评分
private Integer xy;
//质量评分
private Integer zl;
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 getGysName() {return gysName;}
public void setGysName(String gysName) {this.gysName = gysName;}
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;}
public String getCpName() {return cpName;}
public void setCpName(String cpName) {this.cpName = cpName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getBj() {return bj;}
public void setBj(String bj) {this.bj = bj;}
public Integer getXy() {return xy;}
public void setXy(Integer xy) {this.xy = xy;}
public Integer getZl() {return zl;}
public void setZl(Integer zl) {this.zl = zl;}
}

合同javaBean创建语句如下：

package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//合同
public class Ht  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//采购申请
private Integer cgsqId;
//供应商
private Integer gysId;
//采购信息
private Integer cgsId;
//状态
private String htName;
//内容修订
private String content;
//合同
private String fileurl;
//状态
private String status;
public Integer getCgsqId() {return cgsqId;}
public void setCgsqId(Integer cgsqId) {this.cgsqId = cgsqId;}
public Integer getGysId() {return gysId;}
public void setGysId(Integer gysId) {this.gysId = gysId;}
public Integer getCgsId() {return cgsId;}
public void setCgsId(Integer cgsId) {this.cgsId = cgsId;}
public String getHtName() {return htName;}
public void setHtName(String htName) {this.htName = htName;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getFileurl() {return fileurl;}
public void setFileurl(String fileurl) {this.fileurl = fileurl;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}