Table of contents
Summary I
Abstract II
1 Introduction 1
1.1 Topic background 1
1.2 Research significance 1
1.3 System design principles 1
1.3.1 Introduction to Java 1
1.3.2 Development Tools 2
2 Requirements Analysis 3
2.1 Product description 3
2.2 Function list 3
2.3 Technical introduction 4
3 System Analysis 5
3.1 Overall design structure diagram 5
3.2 Functional structure design 5
3.2.1 Student Module 5
3.2.2 Counselor Module 5
3.2.3 Academic Affairs Office Module 5
3.3 Total use case diagram 6
3.4 Login module 7
3.5 Student Module 8
3.5.1 Account Management 9
3.5.2 Application management 10
3.5.3 Personal information management 11
3.5.4 Score query management 12
3.6 Counselor Module 13
3.6.1 Student information management 14
3.6.2 Application review 15
3.6.3 Student account management 16
3.7 Academic Affairs Office Module 17
3.7.1 Application review 18
3.7.2 Information query 19
3.7.3 Announcement Management 20
4 System design and implementation 21
4.1 Module Summary 21
4.2 Database design 21
4.2.1 Database logical structure design 21
4.2.2 Application information form 22
4.2.3 Scholarship Management Information Form 22
4.2.4 Counselor management information 22
4.2.5 Statement of management information table 23
4.2.6 Score management information table 23
4.2.7 Family situation information form 23
4.2.8 Academic Affairs Office Management Information Form 24
4.2.9 Application status information table 24
4.2.10 Student Information Form 24
4.3 Login interface 25
4.4 Student interface 26
4.4.1 Application management interface 26
4.4.2 Personal information management interface 28
4.4.3 Family information management interface 29
4.4.4 Password change interface 30
4.5 Counselor interface 31
4.5.1 Student performance management interface 31
4.6 Academic Affairs Office module interface 31
4.6.1 Account management interface 33
4.6.2 Bulletin board management interface 35
5 System debugging and testing 38
5.1 Program debugging 38
5.2 Testing the program 38
5.2.1 Importance and purpose of testing 38
5.2.2 Test steps 39
5.2.3 Main contents of the test 39
Conclusion 41
Reference 42
Acknowledgments 43
Foreign original text 44
Chinese Translation 66
Scholarship management is an important part of student management in colleges and universities. In order to encourage students to study hard during their studies, colleges and universities have established a variety of scholarships. At the same time, they have invested a lot of manpower, material and financial resources in the evaluation and management of scholarships. Scholarship management work, especially review work, has the characteristics of wide coverage, heavy workload, and relatively concentrated time [3]. The scholarship evaluation work of colleges and universities must be carried out every academic year. The traditional evaluation work is mainly carried out manually, which has disadvantages such as low efficiency and error-prone. Therefore, it is very necessary to realize the informatization of scholarship evaluation management.
The role of information in social and economic development is increasingly valued by people. The level of development and utilization of information resources has become one of the important indicators of a country’s comprehensive national strength. As a tool for information processing, computers are used to adapt to the rapid increase in information processing needs and meet the needs of various information systems for database management. Basic database systems are developed on the basis of file systems. Database methods are designed to meet the needs of large amounts of data management in transaction processing. With the promotion of computer management systems, database applications have gradually become popular [4].
At present, our country’s universities continue to expand enrollment, and the management of student scholarship evaluation is becoming increasingly complex and diversified. In order to facilitate the evaluation and management of scholarships, we created this system [5]. This system adopts a computerized assessment model. Query, modification and other operations all use computer database technology. Compared with the previous manual calculation method, it has made great progress, provides considerable convenience, and solves the problem of manual operation. Problems such as heavy workload, long cycle, low efficiency, errors, and omissions have made the scholarship evaluation management work fast, simple, and accurate [6].
3 System analysis
3.1 Overall design structure diagram
Figure 3-1 Overall design structure diagram
3.2 Functional structure design
3.2.1 Student module
After logging in, students enter the student module. Students can enter application materials (personal information, student family situation), check their own grades, and submit after entering and checking their own information.
3.2.2 Counselor module
After logging in, the counselor enters the counselor module, where he can add, delete, modify, and check students’ grades, rewards and punishments, and review students’ qualifications. After the counselor confirms that the student’s information is correct, he or she will report the approved students to the Academic Affairs Office.
3.2.3 Academic Affairs Office module
The leader of the Academic Affairs Office logs in and enters the Academic Affairs Office module. The Academic Affairs Office can add and delete registered students. The leader of the Academic Affairs Office inquires about student information, and after review, reports the approved students to the Education Bureau, and releases them after confirmation by the Education Bureau. Students receiving scholarships.
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort() + path + "/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'Login.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
<script type="text/javascript" language="javascript">
<!--
function check(){<!-- -->
var us = document.form.username.value;
var pw = document.form.password.value;
if(us == null){<!-- -->
alert("Account cannot be empty!");
document.form.username.focus();
document.form.username.select();
}
else{<!-- -->
if(!us.match(/^[0-9]{<!-- -->0,10}$/i)){<!-- -->
alert("The account number must be a number and the length is 10 digits!");
document.form.username.focus();
document.form.username.select();
}else{<!-- -->
if(!pw.match(/^[0-9a-zA-Z]{<!-- -->1,8}$/i)){<!-- -->
alert('Password must start with a letter or number\
and cannot be empty!');
document.form.password.focus();
document.form.password.select();
}
}
}
}
-->
</script>
</head>
<style type="text/css">
<!--
body {<!-- -->background-image: url(./res/images/Loginbackground.jpg);
background-repeat: no-repeat;
background-position: center}
-->
</style>
<body>
<form action="LoginServlet" method="POST" name="form">
<table width="800" height="586" border="0" align="center" >
<tr>
<td width="537" height="219"> & amp;nbsp;</td>
<td width="253"> & amp;nbsp;</td>
</tr>
<tr>
<td height="30" align="right"><font color="#000000"><B>Account:</B></font></td>
<td><input type="text" height="25" name="username" /></td>
</tr>
<tr>
<td height="30" align="right"><font color="#000000"><B>Password:</B></font></td>
<td><input type="password" height="25" name="password" /></td>
</tr>
<tr>
<td height="22" align="right"><font color="#000000"><B>Character:</B></font></td>
<td>
<select name="loginType">
<option value="1">Student</option>
<option value="2">Counselor</option>
<option value="3">Academic Affairs Department</option>
</select>
</td>
</tr>
<tr>
<td height="28"> & amp;nbsp;</td>
<td><input type="submit" value="Login" onclick="check()"></td>
</tr>
<tr>
<td height="243"> & amp;nbsp;</td>
<td> </td>
</tr>
</table>
</form>
</body>
</html>
