项目介绍:主要功能介绍:本系统基于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数据库设计
-- ----------------------------
-- 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;