百色学院教育类项目管理系统(xaa28)_mysql

百色学院教育类项目管理系统mysql数据库创建语句
百色学院教育类项目管理系统oracle数据库创建语句
百色学院教育类项目管理系统sqlserver数据库创建语句
百色学院教育类项目管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
百色学院教育类项目管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计

百色学院教育类项目管理系统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_customer(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	customerName varchar(100) comment '姓名',
	phone varchar(100) comment '电话',
	sex varchar(100) comment '',
	zw varchar(100) comment '职务',
	zc varchar(100) comment '职称',
	xl varchar(100) comment '学历',
	xw varchar(100) comment '学位',
	xx varchar(100) comment '学校',
	yx varchar(100) comment '邮箱',
	address varchar(100) comment '通讯地址'
) comment '项目申报人';

评审专家表创建语句如下：


create table t_pszj(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	pszjName varchar(100) comment '姓名',
	phone varchar(100) comment '电话',
	sex varchar(100) comment '',
	zw varchar(100) comment '职务',
	zc varchar(100) comment '职称',
	xl varchar(100) comment '学历',
	xw varchar(100) comment '学位',
	xx varchar(100) comment '学校',
	yx varchar(100) comment '邮箱',
	address varchar(100) comment '通讯地址'
) comment '评审专家';

通知公告表创建语句如下：


create table t_tongzhi(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '标题',
	content text comment '内容',
	insertDate datetime comment '日期'
) comment '通知公告';

项目申报表创建语句如下：


create table t_xmsb(
	id int primary key auto_increment comment '主键',
	customerId int comment '申报人',
	sbnd varchar(100) comment '申报年度',
	xmlx varchar(100) comment '',
	cl varchar(100) comment '材料',
	status varchar(100) comment '状态',
	yxadminName varchar(100) comment '院系审核人',
	pszjId1 int comment '专家1',
	v1 text comment '专家1评语',
	codes1 int comment '专家1打分',
	psszId2 int comment '专家2',
	v2 text comment '专家2评语',
	codes2 int comment '专家2打分',
	psszId3 int comment '专家3',
	v3 text comment '专家3评语',
	codes3 int comment '专家3打分',
	zq varchar(100) comment '中期检查附件',
	jt varchar(100) comment '结题检查附件'
) comment '项目申报';

院系管理员表创建语句如下：


create table t_yxadmin(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	yxadminName varchar(100) comment '姓名',
	phone varchar(100) comment '电话',
	sex varchar(100) comment '',
	zw varchar(100) comment '职务',
	zc varchar(100) comment '职称',
	xl varchar(100) comment '学历',
	xw varchar(100) comment '学位',
	xx varchar(100) comment '学校',
	yx varchar(100) comment '邮箱',
	address 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_customer(
	id integer,
	username varchar(100),
	password varchar(100),
	customerName varchar(100),
	phone varchar(100),
	sex varchar(100),
	zw varchar(100),
	zc varchar(100),
	xl varchar(100),
	xw varchar(100),
	xx varchar(100),
	yx varchar(100),
	address varchar(100)
);
--项目申报人字段加注释
comment on column t_customer.id is '主键';
comment on column t_customer.username is '账号';
comment on column t_customer.password is '密码';
comment on column t_customer.customerName is '姓名';
comment on column t_customer.phone is '电话';
comment on column t_customer.sex is '';
comment on column t_customer.zw is '职务';
comment on column t_customer.zc is '职称';
comment on column t_customer.xl is '学历';
comment on column t_customer.xw is '学位';
comment on column t_customer.xx is '学校';
comment on column t_customer.yx is '邮箱';
comment on column t_customer.address is '通讯地址';
--项目申报人表加注释
comment on table t_customer is '项目申报人';

评审专家表创建语句如下：


create table t_pszj(
	id integer,
	username varchar(100),
	password varchar(100),
	pszjName varchar(100),
	phone varchar(100),
	sex varchar(100),
	zw varchar(100),
	zc varchar(100),
	xl varchar(100),
	xw varchar(100),
	xx varchar(100),
	yx varchar(100),
	address varchar(100)
);
--评审专家字段加注释
comment on column t_pszj.id is '主键';
comment on column t_pszj.username is '账号';
comment on column t_pszj.password is '密码';
comment on column t_pszj.pszjName is '姓名';
comment on column t_pszj.phone is '电话';
comment on column t_pszj.sex is '';
comment on column t_pszj.zw is '职务';
comment on column t_pszj.zc is '职称';
comment on column t_pszj.xl is '学历';
comment on column t_pszj.xw is '学位';
comment on column t_pszj.xx is '学校';
comment on column t_pszj.yx is '邮箱';
comment on column t_pszj.address is '通讯地址';
--评审专家表加注释
comment on table t_pszj is '评审专家';

通知公告表创建语句如下：


create table t_tongzhi(
	id integer,
	title varchar(100),
	content text,
	insertDate datetime
);
--通知公告字段加注释
comment on column t_tongzhi.id is '主键';
comment on column t_tongzhi.title is '标题';
comment on column t_tongzhi.content is '内容';
comment on column t_tongzhi.insertDate is '日期';
--通知公告表加注释
comment on table t_tongzhi is '通知公告';

项目申报表创建语句如下：


create table t_xmsb(
	id integer,
	customerId int,
	sbnd varchar(100),
	xmlx varchar(100),
	cl varchar(100),
	status varchar(100),
	yxadminName varchar(100),
	pszjId1 int,
	v1 text,
	codes1 int,
	psszId2 int,
	v2 text,
	codes2 int,
	psszId3 int,
	v3 text,
	codes3 int,
	zq varchar(100),
	jt varchar(100)
);
--项目申报字段加注释
comment on column t_xmsb.id is '主键';
comment on column t_xmsb.customerId is '申报人';
comment on column t_xmsb.sbnd is '申报年度';
comment on column t_xmsb.xmlx is '';
comment on column t_xmsb.cl is '材料';
comment on column t_xmsb.status is '状态';
comment on column t_xmsb.yxadminName is '院系审核人';
comment on column t_xmsb.pszjId1 is '专家1';
comment on column t_xmsb.v1 is '专家1评语';
comment on column t_xmsb.codes1 is '专家1打分';
comment on column t_xmsb.psszId2 is '专家2';
comment on column t_xmsb.v2 is '专家2评语';
comment on column t_xmsb.codes2 is '专家2打分';
comment on column t_xmsb.psszId3 is '专家3';
comment on column t_xmsb.v3 is '专家3评语';
comment on column t_xmsb.codes3 is '专家3打分';
comment on column t_xmsb.zq is '中期检查附件';
comment on column t_xmsb.jt is '结题检查附件';
--项目申报表加注释
comment on table t_xmsb is '项目申报';

院系管理员表创建语句如下：


create table t_yxadmin(
	id integer,
	username varchar(100),
	password varchar(100),
	yxadminName varchar(100),
	phone varchar(100),
	sex varchar(100),
	zw varchar(100),
	zc varchar(100),
	xl varchar(100),
	xw varchar(100),
	xx varchar(100),
	yx varchar(100),
	address varchar(100)
);
--院系管理员字段加注释
comment on column t_yxadmin.id is '主键';
comment on column t_yxadmin.username is '账号';
comment on column t_yxadmin.password is '密码';
comment on column t_yxadmin.yxadminName is '姓名';
comment on column t_yxadmin.phone is '电话';
comment on column t_yxadmin.sex is '';
comment on column t_yxadmin.zw is '职务';
comment on column t_yxadmin.zc is '职称';
comment on column t_yxadmin.xl is '学历';
comment on column t_yxadmin.xw is '学位';
comment on column t_yxadmin.xx is '学校';
comment on column t_yxadmin.yx is '邮箱';
comment on column t_yxadmin.address is '通讯地址';
--院系管理员表加注释
comment on table t_yxadmin is '院系管理员';

oracle特有，对应序列如下：


create sequence s_t_customer;
create sequence s_t_pszj;
create sequence s_t_tongzhi;
create sequence s_t_xmsb;
create sequence s_t_yxadmin;

百色学院教育类项目管理系统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_customer(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	customerName varchar(100),--姓名
	phone varchar(100),--电话
	sex varchar(100),--
	zw varchar(100),--职务
	zc varchar(100),--职称
	xl varchar(100),--学历
	xw varchar(100),--学位
	xx varchar(100),--学校
	yx varchar(100),--邮箱
	address varchar(100)--通讯地址
);

评审专家表创建语句如下：


--评审专家表注释
create table t_pszj(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	pszjName varchar(100),--姓名
	phone varchar(100),--电话
	sex varchar(100),--
	zw varchar(100),--职务
	zc varchar(100),--职称
	xl varchar(100),--学历
	xw varchar(100),--学位
	xx varchar(100),--学校
	yx varchar(100),--邮箱
	address varchar(100)--通讯地址
);

通知公告表创建语句如下：


--通知公告表注释
create table t_tongzhi(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--标题
	content text,--内容
	insertDate datetime--日期
);

项目申报表创建语句如下：


--项目申报表注释
create table t_xmsb(
	id int identity(1,1) primary key not null,--主键
	customerId int,--申报人
	sbnd varchar(100),--申报年度
	xmlx varchar(100),--
	cl varchar(100),--材料
	status varchar(100),--状态
	yxadminName varchar(100),--院系审核人
	pszjId1 int,--专家1
	v1 text,--专家1评语
	codes1 int,--专家1打分
	psszId2 int,--专家2
	v2 text,--专家2评语
	codes2 int,--专家2打分
	psszId3 int,--专家3
	v3 text,--专家3评语
	codes3 int,--专家3打分
	zq varchar(100),--中期检查附件
	jt varchar(100)--结题检查附件
);

院系管理员表创建语句如下：


--院系管理员表注释
create table t_yxadmin(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	yxadminName varchar(100),--姓名
	phone varchar(100),--电话
	sex varchar(100),--
	zw varchar(100),--职务
	zc varchar(100),--职称
	xl varchar(100),--学历
	xw varchar(100),--学位
	xx varchar(100),--学校
	yx varchar(100),--邮箱
	address varchar(100)--通讯地址
);

百色学院教育类项目管理系统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_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 username;
//密码
private String password;
//姓名
private String customerName;
//电话
private String phone;
//
private String sex;
//职务
private String zw;
//职称
private String zc;
//学历
private String xl;
//学位
private String xw;
//学校
private String xx;
//邮箱
private String yx;
//通讯地址
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 getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
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 getZc() {return zc;}
public void setZc(String zc) {this.zc = zc;}
public String getXl() {return xl;}
public void setXl(String xl) {this.xl = xl;}
public String getXw() {return xw;}
public void setXw(String xw) {this.xw = xw;}
public String getXx() {return xx;}
public void setXx(String xx) {this.xx = xx;}
public String getYx() {return yx;}
public void setYx(String yx) {this.yx = yx;}
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_pszj")
public class Pszj {
//主键
@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 pszjName;
//电话
private String phone;
//
private String sex;
//职务
private String zw;
//职称
private String zc;
//学历
private String xl;
//学位
private String xw;
//学校
private String xx;
//邮箱
private String yx;
//通讯地址
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 getPszjName() {return pszjName;}
public void setPszjName(String pszjName) {this.pszjName = pszjName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
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 getZc() {return zc;}
public void setZc(String zc) {this.zc = zc;}
public String getXl() {return xl;}
public void setXl(String xl) {this.xl = xl;}
public String getXw() {return xw;}
public void setXw(String xw) {this.xw = xw;}
public String getXx() {return xx;}
public void setXx(String xx) {this.xx = xx;}
public String getYx() {return yx;}
public void setYx(String yx) {this.yx = yx;}
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_tongzhi")
public class Tongzhi {
//主键
@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_xmsb")
public class Xmsb {
//主键
@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 customerId;
//申报年度
private String sbnd;
//
private String xmlx;
//材料
private String cl;
//状态
private String status;
//院系审核人
private String yxadminName;
//专家1
private Long pszjId1;
//专家1评语
private String v1;
//专家1打分
private Integer codes1;
//专家2
private Long psszId2;
//专家2评语
private String v2;
//专家2打分
private Integer codes2;
//专家3
private Long psszId3;
//专家3评语
private String v3;
//专家3打分
private Integer codes3;
//中期检查附件
private String zq;
//结题检查附件
private String jt;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public String getSbnd() {return sbnd;}
public void setSbnd(String sbnd) {this.sbnd = sbnd;}
public String getXmlx() {return xmlx;}
public void setXmlx(String xmlx) {this.xmlx = xmlx;}
public String getCl() {return cl;}
public void setCl(String cl) {this.cl = cl;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getYxadminName() {return yxadminName;}
public void setYxadminName(String yxadminName) {this.yxadminName = yxadminName;}
public Long getPszjId1() {return pszjId1;}
public void setPszjId1(Long pszjId1) {this.pszjId1 = pszjId1;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public Integer getCodes1() {return codes1;}
public void setCodes1(Integer codes1) {this.codes1 = codes1;}
public Long getPsszId2() {return psszId2;}
public void setPsszId2(Long psszId2) {this.psszId2 = psszId2;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public Integer getCodes2() {return codes2;}
public void setCodes2(Integer codes2) {this.codes2 = codes2;}
public Long getPsszId3() {return psszId3;}
public void setPsszId3(Long psszId3) {this.psszId3 = psszId3;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public Integer getCodes3() {return codes3;}
public void setCodes3(Integer codes3) {this.codes3 = codes3;}
public String getZq() {return zq;}
public void setZq(String zq) {this.zq = zq;}
public String getJt() {return jt;}
public void setJt(String jt) {this.jt = jt;}
}

院系管理员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_yxadmin")
public class Yxadmin {
//主键
@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 yxadminName;
//电话
private String phone;
//
private String sex;
//职务
private String zw;
//职称
private String zc;
//学历
private String xl;
//学位
private String xw;
//学校
private String xx;
//邮箱
private String yx;
//通讯地址
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 getYxadminName() {return yxadminName;}
public void setYxadminName(String yxadminName) {this.yxadminName = yxadminName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
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 getZc() {return zc;}
public void setZc(String zc) {this.zc = zc;}
public String getXl() {return xl;}
public void setXl(String xl) {this.xl = xl;}
public String getXw() {return xw;}
public void setXw(String xw) {this.xw = xw;}
public String getXx() {return xx;}
public void setXx(String xx) {this.xx = xx;}
public String getYx() {return yx;}
public void setYx(String yx) {this.yx = yx;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
}

百色学院教育类项目管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：

项目申报人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 username;
//密码
private String password;
//姓名
private String customerName;
//电话
private String phone;
//
private String sex;
//职务
private String zw;
//职称
private String zc;
//学历
private String xl;
//学位
private String xw;
//学校
private String xx;
//邮箱
private String yx;
//通讯地址
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 getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
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 getZc() {return zc;}
public void setZc(String zc) {this.zc = zc;}
public String getXl() {return xl;}
public void setXl(String xl) {this.xl = xl;}
public String getXw() {return xw;}
public void setXw(String xw) {this.xw = xw;}
public String getXx() {return xx;}
public void setXx(String xx) {this.xx = xx;}
public String getYx() {return yx;}
public void setYx(String yx) {this.yx = yx;}
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 Pszj  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 pszjName;
//电话
private String phone;
//
private String sex;
//职务
private String zw;
//职称
private String zc;
//学历
private String xl;
//学位
private String xw;
//学校
private String xx;
//邮箱
private String yx;
//通讯地址
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 getPszjName() {return pszjName;}
public void setPszjName(String pszjName) {this.pszjName = pszjName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
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 getZc() {return zc;}
public void setZc(String zc) {this.zc = zc;}
public String getXl() {return xl;}
public void setXl(String xl) {this.xl = xl;}
public String getXw() {return xw;}
public void setXw(String xw) {this.xw = xw;}
public String getXx() {return xx;}
public void setXx(String xx) {this.xx = xx;}
public String getYx() {return yx;}
public void setYx(String yx) {this.yx = yx;}
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 Tongzhi  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 Xmsb  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//申报人
private Long customerId;
//申报年度
private String sbnd;
//
private String xmlx;
//材料
private String cl;
//状态
private String status;
//院系审核人
private String yxadminName;
//专家1
private Long pszjId1;
//专家1评语
private String v1;
//专家1打分
private Integer codes1;
//专家2
private Long psszId2;
//专家2评语
private String v2;
//专家2打分
private Integer codes2;
//专家3
private Long psszId3;
//专家3评语
private String v3;
//专家3打分
private Integer codes3;
//中期检查附件
private String zq;
//结题检查附件
private String jt;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public String getSbnd() {return sbnd;}
public void setSbnd(String sbnd) {this.sbnd = sbnd;}
public String getXmlx() {return xmlx;}
public void setXmlx(String xmlx) {this.xmlx = xmlx;}
public String getCl() {return cl;}
public void setCl(String cl) {this.cl = cl;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getYxadminName() {return yxadminName;}
public void setYxadminName(String yxadminName) {this.yxadminName = yxadminName;}
public Long getPszjId1() {return pszjId1;}
public void setPszjId1(Long pszjId1) {this.pszjId1 = pszjId1;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public Integer getCodes1() {return codes1;}
public void setCodes1(Integer codes1) {this.codes1 = codes1;}
public Long getPsszId2() {return psszId2;}
public void setPsszId2(Long psszId2) {this.psszId2 = psszId2;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public Integer getCodes2() {return codes2;}
public void setCodes2(Integer codes2) {this.codes2 = codes2;}
public Long getPsszId3() {return psszId3;}
public void setPsszId3(Long psszId3) {this.psszId3 = psszId3;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public Integer getCodes3() {return codes3;}
public void setCodes3(Integer codes3) {this.codes3 = codes3;}
public String getZq() {return zq;}
public void setZq(String zq) {this.zq = zq;}
public String getJt() {return jt;}
public void setJt(String jt) {this.jt = jt;}
}

院系管理员javaBean创建语句如下：


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

//院系管理员
public class Yxadmin  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 yxadminName;
//电话
private String phone;
//
private String sex;
//职务
private String zw;
//职称
private String zc;
//学历
private String xl;
//学位
private String xw;
//学校
private String xx;
//邮箱
private String yx;
//通讯地址
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 getYxadminName() {return yxadminName;}
public void setYxadminName(String yxadminName) {this.yxadminName = yxadminName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
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 getZc() {return zc;}
public void setZc(String zc) {this.zc = zc;}
public String getXl() {return xl;}
public void setXl(String xl) {this.xl = xl;}
public String getXw() {return xw;}
public void setXw(String xw) {this.xw = xw;}
public String getXx() {return xx;}
public void setXx(String xx) {this.xx = xx;}
public String getYx() {return yx;}
public void setYx(String yx) {this.yx = yx;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
}

百色学院教育类项目管理系统(xaa28)_mysql_oracle代码分享

百色学院教育类项目管理系统mysql数据库版本源码：

百色学院教育类项目管理系统oracle数据库版本源码：

百色学院教育类项目管理系统sqlserver数据库版本源码：

百色学院教育类项目管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计：

百色学院教育类项目管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：

相关毕业设计源码

评论