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

Love The Way You Lie 2021-12-08 17:53 454阅读 0赞

1.项目概况

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

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

2.需求分析

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

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

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

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

3.实现

一些截图如下：

![1479142-20190620203143413-1658024293.png][]

![1479142-20190620203153116-887037358.png][]

![1479142-20190620203206234-2106802773.png][]

4.数据库设计

user

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

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 | |  
\+----------+--------------+------+-----+---------+----------------+

\+----------+--------------+------+-----+---------+----------------+  
| 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

5.具体代码

[详细代码见GitHub][GitHub]

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

[1479142-20190620203143413-1658024293.png]: /images/20211209/789bf310aaa7484481888ba250843e5f.png
[1479142-20190620203153116-887037358.png]: /images/20211209/3e7efbcdc9d64b71b4f68860fc86a15d.png
[1479142-20190620203206234-2106802773.png]: /images/20211209/834edcc488e64d4f8542ad45cb4bdb36.png
[GitHub]: https://github.com/snowy77/software_manage