基于MVC的公司报账系统
基于MVC的公司报账系统mysql数据库创建语句
基于MVC的公司报账系统oracle数据库创建语句
基于MVC的公司报账系统sqlserver数据库创建语句
基于MVC的公司报账系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
基于MVC的公司报账系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
高质量编程视频:shangyepingtai.xin
基于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’);
SQLCopy
报销申请表创建语句如下:
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 ‘报销申请’;
SQLCopy
部门表创建语句如下:
create table t_bm(
id int primary key auto_increment comment ‘主键’,
bmName varchar(100) comment ‘部门名称’
) comment ‘部门’;
SQLCopy
出差申请表创建语句如下:
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 ‘出差申请’;
SQLCopy
差旅费规则说明表创建语句如下:
create table t_clfgz(
id int primary key auto_increment comment ‘主键’,
title varchar(100) comment ‘规则标题’,
content varchar(100) comment ‘规则内容’
) comment ‘差旅费规则说明’;
SQLCopy
员工表创建语句如下:
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 ‘员工’;
SQLCopy
还款申请表创建语句如下:
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 ‘还款申请’;
SQLCopy
借款申请表创建语句如下:
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 ‘借款申请’;
SQLCopy
转账表创建语句如下:
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 ‘转账’;
SQLCopy
基于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 ‘超级管理员’;
SQLCopy
报销申请表创建语句如下:
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 ‘报销申请’;
SQLCopy
部门表创建语句如下:
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 ‘部门’;
SQLCopy
出差申请表创建语句如下:
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 ‘出差申请’;
SQLCopy
差旅费规则说明表创建语句如下:
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 ‘差旅费规则说明’;
SQLCopy
员工表创建语句如下:
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 ‘员工’;
SQLCopy
还款申请表创建语句如下:
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