The Design And Implementation Of Laboratory Reservation Management System

With the rapid development of computer network technology and the maturing of information network,networking in university teaching and practicing management has been becoming a trend.Considering the rising number of university's laboratories,experimental equipment,experimental projects,and experimental hours,we are required to face one crucial problem about how to achieve efficient organization of experimental teaching and full use of laboratories.Thus,a necessity exists for a further research on the laboratory reservation management mechanism,and the development of the relative management system.In this way,elimination of the possible conflicts in the use of laboratories,better utilization and higher efficiency are to be achieved.Based on the demands of laboratory for intelligent management,the paper first analyzes the status of the university's laboratory management,and considering the existing problems,a library reservation management system based on B/S(Browser/Server)architecture is designed.There are four types of users in this system: administrators,teachers,students,and non-registered users,who are given different permissions.The system is equipped with 9 functions: main page,user information,user login,results display,announcement of news and bulletin,laboratory reservation,data management,teaching process management,and data statistics.The major functions of the system are laboratory reservation,data management,teaching process management.(1)The steps for laboratory reservation? The system can know the current time when administrator set up the start time of the term.? The teacher can search the uses of the laboratory at the current time and the later by laboratory name.? The teacher can select the use time of the laboratory and he(or she)can reserve the laboratory and submit in the system.? After the teacher reserves the laboratory,the administrator must verify it,otherwise the reservation is not effective.? After the administrator verify the reservation of the laboratory,the system can email the teacher and students.(2)Teaching process managementThis function major for teachers and students,the teachers can use this function to maintain their courses and record?search the students' experimental grades.When recording the daily grades,the teacher can setup the scales of the participation? performance in experiment?and the experimental results in the total experimental grades.The system can compute the final grades according to the scales setup above.This function can also permit the teachers modify and record the grades of the students.(2)Data managementOnly the administrator can use this function.The data that be managed in the function include: users?teachers?roles?permissions?relations of courses?class?courses?laboratory?bulletin?term time and reservation information.The system has also designed a backtracking algorithm to generate an initial laboratory schedule based on the teacher's data of teaching management so that the teacher can reserve and change the experiment time conveniently.The system has also developed,for students' convenient use,an Android-based APP for them to view experimental appointments,submit experimental content and view experimental results wherever and whenever it is necessary.In order to coordinate the resources and ensure high utilization efficiency,the paper also proposes a three-point model in case there may be more than one teacher making an appointment for the same laboratory at the same period of time.The SSH(Spring&Struts2&Hibernate,SSH)architecture is used to develop the system.Struts2 is used to deal with the presentation layer;Spring is used to realize the business logic;Hibernate is used to maintain the database.The My SQL is used to save and manage the data in the system.The system is developed based on MVC model.In the system,teachers' teaching data can be well maintained,and a sound laboratory reservation management is ensured.Tests on the system show that: such system is easy to operate,and it has good reliability and scalability.Problems like low efficiency of manual reservation and reservation conflicts.Thus,the experimental instruments utilization rate is increased and the management level of the practical teaching is improved.