CN110297843A - Data query method and system, terminal for B/S system - Google Patents
Data query method and system, terminal for B/S system Download PDFInfo
- Publication number
- CN110297843A CN110297843A CN201910591953.2A CN201910591953A CN110297843A CN 110297843 A CN110297843 A CN 110297843A CN 201910591953 A CN201910591953 A CN 201910591953A CN 110297843 A CN110297843 A CN 110297843A
- Authority
- CN
- China
- Prior art keywords
- query
- condition
- dynamic
- configuration
- enquiring 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 33
- 238000012423 maintenance Methods 0.000 claims abstract description 13
- 238000012545 processing Methods 0.000 claims abstract description 9
- 230000003068 static effect Effects 0.000 claims description 26
- 241000208340 Araliaceae Species 0.000 claims description 19
- 235000005035 Panax pseudoginseng ssp. pseudoginseng Nutrition 0.000 claims description 19
- 235000003140 Panax quinquefolius Nutrition 0.000 claims description 19
- 235000008434 ginseng Nutrition 0.000 claims description 19
- 238000001914 filtration Methods 0.000 claims description 8
- 230000008859 change Effects 0.000 claims description 7
- 230000004048 modification Effects 0.000 claims description 7
- 238000012986 modification Methods 0.000 claims description 7
- 238000004590 computer program Methods 0.000 claims description 5
- 238000004806 packaging method and process Methods 0.000 claims description 4
- 230000006870 function Effects 0.000 description 4
- 239000008186 active pharmaceutical agent Substances 0.000 description 3
- 238000002347 injection Methods 0.000 description 2
- 239000007924 injection Substances 0.000 description 2
- 230000008901 benefit Effects 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000018109 developmental process Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000002452 interceptive effect Effects 0.000 description 1
- 230000008569 process Effects 0.000 description 1
- 230000011218 segmentation Effects 0.000 description 1
- 239000000243 solution Substances 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
- 230000009466 transformation Effects 0.000 description 1
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 kind of data query method and system, terminals for B/S system, belong to B/S system queries field, technical problems to be solved are how to realize quick exploitation, the deployment of inquiry operation, and realize that the flexible of query configuration modifies, comes into force immediately in later maintenance；Method includes: to form query statement by common enquiring component configuration querying information, and store above-mentioned query statement by database common enquiring component allocation list；Common enquiring component is called by client foreground, obtains query result；Common enquiring component is called by background logic, different query configurations are uniformly processed.System, including configuration module, enquiry module and logic processing module.Terminal includes processor, input equipment, output equipment and memory, and processor is configured for the data query method for calling described program instruction execution to be used for B/S system.
Description
Technical field
The present invention relates to B/S system queries field, specifically a kind of data query method for B/S system and it is
System, terminal.
Background technique
Currently, traditional web application and development is with a large amount of foreground and background data interactive operation, wherein based on inquiry
Request number has captured high specific weight, these inquiry operations not only bring a large amount of duplicate coding works, or even will cause generation
The safety issue of code, while certain difficulty is caused to the maintenance work in later period, a large amount of time is wasted, and to item
Mesh cost causes very big burden.
Based on above-mentioned analysis, quick exploitation, the deployment of inquiry operation how to be realized, and realizes that inquiry is matched in later maintenance
Set it is flexible modification, come into force immediately, be the technical issues that need to address.
Summary of the invention
Technical assignment of the invention is against the above deficiency, to provide a kind of data query method for B/S system and be
System, terminal to solve how to realize quick exploitation, the deployment of inquiry operation, and realize the spirit of query configuration in later maintenance
The problem of modifying, coming into force immediately living.
In a first aspect, the present invention provides a kind of data query method for B/S system, realized by common enquiring component
Common query logic, comprising:
Query statement is formed by common enquiring component configuration querying information, and is configured by database common enquiring component
Table stores above-mentioned query statement；
Common enquiring component is called by client foreground, obtains query result；
Common enquiring component is called by background logic, different query configurations are uniformly processed；
Query statement is query SQL sentence, including but not limited to query configuration number, inquiry field, table name, inquiry item
Part, sort criteria and grouping condition, querying condition include Static Inquiry condition, dynamic queries condition, dynamic I n querying condition,
Dynamic Like querying condition, above-mentioned query statement at least one, the corresponding query configuration of each query statement.
In above embodiment, query statement is configured by common enquiring component and is configured in database common enquiring component
In table, the flexible modification and maintenance of rule are realized, query information is obtained and supports many kinds of parameters configuration such as static, dynamic, logarithm
Powerful guarantee is provided according to the safety of inquiry operation.
Preferably, forming query statement by common enquiring component configuration querying information, and looked by the way that database is public
It askes component Configuration table and stores above-mentioned query statement, comprising:
Dynamic based on client foreground passes ginseng mode, switches between different query configurations；
Dynamic based on client foreground passes ginseng mode, dynamically load query configuration and the dynamic for transmitting dynamic queries condition
Parameter；
Dynamic based on client foreground passes ginseng mode, changes maintenance to query statement, including modification inquire field,
Table name, querying condition, sort criteria and grouping condition.
Preferably, variable when forming query statement by common enquiring component configuration querying information, in query information
It is wrapped up with@@.
More preferably, query statement is formed by common enquiring component configuration querying information, further includes by Static Inquiry item
Part configuration is filtered data in query information with the mode that the load of dynamic queries condition combines, and specifically includes:
The querying condition that will not change, be not required to dynamic biography value is configured at the static state of database common enquiring component allocation list
In querying condition；
The querying condition for needing dynamic biography value is configured to the dynamic queries condition of database common enquiring component allocation list
In；
Parameter value transmitting is carried out to the parameter of dynamic queries condition in such a way that client front page layout passes ginseng, to realize
The dynamic condition filtering of data in query statement.
Preferably, calling common enquiring component by client foreground, query result is obtained, is included the following steps:
JavaScript API packaging method, the JS file tune that client foreground passes through introducing are provided by client foreground
Use common enquiring component；
ExecutePubEasySqlTable method is called on client foreground, and passes through transmitting query configuration number or dynamic
Querying condition obtains query result.
Preferably, when obtaining query result by transmitting dynamic queries condition, the entitled phase of the parameter of dynamic queries condition
The variable wrapped up in query configuration with@@is answered,；
The condition when parameter of dynamic queries condition has multiple values, the multiple value are separated with comma, and dynamic queries condition has more
When a parameter, the multiple parameter semicolon separated.
Preferably, calling common enquiring component by background logic, different query configurations are uniformly processed, are wrapped
It includes:
Obtain query configuration；
Identify the parameter of query information；
The parameter of query information is packed；
Bind the variable in the parameter of query information；
Inquiry is executed based on query statement, returns to query result.
Second aspect, the present invention provide a kind of data query system for B/S system, comprising:
Configuration module, the configuration module are used to form query statement by common enquiring component configuration querying information, and
For calling database common enquiring component allocation list to store above-mentioned query statement；
Enquiry module, the enquiry module are used to call common enquiring component by client foreground, obtain query result；
Logic processing module, the logic processing module is used to call common enquiring component by background logic, to difference
Query configuration is uniformly processed；
It is query SQL sentence by the query statement that configuration module configures, including but not limited to query configuration is numbered, inquired
Field, table name, querying condition, sort criteria and grouping condition, querying condition include Static Inquiry condition, dynamic queries condition,
Dynamic I n querying condition, dynamic Like querying condition, above-mentioned query statement at least one, the corresponding inquiry of each query statement
Configuration.
The third aspect, the present invention provide a kind of terminal, including processor, input equipment, output equipment and memory, processing
Device, input equipment, output equipment and memory are connected with each other, and memory is for storing computer program, the computer program
Including program instruction, the processor is configured for calling the described in any item use of described program instruction execution such as first aspect
In the data query method of B/S system.
Data query method and system, terminal for B/S system of the invention has the advantage that
1, query statement is configured in database common enquiring component allocation list by common enquiring component, realizes rule
Flexible modification and maintenance then obtain query information and support many kinds of parameters configuration such as static, dynamic, to the peace of data query operation
Full property provides powerful guarantee；
2, grouping, the sort criteria of the data of being inquired can be configured by database, can be configured static state by database and be looked into
Inquiry condition, dynamic queries condition and complex query condition, and can support not shut down to come into force by database configuration querying rule,
Convenient for the maintenance of function；
3, it supports the configuration of Static Inquiry condition, does not need the querying condition of dynamic acquisition value, dynamic queries condition is supported to match
It sets, supports same dynamic condition that can match the configuration of multiple values, the number of intermediate value can be adjusted according to demand；
4, in the case where supporting dynamic condition parameter values dynamic acquisition, the safety problems such as injection SQL injection are solved,
Guarantee that parameter value is compared under conditions of only character string, SQL will not be influenced, original SQL will not more be carried out
It splits and changes, ensure that extraneous data will not be revealed, obtained great safety assurance using user data.
Detailed description of the invention
It to describe the technical solutions in the embodiments of the present invention more clearly, below will be to required in being described in embodiment
The attached drawing used is briefly introduced, it should be apparent that, drawings in the following description are only some embodiments of the invention, for
For those skilled in the art, without creative efforts, it can also be obtained according to these attached drawings
His attached drawing.
The following further describes the present invention with reference to the drawings.
Attached drawing 1 is flow diagram of the embodiment 1 for the data query method of B/S system.
Specific embodiment
The present invention will be further explained below with reference to the attached drawings and specific examples, so that those skilled in the art can be with
It more fully understands the present invention and can be practiced, but illustrated embodiment is not as a limitation of the invention, the case where not conflicting
Under, the technical characteristic in the embodiment of the present invention and embodiment can be combined with each other.
The embodiment of the present invention provides data query method and system, the terminal for being used for B/S system, how to realize for solving
Quick exploitation, the deployment of inquiry operation, and realize that the flexible technology modified, come into force immediately of query configuration is asked in later maintenance
Topic.
Embodiment 1:
As shown in Fig. 1, a kind of data query method for B/S system of the invention passes through common enquiring component reality
Existing common query logic, comprising:
S100, query statement is formed by common enquiring component configuration querying information, and pass through database common enquiring group
Part allocation list stores above-mentioned query statement；
S200, common enquiring component is called by client foreground, obtains query result；
S300, common enquiring component is called by background logic, different query configurations is uniformly processed.
Wherein, query statement is query SQL sentence, and including but not limited to query configuration is numbered, inquiry field, table name, looked into
Inquiry condition, sort criteria and grouping condition, querying condition include Static Inquiry condition, dynamic queries condition, dynamic I n inquiry item
Part, dynamic Like querying condition, above-mentioned query statement at least one, the corresponding query configuration of each query statement.
Wherein, query statement is formed by common enquiring component configuration querying information, and passes through database common enquiring group
Part allocation list stores above-mentioned query statement, including following mode:
Mode one, the dynamic based on client foreground pass ginseng mode, switch between different query configurations；
Mode two, the dynamic based on client foreground pass ginseng mode, and dynamically load query configuration simultaneously transmits dynamic queries item
The dynamic parameter of part；
Mode three, the dynamic based on client foreground pass ginseng mode, change maintenance to query statement, including modification is looked into
Field, table name, querying condition, sort criteria and grouping condition are ask, supports the flexibility of common enquiring component technology.
Common enquiring component will develop the unified configuration of used SQL in the common enquiring component of database in step S100
Unified maintenance and centralized management in allocation list, for inquiry.It is as shown in the table that common enquiring component configures table structure:
By taking the simple queries demand of a business as an example, exploitation original query SQL is as follows:
One inquiry business needs clearly to inquire field, table name, dynamic queries, Static Inquiry, sequence, grouping condition etc..
With shown in sample query sentence, inquiry field is USER_ID, USER_NAME, table name PUB_USERS, Static Inquiry condition is
Do are ACCOUNT_STATUS='11', dynamic queries condition AND IS_SYS=? AND SECURITY_LEVEL=? AND
CREATE_TIME LIKE CONCAT (" % ",?, " % ") AND USER_NAME IN (?,?,?,?) AND USER_ID IN
(?,?,?,?), sort criteria is ORDER BY USER_ID DESC, and grouping condition is ORDER BY USER_ID DESC,
USER_NAME ASC.Wherein, Static Inquiry condition will not be changed with business and be changed, and dynamic queries condition needs to hand over user
Mutually dynamic is passed to condition value, and dynamic queries further include the multivalue matching of IN.
Common enquiring component needs for exploitation original query SQL statement to be configured in database.The configuration of MySql database is shown
Under such as, according to the configuration instruction of allocation list, to the SQL type, inquiry column name, inquiry table name, Static Inquiry of original SQL statement
Condition, dynamic queries condition, dynamic I n querying condition, dynamic like querying condition, sequence, grouping, packet filtering condition carry out
Configuration, each complete configuration represent a complete query SQL sentence.
When forming query statement by common enquiring component configuration querying information, the variable in query information is wrapped up with@@.
That is SECURITY_LEVEL=?? part) it is wrapped up with@@, such as :@SECURITYLEVEL@；Multivalue matching variable only writes one,
Such as: USER_NAME IN (@USERNAME@).Code is as follows:
In step S200, common enquiring component is called by client foreground, query result is obtained, includes the following steps:
S210, JavaScript API packaging method, the JS that client foreground passes through introducing are provided by client foreground
File calls common enquiring component；
S220, client foreground call executePubEasySqlTable method, and pass through transmitting query configuration number
Or dynamic queries condition etc. obtains query result, and the variable of package is used in the entitled corresponding configuration of the parameter of dynamic queries condition,
Such as be@SECURITYLEVEL@in configuration, then Transfer Parameters name in foreground need to use SECURITYLEVEL=XXXX, for one
A parameter has the case where multiple values, need to separate multiple values ', ' comma, used between multiple parameters '；' branch segmentation.
The core code of step S210 is as follows:
In step S300, common enquiring component is called by background logic, different query configurations are uniformly processed, is wrapped
Include following content:
Obtain query configuration；
Identify the parameter of query information；
The parameter of query information is packed；
Bind the variable in the parameter of query information；
Inquiry is executed based on query statement, returns to query result.
The core code of above-mentioned steps S300 are as follows:
It further include being loaded by the configuration of Static Inquiry condition with dynamic queries condition as further improvement of this embodiment
The mode combined is filtered data in query information, comprising:
The querying condition that will not change, be not required to dynamic biography value is configured at the static state of database common enquiring component allocation list
In querying condition；
The querying condition for needing dynamic biography value is configured to the dynamic queries condition of database common enquiring component allocation list
In；
Parameter value transmitting is carried out to the parameter of dynamic queries condition in such a way that client front page layout passes ginseng, to realize
The dynamic condition filtering of data in query statement.
Wherein, the filtering inquiry operation of the multiple values of the same variable is also supported in dynamic condition inquiry, further includes passing through static state
Querying condition configuration is filtered data in query information with the mode that the load of dynamic queries condition combines, comprising:
The querying condition that will not change, be not required to dynamic biography value is configured at the static state of database common enquiring component allocation list
In querying condition；
The querying condition for needing dynamic biography value is configured to the Static Inquiry condition of database common enquiring component allocation list
In；
Parameter value transmitting is carried out to the parameter of dynamic queries condition in such a way that client front page layout passes ginseng, to realize
The dynamic condition filtering of data in query statement.
Embodiment 2:
Data query system for B/S system of the invention, including configuration module, enquiry module and logical process mould
Block, configuration module are used to form query statement by common enquiring component configuration querying information, and for calling database public
Enquiring component allocation list stores above-mentioned query statement；Enquiry module is used to call common enquiring component by client foreground, obtains
Take query result；Logic processing module is used to call common enquiring component by background logic, unites to different query configurations
One processing.
It wherein, is query SQL sentence by the query statement that configuration module configures, including but not limited to query configuration is compiled
Number, inquiry field, table name, querying condition, sort criteria and grouping condition, querying condition includes Static Inquiry condition, dynamically looks into
Inquiry condition, dynamic I n querying condition, dynamic Like querying condition, above-mentioned query statement at least one, each query statement is corresponding
One query configuration.
Configuration module has following function: forming query statement by common enquiring component configuration querying information, and passes through
Database common enquiring component allocation list stores above-mentioned query statement, including following mode:
Mode one, the dynamic based on client foreground pass ginseng mode, switch between different query configurations；
Mode two, the dynamic based on client foreground pass ginseng mode, and dynamically load query configuration simultaneously transmits dynamic queries item
The dynamic parameter of part；
Mode three, the dynamic based on client foreground pass ginseng mode, change maintenance to query statement, including modification is looked into
Field, table name, querying condition, sort criteria and grouping condition are ask, supports the flexibility of common enquiring component technology.
Enquiry module is the module with following function:
(1) JavaScript API packaging method is provided by client foreground, client foreground is literary by the JS introduced
Part calls common enquiring component, and when obtaining query result by transmitting dynamic queries condition, the parameter of dynamic queries condition is entitled
With the variable of@@package in respective queries configuration, the condition when parameter of dynamic queries condition has multiple values, the multiple value comma
Separate, when dynamic queries condition has multiple parameters, the multiple parameter semicolon separated；
(2) client foreground call executePubEasySqlTable method, and by transmitting query configuration number or
Dynamic queries condition obtains query result.
Logic processing module, which is achieved by the steps of, calls common enquiring component by background logic, matches to different inquiries
It sets and is uniformly processed:
(1) query configuration is obtained；
(2) parameter of query information is identified；
(3) parameter of query information is packed；
(4) variable in the parameter of query information is bound；
(5) inquiry is executed based on query statement, returns to query result.
Wherein, configuration module also has following function: query statement is formed by common enquiring component configuration querying information,
It further include that data in query information are carried out in such a way that the configuration of Static Inquiry condition is combined with the load of dynamic queries condition
Filtering, specifically includes:
The querying condition that will not change, be not required to dynamic biography value is configured at the static state of database common enquiring component allocation list
In querying condition；
The querying condition for needing dynamic biography value is configured to the Static Inquiry condition of database common enquiring component allocation list
In；
Parameter value transmitting is carried out to the parameter of dynamic queries condition in such a way that client front page layout passes ginseng, to realize
The dynamic condition filtering of data in query statement.
Data query system for B/S system of the invention can realize the disclosed data for being used for B/S system of embodiment 1
Querying method.
Embodiment 3:
The present invention provides a kind of terminal, including processor, input equipment, output equipment and memory, and processor, input are set
Standby, output equipment and memory are connected with each other, and for memory for storing computer program, which includes that program refers to
It enables, which is configured for the data query for calling described program instruction execution to be used for B/S system as disclosed in embodiment 1
Method.
Embodiment described above is only to absolutely prove preferred embodiment that is of the invention and being lifted, protection model of the invention
It encloses without being limited thereto.Those skilled in the art's made equivalent substitute or transformation on the basis of the present invention, in the present invention
Protection scope within.Protection scope of the present invention is subject to claims.
Claims (9)
1. being used for the data query method of B/S system, it is characterised in that common query logic is realized by common enquiring component,
Include:
Query statement is formed by common enquiring component configuration querying information, and is deposited by database common enquiring component allocation list
Store up above-mentioned query statement；
Common enquiring component is called by client foreground, obtains query result；
Common enquiring component is called by background logic, different query configurations are uniformly processed；
Query statement is query SQL sentence, including but not limited to query configuration number, inquiry field, table name, querying condition, row
Sequence condition and grouping condition, querying condition includes Static Inquiry condition, dynamic queries condition, dynamic I n querying condition, dynamic
Like querying condition, above-mentioned query statement at least one, the corresponding query configuration of each query statement.
2. the data query method according to claim 1 for B/S system, it is characterised in that pass through common enquiring component
Configuration querying information forms query statement, and stores above-mentioned query statement by database common enquiring component allocation list, comprising:
Dynamic based on client foreground passes ginseng mode, switches between different query configurations；
Dynamic based on client foreground passes ginseng mode, dynamically load query configuration and the dynamic ginseng for transmitting dynamic queries condition
Number；
Dynamic based on client foreground passes ginseng mode, changes maintenance, including modification inquiry field, table to query statement
Name, querying condition, sort criteria and grouping condition.
3. the data query method according to claim 1 or 2 for B/S system, it is characterised in that pass through common enquiring
When component Configuration query information forms query statement, the variable in query information is wrapped up with@@.
4. the data query method according to claim 1 or 2 for B/S system, it is characterised in that pass through common enquiring
Component Configuration query information forms query statement, further includes mutually being tied by the configuration of Static Inquiry condition and the load of dynamic queries condition
The mode of conjunction is filtered data in query information, specifically includes:
The querying condition that will not change, be not required to dynamic biography value is configured at the Static Inquiry of database common enquiring component allocation list
In condition；
The querying condition for needing dynamic biography value is configured in the dynamic queries condition of database common enquiring component allocation list；
Parameter value transmitting is carried out to the parameter of dynamic queries condition in such a way that client front page layout passes ginseng, to realize inquiry
The dynamic condition filtering of data in sentence.
5. the data query method according to claim 1 or 2 for B/S system, it is characterised in that before client
Platform calls common enquiring component, obtains query result, includes the following steps:
JavaScript API packaging method is provided by client foreground, client foreground is called public by the JS file introduced
Use enquiring component；
ExecutePubEasySqlTable method is called on client foreground, and passes through transmitting query configuration number or dynamic queries
Condition obtains query result.
6. the data query method according to claim 5 for B/S system, it is characterised in that by transmitting dynamic queries
When condition obtains query result, with the variable of package in the entitled respective queries configuration of the parameter of dynamic queries condition；
The condition when parameter of dynamic queries condition has multiple values, the multiple value are separated with comma, and dynamic queries condition has multiple ginsengs
When number, the multiple parameter semicolon separated.
7. the data query method according to claim 1 or 2 for B/S system, it is characterised in that pass through background logic
Common enquiring component is called, different query configurations are uniformly processed, comprising:
Obtain query configuration；
Identify the parameter of query information；
The parameter of query information is packed；
Bind the variable in the parameter of query information；
Inquiry is executed based on query statement, returns to query result.
8. being used for the data query system of B/S system, characterized by comprising:
Configuration module, the configuration module is used to form query statement by common enquiring component configuration querying information, and is used for
Database common enquiring component allocation list is called to store above-mentioned query statement；
Enquiry module, the enquiry module are used to call common enquiring component by client foreground, obtain query result；
Logic processing module, the logic processing module is used to call common enquiring component by background logic, to different inquiries
Configuration is uniformly processed；
Query statement by configuration module configuration is query SQL sentence, including but not limited to query configuration number, inquiry word
Section, table name, querying condition, sort criteria and grouping condition, querying condition include Static Inquiry condition, dynamic queries condition, move
State In querying condition, dynamic Like querying condition, above-mentioned query statement at least one, the corresponding inquiry of each query statement is matched
It sets.
9. a kind of terminal, it is characterised in that including processor, input equipment, output equipment and memory, processor, input are set
Standby, output equipment and memory are connected with each other, and for memory for storing computer program, the computer program includes that program refers to
It enables, the processor is configured for calling described program instruction execution such as claim 1-7 described in any item for B/S system
The data query method of system.
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 true CN110297843A (en) | 2019-10-01 |
| CN110297843B 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) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112307068A (en) * | 2020-11-10 | 2021-02-02 | 天元大数据信用管理有限公司 | Dynamic SQL query method |
| CN112559472A (en) * | 2020-12-07 | 2021-03-26 | 北京锐安科技有限公司 | File transmission method and 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注入攻击的三层信息系统安全设计研究", 《情报探索》 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112307068A (en) * | 2020-11-10 | 2021-02-02 | 天元大数据信用管理有限公司 | Dynamic SQL query method |
| CN112559472A (en) * | 2020-12-07 | 2021-03-26 | 北京锐安科技有限公司 | File transmission method and device, computer equipment and storage medium |
| CN112559472B (en) * | 2020-12-07 | 2024-05-14 | 北京锐安科技有限公司 | File transmission method, device, computer equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110297843B (en) | 2023-04-28 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110443059B (en) | Data protection method and device | |
| CN106649630A (en) | Data query method and device | |
| CN106227894B (en) | A kind of data page querying method and device | |
| CN109815284A (en) | A kind of method and apparatus of data processing | |
| CN105913316B (en) | Rule configuration method and device | |
| CN108733713A (en) | Data query method and device in data warehouse | |
| CN109947770A (en) | A kind of data base query method, terminal device and storage medium | |
| CN102681878A (en) | Method to add new software features without modifying existing code | |
| CN103186834A (en) | Method and device of business process configuration | |
| CN107391142A (en) | The method and device that a kind of application is split | |
| CN106778351A (en) | Data desensitization method and device | |
| CN111443901B (en) | Java reflection-based service expansion method and device | |
| CN110245029A (en) | A kind of data processing method, device, storage medium and server | |
| CN104239508B (en) | Data query method and data query device | |
| CN109118353A (en) | The data processing method and device of air control model | |
| CN107403111A (en) | HIVE data desensitization method and device | |
| CN110032400A (en) | A kind of method and electric terminal loading plug-in unit | |
| CN110297843A (en) | Data query method and system, terminal for B/S system | |
| CN102915344A (en) | SQL (structured query language) statement processing method and device | |
| CN110009514A (en) | Extracting method, device, terminal and the computer readable storage medium of data | |
| CN102402455A (en) | Method and device for calling dynamic link library | |
| CN102932389B (en) | A kind of request processing method, device and server system | |
| CN110532267A (en) | Determination method, apparatus, storage medium and the electronic device of field | |
| CN101986282A (en) | Topological adaptation method and device | |
| CN112199407B (en) | Data packet ordering method, device, equipment and storage medium |
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 |
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. |
|
| TA01 | Transfer of patent application right | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |