ssm项目——软件项目管理在线学习网站

1.项目概况

针对“软件项目管理”这门课程的在线学习网站

包括软件项目管理在线学习网站以及后台管理网站

2.需求分析

涉众：管理员、教师、学生

教师功能：管理选课结果、成绩录入、成绩分析、成绩预警、发布课程视频、留言回复

学生功能：选课、选课结果查看、成绩查看、线上学习、留言回复

管理员：管理用户信息、课程信息、选课信息

3.实现

一些截图如下：

 

 

 

 

4.数据库设计

user

+----------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+----------------+
| uno | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(20) | NO | | NULL | |
| shool | varchar(20) | NO | | NULL | |
| no | varchar(20) | NO | | NULL | |
| password | varchar(15) | NO | | NULL | |
| email | varchar(30) | NO | | NULL | |
| flag | char(2) | NO | | NULL | |
+----------+-------------+------+-----+---------+----------------+

course

+-------+-------------+------+-----+--------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+--------------+----------------+
| cno | int(11) | NO | PRI | NULL | auto_increment |
| cname | varchar(20) | YES | | 软件项目管理 | |
| uno | int(11) | NO | MUL | NULL | |
+-------+-------------+------+-----+--------------+----------------+

choose

+-------+---------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+----------------+
| no | int(11) | NO | PRI | NULL | auto_increment |
| cno | int(11) | NO | MUL | NULL | |
| uno | int(11) | NO | MUL | NULL | |
| grade | int(11) | YES | | 0 | |
+-------+---------+------+-----+---------+----------------+

media

+----------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| title | varchar(50) | NO | | NULL | |
| name | varchar(20) | NO | | NULL | |
| src | varchar(200) | NO | | NULL | |
| picture | varchar(200) | NO | | NULL | |
| descript | varchar(400) | NO | | NULL | |
| uptime | varchar(40) | NO | | NULL | |
+----------+--------------+------+-----+---------+----------------+

words

+----------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(20) | NO | | NULL | |
| date | varchar(40) | NO | | NULL | |
| content | varchar(400) | NO | | NULL | |
| media_id | int(11) | NO | MUL | NULL | |
+----------+--------------+------+-----+---------+----------------+

reply

+----------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(20) | NO | | NULL | |
| date | varchar(40) | NO | | NULL | |
| content | varchar(400) | NO | | NULL | |
| words_id | int(11) | YES | MUL | NULL | |
| media_id | int(11) | YES | MUL | NULL | |
+----------+--------------+------+-----+---------+----------------+

newst

+---------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| head | varchar(100) | NO | | NULL | |
| summary | varchar(255) | YES | | NULL | |
| body | longtext | NO | | NULL | |
| time | date | YES | | NULL | |
| img | varchar(100) | YES | | NULL | |
| type | varchar(20) | NO | | NULL | |
+---------+--------------+------+-----+---------+----------------+

5.具体代码

详细代码见GitHub

 

转载于:https://www.cnblogs.com/sn-7/p/11055466.html