| Nowadays, with the rapid development of computer science and technology and the communications technology, the advanced management system of the computer room gradually to instead of the traditional management system of the computer room is an inevitable trend. Based on conducting the actual research and access to large amounts of data , and taking advantage of the database technology and network communications technology and so on, I have developed a management system for the computer room and the realization of the network system design, the computer can be operated through a large number of trivial operations manual, which greatly to reduce the amount of managers and to cut costs and to increase the efficiency of management, which to improve the level of the computer room of modern management.Computer room management system is not a common management system, it is an integrated management system which is responsible for the student information management, user management, financial management and network communication management. The main objective of the system is to make the automation, information technology and network of the computer room management come true, so design system has been taking the principle of ensuring system stability, security and reliability, and easy maintained, make the system not only meet current demand, but also meet future expansion needs.The system is mainly composed by the system management module, information query module, information statistics module, serial communication module and network communication module and so on. The system is based on the actual demand of the development of the school computer room management, to achieve information management of the administrators, student information is stored in the computer, the computer generate students information report, count the daily number of students on line, count the students total consumption daily, query records of students on the computer, inquiry students card balance and the network management of the computer room and so on.From the initial database management systems to today's large-scale database management systems, databases have become indispensable in an integral part of our daily life. If there is no database, a lot of simple work on weekdays will be tedious and even difficult to achieve. In this paper , the room management system is also unable to lack the database management system, user login, user management; storage the students information on line, statistics, queries of the system have to be achieved through the database. This paper selects Microsoft Office Access database, chooses ODBC database access technology as the database access technology.Microsoft Office Access database, which means a single data storage, user-friendly operation and management; object-oriented, making it easier to develop applications; user-friendly, easy-to-use; integrated development environment, and can handle a wide range of data and information. In addition, Access allows to create custom reports for printing or exporting database information. As a relational database development Access owns a number of advantages, owns the convenience of the desktop database and a powerful relational database capability in a packet at the same time, and also is very convenient to use for small data exchange.Large number of manufacturers introduced all kinds of database systems, which have their own unique features on performance, price and range of applications. Various departments of an integrated information system need of a wide range of database as a result of differences and other reasons, visit the interconnection between them into a difficult issue, especially when users need to access from the client to different servers. The ODBC (Open Database Connectivity) made by Microsoft has become a strong scheme to solve this problem. ODBC basic idea is to provide users with a simple, standard and transparent database of the public programming interface to connect, the development of vendor was in accordance with the ODBC standards to achieve the bottom driver, the drive is transparent to users and allow different DBMS based on different technologies to achieve the use of Optimization, which is conducive to constantly absorbing new technologies and become more perfect. MFC's ODBC package for more complex types of ODBC API, provide a simplified interface to the call, which greatly facilitated the development of database applications. Use ODBC to complete most of the operation on the database.The system not only achieves the function of computer room management, but also realizes of the system network design by use of C/S (Client / Server) structure. C/S structure, client / server architecture, it is the software system architecture, Client and Server are often, respectively, in two computers which are far from each other, Client's mission is to process the user's request submitted to the server-side procedures, server program and then return the results to be displayed to the user; server program's mission is to receive customer service request procedures, and make the appropriate treatment, then returned the results to the client. Take full advantage of its advantages of hardware environment at both ends, achieve through the rational allocation of tasks to the Client side and Server-side, and reduce the overhead of communication systems.Servers can not only communication with terminals by network, but also can communication with terminal by the serial port or USB. In Win32, there two serial communication programming ways, one of which is the use of ActiveX controls, this process is simple, but is less flexible. The second is to call the API function of Windows, this method can clearly grasp the mechanism for serial communication and freedom and flexibility. Serial port can have two kinds of operation mode: synchronous operation mode and overlap operation mode (also known as asynchronous operation mode). Synchronous operation, API function will be blocked until the operation is complete, before they can return the way in multi-threaded, while not blocking the main thread, but will still be blocking monitor thread; and overlapping operation, API function will return immediately, the operation in the background to avoid blocking threads. This article uses Win32 API to achieve serial communication function, and the operation type is the asynchronous mode of operation.The system uses Visual C + + 6.0 as a development tool, it provides a very complete library and the development of friendly interface, enabling developers to rapidly build up the framework of the system, and it provides a variety of database access technology. |
PDF Full Text Request