Database management interface operation method, device and electronic device

Abstract

The present invention provides a method, device and electronic device for operating a database management interface, which can be applied to the fields of data security, front-end development and computer technology. The method comprises: in response to an interface switching instruction, determining whether a selector in a database management interface is in an activated state, wherein the activated state indicates that the focus in the database management interface is located at the position of the selector, and the selector includes a drop-down box; when the selector is in an activated state, switching the state of the selector to an inactive state; switching from the database management interface to other interfaces corresponding to the interface switching instruction; in response to an interface recovery instruction, switching from other interfaces to the database management interface; wherein the current state of the selector in the database management interface is in a folded state of the drop-down box.

Description

Technical Field

[0001] The present invention relates to the fields of data security, front-end development and computer technology, and in particular to a database management interface operation method, device and electronic equipment. Background Art

[0002] In the process of using a database, in order to improve the user experience, the data in the database is usually operated through a database management interface. In the database management interface, the user can select the operation method for the data in the database through a drop-down box.

[0003] In the process of implementing the present invention, it is found that the prior art has at least the following problems: after the user operates the drop-down box and selects an option, the drop-down box will usually expand automatically during the page switching process, affecting the normal operation of the database management interface. Summary of the invention

[0004] In view of the above problems, the present invention provides a database management interface operation method, device, equipment, medium and program product.

[0005] According to a first aspect of the present invention, a method for operating a database management interface is provided, comprising: in response to an interface switching instruction, determining whether a selector in the database management interface is in an activated state, wherein the activated state indicates that the focus in the database management interface is located at the position of the selector, and the selector includes a drop-down box; when the selector is in an activated state, switching the state of the selector to an inactivated state; switching from the database management interface to other interfaces corresponding to the interface switching instruction; in response to an interface recovery instruction, switching from other interfaces to the database management interface; wherein the current state of the selector in the database management interface is in a folded state of the drop-down box.

[0006] According to an embodiment of the present invention, switching the state of the selector to the inactive state includes: calling a defocus method of the selector to switch the position of the focus to a position different from the position of the selector.

[0007] According to an embodiment of the present invention, a defocus method of a selector is called to switch the focus position to a position different from the position of the selector, including: based on the position of the focus, using registration information on an interface framework, determining reference information of the selector, wherein the interface framework is used to manage a database management interface, the registration information includes a mapping relationship between the position of the selector and the reference information of the selector, the reference information of the selector is used to identify the selector, and the position of the selector is determined using front-end component positioning technology; calling the defocus method of the selector based on the reference information of the selector; using the defocus method to click a position other than the position of the selector in the database management interface to switch the focus position to a position different from the position of the selector.

[0008] According to an embodiment of the present invention, the database management interface includes a selector and other components; switching the focus position to a position different from the position of the selector includes: determining the component position of other components; using the click operation script of the document object model to click the component position on the database management interface to switch the focus position to the component position.

[0009] According to an embodiment of the present invention, the database management interface operation method also includes: expanding the drop-down box in response to a drop-down box expansion instruction; selecting a target option from a plurality of alternative options included in the drop-down box in response to an option determination instruction; and performing an operation corresponding to the target option; wherein the drop-down box expansion instruction is generated by operating a selector in the database management interface.

[0010] According to an embodiment of the present invention, the alternative options include operating methods for the data table displayed on the database management interface, the operating methods including deletion, modification and replacement; performing operations corresponding to the target options, including: using a data binding mechanism to store the operating methods corresponding to the target options and the data table currently displayed on the database management interface, and setting the state of the drop-down box to a collapsed state; using the operating methods corresponding to the target options to operate the data table displayed on the database management interface.

[0011] According to an embodiment of the present invention, an operation method corresponding to a target option is used to operate a data table displayed on a database management interface, including: when the operation method corresponding to the target option is deletion, deleting the data table; when the operation method corresponding to the target option is modification, determining the original data in the data table that needs to be modified based on a data selection instruction; modifying the original data using modification data corresponding to the original data to obtain a data table after the operation; when the operation method corresponding to the target option is replacement, replacing the data table using a replacement data table to obtain a data table after the operation.

[0012] According to an embodiment of the present invention, the database management interface operation method also includes: determining the table identifier of the data table when data recovery is required for the operated data table; and reading the historical data table corresponding to the table identifier from the data binding mechanism based on the table identifier of the data table.

[0013] A second aspect of the present invention provides a database management interface operating device, comprising:

[0014] A state determination module, for determining whether a selector in the database management interface is in an activated state in response to an interface switching instruction, wherein the activated state indicates that the focus in the database management interface is located at the position of the selector, and the selector includes a drop-down box;

[0015] A state switching module is used to switch the state of the selector to an inactive state when the selector is in an active state;

[0016] An interface switching module, used to switch from the database management interface to other interfaces corresponding to the interface switching instruction;

[0017] An interface recovery module, used to switch from other interfaces to the database management interface in response to an interface recovery instruction;

[0018] Among them, the current state of the selector in the database management interface is the drop-down box collapsed state.

[0019] A third aspect of the present invention provides an electronic device, comprising: one or more processors; a memory for storing one or more computer programs, wherein the one or more processors execute the one or more computer programs to implement the steps of the above method.

[0020] The fourth aspect of the present invention further provides a computer-readable storage medium on which a computer program or instruction is stored, and the steps of the above method are implemented when the above computer program or instruction is executed by a processor.

[0021] The fifth aspect of the present invention also provides a computer program product, including a computer program or instructions, which implement the steps of the above method when executed by a processor.

[0022] According to an embodiment of the present invention, after receiving an interface switching instruction and before executing the interface switching operation, the state of the selector in the database management interface is determined, and when the selector is in an activated state, it is switched to an inactivated state before the interface switching is performed, and after receiving an interface recovery instruction, the interface is switched back to the database management interface from other pages. Since the state of the selector is determined before the interface switching, and the interface switching is performed after ensuring that the state of the selector is in an inactivated state, it can be ensured that after the interface is switched back to the database management interface, the drop-down box corresponding to the selector is in a folded state, avoiding the user's misoperation to change the selected content in the selector due to the drop-down box still being in an expanded state after issuing the interface recovery instruction, thereby ensuring the accuracy and security of the data. In addition, it can also avoid the need for an additional click operation to collapse the drop-down box due to the drop-down box being in an expanded state after switching back to the database management interface, which can reduce the amount of operation during interface switching and improve user experience. BRIEF DESCRIPTION OF THE DRAWINGS

[0023] The above contents and other objects, features and advantages of the present invention will become more apparent through the following description of the embodiments of the present invention with reference to the accompanying drawings.

[0024] Figure 1An application scenario diagram of a database management interface operation method, apparatus, device, medium, and program product according to an embodiment of the present invention is shown.

[0025] Figure 2 A flow chart of a database management interface operation method according to an embodiment of the present invention is shown.

[0026] Figure 3A A static diagram of a database management interface according to an embodiment of the present invention is shown.

[0027] Figure 3B The diagram shows the operation result of the database management interface of the related example before the database management interface operation method is applied.

[0028] Figure 3C A diagram showing the operation result after the database management interface according to an embodiment of the present invention is applied with the database management interface operation method.

[0029] Figure 4 A structural block diagram of a database management interface operating device according to an embodiment of the present invention is shown.

[0030] Figure 5 A block diagram of an electronic device suitable for implementing a database management interface operation method according to an embodiment of the present invention is shown. DETAILED DESCRIPTION

[0031] Below, embodiments of the present invention will be described with reference to the accompanying drawings. However, it should be understood that these descriptions are exemplary only and are not intended to limit the scope of the present invention. In the following detailed description, for ease of explanation, many specific details are set forth to provide a comprehensive understanding of embodiments of the present invention. However, it is apparent that one or more embodiments may also be implemented without these specific details. In addition, in the following description, descriptions of known structures and technologies are omitted to avoid unnecessary confusion of concepts of the present invention.

[0032] The terms used herein are only for describing specific embodiments and are not intended to limit the present invention. The terms "comprise", "include", etc. used herein indicate the existence of the features, steps, operations and / or components, but do not exclude the existence or addition of one or more other features, steps, operations or components.

[0033] All terms (including technical and scientific terms) used herein have the meanings commonly understood by those skilled in the art unless otherwise defined. It should be noted that the terms used herein should be interpreted as having a meaning consistent with the context of this specification and should not be interpreted in an idealized or overly rigid manner.

[0034] When using expressions such as "at least one of A, B, and C, etc.", they should generally be interpreted according to the meaning of the expression commonly understood by those skilled in the art (for example, "a system having at least one of A, B, and C" should include but is not limited to a system having A alone, B alone, C alone, A and B, A and C, B and C, and / or A, B, C, etc.).

[0035] In the technical solution of the present invention, the user information (including but not limited to user personal information, user image information, user device information, such as location information, etc.) and data (including but not limited to data used for analysis, stored data, displayed data, etc.) involved are all information and data authorized by the user or fully authorized by all parties, and the collection, storage, use, processing, transmission, provision, invention and application of the relevant data comply with relevant laws, regulations and standards, take necessary confidentiality measures, do not violate public order and good morals, and provide corresponding operation entrances for users to choose to authorize or refuse.

[0036] In the scenario of using personal information for automated decision-making, the methods, devices, and systems provided by the embodiments of the present invention provide users with corresponding operation portals for users to choose to agree or reject the automated decision-making results; if the user chooses to reject, the expert decision-making process will be entered. The expression "automated decision-making" here refers to the activity of automatically analyzing and evaluating an individual's behavioral habits, interests and hobbies, or economic, health, credit status, etc. through computer programs, and making decisions. The expression "expert decision-making" here refers to the activity of making decisions by people who specialize in a certain field, have specialized experience, knowledge and skills, and have reached a certain level of professionalism.

[0037] When the user switches to other software or switches to other tabs in the browser to perform operations and then switches back to the front-end page of the database, the drop-down box will usually expand automatically due to the browser's event mechanism. In this case, the selected option in the drop-down box is easily changed due to the user's accidental touch of input devices such as the keyboard and mouse, affecting the user experience and may also lead to incorrect operation of the data and reduce the security of the data.

[0038] An embodiment of the present invention provides a method for operating a database management interface, comprising: in response to an interface switching instruction, determining whether a selector in the database management interface is in an activated state, wherein the activated state indicates that the focus in the database management interface is located at the position of the selector, and the selector includes a drop-down box; when the selector is in an activated state, switching the state of the selector to an inactivated state; switching from the database management interface to other interfaces corresponding to the interface switching instruction; in response to an interface recovery instruction, switching from other interfaces to the database management interface; wherein the current state of the selector in the database management interface is in a folded state of the drop-down box.

[0039] Figure 1 An application scenario diagram of a database management interface operation method, apparatus, device, medium, and program product according to an embodiment of the present invention is shown.

[0040] like Figure 1 As shown, the application scenario 100 according to this embodiment may include a first terminal device 101, a second terminal device 102, a third terminal device 103, a network 104, and a server 105. The network 104 is used to provide a medium for a communication link between the first terminal device 101, the second terminal device 102, the third terminal device 103, and the server 105. The network 104 may include various connection types, such as wired, wireless communication links, or optical fiber cables, etc.

[0041] The user can use the first terminal device 101, the second terminal device 102, and the third terminal device 103 to interact with the server 105 through the network 104 to receive or send messages, etc. Various communication client applications can be installed on the first terminal device 101, the second terminal device 102, and the third terminal device 103, such as shopping applications, web browser applications, search applications, instant messaging tools, email clients, social platform software, etc. (only for example).

[0042] The first terminal device 101, the second terminal device 102, and the third terminal device 103 may be various electronic devices having display screens and supporting web browsing, including but not limited to smart phones, tablet computers, laptop computers, desktop computers, and the like.

[0043] The server 105 may be a server that provides various services, such as a background management server (only as an example) that provides support for websites browsed by users using the first terminal device 101, the second terminal device 102, and the third terminal device 103. The background management server may analyze and process the received data such as user requests, and feed back the processing results (such as web pages, information, or data obtained or generated according to user requests) to the terminal device.

[0044] It should be noted that the database management interface operation method provided in the embodiment of the present invention can generally be executed by the server 105. Accordingly, the database management interface operation device provided in the embodiment of the present invention can generally be set in the server 105. The database management interface operation method provided in the embodiment of the present invention can also be executed by a server or server cluster that is different from the server 105 and can communicate with the first terminal device 101, the second terminal device 102, the third terminal device 103 and / or the server 105. Accordingly, the database management interface operation device provided in the embodiment of the present invention can also be set in a server or server cluster that is different from the server 105 and can communicate with the first terminal device 101, the second terminal device 102, the third terminal device 103 and / or the server 105.

[0045] It should be understood that Figure 1 The number of terminal devices, networks and servers in the embodiment is only for illustration. Any number of terminal devices, networks and servers may be provided according to the implementation requirements.

[0046] The following will be based on Figure 1 The scene described by Figure 2 , Figure 3A , Figure 3B , Figure 3C The database management interface operation method of the embodiment of the present invention is described in detail.

[0047] Figure 2 A flow chart of a database management interface operation method according to an embodiment of the present invention is shown.

[0048] like Figure 2 As shown, the database management interface operation method of this embodiment includes operations S210 to S240.

[0049] In operation S210 , in response to an interface switching instruction, it is determined whether a selector in the database management interface is in an activated state.

[0050] In operation S220, in a case where the selector is in an activated state, the state of the selector is switched to an inactivated state.

[0051] In operation S230, the database management interface is switched to another interface corresponding to the interface switching instruction.

[0052] In operation S240 , in response to the interface recovery instruction, switching is performed from other interfaces to the database management interface.

[0053] According to an embodiment of the present invention, in response to an interface switching instruction, it is determined whether a selector in a database management interface is in an activated state, wherein the interface switching instruction is used to switch from the database management interface to another interface different from the database management interface, and the selector being in an activated state indicates that the focus in the database management interface is located at the position of the selector, and the focus of the database management interface indicates an element that can currently be interacted with using an input device, and the selector includes a drop-down box. When the selector is in an activated state, the value selected in the drop-down box corresponding to the selector can be changed by an input device such as a mouse or keyboard.

[0054] According to an embodiment of the present invention, when it is determined that the selector is in an activated state, the state of the selector is switched to an inactivated state, wherein the selector being in an inactivated state indicates that the focus position in the database management interface is different from the position of the selector.

[0055] According to an embodiment of the present invention, the database management interface is switched to other interfaces corresponding to the interface switching instruction, wherein the interface operation instruction may include a target interface, and the target interface is displayed after executing the interface switching instruction. Therefore, the target interface of the interface operation instruction is other interfaces in the system that are different from the database management interface.

[0056] According to an embodiment of the present invention, in response to an interface recovery instruction, a switch is made from other interfaces to a database management interface, wherein the interface recovery instruction may include a target interface, and the target interface of the interface recovery instruction is the database management interface. After switching back to the database management interface, the current state of the selector of the database management interface is in a folded state of the drop-down box, and the selector is in an inactive state, thereby avoiding changes in the selected value in the drop-down box due to operations such as accidental touching of the input device due to the selector being in an activated state.

[0057] According to an embodiment of the present invention, after receiving an interface switching instruction and before executing the interface switching operation, the state of the selector in the database management interface is determined, and when the selector is in an activated state, it is switched to an inactivated state before the interface switching is performed, and after receiving an interface recovery instruction, the interface is switched back to the database management interface from other pages. Since the state of the selector is determined before the interface switching, and the interface switching is performed after ensuring that the state of the selector is in an inactivated state, it can be ensured that after the interface is switched back to the database management interface, the drop-down box corresponding to the selector is in a folded state, avoiding the user's misoperation to change the selected content in the selector due to the drop-down box still being in an expanded state after issuing the interface recovery instruction, thereby ensuring the accuracy and security of the data. In addition, it can also avoid the need for an additional click operation to collapse the drop-down box due to the drop-down box being in an expanded state after switching back to the database management interface, which can reduce the amount of operation during interface switching and improve user experience.

[0058] According to an embodiment of the present invention, switching the state of the selector to the inactive state includes: calling a defocus method of the selector to switch the position of the focus to a position different from the position of the selector.

[0059] According to an embodiment of the present invention, the defocus method in the front-end interface can be used to specify a component, and after executing the defocus method, the specified component is defocused, that is, the position of the focus in the interface is not at the position of the component. Therefore, calling the defocus method of the selector can switch the position of the focus to a position different from the position of the selector.

[0060] According to an embodiment of the present invention, a defocusing method of the selector is called to switch the focus position to a position different from the position of the selector, thereby utilizing an automated method to switch the state of the selector to an inactive state, thereby improving the efficiency and accuracy of focus switching.

[0061] According to an embodiment of the present invention, a defocus method of a selector is called to switch the focus position to a position different from the position of the selector, including: based on the position of the focus, using registration information on an interface framework, determining reference information of the selector, wherein the interface framework is used to manage a database management interface, the registration information includes a mapping relationship between the position of the selector and the reference information of the selector, the reference information of the selector is used to identify the selector, and the position of the selector is determined using front-end component positioning technology; calling the defocus method of the selector based on the reference information of the selector; using the defocus method to click a position other than the position of the selector in the database management interface to switch the focus position to a position different from the position of the selector.

[0062] According to an embodiment of the present invention, a database management interface can be constructed using an interface framework, which includes registration information of multiple components. Each registration information includes reference information of the corresponding component and the position of the component in the database management interface, wherein the reference information can be used to uniquely identify a component, that is, there is a one-to-one correspondence between the reference information and the component.

[0063] According to an embodiment of the present invention, the reference information of the component can be registered in the interface framework in advance, and the position of the component in the database management interface can be determined using the front-end component positioning technology. By determining the correspondence between the position of the component and the reference information of the component, the registration information can be obtained.

[0064] According to an embodiment of the present invention, based on the position of the focus, the registration information at the position of the focus is determined, and the reference information of the selector is determined by using the registration information on the interface frame. The defocus method of the selector is called based on the reference information of the selector, and the reference information of the selector is filled in the parameter list of the defocus method as a parameter. The defocus method can be executed to perform a click operation in the database management interface. The position of the click operation is a position other than the position of the selector, and the position of the focus in the database management interface can be switched to a position different from the position of the selector.

[0065] According to an embodiment of the present invention, based on the position of the focus, the reference information of the selector is determined using the registration information on the interface frame, and the defocus method of the selector is called based on the reference information, and the defocus method is used to click a position other than the selector position in the database management interface, thereby achieving defocus of the selector. Since the reference information is determined based on the position of the focus, calling the defocus method based on the reference information can ensure that the focus position in the interface changes after the click operation, that is, the focus position is not located at the position of the selector, thereby ensuring that the selector is in an inactive state and ensuring the accuracy of the defocus operation.

[0066] According to an embodiment of the present invention, the database management interface includes a selector and other components; switching the focus position to a position different from the position of the selector includes: determining the component position of other components; using the click operation script of the document object model to click the component position on the database management interface to switch the focus position to the component position.

[0067] According to an embodiment of the present invention, the component positions of other components in the database management interface are determined, wherein the component positions of other components can be determined using front-end component positioning technology. The component position on the database management interface is clicked using a click operation script of a Document Object Model (DOM) to switch the focus position to the component position, wherein the click operation script is a script pre-configured in the Document Object Model, and by setting parameters of the click operation script, the click operation script can be used to click on a position corresponding to the parameters.

[0068] According to an embodiment of the present invention, the component position of other components is determined, and the component position is clicked using the click operation script of the DOM, thereby switching the focus position to the component position. Since the component position of other components and the position of the drop-down box must be different in the same interface, the component position is clicked using the click operation script, and the focus position is switched to the component position to ensure that the focus position is not at the position of the drop-down box, thereby ensuring the accuracy of the out-of-focus operation.

[0069] According to an embodiment of the present invention, the database management interface operation method also includes: expanding the drop-down box in response to a drop-down box expansion instruction; selecting a target option from a plurality of alternative options included in the drop-down box in response to an option determination instruction; and performing an operation corresponding to the target option; wherein the drop-down box expansion instruction is generated by operating a selector in the database management interface.

[0070] According to an embodiment of the present invention, in response to a drop-down box expansion instruction, the drop-down box is expanded, wherein the drop-down box expansion instruction is generated by operating a selector in a database management interface, wherein the type of operation of the selector includes a click operation, and after the drop-down box is expanded, multiple alternative options included in the drop-down box are displayed. In response to an option determination instruction, a target option is selected from multiple alternative options, wherein the option determination instruction is formed by operating one of the multiple alternative options of the selector, wherein the operation of the alternative option includes a click operation. Each alternative option corresponds to an operation mode for a data table displayed on the database management interface, and an operation corresponding to the target option is performed on the data table, wherein the operation mode includes deletion, modification and replacement.

[0071] According to an embodiment of the present invention, in response to a drop-down box expansion instruction, the drop-down box is expanded and multiple alternative options included in the drop-down box are displayed, and in response to an option determination instruction, a target option is determined from the multiple alternative options, and an operation corresponding to the target option is performed to ensure that the operation performed is the operation corresponding to the target option corresponding to the option determination instruction, thereby ensuring the correctness of the operation.

[0072] According to an embodiment of the present invention, the alternative options include operating methods for the data table displayed on the database management interface, the operating methods including deletion, modification and replacement; performing operations corresponding to the target options, including: using a data binding mechanism to store the operating methods corresponding to the target options and the data table currently displayed on the database management interface, and setting the state of the drop-down box to a collapsed state; using the operating methods corresponding to the target options to operate the data table displayed on the database management interface.

[0073] According to an embodiment of the present invention, a data binding mechanism is used to store the operation mode corresponding to the target option and the data table currently displayed on the database management interface, wherein the data binding mechanism can be used to save the target option in the drop-down box to ensure the synchronization of options between the background data and the database management interface, and can also be used to save the data table currently displayed on the database management interface, so that when the data table needs to be restored, the data table stored in the data binding mechanism can be rolled back.

[0074] According to an embodiment of the present invention, the state of the drop-down box is set to a folded state, wherein after being set to the folded state, the content displayed in the drop-down box is the content of the target option. The data table displayed on the database management interface is operated using the operation method corresponding to the target option.

[0075] According to an embodiment of the present invention, the database management interface may include multiple selectors, wherein the multiple alternative options included in the drop-down boxes corresponding to other selectors may be the table names of multiple data tables, and the data table currently displayed on the database management interface is the data table corresponding to the target option of the selector.

[0076] According to an embodiment of the present invention, a data binding mechanism is used to store the operation mode corresponding to the target option and the data table currently displayed on the database management interface, wherein storing the operation mode corresponding to the target option can ensure that the content displayed in the drop-down box in the database management interface is consistent with the option corresponding to the option determination instruction stored in the background, thereby ensuring the correctness of the display of the database management interface; storing the data table currently displayed on the database management interface can provide a data basis for recovery when the data table needs to be restored, thereby improving data security.

[0077] Figure 3A A static diagram of a database management interface according to an embodiment of the present invention is shown.

[0078] like Figure 3A As shown, the database management interface 301 includes a drop-down box 302, a data table 303, an input box 304 and a button 305, wherein the number of the drop-down boxes, input boxes and buttons is only illustrative. According to the implementation requirements, there can be any number of drop-down boxes, input boxes and buttons.

[0079] Figure 3B The diagram shows the operation result of the database management interface of the related example before the database management interface operation method is applied.

[0080] like Figure 3B As shown, when the database management interface operation method is not applied in the database management interface, after switching from the database management interface to other interfaces and then switching back to the database management interface, the selector will be in an activated state and the drop-down box will be in an expanded state 3021. In this case, although the content displayed in the drop-down box is still the content of the target option, the target option may be changed due to accidental touching of input devices such as a mouse or keyboard, thereby operating the data table according to the operation method corresponding to the wrong target option, resulting in errors in the data table content.

[0081] Figure 3C A diagram showing the operation result after the database management interface according to an embodiment of the present invention is applied with the database management interface operation method.

[0082] like Figure 3C As shown, when the database management interface operation method is applied in the database management interface, after switching from the database management interface to other interfaces and then switching back to the database management interface, the selector will be in an inactive state and the drop-down box will be in a folded state 3022. In this case, the content displayed in the drop-down box is the content of the target option. In this embodiment, the focus of the interface is located at the input box 304. In other embodiments of the present invention, the focus of the interface can also be located at a blank space, that is, no component is activated, thereby ensuring that the target option will not be changed due to an accidental touch of an input device such as a mouse or keyboard, and the data table is operated according to the operation method corresponding to the correct target option, thereby improving data accuracy and data security.

[0083] According to an embodiment of the present invention, an operation method corresponding to a target option is used to operate a data table displayed on a database management interface, including: when the operation method corresponding to the target option is deletion, deleting the data table; when the operation method corresponding to the target option is modification, determining the original data in the data table that needs to be modified based on a data selection instruction; modifying the original data using modification data corresponding to the original data to obtain a data table after the operation; when the operation method corresponding to the target option is replacement, replacing the data table using a replacement data table to obtain a data table after the operation.

[0084] According to an embodiment of the present invention, when the operation mode corresponding to the target option is deletion, the data table is deleted from the database according to the table name of the data table.

[0085] According to an embodiment of the present invention, when the operation mode corresponding to the target option is modification, the original data in the data table that needs to be modified is determined based on the data selection instruction, wherein the granularity of the original data can be a row in the data table, and the data selection instruction can be triggered by a click operation on the original data in the data table that needs to be modified. The original data is modified using the modified data corresponding to the original data to obtain a data table after the operation, and the data table in the database is updated using the data table after the operation, wherein the modified data has the same number of columns as the original data, and the data format at the corresponding position is the same, and the modified data can be input by the user.

[0086] According to an embodiment of the present invention, when the operation mode corresponding to the target option is replacement, the data table is replaced with the replacement data table corresponding to the data table to obtain the data table after the operation, and the data table in the database is updated with the data table after the operation, wherein the replacement data table and the data table can be data tables of the same format or different formats. When the format of the data table is incorrect and needs to be corrected, the format of the replacement data table is different from that of the data table. When the format of the data table is correct but a large amount of data in the data table needs to be replaced, the format of the replacement data table is the same as that of the data table. The replacement data table can be input by the user or specified by the user as other data tables in the database.

[0087] According to an embodiment of the present invention, different operation modes are used to operate the data table according to different target options, wherein, when the operation mode corresponding to the target option is deletion, the data table is deleted, when the operation mode corresponding to the target option is modification, the original data in the data table that needs to be modified is determined, and the original data is modified according to the modification data input by the user, and when the operation mode corresponding to the target option is replacement, the data table is replaced by a replacement data table. Since the operation mode is determined by the target option, operating the data table using the operation mode can ensure the correctness of the operation and improve data security and operation efficiency.

[0088] According to an embodiment of the present invention, the database management interface operation method also includes: determining the table identifier of the data table when data recovery is required for the operated data table; and reading the historical data table corresponding to the table identifier from the data binding mechanism based on the table identifier of the data table.

[0089] According to an embodiment of the present invention, when it is necessary to perform data recovery on a data table after an operation, the table identifier of the data table is determined, wherein the table identifier can be used to uniquely identify a data table. The situations in which data recovery is required may include version recovery, erroneous operation, etc.

[0090] According to an embodiment of the present invention, based on the table identifier of the data table, the historical data table corresponding to the table identifier is read from the data binding mechanism, the data table is replaced with the historical data table to obtain the restored data table, and the restored data table is used to update the data table in the database to complete the data recovery.

[0091] According to an embodiment of the present invention, when it is necessary to recover data of a data table after an operation, based on the table identifier of the data table, the historical data table corresponding to the table identifier is read based on the data binding mechanism, thereby ensuring the correspondence between the historical data table and the data table, ensuring the correctness of the historical data table used for data recovery, thereby improving the accuracy and efficiency of data recovery.

[0092] Based on the above database management interface operation method, the present invention also provides a database management interface operation device. Figure 4 The device is described in detail.

[0093] Figure 4 A structural block diagram of a database management interface operating device according to an embodiment of the present invention is shown.

[0094] like Figure 4 As shown, the database management interface operating device 400 of this embodiment includes a state determination module 410 , a state switching module 420 , an interface switching module 430 and an interface recovery module 440 .

[0095] The state determination module 410 is used to determine whether the selector in the database management interface is in an activated state in response to the interface switching instruction, wherein the activated state indicates that the focus in the database management interface is located at the position of the selector, and the selector includes a drop-down box. In one embodiment, the state determination module 410 can be used to perform the operation S210 described above, which will not be repeated here.

[0096] The state switching module 420 is used to switch the state of the selector to the inactive state when the selector is in the active state. In one embodiment, the state switching module 420 can be used to perform the operation S220 described above, which will not be described in detail here.

[0097] The interface switching module 430 is used to switch from the database management interface to other interfaces corresponding to the interface switching instruction. In one embodiment, the interface switching module 430 can be used to perform the operation S230 described above, which will not be described in detail here.

[0098] The interface recovery module 440 is used to switch from other interfaces to the database management interface in response to the interface recovery instruction. In one embodiment, the interface recovery module 440 can be used to perform the operation S240 described above, which will not be described in detail here.

[0099] According to an embodiment of the present invention, the state switching module 420 includes a focus switching submodule.

[0100] The focus switching submodule is used to call the selector's defocus method to switch the focus position to a position different from the selector's position.

[0101] According to an embodiment of the present invention, the focus switching submodule includes an information determining unit, a method calling unit and a position switching unit.

[0102] An information determination unit is used to determine the reference information of the selector based on the position of the focus and using the registration information on the interface framework, wherein the interface framework is used to manage the database management interface, the registration information includes a mapping relationship between the position of the selector and the reference information of the selector, the reference information of the selector is used to identify the selector, and the position of the selector is determined using the front-end component positioning technology.

[0103] A method calling unit, used to call the focus-losing method of the selector based on the reference information of the selector.

[0104] The position switching unit is used to switch the focus position to a position different from the selector position by clicking a position other than the selector position in the database management interface using the out-of-focus method.

[0105] According to an embodiment of the present invention, the position switching unit includes a position determining subunit and a position clicking subunit.

[0106] The position determination subunit is used to determine the component positions of other components.

[0107] The position click subunit is used to utilize the click operation script of the document object model to click the component position on the database management interface to switch the focus position to the component position.

[0108] According to an embodiment of the present invention, the database management interface operating device 400 further includes a drop-down box expansion module, an option selection module and an operation execution module.

[0109] The drop-down box expansion module is used to expand the drop-down box in response to the drop-down box expansion instruction.

[0110] The option selection module is used to select a target option from a plurality of alternative options included in the drop-down box in response to an option determination instruction.

[0111] The operation execution module is used to execute the operation corresponding to the target option.

[0112] According to an embodiment of the present invention, the operation execution module includes a data storage submodule and a data table operation module.

[0113] The data saving submodule is used to use the data binding mechanism to store the operation mode corresponding to the target option and the data table currently displayed on the database management interface, and set the state of the drop-down box to the collapsed state.

[0114] The data table operation module is used to operate the data table displayed on the database management interface using the operation method corresponding to the target option.

[0115] According to an embodiment of the present invention, the data table operation module includes a data table deletion submodule, a data determination submodule, a data modification submodule and a data table replacement submodule.

[0116] The data table deletion submodule is used to delete the data table when the operation mode corresponding to the target option is deletion.

[0117] The data determination submodule is used to determine the original data in the data table that needs to be modified based on the data selection instruction when the operation mode corresponding to the target option is modification.

[0118] The data modification submodule is used to modify the original data using the modification data corresponding to the original data to obtain a data table after the operation.

[0119] The data table replacement submodule is used to replace the data table with the replacement data table to obtain the data table after the operation when the operation mode corresponding to the target option is replacement.

[0120] According to an embodiment of the present invention, the database management interface operating device 400 further includes an identification determination module and a data reading module.

[0121] The identifier determination module is used to determine the table identifier of the data table when data recovery is required for the data table after the operation.

[0122] The data reading module is used to read the historical data table corresponding to the table identifier from the data binding mechanism based on the table identifier of the data table.

[0123] According to an embodiment of the present invention, any multiple modules of the state determination module 410, the state switching module 420, the interface switching module 430 and the interface recovery module 440 can be combined into one module for implementation, or any one of the modules can be split into multiple modules. Alternatively, at least part of the functions of one or more of these modules can be combined with at least part of the functions of other modules and implemented in one module. According to an embodiment of the present invention, at least one of the state determination module 410, the state switching module 420, the interface switching module 430 and the interface recovery module 440 can be at least partially implemented as a hardware circuit, such as a field programmable gate array (FPGA), a programmable logic array (PLA), a system on a chip, a system on a substrate, a system on a package, an application specific integrated circuit (ASIC), or can be implemented by hardware or firmware such as any other reasonable way of integrating or packaging the circuit, or implemented in any one of the three implementation methods of software, hardware and firmware or in a suitable combination of any of them. Alternatively, at least one of the state determination module 410, the state switching module 420, the interface switching module 430 and the interface recovery module 440 may be at least partially implemented as a computer program module, and when the computer program module is executed, a corresponding function may be performed.

[0124] Figure 5 A block diagram of an electronic device suitable for implementing a database management interface operation method according to an embodiment of the present invention is shown.

[0125] like Figure 5 As shown, the electronic device 500 according to an embodiment of the present invention includes a processor 501, which can perform various appropriate actions and processes according to a program stored in a read-only memory (ROM) 502 or a program loaded from a storage part 508 to a random access memory (RAM) 503. The processor 501 may include, for example, a general-purpose microprocessor (such as a CPU), an instruction set processor and / or a related chipset and / or a special-purpose microprocessor (for example, an application-specific integrated circuit (ASIC)), etc. The processor 501 may also include an onboard memory for caching purposes. The processor 501 may include a single processing unit or multiple processing units for performing different actions of the method flow according to an embodiment of the present invention.

[0126] In RAM 503, various programs and data required for the operation of electronic device 500 are stored. Processor 501, ROM 502 and RAM 503 are connected to each other via bus 504. Processor 501 performs various operations of the method flow according to the embodiment of the present invention by executing the program in ROM 502 and / or RAM 503. It should be noted that the program can also be stored in one or more memories other than ROM 502 and RAM 503. Processor 501 can also perform various operations of the method flow according to the embodiment of the present invention by executing the program stored in the one or more memories.

[0127] According to an embodiment of the present invention, the electronic device 500 may further include an input / output (I / O) interface 505, which is also connected to the bus 504. The electronic device 500 may further include one or more of the following components connected to the input / output (I / O) interface 505: an input portion 506 including a keyboard, a mouse, etc.; an output portion 507 including a cathode ray tube (CRT), a liquid crystal display (LCD), etc., and a speaker, etc.; a storage portion 508 including a hard disk, etc.; and a communication portion 509 including a network interface card such as a LAN card, a modem, etc. The communication portion 509 performs communication processing via a network such as the Internet. A drive 510 is also connected to the input / output (I / O) interface 505 as needed. A removable medium 511, such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, etc., is installed on the drive 510 as needed, so that the computer program read therefrom is installed into the storage portion 508 as needed.

[0128] The present invention also provides a computer-readable storage medium, which may be included in the device / apparatus / system described in the above embodiment; or may exist independently without being assembled into the device / apparatus / system. The above computer-readable storage medium carries one or more programs, and when the above one or more programs are executed, the method according to the embodiment of the present invention is implemented.

[0129] According to an embodiment of the present invention, the computer-readable storage medium may be a non-volatile computer-readable storage medium, for example, may include but is not limited to: a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination thereof. In the present invention, the computer-readable storage medium may be any tangible medium containing or storing a program, which may be used by or in combination with an instruction execution system, an apparatus or a device. For example, according to an embodiment of the present invention, the computer-readable storage medium may include the ROM 502 and / or RAM 503 described above and / or one or more memories other than ROM 502 and RAM 503.

[0130] The embodiment of the present invention also includes a computer program product, which includes a computer program, and the computer program contains program code for executing the method shown in the flowchart. When the computer program product is run in a computer system, the program code is used to enable the computer system to implement the method provided by the embodiment of the present invention.

[0131] The computer program executes the above functions defined in the system / device of the embodiment of the present invention when it is executed by the processor 501. According to the embodiment of the present invention, the system, device, module, unit, etc. described above can be implemented by a computer program module.

[0132] In one embodiment, the computer program may rely on tangible storage media such as optical storage devices, magnetic storage devices, etc. In another embodiment, the computer program may also be transmitted and distributed in the form of signals on a network medium, and downloaded and installed through the communication part 509, and / or installed from the removable medium 511. The program code contained in the computer program may be transmitted using any appropriate network medium, including but not limited to: wireless, wired, etc., or any suitable combination of the above.

[0133] In such an embodiment, the computer program can be downloaded and installed from the network through the communication part 509, and / or installed from the removable medium 511. When the computer program is executed by the processor 501, the above functions defined in the system of the embodiment of the present invention are performed. According to the embodiment of the present invention, the system, device, means, module, unit, etc. described above can be implemented by a computer program module.

[0134] According to an embodiment of the present invention, the program code for executing the computer program provided by the embodiment of the present invention can be written in any combination of one or more programming languages. Specifically, these computing programs can be implemented using high-level process and / or object-oriented programming languages, and / or assembly / machine languages. Programming languages ​​include, but are not limited to, Java, C++, python, "C" language or similar programming languages. The program code can be executed entirely on the user computing device, partially on the user device, partially on the remote computing device, or entirely on the remote computing device or server. In the case of a remote computing device, the remote computing device can be connected to the user computing device through any type of network, including a local area network (LAN) or a wide area network (WAN), or can be connected to an external computing device (e.g., using an Internet service provider to connect through the Internet).

[0135] The flow chart and block diagram in the accompanying drawings illustrate the possible architecture, function and operation of the system, method and computer program product according to various embodiments of the present invention. In this regard, each box in the flow chart or block diagram can represent a module, a program segment, or a part of a code, and the above-mentioned module, program segment, or a part of a code contains one or more executable instructions for realizing the specified logical function. It should also be noted that in some alternative implementations, the functions marked in the box can also occur in a different order from the order marked in the accompanying drawings. For example, two boxes represented in succession can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each box in the block diagram or flow chart, and the combination of the boxes in the block diagram or flow chart can be implemented with a dedicated hardware-based system that performs a specified function or operation, or can be implemented with a combination of dedicated hardware and computer instructions.

[0136] It will be appreciated by those skilled in the art that the features described in the various embodiments of the present invention may be combined and / or combined in various ways, even if such combinations or combinations are not explicitly described in the present invention. In particular, without departing from the spirit and teachings of the present invention, the features described in the various embodiments of the present invention may be combined and / or combined in various ways. All of these combinations and / or combinations fall within the scope of the present invention.

[0137] The embodiments of the present invention are described above. However, these embodiments are only for the purpose of illustration, and are not intended to limit the scope of the present invention. Although each embodiment is described above, it does not mean that the measures in each embodiment cannot be used in combination advantageously. Without departing from the scope of the present invention, those skilled in the art may make various substitutions and modifications, which should all fall within the scope of the present invention.

Claims

1. A database management interface operation method, characterized in that: The method comprises: In response to the interface switching instruction, determining whether the selector in the database management interface is in an activated state, wherein the activated state indicates that the focus in the database management interface is located at the position of the selector, and the selector includes a drop-down box; When the selector is in an activated state, switching the state of the selector to an inactivated state; Switching from the database management interface to another interface corresponding to the interface switching instruction; In response to an interface recovery instruction, switching from the other interface to the database management interface; Wherein, the current state of the selector in the database management interface is a drop-down box folded state; Switching the state of the selector to an inactive state includes: Calling the defocus method of the selector to switch the focus position to a position different from the position of the selector; The calling of the defocus method of the selector to switch the focus position to a position different from the position of the selector includes: Based on the position of the focus, reference information of the selector is determined by using registration information on an interface framework, wherein the interface framework is used to manage the database management interface, the registration information includes a mapping relationship between the position of the selector and the reference information of the selector, the reference information of the selector is used to identify the selector, and the position of the selector is determined by using a front-end component positioning technology; Calling the defocus method of the selector based on the reference information of the selector; The focus position is switched to a position different from the position of the selector by clicking a position other than the position of the selector in the database management interface using the defocusing method.

2. The method according to claim 1, characterized in that The database management interface includes the selector and other components; The step of switching the focus position to a position different from the position of the selector comprises: determining component positions of the other components; By utilizing the click operation script of the document object model, the component position on the database management interface is clicked to switch the focus position to the component position.

3. The method according to claim 1, characterized in that The method further comprises: In response to a drop-down box expansion instruction, expand the drop-down box; In response to the option determination instruction, selecting a target option from a plurality of alternative options included in the drop-down box; Execute an operation corresponding to the target option; The drop-down box expansion instruction is generated by operating the selector in the database management interface.

4. The method according to claim 3, characterized in that The alternative options include operation modes for the data table displayed on the database management interface, and the operation modes include deletion, modification and replacement; The performing of the operation corresponding to the target option includes: Using a data binding mechanism to store the operation mode corresponding to the target option and the data table currently displayed on the database management interface, and setting the state of the drop-down box to the collapsed state; The data table displayed on the database management interface is operated using the operation method corresponding to the target option.

5. The method according to claim 4, characterized in that The operating method corresponding to the target option is used to operate the data table displayed on the database management interface, including: When the operation mode corresponding to the target option is deletion, deleting the data table; In a case where the operation mode corresponding to the target option is modification, determining the original data to be modified in the data table based on the data selection instruction; Modifying the original data using the modification data corresponding to the original data to obtain a data table after the operation; In the case where the operation mode corresponding to the target option is replacement, the data table is replaced by a replacement data table to obtain the data table after the operation.

6. The method according to claim 5, characterized in that The method further comprises: In the case where data recovery is required for the data table after the operation, determining a table identifier of the data table; Based on the table identifier of the data table, a historical data table corresponding to the table identifier is read from the data binding mechanism.

7. A database management interface operating device, characterized in that: The device comprises: a state determination module, configured to determine, in response to an interface switching instruction, whether a selector in the database management interface is in an activated state, wherein the activated state indicates that the focus in the database management interface is located at the position of the selector, and the selector includes a drop-down box; A state switching module, used for switching the state of the selector to an inactive state when the selector is in an active state; An interface switching module, used to switch from the database management interface to other interfaces corresponding to the interface switching instruction; An interface recovery module, used for switching from the other interfaces to the database management interface in response to an interface recovery instruction; Wherein, the current state of the selector in the database management interface is a drop-down box folded state; The state switching module comprises: A focus switching submodule, used for calling the defocus method of the selector to switch the focus position to a position different from the position of the selector; The focus switching submodule includes: an information switching unit, configured to determine reference information of the selector based on the position of the focus and using registration information on an interface framework, wherein the interface framework is used to manage the database management interface, the registration information includes a mapping relationship between the position of the selector and the reference information of the selector, the reference information of the selector is used to identify the selector, and the position of the selector is determined using a front-end component positioning technology; A method calling unit, used for calling the focus loss method of the selector based on the reference information of the selector; A position switching unit is used to use the defocusing method to click a position other than the position of the selector in the database management interface to switch the focus position to a position different from the position of the selector.

8. An electronic device comprising: one or more processors; a memory for storing one or more computer programs, It is characterized in that the one or more processors execute the one or more computer programs to implement the steps of the method according to any one of claims 1 to 6.

Images