【Web入门项目源码分享】Java+Jsp

Web入门项目源码分享——记账本

这篇文章分享一个Web项目——记账本，编码语言：Java+Jsp 。
资源链接：https://download.csdn.net/download/zsdoudou/85045310

---

---

前言

分享一个适合入门的Web项目–记账本，这个是女朋友某天一句话，说给她写一个简单的记账本。

---

一、项目介绍

编程语言：Java+Jsp+html。
适合人群：想入门学习Web项目。
能学到什么：JSP+Servlet模式，servlet层中有方法，实现和数据库交互，jsp将注册信息提交给servlet。

二、代码结构图

三、项目效果图

1、登录界面

2、菜单导航

3、用户管理界面

4、记账界面

5、查账界面

表结构

用户表

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `auth` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'user',
  `sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `home` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `info` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `suoyin1`(`id`) USING BTREE COMMENT '使用用户id作为唯一索引'
) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户表' ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;

消费记录表

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for consume
-- ----------------------------
DROP TABLE IF EXISTS `consume`;
CREATE TABLE `consume`  (
  `date` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '消费日期',
  `num` int unsigned NOT NULL COMMENT '当日消费第num笔',
  `people` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '消费人员',
  `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '消费类型，1-瓜果蔬菜、2-鸡鸭鱼肉、3-零食、4-日用品、5-衣物穿搭、6-奶粉钱、7-理发、8-水费、9-电费、10-停车费、11-房租、12-物业费、13-送猪猪礼物、14-孝敬长辈、15-社交费用、16-汽车保养、17-洗车加油',
  `currency` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '消费币种，1-人名币、2-港币、3-葡币',
  `value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '消费金额',
  `mark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注信息',
  PRIMARY KEY (`date`, `num`) USING BTREE,
  UNIQUE INDEX `suoyin1`(`date`, `num`) USING BTREE COMMENT '使用日期和第num笔作为唯一索引'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '消费记录表' ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;

字典表（功能自行开发）

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for directory
-- ----------------------------
DROP TABLE IF EXISTS `directory`;
CREATE TABLE `directory`  (
  `type` varchar(255) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL COMMENT '字典类型',
  `value` varchar(255) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL COMMENT '字典值',
  `info` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '字典值解释',
  `bak1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备用字段1',
  `bak2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备用字段2',
  `bak3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备用字段3',
  INDEX `suoyin1`(`type`) USING BTREE COMMENT '使用类型作为索引'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '字典表' ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;

总结

以上就是今天要分享的内容，本文仅仅简单介绍了一个Web项目，请大家按需下载源码，谢谢。
资源链接：https://download.csdn.net/download/zsdoudou/85045310