CN110297843B - Data query method and system for B/S system and terminal - Google Patents
Data query method and system for B/S system and terminal Download PDFInfo
- Publication number
- CN110297843B CN110297843B CN201910591953.2A CN201910591953A CN110297843B CN 110297843 B CN110297843 B CN 110297843B CN 201910591953 A CN201910591953 A CN 201910591953A CN 110297843 B CN110297843 B CN 110297843B
- Authority
- CN
- China
- Prior art keywords
- query
- dynamic
- condition
- public
- component
- 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
- 238000000034 method Methods 0.000 title claims abstract description 42
- 238000012545 processing Methods 0.000 claims abstract description 14
- 230000008569 process Effects 0.000 claims abstract description 3
- 230000005540 biological transmission Effects 0.000 claims description 39
- 230000003068 static effect Effects 0.000 claims description 28
- 238000001914 filtration Methods 0.000 claims description 14
- 238000004806 packaging method and process Methods 0.000 claims description 9
- 230000006870 function Effects 0.000 claims description 5
- 238000004590 computer program Methods 0.000 claims description 4
- 238000012423 maintenance Methods 0.000 abstract description 11
- 230000004048 modification Effects 0.000 abstract description 8
- 238000012986 modification Methods 0.000 abstract description 8
- 238000011161 development Methods 0.000 abstract description 7
- 230000018109 developmental process Effects 0.000 description 6
- 230000008859 change Effects 0.000 description 5
- 239000008186 active pharmaceutical agent Substances 0.000 description 3
- 230000007547 defect Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000002347 injection Methods 0.000 description 1
- 239000007924 injection Substances 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 230000011218 segmentation Effects 0.000 description 1
- 239000000243 solution Substances 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 238000010200 validation analysis Methods 0.000 description 1
- 239000002699 waste material Substances 0.000 description 1
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
-
- 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/245—Query processing
- G06F16/2455—Query execution
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Mathematical Physics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a data query method, a system and a terminal for a B/S system, which belong to the field of B/S system query, and solve the technical problems of how to realize rapid development and deployment of query operation and realize flexible modification and immediate effectiveness of query configuration during later maintenance; the method comprises the following steps: forming a query statement by configuring query information through a public query component, and storing the query statement through a database public query component configuration table; the public query component is called through a client foreground to acquire a query result; and calling a public query component through background logic to uniformly process different query configurations. The system comprises a configuration module, a query module and a logic processing module. The terminal includes a processor, an input device, an output device, and a memory, the processor being configured to invoke the program instructions to perform a data query method for the B/S system.
Description
Technical Field
The invention relates to the field of B/S system query, in particular to a data query method, a data query system and a data query terminal for a B/S system.
Background
At present, the traditional web application development is accompanied by a large number of foreground and background data interaction operations, wherein the number of requests mainly inquired occupies a high proportion, and the inquiry operations not only bring a large number of repeated coding works, but also cause the security problem of codes, and meanwhile, cause certain difficulty for later maintenance work, waste a large amount of time and cause great burden on project cost.
Based on the analysis, how to realize rapid development and deployment of query operation and realize flexible modification and immediate effectiveness of query configuration during later maintenance is a technical problem to be solved.
Disclosure of Invention
The technical task of the invention is to provide a data query method, a system and a terminal for a B/S system aiming at the defects, so as to solve the problems of how to realize rapid development and deployment of query operation and realizing flexible modification and immediate effectiveness of query configuration during later maintenance.
In a first aspect, the present invention provides a data query method for a B/S system, implementing a common query logic through a common query component, including:
forming a query statement by configuring query information through a public query component, and storing the query statement through a database public query component configuration table;
the public query component is called through a client foreground to acquire a query result;
calling a public query component through background logic to uniformly process different query configurations;
the query statement is a query SQL statement, including but not limited to a query configuration number, a query field, a table name, a query condition, a sorting condition, and a grouping condition, where the query condition includes a static query condition, a dynamic In query condition, and a dynamic Like query condition, at least one of the query statements, and each query statement corresponds to a query configuration.
In the embodiment, the public query component configures the query statement in the public query component configuration table of the database, so that flexible modification and maintenance of rules are realized, the acquired query information supports various parameter configurations such as static state, dynamic state and the like, and powerful guarantee is provided for the security of the query operation.
Preferably, the query statement is formed by configuring query information through a public query component, and the query statement is stored through a database public query component configuration table, comprising:
switching between different query configurations based on a dynamic parameter transmission mode of a client foreground;
dynamically loading query configuration and transmitting dynamic parameters of dynamic query conditions based on a dynamic parameter transmission mode of a client foreground;
and carrying out change maintenance on the query statement based on a dynamic parameter transmission mode of the client foreground, wherein the change maintenance comprises modification of query fields, table names, query conditions, ordering conditions and grouping conditions.
Preferably, when the query information is configured by the public query component to form a query statement, the variables in the query information are wrapped with @.
Preferably, the query information is configured by the public query component to form a query statement, and the method further comprises the step of filtering data in the query information by combining static query condition configuration and dynamic query condition loading, and specifically comprises the following steps:
the query conditions which are not changed and do not need dynamic value transmission are configured in the static query conditions of the public query component configuration table of the database;
configuring the query conditions needing dynamic value transmission in the dynamic query conditions of the public query component configuration table of the database;
and parameter value transmission is carried out on parameters of the dynamic query conditions in a client foreground page parameter transmission mode, so that dynamic condition filtering of data in query sentences is realized.
Preferably, the public query component is called by the client foreground to acquire the query result, which comprises the following steps:
providing a JavaScript API packaging method through a client foreground, and calling a public query component through an introduced JS file by the client foreground;
the client foreground calls an exectepubeasy sqltable method and obtains a query result by transmitting a query configuration number or a dynamic query condition.
Preferably, when a query result is obtained by transmitting a dynamic query condition, the parameter name of the dynamic query condition is a variable wrapped by @ @ in corresponding query configuration;
the parameters of the dynamic query condition have a plurality of values, the values are separated by commas, and the parameters are separated by semicolons when the dynamic query condition has a plurality of parameters.
Preferably, the unified processing of different query configurations by invoking a common query component through background logic includes:
acquiring query configuration;
identifying parameters of the query information;
packaging parameters of the query information;
binding variables in parameters of the query information;
and executing the query based on the query statement, and returning a query result.
In a second aspect, the present invention provides a data query system for a B/S system, comprising:
the configuration module is used for configuring query information through the public query component to form query sentences and calling a database public query component configuration table to store the query sentences;
the query module is used for calling a public query component through a client foreground to acquire a query result;
the logic processing module is used for calling the public query component through background logic and uniformly processing different query configurations;
the query statement configured by the configuration module is a query SQL statement, including but not limited to a query configuration number, a query field, a table name, a query condition, a sorting condition, and a grouping condition, wherein the query condition includes a static query condition, a dynamic In query condition, and a dynamic Like query condition, at least one of the query statement corresponds to one query configuration.
In a third aspect, the present invention provides a terminal comprising a processor, an input device, an output device and a memory, the processor, the input device, the output device and the memory being interconnected, the memory being for storing a computer program comprising program instructions, the processor being configured to invoke the program instructions to perform a data querying method for a B/S system according to any of the first aspects.
The data query method and system for the B/S system and the terminal have the following advantages:
1. the public query component is used for configuring query sentences in the public query component configuration table of the database, so that flexible modification and maintenance of rules are realized, the acquired query information supports various parameter configurations such as static state, dynamic state and the like, and the security of data query operation is effectively ensured;
2. the grouping and ordering conditions of the data to be queried can be configured through the database, the static query conditions, the dynamic query conditions and the complex query conditions can be configured through the database, and the non-stop validation can be supported through the database configuration query rules, so that the maintenance of functions is facilitated;
3. the configuration of static query conditions is supported, the query conditions of dynamically acquired values are not needed, the configuration of dynamic query conditions is supported, the configuration of the same dynamic conditions which can be matched with a plurality of values is supported, and the number of the values can be adjusted according to requirements;
4. under the condition of supporting dynamic acquisition of dynamic condition parameter values, the method solves the safety problems of injection of SQL, and the like, ensures that parameter values are compared under the condition of only character strings, cannot influence SQL, cannot split and change original SQL, ensures that irrelevant data cannot be leaked, and ensures that user data is greatly ensured to be safe.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings that are needed in the description of the embodiments will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
The invention is further described below with reference to the accompanying drawings.
FIG. 1 is a flow chart of a data query method for a B/S system according to embodiment 1.
Detailed Description
The invention will be further described with reference to the accompanying drawings and specific examples, so that those skilled in the art can better understand the invention and implement it, but the examples are not meant to limit the invention, and the technical features of the embodiments of the invention and the examples can be combined with each other without conflict.
The embodiment of the invention provides a data query method, a data query system and a data query terminal for a B/S system, which are used for solving the technical problems of how to realize rapid development and deployment of query operation and realizing flexible modification and immediate effectiveness of query configuration during later maintenance.
Example 1:
as shown in FIG. 1, a data query method for a B/S system of the present invention implements common query logic through a common query component, comprising:
s100, configuring query information through a public query component to form query sentences, and storing the query sentences through a database public query component configuration table;
s200, calling a public query component through a client foreground to acquire a query result;
s300, calling a public query component through background logic, and uniformly processing different query configurations.
The query statement is a query SQL statement, including but not limited to a query configuration number, a query field, a table name, a query condition, a sorting condition, and a grouping condition, where the query condition includes a static query condition, a dynamic In query condition, and a dynamic Like query condition, at least one of the query statement corresponds to one query configuration.
Wherein, the query statement is formed by configuring the query information through the public query component, and the query statement is stored through the public query component configuration table of the database, comprising the following modes:
the first mode is based on a dynamic parameter transmission mode of a client foreground, and switching is carried out among different query configurations;
mode two, based on the dynamic parameter transmission mode of the client foreground, dynamically loading the query configuration and transmitting the dynamic parameters of the dynamic query conditions;
and thirdly, based on a dynamic parameter transmission mode of a client foreground, changing and maintaining query sentences, including modifying query fields, table names, query conditions, ordering conditions and grouping conditions, and supporting the flexibility of a public query component technology.
In step S100, the common query component uniformly configures the SQL used for development in the common query component configuration table of the database, for uniform maintenance and centralized management of queries. The common query component configuration table structure is shown in the following table:
taking the simple query requirement of a service as an example, the original query SQL is developed as follows:
a query service requires explicit query fields, table names, dynamic queries, static queries, ordering, grouping conditions, etc. As shown in the example query statement, the query field IS user_id, user_name, table NAME pub_users, static query condition IS account_status= '11', dynamic query condition IS AND is_sys=? AND security_level=? AND CREATE _time LIKE CONCAT ("%" ) AND user_NAME IN (. Wherein, the static inquiry condition will not change with the business change, the dynamic inquiry condition needs to interact with the user to dynamically input the condition value, the dynamic inquiry also includes the multi-value matching of IN.
The common query component needs to configure the development original query SQL statement into the database. The MySql database configuration example is as follows, and according to the configuration description of the configuration table, the SQL type, the query column name, the query table name, the static query condition, the dynamic In query condition, the dynamic like query condition, the ordering, grouping and the grouping filtering condition of the original SQL statement are configured, and each complete configuration represents a complete query SQL statement.
When the query information is configured through the public query component to form a query statement, variables in the query information are wrapped by @. I.e., security_level=? Is? Part) wrapped with @ @, such as: the @ SECURITYLEVEL @; the multiple-value matching variable is written only one, such as: user_name IN (@ USER @). The code is as follows:
in step S200, the public query component is invoked by the client foreground to obtain a query result, which includes the following steps:
s210, providing a JavaScript API packaging method through a client foreground, and calling a public query component through an introduced JS file by the client foreground;
s220, calling an exectepubeasy SqlTable method by a client foreground, and acquiring a query result by transmitting a query configuration number or a dynamic query condition, wherein the parameter name of the dynamic query condition is a variable wrapped by @ in corresponding configuration, for example @ SECURITYLEVEL@ in configuration, the foreground transmits the parameter name by using SECURITYLEVEL=XXXX, and a plurality of values are separated by 'commas' for the condition that one parameter has a plurality of values; ' division number segmentation.
The core code of step S210 is as follows:
in step S300, the common query component is invoked by the background logic to perform unified processing on different query configurations, including the following contents:
acquiring query configuration;
identifying parameters of the query information;
packaging parameters of the query information;
binding variables in parameters of the query information;
and executing the query based on the query statement, and returning a query result.
The core code of the step S300 is:
as a further improvement of the present embodiment, filtering the data in the query information by combining static query condition configuration with dynamic query condition loading includes:
the query conditions which are not changed and do not need dynamic value transmission are configured in the static query conditions of the public query component configuration table of the database;
configuring the query conditions needing dynamic value transmission in the dynamic query conditions of the public query component configuration table of the database;
and parameter value transmission is carried out on parameters of the dynamic query conditions in a client foreground page parameter transmission mode, so that dynamic condition filtering of data in query sentences is realized.
The dynamic condition query also supports filtering query operation of multiple values of the same variable, and the method further comprises filtering data in query information by combining static query condition configuration and dynamic query condition loading, and comprises the following steps:
the query conditions which are not changed and do not need dynamic value transmission are configured in the static query conditions of the public query component configuration table of the database;
configuring the query conditions needing dynamic value transmission in the static query conditions of the public query component configuration table of the database;
and parameter value transmission is carried out on parameters of the dynamic query conditions in a client foreground page parameter transmission mode, so that dynamic condition filtering of data in query sentences is realized.
Example 2:
the data query system for the B/S system comprises a configuration module, a query module and a logic processing module, wherein the configuration module is used for configuring query information through a public query component to form query sentences and calling a database public query component configuration table to store the query sentences; the query module is used for calling a public query component through a client foreground to acquire a query result; the logic processing module is used for calling the public query component through background logic and uniformly processing different query configurations.
The query statement configured by the configuration module is a query SQL statement, including but not limited to a query configuration number, a query field, a table name, a query condition, a sorting condition, and a grouping condition, where the query condition includes a static query condition, a dynamic In query condition, and a dynamic Like query condition, and at least one of the query statement corresponds to one query configuration.
The configuration module has the following functions: forming a query statement by configuring query information through a public query component, and storing the query statement through a database public query component configuration table, wherein the query statement comprises the following modes:
the first mode is based on a dynamic parameter transmission mode of a client foreground, and switching is carried out among different query configurations;
mode two, based on the dynamic parameter transmission mode of the client foreground, dynamically loading the query configuration and transmitting the dynamic parameters of the dynamic query conditions;
and thirdly, based on a dynamic parameter transmission mode of a client foreground, changing and maintaining query sentences, including modifying query fields, table names, query conditions, ordering conditions and grouping conditions, and supporting the flexibility of a public query component technology.
The query module is a module with the following functions:
(1) The method comprises the steps that a JavaScript API packaging method is provided through a client foreground, the client foreground calls a public query component through an introduced JS file, when a query result is obtained through transmitting a dynamic query condition, the parameter name of the dynamic query condition is a variable wrapped by @ @ in corresponding query configuration, the parameter of the dynamic query condition has a plurality of values, the values are separated by commas, and when the dynamic query condition has a plurality of parameters, the parameters are separated by semicolons;
(2) The client foreground calls an exectepubeasy sqltable method and obtains a query result by transmitting a query configuration number or a dynamic query condition.
The logic processing module is used for realizing unified processing of different query configurations by calling a public query component through background logic through the following steps:
(1) Acquiring query configuration;
(2) Identifying parameters of the query information;
(3) Packaging parameters of the query information;
(4) Binding variables in parameters of the query information;
(5) And executing the query based on the query statement, and returning a query result.
The configuration module also has the following functions: the method comprises the steps of configuring query information through a public query component to form a query statement, filtering data in the query information through a mode of combining static query condition configuration and dynamic query condition loading, and specifically comprises the following steps:
the query conditions which are not changed and do not need dynamic value transmission are configured in the static query conditions of the public query component configuration table of the database;
configuring the query conditions needing dynamic value transmission in the static query conditions of the public query component configuration table of the database;
and parameter value transmission is carried out on parameters of the dynamic query conditions in a client foreground page parameter transmission mode, so that dynamic condition filtering of data in query sentences is realized.
The data query system for the B/S system of the present invention can implement the data query method for the B/S system disclosed in embodiment 1.
Example 3:
the present invention provides a terminal comprising a processor, an input device, an output device and a memory, the processor, the input device, the output device and the memory being interconnected, the memory being for storing a computer program comprising program instructions configured to invoke said program instructions to perform a data query method for a B/S system as disclosed in embodiment 1.
The above-described embodiments are merely preferred embodiments for fully explaining the present invention, and the scope of the present invention is not limited thereto. Equivalent substitutions and modifications will occur to those skilled in the art based on the present invention, and are intended to be within the scope of the present invention. The protection scope of the invention is subject to the claims.
Claims (6)
1. A data query method for a B/S system, characterized by implementing a common query logic by a common query component, comprising:
forming a query statement by configuring query information through a public query component, and storing the query statement through a database public query component configuration table;
the public query component is called through a client foreground to acquire a query result;
calling a public query component through background logic to uniformly process different query configurations;
the query statement is a query SQL statement, including but not limited to a query configuration number, a query field, a table name, a query condition, a sorting condition and a grouping condition, wherein the query condition comprises a static query condition, a dynamic In query condition and a dynamic Like query condition, at least one of the query statement corresponds to one query configuration;
forming a query statement by configuring query information through a public query component, and storing the query statement through a database public query component configuration table, wherein the method comprises the following steps:
switching between different query configurations based on a dynamic parameter transmission mode of a client foreground;
dynamically loading query configuration and transmitting dynamic parameters of dynamic query conditions based on a dynamic parameter transmission mode of a client foreground;
based on a dynamic parameter transmission mode of a client foreground, changing and maintaining query sentences, including modifying query fields, table names, query conditions, ordering conditions and grouping conditions;
when the query information is configured through the public query component to form a query statement, the variables in the query information are wrapped by @;
the method comprises the steps of configuring query information through a public query component to form a query statement, filtering data in the query information through a mode of combining static query condition configuration and dynamic query condition loading, and specifically comprises the following steps:
the query conditions which are not changed and do not need dynamic value transmission are configured in the static query conditions of the public query component configuration table of the database;
configuring the query conditions needing dynamic value transmission in the dynamic query conditions of the public query component configuration table of the database;
and parameter value transmission is carried out on parameters of the dynamic query conditions in a client foreground page parameter transmission mode, so that dynamic condition filtering of data in query sentences is realized.
2. The data query method for a B/S system according to claim 1, wherein the query result is obtained by calling a common query component through a client foreground, comprising the steps of:
providing a JavaScript API packaging method through a client foreground, and calling a public query component through an introduced JS file by the client foreground;
the client foreground calls an exectepubeasy sqltable method and obtains a query result by transmitting a query configuration number or a dynamic query condition.
3. The data query method for a B/S system according to claim 2, wherein when a query result is obtained by delivering a dynamic query condition, a parameter name of the dynamic query condition is a variable wrapped with @ in a corresponding query configuration;
the parameters of the dynamic query condition have a plurality of values, the values are separated by commas, and the parameters are separated by semicolons when the dynamic query condition has a plurality of parameters.
4. The data query method for a B/S system of claim 1, wherein the unified processing of the different query configurations by invoking the common query component through the background logic comprises:
acquiring query configuration;
identifying parameters of the query information;
packaging parameters of the query information;
binding variables in parameters of the query information;
and executing the query based on the query statement, and returning a query result.
5. A data query system for a B/S system, comprising:
the configuration module is used for configuring query information through the public query component to form query sentences and calling a database public query component configuration table to store the query sentences;
the query module is used for calling a public query component through a client foreground to acquire a query result;
the logic processing module is used for calling the public query component through background logic and uniformly processing different query configurations;
the query statement configured by the configuration module is a query SQL statement, including but not limited to a query configuration number, a query field, a table name, a query condition, a sorting condition and a grouping condition, wherein the query condition comprises at least one of a static query condition, a dynamic In query condition and a dynamic Like query condition, and each query statement corresponds to one query configuration;
the query module is a module with the following functions:
(1) The method comprises the steps that a JavaScript API packaging method is provided through a client foreground, the client foreground calls a public query component through an introduced JS file, when a query result is obtained through transmitting a dynamic query condition, the parameter name of the dynamic query condition is a variable wrapped by @ @ in corresponding query configuration, the parameter of the dynamic query condition has a plurality of values, the values are separated by commas, and when the dynamic query condition has a plurality of parameters, the parameters are separated by semicolons;
(2) The client foreground calls an exectepubeasy sqltable method and obtains a query result by transmitting a query configuration number or a dynamic query condition;
the query module is used for implementing the following steps that query information is configured through a public query component to form a query statement, and the query statement is stored through a database public query component configuration table:
switching between different query configurations based on a dynamic parameter transmission mode of a client foreground;
dynamically loading query configuration and transmitting dynamic parameters of dynamic query conditions based on a dynamic parameter transmission mode of a client foreground;
based on a dynamic parameter transmission mode of a client foreground, changing and maintaining query sentences, including modifying query fields, table names, query conditions, ordering conditions and grouping conditions;
when the query information is configured through the public query component to form a query statement, the variables in the query information are wrapped by @;
the method comprises the steps of configuring query information through a public query component to form a query statement, filtering data in the query information through a mode of combining static query condition configuration and dynamic query condition loading, and specifically comprises the following steps:
the query conditions which are not changed and do not need dynamic value transmission are configured in the static query conditions of the public query component configuration table of the database;
configuring the query conditions needing dynamic value transmission in the dynamic query conditions of the public query component configuration table of the database;
and parameter value transmission is carried out on parameters of the dynamic query conditions in a client foreground page parameter transmission mode, so that dynamic condition filtering of data in query sentences is realized.
6. A terminal comprising a processor, an input device, an output device and a memory, the processor, the input device, the output device and the memory being interconnected, the memory being for storing a computer program, the computer program comprising program instructions, the processor being configured to invoke the program instructions to perform a data query method for a B/S system as claimed in any of claims 1-4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910591953.2A CN110297843B (en) | 2019-07-02 | 2019-07-02 | Data query method and system for B/S system and terminal |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910591953.2A CN110297843B (en) | 2019-07-02 | 2019-07-02 | Data query method and system for B/S system and terminal |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110297843A CN110297843A (en) | 2019-10-01 |
| CN110297843B true CN110297843B (en) | 2023-04-28 |
Family
ID=68029917
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910591953.2A Active CN110297843B (en) | 2019-07-02 | 2019-07-02 | Data query method and system for B/S system and terminal |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110297843B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112307068A (en) * | 2020-11-10 | 2021-02-02 | 天元大数据信用管理有限公司 | Dynamic SQL query method |
| CN112559472B (en) * | 2020-12-07 | 2024-05-14 | 北京锐安科技有限公司 | File transmission method, device, computer equipment and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101178727A (en) * | 2006-11-08 | 2008-05-14 | 国际商业机器公司 | Method of querying relational database management systems |
| CN101706823A (en) * | 2009-12-18 | 2010-05-12 | 中兴通讯股份有限公司 | Inquiry system and method of customized database |
| CN102012945A (en) * | 2010-12-16 | 2011-04-13 | 重庆国际复合材料有限公司 | User-oriented database management system |
| JP2013025446A (en) * | 2011-07-19 | 2013-02-04 | Canon Marketing Japan Inc | Information processing apparatus, information processing system, information processing method, program and recording medium |
-
2019
- 2019-07-02 CN CN201910591953.2A patent/CN110297843B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101178727A (en) * | 2006-11-08 | 2008-05-14 | 国际商业机器公司 | Method of querying relational database management systems |
| CN101706823A (en) * | 2009-12-18 | 2010-05-12 | 中兴通讯股份有限公司 | Inquiry system and method of customized database |
| CN102012945A (en) * | 2010-12-16 | 2011-04-13 | 重庆国际复合材料有限公司 | User-oriented database management system |
| JP2013025446A (en) * | 2011-07-19 | 2013-02-04 | Canon Marketing Japan Inc | Information processing apparatus, information processing system, information processing method, program and recording medium |
Non-Patent Citations (2)
| Title |
|---|
| 基于SP防范SQL注入攻击的三层信息系统安全设计研究;黄辉;《情报探索》;20131115(第11期);全文 * |
| 计算机数据库信息查询方法及实现分析;杨超;《赤峰学院学报(自然科学版)》;20120825(第16期);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110297843A (en) | 2019-10-01 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11366856B2 (en) | System and method for updating target schema of graph model | |
| CN110443059B (en) | Data protection method and device | |
| US20200366463A1 (en) | Apparatuses for Providing a Set of Cryptographically Protected, Filtered, and Sorted Transaction Data Records of a Link of a Blockchain | |
| US7596550B2 (en) | System and method for query planning and execution | |
| US20130104100A1 (en) | Scripting Language for Business Applications | |
| US8244780B1 (en) | Parameter oriented automated database command | |
| CN102982075A (en) | Heterogeneous data source access supporting system and method thereof | |
| CN111443901B (en) | Java reflection-based service expansion method and device | |
| CN102591777A (en) | Unit test code generation method and device | |
| CN110297843B (en) | Data query method and system for B/S system and terminal | |
| US20200142674A1 (en) | Extracting web api endpoint data from source code | |
| US7640238B2 (en) | Query planning for execution using conditional operators | |
| CN103176892A (en) | Page monitoring method and system | |
| CN111782211A (en) | Parameter page dynamic generation method and device based on Vue component | |
| CN112597105B (en) | File association object processing method, server device and storage medium | |
| CN113987337A (en) | Search method, system, equipment and storage medium based on componentized dynamic arrangement | |
| CN110633459B (en) | Automatic generation method and system of data report forms and computer readable storage medium | |
| CN114564480A (en) | Data processing method and device based on Flink platform, electronic equipment and storage medium | |
| CN113342399A (en) | Application structure configuration method and device and readable storage medium | |
| CN114036180A (en) | Report generation method, device, equipment and storage medium | |
| CN111078726B (en) | Operation method of data access layer, server and storage medium | |
| CN114245890A (en) | Method and apparatus for providing function as a service platform | |
| CN106708864A (en) | Query framework-based data query method and apparatus | |
| US11341054B2 (en) | Method for data processing | |
| Pollack et al. | Spring Data MongoDB-Reference Documentation |
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 | ||
| TA01 | Transfer of patent application right | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20230315 Address after: 250000 Langchao Road, Jinan, Shandong Applicant after: Inspur Genersoft Co.,Ltd. Address before: 250100 No. 2877 Kehang Road, Sun Village Town, Jinan High-tech District, Shandong Province Applicant before: SHANDONG INSPUR GENESOFT INFORMATION TECHNOLOGY Co.,Ltd. |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |