基于 SSM 开发学生信息管理系统

/* Navicat Premium Data Transfer Source Server : 本地mysql Source Server Type : MySQL Source Server Version : 50735 Source Host : localhost:3306 Source Schema : student_manager Target Server Type : MySQL Target Server Version : 50735 File Encoding : 65001 Date: 21/11/2021 18:27:51 */ CREATE DATABASE student_manager; USE student_manager; SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for approval -- ---------------------------- DROP TABLE IF EXISTS `approval`; CREATE TABLE `approval` ( `aid` int(11) NOT NULL AUTO_INCREMENT, `sid` int(11) NULL DEFAULT NULL, `title` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `reason` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `sDate` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `eDate` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `status` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `attName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `att` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `msg` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`aid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of approval -- ---------------------------- INSERT INTO `approval` VALUES (1, 1, '张无忌要请假', '光明顶被围攻，急需回明教!', '请假', '2021-10-05', '2021-10-10', '等待审批', '张无忌的附件.docx', 'attachment/张无忌的附件.docx', ''); INSERT INTO `approval` VALUES (2, 5, '黄蓉要请假', '有考试需要参加，望老师批准', '请假', '2021-10-06', '2021-10-07', '等待审批', '黄蓉的附件.docx', 'attachment/黄蓉的附件.docx', ''); INSERT INTO `approval` VALUES (3, 7, '小龙女要休学', '身体原因，希望休学', '休学', '2021-10-07', '2022-09-01', '等待审批', '小龙女的附件.docx', 'attachment/小龙女的附件.docx', ''); -- ---------------------------- -- Table structure for arrange_course -- ---------------------------- DROP TABLE IF EXISTS `arrange_course`; CREATE TABLE `arrange_course` ( `ctid` int(11) NOT NULL AUTO_INCREMENT, `oid` int(11) NULL DEFAULT NULL, `rid` int(11) NULL DEFAULT NULL, `weekno` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `week` int(11) NULL DEFAULT NULL, `start` int(11) NULL DEFAULT NULL, `size` int(11) NULL DEFAULT NULL, PRIMARY KEY (`ctid`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of arrange_course -- ---------------------------- INSERT INTO `arrange_course` VALUES (1, 1, 5, '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16', 1, 1, 2); INSERT INTO `arrange_course` VALUES (2, 2, 6, '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16', 1, 3, 2); INSERT INTO `arrange_course` VALUES (3, 4, 7, '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16', 1, 5, 3); INSERT INTO `arrange_course` VALUES (4, 3, 8, '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16', 2, 1, 2); INSERT INTO `arrange_course` VALUES (5, 6, 9, '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16', 2, 5, 2); INSERT INTO `arrange_course` VALUES (6, 7, 10, '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16', 3, 1, 2); INSERT INTO `arrange_course` VALUES (7, 1, 5, '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16', 4, 3, 2); INSERT INTO `arrange_course` VALUES (8, 2, 6, '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16', 4, 9, 2); INSERT INTO `arrange_course` VALUES (9, 3, 7, '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16', 5, 3, 2); INSERT INTO `arrange_course` VALUES (10, 6, 8, '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16', 5, 5, 2); INSERT INTO `arrange_course` VALUES (11, 8, 10, '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16', 1, 3, 2); INSERT INTO `arrange_course` VALUES (12, 9, 9, '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16', 1, 1, 2); INSERT INTO `arrange_course` VALUES (13, 11, 8, '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16', 1, 5, 3); INSERT INTO `arrange_course` VALUES (14, 10, 7, '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16', 2, 3, 2); INSERT INTO `arrange_course` VALUES (15, 13, 6, '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16', 2, 6, 2); INSERT INTO `arrange_course` VALUES (16, 14, 5, '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16', 3, 3, 2); INSERT INTO `arrange_course` VALUES (17, 8, 8, '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16', 4, 5, 2); INSERT INTO `arrange_course` VALUES (18, 9, 7, '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16', 4, 7, 2); INSERT INTO `arrange_course` VALUES (19, 10, 6, '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16', 5, 1, 2); INSERT INTO `arrange_course` VALUES (20, 13, 5, '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16', 5, 7, 2); INSERT INTO `arrange_course` VALUES (24, 1, 10, '1,3,5,7,9,11,13,15', 5, 7, 2); -- ---------------------------- -- Table structure for article -- ---------------------------- DROP TABLE IF EXISTS `article`; CREATE TABLE `article` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `people` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `date` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `url` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of article -- ---------------------------- INSERT INTO `article` VALUES (1, '[教务处]江苏省2021年下半年中小学教师资格考试笔试报名公告', '叶孤城', '2021-10-01', 'article/1-江苏省2021年下半年中小学教师资格考试笔试报名公告.html'); INSERT INTO `article` VALUES (2, '[教务处]关于做好江苏第二师范学院2021届本科毕业设计（论文）抽检评优工作的通知', '花满楼', '2021-10-02', 'article/2-关于做好江苏第二师范学院2021届本科毕业设计（论文）抽检评优工作的通知.html'); INSERT INTO `article` VALUES (3, '[教务处]2021-2022学年校历', '楚留香', '2021-10-03', 'article/3-2021-2022学年校历.html'); INSERT INTO `article` VALUES (4, '[教务处]关于做好2020—2021学年第二学期期末考试工作的通知', '花无缺', '2021-10-04', 'article/4-关于做好2020—2021学年第二学期期末考试工作的通知.html'); INSERT INTO `article` VALUES (5, '[教务处]关于做好2021年秋季江苏省高等学校计算机等级考试报名的通知', '傅红雪', '2021-10-05', 'article/5-关于做好2021年秋季江苏省高等学校计算机等级考试报名的通知.html'); INSERT INTO `article` VALUES (6, '[教务处]江苏省2021年下半年中小学教师资格考试笔试报名公告', '叶孤城', '2021-10-06', 'article/6-江苏省2021年下半年中小学教师资格考试笔试报名公告.html'); INSERT INTO `article` VALUES (7, '[教务处]关于做好江苏第二师范学院2021届本科毕业设计（论文）抽检评优工作的通知', '花满楼', '2021-10-07', 'article/7-关于做好江苏第二师范学院2021届本科毕业设计（论文）抽检评优工作的通知.html'); INSERT INTO `article` VALUES (8, '[教务处]2021-2022学年校历', '楚留香', '2021-10-08', 'article/8-2021-2022学年校历.html'); INSERT INTO `article` VALUES (9, '[教务处]关于做好2020—2021学年第二学期期末考试工作的通知', '花无缺', '2021-10-09', 'article/9-关于做好2020—2021学年第二学期期末考试工作�