电子文档管理系统

• 电子文档管理系统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 '电话',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别'
) comment '用户';

电子文档表创建语句如下：

create table t_fileup(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	title varchar(100) comment '文档名称',
	fileUrl varchar(100) comment '附件',
	content varchar(100) comment '文档说明',
	insertDate datetime comment '上传日期'
) comment '电子文档';

公告表创建语句如下：

create table t_gg(
	id int primary key auto_increment comment '主键',
	v1 varchar(100) comment '标题',
	pic varchar(100) comment '图片',
	showDate datetime comment '日期',
	v3 varchar(100) comment '内容'
) comment '公告';

公共电子文档表创建语句如下：

create table t_ggfx(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '文档名称',
	fileUrl varchar(100) comment '附件',
	content varchar(100) comment '文档说明',
	insertDate datetime comment '上传日期'
) comment '公共电子文档';

电子文档分享申请表创建语句如下：

create table t_order(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	fileupId int comment '电子文档',
	content varchar(100) comment '共享申请说明',
	insertDate datetime comment '申请日期',
	status varchar(100) comment '状态',
	back varchar(100) comment '审核说明'
) comment '电子文档分享申请';

通知表创建语句如下：

create table t_tongzhi(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	txName varchar(100) comment '标题',
	content varchar(100) comment '内容',
	insertDate datetime 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),
	age varchar(100),
	sex 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.age is '年龄';
comment on column t_customer.sex is '性别';
--用户表加注释
comment on table t_customer is '用户';

电子文档表创建语句如下：

create table t_fileup(
	id integer,
	customerId int,
	title varchar(100),
	fileUrl varchar(100),
	content varchar(100),
	insertDate datetime
);
--电子文档字段加注释
comment on column t_fileup.id is '主键';
comment on column t_fileup.customerId is '用户';
comment on column t_fileup.title is '文档名称';
comment on column t_fileup.fileUrl is '附件';
comment on column t_fileup.content is '文档说明';
comment on column t_fileup.insertDate is '上传日期';
--电子文档表加注释
comment on table t_fileup is '电子文档';

公告表创建语句如下：

create table t_gg(
	id integer,
	v1 varchar(100),
	pic varchar(100),
	showDate datetime,
	v3 varchar(100)
);
--公告字段加注释
comment on column t_gg.id is '主键';
comment on column t_gg.v1 is '标题';
comment on column t_gg.pic is '图片';
comment on column t_gg.showDate is '日期';
comment on column t_gg.v3 is '内容';
--公告表加注释
comment on table t_gg is '公告';

公共电子文档表创建语句如下：

create table t_ggfx(
	id integer,
	title varchar(100),
	fileUrl varchar(100),
	content varchar(100),
	insertDate datetime
);
--公共电子文档字段加注释
comment on column t_ggfx.id is '主键';
comment on column t_ggfx.title is '文档名称';
comment on column t_ggfx.fileUrl is '附件';
comment on column t_ggfx.content is '文档说明';
comment on column t_ggfx.insertDate is '上传日期';
--公共电子文档表加注释
comment on table t_ggfx is '公共电子文档';

电子文档分享申请表创建语句如下：

create table t_order(
	id integer,
	customerId int,
	fileupId int,
	content varchar(100),
	insertDate datetime,
	status varchar(100),
	back varchar(100)
);
--电子文档分享申请字段加注释
comment on column t_order.id is '主键';
comment on column t_order.customerId is '用户';
comment on column t_order.fileupId is '电子文档';
comment on column t_order.content is '共享申请说明';
comment on column t_order.insertDate is '申请日期';
comment on column t_order.status is '状态';
comment on column t_order.back is '审核说明';
--电子文档分享申请表加注释
comment on table t_order is '电子文档分享申请';

通知表创建语句如下：

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

oracle特有，对应序列如下：

create sequence s_t_customer;
create sequence s_t_fileup;
create sequence s_t_gg;
create sequence s_t_ggfx;
create sequence s_t_order;
create sequence s_t_tongzhi;

电子文档管理系统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),--电话
	age varchar(100),--年龄
	sex varchar(100)--性别
);

电子文档表创建语句如下：

--电子文档表注释
create table t_fileup(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	title varchar(100),--文档名称
	fileUrl varchar(100),--附件
	content varchar(100),--文档说明
	insertDate datetime--上传日期
);

公告表创建语句如下：

--公告表注释
create table t_gg(
	id int identity(1,1) primary key not null,--主键
	v1 varchar(100),--标题
	pic varchar(100),--图片
	showDate datetime,--日期
	v3 varchar(100)--内容
);

公共电子文档表创建语句如下：

--公共电子文档表注释
create table t_ggfx(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--文档名称
	fileUrl varchar(100),--附件
	content varchar(100),--文档说明
	insertDate datetime--上传日期
);

电子文档分享申请表创建语句如下：

--电子文档分享申请表注释
create table t_order(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	fileupId int,--电子文档
	content varchar(100),--共享申请说明
	insertDate datetime,--申请日期
	status varchar(100),--状态
	back varchar(100)--审核说明
);

通知表创建语句如下：

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

电子文档管理系统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 age;
//性别
private String sex;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String 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 getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
}

电子文档javaBean创建语句如下：

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

//电子文档
@Table(name = "t_fileup")
public class Fileup {
//主键
@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 customerId;
//文档名称
private String title;
//附件
private String fileUrl;
//文档说明
private String content;
//上传日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
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_gg")
public class Gg {
//主键
@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 pic;
//日期
private Date showDate;
//内容
private String v3;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}

公共电子文档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_ggfx")
public class Ggfx {
//主键
@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 fileUrl;
//文档说明
private String content;
//上传日期
private Date insertDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}

电子文档分享申请javaBean创建语句如下：

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

//电子文档分享申请
@Table(name = "t_order")
public class Order {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//电子文档
private Integer fileupId;
//共享申请说明
private String content;
//申请日期
private Date insertDate;
//状态
private String status;
//审核说明
private String back;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getFileupId() {return fileupId;}
public void setFileupId(Integer fileupId) {this.fileupId = fileupId;}
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;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}

通知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 Integer customerId;
//标题
private String txName;
//内容
private String content;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTxName() {return txName;}
public void setTxName(String txName) {this.txName = txName;}
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;}
}

电子文档管理系统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 age;
//性别
private String sex;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String 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 getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
}

电子文档javaBean创建语句如下：

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

//电子文档
public class Fileup  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//文档名称
private String title;
//附件
private String fileUrl;
//文档说明
private String content;
//上传日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
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 Gg  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String v1;
//图片
private String pic;
//日期
private Date showDate;
//内容
private String v3;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}

公共电子文档javaBean创建语句如下：

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

//公共电子文档
public class Ggfx  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//文档名称
private String title;
//附件
private String fileUrl;
//文档说明
private String content;
//上传日期
private Date insertDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}

电子文档分享申请javaBean创建语句如下：

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

//电子文档分享申请
public class Order  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//电子文档
private Integer fileupId;
//共享申请说明
private String content;
//申请日期
private Date insertDate;
//状态
private String status;
//审核说明
private String back;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getFileupId() {return fileupId;}
public void setFileupId(Integer fileupId) {this.fileupId = fileupId;}
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;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}

通知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 Integer customerId;
//标题
private String txName;
//内容
private String content;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTxName() {return txName;}
public void setTxName(String txName) {this.txName = txName;}
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;}
}