JavaWeb 自适应学生成绩信息管理系统SAMS

淡淡的烟草味﹌ 2022-10-09 03:24 14阅读 0赞

### 文章目录 ###

*   *  开发环境
     *  演示
     *   *  登录页面
         *  学生页面
         *  教师页面
         *  管理员页面
     *  系统概述
     *  系统功能分析
     *  项目实现
     *   *  数据库
         *  配置文件
         *   *  pom.xml 配置
             *  web.xml 配置
             *  spring-mvc.xml 配置
             *  jdbc.properties 配置
         *  项目结构

--------------------

## 开发环境 ##

> JDK 1.8
> 
> MySQL 5.7
> 
> MAVEN 3.8.1
> 
> Tomcat 9.0.45
> 
> SpringMVC

引用 jar 包：

junit、druid、dbutils、dom4j、mysql-connector、servlet、fastjson、jackson-databind、jackson-core、jackson-annotations、lombok、aspectjweaver、spring-webmvc、spring-core、jwt

--------------------

## 演示 ##

### 登录页面 ###

![image-20210623163050601][]

### 学生页面 ###

![image-20210623155428818][]

### 教师页面 ###

![image-20210623155330552][]  
![image-20210623155545861][]

### 管理员页面 ###

![image-20210623155722671][]

--------------------

## 系统概述 ##

学生成绩信息管理系统涉及到学生、教师、系统管理员、班级、学生成绩、课程。

*  管理员通过账号、密码登录，管理员进入系统可以对课程，系部，教师，学生，专业进行添加、查看。
 *  教师通过教工号和密码登录，教师进入系统可以查看自己教的所有课程，以及对选该课程的学生成绩进行修改。
 *  学生通过学号和密码进行登录，学生进入系统可以查看自己学习课程的信息以及成绩。

--------------------

## 系统功能分析 ##

Student

1.  登录
2.  查看成绩

--------------------

Teacher

1.  登录
2.  查看课程
3.  查看学生成绩
4.  录入成绩

--------------------

Administrator

1.  登录
2.  查看系部
3.  查看系部下的专业
4.  查看专业下的班级
5.  查看班级下的学生
6.  新建系部
7.  新建系部下的专业
8.  新建专业下的班级
9.  新建班级下的学生
10. 新建课程

--------------------

## 项目实现 ##

### 数据库 ###

创建数据库

CREATE DATABASE sams;

创建 administrators 数据表

CREATE TABLE `administrators` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `name` varchar(40) DEFAULT NULL,
      `account` varchar(40) DEFAULT NULL,
      `password` varchar(40) DEFAULT NULL,
      PRIMARY KEY (`id`),
      UNIQUE KEY `UNIQUE` (`account`) COMMENT '账号唯一'
    ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

创建 calsses 表

CREATE TABLE `classes` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `name` varchar(40) DEFAULT NULL,
      `graduationyear` varchar(40) DEFAULT NULL,
      `majorid` int(11) DEFAULT NULL,
      PRIMARY KEY (`id`),
      KEY `majorid` (`majorid`),
      CONSTRAINT `classes_ibfk_1` FOREIGN KEY (`majorid`) REFERENCES `majors` (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

创建 courses 表

CREATE TABLE `courses` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `name` varchar(40) DEFAULT NULL,
      `teacherid` int(11) DEFAULT NULL,
      `beginyear` timestamp NULL DEFAULT NULL,
      `endyear` timestamp NULL DEFAULT NULL,
      PRIMARY KEY (`id`),
      KEY `teacherid` (`teacherid`),
      CONSTRAINT `courses_ibfk_1` FOREIGN KEY (`teacherid`) REFERENCES `teachers` (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;

创建 majors 表

CREATE TABLE `majors` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `name` varchar(100) DEFAULT NULL,
      `sdeptid` int(11) DEFAULT NULL,
      PRIMARY KEY (`id`),
      KEY `sdeptid` (`sdeptid`),
      CONSTRAINT `majors_ibfk_1` FOREIGN KEY (`sdeptid`) REFERENCES `sdepts` (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

创建 scores 表

CREATE TABLE `scores` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `studentid` int(11) DEFAULT NULL,
      `courseid` int(11) DEFAULT NULL,
      `grade` double DEFAULT NULL,
      PRIMARY KEY (`id`),
      UNIQUE KEY `studentid` (`studentid`,`courseid`),
      KEY `courseid` (`courseid`),
      CONSTRAINT `scores_ibfk_1` FOREIGN KEY (`studentid`) REFERENCES `students` (`id`),
      CONSTRAINT `scores_ibfk_2` FOREIGN KEY (`courseid`) REFERENCES `courses` (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;

创建 sdepts 表

CREATE TABLE `sdepts` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `name` varchar(40) DEFAULT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

创建 students 表

CREATE TABLE `students` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `name` varchar(40) DEFAULT NULL,
      `password` varchar(40) DEFAULT NULL,
      `sdeptid` int(11) DEFAULT NULL,
      `majorid` int(11) DEFAULT NULL,
      `classid` int(11) DEFAULT NULL,
      PRIMARY KEY (`id`),
      KEY `sdeptid` (`sdeptid`),
      KEY `majorid` (`majorid`),
      KEY `classid` (`classid`),
      CONSTRAINT `students_ibfk_1` FOREIGN KEY (`sdeptid`) REFERENCES `sdepts` (`id`),
      CONSTRAINT `students_ibfk_2` FOREIGN KEY (`majorid`) REFERENCES `majors` (`id`),
      CONSTRAINT `students_ibfk_3` FOREIGN KEY (`classid`) REFERENCES `classes` (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=2020020223 DEFAULT CHARSET=utf8;

创建 teachers 表

CREATE TABLE `teachers` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `name` varchar(40) DEFAULT NULL,
      `password` varchar(100) DEFAULT NULL,
      `sdeptid` int(11) DEFAULT NULL,
      PRIMARY KEY (`id`),
      KEY `sdeptid` (`sdeptid`),
      CONSTRAINT `teachers_ibfk_1` FOREIGN KEY (`sdeptid`) REFERENCES `sdepts` (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=2020221 DEFAULT CHARSET=utf8;

创建 tokens 表

CREATE TABLE `tokens` (
      `token` varchar(120) NOT NULL,
      `overtime` timestamp NULL DEFAULT NULL,
      `adminId` int(11) DEFAULT NULL,
      `studentId` int(11) DEFAULT NULL,
      `teacherId` int(11) DEFAULT NULL,
      PRIMARY KEY (`token`),
      KEY `adminId` (`adminId`),
      KEY `studentId` (`studentId`),
      KEY `teacherId` (`teacherId`),
      CONSTRAINT `tokens_ibfk_1` FOREIGN KEY (`adminId`) REFERENCES `administrators` (`id`),
      CONSTRAINT `tokens_ibfk_2` FOREIGN KEY (`studentId`) REFERENCES `students` (`id`),
      CONSTRAINT `tokens_ibfk_3` FOREIGN KEY (`teacherId`) REFERENCES `teachers` (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--------------------

### 配置文件 ###

#### pom.xml 配置 ####

<?xml version="1.0" encoding="UTF-8"?>
    
    <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
        <modelVersion>4.0.0</modelVersion>
    
        <groupId>com.xxxx</groupId>
        <artifactId>sams</artifactId>
        <version>1.0-SNAPSHOT</version>
        <packaging>war</packaging>
    
        <properties>
            <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
            <maven.compiler.source>1.8</maven.compiler.source>
            <maven.compiler.target>1.8</maven.compiler.target>
        </properties>
    
        <dependencies>
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>4.12</version>
                <scope>test</scope>
            </dependency>
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid</artifactId>
                <version>1.1.10</version>
            </dependency>
            <dependency>
                <groupId>commons-dbutils</groupId>
                <artifactId>commons-dbutils</artifactId>
                <version>1.7</version>
            </dependency>
            <dependency>
                <groupId>dom4j</groupId>
                <artifactId>dom4j</artifactId>
                <version>1.6.1</version>
            </dependency>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.47</version>
            </dependency>
            <dependency>
                <groupId>javax.servlet</groupId>
                <artifactId>javax.servlet-api</artifactId>
                <version>4.0.1</version>
            </dependency>
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>fastjson</artifactId>
                <version>1.2.75</version>
            </dependency>
            <dependency>
                <groupId>com.fasterxml.jackson.core</groupId>
                <artifactId>jackson-databind</artifactId>
                <version>2.9.8</version>
            </dependency>
            <dependency>
                <groupId>com.fasterxml.jackson.core</groupId>
                <artifactId>jackson-core</artifactId>
                <version>2.9.8</version>
            </dependency>
            <dependency>
                <groupId>com.fasterxml.jackson.core</groupId>
                <artifactId>jackson-annotations</artifactId>
                <version>2.9.8</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-core</artifactId>
                <version>5.2.6.RELEASE</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-webmvc</artifactId>
                <version>5.2.6.RELEASE</version>
            </dependency>
            <dependency>
                <groupId>org.aspectj</groupId>
                <artifactId>aspectjweaver</artifactId>
                <version>1.9.2</version>
            </dependency>
            <dependency>
                <groupId>org.projectlombok</groupId>
                <artifactId>lombok</artifactId>
                <version>1.18.12</version>
            </dependency>
            <dependency>
                <groupId>com.auth0</groupId>
                <artifactId>java-jwt</artifactId>
                <version>3.8.2</version>
            </dependency>
        </dependencies>
    
        
        <build>
            <resources>
                <resource>
                    <directory>src/main/java</directory>
                    <includes>
                        <include>**/*.properties</include>
                        <include>**/*.xml</include>
                    </includes>
                    <filtering>false</filtering>
                </resource>
                <resource>
                    <directory>src/main/resources</directory>
                    <includes>
                        <include>**/*.properties</include>
                        <include>**/*.xml</include>
                    </includes>
                    <filtering>false</filtering>
                </resource>
            </resources>
        </build>
    </project>

--------------------

#### web.xml 配置 ####

<?xml version="1.0" encoding="UTF-8"?>
    <web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd" version="4.0">
      
    
        
        <servlet>
            <servlet-name>dispatcherServlet</servlet-name>
            <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
            <init-param>
                <param-name>contextConfigLocation</param-name>
                <param-value>classpath:SpringMvc.xml</param-value>
            </init-param>
            <load-on-startup>1</load-on-startup>
        </servlet>
        <servlet-mapping>
            <servlet-name>dispatcherServlet</servlet-name>
            <url-pattern>/</url-pattern>
        </servlet-mapping>
    
        
        <filter>
            <filter-name>encoding</filter-name>
            <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
            <init-param>
                <param-name>encoding</param-name>
                <param-value>utf-8</param-value>
            </init-param>
        </filter>
        <filter-mapping>
            <filter-name>encoding</filter-name>
            <url-pattern>/*</url-pattern>
        </filter-mapping>
    
    
        
        <welcome-file-list>
            <welcome-file>/WEB-INF/jsp/index.html</welcome-file>
        </welcome-file-list>
    
        <error-page>
            <location>/WEB-INF/jsp/index.html</location>
        </error-page>
    
    </web-app>

--------------------

#### spring-mvc.xml 配置 ####

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans" xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:context="http://www.springframework.org/schema/context" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation=" http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">
        <mvc:annotation-driven/>
    
        <context:component-scan base-package="controller"/>
    
        <mvc:default-servlet-handler/>
        
    
        <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver" id="internalResourceViewResolver">
            <property name="prefix" value="/WEB-INF/jsp/"/>
            <property name="suffix" value=".html"/>
        </bean>
    
        <mvc:annotation-driven>
            <mvc:message-converters register-defaults="true">
                
                <bean class="org.springframework.http.converter.StringHttpMessageConverter">
                    <property name="supportedMediaTypes" value="text/html;charset=UTF-8"/>
                </bean>
                
                <bean id="jacksonMessageConverter" class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter">
                    <property name="supportedMediaTypes" value="application/json;charset=UTF-8"/>
                </bean>
            </mvc:message-converters>
        </mvc:annotation-driven>
    
        
    
    </beans>

--------------------

#### jdbc.properties 配置 ####

url=jdbc:mysql://localhost:3306/sams?useUnicode=true&characterEncoding=utf-8
    username=root
    password=123456
    driver=com.mysql.jdbc.Driver
    initialSize=10
    maxActive=30

--------------------

### 项目结构 ###

![image-20210623160200860][]

<table> 
 <thead> 
  <tr> 
   <th>目录</th> 
   <th></th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>controller</td> 
   <td>控制层，负责处理业务模块流程的控制器</td> 
  </tr> 
  <tr> 
   <td>service</td> 
   <td>业务逻辑层，负责处理业务模块</td> 
  </tr> 
  <tr> 
   <td>dao</td> 
   <td>数据持久层， 负责与数据库进行交互</td> 
  </tr> 
  <tr> 
   <td>pojo</td> 
   <td>存放 JavaBean 类</td> 
  </tr> 
  <tr> 
   <td>utils</td> 
   <td>工具类，提供一些工具</td> 
  </tr> 
  <tr> 
   <td>resources</td> 
   <td>存放资源文件</td> 
  </tr> 
 </tbody> 
</table>

--------------------

项目下载地址：[javaWeb项目学生成绩信息管理系统][javaWeb]

Gitee 项目开源地址：[Student Management System ][Student Management System]

[image-20210623163050601]: /images/20221005/f1b385e618cf461f8324e81b43e86d4e.png
[image-20210623155428818]: /images/20221005/8c40979ac13d43f78267d7ada28fb540.png
[image-20210623155330552]: /images/20221005/2fcf44f005b14e0c9d90fe9882d11237.png
[image-20210623155545861]: /images/20221005/4b31d10a36804ffb97e9c94b1aad3974.png
[image-20210623155722671]: /images/20221005/48b7d9aec5b84a4ab19d800e75efaa97.png
[image-20210623160200860]: /images/20221005/fdd2b68d343749a5ac2a96b7186e71ca.png
[javaWeb]: https://download.csdn.net/download/qq_20185737/19792233
[Student Management System]: https://gitee.com/suitbaby/student-management-system