WO2017088702A1 - Editing method and device for database editor - Google Patents

Abstract

Disclosed are an editing method and device for a database editor. The method comprises: upon monitoring editing of a database content by a database editor, determining an editing location, wherein the editing location is a location in the database content where a content item is currently being edited; acquiring property information associated with the editing location by analyzing the database content currently being edited by the database editor; determining, according to the property information, whether a content matching the editing location exists; and if so, outputting a prompt information. The invention solves a technical problem in which when related techniques employ database editors to edit database contents, a lack of analysis of content inputted by users results in imprecise completion content prompted when performing auto completion on the content inputted by the users.

Description

Database editor editing method and device

The present application claims priority to Chinese Patent Application Serial No. No. No. No. No. No. No. No. No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No No

Technical field

The present invention relates to the field of databases, and in particular to a method and apparatus for editing a database editor.

Background technique

With the development of information technology and market, data management is no longer a simple data storage and data management, but a way of transforming into various data management that users need. In order to meet the needs of users, the database (Datebase) technology came into being. The database is a warehouse that organizes, stores and manages data according to the data structure. In the process of managing the data in the database, the user needs to use the database editor to edit the contents of the database. Common database editors are SQL, Access, Oracle, and so on.

In order to improve the efficiency of users editing database content, many database editors provide users with automatic completion of keywords (such as select, codemirror, ace, etc.), when the user uses the database editor to edit the database content, according to the user input content Ability to ambiguously query tables and fields in the database. However, the database editor in the related art automatically completes the keyword with the following defects:

1. The completion of the database editor prompt is not accurate. The database editor pre-defines all the keywords on the network side. When the user inputs a character, the character is matched with a predefined keyword to obtain the completion content of the character. Since various keywords may appear anywhere in the database, and the content input by the user is not parsed between the character matches, the database editor will prompt the user to fill in the content automatically input. The entire content is not accurate.

2. When the database editor performs automatic completion, all the tables and fields are cached locally. When the data volume of the database exceeds a certain amount, the network page will hang.

When the database content is edited by using the database editor in the related art, since the content input by the user is not parsed, the content of the completion of the prompting when the content input by the user is automatically completed is not accurate, and no effective solution has been proposed yet. Program.

Summary of the invention

The embodiment of the invention provides a method and a device for editing a database editor, so as to at least solve the problem that when the database editor is used to edit the database content in the related art, the content input by the user is automatically analyzed because the content input by the user is not analyzed. The technical content of the incomplete content of the completion of the prompt is complete.

According to an aspect of an embodiment of the present invention, an editing method of a database editor is provided, including: when listening to editing a database content in a database editor, determining an editing location, wherein the editing location is currently being edited The location of the content in the database content; obtaining the attribute information associated with the editing location by parsing the database content currently edited in the database editor; determining whether there is content matching the editing location according to the attribute information; determining presence and editing In the case of a content that matches the position, a prompt message is output.

According to another aspect of the present invention, an editing apparatus for a database editor is further provided, including: a first determining module, configured to determine an editing position when listening to editing the database content in the database editor, The editing location is the location of the content currently being edited in the database content; the parsing module is configured to obtain the attribute information associated with the editing location by parsing the database content currently edited in the database editor; the second determining module, And configured to determine, according to the attribute information, whether there is content that matches the edit position; and an output module, configured to output the prompt information if it is determined that the content that matches the edit position exists.

In the embodiment of the present invention, when the database content is edited in the database editor, the edit position is determined, wherein the edit position is the position of the content currently being edited in the database content; by parsing the current database editor The edited database content, obtaining attribute information associated with the edit position; determining whether there is content matching the edit position according to the attribute information; and outputting the prompt information when determining that there is content matching the edit position, By parsing the database content edited in the database editor, the attribute information matching the editing position is obtained, and the content matching the editing position is completed in the editing position according to the attribute information, so that the user is prompted when using the database editor on the network side. The purpose of auto-filling the content matching the editing position is completed, thereby realizing the technical effect of quickly and accurately complementing the database content matching the editing position when editing the database content in the database editor, thereby solving the use in the related art. Database editor When the contents of the database, not due to user input parsing, leading to user input of technical problems the whole content imprecise prompted automatically fill full-time complement.

DRAWINGS

The drawings described herein are intended to provide a further understanding of the invention, and are intended to be a part of the invention. In the drawing:

1 is a hardware structural block of a computer terminal for editing a database editor according to an embodiment of the present invention; Figure

2 is a flow chart of a method of editing a database editor in accordance with an embodiment of the present invention;

3 is a schematic diagram of an implementation architecture of an editing method of a database editor according to an embodiment of the present invention;

4 is a flow chart of an alternative method of editing a database editor in accordance with an embodiment of the present invention;

5 is a flow chart of another alternative method of editing a database editor in accordance with an embodiment of the present invention;

6 is a flow chart of another alternative method of editing a database editor in accordance with an embodiment of the present invention;

7 is a flow chart of another alternative method of editing a database editor in accordance with an embodiment of the present invention;

8 is a flow chart of another alternative method of editing a database editor in accordance with an embodiment of the present invention;

9 is a flow chart of a preferred method of editing a database editor, in accordance with an embodiment of the present invention;

FIG. 10 is a schematic diagram of an editing apparatus of a database editor according to an embodiment of the present invention; FIG.

11 is a schematic diagram of an editing apparatus of an optional database editor, in accordance with an embodiment of the present invention;

12 is a schematic diagram of another optional editing device of a database editor in accordance with an embodiment of the present invention;

13 is a schematic diagram of another optional editing device of a database editor in accordance with an embodiment of the present invention;

14 is a schematic diagram of another optional editing device of a database editor in accordance with an embodiment of the present invention;

15 is a schematic diagram of another optional editing device of a database editor in accordance with an embodiment of the present invention;

16 is a schematic diagram of another optional editing device of a database editor, in accordance with an embodiment of the present invention;

FIG. 17 is a structural block diagram of a computer terminal according to an embodiment of the present invention.

detailed description

The technical solutions in the embodiments of the present invention are clearly and completely described in the following with reference to the accompanying drawings in the embodiments of the present invention. It is an embodiment of the invention, but not all of the embodiments. All other embodiments obtained by those skilled in the art based on the embodiments of the present invention without creative efforts shall fall within the scope of the present invention.

It is to be understood that the terms "first", "second" and the like in the specification and claims of the present invention are used to distinguish similar objects, and are not necessarily used to describe a particular order or order. It is to be understood that the data so used may be interchanged where appropriate, so that the embodiments of the invention described herein can be implemented in a sequence other than those illustrated or described herein. In addition, the terms "comprises" and "comprises" and "the" and "the" are intended to cover a non-exclusive inclusion, for example, a process, method, system, product, or device that comprises a series of steps or units is not necessarily limited to Those steps or units, but may include those that are not clearly listed or Other steps or units inherent to these processes, methods, products or equipment.

First, some of the nouns or terms that appear in the process of describing the embodiments of the present invention are applicable to the following explanations:

A database is a collection of data that is stored together in a certain way, can be shared by multiple users, has as little redundancy as possible, and is independent of the application.

Database editor, a tool for editing database content in a database.

Edit the location as the location of the content currently being edited in the database content.

Example 1

According to an embodiment of the present invention, there is also provided a method embodiment of a method for editing a database editor, and it should be noted that the steps shown in the flowchart of the drawing may be in a computer system such as a set of computer executable instructions. The steps shown and described may be performed in a different order than the ones described herein, although the logical order is shown in the flowchart.

The method embodiment provided in Embodiment 1 of the present application can be executed in a mobile terminal, a computer terminal or the like. Taking a computer terminal as an example, FIG. 1 is a hardware structural block diagram of a computer terminal for editing a database editor according to an embodiment of the present invention. As shown in FIG. 1, computer terminal 10 may include one or more (only one shown) processor 102 (processor 102 may include, but is not limited to, a processing device such as a microprocessor MCU or a programmable logic device FPGA) A memory 104 for storing data, and a transmission device 106 for communication functions. It will be understood by those skilled in the art that the structure shown in FIG. 1 is merely illustrative and does not limit the structure of the above electronic device. For example, computer terminal 10 may also include more or fewer components than those shown in FIG. 1, or have a different configuration than that shown in FIG.

The memory 104 can be used to store software programs and modules of application software, such as program instructions/modules corresponding to the editing method of the database editor in the embodiment of the present invention, and the processor 102 runs the software programs and modules stored in the memory 104, thereby Perform various function applications and data processing, that is, implement the editing method of the above database editor. 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, memory 104 may further include memory remotely located relative to processor 102, which may be coupled to computer terminal 10 via a network. Examples of such networks include, but are not limited to, the Internet, intranets, local area networks, mobile communication networks, and combinations thereof.

Transmission device 106 is for receiving or transmitting data via a network. The network specific examples described above may include a wireless network provided by a communication provider of the computer terminal 10. In one example, the transmission device 106 includes a Network Interface Controller (NIC) that can be connected to other network devices through the base station. Communicate with the Internet. In one example, the transmission device 106 can be a Radio Frequency (RF) module for communicating with the Internet wirelessly.

In the above operating environment, the present application provides an editing method of the database editor as shown in FIG. 2. 2 is a flow chart of a method of editing a database editor in accordance with an embodiment of the present invention.

As shown in FIG. 2, the editing method of the database editor of this embodiment may include the following steps:

In step S12, when the database content is edited in the database editor, the editing position is determined, wherein the editing position is the position of the content currently being edited in the database content.

In the technical solution provided in step S12, at least one table may be included in the database, and each data table may include at least one column, and each column may include at least one field, wherein each table or each column corresponds to a unique one. Identifier. For example, Table 1 is the data table X1 in the database. As shown in Table 1, the X1 table includes two columns A and B, wherein the A column includes Aciton, Actor, and the B column includes Black, Baby. In the actual scenario, the number of tables and columns in the database is large, and different tables and columns are distinguished by different identifiers, so that the effect of quickly and accurately finding the data in the desired table or column from the database can be achieved.

Table 1 data table X1 in the database

	A	B
1	Action	Black
2	Actor	Baby

The database editor can be a tool for editing the contents of the database in the database, such as SQL, Access, Oracle, and so on. Users can edit the database contents in the database by using the database editor on the network side to manage the data in the database. Database content that users can edit using the database editor can include keywords (such as selcet, from, where, etc.), tables, columns, and so on. On the network side, the user can edit the database content anywhere in the database content, and the user's edit position to the database content can be the location of the content currently being edited by the user in the database content. Similar to the Word editor, the editing location can be the location of the cursor in the editing interface, or the location of other icons used for marking. Preferably, the embodiment determines the position where the blinking cursor is located in the editing interface as the editing position of the current user, and is highlighted in the editing interface in the form of a blinking cursor, which can facilitate the user to quickly and accurately locate the editing position, thereby improving user editing efficiency. Optionally, the embodiment can also use a keyboard or a mouse to change the editing position, so that the user can conveniently edit the database content at any position, which greatly improves the user's editing efficiency of the database content.

In an actual application scenario, the embodiment can design an event listener based on any database editor, that is, adding a layer of event listener on top of the database editor, and using the event listener to monitor whether the user is editing in the database. The contents of the database are edited. When the user is being edited in the database editor, the event listener can also read the location of the cursor, thereby determining the editing position of the current user when editing the database content. And triggering subsequent actions to parse the database content edited by the user.

In step S14, the attribute information associated with the editing position is obtained by parsing the database content currently edited in the database editor.

In the technical solution provided in step S14, when listening to the user editing the database content, the embodiment intercepts the database content edited by the user at the current editing position, and parses the intercepted database content. Optionally, the user-edited database content may be a character or a character string input by the user, and the database content edited by the user may be located in front of the editing position or may be located behind the editing position. For example, the editing position in the editing interface is the position where the blinking cursor is located. In this embodiment, when the user-edited database content is intercepted, the character or character string in front of the blinking cursor is preferably intercepted.

This embodiment parses the database content currently edited in the database editor, and may include parsing the database content edited by the user and which type the database content belongs to, such as tables, columns, and keywords. Taking the SQL editor as an example, in an actual application scenario, the embodiment may set a SQL parser for parsing the SQL content edited by the user at the edit position in the SQL editor, and determine which type of SQL content the user edits belongs to. This embodiment can obtain the attribute information associated with the edit position by parsing the database content currently edited in the database editor, wherein the attribute information associated with the edit position can include the database content edited by the user at the edit position. And the type of database content that the user edits. That is, the attribute information associated with the edit location in this embodiment may be the database content edited by the user at the edit location and the type of the database content.

In this embodiment, the database content edited in the database editor is parsed, the attribute information associated with the edited position is obtained, and the database content edited by the user is complemented according to the attribute information associated with the edited position obtained after the parsing, It can improve the accuracy of complementing the database content edited by the user at the editing position, thereby achieving the effect of improving the user experience.

In step S16, it is determined according to the attribute information whether there is content matching the editing position.

In the solution provided in step S16, the embodiment pre-stores various tables and fields for compiling the user-edited database content in the source database, and only caches some of the more frequently used database contents in the local cache. For example, use more frequent keywords. This is beneficial to alleviate the burden on the network, and can avoid the problem that the network page will hang when the amount of data in the local cache is large, thereby achieving the effect of improving the user experience.

Optionally, when determining, according to the attribute information, whether there is content that matches the edit location, the embodiment may first search, from the local cache, whether there is content that matches the type of the database edited by the user, such as If there is no content in the local cache that matches the content of the database edited by the user, the source database is asynchronously requested, and the content of the source database is matched with the content of the database edited by the user. If there is content in the local cache or the source database that matches the content of the database edited by the user, step S18 is performed. If there is no type and content in the local cache and the source database, the content of the database is matched with the content edited by the user. The content ends the completion of the user-edited database content, and continues to listen to whether the user edits the database content in the database editor.

In an actual application scenario, the embodiment may set a data cache component in a database editor, the data cache component may be used to cache some fixed keywords, and may also be used to request data from a source database in the background, and will be from the source. The data requested in the database is double buffered.

The embodiment uses the combination of the local cache and the source database to store the database content for compiling the user edit, and first determines whether there is content matching the edit position according to the attribute information associated with the edit location, first from the local cache. Find, when you can't find the content that matches the edit location, look it up from the source database. By obtaining the content matching the editing position through the above-mentioned asynchronous request, it is possible to ensure automatic completion of the table and the field in the case of a large amount of data, thereby achieving the effect of optimizing network performance and improving user editing efficiency.

In step S18, in the case where it is determined that there is content matching the editing position, the prompt information is output.

In the solution provided in step S18, when it is determined that there is content in the local cache or the source database that matches the edit position, the embodiment outputs prompt information, wherein the output prompt information is mainly used to prompt the user to complete the edit position. Database content. Optionally, the content matching the editing position may be one or more, and when the content matching the editing position is plural, the embodiment may be displayed one by one in the form of a list. Users can use the mouse or keyboard to select the database content they need in the display list to automatically complete the database content in the editing position. In this embodiment, the database content of the editing location is complemented by displaying the prompt information for the user to select, which is beneficial to ensure the accuracy of the completed database content, and at the same time increase the user selection function, thereby increasing the interaction function with the user and improving the user's use. The effect of the experience.

Optionally, the embodiment may further fill the content matching the editing position directly in the editing position, and the manner may be applicable to the obtained scene that has only one content matching the editing position. By directly filling the content matching the editing position to the editing position, the length of time for the user to edit the database content can be shortened, and the efficiency of the user to edit the database content can be improved.

In an actual application scenario, the embodiment may set an automatic prompt component in the database editor, and the automatic prompt component may be used to display the matched data on the database editor, when the user selects a certain one from the displayed data. The data content of the input is automatically completed in the database editor after the data.

FIG. 3 is a schematic diagram of an implementation architecture of an editing method of a database editor according to an embodiment of the present invention. As shown in FIG. 3, the implementation architecture 300 may include:

The event listener 32, which can be implemented based on any database editor, adds a layer of event listener on top of the database editor, can be used to listen to the database content edited by the user at the edit position, and is used to trigger subsequent user pairs. The edited database content is parsed.

The parser 34, when the database editor is a SQL editor, the parser 34 is a SQL parser, which can be used to parse the database content edited by the user at the editing location, and determine which type of database content the editing location belongs to.

The data cache component 36 can be used to cache some fixed keywords in the local cache, and can also be used to asynchronously request data from the source database in the background through the network, and the requested data is secondarily cached in the local cache.

The automatic prompt component 38 can be used to display data matching the editing position on the database editor, and the user automatically selects the database content edited by the user in the database editor after selecting the required database content.

In the implementation architecture shown in FIG. 3, by step S12 to step S18, the embodiment parses the database content edited by the user at the edit position, and searches from the local cache or the source database according to the attribute information of the edited edit position obtained by the parsing. The database content matching the editing position can solve the related content in the related art when the database editor is used to edit the database content, because the content input by the user is not parsed, and the content of the prompt is completed when the content input by the user is automatically completed. Inaccurate technical problems, in order to edit the database content in the database editor, quickly and accurately complete the database content matching the editing location, and reduce the network burden when the amount of data is large, to ensure that the web page will not hang Technical effect.

As an alternative embodiment, FIG. 4 is a flowchart of an optional editing method of the database editor according to an embodiment of the present invention. As shown in FIG. 4, step S14 is currently edited in the database editor by parsing. The database content, obtaining the attribute information associated with the editing location may include the following steps:

Step S142, intercepting the database statement to be analyzed in the database content according to the editing position.

In the solution provided in step S142, the edit position is the position determined by step S12, and the database statement to be analyzed may be from the edit position to the first database statement end character, and the first database after the edit position The statement contained in the statement end character. The end character of the database statement is different according to the database editor. For example, the end character of the database statement in the SQL editor is a semicolon ";", that is, the statement between the two semicolons where the edit position is located is to be analyzed. Database statement.

Step S144, determining a field type of each field included in the database statement according to a predefined type attribute. Among them, the field types include: tables, columns, and keywords.

In the scenario provided in step S144, the predefined type attributes may include tables, columns, and keywords. The database statement can include at least one field, and the field types of each field can be the same or different. After obtaining the database statement to be analyzed, the embodiment analyzes the field type of each field in the database statement according to the predefined type attribute, wherein the field type of each field may be a table, a column or a keyword. This embodiment analyzes the field type of each field in the database statement in order to accurately analyze the field type of the field at the editing position to achieve the purpose of accurately complementing the database content at the editing location.

Step S146, determining the field type of the field located in the edit position in the database statement according to the field type of each field.

In the solution provided in step S146, the edit position may be located at a position where any one of the database statements is located, and the embodiment preferably determines the first field before the edit position as the field of the edit position, the determination manner and Word. The characters at the cursor position in the editor are determined in the same way. The field attribute of each field in the database statement can be determined by step S162, and when the field located at the edit position is determined, the field type can be determined.

Step S148, generating attribute information associated with the edit position according to the field type and the field content of the field located at the edit position.

In the scenario provided in step S148, the attribute information associated with the edit location may be the field content and field type of the field at the edit location. Specifically, the field content of the field of the edit position can be obtained by intercepting the database statement to be analyzed according to the edit position in step S142, and the field of the field of the edit position can be acquired through step S144 and step S146.

Optionally, after the attribute information associated with the edit position is generated in step S148, the embodiment may store the attribute information associated with the edit position, so that when the user edits the database content for the edit position again, The attribute information associated with the editing position that has been stored before can be quickly called, and the editing efficiency of the user's database content can be improved.

Through the above steps S142 and S148, by parsing the database content currently edited in the database editor, the attribute information associated with the edit position can be accurately acquired, so as to accurately complement and edit the edit information according to the attribute information. The location matches the database content.

As an optional embodiment, step S12 of the embodiment determines that the edit position can be the edit position by reading the cursor position displayed in the database content by the cursor, wherein the field content at the edit position is a character located before the cursor position or String. This embodiment determines the position of the edit position and the edit position by reading the position of the cursor. The content of the paragraph is convenient and simple, and is more in line with the user's editing habits.

As an alternative embodiment, FIG. 5 is a flowchart of another optional editing method of the database editor according to an embodiment of the present invention. As shown in FIG. 5, step S16 determines whether presence and editing are performed according to the attribute information. Before the location matches the content, the editing method of the database editor of this embodiment may further include the following steps:

In step S15, it is determined whether the field type of the field located at the editing position is a keyword.

This embodiment predefines keywords used by the database editor, such as selcet, from, with, and the like. The field type of the field at the edit position can be obtained by step S146 of this embodiment. If the field type of the field located at the editing position is a keyword, the process returns to step S12 to continue to listen to whether the database editor edits the database content; if the field type of the field located at the editing position is not a keyword, the process proceeds to step S16. A step of determining whether there is content matching the edit position based on the attribute information is performed.

The prior art has been able to automatically perform the completion of the keywords in the database editor, so this embodiment only for the case where the field type of the field located at the editing position is not a keyword, how to automatically complete the database at the editing position Content, such as tables and fields. Due to the large amount of data of tables and fields, this embodiment provides an accurate automatic completion scheme for tables and fields, which can achieve the effect of alleviating network pressure and optimizing network page performance.

As an alternative embodiment, FIG. 6 is a flowchart of another optional editing method of the database editor according to an embodiment of the present invention. As shown in FIG. 6, step S16 determines whether presence and editing are performed according to the attribute information. The content that matches the location can include the following steps:

Step S162, querying from the local cache according to the attribute information whether there is content matching the edit position. If the query is successful in the local cache, step S18 is executed to generate and output the prompt information; if the query fails in the local cache, step S164 is performed.

Step S164, asynchronously sending the query request to the source database, and querying from the source database whether there is content matching the edited location. If the query is successful, step S18 is executed to generate and output prompt information; if the query fails, the current event is ended, wherein the query request may include attribute information associated with the edit position, and the attribute information may include a field located at the edit position. Field type and field content.

In this embodiment, some partially used database contents are stored in the local cache in advance, and tables and fields having a large amount of data are stored in the source database in the background. In the solution provided in step S162 and step S164, the embodiment first queries from the local cache whether there is content matching the edit position, and if there is no content matching the edit position in the local cache, the source is redirected to the source. The database asynchronously sends a query request, and queries the source database for content that matches the edit location. The above method can ensure the automatic completion of the table and the field in the case of a large amount of data, without causing the problem that the network page hangs, thereby achieving the performance of optimizing the network page and improving The effect of the user experience.

As an alternative embodiment, FIG. 7 is a flowchart of another optional editing method of the database editor according to an embodiment of the present invention. As shown in FIG. 7, step S162 queries the local cache according to the attribute information. Whether there is content matching the editing location can include the following steps:

Step S1622: Query whether there is content in the local cache that is the same as the field type and the content of the field. If the query fails, step S1624 is performed; if the query is successful, step S18 is performed.

The content matching the editing position in this embodiment is the same database content as the field content and field type of the editing location. Querying from the local cache whether there is content matching the edit location includes querying from the local cache whether there is database content that is the same as the field content and field type of the edit location. The embodiment considers the field content and the field type of the editing position when querying the database content matching the editing position, which can improve the accuracy of the query result, and can automatically improve the accuracy of the database content at the editing position, thereby improving The effect of the user experience.

In step S1624, it is determined whether the field type is a table field or a column field. If the field type is a table field or a column field, the process proceeds to step S164 to perform a step of asynchronously sending a query request to the source database; if the field type is not a table field or a column field, the event is ended.

In the solution provided in step S1624, a keyword is stored in the local cache. When there is no database content in the local cache that has the same field type as the edit location, indicating that the field type of the edit location is not a keyword, the edit location needs to be further determined. Whether the field type is a table field or a column field. If it is determined that it is a table field or a column field, since the table and the field are stored in the source database in the background, the embodiment will asynchronously send the query request to the source database, and query from the source database whether there is content matching the edit position. If it is judged that it is not a table field or a column field, it indicates that the field type of the key position does not belong to the database content that can be automatically completed, and the completion operation is directly ended.

This embodiment can improve the accuracy of automatically completing the database content of the edit position by accurately parsing the field type and the field content of the edit position. At the same time, when querying the database content matching the editing location from the local cache or the source database, by querying the database content with the same field type and field content, the accuracy of complementing the database content of the editing location can be further improved. Moreover, the real-time asynchronous request method can ensure that the webpage does not hang when the amount of data is large, and the performance of the webpage is optimized, and the user experience is improved.

As an optional embodiment, outputting the prompt information in step S18 may include: displaying the prompt information in a database editor, and/or populating the prompt information to an edit position, wherein the prompt information may include: Matching content. This embodiment provides two different completion modes for the user, and the user can adjust according to actual needs. The use of automatic filling saves user operations and improves user editing efficiency of database content. By displaying the user's own choice, the database content required by the user can be accurately determined, the complementation precision of the database content is improved, the interaction with the user is increased, and the user experience is improved.

As an alternative embodiment, FIG. 8 is a flowchart of another optional editing method of the database editor according to an embodiment of the present invention. As shown in FIG. 8, after determining the editing position in step S12, the implementation is performed. The editing method of the database editor of the example may further include the following steps:

In step S13, the content before or after the editing position is scanned in the database content.

If the content before or after the edit position includes a comment character or a comment string, the current event is ended; if the content before or after the edit position includes the database statement end character, the process proceeds to step S14 to parse the database content.

In the scheme provided in step S13, the comment character or the comment string is used to indicate that the database statement is a statement for interpretability and does not belong to a valid database statement. The database editor does nothing with database statements that add comment characters or comment strings. The comment character or comment string may be located between the labels "//*" and "*//", and the comment character or comment string may be a Chinese character, an identifier for interpretation, or the like. Valid database statements are statements that do not contain comment characters or comment strings and that contain the end of the database statement. For example, the SQL statement in the SQL editor is a statement between two semicolons ";", where the semicolon ";" is the end of the database statement in the SQL editor.

By determining whether the database statement before or after the editing position is a valid database statement, the embodiment can ensure the validity of the database statement to be analyzed at the intercepted editing position, thereby improving the parsed attribute associated with the editing position. The accuracy of the information, the precise positioning needs to complete the database content, and improve the effect of the user's use of the feed.

A preferred embodiment of the present application is described in detail below in conjunction with FIG. 9 is a flow chart of a preferred method of editing a database editor, as shown in FIG. 9, including the following steps, in accordance with an embodiment of the present invention:

In step S21, the user inputs the content in the database editor. The database editor in this preferred embodiment can be SQL, Access, Oracle, and the like. The user can use the database editor to edit the database content at any location to manage the data in the database. The user can edit the location of the database content to the location of the content currently being edited by the user in the database content. The contents of the database that the user can edit using the database editor may include keywords (such as select, from, where, etc.), tables, columns, and the like.

In step S22, the input event is monitored. The preferred embodiment can set event monitoring in the database editor Listener for listening to user input in the database editor. When the event listener listens to the user entering content in the database editor, the event listener triggers the action of parsing the user's input.

In step S23, the input content is parsed. When the user listens to the user to edit the database content, the preferred embodiment intercepts the database content edited by the user at the current editing position and parses the intercepted database content. The preferred embodiment parses the user's input content, ie, the database content currently edited in the database editor, and may include parsing the database content edited by the user and which type of database content, such as tables, columns, and keywords. The preferred embodiment can set a parser for parsing the content edited by the user at the edit location in the database editor and determining which type of database content the user edits belongs to. This embodiment can obtain the attribute information associated with the edit position by parsing the database content currently edited in the database editor, wherein the attribute information associated with the edit position can include the database content edited by the user at the edit position. And the type of database content that the user edits.

Specifically, the step S23 parsing the input content may include steps S231 to S234, where:

Step S231, intercepting the database statement to be analyzed according to the editing position. The database statement to be analyzed in the preferred embodiment may be from the edit position to the first database statement end character, and the statement contained in the first database statement end character after the edit position. The end of the database statement varies according to the database editor. For example, the end of the database statement in the SQL editor is a semicolon ";".

Step S232, determining a field type of each field in the database statement according to a predefined type attribute. The predefined type attributes in the preferred embodiment may include tables, columns, and keywords. The database statement can include at least one field, and the field types of each field can be the same or different. This embodiment analyzes the field type of each field in the database statement in order to accurately analyze the field type of the field at the editing position to achieve the purpose of accurately complementing the database content at the editing location.

Step S233, obtaining a field type of a field located at the editing position. The preferred embodiment may determine the first field before the edit location as the field of the edit location. After determining the field properties of each field in the database statement and determining the field at the edit location, the field type of the field at the edit location can be determined.

Step S234, generating attribute information associated with the edit position according to the field type and the field content of the field located at the edit position. The attribute information associated with the edit location in the preferred embodiment may be the field content and field type of the field at the edit location.

Through the above steps S231 and S234, by parsing the database content currently edited in the database editor, the attribute information associated with the edit position can be accurately acquired, so as to accurately complement and edit the edit information according to the attribute information. The location matches the database content.

In step S24, it is edited whether the field type of the location is a keyword. The preferred embodiment is pre-defined with keywords used by the database editor, such as select, from, with, and the like. If the field type of the edit location is a keyword, return to step 22 to continue listening for the input event; if the field type of the edit location is not a keyword, step S25 is performed.

In step S25, the database content matching the editing location is queried. The preferred embodiment pre-stores various tables and fields for compiling the user-edited database content in the source database, and only caches some of the more frequently used database contents in the local cache, such as using more frequent keywords. . When determining whether there is content matching the editing location according to the attribute information, it may first search for the content that matches the type of the database edited by the user, and if there is no type and content in the local cache. If the content edited by the user matches the contents of the database, the source database is asynchronously requested, and the content of the source database is matched with the content of the database edited by the user. The preferred embodiment can also set a data cache component in the database editor, which can be used to cache some fixed keywords, and can also be used to request data from the source database in the background, and will request from the source database. The data is buffered twice. By obtaining the content matching the editing position through the above-mentioned asynchronous request, it is possible to ensure automatic completion of the table and the field in the case of a large amount of data, thereby achieving the effect of optimizing network performance and improving user editing efficiency.

Specifically, step S25 may include steps S251 to S256, where:

Step S251, receiving the field type and the field content of the field located at the editing position. The content matching the editing position in the preferred embodiment is the same database content as the field content and field type of the editing location. The field type and field content of the field at the edit position can be obtained by step S231 and step S234 in the preferred embodiment.

Step S252, determining whether there is content in the local cache that is the same as the field type and the field content. If not, step S253 is performed; if yes, step S254 is performed. Querying from the local cache whether there is content matching the edit location includes querying from the local cache whether there is database content that is the same as the field content and field type of the edit location. The embodiment considers the field content and the field type of the editing position when querying the database content matching the editing position, so that the accuracy of the query result can be improved, and the accuracy of the database content at the editing position can be automatically completed.

Step S253, determining whether the field type is a table field or a column field. If yes, step S255 is performed; if not, step S256 is performed. A keyword is stored in the local cache. When there is no database content in the local cache that has the same field type as the edit location, indicating that the field type of the edit location is not a keyword, it is necessary to further determine whether the field type of the edit location is a table field or Column field. If it is determined that it is a table field or a column field, since the table and the field are stored in the source database in the background, the preferred embodiment will asynchronously send the query request to the source. Database, from the source database to query whether there is content matching the editing location. If it is judged that it is not a table field or a column field, it indicates that the field type of the key position does not belong to the database content that can be automatically completed, and the completion operation is directly ended.

In step S254, prompt information is generated.

In step S255, the query request is sent asynchronously to the source database. The source database is queried whether there is content matching the editing location. If the query is successful, the output prompt information is generated; if the query fails, the current event is ended, wherein the query request may include attribute information associated with the editing location.

In step S256, the event is ended.

Through the above steps S251 and S256, the preferred embodiment first queries the local cache whether there is content matching the edit position, and if there is no content matching the edit position in the local cache, then the source database is asynchronous. Send a query request to query the source database for content that matches the edit location. The preferred embodiment can ensure the automatic completion of the table and the field in the case of a large amount of data, without causing the problem that the network page hangs, thereby achieving the effect of optimizing the performance of the web page and improving the user experience.

In step S26, the prompt information is output. The output prompt information is mainly used to prompt the user to complete the database content in the edit position. The preferred embodiment can be displayed one by one in the form of a list. Users can use the mouse or keyboard to select the database content they need in the display list to automatically complete the database content in the editing position, which is beneficial to ensure the accuracy of the completed database content, and at the same time increase the user selection function. Increase the interaction with the user and improve the user experience. Optionally, the preferred embodiment may further fill the content matching the editing position directly in the editing position, and by directly filling the content matching the editing position to the editing position, the length of time for the user to edit the database content can be shortened, and the user is improved. The efficiency of editing database content.

Through the above steps S21 to S26, the preferred embodiment parses the database content edited by the user at the edit position, and searches for the database matching the edited location from the local cache or the source database according to the attribute information of the edited edit position. The content can solve the technical problem that when the database editor is used to edit the database content in the related art, the content input by the user is not parsed, and the content of the completion of the prompt is not accurate when the content input by the user is automatically completed, thereby realizing When editing the database content in the database editor, it quickly and accurately completes the database content that matches the editing location, and slows down the network burden when the amount of data is large, so as to ensure that the web page does not have the technical effect of hanging.

It should be noted that, for the foregoing method embodiments, for the sake of simple description, they are all expressed as a series of action combinations, but those skilled in the art should understand that the present invention is not limited by the described action sequence. Because certain steps may be performed in other sequences or concurrently in accordance with the present invention. Second, the person skilled in the art also It should be understood that the embodiments described in the specification are a preferred embodiment and that the acts and modules involved are not necessarily essential to the invention.

Through the description of the above embodiments, those skilled in the art can clearly understand that the editing method of the database editor according to the above embodiment can be implemented by means of software plus a necessary general hardware platform, and of course, can also be through hardware, but In many cases the former is a better implementation. Based on such understanding, the technical solution of the present invention, which is essential or contributes to the prior art, may be embodied in the form of a software product stored in a storage medium (such as ROM/RAM, disk, The optical disc includes a number of instructions for causing a terminal device (which may be a cell phone, a computer, a server, or a network device, etc.) to perform the methods described in various embodiments of the present invention.

Example 2

According to an embodiment of the present invention, there is also provided an editing apparatus for a database editor for implementing the editing method of the database editor described above. FIG. 10 is a schematic diagram of an editing apparatus of a database editor according to an embodiment of the present invention. As shown in FIG. 10, the apparatus includes:

The first determining module 22 is configured to determine an editing location when the database content is edited in the database editor, wherein the editing location is a location of the content currently being edited in the database content; the parsing module 24 is configured to: Obtaining the attribute information associated with the editing location by parsing the database content currently edited in the database editor; the second determining module 26 is configured to determine, according to the attribute information, whether there is content that matches the editing location; the output module 28 uses In the case where it is determined that there is content matching the editing position, the prompt information is output.

It should be noted that the first determining module 22 in this embodiment may be used to perform step S12 in the first embodiment of the present application. The parsing module 24 in this embodiment may be used to perform step S14 in the first embodiment of the present application. The second determining module 26 in this embodiment may be used to perform step S16 in the first embodiment of the present application. The output module 28 in the embodiment may be used to perform step S18 in the first embodiment of the present application.

It should be noted that the first determining module 22, the parsing module 24, the second determining module 26, and the output module 28 correspond to steps S12 to S18 in the first embodiment, and the modules and corresponding steps are implemented. It is the same as the application scenario, but is not limited to the content disclosed in the above embodiment. It should be noted that the foregoing module may be implemented in the computer terminal 10 provided in the embodiment as a part of the device, and may be implemented by software or by hardware.

As an alternative embodiment, FIG. 11 is a schematic diagram of an optional editing device of a database editor according to an embodiment of the present invention. As shown in FIG. 11, the parsing module 24 may include: an intercepting module 242, configured to: The database statement to be analyzed in the database content is intercepted according to the editing position; the first sub-determination module 244 is configured to follow the predefined The type attribute determines a field type of each field included in the database statement, wherein the field type includes: a table, a column, and a keyword; and a second sub-determination module 246 is configured to determine that the database statement is located according to the field type of each field Editing the field type of the field of the location; the generating module 248 is configured to generate attribute information associated with the editing location according to the field type and the field content of the field located at the editing location.

It should be noted that the foregoing intercepting module 242, the first sub-determining module 244, the second sub-determining module 246, and the generating module 248 respectively correspond to step S142 to step S148 in the first embodiment, and the foregoing modules and corresponding steps are implemented. The examples and application scenarios are the same, but are not limited to the contents disclosed in the above embodiments. It should be noted that the foregoing module may be implemented in the computer terminal 10 provided in the embodiment as a part of the device, and may be implemented by software or by hardware.

As an optional embodiment, the editing apparatus of the database editor of the embodiment may further include: a reading module, configured to read a cursor position displayed by the cursor in the database content as an editing position, where the editing position is located The field content is a character or string that precedes the cursor position.

As an alternative embodiment, FIG. 12 is a schematic diagram of another optional editing device of a database editor according to an embodiment of the present invention. As shown in FIG. 12, the editing device of the database editor of the embodiment further The first determining module 25 is configured to determine whether the field type of the field located at the editing position is a keyword, and if the field type of the field located in the editing position is a keyword, return to the first determining module 22 to continue. Whether the database editor is listening to whether the database content is edited; if the field type of the field located at the edit position is not a keyword, the entry second determination module 26 performs a step of determining whether there is content matching the edit position based on the attribute information.

It should be noted that the first judging module 25 corresponds to the step S15 in the first embodiment, and the module is the same as the example and the application scenario implemented in step S15, but is not limited to the content disclosed in the foregoing embodiment. It should be noted that the foregoing module may be implemented in the computer terminal 10 provided in the embodiment as a part of the device, and may be implemented by software or by hardware.

As an alternative embodiment, FIG. 13 is a schematic diagram of another optional editing device of the database editor according to an embodiment of the present invention. As shown in FIG. 13, the second determining module 26 may include: a query module 262. And for querying, from the local cache, whether there is content matching the edit location according to the attribute information, wherein when the query in the local cache succeeds, the input output module 28 generates prompt information; and the request module 264 is configured to cache locally. When the query fails, the query request is sent asynchronously to the source database, and the source database is queried whether there is content matching the edit position. If the query is successful, the output module 28 is generated to generate the prompt information. If the query fails, the current information is ended. An event in which the query request includes attribute information.

It should be noted that the query module 262 and the request module 264 correspond to the step S162 and the step S164 in the first embodiment. The foregoing modules are the same as the examples and application scenarios implemented by the corresponding steps, but are not limited to the contents disclosed in the foregoing embodiments. . It should be noted that the foregoing module may be implemented in the computer terminal 10 provided in the embodiment as a part of the device, and may be implemented by software or by hardware.

As an alternative embodiment, FIG. 14 is a schematic diagram of another optional editing device of a database editor according to an embodiment of the present invention. As shown in FIG. 14, the query module 262 may include: a first sub-query module. 2622, configured to query whether there is content in the local cache that is the same as the field type and the field content; the second determining module 2624 is configured to determine, in the case that the query fails, whether the field type is a table field or a column field, where the field is When the type is a table field or a column field, the entry request module 264 performs the step of asynchronously sending a query request to the source database; when the field type is not a table field or a column field, the event is ended. The attribute information includes: the field type and the field content of the field at the editing position.

It should be noted that the first sub-query module 2622 and the second judging module 2624 correspond to step S1622 and step S1624 in the first embodiment. The foregoing modules are the same as the examples and application scenarios implemented by the corresponding steps, but are not limited to the foregoing implementation. The content disclosed in the example. It should be noted that the foregoing module may be implemented in the computer terminal 10 provided in the embodiment as a part of the device, and may be implemented by software or by hardware.

As an alternative embodiment, FIG. 15 is a schematic diagram of another optional editing device of a database editor according to an embodiment of the present invention. As shown in FIG. 15, the output module 28 includes: a display module 282 for The prompt information is displayed in the database editor; and/or the filling module 284 is configured to fill the prompt information to the editing location, wherein the prompt information includes: content that matches the editing location.

As an alternative embodiment, FIG. 16 is a schematic diagram of another optional editing device of a database editor according to an embodiment of the present invention. As shown in FIG. 16, the editing device of the database editor of the embodiment further The method may include: a scanning module 23, configured to scan content in the database content before or after the editing position, wherein the content is ended when the content before or after the editing position includes a comment character or a comment string; When the content before or after the editing position includes the database statement end character, the parsing module 24 proceeds to perform the step of parsing the database content.

It should be noted that the scanning module 23 corresponds to the step S13 in the first embodiment, and the module is the same as the example and the application scenario implemented in step S13, but is not limited to the content disclosed in the foregoing embodiment. It should be noted that the foregoing module may be implemented in the computer terminal 10 provided in the embodiment as a part of the device, and may be implemented by software or by hardware.

The editing device of the database editor of the embodiment parses the database content edited by the user at the editing position through the modules 22 to 28, and searches and edits the location from the local cache or the source database according to the attribute information of the edited edit position. The matching database content can solve the related art in the use of the database editor to edit the database content, because the user input content is not parsed, resulting in the completion of the user input content when the completion of the prompt is not accurate Technical problems, in turn, when editing the database content in the database editor, quickly and accurately complete the database content that matches the editing location, and slow down the network burden when the amount of data is large, so as to ensure that the network page does not hang the technical effect .

Example 3

Embodiments of the present invention may provide a computer terminal, which may be any one of computer terminal groups. Optionally, in this embodiment, the foregoing computer terminal may also be replaced with a terminal device such as a mobile terminal.

Optionally, in this embodiment, the computer terminal may be located in at least one network device of the plurality of network devices of the computer network.

In this embodiment, the computer terminal may execute the program code of the following steps in the editing method of the database editor: when listening to the editing of the database content in the database editor, determining the editing position, wherein the editing position is currently being The location of the edited content in the database content; by parsing the database content currently edited in the database editor, obtaining the attribute information associated with the edit location; determining whether there is content matching the edit location based on the attribute information; In the case of content that matches the edit position, the prompt information is output.

Optionally, FIG. 17 is a structural block diagram of a computer terminal according to an embodiment of the present invention. As shown in FIG. 17, the computer terminal A may include one or more (only one shown in the figure) processor 1702, memory 1704, and transmission device 1706.

The memory 1704 can be used to store software programs and modules, such as the editing method of the database editor and the program instructions/modules corresponding to the device in the embodiment of the present invention. The processor 1702 runs the software programs and modules stored in the memory 1704. Thereby performing various functional applications and data processing, that is, implementing the above-described editing method of the database editor. Memory 1704 can include high speed random access memory 1704, and can also include non-volatile memory 1704, such as one or more magnetic storage devices, flash memory, or other non-volatile solid state memory 1704. In some examples, memory 1704 can further include a memory 1704 remotely disposed relative to processor 1702, which can be connected to terminal A via 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 processor 1702 can invoke the information and application stored by the memory 1704 through the transmission device 1706 to perform the following steps: when listening to the editing of the database content in the database editor, determining the editing location, wherein the editing location is currently being The location of the edited content in the database content; by parsing the database content currently edited in the database editor, obtaining the attribute information associated with the edit location; determining whether there is content matching the edit location based on the attribute information; In the case of content that matches the edit position, the prompt information is output.

Optionally, the processor 1702 may further execute the following steps: intercepting a database statement to be analyzed in the database content according to the edit location; determining a field type of each field included in the database statement according to the predefined type attribute, where The field types include: table, column, and keyword; according to the field type of each field, determine the field type of the field in the database statement at the editing position; generate and edit the position according to the field type and field content of the field at the editing position Associated attribute information.

Optionally, the processor 1702 may further execute the following program code: reading a cursor position displayed by the cursor in the database content as an edit position, wherein the field content at the edit position is a character or a string located before the cursor position. .

Optionally, the processor 1702 may further execute the following program code: determining whether a field type of a field located at an edit position is a keyword; and returning to continue monitoring if a field type of the field at the edit position is a keyword Whether the database editor edits the database content; if the field type of the field located at the editing position is not a keyword, the step of performing execution of determining whether there is content matching the editing position based on the attribute information is entered.

Optionally, the processor 1702 may further execute the following steps: querying, according to the attribute information, whether the content in the local cache matches the edited location; if the query is successful in the local cache, generating the prompt information; If the query fails in the local cache, the query request is sent to the source database asynchronously. The source database queries whether there is content matching the edit location. If the query succeeds, the prompt information is generated. If the query fails, the event ends. The request includes attribute information.

Optionally, the processor 1702 may further execute the following program code: query whether the local cache has the same content as the field type and the field content; if the query fails, determine whether the field type is a table field or a column field. If the field type is a table field or a column field, enter the step of performing an asynchronous send query request to the source database; if the field type is not a table field or a column field, the event ends.

Optionally, the processor 1702 may further execute the following program code: display the prompt information in the database editor, and/or fill the prompt information to the edit location, where the prompt information includes: matching the edit position Matching content.

Optionally, the processor 1702 may further execute the following program code: scan content in the database content before or after the editing position; if the content before or after the editing position includes a comment character or a comment string, end This event; if the content before or after the edit position includes the database statement end character, the step of parsing the database content is entered.

An embodiment of the present invention provides a method for editing a database editor and a device. By parsing the database content edited in the database editor, the attribute information matching the editing position is obtained, and the content matching the editing position is completed in the editing position according to the attribute information, so that the user is prompted when using the database editor on the network side. The purpose of auto-filling the content matching the editing position is completed, thereby realizing the technical effect of quickly and accurately complementing the database content matching the editing position when editing the database content in the database editor, thereby solving the use in the related art. When the database editor edits the contents of the database, since the content input by the user is not parsed, the technical content of the completion content of the prompt when the content input by the user is automatically completed is inaccurate.

A person skilled in the art can understand that the structure shown in FIG. 17 is only an illustration, and the computer terminal can also be a smart phone (such as an Android mobile phone, an iOS mobile phone, etc.), a tablet computer, an applause computer, and a mobile Internet device (MID). Terminal equipment such as PAD. Fig. 17 does not limit the structure of the above electronic device. For example, computer terminal A may also include more or fewer components (such as a network interface, display device, etc.) than shown in FIG. 17, or have a different configuration than that shown in FIG.

A person of ordinary skill in the art may understand that all or part of the steps of the foregoing embodiments may be completed by a program to instruct terminal device related hardware, and the program may be stored in a computer readable storage medium, and the storage medium may be Including: flash disk, read-only memory (ROM), random access memory (RAM), disk or optical disk.

Example 4

Embodiments of the present invention also provide a storage medium. Optionally, in the embodiment, the foregoing storage medium may be used to save the program code executed by the editing method of the database editor provided in the first embodiment.

Optionally, in this embodiment, the foregoing storage medium may be located in any one of the computer terminal groups in the computer network, or in any one of the mobile terminal groups.

Optionally, in the embodiment, the storage medium is configured to store program code for performing the following steps: when listening to editing the database content in the database editor, determining an edit position, wherein the edit position is current The location of the content being edited in the database content; by parsing the database content currently edited in the database editor, obtaining the attribute information associated with the edit location; determining whether there is an edit location based on the attribute information Matching content; in the case where it is determined that there is content matching the editing position, the prompt information is output.

Optionally, in this embodiment, the storage medium may be further configured to store program code for performing the following steps: intercepting the database statement to be analyzed in the database content according to the edit location; determining the database statement according to the predefined type attribute The field type of each field included, where the field type includes: table, column, and keyword; according to the field type of each field, determine the field type of the field in the database statement at the edit position; according to the field located at the edit position Field type and field content, generating attribute information associated with the edit location.

Optionally, in this embodiment, the storage medium may be further configured to store program code for performing the following steps: reading a cursor position displayed by the cursor in the database content as an edit position, wherein the field content at the edit position Is the character or string that precedes the cursor position.

Optionally, in this embodiment, the storage medium may be further configured to store program code for performing the following steps: determining whether the field type of the field located at the editing position is a keyword; and the field type of the field at the editing position In the case of a keyword, the return continues to listen to whether the database editor edits the database content; if the field type of the field at the edit position is not a keyword, the entry execution determines whether there is a match with the edit position according to the attribute information. The steps of the content.

Optionally, in this embodiment, the storage medium may be further configured to store program code for performing the following steps: querying from the local cache according to the attribute information whether there is content matching the edit position; if in the local cache If the query succeeds, the prompt information is generated. If the query fails in the local cache, the query request is sent asynchronously to the source database, and the source database is used to query whether there is content matching the edit position. If the query succeeds, the prompt information is generated, and if the query fails, , the end of the event, where the query request includes attribute information.

Optionally, in this embodiment, the storage medium may be further configured to store program code for performing the following steps: querying whether there is content in the local cache that is the same as the field type and the field content; in the case that the query fails, Determine whether the field type is a table field or a column field; if the field type is a table field or a column field, enter a step of performing an asynchronous send query request to the source database; if the field type is not a table field or a column field, the event ends.

Optionally, in this embodiment, the storage medium may be further configured to store program code for performing the following steps: displaying the prompt information in a database editor, and/or populating the prompt information to an editing location, where The prompt information includes: content that matches the edit location.

Optionally, in this embodiment, the storage medium may be further configured to store program code for performing scanning of content before or after the editing location in the database content; if the content is before or after the editing location Ends this event, including comment characters or comment strings; if it is before or after the edit position The content includes the end of the database statement, then enter the step of parsing the contents of the database.

It should be noted here that any one of the above computer terminal groups can establish a communication relationship with the website server and the scanner, and the scanner can scan the value command of the web application executed by php on the computer terminal.

The serial numbers of the embodiments of the present invention are merely for the description, and do not represent the advantages and disadvantages of the embodiments.

In the above-mentioned embodiments of the present invention, the descriptions of the various embodiments are different, and the parts that are not detailed in a certain embodiment can be referred to the related descriptions of other embodiments.

In the several embodiments provided by the present application, it should be understood that the disclosed technical contents may be implemented in other manners. The device embodiments described above are merely illustrative. For example, the division of the unit is only a logical function division. In actual implementation, there may be another division manner. For example, multiple units or components may be combined or may be Integrate into another system, or some features can be ignored or not executed. In addition, the mutual coupling or direct coupling or communication connection shown or discussed may be an indirect coupling or communication connection through some interface, unit or module, and may be electrical or otherwise.

The units described as separate components may or may not be physically separated, and the components displayed as units may or may not be physical units, that is, may be located in one place, or may be distributed to multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of the embodiment.

In addition, each functional unit in each embodiment of the present invention may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit. The above integrated unit can be implemented in the form of hardware or in the form of a software functional unit.

The integrated unit, if implemented in the form of a software functional unit and sold or used as a standalone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention, which is essential or contributes to the prior art, or all or part of the technical solution, may be embodied in the form of a software product stored in a storage medium. A number of instructions are included to cause a computer device (which may be a personal computer, server or network device, etc.) to perform all or part of the steps of the methods described in various embodiments of the present invention. The foregoing storage medium includes: a U disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a removable hard disk, a magnetic disk, or an optical disk, and the like. .

The above description is only a preferred embodiment of the present invention, and it should be noted that those skilled in the art can also make several improvements and retouchings without departing from the principles of the present invention. It should be considered as the scope of protection of the present invention.

Claims (16)

1. A method for editing a database editor, comprising:

   Determining an editing location when listening to editing the database content in the database editor, wherein the editing location is a location of the content currently being edited in the database content;

   Obtaining attribute information associated with the edit location by parsing the database content currently edited in the database editor;

   Determining, according to the attribute information, whether there is content that matches the edit location;

   In the case where it is determined that there is content matching the edit position, the prompt information is output.
2. The method according to claim 1, wherein the obtaining the attribute information associated with the editing location by parsing the database content currently edited in the database editor comprises:

   Obtaining, in the edit position, a database statement to be analyzed in the database content;

   Determining, according to a predefined type attribute, a field type of each field included in the database statement, wherein the field type includes: a table, a column, and a keyword;

   Determining, according to the field type of each field, a field type of a field in the database statement located at the edit position;

   Attribute information associated with the edit location is generated based on the field type and field content of the field located at the edit location.
3. The method according to claim 2, wherein a cursor position displayed in the database content is read as the editing position, wherein the field content located at the editing position is located at the cursor position. The previous character or string.
4. The method according to claim 2, wherein before determining whether there is content matching the edit position according to the attribute information, the method further comprises:

   Determining whether a field type of a field located at the edit location is the keyword;

   In case the field type of the field located in the editing position is the keyword, returning to continue listening to whether the database editor edits the database content;

   In the case where the field type of the field located at the editing position is not the keyword, a step of performing determination based on the attribute information as to whether or not there is content matching the editing position is entered.
5. The method according to any one of claims 1 to 4, wherein determining whether there is content matching the editing position according to the attribute information comprises:

   Querying, according to the attribute information, whether there is content matching the editing location from the local cache;

   Generating the prompt information if the query is successful in the local cache;

   If the query fails in the local cache, the query request is sent to the source database asynchronously, and the source database is used to query whether there is content matching the edit position. If the query is successful, the prompt information is generated, if the failure occurs. And ending the event, wherein the query request includes the attribute information.
6. The method according to claim 5, wherein the attribute information comprises: the field type and the field content of the field located in the edit position, wherein the presence or absence of the query is performed from the local cache according to the attribute information. The content matching the editing position includes:

   Querying whether there is content in the local cache that is the same as the field type and the content of the field;

   In the case that the query fails, it is determined whether the field type is a table field or a column field;

   If the field type is the table field or the column field, enter a step of executing the asynchronous sending query request to a source database;

   If the field type is not the table field or the column field, the event is ended.
7. The method according to claim 6, wherein outputting the prompt information comprises: displaying the prompt information in the database editor, and/or filling the prompt information to the edit position, wherein The prompt information includes: content that matches the edit position.
8. The method of claim 1, wherein after determining the edit position, the method further comprises:

   Scanning content in the database content before or after the editing location;

   Ending the event if the content before or after the edit position includes a comment character or a comment string;

   If the content before or after the edit position includes a database statement end character, the step of parsing the database content is entered.
9. An editing device for a database editor, comprising:

   a first determining module, configured to determine an editing location when the database content is edited in the database editor, wherein the editing location is a location of the content currently being edited in the database content;

   a parsing module, configured to obtain attribute information associated with the edit location by parsing the database content currently edited in the database editor;

   a second determining module, configured to determine, according to the attribute information, whether there is content that matches the edited location;

   And an output module, configured to output the prompt information if it is determined that there is content matching the edit position.
10. The apparatus according to claim 9, wherein the parsing module comprises:

    An intercepting module, configured to intercept, according to the edit location, a database statement to be analyzed in the database content;

    a first sub-determination module, configured to determine, according to a predefined type attribute, a field type of each field included in the database statement, where the field type includes: a table, a column, and a keyword;

    a second sub-determination module, configured to determine, according to a field type of each field, a field type of a field in the edited position in the database statement;

    And a generating module, configured to generate attribute information associated with the edit location according to the field type and field content of the field located in the edit location.
11. The device according to claim 10, further comprising: a reading module, configured to read a cursor position displayed by the cursor in the database content as the editing position, wherein the editing is located in the editing The field content of the location is a character or string that precedes the cursor position.
12. The device according to claim 10, wherein the device further comprises:

    a first determining module, configured to determine whether a field type of a field located at the editing location is the keyword;

    Wherein, in a case that the field type of the field located at the editing position is the keyword, the first determining module is returned to continue to listen to whether the database editor edits the database content, and is located in the editing. In a case where the field type of the field of the location is not the keyword, the step of entering the second determining module performs determining whether there is content matching the editing location according to the attribute information.
13. The apparatus according to any one of claims 9 to 12, wherein the second determining module comprises:

    a query module, configured to query, according to the attribute information, whether there is content that matches the edit location, where the query is returned to the output module to generate the prompt information;

    a requesting module, configured to asynchronously send a query request to a source database when the query fails in the local cache, and query, from the source database, whether there is content that matches the edit location, and if the query is successful, return the The output module executes to generate the prompt information, and if the query fails, ends the current event, wherein the query request includes the attribute information.
14. The device according to claim 13, wherein the attribute information comprises: the field type and the field content of the field located in the editing position, wherein the query module comprises:

    a first sub-query module, configured to query, in the local cache, whether the content of the field type and the content of the field is the same;

    a second determining module, configured to determine, when the query fails, whether the field type is a table field or a column field, where the request is entered when the field type is the table field or the column field The module performs the step of asynchronously sending a query request to the source database, and ends the event when the field type is not the table field or the column field.
15. The apparatus according to claim 14, wherein said output module comprises:

    a presentation module for displaying the prompt information in the database editor; and/or

    And a filling module, configured to fill the prompt information to the editing location, where the prompt information includes: content that matches the editing location.
16. The device according to claim 9, wherein the device further comprises:

    a scanning module, configured to scan content in the database content before or after the editing position,

    Wherein, when the content before or after the editing position includes a comment character or a comment character string, the current event is ended, and when the content before or after the editing position includes the database statement end character, the parsing module is entered. The step of parsing the contents of the database.

Images