JavaSwing项目-管家婆记帐软件

第一天任务：

 

启动主界面：

 

 

 

登陆成功提示信息

 

 

进入主界面

 

文件菜单

编辑菜单

查询菜单

查询à图表

选项菜单

选项菜单

 

帮助菜单

表格右键快键菜单

 

第二天任务：

编辑菜单à添加

选择支出

选择“收入”

注意：主界面最好实现自动刷新功能，而不是退出程序再进入才看到效果。

 

第三天任务：

修改

删除

当我们点击删除时，提醒：“你确定要删除吗？”，如果点击了“确定”，则如下提示：

第四天任务

查询à查所有

查询à条件查询à按日期查询

 

查询à条件查询à按分类查询à收入

 

查询à条件查询à按分类查询à支出

 

查询à条件查询à按分类查询à按备注查询

 

 

第五天任务

查询à图表à条形图

查询à图表à条形图

查询à图表à饼图

查询à报告

 

 

 

 

第六天任务

选项à添加分类

选项à用户信息

选项à主题

经典黑

帮助à关于软件

帮助à帮助

转到自己csdn博客

 

第七天任务（高级功能）

文件à导入

文件à导出

文件à备份

文件à恢复

文件à退出

数据库设计

/*
 Navicat Premium Data Transfer

 Source Server         : java95
 Source Server Type    : MySQL
 Source Server Version : 50717
 Source Host           : localhost:3306
 Source Schema         : db_bookkeepingsystem

 Target Server Type    : MySQL
 Target Server Version : 50717
 File Encoding         : 65001

 Date: 23/08/2020 17:45:23
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for tb_classification
-- ----------------------------
DROP TABLE IF EXISTS `tb_classification`;
CREATE TABLE `tb_classification`  (
  `cId` int(11) NOT NULL AUTO_INCREMENT,
  `cName` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `cType` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`cId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_classification
-- ----------------------------
INSERT INTO `tb_classification` VALUES (1, '工资', '收入');
INSERT INTO `tb_classification` VALUES (2, '补贴', '收入');
INSERT INTO `tb_classification` VALUES (3, '奖金', '收入');
INSERT INTO `tb_classification` VALUES (4, '饮食', '支出');
INSERT INTO `tb_classification` VALUES (5, '服饰', '支出');
INSERT INTO `tb_classification` VALUES (6, '交通', '支出');
INSERT INTO `tb_classification` VALUES (7, '旅游', '支出');
INSERT INTO `tb_classification` VALUES (8, '住宿', '支出');
INSERT INTO `tb_classification` VALUES (9, '文娱', '支出');
INSERT INTO `tb_classification` VALUES (10, '生活用品', '支出');
INSERT INTO `tb_classification` VALUES (11, '亲人给予', '收入');
INSERT INTO `tb_classification` VALUES (12, '外借', '支出');
INSERT INTO `tb_classification` VALUES (13, '借还', '收入');
INSERT INTO `tb_classification` VALUES (14, '饭卡', '支出');
INSERT INTO `tb_classification` VALUES (15, '代付', '支出');
INSERT INTO `tb_classification` VALUES (16, '付还', '收入');

-- ----------------------------
-- Table structure for tb_records
-- ----------------------------
DROP TABLE IF EXISTS `tb_records`;
CREATE TABLE `tb_records`  (
  `rId` int(11) NOT NULL AUTO_INCREMENT,
  `uId` int(11) NOT NULL,
  `rType` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `rMoney` float NOT NULL,
  `rClassification` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `rMemo` varchar(3000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `rDate` date NOT NULL,
  PRIMARY KEY (`rId`) USING BTREE,
  INDEX `uId`(`uId`) USING BTREE,
  CONSTRAINT `tb_records_ibfk_1` FOREIGN KEY (`uId`) REFERENCES `tb_users` (`uId`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_records
-- ----------------------------
INSERT INTO `tb_records` VALUES (1, 1, '收入', 300, '借还', '获得奖金300元', '2020-08-12');
INSERT INTO `tb_records` VALUES (2, 1, '支出', 300, '外借', '借给某某某300', '2020-08-13');
INSERT INTO `tb_records` VALUES (3, 1, '支出', 11, '饮食', '食堂晚饭11', '2020-08-13');
INSERT INTO `tb_records` VALUES (4, 1, '支出', 3, '饮食', '早饭', '2020-08-13');
INSERT INTO `tb_records` VALUES (5, 1, '支出', 100, '饭卡', '充饭卡100', '2020-08-14');
INSERT INTO `tb_records` VALUES (6, 1, '支出', 3, '饮食', '早晨一杯粥', '2020-08-15');
INSERT INTO `tb_records` VALUES (7, 1, '支出', 42, '生活用品', '一瓶400毫升的洗发液', '2020-08-15');
INSERT INTO `tb_records` VALUES (8, 1, '支出', 6.5, '饮食', '小零食', '2020-08-15');
INSERT INTO `tb_records` VALUES (9, 1, '支出', 3.5, '饮食', '早饭，一个包子', '2020-08-16');
INSERT INTO `tb_records` VALUES (10, 1, '支出', 15, '外借', '借给某某某15充会员', '2020-11-16');
INSERT INTO `tb_records` VALUES (11, 1, '收入', 10000, '工资', '8月工资', '2020-08-15');
INSERT INTO `tb_records` VALUES (12, 1, '支出', 56, '饮食', '胡胖子', '2020-08-23');

-- ----------------------------
-- Table structure for tb_users
-- ----------------------------
DROP TABLE IF EXISTS `tb_users`;
CREATE TABLE `tb_users`  (
  `uId` int(11) NOT NULL AUTO_INCREMENT,
  `uName` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `uPassword` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `uImagePath` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`uId`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tb_users
-- ----------------------------
INSERT INTO `tb_users` VALUES (1, 'admin', '21232f297a57a5a743894a0e4a801fc3', 'C:\\Users\\Administrator\\Pictures\\tang1.jpg');
INSERT INTO `tb_users` VALUES (18, '张三', 'e10adc3949ba59abbe56e057f20f883e', 'src\\AccountSystem\\images\\panda.png');

SET FOREIGN_KEY_CHECKS = 1;