学生成绩管理系统源代码、讲解视频

/* Navicat Premium Data Transfer Source Server : localhost Source Server Type : MySQL Source Server Version : 80019 Source Host : localhost:3306 Source Schema : student_manager_system Target Server Type : MySQL Target Server Version : 80019 File Encoding : 65001 Date: 04/04/2023 19:39:02 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for admin -- ---------------------------- DROP TABLE IF EXISTS `admin`; CREATE TABLE `admin` ( `id` int(0) NOT NULL AUTO_INCREMENT, `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '', `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '', `real_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '', `level` tinyint(0) NOT NULL DEFAULT 0, `school` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '', `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '0', `phone` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '', `sex` tinyint(0) NOT NULL DEFAULT 0, `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of admin -- ---------------------------- INSERT INTO `admin` VALUES (1, 'root', 'password', '管理员', 0, '北京大学', '[email protected]', '15658596944', 0, '2020-03-28 15:06:24'); -- ---------------------------- -- Table structure for course -- ---------------------------- DROP TABLE IF EXISTS `course`; CREATE TABLE `course` ( `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '编号', `name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '课程名', `credits` decimal(4, 1) NOT NULL DEFAULT 2.0 COMMENT '学分', `score` int(0) NOT NULL DEFAULT 100 COMMENT '满分', `number` int(0) NOT NULL DEFAULT 32 COMMENT '课时', `year` int(0) NOT NULL DEFAULT 2016 COMMENT '届时', `term` tinyint(0) NOT NULL DEFAULT 0 COMMENT '学期', `type` tinyint(0) NOT NULL DEFAULT 1 COMMENT '类别 1必修 2选修', `profession` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '专业', `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0), PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of course -- ---------------------------- INSERT INTO `course` VALUES ('2016011001', '数字电路基础', 4.0, 100, 18, 2016, 1, 1, '电子信息工程', '2020-05-04 21:36:06'); INSERT INTO `course` VALUES ('2016011002', '大学物理', 4.0, 100, 20, 2016, 1, 1, '电子信息工程', '2020-05-04 21:36:05'); INSERT INTO `course` VALUES ('2016011003', '线性代数', 1.0, 100, 18, 2016, 1, 1, '电子信息工程', '2020-05-04 21:36:04'); INSERT INTO `course` VALUES ('2016011004', '复变函数', 2.0, 100, 18, 2016, 1, 1, '电子信息工程', '2020-05-04 21:36:03'); INSERT INTO `course` VALUES ('2016011005', '模拟电子线路', 4.0, 100, 18, 2016, 1, 1, '电子信息工程', '2020-05-04 21:36:02'); INSERT INTO `course` VALUES ('2016011006', '信号与系统', 2.0, 100, 18, 2016, 1, 1, '电子信息工程', '2020-05-04 21:36:01'); INSERT INTO `course` VALUES ('2016011007', '大学英语', 4.0, 100, 18, 2016, 1, 1, '电子信息工程', '2020-05-04 21:36:07'); INSERT INTO `course` VALUES ('2016011008', '体育', 1.0, 100, 16, 2016, 1, 1, '电子信息工程', '2020-05-04 21:36:08'); INSERT INTO `course` VALUES ('2016011009', '电子技术', 2.0, 100, 16, 2016, 1, 1, '电子信息工程', '2020-05-04 21:36:09'); INSERT INTO `course` VALUES ('2016011010', '多媒体技术', 2.0, 100, 18, 2016, 1, 1, '电子信息工程', '2020-05-04 21:36:10'); INSERT INTO `course` VALUES ('2016021001', '物联网工程导论', 2.0, 100, 18, 2016, 1, 1, '物联网', '2020-05-04 21:36:10'); INSERT INTO `course` VALUES ('2016021002', '物联网安全', 2.0, 100, 18, 2016, 1, 1, '物联网', '2020-05-04 21:40:55'); INSERT INTO `course` VALUES ('2016021003', '现代通信技术', 1.0, 100, 18, 2016, 1, 1, '物联网', '2020-05-04 21:47:11'); INSERT INTO `course` VALUES ('2016021004', '无线传感器网络', 4.0, 100, 18, 2016, 1, 1, '物联网', '2020-05-04 21:51:16'); INSERT INTO `course` VALUES ('2016021005', '现代传感器技术', 2.0, 100, 18, 2016, 1, 1, '物联网', '2020-05-04 21:52:23'); INSERT INTO `course` VALUES ('2016021006', '信号与系统概论', 2.0, 100, 18, 2016, 1, 1, '物联网', '2020-05-04 21:53:33'); INSERT INTO `course` VALUES ('2016031001', '计算机网络技术', 1.0, 100, 18, 2016, 1, 1, '计算机', '2020-05-04 21:54:51'); INSERT INTO `course` VALUES ('2016031002', '网络与通信', 1.0, 100, 18, 2016, 1, 1, '计算机', '2020-05-04 21:55:28'); INSERT INTO `course` VALUES ('2016031003', '计算机安全', 2.0, 100, 15, 2016, 1, 1, '计算机', '2020-05-04 21:55:51'); INSERT INTO `course` VALUES ('2016031004', '算法与数据结构', 4.0, 100, 18, 2016, 1, 1, '计算机', '2020-05-04 21:56:17'); INSERT INTO `course` VALUES ('2016031005', '多媒体信息处理', 2.0, 100, 14, 2016, 1, 1, '计算机', '2020-05-04 21:56:42'); INSERT INTO `course` VALUES ('2016031006', '计算机组成原理', 2.0, 100, 18, 2016, 1, 1, '计算机', '2020-05-04 21:57:38'); INSERT INTO `course` VALUES ('2016041001', '高频电子线路', 4.0, 100, 18, 2016, 1, 1, '通信工程', '2020-05-04 21:58:30'); INSERT INTO `course` VALUES ('2016041002', '光纤通讯', 2.0, 100, 16, 2016, 1, 1, '通信工程', '2020-05-04 21:58:44'); INSERT INTO `course` VALUES ('2016041003', '移动通讯', 1.0, 100, 18, 2016, 1, 1, '通信工程', '2020-05-04 21:58:59'); INSERT INTO `course` VALUES ('2016041004', '电路分析', 1.0, 100, 18, 2016, 1, 1, '通信工程', '2020-05-04 21:59:12'); INSERT INTO `course` VALUES ('2016041005', '程控交换技术', 2.0, 100, 18, 2016, 1, 1, '通信工程', '2020-05-04 22:05:37'); INSERT INTO `course` VALUES ('2016041006', '通信原理', 4.0, 100, 18, 2016, 1, 1, '通信工程', '2020-05-04 22:05:57'); -- ---------------------------- -- Table structure for course_info -- ---------------------------- DROP TABLE IF EXISTS `course_info`; CREATE TABLE `course_info` ( `id` int(0) NOT NULL AUTO_INCREMENT, `course_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `start` int(0) NOT NULL, `end` int(0) NOT NULL, `room` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `profession` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 30 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of course_info -- ---------------------------- INSERT INTO `course_info` VALUES (1, '2016011001', 1, 25, '404', '电子信息工程'); INSERT INTO `course_info` VALUES (2, '2016011002', 1, 25, '401', '电子信息工程'); INSERT INTO `course_info` VALUES (3, '2016011003', 1, 25, '403', '电子信息工程'); INSERT INTO `course_info` VALUES (4, '2016011004', 1, 25, '406', '电子信息工程'); INSERT INTO `course_info` VALUES (5, '2016011005', 1, 25, '405', '电子信息工程'); INSERT INTO `course_info` VALUES (6, '2016011006', 1, 25, '402', '电子信息工程'); INSERT INTO `course_info` VALUES (7, '2016021001', 1, 25, '505', '物联网'); INSERT INTO `course_info` VALUES (8, '2016021002', 1, 25, NULL, '物联网