TW201525737A - Method for automatically generating website interactive program - Google Patents

Abstract

A website interactive program comprises web form programs and web service programs. After the tables of a database are created, a developer needs to write interactive programs which are able to handle the data create, read, update, and delete (CRUD in short). Taking a web form program as an example, a form includes an input interface required by a data sheet for filling data in the fields. Furthermore, the data is received by a back-end program after being sent out and written in the corresponding fields of the data sheet. The development process is quite laborious and complicated. Therefore, the objective of the invention is to generate an interactive program capable of operating the CRUD for the database automatically, obtain the field names and the properties provided by the Metadata of the data sheet through a core method, and then generate required web forms and back-end processing programs through programming languages to reduce the development time significantly.

Description

Interactive web page program automatic generation method

The invention relates to an automatic generation method of an interactive webpage program, in particular to a meta-data using an associated database to obtain attribute data, so that it is a programmer, a web developer, a planner, or a web. The road administrator only needs to establish the data table of the database, and the web page form and the back-end processing program of the Internet can be easily established in a very short time by the automatic generation method of the interactive webpage program of the present invention. In order to greatly reduce the development time required by the website.

Generally speaking, the information service industry of enterprises, especially small and medium-sized enterprises, usually adopts an outsourcing project because of the low degree of e-business. In the work of building a website, in order to achieve overall efficiency and expect to meet professional standards. The method of development; however, for the increasingly complex, highly competitive, rapid changes in commodity services, immediacy and resilience are often the key to the success of businesses in the virtual space of the Internet. Information service providers must plan and develop It is possible to quickly build an electronic platform to achieve a smooth integration and application of the electronic industry. Therefore, if each page revision must be contracted out, it will not only increase the operating cost, but also spend time on the discussion and communication of webpage construction.

Furthermore, web developers currently have a web page editing system that can link to a database. The webpage provides the function of linking the database system to query the data, and the user can link and query the database through a general web browser, thereby avoiding the need to install and use a specific software; and the traditional webpage editing system capable of linking the database A webpage editing module will be provided. The webpage developer can use the webpage editing interface to launch the link database module, send out the qualification requirements for reading the database, link to the database, and after the authority authentication process, read and display one or The content of multiple databases, the web developer then selects various materials and edits them. The editing system will present the data to the webpage in the form of tables, charts or other types according to various settings; When the library's webpage is used, the work of generating the dynamic link function of the data is very complicated: in general, the rule instructions for passing variables between the data of the database are defined first, and then the link must be dynamically added to the data when the webpage queries the data. At the same time, it is necessary to create a web page that can dynamically accept the link for processing and update the data; The coding or editing tools used lack corresponding functions, such as providing rules for defining the collection link, enabling the establishment, transmission and reception of links to be carried out according to certain standards, and embedding the code in the web page to make the webpage The server can perform various tasks with the received parameters; therefore, the above work must be performed by the person familiar with the web programming language and the database, and the program code editing and web page code editing; please refer to the Republic of China Invention Patent Announcement No. 507142 The "Modular Webpage Editing and Instant Conversion Webpage Display System and Method" disclosed by the number, which provides a system and method for webpage editing and display on the Internet, so that the webpage editor of the merchant is beautiful The editor can download the modular file from the server host to create and edit the schematic webpage, and upload and store it on the server host. However, since the database is built into the server host, the data input is enabled. Is limited to the website architecture set by the server program, and is intended to be made with complex query functions. Page is also a very difficult task.

At present, the editing software for website pages includes, for example, Microsoft's Front Page, Visual Studio, and Adobe's Dreamweaver, which require relevant operations and programming knowledge, so not everyone can skillfully edit web pages; When editing a web page, each web page page is generated by the designer from the existing file data, so the traditional web page editing is quite time consuming; for example, the general website interactive program development includes the web form and the web service program ( Web Service), after the developer establishes the data table of the database, the developer must write interactive programs that can handle adding, modifying, deleting, and querying. For example, the web form program contains a required input field for the data table. The input interface of the data, and received by the backend program after sending and writing the data to the corresponding field in the data table, the development process is quite cumbersome; in addition, the development of the entire website application system contains no less than a thousand programs in it. If you can't provide convenient maintenance and generate bug-free code, developers will be debugging And the energy and time of maintenance will be several times that of the development system, so the development process of the company's website often fails to meet the needs in the shortest time and with the growth pace.

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 an automatic generation method of an interactive webpage program, in particular to a field name and its attribute provided by an interpretation data of an associated database, and then immediately generate a desired webpage form and a subsequent language through the programming language. End-processing program, with an interactive program for adding, modifying, deleting, and querying the operational database, so as to avoid the editor of the webpage editing system developer when making a webpage with a data dynamic link function. Quickly and automatically generate webpage forms, so that web developers do not have to construct a connection database program line by line, and can generate webpage forms for accessing and updating instantness functions in the quickest and simplest way.

In order to achieve the above-mentioned implementation, the inventor proposes an automatic method for generating an interactive webpage program, which is applicable to a webpage editing system having an associated database, and the method includes the following steps: the webpage developer establishes an attribute data file of the associated database. The attribute data file includes at least one attribute data; then, the attribute data of the associated database is used to obtain the attribute data, and a plurality of webpage code files are created by a program that can access the associated database; and finally, the plurality of webpage programs are The code file can generate corresponding static or dynamic web form and web service program in the webpage editing system; thereby, using the interpret data of the associated database to obtain the attribute data can reduce the webpage editing system developer to make a connection to The database has the editing work when the data is dynamically linked to the function page, and provides the function of efficiently editing the webpage components and links, thereby creating a webpage form that is convenient for the webpage user to use.

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 relational database may be SQL Server, MySQL, DB2, or Oracle, and the program that can access the associated database includes a compiler and an interpreter program.

(1) ‧‧‧Web page editing system

(11)‧‧‧Related database

(111)‧‧‧Attribute data files

(1111) ‧ ‧ Attribute data

(12) ‧ ‧ Interpretation data

(13)‧‧‧Programs that can access the associated database

(14)‧‧‧Webpage code file

(15)‧‧‧Web form

(16)‧‧‧Internet Service Program

(2) ‧ ‧ web developers

(S1)‧‧‧Step one

(S2)‧‧‧Step 2

(S3) ‧ ‧ Step 3

The first figure: the flow chart of the steps of the preferred embodiment of the interactive webpage program automatic generation method of the present invention

The second figure: a block diagram of a webpage editing system suitable for the automatic generation method of the interactive webpage program of the present invention

The third figure: the computerized image of the associated database interface of the present invention

The fourth figure: a schematic diagram of the webpage presented by the webpage form of the present invention on the front desk website

Figure 5: Schematic diagram of the web page presented in the background management system after the web form input of the present invention is completed

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, the interactive webpage program automatic generation method of the present invention is applicable to a webpage editing system (1) having an associated database (11), wherein the webpage editing system (1) can be a webpage of a conventional webpage editing module. The editing system, the web developer (2) can select various materials and edit them, and the webpage editing system (1) presents the data to the webpage in the form of a table, a chart or other type representation according to various settings, and the association The database (11) may be, for example, but not limited to, one of SQL Server, MySQL, DB2, or Oracle. Please refer to the first and second figures, respectively, which are steps of a preferred embodiment of the method for automatically generating an interactive webpage program of the present invention. The flow chart and the block diagram of the webpage editing system applicable to the automatic generation method of the interactive webpage program of the present invention, the interactive webpage program automatic generation method comprises the following steps: Step 1: web developer (2) establish a related database (11) The attribute data file (111), the attribute data file (111) may be, for example, a generally well-known data table (Table), and the attribute data file (111) may include at least one attribute data (1111); Please refer to the third figure as a computer image image of the related database interface of the present invention, which can be directly reproduced and conforms to the drawings because it cannot be drawn by the ink drawing method according to the engineering drawing method. Other provisions are replaced by photographs according to the Patent Examination Benchmarks on pages 2-1-37; in addition, the attribute data (1111) may include, for example, a column name parameter (Column Name), a data type parameter (Datatype), and a column. Bit length parameter (value after data type parameter), primary key parameter (primary key, PK), non-no parameter (not null, NN), unique parameter (unique, UQ), binary parameter (binary, BIN) The unsigned (UN) parameter, the zero-fill parameter (zero fill, ZF), and the auto increment (AI) are applicable to the type of the data field; the above data type parameter can be An integer, a positive integer is only an integer (TINYINT) of 255, a character (VARCHAR), a timestamp (TIMESTAMP), etc.; in this embodiment, the field name parameters are idzNanE, Name, Email, Topic, Content, Sex , CreateDate, C1, and C2, and the idzNanE field name The parameter is the data type of INT, and is applicable to the primary key parameter, the non-no parameter, and the automatic addition number parameter; and we should understand that the above-mentioned field name parameters are for convenience of description, and are not limited to the examples. Therefore, the field name parameter of the specific embodiment is not limited; and it is noted here that the parameters listed in the above attribute data (1111) are knowledge known in the art, and are not the focus of the present invention. The detailed mechanism and the principle of the program action will not be described here. Step 2: Use the interpreter data (12) of the relational database (11) to obtain the attribute data (1111), and use the program that can access the associated database. (13) establishing a webpage code file (14) for operating, adding, deleting, and querying the associated database (11); wherein the program (13) for accessing the associated database may include a compiler And the interpreter program, and the compiler program can be, for example, C# language, JAVA language, etc., and the interpreter program For example, but not limited to PHP, JSP or ASP programs, etc.; further, the above-mentioned interpretation data (12) is used to describe data (Data about Data), refers to the content, format, structure, and usage of digital information. The description and description are used as a basis for the computer system to access and use the digital information, and the web developer (2) retrieves the appropriate attribute data (1111) of the related database (11) (for example: field name) In addition, the interpretation data (12) of the relational database (11) can also be replaced, for example, by a data source of a structured document (such as XML), that is, an associated database (11) record. Processing as a structured file, and then specifying the detailed data for the structured file to retrieve the attribute value; and Step 3: The multiple webpage code file (14) generated in Step 2 can be generated in the webpage editing system (1). a static or dynamic web form (15) and a web service program (16); wherein the web form (15) generally refers to a program with a user interface (UI), and the web service program (16) is via the web. Open standards for communication protocols and data formats ( Such as HyperText Transfer Protocol, HTTP, eXtensible Markup Language, XML and Simple Object Access Protocol, SOAP, etc. to provide services for other applications, so it can have good interoperability, can be easily integrated on different platforms; in this embodiment Taking the dynamic webpage form (15) as an example, as shown in the fourth figure, the webpage form of the present invention is presented on the front-end website, and it is worth noting that the webpage form (15) utilizes specific attribute data (1111). The parameter definition rule automatically generates the parameters required for the link to be efficiently edited, and provides a dynamic structured query language function, so that the web developer (2) can create a dynamic link function. Web page; in addition, the web form (15) supports a standard browser, and the standard browser format is selected from ASP.NET, ASP, JSP, PHP, CFM, Word, Excel, and Windows Form. The group formed.

In addition, after the user fills in the page form (15) before the fourth picture and executes the delivery, the input data is sent to another program for processing. The program first receives the data and establishes a database with the associated database (11). After the line, specify the type of the input data and write it to the specified field. The code is as follows: Driver DriverRecordset1 = (Driver)Class.forName(MM_DRIVER).newInstance(); Connection ConnRecordset1 = DriverManager.getConnection(MM_STRING,MM_USERNAME,MM_PASSW ORD); String sql = "insert into znane (Name,Email,Topic,Content,Sex,CreateDate,C1,C2,isChecked,LanguageID) values (?,?,?,?, ?,?,?,?,?,?)"; String Name = request.getParameter("Name"); String Email = request.getParameter("Email"); String Topic = request.getParameter("Topic"); String Content = request.getParameter("Content"); String Sex = request.getParameter("Sex"); String CreateDate = request.getParameter("CreateDate"); String C1 = request.getParameter("C1"); String C2 = request.getParameter("C2 "); String isChecked = request.getParameter("isChecked"); String LanguageID = request.getParameter("LanguageID"); java.util.Date date= new java.util.Date(); Timestamp timestamp1 = new Timestamp(date.getTime()); PreparedStatement preparedStatement1 = ConnRecordset1.prepareStatement(sql); //Set the data into the prepare statement preparedStatement1. setString(1, !Name.equa1s("")?Name: ""); preparedStatement1.setString(2, !Emai1.equa1s("")?Email: ""); preparedStatement1.setString(3, !Topic.equals ("")?Topic: ""); preparedStatement1.setString(4, !Content.equa1s("")?Content: ""); preparedStatement1.setInt(5, Sex != null?1 : 0); preparedStatement1. setTimestamp(6, timestamp1); preparedStatement1.setString(7, !C1.equals("")?C1: ""); preparedStatement1.setString(8, !C2.equals("")?C2: ""); preparedStatement1 .setInt(9, isChecked != null?1 : 0); preparedStatement1.setInt(10, !LanguageID.equals("")?Integer.parseInt(LanguageID): 0); preparedStatement1.executeUpdate(); ConnRecordset1.close( In this way, the background management system can present a schematic diagram of the webpage as shown in the fifth figure, wherein the background webpage has a new Modify, delete and query functions, for example, you can type the corresponding data field four times before the phone is typed in the query field. If the process is completed in a conventional way, when there are many data tables and fields At the time, the process of writing a program is bound to be quite cumbersome.

In addition, as described above, the interactive web page program automatic generation method of the present invention can be applied to hardware or software, where appropriate, or a combination thereof, and thus some aspects or portions thereof may be embedded in actual media. a code (ie, a command), such as a floppy disk, a CD player, a hard disk drive, or any other machine readable storage medium, wherein the machine is loaded and executed by a machine (eg, a computer) It will become a device for carrying out the invention, and in the case where the code is executed in a programmable computer, the computer device usually comprises a processor, a processor-readable storage medium (including volatile or non-volatile a memory and/or storage element), at least one input device, and at least one output device.

It can be seen from the above description that the interactive webpage program automatic generation method of the present invention has the following advantages compared with the prior art:

1. The automatic generation method of the interactive webpage program of the present invention utilizes the metadata of the associated database to obtain the attribute data, which can reduce the webpage editing system developer to make a webpage with the data dynamic link function connected to the database. The editing work of the time provides efficient editing of web components and links, and then creates web forms that are easy for web users to use.

2. The automatic generation method of the interactive webpage program of the invention can quickly and automatically generate the webpage code file of the webpage form by using the simple attribute data setting, so that the webpage developer does not have to work hard to write the program line by line or one by one form field. By constructing a database structure, the web application source code and database for instant access and update functions can be generated in the most rapid and simple manner, which simplifies the development process and website of web developers and programmers. Significantly reduce R&D costs and increase product competitiveness.

In summary, the automatic generation method of the interactive webpage program of the present invention can indeed With the embodiments disclosed above, the intended use efficiency is achieved, and the present invention has not been disclosed before the application, and the company 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.

The illustrations and descriptions of the present invention are merely preferred embodiments of the present invention, and are not intended to limit the scope of the present invention; those skilled in the art, which are characterized by the scope of the present invention, Equivalent variations or modifications are considered to be within the scope of the design of the invention.

(1) ‧‧‧Web page editing system

(11)‧‧‧Related database

(111)‧‧‧Attribute data files

(1111) ‧ ‧ Attribute data

(12) ‧ ‧ Interpretation data

(13)‧‧‧Programs that can access the associated database

(14)‧‧‧Webpage code file

(15)‧‧‧Web form

(16)‧‧‧Internet Service Program

(2) ‧ ‧ web developers

Claims (5)

An interactive webpage program automatic generation method is applicable to a webpage editing system with an associated database. The automatic webpage program automatic generation method comprises the following steps: Step 1: The webpage developer establishes the attribute data file of the related database. The attribute data file includes at least one attribute data; step 2: obtaining the attribute data by using the metadata of the relational database, and establishing a program by accessing the associated database to operate the association The new, modified, deleted and queried web code files of the database; and step 3: the webpage code files are generated in the webpage editing system to generate corresponding static or dynamic webpage forms, and web service programs. For example, the interactive webpage automatic generation method described in claim 1 is one of SQL Server, MySQL, DB2 or Oracle. The method for automatically generating an interactive webpage program according to the first aspect of the patent application, wherein the program for accessing the associated database includes a compiler and an interpreter program. The method for automatically generating an interactive webpage program according to claim 1, wherein the attribute data includes a field name parameter, a field length parameter, a data type parameter, a primary key parameter, a non-parameter, and a unique Parameters, two-bit parameters, unsigned parameters, zero-fill parameters, and auto-enlargement parameters. The method for automatically generating an interactive webpage program according to claim 1, wherein the webpage form supports a standard browser, and the format of the standard browser is selected from ASP.NET, ASP, JSP, PHP. A group of CFM, Word, Excel, and Windows Forms.