基于java的企业报表管理系统的设计与实现

基于java的企业报表管理系统的设计与实现登录注册界面

基于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_baobiao(
	id int primary key auto_increment comment '主键',
	customerId int comment '员工',
	title varchar(100) comment '报表标题',
	content varchar(100) comment '报表内容',
	fileUrl varchar(100) comment '报表附件',
	insertDate datetime comment '上传日期'
) comment '报表';

报表修改申请表创建语句如下:


create table t_bbxg(
	id int primary key auto_increment comment '主键',
	customerId int comment '员工',
	baobiaoId int comment '申请修改报表',
	insertDate datetime comment '申请日期',
	content varchar(100) comment '申请说明',
	status varchar(100) comment '状态'
) comment '报表修改申请';

员工表创建语句如下:


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 '性别',
	v1 varchar(100) comment '查看公告权限',
	v2 varchar(100) comment '报表操作权限',
	v3 varchar(100) 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_nbzl(
	id int primary key auto_increment comment '主键',
	v1 varchar(100) comment '资料名称',
	fileUrl varchar(100) comment '资料附件',
	showDate datetime 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 '通知';

基于java的企业报表管理系统的设计与实现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_baobiao(
	id integer,
	customerId int,
	title varchar(100),
	content varchar(100),
	fileUrl varchar(100),
	insertDate datetime
);
--报表字段加注释
comment on column t_baobiao.id is '主键';
comment on column t_baobiao.customerId is '员工';
comment on column t_baobiao.title is '报表标题';
comment on column t_baobiao.content is '报表内容';
comment on column t_baobiao.fileUrl is '报表附件';
comment on column t_baobiao.insertDate is '上传日期';
--报表表加注释
comment on table t_baobiao is '报表';

报表修改申请表创建语句如下:


create table t_bbxg(
	id integer,
	customerId int,
	baobiaoId int,
	insertDate datetime,
	content varchar(100),
	status varchar(100)
);
--报表修改申请字段加注释
comment on column t_bbxg.id is '主键';
comment on column t_bbxg.customerId is '员工';
comment on column t_bbxg.baobiaoId is '申请修改报表';
comment on column t_bbxg.insertDate is '申请日期';
comment on column t_bbxg.content is '申请说明';
comment on column t_bbxg.status is '状态';
--报表修改申请表加注释
comment on table t_bbxg 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),
	v1 varchar(100),
	v2 varchar(100),
	v3 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 column t_customer.v1 is '查看公告权限';
comment on column t_customer.v2 is '报表操作权限';
comment on column t_customer.v3 is '公司内部资料权限';
--员工表加注释
comment on table t_customer 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_nbzl(
	id integer,
	v1 varchar(100),
	fileUrl varchar(100),
	showDate datetime
);
--内部资料字段加注释
comment on column t_nbzl.id is '主键';
comment on column t_nbzl.v1 is '资料名称';
comment on column t_nbzl.fileUrl is '资料附件';
comment on column t_nbzl.showDate is '日期';
--内部资料表加注释
comment on table t_nbzl 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_baobiao;
create sequence s_t_bbxg;
create sequence s_t_customer;
create sequence s_t_gg;
create sequence s_t_nbzl;
create sequence s_t_tongzhi;

基于java的企业报表管理系统的设计与实现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_baobiao(
	id int identity(1,1) primary key not null,--主键
	customerId int,--员工
	title varchar(100),--报表标题
	content varchar(100),--报表内容
	fileUrl varchar(100),--报表附件
	insertDate datetime--上传日期
);

报表修改申请表创建语句如下:


--报表修改申请表注释
create table t_bbxg(
	id int identity(1,1) primary key not null,--主键
	customerId int,--员工
	baobiaoId int,--申请修改报表
	insertDate datetime,--申请日期
	content varchar(100),--申请说明
	status varchar(100)--状态
);

员工表创建语句如下:


--员工表注释
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),--性别
	v1 varchar(100),--查看公告权限
	v2 varchar(100),--报表操作权限
	v3 varchar(100)--公司内部资料权限
);

公告表创建语句如下:


--公告表注释
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_nbzl(
	id int identity(1,1) primary key not null,--主键
	v1 varchar(100),--资料名称
	fileUrl varchar(100),--资料附件
	showDate datetime--日期
);

通知表创建语句如下:


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

基于java的企业报表管理系统的设计与实现登录后主页

基于java的企业报表管理系统的设计与实现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_baobiao")
public class Baobiao {
//主键
@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 content;
//报表附件
private String fileUrl;
//上传日期
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 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 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_bbxg")
public class Bbxg {
//主键
@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 baobiaoId;
//申请日期
private Date insertDate;
//申请说明
private String content;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getBaobiaoId() {return baobiaoId;}
public void setBaobiaoId(Integer baobiaoId) {this.baobiaoId = baobiaoId;}
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;}
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_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;
//查看公告权限
private String v1;
//报表操作权限
private String v2;
//公司内部资料权限
private String v3;
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;}
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;}
}

公告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_nbzl")
public class Nbzl {
//主键
@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 fileUrl;
//日期
private Date showDate;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
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_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;}
}

基于java的企业报表管理系统的设计与实现spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

报表javaBean创建语句如下:


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

//报表
public class Baobiao  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 content;
//报表附件
private String fileUrl;
//上传日期
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 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 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 Bbxg  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//员工
private Integer customerId;
//申请修改报表
private Integer baobiaoId;
//申请日期
private Date insertDate;
//申请说明
private String content;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getBaobiaoId() {return baobiaoId;}
public void setBaobiaoId(Integer baobiaoId) {this.baobiaoId = baobiaoId;}
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;}
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 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;
//查看公告权限
private String v1;
//报表操作权限
private String v2;
//公司内部资料权限
private String v3;
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;}
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;}
}

公告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 Nbzl  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//资料名称
private String v1;
//资料附件
private String fileUrl;
//日期
private Date showDate;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
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 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;}
}

评论