- 企业财务系统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_bmtz(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
content varchar(100) comment '内容',
insertDate datetime comment '日期',
bumenId int comment '部门'
) comment '部门通知';
部门表创建语句如下：
create table t_bumen(
id int primary key auto_increment comment '主键',
bumenName varchar(100) comment '部门'
) comment '部门';
差旅申请表创建语句如下：
create table t_chailv(
id int primary key auto_increment comment '主键',
customerId int comment '员工',
content text comment '详细说明',
mdd varchar(100) comment '目的地',
rq varchar(100) comment '时间段',
orderNum varchar(100) comment '申请编号',
status varchar(100) comment '状态',
back varchar(100) comment '回复',
insertDate datetime 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 '姓名',
headPic varchar(100) comment '头像',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '',
bumenId int comment '部门',
bmld varchar(100) comment ''
) comment '员工';
费用申请表创建语句如下：
create table t_feiyong(
id int primary key auto_increment comment '主键',
customerId int comment '员工',
fx varchar(100) comment '',
content text comment '详细说明',
fee int comment '申请金额',
orderNum varchar(100) comment '申请编号',
status varchar(100) comment '状态',
back varchar(100) comment '回复',
insertDate datetime comment '申请日期'
) comment '费用申请';
发票提交表创建语句如下：
create table t_fp(
id int primary key auto_increment comment '主键',
customerId int comment '员工',
fx varchar(100) comment '',
pic varchar(100) comment '发票拍照',
content text comment '说明',
orderNum varchar(100) comment '申请编号',
fee int comment '发票金额',
status varchar(100) comment '状态',
back varchar(100) comment '回复',
insertDate datetime comment '提交日期'
) comment '发票提交';
消息表创建语句如下：
create table t_xiaoxi(
id int primary key auto_increment comment '主键',
customerId int comment '员工',
title varchar(100) comment '标题',
content varchar(100) comment '内容',
insertDate datetime comment '日期'
) comment '消息';
系统通知表创建语句如下：
create table t_xttz(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
content varchar(100) comment '内容',
insertDate datetime comment '日期'
) comment '系统通知';
预算表创建语句如下：
create table t_ys(
id int primary key auto_increment comment '主键',
customerId int comment '员工',
title varchar(100) comment '预算标题',
content varchar(100) comment '内容',
allfee int comment '总金额',
status varchar(100) comment ''
) comment '预算';
预算详情表创建语句如下：
create table t_yslist(
id int primary key auto_increment comment '主键',
ysId int comment '预算',
fee int comment '金额',
showDate datetime comment '操作日期',
title text 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_bmtz(
id integer,
title varchar(100),
content varchar(100),
insertDate datetime,
bumenId int
);
--部门通知字段加注释
comment on column t_bmtz.id is '主键';
comment on column t_bmtz.title is '标题';
comment on column t_bmtz.content is '内容';
comment on column t_bmtz.insertDate is '日期';
comment on column t_bmtz.bumenId is '部门';
--部门通知表加注释
comment on table t_bmtz is '部门通知';
部门表创建语句如下：
create table t_bumen(
id integer,
bumenName varchar(100)
);
--部门字段加注释
comment on column t_bumen.id is '主键';
comment on column t_bumen.bumenName is '部门';
--部门表加注释
comment on table t_bumen is '部门';
差旅申请表创建语句如下：
create table t_chailv(
id integer,
customerId int,
content text,
mdd varchar(100),
rq varchar(100),
orderNum varchar(100),
status varchar(100),
back varchar(100),
insertDate datetime
);
--差旅申请字段加注释
comment on column t_chailv.id is '主键';
comment on column t_chailv.customerId is '员工';
comment on column t_chailv.content is '详细说明';
comment on column t_chailv.mdd is '目的地';
comment on column t_chailv.rq is '时间段';
comment on column t_chailv.orderNum is '申请编号';
comment on column t_chailv.status is '状态';
comment on column t_chailv.back is '回复';
comment on column t_chailv.insertDate is '申请日期';
--差旅申请表加注释
comment on table t_chailv is '差旅申请';
员工表创建语句如下：
create table t_customer(
id integer,
username varchar(100),
password varchar(100),
customerName varchar(100),
headPic varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
bumenId int,
bmld 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.headPic 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.bumenId is '部门';
comment on column t_customer.bmld is '';
--员工表加注释
comment on table t_customer is '员工';
费用申请表创建语句如下：
create table t_feiyong(
id integer,
customerId int,
fx varchar(100),
content text,
fee int,
orderNum varchar(100),
status varchar(100),
back varchar(100),
insertDate datetime
);
--费用申请字段加注释
comment on column t_feiyong.id is '主键';
comment on column t_feiyong.customerId is '员工';
comment on column t_feiyong.fx is '';
comment on column t_feiyong.content is '详细说明';
comment on column t_feiyong.fee is '申请金额';
comment on column t_feiyong.orderNum is '申请编号';
comment on column t_feiyong.status is '状态';
comment on column t_feiyong.back is '回复';
comment on column t_feiyong.insertDate is '申请日期';
--费用申请表加注释
comment on table t_feiyong is '费用申请';
发票提交表创建语句如下：
create table t_fp(
id integer,
customerId int,
fx varchar(100),
pic varchar(100),
content text,
orderNum varchar(100),
fee int,
status varchar(100),
back varchar(100),
insertDate datetime
);
--发票提交字段加注释
comment on column t_fp.id is '主键';
comment on column t_fp.customerId is '员工';
comment on column t_fp.fx is '';
comment on column t_fp.pic is '发票拍照';
comment on column t_fp.content is '说明';
comment on column t_fp.orderNum is '申请编号';
comment on column t_fp.fee is '发票金额';
comment on column t_fp.status is '状态';
comment on column t_fp.back is '回复';
comment on column t_fp.insertDate is '提交日期';
--发票提交表加注释
comment on table t_fp is '发票提交';
消息表创建语句如下：
create table t_xiaoxi(
id integer,
customerId int,
title varchar(100),
content varchar(100),
insertDate datetime
);
--消息字段加注释
comment on column t_xiaoxi.id is '主键';
comment on column t_xiaoxi.customerId is '员工';
comment on column t_xiaoxi.title is '标题';
comment on column t_xiaoxi.content is '内容';
comment on column t_xiaoxi.insertDate is '日期';
--消息表加注释
comment on table t_xiaoxi is '消息';
系统通知表创建语句如下：
create table t_xttz(
id integer,
title varchar(100),
content varchar(100),
insertDate datetime
);
--系统通知字段加注释
comment on column t_xttz.id is '主键';
comment on column t_xttz.title is '标题';
comment on column t_xttz.content is '内容';
comment on column t_xttz.insertDate is '日期';
--系统通知表加注释
comment on table t_xttz is '系统通知';
预算表创建语句如下：
create table t_ys(
id integer,
customerId int,
title varchar(100),
content varchar(100),
allfee int,
status varchar(100)
);
--预算字段加注释
comment on column t_ys.id is '主键';
comment on column t_ys.customerId is '员工';
comment on column t_ys.title is '预算标题';
comment on column t_ys.content is '内容';
comment on column t_ys.allfee is '总金额';
comment on column t_ys.status is '';
--预算表加注释
comment on table t_ys is '预算';
预算详情表创建语句如下：
create table t_yslist(
id integer,
ysId int,
fee int,
showDate datetime,
title text
);
--预算详情字段加注释
comment on column t_yslist.id is '主键';
comment on column t_yslist.ysId is '预算';
comment on column t_yslist.fee is '金额';
comment on column t_yslist.showDate is '操作日期';
comment on column t_yslist.title is '用途说明';
--预算详情表加注释
comment on table t_yslist is '预算详情';
oracle特有，对应序列如下：
create sequence s_t_bmtz;
create sequence s_t_bumen;
create sequence s_t_chailv;
create sequence s_t_customer;
create sequence s_t_feiyong;
create sequence s_t_fp;
create sequence s_t_xiaoxi;
create sequence s_t_xttz;
create sequence s_t_ys;
create sequence s_t_yslist;
企业财务系统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_bmtz(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
content varchar(100),--内容
insertDate datetime,--日期
bumenId int--部门
);
部门表创建语句如下：
--部门表注释
create table t_bumen(
id int identity(1,1) primary key not null,--主键
bumenName varchar(100)--部门
);
差旅申请表创建语句如下：
--差旅申请表注释
create table t_chailv(
id int identity(1,1) primary key not null,--主键
customerId int,--员工
content text,--详细说明
mdd varchar(100),--目的地
rq varchar(100),--时间段
orderNum varchar(100),--申请编号
status varchar(100),--状态
back varchar(100),--回复
insertDate datetime--申请日期
);
员工表创建语句如下：
--员工表注释
create table t_customer(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
customerName varchar(100),--姓名
headPic varchar(100),--头像
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--
bumenId int,--部门
bmld varchar(100)--
);
费用申请表创建语句如下：
--费用申请表注释
create table t_feiyong(
id int identity(1,1) primary key not null,--主键
customerId int,--员工
fx varchar(100),--
content text,--详细说明
fee int,--申请金额
orderNum varchar(100),--申请编号
status varchar(100),--状态
back varchar(100),--回复
insertDate datetime--申请日期
);
发票提交表创建语句如下：
--发票提交表注释
create table t_fp(
id int identity(1,1) primary key not null,--主键
customerId int,--员工
fx varchar(100),--
pic varchar(100),--发票拍照
content text,--说明
orderNum varchar(100),--申请编号
fee int,--发票金额
status varchar(100),--状态
back varchar(100),--回复
insertDate datetime--提交日期
);
消息表创建语句如下：
--消息表注释
create table t_xiaoxi(
id int identity(1,1) primary key not null,--主键
customerId int,--员工
title varchar(100),--标题
content varchar(100),--内容
insertDate datetime--日期
);
系统通知表创建语句如下：
--系统通知表注释
create table t_xttz(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
content varchar(100),--内容
insertDate datetime--日期
);
预算表创建语句如下：
--预算表注释
create table t_ys(
id int identity(1,1) primary key not null,--主键
customerId int,--员工
title varchar(100),--预算标题
content varchar(100),--内容
allfee int,--总金额
status varchar(100)--
);
预算详情表创建语句如下：
--预算详情表注释
create table t_yslist(
id int identity(1,1) primary key not null,--主键
ysId int,--预算
fee int,--金额
showDate datetime,--操作日期
title text--用途说明
);
登录后主页.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_bmtz")
public class Bmtz {
//主键
@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;
//部门
private Long bumenId;
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;}
public Long getBumenId() {return bumenId;}
public void setBumenId(Long bumenId) {this.bumenId = bumenId;}
}部门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_bumen")
public class Bumen {
//主键
@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 bumenName;
public String getBumenName() {return bumenName;}
public void setBumenName(String bumenName) {this.bumenName = bumenName;}
}差旅申请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_chailv")
public class Chailv {
//主键
@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 content;
//目的地
private String mdd;
//时间段
private String rq;
//申请编号
private String orderNum;
//状态
private String status;
//回复
private String back;
//申请日期
private Date insertDate;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getMdd() {return mdd;}
public void setMdd(String mdd) {this.mdd = mdd;}
public String getRq() {return rq;}
public void setRq(String rq) {this.rq = rq;}
public String getOrderNum() {return orderNum;}
public void setOrderNum(String orderNum) {this.orderNum = orderNum;}
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;}
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_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 headPic;
//电话
private String phone;
//年龄
private String age;
//
private String sex;
//部门
private Long bumenId;
//
private String bmld;
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 getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
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 Long getBumenId() {return bumenId;}
public void setBumenId(Long bumenId) {this.bumenId = bumenId;}
public String getBmld() {return bmld;}
public void setBmld(String bmld) {this.bmld = bmld;}
}费用申请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_feiyong")
public class Feiyong {
//主键
@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 fx;
//详细说明
private String content;
//申请金额
private Integer fee;
//申请编号
private String orderNum;
//状态
private String status;
//回复
private String back;
//申请日期
private Date insertDate;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public String getFx() {return fx;}
public void setFx(String fx) {this.fx = fx;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getOrderNum() {return orderNum;}
public void setOrderNum(String orderNum) {this.orderNum = orderNum;}
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;}
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_fp")
public class Fp {
//主键
@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 fx;
//发票拍照
private String pic;
//说明
private String content;
//申请编号
private String orderNum;
//发票金额
private Integer fee;
//状态
private String status;
//回复
private String back;
//提交日期
private Date insertDate;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public String getFx() {return fx;}
public void setFx(String fx) {this.fx = fx;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getOrderNum() {return orderNum;}
public void setOrderNum(String orderNum) {this.orderNum = orderNum;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
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;}
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_xiaoxi")
public class Xiaoxi {
//主键
@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 title;
//内容
private String content;
//日期
private Date insertDate;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long 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 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_xttz")
public class Xttz {
//主键
@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_ys")
public class Ys {
//主键
@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 title;
//内容
private String content;
//总金额
private Integer allfee;
//
private String status;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long 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 Integer getAllfee() {return allfee;}
public void setAllfee(Integer allfee) {this.allfee = allfee;}
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_yslist")
public class Yslist {
//主键
@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 ysId;
//金额
private Integer fee;
//操作日期
private Date showDate;
//用途说明
private String title;
public Long getYsId() {return ysId;}
public void setYsId(Long ysId) {this.ysId = ysId;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
}企业财务系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
部门通知javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//部门通知
public class Bmtz 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;
//部门
private Long bumenId;
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;}
public Long getBumenId() {return bumenId;}
public void setBumenId(Long bumenId) {this.bumenId = bumenId;}
}部门javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//部门
public class Bumen extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//部门
private String bumenName;
public String getBumenName() {return bumenName;}
public void setBumenName(String bumenName) {this.bumenName = bumenName;}
}差旅申请javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//差旅申请
public class Chailv extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//员工
private Long customerId;
//详细说明
private String content;
//目的地
private String mdd;
//时间段
private String rq;
//申请编号
private String orderNum;
//状态
private String status;
//回复
private String back;
//申请日期
private Date insertDate;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getMdd() {return mdd;}
public void setMdd(String mdd) {this.mdd = mdd;}
public String getRq() {return rq;}
public void setRq(String rq) {this.rq = rq;}
public String getOrderNum() {return orderNum;}
public void setOrderNum(String orderNum) {this.orderNum = orderNum;}
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;}
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 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 headPic;
//电话
private String phone;
//年龄
private String age;
//
private String sex;
//部门
private Long bumenId;
//
private String bmld;
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 getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
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 Long getBumenId() {return bumenId;}
public void setBumenId(Long bumenId) {this.bumenId = bumenId;}
public String getBmld() {return bmld;}
public void setBmld(String bmld) {this.bmld = bmld;}
}费用申请javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//费用申请
public class Feiyong extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//员工
private Long customerId;
//
private String fx;
//详细说明
private String content;
//申请金额
private Integer fee;
//申请编号
private String orderNum;
//状态
private String status;
//回复
private String back;
//申请日期
private Date insertDate;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public String getFx() {return fx;}
public void setFx(String fx) {this.fx = fx;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getOrderNum() {return orderNum;}
public void setOrderNum(String orderNum) {this.orderNum = orderNum;}
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;}
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 Fp extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//员工
private Long customerId;
//
private String fx;
//发票拍照
private String pic;
//说明
private String content;
//申请编号
private String orderNum;
//发票金额
private Integer fee;
//状态
private String status;
//回复
private String back;
//提交日期
private Date insertDate;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long customerId) {this.customerId = customerId;}
public String getFx() {return fx;}
public void setFx(String fx) {this.fx = fx;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getOrderNum() {return orderNum;}
public void setOrderNum(String orderNum) {this.orderNum = orderNum;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
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;}
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 Xiaoxi extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//员工
private Long customerId;
//标题
private String title;
//内容
private String content;
//日期
private Date insertDate;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long 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 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 Xttz 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 Ys extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//员工
private Long customerId;
//预算标题
private String title;
//内容
private String content;
//总金额
private Integer allfee;
//
private String status;
public Long getCustomerId() {return customerId;}
public void setCustomerId(Long 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 Integer getAllfee() {return allfee;}
public void setAllfee(Integer allfee) {this.allfee = allfee;}
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 Yslist extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//预算
private Long ysId;
//金额
private Integer fee;
//操作日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
//用途说明
private String title;
public Long getYsId() {return ysId;}
public void setYsId(Long ysId) {this.ysId = ysId;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
}