javaweb课程设计基于SpringBoot学生教务管理系统-毕业设计-源代码+初始化数据库脚本

/* Navicat Premium Data Transfer Source Server : 152.32.173.77 Source Server Type : MySQL Source Server Version : 50651 Source Host : 152.32.173.77:3316 Source Schema : bs_jwglxt Target Server Type : MySQL Target Server Version : 50651 File Encoding : 65001 Date: 21/12/2022 22:14:38 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for tb_admin_role -- ---------------------------- DROP TABLE IF EXISTS `tb_admin_role`; CREATE TABLE `tb_admin_role` ( `role_id` int(11) NOT NULL AUTO_INCREMENT, `role_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `note` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `system` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `status` int(11) NULL DEFAULT 0, `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` timestamp(0) NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP(0), PRIMARY KEY (`role_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of tb_admin_role -- ---------------------------- INSERT INTO `tb_admin_role` VALUES (1, '管理员', '', '', NULL, '2022-12-17 23:58:21', '2022-12-17 23:58:21'); -- ---------------------------- -- Table structure for tb_admin_user -- ---------------------------- DROP TABLE IF EXISTS `tb_admin_user`; CREATE TABLE `tb_admin_user` ( `user_id` int(11) NOT NULL AUTO_INCREMENT, `user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `status` int(8) NULL DEFAULT NULL, `note` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` timestamp(0) NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP(0), PRIMARY KEY (`user_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of tb_admin_user -- ---------------------------- INSERT INTO `tb_admin_user` VALUES (1, 'admin', 'admin', '123123', NULL, '', '2022-12-17 23:54:13', '2022-12-17 23:54:13'); -- ---------------------------- -- Table structure for tb_banji -- ---------------------------- DROP TABLE IF EXISTS `tb_banji`; CREATE TABLE `tb_banji` ( `id` int(4) NOT NULL AUTO_INCREMENT, `name` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL, `nianji` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL, `banzhuren` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL, `renshu` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL, `shuoming` text CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `id`(`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = gb2312 COLLATE = gb2312_chinese_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of tb_banji -- ---------------------------- INSERT INTO `tb_banji` VALUES (1, '2010年2班不', '三年二班', '1', '52', '无'); INSERT INTO `tb_banji` VALUES (2, '2010年3班好', '三年三班', '2', '50', '无说明'); -- ---------------------------- -- Table structure for tb_chengji -- ---------------------------- DROP TABLE IF EXISTS `tb_chengji`; CREATE TABLE `tb_chengji` ( `id` int(4) NOT NULL AUTO_INCREMENT, `xuesheng` int(4) NULL DEFAULT NULL, `kemu` int(4) NULL DEFAULT NULL, `shijian` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL, `fenshu` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `id`(`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = gb2312 COLLATE = gb2312_chinese_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of tb_chengji -- ---------------------------- INSERT INTO `tb_chengji` VALUES (1, 3, 3, '2010-04-30', '96'); INSERT INTO `tb_chengji` VALUES (5, 3, 1, '2010-04-30', '50'); INSERT INTO `tb_chengji` VALUES (6, 2, 3, '2010-04-30', '88'); INSERT INTO `tb_chengji` VALUES (7, 2, 1, '2010-04-30', '66'); INSERT INTO `tb_chengji` VALUES (8, 1, 3, '2010-04-30', '82'); INSERT INTO `tb_chengji` VALUES (9, 1, 1, '2010-04-30', '45'); -- ---------------------------- -- Table structure for tb_functions -- ---------------------------- DROP TABLE IF EXISTS `tb_functions`; CREATE TABLE `tb_functions` ( `func_id` int(11) NOT NULL AUTO_INCREMENT, `func_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `func_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `parent_id` int(11) NULL DEFAULT 0, `status` int(8) NULL DEFAULT 0, `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP, `update_time` timestamp(0) NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP(0), PRIMARY KEY (`func_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of tb_functions -- ---------------------------- INSERT INTO `tb_functions` VALUES (1, '系统管理', '', 0, 0, '2022-12-18 14:03:36', '2022-12-18 14:03:36'); INSERT INTO `tb_functions` VALUES (2, '用户管理', '/adminUser/list', 1, 0, '2022-12-18 14:04:07', '2022-12-18 14:04:07'); INSERT INTO `tb_functions` VALUES (3, '用户-角色管理', '/userRole/list', 1, 0, '2022-12-19 04:04:59', '2022-12-19 04:04:59'); INSERT INTO `tb_functions` VALUES (4, ' 功能管理', '/function/list', 1, 0, '2022-12-18 00:07:19', '2022-12-18 00:07:19'); INSERT INTO `tb_functions` VALUES (5, '角色管理', '/adminRole/list', 1, 0, '2022-12-18 16:14:55', '2022-12-18 16:14:55'); INSERT INTO `tb_functions` VALUES (6, '角色-功能管理', '/roleFunction/list', 1, 0, '2022-12-18 16:15:41', '2022-12-18 16:15:41'); INSERT INTO `tb_functions` VALUES (7, '教务管理', '', 0, 0, '2022-12-21 22:03:12', '2022-12-21 22:03:12'); INSERT INTO `tb_functions` VALUES (8, '班级管理', '/banji/list', 7, 0, '2022-12-21 22:05:11', '2022-12-21 22:05:11'); INSERT INTO `tb_functions` VALUES (9, '成绩管理', '/chengji/list', 7, 0, '2022-12-21 22:05:58', '2022-12-21 22:05:58'); INSERT INTO `tb_functions` VALUES (10, '教师管理', '/jiaoshi/list', 7, 0, '2022-12-21 22:06:28', '2022-12-21 22:06:28'); INSERT INTO `tb_functions` VALUES (11, '课程管理', '/kecheng/list', 7, 0, '2022-12-21 22:07:37', '2022-12-21 22:07:37'); INSERT INTO `tb_functions` VALUES (12, '课程表管理', '/kechengbiao/list', 7, 0, '2022-12-21 22:08:02', '2022-12-21 22:08:02'); INSERT INTO `tb_functions` VALUES (13, '逃课管理', '/taoke/list', 7, 0, '2022-12-21 22:08:26', '2022-12-21 22:08:26'); INSERT INTO `tb_functions` VALUES (14, '选课管理', '/xuanke/list', 7, 0, '2022-12-21 22:08:48', '2022-12-21 22:08:48'); INSERT INTO `tb_functions` VALUES (15, '学生管理', '/xuesheng/list', 7, 0, '2022-12-21 22:09:06', '2022-12-21 22:09:06'); -- ---------------------------- -- Table structure for tb_jiaoshi -- ---------------------------- DROP TABLE IF EXISTS `tb_jiaoshi`; CREATE TABLE `tb_jiaoshi` ( `id` int(4) NOT NULL AUTO_INCREMENT, `name` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL, `pwd` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL, `jiaoshihao` varchar(50) CHARACTER SET gb