Open laboratory management system based on distributed IC card

0 Preface

The laboratory of higher education is an important place for students to consolidate the theoretical knowledge they have learned and to cultivate students' practical ability, analytical problem-solving ability and innovative thinking. In recent years, with the continuous development of teaching reform, teaching modes, teaching methods and teaching methods are changing. In order to further improve students' hands-on ability and provide more mobile phone meetings for students, the laboratory is gradually open to students. . In the open mode, how to effectively manage experimental equipment, personnel, etc. is an important issue before us. Establishing an open laboratory management system is the best way to solve problems.

The experimental teaching information management platform is the key link to improve the quality and efficiency of teaching management and even to construct high-level experimental teaching units. The computerization and networking of experimental teaching information processing is also an important part of realizing the modernization and informationization of college management. The purpose of the experimental teaching information management platform is to provide optimal experimental teaching resources for experimental teaching and learning, to provide experimental teachers with simple and effective experimental management tools, experimental data and storage and supervision of experimental processes, as well as experimental assessment and The experimental information archive provides guarantee; the students are provided with the experimental environment and resources optimized by the combination of virtual and reality, so that students can master the basic experimental operation skills in the real experimental environment with the least amount of time, and carry out creative experiments on this basis. Develop an open laboratory management system based on distributed IC cards, so that student attendance, experimental equipment arrangement and use, access control management, etc. are all completed by computer, and the use of the laboratory and the personnel entering the laboratory can be inquired in real time. Remote maintenance of the system breaks through the boundaries between space and time, greatly reducing the workload of teaching managers and improving management efficiency.

1 system structure and configuration

This system is based on Windows Server 2003 platform and adopts ASP. NET technology, the connection between the Web server and the database, the background database is SQL Server 2005. Because the experimental teaching part is arranged in two experimental buildings, and also for the convenience of future query and system maintenance, the system adopts B/S structure mode, that is, the browser, web server and database server form a three-layer structure, and the system topology The structure is shown in Figure 1. The IC card reader is remotely connected through the router and the switch and the whole system. The system includes a web server, a database server and a plurality of card reader terminals, which are connected to each department floor switch through a twisted pair cable and interconnected. Each laboratory installs an IC card reader using RS 485 protocol, and connects to the RS 485 industry standard network, and then uses RS 485-TCP/IP converter to convert to standard network data to communicate with the server. .

2 system function

The system has the following functions (see Figure 2):

(1) System maintenance

To ensure the accuracy and reliability of the information and the integrity of the maintenance data, the fixed information used by the entire system is managed and maintained by the system administrator of the highest level of authority. Different units may add, delete, modify and set corresponding authority for department information by department-level management personnel according to specific conditions. Administrators can perform day-to-day management of devices and software over the Internet. You can register and authorize the cards issued to the teachers and students in the University City, and collect and output the collected information data.

(2) Card management

Card management is the management of personnel. IC cards are issued by the University City Card Center, but they must be registered in this system before they can be used. The card management completes the daily management of the IC card, such as placement, card replacement, replacement card, registration, authorization, etc., and different identity personnel have different usage rights.

(3) Attendance and access control management

Usually done by the IC card reader, the lab administrator can swipe the card and enter a password to open and close the door. Each laboratory is a time and attendance point. Each card is equipped with a dedicated card reader. The interface protocol is RS 485 or TCP/IP. There are two types of management structure for the card reader. One is one-way sensing. In the style of the class (that is, during the class time in the schedule), the user presents the authorized proximity card outside the door, and after the card reader recognizes the legal identity, it records the class time. The second is the two-way induction type (that is, the approval time of the open free course selection). The user presents the authorized proximity card outside the door. After the card reader recognizes the identity, the controller drives the electric lock to release and records the door entry time. When the user leaves the controlled room, the authorized proximity card is also presented in the door. After the identity is confirmed and confirmed, the controller drives the electric lock to release and records the door time, which can effectively prevent illegal entry of outsiders. And you can check the last person and time to leave the classroom. The dedicated card reader automatically records the attendance data, and periodically transmits the attendance data to the server through the bus, and also receives data from the server management center.

(4) Comprehensive inquiry

At present, the system has multiple levels of authority. The roles include administrators, leaders, department-level administrators, faculty, and students. The system will display the corresponding browsing interface according to the viewer's own permission level, and can query and carry out related information. operating.

The data of the query can be summarized and consistent with the browsing authority. It is divided into summary statistics and individual statistics. Annual statistics, monthly statistics and daily statistics can be performed on class students, faculty, laboratories and experimental equipment at different time periods. And can summarize the attendance results report with the class as the basic unit, and can also generate reports such as laboratory utilization, equipment or seat utilization, and print out the report.

(5) Information release

The system can post some notifications and information, and can also automatically publish the time information of the classroom vacant for students and teachers to freely make appointments.

3 The key to the realization of the plan and the problem to be solved

3.1 VPN environment construction

As a secure and effective commercial communication technology, virtual private network VPN has been widely used. It uses a shared network (such as IP network) and uses an encrypted VPN tunnel to ensure the security of transmitted data. The data transmission between the system server and the IC card reader terminal uses the constructed VPN tunnel for communication.

3.2 Web database access technology

The system uses SQL Server 2005 as the back-end database. The ADO data access object is powerful and realizes the security control of the shared database. Only authorized users can use the corresponding data. ADO is a powerful object method for developing database applications. SQL Server 2005 has a fairly complete security management mechanism. By properly using these two aspects, you can develop database applications that meet data security requirements.

3.3 Interface function of system and IC card collector

The used IC card acquisition instrument uses AVR single-chip microcomputer as the main control chip development. The interface implementation method mainly uses the network standard protocol TCP/IP protocol for data communication, realizes the standardization of the interface, solves the problem of long-distance wiring, and IC card reading. As a terminal on the network, the machine has its own IP address, which is convenient for the remote server to control it separately. The IP address of the interface module is not automatically obtained after dynamic allocation after each boot, but is fixed after each write to the main control chip. The address to be changed can only be completed by re-modifying the program; The defined application protocol makes the MCU programming more concise, and the IC card read and write matching is more convenient in the network communication process.

3.4 Security

In the distributed information management system based on campus network, the information of the system is stored in the database, so a large amount of key data is stored in the database. At the same time, because the database server is connected to the Internet, the destruction and theft of the database are not only from the inside, but also from the malicious destruction on the In-ternet and the theft of data information. This puts higher demands on the security of the database. How to ensure and strengthen its security is an important issue that every information system must solve. Therefore, the security mechanism of VPN technology is adopted, and the corresponding security function design is implemented in the whole program development, which includes: user ID and password, user authority allocation, user module allocation, and all operations of the user during system login. A series of development work such as recording; the card is also used as the access control card number and password.

4 Conclusion

The superiority of the laboratory open management system is clearly reflected in the use process. Providing accurate attendance data in a timely manner through advanced network technology can truly reflect the student's attendance and reflect the use of the equipment. At the same time, the system provides statistics, query and analysis functions for various conditions. With the continuous development of computer technology and the deepening of teaching reform, the Web-based computer management system will become one of the most promising applications of the Internet, and it will play a positive role in promoting teaching reform, and its social and economic benefits will be very Appreciable, with high practical value and extensive promotion significance.

Coffee Series :

We offer many different kinds of coffeeware, such as Double Wall French Press, Glass French Press , Pour Over Coffee Kettle ,handle drip coffee kettle, coffee filter, Coffee Canister , Coffee Tamper and so on.

Use our excellent quality product, enjoy a cup of coffee by yourselves.

If which one suitable for you, welcome to contact me or ask for the catalog .Will be glad to hear from you.

FAQ:

1:How can I get the sample?

We can provide the sample for customers to check the quality.

Please kindly provide the delivery info for calculate the sample cost. If you have DHL /TNT/UPS/FEDEX account, please also kindly provide it to us.

You can do the payment of sample via T/T and PayPal.

2:How about the sample time?

Usually the sample time is 7~10 days after have the sample cost.

3:How long will it take for mass production?

Usually 45~60 days after have the deposit.

4:Can we Have our logo or company name to be printed on your products or the package?

Welcome OEM.

5:what certificate can you provide?

CE,CB,GS,FDA,LFGB,ROHS are available here.

6:How can we get your monthly new products announcement?

Please join our mailing lists.

Coffee Series

Pour Over Coffee Kettle,Coffee Series,Coffee Canister,Coffee Tamper

Jiangmen Wellway Houseware Co.,Ltd , https://www.wellwayhouseware.com