学费管理系统代码

/*
Navicat MySQL Data Transfer

Source Server : localhost_3306
Source Server Version : 80031
Source Host : localhost:3306
Source Database : jspmr289f

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

Date: 2023-08-13 00:33:40
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for config
-- ----------------------------
DROP TABLE IF EXISTS `config`;
CREATE TABLE `config` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`name` varchar(100) NOT NULL COMMENT '配置参数名称',
`value` varchar(100) DEFAULT NULL COMMENT '配置参数值',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COMMENT='配置文件';

-- ----------------------------
-- Records of config
-- ----------------------------
INSERT INTO `config` VALUES ('1', 'picture1', 'upload/picture1.jpg');
INSERT INTO `config` VALUES ('2', 'picture2', 'upload/picture2.jpg');
INSERT INTO `config` VALUES ('3', 'picture3', 'upload/picture3.jpg');

-- ----------------------------
-- Table structure for fankuixinxi
-- ----------------------------
DROP TABLE IF EXISTS `fankuixinxi`;
CREATE TABLE `fankuixinxi` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`fankuibianhao` varchar(200) DEFAULT NULL COMMENT '反馈编号',
`fankuimingcheng` varchar(200) DEFAULT NULL COMMENT '反馈名称',
`fankuishijian` datetime DEFAULT NULL COMMENT '反馈时间',
`xuehao` varchar(200) DEFAULT NULL COMMENT '学号',
`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
`xueshengdianhua` varchar(200) DEFAULT NULL COMMENT '学生电话',
`fankuineirong` longtext COMMENT '反馈内容',
`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
`userid` bigint DEFAULT NULL COMMENT '用户id',
PRIMARY KEY (`id`),
UNIQUE KEY `fankuibianhao` (`fankuibianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=1648256959930 DEFAULT CHARSET=utf8mb3 COMMENT='反馈信息';

-- ----------------------------
-- Records of fankuixinxi
-- ----------------------------
INSERT INTO `fankuixinxi` VALUES ('61', '2023-03-26 09:02:24', '1111111111', '反馈名称1', '2023-03-26 09:02:24', '学号1', '姓名1', '学生电话1', '反馈内容1', '是', '', '1');
INSERT INTO `fankuixinxi` VALUES ('62', '2023-03-26 09:02:24', '2222222222', '反馈名称2', '2023-03-26 09:02:24', '学号2', '姓名2', '学生电话2', '反馈内容2', '是', '', '2');
INSERT INTO `fankuixinxi` VALUES ('63', '2023-03-26 09:02:24', '3333333333', '反馈名称3', '2023-03-26 09:02:24', '学号3', '姓名3', '学生电话3', '反馈内容3', '是', '', '3');
INSERT INTO `fankuixinxi` VALUES ('64', '2023-03-26 09:02:24', '4444444444', '反馈名称4', '2023-03-26 09:02:24', '学号4', '姓名4', '学生电话4', '反馈内容4', '是', '', '4');
INSERT INTO `fankuixinxi` VALUES ('65', '2023-03-26 09:02:24', '5555555555', '反馈名称5', '2023-03-26 09:02:24', '学号5', '姓名5', '学生电话5', '反馈内容5', '是', '', '5');
INSERT INTO `fankuixinxi` VALUES ('66', '2023-03-26 09:02:24', '6666666666', '反馈名称6', '2023-03-26 09:02:24', '学号6', '姓名6', '学生电话6', '反馈内容6', '是', '', '6');
INSERT INTO `fankuixinxi` VALUES ('1648256959929', '2023-03-26 09:09:19', '1648256966', '宿舍灯泡坏了', '2023-03-26 09:09:25', '111', '123', '13622222222', '<p>宿舍灯泡坏了</p>', '是', 'xxxxxx', null);

-- ----------------------------
-- Table structure for token
-- ----------------------------
DROP TABLE IF EXISTS `token`;
CREATE TABLE `token` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`userid` bigint NOT NULL COMMENT '用户id',
`username` varchar(100) NOT NULL COMMENT '用户名',
`tablename` varchar(100) DEFAULT NULL COMMENT '表名',
`role` varchar(100) DEFAULT NULL COMMENT '角色',
`token` varchar(200) NOT NULL COMMENT '密码',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
`expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '过期时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COMMENT='token表';

-- ----------------------------
-- Records of token
-- ----------------------------
INSERT INTO `token` VALUES ('1', '1648256718585', '111', 'xuesheng', '学生', 'lde4kp7y4fvuz3ffp9glgoy65f073g3m', '2023-03-26 09:05:23', '2023-03-26 10:10:15');
INSERT INTO `token` VALUES ('2', '1', 'abo', 'users', '管理员', 'rhh8itkpcu5mki1itcfuf8q3u8k7dfki', '2023-03-26 09:05:50', '2023-08-13 01:25:41');
INSERT INTO `token` VALUES ('3', '1691857296209', '123', 'xuesheng', '学生', 'fd5j68snauxkyu4bdk4upg6yw4b0x4hn', '2023-08-13 00:22:47', '2023-08-13 01:30:21');

-- ----------------------------
-- Table structure for tongzhigonggao
-- ----------------------------
DROP TABLE IF EXISTS `tongzhigonggao`;
CREATE TABLE `tongzhigonggao` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`gonggaobianhao` varchar(200) DEFAULT NULL COMMENT '公告编号',
`gonggaobiaoti` varchar(200) DEFAULT NULL COMMENT '公告标题',
`faburiqi` date DEFAULT NULL COMMENT '发布日期',
`fabuneirong` longtext COMMENT '发布内容',
PRIMARY KEY (`id`),
UNIQUE KEY `gonggaobianhao` (`gonggaobianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=1648256811929 DEFAULT CHARSET=utf8mb3 COMMENT='通知公告';

-- ----------------------------
-- Records of tongzhigonggao
-- ----------------------------
INSERT INTO `tongzhigonggao` VALUES ('21', '2023-03-26 09:02:24', '1111111111', '公告标题1', '2023-03-26', '发布内容1');
INSERT INTO `tongzhigonggao` VALUES ('22', '2023-03-26 09:02:24', '2222222222', '公告标题2', '2023-03-26', '发布内容2');
INSERT INTO `tongzhigonggao` VALUES ('23', '2023-03-26 09:02:24', '3333333333', '公告标题3', '2023-03-26', '发布内容3');
INSERT INTO `tongzhigonggao` VALUES ('24', '2023-03-26 09:02:24', '4444444444', '公告标题4', '2023-03-26', '发布内容4');
INSERT INTO `tongzhigonggao` VALUES ('25', '2023-03-26 09:02:24', '5555555555', '公告标题5', '2023-03-26', '发布内容5');
INSERT INTO `tongzhigonggao` VALUES ('26', '2023-03-26 09:02:24', '6666666666', '公告标题6', '2023-03-26', '发布内容6');
INSERT INTO `tongzhigonggao` VALUES ('1648256811928', '2023-03-26 09:06:51', '1648256816', '校园公告', '2023-03-26', '<p>编辑发布内容xxxxxxx</p>');

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`username` varchar(100) NOT NULL COMMENT '用户名',
`password` varchar(100) NOT NULL COMMENT '密码',
`role` varchar(100) DEFAULT '管理员' COMMENT '角色',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COMMENT='用户表';

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES ('1', 'admin', 'admin', '管理员', '2023-03-26 09:02:24');

-- ----------------------------
-- Table structure for xinshengxuefei
-- ----------------------------
DROP TABLE IF EXISTS `xinshengxuefei`;
CREATE TABLE `xinshengxuefei` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`shoufeibiaoti` varchar(200) DEFAULT NULL COMMENT '收费标题',
`xuefei` float DEFAULT NULL COMMENT '学费',
`zhusufei` float DEFAULT NULL COMMENT '住宿费',
`shubenfei` float DEFAULT NULL COMMENT '书本费',
`tijianfei` float DEFAULT NULL COMMENT '体检费',
`zongjine` float DEFAULT NULL COMMENT '总金额',
`xuehao` varchar(200) DEFAULT NULL COMMENT '学号',
`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
`yuanxi` varchar(200) DEFAULT NULL COMMENT '院系',
`ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1691857335986 DEFAULT CHARSET=utf8mb3 COMMENT='新生学费';

-- ----------------------------
-- Records of xinshengxuefei
-- ----------------------------
INSERT INTO `xinshengxuefei` VALUES ('31', '2023-03-26 09:02:24', '收费标题1', '1', '1', '1', '1', '1', '学号1', '姓名1', '院系1', '未支付');
INSERT INTO `xinshengxuefei` VALUES ('32', '2023-03-26 09:02:24', '收费标题2', '2', '2', '2', '2', '2', '学号2', '姓名2', '院系2', '未支付');
INSERT INTO `xinshengxuefei` VALUES ('33', '2023-03-26 09:02:24', '收费标题3', '3', '3', '3', '3', '3', '学号3', '姓名3', '院系3', '未支付');
INSERT INTO `xinshengxuefei` VALUES ('34', '2023-03-26 09:02:24', '收费标题4', '4', '4', '4', '4', '4', '学号4', '姓名4', '院系4', '未支付');
INSERT INTO `xinshengxuefei` VALUES ('35', '2023-03-26 09:02:24', '收费标题5', '5', '5', '5', '5', '5', '学号5', '姓名5', '院系5', '未支付');
INSERT INTO `xinshengxuefei` VALUES ('36', '2023-03-26 09:02:24', '收费标题6', '6', '6', '6', '6', '6', '学号6', '姓名6', '院系6', '未支付');
INSERT INTO `xinshengxuefei` VALUES ('1648256835955', '2023-03-26 09:07:15', '新生费用', '1500', '60', '30', '60', '1650', '111', '张宇', '金融系', '已支付');
INSERT INTO `xinshengxuefei` VALUES ('1691857335985', '2023-08-13 00:22:15', '新生费用', '5000', '1000', '1000', '1000', '8000', '123', '张三', '计算机', '已支付');

-- ----------------------------
-- Table structure for xuesheng
-- ----------------------------
DROP TABLE IF EXISTS `xuesheng`;
CREATE TABLE `xuesheng` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`xuehao` varchar(200) DEFAULT NULL COMMENT '学号',
`mima` varchar(200) DEFAULT NULL COMMENT '密码',
`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`xueshengdianhua` varchar(200) DEFAULT NULL COMMENT '学生电话',
`touxiang` varchar(200) DEFAULT NULL COMMENT '头像',
`zhuzhi` varchar(200) DEFAULT NULL COMMENT '住址',
PRIMARY KEY (`id`),
UNIQUE KEY `xuehao` (`xuehao`)
) ENGINE=InnoDB AUTO_INCREMENT=1691857296210 DEFAULT CHARSET=utf8mb3 COMMENT='学生';

-- ----------------------------
-- Records of xuesheng
-- ----------------------------
INSERT INTO `xuesheng` VALUES ('12', '2023-03-26 09:02:24', '学号2', '123456', '姓名2', '女', '13823888882', 'upload/xuesheng_touxiang2.jpg', '住址2');
INSERT INTO `xuesheng` VALUES ('13', '2023-03-26 09:02:24', '学号3', '123456', '姓名3', '男', '13823888883', 'upload/xuesheng_touxiang3.jpg', '住址3');
INSERT INTO `xuesheng` VALUES ('14', '2023-03-26 09:02:24', '学号4', '123456', '姓名4', '男', '13823888884', 'upload/xuesheng_touxiang4.jpg', '住址4');
INSERT INTO `xuesheng` VALUES ('15', '2023-03-26 09:02:24', '学号5', '123456', '姓名5', '男', '13823888885', 'upload/xuesheng_touxiang5.jpg', '住址5');
INSERT INTO `xuesheng` VALUES ('16', '2023-03-26 09:02:24', '学号6', '123456', '姓名6', '男', '13823888886', 'upload/xuesheng_touxiang6.jpg', '住址6');
INSERT INTO `xuesheng` VALUES ('1648256718585', '2023-03-26 09:05:18', '111', '111', '张宇', '女', '13622222222', 'upload/1648256737681.jpg', '江苏阳光小区');
INSERT INTO `xuesheng` VALUES ('1691857296209', '2023-08-13 00:21:36', '123', '123', '张三', '男', '15891589413', 'upload/1691857286880.jpg', '123');

-- ----------------------------
-- Table structure for xueshengqiandao
-- ----------------------------
DROP TABLE IF EXISTS `xueshengqiandao`;
CREATE TABLE `xueshengqiandao` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`qiandaobianhao` varchar(200) DEFAULT NULL COMMENT '签到编号',
`qiandaoweizhi` varchar(200) DEFAULT NULL COMMENT '签到位置',
`qiandaoshijian` datetime DEFAULT NULL COMMENT '签到时间',
`beizhu` varchar(200) DEFAULT NULL COMMENT '备注',
`xuehao` varchar(200) DEFAULT NULL COMMENT '学号',
`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
`xueshengdianhua` varchar(200) DEFAULT NULL COMMENT '学生电话',
`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
PRIMARY KEY (`id`),
UNIQUE KEY `qiandaobianhao` (`qiandaobianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=1691857425135 DEFAULT CHARSET=utf8mb3 COMMENT='学生签到';

-- ----------------------------
-- Records of xueshengqiandao
-- ----------------------------
INSERT INTO `xueshengqiandao` VALUES ('51', '2023-03-26 09:02:24', '1111111111', '签到位置1', '2023-03-26 09:02:24', '备注1', '学号1', '姓名1', '学生电话1', '是', '');
INSERT INTO `xueshengqiandao` VALUES ('52', '2023-03-26 09:02:24', '2222222222', '签到位置2', '2023-03-26 09:02:24', '备注2', '学号2', '姓名2', '学生电话2', '是', '');
INSERT INTO `xueshengqiandao` VALUES ('53', '2023-03-26 09:02:24', '3333333333', '签到位置3', '2023-03-26 09:02:24', '备注3', '学号3', '姓名3', '学生电话3', '是', '');
INSERT INTO `xueshengqiandao` VALUES ('54', '2023-03-26 09:02:24', '4444444444', '签到位置4', '2023-03-26 09:02:24', '备注4', '学号4', '姓名4', '学生电话4', '是', '');
INSERT INTO `xueshengqiandao` VALUES ('55', '2023-03-26 09:02:24', '5555555555', '签到位置5', '2023-03-26 09:02:24', '备注5', '学号5', '姓名5', '学生电话5', '是', '');
INSERT INTO `xueshengqiandao` VALUES ('56', '2023-03-26 09:02:24', '6666666666', '签到位置6', '2023-03-26 09:02:24', '备注6', '学号6', '姓名6', '学生电话6', '是', '');
INSERT INTO `xueshengqiandao` VALUES ('1691857425134', '2023-08-13 00:23:44', '1691857415', '宿舍', '2023-08-13 00:23:35', '111', '123', '张三', '15891589413', '是', '收到');

-- ----------------------------
-- Table structure for xueshengshenqing
-- ----------------------------
DROP TABLE IF EXISTS `xueshengshenqing`;
CREATE TABLE `xueshengshenqing` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`shenqingbianhao` varchar(200) DEFAULT NULL COMMENT '申请编号',
`shenqingbiaoti` varchar(200) DEFAULT NULL COMMENT '申请标题',
`shenqingshijian` date DEFAULT NULL COMMENT '申请时间',
`shenqingneirong` longtext COMMENT '申请内容',
`xuehao` varchar(200) DEFAULT NULL COMMENT '学号',
`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
`xueshengdianhua` varchar(200) DEFAULT NULL COMMENT '学生电话',
`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
PRIMARY KEY (`id`),
UNIQUE KEY `shenqingbianhao` (`shenqingbianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=1691857406850 DEFAULT CHARSET=utf8mb3 COMMENT='学生申请';

-- ----------------------------
-- Records of xueshengshenqing
-- ----------------------------
INSERT INTO `xueshengshenqing` VALUES ('41', '2023-03-26 09:02:24', '1111111111', '申请标题1', '2023-03-26', '申请内容1', '学号1', '姓名1', '学生电话1', '是', '');
INSERT INTO `xueshengshenqing` VALUES ('42', '2023-03-26 09:02:24', '2222222222', '申请标题2', '2023-03-26', '申请内容2', '学号2', '姓名2', '学生电话2', '是', '');
INSERT INTO `xueshengshenqing` VALUES ('43', '2023-03-26 09:02:24', '3333333333', '申请标题3', '2023-03-26', '申请内容3', '学号3', '姓名3', '学生电话3', '是', '');
INSERT INTO `xueshengshenqing` VALUES ('44', '2023-03-26 09:02:24', '4444444444', '申请标题4', '2023-03-26', '申请内容4', '学号4', '姓名4', '学生电话4', '是', '');
INSERT INTO `xueshengshenqing` VALUES ('45', '2023-03-26 09:02:24', '5555555555', '申请标题5', '2023-03-26', '申请内容5', '学号5', '姓名5', '学生电话5', '是', '');
INSERT INTO `xueshengshenqing` VALUES ('46', '2023-03-26 09:02:24', '6666666666', '申请标题6', '2023-03-26', '申请内容6', '学号6', '姓名6', '学生电话6', '是', '');
INSERT INTO `xueshengshenqing` VALUES ('1691857406849', '2023-08-13 00:23:26', '1691857393', '桌子', '2023-08-13', '', '123', '张三', '15891589413', '是', '马上安排');

本栏目推荐文章
• 代码随想录 day18 找树左下角的值 路径总和 从中序与后序遍历序列构造二叉树
• Flutter Getx 路由管理
• node版本管理工具推荐
• 深入探索JVM：理解Java程序在虚拟机中的存储和管理
• VMware虚拟机安装银河麒麟桌面版V10系统
• OpenHarmony 上跑CV 应用 - Windows上搭建 Linux 桌面系统
• 用jacoco统计JAVA项目测试代码覆盖率
• 阅读-《所谓时间管理就是选择性放弃》
• JFinal学生信息管理系统
• （坚持每天写算法）基础算法复习与学习part1基础算法1-7——高精度减法（处理t=1和t>1代码的写法，t为操作次数）

学费 管理系统 代码 系统学费 管理系统 代码 系统 代码 系统 swallow代码 系统 源代码wpf系统erp 一行 代码 系统cmdpe 电力系统 机组 电力 代码 系统 源代码 真相 书籍 源代码uniapp系统video 能源 代码matlab系统 imessage常见 代码 系统