计算机SSM毕设选题基于JavaWeb的学生选课管理系统

淩亂°似流年 2024-02-19 10:00 70阅读 0赞

> 项目介绍：后端采用Jsp+Servlet。前端使用的是Layui的一个网站模板。开发一个在线的学生选课管理系统，用于课程设计的使用。

> 项目类型：JavaWeb源码
> 
> 用户类型：2个角色（管理员+学生）
> 
> 主要技术：Jsp+Servlet+MySQL+Jquery(前端Bootstrap或者Layui)
> 
> 开发工具：Eclipse/Idea均可使用，有两个不同的版本
> 
> 数据库：MySQL
> 
> 数据库表：6/4张

**目录**

00完整的程序目录

01版本1（6张表）

1.0用户登录

1.1学生管理模块

1.2班级管理模块

1.3课程管理模块

1.4选课信息管理模块+成绩录入

1.5公告管理模块

1.6密码修改

1.7选课与退选模块

02版本2（6张表）

2.1 登录

2.2学生信息管理模块

2.3选课成绩管理模块

2.4课程信息管理模块

2.5选课管理模块

2.6教师管理模块

2.7在线选课

03版本3（4张表）

3.1登录

3.2资料修改模块

3.3学生管理模块

3.4课程管理模块

3.5选课及退选管理模块

3.6成绩录入

04项目结构

Eclipse版本目录

Idea版本目录

05数据库设计

06系统演示

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

## 00 **完整的程序目录** ##

![0e0600ef92acda6be459bd2196def3e2.png][]

## 01 **版本1（6张表）** ##

### **1.0用户登录** ###

![a92df688748993b130593f8bc6981001.png][]

### 1.1学生管理模块 ###

![f1de3ab4a080b12227ff9f8966092abe.png][]

### **1.2班级管理模块** ###

![99a35489c27607e70ec01102e0a40421.png][]

### **1.3课程管理模块** ###

![ee60a7e1cce93d793de963d3364c3531.png][]

### **1.4选课信息管理模块+成绩录入** ###

![4d46d67aa30b079938e9039200dc560f.png][]

![a0916b51fe7a7025e4698ed06cc7503f.png][]

### **1.5公告管理模块** ###

![bc57a2bb7c9b47e1ebfca86e79e59687.png][]

### **1.6密码修改** ###

![58457d8adf7979fa8f8806c90799d955.png][]

### **1.7选课与退选模块** ###

![be46a89eb0ed20ee801022444b9a536a.png][]

## 02 **版本2（6张表）** ##

### **2.1 登录** ###

![60c4ffa41b3300aacd305883762b3f26.png][]

### **2.2学生信息管理模块** ###

![09d77f46b8abcaa314ddbd2608375d8a.png][]

### **2.3选课成绩管理模块** ###

![0ad4bae0d48a675ffc522dd0f07788c6.png][]

### **2.4课程信息管理模块** ###

![01f2e747494d85de30dc18a863da65ef.png][]

### 2.5选课管理模块 ###

![2fb172cb62384b177fe5dafd6fc62fe7.png][]

### **2.6教师管理模块** ###

![4df4ee594cf1b8d5b70a0b06e3727634.png][]

### **2.7在线选课** ###

![64ff4fabebbffda040f1b327a0194183.png][]

## 03 **版本3（4张表）** ##

### **3.1登录** ###

![108c67f5f7d74d07d1788e29397dbce6.png][]

### **3.2资料修改模块** ###

![88e70e64f55f2c9fe2077e87e2d84d7d.png][]

### **3.3学生管理模块** ###

![0e150d2fc1755f8a0103d0ebb7d7cb03.png][]

### **3.4课程管理模块** ###

![1bd5d1f4d65639ed05db24590273d11e.png][]

### **3.5选课及退选管理模块** ###

![b3bfaadb022a0408a9617082bd553224.png][]

![c8aabb9dce52cd1c04838f86704b3b33.jpeg][]

### **3.6成绩录入** ###

![a2ed3ef06ca5eb618b1facb3a70c1ce1.png][]

## 04 **项目结构** ##

### **Eclipse版本目录** ###

![df26f732dd9889680375fe50d7416039.jpeg][]

### **Idea版本目录** ###

![fe35eac521accfe44ca18663e4f9cf77.jpeg][]

## 05 **数据库设计** ##

![e688615782fe13b759dc5efd9cd9a8d1.jpeg][]

![fa88dfad403b5d2d4fc5d5cd03c6c842.png][]

![361f920b6e127a618965f7d20a483d8b.jpeg][]

## 06系统演示 ##

基于Jsp+Servlet的学生选课管理系统

SET NAMES utf8mb4;
    SET FOREIGN_KEY_CHECKS = 0;
    
    -- ----------------------------
    -- Table structure for admin
    -- ----------------------------
    DROP TABLE IF EXISTS `admin`;
    CREATE TABLE `admin`  (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `nickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Records of admin
    -- ----------------------------
    INSERT INTO `admin` VALUES (1, '泰迪', 'admin', '123456');
    
    -- ----------------------------
    -- Table structure for category
    -- ----------------------------
    DROP TABLE IF EXISTS `category`;
    CREATE TABLE `category`  (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `cname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Records of category
    -- ----------------------------
    INSERT INTO `category` VALUES (1, '计科1班');
    INSERT INTO `category` VALUES (2, '计科2班');
    INSERT INTO `category` VALUES (3, '计科3班');
    INSERT INTO `category` VALUES (4, '计科4班');
    
    -- ----------------------------
    -- Table structure for course
    -- ----------------------------
    DROP TABLE IF EXISTS `course`;
    CREATE TABLE `course`  (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `teacher` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `place` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `numb` int(255) DEFAULT NULL,
      `times` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `cname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Records of course
    -- ----------------------------
    INSERT INTO `course` VALUES (1, '张老师', '民德楼201', 20, '每周三上午1-2节课', '必修', '计算机网络');
    INSERT INTO `course` VALUES (2, '3', '3', 3, '3', '3', '3');
    INSERT INTO `course` VALUES (3, '2', '2', 2, '2', '2', '2');
    
    -- ----------------------------
    -- Table structure for gonggao
    -- ----------------------------
    DROP TABLE IF EXISTS `gonggao`;
    CREATE TABLE `gonggao`  (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `content` text CHARACTER SET utf8 COLLATE utf8_general_ci,
      `gtime` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Records of gonggao
    -- ----------------------------
    INSERT INTO `gonggao` VALUES (4, '44', '
    
    444123123
    
    ', '2022-03-27 12:32');
    INSERT INTO `gonggao` VALUES (5, '55', '
    
    55
    
    ', '2022-03-27 12:33');
    INSERT INTO `gonggao` VALUES (6, '123', '
    
    123
    
    ', '2022-05-16 16:29');
    
    -- ----------------------------
    -- Table structure for orders
    -- ----------------------------
    DROP TABLE IF EXISTS `orders`;
    CREATE TABLE `orders`  (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `ordernum` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `cid` int(11) DEFAULT NULL,
      `createtime` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `courseid` int(255) DEFAULT NULL,
      `score` int(255) DEFAULT NULL,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 75 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Records of orders
    -- ----------------------------
    INSERT INTO `orders` VALUES (66, '20220706143349552', 21, '2022-07-06 14:33', 1, 80);
    INSERT INTO `orders` VALUES (67, '20220706143627554', 21, '2022-07-06 14:36', 2, 80);
    INSERT INTO `orders` VALUES (72, '20220706170523078', 19, '2022-07-06 17:05', 1, 80);
    INSERT INTO `orders` VALUES (74, '20220706170713035', 19, '2022-07-06 17:07', 2, 80);
    
    -- ----------------------------
    -- Table structure for student
    -- ----------------------------
    DROP TABLE IF EXISTS `student`;
    CREATE TABLE `student`  (
      `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
      `cname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `category` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `createtime` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `age` int(11) DEFAULT NULL,
      `major` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Records of student
    -- ----------------------------
    INSERT INTO `student` VALUES (19, '3', '计科1班', '3', '2022-06-19 15:09', '男', 3, '3', '3');
    INSERT INTO `student` VALUES (20, '3', '计科2班', '23', '2022-06-19 15:25', '男', 3, '3', '3');
    INSERT INTO `student` VALUES (21, '嘎子', '计科3班', '2', '2022-06-19 15:28', '男', 2, '2', '2');
    
    SET FOREIGN_KEY_CHECKS = 1;

## 项目获取: ##

[https://gitee.com/sinonfin/L-javaWebSha/tree/master][https_gitee.com_sinonfin_L-javaWebSha_tree_master]

[0e0600ef92acda6be459bd2196def3e2.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/e4343d1f5b2e456fa8dcd56fa19c8cae.png
[a92df688748993b130593f8bc6981001.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/d66475b45bad48cc8ea95b1fb14c486e.png
[f1de3ab4a080b12227ff9f8966092abe.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/fe790c678b974d6097aefb2762015620.png
[99a35489c27607e70ec01102e0a40421.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/39b0e5e73c1d43e4a18a10e15d7218ee.png
[ee60a7e1cce93d793de963d3364c3531.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/7e824481bf0a4a9a8dcfcee5452e4a45.png
[4d46d67aa30b079938e9039200dc560f.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/f258bb44bef54caca9d7e15b7c636e01.png
[a0916b51fe7a7025e4698ed06cc7503f.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/d5b8a307904d4daebbd8b5426ff1510e.png
[bc57a2bb7c9b47e1ebfca86e79e59687.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/008b04137592491bacde3e9777d8a43f.png
[58457d8adf7979fa8f8806c90799d955.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/9f33d4cc378847ee9d4f19e8aa7c6ff8.png
[be46a89eb0ed20ee801022444b9a536a.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/b511ff9c3e44416086eecb0dbea8ce32.png
[60c4ffa41b3300aacd305883762b3f26.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/e098602a916e4cd4a70a3cbc2e847b1e.png
[09d77f46b8abcaa314ddbd2608375d8a.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/0d4c4eed20ab4effa7f62dca4fd4ff0d.png
[0ad4bae0d48a675ffc522dd0f07788c6.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/377bbffe81934856a21a81e47713c5ce.png
[01f2e747494d85de30dc18a863da65ef.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/3e1078a81ec14e0783af83f67d5d40d5.png
[2fb172cb62384b177fe5dafd6fc62fe7.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/20e4d3cf2f324c1297bb127d8633a7b2.png
[4df4ee594cf1b8d5b70a0b06e3727634.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/b5ff992617ca47c6ae62fa3be5f62977.png
[64ff4fabebbffda040f1b327a0194183.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/bd15db7ec8c248c0947a3dd4394b369a.png
[108c67f5f7d74d07d1788e29397dbce6.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/a39d16b2e6cc466c877f642135a49fbe.png
[88e70e64f55f2c9fe2077e87e2d84d7d.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/b924615aeaae4aba9a683077eb0b7dd6.png
[0e150d2fc1755f8a0103d0ebb7d7cb03.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/739a0edf83b84d2d820f320e59b7632a.png
[1bd5d1f4d65639ed05db24590273d11e.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/9c5177c5cf2340b7a987345643af1708.png
[b3bfaadb022a0408a9617082bd553224.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/3390b8635d0f4232b32642228f6b74d0.png
[c8aabb9dce52cd1c04838f86704b3b33.jpeg]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/883409099d234cdabaabe915cabf9d4d.png
[a2ed3ef06ca5eb618b1facb3a70c1ce1.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/6f151a3c9d2947c6b2c7c693f46fd420.png
[df26f732dd9889680375fe50d7416039.jpeg]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/dfa167ec83614958aa3d46fd11c49719.png
[fe35eac521accfe44ca18663e4f9cf77.jpeg]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/9d0f336dc47b4b79854388c11c613320.png
[e688615782fe13b759dc5efd9cd9a8d1.jpeg]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/08d3b9066b7a42f88aab55bbd83f79f8.png
[fa88dfad403b5d2d4fc5d5cd03c6c842.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/fe730609305d4d208511a70d1e2e10a9.png
[361f920b6e127a618965f7d20a483d8b.jpeg]: https://image.dandelioncloud.cn/pgy_files/images/2024/02/19/01d3c513242c4432ba65f9535cbfec87.png
[https_gitee.com_sinonfin_L-javaWebSha_tree_master]: https://gitee.com/sinonfin/L-javaWebSha/tree/master