介绍:
eclipse开发工具,mysql数据库,jsp技术,servlet技术
项目截图:
数据库表:
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等编著’);