General Examination Database Design Based On B / S Mode And Realization

With the development of internet technology and the further reform in education, the general test base management system has already become one part of the computer assisted instructions. It mainly stores a great deal of examination questions under categories in computer, and chooses examination questions from the collections of examinations through strategy for buildup paper at random to cover the requirements of the examination. The development of the system do not only able to release teachers from assigning topics, grouping topics and correcting the examination papers repeatedly, improve teachers' work efficiency greatly, but also makes the questions become standardized and objective, which is helpful to improve the teaching quality and make teaching-examination separation comes true. Therefore general test base management system has become a hot research topic in recent years.Based on detailed research of the designment and establishment of B/S model system of the test program, several aspects of work are listed as follows:1,To describe the background, classification, research status and the future development tendency of the database system of the collections of examinations.2,To state the general introductions of the fundamental theory of the examinations collections and system structure, then to introduce the associative technology of JSP like JSP, Java Bean components, JDBC and Java Servlet etc.3,To analyse the need of database system, to defines the system cases and data flow chart.4,To describe the of the general system structure and the hierarchical division of structure, and introduces the basic function of each subsystem.5,To detailed design the database system based on the ordinary design, and to point out the problems and solutions in the process of the system achievement. 6,To introduce the system of auto-composing test paper function emphatically. Mainly introduced based on genetic algorithm of grouping algorithm, is characterized by simple operation, flexible, practical strong, fault tolerant ability, etc.The system adopts B/S three-layered structure, using the JSP relevant technology, using SQL2000 as the backend database, and use Windows 2000 as a server system to develop it. Proved by the basic testing, this system is stable in operation, convenient to be operated and it can cover the basic requirements of examination papers. It lays the foundation for further research and the development of database system.