在线公文管理系统(officeonlinesystem),java项目设计

在线公文管理系统登录注册界面

在线公文管理系统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 '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话',
	idcard varchar(100) comment '身份证',
	address varchar(100) comment '地址',
	types varchar(100) comment '类型',
	deptId int comment '部门'
) comment '用户';

部门表创建语句如下:


create table t_dept(
	id int primary key auto_increment comment '主键',
	deptName varchar(100) comment '部门名称'
) comment '部门';

公文表创建语句如下:


create table t_gw(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	gwName varchar(100) comment '公文标题',
	gwContent varchar(100) comment '公文内容',
	fileUrl varchar(100) comment '公文附件',
	types varchar(100) comment '公文类型',
	status varchar(100) comment '状态',
	deptName 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),
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	idcard varchar(100),
	address varchar(100),
	types varchar(100),
	deptId int
);
--用户字段加注释
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.age is '年龄';
comment on column t_customer.sex is '性别';
comment on column t_customer.phone is '电话';
comment on column t_customer.idcard is '身份证';
comment on column t_customer.address is '地址';
comment on column t_customer.types is '类型';
comment on column t_customer.deptId is '部门';
--用户表加注释
comment on table t_customer is '用户';

部门表创建语句如下:


create table t_dept(
	id integer,
	deptName varchar(100)
);
--部门字段加注释
comment on column t_dept.id is '主键';
comment on column t_dept.deptName is '部门名称';
--部门表加注释
comment on table t_dept is '部门';

公文表创建语句如下:


create table t_gw(
	id integer,
	customerId int,
	gwName varchar(100),
	gwContent varchar(100),
	fileUrl varchar(100),
	types varchar(100),
	status varchar(100),
	deptName varchar(100),
	insertDate datetime
);
--公文字段加注释
comment on column t_gw.id is '主键';
comment on column t_gw.customerId is '用户';
comment on column t_gw.gwName is '公文标题';
comment on column t_gw.gwContent is '公文内容';
comment on column t_gw.fileUrl is '公文附件';
comment on column t_gw.types is '公文类型';
comment on column t_gw.status is '状态';
comment on column t_gw.deptName is '部门名称';
comment on column t_gw.insertDate is '发布日期';
--公文表加注释
comment on table t_gw is '公文';

oracle特有,对应序列如下:


create sequence s_t_customer;
create sequence s_t_dept;
create sequence s_t_gw;

在线公文管理系统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),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100),--电话
	idcard varchar(100),--身份证
	address varchar(100),--地址
	types varchar(100),--类型
	deptId int--部门
);

部门表创建语句如下:


--部门表注释
create table t_dept(
	id int identity(1,1) primary key not null,--主键
	deptName varchar(100)--部门名称
);

公文表创建语句如下:


--公文表注释
create table t_gw(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	gwName varchar(100),--公文标题
	gwContent varchar(100),--公文内容
	fileUrl varchar(100),--公文附件
	types varchar(100),--公文类型
	status varchar(100),--状态
	deptName 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 age;
//性别
private String sex;
//电话
private String phone;
//身份证
private String idcard;
//地址
private String address;
//类型
private String types;
//部门
private Integer deptId;
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 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 getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Integer getDeptId() {return deptId;}
public void setDeptId(Integer deptId) {this.deptId = deptId;}
}

部门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_dept")
public class Dept {
//主键
@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 deptName;
public String getDeptName() {return deptName;}
public void setDeptName(String deptName) {this.deptName = deptName;}
}

公文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 Integer customerId;
//公文标题
private String gwName;
//公文内容
private String gwContent;
//公文附件
private String fileUrl;
//公文类型
private String types;
//状态
private String status;
//部门名称
private String deptName;
//发布日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getGwName() {return gwName;}
public void setGwName(String gwName) {this.gwName = gwName;}
public String getGwContent() {return gwContent;}
public void setGwContent(String gwContent) {this.gwContent = gwContent;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getDeptName() {return deptName;}
public void setDeptName(String deptName) {this.deptName = deptName;}
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 age;
//性别
private String sex;
//电话
private String phone;
//身份证
private String idcard;
//地址
private String address;
//类型
private String types;
//部门
private Integer deptId;
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 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 getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Integer getDeptId() {return deptId;}
public void setDeptId(Integer deptId) {this.deptId = deptId;}
}

部门javaBean创建语句如下:


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

//部门
public class Dept  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//部门名称
private String deptName;
public String getDeptName() {return deptName;}
public void setDeptName(String deptName) {this.deptName = deptName;}
}

公文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 Integer customerId;
//公文标题
private String gwName;
//公文内容
private String gwContent;
//公文附件
private String fileUrl;
//公文类型
private String types;
//状态
private String status;
//部门名称
private String deptName;
//发布日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getGwName() {return gwName;}
public void setGwName(String gwName) {this.gwName = gwName;}
public String getGwContent() {return gwContent;}
public void setGwContent(String gwContent) {this.gwContent = gwContent;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getDeptName() {return deptName;}
public void setDeptName(String deptName) {this.deptName = deptName;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}

评论