ASP-based Score Management System For Students

With the development of Internet and the maturity of database, it is exigently necessary to establish a student manage information system. By reference to the development of student manage mode in domestic colleges today and with the help of large advanced manage system, the manage system of student's studing results was designed and the"Web-based"operation platform was built up. SQL Server 2000 was used as its background database, ASP and ADO technology were adopted to operate and to safeguard the database. With this system, registering and searching information can be very convenient by students.In the paper, the system developing environment was introduced, including server environment and development of language. In server environment a major comparison betreen C/S and B/S structures was made. It was found that a unified browser interface format is used by B / S mode client, so it is easy to operate and to improve work efficiency, and is favorable to realize the connection between different networks. The SQL Server database system and Web database access technology were also discussed by comparing the advantages and disadvantages of several methods. The conclusion is that the ASP technology is more powerful, higher efficiency and is easier for student to visit database. Finally the system using the current popular technology programme developed by Microsoft was employed which combining IIS and ASP and SQL Server for developing a Web server application at the windows environment, and providing a valid means for developing a dynamic intercommunication and effective web management system.In the development of language the dynamic and static Web pages, as well as the distinction of several scripting languages were introduced. VBScript script language is easier to learn, so it was chosen in the design as the scripting language.The design of database management system and interface were also introduced. In the SQL Server 2000 database four tables including user registing information table, student data table, course information table and score data table were established and then interrelated by different binders. Then ASP and ADO were combined to realize the student achievement database access. With various friendly interfaces the operation was made to be simple and quick. The system possesses the following major functions:①teachers, students and parents can require online about student's imformation, selected courses and examination results;②Senate managers can modify and delete some date online;③system managers can set purview levels for other users beside above mentioned.Some key problems of the technical and the solutions, which include the SQL Server database connectivity and database backup and restore were stated in the system design. The main technique and characteristics are as follows:①Convenience and simple. Based on B/ S pattern, system development and maintain can be run only on the server part, and users can operate system on the web only by a browser. Furthermore, the system has an amity and convenience interface, so it is easy to operate;②The real time and share quality. The system supports unlimited number of users. Legal users can enjoy appropriate service according to his right, and can be satisfied with different requirements;③Variety of searching. This system can realize assemblage condition search, and separate the search results from pages;④Reliable security. This system adopts Windows NT Server safety strategy and IIS safety strategy, and therefore provides a safety guarantee with it;⑤The database business handle. It ensures dependability and safety of the database.Finally, a main problem of the system was presented after running test, which is that the user access control is not very satisfactory. The next work is to resolve the issue of access control based on the competence of the role of access control methods.