- 项目众包平台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_gw(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码 ',
gwName varchar(100) comment '姓名',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
phone varchar(100) comment '电话',
pic varchar(100) comment '头像',
qx varchar(100) comment '是否有承接项目权限'
) comment '顾问';
雇主表创建语句如下:
create table t_gz(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码 ',
gzName varchar(100) comment '姓名',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
phone varchar(100) comment '电话',
qx varchar(100) comment '是否有发布信息权限'
) comment '雇主';
咨询交流表创建语句如下:
create table t_jl(
id int primary key auto_increment comment '主键',
xmId int comment '项目',
name varchar(100) comment '姓名',
content varchar(100) comment '内容',
insertDate datetime comment '日期'
) comment '咨询交流';
类型表创建语句如下:
create table t_types(
id int primary key auto_increment comment '主键',
typesName varchar(100) comment '类型'
) comment '类型';
系统日志表创建语句如下:
create table t_v1(
id int primary key auto_increment comment '主键',
name varchar(100) comment '姓名',
insertDate datetime comment '日期',
content varchar(100) comment '内容'
) comment '系统日志';
操作日志表创建语句如下:
create table t_v2(
id int primary key auto_increment comment '主键',
name varchar(100) comment '操作人姓名',
insertDate datetime comment '日期',
content varchar(100) comment '操作菜单url'
) comment '操作日志';
定时记录表创建语句如下:
create table t_v3(
id int primary key auto_increment comment '主键',
v1 varchar(100) comment '仲裁员数量',
v2 varchar(100) comment '顾问数量',
v3 varchar(100) comment '雇主数量',
insertDate datetime comment '日期'
) comment '定时记录';
项目需求表创建语句如下:
create table t_xm(
id int primary key auto_increment comment '主键',
typesId int comment '类型',
xmbh varchar(100) comment '项目编号',
gzId int comment '雇主',
xmName varchar(100) comment '项目名称',
content varchar(100) comment '内容',
fileUrl varchar(100) comment '文件',
gwId int comment '顾问',
status varchar(100) comment '状态',
pj varchar(100) comment '评价'
) comment '项目需求';
项目合约表创建语句如下:
create table t_xmhy(
id int primary key auto_increment comment '主键',
xmId int comment '项目',
gwId int comment '顾问',
gzId int comment '雇主',
hyFile varchar(100) comment '合约文件',
status varchar(100) comment '状态'
) comment '项目合约';
项目进度表创建语句如下:
create table t_xmjd(
id int primary key auto_increment comment '主键',
xmId int comment '项目',
title varchar(100) comment '标题',
content varchar(100) comment '内容',
showDate datetime comment '日期'
) comment '项目进度';
仲裁管理员表创建语句如下:
create table t_zcgly(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码 ',
gzName varchar(100) comment '姓名',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
phone 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_gw(
id integer,
username varchar(100),
password varchar(100),
gwName varchar(100),
age varchar(100),
sex varchar(100),
phone varchar(100),
pic varchar(100),
qx varchar(100)
);
--顾问字段加注释
comment on column t_gw.id is '主键';
comment on column t_gw.username is '账号';
comment on column t_gw.password is '密码 ';
comment on column t_gw.gwName is '姓名';
comment on column t_gw.age is '年龄';
comment on column t_gw.sex is '性别';
comment on column t_gw.phone is '电话';
comment on column t_gw.pic is '头像';
comment on column t_gw.qx is '是否有承接项目权限';
--顾问表加注释
comment on table t_gw is '顾问';
雇主表创建语句如下:
create table t_gz(
id integer,
username varchar(100),
password varchar(100),
gzName varchar(100),
age varchar(100),
sex varchar(100),
phone varchar(100),
qx varchar(100)
);
--雇主字段加注释
comment on column t_gz.id is '主键';
comment on column t_gz.username is '账号';
comment on column t_gz.password is '密码 ';
comment on column t_gz.gzName is '姓名';
comment on column t_gz.age is '年龄';
comment on column t_gz.sex is '性别';
comment on column t_gz.phone is '电话';
comment on column t_gz.qx is '是否有发布信息权限';
--雇主表加注释
comment on table t_gz is '雇主';
咨询交流表创建语句如下:
create table t_jl(
id integer,
xmId int,
name varchar(100),
content varchar(100),
insertDate datetime
);
--咨询交流字段加注释
comment on column t_jl.id is '主键';
comment on column t_jl.xmId is '项目';
comment on column t_jl.name is '姓名';
comment on column t_jl.content is '内容';
comment on column t_jl.insertDate is '日期';
--咨询交流表加注释
comment on table t_jl is '咨询交流';
类型表创建语句如下:
create table t_types(
id integer,
typesName varchar(100)
);
--类型字段加注释
comment on column t_types.id is '主键';
comment on column t_types.typesName is '类型';
--类型表加注释
comment on table t_types is '类型';
系统日志表创建语句如下:
create table t_v1(
id integer,
name varchar(100),
insertDate datetime,
content varchar(100)
);
--系统日志字段加注释
comment on column t_v1.id is '主键';
comment on column t_v1.name is '姓名';
comment on column t_v1.insertDate is '日期';
comment on column t_v1.content is '内容';
--系统日志表加注释
comment on table t_v1 is '系统日志';
操作日志表创建语句如下:
create table t_v2(
id integer,
name varchar(100),
insertDate datetime,
content varchar(100)
);
--操作日志字段加注释
comment on column t_v2.id is '主键';
comment on column t_v2.name is '操作人姓名';
comment on column t_v2.insertDate is '日期';
comment on column t_v2.content is '操作菜单url';
--操作日志表加注释
comment on table t_v2 is '操作日志';
定时记录表创建语句如下:
create table t_v3(
id integer,
v1 varchar(100),
v2 varchar(100),
v3 varchar(100),
insertDate datetime
);
--定时记录字段加注释
comment on column t_v3.id is '主键';
comment on column t_v3.v1 is '仲裁员数量';
comment on column t_v3.v2 is '顾问数量';
comment on column t_v3.v3 is '雇主数量';
comment on column t_v3.insertDate is '日期';
--定时记录表加注释
comment on table t_v3 is '定时记录';
项目需求表创建语句如下:
create table t_xm(
id integer,
typesId int,
xmbh varchar(100),
gzId int,
xmName varchar(100),
content varchar(100),
fileUrl varchar(100),
gwId int,
status varchar(100),
pj varchar(100)
);
--项目需求字段加注释
comment on column t_xm.id is '主键';
comment on column t_xm.typesId is '类型';
comment on column t_xm.xmbh is '项目编号';
comment on column t_xm.gzId is '雇主';
comment on column t_xm.xmName is '项目名称';
comment on column t_xm.content is '内容';
comment on column t_xm.fileUrl is '文件';
comment on column t_xm.gwId is '顾问';
comment on column t_xm.status is '状态';
comment on column t_xm.pj is '评价';
--项目需求表加注释
comment on table t_xm is '项目需求';
项目合约表创建语句如下:
create table t_xmhy(
id integer,
xmId int,
gwId int,
gzId int,
hyFile varchar(100),
status varchar(100)
);
--项目合约字段加注释
comment on column t_xmhy.id is '主键';
comment on column t_xmhy.xmId is '项目';
comment on column t_xmhy.gwId is '顾问';
comment on column t_xmhy.gzId is '雇主';
comment on column t_xmhy.hyFile is '合约文件';
comment on column t_xmhy.status is '状态';
--项目合约表加注释
comment on table t_xmhy is '项目合约';
项目进度表创建语句如下:
create table t_xmjd(
id integer,
xmId int,
title varchar(100),
content varchar(100),
showDate datetime
);
--项目进度字段加注释
comment on column t_xmjd.id is '主键';
comment on column t_xmjd.xmId is '项目';
comment on column t_xmjd.title is '标题';
comment on column t_xmjd.content is '内容';
comment on column t_xmjd.showDate is '日期';
--项目进度表加注释
comment on table t_xmjd is '项目进度';
仲裁管理员表创建语句如下:
create table t_zcgly(
id integer,
username varchar(100),
password varchar(100),
gzName varchar(100),
age varchar(100),
sex varchar(100),
phone varchar(100)
);
--仲裁管理员字段加注释
comment on column t_zcgly.id is '主键';
comment on column t_zcgly.username is '账号';
comment on column t_zcgly.password is '密码 ';
comment on column t_zcgly.gzName is '姓名';
comment on column t_zcgly.age is '年龄';
comment on column t_zcgly.sex is '性别';
comment on column t_zcgly.phone is '电话';
--仲裁管理员表加注释
comment on table t_zcgly is '仲裁管理员';
oracle特有,对应序列如下:
create sequence s_t_gw;
create sequence s_t_gz;
create sequence s_t_jl;
create sequence s_t_types;
create sequence s_t_v1;
create sequence s_t_v2;
create sequence s_t_v3;
create sequence s_t_xm;
create sequence s_t_xmhy;
create sequence s_t_xmjd;
create sequence s_t_zcgly;
项目众包平台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_gw(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
gwName varchar(100),--姓名
age varchar(100),--年龄
sex varchar(100),--性别
phone varchar(100),--电话
pic varchar(100),--头像
qx varchar(100)--是否有承接项目权限
);
雇主表创建语句如下:
--雇主表注释
create table t_gz(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
gzName varchar(100),--姓名
age varchar(100),--年龄
sex varchar(100),--性别
phone varchar(100),--电话
qx varchar(100)--是否有发布信息权限
);
咨询交流表创建语句如下:
--咨询交流表注释
create table t_jl(
id int identity(1,1) primary key not null,--主键
xmId int,--项目
name varchar(100),--姓名
content varchar(100),--内容
insertDate datetime--日期
);
类型表创建语句如下:
--类型表注释
create table t_types(
id int identity(1,1) primary key not null,--主键
typesName varchar(100)--类型
);
系统日志表创建语句如下:
--系统日志表注释
create table t_v1(
id int identity(1,1) primary key not null,--主键
name varchar(100),--姓名
insertDate datetime,--日期
content varchar(100)--内容
);
操作日志表创建语句如下:
--操作日志表注释
create table t_v2(
id int identity(1,1) primary key not null,--主键
name varchar(100),--操作人姓名
insertDate datetime,--日期
content varchar(100)--操作菜单url
);
定时记录表创建语句如下:
--定时记录表注释
create table t_v3(
id int identity(1,1) primary key not null,--主键
v1 varchar(100),--仲裁员数量
v2 varchar(100),--顾问数量
v3 varchar(100),--雇主数量
insertDate datetime--日期
);
项目需求表创建语句如下:
--项目需求表注释
create table t_xm(
id int identity(1,1) primary key not null,--主键
typesId int,--类型
xmbh varchar(100),--项目编号
gzId int,--雇主
xmName varchar(100),--项目名称
content varchar(100),--内容
fileUrl varchar(100),--文件
gwId int,--顾问
status varchar(100),--状态
pj varchar(100)--评价
);
项目合约表创建语句如下:
--项目合约表注释
create table t_xmhy(
id int identity(1,1) primary key not null,--主键
xmId int,--项目
gwId int,--顾问
gzId int,--雇主
hyFile varchar(100),--合约文件
status varchar(100)--状态
);
项目进度表创建语句如下:
--项目进度表注释
create table t_xmjd(
id int identity(1,1) primary key not null,--主键
xmId int,--项目
title varchar(100),--标题
content varchar(100),--内容
showDate datetime--日期
);
仲裁管理员表创建语句如下:
--仲裁管理员表注释
create table t_zcgly(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
gzName varchar(100),--姓名
age varchar(100),--年龄
sex varchar(100),--性别
phone 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_gw")
public class Gw {
//主键
@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 gwName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//头像
private String pic;
//是否有承接项目权限
private String qx;
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 getGwName() {return gwName;}
public void setGwName(String gwName) {this.gwName = gwName;}
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 getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getQx() {return qx;}
public void setQx(String qx) {this.qx = qx;}
}
雇主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_gz")
public class Gz {
//主键
@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 gzName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//是否有发布信息权限
private String qx;
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 getGzName() {return gzName;}
public void setGzName(String gzName) {this.gzName = gzName;}
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 getQx() {return qx;}
public void setQx(String qx) {this.qx = qx;}
}
咨询交流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_jl")
public class Jl {
//主键
@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 xmId;
//姓名
private String name;
//内容
private String content;
//日期
private Date insertDate;
public Integer getXmId() {return xmId;}
public void setXmId(Integer xmId) {this.xmId = xmId;}
public String getName() {return name;}
public void setName(String name) {this.name = name;}
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_types")
public class Types {
//主键
@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 typesName;
public String getTypesName() {return typesName;}
public void setTypesName(String typesName) {this.typesName = typesName;}
}
系统日志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_v1")
public class V1 {
//主键
@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 name;
//日期
private Date insertDate;
//内容
private String content;
public String getName() {return name;}
public void setName(String name) {this.name = name;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}
操作日志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_v2")
public class V2 {
//主键
@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 name;
//日期
private Date insertDate;
//操作菜单url
private String content;
public String getName() {return name;}
public void setName(String name) {this.name = name;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}
定时记录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_v3")
public class V3 {
//主键
@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 v1;
//顾问数量
private String v2;
//雇主数量
private String v3;
//日期
private Date insertDate;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
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_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 Integer typesId;
//项目编号
private String xmbh;
//雇主
private Integer gzId;
//项目名称
private String xmName;
//内容
private String content;
//文件
private String fileUrl;
//顾问
private Integer gwId;
//状态
private String status;
//评价
private String pj;
public Integer getTypesId() {return typesId;}
public void setTypesId(Integer typesId) {this.typesId = typesId;}
public String getXmbh() {return xmbh;}
public void setXmbh(String xmbh) {this.xmbh = xmbh;}
public Integer getGzId() {return gzId;}
public void setGzId(Integer gzId) {this.gzId = gzId;}
public String getXmName() {return xmName;}
public void setXmName(String xmName) {this.xmName = xmName;}
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 Integer getGwId() {return gwId;}
public void setGwId(Integer gwId) {this.gwId = gwId;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getPj() {return pj;}
public void setPj(String pj) {this.pj = pj;}
}
项目合约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_xmhy")
public class Xmhy {
//主键
@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 xmId;
//顾问
private Integer gwId;
//雇主
private Integer gzId;
//合约文件
private String hyFile;
//状态
private String status;
public Integer getXmId() {return xmId;}
public void setXmId(Integer xmId) {this.xmId = xmId;}
public Integer getGwId() {return gwId;}
public void setGwId(Integer gwId) {this.gwId = gwId;}
public Integer getGzId() {return gzId;}
public void setGzId(Integer gzId) {this.gzId = gzId;}
public String getHyFile() {return hyFile;}
public void setHyFile(String hyFile) {this.hyFile = hyFile;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}
项目进度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_xmjd")
public class Xmjd {
//主键
@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 xmId;
//标题
private String title;
//内容
private String content;
//日期
private Date showDate;
public Integer getXmId() {return xmId;}
public void setXmId(Integer xmId) {this.xmId = xmId;}
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 getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}
仲裁管理员javaBean创建语句如下:
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//仲裁管理员
@Table(name = "t_zcgly")
public class Zcgly {
//主键
@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 gzName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
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 getGzName() {return gzName;}
public void setGzName(String gzName) {this.gzName = gzName;}
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;}
}
项目众包平台spring+springMVC+mybatis框架对象(javaBean,pojo)设计:
顾问javaBean创建语句如下:
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//顾问
public class Gw 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 gwName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//头像
private String pic;
//是否有承接项目权限
private String qx;
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 getGwName() {return gwName;}
public void setGwName(String gwName) {this.gwName = gwName;}
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 getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getQx() {return qx;}
public void setQx(String qx) {this.qx = qx;}
}
雇主javaBean创建语句如下:
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//雇主
public class Gz 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 gzName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//是否有发布信息权限
private String qx;
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 getGzName() {return gzName;}
public void setGzName(String gzName) {this.gzName = gzName;}
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 getQx() {return qx;}
public void setQx(String qx) {this.qx = qx;}
}
咨询交流javaBean创建语句如下:
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//咨询交流
public class Jl extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//项目
private Integer xmId;
//姓名
private String name;
//内容
private String content;
//日期
private Date insertDate;
public Integer getXmId() {return xmId;}
public void setXmId(Integer xmId) {this.xmId = xmId;}
public String getName() {return name;}
public void setName(String name) {this.name = name;}
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 Types extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//类型
private String typesName;
public String getTypesName() {return typesName;}
public void setTypesName(String typesName) {this.typesName = typesName;}
}
系统日志javaBean创建语句如下:
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//系统日志
public class V1 extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//姓名
private String name;
//日期
private Date insertDate;
//内容
private String content;
public String getName() {return name;}
public void setName(String name) {this.name = name;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}
操作日志javaBean创建语句如下:
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//操作日志
public class V2 extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//操作人姓名
private String name;
//日期
private Date insertDate;
//操作菜单url
private String content;
public String getName() {return name;}
public void setName(String name) {this.name = name;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}
定时记录javaBean创建语句如下:
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//定时记录
public class V3 extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//仲裁员数量
private String v1;
//顾问数量
private String v2;
//雇主数量
private String v3;
//日期
private Date insertDate;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
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 Xm extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//类型
private Integer typesId;
//项目编号
private String xmbh;
//雇主
private Integer gzId;
//项目名称
private String xmName;
//内容
private String content;
//文件
private String fileUrl;
//顾问
private Integer gwId;
//状态
private String status;
//评价
private String pj;
public Integer getTypesId() {return typesId;}
public void setTypesId(Integer typesId) {this.typesId = typesId;}
public String getXmbh() {return xmbh;}
public void setXmbh(String xmbh) {this.xmbh = xmbh;}
public Integer getGzId() {return gzId;}
public void setGzId(Integer gzId) {this.gzId = gzId;}
public String getXmName() {return xmName;}
public void setXmName(String xmName) {this.xmName = xmName;}
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 Integer getGwId() {return gwId;}
public void setGwId(Integer gwId) {this.gwId = gwId;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getPj() {return pj;}
public void setPj(String pj) {this.pj = pj;}
}
项目合约javaBean创建语句如下:
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//项目合约
public class Xmhy extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//项目
private Integer xmId;
//顾问
private Integer gwId;
//雇主
private Integer gzId;
//合约文件
private String hyFile;
//状态
private String status;
public Integer getXmId() {return xmId;}
public void setXmId(Integer xmId) {this.xmId = xmId;}
public Integer getGwId() {return gwId;}
public void setGwId(Integer gwId) {this.gwId = gwId;}
public Integer getGzId() {return gzId;}
public void setGzId(Integer gzId) {this.gzId = gzId;}
public String getHyFile() {return hyFile;}
public void setHyFile(String hyFile) {this.hyFile = hyFile;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}
项目进度javaBean创建语句如下:
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//项目进度
public class Xmjd extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//项目
private Integer xmId;
//标题
private String title;
//内容
private String content;
//日期
private Date showDate;
public Integer getXmId() {return xmId;}
public void setXmId(Integer xmId) {this.xmId = xmId;}
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 getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}
仲裁管理员javaBean创建语句如下:
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//仲裁管理员
public class Zcgly 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 gzName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
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 getGzName() {return gzName;}
public void setGzName(String gzName) {this.gzName = gzName;}
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;}
}