1、1Management Information System of Open Laboratory Based on ASP and SQL Server Technique（1.Information Management Department ，Shandong Foreign Trade Vocational College，Qingdao，Shandong，266071 China） Abstract. ASP is located in a server-side scripting running environment， through this kind of environm
2、ent， the user will be able to create and run dynamic interactive Web server application， such as interactive dynamic Web page， Web information processing， Web database access and so on. Analysis of the ASP technology and access the characteristics of WEB database， this paper introduces the working p
3、rinciple of ASP and ASP built-in objects and components， and emphasizes to discuss the ASP database access components ADO， based on this， gives the realization with ASP WEB database access to the application example. Key words： network technology； ASP； WEB database， laboratory management Introductio
4、n ASP is Microsoft Active Server Pages， namely activities of the Server page， is a set of Microsoft server-side scripting 2environment， ASP inclusion in IIS 5.0 and IIS 6.0 in. ASP is a technical framework， its main function is to generate dynamic interactive WEB server application， provide a powerf
5、ul method or technology. Through the ASP we can combine HTML WEB pages， ASP instruction and ActiveX element to establish dynamic， interactive and effective WEB server application. ASP write web page code running on the server side， the built-in IIS responsible for the explanation， and will explain t
6、he final results through the network to return to the client browser， so， as customers dont worry about your computer whether can run dynamic web page code， as well as on the server to run the program code， and therefore， can greatly improve the running speed of the web page， and ensure the safety o
7、f the source program to prevent program from eavesdroppers. Opening laboratory management system is designed to opening laboratory management and design. Mainly to solve the open laboratory process need to solve the relevant problems， both： laboratory courses， experiment booking， the experiment data
8、 record and submit the experiment report， the roll call， the experiment test module. 1.System structure design and function of the realization of the system 3Along with the development of network technology and the school teaching management modernization， the open laboratory management in our count
9、ry have made a great progress， and become the focus of teaching management. Opening laboratory management system improve the flexibility of teaching and rational configuration of teaching resources. Through the network to make an appointment can break through the traditional experiment of the constr
10、aints of time and space， with its network advantage， make reservations in advance， on time doing the experiment， finish the experiment automatically submit reports， as well as access to every experiment result， to provide students with more “freedom“ study， review and practice， experiment platform.
11、1.1 The construction and design of the system Management information system USES a BPS （BrowserPS- erver） three layer architecture： namely the browser layer； Application server layer； The database server layer. System structure as shown in figure 1 shows： Fig 1 System structure This system structure
12、 allows the user to the database access and application program execution are in complete Web server. Client need not install any special software， through 4the browser can access Web server and run the program. Use this system structure of the system to make full use of the server resources， provid
13、e a cross-platform， simple consistent application environment and realizing the development environment and application environment of separation， reduce the system development and maintenance workload and is convenient for the user to the expansion of the group. 1. 2 Realization of the system （1） e
14、xperiment course According to the experimental teaching requirements arrangement， in the system arranged each laboratory teaching contents. For example： laboratory 1： digital circuit experiment， laboratory 2： analog electronic technology experiment； Experiment 3： electrotechnics experiment. And so o
15、n. Free for students to make an appointment to do the experimental project and number. （2） the appointment. Students can through the network， in the allotted time， the free scheduled time experiment. The system automatically records， and the experiment scheduled in the form of chart display. 5（3） da
16、ta record To realize the door punch， the system automatically assigns experiment position. The experimental process to be automatic and manual mode of records of students experimental data， automatic generation of test report to teachers mailbox. Leave the lab also need to punch， and automatically s
17、hut off the power supply. （4） experiment and test Teachers can independent to the experiment content of add， delete and modify problem， can management and maintenance problems. Students answer after the system automatically judge or submit experimental teacher， generating performance statistical dat
18、a. Therefore， not only save the resources， improve the efficiency and realize the modernization of teaching management （5） equipment management In the student do the experiment process， if it is found that the experiment equipment failure， can be in management system of registration （equipment Numbe
19、rs， the equipment fault phenomenon） ， convenient experimental maintenance personnel maintenance. 2. Development tools and the choice of database 6In order to realize the system function of the network， the system by using the technology of ASP as a development tool， the system front-end web dialogue
20、 interface design， back end database application by high reliability， safety SQLServer2005 database. 2. 1 Process of ASP access WEB database ASP is a server-side scripting language， ASP execution the need for a server to explain. Interpretive execution ASP Server program is commonly IIS （InternetInf
21、ormation Server） ， it is Windows components. In the installation Windows choice when the components or install any after installation IIS components， then the right setting， can make the machine be server， and has explained ASP script language ability， all Microsoft Web servers support ASP. The WEB
22、database access method， as shown in figure 2 shows： Fig 2 principle of ASP access 2.2 ASP working principle ASP working principle： first of all， the client browser has a HTTP request to send to the Web server， request to visit a Web page. Then， the Web server through the analysis customer an HTTP re
23、quest to locate the position of the requested page. If the requested page filename suffix is aspx， then let this 7file transfer to aspnet - isapi. DLL processing， by aspnet - isapi. DLL the ASP code submitted to the CLR. If havent performed this program， then the CLR compilation and execution， get p
24、ure HTML results； If you have already performed this program， then direct execution compiled program and get pure HTML results. Finally， take these pure HTML results back to the browser as HTTP response， the browser received after this response， can display Web page. Due to the emergence of ASP， mak
25、e the Web visitors and server to interact more easy， use ASP can realize the information management system based on Web. Using ASP to realize information management system and its convenient for the user to back end database to add， delete， modify， query operation， and use ASP can realize paging tec
26、hnique， the user of a mass of record of inquires the be clear at a glance， easy to check all records. 2.3 ASP access WEB database using ADO technology A dynamic site is without database， the content of the site with database content changes. ASP ADO is recommended in connection and call database way
27、， it through the WEB Server setting ODBC （OpenDatabase Connectivity） ， can to almost all database read and write operation， such as Access to Microsoft 8Access， Microsoft SQL Server， and Oracle database， etc. ADO connection database in many ways， we mainly introduced， using database driver， direct a
28、ccess to the database connection string way. And through the design of the database server students read the page to for example， using ASP to realize user access to WEB database process. The system database connection code into in the conn. Asp file， in all and database connection page as long as c
29、ontains the file， you can through the call conn. Open to connect and open database， operation is completed after the call Close （） function to Close the connection database. Specific connection database code are as follows： Users in the client browser input a URL address in address bar and press ent
30、er such as： http： /localhost/browser.asp. When the browser web press the corresponding button， and the program will automatically jump to the server and open the server of the default directory data. Asp dynamic web page on the server database access. Establishment of file data. Asp in the server an
31、d read database to display. The first step to establish Connection 10object， an example of the second step use Open method and Access data driver Open Access database on the server studata. MDB， the third step SQL query， and inquires the results combined with HTML code to return to the client browse
32、r. 3. Conclusion According to the actual needs of the establishment of a the experiment management information system. This system has a simple， practical operation， maintenance， easy to upgrade， powerful， stable operation superiority， in line with the development trend of network information techno
33、logy； able to meet the “student-centered“ philosophy. Reference 1 Xu Feng，Wang Lime. The Design and Realization Based on the Asp Visiting Technology of WEB DatabaseJ. Microcomputer Applications.2012.28（7）：18-20 2 ZHOU Ren-yun.YANG Shi-feng. Online Examination System Design and Achieve Based on ASP TechnologyJ. Computer Knowledge and Technology.2012.8（16）：384-388 3 LU Bo， ZHANG Lu-lu. Design and Inplementation of Coal University Sports Network Chooese Class System Based on ASPJ. Coal Technology.2012.31（7）：202-204
