KR100370753B1 - Generating Method of pages related database and executed in the server - Google Patents

Abstract

The present invention relates to a method for generating a database-linked page executed in a server, comprising: a database generation module (S100) for tables, fields, and components; a screen configuration module (S200) for generating a standard screen for presentation to a client; A code conversion module (S300) for coding a standard screen generated by the screen configuration module and a site generation module (S400) for generating a work site of each client on the server by reconfiguring the screen according to selection information from the client. The program developer can easily program through WYSIWYG (What You See Is What You Get) method to provide standard screen and unified source code, and the contents necessary for client's own work by simple selection of client. You can create a database linked page that runs on your server, The program development time can be shortened, the program development cost can be reduced, and the client's needs can be flexibly accommodated to accommodate the needs of various customers.

Description

Generating method of pages related database and executed in the server}

The present invention relates to a method for generating a database-linked page that runs on a server, in particular, which is executed in a server that is executed in a server and transmitted to a web browser of a client computer when a request is received from a web browser of a client computer. It relates to how to create a database-linked page that runs on a server that processes a possible database.

The program running on the server emerged to solve the server overload caused by the existing server concentration by dividing the roles appropriately between the server and the client computer. The client side has a user logic that is in charge of the user interface. Having a data logic that stores a database, the business logic that actually implements a task is to have it separated either on the client side, on the server side, or on another remote server.

In the conventional database management method, first, each company has a method of implementing a task with a database management program.

In this case, since each company has an independent database management program, the service provider that provides it has to implement a different program for each company, which requires a lot of time and manpower. there was.

Second, there was a method of implementing a task by providing a separate database management program for each company through a database program running on the server.

This method also requires a lot of time and money by implementing a different program for each company as in the above method, there was a problem that it is not easy to maintain and repair.

Third, there was a method of implementing a task by providing a database manager that each company can use commonly through the database program model that runs on the server.

However, in this case, although all companies use the same program, the time and cost of investing in the development of the program is reduced, but the program is almost impossible to change, so it is difficult to flexibly respond to the business requirements of each company. There was this.

Therefore, the company's various applications are installed in the data centers of IT (Information Technologe) and Internet service companies, not in the computing environment of each company, and companies can access the data centers via the Internet to freely use the necessary applications. A database that runs on a new model of server that can respond flexibly to the requirements of each company in outsourcing web-based applications by a software leasing service provider (ASP). There has been a need to provide a method for creating a linked page.

The present invention has been invented by the necessity as described above, and an object thereof is to provide a database-linked page generation method that is executed on a server that can flexibly cope with a client's request.

Still another object of the present invention is to provide a method for creating a database-linked page that runs on a server that can provide a development environment for a WYSIWYG (What You See Is What You Get) easy program. .

Still another object of the present invention is to provide a method for generating a database-linked page that is executed on a server capable of constructing a screen desired by the client by a simple selection of the client.

1A is a schematic diagram of a first embodiment of a program model executed on a server

1B is a schematic diagram of a second embodiment of a program model executed on a server

1C is a schematic diagram of a third embodiment of a program model executed on a server

2A to 2D are flowcharts of one embodiment of a method for generating a database interlocking page executed in a server according to the present invention.

3 is a screen example of searching for a field generated by the field database creation step;

4A illustrates an example of displaying a registered table on a screen

4B illustrates an example of displaying a field included in a table on a screen.

5 illustrates an example of displaying a component on a screen

6 illustrates an example of displaying a field variation on a screen.

7 is an example of outputting a table on the screen

8 is an example of contents of a file converted by transcoding

According to an aspect of the method for generating a database interlocking page executed in a server according to the present invention for achieving the above object, the method for generating a database interlocking page executed in a server according to the present invention is executed in a server. A database linked page generation method for processing a database, the method comprising: registering a data type to be used in an object (S110); Creating a field database by defining at least one field object derived during work analysis (S120); Create at least one table using the fields defined by step S120, define an index for each table, and store the table according to the defined index to create a table database. Generating (S130); Generating at least one component to be applied to the field and defining a property of each component to generate a component database (S140);

Outputting a list of tables and field details for each table (S210); Executing a table generation script by selecting a table from the list of tables output on the screen to generate a selected table and initializing the screen (S220); Registering a component to be used in a field of the generated table (S230); Generating at least one screen field by combining a predetermined component with each field constituting the table (S240); Standard screen configuration comprising the step (S250) of dragging the screen field generated by the step (S240) to a predetermined position on the screen table, and inserting an unspecified field not included in the database to form a standard screen (S250) With module S200:

Registering an event for executing the screen (S310); And a code conversion module S300 including a step of code conversion of the standard screen (S320).

According to an additional aspect of the method for generating a database interlocking page executed in the server according to the present invention, the method for generating a database interlocking page executed in the server according to the present invention generates a client-specific site on the server according to a request of the client. A site registration step (S410) of giving login information to the client; Receiving a work area from a client and presenting each standard screen for the corresponding work area generated by the code conversion module S300 (S420); Receiving input of use of each field from the standard screen from a client, and receiving a property change request (S430); The method may further include a site generation module S400 including changing the attributes requested by the step S430 and reconfiguring and sorting the screen using only selected fields.

According to an additional aspect of the method for generating a database-linked page executed in the server according to the present invention, the database generation module (S100) of the method for generating a database-linked page executed in the server according to the present invention includes fields, components, and tables. The method further comprises the step of updating the database by checking the change in the configuration details (S150).

According to an additional aspect of the method for generating a database-linked page executed in the server according to the present invention, the step of creating the table database of the method for generating a database-linked page executed in the server according to the present invention (S130) may include a table number. In this case, the table is registered by assigning a table name and selecting a field to be used in the registered table.

Hereinafter, the present invention will be described in detail with reference to the accompanying drawings so that those skilled in the art can easily understand and reproduce the present invention.

1A-1C are schematic diagrams of a program model executed on a server.

As shown in the figure, a program model that runs on a server is a client-server concept. The client side has a user logic that is in charge of the user interface, the server side has a data logic that stores a database, and the business logic that actually implements the business is shown in FIG. 1A. On the client side, as shown in FIG. 1B, or on the server side, or as shown in FIG.

That is, having a database on the server side, the client downloads a predetermined program from the server and manages its own database. At this time, the client loads the work logic through the client logic running on his client computer and performs the work, and the result of the performed work is stored in the server through the data logic of the server.

The present invention adopts a program model executed on the server, provides a standard screen of a program for database management from the server side to the client side, and selects the desired item from the client so as to select each client according to the selected contents. By reconfiguring the program separately, it is possible to respond flexibly to the needs of each client.

2A to 2D are flowcharts of one embodiment of a database-linked page generation method executed in a server according to the present invention.

The database interworking page generation method executed in the server according to the embodiment includes a database generation module (S100) for tables, fields, and components, a screen configuration module (S200) for generating a standard screen for presentation to a client, Code conversion module (S300) for coding the standard screen generated by the screen configuration module and a site generation module (S400) for generating a work site of each client on the server by reconfiguring the screen according to the selection information from the client Doing.

The database generation module S100 is as follows.

In the first step S110, a data type to be used in the object is registered.

This step S110 defines and registers a data type including a character or a number to be referred to by data to be used in a table or field object, a size, a maximum value, a minimum value, and an initial value for the data type.

For example, by defining the data type as CHAR, integer as INT, etc., various data types can be defined by referencing this data type.

In a second step (S120), at least one field object derived during work analysis is defined to create a field database.

This step (S120) analyzes the task to create a field database by defining Korean and English field names, data types, sizes, initial values, etc. for all possible task fields used in this task.

3 shows an example of a screen for searching a field generated by the step (S120), the English field description starting with 'c' on the left side of the screen, the English field 'cd_as_ioact' selected from the field description on the right side of the screen; It shows the defined contents of.

In a third step S130, at least one table is created using the fields defined by the step S120, an index for each table is defined, and the table is defined according to the defined index. Save and create a table database.

This step (S130) defines the table name, table number, the corresponding task, record length and the like to generate the information in the table, register the field corresponding to the task of each table in the table, and assign an index to each table.

4A is an example of displaying a registered table on a screen, and shows an index name, an English table name, a Korean table name, a corresponding task division, and the like from left to right.

That is, in this step S130, the table is registered by assigning a table number and a table name, and a field is selected by selecting a field to be used in the registered table.

FIG. 4B illustrates an example of displaying a field included in a table on a screen. In the right side of the screen, FIG. 4B illustrates fields included in a table name 'INSAMS'.

In a fourth step S140, at least one component is generated to be applied to a field, and a component database is created by defining properties of each component.

In this step (S140), a component name and attributes of each component are defined for the component to be applied to the field.

5 illustrates an example of displaying a component on a screen. The left side of the screen displays a component type, and the right side of the screen displays a property of a component whose component name is 'EGenComboBox' among the components on the left side of the screen.

In an additional step S150, the database is updated by checking for changes in the field, component, and table configuration details.

FIG. 6 shows an example of displaying a field variation on a screen, and shows that two fields were changed on March 16, 2001, and one field was added and deleted.

Therefore, the database creation module (S100) described above generates a table, a field constituting the table, and a component applied to the field to make a database so that a program developer can easily use the database.

The screen configuration module S200 is as follows.

In the first step S210, the table list generated by the database generation module S100 and the field details of each table are displayed on the screen.

This step (S210) provides the program developer with a list of tables implemented as a database and configuration fields of each table to facilitate program development.

7 illustrates an example in which a table is output on a screen. A table resource, which is a work area to which a corresponding table belongs, is displayed on a left side, and a table item related to a selected 'computer operation' is displayed on the right side of the table resource.

In the second step (S220), by selecting a table from the table list displayed on the screen, a table creation script is executed to generate the selected table to initialize the screen.

That is, in this step, when the program developer selects a desired table item on the screen output by the step S210, a table generation script for automatically generating a table is executed to display the selected table on the screen.

In a third step S230, a component to be used in a field of the generated table is registered.

In other words, this step (S230) loads and registers a component to be used in a field of the corresponding table in the component database generated by the database generation module (S100).

In a fourth step S240, at least one screen field is generated by combining a predetermined component with each field constituting the table.

That is, this step (S240) combines the components registered in the step (S230) to each field to generate a field screen combined with the components.

In a fifth step S250, at least one or more screen fields generated by the step S240 are dragged and placed at predetermined positions on the screen table, and an unspecified field not included in the database is inserted to form a standard screen. .

That is, this step (S250) is a program developer checks the screen with the eyes of the field in which the components are coupled to the table in the WYSIWYG method and arrange the field, the keyboard not generated by the database generation module (S100) keyboard Insert through an input means such as to generate a standard screen provided to the client.

Accordingly, the standard screen configuration module S200 facilitates program development by adopting a WYSIWYG method in generating a standard screen generated by a program developer.

The code conversion module (S300) is as follows.

In the first step (S310) it is registered the event that the screen is executed.

Since a program executed in the Windows environment performs an operation set to the corresponding event according to the generated event, the corresponding screen is displayed when the corresponding event occurs by setting an event to execute the screen.

In a second step S320, the standard screen is code-converted.

This step (S320) converts the standard screen implemented by the developer in the standard screen configuration module (S200) into a code supporting the RMI (Remote Method Interface) method through a predetermined conversion program means.

The converting program means includes, for example, JAVA code, and the code inserted into the generated file is commonly inserted into all the files generated by the converting program means and the program developer through the configuration of the converting program. It includes code inserted differently according to the standard screen configured by the code and code inserted by the input of the program developer.

8 shows an example of the contents of the file converted by the step (S310), and the technique related to the code conversion is already known in the art before this application in various ways and is a part that deviates from the gist of the present invention. Detailed description will be omitted.

Therefore, the code conversion module S300 converts the standard screen implemented by the standard screen configuration module S200 to be executable on the web through a network.

The site generation module (S400) is as follows.

In the first step S410, a client's own work site is created on the server according to the client's request, and the site is registered by giving login information to the client.

That is, in this step (S410) to give the client a login account to have its own data logic for each client on the server to be able to store the database managed by the client.

In the second step (S420) receives the work area from the client and presents each standard screen for the corresponding work area generated by the code conversion module (S300).

That is, this step (S420) provides a standard screen generated by the standard screen configuration module (S200) to the screen of the client computer.

In the third step (S430), whether or not to use each field from the standard screen from the client receives the property change request.

That is, in this step, it is possible to flexibly cope with the client's request by selecting a field suitable for the client's work environment by selecting a field to be used for each client in the standard screen.

In the fourth step S440, the property requested by the step S430 is changed, and the screen is reorganized and aligned using only the selected field.

That is, in step S440, fields other than those selected by the client are deleted from the inside of the ASP file, and the file contents are changed to, for example, change attributes such as text color and background color to attributes desired by the client.

Therefore, the site generation module (S400) gives the client a login account to have its own data logic for each client on the server, and receives the content that the client wants to delete or change from the standard screen presented to the client By updating the screen to the client's desired screen, the client can create a screen suitable for the client's work environment.

As described above, the method for generating a database-linked page that is executed on the server according to the present invention provides a standard screen and a unified source code by easily programming a program developer through the WYSIWYG (What You See Is What You Get) method. And by selecting the client, the screen can be created with the contents necessary for the client's own work. Therefore, the program development time can be shortened, the program development cost can be reduced, and the client's needs can be flexibly responded. There is a useful effect such as to accommodate the needs of various customers.

Although the present invention has been described with reference to the accompanying drawings, it will be apparent to those skilled in the art that various modifications may be made therein without departing from the scope of the invention, which is covered by the following claims.

Claims (5)

In the database linked page generation method for processing a database (Database) executable in the server (Server), Registering a data type to be used in the object (S110); Creating a field database by defining at least one field object derived during work analysis (S120); Create at least one table using the fields defined by step S120, define an index for each table, and store the table according to the defined index to create a table database. Generating (S130); Generating at least one component to be applied to the field and defining a property of each component to generate a component database (S140); Database generation module (S100), including: Outputting a list of tables and field details for each table (S210); Executing a table generation script by selecting a table from the list of tables output on the screen to generate a selected table and initializing the screen (S220); Registering a component to be used in a field of the generated table (S230); Generating at least one screen field by combining a predetermined component with each field constituting the table (S240); Dragging the screen field generated by the step (S240), placing the screen field at a predetermined position on the screen table, and inserting an unspecified field not included in the database (S250); Standard screen configuration module (S200), including: Registering an event for executing the screen (S310); A code conversion module (S300) including code conversion of the standard screen (S320); Database interworking page generation method that runs on a server, characterized in that it comprises. The method of claim 1, To create a database linked page that runs on the server: A site registration step (S410) of generating a client-specific site on a server according to a client's request and giving login information to the client; Receiving a work area from a client and presenting each standard screen for the corresponding work area generated by the code conversion module S300 (S420); Receiving input of use of each field from the standard screen from a client, and receiving a property change request (S430); Changing the attributes requested by the step (S430), and reconfiguring and sorting the screen using only selected fields (S440); Method for generating a database linked page running on a server, characterized in that it further comprises a site generation module (S400) comprising. The method according to claim 1 or 2, The database generation module (S100): And updating (S150) the database by checking changes in fields, components, and table configuration details (S150). The method according to claim 1 or 2, Creating the table database (S130) is: A method for creating a database-linked page executed on a server, comprising: registering a table by assigning a table number and a table name, and selecting a field to be used in the registered table. The method of claim 3, wherein Creating the table database (S130) is: A method for creating a database-linked page executed on a server, comprising: registering a table by assigning a table number and a table name, and selecting a field to be used in the registered table.