TW201545046A - Method for automatically generate fields of drop-down menu by foreign keys corresponding to data sheet - Google Patents

Abstract

For making a drop-down menu on current web forms, web developers must set options by themselves. Each option is given a different code for the purpose of program interpretation. It's troublesome for web developers to memorize options and codes when there are multiple options. Accordingly, by utilizing the relationship between foreign keys and a data sheet and a main data sheet in the present invention, web developers only need to newly add or revise the contents of the correspondence table through a rapidest and simplest way to automatically generate web page program codes which the foreign keys correspond to the data sheet. Furthermore, the attribute data of the foreign keys is shown in the form of a drop-down menu. Thereby programmers' development process and timelines can be optimized.

Description

Method for automatically generating a drop-down form field from a foreign key mapping data table

The invention relates to a method for automatically generating a drop-down form field in a foreign key mapping data table, in particular to establishing an association between a foreign key mapping data table and a master data table, so that the web developer only needs to add or By modifying the content on the corresponding relationship table, the webpage code of the foreign key mapping data table can be automatically generated in the fastest and simple manner, and the foreign key attribute data is presented in the pull-down menu to quickly develop the webpage. The form's application.

Different companies have different needs for web forms. The editing software for website pages currently has such things as Microsoft's Front Page, Visual Studio, and Adobe's Dreamweaver. It requires relevant operations and programming knowledge, so not everyone. All of them can be skillfully edited on the webpage. When editing a webpage, each webpage page is generated by the designer from the existing archives. Therefore, the traditional webpage editing is quite time consuming, and the average person does not use or write the hypertext markup. Language (HTML) training; for example, the general website interactive program development includes a web form and a web service program. After the developer establishes the data sheet of the database, the developer must write to handle the addition and modification. An interactive program such as deletion and query; taking a web form program as an example, the form contains an input interface for inputting field data of a data table, and is sent by the backend program after being sent and written into the data table. The development process is not only cumbersome, but the length of the form field on the front end is often not Closing the rear end of the corresponding data table field length, resulting in part of the input data is lost or can not write to the table of the case occurred.

In addition, at present, when creating a webpage linking the database, the work of generating the dynamic link function of the data is very complicated: generally, the rule instruction for transferring variables between the data of the database is first defined, and then the data must be queried on the webpage. Dynamically attach a link to the data, and at the same time create a web page that can dynamically accept the link for processing and update the data; however, the commonly used encoding or editing tools lack corresponding functions, such as: providing rules for defining the collection link, enabling the establishment The transmission and reception links can be carried out according to certain standards, and the code is embedded in the webpage, so that the server end of the webpage can perform various tasks along with the received parameters; therefore, the above work must be familiar with the webpage programming language. Work with the relevant persons of the database for program coding and web code editing; please refer to the "Modular Web Page Editing and Instant Conversion Web Display System and Method" disclosed in the Republic of China Invention Patent Notice No. 507142. Provide a system and method for web page editing and display on the Internet The method enables the web page editor or the beauty editor of the merchant to download the modular file on the server host to create and edit the schematic webpage, and upload and store it on the server host after completion; however, since the database is already Built on the server host, the input of the data is limited to the website structure set by the server program, and the existing form field cannot dynamically set the required column length, field check rule, input. The related settings of the fields such as the prompt message, the web page editor must write a program for each form field, and increase the development process and schedule of the website developer and the programmer; in addition, generally, the pull-down menu is created in the web form. Web developers must set their own options, and each option requires different code for the program to interpret, causing web developers to remember these options and their code when making drop-down menus. When it comes to memory, it is trouble.

Nowadays, the inventor is in view of the many shortcomings in the above-mentioned webpage development method, so it is a tireless spirit, and it is improved by its rich professional knowledge and years of practical experience. The present invention has been made.

The main purpose of the present invention is to provide a method for automatically generating a drop-down form field in a foreign key mapping data table, in particular to establish a correlation between a foreign key mapping data table and a master data table, so that the web developer only needs new By adding or modifying the content on the corresponding relationship table, the webpage code of the foreign key mapping data table can be automatically generated in the quickest and simple manner, and the foreign key attribute data is presented in the pull-down menu, thereby solving the problem. Traditional web developers need to refine the options and their code memory when making drop-down menus to further optimize the programmer's development process.

In order to achieve the above-mentioned implementation purpose, the inventors propose a method for automatically generating a drop-down form field by a foreign key mapping data table, which is applicable to a webpage editing system with an associated database, and the method includes: a web developer Firstly, a master data table of the associated database is established. The master data table includes at least one field name parameter corresponding to the field of the form; then, a foreign key mapping data table is established, and the foreign key mapping data table includes a corresponding drop-down form. Field key attribute data, foreign key attribute data is composed of number, display name, and encoding three field name parameters; then establish the corresponding relationship table of the three field name parameters of the foreign key attribute data; The field name parameter establishes an association between the foreign key mapping data table and the main data table, wherein the main data table includes the field name parameter of the number; finally, the data is interpreted by the database of the associated database to obtain the import key value. Make any data item in the associated database accessible through the primary key data table name in the import key The foreign key data table name, the primary key row name, and the foreign key row name are accessed, and the webpage code file corresponding to the master data table and the foreign key mapping data table is created by the program that can access the associated database, and the webpage program The code file can generate a corresponding static or dynamic drop-down form field in the webpage editing system.

In an embodiment of the present invention, the attribute data may include a field name parameter, a field length parameter, a data type parameter, a primary key parameter, a non-parameter, a unique parameter, a binary parameter, and an unsigned sign. Parameters, zero-fill parameters, and auto-enlargement parameters.

In an embodiment of the present invention, the associated database may be one of SQL Server, MySQL, DB2, or Oracle; and the program that can access the associated database includes a compiler and an interpreter program.

The object of the present invention and its structural design and advantages will be apparent from the following detailed description of the preferred embodiments.

First of all, in order to better understand the present invention, the basic concept of foreign key (FK) will be briefly explained first. The foreign key in the database is used to link other data tables, if a certain data table The field must be compared to the primary key in the data sheet to make the value of the field meaningful. We call this field the foreign key of the data sheet. The purpose is to determine the reference integrity of the data. Integrity); In the relational database (1), the relationship between the data tables is established by external keys. For example, suppose we have two tables: a "customer" data sheet, which records All customer information; another "order" data sheet, which records all customer orders, when all the customers in the order information must be in the "customer" data sheet, we will be in the "order" A foreign key is set in the data table, and the foreign key is a primary key in the "customer" data table, so that all the items in the "order" data table can be determined. Off there "customer" data sheet. Next, please refer to the first and second figures, which are respectively a flow chart of the steps of the method of the present invention, and a block diagram of a webpage editing system suitable for the method of the present invention. The external key mapping data table of the present invention automatically generates a pull-down form. The method of the field is applicable to a webpage editing system (A) having an associated database (1), wherein the webpage editing system (A) can be a webpage editing system (A) of a webpage editing module, a webpage The developer (B) can select various materials and edit them. The webpage editing system (A) can present the data to the webpage in the form of tables, charts or other types according to various settings, and the related database (1) For example, but not limited to, one of SQL Server, MySQL, DB2, or Oracle, the method steps of the present invention include:

Step 1 (S1): The web developer (B) establishes a master data table (11) of the associated database (1), and the master data table (11) includes at least one field name parameter corresponding to the form field (16) ( 111); Among them, the specific method for establishing the master data sheet (11) can refer to the invention patent application number 102149379, "Automatic generation method of interactive webpage program" and the first inventor of the present invention on December 31, 102 102149383 "Method for generating form verification program and corresponding form interface from dataset interpretation data"; as it is not the focus of this case, it will not be described in detail here, and all its contents are included herein for reference;

Step 2 (S2): Establish a foreign key mapping data table (12), and the foreign key mapping data table (12) includes a corresponding key attribute data (121) corresponding to the pull-down form field (17), and the foreign key attribute data. (121) is composed of number (1211), display name (1212), and code (1213) three column name parameters (Column Name); please refer to the third figure together, which is the external key pair of the present invention. The computerized image image of the data sheet must be described here. The drawings of the third to seventh figures of this specification are in the case where the drawing method can not be drawn by the ink drawing method with reference to the engineering drawing method, and can directly reproduce and conform to the drawing. Other applicable regulations are replaced by photographs according to the Patent Examination Benchmarks, pp. 2-137. In addition, the above-mentioned foreign key attribute data (121) further includes a data type parameter (Datatype) and a field length parameter (data). The value after the type parameter), a primary key parameter (primary key, PK), non-no parameter (not null, NN), unique parameter (unique, U Q), binary parameter (BIN), unsigned parameter (unsigned, UN), zero fill parameter (zero fill, ZF), and auto increment (AI) are applicable to the data field. The data type parameter can be an integer, a positive integer only to 255 integer (TINYINT), a character (VARCHAR), etc.; in the specific embodiment, the number (1211), display name (1212) ), and the code (1213) field name parameters are respectively LanguageID, LanguageName, and LanguageEncode; and we should understand that the above-mentioned field name parameter (111) is for convenience of description, and not limited to this example, This does not limit the field name parameters of the specific embodiment;

Step 3 (S3): Establish a correspondence table (13) of the foreign key attribute data (121) number (1211), display name (1212), and code (1213) field name parameter; for the specific implementation manner, refer to The four figures show the correspondence table of the three field name parameters of the foreign key attribute data of the present invention; further, when the number (1211) field name parameter LanguageID is "1", in the pull-down menu. The display name (1212) LanguageName is "Traditional Chinese", and the encoding (1213) field name parameter LanguageEncode is "zh-TW", and so on;

Step 4 (S4): The association between the foreign key mapping data table (12) and the main data table (11) is established by the field name parameter of the number (1211), wherein the main data table (11) must include the number (1211). The column name parameter; please refer to the fifth and sixth figures respectively, which is a schematic diagram of the computerized image of the main data table and the foreign key mapping data table of the present invention, and the webpage editing system establishes the number in the main data table. The field name is a computerized image of the foreign key;

Step 5 (S5): Finally, use the database metadata of the relational database (1) to obtain import keys, so that any data items in the relational database (1) can be Access through the primary key data sheet name (PK Table Name), foreign key data sheet name (FK Table Name), primary key row name (PK Column Name), and foreign key row name (FK Column Name) in the import key value. And the webpage code file (15) corresponding to the master data table (11) and the foreign key mapping data table (12) is created by the program (14) that can access the associated database, and the webpage code file (15) is A corresponding static or dynamic pull-down form field (17) can be generated in the webpage editing system (A); wherein the above-mentioned interpretation data refers to data used to describe the data (Data about Data), which refers to digital information. Description and description of the content, format, structure, usage, etc., as the basis for the computer system to access and use the digital information, by the web developer (B) Correspond to the associated database (1) appropriate foreign key attribute data (121) (for example: number (1211), display name (1212), code (1213), etc.); in addition, the interpretation of the relational database (1) The data can also be replaced, for example, by a data source of a structured document (such as XML), that is, the associated database (1) records are processed as structured files, and detailed data is specified for the structured files to retrieve attribute values; The program (14) for accessing the associated database may include a compiler and an interpreter program, and the compiler program may be, for example, a C# language, a JAVA language, etc., and the interpreter program may be, for example but not limited to, PHP, JSP. Or ASP program, etc.; the computer image of the front-end website is shown in the seventh figure. When the user clicks or the mouse moves to the drop-down form field (17), a display "Traditional Chinese, Simplified Chinese" will pop up. Chinese, Japanese, English, and Korean" windows; accordingly, the method of automatically generating a drop-down form field by the external key mapping data table of the present invention can be the fastest and simplest The way to generate the program source code of the drop-down form field (17), to solve the trouble of the traditional website developers in the production of the drop-down menu, the option of the menu and its code memory, further optimize the programmer's development process Timely process; it is worth noting that the pull-down form field (17) of the present invention can also be represented by a check box or a radio button on the front-end website, and the computer-imported webpage diagrams are respectively eighth. In the nine figures, the checkbox can select more than one at the same time, and the option button can only select one at a time.

In addition, as described above, the method of automatically generating a pull-down form field in the foreign key mapping data table of the present invention may be applied to a hardware or a soft body, a suitable place or a combination thereof, and thus the method of the present invention, some viewpoints Or part of it may be a code (ie, a command) embedded in actual media, such as a floppy disk, a CD player, a hard disk drive, or any other machine readable storage medium, where the code is used by a machine (eg, a computer) When loaded and executed, the machine becomes a device for performing the present invention, and in the case where the code is executed in a programmable computer, the computer device typically includes a processor, a processor readable storage A medium (including volatile or non-volatile memory and/or storage elements), at least one input device, and at least one output device.

In summary, the method for automatically generating a pull-down form field in the foreign key mapping data table of the present invention can achieve the intended use efficiency by the above disclosed embodiments, and the present invention has not been disclosed in Before applying, Cheng has fully complied with the requirements and requirements of the Patent Law.爰Issuing an application for a patent for invention in accordance with the law, and asking for a review, and granting a patent, is truly sensible.

(A) ‧‧‧Web page editing system

(1)‧‧‧Related database

(11) ‧‧‧ Master Data Sheet

(111)‧‧‧Field name parameters

(12) ‧‧‧ Foreign key mapping data sheet

(121)‧‧‧ Foreign key attribute data

(1211)‧‧‧No.

(1212)‧‧‧ Display name

(1213) ‧ ‧ code

(13) ‧‧‧ correspondence table

(14) ‧‧‧Programs for accessing relational databases

(15)‧‧‧Webpage code file

(16)‧‧‧Form field

(17)‧‧‧Drawdown form field

(18) ‧ ‧ Database Interpretation Information

(181)‧‧‧ Import key values

(B) ‧ ‧ web developers

(S1)‧‧‧Step one

(S2)‧‧‧Step 2

(S3) ‧ ‧ Step 3

(S4)‧‧‧Step four

(S5) ‧ ‧ step five

The first figure: a flow chart of the method steps for automatically generating a drop-down form field in the foreign key mapping data table of the present invention

Second Figure: Block diagram of a web page editing system suitable for use in the method of the present invention

The third figure: the computerized contrast image of the external key mapping data of the present invention

The fourth figure: the correspondence table of the three field name parameters of the foreign key attribute data of the present invention

Figure 5: Schematic diagram of computer angiography image associated with the main data table of the present invention and the foreign key mapping data table

Figure 6: The computer image of the invention is created in the main page of the webpage editing system.

Figure 7: Schematic diagram of a computer angiography page that presents a drop-down form field on the front-end website by the method of the present invention

The eighth figure: a computer illuminating webpage diagram showing a drop-down form field on the front-end website by using the method of the present invention

Ninth diagram: a computer illuminating webpage diagram showing a drop-down form field with an option button on the foreground website by the method of the present invention

(A) ‧‧‧Web page editing system

(1)‧‧‧Related database

(11) ‧‧‧ Master Data Sheet

(111)‧‧‧Field name parameters

(12) ‧‧‧ Foreign key mapping data sheet

(121)‧‧‧ Foreign key attribute data

(13) ‧‧‧ correspondence table

(14) ‧‧‧Programs for accessing relational databases

(15)‧‧‧Webpage code file

(16)‧‧‧Form field

(17)‧‧‧Drawdown form field

(18) ‧ ‧ Database Interpretation Information

(181)‧‧‧ Import key values

(B) ‧ ‧ web developers

Claims (3)

A method for automatically generating a drop-down form field by a foreign key mapping data table is applicable to a webpage editing system with an associated database, and the method comprises the following steps: Step 1: The web developer establishes the related database a master data table, the master data table includes at least one field name parameter corresponding to the form field; Step 2: establishing a foreign key mapping data table, the foreign key mapping data table includes a corresponding pull-down form field The key attribute data, the foreign key attribute data is composed of the number, the display name, and the encoding three field name parameters; Step 3: establishing a correspondence table of the three field name parameters of the foreign key attribute data; Step 4: The field name parameter of the number establishes the association of the foreign key mapping data table with the master data table, wherein the master data table includes a field name parameter of the number; and step 5: using the database of the relational database The interpretation data is obtained by importing the key value, and the corresponding master data table and the foreign key pair are established by a program that can access the associated database. The webpage code file of the data table, the webpage code file is generated in the webpage editing system to generate a corresponding static or dynamic drop-down form field. The method for automatically generating a drop-down form field in the key mapping data table as described in claim 1 of the patent application scope, wherein the relational database is one of SQL Server, MySQL, DB2 or Oracle. The method for automatically generating a drop-down form field in the foreign key mapping data table as described in claim 1 of the patent application scope, wherein the program for accessing the associated database includes a compiler and an interpreter program.