- 基于MVC的公司报账系统mysql数据库创建语句
- 基于MVC的公司报账系统oracle数据库创建语句
- 基于MVC的公司报账系统sqlserver数据库创建语句
- 基于MVC的公司报账系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 基于MVC的公司报账系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
基于MVC的公司报账系统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_baoxiao(
id int primary key auto_increment comment '主键',
customerId int comment '员工',
title varchar(100) comment '报销标题',
jkfee int comment '报销金额',
types varchar(100) comment '报销类型',
content varchar(100) comment '报销内容描述',
status varchar(100) comment '状态',
bmback varchar(100) comment '部门回复',
zjlback varchar(100) comment '总经理回复',
cwback varchar(100) comment '财务备注',
insertDate datetime comment '发起日期',
bmDate datetime comment '部门回复日期',
zjlDate datetime comment '总经理回复日期',
cwDate datetime comment '财务审核日期',
qsDate datetime comment '签收日期'
) comment '报销申请';
部门表创建语句如下：
create table t_bm(
id int primary key auto_increment comment '主键',
bmName varchar(100) comment '部门名称'
) comment '部门';
出差申请表创建语句如下：
create table t_chuchai(
id int primary key auto_increment comment '主键',
customerId int comment '员工',
title varchar(100) comment '出差标题',
content varchar(100) comment '内容说明',
status varchar(100) comment '状态',
back varchar(100) comment '回复',
insertDate datetime comment '发起日期',
hfDate datetime comment '回复日期',
isjk varchar(100) comment '是否需要借款'
) comment '出差申请';
差旅费规则说明表创建语句如下：
create table t_clfgz(
id int primary key auto_increment comment '主键',
title varchar(100) comment '规则标题',
content 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 '姓名',
headPic varchar(100) comment '头像',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
js varchar(100) comment '角色',
bmName varchar(100) comment '部门',
fee int comment '金额'
) comment '员工';
还款申请表创建语句如下：
create table t_huankuan(
id int primary key auto_increment comment '主键',
customerId int comment '员工',
title varchar(100) comment '还款标题',
jkfee int comment '借款金额',
content varchar(100) comment '还款内容描述',
status varchar(100) comment '状态',
insertDate datetime comment '发起日期',
cwback1 varchar(100) comment '财务回复',
cwDate datetime comment '财务审核时间',
hkbh varchar(100) comment '汇款编号',
reback datetime comment '汇款时间',
cwdate2 datetime comment '最终确认时间'
) comment '还款申请';
借款申请表创建语句如下：
create table t_jiekuan(
id int primary key auto_increment comment '主键',
customerId int comment '员工',
title varchar(100) comment '借款标题',
jkfee int comment '借款金额',
content varchar(100) comment '借款内容描述',
status varchar(100) comment '状态',
bmback varchar(100) comment '部门回复',
zjlback varchar(100) comment '总经理回复',
cwback varchar(100) comment '财务备注',
insertDate datetime comment '发起日期',
bmDate datetime comment '部门回复日期',
zjlDate datetime comment '总经理回复日期',
cwDate datetime comment '财务审核日期',
qsDate datetime comment '签收日期'
) comment '借款申请';
转账表创建语句如下：
create table t_zhuanzhang(
id int primary key auto_increment comment '主键',
customerId int comment '员工',
zzbh varchar(100) comment '转账编号',
fee int comment '金额',
types varchar(100) comment '操作类型',
insertDate datetime comment '发起日期'
) comment '转账';
基于MVC的公司报账系统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_baoxiao(
id integer,
customerId int,
title varchar(100),
jkfee int,
types varchar(100),
content varchar(100),
status varchar(100),
bmback varchar(100),
zjlback varchar(100),
cwback varchar(100),
insertDate datetime,
bmDate datetime,
zjlDate datetime,
cwDate datetime,
qsDate datetime
);
--报销申请字段加注释
comment on column t_baoxiao.id is '主键';
comment on column t_baoxiao.customerId is '员工';
comment on column t_baoxiao.title is '报销标题';
comment on column t_baoxiao.jkfee is '报销金额';
comment on column t_baoxiao.types is '报销类型';
comment on column t_baoxiao.content is '报销内容描述';
comment on column t_baoxiao.status is '状态';
comment on column t_baoxiao.bmback is '部门回复';
comment on column t_baoxiao.zjlback is '总经理回复';
comment on column t_baoxiao.cwback is '财务备注';
comment on column t_baoxiao.insertDate is '发起日期';
comment on column t_baoxiao.bmDate is '部门回复日期';
comment on column t_baoxiao.zjlDate is '总经理回复日期';
comment on column t_baoxiao.cwDate is '财务审核日期';
comment on column t_baoxiao.qsDate is '签收日期';
--报销申请表加注释
comment on table t_baoxiao is '报销申请';
部门表创建语句如下：
create table t_bm(
id integer,
bmName varchar(100)
);
--部门字段加注释
comment on column t_bm.id is '主键';
comment on column t_bm.bmName is '部门名称';
--部门表加注释
comment on table t_bm is '部门';
出差申请表创建语句如下：
create table t_chuchai(
id integer,
customerId int,
title varchar(100),
content varchar(100),
status varchar(100),
back varchar(100),
insertDate datetime,
hfDate datetime,
isjk varchar(100)
);
--出差申请字段加注释
comment on column t_chuchai.id is '主键';
comment on column t_chuchai.customerId is '员工';
comment on column t_chuchai.title is '出差标题';
comment on column t_chuchai.content is '内容说明';
comment on column t_chuchai.status is '状态';
comment on column t_chuchai.back is '回复';
comment on column t_chuchai.insertDate is '发起日期';
comment on column t_chuchai.hfDate is '回复日期';
comment on column t_chuchai.isjk is '是否需要借款';
--出差申请表加注释
comment on table t_chuchai is '出差申请';
差旅费规则说明表创建语句如下：
create table t_clfgz(
id integer,
title varchar(100),
content varchar(100)
);
--差旅费规则说明字段加注释
comment on column t_clfgz.id is '主键';
comment on column t_clfgz.title is '规则标题';
comment on column t_clfgz.content is '规则内容';
--差旅费规则说明表加注释
comment on table t_clfgz 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),
js varchar(100),
bmName varchar(100),
fee 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.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.js is '角色';
comment on column t_customer.bmName is '部门';
comment on column t_customer.fee is '金额';
--员工表加注释
comment on table t_customer is '员工';
还款申请表创建语句如下：
create table t_huankuan(
id integer,
customerId int,
title varchar(100),
jkfee int,
content varchar(100),
status varchar(100),
insertDate datetime,
cwback1 varchar(100),
cwDate datetime,
hkbh varchar(100),
reback datetime,
cwdate2 datetime
);
--还款申请字段加注释
comment on column t_huankuan.id is '主键';
comment on column t_huankuan.customerId is '员工';
comment on column t_huankuan.title is '还款标题';
comment on column t_huankuan.jkfee is '借款金额';
comment on column t_huankuan.content is '还款内容描述';
comment on column t_huankuan.status is '状态';
comment on column t_huankuan.insertDate is '发起日期';
comment on column t_huankuan.cwback1 is '财务回复';
comment on column t_huankuan.cwDate is '财务审核时间';
comment on column t_huankuan.hkbh is '汇款编号';
comment on column t_huankuan.reback is '汇款时间';
comment on column t_huankuan.cwdate2 is '最终确认时间';
--还款申请表加注释
comment on table t_huankuan is '还款申请';
借款申请表创建语句如下：
create table t_jiekuan(
id integer,
customerId int,
title varchar(100),
jkfee int,
content varchar(100),
status varchar(100),
bmback varchar(100),
zjlback varchar(100),
cwback varchar(100),
insertDate datetime,
bmDate datetime,
zjlDate datetime,
cwDate datetime,
qsDate datetime
);
--借款申请字段加注释
comment on column t_jiekuan.id is '主键';
comment on column t_jiekuan.customerId is '员工';
comment on column t_jiekuan.title is '借款标题';
comment on column t_jiekuan.jkfee is '借款金额';
comment on column t_jiekuan.content is '借款内容描述';
comment on column t_jiekuan.status is '状态';
comment on column t_jiekuan.bmback is '部门回复';
comment on column t_jiekuan.zjlback is '总经理回复';
comment on column t_jiekuan.cwback is '财务备注';
comment on column t_jiekuan.insertDate is '发起日期';
comment on column t_jiekuan.bmDate is '部门回复日期';
comment on column t_jiekuan.zjlDate is '总经理回复日期';
comment on column t_jiekuan.cwDate is '财务审核日期';
comment on column t_jiekuan.qsDate is '签收日期';
--借款申请表加注释
comment on table t_jiekuan is '借款申请';
转账表创建语句如下：
create table t_zhuanzhang(
id integer,
customerId int,
zzbh varchar(100),
fee int,
types varchar(100),
insertDate datetime
);
--转账字段加注释
comment on column t_zhuanzhang.id is '主键';
comment on column t_zhuanzhang.customerId is '员工';
comment on column t_zhuanzhang.zzbh is '转账编号';
comment on column t_zhuanzhang.fee is '金额';
comment on column t_zhuanzhang.types is '操作类型';
comment on column t_zhuanzhang.insertDate is '发起日期';
--转账表加注释
comment on table t_zhuanzhang is '转账';
oracle特有，对应序列如下：
create sequence s_t_baoxiao;
create sequence s_t_bm;
create sequence s_t_chuchai;
create sequence s_t_clfgz;
create sequence s_t_customer;
create sequence s_t_huankuan;
create sequence s_t_jiekuan;
create sequence s_t_zhuanzhang;
基于MVC的公司报账系统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_baoxiao(
id int identity(1,1) primary key not null,--主键
customerId int,--员工
title varchar(100),--报销标题
jkfee int,--报销金额
types varchar(100),--报销类型
content varchar(100),--报销内容描述
status varchar(100),--状态
bmback varchar(100),--部门回复
zjlback varchar(100),--总经理回复
cwback varchar(100),--财务备注
insertDate datetime,--发起日期
bmDate datetime,--部门回复日期
zjlDate datetime,--总经理回复日期
cwDate datetime,--财务审核日期
qsDate datetime--签收日期
);
部门表创建语句如下：
--部门表注释
create table t_bm(
id int identity(1,1) primary key not null,--主键
bmName varchar(100)--部门名称
);
出差申请表创建语句如下：
--出差申请表注释
create table t_chuchai(
id int identity(1,1) primary key not null,--主键
customerId int,--员工
title varchar(100),--出差标题
content varchar(100),--内容说明
status varchar(100),--状态
back varchar(100),--回复
insertDate datetime,--发起日期
hfDate datetime,--回复日期
isjk varchar(100)--是否需要借款
);
差旅费规则说明表创建语句如下：
--差旅费规则说明表注释
create table t_clfgz(
id int identity(1,1) primary key not null,--主键
title varchar(100),--规则标题
content varchar(100)--规则内容
);
员工表创建语句如下：
--员工表注释
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),--性别
js varchar(100),--角色
bmName varchar(100),--部门
fee int--金额
);
还款申请表创建语句如下：
--还款申请表注释
create table t_huankuan(
id int identity(1,1) primary key not null,--主键
customerId int,--员工
title varchar(100),--还款标题
jkfee int,--借款金额
content varchar(100),--还款内容描述
status varchar(100),--状态
insertDate datetime,--发起日期
cwback1 varchar(100),--财务回复
cwDate datetime,--财务审核时间
hkbh varchar(100),--汇款编号
reback datetime,--汇款时间
cwdate2 datetime--最终确认时间
);
借款申请表创建语句如下：
--借款申请表注释
create table t_jiekuan(
id int identity(1,1) primary key not null,--主键
customerId int,--员工
title varchar(100),--借款标题
jkfee int,--借款金额
content varchar(100),--借款内容描述
status varchar(100),--状态
bmback varchar(100),--部门回复
zjlback varchar(100),--总经理回复
cwback varchar(100),--财务备注
insertDate datetime,--发起日期
bmDate datetime,--部门回复日期
zjlDate datetime,--总经理回复日期
cwDate datetime,--财务审核日期
qsDate datetime--签收日期
);
转账表创建语句如下：
--转账表注释
create table t_zhuanzhang(
id int identity(1,1) primary key not null,--主键
customerId int,--员工
zzbh varchar(100),--转账编号
fee int,--金额
types varchar(100),--操作类型
insertDate datetime--发起日期
);
登录后主页.jpg?x-oss-process=style/00001)
基于MVC的公司报账系统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_baoxiao")
public class Baoxiao {
//主键
@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 Integer jkfee;
//报销类型
private String types;
//报销内容描述
private String content;
//状态
private String status;
//部门回复
private String bmback;
//总经理回复
private String zjlback;
//财务备注
private String cwback;
//发起日期
private Date insertDate;
//部门回复日期
private Date bmDate;
//总经理回复日期
private Date zjlDate;
//财务审核日期
private Date cwDate;
//签收日期
private Date qsDate;
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 Integer getJkfee() {return jkfee;}
public void setJkfee(Integer jkfee) {this.jkfee = jkfee;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
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;}
public String getBmback() {return bmback;}
public void setBmback(String bmback) {this.bmback = bmback;}
public String getZjlback() {return zjlback;}
public void setZjlback(String zjlback) {this.zjlback = zjlback;}
public String getCwback() {return cwback;}
public void setCwback(String cwback) {this.cwback = cwback;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Date getBmDate() {return bmDate;}
public void setBmDate(Date bmDate) {this.bmDate = bmDate;}
public Date getZjlDate() {return zjlDate;}
public void setZjlDate(Date zjlDate) {this.zjlDate = zjlDate;}
public Date getCwDate() {return cwDate;}
public void setCwDate(Date cwDate) {this.cwDate = cwDate;}
public Date getQsDate() {return qsDate;}
public void setQsDate(Date qsDate) {this.qsDate = qsDate;}
}部门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_bm")
public class Bm {
//主键
@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 bmName;
public String getBmName() {return bmName;}
public void setBmName(String bmName) {this.bmName = bmName;}
}出差申请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_chuchai")
public class Chuchai {
//主键
@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 status;
//回复
private String back;
//发起日期
private Date insertDate;
//回复日期
private Date hfDate;
//是否需要借款
private String isjk;
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 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;}
public Date getHfDate() {return hfDate;}
public void setHfDate(Date hfDate) {this.hfDate = hfDate;}
public String getIsjk() {return isjk;}
public void setIsjk(String isjk) {this.isjk = isjk;}
}差旅费规则说明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_clfgz")
public class Clfgz {
//主键
@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;
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;}
}员工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 String js;
//部门
private String bmName;
//金额
private Integer fee;
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 String getJs() {return js;}
public void setJs(String js) {this.js = js;}
public String getBmName() {return bmName;}
public void setBmName(String bmName) {this.bmName = bmName;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
}还款申请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_huankuan")
public class Huankuan {
//主键
@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 Integer jkfee;
//还款内容描述
private String content;
//状态
private String status;
//发起日期
private Date insertDate;
//财务回复
private String cwback1;
//财务审核时间
private Date cwDate;
//汇款编号
private String hkbh;
//汇款时间
private Date reback;
//最终确认时间
private Date cwdate2;
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 Integer getJkfee() {return jkfee;}
public void setJkfee(Integer jkfee) {this.jkfee = jkfee;}
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;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getCwback1() {return cwback1;}
public void setCwback1(String cwback1) {this.cwback1 = cwback1;}
public Date getCwDate() {return cwDate;}
public void setCwDate(Date cwDate) {this.cwDate = cwDate;}
public String getHkbh() {return hkbh;}
public void setHkbh(String hkbh) {this.hkbh = hkbh;}
public Date getReback() {return reback;}
public void setReback(Date reback) {this.reback = reback;}
public Date getCwdate2() {return cwdate2;}
public void setCwdate2(Date cwdate2) {this.cwdate2 = cwdate2;}
}借款申请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_jiekuan")
public class Jiekuan {
//主键
@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 Integer jkfee;
//借款内容描述
private String content;
//状态
private String status;
//部门回复
private String bmback;
//总经理回复
private String zjlback;
//财务备注
private String cwback;
//发起日期
private Date insertDate;
//部门回复日期
private Date bmDate;
//总经理回复日期
private Date zjlDate;
//财务审核日期
private Date cwDate;
//签收日期
private Date qsDate;
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 Integer getJkfee() {return jkfee;}
public void setJkfee(Integer jkfee) {this.jkfee = jkfee;}
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;}
public String getBmback() {return bmback;}
public void setBmback(String bmback) {this.bmback = bmback;}
public String getZjlback() {return zjlback;}
public void setZjlback(String zjlback) {this.zjlback = zjlback;}
public String getCwback() {return cwback;}
public void setCwback(String cwback) {this.cwback = cwback;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Date getBmDate() {return bmDate;}
public void setBmDate(Date bmDate) {this.bmDate = bmDate;}
public Date getZjlDate() {return zjlDate;}
public void setZjlDate(Date zjlDate) {this.zjlDate = zjlDate;}
public Date getCwDate() {return cwDate;}
public void setCwDate(Date cwDate) {this.cwDate = cwDate;}
public Date getQsDate() {return qsDate;}
public void setQsDate(Date qsDate) {this.qsDate = qsDate;}
}转账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_zhuanzhang")
public class Zhuanzhang {
//主键
@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 zzbh;
//金额
private Integer fee;
//操作类型
private String types;
//发起日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getZzbh() {return zzbh;}
public void setZzbh(String zzbh) {this.zzbh = zzbh;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}基于MVC的公司报账系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
报销申请javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//报销申请
public class Baoxiao 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 Integer jkfee;
//报销类型
private String types;
//报销内容描述
private String content;
//状态
private String status;
//部门回复
private String bmback;
//总经理回复
private String zjlback;
//财务备注
private String cwback;
//发起日期
private Date insertDate;
//部门回复日期
private Date bmDate;
//总经理回复日期
private Date zjlDate;
//财务审核日期
private Date cwDate;
//签收日期
private Date qsDate;
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 Integer getJkfee() {return jkfee;}
public void setJkfee(Integer jkfee) {this.jkfee = jkfee;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
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;}
public String getBmback() {return bmback;}
public void setBmback(String bmback) {this.bmback = bmback;}
public String getZjlback() {return zjlback;}
public void setZjlback(String zjlback) {this.zjlback = zjlback;}
public String getCwback() {return cwback;}
public void setCwback(String cwback) {this.cwback = cwback;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Date getBmDate() {return bmDate;}
public void setBmDate(Date bmDate) {this.bmDate = bmDate;}
public Date getZjlDate() {return zjlDate;}
public void setZjlDate(Date zjlDate) {this.zjlDate = zjlDate;}
public Date getCwDate() {return cwDate;}
public void setCwDate(Date cwDate) {this.cwDate = cwDate;}
public Date getQsDate() {return qsDate;}
public void setQsDate(Date qsDate) {this.qsDate = qsDate;}
}部门javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//部门
public class Bm extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//部门名称
private String bmName;
public String getBmName() {return bmName;}
public void setBmName(String bmName) {this.bmName = bmName;}
}出差申请javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//出差申请
public class Chuchai 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 status;
//回复
private String back;
//发起日期
private Date insertDate;
//回复日期
private Date hfDate;
//是否需要借款
private String isjk;
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 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;}
public Date getHfDate() {return hfDate;}
public void setHfDate(Date hfDate) {this.hfDate = hfDate;}
public String getIsjk() {return isjk;}
public void setIsjk(String isjk) {this.isjk = isjk;}
}差旅费规则说明javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//差旅费规则说明
public class Clfgz extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//规则标题
private String title;
//规则内容
private String content;
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;}
}员工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 String js;
//部门
private String bmName;
//金额
private Integer fee;
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 String getJs() {return js;}
public void setJs(String js) {this.js = js;}
public String getBmName() {return bmName;}
public void setBmName(String bmName) {this.bmName = bmName;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
}还款申请javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//还款申请
public class Huankuan 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 Integer jkfee;
//还款内容描述
private String content;
//状态
private String status;
//发起日期
private Date insertDate;
//财务回复
private String cwback1;
//财务审核时间
private Date cwDate;
//汇款编号
private String hkbh;
//汇款时间
private Date reback;
//最终确认时间
private Date cwdate2;
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 Integer getJkfee() {return jkfee;}
public void setJkfee(Integer jkfee) {this.jkfee = jkfee;}
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;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getCwback1() {return cwback1;}
public void setCwback1(String cwback1) {this.cwback1 = cwback1;}
public Date getCwDate() {return cwDate;}
public void setCwDate(Date cwDate) {this.cwDate = cwDate;}
public String getHkbh() {return hkbh;}
public void setHkbh(String hkbh) {this.hkbh = hkbh;}
public Date getReback() {return reback;}
public void setReback(Date reback) {this.reback = reback;}
public Date getCwdate2() {return cwdate2;}
public void setCwdate2(Date cwdate2) {this.cwdate2 = cwdate2;}
}借款申请javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//借款申请
public class Jiekuan 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 Integer jkfee;
//借款内容描述
private String content;
//状态
private String status;
//部门回复
private String bmback;
//总经理回复
private String zjlback;
//财务备注
private String cwback;
//发起日期
private Date insertDate;
//部门回复日期
private Date bmDate;
//总经理回复日期
private Date zjlDate;
//财务审核日期
private Date cwDate;
//签收日期
private Date qsDate;
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 Integer getJkfee() {return jkfee;}
public void setJkfee(Integer jkfee) {this.jkfee = jkfee;}
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;}
public String getBmback() {return bmback;}
public void setBmback(String bmback) {this.bmback = bmback;}
public String getZjlback() {return zjlback;}
public void setZjlback(String zjlback) {this.zjlback = zjlback;}
public String getCwback() {return cwback;}
public void setCwback(String cwback) {this.cwback = cwback;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Date getBmDate() {return bmDate;}
public void setBmDate(Date bmDate) {this.bmDate = bmDate;}
public Date getZjlDate() {return zjlDate;}
public void setZjlDate(Date zjlDate) {this.zjlDate = zjlDate;}
public Date getCwDate() {return cwDate;}
public void setCwDate(Date cwDate) {this.cwDate = cwDate;}
public Date getQsDate() {return qsDate;}
public void setQsDate(Date qsDate) {this.qsDate = qsDate;}
}转账javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//转账
public class Zhuanzhang extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//员工
private Integer customerId;
//转账编号
private String zzbh;
//金额
private Integer fee;
//操作类型
private String types;
//发起日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getZzbh() {return zzbh;}
public void setZzbh(String zzbh) {this.zzbh = zzbh;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}