KR100689194B1 - Web screen change-over protection method application string data sender/receiver technic and architecture thereof - Google Patents

Abstract

The present invention prevents web screen switching by applying a string data transmission / reception method that can process an event without the occurrence of web page screen switching by separating the presentation page and the data query page from the web page and processing the screen. It is an object and an effect to provide a method and a structure thereof.

Web screen switching prevention method using the string data transmission and reception method according to the present invention can be viewed, modified and deleted to which the ActiveX grid component is applied and the data result processed by the ActiveX grid component An inquiry screen for reading and displaying the displayed key and storing the start key value and the last key value of the displayed data in a memory; a registration screen for registering a multi-database; an inquiry button for querying data; and storing in the memory. Next button to read and execute one start key value and last key value to erase previously displayed data or to continue adding data to the previous data position for display, and to store start key value and last key value of newly read data in the memory. Multi- and collectively register, modify, delete Presentation page screen to automatically query or postprocessing including the refresh button on a grid that reflects the component steps of providing via a Web browser; Configuring condition data generated by any one of a button processing event and a scroll bar processing event on the presentation page screen as string data and transmitting the string data to a data query page through a web server; And analyzing the condition data received from the data query page and constructing the processed data result into string data and transmitting the generated string data to the presentation page.

Description

Web screen switching prevention method using string data transmission method and its structure {WEB SCREEN CHANGE-OVER PROTECTION METHOD APPLICATION STRING DATA SENDER / RECEIVER TECHNIC AND ARCHITECTURE THEREOF}

1 is a system infrastructure diagram for explaining a business logic processing method according to the prior art

2 is a structural diagram showing a web screen switching prevention structure applying the string data transmission and reception method according to the present invention

3 is an operation block diagram of a web page and server DAO module

4A is a structural diagram of string data

4B is a client side data set component memory table configuration diagram

Figure 4c is a client-side corresponding index memory table data structure diagram

5 is a flowchart illustrating a web screen switching prevention method using a string data transmission / reception scheme according to the present invention.

6 is a module structure diagram of a detailed DB (DataBase) manager module 80 according to the present invention

7 is a screen of a presentation web page according to the present invention, showing an inquiry / registration / modification / deletion processing screen to which an ActiveX component is applied.

Explanation of symbols on the main parts of the drawings

10: web browser

20: presentation page

30: web server

40: middleware

50: Database Server

60: data quarry page

70: DAO (Data Access Object) Manager Module

80: DB (DataBase) Manager Module

The present invention relates to a web screen switching prevention method and a structure by applying a string data transmission / reception scheme, and in particular, by allowing only data to be refreshed without reloading a web page. The present invention relates to a web screen switching prevention method and a structure using a string data transmission / reception scheme capable of processing an event without the occurrence of a screen switching.

With the rapid development of the Internet culture, customers want to receive various information and services from companies, and companies have been able to develop applications that are implemented as client servers accordingly. We are trying to provide a variety of information to our customers by switching to the environment. To this end, companies are trying to develop programs that can be applied to the web environment with the application screen interface developed by the customer server.

1 is a system-based structure diagram for explaining a business logic processing method according to the prior art, a web browser (1), a presentation page (2), a web server (3) , Middleware (4), DB (DataBase) server (5).

Here, the web browser 1 is a program that enables users to navigate the web. The web browser 1 can read a hypertext markup language (HTML) document, which is a standard document of the web, and has a uniform resource locator. Access to the web server 3 using a common gateway interface (CGI).

The presentation page 2 is a page for providing a presentation, which is loaded through the web browser 1.

The web server 3 is software used to build an environment capable of providing a web service, and includes HTML, JavaScript, JSP (extension name), Java (JAVA), and image (IMAGE). , CAB (Extension Name) files, and so on.

The middleware 4 is software for connecting applications that are separated from each other. The middleware 4 allows a user to make a request for a database using a form of the web browser 1 so that the user Allows the web server 3 to return a dynamic web page in accordance with the needs and profile of. In addition, the middleware 4 has a connection with WebLogic, EJB and other DB.

The DB server 5 creates, manages and stores related DB tables.

Hereinafter, the operation of the system by the above configuration will be described in more detail.

An end user loads the presentation page 2 via the web browser 1. In the presentation page 2, various components and controls are applied, and when the end user generates an event on the screen, an action or a task is processed.

The presentation page 2 of the existing web method is responsible for designing various components and controls, and querying and displaying data. Here, the web server (3) is to put the processing to put the HTML, JavaScript (JavaScript), image (IMAGE), Java (JAVA), cab (CAB) in order to reduce the load of the server, the DB server (5) Store related DB tables.

The existing screen processing method is composed of processing flow provided in HTML, JAVA, JavaScript, and ASP. This processing flow calls the presentation page (2) on the web server (3) to get the next data when an event occurs on the screen (in which case a screen transition occurs), and then restarts the web page. It is processed by reading and reloading.

Since then, with the development of technology, the web screen interface is being changed little by little while applying a component made using the COM (extension name) function provided by MS to the web.

The conventional screen processing method using the component is processed in the same processing flow method as the existing method without departing from the limitations of the existing script language. In other words, a component can process a data processing event on a client server application screen to retrieve data from the server and display only the data on the screen without switching the screen. It was impossible. Therefore, the conventional web structure processing method has a limitation in solving this problem.

Since the script language is read and analyzed by the web browser parser, it is forced to reload when an event occurs. However, the solution can be solved by applying a component compiled as a binary. Even today, companies are applying components while converting business programs to the web (though they are only compatible with the scripting language and only highlighting the GUI function of the component).

As such, the conventional web page data processing processing method generates the next data from the web server when an event (for example, an event generated when a button or scroll bar or other event is generated to retrieve the next data) is generated. Since the page is called and the page is reloaded and displayed to retrieve the screen, the screen is switched.

Accordingly, the present invention has been made to solve the above problems, and an object of the present invention is to separate a presentation page (control design portion) and a data query page (data processing processor portion) from a web page so that the screen configuration and data processing are possible. In addition, the present invention provides a method and structure for preventing a web screen switching by applying a string data transmission / reception scheme that can process an event without the occurrence of a web page screen switching.

In addition, another object of the present invention is to pass the data condition to the data query page in a string method when generating an event to process the data in the presentation page, and the processed data back to the presentation page in a string method. A method of preventing web screen switching by applying a string data transmission / reception scheme that can process an event without the occurrence of web page screen switching by allowing only data to be refreshed without reloading the web page. To provide structure.

In addition, another object of the present invention is to register, modify, delete, inquiries in the existing web screen as a single event such as 4GL, but it is not possible to handle business in a batch, presentation page, data query page and string transmission method and DB manager The present invention provides a web screen switching prevention method and structure by applying a string data transmission / reception method that can be processed as a single event using a module.                         

In addition, another object of the present invention is to provide a business module made of Java in order to facilitate the process flow process Web by applying a string data transmission and reception method that can increase the efficiency of business development and provide an interface of the customer's business perspective The present invention provides a method and a structure for preventing screen switching.

Web screen switching prevention method using the string data transmission and reception method according to the present invention for achieving the above object, it is possible to query, modify and delete the ActiveX grid component (App) is applied by the ActiveX grid component An inquiry button for reading and displaying the processed data result, storing an entry key value and an end key value of the displayed data in a memory; a registration screen for registering a multi-database; Read and execute the start key value and the last key value stored in the memory to erase the previously displayed data or continue to add data to the previous data position and display the start key value and the last key value of the newly read data. Next button to save in, multi-register, modify, delete And providing, via a web browser, a presentation page screen including a reflection button for processing in a batch or automatically inquiring after processing and refreshing the grid component. Configuring condition data generated by any one of a button processing event and a scroll bar processing event on the presentation page screen as string data and transmitting the string data to a data query page through a web server; And analyzing the condition data received from the data query page, constructing the processed data result into string data and transmitting the string data to the presentation page.

delete

delete

delete

delete

delete

The inquiry screen is configured to be inquired, changed, and deleted with any one of a check box and a radio button, and is configured to enable full inquiry or split inquiry of data.

The scroll bar processing event is a data processing event occurs when the scroll bar is positioned at the start position and the end position, and after the inquiry button processing, the start key value and the last key value stored in the memory by the inquiry button are processed. Read and execute the result of processing in the database to erase the old data displayed in the ActiveX grid component and display N new data in its place or continue to add the data in the previous data position displayed in the ActiveX grid component. And display the start key value and the last key value of the data read by N pieces in the memory.

delete

delete

delete

The string data includes a header portion and a body portion, the header portion includes n digits and includes data information, the body portion includes condition data and processing result data information, and a separator between the string data is a token. It is characterized by transmitting and receiving a distinction.

The string data may be automatically generated by a static SQL statement or a dynamic SQL statement according to the delimiter.

The data information includes a memory table index position, a corresponding memory table record number, and a corresponding memory table field number information.

Web screen switching prevention structure applying the string data transmission and reception method according to the present invention for achieving the above object,

A web browser for parsing and loading web pages and executing script languages;

A presentation page in which various controls provided by a component and the web are designed, generating an event for data processing, and calling a data query page upon occurrence of the event;

A data query page for receiving a data condition from the presentation page in a string manner by the occurrence of the event and transmitting the processed data result to the presentation page in a string manner;

A web server calling the presentation page by the web browser, the web server including a middleware, a data access object (DAO) manager module, and a DB (DataBase) manager module; And

Characterized in that it comprises a database (DB) server for creating, managing and storing database tables.

The DB manager module is in charge of connecting to, disconnecting from, and querying the DB server, and dynamically inserts, deletes, updates, and selects SQL statements in a dynamic manner. It is characterized by creating and executing (Structured Query Language) statement.

The data query page is configured as an i-frame.

Hereinafter, with reference to the accompanying drawings will be described in detail an embodiment of the present invention.

2 is a structural diagram showing a web screen switching prevention structure applying a string data transmission / reception scheme according to the present invention, which includes a web browser 10, a presentation page 20, and a web server. (30), middleware (40), DB (DataBase) server (50), data query page (60), DAO (Data Access Object) manager module 70, DB (DataBase) manager Module 80 is configured.

Here, the web browser 10 is a program that allows you to move around the web, and executes a script language. The web browser 10 may read a hypertext markup language (HTML) document, which is a standard document of the web, and may be accessed through a uniform resource locator (URL), and a common gateway (CGI). A common path interface may be used to communicate with the web server 30. The web browser 10 on the customer side is responsible for parsing and loading web pages.

The presentation page 20 is a page in charge of component design and control design provided by a general web, and is in charge of web page control design and event processing. The presentation page 20 is loaded through the web browser 10. In addition, the presentation page 20 transmits data conditions to the data query page 60 in a string manner when an event is generated for data processing, and processes the data from the data query page 60. Is received by the string method.

The web server 30 is a software used to build an environment that can provide a web service, HTML, JavaScript, JSP (extension name), Java (JAVA), image (IMAGE), cap ( Service files such as CAB (extension name).

The middleware 40 is software for facilitating DB access and managing web service traffic. The middleware 40 allows a user to request a database (DB) using a form of the web browser 10. To allow the web server 30 to return a dynamic web page according to the user's needs and profile. The middleware 40 has a connection with other DBs such as web logic, EJB, and the like.

The DB server 50 creates, manages and stores related DB tables.

The data query page 60 is a page that calls a DAO (Data Access Object) Java object and is responsible for transmitting string data. The data query page 60 is a page configured as an I-frame for dedicated data processing. . The data query page 60 receives a data condition from the presentation page 20 in a string manner, and transmits the processed data back to the presentation page 20 in a string manner.

The DAO manager module 70 analyzes all business process query conditions to call the DB manager module 80 and is in charge of corresponding business processing.

The DB manager module 80 is responsible for connecting to, disconnecting from, and querying the DB server, and dynamically inserts, deletes, updates, and selects query statements. ) Create and execute a Structured Query Language (SQL) statement.

3 is an operation block diagram of a web page and server DAO module.

2 and 3, the web browser 10 calls the presentation page 20 through the web server 30. The presentation page 20 is designed with various controls and components. An event is generated for data processing on the presentation page 20. This event calls the data query page 60 composed of an I-Frame. The presentation page 20 transmits condition data to the data query page 60 and calls the DAO manager module 70.

The DAO manager module 70 checks the condition data header (S / C / U / D) to determine whether it is inquiry (S), registration (C), modification (U), or deletion (D). Call 72). It just serves as a branch.

The DAO module 72 calls the DB manager module 80 after processing the business logic. In this case, the DB server 50 allows operation information DB connection, termination, execution, and query (quarry).

The processed data result data is stored in the hash table memory area.

In addition, the data processing result is returned to the DAO manager module 70 and sent to the data query page 60 composed of an I-Frame. In the data query page 60, the data page is sent to the presentation page 20 and parsed by the data set component to make a client-side table memory area for use in various components.

Data transmission between web pages is carried out in a string structure, including filter delimiters. The structure of string data is made as shown in FIG. 4A.

As shown in FIG. 4A, assuming that the structure of the string data is composed of 1 | 5 | 3 | data1 | data2 | data3 | data4 | ...... The first three digits (or more than one character) of the header contain data information, and the rest of the headers are used for data insertion. In other words,

The first digit ('1') is the number of memory table indexes, the second digit ('5') is the number of records, the third digit ('3') is the number of fields, and the remaining digits are represented by the data structure.

4B is a schematic diagram of a client-side data set component memory table.

The table memory on the client side uses the functions provided by the data set component to create a table memory where data can be set by setting parameter values. The table manages each positional information by an index.

4C is a client side data set component table memory data structure diagram.

The table memory data analyzes a string data header to obtain a table position, a record number, and a field number to form table memory data.

The data transmitted in this manner is used by the client-side data set component to construct and use memory data by parsing string structure data as shown in FIG. 4A.

5 is a flowchart illustrating a web screen switching prevention method using the string data transmission / reception scheme according to the present invention.

Referring to FIG. 5, the end user executes the web browser 10 to call the inquiry, registration, modification, and deletion processing screen (see FIG. 7) to which the grid component is applied (steps S10-S12).

Next, the screen of the presentation page 20 is applied to the ActiveX grid component and divided into a portion Z1 for inquiring, modifying and deleting, and a portion Z3 for registering. The processing is performed by a general inquiry button Z4 and next button. And a reflection button Z5 for collectively performing registration, correction and deletion (step S14).

Next, it is determined whether a data processing event has occurred in the presentation page 20 screen (step S16). That is, whether the inquiry button Z4 event or the reflection button Z5 event (registration (C), modification (U), deletion (D) can be processed collectively) has occurred or is a double-click (Z7) event on the grid component, or Determines whether a scroll bar (Z6) event has occurred or not. At this time, if a data processing event has occurred, go to the next step (S18), and if the event has not occurred, returns to the previous step (S14).

Next, if a data processing event occurs when the screen of the presentation page 20 is generated, the condition data is generated, and the data query page 60 is called through the web server 30 to transmit the condition data in a string manner. (Steps S18-S20). For reference, as described above, the data query page 60 is configured as an I-frame, and is hidden so that the data query page 60 can be called as an event in the presentation page 20.

The data query page 60 then analyzes the received condition data (step S24).

Then, the DAO manager module 70 analyzes the condition data and calls each corresponding DAO branch (step S26). In this case, the DAO module 72 is called, and the condition data is parsed into string data to create a hash memory. The business logic is analyzed, interpreted and processed. In addition, as shown in Fig. 4, the executed data result is data structured.

Then, DB connection, disconnection, and query are performed (step S28). In this case, the DB manager module 80 is called, and accesses and executes the database DB (step S30) for general inquiry (S), registration (C), modification (U), and deletion (D) processing. .

In this case, in order to enable batch processing, the query (S), registration (C), modification (U), and deletion (D) processing are performed in one function call. For reference, in FIG. 7, the inquiry (S), registration (C), correction (U), and deletion (D) processes are generated and processed at one time by clicking on the inquiry button Z4 and the reflection button Z5.

6 is a module structure diagram of the DB (DataBase) manager module 80 according to the present invention.

The DB manager module 80 generates a SQL statement to dynamically register, modify, and delete one of the reflected button Z5 events on the screen shown in FIG. The presentation page 20 represents a granular module structure in which only data is refreshed.

The DB manager module 80 is an object that receives and configures the hash table created in steps S24 to S26 of FIG. 5 and executes a DB connection / dynamic SQL statement execution and query. On the screen shown in Fig. 7, a reflection button Z5 event is executed to collectively perform registration, correction, and correction.

The hash table 101 analyzes the condition data to form a hash table composed of a key and data. At this time, the key is composed of inquiry (C), registration (C), modification (U), deletion (D), and the data (Data) is composed of query condition data.

Another hash table 102 accesses the database 110 and reads table information (field, type, length, etc.) to form a hash table. In this case, the key is composed of an index, and the data is composed of field, type, and length information and used to create a dynamic SQL statement.

When the hash table is finished, the hash table 101 is looped to register (C), modify (U), and delete (D) to read the hash table 102 to read dynamic SQL statements (register, modify, delete SQL). Statement) to reflect the DB 110, remove the hash table 102 and access DB 110 again to read the operator information table to create the hash table 102 until the end of the loop. When finished, it makes the query SQL statement dynamically and returns the processing result.

Finally, the processed data is converted into a string structure and returned to the data query page 60.

The data query page 60 transmits data to the presentation page 20 in a string manner, and the presentation page 20 configures a table memory by analyzing and parsing the received string data in a data set component. Process.

In addition, all events (button events, double click events, scrub bar events, etc.), that is, data processing related events, are processed in the procedure of the business processing flow of FIG. 5, and all components perform string data transmission in the data query page 60. The presentation page 20 is processed without page reloading because the table memory created by the client-side data set is accessed and the data is refreshed and processed in the corresponding area.

FIG. 7 is a presentation page 20 screen showing an inquiry / registration / modification / deletion process screen to which a grid component is applied.

Based on the data described with reference to FIGS. 2, 3, and 4, the screen illustrated in FIG. 7 is created using a data set / grid component.

The screen structure of the presentation page 20 will now be described with reference to FIG. 7.

The screen of the presentation page 20 is divided into a portion Z1 for inquiring, modifying and deleting by applying an ActiveX grid component and a portion Z3 for registering, and processing is performed by a general inquiry button Z4, next button and registration. , Reflect button (Z5) for executing modification, deletion all at once

In the figure, Z2 is an ActiveX grid component applied to a tab control. When Z2 clicks on a tab control, only the modified data is displayed without a screen change.

The registering portion Z3 is configured to enable multi-input by applying an ActiveX grid component.

The inquiry button Z4 displays and refreshes data in the grid by clicking.

The registration button (C), correction (U), and deletion (D) is reflected in the DB by multi / batch operation by the reflect button (Z5) click event, and when the result processing is completed, the data data is refreshed in the web page again ( reflash). We solved the problem which was mostly impossible in web and only in client server application.

And the scroll bar (Z6) event refreshes the scattered data if there is data to be read when the next component is retrieved from the presentation page and the next data is retrieved when the grid component moves to the last position of the scroll bar or when moving to the top position of the scroll bar. A grid row is created next to the data that is reflashed or scattered so that the data is subsequently displayed. Currently this is possible in client-server applications but not on the Web. Application of the present invention can compensate for the shortcomings of the web, and has the features to enable the screen interface and business processing such as 4GL.

Finally, the configuration presentation page, data query page, data string send / receive method, string parser, event (button event, mouse event, double click event, etc.) processing configuration should be configured, but ActiveX component application business logic processing and display A switch prevention method can be realized.

Preferred embodiments of the present invention as described above are disclosed for purposes of illustration, and those skilled in the art will be able to make various modifications, modifications, additions, etc. within the spirit and scope of the present invention, such modifications and the like belong to the following claims You will have to look.

As described above, according to the web screen switching prevention method and the structure by applying the string data transmission and reception method according to the present invention, a 4GL level screen configuration is possible using an optimal web GUI component, component server based While various user interfaces (UIs) are provided for 4GL applications in the world, the existing methods handled when modifying data and requesting next data are to reload JSP pages from web servers and reload web pages. On the other hand, the method of the present invention divides the presentation page (JSP) and the data query page (JSP) and processes them so that only the data query page is called from the web server while the presentation page designed with the actual control remains intact. Modified parts and batched data because they are processed using string method By passing the data to the component, the component's own function allows the data to be parsed and refreshed so that the data can be refreshed on its own without changing the web page.

In addition, since the web can be processed without switching the screen, it is possible to freely implement and process the inquiry and CUD (registration / modification / deletion) based screen composition like a client server-based 4GL application by applying the component. In other words, the CUD (Registration / Modification / Delete) business logic is processed as a reflected button event, and the result is re-inquired so that only the data is refreshed, and the scroll bar event processing and the next button event processing are performed. Inquire the data to be refreshed or to be displayed from the scattered data. Currently, it is hard to accept complex interfaces and processing methods on the web screen in the client server application screen. However, the present invention can solve the shortcomings of the web, and it is a big feature that the web has made possible the method that is currently only available in 4GL.

In addition, it is possible to implement 4GL application level screens to satisfy various interfaces of customers, while the application screens developed as client servers can be implemented on the web in the same way, and the business logic (business level perspective) is maintained as it is. I can save it.

In addition, unlike web page reloading, the data is refreshed so that it can be processed much faster than the existing method.

In addition, the present invention is configured to separate the presentation page and the data query page on the Web using the ActiveX component to configure the screen and process the data so that only data is refreshed without web page reloading. It can be reflashed so that events can be handled without screen changeover, so that the speed can be improved, the convenience of customers and the expected effects of the work can be met, and the modules are common. This can shorten the effect.

Claims (12)

It is possible to inquire, modify and delete the ActiveX grid component and read and display the data result processed by the ActiveX grid component, and start key value and last key value of the displayed data. An inquiry screen for storing the data in a memory, a registration screen for registering a multi-database, an inquiry button for inquiring data, a start key value and a last key value stored in the memory for reading and executing to erase the previously displayed data. Or continue to add data to the previous data position, display the next key for storing the start key value and the last key value of the newly read data in the memory, and process the registration, modification and deletion in multi and batch or after processing. Includes a reflect button that automatically refreshes and refreshes grid components The method comprising: providing a presentation page, the screen via a Web browser; Configuring condition data generated by any one of a button processing event and a scroll bar processing event on the presentation page screen as string data and transmitting the string data to a data query page through a web server; And And analyzing the condition data received from the data query page and constructing the processed data result as string data and transmitting the result to the presentation page. Way. The method of claim 1, The inquiry screen is configured to be able to inquire, change and delete by any one of a check box and a radio button, but prevents switching of the web screen to which the string data transmission / reception method is applied, which is configured to enable full inquiry or split inquiry of data. Way. delete delete delete The method of claim 1, wherein the scroll bar processing event, When the scroll bar is positioned at the start position and the end position, a data processing event occurs. After the inquiry button is processed, the inquiry key reads the start key value and the last key value stored in the memory and executes the process in the database to delete the old data displayed in the ActiveX grid component and to store N new data in its place. Display or continue to add data to the previous data position displayed in the ActiveX grid component, A method of preventing web screen switching using a method of transmitting / receiving a string data, characterized by storing the start key value and the last key value of N read data in memory. The method of claim 1, The string data is composed of a header portion and a body portion, The header portion is composed of n digits and has data information. The body portion has condition data and processing result data information, Separator between the string data is divided into a token (token) to transmit and receive a web screen switching method applying a string data transmission method, characterized in that the transmission. The method of claim 7, wherein the string data, Method for preventing a web screen switching to a string data transmission and reception method, characterized in that automatically generated by a static SQL statement or a dynamic SQL statement according to the delimiter. The method of claim 7, wherein the data information, A method of preventing web screen switching using a string data transceiving method comprising information on a memory table index position, a corresponding memory table record number, and a corresponding memory table field number information. A web browser for parsing and loading web pages and executing script languages; A presentation page in which various controls provided by a component and the web are designed, generating an event for data processing, and calling a data query page upon occurrence of the event; A data query page for receiving a data condition from the presentation page in a string manner by the occurrence of the event and transmitting the processed data result to the presentation page in a string manner; A web server calling the presentation page by the web browser, the web server including a middleware, a data access object (DAO) manager module, and a DB (DataBase) manager module; And Web screen switching prevention structure applying a string data transmission and reception method characterized in that it comprises a database (DB) server for creating, managing and storing database tables. The method of claim 10, The DB manager module is in charge of connecting to, disconnecting from, and querying the DB server, and dynamically inserts, deletes, updates, and selects SQL statements in a dynamic manner. A web screen switching prevention structure applying a string data transmission / reception scheme, characterized by creating and executing a structured query language (Structured Query Language) statement. The method of claim 10, The data query page is a web screen switching prevention structure applying a string data transmission and reception method, characterized in that consisting of an I-Frame (I-Frame).

Images