KR20020022407A - Method of generating a web site corporated with databases and program recording medium - Google Patents

Abstract

PURPOSE: A method for creating a database linked with a web site and a recording medium for storing the program thereof are provided to easily and rapidly construct a specialized data focused web site by make the web pages linked with a database generate easily and reduce the construction time for the web site. CONSTITUTION: The method comprises steps of registering the information of a pre-constructed database to a data manager(S10), creating a new database in order to use the database to be registered and extracting the information of pre-crated table(S20), creating the web pages linked with the corresponding database confronting to each web page after creating the web pages to be adapting the registered database(S30), and transmitting and publishing the created web page to a web server(S40). The database registering page is generated at the database registering step and includes a DBMS(Database Management System) display entry, an ODBC(Open DataBase Connectivity) selection entry, a server information input entry and a database information entry with respect to the database registering menu selection of the user.

Description

METHOOD OF GENERATING A WEB SITE CORPORATED WITH DATABASES AND PROGRAM RECORDING MEDIUM}

The present invention relates to a web site creation method. In particular, the present invention relates to a method for generating a database-linked website and a recording medium for recording a program for executing the same.

At present, with the rapid development of the Internet, the world wide web (hereinafter, referred to as web) technology is also being developed. In addition, all Internet technologies are being integrated around the web.

Typically, the web is written in hypertext markup language (HTML), and the web browser interprets the HTML to make it easier for Internet users to understand.

Therefore, in order to put information in cyberspace on the Internet, HTML writing is essential, and a program that helps to write such HTML easily and quickly is called a web editor.

HTML is a simple script-style language made up of tags that can be edited in a simple text editor such as Windows Notepad. The HTML editor is a text editor that adds handy features to make it easier to write HTML.

In general, you can edit HTML directly by coding it, and the preview function is provided so that you can check the HTML on the web.

Such HTML data includes hot dogs and ultra edits.

Unlike HTML editors like this, an editor that writes HTML in the same style as seen in a web browser is called a WYSIWYG (what you see is what you get) editor.

At present, it is this commonly used web editor. The most widely used web editor in the world is Microsoft's front page, and Namo Web Editor is the most widely used in Korea.

Recently, products such as applying dynamic HTML (DHTML) to make a more colorful homepage, or enhanced multimedia functions such as dreamwearver's flash have appeared.

However, there is a problem that such a web editor cannot build a web site using a database. This is because, in order to output the contents of the database on the web or to put the contents input from the web into the database, the common gateway interface (CGI) must be used instead of HTML.

Such CGI is very difficult to implement unless you are a professional programmer because you have to program in difficult 3rd generation languages such as C and Perl.

The present invention was created to solve such a problem, and an object of the present invention is to provide a database-linked web site generation method that can easily and quickly build a more professional data-driven Web site.

According to an aspect of the present invention for achieving the above object, a method comprising the steps of: a) registering information of a database built in advance;

b) creating a new table or extracting information of a previously created table to use the database to be registered;

c) generating web pages to which the table is to be applied, and then generating web pages linked with the database corresponding to each of the web pages; And

d) transmitting the web pages generated in step c) to a web server for publishing.

According to the present invention, it is possible to easily generate web pages linked with the database, it is possible to shorten the web site construction time to maximize the efficiency.

1 is a diagram illustrating a main screen for creating a web site interoperating with a database according to an embodiment of the present invention.

2 is a block diagram illustrating a method for creating a database-linked web site according to an embodiment of the present invention.

3 is an overall flowchart illustrating a method for creating a database-linked web site according to an embodiment of the present invention.

4 through 9 are diagrams for describing a process of registering a database and creating a table.

10 to 12 are diagrams for explaining a web page generation process.

13 to 21 are diagrams for describing a process of generating a web page linked to the database of FIG. 3.

22 to 24 are diagrams for describing a process of publishing web pages linked to a database.

<Explanation of symbols for main drawings>

10: database 20: data manager

30: Page Manager 40: Form Wizard

50: Publishing Manager 60: Web Servers

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

1 is a diagram illustrating a main screen for creating a web site interoperating with a database according to an embodiment of the present invention, and FIG. 2 is a block diagram illustrating a method for creating a web site interworking with a database according to an embodiment of the present invention. to be.

First, referring to FIG. 2, the data manager 20 is a program for registering and managing the database 10, and extracts the contents of a table previously built in the registered database 10 or creates a new table. Perform tasks like modifying, deleting, and deleting.

In the present embodiment, a method of generating a new table and a web page linked with the table data will be described.

The page manager 30 connected to the data manager 20 provides a function of generating a web page to which the table is applied or modifying or deleting a previously generated web page.

The form wizard 40 connected to the data manager 20 forms a new form on the web page generated by the page manager 30 to generate a web page linked with the registered database 10. to provide. That is, the form wizard 40 generates logic to interwork with a database.

The publication manager 50 connected to the page manager 30 provides a function of publishing the generated web pages on the web server 60. That is, the web pages are transmitted to the web server 60 via FTP (file transfer protocol) or a network.

Such components are included in the main page 100 shown in FIG. 1. For example, the main page 100 is a page generated when the webgener according to the present invention is executed by a user, and includes a menu window 110, a page manager 30, a preview and a source window 120, and The tag information display window 130 is included.

The menu window 110 includes a file menu, an edit menu, a view menu, a wizard menu, a publication menu, a tool menu, and a help menu.

When the file menu is selected, a file menu window 111 is generated, and the file menu window 111 displays a new project, opening a project, adding to a project, project properties, removing all pages, a new file, opening a file, Includes Save As, Print, and Exit menus.

When the view menu is selected, a view menu window 112 is generated, and the view menu window 112 includes a design mode, a preview mode, and tag information view menus.

When the wizard menu is selected, a wizard menu window 113 is generated, and the wizard menu window 113 includes form wizard and SQL wizard menus.

When the tool menu is selected, a tool menu window 114 is generated, and the tool menu window 114 includes a data manager, a page designer, and option menus.

The preview and source window 120 includes a preview tab and a source view tab, and provides a preview and design function for a web page currently being worked on according to a user's mode selection.

In addition, when the source view tab is selected, the preview and the source window 120 allows the source of the web page currently being worked on to be displayed.

When the tag information view menu of the view menu window 112 is selected, the tag information display window 130 allows the HTML source of the current web page to be displayed.

Hereinafter, a method of generating a web site interoperating with a database according to an embodiment of the present invention will be schematically described with reference to FIG. 3.

First, the database 10 established in advance starts from the step of registering in the data manager 20 (S10).

In step S20, tables are created to use the registered database 10.

In step S30, web pages to which the generated table is applied are generated, and web pages linked to the database are generated corresponding to each of the web pages.

In step S40, the web pages linked with the database are transmitted to the web server 60 and published.

Hereinafter, with reference to the accompanying Figures 4 to 24 will be described in more detail with respect to the present invention.

4 through 9 are diagrams for describing a process of registering a database and creating a table S20 of FIG. 3.

First, when the data manager 20 in the tool menu of the main page 100 is selected by the user, the database management page 100 as shown in FIG. 4 is generated. The database management page 100 includes information about a database selected by a user and a first page 210 on which registerable database management system (DBMS) items such as MS Access, SQL Server, Oracle, Sybase, Informix, and DB2 are displayed. That is, the second page 220 displays the name of the database, the server name, the server data source name (DSN), and the Open DataBase Connectivity (ODBC) name items.

In the present embodiment, a case where Access, which is a PC DBMS, is selected among the DBMSs.

When the user selects the Access and clicks the right button of the mouse in a state where a point of a mouse (not shown) is positioned in the Access, a database registration selection window 230 is generated. The database registration selection window 230 includes a database registration menu and a registration wizard menu.

When the database registration menu is selected by the user (S111), the data manager 20 generates a database registration page 231 as shown in FIG. 5 (S112).

The database registration page 231 includes a DBMS display field, an ODBC check box of a database, a server information input field, a database information input field, and an option information input field.

In the DBMS display column, Access, which is a DBMS selected by the user, is displayed (S113).

In the ODBC check box, ODBC for the DBMS selected by the user is selected (S114).

When the items are described, the name item of the server information is inputted as local because Access, which is a PC DBMS, is selected (S115).

In addition, the DSN item is inputted with the DSN input when ODBC is set up at the server computer (S115). Among the database information items, a name of a database to be registered (sampleDB in this embodiment) is input in a name item, an ID for logging on to a database is input in a logon ID item, and a password for logging on to a database in a password item. Is input (S116).

Here, when the Access or SQL server is selected as the DBMS, the option input item is inactive. However, when Oracle is selected as the DBMS, the service item may be activated among the option input items and a service name may be input (S117).

In addition, when Infomix, Sybase and DB2 are selected as the DBMS, a version item of the option input item becomes active and a version of each database may be input (S117).

When the selection and input of corresponding information is completed by the user and the confirmation button is selected, as shown in FIG. 4, a database called sampleDB (local) is registered under the Access.

Here, when the test button is selected by the user, the data manager 20 generates a test result page (not shown) for checking the connection state of the selected DBMS.

After the database registration process as described above is completed, when the user clicks the right button of the mouse while the mouse is positioned on the SampleDB, a table generation selection window 240 is generated. The table creation selection window 240 includes a table creation menu, a table import menu, and an external table import menu.

When the table generation menu is selected by a user, the data manager 20 generates a first table generation page 250 as shown in FIG. 6.

The first table generation page 250 includes table information input items, such as a database name input item, a table ID input item, a table name input item, a table variable input item, and a description input item.

As shown in FIG. 6, when information items of the table are input by the user (S118) and the next button is selected, the data manager 20 generates a second table generation page 260.

The second table generation page 260 includes a database information display field 261, a table information display field 262, a check box 263, and a column information input field 264 of a table.

In the database information display field 261, the DBMS and name of the database selected by the user are displayed. The table information display field 262 displays the ID, name and variable of the table input by the user.

The check box 263 includes a server table check item, a table delete check item, and an automatic conversion check item.

Here, when the server table check item is selected by a user, an actual table is created in the registered database. On the other hand, if the server table check item is not selected by the user, a virtual table having only information is created in the user's local computer.

When the table delete check item is selected by a user, information of an already created table is deleted, and a new table having the same table ID and name is created. This is to prepare for the case where the table needs to be modified if the table design is incorrect during operation.

When the automatic conversion check item is selected by the user, the same value as the entered table ID is automatically entered, and default values are added to the column name, data type item, length item, null value item, and primary key item among the column values of the table to be described later. It is entered automatically.

The column information input field 264 of the table includes column ID, column name, data type, length, null value, primary key, column variable, and description input items.

The column ID is input in alphanumeric characters as the name of the column to be used.

The column name is a name of the column ID, and is automatically input when the automatic conversion check item is selected.

The data type is input according to an attribute provided by the selected DBMS as an attribute of the corresponding column.

The length is a length of a column, for example, 2 bytes for Korean characters, 1 byte for Korean characters, and 1 character for English characters.

The null value indicates whether null values are allowed, and the null value means that there is no information in the field. Here, when data is not input when data is input or modified when it is set to not allow the null value, it is preferable to allow the null value if it is not necessary (Y) because a database error occurs.

If a column is set as the primary key by the user, the column must have a unique value and must contain data. That is, the null value should not be allowed. When the primary key is selected as Y, the null value item is automatically designated as N.

The column variable is a value for storing a value of a corresponding column in a designated variable. For example, when the column ID is English, a column variable does not need to be separately designated, but must be input in English.

When the column information of the table is input by the user (S119) and the finish button is selected, as shown in FIG. 8, a table called Member below the left page tables of the database management page 100. Is generated.

In addition, column information of a table is displayed on the right side of the database management page.

The table import menu of the table creation selection window 240 provides a function of loading a previously created table.

The external table import menu of the table creation selection window 240 provides a function of importing a table from a database that is not selected by the user.

Hereinafter, a process of generating a general web page to which the generated table is applied will be described in detail with reference to the accompanying drawings.

10 to 12 are diagrams for describing a generation process S30 of the general web page.

First, when the file menu of the main page 100 is selected by the user, the file menu window 111 is generated as shown in FIG. 1.

A user selects a "New Project" menu among the menus of the file menu window 111, and as shown in FIG. 10, a project named "New Project" is created in the page manager 30 (S211). ). Here, the project means a collection of generated web pages.

Subsequently, when the "Add to Project" menu and the "Add New File" menu of the "Add to Project" menu are selected among the menus of the file menu window 111 (S212), the page manager 30 is selected. Generates a file add page 121-1 as shown in FIG. 11 (S213).

Here, the "file" is the same concept as the page, in the present invention, the web pages are managed as files in the project as the files are managed under the directory in the Windows Explorer.

The file add page 121-1 includes file information input and selection items, and a file name, for example, "member registration", is input to the file information input item as a name of a page to be generated (S214).

The file extension of the file information selection item may be selected from htm / html / asp, and an extension other than this may be input (S215).

In the file information selection item, a page or a frame page is selected as a file type (S215). The frame page refers to a page that divides pages into left and right, top and bottom, and displays several pages on one screen by connecting general pages to respective spaces.

Through the above process, a web page called member registration is generated under the new project of FIG.

The file menu window 111 is a menu other than adding a new file, and includes frame page creation, existing file addition, group addition, all page removal, and project property items.

Here, the frame page creation menu provides a function for making a page currently being worked as a frame page.

The add existing file menu provides a function of adding a previously generated page to a lower part of the currently working project.

The Add Group menu provides a function for sorting and managing pages in a project. This is similar to the directory in Windows Explorer.

The Remove All Pages menu provides a function to remove information of pages belonging to a project.

The project property menu provides a function of providing a name of a project currently being worked by a user, a project path, and information on all pages and groups belonging to the project.

Hereinafter, a process of generating a web page linked with a database will be described in more detail with reference to FIGS. 13 to 21.

13 to 21 are diagrams for explaining a process of generating a web page (S30) linked to a database.

First, a target page for creating a new form is selected by the user using the form wizard 40 among the wizard menus of the main page 100 (S300). In this embodiment, a previously created member registration page is selected. Explain about.

Subsequently, when the form wizard 40 is selected by the user (S301), the form wizard 40 includes a page information input box 301 and a database processing task check box 302 as shown in FIG. 13. One generation page 300 is generated.

The page information input field 301 includes a page name item, a page ID item, and a form name item. The page name item and the page ID item display the name and ID of the page selected by the user, that is, the member registration.

In the form name, a name of a form to be newly configured, for example, form1 is input (S302), because when a web page is generated by the form wizard 40, a page is formed while a new form is created in one page. .

In addition, when the web page is generated by the form wizard 40, the name of each field and the value of the database column are prefixed with the form name.

The processing tasks that can be selected by the user in the database processing task selection box 302 include an inquiry menu, a modification menu, an insert menu, and a delete menu.

The inquiry menu provides a function of inquiring data and is selected by default on all pages.

The correction menu provides a function for modifying data.

The insertion menu provides a function for inputting data, and input is selected for a page for inputting data.

The delete menu provides a function of deleting selected data according to an input condition.

After the form name and the database processing operation are selected by the user (S303) and the next button is selected, as shown in FIG. 14, the form wizard 40 selects the database and table check box 311 to be used in the form of the web page. And a second selection page 310 including the selected table display field 312.

The database registered by the user is displayed in the database and table selection box 311, and a table to be used in the registered database is selected (S304). In this embodiment, the database registered by the user is "sampleDB", and the newly created table is "Member".

When the table is selected by the user (S304), the table and the columns are displayed in the selected table display field 312.

When the selection of the database and the table is completed and the next button is selected by the user, the form wizard 40 displays the column check box 32 of the table, the attribute check box 3222 of the component of the selected column. And a third selection page 320 including a column attribute field 323 and a preview window 324.

In the state where the third selection page 320 is generated, when the square icon 321-2 located on the left side of the table displayed in the column selection column 321 of the table is selected by the user, all columns of the table are selected ( S305), as shown in FIG. 15, all fields of the database table are displayed in the third selection page 320.

The column display type of the table displayed in the preview window 324 is a form of a data sheet type capable of simultaneously processing a plurality of data. When the icon 312-1 located on the right side of the selected table item is selected, the data sheet type form is converted into a field type form that can dry-process data.

The attribute check box 322 includes a name item, a label item, and a format item. In the name item, variable names of the columns of the database table, that is, variable names of the columns prefixed with form1 input to the form name of the first generation page 300 are displayed.

The label items are the names of the fields to appear in the form. The column names of the table are displayed by default, but can be modified by the user.

The format item is a format of each field to be displayed in the form, and can be selected from a single line box, a combo box, a scroll box, a password, a hidden box, a data field, and a picture format.

In this case, when only inquiry is selected as the database processing job, the data field is displayed as a default value, and when input and modification are selected, a single line box is displayed as a default value.

For example, when a combo box is selected as a form of the form field, an option text and an option value should be input (S306). This is followed by a process of selecting an attribute button of the attribute selection box 322 and inputting an option text and an option value.

In addition, when one of the table fields is selected by the user and the triangle icon 3222-1 located to the right of the format item corresponding to the field is double-clicked, a single line box, a combo box, a scroll box, a password , Hidden boxes, data fields, and picture formats are displayed.

At this time, if an appropriate format is selected by the user (S307), the corresponding field is converted according to the selected format.

The add button in the attribute check box 322 provides the ability to insert fields not specified as columns of the table into the form.

The remove button of the attribute select box 322 provides a function of deleting an item added using a column selected from a table or the add button.

The up button of the attribute check box 322 provides a function of moving an item displayed in the selected elements upward by one space.

The down button of the attribute selection box 322 provides a function of moving items displayed in the selected elements downward by one space.

The attribute button of the attribute select box 322 provides a function of displaying an attribute for the selected item.

The Add Receive Variable button of the attribute selection box 322 provides a function of making a field in a form when a link relation is set from another page to a currently working page and data designated as a parameter is passed.

Here, when the format of the field, for example, the gender is selected as the combo box, when the attribute button 322-2 is selected by the user, as shown in FIG. 16, the form wizard 40 displays the information of the combo box. Generate an input page 330 that includes the input items.

The information input items include a label name, name, size, option text, and option value of the selected field.

The input page 330 includes an add button 331, a change button 332, a remove button 333, an up button 334, and a down button 335.

The add button 331 provides a function of adding an option text and an option value of the combo box.

The change button 332 provides a function of modifying the selected option text and the option value.

The remove button 333 provides a function of removing the selected option text and the option value.

The up and down buttons 334 and 335 provide a function of adjusting an arrangement order of selected option texts and option values.

In addition, when the form is generated in a data sheet format, since several pieces of data are displayed at the same time, if a search field is specified, only data meeting a search condition is displayed on the data sheet (S308).

For example, if the right button of the mouse is selected while the member number field is selected by the user, as shown in FIG. 17, the form wizard 40 generates a selection window 340 including a search field creation item.

When the search field creation item is selected, a search condition display window 341 including an item search including a matching item search and a word as a search condition is generated.

When the search field is generated by the matching item search, only data that exactly matches the search condition is searched. When the search field is generated by the item search including the word, all the data including the word input in the search condition are searched.

In the case where the form is a data sheet format, since several pieces of data are retrieved at the same time, it is necessary to specify a data sort order (S309).

For example, if the sort button 326 is selected after the columns are selected by the user, the form wizard 40 generates a selection page 350 to select the sort order of the columns, as shown in FIG.

The selection page 350 includes a column list field 351 for displaying selected columns, control buttons 353 and 354 for adjusting sort priority, and a designation button 352 for designating a sort order of columns.

For example, when the member name column is double-clicked as a column to be arranged by the user, the designated button 352 is displayed in red and sorted in ascending order.

On the other hand, if the member name column is double-clicked again, the designated button 352 is changed to blue and sorted in descending order.

In addition, when a specific column is linked to another page by the user, the specific column may be linked using a hyperlink link function (S310).

In addition, when the source button 325 of the third selection page 320 is selected by the user, the form wizard 40 generates a display window (not shown) that displays a source for the content that has been worked so far ( S311).

Hereinafter, the setting for the subprocess when inserting, modifying or deleting is selected as the database processing job in step S303 will be described.

When step S311 is completed and the next button is selected by the user, the form wizard 40 generates a setup page 3630 that allows the details of the database process task to be set as shown in FIG. 20.

The setting page 360 includes a process application table display window 361, a user formula window 363, and a script preview window 362.

In the left pane of the process application table display window 361, the columns of the table selected in the above steps are automatically displayed, and the variables displayed in the right pane are assigned.

Hereinafter, an example in which the automatic increase function is given to the member number item designated as the hidden box in step S307 will be described.

When the member number item is selected by the user, and the formula use check box 363-1 of the user formula window 363 is selected, w_double and 8 are displayed in format and length, respectively, and the variable of the member number item is selected. Form1_M_ID is displayed in the user expression window 363.

Subsequently, when the algorithm / function application button 363-2 is selected by the user, the form wizard 40 generates a script algorithm application page 370 as shown in FIG. 21.

The script algorithm application page 370 includes an algorithm list window 371 and a script window 372.

When the sequential increment item is double-clicked in the algorithm list window 371, an algorithm is applied to the member number item.

At this time, the script window 372 displays a script for the sequential increase.

When the confirmation button of the script algorithm application page 370 is selected by the user, the form wizard 40 generates the setting page 360 again.

In this case, when the script view box 362-1 is selected by the user, the script preview window 362 displays the entire source of the process page.

Here, a process page for processing input data is displayed when the insert tab is selected, and a process page for processing correction data is displayed when the correction tab is selected.

If the Delete tab is selected, the process page for deleting data is displayed.

Thereafter, when the finish button of the setting page 360 is selected by the user, a member registration page is generated in which the number is automatically increased by one each time a member is registered one by one.

Through this process, a web page linked with the database is created.

Through the same process as described above, it is possible to generate web pages linked to the database, for example, a member management page including a member registration page and a member list page.

Hereinafter, a process (S40) in which the web pages generated as described above are published on the web server 60 will be described in detail with reference to FIGS. 22 to 24.

When the publication manager 50 shown in FIG. 2 is selected by the user, the publication manager 50 generates a publishing environment setting page 400 for setting the publishing environment as shown in FIG. 22 (S401). . Here, the publication environment setting page 400 is generated even if the publication menu of the main page 100 is selected.

The publishing environment setting page 400 includes a server URL input box 401 on which a web service is to be executed and a publishing location input box 402 of generated web pages.

The publication location input field 402 includes a network drive check item, a user name input item, a password input item and a publication location input item.

The server URL input field 401 is a place where an address where a web service is executed is input, and varies according to a user's publishing environment.

That is, when the user's environment is the FTP access environment (S402), the server URL input field 401 is inputted as http: // localhost (S403). This is because the generated web pages are executed through, for example, an explorer and viewed on a user's own PC.

In addition, the network drive check item of the publication location input field 402 is selected. When the network drive check item is selected, a user name input item and a password input item cannot be input.

In addition, an address where FTP is installed, for example, FTP://210.98.172.86/ftp/, is entered in the publication location item of the publication location input field 402 (S404).

If the user's environment is a network server environment instead of an FTP access environment in step S402, the address of the network server currently used, for example, E: WInterPubWwwwroot, is entered in the server URL input field 401 (S405).

In addition, the network drive check item is not selected, and the user name of the FTP and the password of the FTP user are respectively input to the user name input item and the password (S406).

In addition, an FTP address, for example, the same address as the server URL is input to the publication location item of the publication location input field 402 (S407).

If the confirmation button is selected after the input process is completed by the user, the publication manager 50 generates the publication selection page 410 as shown in FIG.

The publication selection page 410 includes a server URL display field 411, a publication position display field 412, a publication list screen 413, a publishing option selection item 414, and an FTP option selection item 415.

In the server URL display field 411 and the publication location display field 412, the URL and the location input from the publication environment setting page 400 are displayed.

The publication list screen 413 displays a page connected to the currently selected page, for example, a member registration page, a member list page, and names, IDs, formats, states, and modification dates of member management pages.

The state indicates a publication state, and there may be three following states. First, it is not published as Not Pub. Secondly, it is in the local Pub state and is only published in the current directory. Third, it has been published to the web server as FTP Trans state.

The publishing option selection item 414 includes selection and both items. When the selection item is selected, only the page name is selected is published. When all of the above items are selected, the entire page name displayed on the screen is published.

The FTP option selection item 415 includes source generation (local) and server transfer items, which are published under the working directory when the source generation item is selected. If the server transmission item is selected, it is transmitted to the designated server.

In the present embodiment, it is assumed that a selection item is selected from the publishing option selection item 414 and a server transmission is selected from the FTP option selection item 415.

If the user selects the publish option and the FTP option as described above, and then selects the OK button, the web pages are transmitted to the web server 60 via FTP and published (S408).

As described above, web pages (web sites) that interoperate with the database can be easily generated, and the construction time of the web site can be shortened to maximize efficiency.

As described above, according to the present invention, even a general user who does not know the website production program language can use the wizard function to build a more professional website.

In addition, the present invention is applicable to all relational databases because it basically supports the ODBC database access.

Although the present invention has been described in detail by the above embodiments, various modifications are possible without departing from the spirit and scope of the present invention.

Claims (54)

a) registering information of a previously built database; b) creating a new table or extracting information of a previously created table to use the database to be registered; c) generating web pages to which the table is to be applied, and then generating web pages linked with the database corresponding to each of the web pages; And d) transmitting the web pages generated through the step c) to a web server and publishing the web pages. The method of claim 1, wherein step a) a-1) generating a database registration page including a DBMS display field, an ODBC check box of a database, a server information input field, and a database information input field corresponding to a user's selection of a database registration menu; and a-2) storing information input through the database registration page. The database registration page of claim 2, wherein the database registration page is linked with a database management page, and the database management page includes a first page including registerable DBMS items and a second page including information of a database selected by a user. The second page includes a database registration selection window and a table creation selection window, The database registration selection window may include a database registration menu and a registration wizard menu. 4. The database as claimed in claim 3, wherein the table creation selection window further comprises a table import menu item for loading a previously created table and an external table import menu item for loading a table from a database not selected by the user. How to create a linked website. The method of claim 1, wherein step b) b-1) a first table creation page including table information input items and a second table creation page including column information input items of the table in response to a user's selection of a table creation menu for creating a table in the database. Generating; And b-2) generating a table corresponding to information inputted in each information input item of the first and second table generation pages. The method of claim 5, wherein the table information input items of the first table creation page include a database name, a table ID, a table name, and a table variable item, and the column information input items of the table of the second table creation page are displayed as database information. And a table information display column, a check box and a column information input field of the table. 7. The method of claim 6, wherein the column information input field of the table includes column ID, column name, data type, length, null value, primary key, and column variable input items. The method of claim 1, wherein step c) c-1) Create a new project in response to a user's selection of a new project creation menu for generating a web page to which the table is applied, and file information in response to a file addition menu selection included in the file menu window of the new project. Generating a file add page comprising input and selection items; c-2) generating a web page corresponding to the information input to the file addition page; c-3) generating a first generated page that is selected by the user and includes a page information input box and a database processing task check box to form a new form in the web page that is linked with a database; c-4) after input of the information and selection of the processing operation in the page information input box and the database processing operation check box of the first generated page are completed, the database to be used in the form of the second web page in response to the user's next menu selection; Generating a second selection page comprising a table check box and the selected table display field; c-5) After the database and table selection of step d-2) are completed by the user, the column selection item of the table, the attribute selection column of the component of the selected column, the column attribute column and the like in advance in response to the user's next menu selection. Generating a third selection page comprising a view window; And c-6) generating a web page interworking with the database according to the selection of the column of step d-3) by the user and the attribute of the component of the selected column being selected. How to create a site. The method of claim 8, wherein the add file selection menu is included in a file menu window, and the file menu window further includes a frame page creation, an existing file addition, a group addition, a removal of all pages, and a project property menu. How to create a database-linked website characterized in. The method of claim 8, wherein the file information input and selection items of the file add page include a format, a file extension, and a file type of a file to be generated. The method of claim 10, wherein the file type comprises a frame page and a page. 10. The method of claim 8, wherein the database processing operation of step c-3), which can be selected by the user, comprises items of inquiry, modification, insertion, and deletion. The method of claim 8, wherein the method is A) if the insert and modify operation is selected as the database processing operation of step c-3) by the user, further comprising providing a source of the web page generated by steps c-3) to c-6); Method for generating a database-linked website, characterized in that configured. 10. The method of claim 8, wherein the preview window is a window for displaying a form of a column of the selected table in advance, wherein a form or data of a data sheet type in which a plurality of pieces of data can be processed simultaneously are processed one by one. A method for creating a database-linked website, comprising: an icon for converting to a form of a field type that can be converted. The method of claim 8, wherein the method is B) further comprising the step of converting the format of each field to appear in the form of the column selected by the user, A user selectable field type includes a single line box, a combo box, a scrolling box, a password, a hidden box, a data field, and a picture format. The method of claim 8, wherein the method is C) if the format of the field selected by the user is a combo box, further comprising generating an input page including information input items of the combo box, The information input item may include a label name, name, size, option text, and option value of the selected field. The apparatus of claim 16, wherein the input page comprises an add button, a change button, a remove button, a up and down button, The add button adds an option post and an option value of a combo box, the change button modifies a selected option post and an option value, the remove button removes the selected option post and an option value, and the up and down buttons. Is a method for creating a database-linked website, which provides a function of adjusting an arrangement order of selected option texts and option values. The method of claim 8, wherein the method is D) if the form of the column selected by the user is a data sheet type in which several pieces of data are displayed at the same time, generating a selection window including an item for creating a search field so that only data meeting the search conditions are displayed in the data sheet. Database interworking website generation method comprising a. 19. The method of claim 18, wherein when the search field creation item is selected, a search condition display window including a search for a matching item and an item search including a word is generated as a search condition. Here, when the search field is generated by the matching item search, only data matching the search condition is searched. When the search field is generated by the item search including the word, all data including the word entered in the search condition is searched. How to create a database-linked website, characterized in that. The method of claim 8, wherein the method is E) if the form of the column selected by the user is a data sheet type in which several pieces of data are displayed at the same time, generating a selection page for selecting the sort order of the columns; Wherein the selection page includes a column list indicating selected columns, an adjustment button for adjusting a sorting priority and a designation button for designating a sort order of the columns. 21. The method of claim 20, wherein when a specific column to be sorted by a user is double-clicked, the color of the designated button is changed so that the columns are sorted in ascending or descending order. The method of claim 8, wherein the method is (F) generating, by a user, a setting page for setting details of the database process task when inserting, modifying, or deleting is selected as the database processing task; And the setting page includes a process application table display window, a user formula window, and a script preview window. The method according to claim 22, wherein the user formula window includes a formula use check box and an algorithm / function application button. The method, G) generating a script algorithm application page including an algorithm list window and a script window in response to selection of the algorithm / function application button by the user. The system of claim 22, wherein the script preview window includes an insert tab, a edit tab, and a delete tab, When the insert tab is selected, a process page for processing input data is displayed; when the correction tab is selected, a process page for processing correction data is displayed; when the delete tab is selected, a process page for deleting data is displayed. How to create a database-linked website, characterized in that. The method of claim 1, wherein step d) d-1) generating a publishing preference page including a server URL input box in which a web service is to be executed and a publishing location input box of web pages in response to selection of a publishing preference menu by a user; d-2) If the user's environment is an FTP access environment, after the server URL and the publication location are input, in response to the user's selection of the publishing menu, the server URL display column, the publication location display column, the publication list screen, and the publishing option Generating a publication selection page comprising the selection item and the FTP option selection item; And d-3) after the options of step d-2) are selected by the user, further comprising the step of publishing the generated web pages in response to the user's selection of the confirmation menu. 26. The method of claim 25, wherein the publishing location input box of the publishing environment setting page includes a network drive check item, a user name input item, a password input item, and a publishing location input item. The method of claim 25, wherein the method is H) If the user's environment is a network server environment, after the server URL, user ID, password, and publication location are input, a publishing selection including a publishing option selection item and an FTP option selection item corresponding to the user's publishing menu selection Generating a page; And I) After the options of step d-2) are selected by the user, the generated web pages are published according to the user's selection of the confirmation menu. The method of claim 25, wherein the publication list screen displays the name, ID, format, status and date of change of the web pages connected to the currently selected web page, Wherein the format indicates a publication status of each web page. A computer readable recording medium comprising instructions for performing the steps of claim 1. a-1) generating a database registration page including a DBMS display field, an ODBC check box of a database, a server information input field, and a database information input field corresponding to a user's selection of a database registration menu; a-2) storing information input through the database registration page; a-3) a first table creation page including table information input items and a second table creation page including column information input items of the table in response to a user's selection of a table creation menu for creating a table in the database; Generating; a-4) generating a table corresponding to information input to each information input item of the first and second table generation pages; a-5) Create a new project in response to a user's selection of a new project creation menu for generating a web page to which the table is applied, and file information in response to a file addition menu selection included in a file menu window of the new project. Generating a file add page comprising input and selection items; a-6) generating a web page corresponding to the information input to the file addition page; a-7) generating a first generated page selected by the user and including a page information input box and a database processing task check box to form a new form in the web page that is linked with a database; a-8) After the input of the information and the selection of the processing operation in the page information input box and the database processing operation check box of the first generation page are completed, the database to be used in the form of the second web page in response to the user's next menu selection; Generating a second selection page comprising a table check box and the selected table display field; a-9) After the database and table selection in step a-8) are completed by the user, the column selection item of the table, the attribute selection column of the component of the selected column, the column attribute column and the like in advance in response to the user's next menu selection. Generating a third selection page comprising a view window; a-10) generating a web page linked with a database when a column of step a-9) is selected by a user and an attribute of a component of the selected column is selected; a-11) generating a publishing preference page including a server URL input box in which a web service is to be executed and a publishing location input box of web pages in response to selection of a publishing preference menu by a user; a-12) When the user's environment is an FTP access environment, after the server URL and the publication location are input, in response to the user's selection of the publishing menu, the server URL display column, the publication location display column, the publication list screen, the publishing option Generating a publication selection page comprising the selection item and the FTP option selection item; And a-13) after the options of step a-12) are selected by the user, the generated web pages are published in response to the user selecting a confirmation menu. 31. The database registration page of claim 30, wherein the database registration page is linked with a database management page, and the database management page includes a first page including registerable DBMS items and a second page including information of a database selected by a user. The second page includes a database registration selection window and a table creation selection window, The database registration selection window may include a database registration menu and a registration wizard menu. 33. The database of claim 31, wherein the table creation selection window further comprises a table import menu item for loading a previously created table and an external table import menu item for loading a table from a database not selected by the user. How to create a linked website. 31. The method of claim 30, wherein the table information input items of the first table creation page include a database name, a table ID, a table name, and a table variable item, and the column information input items of the table of the second table creation page are displayed as database information. And a table information display column, a check box and a column information input field of the table. 34. The method of claim 33, wherein the column information input field of the table includes column ID, column name, data type, length, null value, primary key, and column variable input items. 31. The method of claim 30, wherein the add file selection menu is included in a file menu window, wherein the file menu window further includes a frame page creation, an existing file addition, a group addition, a removal of all pages, and a project property menu. How to create a database-linked website characterized in that. 31. The method of claim 30, wherein the file information input and selection items of the file add page include a format, a file extension, and file types of a file to be created. 37. The method of claim 36, wherein the file type comprises a frame page and a page. 31. The method of claim 30, wherein the database processing operation of step a-7), which can be selected by the user, consists of inquiry, modification, insertion, and deletion items. The method of claim 30, wherein the method is A) if the insert and modify operation is selected as the database processing operation of step a-7) by the user, further comprising providing a source of the web page generated by steps a-7) to a-10) Method for generating a database-linked website, characterized in that configured. 31. The method of claim 30, wherein the preview window is a window for displaying a form of a column of the selected table in advance, wherein a form or data of a data sheet type in which multiple data can be processed simultaneously are processed one by one. A method for creating a database-linked website, comprising: an icon for converting to a form of a field type that can be converted. The method of claim 30, wherein the method is B) further comprising the step of converting the format of each field to appear in the form of the column selected by the user, A user selectable field type includes a single line box, a combo box, a scrolling box, a password, a hidden box, a data field, and a picture format. The method of claim 30, wherein the method is C) if the format of the field selected by the user is a combo box, further comprising generating an input page including information input items of the combo box, The information input item may include a label name, name, size, option text, and option value of the selected field. 43. The system of claim 42, wherein the input page comprises an add button, a change button, a remove button, a up and down button, The add button adds an option article and an option value of a combo box, the change button modifies the selected option article and an option value, the remove button removes the selected option article and option values, and the up and down buttons. Is a method for creating a database-linked website, which provides a function of adjusting an arrangement order of selected option texts and option values. The method of claim 30, wherein the method is D) if the form of the column selected by the user is a data sheet type in which several pieces of data are displayed at the same time, generating a selection window including an item for creating a search field so that only data meeting the search conditions are displayed in the data sheet. Database interworking website generation method comprising a. The search condition display window according to claim 44, wherein when the search field creation item is selected, a search condition display window including an item search including a matching item search and a word as a search condition is generated. Here, when the search field is generated by the matching item search, only data matching the search condition is searched. When the search field is generated by the item search including the word, all data including the word entered in the search condition is searched. How to create a database-linked website, characterized in that. The method of claim 30, wherein the method is E) when the form of the column selected by the user is a data sheet type in which several pieces of data are displayed at the same time, generating a selection page for selecting the sort order of the columns; Wherein the selection page includes a column list indicating selected columns, an adjustment button for adjusting a sorting priority and a designation button for designating a sort order of the columns. 47. The method of claim 46, wherein when a specific column to be sorted by a user is double-clicked, the color of the designated button is changed so that the columns are sorted in ascending or descending order. The method of claim 30, wherein the method is (F) generating, by a user, a setting page for setting details of the database process task when inserting, modifying, or deleting is selected as the database processing task; And the setting page includes a process application table display window, a user formula window, and a script preview window. 49. The system according to claim 48, wherein the user formula window includes a formula usage check box and an algorithm / function application button. The method, G) generating a script algorithm application page including an algorithm list window and a script window in response to selection of the algorithm / function application button by the user. 49. The system of claim 48, wherein the script preview window includes an insert tab, a modify tab, and a delete tab, When the insertion tab is selected, a process page for processing input data is displayed. When the correction tab is selected, a process page for processing correction data is displayed. When the deletion tab is selected, a process page for deleting data is displayed. Method for creating a database-linked website, characterized in that. 31. The method of claim 30, wherein the publishing location input box of the publishing environment setting page includes a network drive check item, a user name input item, a password input item, and a publishing location input item. The method of claim 30, wherein the method is H) If the user's environment is a network server environment, after the server URL, user ID, password, and publication location are input, a publishing selection including a publishing option selection item and an FTP option selection item corresponding to the user's publishing menu selection Generating a page; And I) After the options of step a-12) are selected by the user, the generated web pages are published according to the user's selection of the confirmation menu. 32. The method of claim 30, wherein the publication list screen displays the name, ID, format, status, and date of change of the web pages connected to the currently selected web page. Wherein the format indicates a publication status of each web page. A computer readable recording medium comprising instructions for performing the steps of claim 30.