CN112860699A - Database management method and device, storage medium and electronic device - Google Patents
Database management method and device, storage medium and electronic device Download PDFInfo
- Publication number
- CN112860699A CN112860699A CN202110197272.5A CN202110197272A CN112860699A CN 112860699 A CN112860699 A CN 112860699A CN 202110197272 A CN202110197272 A CN 202110197272A CN 112860699 A CN112860699 A CN 112860699A
- Authority
- CN
- China
- Prior art keywords
- target
- database
- area
- display interface
- query language
- 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.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
- G06F16/285—Clustering or classification
- G06F16/287—Visualization; Browsing
Abstract
The invention discloses a database management method and device, a storage medium and an electronic device, wherein the method comprises the following steps: receiving a first operation of a target object through a first area of a target display interface, wherein a database list is displayed in the first area of the target display interface and comprises one or more database identifications; responding to the first operation, selecting a target database identifier in the database list so as to display a number corresponding to the target database in a second area of the target display interface; receiving a target Structured Query Language (SQL) operation instruction input by a target object in a third area of a target display interface; and searching target data corresponding to the target Structured Query Language (SQL) operation instruction in the target database, and displaying the target data in a fourth area of the target display interface.
Description
Technical Field
The present invention relates to the field of communications, and in particular, to a method and an apparatus for managing a database, a storage medium, and an electronic apparatus.
Background
Building a complete set of test environment requires multiple applications and databases, the IP address and port number corresponding to each database instance are randomly allocated, if the databases are to be accessed, multiple configurations are required at the database client, for example, authentication information, IP ports, user names, passwords, IP authorization and the like are configured, multiple windows need to be opened when operating multiple databases, and the use complexity is greatly increased.
Aiming at the problems that in the related art, when a plurality of databases are accessed, the databases need to be configured on a database client side for a plurality of times, a plurality of windows need to be opened when the databases are operated, and the like, an effective solution is not provided.
Disclosure of Invention
The embodiment of the invention provides a database management method and device, a storage medium and an electronic device, which are used for at least solving the problems that multiple configurations are required at a database client side when a plurality of databases are accessed, a plurality of windows are required to be opened when the plurality of databases are operated and the like in the related art.
According to an embodiment of the present invention, there is provided a database management method, including: receiving a first operation of a target object through a first area of a target display interface, wherein a database list is displayed in the first area of the target display interface and comprises one or more database identifications; responding to the first operation, selecting a target database identifier in the database list so as to display a number corresponding to the target database in a second area of the target display interface; receiving a target Structured Query Language (SQL) operation instruction input by the target object in a third area of the target display interface; and searching target data corresponding to the target Structured Query Language (SQL) operation instruction in the target database, and displaying the target data in a fourth area of the target display interface.
In an exemplary embodiment, before the target data is displayed in the fourth area of the target display interface, the method further includes: acquiring a data table and a data table field corresponding to the target database from the target database; creating a database link according to the data table and the data table field corresponding to the target database; and responding to the target structured query language SQL operation instruction through the database link, and displaying target data corresponding to the target structured query language SQL operation instruction in a third area of the target display interface.
In an exemplary embodiment, a second operation of the target object is received through the first area; and responding to the second operation, and displaying the data table of the target database in the first area.
In an exemplary embodiment, after the first area displays the data table of the target database, the method further includes: receiving a third operation of the target object through the first area; and responding to the third operation, and displaying the field information and the index information corresponding to the data table in the first area.
In an exemplary embodiment, after the target data is displayed in the fourth area of the target display interface, the method further includes: receiving a fourth operation of the target object; and responding to the fourth operation of the target object, and exporting the target data corresponding to the target Structured Query Language (SQL) operation instruction to a requester of the target data.
In an exemplary embodiment, a target structured query language SQL operation instruction input by the target object is received in a third area of the target display interface, and the method further includes: and under the condition that the target structured query language SQL operation instruction comprises a plurality of target structured query language SQL operation instructions, simultaneously executing the plurality of target structured query language SQL operation instructions, and simultaneously displaying target data corresponding to the plurality of SQL operation instructions in the fourth area.
According to another embodiment of the present invention, there is also provided a database management apparatus including: the system comprises a first receiving module, a first display module and a second receiving module, wherein the first receiving module is used for receiving a first operation of a target object through a first area of a target display interface, a database list is displayed in the first area of the target display interface and comprises one or more database identifications; the response module is used for responding to the first operation and selecting a target database identifier in the database list so as to display a serial number corresponding to the target database in a second area of the target display interface; the second receiving module is used for receiving a target Structured Query Language (SQL) operation instruction input by the target object in a third area of the target display interface; and the searching module is used for searching the target data corresponding to the target Structured Query Language (SQL) operation instruction in the target database and displaying the target data in a fourth area of the target display interface.
In an exemplary embodiment, the response module is further configured to: acquiring a data table and a data table field corresponding to the target database from the target database; creating a database link according to the data table and the data table field corresponding to the target database; and responding to the target structured query language SQL operation instruction through the database link, and displaying target data corresponding to the target structured query language SQL operation instruction in a third area of the target display interface.
According to still another aspect of the embodiments of the present invention, there is also provided a computer-readable storage medium in which a computer program is stored, wherein the computer program is configured to execute the above database management method when running.
According to another aspect of the embodiments of the present invention, there is also provided an electronic apparatus, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the database management method through the computer program.
In the embodiment of the invention, a first operation of a target object is received through a first area of a target display interface, wherein a database list is displayed in the first area of the target display interface and comprises one or more database identifications; responding to the first operation, selecting a target database identifier in the database list so as to display a number corresponding to the target database in a second area of the target display interface; receiving a target Structured Query Language (SQL) operation instruction input by a target object in a third area of a target display interface; the technical scheme is adopted, the problems that in the related art, multiple configuration needs to be carried out on a database client side when a plurality of databases are accessed, a plurality of windows need to be opened when the plurality of databases are operated and the like are solved, and further the operation time of configuring the connection information of the databases is shortened and the complexity of switching back and forth of the plurality of windows is reduced.
Drawings
The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this application, illustrate embodiment(s) of the invention and together with the description serve to explain the invention without limiting the invention. In the drawings:
fig. 1 is a block diagram of a hardware configuration of a computer terminal of a database management method according to an embodiment of the present invention;
FIG. 2 is a flow chart of a method of managing a database according to an embodiment of the present invention;
FIG. 3 is a flow diagram of a database query according to an embodiment of the invention;
FIG. 4 is a database column representation according to an embodiment of the present invention;
FIG. 5 is a flow diagram for looking up data tables, data table field names, and data table indices according to an embodiment of the present invention;
FIG. 6 is a flow diagram of instructions for performing SQL operations according to an embodiment of the invention;
FIG. 7 is a schematic diagram of an instruction to perform SQL operations according to an embodiment of the invention;
FIG. 8 is a schematic diagram of result derivation according to an embodiment of the invention;
fig. 9 is a block diagram of a structure of a management apparatus of a database according to an embodiment of the present invention.
Detailed Description
In order to make the technical solutions of the present invention better understood, 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 only a part of the embodiments of the present invention, and not all of the embodiments. 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.
It should be noted that the terms "first," "second," and the like in the description and claims of the present invention and in the drawings described above are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the invention described herein are capable of operation in sequences other than those illustrated or described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
The method provided by the embodiment of the application can be executed in a computer terminal, a mobile terminal or a similar operation device. Taking the example of running on a computer terminal, fig. 1 is a hardware structure block diagram of a computer terminal of a database management method according to an embodiment of the present invention. As shown in fig. 1, the computer terminal may include one or more (only one shown in fig. 1) processors 102 (the processors 102 may include, but are not limited to, a processing device such as a microprocessor MCU or a programmable logic device FPGA) and a memory 104 for storing data, and in an exemplary embodiment, may also include a transmission device 106 for communication functions and an input-output device 108. It will be understood by those skilled in the art that the structure shown in fig. 1 is only an illustration and is not intended to limit the structure of the computer terminal. For example, the computer terminal may also include more or fewer components than shown in FIG. 1, or have a different configuration with equivalent functionality to that shown in FIG. 1 or with more functionality than that shown in FIG. 1.
The memory 104 may be used for storing computer programs, for example, software programs and modules of application software, such as computer programs corresponding to the database management method in the embodiment of the present invention, and the processor 102 executes various functional applications and data processing by running the computer programs stored in the memory 104, so as to implement the above-mentioned method. The memory 104 may include high speed random access memory, and may also include non-volatile memory, such as one or more magnetic storage devices, flash memory, or other non-volatile solid-state memory. In some examples, the memory 104 may further include memory located remotely from the processor 102, which may be connected to a computer terminal over a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.
The transmission device 106 is used for receiving or transmitting data via a network. Specific examples of the network described above may include a wireless network provided by a communication provider of the computer terminal. In one example, the transmission device 106 includes a Network adapter (NIC), which can be connected to other Network devices through a base station so as to communicate with the internet. In one example, the transmission device 106 may be a Radio Frequency (RF) module, which is used for communicating with the internet in a wireless manner.
In this embodiment, a management method for a database is provided, which is applied to the above-mentioned computer terminal, and fig. 2 is a flowchart of a management method for a database according to an embodiment of the present invention, where the flowchart includes the following steps:
step S202, receiving a first operation of a target object through a first area of a target display interface, wherein a database list is displayed in the first area of the target display interface and comprises one or more database identifiers;
step S204, responding to the first operation, selecting a target database identifier in the database list so as to display a number corresponding to the target database in a second area of the target display interface;
step S206, receiving a target Structured Query Language (SQL) operation instruction input by the target object in a third area of the target display interface;
step S208, searching the target data corresponding to the target Structured Query Language (SQL) operation instruction in the target database, and displaying the target data in a fourth area of the target display interface.
Through the steps, receiving a first operation of a target object through a first area of a target display interface, wherein a database list is displayed in the first area of the target display interface and comprises one or more database identifications; responding to the first operation, selecting a target database identifier in the database list so as to display a number corresponding to the target database in a second area of the target display interface; receiving a target Structured Query Language (SQL) operation instruction input by a target object in a third area of a target display interface; the technical scheme is adopted, the problems that in the related art, multiple configuration needs to be carried out on a database client side when a plurality of databases are accessed, a plurality of windows need to be opened when the plurality of databases are operated and the like are solved, and further the operation time of configuring the connection information of the databases is shortened and the complexity of switching back and forth of the plurality of windows is reduced.
In the above steps S202 to S208, the first area in the target display interface displays a database list, the target object selects the target database in the database list, and then displays the number corresponding to the target database in the second area of the target display interface, and further opens the third area corresponding to the target database, and after the target object inputs the target structured query language SQL operation instruction through the third area of the target display interface, the target object displays the target data corresponding to the target structured query language SQL operation instruction in the fourth area of the target display interface. Before step S202, it is also necessary to acquire a database list corresponding to the environment number by inputting the environment number.
The step S208 may have a plurality of implementation manners, and the embodiment of the present invention mainly provides an implementation scheme: acquiring a data table and a data table field corresponding to the target database from the target database; creating a database link according to the data table and the data table field corresponding to the target database; and responding to the target structured query language SQL operation instruction through the database link, and displaying target data corresponding to the target structured query language SQL operation instruction in a third area of the target display interface.
In other words, before the target data is displayed in the fourth area of the target display interface, the data table and the data table field corresponding to the target database are first obtained, a database link is further created according to the data table and the data table field, finally, the target structured query language SQL operation instruction is executed, the target data corresponding to the target structured query language SQL operation instruction is obtained through the database link, and finally, the target data is displayed in the fourth area.
Receiving a second operation of the target object through the first area; and responding to the second operation, and displaying the data table of the target database in the first area.
It should be noted that all data tables in the target database can be shown in the first area by clicking on a specific symbol, such as ">, of the target database in the database list.
Further, a third operation of the target object is received through the first area; and responding to the third operation, and displaying the field information and the index information corresponding to the data table in the first area. That is, the target object may expose the spreadsheet field name and spreadsheet index in the first area by clicking on a particular symbol in the spreadsheet, such as ">".
In an optional embodiment, after the target data is displayed in the fourth area of the target display interface, a fourth operation of the target object is received; and responding to the fourth operation of the target object, and exporting the target data corresponding to the target Structured Query Language (SQL) operation instruction to a requester of the target data.
It should be noted that, when the target object needs to derive the target data corresponding to the target structured query language SQL operation instruction, the target data corresponding to the target structured query language SQL operation instruction may be derived by receiving the fourth operation of the target object.
Further, if the target structured query language SQL operation instruction includes a plurality of target structured query language SQL operation instructions, the plurality of target structured query language SQL operation instructions are executed simultaneously, and target data corresponding to the plurality of SQL operation instructions are displayed simultaneously in the fourth area.
That is, a plurality of target structured query language SQL operation instructions may be executed simultaneously, and a plurality of target data corresponding to the plurality of target structured query language SQL operation instructions may be displayed simultaneously in the fourth area.
Further, when the target object needs to derive a plurality of target data corresponding to a plurality of target structured query language SQL operation instructions, the target object may receive a fifth operation of the target object, and further derive a plurality of target data corresponding to a plurality of target structured query language SQL operation instructions.
Further, the SQL operation instruction highlights and automatically prompts MYSQL keywords, table names, table fields and the like, and the SQL operation instruction can be executed through a shortcut key.
In order to better understand the process of the database management method, the following describes an implementation method flow of the database management with reference to an optional embodiment, but the implementation method flow is not limited to the technical solution of the embodiment of the present invention.
The invention relates to a database management scheme based on a java B/S (Browser/Server) structure. The Browser side is implemented by Vue (Vue is a set of progressive JavaScript framework for constructing a user interface) (JavaScript is a programming language running on a web Browser), and the Server side is implemented by java. Specifically, a JAVA connection pool is used for managing multiple database links, DML and DDL statements are executed through the database links, and data related information is obtained for front-end display.
The specific implementation steps are as follows:
step 1: inquiring a database list according to the environment number;
as shown in fig. 3, the specific steps are as follows:
step S301: opening a home page;
step S302: inputting an environment number;
step S303: querying a database list;
step S304: and displaying the database name list.
As shown in fig. 4, fig. 4 is a database column representation intent, and a database column table corresponding to an environment number can be queried through the environment number according to the embodiment of the invention.
Step 2: as shown in fig. 5, fig. 5 is a flowchart for looking up a data table, a field name of the data table, and an index of the data table according to an embodiment of the present invention, which includes the following specific steps:
step S501: click on ">" of the target database in the left (equivalent to the first zone in the above embodiment) database listing;
step S502: searching a data table corresponding to a target database in the database;
step S503: showing all the corresponding data tables in the target database base,
step S504: click on ">" of the data sheet;
step S505: searching a data table field name and a data table index in a database;
step S506: the progress indicates a data table field name and a data table index.
And step 3: as shown in fig. 6, fig. 6 is a flowchart of executing an SQL operation instruction according to an embodiment of the present invention, which includes the following specific steps:
step S601: double-clicking the target database identifier in the database list;
step S602: the SQL operation area (equivalent to the third area in the above embodiment) of the target database is opened on the right side of the workspace;
step S603: searching and returning a data table name and a data table field in a database;
step S604: inputting and executing an SQL operation instruction;
step S605: creating a database connection;
step S606: executing the SQL operation instruction;
step S607: and assembling and displaying the result.
As shown in fig. 7, fig. 7 is a schematic diagram of an instruction for executing SQL operations according to an embodiment of the invention.
Specifically, the optional embodiment of the present invention supports parallel execution of multiple SQL operation instructions, displays results corresponding to the multiple SQL operation instructions, highlights SQL syntax, automatically prompts MYSQL keywords, table names, table fields, and the like, and supports shortcut keys to execute the SQL operation instructions, and clears the screen.
And 4, step 4: and exporting a result corresponding to the SQL operation instruction.
As shown in fig. 8, fig. 8 is a schematic diagram of result derivation according to an embodiment of the present invention.
In the related technology, a set of complete test environment is built, a plurality of applications and databases are needed, ip addresses and port numbers corresponding to database instances are randomly distributed, if the databases are to be accessed, the databases need to be configured on a database client side for many times, a plurality of windows need to be opened when a plurality of databases are operated, and the use complexity is greatly increased. In the optional embodiment of the invention, the database and the operation database are quickly accessed by using a graphical interface without configuration in a web browser, the MySQL database is controlled and operated in a web mode, the use complexity is reduced, the database can be quickly connected and operated without specifying the connection information of the database, the highlighting and automatic prompting of SQL grammar are supported, the execution of the selected SQL segment is supported, the execution of SQL is supported by a shortcut key, the simultaneous execution of a plurality of sentences is supported, a plurality of result sets are displayed, the display of the database and the information of table structures are supported, and the export of query records into SQL sentences is supported.
By the optional embodiment of the present invention, a first operation of a target object is received through a first area of a target display interface, wherein a database list is displayed in the first area of the target display interface, the database list including one or more database identifiers; responding to the first operation, selecting a target database identifier in the database list so as to display a number corresponding to the target database in a second area of the target display interface; receiving a target Structured Query Language (SQL) operation instruction input by a target object in a third area of a target display interface; the technical scheme is adopted, the problems that in the related art, multiple configuration needs to be carried out on a database client side when a plurality of databases are accessed, a plurality of windows need to be opened when the plurality of databases are operated and the like are solved, and further the operation time of configuring the connection information of the databases is shortened and the complexity of switching back and forth of the plurality of windows is reduced.
Through the above description of the embodiments, those skilled in the art can clearly understand that the method according to the above embodiments can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware, but the former is a better implementation mode in many cases. Based on such understanding, the technical solutions of the present invention may be embodied in the form of a software product, which is stored in a storage medium (such as ROM/RAM, magnetic disk, optical disk) and includes instructions for enabling a terminal device (such as a mobile phone, a computer, a server, or a network device) to execute the method according to the embodiments of the present invention.
Fig. 9 is a block diagram of a structure of a management apparatus of a database according to an embodiment of the present invention; as shown in fig. 9, includes:
a first receiving module 32, configured to receive a first operation of a target object through a first area of a target display interface, where a database list is displayed in the first area of the target display interface, and the database list includes one or more database identifiers;
a response module 34, configured to respond to the first operation, select a target database identifier in the database list, so that a serial number corresponding to the target database is displayed in a second area of the target display interface;
a second receiving module 36, configured to receive, in a third area of the target display interface, a target structured query language SQL operation instruction input by the target object;
the searching module 38 is configured to search the target database for target data corresponding to the target structured query language SQL operation instruction, and display the target data in a fourth area of the target display interface.
According to the technical scheme, in the embodiment of the invention, a first operation of a target object is received through a first area of a target display interface, wherein a database list is displayed in the first area of the target display interface and comprises one or more database identifiers; responding to the first operation, selecting a target database identifier in the database list so as to display a number corresponding to the target database in a second area of the target display interface; receiving a target Structured Query Language (SQL) operation instruction input by a target object in a third area of a target display interface; the technical scheme is adopted, the problems that in the related art, multiple configuration needs to be carried out on a database client side when a plurality of databases are accessed, a plurality of windows need to be opened when the plurality of databases are operated and the like are solved, and further the operation time of configuring the connection information of the databases is shortened and the complexity of switching back and forth of the plurality of windows is reduced.
It should be noted that, a database list is displayed in a first area of the target display interface, the target object selects the target database in the database list, and then displays a number corresponding to the target database in a second area of the target display interface, and further opens a third area corresponding to the target database, and after the target object inputs a target structured query language SQL operation instruction through the third area of the target display interface, target data corresponding to the target structured query language SQL operation instruction is displayed in a fourth area of the target display interface.
Optionally, the response module is further configured to: acquiring a data table and a data table field corresponding to the target database from the target database; creating a database link according to the data table and the data table field corresponding to the target database; and responding to the target structured query language SQL operation instruction through the database link, and displaying target data corresponding to the target structured query language SQL operation instruction in a third area of the target display interface.
In other words, before the target data is displayed in the fourth area of the target display interface, the data table and the data table field corresponding to the target database are first obtained, a database link is further created according to the data table and the data table field, finally, the target structured query language SQL operation instruction is executed, the target data corresponding to the target structured query language SQL operation instruction is obtained through the database link, and finally, the target data is displayed in the fourth area.
Optionally, the response module is further configured to receive a second operation of the target object through the first area; and responding to the second operation, and displaying the data table of the target database in the first area.
It should be noted that all data tables in the target database can be shown in the first area by clicking on a specific symbol, such as ">, of the target database in the database list.
Further, the response module is further configured to receive a third operation of the target object through the first area; and responding to the third operation, and displaying the field information and the index information corresponding to the data table in the first area. That is, the target object may expose the spreadsheet field name and spreadsheet index in the first area by clicking on a particular symbol in the spreadsheet, such as ">".
In an optional embodiment, the apparatus further comprises: the export module is used for receiving a fourth operation of the target object after the target data is displayed in a fourth area of the target display interface; and responding to the fourth operation of the target object, and exporting the target data corresponding to the target Structured Query Language (SQL) operation instruction to a requester of the target data.
It should be noted that, when the target object needs to derive the target data corresponding to the target structured query language SQL operation instruction, the target data corresponding to the target structured query language SQL operation instruction may be derived by receiving the fourth operation of the target object.
Further, if the target structured query language SQL operation command includes a plurality of target structured query language SQL operation commands, the response module is further configured to execute the plurality of target structured query language SQL operation commands simultaneously, and display target data corresponding to the plurality of SQL operation commands simultaneously in the fourth area.
That is, a plurality of target structured query language SQL operation instructions may be executed simultaneously, and a plurality of target data corresponding to the plurality of target structured query language SQL operation instructions may be displayed simultaneously in the fourth area.
Further, the response module is further configured to, when the target object needs to derive a plurality of target data corresponding to a plurality of target structured query language SQL operation instructions, further derive a plurality of target data corresponding to the plurality of target structured query language SQL operation instructions by receiving a fifth operation of the target object.
Further, the SQL operation instruction highlights and automatically prompts MYSQL keywords, table names, table fields and the like, and the SQL operation instruction can be executed through a shortcut key.
An embodiment of the present invention further provides a storage medium including a stored program, wherein the program executes any one of the methods described above.
Alternatively, in the present embodiment, the storage medium may be configured to store program codes for performing the following steps:
s1, receiving a first operation of a target object through a first area of a target display interface, wherein a database list is displayed in the first area of the target display interface and comprises one or more database identifications;
s2, responding to the first operation, selecting a target database identifier in the database list so as to display a number corresponding to the target database in a second area of the target display interface; a
S3, receiving a target Structured Query Language (SQL) operation instruction input by the target object in a third area of the target display interface;
s4, searching the target data corresponding to the target Structured Query Language (SQL) operation instruction in the target database, and displaying the target data in a fourth area of the target display interface.
An embodiment of the present invention further provides a storage medium including a stored program, wherein the program executes any one of the methods described above.
Embodiments of the present invention also provide an electronic device comprising a memory having a computer program stored therein and a processor arranged to run the computer program to perform the steps of any of the above method embodiments.
Optionally, the electronic apparatus may further include a transmission device and an input/output device, wherein the transmission device is connected to the processor, and the input/output device is connected to the processor.
Optionally, in this embodiment, the processor may be configured to execute the following steps by a computer program:
s1, receiving a first operation of a target object through a first area of a target display interface, wherein a database list is displayed in the first area of the target display interface and comprises one or more database identifications;
s2, responding to the first operation, selecting a target database identifier in the database list so as to display a number corresponding to the target database in a second area of the target display interface; a
S3, receiving a target Structured Query Language (SQL) operation instruction input by the target object in a third area of the target display interface;
s4, searching the target data corresponding to the target Structured Query Language (SQL) operation instruction in the target database, and displaying the target data in a fourth area of the target display interface.
Optionally, in this embodiment, the storage medium may include, but is not limited to: various media capable of storing program codes, such as a usb disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a removable hard disk, a magnetic disk, or an optical disk.
Optionally, the specific examples in this embodiment may refer to the examples described in the above embodiments and optional implementation manners, and this embodiment is not described herein again.
It will be apparent to those skilled in the art that the modules or steps of the present invention described above may be implemented by a general purpose computing device, they may be centralized on a single computing device or distributed across a network of multiple computing devices, and alternatively, they may be implemented by program code executable by a computing device, such that they may be stored in a storage device and executed by a computing device, and in some cases, the steps shown or described may be performed in an order different than that described herein, or they may be separately fabricated into individual integrated circuit modules, or multiple ones of them may be fabricated into a single integrated circuit module. Thus, the present invention is not limited to any specific combination of hardware and software.
The above description is only a preferred embodiment of the present invention and is not intended to limit the present invention, and various modifications and changes may be made by those skilled in the art. Any modification, equivalent replacement, or improvement made within the principle of the present invention should be included in the protection scope of the present invention.
Claims (10)
1. A method for managing a database, comprising:
receiving a first operation of a target object through a first area of a target display interface, wherein a database list is displayed in the first area of the target display interface and comprises one or more database identifications;
responding to the first operation, selecting a target database identifier in the database list so as to display a number corresponding to the target database in a second area of the target display interface;
receiving a target Structured Query Language (SQL) operation instruction input by the target object in a third area of the target display interface;
and searching target data corresponding to the target Structured Query Language (SQL) operation instruction in the target database, and displaying the target data in a fourth area of the target display interface.
2. The method of claim 1, wherein prior to displaying the target data in the fourth region of the target display interface, the method further comprises:
acquiring a data table and a data table field corresponding to the target database from the target database;
creating a database link according to the data table and the data table field corresponding to the target database;
and responding to the target structured query language SQL operation instruction through the database link, and displaying target data corresponding to the target structured query language SQL operation instruction in a third area of the target display interface.
3. The method of claim 1, further comprising:
receiving a second operation of the target object through the first area;
and responding to the second operation, and displaying the data table of the target database in the first area.
4. The method of claim 3, wherein after the first area displays the data tables of the target database, the method further comprises:
receiving a third operation of the target object through the first area;
and responding to the third operation, and displaying the field information and the index information corresponding to the data table in the first area.
5. The method of claim 1, wherein after the target data is displayed in the fourth region of the target display interface, the method further comprises:
receiving a fourth operation of the target object;
and responding to the fourth operation of the target object, and exporting the target data corresponding to the target Structured Query Language (SQL) operation instruction to a requester of the target data.
6. The method according to claim 1, wherein a target Structured Query Language (SQL) operation instruction input by the target object is received in a third area of the target display interface, and the method further comprises:
and under the condition that the target structured query language SQL operation instruction comprises a plurality of target structured query language SQL operation instructions, simultaneously executing the plurality of target structured query language SQL operation instructions, and simultaneously displaying target data corresponding to the plurality of SQL operation instructions in the fourth area.
7. An apparatus for managing a database, comprising:
the system comprises a first receiving module, a first display module and a second receiving module, wherein the first receiving module is used for receiving a first operation of a target object through a first area of a target display interface, a database list is displayed in the first area of the target display interface and comprises one or more database identifications;
the response module is used for responding to the first operation and selecting a target database identifier in the database list so as to display a serial number corresponding to the target database in a second area of the target display interface;
the second receiving module is used for receiving a target Structured Query Language (SQL) operation instruction input by the target object in a third area of the target display interface;
and the searching module is used for searching the target data corresponding to the target Structured Query Language (SQL) operation instruction in the target database and displaying the target data in a fourth area of the target display interface.
8. The apparatus of claim 7, wherein the response module is further configured to:
acquiring a data table and a data table field corresponding to the target database from the target database; creating a database link according to the data table and the data table field corresponding to the target database; and responding to the target structured query language SQL operation instruction through the database link, and displaying target data corresponding to the target structured query language SQL operation instruction in a third area of the target display interface.
9. A computer-readable storage medium, comprising a stored program, wherein the program is operable to perform the method of any one of claims 1 to 6.
10. An electronic device comprising a memory and a processor, characterized in that the memory has stored therein a computer program, the processor being arranged to execute the method of any of claims 1 to 6 by means of the computer program.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110197272.5A CN112860699A (en) | 2021-02-22 | 2021-02-22 | Database management method and device, storage medium and electronic device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110197272.5A CN112860699A (en) | 2021-02-22 | 2021-02-22 | Database management method and device, storage medium and electronic device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112860699A true CN112860699A (en) | 2021-05-28 |
Family
ID=75988530
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110197272.5A Pending CN112860699A (en) | 2021-02-22 | 2021-02-22 | Database management method and device, storage medium and electronic device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112860699A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113282502A (en) * | 2021-06-04 | 2021-08-20 | 青岛海尔科技有限公司 | Script generation method, device, storage medium and electronic device |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040103073A1 (en) * | 2002-11-21 | 2004-05-27 | Blake M. Brian | System for and method of using component-based development and web tools to support a distributed data management system |
| CN109165039A (en) * | 2018-04-28 | 2019-01-08 | 北京数聚鑫云信息技术有限公司 | A kind of configuration and execution method, system and medium of web API |
| CN109558447A (en) * | 2018-12-14 | 2019-04-02 | 万翼科技有限公司 | Data managing method, device and computer readable storage medium |
| CN109710655A (en) * | 2018-11-09 | 2019-05-03 | 中国平安人寿保险股份有限公司 | Data base query method, device, terminal device and storage medium |
| US20200311108A1 (en) * | 2019-03-29 | 2020-10-01 | Mckesson Corporation | Methods and systems for supply chain analytics |
| CN112286943A (en) * | 2020-12-26 | 2021-01-29 | 东华理工大学南昌校区 | Ideological and political theory teaching plan display method and system based on current affair case optimization |
| CN112364033A (en) * | 2021-01-13 | 2021-02-12 | 北京云真信科技有限公司 | Data retrieval system |
-
2021
- 2021-02-22 CN CN202110197272.5A patent/CN112860699A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040103073A1 (en) * | 2002-11-21 | 2004-05-27 | Blake M. Brian | System for and method of using component-based development and web tools to support a distributed data management system |
| CN109165039A (en) * | 2018-04-28 | 2019-01-08 | 北京数聚鑫云信息技术有限公司 | A kind of configuration and execution method, system and medium of web API |
| CN109710655A (en) * | 2018-11-09 | 2019-05-03 | 中国平安人寿保险股份有限公司 | Data base query method, device, terminal device and storage medium |
| CN109558447A (en) * | 2018-12-14 | 2019-04-02 | 万翼科技有限公司 | Data managing method, device and computer readable storage medium |
| US20200311108A1 (en) * | 2019-03-29 | 2020-10-01 | Mckesson Corporation | Methods and systems for supply chain analytics |
| CN112286943A (en) * | 2020-12-26 | 2021-01-29 | 东华理工大学南昌校区 | Ideological and political theory teaching plan display method and system based on current affair case optimization |
| CN112364033A (en) * | 2021-01-13 | 2021-02-12 | 北京云真信科技有限公司 | Data retrieval system |
Non-Patent Citations (3)
| Title |
|---|
| MANOJ E. PATIL等: "Design and implementation of graphical user interface for relational database management system", 《INTERNATIONAL JOURNAL OF COMPUTER SCIENCE AND INFORMATION TECHNOLOGIES》, vol. 3, no. 3, pages 3871 - 3874 * |
| SHWETA MALHOTRA等: "Generalized Query Processing Mechanism in Cloud Database Management System", 《BIG DATA ANALYTICS:PROCEEDING OF CSI 2015》, vol. 654, pages 641 - 648 * |
| 林琛等: "福建省交通工程地质数据库管理系统的构建与开发", 《福建交通科技》, no. 2021, pages 111 - 114 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113282502A (en) * | 2021-06-04 | 2021-08-20 | 青岛海尔科技有限公司 | Script generation method, device, storage medium and electronic device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107809383B (en) | MVC-based path mapping method and device | |
| CN111209309B (en) | Method, device and equipment for determining processing result of data flow graph and storage medium | |
| US8161140B2 (en) | Interfacing between a command line interface-based application program and a remote network device | |
| US9532196B2 (en) | Method for implementing unstructured supplementary service data service | |
| CN108197091B (en) | Method, system and related equipment for creating data table | |
| WO2015058599A1 (en) | Method and apparatus for searching for and locating application program | |
| CN112084315A (en) | Question-answer interaction method, device, storage medium and equipment | |
| CN108664665A (en) | Data format method for transformation, device, equipment and readable storage medium storing program for executing | |
| CN104679900A (en) | Application program searching method and device | |
| US20190236202A1 (en) | Systems to interleave search results and related methods therefor | |
| CN106156088A (en) | A kind of index data processing method, data query method and device | |
| CN111047434B (en) | Operation record generation method and device, computer equipment and storage medium | |
| CN112860699A (en) | Database management method and device, storage medium and electronic device | |
| CN110941634A (en) | Data processing method and device, storage medium and electronic device | |
| CN106850838A (en) | The control method and system of mobile terminal cloud application | |
| CN110278565A (en) | A kind of base station design method and device | |
| CN111385110B (en) | Network management method and device | |
| CN114296696A (en) | Business function operation method and device, storage medium and electronic equipment | |
| CN114721640A (en) | Code completion method and device, storage medium, processor and terminal | |
| CN114003329A (en) | Data display component creating method and device, storage medium and electronic device | |
| CN112667632A (en) | Metadata processing method and device | |
| CN110609781A (en) | Interface test method, device and storage medium | |
| CN111488368A (en) | Data query method and device and electronic equipment | |
| CN104462426B (en) | The method and device of the site information of internet information query service | |
| CN110019190B (en) | Method and device for creating index |
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 |