CN104881490A - WEB form data access method and system - Google Patents

Abstract

The invention discloses a WEB form data access method and system and relates to the technical field of data processing. According to an embodiment, the WEB form data access method and system are provided through opening of a user interface layer and integrating of object relationship mapping and a database access layer. With the adoption of the system, all that is required for a developer is to keep names of a Web page form field and a database field same; data operation of addition, deletion, modification and check of a WEB form can be realized by calling the method, further, data access is realized, excessive configuration is not required, and if configuration mistakes exist, a bottom layer of the system can intelligently correct the mistakes, and the system is stable and reliable; the required fields are controlled through a page, and the Web page layout can be randomly adjusted conveniently, flexible and efficiently.

Description

A method and system for accessing WEB form data

technical field

The invention relates to the technical field of data processing, in particular to a method and system for accessing WEB form data.

Background technique

Since the data in the WEB form changes dynamically, an excellent WEB form data access method has an important impact on the response rate of the background.

At present, the data access methods of WEB forms mainly include the following two methods: the first one is to first use ASP.NET Entity Formwork technology to realize the mapping and conversion of business objects to relational data, and then use Linq technology to generate SQL scripts to make WEB The page form data is bound to the DBContext data object to realize data access. However, since this method needs to establish a large number of data models and bind page fields one by one, there are performance and efficiency problems when there are a large number of form fields; the second method is based on ASP.NET single table collection technology , integrates Page UI, ORM and DB. For single-table operations, you only need to configure related table value type items in the database, which can quickly realize the addition, deletion, modification and query of single-table modules. Although this method can quickly realize the addition, deletion, modification and query of the single-table module, because the single-table collection requires complex configuration, when the user has individual UI requirements, this method cannot meet the user's special requirements for the UI.

Therefore, the prior art cannot guarantee both software quality and user satisfaction.

Contents of the invention

The object of the present invention is to provide a method and system for accessing WEB form data, thereby solving the aforementioned problems in the prior art.

In order to achieve the above object, the technical scheme adopted in the present invention is as follows:

A method for accessing WEB form data, comprising the steps of:

S1, the client obtains the WEB form data, and submits the WEB form data to the server;

S2, the server receives the WEB form data, and converts the WEB form data into the original key-value data set;

S3, verifying the original key-value data set to obtain a valid key-value data set;

S5, traversing the effective key-value data set, and automatically splicing the key-value data to generate an SQL statement according to the data manipulation mode;

S6. Execute the SQL statement and return the execution result to the client.

Preferably, in S1, the client obtains form data, including:

S101, in the HTML page, layout the WEB form control,

S102, using a WEB form control to set WEB form data;

S103, encapsulating the WEB form data through the WEB form data processor to obtain the encapsulated WEB form data;

S104, submitting the encapsulated WEB form data to the server.

Preferably, the name of the WEB form data is the same as the field name in the server database.

Preferably, S2 includes:

S201, the server stores the WEB form data submitted by the client into the object, and obtains the WEB form object;

S202. Convert the WEB form object into an original key-value data set.

Preferably, S3 includes the following steps:

S301. Parse the original key-value data set to obtain a primary key and/or an auto-increment field;

S302. Check the Keys according to the primary key and/or the auto-increment field to obtain a valid key-value data set.

More preferably, in S301, the parsing of the original key-value data set specifically includes: using the server-side database table SysColumns to obtain the primary key and/or auto-increment field of the original key-value data set.

More preferably, S302 is specifically: comparing the primary key and/or self-increment field of the original key-value data set with the primary key and/or self-increment field in the server database, if the original key exists in the server database The primary key and/or auto-increment field of the value data set, the key-value data is valid and stored in the valid key-value data set, otherwise, it is deleted.

Preferably, in S5, the data manipulation method includes querying, adding, modifying or deleting data.

Preferably, the automatic splicing of key-value data to generate SQL statements is specifically: using the parameterizable feature of T-SQL to automatically splice key-value data to generate SQL statements.

A WEB form data access system, comprising: a page layer, a logic layer and a data access layer, the page layer is located at the client, the logic layer and the data access layer are located at the server; the page layer is used For obtaining WEB form data and submitting WEB form data to the logic layer, and also for receiving and displaying the execution result of the SQL statement forwarded by the data access layer through the logic layer; the logic layer is used for receiving WEB form data , and convert the WEB form data into the original key-value data set, which is also used to send the original key-value data set to the data access layer, and is also used to forward the execution result of the SQL statement by the data access layer to the page layer ; The data access layer is used to receive the original key-value data set sent by the logic layer, and check the original key-value data set to obtain an effective key-value data set, and is also used to traverse the effective key-value data According to the data manipulation method, the key-value data is automatically spliced to generate SQL statements, which are also used to execute the SQL statements and forward the execution results to the page layer through the logic layer.

The beneficial effects of the present invention are: the embodiment of the present invention provides a method and system for accessing WEB form data by opening the user interface layer and integrating object-relational mapping and database access layer. The name of the page form field is the same as that of the database field. Calling this method can realize the data manipulation of adding, deleting, modifying and checking the WEB form, and then realize data access without too much configuration. If there is a configuration error, the bottom layer of the system will intelligently correct it. Wrong, making the system stable and reliable; and the required fields are controlled through the page, and the layout of the Web page can be adjusted at will, which is convenient, flexible and efficient.

Description of drawings

FIG. 1 is a schematic flow chart of a method for accessing WEB form data provided by Embodiment 1 of the present invention;

FIG. 2 is a schematic structural diagram of a WEB form data access system provided by Embodiment 2 of the present invention.

Detailed ways

In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be further described in detail below in conjunction with the accompanying drawings. It should be understood that the specific embodiments described here are only used to explain the present invention, and are not intended to limit the present invention.

Embodiment one

As shown in Figure 1, the embodiment of the present invention provides a kind of WEB form data access method, comprises the following steps:

S1, the client obtains the WEB form data, and submits the WEB form data to the server;

S2, the server receives the WEB form data, and converts the WEB form data into the original key-value data set;

S3, verifying the original key-value data set to obtain a valid key-value data set;

S5, traversing the effective key-value data set, and automatically splicing the key-value data to generate an SQL statement according to the data manipulation mode;

S6. Execute the SQL statement and return the execution result to the client.

Using the above method, the actual development process can be as follows:

The developer first layouts the form at the page level, keeping the name of the form control and the name of the database field the same. Call the key-value conversion method at the server-side logic layer, the input parameter is the form data object, and output the key-value dataset object; then call the underlying data manipulation method, the input parameter is the table name and the key-value dataset object, output the manipulation result, and The results are passed to the UI layer and finally fed back to the user.

In the embodiment of the present invention, in S1, the client obtains form data, including:

S101, in the HTML page, layout the WEB form control,

S102, using a WEB form control to set WEB form data;

S103, encapsulating the WEB form data through the WEB form data processor to obtain the encapsulated WEB form data;

S104, submitting the encapsulated WEB form data to the server.

Using the above method, the actual development process can be as follows:

Step 1, you can use HTML design tools for Web form layout, such as Dreamweaver, VisualStudio, etc.

Step 2, manually set the name of the form control to be the same as the name of the database field.

Step 3, form data encapsulation, you can use the automatic collection feature of HTML Form or use the jQueryForm framework to collect.

Step 4, complete data submission through the Submit method in JavaScript/jQuery.

In the embodiment of the present invention, the name of the WEB form data is the same as the field name in the server database.

Keeping the name of the WEB form data the same as the name of the database field is to establish the mapping relationship between the page data and the database field, so as to ensure that the underlying system can correctly identify the data item to be accessed, generate the correct SQL statement, and execute the correct result. If there is a large difference between the page data name and the database field name, the system will ignore it if it cannot recognize it, and the data in this field cannot be accessed correctly.

In the embodiment of the present invention, S2 includes:

S201, the server stores the WEB form data submitted by the client into the object, and obtains the WEB form object;

S202. Convert the WEB form object into an original key-value data set.

5. The WEB form data access method according to claim 1, characterized in that S3 comprises the following steps:

S301. Parse the original key-value data set to obtain a primary key and/or an auto-increment field;

S302. Check the Keys according to the primary key and/or the auto-increment field to obtain a valid key-value data set.

Using the above method, the actual development process can be as follows:

First, on the server side of the .NET framework, the WEB form object of the NameValueCollection dataset can be obtained through Request.Form.

Then, on the server side, by traversing the NameValueCollection dataset object, it is converted into an editable key-value dataset Dictionary<string, object>, and the data items in the key-value collection can be re-edited and corrected.

In the embodiment of the present invention, in S301, the parsing of the original key-value data set specifically includes: using the server-side database table SysColumns to obtain the primary key and/or auto-increment field of the original key-value data set.

The acquisition of the primary key and auto-increment field of the database table can be specified by the coder, or can be automatically detected by using SysColumns in the database. Compared with the former, the reliability and accuracy of the latter will be higher.

In the embodiment of the present invention, S302 is specifically: comparing the primary key and/or auto-increment field of the original key-value data set with the primary key and/or auto-increment field in the server database, if the server database exists the primary key and/or auto-increment field of the original key-value dataset, the key-value data is valid and stored in the valid key-value dataset, otherwise, delete it.

Comparing the original key set with the field set of the database table, eliminating invalid or unnecessary fields, is to improve the accuracy of the matching fields, avoid the interference of wrong or malicious key names, and improve the correctness of splicing SQL; also based on the primary key and The auto-increment field can determine whether the field needs to be preserved. For example, in the add/modify operation, auto-increment fields are not allowed in SQL, otherwise it will not be executed. The method can effectively improve the correctness of SQL splicing, avoid SQL injection attacks, and ensure the final correct execution result.

In the embodiment of the present invention, in S5, the data manipulation method includes querying, adding, modifying or deleting data.

Among them, in the query operation, you need to provide the table name, query condition key-value data set parameters; first, write the query prefix basic statement "SELECT*FROM{0}where 1=1", and then traverse the key-value data set to stitch the where suffix statement "AND{1}={2}"; {0}, {1}, and {3} represent different placeholders, and the final splicing is completed by replacing the values of the placeholders.

In the adding operation, the first is the basic statement "INSERT INTO{0}({1})VALUES({2})". Three strings are obtained by traversing the key-value data set, and the {0}, {1}, {3} placeholders. Among them, the first string is the table name, the second string is the field set connected by commas, and the third string is the corresponding value of the fields connected by commas.

In the modification operation, the first is "UPDATE{0}SET{1}WHERE{2}", where {0} is the table name, and {1} is generated by traversing the key-value collection "key1=value1,key2=value2,... ..." string, {2} is a string of conditional statements similar to where splicing in the query.

In the delete operation, the basic statement "DELETE FROM{0}WHERE 1=1" is also first, and then the conditional statement is spliced with the Where splicing method in the query.

In the embodiment of the present invention, the automatic splicing of key-value data to generate SQL statements is specifically: using the parameterizable feature of T-SQL to automatically splice key-value data to generate SQL statements.

The parameterizable feature of T-SQL means that the system can recognize the form of "Value=Value", and Value represents the parameter variable in T-SQL; in ADO.NET, the value can be passed to the execution command through the DBParameter method, Complete the final SQL execution.

Embodiment two

As shown in Figure 2, the embodiment of the present invention provides a kind of WEB form data access system, comprises: page layer, logic layer and data access layer, and described page layer is positioned at client, and described logic layer and described data The access layer is located at the server; the page layer is used to obtain WEB form data, and submit the WEB form data to the logic layer, and is also used to receive the execution result of the SQL statement forwarded by the data access layer through the logic layer, and Display; the logic layer is used to receive WEB form data, and convert the WEB form data into the original key-value data set, and is also used to send the original key-value data set to the data access layer, and is also used to transfer the data access layer The execution result of the SQL statement is forwarded to the page layer; the data access layer is used to receive the original key-value data set sent by the logic layer, and check the original key-value data set to obtain valid key-value data The set is also used to traverse the effective key-value data set, automatically splicing the key-value data to generate SQL statements according to the data manipulation method, and is also used to execute the SQL statement and forward the execution result to the page layer through the logic layer.

The above-mentioned system can adopt the WEB form data access method provided in the first embodiment. The method and its implementation technology and functions have been described in detail in the first embodiment, and will not be repeated here.

By adopting the above-mentioned technical solution disclosed in the present invention, the following beneficial effects are obtained: the embodiment of the present invention provides a method and system for accessing WEB form data by opening the user interface layer and integrating the object-relational mapping and the database access layer, Using this system, developers only need to keep the name of the web page form field and the database field the same, and call this method to realize the data manipulation of adding, deleting, modifying and checking the WEB form, and then realize data access without too much configuration, and if If there is a configuration error, the bottom layer of the system will intelligently correct the error, making the system stable and reliable; and the required fields are controlled through the page, and the layout of the Web page can be adjusted at will, which is convenient, flexible and efficient.

Each embodiment in this specification is described in a progressive manner, each embodiment focuses on the difference from other embodiments, and the same and similar parts of each embodiment can be referred to each other.

Those skilled in the art should understand that the timing of the method steps provided in the foregoing embodiments may be adjusted adaptively according to actual conditions, or may be performed concurrently according to actual conditions.

All or part of the steps in the methods involved in the above-mentioned embodiments can be completed by instructing related hardware through a program, and the program can be stored in a storage medium readable by a computer device, and is used to execute the methods described in the above-mentioned embodiments. all or part of the steps. The computer equipment, such as: personal computer, server, network equipment, smart mobile terminal, smart home equipment, wearable smart equipment, vehicle-mounted smart equipment, etc.; the storage medium, such as: RAM, ROM, disk, tape, CD, flash memory, U disk, mobile hard disk, memory card, memory stick, network server storage, network cloud storage, etc.

Finally, it should also be noted that in this text, relational terms such as first and second etc. are only used to distinguish one entity or operation from another, and do not necessarily require or imply that these entities or operations, any such actual relationship or order exists. Furthermore, the term "comprises", "comprises" or any other variation thereof is intended to cover a non-exclusive inclusion such that a process, method, article, or apparatus comprising a set of elements includes not only those elements, but also includes elements not expressly listed. other elements of, or also include elements inherent in, such a process, method, commodity, or apparatus. Without further limitations, an element defined by the phrase "comprising a ..." does not exclude the presence of additional identical elements in the process, method, article or apparatus comprising said element.

The above is only a preferred embodiment of the present invention, it should be pointed out that, for those of ordinary skill in the art, without departing from the principle of the present invention, some improvements and modifications can also be made, and these improvements and modifications can also be made. It should be regarded as the protection scope of the present invention.

Claims (10)

1. a WEB form data access method, is characterized in that, comprises the steps:

S1, client obtains WEB form data, and WEB form data is committed to service end;

S2, service end receives WEB form data, and WEB form data is converted to original key assignments data set;

S3, verifies original key assignments data set, obtains effective key assignments data set;

S5, travels through described effective key assignments data set, according to data manipulation mode, and automatic Mosaic key assignments data genaration SQL statement;

S6, performs described SQL statement and execution result is back to client.

2. WEB form data access method according to claim 1, is characterized in that, in S1, described client obtains form data, comprising:

S101, in html page, carries out layout to WEB form controls,

S102, uses WEB form controls, arranges WEB form data;

S103, is undertaken encapsulating WEB form data by WEB form data processor, obtains the WEB form data encapsulated;

S104, is committed to service end by the WEB form data of encapsulation.

3. WEB form data access method according to claim 1, is characterized in that, the title of described WEB form data is identical with field name in service end database.

4. WEB form data access method according to claim 1, it is characterized in that, S2 comprises:

S201, the WEB form data that client is submitted to by service end, stored in object, obtains WEB form object;

S202, is converted to original key assignments data set by described WEB form object.

5. WEB form data access method according to claim 1, it is characterized in that, S3 comprises the steps:

S301, resolves described original key assignments data set, obtains major key and/or certainly increases field;

S302, proofreading Keys according to major key and/or from increasing field, obtaining effective key assignments data set.

6. WEB form data access method according to claim 5, it is characterized in that, in S301, described described original key assignments data set to be resolved, be specially: utilize the database table SysColumns of service end obtain the major key of original key assignments data set and/or certainly increase field.

7. WEB form data access method according to claim 5, it is characterized in that, S302 is specially: compare by the major key of described original key assignments data set and/or from the major key increased in field and service end database and/or from increasing field, if there is the major key of described original key assignments data set in service end database and/or certainly increase field, then key assignments data are effective, and be stored in effective key assignments data centralization, otherwise, delete.

8. WEB form data access method according to claim 1, is characterized in that, in S5, described data manipulation mode comprises the inquiry of data, interpolation, amendment or deletion.

9. WEB form data access method according to claim 1, is characterized in that, described automatic Mosaic key assignments data genaration SQL statement, is specially: the parameterisable characteristic automatic Mosaic key assignments data genaration SQL statement utilizing T-SQL.

10. a WEB form data access system, is characterized in that, comprising: page layer, logical layer and data access layer, and described page layer is positioned at client, and described logical layer and described data access layer are positioned at service end; WEB form data for obtaining WEB form data, and is committed to logical layer by described page layer, also for receiving the execution result of the described SQL statement that data access layer is forwarded by logical layer, and shows; Described logical layer is for receiving WEB form data, and WEB form data is converted to original key assignments data set, also for original key assignments data set is sent to data access layer, also for the execution result of data access layer to described SQL statement is forwarded to page layer; The original key assignments data set that described data access layer sends for receiving described logical layer, and original key assignments data set is verified, obtain effective key assignments data set, also for traveling through described effective key assignments data set, according to data manipulation mode, automatic Mosaic key assignments data genaration SQL statement, also for performing described SQL statement and execution result being forwarded to page layer by logical layer.