• 基于springboot学生管理系统设计与实现

    摘　　要

    目前，借助信息管理系统能够有效解决高校的信息管理问题，对于提高教育管理水平有着非常重要的作用。 因此，有必要建立一个与之相适应的管理信息系统。基于此，本文为了使教师高效地管理学生信息，需要对现代的学生 信息管理系统进行设计与实现，建立一个快速、简单、规范、标准化的学校办公管理平台。

    本学生管理系统系统是根据目前学校实际情况的实际需求而设计的，采用了B/S结构和MVC三层设计模式、springboot mybatis技术、idea集成开发环境、mysql数据库。本本学生管理系统系统主要包括系统用户登录、选课管理、教评管理、校建管理、教师管理和学生管理,校园新闻，系统管理等多个模块。本文在开发学生信息管理系统的过程中，选取适合Java开发 语言的 MVC 架构开发模式。该开发模式能够降 低学生信息管理业务逻辑之间的耦合度，不仅能够使学生信息 管理的业务更加清晰，也能为系统的数据安全提供保障。

    关键词： springboot学生管理系统：mysql数据库; html

    Design and implementation of head teacher management system

    Abstract

    At present, with the help of information management system can effectively solve the problem of information management in Colleges and universities, which plays a very important role in improving the level of education management. Therefore, it is necessary to establish a corresponding management information system. Based on this, in order to make teachers manage student information efficiently, we need to design and implement a modern student information management system, and establish a fast, simple, standardized and standardized school office management platform.

    The head teacher management system is designed according to the actual needs of the current situation of the school, using the B / S structure and MVC three-tier design mode, springboot mybatis technology, idea integrated development environment, MySQL database. The head teacher management system mainly includes user login, course selection management, teaching evaluation management, school construction management, teacher management and student management. In the process of developing student information management system, this paper selects the MVC architecture development mode suitable for java development language. The development mode can reduce the coupling degree between the business logic of student information management, which can not only make the business of student information management more clear, but also provide guarantee for the data security of the system.

    Key words: springboot head teacher management system: MySQL database; HTML

    目　　录

    摘　　要

    Abstract

    1 绪论

    1.1系统开发背景

    1.2 系统研究意义

    1.3 学生管理系统现状

    1.4 论文结构

    2 系统的相关技术

    2.1 HTML语言介绍

    2.2 springboot简介

    2.3 B/S模式介绍

    2.4 MVC三层框架

    2.5数据库技术

    3 系统分析

    3.1 需求分析

    3.2可行性分析

    3.3业务流程图分析

    3.3.1业务流程图

    3.3.2系统业务流程图

    4 系统设计

    4.1系统总体设计

    4.1.1系统功能设计

    4.1.2系统模块设计

    4.2数据库设计

    4.2.1数据库需求分析

    4.2.2数据库概念设计

    4.2.3 数据库逻辑设计

    5 系统实现

    5.1网站首页

    5.2系统界面

    5.2用户登录模块

    5.2.1选课管理模块 ......................................................

    5.2.2教评管理模块

    5.2.3校建管理模块

    5.2.4教师管理模块

    5.2.5学生管理模块

    5.2.6课程管理模块

    5.2.7校园新闻模块 .....................................................

    5.2.8系统管理模块................................................... ...

    6 系统测试

    6.1测试概述

    6.2系统测试

    7 结束语

    参考文献

    致    谢

    pom.xml

    1. <?xml version="1.0" encoding="UTF-8"?>
    2. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    3.          xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    4.     <modelVersion>4.0.0</modelVersion>
    5.  
    6.     <groupId>com</groupId>
    7.     <artifactId>studentsystem</artifactId>
    8.     <version>0.0.1</version>
    9.     <packaging>jar</packaging>
    10.  
    11.     <name>studentsystem</name>
    12.     <description>Demo project for Spring Boot</description>
    13.  
    14.     <parent>
    15.         <groupId>org.springframework.boot</groupId>
    16.         <artifactId>spring-boot-starter-parent</artifactId>
    17.         <version>2.0.3.RELEASE</version>
    18.         <relativePath/> <!-- lookup parent from repository -->
    19.     </parent>
    20.  
    21.     <properties>
    22.         <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    23.         <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
    24.         <java.version>1.8</java.version>
    25.  
    26.         <shiro.version>1.4.0</shiro.version>
    27.         <mybatis-plus-boot-starter.version>3.0-RC1</mybatis-plus-boot-starter.version>
    28.         <HikariCP.version>3.2.0</HikariCP.version>
    29.         <commons-lang3.version>3.4</commons-lang3.version>
    30.         <commons-codec.version>1.11</commons-codec.version>
    31.         <fastjson.version>1.2.41</fastjson.version>
    32.         <!--<jackson.version>2.9.0</jackson.version>-->
    33.     </properties>
    34.  
    35.  
    36.     <dependencies>
    37.         <dependency>
    38.             <groupId>org.springframework.boot</groupId>
    39.             <artifactId>spring-boot-starter-thymeleaf</artifactId>
    40.         </dependency>
    41.         <dependency>
    42.             <groupId>org.springframework.boot</groupId>
    43.             <artifactId>spring-boot-starter-web</artifactId>
    44.         </dependency>
    45.         <dependency>
    46.             <groupId>org.springframework.boot</groupId>
    47.             <artifactId>spring-boot-starter-aop</artifactId>
    48.         </dependency>
    49.         <dependency>
    50.             <groupId>org.springframework</groupId>
    51.             <artifactId>spring-context-support</artifactId>
    52.         </dependency>
    53.  
    54.         <dependency>
    55.             <groupId>org.springframework.boot</groupId>
    56.             <artifactId>spring-boot-starter-test</artifactId>
    57.             <scope>test</scope>
    58.         </dependency>
    59.  
    60.         <dependency>
    61.             <groupId>mysql</groupId>
    62.             <artifactId>mysql-connector-java</artifactId>
    63.             <version>8.0.12</version>
    64.         </dependency>
    65.  
    66.         <!-- 自定义引入 -->
    67.         <dependency>
    68.             <groupId>org.springframework.boot</groupId>
    69.             <artifactId>spring-boot-starter-cache</artifactId>
    70.         </dependency>
    71.         <!--加入分页依赖-->
    72.         <dependency>
    73.             <groupId>com.github.pagehelper</groupId>
    74.             <artifactId>pagehelper-spring-boot-starter</artifactId>
    75.             <version>1.2.3</version>
    76.         </dependency>
    77.         <dependency>
    78.             <groupId>org.apache.commons</groupId>
    79.             <artifactId>commons-lang3</artifactId>
    80.             <version>${commons-lang3.version}</version>
    81.         </dependency>
    82.  
    83.         <dependency>
    84.             <groupId>commons-codec</groupId>
    85.             <artifactId>commons-codec</artifactId>
    86.             <version>${commons-codec.version}</version>
    87.         </dependency>
    88.  
    89.         <dependency>
    90.             <groupId>com.alibaba</groupId>
    91.             <artifactId>fastjson</artifactId>
    92.             <version>${fastjson.version}</version>
    93.         </dependency>
    94.  
    95.  
    96.         <!-- mybatis-plus begin -->
    97.         <dependency>
    98.             <groupId>com.baomidou</groupId>
    99.             <artifactId>mybatis-plus-boot-starter</artifactId>
    100.             <version>${mybatis-plus-boot-starter.version}</version>
    101.         </dependency>
    102.         <!-- mybatis-plus end -->
    103.  
    104.  
    105.         <!--shiro begin-->
    106.         <dependency>
    107.             <groupId>org.apache.shiro</groupId>
    108.             <artifactId>shiro-web</artifactId>
    109.             <version>${shiro.version}</version>
    110.         </dependency>
    111.         <dependency>
    112.             <groupId>org.apache.shiro</groupId>
    113.             <artifactId>shiro-cas</artifactId>
    114.             <version>${shiro.version}</version>
    115.         </dependency>
    116.  
    117.         <dependency>
    118.             <groupId>org.apache.shiro</groupId>
    119.             <artifactId>shiro-core</artifactId>
    120.             <version>${shiro.version}</version>
    121.         </dependency>
    122.  
    123.         <dependency>
    124.             <groupId>org.apache.shiro</groupId>
    125.             <artifactId>shiro-spring</artifactId>
    126.             <version>${shiro.version}</version>
    127.         </dependency>
    128.  
    129.         <dependency>
    130.             <groupId>org.apache.shiro</groupId>
    131.             <artifactId>shiro-ehcache</artifactId>
    132.             <version>${shiro.version}</version>
    133.         </dependency>
    134.  
    135.         <dependency>
    136.             <groupId>com.github.theborakompanioni</groupId>
    137.             <artifactId>thymeleaf-extras-shiro</artifactId>
    138.             <version>2.0.0</version>
    139.         </dependency>
    140.  
    141.         <!--shiro end-->
    142.  
    143.         <dependency>
    144.             <groupId>com.cuisongliu</groupId>
    145.             <artifactId>kaptcha-spring-boot-autoconfigure</artifactId>
    146.             <version>1.3</version>
    147.             <exclusions>
    148.                 <exclusion>
    149.                     <artifactId>javax.servlet-api</artifactId>
    150.                     <groupId>javax.servlet</groupId>
    151.                 </exclusion>
    152.             </exclusions>
    153.         </dependency>
    154.  
    155.         <dependency>
    156.             <groupId>org.springframework.boot</groupId>
    157.             <artifactId>spring-boot-devtools</artifactId>
    158.             <optional>true</optional>
    159.         </dependency>
    160.         <dependency>
    161.             <groupId>org.mybatis</groupId>
    162.             <artifactId>mybatis</artifactId>
    163.             <version>3.5.2</version>
    164.         </dependency>
    165.         <dependency>
    166.             <groupId>org.mybatis</groupId>
    167.             <artifactId>mybatis</artifactId>
    168.             <version>3.4.6</version>
    169.         </dependency>
    170.  
    171.         <dependency>
    172.             <groupId>org.springframework.boot</groupId>
    173.             <artifactId>spring-boot-devtools</artifactId>
    174.             <optional>true</optional>
    175.         </dependency>
    176.         <dependency>
    177.             <groupId>org.springframework</groupId>
    178.             <artifactId>spring-test</artifactId>
    179.             <version>5.0.4.RELEASE</version>
    180.         </dependency>
    181.  
    182.     </dependencies>
    183.  
    184.     <build>
    185.         <plugins>
    186.             <plugin>
    187.                 <groupId>org.apache.maven.plugins</groupId>
    188.                 <artifactId>maven-compiler-plugin</artifactId>
    189.                 <configuration>
    190.                     <source>1.8</source>
    191.                     <target>1.8</target>
    192.                 </configuration>
    193.             </plugin>
    194.             <plugin>
    195.                 <groupId>org.apache.maven.plugins</groupId>
    196.                 <artifactId>maven-surefire-plugin</artifactId>
    197.                 <configuration>
    198.                     <skipTests>true</skipTests>
    199.                 </configuration>
    200.             </plugin>
    201.             <plugin>
    202.                 <groupId>org.springframework.boot</groupId>
    203.                 <artifactId>spring-boot-maven-plugin</artifactId>
    204.                 <version>2.0.3.RELEASE</version>
    205.                 <configuration>
    206.                     <mainClass>com.studentsystem.StudentsystemApplication</mainClass>
    207.                 </configuration>
    208.                 <executions>
    209.                     <execution>
    210.                         <goals>
    211.                             <goal>repackage</goal>
    212.                         </goals>
    213.                     </execution>
    214.                 </executions>
    215.             </plugin>
    216.         </plugins>
    217.         <resources>
    218.             <resource>
    219.                 <directory>src/main/java</directory>
    220.                 <includes>
    221.                     <include>**/*.xml</include>
    222.                 </includes>
    223.                 <filtering>false</filtering>
    224.             </resource>
    225.             <resource>
    226.                 <directory>src/main/resources</directory>
    227.                 <includes>
    228.                     <include>**/*.*</include>
    229.                 </includes>
    230.                 <filtering>false</filtering>
    231.             </resource>
    232.         </resources>
    233.     </build>
    234.     <repositories><!-- 代码库 -->
    235.         <repository>
    236.             <id>maven-ali</id>
    237.             <url>http://maven.aliyun.com/nexus/content/groups/public//</url>
    238.             <releases>
    239.                 <enabled>true</enabled>
    240.             </releases>
    241.             <snapshots>
    242.                 <enabled>true</enabled>
    243.                 <updatePolicy>always</updatePolicy>
    244.                 <checksumPolicy>fail</checksumPolicy>
    245.             </snapshots>
    246.         </repository>
    247.     </repositories>
    248.  
    249. </project>

    数据库文件：

    1.  
    2.  
    3. SET FOREIGN_KEY_CHECKS=0;
    4.  
    5. -- ----------------------------
    6. -- Table structure for classinfo
    7. -- ----------------------------
    8. DROP TABLE IF EXISTS `classinfo`;
    9. CREATE TABLE `classinfo` (
    10.   `classid` int(11) NOT NULL AUTO_INCREMENT,
    11.   `classname` varchar(50) NOT NULL,
    12.   `begintime` date DEFAULT NULL,
    13.   `endtime` date DEFAULT NULL,
    14.   `ccount` int(11) NOT NULL DEFAULT '0',
    15.   `gid` int(11) NOT NULL,
    16.   `is_del` int(11) NOT NULL DEFAULT '0',
    17.   PRIMARY KEY (`classid`) USING BTREE,
    18.   KEY `gid` (`gid`) USING BTREE,
    19.   CONSTRAINT `classinfo_ibfk_1` FOREIGN KEY (`gid`) REFERENCES `grade` (`gid`)
    20. ) ENGINE=InnoDB AUTO_INCREMENT=118 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
    21.  
    22. -- ----------------------------
    23. -- Records of classinfo
    24. -- ----------------------------
    25. INSERT INTO `classinfo` VALUES ('112', '软件工程2班', null, null, '4', '33', '0');
    26. INSERT INTO `classinfo` VALUES ('113', '电子15012班', null, null, '0', '34', '0');
    27. INSERT INTO `classinfo` VALUES ('114', '电子1501\n', null, null, '0', '35', '0');
    28. INSERT INTO `classinfo` VALUES ('115', 'java班', null, null, '1', '33', '0');
    29. INSERT INTO `classinfo` VALUES ('116', '软件1班', null, null, '0', '33', '0');
    30. INSERT INTO `classinfo` VALUES ('117', '软件666班', null, null, '1', '33', '0');
    31.  
    32. -- ----------------------------
    33. -- Table structure for course
    34. -- ----------------------------
    35. DROP TABLE IF EXISTS `course`;
    36. CREATE TABLE `course` (
    37.   `cid` int(11) NOT NULL AUTO_INCREMENT,
    38.   `cname` varchar(200) NOT NULL,
    39.   `ccredit` decimal(9,2) NOT NULL,
    40.   `cperiod` decimal(9,2) NOT NULL,
    41.   `cstate` int(11) NOT NULL DEFAULT '0',
    42.   `cselcount` int(11) NOT NULL DEFAULT '0',
    43.   `cmaxcount` int(11) NOT NULL DEFAULT '0',
    44.   `studytype` varchar(10) NOT NULL,
    45.   `ctid` int(11) NOT NULL,
    46.   `mid` int(11) NOT NULL,
    47.   `is_del` int(11) NOT NULL DEFAULT '0',
    48.   PRIMARY KEY (`cid`) USING BTREE,
    49.   KEY `ctid` (`ctid`) USING BTREE,
    50.   KEY `mid` (`mid`) USING BTREE,
    51.   CONSTRAINT `course_ibfk_1` FOREIGN KEY (`ctid`) REFERENCES `course_type` (`ctid`),
    52.   CONSTRAINT `course_ibfk_2` FOREIGN KEY (`mid`) REFERENCES `major` (`mid`)
    53. ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
    54.  
    55. -- ----------------------------
    56. -- Records of course
    57. -- ----------------------------
    58. INSERT INTO `course` VALUES ('1', 'java 基础', '4.00', '64.00', '0', '0', '100', '必修', '2', '13', '0');
    59. INSERT INTO `course` VALUES ('2', 'python学习', '9.00', '100.00', '0', '0', '100', '选修', '2', '14', '0');
    60. INSERT INTO `course` VALUES ('3', '结构和数据', '8.00', '80.00', '0', '0', '50', '选修', '3', '13', '0');
    61. INSERT INTO `course` VALUES ('4', '数据库设计', '7.00', '80.00', '0', '0', '80', '选修', '1', '13', '0');
    62.  
    63. -- ----------------------------
    64. -- Table structure for course_type
    65. -- ----------------------------
    66. DROP TABLE IF EXISTS `course_type`;
    67. CREATE TABLE `course_type` (
    68.   `ctid` int(11) NOT NULL AUTO_INCREMENT,
    69.   `ctname` varchar(100) NOT NULL,
    70.   PRIMARY KEY (`ctid`) USING BTREE
    71. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
    72.  
    73. -- ----------------------------
    74. -- Records of course_type
    75. -- ----------------------------
    76. INSERT INTO `course_type` VALUES ('1', '专业基础课');
    77. INSERT INTO `course_type` VALUES ('2', '公共课');
    78. INSERT INTO `course_type` VALUES ('3', '任选课');
    79.  
    80. -- ----------------------------
    81. -- Table structure for department
    82. -- ----------------------------
    83. DROP TABLE IF EXISTS `department`;
    84. CREATE TABLE `department` (
    85.   `did` int(11) NOT NULL AUTO_INCREMENT,
    86.   `dname` varchar(50) NOT NULL,
    87.   `dcount` int(11) NOT NULL DEFAULT '0',
    88.   `is_del` int(11) NOT NULL DEFAULT '0',
    89.   PRIMARY KEY (`did`) USING BTREE
    90. ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
    91.  
    92. -- ----------------------------
    93. -- Records of department
    94. -- ----------------------------
    95. INSERT INTO `department` VALUES ('1', '文学系', '0', '0');
    96. INSERT INTO `department` VALUES ('7', '计算机', '6', '0');
    97. INSERT INTO `department` VALUES ('8', '电子信息系', '0', '0');
    98. INSERT INTO `department` VALUES ('9', '音乐系', '0', '0');
    99.  
    100. -- ----------------------------
    101. -- Table structure for dropout
    102. -- ----------------------------
    103. DROP TABLE IF EXISTS `dropout`;
    104. CREATE TABLE `dropout` (
    105.   `drid` int(11) NOT NULL AUTO_INCREMENT,
    106.   `drreason` longtext NOT NULL,
    107.   `sid` int(11) DEFAULT NULL,
    108.   PRIMARY KEY (`drid`) USING BTREE,
    109.   KEY `sid` (`sid`) USING BTREE,
    110.   CONSTRAINT `dropout_ibfk_1` FOREIGN KEY (`sid`) REFERENCES `student` (`sid`)
    111. ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
    112.  
    113. -- ----------------------------
    114. -- Records of dropout
    115. -- ----------------------------
    116. INSERT INTO `dropout` VALUES ('12', 'xxxxxxxxxxxxxxxxxx', '15020001');
    117.  
    118. -- ----------------------------
    119. -- Table structure for evaluate_list
    120. -- ----------------------------
    121. DROP TABLE IF EXISTS `evaluate_list`;
    122. CREATE TABLE `evaluate_list` (
    123.   `elid` int(11) NOT NULL AUTO_INCREMENT,
    124.   `elcontent` varchar(500) NOT NULL,
    125.   PRIMARY KEY (`elid`) USING BTREE
    126. ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
    127.  
    128. -- ----------------------------
    129. -- Records of evaluate_list
    130. -- ----------------------------
    131. INSERT INTO `evaluate_list` VALUES ('1', '讲师是否能坚持进行随堂测试，及时激励和督促学生的学习');
    132. INSERT INTO `evaluate_list` VALUES ('2', '讲师是否能提前五分钟入班并准时上课？');
    133. INSERT INTO `evaluate_list` VALUES ('3', '讲师的授课内容是否条理清晰、表达准确、操作熟练、逻辑性强？');
    134. INSERT INTO `evaluate_list` VALUES ('4', '课堂气氛是否活跃，你对所学知识是否感兴趣并能积极参与？');
    135. INSERT INTO `evaluate_list` VALUES ('5', '在做练习或项目时讲师是否保持在班内巡视，随时监督学生进度并及时发现和解决问题？');
    136. INSERT INTO `evaluate_list` VALUES ('6', '讲师是否能在课程结束时及时总结，便于我对知识点的理解和掌握？');
    137. INSERT INTO `evaluate_list` VALUES ('7', '讲师是否能对作业或练习中的问题进行集中讲解或单个点评？');
    138. INSERT INTO `evaluate_list` VALUES ('8', '讲师是否能够严格要求学生并积极耐心的解答学生疑问？');
    139. INSERT INTO `evaluate_list` VALUES ('9', '讲师是否能够诚实讲授知识，从不诱导我为其授课结果虚高打分？');
    140. INSERT INTO `evaluate_list` VALUES ('10', '讲师是否能对学生认真负责，责任心强？');
    141.  
    142. -- ----------------------------
    143. -- Table structure for evaluate_record
    144. -- ----------------------------
    145. DROP TABLE IF EXISTS `evaluate_record`;
    146. CREATE TABLE `evaluate_record` (
    147.   `erid` int(11) NOT NULL AUTO_INCREMENT,
    148.   `stuid` varchar(20) NOT NULL,
    149.   `tchid` varchar(20) NOT NULL,
    150.   `erexam` int(11) NOT NULL,
    151.   `is_del` int(11) NOT NULL DEFAULT '0',
    152.   PRIMARY KEY (`erid`) USING BTREE
    153. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
    154.  
    155. -- ----------------------------
    156. -- Records of evaluate_record
    157. -- ----------------------------
    158.  
    159. -- ----------------------------
    160. -- Table structure for grade
    161. -- ----------------------------
    162. DROP TABLE IF EXISTS `grade`;
    163. CREATE TABLE `grade` (
    164.   `gid` int(11) NOT NULL AUTO_INCREMENT,
    165.   `gname` varchar(20) NOT NULL,
    166.   `gcount` int(5) unsigned zerofill NOT NULL DEFAULT '00000',
    167.   `mid` int(11) NOT NULL,
    168.   `is_del` int(11) NOT NULL DEFAULT '0',
    169.   PRIMARY KEY (`gid`) USING BTREE,
    170.   KEY `mid` (`mid`) USING BTREE,
    171.   CONSTRAINT `grade_ibfk_1` FOREIGN KEY (`mid`) REFERENCES `major` (`mid`)
    172. ) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
    173.  
    174. -- ----------------------------
    175. -- Records of grade
    176. -- ----------------------------
    177. INSERT INTO `grade` VALUES ('33', '1502', '00006', '13', '0');
    178. INSERT INTO `grade` VALUES ('34', '电科1501\n', '00000', '15', '0');
    179. INSERT INTO `grade` VALUES ('35', '电子15级', '00000', '14', '0');
    180.  
    181. -- ----------------------------
    182. -- Table structure for major
    183. -- ----------------------------
    184. DROP TABLE IF EXISTS `major`;
    185. CREATE TABLE `major` (
    186.   `mid` int(11) NOT NULL AUTO_INCREMENT,
    187.   `mname` varchar(50) NOT NULL,
    188.   `mcount` int(11) NOT NULL DEFAULT '0',
    189.   `did` int(11) NOT NULL,
    190.   `is_del` int(11) NOT NULL DEFAULT '0',
    191.   PRIMARY KEY (`mid`) USING BTREE,
    192.   KEY `did` (`did`) USING BTREE,
    193.   CONSTRAINT `major_ibfk_1` FOREIGN KEY (`did`) REFERENCES `department` (`did`)
    194. ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
    195.  
    196. -- ----------------------------
    197. -- Records of major
    198. -- ----------------------------
    199. INSERT INTO `major` VALUES ('13', '软件工程', '6', '7', '0');
    200. INSERT INTO `major` VALUES ('14', '电子信息工程', '0', '8', '0');
    201. INSERT INTO `major` VALUES ('15', '电子科学与技术', '0', '8', '0');
    202.  
    203. -- ----------------------------
    204. -- Table structure for newsinfo
    205. -- ----------------------------
    206. DROP TABLE IF EXISTS `newsinfo`;
    207. CREATE TABLE `newsinfo` (
    208.   `nid` int(11) NOT NULL AUTO_INCREMENT,
    209.   `ntitle` text NOT NULL,
    210.   `ncontent` longtext NOT NULL,
    211.   `nauthor` varchar(100) NOT NULL,
    212.   `ntime` datetime DEFAULT CURRENT_TIMESTAMP,
    213.   `nimg` varchar(500) DEFAULT 'http://projects.whn946.cn/images/niceschool/default.jpg',
    214.   PRIMARY KEY (`nid`) USING BTREE
    215. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
    216.  
    217. -- ----------------------------
    218. -- Records of newsinfo
    219. -- ----------------------------
    220. INSERT INTO `newsinfo` VALUES ('1', '活动通知', '因为学校100周年庆典，需要各院系出1-3个节目。', '校园宣传部', '2020-07-26 14:13:40', 'http://projects.whn946.cn/images/niceschool/default.jpg');
    221. INSERT INTO `newsinfo` VALUES ('2', '放假通知', '中秋放假三天', '校领导', '2020-07-26 17:01:44', 'http://projects.whn946.cn/images/niceschool/default.jpg');
    222.  
    223. -- ----------------------------
    224. -- Table structure for politics_type
    225. -- ----------------------------
    226. DROP TABLE IF EXISTS `politics_type`;
    227. CREATE TABLE `politics_type` (
    228.   `pid` int(11) NOT NULL AUTO_INCREMENT,
    229.   `pname` varchar(50) NOT NULL,
    230.   PRIMARY KEY (`pid`) USING BTREE
    231. ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
    232.  
    233. -- ----------------------------
    234. -- Records of politics_type
    235. -- ----------------------------
    236. INSERT INTO `politics_type` VALUES ('1', '中共党员');
    237. INSERT INTO `politics_type` VALUES ('2', '中共预备党员');
    238. INSERT INTO `politics_type` VALUES ('3', '共青团员');
    239. INSERT INTO `politics_type` VALUES ('4', '民革党员');
    240. INSERT INTO `politics_type` VALUES ('5', '民盟盟员');
    241. INSERT INTO `politics_type` VALUES ('6', '民建会员');
    242. INSERT INTO `politics_type` VALUES ('7', '民进会员');
    243. INSERT INTO `politics_type` VALUES ('8', '农工党党员');
    244. INSERT INTO `politics_type` VALUES ('9', '致公党会员');
    245. INSERT INTO `politics_type` VALUES ('10', '九三学社社员');
    246. INSERT INTO `politics_type` VALUES ('11', '台盟盟员');
    247. INSERT INTO `politics_type` VALUES ('12', '无党派人士');
    248. INSERT INTO `politics_type` VALUES ('13', '群众');
    249.  
    250. -- ----------------------------
    251. -- Table structure for schedule
    252. -- ----------------------------
    253. DROP TABLE IF EXISTS `schedule`;
    254. CREATE TABLE `schedule` (
    255.   `schid` int(11) NOT NULL AUTO_INCREMENT,
    256.   `timeinterval` varchar(100) NOT NULL,
    257.   `schname` varchar(100) NOT NULL,
    258.   `summer` varchar(100) NOT NULL,
    259.   `winter` varchar(100) NOT NULL,
    260.   PRIMARY KEY (`schid`) USING BTREE
    261. ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
    262.  
    263. -- ----------------------------
    264. -- Records of schedule
    265. -- ----------------------------
    266. INSERT INTO `schedule` VALUES ('1', '早上', '起床', '6:00', '6:30');
    267. INSERT INTO `schedule` VALUES ('2', '早上', '早操', '6:10-7:00', '6:40-7:00');
    268. INSERT INTO `schedule` VALUES ('3', '早上', '早饭', '7:10', '7:10');
    269. INSERT INTO `schedule` VALUES ('4', '上午', '预备', '8:00', '8:00');
    270. INSERT INTO `schedule` VALUES ('5', '上午', '第一节', '8:10-8:55', '8:10-8:55');
    271. INSERT INTO `schedule` VALUES ('6', '上午', '第二节', '9:05-9:50', '9:05-9:50');
    272. INSERT INTO `schedule` VALUES ('7', '上午', '课间操', '9:50-10:10', '9:50-10:10');
    273. INSERT INTO `schedule` VALUES ('8', '上午', '第三节', '10:10-10:55', '10:10-10:55');
    274. INSERT INTO `schedule` VALUES ('9', '上午', '第四节', '11:05-11:50', '11:05-11:50');
    275. INSERT INTO `schedule` VALUES ('10', '中午', '午饭', '12:00', '12:00');
    276. INSERT INTO `schedule` VALUES ('11', '下午', '预备', '14:30', '14:00');
    277. INSERT INTO `schedule` VALUES ('12', '下午', '第五节', '14:40-15:25', '14:10-14:55');
    278. INSERT INTO `schedule` VALUES ('13', '下午', '第六节', '15:35-16:20', '15:05-15:50');
    279. INSERT INTO `schedule` VALUES ('14', '下午', '课外活动', '16:30-18:00', '16:00-17:30');
    280.  
    281. -- ----------------------------
    282. -- Table structure for stu_course
    283. -- ----------------------------
    284. DROP TABLE IF EXISTS `stu_course`;
    285. CREATE TABLE `stu_course` (
    286.   `scid` int(11) NOT NULL AUTO_INCREMENT,
    287.   `sid` int(11) NOT NULL,
    288.   `cid` int(11) NOT NULL,
    289.   `is_del` int(11) NOT NULL DEFAULT '0',
    290.   PRIMARY KEY (`scid`) USING BTREE,
    291.   KEY `sid` (`sid`) USING BTREE,
    292.   KEY `cid` (`cid`) USING BTREE,
    293.   CONSTRAINT `stu_course_ibfk_1` FOREIGN KEY (`sid`) REFERENCES `student` (`sid`),
    294.   CONSTRAINT `stu_course_ibfk_2` FOREIGN KEY (`cid`) REFERENCES `course` (`cid`)
    295. ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
    296.  
    297. -- ----------------------------
    298. -- Records of stu_course
    299. -- ----------------------------
    300. INSERT INTO `stu_course` VALUES ('1', '15020003', '1', '0');
    301. INSERT INTO `stu_course` VALUES ('2', '15020004', '1', '0');
    302. INSERT INTO `stu_course` VALUES ('3', '15020005', '1', '0');
    303. INSERT INTO `stu_course` VALUES ('4', '15020006', '1', '0');
    304. INSERT INTO `stu_course` VALUES ('5', '738103', '1', '0');
    305.  
    306. -- ----------------------------
    307. -- Table structure for stu_exam
    308. -- ----------------------------
    309. DROP TABLE IF EXISTS `stu_exam`;
    310. CREATE TABLE `stu_exam` (
    311.   `seid` int(11) NOT NULL AUTO_INCREMENT,
    312.   `sid` int(11) NOT NULL,
    313.   `scid` int(11) NOT NULL,
    314.   `normalexam` decimal(9,2) DEFAULT NULL,
    315.   `testexam` decimal(9,2) DEFAULT NULL,
    316.   `sumexam` decimal(9,2) DEFAULT NULL,
    317.   `stime` int(11) NOT NULL,
    318.   `studynature` int(11) NOT NULL,
    319.   `is_del` int(11) NOT NULL DEFAULT '0',
    320.   PRIMARY KEY (`seid`) USING BTREE,
    321.   KEY `sid` (`sid`) USING BTREE,
    322.   KEY `scid` (`scid`) USING BTREE,
    323.   CONSTRAINT `stu_exam_ibfk_1` FOREIGN KEY (`sid`) REFERENCES `student` (`sid`),
    324.   CONSTRAINT `stu_exam_ibfk_2` FOREIGN KEY (`scid`) REFERENCES `stu_course` (`scid`)
    325. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
    326.  
    327. -- ----------------------------
    328. -- Records of stu_exam
    329. -- ----------------------------
    330.  
    331. -- ----------------------------
    332. -- Table structure for student
    333. -- ----------------------------
    334. DROP TABLE IF EXISTS `student`;
    335. CREATE TABLE `student` (
    336.   `sid` int(11) NOT NULL AUTO_INCREMENT,
    337.   `stuid` varchar(20) NOT NULL,
    338.   `sname` varchar(20) NOT NULL,
    339.   `sgender` varchar(20) NOT NULL,
    340.   `sbirthday` date NOT NULL,
    341.   `pid` int(11) NOT NULL,
    342.   `snation` varchar(50) NOT NULL,
    343.   `scardid` varchar(50) NOT NULL,
    344.   `sphone` varchar(50) NOT NULL,
    345.   `saddress` varchar(200) NOT NULL,
    346.   `entertime` date NOT NULL,
    347.   `leavetime` date DEFAULT NULL,
    348.   `stustate` int(11) NOT NULL DEFAULT '0',
    349.   `classid` int(11) NOT NULL,
    350.   `is_del` int(11) NOT NULL DEFAULT '0',
    351.   `mim` varchar(20) NOT NULL DEFAULT '111111',
    352.   PRIMARY KEY (`sid`) USING BTREE,
    353.   KEY `pid` (`pid`) USING BTREE,
    354.   KEY `classid` (`classid`) USING BTREE,
    355.   CONSTRAINT `student_ibfk_1` FOREIGN KEY (`pid`) REFERENCES `politics_type` (`pid`),
    356.   CONSTRAINT `student_ibfk_2` FOREIGN KEY (`classid`) REFERENCES `classinfo` (`classid`)
    357. ) ENGINE=InnoDB AUTO_INCREMENT=15020007 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
    358.  
    359. -- ----------------------------
    360. -- Records of student
    361. -- ----------------------------
    362. INSERT INTO `student` VALUES ('10000', '10000', '年份过渡数据', '年份过渡数据', '2020-06-27', '1', '年份过渡数据', '年份过渡数据', '年份过渡数据', '年份过渡数据', '2020-06-27', '2020-06-27', '1', '112', '1', '111111');
    363. INSERT INTO `student` VALUES ('738103', '738103', '111', '女', '1998-09-08', '1', '汉族', '11111', '17688888888', '', '1502-08-31', null, '0', '112', '0', '111111');
    364. INSERT INTO `student` VALUES ('15020001', '15020001', 'morty', '男', '1996-01-23', '1', '汉族', '412365199601236544', '13744444444', '', '1502-09-01', '2020-06-27', '2', '112', '1', '111111');
    365. INSERT INTO `student` VALUES ('15020002', '15020002', 'morty', '女', '1996-01-23', '1', '汉族', '412365199601236544', '13974444444', 'xxx', '1502-09-01', null, '0', '112', '0', '111111');
    366. INSERT INTO `student` VALUES ('15020003', '15020003', '周二珂', '女', '1998-09-08', '1', '瑶族', '510522199609097654', '18789897876', '', '1502-08-31', null, '0', '115', '0', '111111');
    367. INSERT INTO `student` VALUES ('15020004', '15020004', '周明', '女', '1998-09-08', '1', '汉族', '510522199809099999', '18766666666', '', '1502-08-31', null, '0', '112', '0', '111111');
    368. INSERT INTO `student` VALUES ('15020005', '15020005', '黄周', '女', '1998-09-08', '1', '汉族', '510654199809097777', '17655555555', '', '1502-08-31', null, '0', '117', '0', '111111');
    369. INSERT INTO `student` VALUES ('15020006', '1.5020006E7', '打狗棒', '女', '1994-03-03', '1', '汉族', '51089776666', '18789898989', '', '1502-08-31', null, '0', '112', '0', '111111');
    370.  
    371. -- ----------------------------
    372. -- Table structure for sys_menu
    373. -- ----------------------------
    374. DROP TABLE IF EXISTS `sys_menu`;
    375. CREATE TABLE `sys_menu` (
    376.   `id` varchar(36) NOT NULL,
    377.   `name` varchar(40) DEFAULT NULL COMMENT '菜单名称',
    378.   `parent_id` varchar(36) DEFAULT NULL COMMENT '父菜单',
    379.   `level` bigint(2) DEFAULT NULL COMMENT '菜单层级',
    380.   `parent_ids` varchar(2000) DEFAULT NULL COMMENT '父菜单联集',
    381.   `sort` smallint(6) DEFAULT NULL COMMENT '排序',
    382.   `href` varchar(2000) DEFAULT NULL COMMENT '链接地址',
    383.   `target` varchar(20) DEFAULT NULL COMMENT '打开方式',
    384.   `icon` varchar(100) DEFAULT NULL COMMENT '菜单图标',
    385.   `bg_color` varchar(255) DEFAULT NULL COMMENT '显示背景色',
    386.   `is_show` tinyint(2) DEFAULT NULL COMMENT '是否显示',
    387.   `permission` varchar(200) DEFAULT NULL COMMENT '权限标识',
    388.   `create_by` varchar(36) DEFAULT NULL,
    389.   `create_date` datetime DEFAULT NULL,
    390.   `update_by` varchar(36) DEFAULT NULL,
    391.   `update_date` datetime DEFAULT NULL,
    392.   `remarks` varchar(255) DEFAULT NULL,
    393.   `del_flag` tinyint(2) DEFAULT NULL,
    394.   PRIMARY KEY (`id`) USING BTREE
    395. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
    396.  
    397. -- ----------------------------
    398. -- Records of sys_menu
    399. -- ----------------------------
    400. INSERT INTO `sys_menu` VALUES ('0127fd90587d43c2846f0b6aa563f35c', '教师授课管理', '832e289e4a4d49a68eea3441979ff703', '2', '832e289e4a4d49a68eea3441979ff703,0127fd90587d43c2846f0b6aa563f35c,', '4', '/tchcoursemanage/tchcoursemanage', null, null, '', '1', '', '054a2cd6369c48d8a52d62e0084d4527', '2019-11-07 11:18:28', '054a2cd6369c48d8a52d62e0084d4527', '2019-11-07 11:18:28', null, '0');
    401. INSERT INTO `sys_menu` VALUES ('0516eff241b7418a9ead2111187f9d75', '退学信息', '346bee7d3f7741b58e01ee062c3aba73', '2', '346bee7d3f7741b58e01ee062c3aba73,0516eff241b7418a9ead2111187f9d75,', '4', '/dropoutPage', null, null, '', '1', '', '054a2cd6369c48d8a52d62e0084d4527', '2019-11-20 16:45:52', '054a2cd6369c48d8a52d62e0084d4527', '2019-11-20 16:45:52', null, '0');
    402. INSERT INTO `sys_menu` VALUES ('0ad281e996484506b0064e647bfb1e1c', '成绩查询', '32e652d6788d471196683ca53b948c63', '2', '32e652d6788d471196683ca53b948c63,0ad281e996484506b0064e647bfb1e1c,', '1', '/selectGrade', null, null, '', '1', '', '0684935cb2ae4cd5994155a32603d195', '2019-11-04 15:15:53', '0684935cb2ae4cd5994155a32603d195', '2019-11-06 19:16:56', null, '0');
    403. INSERT INTO `sys_menu` VALUES ('118126c2a71141858ec667c104d7cd3d', '发布新闻', 'bb86050a4b4b498b977f93cccd5b2bec', '2', 'bb86050a4b4b498b977f93cccd5b2bec,118126c2a71141858ec667c104d7cd3d,', '1', '/news/addnews', null, null, '', '1', '', '0684935cb2ae4cd5994155a32603d195', '2019-11-04 01:22:30', '0684935cb2ae4cd5994155a32603d195', '2019-11-04 01:22:30', null, '0');
    404. INSERT INTO `sys_menu` VALUES ('16da2b1c1fa14182816f05850515bdce', '课表查询', '42ff87aec13c409da75b6c7b5ee333ec', '2', '42ff87aec13c409da75b6c7b5ee333ec,16da2b1c1fa14182816f05850515bdce,', '1', '', null, null, '', '1', '', '0684935cb2ae4cd5994155a32603d195', '2019-11-04 15:17:02', '054a2cd6369c48d8a52d62e0084d4527', '2019-11-20 17:17:13', null, '1');
    405. INSERT INTO `sys_menu` VALUES ('19c96fa92510436196066c4d529ddd65', '课目管理', '42ff87aec13c409da75b6c7b5ee333ec', '2', '42ff87aec13c409da75b6c7b5ee333ec,19c96fa92510436196066c4d529ddd65,', '3', '/selCou', null, '', '', '1', '', '0684935cb2ae4cd5994155a32603d195', '2019-11-07 08:20:03', '054a2cd6369c48d8a52d62e0084d4527', '2019-11-07 13:00:38', null, '0');
    406. INSERT INTO `sys_menu` VALUES ('1b84b70acfbd4b12ac3bad1fee892330', '选课管理', null, '1', '1b84b70acfbd4b12ac3bad1fee892330,', '13', '', null, '', '', '1', '', '0684935cb2ae4cd5994155a32603d195', '2019-11-07 08:22:51', '0684935cb2ae4cd5994155a32603d195', '2019-11-07 08:22:51', null, '0');
    407. INSERT INTO `sys_menu` VALUES ('32e652d6788d471196683ca53b948c63', '成绩管理', null, '1', '32e652d6788d471196683ca53b948c63,', '4', '', null, '', '', '1', '', '0684935cb2ae4cd5994155a32603d195', '2019-11-04 15:15:10', 'fcf2cf83960d4a16955a2d79a3f69b1b', '2020-07-26 01:21:01', null, '1');
    408. INSERT INTO `sys_menu` VALUES ('346bee7d3f7741b58e01ee062c3aba73', '学生管理', null, '1', '346bee7d3f7741b58e01ee062c3aba73,', '7', '', null, '', '', '1', '', '0684935cb2ae4cd5994155a32603d195', '2019-11-04 15:23:25', '0684935cb2ae4cd5994155a32603d195', '2019-11-05 15:32:03', null, '0');
    409. INSERT INTO `sys_menu` VALUES ('3b54e2a2-9adb-11e8-aebe-1368d4ec24eb', '用户管理', '7d1020ee-9ad9-11e8-aebe-1368d4ec24eb', '2', '7d1020ee-9ad9-11e8-aebe-1368d4ec24eb,3b54e2a2-9adb-11e8-aebe-1368d4ec24eb,', '9', '/admin/system/user/list', null, '', '#47e69c', '1', 'sys:user:list', '18b8b543-9ad7-11e8-aebe-1368d4ec24eb', '2018-01-16 11:31:18', '18b8b543-9ad7-11e8-aebe-1368d4ec24eb', '2018-01-20 05:59:20', null, '0');
    410. INSERT INTO `sys_menu` VALUES ('3b58e01e-9adb-11e8-aebe-1368d4ec24eb', '角色管理', '7d1020ee-9ad9-11e8-aebe-1368d4ec24eb', '2', '7d1020ee-9ad9-11e8-aebe-1368d4ec24eb,3b58e01e-9adb-11e8-aebe-1368d4ec24eb,', '10', '/admin/system/role/list', null, '', '#c23ab9', '1', 'sys:role:list', '18b8b543-9ad7-11e8-aebe-1368d4ec24eb', '2018-01-16 11:32:33', '18b8b543-9ad7-11e8-aebe-1368d4ec24eb', '2018-01-20 05:58:58', null, '0');
    411. INSERT INTO `sys_menu` VALUES ('3b5cb607-9adb-11e8-aebe-1368d4ec24eb', '权限管理', '7d1020ee-9ad9-11e8-aebe-1368d4ec24eb', '2', '7d1020ee-9ad9-11e8-aebe-1368d4ec24eb,3b5cb607-9adb-11e8-aebe-1368d4ec24eb,', '20', '/admin/system/menu/list', null, '', '#d4573b', '1', 'sys:menu:list', '18b8b543-9ad7-11e8-aebe-1368d4ec24eb', '2018-01-16 11:33:19', '18b8b543-9ad7-11e8-aebe-1368d4ec24eb', '2018-02-08 09:49:28', null, '0');
    412. INSERT INTO `sys_menu` VALUES ('3d2bbd52a26344e59c2b25d615614d44', '班级管理', 'd04edab30f5b4df4af28254e375c2ff6', '2', 'd04edab30f5b4df4af28254e375c2ff6,3d2bbd52a26344e59c2b25d615614d44,', '4', '/schoolmanage/classmanage', null, null, '', '1', '', '0684935cb2ae4cd5994155a32603d195', '2019-11-05 09:28:18', '0684935cb2ae4cd5994155a32603d195', '2019-11-05 09:28:19', null, '0');
    413. INSERT INTO `sys_menu` VALUES ('3e0b86a3-9adc-11e8-aebe-1368d4ec24eb', '新增用户', '3b54e2a2-9adb-11e8-aebe-1368d4ec24eb', '3', '7d1020ee-9ad9-11e8-aebe-1368d4ec24eb,3b54e2a2-9adb-11e8-aebe-1368d4ec24eb,3e0b86a3-9adc-11e8-aebe-1368d4ec24eb,', '0', '', null, null, null, '0', 'sys:user:add', '18b8b543-9ad7-11e8-aebe-1368d4ec24eb', '2018-02-08 10:10:32', '18b8b543-9ad7-11e8-aebe-1368d4ec24eb', '2018-02-08 10:10:32', null, '0');
    414. INSERT INTO `sys_menu` VALUES ('3e2fa8b6-9adc-11e8-aebe-1368d4ec24eb', '编辑用户', '3b54e2a2-9adb-11e8-aebe-1368d4ec24eb', '3', '7d1020ee-9ad9-11e8-aebe-1368d4ec24eb,3b54e2a2-9adb-11e8-aebe-1368d4ec24eb,3e2fa8b6-9adc-11e8-aebe-1368d4ec24eb,', '10', '', null, null, null, '0', 'sys:user:edit', '18b8b543-9ad7-11e8-aebe-1368d4ec24eb', '2018-02-08 10:11:49', '18b8b543-9ad7-11e8-aebe-1368d4ec24eb', '2018-02-08 10:11:49', null, '0');
    415. INSERT INTO `sys_menu` VALUES ('3e36cf2f-9adc-11e8-aebe-1368d4ec24eb', '删除用户', '3b54e2a2-9adb-11e8-aebe-1368d4ec24eb', '3', '7d1020ee-9ad9-11e8-aebe-1368d4ec24eb,3b54e2a2-9adb-11e8-aebe-1368d4ec24eb,3e36cf2f-9adc-11e8-aebe-1368d4ec24eb,', '20', '', null, null, null, '0', 'sys:user:delete', '18b8b543-9ad7-11e8-aebe-1368d4ec24eb', '2018-02-08 10:12:43', '18b8b543-9ad7-11e8-aebe-1368d4ec24eb', '2018-02-08 10:12:43', null, '0');
    416. INSERT INTO `sys_menu` VALUES ('42ff87aec13c409da75b6c7b5ee333ec', '课程管理', null, '1', '42ff87aec13c409da75b6c7b5ee333ec,', '5', '', null, '', '', '1', '', '0684935cb2ae4cd5994155a32603d195', '2019-11-04 15:16:44', '0684935cb2ae4cd5994155a32603d195', '2019-11-05 15:30:30', null, '0');
    417. INSERT INTO `sys_menu` VALUES ('45076bf2dbb5443db49c062994d0fb4b', '专业管理', 'd04edab30f5b4df4af28254e375c2ff6', '2', 'd04edab30f5b4df4af28254e375c2ff6,45076bf2dbb5443db49c062994d0fb4b,', '2', '/schoolmanage/majormanage', null, null, '', '1', '', '0684935cb2ae4cd5994155a32603d195', '2019-11-05 09:27:19', '0684935cb2ae4cd5994155a32603d195', '2019-11-05 09:27:19', null, '0');
    418. INSERT INTO `sys_menu` VALUES ('4d457c31f4fc4e0595c5c6448fe7630a', '新闻管理', 'bb86050a4b4b498b977f93cccd5b2bec', '2', 'bb86050a4b4b498b977f93cccd5b2bec,4d457c31f4fc4e0595c5c6448fe7630a,', '3', '/news/newscontrol', null, null, '', '1', '', '0684935cb2ae4cd5994155a32603d195', '2019-11-04 15:18:13', '0684935cb2ae4cd5994155a32603d195', '2019-11-04 15:18:13', null, '0');
    419. INSERT INTO `sys_menu` VALUES ('4e833c1bd3e8485ab12d4d19269de739', '系部管理', 'd04edab30f5b4df4af28254e375c2ff6', '2', 'd04edab30f5b4df4af28254e375c2ff6,4e833c1bd3e8485ab12d4d19269de739,', '1', '/schoolmanage/dpmmanage', null, null, '', '1', '', '0684935cb2ae4cd5994155a32603d195', '2019-11-05 09:26:32', '0684935cb2ae4cd5994155a32603d195', '2019-11-05 09:26:33', null, '0');
    420. INSERT INTO `sys_menu` VALUES ('4f1451598a344744b0d225790f52aa19', '退课', '4f8ead47ab25421f85f27af3db60a84e', '2', '4f8ead47ab25421f85f27af3db60a84e,4f1451598a344744b0d225790f52aa19,', '2', '/seledCourse', null, null, '', '1', '', '0684935cb2ae4cd5994155a32603d195', '2019-11-07 14:12:55', '0684935cb2ae4cd5994155a32603d195', '2019-11-07 14:12:55', null, '0');
    421. INSERT INTO `sys_menu` VALUES ('4f8ead47ab25421f85f27af3db60a84e', '网上选课', null, '1', '4f8ead47ab25421f85f27af3db60a84e,', '11', '/', null, null, '', '1', '', '0684935cb2ae4cd5994155a32603d195', '2019-11-06 19:16:04', '0684935cb2ae4cd5994155a32603d195', '2019-11-07 14:12:07', null, '0');
    422. INSERT INTO `sys_menu` VALUES ('5178554598814a239475716ed4fef474', '查询学生', '832e289e4a4d49a68eea3441979ff703', '2', '832e289e4a4d49a68eea3441979ff703,5178554598814a239475716ed4fef474,', '5', '/selAllStudent', null, null, '', '1', '', '054a2cd6369c48d8a52d62e0084d4527', '2019-11-22 13:43:20', '054a2cd6369c48d8a52d62e0084d4527', '2019-11-22 13:51:08', null, '0');
    423. INSERT INTO `sys_menu` VALUES ('54b74a2152674cbdbdf63c32daf840c5', '网上教评', null, '1', '54b74a2152674cbdbdf63c32daf840c5,', '6', '/appraise/seltch', null, '', '', '1', '', '0684935cb2ae4cd5994155a32603d195', '2019-11-04 15:18:47', '0684935cb2ae4cd5994155a32603d195', '2019-11-05 15:31:12', null, '0');
    424. INSERT INTO `sys_menu` VALUES ('5940b85334e54463a557f9d7b57f883f', '教师信息修改', '832e289e4a4d49a68eea3441979ff703', '2', '832e289e4a4d49a68eea3441979ff703,5940b85334e54463a557f9d7b57f883f,', '2', '', null, null, '', '1', '', '0684935cb2ae4cd5994155a32603d195', '2019-11-04 15:34:24', '054a2cd6369c48d8a52d62e0084d4527', '2019-11-11 09:48:39', null, '1');
    425. INSERT INTO `sys_menu` VALUES ('69b1c803b1a14a8989cf79c4465c0c7e', '录入教师', '832e289e4a4d49a68eea3441979ff703', '2', '832e289e4a4d49a68eea3441979ff703,69b1c803b1a14a8989cf79c4465c0c7e,', '3', '/addTeacherPage', null, null, '', '1', '', '0684935cb2ae4cd5994155a32603d195', '2019-11-04 15:34:37', '0684935cb2ae4cd5994155a32603d195', '2019-11-06 20:01:58', null, '0');
    426. INSERT INTO `sys_menu` VALUES ('72cfb92b47584cf499624dba63cc553a', '教师成绩查询', '32e652d6788d471196683ca53b948c63', '2', '32e652d6788d471196683ca53b948c63,72cfb92b47584cf499624dba63cc553a,', '4', '/tchExam', null, '', '', '1', '', '054a2cd6369c48d8a52d62e0084d4527', '2019-11-14 17:35:29', 'fcf2cf83960d4a16955a2d79a3f69b1b', '2020-07-26 01:20:53', null, '1');
    427. INSERT INTO `sys_menu` VALUES ('7a3b765260f5422c8d0a22e8d5ea8d05', '教师信息查询', '832e289e4a4d49a68eea3441979ff703', '2', '832e289e4a4d49a68eea3441979ff703,7a3b765260f5422c8d0a22e8d5ea8d05,', '1', '/selectTeacher', null, null, '', '1', '', '0684935cb2ae4cd5994155a32603d195', '2019-11-04 15:33:54', '0684935cb2ae4cd5994155a32603d195', '2019-11-06 19:25:38', null, '0');
    428. INSERT INTO `sys_menu` VALUES ('7ab4c00ce86f4ef8808a16a25625919d', '学生选课管理', '1b84b70acfbd4b12ac3bad1fee892330', '2', '1b84b70acfbd4b12ac3bad1fee892330,7ab4c00ce86f4ef8808a16a25625919d,', '1', '/selCourses', null, null, '', '1', '', '0684935cb2ae4cd5994155a32603d195', '2019-11-07 08:27:04', '054a2cd6369c48d8a52d62e0084d4527', '2019-11-07 13:01:45', null, '0');
    429. INSERT INTO `sys_menu` VALUES ('7d1020ee-9ad9-11e8-aebe-1368d4ec24eb', '系统管理', null, '1', '7d1020ee-9ad9-11e8-aebe-1368d4ec24eb,', '1', '', null, '', null, '1', '', '18b8b543-9ad7-11e8-aebe-1368d4ec24eb', '2018-01-16 11:29:46', '18b8b543-9ad7-11e8-aebe-1368d4ec24eb', '2018-01-20 03:09:26', null, '0');
    430. INSERT INTO `sys_menu` VALUES ('832e289e4a4d49a68eea3441979ff703', '教师管理', null, '1', '832e289e4a4d49a68eea3441979ff703,', '8', '', null, '', '', '1', '', '0684935cb2ae4cd5994155a32603d195', '2019-11-04 15:23:46', '0684935cb2ae4cd5994155a32603d195', '2019-11-05 15:32:13', null, '0');
    431. INSERT INTO `sys_menu` VALUES ('894cc49337bf49cb83b91f859e471349', '新闻查询', 'bb86050a4b4b498b977f93cccd5b2bec', '2', 'bb86050a4b4b498b977f93cccd5b2bec,894cc49337bf49cb83b91f859e471349,', '2', '', null, null, '', '1', '', '0684935cb2ae4cd5994155a32603d195', '2019-11-04 15:11:00', '0684935cb2ae4cd5994155a32603d195', '2019-11-05 09:29:06', null, '1');
    432. INSERT INTO `sys_menu` VALUES ('8c4743e9a38446e7b13f7e0b6b97a28e', '年级管理', 'd04edab30f5b4df4af28254e375c2ff6', '2', 'd04edab30f5b4df4af28254e375c2ff6,8c4743e9a38446e7b13f7e0b6b97a28e,', '3', '/schoolmanage/grademanage', null, null, '', '1', '', '0684935cb2ae4cd5994155a32603d195', '2019-11-05 09:27:52', '0684935cb2ae4cd5994155a32603d195', '2019-11-05 09:27:52', null, '0');
    433. INSERT INTO `sys_menu` VALUES ('93979ed945b94fee9a53dbdc184a8eee', '教评问题管理', 'c457ebb1ad6f47afa69ccc32d6b73b1a', '2', 'c457ebb1ad6f47afa69ccc32d6b73b1a,93979ed945b94fee9a53dbdc184a8eee,', '1', '/appraise/evlistcontrol', null, null, '', '1', '', '0684935cb2ae4cd5994155a32603d195', '2019-11-05 13:58:29', '0684935cb2ae4cd5994155a32603d195', '2019-11-05 13:58:29', null, '0');
    434. INSERT INTO `sys_menu` VALUES ('95273203460543e8942174ec460a6f12', '正选', '4f8ead47ab25421f85f27af3db60a84e', '2', '4f8ead47ab25421f85f27af3db60a84e,95273203460543e8942174ec460a6f12,', '1', '/course/sel', null, null, '', '1', '', '0684935cb2ae4cd5994155a32603d195', '2019-11-07 14:11:26', '0684935cb2ae4cd5994155a32603d195', '2019-11-07 14:11:26', null, '0');
    435. INSERT INTO `sys_menu` VALUES ('96fd6a5a-9adb-11e8-aebe-1368d4ec24eb', '新增权限', '3b5cb607-9adb-11e8-aebe-1368d4ec24eb', '3', '7d1020ee-9ad9-11e8-aebe-1368d4ec24eb,3b5cb607-9adb-11e8-aebe-1368d4ec24eb,96fd6a5a-9adb-11e8-aebe-1368d4ec24eb,', '0', '', null, null, null, '0', 'sys:menu:add', '18b8b543-9ad7-11e8-aebe-1368d4ec24eb', '2018-02-08 09:49:15', '18b8b543-9ad7-11e8-aebe-1368d4ec24eb', '2018-02-08 09:49:38', null, '0');
    436. INSERT INTO `sys_menu` VALUES ('9703ccf2-9adb-11e8-aebe-1368d4ec24eb', '编辑权限', '3b5cb607-9adb-11e8-aebe-1368d4ec24eb', '3', '7d1020ee-9ad9-11e8-aebe-1368d4ec24eb,3b5cb607-9adb-11e8-aebe-1368d4ec24eb,9703ccf2-9adb-11e8-aebe-1368d4ec24eb,', '10', '', null, null, null, '0', 'sys:menu:edit', '18b8b543-9ad7-11e8-aebe-1368d4ec24eb', '2018-02-08 09:50:16', '18b8b543-9ad7-11e8-aebe-1368d4ec24eb', '2018-02-08 09:50:25', null, '0');
    437. INSERT INTO `sys_menu` VALUES ('9707cf58-9adb-11e8-aebe-1368d4ec24eb', '删除权限', '3b5cb607-9adb-11e8-aebe-1368d4ec24eb', '3', '7d1020ee-9ad9-11e8-aebe-1368d4ec24eb,3b5cb607-9adb-11e8-aebe-1368d4ec24eb,9707cf58-9adb-11e8-aebe-1368d4ec24eb,', '20', '', null, null, null, '0', 'sys:menu:delete', '18b8b543-9ad7-11e8-aebe-1368d4ec24eb', '2018-02-08 09:51:53', '18b8b543-9ad7-11e8-aebe-1368d4ec24eb', '2018-02-08 09:53:42', null, '0');
    438. INSERT INTO `sys_menu` VALUES ('ad13ddd195e147b7a7e8c3bd20f05cea', '录入学生', '346bee7d3f7741b58e01ee062c3aba73', '2', '346bee7d3f7741b58e01ee062c3aba73,ad13ddd195e147b7a7e8c3bd20f05cea,', '3', '/addStudentPage', null, null, '', '1', '', '0684935cb2ae4cd5994155a32603d195', '2019-11-04 15:33:38', '0684935cb2ae4cd5994155a32603d195', '2019-11-05 15:20:28', null, '0');
    439. INSERT INTO `sys_menu` VALUES ('b85b2b42c1cd4281b6e3884cc1a53327', '成绩录入', '32e652d6788d471196683ca53b948c63', '2', '32e652d6788d471196683ca53b948c63,b85b2b42c1cd4281b6e3884cc1a53327,', '2', '/selstudentExam', null, '', '', '1', '', '0684935cb2ae4cd5994155a32603d195', '2019-11-04 15:16:14', '0684935cb2ae4cd5994155a32603d195', '2019-11-17 19:18:42', null, '0');
    440. INSERT INTO `sys_menu` VALUES ('bb86050a4b4b498b977f93cccd5b2bec', '校园新闻', null, '1', 'bb86050a4b4b498b977f93cccd5b2bec,', '2', '', null, '', '', '1', '', '0684935cb2ae4cd5994155a32603d195', '2019-11-03 20:15:53', '0684935cb2ae4cd5994155a32603d195', '2019-11-05 15:29:54', null, '0');
    441. INSERT INTO `sys_menu` VALUES ('c0ae0cc7e86c45b7a7d6c276a4400a80', '选课管理', null, '1', 'c0ae0cc7e86c45b7a7d6c276a4400a80,', '12', '', null, null, '', '1', '', '0684935cb2ae4cd5994155a32603d195', '2019-11-07 08:22:09', '0684935cb2ae4cd5994155a32603d195', '2019-11-07 08:22:18', null, '1');
    442. INSERT INTO `sys_menu` VALUES ('c457ebb1ad6f47afa69ccc32d6b73b1a', '教评管理', null, '1', 'c457ebb1ad6f47afa69ccc32d6b73b1a,', '10', '', null, '', '', '1', '', '0684935cb2ae4cd5994155a32603d195', '2019-11-05 13:58:00', '0684935cb2ae4cd5994155a32603d195', '2019-11-05 15:33:59', null, '0');
    443. INSERT INTO `sys_menu` VALUES ('c6d5768068f1401bad9f24a5a5b33a92', '学生成绩', '346bee7d3f7741b58e01ee062c3aba73', '2', '346bee7d3f7741b58e01ee062c3aba73,c6d5768068f1401bad9f24a5a5b33a92,', '2', '/tchSelExam', null, null, '', '1', '', '0684935cb2ae4cd5994155a32603d195', '2019-11-04 15:33:25', '054a2cd6369c48d8a52d62e0084d4527', '2019-11-11 09:27:53', null, '0');
    444. INSERT INTO `sys_menu` VALUES ('d024c4836bc941208ae2f2ad00bf630e', '调换课程', '42ff87aec13c409da75b6c7b5ee333ec', '2', '42ff87aec13c409da75b6c7b5ee333ec,d024c4836bc941208ae2f2ad00bf630e,', '2', '', null, null, '', '1', '', '0684935cb2ae4cd5994155a32603d195', '2019-11-04 15:17:24', '054a2cd6369c48d8a52d62e0084d4527', '2019-11-20 17:17:19', null, '1');
    445. INSERT INTO `sys_menu` VALUES ('d04edab30f5b4df4af28254e375c2ff6', '校建管理', null, '1', 'd04edab30f5b4df4af28254e375c2ff6,', '9', '', null, '', '', '1', '', '0684935cb2ae4cd5994155a32603d195', '2019-11-05 09:24:09', '0684935cb2ae4cd5994155a32603d195', '2019-11-05 15:33:34', null, '0');
    446. INSERT INTO `sys_menu` VALUES ('dadca40757374e38a46c9901876febb9', '学生成绩查询', '32e652d6788d471196683ca53b948c63', '2', '32e652d6788d471196683ca53b948c63,dadca40757374e38a46c9901876febb9,', '3', '/selStuAllExam', null, '', '', '1', '', '054a2cd6369c48d8a52d62e0084d4527', '2019-11-14 10:23:04', '054a2cd6369c48d8a52d62e0084d4527', '2019-11-14 10:23:04', null, '0');
    447. INSERT INTO `sys_menu` VALUES ('ed63866b30cf46bfb6797a1d31ae930c', '锁定用户', '3b54e2a2-9adb-11e8-aebe-1368d4ec24eb', '3', '7d1020ee-9ad9-11e8-aebe-1368d4ec24eb,3b54e2a2-9adb-11e8-aebe-1368d4ec24eb,ed63866b30cf46bfb6797a1d31ae930c,', '21', '', null, null, '', '0', 'sys:user:lock', '18b8b543-9ad7-11e8-aebe-1368d4ec24eb', '2018-08-21 17:44:05', '18b8b543-9ad7-11e8-aebe-1368d4ec24eb', '2018-08-21 17:44:05', null, '0');
    448. INSERT INTO `sys_menu` VALUES ('fd3b5d6130dc496fadbb33cca4737863', '学生信息查询', '346bee7d3f7741b58e01ee062c3aba73', '2', '346bee7d3f7741b58e01ee062c3aba73,fd3b5d6130dc496fadbb33cca4737863,', '1', '/selectStudent', null, null, '', '1', '', '0684935cb2ae4cd5994155a32603d195', '2019-11-04 15:33:08', '0684935cb2ae4cd5994155a32603d195', '2019-11-06 19:20:41', null, '0');
    449. INSERT INTO `sys_menu` VALUES ('ff619e04-9adb-11e8-aebe-1368d4ec24eb', '新增角色', '3b58e01e-9adb-11e8-aebe-1368d4ec24eb', '3', '7d1020ee-9ad9-11e8-aebe-1368d4ec24eb,3b58e01e-9adb-11e8-aebe-1368d4ec24eb,ff619e04-9adb-11e8-aebe-1368d4ec24eb,', '0', '', null, null, null, '0', 'sys:role:add', '18b8b543-9ad7-11e8-aebe-1368d4ec24eb', '2018-02-08 09:58:11', '18b8b543-9ad7-11e8-aebe-1368d4ec24eb', '2018-02-08 09:58:11', null, '0');
    450. INSERT INTO `sys_menu` VALUES ('ff9477c9-9adb-11e8-aebe-1368d4ec24eb', '编辑权限', '3b58e01e-9adb-11e8-aebe-1368d4ec24eb', '3', '7d1020ee-9ad9-11e8-aebe-1368d4ec24eb,3b58e01e-9adb-11e8-aebe-1368d4ec24eb,ff9477c9-9adb-11e8-aebe-1368d4ec24eb,', '10', '', null, null, null, '0', 'sys:role:edit', '18b8b543-9ad7-11e8-aebe-1368d4ec24eb', '2018-02-08 09:59:01', '18b8b543-9ad7-11e8-aebe-1368d4ec24eb', '2018-02-08 09:59:01', null, '0');
    451. INSERT INTO `sys_menu` VALUES ('ff9ad846-9adb-11e8-aebe-1368d4ec24eb', '删除角色', '3b58e01e-9adb-11e8-aebe-1368d4ec24eb', '3', '7d1020ee-9ad9-11e8-aebe-1368d4ec24eb,3b58e01e-9adb-11e8-aebe-1368d4ec24eb,ff9ad846-9adb-11e8-aebe-1368d4ec24eb,', '20', '', null, null, null, '0', 'sys:role:delete', '18b8b543-9ad7-11e8-aebe-1368d4ec24eb', '2018-02-08 09:59:56', '18b8b543-9ad7-11e8-aebe-1368d4ec24eb', '2018-02-08 09:59:56', null, '0');
    452.  
    453. -- ----------------------------
    454. -- Table structure for sys_role
    455. -- ----------------------------
    456. DROP TABLE IF EXISTS `sys_role`;
    457. CREATE TABLE `sys_role` (
    458.   `id` varchar(36) NOT NULL,
    459.   `name` varchar(40) DEFAULT NULL COMMENT '角色名称',
    460.   `create_date` datetime DEFAULT NULL,
    461.   `create_by` varchar(36) DEFAULT NULL,
    462.   `update_date` datetime DEFAULT NULL,
    463.   `update_by` varchar(36) DEFAULT NULL,
    464.   `remarks` varchar(255) DEFAULT NULL,
    465.   `del_flag` tinyint(2) DEFAULT NULL,
    466.   PRIMARY KEY (`id`) USING BTREE
    467. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
    468.  
    469. -- ----------------------------
    470. -- Records of sys_role
    471. -- ----------------------------
    472. INSERT INTO `sys_role` VALUES ('1893c63a307b44709c643d60324ed3de', '教师', '2019-11-27 23:18:13', '054a2cd6369c48d8a52d62e0084d4527', '2020-07-26 01:21:27', 'fcf2cf83960d4a16955a2d79a3f69b1b', '教师', '1');
    473. INSERT INTO `sys_role` VALUES ('4212d47f61944d3e9f797598102ea67b', '学生', '2019-11-27 23:17:37', '054a2cd6369c48d8a52d62e0084d4527', '2020-07-26 01:21:21', 'fcf2cf83960d4a16955a2d79a3f69b1b', '学生', '1');
    474. INSERT INTO `sys_role` VALUES ('6619c0ed9452430e9ea23a6542d884a2', '管理员', '2019-11-27 23:09:05', '054a2cd6369c48d8a52d62e0084d4527', '2019-11-27 23:09:05', '054a2cd6369c48d8a52d62e0084d4527', '管理员', '0');
    475. INSERT INTO `sys_role` VALUES ('e7ff6f9fe3954847890282ac1feb04f8', '普通管理员', '2020-07-26 04:06:02', '6966c357cc5b4c64bf3c953b4fd18a76', '2020-07-26 04:06:11', '6966c357cc5b4c64bf3c953b4fd18a76', '一般管理员', '1');
    476.  
    477. -- ----------------------------
    478. -- Table structure for sys_role_menu
    479. -- ----------------------------
    480. DROP TABLE IF EXISTS `sys_role_menu`;
    481. CREATE TABLE `sys_role_menu` (
    482.   `role_id` varchar(36) NOT NULL,
    483.   `menu_id` varchar(36) NOT NULL,
    484.   PRIMARY KEY (`role_id`,`menu_id`) USING BTREE
    485. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
    486.  
    487. -- ----------------------------
    488. -- Records of sys_role_menu
    489. -- ----------------------------
    490. INSERT INTO `sys_role_menu` VALUES ('6619c0ed9452430e9ea23a6542d884a2', '0127fd90587d43c2846f0b6aa563f35c');
    491. INSERT INTO `sys_role_menu` VALUES ('6619c0ed9452430e9ea23a6542d884a2', '0516eff241b7418a9ead2111187f9d75');
    492. INSERT INTO `sys_role_menu` VALUES ('6619c0ed9452430e9ea23a6542d884a2', '118126c2a71141858ec667c104d7cd3d');
    493. INSERT INTO `sys_role_menu` VALUES ('6619c0ed9452430e9ea23a6542d884a2', '19c96fa92510436196066c4d529ddd65');
    494. INSERT INTO `sys_role_menu` VALUES ('6619c0ed9452430e9ea23a6542d884a2', '1b84b70acfbd4b12ac3bad1fee892330');
    495. INSERT INTO `sys_role_menu` VALUES ('6619c0ed9452430e9ea23a6542d884a2', '32e652d6788d471196683ca53b948c63');
    496. INSERT INTO `sys_role_menu` VALUES ('6619c0ed9452430e9ea23a6542d884a2', '346bee7d3f7741b58e01ee062c3aba73');
    497. INSERT INTO `sys_role_menu` VALUES ('6619c0ed9452430e9ea23a6542d884a2', '3b54e2a2-9adb-11e8-aebe-1368d4ec24eb');
    498. INSERT INTO `sys_role_menu` VALUES ('6619c0ed9452430e9ea23a6542d884a2', '3b58e01e-9adb-11e8-aebe-1368d4ec24eb');
    499. INSERT INTO `sys_role_menu` VALUES ('6619c0ed9452430e9ea23a6542d884a2', '3b5cb607-9adb-11e8-aebe-1368d4ec24eb');
    500. INSERT INTO `sys_role_menu` VALUES ('6619c0ed9452430e9ea23a6542d884a2', '3d2bbd52a26344e59c2b25d615614d44');
    501. INSERT INTO `sys_role_menu` VALUES ('6619c0ed9452430e9ea23a6542d884a2', '3e0b86a3-9adc-11e8-aebe-1368d4ec24eb');
    502. INSERT INTO `sys_role_menu` VALUES ('6619c0ed9452430e9ea23a6542d884a2', '3e2fa8b6-9adc-11e8-aebe-1368d4ec24eb');
    503. INSERT INTO `sys_role_menu` VALUES ('6619c0ed9452430e9ea23a6542d884a2', '3e36cf2f-9adc-11e8-aebe-1368d4ec24eb');
    504. INSERT INTO `sys_role_menu` VALUES ('6619c0ed9452430e9ea23a6542d884a2', '42ff87aec13c409da75b6c7b5ee333ec');
    505. INSERT INTO `sys_role_menu` VALUES ('6619c0ed9452430e9ea23a6542d884a2', '45076bf2dbb5443db49c062994d0fb4b');
    506. INSERT INTO `sys_role_menu` VALUES ('6619c0ed9452430e9ea23a6542d884a2', '4d457c31f4fc4e0595c5c6448fe7630a');
    507. INSERT INTO `sys_role_menu` VALUES ('6619c0ed9452430e9ea23a6542d884a2', '4e833c1bd3e8485ab12d4d19269de739');
    508. INSERT INTO `sys_role_menu` VALUES ('6619c0ed9452430e9ea23a6542d884a2', '69b1c803b1a14a8989cf79c4465c0c7e');
    509. INSERT INTO `sys_role_menu` VALUES ('6619c0ed9452430e9ea23a6542d884a2', '72cfb92b47584cf499624dba63cc553a');
    510. INSERT INTO `sys_role_menu` VALUES ('6619c0ed9452430e9ea23a6542d884a2', '7a3b765260f5422c8d0a22e8d5ea8d05');
    511. INSERT INTO `sys_role_menu` VALUES ('6619c0ed9452430e9ea23a6542d884a2', '7ab4c00ce86f4ef8808a16a25625919d');
    512. INSERT INTO `sys_role_menu` VALUES ('6619c0ed9452430e9ea23a6542d884a2', '7d1020ee-9ad9-11e8-aebe-1368d4ec24eb');
    513. INSERT INTO `sys_role_menu` VALUES ('6619c0ed9452430e9ea23a6542d884a2', '832e289e4a4d49a68eea3441979ff703');
    514. INSERT INTO `sys_role_menu` VALUES ('6619c0ed9452430e9ea23a6542d884a2', '8c4743e9a38446e7b13f7e0b6b97a28e');
    515. INSERT INTO `sys_role_menu` VALUES ('6619c0ed9452430e9ea23a6542d884a2', '93979ed945b94fee9a53dbdc184a8eee');
    516. INSERT INTO `sys_role_menu` VALUES ('6619c0ed9452430e9ea23a6542d884a2', '96fd6a5a-9adb-11e8-aebe-1368d4ec24eb');
    517. INSERT INTO `sys_role_menu` VALUES ('6619c0ed9452430e9ea23a6542d884a2', '9703ccf2-9adb-11e8-aebe-1368d4ec24eb');
    518. INSERT INTO `sys_role_menu` VALUES ('6619c0ed9452430e9ea23a6542d884a2', '9707cf58-9adb-11e8-aebe-1368d4ec24eb');
    519. INSERT INTO `sys_role_menu` VALUES ('6619c0ed9452430e9ea23a6542d884a2', 'ad13ddd195e147b7a7e8c3bd20f05cea');
    520. INSERT INTO `sys_role_menu` VALUES ('6619c0ed9452430e9ea23a6542d884a2', 'bb86050a4b4b498b977f93cccd5b2bec');
    521. INSERT INTO `sys_role_menu` VALUES ('6619c0ed9452430e9ea23a6542d884a2', 'c457ebb1ad6f47afa69ccc32d6b73b1a');
    522. INSERT INTO `sys_role_menu` VALUES ('6619c0ed9452430e9ea23a6542d884a2', 'd04edab30f5b4df4af28254e375c2ff6');
    523. INSERT INTO `sys_role_menu` VALUES ('6619c0ed9452430e9ea23a6542d884a2', 'dadca40757374e38a46c9901876febb9');
    524. INSERT INTO `sys_role_menu` VALUES ('6619c0ed9452430e9ea23a6542d884a2', 'ed63866b30cf46bfb6797a1d31ae930c');
    525. INSERT INTO `sys_role_menu` VALUES ('6619c0ed9452430e9ea23a6542d884a2', 'fd3b5d6130dc496fadbb33cca4737863');
    526. INSERT INTO `sys_role_menu` VALUES ('6619c0ed9452430e9ea23a6542d884a2', 'ff619e04-9adb-11e8-aebe-1368d4ec24eb');
    527. INSERT INTO `sys_role_menu` VALUES ('6619c0ed9452430e9ea23a6542d884a2', 'ff9477c9-9adb-11e8-aebe-1368d4ec24eb');
    528. INSERT INTO `sys_role_menu` VALUES ('6619c0ed9452430e9ea23a6542d884a2', 'ff9ad846-9adb-11e8-aebe-1368d4ec24eb');
    529.  
    530. -- ----------------------------
    531. -- Table structure for sys_user
    532. -- ----------------------------
    533. DROP TABLE IF EXISTS `sys_user`;
    534. CREATE TABLE `sys_user` (
    535.   `id` varchar(36) NOT NULL COMMENT '用户ID',
    536.   `login_name` varchar(36) DEFAULT NULL COMMENT '登录名',
    537.   `nick_name` varchar(40) DEFAULT NULL COMMENT '昵称',
    538.   `icon` varchar(2000) DEFAULT NULL,
    539.   `password` varchar(40) DEFAULT NULL COMMENT '密码',
    540.   `salt` varchar(40) DEFAULT NULL COMMENT 'shiro加密盐',
    541.   `tel` varchar(11) DEFAULT NULL COMMENT '手机号码',
    542.   `email` varchar(200) DEFAULT NULL COMMENT '邮箱地址',
    543.   `locked` tinyint(2) DEFAULT NULL COMMENT '是否锁定',
    544.   `create_date` datetime DEFAULT NULL,
    545.   `create_by` varchar(36) DEFAULT NULL,
    546.   `update_date` datetime DEFAULT NULL,
    547.   `update_by` varchar(36) DEFAULT NULL,
    548.   `remarks` varchar(255) DEFAULT NULL,
    549.   `del_flag` tinyint(4) NOT NULL,
    550.   `is_admin` tinyint(2) DEFAULT NULL,
    551.   PRIMARY KEY (`id`) USING BTREE
    552. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
    553.  
    554. -- ----------------------------
    555. -- Records of sys_user
    556. -- ----------------------------
    557. INSERT INTO `sys_user` VALUES ('054a2cd6369c48d8a52d62e0084d4527', 'admin', '管理员', '', 'ab44fda09e0872c39d6feb181a79b3840ba541b6', 'b5d007f4b2f7542e', '10101010101', 'gly@gly.com', '0', '2020-07-26 17:42:56', '0684935cb2ae4cd5994155a32603d195', '2020-07-08 14:49:25', '054a2cd6369c48d8a52d62e0084d4527', '', '0', '1');
    558. INSERT INTO `sys_user` VALUES ('0d7c7e240d03457fb71bc6158ddfe005', '738103', '111', null, '26e3c7f2679a974d849c3b23c4acfcff8ecbaa87', '0c7bd06f67c310d9', '17688888888', null, '0', '2020-07-26 04:31:13', '054a2cd6369c48d8a52d62e0084d4527', '2020-07-26 04:31:13', '054a2cd6369c48d8a52d62e0084d4527', null, '0', '1');
    559. INSERT INTO `sys_user` VALUES ('4c958d6bd9374abb8b16175b2d4a64fe', '1.5020006E7', '打狗棒', null, '22d17922b97ab9edd5ead43277bd39113283b6aa', '4a87eb83185aa70f', '18789898989', null, '0', '2020-07-26 04:23:03', '054a2cd6369c48d8a52d62e0084d4527', '2020-07-26 04:23:03', '054a2cd6369c48d8a52d62e0084d4527', null, '0', '1');
    560. INSERT INTO `sys_user` VALUES ('6966c357cc5b4c64bf3c953b4fd18a76', 'qqqqq', 'qqqqq', null, 'f78e83e0c03256985b0f1617940f74e53a3e03c2', '252f328d1c0a763d', '18888888888', '2118119173@qq.com', '0', '2020-07-26 04:04:33', '054a2cd6369c48d8a52d62e0084d4527', '2020-07-26 04:04:33', '054a2cd6369c48d8a52d62e0084d4527', null, '0', '1');
    561. INSERT INTO `sys_user` VALUES ('6aa9d87cfd13487a9d770d934e151606', '1.5020005E7', '黄周', null, 'db41800935146c182c89e85a4c947ce72d79f8c3', '521e012ba810b06d', '17655555555', null, '0', '2020-07-26 04:18:37', '054a2cd6369c48d8a52d62e0084d4527', '2020-07-26 04:18:37', '054a2cd6369c48d8a52d62e0084d4527', null, '0', '1');
    562. INSERT INTO `sys_user` VALUES ('87da06fe5a6a4e42a5e222afead3ede0', '2020002', '李老师', null, '32ed2cd868dc68f2337ff44aa02d18438906ba9c', '53e6aa7a23095be7', '18990998776', null, '0', '2020-07-26 02:30:56', '054a2cd6369c48d8a52d62e0084d4527', '2020-07-26 02:30:56', '054a2cd6369c48d8a52d62e0084d4527', null, '0', '1');
    563. INSERT INTO `sys_user` VALUES ('b7e22ebcc4c64677ab718de67009c1dd', '2020004', '小周老师', null, '31587d4f4134bafdebdaded1d3e5974137b94129', '6fcfdb050834b76c', '18767675656', null, '0', '2020-07-26 03:53:10', '054a2cd6369c48d8a52d62e0084d4527', '2020-07-26 03:53:10', '054a2cd6369c48d8a52d62e0084d4527', null, '0', '1');
    564. INSERT INTO `sys_user` VALUES ('bbea0da84db042f98598895de9f55db0', '2020003', 'aa老师', null, '9a71871ec38ed9d38c505b2c0dbe95f51ff5178f', 'ebdf021f54745b3d', '17890987654', null, '0', '2020-07-26 02:37:04', '054a2cd6369c48d8a52d62e0084d4527', '2020-07-26 02:37:04', '054a2cd6369c48d8a52d62e0084d4527', null, '0', '1');
    565. INSERT INTO `sys_user` VALUES ('ca1ebdac69574a5ea3c699a31bde6836', '1.5020003E7', '周二珂', null, '24cc7bda292d9c96caebbae4c9a042c350e82259', '1cb74206becbe7d1', '18789897876', null, '0', '2020-07-26 03:34:20', '054a2cd6369c48d8a52d62e0084d4527', '2020-07-26 03:34:20', '054a2cd6369c48d8a52d62e0084d4527', null, '0', '1');
    566. INSERT INTO `sys_user` VALUES ('f1ed3116883c41d7b0c3b664a01c8258', '1.5020004E7', '周明', null, 'ff57ff137456e4b6b8c1ccd9bed6f57011fb380c', 'd8bb87f59c95b9d7', '18766666666', null, '0', '2020-07-26 03:59:40', '054a2cd6369c48d8a52d62e0084d4527', '2020-07-26 03:59:40', '054a2cd6369c48d8a52d62e0084d4527', null, '0', '1');
    567.  
    568. -- ----------------------------
    569. -- Table structure for sys_user_role
    570. -- ----------------------------
    571. DROP TABLE IF EXISTS `sys_user_role`;
    572. CREATE TABLE `sys_user_role` (
    573.   `user_id` varchar(36) NOT NULL,
    574.   `role_id` varchar(36) NOT NULL,
    575.   PRIMARY KEY (`user_id`,`role_id`) USING BTREE
    576. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
    577.  
    578. -- ----------------------------
    579. -- Records of sys_user_role
    580. -- ----------------------------
    581. INSERT INTO `sys_user_role` VALUES ('054a2cd6369c48d8a52d62e0084d4527', '6619c0ed9452430e9ea23a6542d884a2');
    582. INSERT INTO `sys_user_role` VALUES ('0d7c7e240d03457fb71bc6158ddfe005', '4212d47f61944d3e9f797598102ea67b');
    583. INSERT INTO `sys_user_role` VALUES ('4c958d6bd9374abb8b16175b2d4a64fe', '4212d47f61944d3e9f797598102ea67b');
    584. INSERT INTO `sys_user_role` VALUES ('6966c357cc5b4c64bf3c953b4fd18a76', '6619c0ed9452430e9ea23a6542d884a2');
    585. INSERT INTO `sys_user_role` VALUES ('6aa9d87cfd13487a9d770d934e151606', '4212d47f61944d3e9f797598102ea67b');
    586. INSERT INTO `sys_user_role` VALUES ('87da06fe5a6a4e42a5e222afead3ede0', '1893c63a307b44709c643d60324ed3de');
    587. INSERT INTO `sys_user_role` VALUES ('b7e22ebcc4c64677ab718de67009c1dd', '1893c63a307b44709c643d60324ed3de');
    588. INSERT INTO `sys_user_role` VALUES ('bbea0da84db042f98598895de9f55db0', '1893c63a307b44709c643d60324ed3de');
    589. INSERT INTO `sys_user_role` VALUES ('ca1ebdac69574a5ea3c699a31bde6836', '4212d47f61944d3e9f797598102ea67b');
    590. INSERT INTO `sys_user_role` VALUES ('dfcc397dafe04c10943629f8d1237c5b', '6619c0ed9452430e9ea23a6542d884a2');
    591. INSERT INTO `sys_user_role` VALUES ('f1ed3116883c41d7b0c3b664a01c8258', '4212d47f61944d3e9f797598102ea67b');
    592. INSERT INTO `sys_user_role` VALUES ('fcf2cf83960d4a16955a2d79a3f69b1b', '6619c0ed9452430e9ea23a6542d884a2');
    593.  
    594. -- ----------------------------
    595. -- Table structure for tch_class
    596. -- ----------------------------
    597. DROP TABLE IF EXISTS `tch_class`;
    598. CREATE TABLE `tch_class` (
    599.   `tcsid` int(11) NOT NULL AUTO_INCREMENT,
    600.   `tid` int(11) NOT NULL,
    601.   `classid` int(11) NOT NULL,
    602.   `tcid` int(11) NOT NULL,
    603.   `is_del` int(11) NOT NULL DEFAULT '0',
    604.   PRIMARY KEY (`tcsid`) USING BTREE,
    605.   KEY `tid` (`tid`) USING BTREE,
    606.   KEY `classid` (`classid`) USING BTREE,
    607.   KEY `tch_class_ibfk_3` (`tcid`) USING BTREE,
    608.   CONSTRAINT `tch_class_ibfk_1` FOREIGN KEY (`tid`) REFERENCES `teacher` (`tid`),
    609.   CONSTRAINT `tch_class_ibfk_2` FOREIGN KEY (`classid`) REFERENCES `classinfo` (`classid`),
    610.   CONSTRAINT `tch_class_ibfk_3` FOREIGN KEY (`tcid`) REFERENCES `tch_course` (`tcid`)
    611. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
    612.  
    613. -- ----------------------------
    614. -- Records of tch_class
    615. -- ----------------------------
    616. INSERT INTO `tch_class` VALUES ('1', '2020001', '112', '1', '0');
    617. INSERT INTO `tch_class` VALUES ('2', '2020004', '116', '2', '0');
    618.  
    619. -- ----------------------------
    620. -- Table structure for tch_course
    621. -- ----------------------------
    622. DROP TABLE IF EXISTS `tch_course`;
    623. CREATE TABLE `tch_course` (
    624.   `tcid` int(11) NOT NULL AUTO_INCREMENT,
    625.   `tid` int(11) NOT NULL,
    626.   `cid` int(11) NOT NULL,
    627.   `wid` int(11) NOT NULL,
    628.   `schid` int(11) NOT NULL,
    629.   `gid` int(11) NOT NULL,
    630.   `is_del` int(11) NOT NULL DEFAULT '0',
    631.   PRIMARY KEY (`tcid`) USING BTREE,
    632.   KEY `tid` (`tid`) USING BTREE,
    633.   KEY `cid` (`cid`) USING BTREE,
    634.   KEY `wid` (`wid`) USING BTREE,
    635.   KEY `schid` (`schid`) USING BTREE,
    636.   KEY `gid` (`gid`) USING BTREE,
    637.   CONSTRAINT `tch_course_ibfk_1` FOREIGN KEY (`tid`) REFERENCES `teacher` (`tid`),
    638.   CONSTRAINT `tch_course_ibfk_2` FOREIGN KEY (`cid`) REFERENCES `course` (`cid`),
    639.   CONSTRAINT `tch_course_ibfk_3` FOREIGN KEY (`wid`) REFERENCES `weeks` (`wid`),
    640.   CONSTRAINT `tch_course_ibfk_4` FOREIGN KEY (`schid`) REFERENCES `schedule` (`schid`),
    641.   CONSTRAINT `tch_course_ibfk_5` FOREIGN KEY (`gid`) REFERENCES `grade` (`gid`)
    642. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
    643.  
    644. -- ----------------------------
    645. -- Records of tch_course
    646. -- ----------------------------
    647. INSERT INTO `tch_course` VALUES ('1', '2020001', '1', '1', '1', '33', '0');
    648. INSERT INTO `tch_course` VALUES ('2', '2020004', '3', '1', '1', '33', '0');
    649.  
    650. -- ----------------------------
    651. -- Table structure for tch_exam
    652. -- ----------------------------
    653. DROP TABLE IF EXISTS `tch_exam`;
    654. CREATE TABLE `tch_exam` (
    655.   `teid` int(11) NOT NULL AUTO_INCREMENT,
    656.   `tid` int(11) NOT NULL,
    657.   `exam` decimal(9,2) DEFAULT NULL,
    658.   `pcount` int(11) DEFAULT NULL,
    659.   `tetime` date NOT NULL,
    660.   `semester` int(11) NOT NULL,
    661.   `is_del` int(11) NOT NULL DEFAULT '0',
    662.   PRIMARY KEY (`teid`) USING BTREE,
    663.   KEY `tid` (`tid`) USING BTREE,
    664.   CONSTRAINT `tch_exam_ibfk_1` FOREIGN KEY (`tid`) REFERENCES `teacher` (`tid`)
    665. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
    666.  
    667. -- ----------------------------
    668. -- Records of tch_exam
    669. -- ----------------------------
    670.  
    671. -- ----------------------------
    672. -- Table structure for teacher
    673. -- ----------------------------
    674. DROP TABLE IF EXISTS `teacher`;
    675. CREATE TABLE `teacher` (
    676.   `tid` int(11) NOT NULL AUTO_INCREMENT,
    677.   `tchid` varchar(20) NOT NULL,
    678.   `tname` varchar(20) NOT NULL,
    679.   `tgender` varchar(20) NOT NULL,
    680.   `tbirthday` date NOT NULL,
    681.   `pid` int(11) NOT NULL,
    682.   `tnation` varchar(50) NOT NULL,
    683.   `tcardid` varchar(50) NOT NULL,
    684.   `tphone` varchar(50) NOT NULL,
    685.   `taddress` varchar(200) NOT NULL,
    686.   `entertime` date NOT NULL,
    687.   `leavetime` date DEFAULT NULL,
    688.   `tchstate` int(11) NOT NULL DEFAULT '0',
    689.   `is_del` int(11) NOT NULL DEFAULT '0',
    690.   PRIMARY KEY (`tid`) USING BTREE,
    691.   KEY `pid` (`pid`) USING BTREE,
    692.   CONSTRAINT `teacher_ibfk_1` FOREIGN KEY (`pid`) REFERENCES `politics_type` (`pid`)
    693. ) ENGINE=InnoDB AUTO_INCREMENT=2020005 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
    694.  
    695. -- ----------------------------
    696. -- Records of teacher
    697. -- ----------------------------
    698. INSERT INTO `teacher` VALUES ('2020000', '2020000', '年份过渡数据', '年份过渡数据', '2020-07-09', '1', '年份过渡数据', '年份过渡数据', '年份过渡数据', '年份过渡数据', '2020-07-09', '2020-07-09', '1', '1');
    699. INSERT INTO `teacher` VALUES ('2020001', '2020001', '王老师', '男', '1997-08-13', '1', '汉族', '420984199708133614', '13986744231', 'xxxxxxxxx', '2020-07-09', null, '0', '0');
    700. INSERT INTO `teacher` VALUES ('2020002', '2020002', '李老师', '女', '1995-09-08', '1', '汉族', '555555555', '18990998776', '', '2020-07-25', null, '0', '0');
    701. INSERT INTO `teacher` VALUES ('2020003', '2020003', 'aa老师', '男', '2020-07-25', '1', '汉族', 'aaaaaa', '17890987654', '', '2020-07-25', null, '0', '0');
    702. INSERT INTO `teacher` VALUES ('2020004', '2020004', '小周老师', '男', '1994-09-08', '1', '汉族', '501211199509090876', '18767675656', '', '2020-07-13', null, '0', '0');
    703.  
    704. -- ----------------------------
    705. -- Table structure for weeks
    706. -- ----------------------------
    707. DROP TABLE IF EXISTS `weeks`;
    708. CREATE TABLE `weeks` (
    709.   `wid` int(11) NOT NULL AUTO_INCREMENT,
    710.   `wname` varchar(20) NOT NULL,
    711.   `walias` varchar(20) NOT NULL,
    712.   PRIMARY KEY (`wid`) USING BTREE
    713. ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
    714.  
    715. -- ----------------------------
    716. -- Records of weeks
    717. -- ----------------------------
    718. INSERT INTO `weeks` VALUES ('1', '星期一', '周一');
    719. INSERT INTO `weeks` VALUES ('2', '星期二', '周二');
    720. INSERT INTO `weeks` VALUES ('3', '星期三', '周三');
    721. INSERT INTO `weeks` VALUES ('4', '星期四', '周四');
    722. INSERT INTO `weeks` VALUES ('5', '星期五', '周五');
    723. INSERT INTO `weeks` VALUES ('6', '星期六', '周六');
    724. INSERT INTO `weeks` VALUES ('7', '星期日', '周日');

    学生信息管理系统是针对学校的学生管理部门需要处理繁重的学生业务工作而开发的管理软件， 主要用于学校学生信息管理，主要目标是实现学生信息和老师 信息的系统化、科学化、规范化和自动化，其主要任务是用软件 对学生各种信息进行日常管理，如查询、修改、增加、删除，另外 还考虑到学生选课，针对这些要求设计了学生信息管理系统。 推行学生的信息管理系统的相关应用是进一步推进学生信息 管理规范化、电子化和提高义务教育水平的重要举措。

    学生信息管理系统，简单地来说就是从学生入学开始 至毕业结束这一时期内所有的信息进行统一管理的过程。 主要包括：学生基本信息、体检表、军训登记表、学年考评 表、奖惩材料以及高等学生毕业生等级表等。随着校园信 息化的不断发展，智能化的学生信息管理系统逐渐地受到 了系统管理员及用户的青睐。在这样的背景之下，有越来 越多的学生想通过信息管理系统来了解自己的学习情况， 更有越来越多的家长也开始关心自己的子女在学校中的生 活状态。所以，作为学校理应从学生入学开始至毕业结束 对学生的信息做一个系统且全面地管理。学生信息管理系 统具备如下特点：①网络信息操作化。没有网络就没有对 学生信息操作的基础，所以说，学生系统管理系统是建立在 网络系统之上的。②信息管理数字化，信息管理数字化指 的是通过现代化的信息技术将学生的信息转化成为计算机 可以识别的数字信息，它为学生信息信息管理系统的分析 奠定了坚实的基础。

  • 相关阅读:
    从Redis分布式缓存实战入手到底层原理分析、覆盖大厂面试考点
    .NET Core学习笔记
    【狂神】MyBatisPlus笔记
    Es的核心概念
    OK6410A 开发板 (八) 126 linux-5.11 OK6410A GPIO驱动的应用
    Redis数据类型-String-基本使用和原理
    [4G/5G/6G专题基础-158]: 5G VoNR（Voice over NR）与VoLTE共同组成5G三大语音方案
    【Java第十七期】：##模拟实现一个ArrayList
    漫谈万维网的华丽史诗：Web3.0是技术金矿 还是郁金香泡沫？
    NCCL源码解析②：Bootstrap网络连接的建立
  • 原文地址：https://blog.csdn.net/weixin_46437112/article/details/127924861