- 企业财务系统mysql数据库创建语句
- 企业财务系统oracle数据库创建语句
- 企业财务系统oracle数据库创建语句
- 企业财务系统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');
SQL
Copy
部门通知表创建语句如下:
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 '部门通知';
SQL
Copy
部门表创建语句如下:
create table t_bumen(id int primary key auto_increment comment '主键',bumenName varchar(100) comment '部门'
) comment '部门';
SQL
Copy
差旅申请表创建语句如下:
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 '差旅申请';
SQL
Copy
员工表创建语句如下:
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 '员工';
SQL
Copy
费用申请表创建语句如下:
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 '费用申请';
SQL
Copy
发票提交表创建语句如下:
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 '发票提交';
SQL
Copy
消息表创建语句如下:
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 '消息';
SQL
Copy
系统通知表创建语句如下:
create table t_xttz(id int primary key auto_increment comment '主键',title varchar(100) comment '标题',content varchar(100) comment '内容',insertDate datetime comment '日期'
) comment '系统通知';
SQL
Copy
预算表创建语句如下:
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 '预算';
SQL
Copy
预算详情表创建语句如下:
create table t_yslist(id int primary key auto_increment comment '主键',ysId int comment '预算',fee int comment '金额',showDate datetime comment '操作日期',title text comment '用途说明'
) comment '预算详情';
SQL
Copy
企业财务系统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 '超级管理员';
SQL
Copy
部门通知表创建语句如下:
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 '部门通知';
SQL
Copy
部门表创建语句如下:
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 '部门';
SQL
Copy
差旅申请表创建语句如下:
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 '差旅申请';
SQL
Copy
员工表创建语句如下:
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 '员工';
SQL
Copy
费用申请表创建语句如下:
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 '费用申请';
SQL
Copy
发票提交表创建语句如下:
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 '发票提交';
SQL
Copy
消息表创建语句如下:
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 '消息';
SQL
Copy
系统通知表创建语句如下:
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 '系统通知';
SQL
Copy
预算表创建语句如下:
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 '预算';
SQL
Copy
预算详情表创建语句如下:
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 '预算详情';
SQL
Copy
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;
SQL
Copy
企业财务系统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');
SQL
Copy
部门通知表创建语句如下:
--部门通知表注释
create table t_bmtz(id int identity(1,1) primary key not null,--主键title varchar(100),--标题content varchar(100),--内容insertDate datetime,--日期bumenId int--部门
);
SQL
Copy
部门表创建语句如下:
--部门表注释
create table t_bumen(id int identity(1,1) primary key not null,--主键bumenName varchar(100)--部门
);
SQL
Copy
差旅申请表创建语句如下:
--差旅申请表注释
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--申请日期
);
SQL
Copy
员工表创建语句如下:
--员工表注释
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)--
);
SQL
Copy
费用申请表创建语句如下:
--费用申请表注释
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--申请日期
);
SQL
Copy
发票提交表创建语句如下:
--发票提交表注释
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--提交日期
);
SQL
Copy
消息表创建语句如下:
--消息表注释
create table t_xiaoxi(id int identity(1,1) primary key not null,--主键customerId int,--员工title varchar(100),--标题content varchar(100),--内容insertDate datetime--日期
);
SQL
Copy
系统通知表创建语句如下:
--系统通知表注释
create table t_xttz(id int identity(1,1) primary key not null,--主键title varchar(100),--标题content varchar(100),--内容insertDate datetime--日期
);
SQL
Copy
预算表创建语句如下:
--预算表注释
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)--
);
SQL
Copy
预算详情表创建语句如下:
--预算详情表注释
create table t_yslist(id int identity(1,1) primary key not null,--主键ysId int,--预算fee int,--金额showDate datetime,--操作日期title text--用途说明
);
SQL
Copy
企业财务系统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;}
}
Java
Copy
部门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;}
}
Java
Copy
差旅申请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;}
}
Java
Copy
员工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;}
}
Java
Copy
费用申请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;}
}
Java
Copy
发票提交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;}
}
Java
Copy
消息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;}
}
Java
Copy
系统通知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;}
}
Java
Copy
预算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;}
}
Java
Copy
预算详情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;}
}
Java
Copy
企业财务系统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;}
}
Java
Copy
部门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;}
}
Java
Copy
差旅申请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;}
}
Java
Copy
员工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;}
}
Java
Copy
费用申请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;}
}
Java
Copy
发票提交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;}
}
Java
Copy
消息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;}
}
Java
Copy
系统通知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;}
}
Java
Copy
预算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;}
}
Java
Copy
预算详情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;}
}