/*
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学年第二学期期末考试工作�
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
此学生管理系统是一个综合性的信息管理平台,它依托于当下成熟且完善的SSM框架(Spring, Spring MVC, MyBatis),这一框架组合因其高效、稳定和易于维护的特性,在企业级应用开发中广受欢迎。系统采用Java语言进行开发,Java以其跨平台的特性,能够支持大型商业网站的构建,确保了系统在不同操作系统上的兼容性和稳定性。 在数据存储方面,系统选择了MySQL这一最受欢迎的关系型数据库管理系统(RDBMS)之一。MySQL以其高性能、可靠性和易用性,成为了众多企业和开发者的首选。通过MySQL,系统能够高效地存储和管理大量的学生和用户信息。 系统的核心功能包括对学生、用户等信息的增删改查(CRUD)操作,这些操作是信息管理系统的基础,确保了数据的准确性和实时性。此外,系统还实现了登录和分页功能,登录功能保障了系统的安全性,防止未授权访问;分页功能则提升了数据展示的效率,使用户在浏览大量数据时更加便捷。 在架构设计上,本项目采用了三层架构模式,将系统分为entity层、service层、dao层和controller层。
资源推荐
资源详情
资源评论
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![pptx](https://img-home.csdnimg.cn/images/20210720083543.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![doc](https://img-home.csdnimg.cn/images/20210720083327.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
收起资源包目录
![package](https://csdnimg.cn/release/downloadcmsfe/public/img/package.f3fc750b.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/RAR.png)
共 2 条
- 1
资源评论
![avatar-default](https://csdnimg.cn/release/downloadcmsfe/public/img/lazyLogo2.1882d7f4.png)
![avatar](https://profile-avatar.csdnimg.cn/e10196a6b19240e782aeb00ab14f988d_weixin_62275996.jpg!1)
茶色岛^
- 粉丝: 1821
- 资源: 2
上传资源 快速赚钱
我的内容管理 展开
我的资源 快来上传第一个资源
我的收益
登录查看自己的收益我的积分 登录查看自己的积分
我的C币 登录后查看C币余额
我的收藏
我的下载
下载帮助
![voice](https://csdnimg.cn/release/downloadcmsfe/public/img/voice.245cc511.png)
![center-task](https://csdnimg.cn/release/downloadcmsfe/public/img/center-task.c2eda91a.png)
最新资源
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
![feedback](https://img-home.csdnimg.cn/images/20220527035711.png)
![feedback](https://img-home.csdnimg.cn/images/20220527035711.png)
![feedback-tip](https://img-home.csdnimg.cn/images/20220527035111.png)
安全验证
文档复制为VIP权益,开通VIP直接复制
![dialog-icon](https://csdnimg.cn/release/downloadcmsfe/public/img/green-success.6a4acb44.png)