Current location - Education and Training Encyclopedia - Graduation thesis - Requirements and feasible design scheme of office automation management system in enterprises
Requirements and feasible design scheme of office automation management system in enterprises
Demand analysis of OA office system

OA Office System Requirements Analysis 1

Chapter 1 Introduction 1

1.2 the work done in this paper

Chapter II System Development Technology 2

2.2 Spring technology 3

Chapter III System Analysis 6

3.2 System Analysis 7

3.2.3 My Desk Module 8

System management module 9

Chapter 4 Database Design 10

4. 1 chart 10

Chapter V System Implementation Process 13

Chapter VI System Testing and Operation 14

The first chapter is introduction.

1. 1 topic background

In normal office work, enterprises usually encounter a lot of resources and data, such as employee information, emails, application records, printers, computers and so on. These resources and data are usually messy in the case of poor management, and they don't know where to store them when needed, thus affecting work efficiency. Therefore, we designed a system that can meet this demand-enterprise Web OA system.

Through the "enterprise Web OA system" to manage the daily office of the enterprise, it meets the needs of all aspects of the daily office management of the enterprise, realizes the function of sending and receiving short messages between employees of the enterprise, and greatly facilitates the communication between employees of the enterprise.

1.2 the work done in this paper

In order to develop the system and ensure that the system can truly reach the standard of "applicability, sufficiency and ease of use", I will cooperate with the use of user units, consult relevant books and electronic documents, and consult my predecessors. In the process of development and design, the popular SSH framework integration, Jquery and Ajax technologies are adopted, and the database is connected through Hibernate, and some tools are used to optimize the system. In addition, in order to increase the practicability of the system and make it meet the actual application system and user requirements as much as possible, I have analyzed and compared the contents and functions of many similar systems, absorbed their advantages and learned some experience.

1.3 This article is arranged.

The whole design is divided into six chapters, and the main contents of each chapter are arranged as follows:

1. The introduction introduces the background, work and structure of this paper.

2. System development technology. This paper mainly introduces the main technologies used in this system.

3. System analysis. This paper mainly introduces the preliminary work before system development, including the feasibility analysis and the ideas and requirements of system design. Function, performance, efficiency and other indicators that should be achieved from the perspective of user needs and system.

4. Database design. In order to let software developers have a general understanding of software function division, data structure and business process, it will become the beginning of the whole development work.

5. System implementation. This paper mainly explains in detail how the project is realized and the interface display.

6. System testing and operation. This paper expounds the test method, test steps and test results.

Chapter II System Development Technology

2. 1 Jquery and JavaScript technology

JQuery is another excellent Javascrī pt and pt framework after prototype. Its purpose is-do more without writing, do more with less code. JQuery is a fast and concise javaScript library, which is convenient for users to handle HTML documents and events, realize animation effects, and provide AJAX interaction for websites. Almost all technologies owned by Ajax can be realized by using the omnipotent $ in Jquery technology.

On the one hand, Jquery is simple to use. This is a lightweight JS library. When using, you only need to import the compiled JS file. On the other hand, the view effect made by its UI plug-in is very ideal and easy to apply. JQuery can keep the code and html content of users' html pages separate, that is, you don't need to insert a bunch of js into html to call commands, just define the id.

2.2 spring technology

The core of Spring is a lightweight framework for constructing Java applications, which implements the container of Ioc mode. The core package is the most basic part of the framework, which provides dependency injection features, enabling you to manage Bean container functions; The context package provides a framework Bean access method (ApplicationContext.xml), and also adds the sending of text messages. The DAO package provides an abstraction layer for JDBC. It also provides methods to realize programming and declarative transaction management, not just to implement specific interfaces. An important MVC pattern in Spring: View comes from the client layer and usually uses jsp, that is, the page display part; The controller is also in the server layer, usually implemented by Servlet, that is, the logical part of page display; Model is in the middle layer, usually implemented by javabean on the server side, which is the business logic part. For some public methods, you can put them in a class.

2.3 JPA technology

JPA describes the mapping relationship between objects and relational tables through JDK 5.0 annotations or XML, and persists the entity objects at runtime into the database. You can carry out persistent development according to the basic semantics of Java.

2.4 Fire Workflow Plug-in

Fire Workflow is an open source plug-in in China, which is used for workflow design and deployment. Compared with several well-known workflow engines in the world, this framework has the advantages of simple structure and good expansibility! This plug-in, like Spring and JPA, is several common jar packages, which are embedded in the system to solve the problems in the workflow field.

Fire workflow is for developers and consists of four parts: model, engine, designer and process management. Its process designer is closely integrated with the mainstream IDE, and the plug-in in Eclipse allows developers to debug the process as simple as debugging basic java classes. The Fire workflow comes with seven tables. Because the system itself has a large number of data tables, compared with the 30 tables of the popular JPBM, the fire fighting workflow is extremely simple. In addition, another reason for choosing this plug-in is that the development of this plug-in is based on Spring files and is well integrated with this system.

2.5 Apache James mail server

Apache James is short for James and short for Java Apache Mail Enterprise Server. James is a 100% Java-based email server. It is an independent mail server, which provides a complete email solution for sending and receiving emails. The core of James server is a configuration file named config.xml. After the server is started for the first time, the system will automatically generate a config.xml file. The operation that the server will perform is based on this profile. When it loses connection with the external network, it can send and receive mail in the local area network. DNS in the configuration file can send and receive mail with the external network, but it will be regarded as spam by other servers to a great extent. Internal mail is best used in its own local area network.

2.6 Struts technology

Struts is an MVC framework based on J2EE platform, which is mainly realized by Servlet and JSP technology. It is an open source framework for developing Web applications. Struts integrates Servlet, JSP, custom tags and message resources into a unified framework, and developers do not need to code themselves to realize a full set of MVC patterns during development, which greatly saves time.

Struts is chosen as the controller of MVC in this system because it is mature enough and has a wide user base. Although it also has shortcomings, it is completely compensated by other software, such as replacing Titles with Sitemesh. WebWork is excellent, but it started late and its user base is too small. JSF and Tapestry are heavyweight MVC architectures. By comparing these two aspects, we can get two advantages of Struts, namely, large user base and lightweight.

2.7 JSP page technology

JSP came into being after Servlet, mainly to solve the problem of low efficiency in outputting HTML code in Servlet. JSP technology is relatively simple, similar to scripting languages such as ASP and PHP. JSP technology mainly consists of the following two parts:

The basic syntax of JSP: two comments, three script elements and eight action instructions.

JSP has nine built-in objects: request object, response object, page context page context object, session object, application object, output object, configuration object, page page object and exception object.

Chapter III System Analysis

3. 1 demand analysis

3. 1. 1 Introduction

The compilation of software requirements analysis is to make users and software developers have a common understanding of the initialization rules of software and make it the basis of the whole development work.

3. 1.2 Mission overview

Web version or LAN system, the application scope is government agencies, large, medium and small enterprises. Relevant personnel should have a certain understanding of computer operation and business.

3. 1.3 requirements

A. Provisions on performance: The number of terminals supported by the software is determined according to the number of users supported by the database; The parallel operation users supported by the software should be above 100.

B. Performance requirements: the speed should be fast, and for data records with small data volume, various operations and conversion transmission should be realized in a short time; When the business requirements change, the software should be able to adapt to these changes and keep the consistency of code and table data. Some environments or software or operating modes will not change.

C Input and output requirements: Input and output data must be given corresponding format type, numerical range and precision description.

D other special requirements: users are involved in company secrets and finance, and pay special attention to the confidentiality and security of data. At the same time, they have high requirements for the convenience, maintainability, complementarity, readability, reliability and the convertibility of the running environment of the software.

3.2 System analysis

3.2. 1 compilation process

The background function diagram is as follows:

The function diagram of the front desk is as follows:

3.2.2 User authentication module

The development and design of the system function is completely aimed at the office management within the company, providing a convenient electronic interaction platform for employees in various departments. User authentication module is one of the important parts of the company's office automation management system. Its main function is to authenticate system users when they enter the system and to authenticate when they browse different pages, so as to prevent the disclosure of important company information.

3.2.3 My Desktop Module

This module includes three sub-modules: department management, e-mail and personal data management. Mainly used for daily office needs, all users have this module.

Department management: it mainly includes the addition, deletion, inspection and modification of doors and windows.

E-mail: This part is mainly used to send and receive internal mail. When users can't connect to the external network, they can send and receive emails with attachments. At present, there is no requirement for attachments (adding or deleting messages).

Personal data management: used to modify your personal data (add, delete, check and modify users).

3.2.4 System management module

In this system, the administrator's authority is the biggest, which is also designed in consideration of the security of this system to prevent company secrets from leaking out. This module includes login authentication and system administrator management.

Administrator: the administrator who manages the system.

3.3 Data structure analysis

3.3. 1 logical structure

The name and identifier of each data structure used in this system, as well as the identification, definition and length of each data item, record, file and department between them, and the relationship between their levels or tables should be fully reflected.

3.3.2 Physical structure

The storage requirements, access methods, access units, access physical relationships (indexes, devices, storage areas), design considerations and confidentiality conditions of each data item in each data structure used in this system.

3.3.3 Remedial measures for errors

After the failure occurs, alternative measures can be taken, including:

(1) backup technology, when the original system data is lost, the system backup data can be used for recovery;

(2) Efficiency reduction technology, when there is not much lost data, you can re-enter the data by manual operation;

(3) When the database has errors due to unpredictable reasons such as abnormal shutdown or power failure, turn to the engineers of Oracle Company, which is not a supplier of Oracle database products and does not provide similar corresponding services;

(Oracle company or related engineers optimize the database;

(5) Optimize the network configuration.

Chapter IV Database Design

Database design is a very important link in project development and system design. What I want to emphasize here is the importance of database design, because database design is like building the foundation of a tall building. If the design is not good, it will cause big problems in the later system maintenance, change and function expansion, and even in the system development process.

4. 1 chart

4. 1. 1 my desk

(1) administrator table (tb_admin)

Whether the field type primary key foreign key can be null description.

Idint is not self-increasing.

Namevarchar cannot be an account.

Pwdvarchar can be encrypted.

UseFlagbit can

(2) Department Table (tb_department)

Whether the field type primary key foreign key can be null description.

Idint is not self-increasing.

Memovarchar can make a memo.

Namevarchar cannot be a department name.

UseFlagbit can

(3) Circular form (tb_handround)

Whether the field type primary key foreign key can be null description.

Idint is not self-increasing.

Contentlongtext content

CreatorIPvarchar canal

Send Time Date Time Available Time

Titlelongtext cannot be added with a title.

UseFlagbit can

User _ Id int cannot be a user Id.

(4) circulate the attachment table (tb_handround_attachment)

Whether the field type primary key foreign key can be null description.

Idint is not self-increasing.

Attachment name Long text can be attached with a name.

AttachmentRealNamelongtext Real attachment name

AttachmentYearvarchar can

Handround_ID does not cycle ID.

(5) Circulation Status Table (tb_handround_state)

Whether the field type primary key foreign key can be null description.

Idint is not self-increasing.

ComfirmDatedatetime can confirm the time

LeaveWordlongtext can

Send Time Date Time Cycle Time

StateFlagInt canal

Handround_ID does not cycle ID.

User _ ID int user ID

(6) User table (tb_userinfo)

Whether the field type primary key foreign key can be null description.

Idint is not self-increasing.

Namevarchar cannot be a user name.

Locatable

Non-negotiable time

RealNamevarchar cannot be a real name.

Use flag bit to cycle ID.

Department_ID user ID

Chapter V System Implementation Process

5. 1 development platform

Server: Weblogic 8.0

Database: MySQL5. 1

Platform technology: Jquery+Struts+Spring+JPA.

Operating system: Windows XP

5.2 System Framework

In the src directory, there are mainly packages at all levels, including some java classes. In the WebRoot directory, there are some JSP files to realize the page. At the same time, there are struts and spring configuration files in the WEB-INF package.

5.3 System implementation

5.3. 1 My Desktop Module

It is mainly used for daily office needs, sending and receiving emails, and is an essential function of the whole office system.

After the user successfully logs in to the page, clicking "My Desk" will list three functional blocks: department information, email address and personal information, and each block will be opened through hyperlinks, as shown below:

Department information: including all departments of the company.

E-mail: it is mainly used to send and receive emails in the system, and supports uploading and downloading attachments. It uses James server and pre-assigned internal email name to send and receive emails, as shown below:

Personal data: This block is mainly used for users to modify their own passwords.

Chapter VI System Testing and Operation

6. 1 system test

6. 1. 1 Configure the test environment

(1) Install JDK and bea, weblogic

(2) Run the whole project;

(3) Start weblogic. After logging in to http://localhost:80/OA/, you need to start the Apatche James server to manage mail reception.

(4) Publishing system, which is realized by Web application module.

(5) After the publication is successful, you can enter the login page.

6.2 Test results

The test results are displayed in the following interface:

(1) login page

(2) the main page

conclusion

The intense and pleasant graduation project is over, and I have worked hard to realize a system that combines the theory of computer and office automation and reflects the trend of the times.

This system only provides some basic functions, but it can't provide complete information of office automation requirements, which needs further investigation. All possible functions will continue to be analyzed, designed and gradually realized in the future work, making the system more perfect.

In the process of development, I developed a high-quality system with the idea of applying the theoretical knowledge I have learned to practice, conducted detailed research, carefully and patiently developed the design, and developed the system with a diligent and realistic attitude. Most importantly, through development and design, we have exercised our ability to analyze problems, make reasonable planning and analysis and design, and at the same time, we have greatly improved our ability to use development tools. We combine the theoretical knowledge we have learned with practical application, and our practical ability has been obviously improved.

Although there are still many problems to be solved and places to be improved in the office automation system, I believe that through our continuous efforts and continuous learning, there will be more perfect results to meet with you. All the knowledge learned in this development process will be a solid foundation for my future study and work. I hope to have such practical opportunities to exercise myself in the future.

The above is a model essay for your reference. I hope I can help you.