Design of Civil Servant Examination Simulation System Based on Network
With the rapid development of the Internet, people pay more and more attention to various applications based on the Internet. In this case, the online examination system based on Web came into being. It can take exams for students anytime and anywhere by using the Internet, which is an extension of the traditional examination room. Based on the design and implementation technology of general online examination system, combined with the characteristics of civil service examination, through the structural design, background design and front-end development of the system, a civil service examination system based on B/S three-tier structure, ASP.NET 2.0 as the development platform and SQL Server 2000 as the database is constructed. This system basically realizes the functions of students' online examination, test paper generation, teacher's test paper evaluation and administrator's management of users and roles. The technology used in this civil service examination system is relatively novel and will be widely used in the future. The system can be used to evaluate the ability of candidates at ordinary times, and can also be used in actual exams. Keywords: online examination system; Online examination; Test paper generation; ASP.NET 2.0; C# design of online examination model for civil servants based on. With the rapid development of Internet, people pay more and more attention to Internet-based applications. The online examination system came into being. With the help of the Internet, it has become an extension of the traditional examination system, which can test students at any time and any place. Based on the design and implementation technology of traditional examination and the characteristics of civil service examination, this paper attempts to establish an examination system based on B/S, ASP.NET 2.0 and SQL Server 2000. The system can realize the general functions of online examination, such as generating papers, marking papers, user management and so on. The civil service examination system adopts many novel technologies and will be widely used in future practice. The system can be used for students' self-test and formal examination. Keywords: online examination system; The formation of test paper; ASP.NET 2.0; Total pages of C# catalog papers: 27 pages 1 citation 1 2 related theoretical and technical basis 1 2. 1 C #. Net12.2 Introduction to ASP.NET 2.0 2.3 SQL Server 2000 3 2.4 B/S Mode 3 3 System Requirements Design 4 3. 1 User Role Requirements 4 3.2 Function Requirements 4 3.2. 1 Candidates 4 3.2.2 Teachers 4 3.2.3 Administrators 5 3.3 Performance Requirements 54 System Overall Design 5 4. 1 System Function Description 5 4.2 Database Design 6 4.2.65438 Exam _ User Database 64.2.2 The main functions of the exam database are realized 75 System 10 5. 1 User. 0 5.2 Announcement View 10 5.3 Online Examination Module 1 1 5.3. 1 objective (administrative ability test 438+03 5.3.2 subjective (application) test 15.4 test paper +0 objective question (management ability test Kloc-0/9 5.6 User and Role Management 20 5.6. 1 User Management 20 5.6.2 Role Management 20 5.7 Announcement Management Module 2 1 6 System Test 265438. 2 1 6.2 test results 2 1 6.3 system security design 2 1 6.3. 1 password security 2 1 6.3.2 role access control 22 6.3.3 database security 22 conclusion 22 references 23 thanks 24 statements 25 appendix 26 Even in the traditional education mode, it is a trend to move the usual exercises and exams at the end of the course to the internet. Under the traditional examination method, organizing the examination should go through the steps of setting questions, examination and marking papers. With the increase of examination types and the improvement of examination requirements, teachers' workload will become larger and larger, and their work will be prone to mistakes. At the same time, the traditional examination is limited by time and place, and it is easy to damage and lose the test paper saved with paper. Therefore, to a certain extent, it is necessary to reform the traditional examination methods. In recent years, the popularity of civil service examination is increasing day by day, and there are more and more examination review materials. Among the civil service examination subjects, the number of administrative ability test questions is huge, and there are many kinds of questions, and the amount of information applied for is also thousands of words. If you blindly buy all kinds of materials, it is also a waste. Most of the materials and exercises are the same or can be reused. Therefore, under the condition of making full use of network resources, we can consider developing a civil servant exam simulation system, which can run on a website, so that both LAN users and Web users can access it through browsers and use it to do exercises or exams. In this way, we can make use of the outstanding advantages of online examination system, such as low running cost, high efficiency and strong flexibility, to realize paperless civil service examination, which is a kind of saving for all kinds of manpower, material resources and financial resources needed for civil service examination. At present, most examination systems at home and abroad use ASP technology as a server-side script to realize interactive web pages with applications such as databases. However, ASP adopts the way of explanation and execution, which is inefficient; The performance of some examination systems is low, and the number of online examinations supported is small, which is far from the scale effect of system operation. In addition, it still has great defects in security, robustness and reusability. In view of the above reasons, this graduation project chooses ASP.NET 2.0 technology to develop the civil service examination simulation system, and adopts the familiar and standardized C#. NET language and commonly used SQL Server 2000 as the database. 2. Relevant theoretical and technical basis 2. 1 C#. Net C# is an object-oriented programming language based on C and C++, which is suitable for Microsoft's basic XML application development based on "". NET "platform. C# components can become basic Web services and can be called by any application running on any platform. Microsoft claims that C# improves the progress of program development, reduces programming errors that may increase the development cost, and thus greatly improves the speed of program development. C# is such a programming language, which enables programmers to quickly develop a new generation of Microsoft applications. Net platform. Specifically, Microsoft's C# has the following characteristics: 1) high efficiency and security. The increasingly fierce competition requires developers to shorten the development cycle as much as possible, which is exactly the design idea of C#. This language is designed to help developers reduce the amount of code and the probability of code errors. 2) Meet the increasingly mature Web programming standards. At present, most application schemes are closely related to the Web, but the existing development tools all appear in the embryonic period of the Internet and the Web, so they are generally not suitable for the new Web technology. The development of C# language is based on Microsoft.Net platform, which can convert components into Web services and can be called by any application running on any platform. In addition, the Web service framework makes existing Web services look like local C# objects to programmers, which enables programmers to make use of their experience in object-oriented programming. 3) Eliminating programming mistakes Even professional C++ programmers often make some simple mistakes, such as forgetting to initialize variables. These simplest omissions often lead to unpredictable errors. Once the program is put into use, even the simplest mistakes will cost a lot of money to fix. Some new functions provided by C# can eliminate common C++ programming errors. For example, "garbage collection" reduces the pressure on programmers to manually manage memory, and variables in C# are automatically initialized by the environment. 4) Support version encapsulation. Subsequent versions can be developed directly on the basis of the old version without modifying the program. This function simplifies the process of developing subsequent versions and reduces the total cost of developing upgraded versions. 5) Most programming tools associated with business logic find it difficult to associate program code with business logic, but unlike C#, it can be used for extensible metadata of any object. C# can define domain attributes for engineering structures and apply them to any class or interface, which will ensure that each class or interface can be correctly identified as a part of a specific business object and help to strengthen the connection between program code and business logic. 2.2 Introduction to ASP.NET 2.0 ASP.NET 2.0 greatly improves the development efficiency of programmers and reduces the coding workload by 70% compared with ASP.NET1.1. Even in some cases, so-called zero coding can be realized. For developers, ASP.NET 2.0 encapsulates common functions such as user management and data control, and can be used as a standard control. The new controls include data source control, site navigation control, login control, theme and skin, master page, membership and role service. In ASP.NET 2.0, many new services based on the provider model are built in, and the common ones are member and role services. You can use the tool Aspnet_regsql.exe under C: \ Windows \ Microsoft. Follow the wizard to create or configure a SQL Server database for storing ASP.NET application service information. Of course, you can also install the SQL Server database used by the SQL Server provider through the Aspnet_regsql.exe command. For ASP.NET 2.0 membership and more information, please visit www.lw5173.com.