CN116821164B - Searching method for realizing visual flexible combination dynamic configuration - Google Patents
Searching method for realizing visual flexible combination dynamic configuration Download PDFInfo
- Publication number
- CN116821164B CN116821164B CN202311107632.3A CN202311107632A CN116821164B CN 116821164 B CN116821164 B CN 116821164B CN 202311107632 A CN202311107632 A CN 202311107632A CN 116821164 B CN116821164 B CN 116821164B
- Authority
- CN
- China
- Prior art keywords
- query
- page
- expression
- dynamic configuration
- condition
- 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
- 230000000007 visual effect Effects 0.000 title claims abstract description 33
- 238000000034 method Methods 0.000 title claims abstract description 29
- 239000012634 fragment Substances 0.000 claims abstract description 14
- 230000014509 gene expression Effects 0.000 claims description 30
- 230000000295 complement effect Effects 0.000 claims description 3
- 230000009191 jumping Effects 0.000 claims description 3
- 238000012827 research and development Methods 0.000 abstract description 5
- 238000012360 testing method Methods 0.000 abstract description 3
- 238000011161 development Methods 0.000 description 3
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000004807 localization Effects 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention aims to provide a search method for realizing visual flexible combination dynamic configuration, which realizes visual flexible combination dynamic configuration advanced search and comprises configuration management and OPS-SDK, wherein the configuration management realizes the visual and dynamic configuration management functions of page query conditions, and comprises the steps of adding, copying, importing, exporting, deleting, configuring search fields and configuring sorting fields to page query conditions; OPS-SDK refers to the introduction of OPS-SDK package in software development, and the program automatically analyzes and converts SQL query fragments of different databases according to different database drivers. The searching method for realizing the visual flexible combination dynamic configuration greatly reduces the workload of front and back research and development and testing and the cost. Aiming at different inquiry conditions in different areas, the system can be flexibly combined and flexibly configured, and the universality and reusability of the system are effectively improved.
Description
Technical Field
The invention relates to the field of searching, in particular to a searching method for realizing visual flexible combination dynamic configuration.
Background
In software development, various condition search queries exist, when a product manager designs a certain function, the query conditions need to be combed in advance, and the query conditions and the query modes are built in program codes by the front end and the rear end of the development. Front-end and back-end development of the change code is required when query conditions need to be added, changed and removed. However, when any condition changes, the code needs to be changed, which is disadvantageous to flexibility, reusability and universality of the program.
Disclosure of Invention
The invention aims to solve the problems, and provides a visual dynamic configuration and flexible combination advanced search, and meanwhile, the advanced search supports localization.
A searching method for realizing visual flexible combination dynamic configuration realizes visual flexible combination dynamic configuration of advanced searching, comprising configuration management and OPS-SDK.
Furthermore, the searching method for realizing the visual flexible combination dynamic configuration is characterized in that the configuration management realizes the visual and dynamic configuration management functions of page query conditions, and comprises the steps of adding, copying, importing, exporting, deleting, configuring searching fields and configuring sorting fields for the page query conditions.
Furthermore, the OPS-SDK refers to a searching method for realizing visual flexible combination dynamic configuration, wherein OPS-SDK packages are introduced in software development, and a program automatically analyzes and converts SQL query fragments of different databases according to different database drivers.
Further, a searching method for realizing visual flexible combination dynamic configuration comprises the following steps:
s1: setting different query conditions according to different pages in software development, clicking a new button to add page query condition configuration, wherein page coding is not repeatable, and a software system queries the advanced condition configuration of a page through page coding when using advanced query;
s2: jumping to the query condition after clicking the search field on the advanced query management list;
s3: clicking the sorting field to define whether the page list column supports database sorting;
s4: after configuration management is completed, the software system calls the interface when the function page uses advanced query.
Furthermore, the searching method for realizing the visual flexible combination dynamic configuration can perform the operations of adding, editing and deleting the query condition; elements of the query condition configuration include field names, SQL fragments, types, expressions, rankings, and groupings.
Furthermore, the field name refers to the name of query condition display when the software system is used, the SQL fragment refers to the SQL sentence field executed by the rear end of the software system in the database, the type refers to the type of a condition input box, the method comprises text, numerical value, date, cascade connection, enumeration and numerical value interval, the ordering refers to the sequence of query condition display, the grouping refers to the page query condition, and the page query condition is divided into a plurality of query SQL fragments according to grouping identification, so that the method is suitable for an advanced query application scene containing sub-query SQL in the software system.
Furthermore, a search method for realizing visual flexible combination dynamic configuration is provided, wherein the types and the expressions have cascade relation;
if the type selects the text, the expression can select equal, contain, not contain and index;
the index refers to the fact that the privacy data is stored in an encrypted mode and simultaneously the index field is stored, and only the index field can be queried when the privacy data is queried under the condition;
if the type selects the numerical value, the expression can be selected to be equal to, smaller than, larger than, smaller than or equal to or larger than or equal to;
if the type selects a date, the expression can select an intermediate (date range);
if the type selects enumeration, an enumeration URL address is required to be configured for inquiring the enumerated value, and the expression can be selected to belong to and support multiple selection and single selection at the same time;
if the type selects the area, the expression can be selected to be equal to;
the region refers to three-level linkage of province-city-district of national administrative region;
if the type is selected to be complemented, and the URL address of the data source is required to be configured, inputting the keyword to automatically complement the data through the URL address, the expression can be selected to be equal to the data;
if the type selects cascade connection, and the data source URL is configured at the same time, the multi-stage cascade connection linkage condition can be displayed, and the expression can be selected to be equal to, contain and belong to;
if the type selects the numerical value interval, the numerical value input box inputs the minimum value and the maximum value of the numerical value, and the expression can only be selected between the minimum value and the maximum value.
The invention has the beneficial effects that: the visual and flexible diversified configuration of the query conditions are realized, the research and development in software development is not needed to write the condition query codes, the front end only needs to introduce the advanced query public components, and the repeated writing of the query condition codes and the change of codes for each new query condition are not needed. The front and back research and development, testing workload and cost are greatly reduced. Aiming at different inquiry conditions in different areas, the system can be flexibly combined and flexibly configured, and the universality and reusability of the system are effectively improved.
Drawings
FIG. 1 is a flow chart of a search method implementing a visual flexible combination dynamic configuration.
Detailed Description
For a clearer understanding of technical features, objects, and effects of the present invention, a specific embodiment of the present invention will be described with reference to the accompanying drawings.
As shown in figure 1, the method for realizing the visual flexible combination dynamic configuration search comprises configuration management and OPS-SDK.
A search method for realizing visual flexible combination dynamic configuration, wherein the configuration management realizes the visual and dynamic configuration management functions of page query conditions, and comprises the steps of adding, copying, importing, exporting, deleting, configuring search fields and configuring sorting fields for page query conditions.
A searching method for realizing visual flexible combination dynamic configuration is characterized in that an OPS-SDK package is introduced in software development, and a program automatically analyzes and converts SQL query fragments of different databases according to different database drivers.
A search method for realizing visual flexible combination dynamic configuration comprises the following steps:
s1: setting different query conditions according to different pages in software development, clicking a new button to add page query condition configuration, wherein page coding is not repeatable, and a software system queries the advanced condition configuration of a page through page coding when using advanced query;
s2: jumping to the query condition after clicking the search field on the advanced query management list;
s3: clicking the sorting field to define whether the page list column supports database sorting;
s4: after configuration management is completed, the software system calls the interface when the function page uses advanced query.
The searching method for realizing the visual flexible combination dynamic configuration comprises the steps of adding, editing and deleting the query conditions; elements of the query condition configuration include field names, SQL fragments, types, expressions, rankings, and groupings.
A search method for realizing visual flexible combination dynamic configuration, wherein the field name refers to the name of query condition display when a software system is used, the SQL fragment refers to the SQL sentence field executed by the rear end of the software system in a database, the type refers to the type of a condition input box, the method comprises text, numerical value, date, cascade connection, enumeration and numerical value interval, the sequence refers to the sequence of query condition display, the grouping refers to the page query condition and is divided into a plurality of query SQL fragments according to grouping identification, and the method is suitable for a high-level query application scene containing sub-query SQL in the software system.
A search method for realizing visual flexible combination dynamic configuration, wherein the types and expressions have cascade relation;
if the type selects the text, the expression can select equal, contain, not contain and index;
the index refers to the fact that the privacy data is stored in an encrypted mode and simultaneously the index field is stored, and only the index field can be queried when the privacy data is queried under the condition;
if the type selects the numerical value, the expression can be selected to be equal to, smaller than, larger than, smaller than or equal to or larger than or equal to;
if the type selects a date, the expression can select an intermediate (date range);
if the type selects enumeration, an enumeration URL address is required to be configured for inquiring the enumerated value, and the expression can be selected to belong to and support multiple selection and single selection at the same time;
if the type selects the area, the expression can be selected to be equal to;
the region refers to three-level linkage of province-city-district of national administrative region;
if the type is selected to be complemented, and the URL address of the data source is required to be configured, inputting the keyword to automatically complement the data through the URL address, the expression can be selected to be equal to the data;
if the type selects cascade connection, and data source URL is configured at the same time, multi-stage cascade connection linkage conditions can be displayed, and expressions can be selected to be equal to, contain, belong to and the like;
if the type selects the numerical value interval, the numerical value input box inputs the minimum value and the maximum value of the numerical value, and the expression can only be selected between the minimum value and the maximum value.
A searching method for realizing visual flexible combination dynamic configuration can flexibly combine different condition inquiry modes to carry out accurate inquiry.
For example, when the software system uses advanced query, the backend needs to inherit the advquery advanced query base class, where filters: querying a condition set, sorters: a set of sorting conditions;
the AdvQuerySqlBuilder class in the OPS-SDK completes the analysis and assembly of the query condition and the ordering condition SQL fragment;
the back-end research and development adds $ { big.sql } in the corresponding query SQL of the Mapper to realize the flexible configuration of the advanced query.
According to the scheme, the searching method for realizing the visual flexible combination dynamic configuration is used for realizing the visual flexible diversified configuration query conditions, the condition query codes are not required to be written in the development of software, the front end only needs to introduce a high-level query public component, and the repeated writing of the query condition codes and the modification of codes for each new query condition are not required. The front and back research and development, testing workload and cost are greatly reduced. Aiming at different inquiry conditions in different areas, the system can be flexibly combined and flexibly configured, and the universality and reusability of the system are effectively improved.
The foregoing has shown and described the basic principles and main features of the present invention and the advantages of the present invention. It will be understood by those skilled in the art that the present invention is not limited to the embodiments described above, and that the above embodiments and descriptions are merely illustrative of the principles of the present invention, and various changes and modifications may be made without departing from the spirit and scope of the invention, which is defined in the appended claims. The scope of the invention is defined by the appended claims and equivalents thereof.
Claims (2)
1. A search method for realizing visual flexible combination dynamic configuration is characterized by realizing visual flexible combination dynamic configuration advanced search, comprising configuration management and OPS-SDK;
the method comprises the following steps:
s1: setting different query conditions according to different pages in software development, clicking a new button to add page query condition configuration, wherein page coding is not repeatable, and a software system queries the advanced condition configuration of a page through page coding when using advanced query;
s2: jumping to the query condition after clicking the search field on the advanced query management list;
s3: clicking the sorting field to define whether the page list column supports database sorting;
s4: after the configuration management is completed, the software system calls an interface when the function page uses advanced inquiry;
the OPS-SDK refers to that OPS-SDK packages are introduced in software development, and a program automatically analyzes and converts SQL query fragments of different databases according to different database drivers;
the inquiry condition can be subjected to new adding, editing and deleting operations; the elements of the query condition configuration include field names, SQL fragments, types, expressions, ranks, and groupings;
the field names refer to names displayed by query conditions when the software system is used, the SQL fragments refer to SQL statement fields executed by the rear end of the software system in a database, the types refer to the types of condition input boxes, the types comprise texts, numerical values, dates, cascading, enumeration and numerical value intervals, the ordering refers to the sequence of displaying the query conditions, the grouping refers to page query conditions, and the page query conditions are divided into a plurality of query SQL fragments according to grouping identifiers, so that the method is suitable for an advanced query application scene containing sub-query SQL in the software system;
the type has a cascade relation with the expression;
if the type selects the text, the expression can select equal, contain, not contain and index;
the index refers to the fact that the privacy data is stored in an encrypted mode and simultaneously the index field is stored, and only the index field can be queried when the privacy data is queried under the condition;
if the type selects the numerical value, the expression can be selected to be equal to, smaller than, larger than, smaller than or equal to or larger than or equal to;
if the type selects the date, the expression can be selected to be between the date range;
if the type selects enumeration, an enumeration URL address is required to be configured for inquiring the enumerated value, and the expression can be selected to belong to and support multiple selection and single selection at the same time;
if the type selects the area, the expression can be selected to be equal to;
the region refers to three-level linkage of province-city-district of national administrative region;
if the type is selected to be complemented, and the URL address of the data source is required to be configured, inputting the keyword to automatically complement the data through the URL address, the expression can be selected to be equal to the data;
if the type selects cascade connection, and the data source URL is configured at the same time, the multi-stage cascade connection linkage condition can be displayed, and the expression can be selected to be equal to, contain and belong to;
if the type selects the numerical value interval, the numerical value input box inputs the minimum value and the maximum value of the numerical value, and the expression can only be selected between the minimum value and the maximum value.
2. The method for searching for realizing the visual flexible combination dynamic configuration according to claim 1, wherein the configuration management realizes the visual and dynamic configuration management functions of the page query conditions, and comprises the steps of adding, copying, importing, exporting, deleting, configuring search fields and configuring sorting fields to the page query conditions.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311107632.3A CN116821164B (en) | 2023-08-31 | 2023-08-31 | Searching method for realizing visual flexible combination dynamic configuration |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311107632.3A CN116821164B (en) | 2023-08-31 | 2023-08-31 | Searching method for realizing visual flexible combination dynamic configuration |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN116821164A CN116821164A (en) | 2023-09-29 |
| CN116821164B true CN116821164B (en) | 2023-11-21 |
Family
ID=88116997
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311107632.3A Active CN116821164B (en) | 2023-08-31 | 2023-08-31 | Searching method for realizing visual flexible combination dynamic configuration |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116821164B (en) |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101221566A (en) * | 2007-07-15 | 2008-07-16 | 杨筑平 | Information searching and access authorization method |
| CN102567032A (en) * | 2010-12-08 | 2012-07-11 | 金蝶软件（中国）有限公司 | Common interface configuration method and computer |
| CN104063523A (en) * | 2014-07-21 | 2014-09-24 | 焦点科技股份有限公司 | E-commerce search scoring and ranking method and system |
| WO2017027868A1 (en) * | 2015-08-13 | 2017-02-16 | PositiveEdge Solutions LLC | Configurable development platform integrating heterogeneous persistence systems |
| CN112035510A (en) * | 2020-08-28 | 2020-12-04 | 中电长城(长沙)信息技术有限公司 | Complex data query method and system for information system |
| CN112182349A (en) * | 2020-09-14 | 2021-01-05 | 支付宝(杭州)信息技术有限公司 | Method, device and system for querying compliance file |
| CN113887183A (en) * | 2021-09-29 | 2022-01-04 | 中广核工程有限公司 | Configurable data report and table configuration method and computer terminal |
| CN114443683A (en) * | 2021-12-16 | 2022-05-06 | 广东电网有限责任公司 | System, method, device and medium for on-site query of automatic operation of power grid equipment |
| CN115618410A (en) * | 2022-10-10 | 2023-01-17 | 浪潮云信息技术股份公司 | Independent control method for data authority |
-
2023
- 2023-08-31 CN CN202311107632.3A patent/CN116821164B/en active Active
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101221566A (en) * | 2007-07-15 | 2008-07-16 | 杨筑平 | Information searching and access authorization method |
| CN102567032A (en) * | 2010-12-08 | 2012-07-11 | 金蝶软件（中国）有限公司 | Common interface configuration method and computer |
| CN104063523A (en) * | 2014-07-21 | 2014-09-24 | 焦点科技股份有限公司 | E-commerce search scoring and ranking method and system |
| WO2017027868A1 (en) * | 2015-08-13 | 2017-02-16 | PositiveEdge Solutions LLC | Configurable development platform integrating heterogeneous persistence systems |
| CN112035510A (en) * | 2020-08-28 | 2020-12-04 | 中电长城(长沙)信息技术有限公司 | Complex data query method and system for information system |
| CN112182349A (en) * | 2020-09-14 | 2021-01-05 | 支付宝(杭州)信息技术有限公司 | Method, device and system for querying compliance file |
| CN113887183A (en) * | 2021-09-29 | 2022-01-04 | 中广核工程有限公司 | Configurable data report and table configuration method and computer terminal |
| CN114443683A (en) * | 2021-12-16 | 2022-05-06 | 广东电网有限责任公司 | System, method, device and medium for on-site query of automatic operation of power grid equipment |
| CN115618410A (en) * | 2022-10-10 | 2023-01-17 | 浪潮云信息技术股份公司 | Independent control method for data authority |
Non-Patent Citations (2)
| Title |
|---|
| MEST: A Model-Driven Efficient Searching Approach for MapReduce Self-Tuning;Zhendong Bei 等;IEEE Access;3580 - 3593 * |
| 一个可配置用户界面生成器的设计与实现;吕信;中国优秀硕士学位论文全文数据库 信息科技辑;I138-1401 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN116821164A (en) | 2023-09-29 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7124148B2 (en) | User-friendly search results display system, method, and computer program product | |
| US7844623B2 (en) | Method to provide management of query output | |
| CN1307585C (en) | Data processing method for realizing data base multitable inguiry | |
| EP0120185B1 (en) | Computing apparatus and method for translating into a linear query a graphic language query | |
| US5761657A (en) | Global optimization of correlated subqueries and exists predicates | |
| US6826566B2 (en) | Identifier vocabulary data access method and system | |
| US8156125B2 (en) | Method and apparatus for query and analysis | |
| US7231396B2 (en) | Data abstraction layer for a database | |
| US7567952B2 (en) | Optimizing a computer database query that fetches n rows | |
| US7853603B2 (en) | User-defined relevance ranking for search | |
| US20080319958A1 (en) | Dynamic Metadata based Query Formulation for Multiple Heterogeneous Database Systems | |
| US20040093330A1 (en) | System and method for data storage and retrieval | |
| US7624122B2 (en) | Method and system for querying a database | |
| KR20040104465A (en) | Efficiently storing indented threads in threaded application | |
| US20060253410A1 (en) | Database reverse query matching | |
| US8065343B2 (en) | Data storage and retrieval system with optimized categorization of information items based on category selection | |
| US20120096054A1 (en) | Reading rows from memory prior to reading rows from secondary storage | |
| CN1601524A (en) | Fuzzy inquiry system and method | |
| CN116821164B (en) | Searching method for realizing visual flexible combination dynamic configuration | |
| US20030172048A1 (en) | Text search system for complex queries | |
| CN100456285C (en) | Method and device for accessing a database | |
| US7627553B1 (en) | Custom queries for segmentation | |
| CN118093986A (en) | Cloud search system based on distributed search engine | |
| CN117130937A (en) | Test case processing method, device, electronic equipment and storage medium | |
| CN116680319A (en) | Retrieval method and system based on system metadata |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |