abstract
Due to the further expansion of the school scale, the number of students has increased year by year, and the management of student information has become more and more complicated. Therefore, it is of great significance to effectively introduce the student information management system into the school educational administration for perfecting the school management system and improving the school teaching quality.
This system adopts B/S structure, ASP as development language and SQL Server 2000 as database for design and development. This paper briefly introduces the development background and environment of the system, analyzes the architecture of the system, and divides it into various modules, including user registration module, user login module, personal management module, basic information management module, special information management module, graduate information management module, score management module, more information management module and exit system module. The realization principle of each module and function of the system is introduced in detail, and finally the problems and solutions encountered in the development stage and testing stage are summarized.
Keywords: ASP；; SQL Server 2000B/S structure
1 Introduction
Management information system is what we often call m is (Management Information System), which is becoming more and more popular in the modern society that emphasizes management and information. Management information system is a new science, which spans many fields such as management science, system science, operational research, statistics and computer science. On the basis of these disciplines, information collection and processing methods are formed, thus forming a crisscross system.
With the rapid development of Internet in recent years, Intranet technology has been applied, which provides a good supporting environment for enterprise MIS. The application of management information system in enterprises has three elements, namely, people, computers and data. People refer to enterprise leaders, managers and technicians, as well as the leading institutions and implementing institutions of MIS construction. They must have the active participation of enterprise managers, especially enterprise leaders. Computer technology is the main technology to implement management information system. Among these technologies, software development is the focus of MIS development. The third factor cannot be ignored. Enterprise management data is the basis of normal operation of MIS. Broadly speaking, various management controls are the basis of MIS. In order to calculate the cost of a machine tool, it is necessary to input the cost of each part and each screw and nut on time, which involves many departments such as production workshop, procurement, warehouse, process design and finance, and must be guaranteed by a set of management system.
With the continuous progress of science and technology, computer science is becoming more and more mature, and its powerful functions have been deeply recognized by people. It has entered all fields of human society and is playing an increasingly important role. At present, the management of school students is an extremely important link in educational administration, and it is the core and foundation of the whole management. Due to the further expansion of the school scale, the number of students has increased year by year, and the management of students' situation has become more and more complicated. Faced with such a complicated task. It will be time-consuming and laborious for individuals to manage documents. Especially in performance management, the task is more arduous. As far as grade management itself is concerned, it is a systematic work with heavy tasks and strong timeliness. It involves not only the inquiry of students' personal grades, but also the work efficiency and quality of teachers. In recent years, with the rapid development of computers, computers have shown its great role in all fields of society. Undoubtedly, the effective introduction of computer management into school educational administration is of great significance for improving the school management system and improving the teaching quality and running level of the school.
At present, the information management efficiency of some colleges and universities in China is not very high, and it can no longer adapt to the development of the times because it wastes a lot of manpower and material resources. In the information age, this traditional management method will inevitably be replaced by computer-based information management. Therefore, the design and development of student information system is also an inevitable stage of the development of the times. This design mainly adopts B/S structure, which is mainly applied to all majors in colleges and universities, from students' entrance to graduation, everyone's information in the school and the management of their grades. This system mainly consists of six modules, which are basic information management, special information management, graduate information management, more information management (funding information management, work-study program information management, reward information management, punishment information management, change information management), achievement management and personal management. With WindonwsXP as the operating platform, ASP as the scripting language and SQL Sever 2000 as the database, users can input, modify and delete data.
2 system development background
With the continuous progress of science and technology, the current school student management is an extremely important link in educational administration, and it is the core and foundation of the whole management. Due to the further expansion of the school scale, the number of students has increased year by year, and the management of students' situation has become more and more complicated. Faced with such a complicated task. It will be time-consuming and laborious for individuals to manage documents. In recent years, with the rapid development of computers, computers have shown its great role in all fields of society. Undoubtedly, the effective introduction of computer management into school educational administration is of great significance for improving the school management system and improving the teaching quality and running level of the school. For the above reasons, the development of student management system is also an inevitable stage of the development of the times. This design mainly adopts B/S structure, from students' enrollment to graduation, everyone's information in school and performance management. This system is mainly divided into six modules, namely, basic information management, special information management, graduate information management, more information management (funding information management, work-study program information management, reward information management, punishment information management, change information management), achievement management and personal management. Users can input, modify and delete all kinds of information. It is more convenient for teachers of various majors to systematically manage student information, improve office efficiency and achieve more reasonable and convenient requirements.
3 system development environment
3. 1 theoretical basis of system development
3. Overview of1.1ASP
The basic meaning and characteristics of 1 active server pages
ASP is the abbreviation of Active Server Page, which means "Active Server Page". ASP is an application developed by Microsoft, not a CGI script. It can interact with databases and other programs, and is a simple and convenient programming tool. The web page file format of Asp is. ASP, now commonly used in various dynamic websites. ASP is a server-side scripting environment, which can be used to create and run dynamic web pages or web applications. ASP web pages can contain HTML tags, plain text, script commands, com components and so on. With ASP, you can add interactive content (such as online forms) to web pages, and you can also create web applications that use HTML pages as user interfaces. Compared with HTML, ASP pages have the following characteristics:
(1) ASP can break through some functional limitations of static web pages and realize dynamic web page technology;
(2)ASP files are contained in files composed of HTML codes, which are easy to modify and test;
(3) The ASP interpreter on the server will make ASP programs on the server and send the results to the client browser in HTML format, so that all browsers can browse the pages generated by ASP normally;
(4)ASP provides some built-in objects, which can make server-side scripts more powerful. For example, you can get the information submitted by users through HTML forms from the web browser, process the information in the script, and then send the information to the web browser;
(5)ASP can use server-side ActiveX to perform various tasks, such as accessing the database, searching the email or accessing the file system.
(6) Because the server sends the result of ASP program execution back to the client browser in HTML format, users will not see the original program code written by ASP, and the stored ASP program code will be stolen.
Advantages of 2.ASP
The main advantages of ASP can be summarized as follows:
(1) You can use VBscript or Jscript to create scripts, and combine with HTML language to easily complete the application of the website. For VBscript and Jscript, it doesn't matter which language you use. The Web server handles the two languages equally and sends the results in HTML format to the user's browser.
(2) ASP can easily write programs by using scripting languages (VBscript and Jscript), which greatly saves the time for network designers to learn a new language again. Moreover, writing ASP can be executed directly on the server side, without manual compilation or linking of programs, which is undoubtedly more convenient for the writing process.
(3) Use common text editors such as Notepad for editing design, such as Windows Notepad. Don't use FontPage98 or DreamWeaver2.0 for software modification, because it will destroy the source code. It is suggested to use CuteFTP's own CuteHTML editor for editing and design.
(4)ASP runs on the server side, so you don't have to worry about whether the browser supports the programming language used by ASP. A client can browse the content of a web page designed by a dynamic server page by using a browser capable of executing HTML code. ASP runs on the server side. After the program is executed, the server only returns the execution result to the client browser, which reduces the burden of the client browser and greatly improves the interaction speed.
(5)ASP is compatible with any ActiveX scripting language. In addition to designing in VBscript or Jscript, other scripting languages provided by third parties, such as Perl and Tcl, are also used by plug-ins. The scripting engine is a COM (Component Object Model) component that handles scripting programs.
(6) 6) The program code of Active Server Pages is hidden, and only the dynamic HTML file output by ASP can be seen at the client. Therefore, the source program can be prevented from being copied by others, and the security of the program is also improved.
(7) Server-side scripts can be used to generate client-side scripts.
(8) Object-oriented, and can expand the functions of ActiveX server components.
(9) ActiveX server components can be extended infinitely. You can use any programming language to write the required ActiveX server components.
(10) ADO(ActiveX data object) is a new data access model of Microsoft and the latest web database technology, which can provide web developers with convenient access to the internet database, and can be instantly updated and displayed on the client. It is very convenient to access the database, which makes it easy to access the database.
3. Introduction to1.2 SQL
SQL is the abbreviation of English Structured Query Language, which means Structured Query Language. The main function of SQL language is to establish contact and communication with various databases. According to ANSI (American National Standards Institute), SQL is considered as the standard language of relational database management system. SQL statements can be used to perform various operations, such as updating data in the database and extracting data from the database. At present, the most popular relational database management systems, such as Oracle, Sybase, Microsoft SQL Server, Access, etc. , using the SQL language standard. Although many databases have re-developed and expanded SQL statements, standard SQL commands including select, insert, update, delete, create and Drop can still be used to complete almost all database operations.
3. Introduction to the structure of1.3b/s
B/S (Browser/Server) structure is a browser and server structure. It is a change or improvement of C/S structure with the rise of Internet technology. Under this structure, the user interface is realized through the www browser, and very little transaction logic is realized in the browser, while the main transaction logic is realized in the server, forming a so-called three-tier and three-tier structure. This greatly simplifies the load of client computers, reduces the cost and workload of system maintenance and upgrade, and reduces the total cost (TCO) of users.
According to the current technology, it is relatively easy to master and low cost to establish a network application program with B/S structure in local area network and apply it through the database of Internet/Intranet mode. It is a one-time development, which enables different people to access and operate the same database from different places in different access ways (such as LAN, WAN, Internet/Intranet, etc.). ). It can effectively protect the data platform and management access rights, and the server database is also very secure.
3.2 System Development Environment
3.2. 1 system software environment
The software tools used in this system are:
Windows XP
Dreamweaver MX 2004
SQL Server 2000
IIS 5. 1V
Inertnet Explorer 6.0 or above.
Tool introduction
Introduction of Dreamweaver MX 2004
Dreamweaver MX 2004 is a professional tool for building websites and applications. It combines visual layout tools, application development functions and code editing support into a powerful tool so that developers and designers at all levels can use it to quickly create attractive interfaces and standards-based sites and applications. From leading support for CSS-based design to manual coding, Dreamweaver provides professionals with the tools they need in an integrated and efficient environment. Developers can use the server technology of their choice in Dreamweaver to build powerful Internet applications and connect users to databases, Web services and legacy systems.
Introduction to SQL Server 2000
SQL Server 2000 can meet the requirements of different types of database solutions in today's business environment. It is a widely used database management system, which has many remarkable advantages: ease of use, scalability suitable for distributed organizations, data warehouse function for decision support, close integration with many other server software, good cost performance and so on. Performance, scalability and reliability are basic requirements, and time to market is also critical. In addition to these core enterprise qualities, SQL Server 2000 also brings flexibility to data management and analysis, enabling organizations to cope calmly in a rapidly changing environment and gain a competitive advantage. From the point of view of data management and analysis, it is very important to turn raw data into business intelligence and make full use of the opportunities brought by the Web. As the record holder of the important benchmark scalability and speed award, SQL Server 2000 is a database product that fully supports the Web. It provides the core support for Extensible Markup Language (XML) and the ability to query on the Internet and outside the firewall.
4 system analysis
4. 1 system objective
On the basis of careful investigation and analysis of the existing system and current situation, the problems existing in student information management itself and the preliminary requirements for establishing a management information system are clarified, and the objectives of the new system are determined as follows through further research:
(1) According to the principles and methods of management information system, mature information technology and means are adopted to support the whole process of student management and improve the efficiency of educational administration.
(2) In view of the wide application of modern computers and the closed data, a student information management system based on Windows system is developed.
(3) Considering funds and other reasons, the system uses a PC and existing software to save money and reduce costs.
4.2 Feasibility analysis
After investigation, research, analysis and calculation, the application in student information management has matured. The feasibility of system development will be summarized from the following aspects, as follows:
(1) technical feasibility
With WindowsXP as the operating system, ASP as the scripting language and SQL database technology, a student information management system is designed and developed. The hardware environment of the new system is PC. When users use the system, they can enter the system with the correct password to maintain, operate and use the database.
(2) Economic feasibility
On the one hand, the friendly man-machine interface and stronger functional support in the system will further improve the work of educational administrators, thus saving manpower and material resources and improving economic benefits; On the other hand, the cost of system development is low, and the existing PC can provide all the hardware equipment environment needed for system development.
(3) Operational feasibility
Operationally, it is a reference to the Windows operating system. The use of this system is mainly based on the use of Windows operating technology to complete data entry, modification, deletion and other functions, which is convenient and simple. Before use, you can use the system by simply explaining to the user or reading the help file.
I hope it helps you.