CN106940721B - Data processing method and system for user-defined selection box - Google Patents
Data processing method and system for user-defined selection box Download PDFInfo
- Publication number
- CN106940721B CN106940721B CN201710153422.6A CN201710153422A CN106940721B CN 106940721 B CN106940721 B CN 106940721B CN 201710153422 A CN201710153422 A CN 201710153422A CN 106940721 B CN106940721 B CN 106940721B
- Authority
- CN
- China
- Prior art keywords
- field information
- selection box
- selection
- attribute
- data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/38—Creation or generation of source code for implementing user interfaces
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Software Systems (AREA)
- General Physics & Mathematics (AREA)
- Human Computer Interaction (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The embodiment of the invention discloses a data processing method and a data processing system for a custom selection box, which are used for reducing the time cost and the economic cost of developing an application program. The method provided by the embodiment of the invention comprises the following steps: receiving an input identification of a selection box and a data source; acquiring field information of the selection frame according to the data source; receiving the attribute of the input field information; storing the identification of the selection box, the field information of the selection box and the attribute association of the field information in a database; when a selection box loading request is triggered, receiving an input identification of the selection box and a selection box control, and acquiring field information and attributes of the field information of the selection box from a database according to the identification of the selection box; and acquiring the corresponding data value of the field information in the data source according to the field information of the selection frame, and displaying the field information and the data value of the selection frame in the selection frame control according to the attribute of the field information. The invention also provides a related system, which can reduce the time cost and the economic cost for developing the application program.
Description
Technical Field
The invention relates to computer data processing and data display technologies, in particular to a data processing method and system of a user-defined selection box.
Background
Data query and display are the most common functions in computers, and the selection box is a common means for data query and display. The selection box mainly has two forms, namely pop-up box selection and pull-down option selection. The use of selection boxes in different applications may involve querying various types of data, which in turn may involve different data presentations.
In order to satisfy data query and display of different services, developers write different application program codes, make various types of selection frame pages for data query, and display data in applications.
In the existing selection frame manufacturing mode, technical personnel are required to code, development time and labor cost are inevitably consumed, and after codes are compiled, relevant technical personnel are required to call the codes through a preset calling program, so that ordinary personnel in non-relevant fields cannot reuse the compiled code programs, and the time cost and the economic cost for developing application programs are increased.
Disclosure of Invention
The embodiment of the invention provides a method and a system for customizing a selection box, which are used for reducing the time cost and the economic cost of developing an application program.
An embodiment of the present invention provides a data processing method for a custom selection box, including: receiving an identification and a data source of a selection box input by a user; acquiring field information of the selection frame according to the data source; receiving the attribute of field information input by a user; storing the identification of the selection box, the field information of the selection box and the attribute association of the field information in a database; when a loading request of a selection box is triggered, receiving an identification of the selection box and a selection box control input by a user, and acquiring field information and attributes of the field information of the selection box from a database according to the identification of the selection box; and acquiring the corresponding data value of the field information in the data source according to the field information of the selection frame, and displaying the field information and the data value of the selection frame in the selection frame control according to the attribute of the field information.
Another aspect of the embodiments of the present invention provides a user-defined selection box system, including: the first receiving unit is used for receiving the identification of the selection box input by the user and a data source; the first acquisition unit is used for acquiring the field information of the selection frame according to the data source; the second receiving unit is used for receiving the attribute of the field information input by the user; the storage unit is used for storing the identification of the selection frame, the field information of the selection frame and the attribute association of the field information in a database; the third receiving unit is used for receiving the mark of the selection box and the selection box control input by the user when the loading request of the selection box is triggered; the second acquisition unit is used for acquiring the field information of the selection frame and the attribute of the field information according to the identification of the selection frame; a third obtaining unit, configured to obtain, according to the field information of the selection box, a data value corresponding to the field information in the data source; and the display unit is used for displaying the field information and the data dereferencing of the selection frame in the selection frame control according to the attribute of the field information.
According to the technical scheme, the embodiment of the invention has the following advantages: the user-defined selection frame system stores the implementation logic association of the selection frame in a database, supports the user to input the user-defined selection frame identification and data source, can develop the personalized selection frame without compiling additional codes, and can call out the original selection frame by inputting the same selection frame identification when being quoted next time, thereby providing a convenient and fast selection frame development tool for developers, improving the efficiency of selection frame development, solving the problem that codes cannot be reused in the traditional development mode, and reducing the workload and the economic cost for developing application programs.
Drawings
FIG. 1 is a schematic diagram of an embodiment of a data processing method for a custom selection box according to an embodiment of the present invention;
FIG. 2 is a diagram of another embodiment of a data processing method for a custom selection box according to an embodiment of the present invention;
FIG. 3 is a diagram of another embodiment of a data processing method for a custom selection box according to an embodiment of the present invention;
FIG. 4 is a schematic diagram of an embodiment of a custom checkbox system according to an embodiment of the present invention;
FIG. 5 is a schematic diagram of another embodiment of a custom checkbox system according to an embodiment of the present invention;
FIG. 6 is a schematic diagram of another embodiment of a custom checkbox system in accordance with an embodiment of the present invention;
FIG. 7 is a diagram illustrating a data source configuration for database table types in an embodiment of the present invention;
FIG. 8 is a diagram illustrating field information obtained according to data sources in an embodiment of the invention;
FIG. 9 is a diagram illustrating the setting of field information and field information attributes of a pop-up selection box according to an embodiment of the present invention;
FIG. 10 is a diagram illustrating field information of a drop-down selection box according to an embodiment of the present invention.
Detailed Description
The embodiment of the invention provides a data processing method and a data processing system for a custom selection box, which are used for reducing the time cost and the economic cost of developing an application program.
Referring to fig. 1, an embodiment of a data processing method for a custom selection box according to the present invention includes:
101. receiving an identification and a data source of a selection box input by a user;
when a user queries, displays or operates on computer data, a selection box is often used as a common means. In the embodiment, when a user develops the selection box, the user inputs the identification of the selection box according to the own needs and preferences, the user can call the selection box according to the identification of the selection box next time, the field information in the selection box can be set according to the needs, and different field information is displayed by selecting different data contents from different data sources.
In this embodiment, the custom checkbox system receives a checkbox identifier and a data source input by a user, where the data source supports multiple different paths and different types of data, which are described in detail in the following embodiments.
102. Acquiring field information of the selection frame according to the data source;
the user can select different data sources from different paths as field information in the selection box according to needs.
The user-defined selection frame system receives data sources of different paths input by a user, and can read required data contents from the data sources.
103. Receiving the attribute of field information input by a user;
the user can set the attribute of the field information input in the selection box, and the user-defined selection box system receives the attribute of the field information input by the user, so that the field information in the selection box is displayed in the selection box in different forms, and the user can conveniently use the selection box to inquire and display data as required.
104. Storing the identification of the selection box, the field information of the selection box and the attribute association of the field information in a database;
after the user finishes setting the identification of the selection box, the field information in the selection box and the attribute of the field information, the user-defined selection box system stores the information of the selection box in a database in a correlated mode, and the user can conveniently call the selection box from the database according to the identification of the selection box.
105. Receiving an identification of a selection box and a selection box control input by a user, and acquiring field information of the selection box and attributes of the field information from a database according to the identification of the selection box;
after the custom selection frame system stores the developed selection frame in an associated manner, when a user needs to call the selection frame, namely when a loading request of the selection frame is triggered, the custom selection frame system receives a selection frame identifier and a selection frame control input by the user in a database, and the custom selection frame system can read field information and attributes of the field information in the selection frame from the database according to the selection frame identifier.
106. And acquiring the corresponding data value of the field information in the data source according to the field information of the selection frame, and displaying the field information and the data value of the selection frame in the selection frame control according to the attribute of the field information.
After the user-defined selection frame system reads the field information of the selection frame, the data dereferencing can be read from the data source according to the data path of the field information, and the field information and the data dereferencing of the selection frame are displayed in the selection frame control according to the attribute of the field information set by the user.
After the user selects data by using the selection box control, the data selected by the user can be backfilled on the current page of the user according to the user requirement in a matching mode.
In the embodiment, the user-defined selection frame system stores the implementation logic association of the selection frame in the database, supports the user to input the user-defined selection frame identification and data source, can develop the personalized selection frame without compiling additional codes, and can call the original selection frame by inputting the same selection frame identification in the next reference, thereby providing a convenient selection frame development tool for a large number of developers, improving the development efficiency of the selection frame, solving the problem that codes cannot be reused in the traditional development mode, and reducing the workload and the economic cost for developing the application program.
For convenience of understanding, the following describes in detail a method for processing custom checkbox data in an embodiment of the present invention, where a custom checkbox system may display checkbox information in different ways according to a selection of a user, and the following is introduced from various aspects:
firstly, displaying field information and data dereferencing of a selection box in a pop-up selection box according to attributes of the field information;
referring to fig. 2, another embodiment of the data processing method for a custom selection box according to the embodiment of the present invention includes:
201. receiving an identification and a data source of a selection box input by a user;
when a user queries, displays or operates on computer data, a selection box is often used as a common means. In the embodiment, when a user develops the selection box, the user inputs the identification of the selection box according to the own needs and preferences, the user can call the selection box according to the identification of the selection box next time, the field information attribute in the selection box can be set according to the needs, and different field information is displayed by selecting different data contents from different data sources.
In this embodiment, the custom checkbox system receives a checkbox identifier and a data source input by a user, where the data source supports multiple different paths and different types of data, and the data source may be a database table, SQL script editing, API interface data, and corresponds to a local database single table, a local database multiple table, or external data, respectively. For example: the user needs to read the preset data qymc, sh and hylb in the table with the preset table name of 'tt _ sys _ user' from the local database single table, and then the user can look up the table with the name of 'tt _ sys _ user' from the local database single table according to the storage path of the preset table and read the preset data qymc, sh and hylb from the table. As shown in FIG. 7, a data source setting of a database table type is depicted, and the selection box as set in the figure is identified as "MyDialog" and the table name is tt _ sys _ user.
202. Acquiring field information of the selection frame according to the data source;
the user can select different data sources from different paths as field information in the selection box according to needs. The custom selection frame system can read the required data content from the data source according to the data source of different paths input by the user.
For example, field information of the table tt _ sys _ user is obtained according to a data source, if the table has three fields, the returned field information is as shown in fig. 8, and corresponding field identifiers and fields are respectively described as: "qymc/Enterprise identification", "sh/tax number", "hylb/industry Category".
203. Receiving the attribute of field information input by a user;
the user can set the attribute of the field information input in the selection box, and the user-defined selection box system receives the attribute of the field information input by the user, so that the field information in the selection box is displayed in the selection box in different forms, and the user can conveniently use the selection box to inquire and display data as required.
For example, after the field information is read by the custom selection box system, the display attribute and the query attribute of the field information may be set, the display attribute indicates whether to display the field, the query attribute indicates whether the field may be used as a query condition, fig. 8 shows different attribute settings in the field information, three fields of "enterprise identifier", "tax number" and "industry category" are set and displayed in the selection box, and "enterprise identifier" and "tax number" are set as query fields.
204. Converting the identification of the selection frame, the field information of the selection frame and the attribute of the field information into json format parameters;
in the database, in order to follow the development principle of the application program, the set parameters need to be converted into json parameters in a specified format, and the specific format may be a text or a data group, which is not limited herein.
205. Storing the identification of the selection box, the field information of the selection box and the attribute association of the field information in a database;
after the user finishes setting the identification of the selection box, the field information in the selection box and the attribute of the field information, the user-defined selection box system converts the set parameters into json parameters in a specified format, stores the json parameters in a persistent association manner into a database, and extracts and analyzes the set parameters when in use.
206. Receiving an identification of a selection box and a selection box control input by a user, and acquiring field information of the selection box and attributes of the field information from a database according to the identification of the selection box;
after the user-defined selection frame system stores the developed selection frame in an associated manner, when a user needs to call the selection frame, namely when a loading request of the selection frame is triggered, the user-defined selection frame system receives a selection frame identifier and a selection frame control input by the user in the database, and the user-defined selection frame system can read the field information and the attribute of the field information in the selection frame from the database according to the selection frame identifier.
For example, a user inputs "MyDialog" in an element of a selection box, and the selection box control selects a pop-up selection box, wherein the selection box control comprises a pull-down selection box or a pop-up selection box, the custom selection box system can request data from a database with an identifier of the selection box, and the database can return field information according to attributes of the field information set by the user. For example, the user sets and displays three fields of 'enterprise identification', 'tax number' and 'industry type', sets 'enterprise identification' and 'tax number' as query fields, and can see the three fields of 'enterprise identification', 'tax number' and 'industry type' in a returned selection box, but only the 'enterprise identification' and the 'tax number' can be used as query fields for querying.
207. Acquiring a corresponding data value of the field information in the data source according to the field information of the selection frame;
after the custom selection box system obtains the field information, the data path of the field information is firstly analyzed, and then the corresponding data value of the field information in the data source is read from the data source according to the data path of the field information, for example: the custom selection frame system reads field information of the enterprise identifier, the tax number and the industry type from the tt _ sys _ user table in the local data sheet table, and can read specific values in rows or columns of the enterprise identifier, the tax number and the industry type according to the field information, such as ' Hongxing food ', ' Hongxing science and technology ', ' Hongxing property ', corresponding to the enterprise identifier, ' 1231 ', ' 15645 ', ' 18485 ', corresponding to the tax number ', and ' catering ', ' internet ' and ' real estate ' corresponding to the industry type. It should be noted that the form identifier and the field information in this embodiment are only examples, and specific form identifiers and contents are not limited herein.
208. Converting the acquired data value into a json parameter in a specified format according to the attribute of the field information;
after the user-defined selection box system obtains a data value, the obtained data value is converted into a json parameter in a specified format according to the attribute of field information, wherein the attribute of the field information comprises a display attribute and a query attribute, the display attribute indicates whether the field is displayed, the query attribute indicates whether the field can be used as a query condition, for example, three fields of ' enterprise identification ', ' tax number ' and ' industry category ' are displayed, then ' Hongxing food ', ' Hongxing science ', ' Hongxing real estate ', ' 1231 ', ' 15645 ', ' 18485 ', ' catering ', ' internet ', ' real estate ' which respectively correspond to the ' enterprise identification ', ' tax number ' and the ' industry category ' are converted into the json parameter in the specified format, the ' enterprise identification ' and the ' tax number ' are set as query fields, and then the displayed query fields of ' Hongxing food ', ' Hongxing science, "macroshape", "1231", "15645" and "18485" are also converted into json parameters in a specified format, which may be a text or a data set, and the specific format is not limited herein.
209. And displaying the field information and the data value of the selection box in the pop-up selection box according to the attribute of the field information.
When the user selects the pop-up selection box, the custom selection box system displays the field information and the data value of the selection box in the pop-up selection box according to the attribute of the field information, for example, the field information is "qymc/enterprise id", "sh/tax number", "hylb/industry category", the data value is "Hongxing food", "Hongxing science and technology", "Hongxing property", "1231", "15645", "18485", "catering", "internet", "real estate", wherein "enterprise id", "tax number", "industry category" is a display field, and "enterprise id" and "tax number" are query fields, and the displayed selection box control and data are as shown in fig. 9.
After the user selects data by using the pop-up selection box control, the data selected by the user can be backfilled to the current page of the user in a matching mode according to the needs of the user. For example: when the user selects the data item names qymc, sh and hylb by using the pop-up selection box control, the data item names are matched with the name attribute of the current page of the user, and if the matching is successful, the data corresponding to the data item names in the pop-up selection box is backfilled in the current page.
In the embodiment, the user-defined selection frame system stores the implementation logic association of the selection frame in the database, supports the user to input the user-defined selection frame identification and data source, can develop the personalized selection frame without compiling additional codes, and can call the original selection frame by inputting the same selection frame identification in the next reference, thereby providing a convenient selection frame development tool for a large number of developers, improving the development efficiency of the selection frame, solving the problem that codes cannot be reused in the traditional development mode, and reducing the workload and the economic cost for developing the application program.
Secondly, in this embodiment, before the user invokes the selection box program, the user selects the pop-up selection box control, and displays the field information in the pop-up selection box control, so that the diversity of the scheme is improved.
Secondly, displaying the field information and the data value of the selection box in a pull-down selection box control according to the attribute of the field information;
referring to fig. 3, another embodiment of the data processing method for a custom selection box in the embodiment of the present invention includes:
301. receiving an identification and a data source of a selection box input by a user;
302. acquiring field information of the selection frame according to the data source;
303. receiving the attribute of field information input by a user;
304. converting the identification of the selection frame, the field information of the selection frame and the attribute of the field information into json format parameters;
305. storing the identification of the selection box, the field information of the selection box and the attribute association of the field information in a database;
306. receiving an identification of a selection box and a selection box control input by a user, and acquiring field information of the selection box and attributes of the field information from a database according to the identification of the selection box;
307. acquiring a corresponding data value of the field information in the data source according to the field information of the selection frame;
308. converting the acquired data value into a json parameter in a specified format according to the attribute of the field information;
it should be noted that steps 301 to 308 in this embodiment are similar to steps 201 to 208 in the embodiment described in fig. 2, and detailed description thereof is omitted here.
309. And displaying the field information and the data value of the selection frame in the pull-down selection frame according to the attribute of the field information.
When the user selects the drop-down selection box, the custom selection box system displays the field information and the data value of the selection box in the drop-down selection box according to the attribute of the field information, for example, the field information is "qymc/enterprise id", "sh/tax number", "hylb/industry category", the data value is "Hongxing food", "Hongxing science and technology", "Hongxing property", "1231", "15645", "18485", "catering", "internet", "real estate", wherein "enterprise id", "tax number", "industry category" is a display field, and "enterprise id" and "tax number" are query fields, and the displayed selection box control and data queried by the enterprise id are as shown in fig. 10.
After the user selects data by using the pull-down selection box control, the data selected by the user can be backfilled to the current page of the user in a matching mode according to the needs of the user. For example: when the user selects the data item names qymc, sh and hylb by using the pull-down selection box control, the data item names are matched with the name attribute of the current page of the user, and if the matching is successful, the data corresponding to the data item names in the pop-up selection box is backfilled in the current page.
In the embodiment, the user-defined selection frame system stores the implementation logic association of the selection frame in the database, supports the user to input the user-defined selection frame identification and data source, can develop the personalized selection frame without compiling additional codes, and can call the original selection frame by inputting the same selection frame identification in the next reference, thereby providing a convenient selection frame development tool for a large number of developers, improving the development efficiency of the selection frame, solving the problem that codes cannot be reused in the traditional development mode, and reducing the workload and the economic cost for developing the application program.
Secondly, in this embodiment, before the user invokes the selection box program, the user selects the drop-down selection box control, and displays the field information in the drop-down selection box control, so that the diversity of the scheme is improved.
The above describes a method for processing custom selection box data in the embodiment of the present invention, and the following describes a custom selection box system in the embodiment of the present invention.
Referring to fig. 4, an embodiment of the custom checkbox system in the embodiment of the present invention includes:
a first receiving unit 401, configured to receive an identifier of a selection box and a data source input by a user;
a first obtaining unit 402, configured to obtain field information of the selection box according to a data source;
a second receiving unit 403, configured to receive an attribute of field information input by a user;
a storage unit 404, configured to store the identifier of the selection box, the field information of the selection box, and the attribute association of the field information in a database;
a third receiving unit 405, configured to receive an identifier of a selection box and a selection box control input by a user;
a second obtaining unit 406, configured to obtain field information of the selection box and an attribute of the field information according to the identifier of the selection box;
a third obtaining unit 407, configured to obtain, according to the field information of the selection box, a data value corresponding to the field information in the data source;
and the display unit 408 is configured to display the field information and the data dereferencing of the selection box in the selection box control according to the attribute of the field information.
It should be noted that the functions of the units in this embodiment are similar to the functions of the custom selection frame system in the embodiment shown in fig. 1, and detailed description thereof is omitted here.
In this embodiment, the custom checkbox system stores the implementation logic association of the checkbox in the database through the storage unit 404, and supports the user to input the custom checkbox identifier and the data source through the first receiving unit 401, and the personalized checkbox can be developed without compiling additional codes, and the original checkbox can be retrieved by inputting the same checkbox identifier through the third receiving unit 405 when the user refers next time.
For ease of understanding, the following describes in detail a custom checkbox system in an embodiment of the present invention, where the custom checkbox system may display checkbox information in different ways according to a selection of a user, and the following is introduced from various aspects:
firstly, displaying field information and data dereferencing of a selection box in a pop-up selection box control according to the attribute of the field information;
referring to fig. 5, another embodiment of the custom checkbox system in the embodiment of the present invention includes:
a first receiving unit 501, configured to receive an identifier of a selection box and a data source input by a user;
a first obtaining unit 502, configured to obtain field information of the selection box according to a data source;
a second receiving unit 503, configured to receive an attribute of field information input by a user;
a first parameter conversion unit 504, configured to convert an identifier of a selection box, field information of the selection box, and an attribute of the field information into json format parameters;
a storage unit 505, configured to store the identifier of the selection box, the field information of the selection box, and the attribute association of the field information in a database;
a third receiving unit 506, configured to receive an identifier of a selection box and a selection box control input by a user;
a second obtaining unit 507, configured to obtain field information of the checkbox and an attribute of the field information according to the identifier of the checkbox;
a third obtaining unit 508, configured to obtain, according to the field information of the selection box, a data value corresponding to the field information in the data source;
a second parameter conversion unit 509, configured to convert the data value into a json format parameter according to the attribute of the field information;
and a display unit 510, configured to display the field information and the data dereferencing of the selection box in the selection box control according to the attribute of the field information.
The first receiving unit 501 includes:
a first receiving subunit 5011, configured to receive an identifier of a selection box input by a user;
the second receiving subunit 5012 is configured to receive a data source selected by a user from the local database list, or the external data.
The first obtaining unit 502 includes:
a reading subunit 5021, configured to read preset data from a single table of the local database, multiple tables of the local database, or a preset table in external data;
a storage subunit 5022, configured to store the preset data in the selection box as field information of the selection box.
Wherein, the display unit 510 includes:
the first display unit 5101 is configured to display the field information and the data value of the selection box in a pop-up selection box according to the attribute of the field information.
It should be noted that the functions of each unit in this embodiment are similar to the functions of the custom selection frame system in the embodiment described in fig. 2, and detailed description thereof is omitted here.
In this embodiment, the custom checkbox system stores the implementation logic association of the checkbox in the database through the storage unit 504, and supports the user to input the custom checkbox identifier and the data source through the first receiving unit 501, and the personalized checkbox can be developed without compiling additional codes, and the original checkbox can be retrieved by inputting the same checkbox identifier through the third receiving unit 505 when the user refers next time.
Secondly, in this embodiment, before the user calls the selection box program, the user selects the pop-up selection box control, and the first display unit 5101 displays the field information in the pop-up selection box control, so that the diversity of the scheme is improved.
Secondly, displaying the field information and the data value of the selection box in a pull-down selection box control according to the attribute of the field information;
referring to fig. 6, another embodiment of the custom checkbox system in the embodiment of the present invention includes:
a first receiving unit 601, configured to receive an identifier of a selection box and a data source input by a user;
a first obtaining unit 602, configured to obtain field information of a selection box according to a data source;
a second receiving unit 603, configured to receive an attribute of field information input by a user;
a first parameter conversion unit 604, configured to convert an identifier of a selection box, field information of the selection box, and an attribute of the field information into json format parameters;
a storage unit 605, configured to store the identifier of the selection box, the field information of the selection box, and the attribute association of the field information in a database;
a third receiving unit 606, configured to receive an identifier of a selection box and a selection box control input by a user;
a second obtaining unit 607, configured to obtain field information of the checkbox and an attribute of the field information according to the identifier of the checkbox;
a third obtaining unit 608, configured to obtain, according to the field information of the selection box, a data value corresponding to the field information in the data source;
a second parameter conversion unit 609, configured to convert the data value into a json format parameter according to the attribute of the field information;
and the display unit 610 is configured to display the field information and the data dereferencing of the selection box in the selection box control according to the attribute of the field information.
The first receiving unit 601 includes:
a first receiving subunit 6011, configured to receive an identifier of a selection box input by a user;
a second receiving subunit 6012, configured to receive a data source selected by a user from a single table of the local database, multiple tables of the local database, or external data.
The first obtaining unit 602 includes:
a reading subunit 6021, configured to read preset data from a single table of the local database, multiple tables of the local database, or a preset table in external data;
a storing subunit 6022, configured to store the preset data in the selection box as field information of the selection box.
Wherein, the display unit 610 includes:
a second display unit 6102, configured to display the field information of the selection box and the data value in a drop-down selection box according to the attribute of the field information.
In this embodiment, the custom selection box system stores the implementation logic association of the selection box in the database through the storage unit 604, and supports the user to input the custom selection box identifier and the data source through the first receiving unit 601, and the personalized selection box can be developed without writing additional codes, and the original selection box can be retrieved by inputting the same selection box identifier through the third receiving unit 605 when the user refers next time.
Secondly, in this embodiment, before the user calls the selection box program, the user selects the drop-down selection box control, and the second display unit 6102 displays the field information in the drop-down selection box control, so that the diversity of the scheme is improved.
It is clear to those skilled in the art that, for convenience and brevity of description, the specific working processes of the above-described systems, apparatuses and units may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
In the several embodiments provided in the present application, it should be understood that the disclosed system, apparatus and method may be implemented in other manners. For example, the above-described apparatus embodiments are merely illustrative, and for example, a division of a unit is merely a logical division, and an actual implementation may have another division, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.
Units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other various media capable of storing program codes.
The above embodiments are only used to illustrate the technical solution of the present invention, and not to limit the same; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present invention.
Claims (13)
1. A data processing method of a custom selection box is characterized by being applied to a custom selection box system and comprising the following steps:
receiving an identification and a data source of a selection box input by a user;
acquiring field information of the selection frame according to the data source;
receiving the attribute of the field information input by the user;
storing the identification of the selection box, the field information of the selection box and the attribute association of the field information in a database;
when a loading request of the selection box is triggered, receiving an identification of the selection box and a selection box control input by the user, and acquiring field information of the selection box and attributes of the field information from the database according to the identification of the selection box;
and acquiring a data value corresponding to the field information in the data source according to the field information of the selection frame, and displaying the field information of the selection frame and the data value in the selection frame control according to the attribute of the field information.
2. The method of claim 1, wherein after said receiving the user-entered attribute of the field information, prior to storing the selection box identification, the selection box field information, and the field information attribute association in a database, the method further comprises:
and converting the identification of the selection box, the field information of the selection box and the attribute of the field information into json format parameters.
3. The method according to claim 2, wherein after the obtaining of the corresponding data value of the field information in the data source according to the field information of the selection box, the method further comprises:
and converting the data value into the json format parameter according to the attribute of the field information.
4. The method of claim 1, wherein the selection box control comprises:
pop-up checkboxes or pull-down checkboxes.
5. The method of claim 1, wherein the data source comprises:
a single table of the local database, multiple tables of the local database, or a data source in the external data.
6. The method of claim 5, wherein obtaining field information of the selection box according to the data source comprises:
and reading preset data from a single table of a local database, a plurality of tables of the local database or a preset table of external data, and storing the preset data into the selection box as field information of the selection box.
7. The method of claim 1, wherein the attributes of the field information comprise:
and the display attribute and the query attribute of the field information.
8. A custom checkbox system, comprising:
the first receiving unit is used for receiving the identification of the selection box input by the user and a data source;
the first acquisition unit is used for acquiring the field information of the selection frame according to the data source;
a second receiving unit, configured to receive an attribute of the field information input by the user;
the storage unit is used for storing the identification of the selection box, the field information of the selection box and the attribute association of the field information in a database;
a third receiving unit, configured to receive, when a loading request of the selection box is triggered, an identifier of the selection box and a selection box control input by the user;
a second obtaining unit, configured to obtain field information of the selection box and an attribute of the field information according to the identifier of the selection box;
a third obtaining unit, configured to obtain, according to the field information of the selection box, a data value corresponding to the field information in the data source;
and the display unit is used for displaying the field information of the selection frame and the data dereferencing in the selection frame control according to the attribute of the field information.
9. The system of claim 8, further comprising:
the first parameter conversion unit is used for converting the identification of the selection box, the field information of the selection box and the attribute of the field information into json format parameters;
and the second parameter conversion unit is used for converting the data dereferencing into the json format parameter according to the attribute of the field information.
10. The system of claim 8, wherein the first receiving unit comprises:
the first receiving subunit is used for receiving the identification of the selection box input by the user;
and the second receiving subunit is used for receiving a data source selected by the user from the single table of the local database, the multiple tables of the local database or the external data.
11. The system of claim 10, wherein the first obtaining unit comprises:
the reading subunit is used for reading preset data from the local database single table, the local database multiple tables or a preset table in the external data;
and the storage subunit is used for storing the preset data into the selection frame as the field information of the selection frame.
12. The system of claim 8, wherein the attributes of the field information comprise:
and the display attribute and the query attribute of the field information.
13. The system of claim 8, wherein the display unit comprises:
the first display unit is used for displaying the field information and the data dereferencing of the selection box in a pop-up selection box according to the attribute of the field information;
and the second display unit is used for displaying the field information and the data dereferencing of the selection frame in the pull-down selection frame according to the attribute of the field information.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710153422.6A CN106940721B (en) | 2017-03-15 | 2017-03-15 | Data processing method and system for user-defined selection box |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710153422.6A CN106940721B (en) | 2017-03-15 | 2017-03-15 | Data processing method and system for user-defined selection box |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106940721A CN106940721A (en) | 2017-07-11 |
| CN106940721B true CN106940721B (en) | 2020-02-14 |
Family
ID=59468993
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710153422.6A Active CN106940721B (en) | 2017-03-15 | 2017-03-15 | Data processing method and system for user-defined selection box |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106940721B (en) |
Families Citing this family (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109299288A (en) * | 2018-11-09 | 2019-02-01 | 北京锐安科技有限公司 | Read method, device, server and the storage medium of dictionary data |
| CN109344165A (en) * | 2018-11-23 | 2019-02-15 | 福建榕基软件股份有限公司 | A kind of querying method and storage equipment |
| CN109871500A (en) * | 2019-01-24 | 2019-06-11 | 平安科技（深圳）有限公司 | Page loading method, device, computer equipment and storage medium |
| CN110221745A (en) * | 2019-05-30 | 2019-09-10 | 贝壳技术有限公司 | For the generation method and device of the multi-layer drop-down choice box of asynchronous data |
| CN116097203A (en) * | 2021-08-31 | 2023-05-09 | 京东方科技集团股份有限公司 | Data display method and device, storage medium and electronic equipment |
| CN116382659B (en) * | 2023-05-29 | 2023-09-01 | 珠海乐图软件有限公司 | Data definition method of code-free development platform |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101083684A (en) * | 2007-07-24 | 2007-12-05 | 华为技术有限公司 | Communication apparatus batch configuration managerial approach and apparatus |
| CN101359290A (en) * | 2008-09-11 | 2009-02-04 | 中兴通讯股份有限公司 | Method for customizing service document based on metadata and apparatus |
| CN101814064A (en) * | 2009-02-23 | 2010-08-25 | 华为技术有限公司 | Establishment method of report template, report generation method and report system |
| CN102346785A (en) * | 2011-11-15 | 2012-02-08 | 北京创腾科技有限公司 | Method and device for directly self-defining field of database |
| US8483268B1 (en) * | 2006-03-14 | 2013-07-09 | Geo Semiconductor Inc. | Method and apparatus for frame, field and macroblock adaptive progressive/interlace coding selection |
| CN103699482A (en) * | 2013-12-12 | 2014-04-02 | 金蝶软件（中国）有限公司 | Method and device for testing reasonableness of controls |
| CN104699488A (en) * | 2015-03-31 | 2015-06-10 | 北京奇虎科技有限公司 | Method, equipment and system for acquiring APP (application) interface control data dynamically |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7650276B2 (en) * | 2003-02-26 | 2010-01-19 | Bea Systems, Inc. | System and method for dynamic data binding in distributed applications |
-
2017
- 2017-03-15 CN CN201710153422.6A patent/CN106940721B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8483268B1 (en) * | 2006-03-14 | 2013-07-09 | Geo Semiconductor Inc. | Method and apparatus for frame, field and macroblock adaptive progressive/interlace coding selection |
| CN101083684A (en) * | 2007-07-24 | 2007-12-05 | 华为技术有限公司 | Communication apparatus batch configuration managerial approach and apparatus |
| CN101359290A (en) * | 2008-09-11 | 2009-02-04 | 中兴通讯股份有限公司 | Method for customizing service document based on metadata and apparatus |
| CN101814064A (en) * | 2009-02-23 | 2010-08-25 | 华为技术有限公司 | Establishment method of report template, report generation method and report system |
| CN102346785A (en) * | 2011-11-15 | 2012-02-08 | 北京创腾科技有限公司 | Method and device for directly self-defining field of database |
| CN103699482A (en) * | 2013-12-12 | 2014-04-02 | 金蝶软件（中国）有限公司 | Method and device for testing reasonableness of controls |
| CN104699488A (en) * | 2015-03-31 | 2015-06-10 | 北京奇虎科技有限公司 | Method, equipment and system for acquiring APP (application) interface control data dynamically |
Non-Patent Citations (1)
| Title |
|---|
| 基于自定义表单的业务一体化架构平台研究;袁长春 等;《江苏科技信息》;20101231;第51-52页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106940721A (en) | 2017-07-11 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106940721B (en) | Data processing method and system for user-defined selection box | |
| US11886806B2 (en) | Templating process for a multi-page formatted document | |
| US9152305B2 (en) | Systems and methods for presentations with live application integration | |
| US8782530B2 (en) | Method and system for providing a user interface in a computer | |
| US9383902B2 (en) | Systems and methods for presentations with live application integration | |
| TW201430597A (en) | Method and device for generating and updating project based web pages | |
| US9652203B1 (en) | Application development framework using configurable data types | |
| CN102789457A (en) | Method for dynamically customizing filter conditions | |
| CN110046287A (en) | A kind of the data query method, apparatus and storage medium unrelated with type of database | |
| CN105389184A (en) | Configuration method and apparatus for product interface information | |
| CN108572817B (en) | Method, apparatus and medium for dynamic resource configuration based on business modeling | |
| CN104808995B (en) | A kind of method and apparatus for across application collection application content | |
| CN105739717B (en) | Data inputting method and device | |
| US7962856B2 (en) | Lookup control configuration | |
| JP6670051B2 (en) | Information processing apparatus, information processing method, and program | |
| US8805857B2 (en) | Merging of items from different data sources | |
| JP2008269515A (en) | Method for dynamically generating image layout by parameter | |
| JP2009093389A (en) | Information processor, information processing method, and program | |
| CN110019433B (en) | Report query method and device | |
| CN106648338A (en) | Method and device for editing data | |
| CN112948441B (en) | Multi-dimensional data collection method and equipment for financial data | |
| US20150347573A1 (en) | Information Processing Device and Method Therefor, and Non-Transitory Computer Readable Medium | |
| CN109213811B (en) | Report form display method and device | |
| JP7183458B1 (en) | Setting work support device, setting work support method, and setting work support program | |
| JP5487181B2 (en) | Setting information input support apparatus and program |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information | ||
| CB02 | Change of applicant information |
Address after: Room 01 and 02, 10 / F, building 4, zone 3, No. 186, South Fourth Ring West Road, Fengtai District, Beijing 100070 Applicant after: Guoxin electronic bill Platform Information Service Co., Ltd. Address before: 100089 Beijing, Haidian District West Third Ring Road, No. 13, layer 1-1303, No. 87 Applicant before: Electronic invoice Marketing Data Services Ltd |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |