# 基于JSP实现的学生成绩管理系统
# 1 引言
## 1.1 任务简介
- 多用户管理:用户分管理员,学生
- 网页界面设计:利用HTML和CSS实现客户端前台设计
- 类间关系的设计、数据库表格设计
- 数据库数据的增(录入)、删、改、查等基本功能
- JSP中Requests Response内置对象的使用;
- 数据库表格结构的生成(SQL脚本)
- 前台JS校验设计
- DOM技术实现
- 其他扩展功能
- 开发环境与技术:IDEA、Java 语言、JDK 1.7、MySQL 6.0
## 1.2 需求分析
本学生成绩管理系统分为管理员登录,学生登录,其中管理员可以实现增加学生成绩信息,删除学生成绩信息,修改学生成绩信息,查找学生成绩信息,按照学生GPA进行排名,其中学生可以实现登录查询成绩功能,能否成功登录取决于数据库中是否有该学生。
# 2可行性分析
## 2.1 社会可行性分析
成绩是每一个大学生都会接触到的东西,不仅学生为之心动,为了管理学生的成绩,如果不用计算机来实现,老师们也会感觉很头疼麻烦,开发学生成绩管理系统后,让学生的成绩管理变的更加方便,学生也可以实现自助查询成绩功能,老师们也可以对学生成绩进行排名等。
## 2.2 经济可行性分析
该系统的开发调查主要是需要软件,这些软件都是免费的。主要的花销在于服务器的维护,除此之外没有其他的花销。
## 2.3 法律可行性分析
系统开发及维护所使用工具和技术及数据信息不违反法律。
# 3系统设计
## 3.1 系统功能设计
学生成绩管理系统具备以下功能:管理员学生分权限登录,增加学生成绩信息,删除学生成绩信息,修改学生成绩信息,查询学生成绩,按照学生GPA进行排名。
- **分权限登录**:系统分为管理员和学生用户两个权限,因为管理员就一个,所以账号秘密固定,但是学生有很多,所以在学生登录的过程中要对数据库中的学生进行查询,如果存在,而且密码正确,才能成功登录
- **增加学生成绩**:该功能可以将学生的姓名,学号,一系列成绩,登录密码等信息录入系
统
- **删除学生成绩**:该功能可以将学生的信息全部列举出来,然后选择想要删除的学生的信
息
- **修改学生成绩**:该功能可以将学生的所有信息全部列举出来,然后再选择想要修改的学生的信息,然后弹出一个修改框,再做仔细的修改
- **查询学生成绩信息**:该功能可以在输入学号后显示出学生的各项成绩信息
- **按照学生GPA进行排名**:该功能可以将所有学生按照GPA进行排名,并显示出来
## 3.2 算法流程设计
根据需求分析,将本系统分为以下模块,模块图如下:
![](http://www.writebug.com/myres/static/uploads/2021/10/19/ae0c77ad138facbe5c6b17fe776e8bcf.writebug)
# 4 关键技术及代码实现
## 4.1 基本功能
### 4.1.1 Web前端设计与实现
#### 4.1.1.1 HTML关键技术及应用
**include file技术**
```html
<html>
<head>
<title>
学生成绩管理系统
</title>
</head>
<body bgcolor="#FFFFFF">
<%@ include file="include_head_JSP2.jsp"%>
</body>
</html>
```
**Bootstrap 框架技术**
```html
<%@page contentType= "text/html; charset=UTF-8" language= "java" errorPage=""%> <!DOCTYPE html>
<html>
<head>
<style>
body{
background-image: url("1281116171866201.jpg");
}
</style>
<title>学生管理系统</title>
<meta name= "viewport" content = "width=device-width, initial-scale= 1.0">
<!-引入Bootstrap->
<link href="bootstrap.css" rel="stylesheet">
</head>
<body>
<center> <hi>学生成绩管理系统</hi></center>
<br>
<center> <div class ="container">
<a href= "selectLogin .j sp" class= "btn btn-info" role= "button">管理员</a>
<a href= "studentLogin.jsp" class= "btn btn-info" role= "button">学生</a>
</div></center>
<!– jQuery (Bootstrap 的 JavaScript 插件需要引⼊ jQuery) –>
<script src=”jquery-3.2.1.min.js”></script>
<!– 包括所有已编译的插件 –>
<script src=”bootstrap.min.js”></script>
</body>
</html>
```
#### 4.1.1.2 CSS关键技术及应用
**Bootstrap.css技术**
大量运用Boostrap前段框架中的CSS样式,美化登录界面,表格,按钮。
响应式表格:
```html
<table class=”table table-condensed table-hover” >
```
美化按钮:
```html
<a href=”Findinfo2.jsp” class=”btn btn-info” role=”button”> 返回 </a>
```
### 4.1.1.3 JS校验设计及应用
**登录界面的校验**
```javascript
<script language=”javascript” type=””>
function checkform()
{
//验证输⼊数据的合法性
if (form1.teacherName.value==””)
{
alert(” ⽤户名不能为空。”);
return false;
}
if (form1.teacherPassword.value==””)
{
alert(” 密码不能为空。”);
return false;
}
}
</script>
```
**往数据库写⼊数据的检验 **
```javascript
function checkform()
{
//验证输⼊数据的合法性
if (form1.id.value==””)
{
alert(” 学号不能为空。”);
return false;
}
if (isNaN(form1.id.value))
{
alert(” 学号只能为数字”);
return false;
}
if (form1.name.value==””)
{
alert(” 姓名不能为空。”);
return false;
}
if (form1.cppstring.value==””)
{
alert(”C++ 成绩不能为空。”);
return false;
}
if (isNaN(form1.cppstring.value))
{
alert(”C++ 成绩只能为数字”);
return false;
}
else
{
var num=parseFloat(form1.cppstring.value);
if (num<0||num>100)
{
alert(”C++ 成绩必须在 0-100 之间!”);
return false;
}
}
if (form1.cirstring.value==””)
{
alert(” 电路成绩不能为空。”);
return false;
}
if (isNaN(form1.cirstring.value))
{
alert(” 电路成绩只能为数字”);
return false;
}
else
{
var num=parseFloat(form1.cirstring.value);
if (num<0||num>100)
{
alert(” 电路成绩必须在 0-100 之间!”);
return false;
}
}
if (form1.Ewritestring.value==””)
{
alert(” 英语读写成绩不能为空。”);
return false;
}
if (isNaN(form1.Ewritestring.value))
{
alert(” 英语读写成绩只能为数字”);
return false;
}
else
{
var num=parseFloat(form1.Ewritestring.value);
if (num<0||num>100)
{
alert(” 英语读写成绩必须在 0-100 之间!”);
return false;
}
}
if (form1.Elistenstring.value==””)
{
alert(” 英语听说成绩不能为空。”);
return false;
}
if (isNaN(form1.Elistenstring.value))
{
alert(” 英语听说成绩只能为数字”);
return false;
}
else
{
var num=parseFloat(form1.Elistenstring.value);
if (num<0||num>100)
{
alert(” 英语听说成绩必须在 0-100 之间!”);
return false;
}
}
if (form1.physicsstring.value==””)
{
alert(” ⼤学物理成绩不能为空。”);
return false;
}
if (isNaN(form1.physicsstring.value))
{
alert(” ⼤学物理成绩只能为数字”);
return false;
}
else
{
var num=parseFloat(form1.physicstring.value);
if (num<0||num>100)
{
alert(” ⼤学物理成绩必须在 0-100 之间!”);
return false;
}
}
if (form1.prostring.value==””)
{
alert(” 概率论成绩不能为空。”);
return false;
}
if (isNaN(form1.prostring.value))
{
alert(” 概率论成绩只能为数字”);
return false;
}
else
{
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![doc](https://img-home.csdnimg.cn/images/20210720083327.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![jar](https://img-home.csdnimg.cn/images/20210720083455.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
收起资源包目录
![package](https://csdnimg.cn/release/downloadcmsfe/public/img/package.f3fc750b.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/PDF.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/JPG.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/JPG.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![folder](https://csdnimg.cn/release/downloadcmsfe/public/img/folder.005fa2e5.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
共 64 条
- 1
资源评论
![avatar-default](https://csdnimg.cn/release/downloadcmsfe/public/img/lazyLogo2.1882d7f4.png)
![avatar](https://profile-avatar.csdnimg.cn/efa50bd0b9924b728ac8bf795a9d17d9_u010918911.jpg!1)
工具盒子
- 粉丝: 61
- 资源: 1313
上传资源 快速赚钱
我的内容管理 展开
我的资源 快来上传第一个资源
我的收益
登录查看自己的收益我的积分 登录查看自己的积分
我的C币 登录后查看C币余额
我的收藏
我的下载
下载帮助
![voice](https://csdnimg.cn/release/downloadcmsfe/public/img/voice.245cc511.png)
![center-task](https://csdnimg.cn/release/downloadcmsfe/public/img/center-task.c2eda91a.png)
安全验证
文档复制为VIP权益,开通VIP直接复制
![dialog-icon](https://csdnimg.cn/release/downloadcmsfe/public/img/green-success.6a4acb44.png)