【原创】基于JavaWeb的网上银行管理系统(Jsp银行管理系统)

  项目介绍:主要功能介绍:本系统基于Java语言开发。在开发的时候,使用JavaWeb实现。将银行账务的工作作为核心业务。本系统实现了银行的各种账户管理业务,如用户办理银行卡、银行卡办理审核、账户余额充值、账户余额取款、不同银行卡转账等。对于相关的数据,通过MySQL存储。

项目类型:SSM源码 

用户类型:2个角色(管理员+用户)

主要技术:Jsp+Servlet+MySQL

开发工具:Eclipse/Idea均可使用,有两个不同的版本

数据库:MySQL

数据库表:8张

🍅演示视频在底部🍅

🍅文末获取联系🍅

目录

01管理员端

1.0用户管理

1.1银行卡类型管理

1.2银行新闻管理

1.3银行卡办理审核

1.4取款管理模块

1.5存款管理模块

1.6转账管理模块

02用户端

2.1银行卡办理

2.2存款模块

2.3取款模块

2.4转账模块

2.5个人资料修改

03项目结构

04数据库设计


01管理员端

1.0用户管理

1.1银行卡类型管理

1.2银行新闻管理

1.3银行卡办理审核

1.4取款管理模块

1.5存款管理模块

1.6转账管理模块

02用户端

2.1银行卡办理

2.2存款模块

2.3取款模块

2.4转账模块

2.5个人资料修改

03项目结构

04数据库设计



-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `nickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES (1, '1', '泰迪', '1');

-- ----------------------------
-- Table structure for fuwu
-- ----------------------------
DROP TABLE IF EXISTS `fuwu`;
CREATE TABLE `fuwu`  (
  `id` int(22) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `gid` int(22) DEFAULT NULL COMMENT '银行卡类型',
  `uname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '姓名',
  `sex` varchar(2552) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '性别',
  `nation` varchar(102) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '',
  `birth` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '生日',
  `idcard` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '身份证',
  `place` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '',
  `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '户籍地',
  `youb` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '邮编',
  `tel` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '手机号',
  `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '座机号',
  `money` double(255, 2) DEFAULT NULL COMMENT '预充金额',
  `ctime` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '',
  `state` int(255) DEFAULT NULL COMMENT '办卡状态',
  `rno` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '',
  `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '',
  `uid` int(11) NOT NULL COMMENT '用户id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of fuwu
-- ----------------------------
INSERT INTO `fuwu` VALUES (3, 1, '张飞2222', '否', '中国', '2', '18020154120', '只是', '北京', '18020154120', '18020154120', '18020154120', 100.00, '2023-03-21 13:53', 1, '546120230321133937', '1e6fd9a7-cb5a-4dee-ae16-6c54a5645dd2.jpg', 13);
INSERT INTO `fuwu` VALUES (5, 1, '张三帅', '女', '中国', '1998-05-21', '320481199805055555', '江苏', '南京', '210000', '18888888888', '88888888', 7978.00, '2023-12-06 23:35', 1, '455920231206233645', '36431e2e-764c-43b0-b87e-10b74f7a9f3d.jpg', 8);
INSERT INTO `fuwu` VALUES (6, 4, '张三帅', '女', '中国', '1998-05-21', '320320320320320321', '江苏', '南京', '210000', '18888888882', '88888881', 1211.00, '2023-12-06 23:37', 1, '348220231206233943', 'b0f0031b-fa84-4a4c-81bc-0f0c4b76b908.jpg', 8);

-- ----------------------------
-- Table structure for goods
-- ----------------------------
DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '客片id',
  `names` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '客片名称',
  `times` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '发布时间',
  `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '客片图片',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of goods
-- ----------------------------
INSERT INTO `goods` VALUES (1, '储蓄卡', '2023-02-01 19:34', '7b7f098e-d3e2-42ac-a390-0380e481bda5.jpg');
INSERT INTO `goods` VALUES (3, '贷记卡', '2023-02-01 19:34', '8baca89f-75ab-4ab0-a1df-59b9fdb17d59.jpg');
INSERT INTO `goods` VALUES (4, '联名卡', '2023-02-01 19:34', '1e6fd9a7-cb5a-4dee-ae16-6c54a5645dd2.jpg');

-- ----------------------------
-- Table structure for news
-- ----------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '资讯id',
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '标题',
  `detail` varchar(2552) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '介绍',
  `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '图片',
  `times` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '发布时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;



-- ----------------------------
-- Table structure for orders
-- ----------------------------
DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders`  (
  `id` int(255) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `uid` int(11) DEFAULT NULL COMMENT '用户id',
  `fid` int(11) DEFAULT NULL COMMENT '',
  `ordernum` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '号',
  `stime` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '时间',
  `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '备注',
  `money` double(255, 2) DEFAULT NULL COMMENT '',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of orders
-- ----------------------------
INSERT INTO `orders` VALUES (11, 8, 5, '20231206234757547', '2023-12-06 23:47', '20', 100.00);
INSERT INTO `orders` VALUES (12, 8, 5, '20231206234809633', '2023-12-06 23:48', '1', 100.00);
INSERT INTO `orders` VALUES (13, 8, 5, '20231206235114735', '2023-12-06 23:51', '', 11111.00);

-- ----------------------------
-- Table structure for records
-- ----------------------------
DROP TABLE IF EXISTS `records`;
CREATE TABLE `records`  (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT NULL,
  `fid` int(11) DEFAULT NULL,
  `ordernum` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `stime` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `money` double(11, 0) DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of records
-- ----------------------------
INSERT INTO `records` VALUES (6, 8, 3, '20230321140627284', '2023-03-21 14:06', '2', 22);
INSERT INTO `records` VALUES (7, 8, 3, '20230321140642275', '2023-03-21 14:06', '123', 123);
INSERT INTO `records` VALUES (8, 8, 3, '20230405155626801', '2023-04-05 15:56', '99', 99999);
INSERT INTO `records` VALUES (9, 8, 3, '20230405155640541', '2023-04-05 15:56', '取款2', 2);
INSERT INTO `records` VALUES (10, 8, 3, '20230405155700938', '2023-04-05 15:57', '9', 9999);
INSERT INTO `records` VALUES (11, 8, 5, '20231206234826428', '2023-12-06 23:48', '100', 100);
INSERT INTO `records` VALUES (12, 8, 5, '20231206234836759', '2023-12-06 23:48', '1111', 1111);
INSERT INTO `records` VALUES (13, 8, 5, '20231206235129557', '2023-12-06 23:51', '11', 1111);

-- ----------------------------
-- Table structure for transfers
-- ----------------------------
DROP TABLE IF EXISTS `transfers`;
CREATE TABLE `transfers`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT NULL,
  `firstfid` int(11) DEFAULT NULL,
  `secondfid` int(11) DEFAULT NULL,
  `money` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `stime` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `ordernum` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of transfers
-- ----------------------------
INSERT INTO `transfers` VALUES (2, 8, 3, 5, '50.0', '2023-03-21 14:45', '50', '20230321144500782');
INSERT INTO `transfers` VALUES (3, 8, 5, 6, '1111.0', '2023-12-06 23:51', '111111', '20231206235156471');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户id',
  `realname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '姓名',
  `pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '密码',
  `sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '性别',
  `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '手机',
  `times` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '注册时间',
  `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '头像',
  `money` double(255, 2) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (8, '陈德修', '1', '女', '1', '2023-02-01 19:34', 'a753d7e7-fa1f-4f44-9e57-c2d547887aa3.jpg', 0.00);
INSERT INTO `user` VALUES (9, '吴亚麟', '1', '男', '18020154121', '2023-02-01 19:34', '38e971b8-a704-4e81-a610-0cab1f124d61.png', 0.00);
INSERT INTO `user` VALUES (10, '张飞', '1', '男', '18020224121', '2023-02-01 19:34', '4aa63401-3f39-4171-a2f0-50b648192f56.jpg', 0.00);
INSERT INTO `user` VALUES (11, '陈宫', '0', '男', '18020254121', '2023-02-01 19:34', 'fcf9c518-24d6-4a6b-81d9-bfe616d2503a.jpg', 0.00);
INSERT INTO `user` VALUES (12, '吕布', '22', '男', '18030154121', '2023-02-01 19:34', 'c80676ca-3f96-4bff-9234-fcfc400d5c26.jpg', 0.00);

SET FOREIGN_KEY_CHECKS = 1;

评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

那条学长V

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值