| 3This paper is based on the project named "Quality Inspection Management System for Construction Material". The project is developed by 'Database and Intelligent-web Laboratory of Colleague of Computer Science and Technology of Jilin University', 'Construction Quality Supervision and Inspection Center of Qiqihar' and 'Changchun materials test machine Ltd.'. This paper is focues on "Information System for Construction Materials" which ueses Eclipse RCP as its framework and is implemented by eclipse plug-in. The system implements and perfects quanlity management of construction material and includes three parts which are 'Information System for Construction Materials', 'Quality Inspection System' and 'Web Monitoring System'.Construction industry is a pillar industry in our country. It penetrate into other fields and makes the foundatoin for other fields'existence and development. So, monitoring the quality of construction materials is a major bearing on people's livelihood. Monitoring the quality of construction materials is using instruments and equipment to test the quanlity of building materials, and judge the quanlity of building materials up to state's standard or not. Construction materials includes sand, stone, cement, concrete, bricks, and so on. Instruments and equipment include ruler, thermometers, pressure testing machine, micro-deformation measurement instrument, and so on. Management steps include: receive samples, testing, checking, verification, authorization, report printing, report releasing.However, there are many shortcomings of the existing system: the low level of inspection procedures, the short life cycle of information systems, information systems development platform generally low, difficult to upgrade information systems update. In order to address these problems, "Quality Inspection Management System for Construction Material",using Java language and Eclipse development platform for the development of client application,using Eclipse plug-in mechanism to detect the material generated plugin-test, using SQL Server2000 database to do background. The most important thing is Eclipse plug-in mechanism is the soul of the whole system: plug-in architecture, and its greatest strengths is to ensure that the system can form a stable structure of the system, all of the interactive, extended through plug-in for, and at the same time to ensure that all The independence of the plug-in, making system based on an assembly-type structure, that is loosely coupled, each of the terms of an external plug-in for a black box. More effective measures to solve the current widespread use of the system has flaws.There are three child system in "Quality Inspection Management System for Construction Material", and they are 'Information System for Construction Materials', 'Quality Inspection System' and 'Web Monitoring System'. These three complementary parts compose a Quanlity Monitoring System which is information-based and network-based.This paper mainly introduce the design of Data Upload and how it works, and data dump's implements. Data Processing include two parts: one is database tables and related operations of data upload, and the other one is upload programs. Database table of information related to the project table, and the data uploading information table, monitoring location information table, the table of the pilot reported to the basic information, and so on. Data is packaged into a plug-in operation named DBIN_DBInterface, it exposed the outside of a database connection, that is, all of the database operations through the completion of the connection. The database information, such as: location, name of the driver, user name, password and other information are stored in files named database.properties. According to the existing reality, we use Java socket programming, the upload process will be divided into three parts, the client program to send data, transit data transfer process, the server receives datas. The AutoClinet client running in the test center in the local area network servers, file ip.txt to change the allocation of the corresponding procedures; the port2port run transit center in the local area network can be detected on the network outside the machine, ip.txt the realization of the corresponding configuration file; the ServerPro Server running on the superior department in charge of Web site server, port.txt file for the program's profile. The ServerPro procedure which also considered mutually exclusive and thread synchronization problem, to solve a number of client server to upload data at the same time when possible deadlock. Using the DTS provided by SQL Server2000 database to extract the uploaded data.As the database may has various fault when it being used, such as the fault of things in-house, system failure, media failure, computer viruses, user misoperations, or the system running long after the use of a large number of very low frequency data have piled up, so we need to transfer data Reserve backup to reduce the amount of data. When the user needs, system can restore the data to dump out the operation to restore the data to the database. We use the data restore and backup tools that provided by SQL Serve2000 and use Stored procedure to dump data high-security. The "Quality Inspection Management System for Construction Material" provide users with graphical user interface, users do not have to concern how to achieve the background, user-friendly operation. However, the current way of the realization of the existence of the database table involved in a number of shortcomings: a new test system, a new plug-in at the same time, leading to a new database of private information table; changes in the original trial, although the number of table Has not changed, but lead to a corresponding database table fields change; full backup, more efficient low. Work in the future, we will fully use their own code instead of SQL Server2000 to provide the tools to overcome these shortcomings so that the system more stable and efficient.This subject implements Quality Inspection Management System for Construction Material, and compensates for the existing system in norms of testing procedures, life cycle and update of information system. |
PDF Full Text Request