084基于javaweb的财务管理系统（Mysql版）

技术：ssh+java+mysql+eclipse
截图：






数据库表：
CREATE TABLE billforin (
id varchar(36) NOT NULL COMMENT ‘ID’,
date double DEFAULT NULL COMMENT ‘入账日期’,
amount double DEFAULT NULL COMMENT ‘金额’,
fromId varchar(36) DEFAULT NULL COMMENT ‘经手人ID’,
toId varchar(36) DEFAULT NULL COMMENT ‘接受人ID’,
recordId varchar(36) DEFAULT NULL COMMENT ‘记录人ID’,
createDate double DEFAULT NULL COMMENT ‘记录日期’,
remark varchar(255) DEFAULT NULL COMMENT ‘备注’,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

---

– Records of billforin

---

INSERT INTO billforin VALUES (‘a0af7a53-f8dc-4882-add9-cf8debcd9f63’, ‘20190612’, ‘43’, ‘d30836a3-3dc0-4d67-9715-dcecbd27b4b6’, ‘e4afd70a-90cc-4471-92ae-e5fb360223e8’, ‘e4afd70a-90cc-4471-92ae-e5fb360223e8’, ‘20190612’, ‘34’);
INSERT INTO billforin VALUES (‘e1c66766-2310-49eb-b194-a38002c2be44’, ‘20190612’, ‘4323’, ‘d30836a3-3dc0-4d67-9715-dcecbd27b4b6’, ‘d30836a3-3dc0-4d67-9715-dcecbd27b4b6’, ‘e4afd70a-90cc-4471-92ae-e5fb360223e8’, ‘20190612’, ‘导游基础知识，有两部同名书籍。一本是《导游基础知识（第4版）》，认真总结了我国导游工作的经验，注重知识的全面性、权威性与实用性，既是导游人员资格考试（全国部分）的培训教材，也适用于各旅游院校导游专业的师生使用。另一本《导游基础》与浙江省级精品课程建设紧密’);

---

– Table structure for billforout

---

DROP TABLE IF EXISTS billforout;
CREATE TABLE billforout (
id varchar(36) NOT NULL COMMENT ‘ID’,
date double DEFAULT NULL COMMENT ‘支付日期’,
event varchar(255) DEFAULT NULL COMMENT ‘事项’,
amount double DEFAULT NULL COMMENT ‘金额’,
payId varchar(36) DEFAULT NULL COMMENT ‘支付人ID’,
status int(11) DEFAULT NULL COMMENT ‘状态（0:未支付 1:已支付 2:待审核 3:不通过）’,
recordId varchar(36) DEFAULT NULL COMMENT ‘记录人ID’,
createDate double DEFAULT NULL COMMENT ‘记录日期’,
remark varchar(255) DEFAULT NULL COMMENT ‘备注’,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

---

– Records of billforout

---

INSERT INTO billforout VALUES (‘af6ebc19-29aa-4cc1-a27c-890e31d14a67’, ‘20190612’, ‘工资支出’, ‘411’, ‘e4afd70a-90cc-4471-92ae-e5fb360223e8’, ‘2’, ‘d30836a3-3dc0-4d67-9715-dcecbd27b4b6’, ‘20190612’, ‘12’);
INSERT INTO billforout VALUES (‘b4c099c9-398c-435f-9694-a769b13c0006’, ‘20190612’, ‘团建开支’, ‘4111’, ‘e4afd70a-90cc-4471-92ae-e5fb360223e8’, ‘1’, ‘e4afd70a-90cc-4471-92ae-e5fb360223e8’, ‘20190612’, ‘出游’);
INSERT INTO billforout VALUES (‘ddaadf2d-43ce-4cd1-acf2-52ca9b9e22ce’, ‘20190612’, ‘支出’, ‘411’, ‘d30836a3-3dc0-4d67-9715-dcecbd27b4b6’, ‘0’, ‘e4afd70a-90cc-4471-92ae-e5fb360223e8’, ‘20190612’, ‘Java领域*有影响力和价值的著作之一，与《Java编程思想》齐名，10余年优选畅销不衰，广受好评 　　根据Java SE 8全面更新，系统全面讲解Java语言的核心概念、语法、重要特性和开发方法，包含大量案例，实践性强CayS.Horstmann等编著’);

---

– Table structure for menu

---

DROP TABLE IF EXISTS menu;
CREATE TABLE menu (
menuId varchar(36) NOT NULL,
name varchar(255) DEFAULT NULL,
url varchar(255) DEFAULT NULL,
href varchar(255) DEFAULT NULL,
no int(11) DEFAULT NULL,
roleId int(11) DEFAULT NULL,
PRIMARY KEY (menuId)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

---

– Records of menu

---

INSERT INTO menu VALUES (‘001’, ‘首页’, ‘/’, ‘’, ‘1’, ‘0’);
INSERT INTO menu VALUES (‘002’, ‘用户管理’, ‘/view/user.html’, ‘user’, ‘2’, ‘0’);
INSERT INTO menu VALUES (‘003’, ‘入账管理’, ‘/view/billforin.html’, ‘billforin’, ‘3’, ‘0’);
INSERT INTO menu VALUES (‘004’, ‘支出管理’, ‘/view/billforout.html’, ‘billforout’, ‘4’, ‘0’);
INSERT INTO menu VALUES (‘005’, ‘报账记录’, ‘/view/apply.html’, ‘apply’, ‘5’, ‘0’);
INSERT INTO menu VALUES (‘006’, ‘报账审核’, ‘/view/review.html’, ‘review’, ‘6’, ‘0’);
INSERT INTO menu VALUES (‘007’, ‘支付管理’, ‘/view/pay.html’, ‘pay’, ‘7’, ‘0’);
INSERT INTO menu VALUES (‘008’, ‘关于’, ‘/view/about.html’, ‘about’, ‘8’, ‘0’);
INSERT INTO menu VALUES (‘101’, ‘首页’, ‘/’, ‘’, ‘1’, ‘1’);
INSERT INTO menu VALUES (‘102’, ‘用户管理’, ‘/view/user.html’, ‘user’, ‘2’, ‘1’);
INSERT INTO menu VALUES (‘103’, ‘入账管理’, ‘/view/billforin.html’, ‘billforin’, ‘3’, ‘1’);
INSERT INTO menu VALUES (‘104’, ‘支出管理’, ‘/view/billforout.html’, ‘billforout’, ‘4’, ‘1’);
INSERT INTO menu VALUES (‘105’, ‘报账记录’, ‘/view/apply.html’, ‘apply’, ‘5’, ‘1’);
INSERT INTO menu VALUES (‘108’, ‘关于’, ‘/view/about.html’, ‘about’, ‘8’, ‘1’);
INSERT INTO menu VALUES (‘201’, ‘首页’, ‘/’, ‘’, ‘1’, ‘2’);
INSERT INTO menu VALUES (‘205’, ‘报账记录’, ‘/view/apply.html’, ‘apply’, ‘5’, ‘2’);
INSERT INTO menu VALUES (‘208’, ‘关于’, ‘/view/about.html’, ‘about’, ‘8’, ‘2’);

---

– Table structure for message

---

DROP TABLE IF EXISTS message;
CREATE TABLE message (
id varchar(36) NOT NULL,
type varchar(1) DEFAULT NULL,
content varchar(255) DEFAULT NULL,
createTime double DEFAULT NULL,
userId varchar(36) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

---

– Records of message

---

INSERT INTO message VALUES (‘19675568-3f75-41d4-a4fa-717a9890a30e’, ‘1’, ‘尊敬的黄则鸣，欢迎您使用本系统’, ‘20160507211445’, ‘d30836a3-3dc0-4d67-9715-dcecbd27b4b6’);
INSERT INTO message VALUES (‘67cb67d3-f3db-4cfe-b527-987d447edd6f’, ‘1’, ‘尊敬的张三，欢迎您使用本系统’, ‘20190612113131’, ‘d30836a3-3dc0-4d67-9715-dcecbd27b4b6’);
INSERT INTO message VALUES (‘74dcf2b8-befa-44d9-aa8b-eebeb0a2ef3e’, ‘1’, ‘尊敬的zhangmaowen，欢迎您使用本系统’, ‘20190612120405’, ‘fecb1087-fe06-4976-8f30-24663f666db9’);
INSERT INTO message VALUES (‘8d2a52c9-5140-4e1e-ac96-3e23ba762496’, ‘2’, ‘超级管理员报账，等待您的审核’, ‘20190612113722’, ‘e4afd70a-90cc-4471-92ae-e5fb360223e8’);
INSERT INTO message VALUES (‘c2acb118-4baa-478b-aebb-cc58c89b3b0c’, ‘1’, ‘尊敬的张三12，欢迎您使用本系统’, ‘20190612120335’, ‘d30836a3-3dc0-4d67-9715-dcecbd27b4b6’);
INSERT INTO message VALUES (‘c3be29a9-c9f0-4877-bfee-587b330853fc’, ‘1’, ‘您在2019/06/12提交的报账申请经超级管理员审核已通过’, ‘20190612120552’, ‘e4afd70a-90cc-4471-92ae-e5fb360223e8’);
INSERT INTO message VALUES (‘ece7d804-c003-461c-aa72-821fc74e7664’, ‘2’, ‘超级管理员报账，等待您的审核’, ‘20190612120541’, ‘e4afd70a-90cc-4471-92ae-e5fb360223e8’);

---

– Table structure for page

---

DROP TABLE IF EXISTS page;
CREATE TABLE page (
pageId varchar(36) NOT NULL COMMENT ‘ID’,
page varchar(255) DEFAULT NULL COMMENT ‘网页路径’,
roleId int(11) DEFAULT NULL COMMENT ‘角色ID’,
PRIMARY KEY (pageId)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

---

– Records of page

---

INSERT INTO page VALUES (‘1’, ‘/main.html’, ‘0’);
INSERT INTO page VALUES (‘10’, ‘/view/welcome.html’, ‘0’);
INSERT INTO page VALUES (‘11’, ‘/view/welcome.html’, ‘1’);
INSERT INTO page VALUES (‘12’, ‘/view/welcome.html’, ‘2’);
INSERT INTO page VALUES (‘13’, ‘/view/apply.html’, ‘0’);
INSERT INTO page VALUES (‘14’, ‘/view/apply.html’, ‘1’);
INSERT INTO page VALUES (‘15’, ‘/view/apply.html’, ‘2’);
INSERT INTO page VALUES (‘16’, ‘/view/review.html’, ‘0’);
INSERT INTO page VALUES (‘17’, ‘/view/pay.html’, ‘0’);
INSERT INTO page VALUES (‘2’, ‘/main.html’, ‘1’);
INSERT INTO page VALUES (‘3’, ‘/main.html’, ‘2’);
INSERT INTO page VALUES (‘4’, ‘/view/user.html’, ‘0’);
INSERT INTO page VALUES (‘5’, ‘/view/user.html’, ‘1’);
INSERT INTO page VALUES (‘6’, ‘/view/billforin.html’, ‘0’);
INSERT INTO page VALUES (‘7’, ‘/view/billforin.html’, ‘1’);
INSERT INTO page VALUES (‘8’, ‘/view/billforout.html’, ‘0’);
INSERT INTO page VALUES (‘9’, ‘/view/billforout.html’, ‘1’);