计算机毕业设计java银行储蓄业务管理系统

最新推荐文章于 2023-10-22 08:45:00 发布

QQ_188083800

最新推荐文章于 2023-10-22 08:45:00 发布

阅读量225

点赞数

文章标签： java 课程设计数据库

本文链接：https://blog.csdn.net/QQ_188083800/article/details/130537661

版权

银行管理系统安徽师范大学皖江学院
开发工具(eclipse/idea/vscode等)：
数据库(sqlite/mysql/sqlserver等)：
功能模块(请用文字描述，至少200字)：

/*
Navicat MySQL Data Transfer

Source Server : test
Source Server Version : 50722
Source Host : localhost:3306
Source Database : db_bdm101yinghangxt

Target Server Type : MYSQL
Target Server Version : 50722
File Encoding : 65001

Date: 2021-01-21 18:07:37
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `t_admin`
-- ----------------------------
DROP TABLE IF EXISTS `t_admin`;
CREATE TABLE `t_admin` (
`adminId` int(11) NOT NULL AUTO_INCREMENT,
`adminName` varchar(255) DEFAULT NULL,
`adminPassword` varchar(255) DEFAULT NULL,
PRIMARY KEY (`adminId`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

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

-- ----------------------------
-- Table structure for `t_jcbiaoti`
-- ----------------------------
DROP TABLE IF EXISTS `t_jcbiaoti`;
CREATE TABLE `t_jcbiaoti` (
`jcbiaotiId` int(11) NOT NULL AUTO_INCREMENT,
`jcbiaotiName` varchar(255) DEFAULT NULL COMMENT '汉字',
`jcbiaotiNeirong` varchar(255) DEFAULT NULL COMMENT 'url',
`jcbiaotiMark` varchar(255) DEFAULT NULL,
`jcbiaotiMark1` varchar(255) DEFAULT NULL,
`jcbiaotiMark2` varchar(255) DEFAULT NULL,
`jcbiaotiPaixu` int(11) DEFAULT NULL,
`jcbiaotiType` int(11) DEFAULT NULL COMMENT '0网页导航1admin导航2user导航3yonghu导航4juese导航',
`jcbiaotiType1` int(11) DEFAULT NULL,
`jcbiaotiType2` int(11) DEFAULT NULL,
PRIMARY KEY (`jcbiaotiId`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_jcbiaoti
-- ----------------------------
INSERT INTO `t_jcbiaoti` VALUES ('1', '取款信息', null, null, null, null, '4', '1', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('2', '用户信息', null, null, null, null, '2', '1', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('3', '账户信息', null, null, null, null, '3', '1', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('4', '存款信息', null, null, null, null, '4', '1', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('5', '转账信息', null, null, null, null, '5', '1', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('6', '贷款信息', null, null, null, null, '6', '1', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('7', '取款信息', null, null, null, null, '4', '2', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('8', '个人消息', null, null, null, null, '2', '2', '1', null);
INSERT INTO `t_jcbiaoti` VALUES ('9', '账户信息', null, null, null, null, '3', '2', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('10', '存款信息', null, null, null, null, '4', '2', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('11', '转账信息', null, null, null, null, '5', '2', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('12', '贷款信息', null, null, null, null, '6', '2', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('13', '理财信息', null, null, null, null, '7', '1', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('14', '理财信息', null, null, null, null, '7', '2', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('15', '统计信息', null, null, null, null, '8', '1', '0', null);
INSERT INTO `t_jcbiaoti` VALUES ('16', '统计信息', null, null, null, null, '8', '2', '1', null);

-- ----------------------------
-- Table structure for `t_jcdaohang`
-- ----------------------------
DROP TABLE IF EXISTS `t_jcdaohang`;
CREATE TABLE `t_jcdaohang` (
`jcdaohangId` int(11) NOT NULL AUTO_INCREMENT,
`jcdaohangName` varchar(255) DEFAULT NULL COMMENT '汉字',
`jcdaohangNeirong` varchar(255) DEFAULT NULL COMMENT 'url',
`jcdaohangMark` varchar(255) DEFAULT NULL,
`jcdaohangMark1` varchar(255) DEFAULT NULL,
`jcdaohangMark2` varchar(255) DEFAULT NULL,
`jcdaohangPaixu` int(11) DEFAULT NULL,
`jcdaohangType` int(11) DEFAULT NULL COMMENT '0网页导航1admin导航2user导航3yonghu导航4juese导航',
`jcdaohangType1` int(11) DEFAULT NULL,
`jcdaohangType2` int(11) DEFAULT NULL,
`jcbiaotiId` int(11) DEFAULT NULL,
`jcbiaotiName` varchar(255) DEFAULT NULL,
PRIMARY KEY (`jcdaohangId`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_jcdaohang
-- ----------------------------
INSERT INTO `t_jcdaohang` VALUES ('1', '取款信息', 'sjpinglun.jsp', null, null, null, '1', '1', '0', null, '1', '公告信息');
INSERT INTO `t_jcdaohang` VALUES ('3', '用户信息', 'user.jsp', null, null, null, '1', '1', '0', null, '2', '用户信息');
INSERT INTO `t_jcdaohang` VALUES ('6', '用户意见', 'uyijian.jsp', null, null, null, '4', '1', '1', null, '2', '用户信息');
INSERT INTO `t_jcdaohang` VALUES ('7', '账户类型', 'sjleixing.jsp', '', '', '', '1', '1', '0', null, '3', '账户信息');
INSERT INTO `t_jcdaohang` VALUES ('8', '账户信息', 'shuju.jsp', '', '', '', '2', '1', '0', null, '3', '账户信息');
INSERT INTO `t_jcdaohang` VALUES ('9', '存款类型', 'sjlaiyuan.jsp', '', '', '', '1', '1', '1', null, '4', '存款信息');
INSERT INTO `t_jcdaohang` VALUES ('10', '存款信息', 'sjduochu.jsp', '', '', '', '2', '1', '0', null, '4', '存款信息');
INSERT INTO `t_jcdaohang` VALUES ('11', '转账类型', 'sjqita.jsp', '', '', '', '1', '1', '1', null, '5', '转账信息');
INSERT INTO `t_jcdaohang` VALUES ('12', '转账信息', 'sjshaochu.jsp', '', '', '', '2', '1', '0', null, '5', '转账信息');
INSERT INTO `t_jcdaohang` VALUES ('13', '贷款类型', 'sjxingtai.jsp', '', '', '', '1', '1', '0', null, '6', '贷款信息');
INSERT INTO `t_jcdaohang` VALUES ('14', '贷款信息', 'sjjianchu.jsp', '', '', '', '2', '1', '0', null, '6', '贷款信息');
INSERT INTO `t_jcdaohang` VALUES ('15', '取款信息', 'sjpinglun.jsp', null, null, null, '1', '2', '0', null, '7', '公告信息');
INSERT INTO `t_jcdaohang` VALUES ('17', '意见信息', 'uyijian.jsp', null, null, null, '2', '2', '1', null, '8', '个人消息');
INSERT INTO `t_jcdaohang` VALUES ('19', '账户信息', 'shuju.jsp', null, null, null, '2', '2', '0', null, '9', '账户信息');
INSERT INTO `t_jcdaohang` VALUES ('21', '存款信息', 'sjduochu.jsp', null, null, null, '2', '2', '0', null, '10', '存款信息');
INSERT INTO `t_jcdaohang` VALUES ('23', '转账信息', 'sjshaochu.jsp', null, null, null, '2', '2', '0', null, '11', '转账信息');
INSERT INTO `t_jcdaohang` VALUES ('24', '贷款类型', 'sjxingtai.jsp', null, null, null, '1', '2', '0', null, '12', '贷款信息');
INSERT INTO `t_jcdaohang` VALUES ('25', '贷款信息', 'sjjianchu.jsp', null, null, null, '2', '2', '0', null, '12', '贷款信息');
INSERT INTO `t_jcdaohang` VALUES ('26', '理财类型', 'uxtype.jsp', null, null, null, '1', '1', '0', null, '13', '理财信息');
INSERT INTO `t_jcdaohang` VALUES ('27', '理财信息', 'uxinxi.jsp', null, null, null, '2', '1', '0', null, '13', '理财信息');
INSERT INTO `t_jcdaohang` VALUES ('28', '理财信息', 'uxinxi.jsp', null, null, null, '2', '2', '0', null, '14', '理财信息');
INSERT INTO `t_jcdaohang` VALUES ('29', '账户统计', 'bingzhuangtu.jsp?tijiaoUrl=shujuTongji', null, null, null, '1', '1', '0', null, '15', '统计信息');
INSERT INTO `t_jcdaohang` VALUES ('30', '账户统计', 'bingzhuangtu.jsp?tijiaoUrl=shujuTongji', null, null, null, '1', '2', '1', null, '16', '统计信息');
INSERT INTO `t_jcdaohang` VALUES ('31', '存款统计', 'bingzhuangtu.jsp?tijiaoUrl=sjduochuTongji', null, null, null, '2', '1', '1', null, '15', '统计信息');
INSERT INTO `t_jcdaohang` VALUES ('32', '存款统计', 'bingzhuangtu.jsp?tijiaoUrl=sjduochuTongji', null, null, null, '2', '2', '1', null, '16', '统计信息');
INSERT INTO `t_jcdaohang` VALUES ('33', '转账统计', 'bingzhuangtu.jsp?tijiaoUrl=sjshaochuTongji', null, null, null, '3', '1', '1', null, '15', '统计信息');
INSERT INTO `t_jcdaohang` VALUES ('34', '转账统计', 'bingzhuangtu.jsp?tijiaoUrl=sjshaochuTongji', null, null, null, '3', '2', '1', null, '16', '统计信息');
INSERT INTO `t_jcdaohang` VALUES ('35', '贷款统计', 'zhuzhuangtu.jsp?tijiaoUrl=sjjianchuTongji', null, null, null, '4', '1', '0', null, '15', '统计信息');
INSERT INTO `t_jcdaohang` VALUES ('36', '贷款统计', 'zhuzhuangtu.jsp?tijiaoUrl=sjjianchuTongji', null, null, null, '4', '2', '1', null, '16', '统计信息');
INSERT INTO `t_jcdaohang` VALUES ('37', '理财统计', 'zhuzhuangtu.jsp?tijiaoUrl=uxinxiTongji', null, null, null, '5', '1', '0', null, '15', '统计信息');
INSERT INTO `t_jcdaohang` VALUES ('38', '理财统计', 'zhuzhuangtu.jsp?tijiaoUrl=uxinxiTongji', null, null, null, '5', '2', '1', null, '16', '统计信息');

-- ----------------------------
-- Table structure for `t_jcpeizhi`
-- ----------------------------
DROP TABLE IF EXISTS `t_jcpeizhi`;
CREATE TABLE `t_jcpeizhi` (
`jcpeizhiId` int(11) NOT NULL AUTO_INCREMENT,
`jcpeizhiName` varchar(255) DEFAULT NULL,
`jcpeizhiNeirong` varchar(255) DEFAULT NULL,
`jcpeizhiMark` varchar(255) DEFAULT NULL,
`bumenBieming` varchar(255) DEFAULT NULL,
`buyuanBieming` varchar(255) DEFAULT NULL,
`buzhiBieming` varchar(255) DEFAULT NULL,
`userBieming` varchar(255) DEFAULT NULL COMMENT 'userBieming',
`uxtypeBieming` varchar(255) DEFAULT NULL,
`uxinxiBieming` varchar(255) DEFAULT NULL,
`uyijianBieming` varchar(255) DEFAULT NULL,
`roleBieming` varchar(255) DEFAULT NULL,
`byumenBieming` varchar(255) DEFAULT NULL,
`byuyuanBieming` varchar(255) DEFAULT NULL,
`byuzhiBieming` varchar(255) DEFAULT NULL,
`yonghuBieming` varchar(255) DEFAULT NULL COMMENT 'yonghuBieming',
`yxtypeBieming` varchar(255) DEFAULT NULL,
`yxinxiBieming` varchar(255) DEFAULT NULL,
`yyijianBieming` varchar(255) DEFAULT NULL,
`yhroleBieming` varchar(255) DEFAULT NULL,
`ggtypeBieming` varchar(255) DEFAULT NULL,
`gonggaoBieming` varchar(255) DEFAULT NULL,
`ggpinglunBieming` varchar(255) DEFAULT NULL,
`shujuBieming` varchar(255) DEFAULT NULL,
`sjduochuBieming` varchar(255) DEFAULT NULL,
`sjjianchuBieming` varchar(255) DEFAULT NULL,
`sjlaiyuanBieming` varchar(255) DEFAULT NULL,
`sjleixingBieming` varchar(255) DEFAULT NULL,
`sjpinglunBieming` varchar(255) DEFAULT NULL,
`sjqitaBieming` varchar(255) DEFAULT NULL,
`sjshaochuBieming` varchar(255) DEFAULT NULL,
`sjxingtaiBieming` varchar(255) DEFAULT NULL,
`jcpeizhiType` int(11) DEFAULT NULL,
`jcpeizhiType1` int(11) DEFAULT NULL,
`jcpeizhiType2` int(11) DEFAULT NULL,
PRIMARY KEY (`jcpeizhiId`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_jcpeizhi
-- ----------------------------
INSERT INTO `t_jcpeizhi` VALUES ('1', '银行管理系统', null, null, '部门', '部院', '部织', '用户', '类型', '理财', '建议', '权限', '部门', '部院', '部织', '用户', '类型', '消息', '建议', '权限', '类型', '公告', '评论', '账户', '存款', '贷款', '类型', '类型', '评论', '类型', '转账', '类型', '0', null, null);

-- ----------------------------
-- Table structure for `t_rizhi`
-- ----------------------------
DROP TABLE IF EXISTS `t_rizhi`;
CREATE TABLE `t_rizhi` (
`rizhiId` int(11) NOT NULL AUTO_INCREMENT,
`rizhiName` varchar(255) NOT NULL,
`dengluIp` varchar(255) NOT NULL,
`date` datetime NOT NULL,
PRIMARY KEY (`rizhiId`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_rizhi
-- ----------------------------
INSERT INTO `t_rizhi` VALUES ('1', 'admin', '127.0.0.1', '2021-01-21 18:03:52');
INSERT INTO `t_rizhi` VALUES ('2', 'yonghu1', '127.0.0.1', '2021-01-21 18:04:34');
INSERT INTO `t_rizhi` VALUES ('3', 'admin', '127.0.0.1', '2021-01-21 18:06:17');

-- ----------------------------
-- Table structure for `t_shuju`
-- ----------------------------
DROP TABLE IF EXISTS `t_shuju`;
CREATE TABLE `t_shuju` (
`shujuId` int(11) NOT NULL AUTO_INCREMENT,
`shujuName` varchar(255) DEFAULT NULL,
`shujuMark` varchar(2550) DEFAULT NULL,
`shujuMark1` varchar(2550) DEFAULT NULL,
`shujuMark2` varchar(2550) DEFAULT NULL,
`shujuMark3` varchar(2550) DEFAULT NULL,
`shujuDate` datetime DEFAULT NULL,
`shujuDate1` datetime DEFAULT NULL,
`shujuZong` int(11) DEFAULT NULL,
`shujuZong1` int(11) DEFAULT NULL,
`shujuZong2` int(11) DEFAULT NULL,
`shujuDouble` double DEFAULT NULL,
`shujuDouble1` double DEFAULT NULL,
`shujuDouble2` double DEFAULT NULL,
`shujuDouble3` double DEFAULT NULL,
`shujuDouble4` double DEFAULT NULL,
`shujuType` int(11) DEFAULT NULL,
`shujuType1` int(11) DEFAULT NULL,
`shujuType2` int(11) DEFAULT NULL,
`shujuImg` varchar(255) DEFAULT NULL,
`shujuImgName` varchar(255) DEFAULT NULL,
`sjleixingId` int(11) DEFAULT NULL,
`sjleixingName` varchar(255) DEFAULT NULL,
`sjxingtaiId` int(11) DEFAULT NULL,
`sjxingtaiName` varchar(255) DEFAULT NULL,
`userId` int(11) DEFAULT NULL,
`userName` varchar(255) DEFAULT NULL,
`bumenId` int(11) DEFAULT NULL,
`bumenName` varchar(255) DEFAULT NULL,
`buyuanId` int(11) DEFAULT NULL,
`buyuanName` varchar(255) DEFAULT NULL,
`yonghuId` int(11) DEFAULT NULL,
`yonghuName` varchar(255) DEFAULT NULL,
`byumenId` int(11) DEFAULT NULL,
`byumenName` varchar(255) DEFAULT NULL,
`byuyuanId` int(11) DEFAULT NULL,
`byuyuanName` varchar(255) DEFAULT NULL,
`buzhiId` int(11) DEFAULT NULL,
`buzhiName` varchar(255) DEFAULT NULL,
`roleId` int(11) DEFAULT NULL,
`roleName` varchar(255) DEFAULT NULL,
`byuzhiId` int(11) DEFAULT NULL,
`byuzhiName` varchar(255) DEFAULT NULL,
`yhroleId` int(11) DEFAULT NULL,
`yhroleName` varchar(255) DEFAULT NULL,
PRIMARY KEY (`shujuId`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_shuju
-- ----------------------------
INSERT INTO `t_shuju` VALUES ('1', '账户信息1', null, null, null, null, '2021-01-21 18:04:06', null, null, null, null, '4167', '0', '833', null, null, '0', null, null, null, null, '1', '白金', null, null, '1', 'yonghu1', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `t_shuju` VALUES ('2', '账户信息2', null, null, null, null, '2021-01-21 18:04:16', null, null, null, null, '8030', '30', '0', null, null, '0', null, null, null, null, '2', '钻石', null, null, '1', 'yonghu1', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);

-- ----------------------------
-- Table structure for `t_sjduochu`
-- ----------------------------
DROP TABLE IF EXISTS `t_sjduochu`;
CREATE TABLE `t_sjduochu` (
`sjduochuId` int(11) NOT NULL AUTO_INCREMENT,
`sjduochuName` varchar(255) DEFAULT NULL,
`sjduochuMark` varchar(2550) DEFAULT NULL,
`sjduochuMark1` varchar(2550) DEFAULT NULL,
`sjduochuMark2` varchar(2550) DEFAULT NULL,
`sjduochuMark3` varchar(2550) DEFAULT NULL,
`sjduochuDate` datetime DEFAULT NULL,
`sjduochuDate1` datetime DEFAULT NULL,
`sjduochuZong` int(11) DEFAULT NULL,
`sjduochuZong1` int(11) DEFAULT NULL,
`sjduochuZong2` int(11) DEFAULT NULL,
`sjduochuDouble` double DEFAULT NULL,
`sjduochuDouble1` double DEFAULT NULL,
`sjduochuDouble2` double DEFAULT NULL,
`sjduochuType` int(11) DEFAULT NULL,
`sjduochuType1` int(11) DEFAULT NULL,
`sjduochuType2` int(11) DEFAULT NULL,
`sjqitaId` int(11) DEFAULT NULL,
`sjqitaName` varchar(255) DEFAULT NULL,
`sjlaiyuanId` int(11) DEFAULT NULL,
`sjlaiyuanName` varchar(255) DEFAULT NULL,
`sjduochuImg` varchar(255) DEFAULT NULL,
`sjduochuImgName` varchar(255) DEFAULT NULL,
`shujuId` int(11) DEFAULT NULL,
`shujuName` varchar(255) DEFAULT NULL,
`sjleixingId` int(11) DEFAULT NULL,
`sjleixingName` varchar(255) DEFAULT NULL,
`sjxingtaiId` int(11) DEFAULT NULL,
`sjxingtaiName` varchar(255) DEFAULT NULL,
`userId` int(11) DEFAULT NULL,
`userName` varchar(255) DEFAULT NULL,
`bumenId` int(11) DEFAULT NULL,
`bumenName` varchar(255) DEFAULT NULL,
`buyuanId` int(11) DEFAULT NULL,
`buyuanName` varchar(255) DEFAULT NULL,
`yonghuId` int(11) DEFAULT NULL,
`yonghuName` varchar(255) DEFAULT NULL,
`byumenId` int(11) DEFAULT NULL,
`byumenName` varchar(255) DEFAULT NULL,
`byuyuanId` int(11) DEFAULT NULL,
`byuyuanName` varchar(255) DEFAULT NULL,
`buzhiId` int(11) DEFAULT NULL,
`buzhiName` varchar(255) DEFAULT NULL,
`roleId` int(11) DEFAULT NULL,
`roleName` varchar(255) DEFAULT NULL,
`byuzhiId` int(11) DEFAULT NULL,
`byuzhiName` varchar(255) DEFAULT NULL,
`yhroleId` int(11) DEFAULT NULL,
`yhroleName` varchar(255) DEFAULT NULL,
PRIMARY KEY (`sjduochuId`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_sjduochu
-- ----------------------------
INSERT INTO `t_sjduochu` VALUES ('1', null, null, null, null, null, '2021-01-21 18:04:58', null, null, null, null, '30', null, null, '0', null, null, null, null, null, null, null, null, '2', '账户信息2', '2', '钻石', null, null, '1', 'yonghu1', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);

-- ----------------------------
-- Table structure for `t_sjjianchu`
-- ----------------------------
DROP TABLE IF EXISTS `t_sjjianchu`;
CREATE TABLE `t_sjjianchu` (
`sjjianchuId` int(11) NOT NULL AUTO_INCREMENT,
`sjjianchuName` varchar(255) DEFAULT NULL,
`sjjianchuMark` varchar(2550) DEFAULT NULL,
`sjjianchuMark1` varchar(2550) DEFAULT NULL,
`sjjianchuMark2` varchar(2550) DEFAULT NULL,
`sjjianchuMark3` varchar(2550) DEFAULT NULL,
`sjjianchuDate` datetime DEFAULT NULL,
`sjjianchuDate1` datetime DEFAULT NULL,
`sjjianchuZong` int(11) DEFAULT NULL,
`sjjianchuZong1` int(11) DEFAULT NULL,
`sjjianchuZong2` int(11) DEFAULT NULL,
`sjjianchuDouble` double DEFAULT NULL,
`sjjianchuDouble1` double DEFAULT NULL,
`sjjianchuDouble2` double DEFAULT NULL,
`sjjianchuType` int(11) DEFAULT NULL,
`sjjianchuType1` int(11) DEFAULT NULL,
`sjjianchuType2` int(11) DEFAULT NULL,
`sjqitaId` int(11) DEFAULT NULL,
`sjqitaName` varchar(255) DEFAULT NULL,
`sjlaiyuanId` int(11) DEFAULT NULL,
`sjlaiyuanName` varchar(255) DEFAULT NULL,
`sjjianchuImg` varchar(255) DEFAULT NULL,
`sjjianchuImgName` varchar(255) DEFAULT NULL,
`shujuId` int(11) DEFAULT NULL,
`shujuName` varchar(255) DEFAULT NULL,
`sjleixingId` int(11) DEFAULT NULL,
`sjleixingName` varchar(255) DEFAULT NULL,
`sjxingtaiId` int(11) DEFAULT NULL,
`sjxingtaiName` varchar(255) DEFAULT NULL,
`userId` int(11) DEFAULT NULL,
`userName` varchar(255) DEFAULT NULL,
`bumenId` int(11) DEFAULT NULL,
`bumenName` varchar(255) DEFAULT NULL,
`buyuanId` int(11) DEFAULT NULL,
`buyuanName` varchar(255) DEFAULT NULL,
`yonghuId` int(11) DEFAULT NULL,
`yonghuName` varchar(255) DEFAULT NULL,
`byumenId` int(11) DEFAULT NULL,
`byumenName` varchar(255) DEFAULT NULL,
`byuyuanId` int(11) DEFAULT NULL,
`byuyuanName` varchar(255) DEFAULT NULL,
`buzhiId` int(11) DEFAULT NULL,
`buzhiName` varchar(255) DEFAULT NULL,
`roleId` int(11) DEFAULT NULL,
`roleName` varchar(255) DEFAULT NULL,
`byuzhiId` int(11) DEFAULT NULL,
`byuzhiName` varchar(255) DEFAULT NULL,
`yhroleId` int(11) DEFAULT NULL,
`yhroleName` varchar(255) DEFAULT NULL,
PRIMARY KEY (`sjjianchuId`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_sjjianchu
-- ----------------------------
INSERT INTO `t_sjjianchu` VALUES ('1', '贷款信息1', '贷款信息', null, null, '阿萨德发士大夫撒地方', '2021-01-21 18:05:33', null, null, null, null, '100', '0.02', null, '1', null, null, null, null, null, null, '/file/01.jpg', '01.jpg', null, null, null, null, '1', '贷款类型1', '1', 'yonghu1', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);
INSERT INTO `t_sjjianchu` VALUES ('2', '贷款信息2', '贷款信息', null, null, '奥德赛范德萨发是打发打发', '2021-01-21 18:05:43', null, null, null, null, '500', '0.15', null, '1', null, null, null, null, null, null, '/file/01.jpg', '01.jpg', null, null, null, null, '2', '贷款类型2', '1', 'yonghu1', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);

-- ----------------------------
-- Table structure for `t_sjleixing`
-- ----------------------------
DROP TABLE IF EXISTS `t_sjleixing`;
CREATE TABLE `t_sjleixing` (
`sjleixingId` int(11) NOT NULL AUTO_INCREMENT,
`sjleixingName` varchar(255) DEFAULT NULL,
`sjleixingMark` varchar(255) DEFAULT NULL,
`sjleixingMark1` varchar(255) DEFAULT NULL,
`sjleixingMark2` varchar(255) DEFAULT NULL,
`sjleixingPhone` varchar(255) DEFAULT NULL,
`sjleixingDizhi` varchar(255) DEFAULT NULL,
`sjleixingDate` datetime DEFAULT NULL,
`sjleixingDate1` datetime DEFAULT NULL,
`sjleixingType` int(11) DEFAULT NULL,
`sjleixingType1` int(11) DEFAULT NULL,
`sjleixingDouble` double DEFAULT NULL,
`sjleixingDouble1` double DEFAULT NULL,
PRIMARY KEY (`sjleixingId`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_sjleixing
-- ----------------------------
INSERT INTO `t_sjleixing` VALUES ('1', '白金', '白金', null, null, null, null, null, null, null, null, null, null);
INSERT INTO `t_sjleixing` VALUES ('2', '钻石', '钻石', null, null, null, null, null, null, null, null, null, null);

-- ----------------------------
-- Table structure for `t_sjpinglun`
-- ----------------------------
DROP TABLE IF EXISTS `t_sjpinglun`;
CREATE TABLE `t_sjpinglun` (
`sjpinglunId` int(11) NOT NULL AUTO_INCREMENT,
`sjpinglunName` varchar(2550) DEFAULT NULL,
`sjpinglunMark` varchar(2550) DEFAULT NULL,
`sjpinglunDate` datetime DEFAULT NULL,
`sjpinglunDate1` datetime DEFAULT NULL,
`sjpinglunType` int(11) DEFAULT NULL,
`sjpinglunType1` int(11) DEFAULT NULL,
`sjpinglunImg` varchar(255) DEFAULT NULL,
`sjpinglunImgName` varchar(255) DEFAULT NULL,
`shujuId` int(11) DEFAULT NULL,
`shujuName` varchar(255) DEFAULT NULL,
`sjleixingId` int(11) DEFAULT NULL,
`sjleixingName` varchar(255) DEFAULT NULL,
`userId` int(11) DEFAULT NULL,
`userName` varchar(255) DEFAULT NULL,
`bumenId` int(11) DEFAULT NULL,
`bumenName` varchar(255) DEFAULT NULL,
`buyuanId` int(11) DEFAULT NULL,
`buyuanName` varchar(255) DEFAULT NULL,
`yonghuId` int(11) DEFAULT NULL,
`yonghuName` varchar(255) DEFAULT NULL,
`byumenId` int(11) DEFAULT NULL,
`byumenName` varchar(255) DEFAULT NULL,
`byuyuanId` int(11) DEFAULT NULL,
`byuyuanName` varchar(255) DEFAULT NULL,
`buzhiId` int(11) DEFAULT NULL,
`buzhiName` varchar(255) DEFAULT NULL,
`roleId` int(11) DEFAULT NULL,
`roleName` varchar(255) DEFAULT NULL,
`byuzhiId` int(11) DEFAULT NULL,
`byuzhiName` varchar(255) DEFAULT NULL,
`yhroleId` int(11) DEFAULT NULL,
`yhroleName` varchar(255) DEFAULT NULL,
PRIMARY KEY (`sjpinglunId`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_sjpinglun
-- ----------------------------
INSERT INTO `t_sjpinglun` VALUES ('1', null, null, '2021-01-21 18:04:50', null, '0', '500', null, null, '1', '账户信息1', '1', '白金', '1', 'yonghu1', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);

-- ----------------------------
-- Table structure for `t_sjshaochu`
-- ----------------------------
DROP TABLE IF EXISTS `t_sjshaochu`;
CREATE TABLE `t_sjshaochu` (
`sjshaochuId` int(11) NOT NULL AUTO_INCREMENT,
`sjshaochuName` varchar(255) DEFAULT NULL,
`sjshaochuMark` varchar(2550) DEFAULT NULL,
`sjshaochuMark1` varchar(2550) DEFAULT NULL,
`sjshaochuMark2` varchar(2550) DEFAULT NULL,
`sjshaochuMark3` varchar(2550) DEFAULT NULL,
`sjshaochuDate` datetime DEFAULT NULL,
`sjshaochuDate1` datetime DEFAULT NULL,
`sjshaochuZong` int(11) DEFAULT NULL,
`sjshaochuZong1` int(11) DEFAULT NULL,
`sjshaochuZong2` int(11) DEFAULT NULL,
`sjshaochuDouble` double DEFAULT NULL,
`sjshaochuDouble1` double DEFAULT NULL,
`sjshaochuDouble2` double DEFAULT NULL,
`sjshaochuType` int(11) DEFAULT NULL,
`sjshaochuType1` int(11) DEFAULT NULL,
`sjshaochuType2` int(11) DEFAULT NULL,
`sjqitaId` int(11) DEFAULT NULL,
`sjqitaName` varchar(255) DEFAULT NULL,
`sjlaiyuanId` int(11) DEFAULT NULL,
`sjlaiyuanName` varchar(255) DEFAULT NULL,
`sjshaochuImg` varchar(255) DEFAULT NULL,
`sjshaochuImgName` varchar(255) DEFAULT NULL,
`shujuId` int(11) DEFAULT NULL,
`shujuName` varchar(255) DEFAULT NULL,
`sjleixingId` int(11) DEFAULT NULL,
`sjleixingName` varchar(255) DEFAULT NULL,
`sjxingtaiId` int(11) DEFAULT NULL,
`sjxingtaiName` varchar(255) DEFAULT NULL,
`userId` int(11) DEFAULT NULL,
`userName` varchar(255) DEFAULT NULL,
`bumenId` int(11) DEFAULT NULL,
`bumenName` varchar(255) DEFAULT NULL,
`buyuanId` int(11) DEFAULT NULL,
`buyuanName` varchar(255) DEFAULT NULL,
`yonghuId` int(11) DEFAULT NULL,
`yonghuName` varchar(255) DEFAULT NULL,
`byumenId` int(11) DEFAULT NULL,
`byumenName` varchar(255) DEFAULT NULL,
`byuyuanId` int(11) DEFAULT NULL,
`byuyuanName` varchar(255) DEFAULT NULL,
`buzhiId` int(11) DEFAULT NULL,
`buzhiName` varchar(255) DEFAULT NULL,
`roleId` int(11) DEFAULT NULL,
`roleName` varchar(255) DEFAULT NULL,
`byuzhiId` int(11) DEFAULT NULL,
`byuzhiName` varchar(255) DEFAULT NULL,
`yhroleId` int(11) DEFAULT NULL,
`yhroleName` varchar(255) DEFAULT NULL,
PRIMARY KEY (`sjshaochuId`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_sjshaochu
-- ----------------------------
INSERT INTO `t_sjshaochu` VALUES ('1', '阿斯蒂芬', '13012345678', '阿萨德', '阿撒旦法大师傅第三方', null, '2021-01-21 18:05:17', null, null, null, null, '333', null, null, '0', null, null, null, null, null, null, null, null, '1', '账户信息1', '1', '白金', null, null, '1', 'yonghu1', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null);

-- ----------------------------
-- Table structure for `t_sjxingtai`
-- ----------------------------
DROP TABLE IF EXISTS `t_sjxingtai`;
CREATE TABLE `t_sjxingtai` (
`sjxingtaiId` int(11) NOT NULL AUTO_INCREMENT,
`sjxingtaiName` varchar(255) DEFAULT NULL,
`sjxingtaiMark` varchar(255) DEFAULT NULL,
`sjxingtaiMark1` varchar(255) DEFAULT NULL,
`sjxingtaiMark2` varchar(255) DEFAULT NULL,
`sjxingtaiPhone` varchar(255) DEFAULT NULL,
`sjxingtaiDizhi` varchar(255) DEFAULT NULL,
`sjxingtaiDate` datetime DEFAULT NULL,
`sjxingtaiDate1` datetime DEFAULT NULL,
`sjxingtaiType` int(11) DEFAULT NULL,
`sjxingtaiType1` int(11) DEFAULT NULL,
`sjxingtaiDouble` double DEFAULT NULL,
`sjxingtaiDouble1` double DEFAULT NULL,
PRIMARY KEY (`sjxingtaiId`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_sjxingtai
-- ----------------------------
INSERT INTO `t_sjxingtai` VALUES ('1', '贷款类型1', '贷款类型', '贷款类型', null, null, null, null, null, null, null, '0.02', null);
INSERT INTO `t_sjxingtai` VALUES ('2', '贷款类型2', '贷款类型', '贷款类型', null, null, null, null, null, null, null, '0.15', null);

-- ----------------------------
-- Table structure for `t_user`
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
`userId` int(11) NOT NULL AUTO_INCREMENT,
`userName` varchar(255) DEFAULT NULL,
`userPassword` varchar(255) DEFAULT NULL,
`userXingming` varchar(255) DEFAULT NULL,
`userSex` int(11) DEFAULT NULL,
`userAge` int(11) DEFAULT NULL,
`userMinzu` varchar(255) DEFAULT NULL,
`userPhone` varchar(255) DEFAULT NULL,
`userMark` varchar(2550) DEFAULT NULL,
`userMark1` varchar(255) DEFAULT NULL,
`userMark2` varchar(255) DEFAULT NULL,
`userMark3` varchar(255) DEFAULT NULL,
`userMark4` varchar(255) DEFAULT NULL,
`userDate` datetime DEFAULT NULL,
`userDate1` datetime DEFAULT NULL,
`userDate2` datetime DEFAULT NULL,
`userType` int(11) DEFAULT NULL,
`userType1` int(11) DEFAULT NULL,
`userType2` int(11) DEFAULT NULL,
`userDouble` double DEFAULT NULL,
`userDouble1` double DEFAULT NULL,
`userDouble2` double DEFAULT NULL,
`userZong` int(11) DEFAULT NULL,
`userZong1` int(11) DEFAULT NULL,
`userZong2` int(11) DEFAULT NULL,
`userImg` varchar(255) DEFAULT NULL,
`userImgName` varchar(255) DEFAULT NULL,
`roleId` int(11) DEFAULT NULL,
`roleName` varchar(255) DEFAULT NULL,
`bumenId` int(11) DEFAULT NULL,
`bumenName` varchar(255) DEFAULT NULL,
`buyuanId` int(11) DEFAULT NULL,
`buyuanName` varchar(255) DEFAULT NULL,
`buzhiId` int(11) DEFAULT NULL,
`buzhiName` varchar(255) DEFAULT NULL,
PRIMARY KEY (`userId`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_user
-- ----------------------------
INSERT INTO `t_user` VALUES ('1', 'yonghu1', 'yonghu1', 'yonghu1', '0', '22', null, '13012345678', null, '130123456782345678', null, null, null, '2021-01-21 18:03:49', null, null, '0', null, null, '12197', '30', '833', null, null, null, null, null, null, null, null, null, null, null, null, null);

-- ----------------------------
-- Table structure for `t_uxinxi`
-- ----------------------------
DROP TABLE IF EXISTS `t_uxinxi`;
CREATE TABLE `t_uxinxi` (
`uxinxiId` int(11) NOT NULL AUTO_INCREMENT,
`uxinxiName` varchar(255) DEFAULT NULL,
`uxinxiMark` varchar(2550) DEFAULT NULL,
`uxinxiMark1` varchar(2550) DEFAULT NULL,
`uxinxiMark2` varchar(2550) DEFAULT NULL,
`uxinxiImg` varchar(255) DEFAULT NULL,
`uxinxiImgName` varchar(255) DEFAULT NULL,
`uxinxiDate` datetime DEFAULT NULL,
`uxinxiZong` int(11) DEFAULT NULL,
`uxinxiZong1` int(11) DEFAULT NULL,
`uxinxiZong2` int(11) DEFAULT NULL,
`uxinxiDouble` double DEFAULT NULL,
`uxinxiDouble1` double DEFAULT NULL,
`uxinxiDouble2` double DEFAULT NULL,
`uxinxiType` int(11) DEFAULT NULL,
`uxinxiType1` int(11) DEFAULT NULL,
`uxinxiType2` int(11) DEFAULT NULL,
`uxtypeId` int(11) DEFAULT NULL,
`uxtypeName` varchar(255) DEFAULT NULL,
`userId` int(11) DEFAULT NULL,
`userName` varchar(255) DEFAULT NULL,
`bumenId` int(11) DEFAULT NULL,
`bumenName` varchar(255) DEFAULT NULL,
`buyuanId` int(11) DEFAULT NULL,
`buyuanName` varchar(255) DEFAULT NULL,
`buzhiId` int(11) DEFAULT NULL,
`buzhiName` varchar(255) DEFAULT NULL,
`roleId` int(11) DEFAULT NULL,
`roleName` varchar(255) DEFAULT NULL,
PRIMARY KEY (`uxinxiId`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_uxinxi
-- ----------------------------
INSERT INTO `t_uxinxi` VALUES ('1', '用户理财1', '用户理财用户理财用户理财', null, null, null, null, '2021-01-21 18:06:03', null, null, null, '5000', '0.02', null, null, null, null, '1', '教育', '1', 'yonghu1', null, null, null, null, null, null, null, null);
INSERT INTO `t_uxinxi` VALUES ('2', '用户理财2', '用户理财用户理财用户理财', null, null, null, null, '2021-01-21 18:06:12', null, null, null, '4000', '0.02', null, null, null, null, '2', '投资', '1', 'yonghu1', null, null, null, null, null, null, null, null);

-- ----------------------------
-- Table structure for `t_uxtype`
-- ----------------------------
DROP TABLE IF EXISTS `t_uxtype`;
CREATE TABLE `t_uxtype` (
`uxtypeId` int(11) NOT NULL AUTO_INCREMENT,
`uxtypeName` varchar(255) DEFAULT NULL,
`uxtypeMark` varchar(255) DEFAULT NULL,
PRIMARY KEY (`uxtypeId`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_uxtype
-- ----------------------------
INSERT INTO `t_uxtype` VALUES ('1', '教育', '教育教育教育教育');
INSERT INTO `t_uxtype` VALUES ('2', '投资', '投资');

-- ----------------------------
-- Table structure for `t_uyijian`
-- ----------------------------
DROP TABLE IF EXISTS `t_uyijian`;
CREATE TABLE `t_uyijian` (
`uyijianId` int(11) NOT NULL AUTO_INCREMENT,
`uyijianName` varchar(255) DEFAULT NULL,
`uyijianMark` varchar(2550) DEFAULT NULL,
`uyijianMark1` varchar(2550) DEFAULT NULL,
`uyijianMark2` varchar(2550) DEFAULT NULL,
`uyijianImg` varchar(255) DEFAULT NULL,
`uyijianImgName` varchar(255) DEFAULT NULL,
`uyijianDate` datetime DEFAULT NULL,
`uyijianZong` int(11) DEFAULT NULL,
`uyijianZong1` int(11) DEFAULT NULL,
`uyijianZong2` int(11) DEFAULT NULL,
`uyijianDouble` double DEFAULT NULL,
`uyijianDouble1` double DEFAULT NULL,
`uyijianDouble2` double DEFAULT NULL,
`uyijianType` int(11) DEFAULT NULL,
`uyijianType1` int(11) DEFAULT NULL,
`uyijianType2` int(11) DEFAULT NULL,
`uxtypeId` int(11) DEFAULT NULL,
`uxtypeName` varchar(255) DEFAULT NULL,
`userId` int(11) DEFAULT NULL,
`userName` varchar(255) DEFAULT NULL,
`bumenId` int(11) DEFAULT NULL,
`bumenName` varchar(255) DEFAULT NULL,
`buyuanId` int(11) DEFAULT NULL,
`buyuanName` varchar(255) DEFAULT NULL,
`buzhiId` int(11) DEFAULT NULL,
`buzhiName` varchar(255) DEFAULT NULL,
`roleId` int(11) DEFAULT NULL,
`roleName` varchar(255) DEFAULT NULL,
PRIMARY KEY (`uyijianId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_uyijian
-- ----------------------------

QQ_188083800

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
计算机毕业设计java银行储蓄业务管理系统

INSERT INTO `t_jcpeizhi` VALUES ('1', '银行管理系统', null, null, '部门', '部院', '部织', '用户', '类型', '理财', '建议', '权限', '部门', '部院', '部织', '用户', '类型', '消息', '建议', '权限', '类型', '公告', '评论', '账户', '存款', '贷款', '类型', '类型', '评论', '类型', '转账', '类型', '0', null, null);
复制链接

扫一扫