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.具体代码