JP2000276396A - Web site construction system, its method and storage medium recording its processing program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To obtain web site construction system and method capable of constructing a web site cooperated with a data base without executing program ming and a storage medium recording a program for web site construction processing. SOLUTION: The system is provided with a web site construction tool 11 for preparing information for specifying a relational data base(RDB) and a table in the RDB on the basis of interactive operation with a user by a GUI and storing the prepared information in a site information file 14, a web page design tool 12 for preparing a web page file 13 displayed by a www browser on the basis of the interactive operation with the user by the GUI and padding DB information for specifying the table of the RDB which is to be operated from the browser in the file 13 and a CGI program 15 started from a web server program so as to execute processing for the table requested from the browser by accessing the RDB table specified by the DB information in the file 13. Thus the system constructs a web site for executing operation for the RDB by operation from the browser on the basis of the interactive operation with the user by the GUI.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

The present invention relates to the World Wide Web (hereinafter referred to as "WW") of the Internet or an intranet.
W "), and in particular, a website construction system and method suitable for efficiently constructing a website that cooperates with a relational database existing on a network, and The present invention relates to a recording medium on which the processing program is recorded.

[0002]

2. Description of the Related Art With the spread of Internet technology, WW
Many websites for transmitting various kinds of information by W have been constructed. Recently, the number of Web sites that link the WWW with a database management system to display data stored in a database with a browser that accesses a WWW server and to enable data maintenance processing of addition, update, and deletion has been increasing. I have.

As a technique for linking the WWW with the database management system, for example, Japanese Patent Laid-Open No. 10-198
No. 596 is disclosed. In this technology, for example, it is assumed that there is information such as merchandise information which is displayed in a static HTML (Hyper Text Markup Language) file and is managed in a database, and such information is obtained by using an information updating tool. DBMS (Data Base Mang
ement System) to update the database.

This information updating tool calls a template of a static HTML file which normally displays information statically, creates a new static HTML file in which new information based on updated data is embedded, and creates a new static HTML file. Replace with existing file. In this way, the latest information in the database can be displayed on the browser.

[0005] In relational database management systems currently on the market, a function for maintaining (adding, updating, deleting) data on a database by web server data access via the Internet or an intranet is provided. It has not been.

Therefore, maintenance (addition / update / update) of data on a relational database management system is performed via the Internet or an intranet.
In order to construct a Web site for performing (deletion), it must be realized by programming using a text (character string) describing a processing procedure called a script.

[0007] As described above, in the conventional Web site construction technology for performing data maintenance of the linked database, it is necessary to add processing by programming.
In addition, when a search Web page for extracting target data from existing data, a list display Web page, and the like are added, they must be separately created by programming.

[0008] Therefore, in order to construct a Web site for performing data maintenance of a database, knowledge of the database, programming technology, and knowledge of HTML which is a basic language for transmitting information on the Internet Web are required. Therefore, it is difficult for a Web site provider who does not have such knowledge and technology to construct such a Web site by himself.

[0009]

The problem to be solved is that, in the prior art, unless the user has knowledge about a database, programming technology, and HTML, etc., the WWW server and the database are linked. The point is that the site cannot be constructed and maintained.

An object of the present invention is to solve the problems of the prior art and to make it possible to construct a Web site linked to a database without programming.
It is an object of the present invention to provide a b-site construction system and method and a recording medium on which a processing program is recorded.

[0011]

In order to achieve the above object, a system and method for constructing a Web site according to the present invention comprises:
Web that links W and RBD and references, updates, adds and deletes RDB by operation from WWW browser
When constructing a site, a Web site is constructed based on an interactive operation with a user using a GUI. For this purpose, information on a database to be used, connection information, and the like are stored as a site information file, and are used when creating and operating a Web site.

[0012]

Embodiments of the present invention will be described below in detail with reference to the drawings. FIG. 1 is a block diagram showing an embodiment of a configuration according to the present invention of a Web site construction system of the present invention. In FIG. 1, reference numeral 1 denotes a user who creates a data maintenance Web site;
b, a server machine for storing site-related information, and 3 a Web site constructed on the server machine 2 by a WWW browser 1.
7 is a client machine to be referenced and updated.

The server machine 2 is provided with an existing database 10 for data maintenance including a database management system, a Web site construction tool 11, a page design tool 12, a CGI (Common Gateway Interface) program 15, a WWW server program 16, and the like. These are a CD-ROM (Compact) not shown.
It is installed by installing a processing program and data recorded on a recording medium such as a Disc-Read Only Memory).

[0014] The Web site construction tool 11
GUI (Graphical User Interface) for various definition information about a Web site to be constructed using an input device such as a screen display device and a mouse and a keyboard.
And outputs the input definition information as the site information file 14.

The page design tool 12 outputs, as an HTML file 13, a definition result from the user 1 such as a web page configuration displayed on the WWW browser 17 of the client machine 3 and a layout of each web page.

[0016] The CGI program 15 is a WWW server program 1 that has received a request from the WWW browser 17.
6 and generates display screen data of the WWW browser 17. Hereinafter, the Web site construction tool 11 will be described in detail with reference to FIG.

FIG. 2 is an explanatory diagram showing an example of the processing operation of the Web site construction tool in FIG. This example shows an example of a GUI in the website construction tool 11 of FIG. The user 1 selects or inputs items to be defined from the candidate list in the order requested by the Web site construction tool 11 in an interactive manner.

The input information is as follows in the order of input. (1) Web site type: A reference Web site that performs only reference to a table on the existing database 10, or an update Web site to which a maintenance function (data addition, update, and deletion) is added. Decide if you want a site. (2) Web site page configuration: An appropriate configuration type is selected from several types of Web page configurations prepared by the system, and the style of the Web site is determined.

(3) Database information to be connected (cooperated): An ODBC data source name for accessing the existing database 10 is selected via the GUI screen 11a of FIG. 2, and a database type (for the database management system of the database 10). Name). ODB
C is Open DataBase Connecti
It is an abbreviation of "vitity" and is a database connection standard proposed by Microsoft Corporation in the United States. It aims to standardize a mechanism for accessing various database files from various application software and a database engine on a server.

(4) Setting of user name and password: A user name and password for accessing the database are input. (5) Selection of table to be used: GUI screen 11 in FIG.
Through b, one main table in the table structure of the database to be used is selected. Search, add, or update data for the table set here.

(6) Setting of a related table: When a related table exists, related information between the main table and the related table is defined here. (7) Setting of site name and site directory: G in FIG.
Through the UI screen 11c, the user specifies the name of the Web site to be created and the name of the directory in which files (HTML files and the like) constituting the Web site are located.

Then, the Web site construction tool 11
The entered information is added to the site information file 14 as a new Web
Registration is performed as a site b, a directory specified by the user 1 is created on the physical disk of the server machine 2, and a Web site is registered in the WWW server program 16 with the specified name.

Next, the page design tool 12 in FIG. 1 will be described. In the page design tool 12, based on an interactive operation by the GUI with the user 1,
The design of the part for displaying the data of the existing database 10 on the browser display screen and the Web page (W
In the website construction tool 11, a link between pages (pages belonging to the page configuration selected in the style of the website to be created) is set.

At this time, the page design tool 12 reads out the information of the Web site to be created from the site information file 14, and based on the information, the database 1
0, and a list of “columns” that can be selected in creating a web page is displayed on the GUI screen.

Here, "column" means an item included in a table on the database. That is, each of the types of information stored in the table is a column. Therefore, the list of columns displayed on the GUI screen of the page design tool 12 is a list of data items included in the specified table on the database.

FIG. 3 is an explanatory diagram showing an example of the processing operation of the page design tool in FIG. This example shows a display example of a GUI screen in the page design tool 12 of FIG. The user 1 uses the W
The column used in the eb page is displayed on the GUI screen 12a.
The selection process is performed by copying from the selection target column list on the left side of the screen to the page creation target column list on the right side of the screen (GUI screen 12b).

Then, the page design tool 12 generates an HTML file 13 based on the information of the column selected in this manner.
Create. At this time, the page design tool 12
A process description in HTML code executed by the CGI program 15 is embedded in the created HTML file 13 with a tag (<# ...> mark) added.

As described above, when the user 1 performs the GUI operation of the Web site construction tool 11, the page design tool 12, and the two tool programs, the target Web
This means that the site b has been defined and constructed. The definition information on the constructed Web site includes a site information file 14, an HTML file 13, and a CGI program 15.
Is created inside.

Next, the processing operation when the Web site constructed in this way is displayed from the WWW browser 23 of the client machine 21 in FIG. 1 will be described. First, processing is executed from the WWW browser 23 to a Web site on the server machine 2, or
Next, a request to display a web page to be browsed on the WWW browser 23 is transmitted.

In the server machine 2, the WWW browser 23
Request sent from WWW server program 1
6, the WWW server program 16
The GI program 15 is started.

The CGI program 15 reads the next W
With reference to the HTML page 13 of the web page and the site information file 14, the database 10 is searched, and processing such as new addition / update / deletion of data is executed. In the case of a search, the data of the search result, and in the case of a new addition, update, or deletion, the result of success or failure,
Output to the referenced HTML file 13.

The WWW server program 16 returns the HTML file 13 on which the processing result of the CGI program 15 is reflected to the WWW browser 23 as a response to the request. Hereinafter, such FIG. 1 will be described with reference to FIG.
An example of the processing operation of the Web site construction system in FIG.

FIG. 4 is a flowchart showing an example of a processing operation according to the present invention of the Web site construction system in FIG. In this example, the WWW server program 16 and the CGI
The processing in the program 15 is shown. Steps 101, 102, and 109 are the processing of the WWW server program 16, and the processing of steps 103 to 108 is the processing of the CGI program 15.

In step 102, the WWW shown in FIG.
The server name and the target HTML file 1 which are the arguments passed when the server program 16 receives the request
The CGI program 15 is started using the name of the CGI. In steps 103 to 107, the target HTML
The file 13 is analyzed.

That is, in step 104, C
"<# ..." which is a mark to be processed by the GI program 15
It is determined whether or not there is a tag of >>. If not, it is determined in step 107 whether or not all tags have been read. , Follow the instructions of the tag
The processing is executed in the GI program 15.

At this time, data processing of search, new addition, update, and deletion is performed on the table of the database 10. Then, in step 106, the result of step 105 is described in a corresponding position of the target HTML file 13 according to the HTML format.

In step 107, all the lines in the target HTML file are read, and after a series of processing is completed, in step 108, the target HTML file 13
Return to WW server program 16. The WWW server program 16 transmits the HTML file 13 to the WWW browser 17 of the client machine 3 that has made the request (Step 109).

Hereinafter, examples of GUI screens displayed by the Web site construction tool 11 in FIG. 1 will be described with reference to FIGS. FIG. 5 is an explanatory diagram showing a first GUI screen example displayed by the website construction tool in FIG. This example is a GUI screen for displaying a list of databases to be connected and DBMS names of the databases, and setting a database and a DBMS name selected by the user from the list.

FIG. 6 is an explanatory diagram showing an example of the second GUI screen displayed by the Web site construction tool in FIG. This example is a GUI screen for displaying a list of tables in the database selected and set on the GUI screen in FIG. 5 and setting the table selected by the user from the list.

FIG. 7 is an explanatory diagram showing a third GUI screen example displayed by the Web site construction tool in FIG. The GUI screen of this example is used to define, when there is a related table with respect to the table selected and set on the GUI screen of FIG. 6, the related information, and the related table name and its item name. Are displayed in a list, and the table and items selected by the user from the list are set.

FIG. 8 is an explanatory diagram showing a fourth GUI screen example displayed by the Web site construction tool in FIG. This example is a GUI screen for setting a storage destination of a newly created Web site, and stores files constituting the Web site in a directory having a site name input by the user and a directory name input by the user. I do.

As described above with reference to FIGS. 1 to 8, in the Web site construction system and method of this embodiment,
The definition and construction of the b-site can all be performed through the GUI, and the creation of the Web site and the creation of the HTML page constituting the Web site can be performed without programming.

As a result, even a user who lacks knowledge about a database, programming technology, and HTML, can easily link a Web with a database.
It is possible to build a site.

The present invention is not limited to the examples described with reference to FIGS. 1 to 8, and can be variously modified without departing from the gist thereof. For example, the Web site construction tool 11, the page design tool 12, and the CGI program 15 described in the present embodiment are installed from a recording medium such as a CD-ROM, but other computers connected to the server machine 2 via a network. You can also load the program from.

[0045]

According to the present invention, it is possible to construct and maintain a Web site in which a WWW server and a database are linked, even if the user does not have knowledge about a database, programming technology, and HTML. , W linked with such a database
Efficient operation of the web site becomes possible.

[Brief description of the drawings]

FIG. 1 is a block diagram showing one embodiment of a configuration according to the present invention of a Web site construction system of the present invention.

FIG. 2 is an explanatory diagram showing a processing operation example of a Web site construction tool in FIG. 1;

FIG. 3 is an explanatory diagram illustrating an example of a processing operation of a page design tool in FIG. 1;

FIG. 4 is a flowchart showing an example of a processing operation according to the present invention of the Web site construction system in FIG. 1;

FIG. 5 is an explanatory diagram showing a first GUI screen example displayed by the website construction tool in FIG. 1;

FIG. 6 is an explanatory diagram showing a second GUI screen example displayed by the website construction tool in FIG. 1;

FIG. 7 is an explanatory diagram showing a third GUI screen example displayed by the website construction tool in FIG. 1;

FIG. 8 is an explanatory diagram showing a fourth GUI screen example displayed by the website construction tool in FIG. 1;

[Explanation of symbols]

1: User, 2: Server machine, 3: Client machine, 10: Existing database, 11: Web site construction tool, 11a to 11c: GUI screen (Web site construction tool), 12: Page design tool, 12a, 1
2b: GUI screen (page design tool), 13: H
TML file, 14: site information file, 15: C
GI program, 16: WWW server program, 1
7: WWW browser.

Claims (7)

[Claims] 1. A system for constructing a Web site in which a WWW (World Wide Web) and an RBD (Relational Database) are linked, and a reference, update, addition, and deletion of the RDB is performed by an operation from a WWW browser. On the basis of the interactive operation with the user by the GUI, based on the interactive operation with the user, the Web site construction means for creating the information specifying the RDB and the table in the RDB and storing the information in the site information file;
Web page design means for creating a Web page file to be displayed on the WWW browser and embedding DB information for specifying the RDB table to be operated from the WWW browser in the Web page file; It is started from the Web server program accessed from the WWW browser, and the Web server
The DB information embedded in the page file is detected, the RDB table specified by the DB information is accessed, and the R request from the WWW browser is made.
CGI program processing means for performing processing on the DB table, and referencing, updating, adding, and deleting the RDB by operation from the WWW browser
A Web site construction system for constructing a site b based on an interactive operation with a user using a GUI. 2. The Web site construction system according to claim 1, wherein said Web site construction means comprises:
A site type setting GUI screen that allows the user to select whether to set the processing of the RDB table requested by the W browser to reference or update;
The above RDB set as an operation target from the WW browser
RDB setting GU that displays the candidate counties and allows the user to select
I screen, a login setting GUI screen for allowing a user to enter a user account name and a password set to log in to the RDB to be operated, and a candidate group in the RDB table to be set as an operation target from the WWW browser. Table setting G to be displayed and selected by the user
A UI screen, a related table setting GUI screen that allows the user to set a table related to the table set on the table setting GUI screen, and a directory setting GUI screen that allows the user to set the name of the Web site to be built and the storage destination directory name. Web site construction system characterized by having. 3. The Web site construction system according to claim 1, wherein the W
The web page design means includes a first window for displaying a group of tables of the RDB that are candidates for an operation target from the WWW browser, and a second window for displaying a table of the RDB determined as an operation target from the WWW browser. The user can drag and drop the table group displayed in the first window to the second window to set the RDB table that is a candidate for operation from the WWW browser. A web site construction system having a table setting GUI screen for allowing the user to make a setting. 4. A system for linking a WWW (World Wide Web) and an RBD (relational database) and operating a WWW browser to construct a Web site for referencing, updating, adding, and deleting the RDB.
a web site building method for creating information for specifying the RDB and a table in the RDB based on an interactive operation with the user using a GUI and storing the information in a site information file; Based on the interactive operation with the Web server, a Web page file to be displayed on the WWW browser is created, and DB information for specifying the RDB table to be operated from the WWW browser is stored in the Web page file. Web page design creation step to embed,
The Web server program accessed from the WWW browser is activated, detects the DB information embedded in the Web page file, accesses the RDB table specified by the DB information, and executes the WWW. A CGI processing step of performing a process on the table of the RDB requested by the browser, and referring to the RDB by an operation from the WWW browser;
A website construction method for constructing a website to be updated, added, or deleted based on a GUI interactive operation with a user. 5. The Web site construction method according to claim 4, wherein the Web site construction step comprises:
A process for the RDB table requested by the W browser is displayed based on a selection operation from the user by displaying a site type setting GUI screen that allows the user to select whether to set the process of the RDB table to reference or update. And displaying the RDB setting GUI screen for allowing the user to select and display the candidate group of the RDB to be set as an operation target from the WWW browser and to perform a selection operation from the user. Setting an RDB to be operated from the WWW browser based on the
Displays a login setting GUI screen that allows the user to enter the user account name and password to be set to log in to the server, and sets the user account name and password to log in to the RDB to be operated based on the input operation from the user And a table setting GU for displaying a candidate group of the table of the RDB set as an operation target from the WWW browser and allowing the user to select the group.
Displaying an I screen and setting a table to be operated from the WWW browser based on a selection operation from the user; and setting a table related to the table set via the table setting GUI screen to the user Displaying a related table setting GUI screen to set a table related to a table to be operated from the WWW browser based on a setting operation by a user; and setting a name of a Web site to be constructed and a storage destination directory name. Displaying a directory setting GUI screen to be set by the user and setting the name of the web site to be built and the storage directory name based on the setting operation from the user. 6. The Web site construction method according to claim 4, wherein the Web site
The page design creating step includes a first window for displaying a group of tables of the RDB that are candidates for an operation target from the WWW browser, and a second window for displaying a table of the RDB determined as an operation target from the WWW browser. 2 displays a table setting GUI screen including windows and allows the user to drag and drop the table group displayed in the first window to the second window, and to operate the candidate from the WWW browser. A step of setting a table of the RDB as follows. 7. A recording medium for recording a program and data readable by a computer, wherein the recording medium is a computer readable recording medium.
A recording medium on which a program for causing a computer to execute the processing of each step according to any one of claims 1 to 6 is recorded.