ABSTRACT摘要
随着全球化的迅速发展,企业经受着与跨国公司直接竞争的巨大挑战。要赢得这场挑战就必须提高整体竞争能力,因此变革企业的管理模式,提高管理水平,实施信息化建设无疑是实现这一目的的必由之路和明智之举。一个成功的企业,不仅要提供高质量的产品,还要有高的工作效率,并控制成本。在信息化时代,一套完善的管理信息系统就是有效提高企业工作效率,降低成本的最佳途径。基于这一点,开发了企业设备资产管理系统。
With the rapid development of globalization, Chinese enterprises experiencing great challenges in direct competition with multinational companies . To win this challenge it is necessary to improve the overall competitiveness , and therefore change the management model to improve the management level, the implementation of information technology is undoubtedly the only way to achieve this purpose and wise. A successful business , not only to provide high quality products , but also have high work efficiency and control costs. In the information age , a sound management information system is to improve the efficiency of enterprises , the best way to reduce costs . Based on this , the development of the enterprise asset management system.
本系统要实现的功能比较多,最重要的是对设备从采购到安装,维护等的跟踪。在日常工作中由用户即系统管理员负责具体的业务,比如添加新购设备,设备维护计划表,每周或每月生成设备资产统计表,为公司决策层提供服务。其次,本系统充分运用了Ajax技术和模糊查询来实现查询的智能提示功能,提供了很好的用户体验。最后,本系统使用JavaScript和DOM技术方来实现用户在提交表单时的友好提示。
The system functions to achieve more, the most important is the device from procurement to installation , maintenance tracking. In their daily work by the user that the system administrator is responsible for specific services, such as adding new equipment , equipment maintenance schedules , weekly or monthly statistics generation equipment assets to provide services to the company decision-making . Secondly , the system and make full use of Ajax technology to achieve intelligent fuzzy query prompts queries, provide a good user experience. Finally , the system side using JavaScript and DOM techniques to achieve user-friendly tips when submitting the form.
In this paper, the use of JSP + MySQL enterprise asset management systems, enterprise asset management system includes asset management, software management , service management , report generation and so on. The device can achieve the basic asset information query, add , modify, delete . The system can greatly improve the efficiency of enterprise management , provide the basis for the daily operation and development decision-making enterprise . To maximize the satisfaction of enterprise characteristics and needs of each user .
Along with the quick development of globalization, our country the business enterprise experience to directly compete with multinational company of huge challenge.To win this challenge and then have to improve whole competition ability therefore the management style that changes a business enterprise raises to manage level and carry out information-based construction undoubtedly is carry out this purpose of necessarily from of the road and advisability raises.A successful business enterprise not only needs to provide the product of high quality, but also has to have the work efficiency of Gao, and control cost.In the information-based ages, a set of perfect management information system is to effectively raise a business enterprise work efficiency and decline low cost the best path.According to this, develops a business enterprise equipments property to manage system.
The function that this system wants to realize is more, most important of is to equipments from buy gearing, following of maintenance etc..In the daily pursuit from customer namely the system managing person be responsible for concrete business and for example add to lately buy an equipments, the equipments supports to plan form, weekly or monthly born equipments property statistics form, provide service for the company decision layer.Secondly, this system is made the most of Ajax technique and misty search to carry out the intelligence of search hint function and provides good customer's experience.Finally, this system uses JavaScript and DOM technique square to carry out customer the amity hint while handing in a form and list.
This article mainly makes use of JSP+MySQL carry out a business enterprise equipments property management system, the business enterprise equipments property manages system to mainly include a property management, the software manages, service management, the statement is born etc..The basic search that can carry out to the equipments property information, add, modification, deletion.The system can biggest raise a business enterprise management efficiency, is daily operation and development decision of business enterprise to provide a basis.It is utmost to satisfy the characteristics and need of each customer of business enterprise.
1 Introduction绪论
1.1 Background , purpose and significance of this study本文研究的背景、目的与意义
The traditional enterprise asset management model , the majority of enterprise asset management business is mainly dependent on artificial means , workload and inefficient , prone assets attributable unknown , inventory too long, and even lead to the financial sector can not understand the business equipment dynamic changes of information assets , can not provide accurate information to the enterprise equipment asset management decision-making . Part of the re- purchase of the unit , light management, lack of a sound internal control system did not develop a complete asset inventory and equipment assets for device classification number is not reflected in detail the source of the equipment assets , acceptance , location , responsible units and persons related content, is not conducive to effective monitoring and management of equipment assets. The key to the solution to these problems lies in information technology enterprise asset management , enterprise vertical management system, to develop and transparency flattening development . Equipment asset management system for specific business development companies , specifically in the asset management business and report generation module based, to provide accurate and timely information to the business equipment asset management , improve its value , so that timely purchase and timely depreciation timely maintenance. This business plays a vital role and significance in the information construction.
Now more and more attention to the management of enterprise equipment assets , they passed information and build a sound management system, to be unified enterprise asset management , thereby improving the ability to resist risks . Sequential reads abreast of the latest equipment to ensure that the situation , which can set effective decision-making system in the shortest possible time . They fix various defects originally existing enterprise asset management , especially for private long-term occupation of public equipment for the control , avoiding the accounts appear in the traditional asset management in clear, early retirement , advance purchase and other issues. Through technology and scientific management , greatly improve work efficiency, increase efficiency , reduce costs and help enterprises to improve their competitiveness and management level.
1.2 The organization of this article本文的组织安排
The second chapter of the system development techniques are analyzed briefly enterprise asset management system used by the techniques, tools , and its simple introduced and analyzed. Chapter III database technology, introduce enterprise asset management system used in database technology and its structure. Chapter IV systems analysis , including content feasibility analysis, system analysis and functional analysis of the operating environment and so on. Chapter V system design, specific development modules. Chapter VI system functions and implementation , functional module . Chapter VII of system testing. Chapter VIII of the conclusions summarize the whole thesis work done , and get the harvest in the paper .
2. key technologies and frameworks.关键技术和框架
JSP technology uses the Java programming language class of XML tags and scriptlets, processing logic to encapsulate produce dynamic web pages . Web access also exists in the server-side application logic resources through tags and scriptlets. JSP Web pages and Web design and display logic separate support reusable component-based design that becomes quickly and easily develop Web -based applications .
JSP and Java Servlet , is executed on the server , usually returned to the client is an HTML text, so long as the client browser will be able to navigate.
MVC is the abbreviation of three words , namely: model (Model), view (View) and control Controller). The purpose of the MVC pattern is the division of the functions of Web systems . Model layer implements the business logic of the system can usually be achieved with a JavaBean or EJB . View layer is used to interact with the user, typically using JSP to achieve. Controller layer is the communication bridge between the Model and the View , which can be assigned to user requests and selects the appropriate view for display , but it also may explain the user's input and map them to the model layer can perform.#p#分页标题#e#
( 1 ) write once, run everywhere . In addition to the system , do not make any changes to the code . ( 2 ) system support. Basically any environment can develop on all platforms , the system deployed in any environment , any expansion of the environment. Compared ASP.net limitations are obvious.
( 3 ) strong scalability. From only a small Jar file to run Servlet / JSP, the clustering of multiple servers and load balancing to multiple Application for transaction processing , messaging, one server to many servers , Java shows a huge vitality.
( 4 ) diversification and powerful development tool support. Java already has many excellent development tools, and many can get free .
( 5 ) support for server-side components. web applications require powerful server -side components to support , developers need to use other tools designed to achieve functional components for complex web pages to call in order to enhance system performance. JSP can use sophisticated JAVA BEANS components to implement complex business functions.
Struts is an Open Source project Apache Foundation 's Jakarta project group , which uses the MVC pattern , can be a good help java developers to take advantage of J2EE Web application development . And , like other java framework , Struts also object-oriented design, MVC Mode " display logic and business logic separation " capability on its head. Core Structs framework is a flexible control layer , and so on , such as Java Servlets, JavaBeansResourceBundles with the XML standard technologies , as well as some of the Jakarta Commons libraries . Struts by a group of cooperating classes ( components ), Servlet and jsp tag lib components. Struts -based web application framework is basically in line with JSP Model2 design standards can be said to be a change in the type of a traditional MVC design pattern.
Spring is an open source framework to solve the complexity of enterprise application development created by the Rod Johnson . One of the main advantages of the framework is its layered architecture , layered architecture allows the user to choose which one to use components , as well as provide an integrated J2EE application framework development . Spring accomplished using basic JavaBean previously could only be completed by the EJB thing . However, Spring is not limited to the use of server-side development . Any Java application can benefit from the simplicity , testability , and loose coupling perspective from the Spring .
Hibernate object-relational mapping framework is an open source , it had a very lightweight JDBC object package so that Java programmers can use arbitrary object programming thinking to manipulate the database . Hibernate can use JDBC in any application , both can be used in Java client program can also be used in Servlet / JSP Web application , the most revolutionary is , Hibernate can replace the EJB CMP J2EE application architecture to complete the task of data persistence .
Ajax means Asynchronous JavaScript and XML (Asynchronous JavaScript And XML). Ajax is not a new programming language, but a technique for creating better, faster and more interactive Web applications . By Ajax, you can use the JavaScript XMLHttpRequest object to communicate directly with the server . With this object , JavaScript without reloading the page in the case with the Web server to exchange data . Ajax between the browser and the Web server uses asynchronous data transfer (HTTP requests ) , so you can make a small amount of information request pages from the server , rather than the entire page. Ajax allows Internet applications smaller, faster and more friendly. Ajax is an independent Web server software in browser technology .
The database is organized in accordance with a data model, data collection and storage of secondary memory. This data set has the following characteristics : try not to duplicate , to the best way for a variety of application services to a specific organization , its data structure is independent of the application that uses it , the data add, delete, change and retrieved by unified software management and control. From a historical development, the database is the advanced stage of data management , which was developed by the document management system.
Relational database , is built on the basis of the relational model database , a collection of algebra and other mathematical concepts by means and methods to process the data in the database. Linkages various entities in the real world entities and relationships between models are used to represent. SQL is the standard query language to retrieve data based on relational database language , the language implementation of relational database data and operations. Relational model data structures from the relationship , the relationship between the operating set , relational integrity constraints three parts.
MySQL is an open source relational database management system, developed by the Swedish company MySQL AB. Currently MySQL is widely used on the Internet for small and medium sites. Because of its small size , speed , and overall have chosen MySQL database as a site of low cost, open source , especially this feature , many small and medium sized websites in order to reduce the total cost of ownership.
( 1 ) the use of C and C + + to write and use a variety of compiler testing to ensure the portability of the source code.
( 2 ) support for multiple operating systems AIX, BSDi, FreeBSD, HP-UX, Linux, Mac OS, Novell NetWare, NetBSD, OpenBSD, OS / 2 Wrap, Solaris, Windows and so on.
( 3 ) provides an API for a variety of programming languages. These programming languages , including C, C + +, C #, VB.NET, Delphi, Eiffel, Java, Perl, PHP, Python, Ruby and Tcl .
( 4 ) Support multi-threading , make full use of CPU resources to support multiple users.
( 5 ) both can be used as a separate application in a client -server network environment, but also can be used as a library and embedded into other software.
( 6 ) provide multi- language support, such as the Chinese of common coding GB 2312, BIG5, Japanese Shift JIS and so can be used as a data table name and data column name.
( 7 ) optimized SQL query algorithm effectively improve the query speed. Provide for the management, inspection , and optimize database operations management tools that can handle millions of records have a large database .
Requirements analysis phase is the development of enterprise asset management system the most important stage. The first is to understand the needs analysis and clarification of the needs of users , and then rigorously define define enterprise asset management system requirements specification .
The system involves three types of users : ordinary users , system administrators and anonymous users. Among them, the anonymous user can log home , ready to view basic information about the device assets , primarily serving the general staff . Ordinary users are those in charge of equipment management department , they can enter the system back , but only viewing . System administrators are the primary user of the system is responsible for data entry , modify, delete, and general user management.
( 1 ) Asset Management Module: including fixed asset management and consumables in two parts , which focuses on fixed asset management division of this paper is mainly to manage more than $ 500 for the price of corporate assets devices, and consumables mainly managed unit for smaller items.
( 2 ) Software Management Module : Includes basic information management software and management information software installation , software, basic information which is used to purchase commercial software for enterprise unified management , and software installation information for the management of enterprise software installation information .
( 3 ) Service Management modules: including lending return management, equipment maintenance management, and management of equipment depreciation for fixed assets to provide restitution lending management, maintenance management , and depreciation management functions.
( 4 ) Statistics Module : statistics including fixed assets , loan return statistics, statistics equipment maintenance , equipment depreciation statistics, consumables and software basic statistical information statistics. This module is the use of a multi- criteria query , statistics information under a variety of conditions , while also providing a full Excel functionality. Administrators can export data to Excel tables needed .
( 5 ) System Management Module: including department management and user management , including department management departments to maintain basic information , user management is used to maintain the user basic information. The system administrator can add new users and modify their own passwords , but ordinary users can only change their own passwords .
Design and implementation of this system is the main line of fixed asset management , completed the purchase of fixed assets from the use , maintenance and tracking loan repaid . While increasing the consumables management, providing management for the enterprise to purchase consumables . The system also provides statistical management module, the user can according to their needs statistics , but also can be exported to Excel table.
Users of the system altogether divided into three , namely, anonymous users , the average user and administrator user. Anonymous users can query specific equipment assets can expose data, such as device name , date of purchase , maintenance records, loan records and other information return . Ordinary users are those in charge of equipment management department , you can enter the system background check of each data can also be statistical queries, export data to Excel. Normal users do not have to add specific information , modify, and delete functions . Administrators are responsible for maintaining specific information , such as add, modify and delete information , is also responsible for regularly export asset data , and prints sent to the company leadership , leadership of the company in order to allow an accurate grasp of specific information on business equipment assets for future equipment purchases make the right decisions.#p#分页标题#e#
According to the results of system analysis , system design according to a structured approach, " enterprise asset management system" from the function can make the following division subsystem , 5-1 enterprise asset management system architecture is shown in Figure .
Systems developed the software development is not the end , because a reliable system must undergo rigorous testing .
( A ) the test is to find the program during program execution errors .
( 2 ) good test program is likely to find errors in the test program so far yet to find .
( 3 ) successful test is found wrong test so far not been found .
Correct understanding of the goal of testing is very important to determine the design of the test target test solutions . At the same time it should be recognized test procedures must not prove correct . After even after the most rigorous testing , there may still be wrong not to be found lurking in the program. Test procedures can identify errors , the program can not prove that there are no errors .
The test system using a variety of methods, the use of a unit testing , integration testing module , the system uses the system to complete the test . System testing using a black box testing .
During system testing , first verify the data integrity testing during entry , such as the input data can not be empty , digital input must be legitimate , the main code unique assets , such as adding a state selection . Subsequently tested modify, and delete functions. Find data inconsistencies , the modified procedures, re-commissioning , the system meets the requirements analysis functions. Export Excel sheet normal statistical module.
After several tests , modification, testing , system will eventually comply with the purpose of the design . Well done feature enterprise asset management system. But the test can not prove that the system is correct , so in the future operation of the system and found correct errors in a timely manner and do maintenance work.
In the development process of the system, the basic step by step in accordance with the requirements of software engineering to the implementation of the management information system based on B / S software systems have a more profound understanding of the accumulation of a certain amount of development experience, know that to achieve success enterprise asset management system design must do the following:
Enterprise asset management system is to achieve business equipment assets from the purchase, installation and maintenance of track, including equipment assets mainly in fixed assets, hence the fixed asset data is returned to its lending, maintenance and depreciation of the fundamental.
Establishment of enterprise asset management system is a progressive, dynamic process, system development to the times, in the analysis of the original model and enterprise device management objectives to be achieved on the basis of management information systems to fully understand. Establishment of the system is a continuous improvement, continuous improvement process.
Conclusion结论
This article is a lot of theoretical study, based on research done . First, the paper did a needs analysis , a clear need for enterprise asset management system to achieve the functions and objectives , and then created a database based on the needs analysis , then use JSP technology of the system , and finally through extensive testing to ensure the system meets the design objectives. Characteristics of the system are as follows:
With the rapid development of globalization, Chinese enterprises experiencing great challenges in direct competition with multinational companies . To win this challenge it is necessary to improve the overall competitiveness , and therefore change the management model to improve the management level, the implementation of information technology is undoubtedly the only way to achieve this purpose and wise. A successful business , not only to provide high quality products , but also have high work efficiency and control costs. In the information age , a sound management information system is to improve the efficiency of enterprises , the best way to reduce costs . Based on this , the development of the enterprise asset management system.
The system functions to achieve more, the most important is the device from procurement to installation , maintenance tracking. In their daily work by the user that the system administrator is responsible for specific services, such as adding new equipment , equipment maintenance schedules , weekly or monthly statistics generation equipment assets to provide services to the company decision-making . Secondly , the system and make full use of Ajax technology to achieve intelligent fuzzy query prompts queries, provide a good user experience. Finally , the system side using JavaScript and DOM techniques to achieve user-friendly tips when submitting the form.
In this paper, the use of JSP + MySQL enterprise asset management systems, enterprise asset management system includes asset management, software management , service management , report generation and so on. The device can achieve the basic asset information query, add , modify, delete . The system can greatly improve the efficiency of enterprise management , provide the basis for the daily operation and development decision-making enterprise . To maximize the satisfaction of enterprise characteristics and needs of each user .
( 1 ) Cross -platform : Java language has " compile once , run anywhere " feature , the system can easily be ported to different platforms or different versions of the same platform. Extends the Java J2EE standard cross-platform , developed system can not only across hardware , operating systems, you can also cross-application server software, which greatly reduces the difficulty of system development and maintenance .
( 2 ) practicality: the development of the system used in the enterprise , enterprise asset management solution to difficult problems and improve work efficiency.
( 3 ) using the MySQL open source database , reducing business input costs.
( 4 ) maintenance of good: the system uses the B / S architecture , the system upgrades, maintenance, only need to modify the server without changing the client to achieve the client's zero maintenance , reducing costs while improving efficiency.
References文献参考
[ 1 ] Zhang deep base . Intelligent Parking Management System [J]. Hunan Institute of Engineering .2003.13 ( 2 ) :14 -17 .
[ 2 ] Luo Xiaobin , Yin Guofu research of key technologies and implementation of intelligent charging system [J]. Computer Engineering .2003.29 ( 4 ) :137 -139
[3 ] Shiraki , sub- Yam smart parking - a gold industry [J] Communications Standardization .2003.1 ( 4 ) :60 -636 .
[4] M.Tamer Ojsu, Patrick Valduriez Principles of Distributed Datebase Systems (Second Edition) , Beijing: Tsinghua University Press, 2002 .
[ 5 ] ( the United States ) Ullman, JDFirst course in Database Systens [M], Tsinghua University Press .2006.7
[6 ] Cui Haiping parking information management is an important part of urban intelligent transportation - visit China Academy of Urban Planning and Design
Senior engineer Mr. Dong Suhua [J]. Intelligent building and city information .2006.110 ( 1 ) :7 -8
[ 7 ] Lee community home, the former Bonhams , Zhu Donghua , Liu Jianshun intelligent technologies and trends parking [J]. MATERIALS & APPLICATIONS .2002.30 ( 4 ) :41 -43 .
Study [ 8 ] Ding Yan, Zhao Yifan . Detection of moving targets [J]. Optical technology .2002 ( 7 ) :30- 312.
[9 ] Huang C # programming language advantage Analysis [J] Wuhan Jiaotong University Press : 2005.4 .
[ 10 ] More than cotton water, LI Shao-fa . Automatically locate and extract [J]. Computer Applications Research .2004.10:131-133 edge and SVM -based license plate .
[11] Ed Roman, Scott Ambler.Tyler Jewell.Mastering enterprise Javabeans [M]. NEW YORK.USA Published by John Wiley & Sons.Inc.2002.
[12 ] to the side in ASP.NET and C # Web database application [J] Anyang Teachers College Publication : 2001.2 .
[ 13 ] Huang Wei , Li Hongtao Chen Reed toll collection computer management system database design [J] Southeast University Publication year : 1998.3 .
[14] Scott Urman, Ron Hardman.Oracle Database 10G Pl / SQL Programming [M]. McGraw-Hill Osbome Media.2004.
[15] Steven Feuerstein.Oracle PL / SQL program design [M]. China Electric Power Press .2004 .
|