The Design And Implementation Of Experiment Report Management System For Panzhihua University

At present, the lab reports of Panzhihua University are in artificial management mode. In order to achive better education, improve the teaching quality, simplify the way to write lab reports, the informationalization of the management of lab report is in urgent need.Therefore, the author tries to design a friendly interface for students, teachers and administers by using SQL Server2005to set up the background database for the lab report management system of Panzhihua University and using Visual Studio2008to implement the system. This system mainly includes three modules for students, teachers and administrators seperately. Students can use the system to choose courses on line, check the experiment results, write lab report and download courseware resources; teachers can release experimentProject, upload courseware, grading the students experiment report students submitted; adiministrators can clear up or delete the information of the website, so as to optimize quality of the information, etc. The research content are as follows:1) The author uses the idea of displaying the stored procedures by web pages. And after analysis, the paper proves that this kind of stored procedure can search needer information out of massive experiment report data rapidly.2) We use the concurrency control scheme elective reservation system.The scheme includes three basic requirements:system reservation will not exceed the prescribed maximum size; once the number of students is up to the limit, students who are still booking the course can only be put into the waiting list; if there is no one in the waiting list, students who book the course will be added to the name list automatically; if someone on the name list cancelled his reservation, the system would fill up with one student on the waiting list accordding to order automatically. This thesis also conducted three basic requirement analysis The result shows this scheme can process students’course selection requirement in real time. And it will not result in a concurrent data inconsistent phenomenon.3) This thesis also proposes a method of how to control students to select courses in different times, which is based on the experience of the author who has been responsible for the job to maintain the operation of educational affairs administration system for years. Practice proves that this method can guarantee the normal operation of educational affairs administration system despite of the limited resources, even when there are ten thousand students to select courses in this system.