CN110674380B - Data query method, system, readable storage medium and intelligent device - Google Patents
Data query method, system, readable storage medium and intelligent device Download PDFInfo
- Publication number
- CN110674380B CN110674380B CN201910877963.2A CN201910877963A CN110674380B CN 110674380 B CN110674380 B CN 110674380B CN 201910877963 A CN201910877963 A CN 201910877963A CN 110674380 B CN110674380 B CN 110674380B
- Authority
- CN
- China
- Prior art keywords
- mobile terminal
- service end
- server
- target
- data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/953—Querying, e.g. by the use of web search engines
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/955—Retrieval from the web using information identifiers, e.g. uniform resource locators [URL]
- G06F16/9566—URL specific, e.g. using aliases, detecting broken or misspelled links
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L61/00—Network arrangements, protocols or services for addressing or naming
- H04L61/50—Address allocation
- H04L61/5007—Internet protocol [IP] addresses
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computer Networks & Wireless Communication (AREA)
- Signal Processing (AREA)
- Information Transfer Between Computers (AREA)
Abstract
The invention discloses a data query method, a data query system, a readable storage medium and intelligent equipment, wherein the method comprises the following steps: when login information on a login page of a user for a target application is acquired, verifying the login information; when the address information of the mobile terminal is judged to be consistent with the address information of the mobile terminal, performing modular operation on the number of the service end IP of the area where the mobile terminal is located through the access time to obtain a target service end IP; establishing a connection relation between the mobile terminal and a target server; when application data in the mobile terminal are acquired within a preset time, a database query engine in the mobile terminal processes a query statement and feeds back a query result to a browser based on a chrome kernel in a target server through a connection relation.
Description
Technical Field
The invention relates to the technical field of data processing, in particular to a data query method, a data query system, a readable storage medium and intelligent equipment.
Background
The mobile terminal refers to a computer device that can be used in mobile, and generally includes a mobile phone, a notebook, a tablet computer, a POS machine, and a vehicle-mounted computer. With the development of networks and technologies towards increasingly broader bands, the mobile communications industry will move towards a true mobile information age. On the other hand, with the rapid development of integrated circuit technology, the processing capability of the mobile terminal has already possessed strong processing capability, and the mobile terminal is changing from a simple conversation tool to an integrated information processing platform.
With the rise of mobile internet, more and more internet enterprises and e-commerce platforms take APP as one of the main battlefields of sale. Data show that the flow brought to the e-commerce by the APP mobile phone far exceeds the flow of the traditional Internet (PC end), and the APP is profitable and is the development direction of various large e-commerce platforms. The fact shows that the inclination of each large e-commerce platform to the mobile APP is also very obvious, the reason is not only the flow increased every day, more importantly, more users are accumulated for the enterprise due to the convenience of the mobile terminal of the mobile phone, and more importantly, certain APPs with good user experience enable the loyalty and activeness of the users to be improved to a great extent, so that the key effect is played for the creation and the future development of the enterprise.
In the using process of the APP, the business data is downloaded from the server and stored in the database of the application, and meanwhile, the business operation also carries out the operations of adding, deleting and modifying the database. In the project implementation process, if an implementation developer wants to know whether data downloaded from a server is correctly stored in an application database or whether business operation is finished to add, delete and modify the database, a development mode needs to be opened in an APP, an integrated development environment is logged in at the same time, a matching code displayed in the corresponding APP and a database statement to be queried are input and sent to the APP, a refresh button in the integrated development environment is not clicked, and a result obtained after the APP executes a query statement is tried to be pulled from the server. Therefore, the implementation developers need to log in the APP and the integrated development environment through the APP development account and the integrated development environment account respectively, the memory cost is increased, and the efficiency is low, so that the problems of high development cost and high maintenance cost are caused.
Disclosure of Invention
In order to solve the above problems, an object of the present invention is to provide a data query method, a data query system, a readable storage medium, and an intelligent device, which have high query response speed, high query efficiency, and low maintenance cost.
A data query method is applied to a mobile terminal, and comprises the following steps:
when login information on a login page of a user aiming at a target application is acquired, verifying the login information, wherein the login information comprises the IP (Internet protocol), the access time and the access items of the mobile terminal;
when the address information of the mobile terminal is judged to be consistent with the address information of the mobile terminal, performing modular operation on the number of the service end IP of the area where the mobile terminal is located through the access time to obtain a target service end IP;
establishing a connection relation between the mobile terminal and a target server;
when application data in the mobile terminal are received and acquired within preset time, a database query engine in the mobile terminal processes a query statement and feeds back a query result to a browser based on a chrome kernel in a target server through a connection relation.
According to the data query method provided by the invention, firstly, the login information of a user is verified to determine the legality of login; when the address information of the mobile terminal is consistent with the address information of the mobile terminal, the number of the service end IPs of the area where the mobile terminal is located is subjected to modular operation by using the access time to obtain the target service end IP, so that the IP address of the target service end meeting the requirement is obtained, the balanced configuration of the service end is realized, and the resource allocation is more reasonable finally; and after processing the query statement, a database query engine in the mobile terminal feeds back a query result to a browser based on a chrome kernel in a target server through a connection relation, so that the server determines whether the business operation of the mobile terminal has finished the operations of adding, deleting and modifying the database according to the query result. The data query method provided by the invention solves the problems that in the process of implementing the project, if the existing application wants to know whether the data downloaded from the server is correctly stored in the application database or whether the business operation is finished to add, delete and modify the database, a development mode needs to be opened in the APP, the application logs in the integrated development environment, inputs the matching code displayed in the corresponding APP and the database statement to be queried, issues the matching code and the database statement to the APP, does not click a refresh button in the integrated development environment at a break point, tries to pull the result of the APP after the query statement is executed from the service, increases the memory cost, and has low efficiency, thereby causing higher development cost and maintenance cost.
In addition, the data query method according to the present invention may further have the following additional technical features:
further, the method further comprises:
and when the IP of the target server is judged to be inconsistent with the IP of the mobile terminal, initiating a redirection instruction to the mobile terminal so that the mobile terminal sends the access item to the target server corresponding to the IP of the target server.
Further, the method further comprises:
when the address information of the mobile terminal is judged to be consistent with the address information of the mobile terminal, judging whether the quantity of the service end IP of the area where the mobile terminal is located meets the quantity of channel configuration or not through the access time;
if yes, inquiring a server which is the same as the target application type and the login number of which does not meet the channel configuration number in a pre-stored application information database, and acquiring an inquired server recommendation value from the application information database;
generating a server list according to the inquired server recommended value, and determining a server with the highest recommended value in the server list as an alternative server;
and switching the login page of the target application to the login page of the alternative server.
Further, the method for obtaining the recommendation value comprises the following steps:
acquiring comprehensive strength evaluation data, service quality evaluation data, service heat evaluation data and service effect evaluation data of each server;
and performing weight calculation on the obtained data according to the weight of each type of data to obtain the recommended value of the server.
Further, the method for establishing the connection relationship between the mobile terminal and the target server comprises the following steps:
acquiring the IP address and the connection parameter of the mobile terminal, verifying the IP address and the connection parameter of the mobile terminal, and judging the type of the mobile terminal when the verification is passed;
when the mobile terminal is a mobile terminal, directly establishing the connection relation between the target server and the mobile terminal;
and when the mobile terminal is a mobile terminal simulator, establishing the connection relation between the target server and the mobile terminal simulator after IP address conversion is carried out through a window desktop system or a desktop system.
Further, the method further comprises:
when application data in the mobile terminal are received and obtained within preset time, recording the current time as first time, and simultaneously obtaining second time for obtaining the application data in the mobile terminal last time;
judging whether the time difference between the first time and the second time is greater than a preset time value or not;
and if the time difference is larger than the preset time value, generating login authentication information, wherein the login authentication information is used for prompting a user whether to authenticate the login information of the mobile terminal again.
Further, before the step of establishing the connection relationship between the mobile terminal and the target server, the method further includes:
judging whether the mobile terminal and the target server are in the same local area network or not;
when the mobile terminal and the target server are in the same local area network, directly establishing a connection relation between the mobile terminal and the target server;
and when the mobile terminal and the target server are not in the same local area network, establishing a connection relation between the mobile terminal and the target server after switching to a wide area network.
Another embodiment of the present invention provides a data query system, which solves the problem that in the project implementation process of the existing application, if it is desired to know whether the data downloaded from the server is correctly stored in the application database or whether the business operation has completed the operations of adding, deleting and modifying the database, it is necessary to open a development mode in the APP, log in the integrated development environment at the same time, input the matching code displayed in the corresponding APP and the database statement to be queried, issue the matching code and the database statement to be queried to the APP, and try to pull the result of the APP after executing the query statement from the service without clicking the refresh button in the integrated development environment, increase the memory cost, and have low efficiency, thereby resulting in higher development cost and maintenance cost.
The data query system according to the embodiment of the invention comprises:
the verification module is used for verifying login information when the login information on a login page of a user aiming at a target application is acquired, wherein the login information comprises the IP (Internet protocol), the access time and the access items of the mobile terminal;
the operation module is used for performing modular operation on the number of the service end IP of the area where the mobile terminal is located through the access time to obtain a target service end IP when the address information of the mobile terminal is judged to be consistent with the address information of the mobile terminal;
the connection module is used for establishing the connection relation between the mobile terminal and the target server;
and the query module is used for processing the query statement by a database query engine in the mobile terminal and feeding back the query result to a browser based on a chrome kernel in a target server through a connection relation when the application data in the mobile terminal is received and acquired within the preset time.
Another embodiment of the invention also proposes a readable storage medium on which a computer program is stored which, when being executed by a processor, carries out the steps of the above-mentioned method.
Another embodiment of the present invention also proposes a smart device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the above method when executing the program.
Additional aspects and advantages of the invention will be set forth in part in the description which follows and, in part, will be obvious from the description, or may be learned by practice of the invention.
Drawings
Fig. 1 is a flowchart of a data query method according to a first embodiment of the present invention;
FIG. 2 is a detailed flowchart of step S103 in FIG. 1;
fig. 3 is a block diagram of a data query system according to a second embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, but not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Referring to fig. 1, a data query method according to a first embodiment of the present invention includes steps S101 to S104:
step S101, when login information on a login page of a user aiming at a target application is acquired, the login information is verified, and the login information comprises the IP, the access time and the access items of the mobile terminal.
In the method provided by this embodiment, an execution main body of the method is a mobile terminal, the mobile terminal is, for example, a mobile phone or a tablet computer, the mobile terminal communicates with a server through the internet, a browser based on a kernel of chrome is installed on the server, the browser runs on the server, the browser can package data information to be queried through a webpage and then transmit the data information to the mobile terminal in a streaming mode, the data information is decoded on the mobile terminal and then loaded, meanwhile, a user can operate the mobile terminal, and the mobile terminal sends operation information to the server, so that a query function of an application through the server is realized. Therefore, when the user performs service operation on the application on the mobile terminal, service operation data is generated, and the mobile terminal sends the service operation data to the server.
Specifically, when it is obtained that a user needs to debug and query an application, the APP of the application is usually required to be downloaded to enter a registration page of the application or enter an application registration page by logging in a webpage of the application, and the APP is registered on the registration page of the application, and the registration is successful or the application can be logged in. When a user logs in an application login page, login information of the user needs to be verified, wherein the login information comprises the IP (Internet protocol), the access time and the access items of the mobile terminal.
And step S102, when the address information of the mobile terminal is judged to be consistent with the address information of the mobile terminal, performing modular operation on the number of the service end IPs of the area where the mobile terminal is located through the access time to obtain the target service end IP.
In one implementation, there are multiple servers in multiple areas, such as a server A, B, C, D, E in the first test area, a server F, G, H in the second test area, and a server I, J, K in the third test area. All the service end IP correspond to the same domain name, such as www.test.com, and the domain name resolution adopts polling resolution. And creating a data structure table of the IP of each service end in a plurality of service ends and the address information of the area where each service end is positioned. By using the data structure table, when the access request of the mobile terminal is acquired, the address information corresponding to the self IP can be searched from the data structure table according to the self IP so as to judge whether the address information of the client terminal is consistent with the address information of the self, so that the server can search the corresponding address information through the data structure table, and the reasonable allocation of resources is ensured.
If the address information of the mobile terminal is the first test area, the server C judges that the address information of the server C is the same as the IP of the server C, and at the moment, the number of the servers in the area where the server C is located is subjected to modular operation through the access time so as to obtain the target server IP.
When the IP of the target server is judged to be inconsistent with the IP of the mobile terminal, a redirection instruction is sent to the mobile terminal, namely, the mobile terminal is disconnected from the current server, so that the mobile terminal is connected with the target server according to the IP of the target server, and meanwhile, the mobile terminal sends the access item to the target server corresponding to the IP of the target server, so that reasonable resource distribution among a plurality of servers in the same area is realized.
It should be further noted that, in another embodiment of the present invention, when it is determined that the address information of the mobile terminal is consistent with the address information of the mobile terminal, it is determined whether the number of the service end IPs in the area where the mobile terminal is located meets the number of channel configurations according to the access time; if yes, inquiring a server which is the same as the target application type and the login number of which does not meet the channel configuration number in a pre-stored application information database, and acquiring an inquired server recommendation value from the application information database; generating a server list according to the inquired server recommended value, and determining a server with the highest recommended value in the server list as an alternative server; and switching the login page of the target application to the login page of the alternative server.
Generally, at least one server is set for an application in an area, each server is configured with the number of login persons, and when the number of login persons reaches the number configured by the server (namely, the number meeting the channel configuration), the server cannot be logged in. Therefore, project implementers can add new servers in due time according to the number of login people of the current regional server or the aging degree of the server.
Further, when the number of the IP of the server in the area where the access time of the access time meets the number of the channel configuration, the server which is the same as the target application type and the number of which does not meet the number of the channel configuration is inquired in a pre-stored application information database. The application types in this embodiment can be distinguished according to the application contents, including but not limited to management, marketing, monitoring, entertainment, and office types. The recommended value of each server is obtained by dynamically evaluating a plurality of evaluation items, for example, the comprehensive strength evaluation data, the service quality evaluation data, the service heat evaluation data and the service effect evaluation data of each server are evaluated and scored to obtain the servers of which the login number does not meet the channel configuration number, and the higher the recommended value is, the higher the comprehensive quality of the server is, and the real-time update of the recommended value is represented. Generating a server list according to the inquired server recommended value, and determining a server with the highest recommended value in the server list as an alternative server; and switching the landing page of the target application to the landing page of the alternative server to improve the satisfaction degree of user experience.
Specifically, the method for obtaining the recommended value includes: acquiring comprehensive strength evaluation data, service quality evaluation data, service heat evaluation data and service effect evaluation data of each server; and performing weight calculation on the obtained data according to the weight of each type of data to obtain the recommended value of the server.
And step S103, establishing a connection relation between the mobile terminal and the target server.
As described above, when the target server meeting the requirement is obtained, it is necessary to determine whether the mobile terminal and the target server are in the same local area network; when the mobile terminal and the target server are in the same local area network, directly establishing a connection relation between the mobile terminal and the target server; and when the mobile terminal and the target server are not in the same local area network, establishing a connection relation between the mobile terminal and the target server after switching to a wide area network. The mobile terminal and the target server are normally selected as service equipment in the same local area network, so that the problem that the target application is easy to be in a waiting state for a long time and wastes application resources due to network environment jitter is avoided; in addition, because the target application is in a waiting state for a long time, implementation developers can continuously and repeatedly send the database query statement and the matching code, server resources are occupied, and the problem of low efficiency of the implementation developers is caused by long-time waiting and repeated sending, so that the query method disclosed by the invention has low requirements on network environment and quick response.
Referring to fig. 2, the method for establishing the connection relationship between the mobile terminal and the target server includes the following steps:
and step S1031, acquiring the IP address and the connection parameter of the mobile terminal, verifying the IP address and the connection parameter of the mobile terminal, and judging the type of the mobile terminal when the verification is passed.
Step S1032, when the mobile terminal is a mobile terminal, directly establishing a connection relationship between the target server and the mobile terminal.
Step S1033, when the mobile terminal is a mobile terminal simulator, after a window desktop system or a desktop system performs an IP address conversion, a connection relationship between the target server and the mobile terminal simulator is established.
It can be understood that when the IP address and the connection parameter of the mobile terminal both pass the verification, it indicates that the mobile terminal has the target application to be debugged, and at this time, if the mobile terminal used by the user is a mobile terminal, the data transmission can be directly performed; if the mobile terminal used by the user is the mobile terminal simulator, the connection relationship between the cloud server and the mobile terminal simulator is established after IP address conversion is carried out through a window desktop system or a desktop system.
And step S104, when the application data in the mobile terminal is received and acquired within the preset time, a database query engine in the mobile terminal processes the query statement and feeds back the query result to a browser based on a chrome kernel in a target server through a connection relation.
As described above, since the database query engine is disposed inside the mobile terminal, after the query statement is verified and analyzed, the key data can be retrieved from the application information database, and the query result is fed back to the browser based on the kernel in the target server through the connection relationship, so that the server determines whether the business operation of the mobile terminal has completed the operations of adding, deleting and modifying the database according to the query result.
It should be noted that, in other implementations of the present invention, the method further includes: when the application data in the mobile terminal are acquired within the preset time, recording the current time as a first time, acquiring a second time of the application data in the mobile terminal at the same time, and judging whether the time difference between the first time and the second time is greater than a preset time value. The time difference between the two times is, for example, 48 hours, and the preset time is, for example, 12 hours, since the time difference is greater than the preset time value, it indicates that the identity information of the mobile terminal is not verified for a long time, and only in this case, an identity information verification dialog box is popped up to prompt the user to verify the identity information of the mobile terminal to be debugged again. The advantage of this setting can regularly remind the user to treat the identity information of debugging mobile terminal and verify to need not carry out validity check at every turn at the in-process of debugging mobile terminal, also can avoid long-time not verifying and the phenomenon that appears the information transmission mistake.
According to the data query method provided by the invention, firstly, the login information of a user is verified to determine the legality of login; when the address information of the mobile terminal is consistent with the address information of the mobile terminal, the number of the service end IPs of the area where the mobile terminal is located is subjected to modular operation by using the access time to obtain the target service end IP, so that the IP address of the target service end meeting the requirement is obtained, the balanced configuration of the service end is realized, and the resource allocation is more reasonable finally; and after processing the query statement, a database query engine in the mobile terminal feeds back a query result to a browser based on a chrome kernel in a target server through a connection relation, so that the server determines whether the business operation of the mobile terminal has finished the operations of adding, deleting and modifying the database according to the query result. The data query method provided by the invention solves the problems that in the process of implementing the project, if the existing application wants to know whether the data downloaded from the server is correctly stored in the application database or whether the business operation is finished to add, delete and modify the database, a development mode needs to be opened in the APP, the application logs in the integrated development environment, inputs the matching code displayed in the corresponding APP and the database statement to be queried, issues the matching code and the database statement to the APP, does not click a refresh button in the integrated development environment at a break point, tries to pull the result of the APP after the query statement is executed from the service, increases the memory cost, and has low efficiency, thereby causing higher development cost and maintenance cost.
Referring to fig. 3, based on the same inventive concept, a data query system according to a second embodiment of the present invention includes:
the verification module 10 is configured to verify login information when the login information on a login page of a user for a target application is acquired, where the login information includes an IP, an access time, and an access item of the mobile terminal.
The operation module 20 is configured to perform a modulo operation on the number of service end IPs in the area where the mobile terminal is located according to the access time to obtain a target service end IP when it is determined that the address information of the mobile terminal is consistent with the address information of the mobile terminal; and when the IP of the target server is judged to be inconsistent with the IP of the mobile terminal, initiating a redirection instruction to the mobile terminal so that the mobile terminal sends the access item to the target server corresponding to the IP of the target server.
In this embodiment, the operation module 20 is further configured to determine whether the number of the service end IPs in the area where the mobile terminal is located meets the number of channel configurations according to the access time when it is determined that the address information of the mobile terminal is consistent with the address information of the mobile terminal; if yes, searching a server which is the same as the target application type and does not meet the channel configuration number in the pre-stored application information database, logging in the server, obtaining comprehensive strength evaluation data, service quality evaluation data, service heat evaluation data and service effect evaluation data of each server, performing weight calculation on the obtained data according to the weight of each type of data, storing the calculation result in the application information database, and obtaining the recommended value of the searched server from the application information database; generating a server list according to the inquired server recommended value, and determining a server with the highest recommended value in the server list as an alternative server; and switching the login page of the target application to the login page of the alternative server.
The connection module 30 is configured to determine whether the mobile terminal and the target server are in the same local area network; when the mobile terminal and the target server are in the same local area network, directly establishing a connection relation between the mobile terminal and the target server; and when the mobile terminal and the target server are not in the same local area network, establishing a connection relation between the mobile terminal and the target server after switching to a wide area network.
In this embodiment, the connection module 30 includes:
an obtaining unit 31, configured to obtain an IP address and a connection parameter of the mobile terminal, check the IP address and the connection parameter of the mobile terminal, and determine the type of the mobile terminal when the check passes.
A connection unit 32, configured to directly establish a connection relationship between the target server and the mobile terminal when the mobile terminal is a mobile terminal.
A conversion unit 33, configured to, when the mobile terminal is a mobile end simulator, perform IP address conversion once through a window desktop system or a desktop system, and then establish a connection relationship between the target server and the mobile end simulator.
And the query module 40 is configured to, when the application data in the mobile terminal is received and acquired within a preset time, process the query statement by a database query engine in the mobile terminal, and feed back a query result to a browser based on a kernel in a target server through a connection relationship.
In this embodiment, the query module 40 is further configured to record a current time as a first time when the application data in the mobile terminal is received and acquired within a preset time, and acquire a second time when the application data in the mobile terminal is acquired last time; judging whether the time difference between the first time and the second time is greater than a preset time value or not; and if the time difference is larger than the preset time value, generating login authentication information, wherein the login authentication information is used for prompting a user whether to authenticate the login information of the mobile terminal again.
According to the data query system provided by the invention, firstly, the login information of a user is verified to determine the legality of login; when the address information of the mobile terminal is consistent with the address information of the mobile terminal, the number of the service end IPs of the area where the mobile terminal is located is subjected to modular operation by using the access time to obtain the target service end IP, so that the IP address of the target service end meeting the requirement is obtained, the balanced configuration of the service end is realized, and the resource allocation is more reasonable finally; and after processing the query statement, a database query engine in the mobile terminal feeds back a query result to a browser based on a chrome kernel in a target server through a connection relation, so that the server determines whether the business operation of the mobile terminal has finished the operations of adding, deleting and modifying the database according to the query result. The data query method provided by the invention solves the problems that in the process of implementing the project, if the existing application wants to know whether the data downloaded from the server is correctly stored in the application database or whether the business operation is finished to add, delete and modify the database, a development mode needs to be opened in the APP, the application logs in the integrated development environment, inputs the matching code displayed in the corresponding APP and the database statement to be queried, issues the matching code and the database statement to the APP, does not click a refresh button in the integrated development environment at a break point, tries to pull the result of the APP after the query statement is executed from the service, increases the memory cost, and has low efficiency, thereby causing higher development cost and maintenance cost.
The technical features and technical effects of the data query system provided by the embodiment of the present invention are the same as those of the method provided by the embodiment of the present invention, and are not described herein again.
Furthermore, an embodiment of the present invention also proposes a readable storage medium, on which a computer program is stored, which when executed by a processor implements the steps of the above-mentioned method.
Furthermore, an embodiment of the present invention also provides an intelligent device, which includes a memory, a processor, and a computer program stored on the memory and executable on the processor, wherein the processor implements the steps of the above method when executing the program.
The logic and/or steps represented in the flowcharts or otherwise described herein, e.g., an ordered listing of executable instructions that can be considered to implement logical functions, can be embodied in any computer-readable medium for use by or in connection with an instruction execution system, apparatus, or device, such as a computer-based system, processor-containing system, or other system that can fetch the instructions from the instruction execution system, apparatus, or device and execute the instructions. For the purposes of this description, a "computer-readable medium" can be any means that can contain, store, communicate, propagate, or transport the program for use by or in connection with the instruction execution system, apparatus, or device.
More specific examples (a non-exhaustive list) of the computer-readable medium would include the following: an electrical connection (electronic device) having one or more wires, a portable computer diskette (magnetic device), a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber device, and a portable compact disc read-only memory (CDROM). Additionally, the computer-readable medium could even be paper or another suitable medium upon which the program is printed, as the program can be electronically captured, via for instance optical scanning of the paper or other medium, then compiled, interpreted or otherwise processed in a suitable manner if necessary, and then stored in a computer memory.
It should be understood that portions of the present invention may be implemented in hardware, software, firmware, or a combination thereof. In the above embodiments, the various steps or methods may be implemented in software or firmware stored in memory and executed by a suitable instruction execution system. For example, if implemented in hardware, as in another embodiment, any one or combination of the following techniques, which are known in the art, may be used: a discrete logic circuit having a logic gate circuit for implementing a logic function on a data signal, an application specific integrated circuit having an appropriate combinational logic gate circuit, a Programmable Gate Array (PGA), a Field Programmable Gate Array (FPGA), or the like.
In the description herein, references to the description of the term "one embodiment," "some embodiments," "an example," "a specific example," or "some examples," etc., mean that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the invention. In this specification, the schematic representations of the terms used above do not necessarily refer to the same embodiment or example. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples.
While embodiments of the invention have been shown and described, it will be understood by those of ordinary skill in the art that: various changes, modifications, substitutions and alterations can be made to the embodiments without departing from the principles and spirit of the invention, the scope of which is defined by the claims and their equivalents.
Finally, it should be noted that: the above-mentioned embodiments are only specific embodiments of the present invention, which are used for illustrating the technical solutions of the present invention and not for limiting the same, and the protection scope of the present invention is not limited thereto, although the present invention is described in detail with reference to the foregoing embodiments, those skilled in the art should understand that: any person skilled in the art can modify or easily conceive the technical solutions described in the foregoing embodiments or equivalent substitutes for some technical features within the technical scope of the present disclosure; such modifications, changes or substitutions do not depart from the spirit and scope of the embodiments of the present invention, and they should be construed as being included therein. Therefore, the protection scope of the present invention shall be subject to the protection scope of the appended claims.
Claims (9)
1. A data query method is applied to a mobile terminal, and is characterized by comprising the following steps:
when login information on a login page of a user aiming at a target application is acquired, verifying the login information, wherein the login information comprises the IP (Internet protocol), the access time and the access items of a mobile terminal;
when the address information of the mobile terminal is judged to be consistent with the address information of the mobile terminal, performing modular operation on the number of the service end IP of the area where the mobile terminal is located through the access time to obtain a target service end IP; when the address information of the mobile terminal is judged to be consistent with the address information of the mobile terminal, judging whether the number of the service end IPs of the area where the mobile terminal is located meets the number of channel configuration through the access time, if so, inquiring a service end which has the same type as the target application and does not meet the number of the channel configuration in a pre-stored application information database, acquiring an inquired service end recommendation value from the application information database, generating a service end list according to the inquired service end recommendation value, determining the service end with the highest recommendation value in the service end list as an alternative service end, and switching the login page of the target application to the login page of the alternative service end;
establishing a connection relation between the mobile terminal and a target server/an alternative server;
when application data in the mobile terminal are acquired within a preset time, a database query engine in the mobile terminal processes a query statement and feeds back a query result to a browser based on a kernel in a target server/an alternative server through a connection relation.
2. The data query method of claim 1, further comprising:
and when the IP of the target server is judged to be inconsistent with the IP of the target server, initiating a redirection instruction to the mobile terminal so that the mobile terminal sends the access item to the target server corresponding to the IP of the target server.
3. The data query method of claim 1, wherein the method of obtaining the recommendation value comprises:
acquiring comprehensive strength evaluation data, service quality evaluation data, service heat evaluation data and service effect evaluation data of each server;
and performing weight calculation on the obtained data according to the weight of each type of data to obtain the recommended value of the server.
4. The data query method of claim 1, wherein the method for establishing the connection relationship between the mobile terminal and the target server comprises:
acquiring the IP address and the connection parameter of the mobile terminal, verifying the IP address and the connection parameter of the mobile terminal, and judging the type of the mobile terminal when the verification is passed;
when the mobile terminal is a mobile terminal, directly establishing the connection relation between the target server and the mobile terminal;
and when the mobile terminal is a mobile terminal simulator, establishing the connection relation between the target server and the mobile terminal simulator after IP address conversion is carried out through a window desktop system or a desktop system.
5. The data query method of claim 1, further comprising:
when application data in the mobile terminal are received and obtained within preset time, recording the current time as first time, and simultaneously obtaining second time for obtaining the application data in the mobile terminal last time;
judging whether the time difference between the first time and the second time is greater than a preset time value or not;
and if the time difference is larger than the preset time value, generating login authentication information, wherein the login authentication information is used for prompting a user whether to authenticate the login information of the mobile terminal again.
6. The data query method according to claim 1, wherein before the step of establishing the connection relationship between the mobile terminal and the target server, the method further comprises:
judging whether the mobile terminal and the target server are in the same local area network or not;
when the mobile terminal and the target server are in the same local area network, directly establishing a connection relation between the mobile terminal and the target server;
and when the mobile terminal and the target server are not in the same local area network, establishing a connection relation between the mobile terminal and the target server after switching to a wide area network.
7. A data query system, the system comprising:
the verification module is used for verifying login information when the login information on a login page of a user aiming at a target application is acquired, wherein the login information comprises the IP (Internet protocol), the access time and the access items of the mobile terminal;
the operation module is used for performing modular operation on the number of the service end IPs of the area where the mobile terminal is located through the access time to obtain a target service end IP when the address information of the mobile terminal is judged to be consistent with the address information of the mobile terminal; when the address information of the mobile terminal is judged to be consistent with the address information of the mobile terminal, judging whether the number of the service end IPs of the area where the mobile terminal is located meets the number of channel configuration through the access time, if so, inquiring a service end which has the same type as the target application and does not meet the number of the channel configuration in a pre-stored application information database, acquiring an inquired service end recommendation value from the application information database, generating a service end list according to the inquired service end recommendation value, determining the service end with the highest recommendation value in the service end list as an alternative service end, and switching the login page of the target application to the login page of the alternative service end;
the connection module is used for establishing the connection relation between the mobile terminal and the target server;
and the query module is used for processing the query statement by a database query engine in the mobile terminal and feeding back the query result to a browser based on a chrome kernel in a target server through a connection relation when the application data in the mobile terminal is received and acquired within the preset time.
8. A readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out the method according to any one of claims 1 to 6.
9. An intelligent device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the method according to any one of claims 1 to 6 when executing the program.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910877963.2A CN110674380B (en) | 2019-09-17 | 2019-09-17 | Data query method, system, readable storage medium and intelligent device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910877963.2A CN110674380B (en) | 2019-09-17 | 2019-09-17 | Data query method, system, readable storage medium and intelligent device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110674380A CN110674380A (en) | 2020-01-10 |
| CN110674380B true CN110674380B (en) | 2020-08-04 |
Family
ID=69076709
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910877963.2A Active CN110674380B (en) | 2019-09-17 | 2019-09-17 | Data query method, system, readable storage medium and intelligent device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110674380B (en) |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103188270A (en) * | 2013-04-11 | 2013-07-03 | 腾讯科技（深圳）有限公司 | Method, device and system for accessing recommended server to IP address |
| CN104104717A (en) * | 2014-06-30 | 2014-10-15 | 广州唯品会网络技术有限公司 | Inputting channel data statistical method and device |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20100325207A1 (en) * | 2009-06-19 | 2010-12-23 | Yahoo! Inc. | Conditional communication access based on user status |
| US9560035B2 (en) * | 2010-08-04 | 2017-01-31 | At&T Mobility Ii Llc | Systems, devices, methods and computer program products for establishing network connections between service providers and applications that run natively on devices |
| US11238365B2 (en) * | 2017-12-29 | 2022-02-01 | Verizon Media Inc. | Method and system for detecting anomalies in data labels |
-
2019
- 2019-09-17 CN CN201910877963.2A patent/CN110674380B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103188270A (en) * | 2013-04-11 | 2013-07-03 | 腾讯科技（深圳）有限公司 | Method, device and system for accessing recommended server to IP address |
| CN104104717A (en) * | 2014-06-30 | 2014-10-15 | 广州唯品会网络技术有限公司 | Inputting channel data statistical method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110674380A (en) | 2020-01-10 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108153670B (en) | Interface testing method and device and electronic equipment | |
| CN109446071A (en) | Interface test method, interface test device, electronic equipment and storage medium | |
| CN104601641A (en) | Application link sharing method, device and system | |
| CN107305611B (en) | Method and device for establishing model corresponding to malicious account and method and device for identifying malicious account | |
| CN111143207B (en) | Method for checking model training notice and training log at mobile terminal | |
| CN103136342B (en) | The searching method of application A PP, system and search server | |
| CN108829838B (en) | Batch processing method of account information and server | |
| CN110598280A (en) | Equipment simulation system and method and computer readable storage medium | |
| CN110011875B (en) | Dial testing method, device, equipment and computer readable storage medium | |
| CN104394133A (en) | Login method and login system | |
| CN107807841B (en) | Server simulation method, device, equipment and readable storage medium | |
| CN103313289A (en) | Wap system automatic test system and method | |
| CN107094088A (en) | A kind of loiter network device identification method, device and system | |
| CN111008059A (en) | Control method and device for popup window display, terminal and storage medium | |
| CN106254528A (en) | A kind of resource downloading method and buffer memory device | |
| CN114328132A (en) | Method, device, equipment and medium for monitoring state of external data source | |
| CN111078424A (en) | Information interaction method and device, computer equipment and storage medium | |
| CN111209325A (en) | Service system interface identification method, device and storage medium | |
| CN106257520A (en) | Resolve answer method and system | |
| CN107766224B (en) | Test method and test device | |
| CN109522202B (en) | Software testing method and device | |
| CN111061637B (en) | Interface testing method, interface testing device and storage medium | |
| CN110674380B (en) | Data query method, system, readable storage medium and intelligent device | |
| CN109992614B (en) | Data acquisition method, device and server | |
| CN113127335A (en) | System testing method and device |
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 | ||
| CP02 | Change in the address of a patent holder | ||
| CP02 | Change in the address of a patent holder |
Address after: 510000 room 23bd, No. 109, TIYU West Road, Tianhe District, Guangzhou City, Guangdong Province Patentee after: GUANGZHOU XUANWU WIRELESS TECHNOLOGY Co.,Ltd. Address before: 32B, no.103b, TianLiHe Road, Guangzhou, 510000 Patentee before: GUANGZHOU XUANWU WIRELESS TECHNOLOGY Co.,Ltd. |