WO2021169300A1

WO2021169300A1 - Method and apparatus for exporting database table structure, and terminal device

Info

Publication number: WO2021169300A1
Application number: PCT/CN2020/119294
Authority: WO
Inventors: 耿相国
Original assignee: 平安科技（深圳）有限公司
Priority date: 2020-02-28
Filing date: 2020-09-30
Publication date: 2021-09-02
Also published as: CN111352986A

Abstract

A method and apparatus for exporting a database table structure, and a terminal device, which are applicable to the technical field of computers. The method comprises: acquiring database information of a target database, wherein the database information comprises: address information, a database user name and a database password (S201); after the database password and the database user name pass verification, reading a database table to be exported, a database table annotation, a database table field and a database table field annotation according to the address information (S202); and exporting the database table and the database table annotation according to a preset format and generating a directory worksheet, and exporting the database table field and the database table field annotation according to a preset format and generating a database table worksheet (S203). By means of the method, a worksheet of a database table is generated, and when there are a plurality of tables in a database, it is convenient to simultaneously export the tables for viewing and maintenance.

Description

Method, device and terminal equipment for exporting database table structure

This application requires a Chinese patent application filed at the Patent Office of the State Intellectual Property Office of the People’s Republic of China on February 28, 2020, with an application number of 202010131024.6, and the title of the invention "a method, device and terminal device for deriving a database table structure" The priority of, the entire content of which is incorporated in this application by reference.

Technical field

This application belongs to the field of big data, and in particular relates to a method, device and terminal equipment for deriving a database table structure.

Background technique

During project development, databases are often used. One database will include multiple tables, that is, database tables for recording project development; during project development, certain functions of the development project will be added or modified, and the corresponding database will also be added Many tables may need to modify the table structure; before the database is generated, the document of the table structure corresponding to the database is not improved or updated in time, which causes a lot of inconvenience to the later development and maintenance. Therefore, it is necessary to export the database table structure from the database in order to Modify or maintain later.

The inventor realized that the traditional database table structure export tool requires additional application for installation. The installation tool takes up more hard disk space and also takes up a certain amount of memory when running. Moreover, the exported document is a document in a specified format and needs to be activated. The tool program can only be opened, and users who have not installed the tool cannot view it. There are many inconveniences in the use process.

technical problem

One of the objectives of the embodiments of the present application is to provide a method, device, and terminal device for deriving a database table structure, which can solve many inconvenience problems in the use of traditional database table structure derivation tools.

Technical solutions

In order to solve the above technical problems, the technical solutions adopted in the embodiments of this application are:

In the first aspect, an embodiment of the present application provides a method for deriving a database table structure, including:

Acquiring database information of the target database, the database information including: address information, database user name, and database password;

After the database password and the database user name are verified, read the database table to be exported, the database table comment, the database table field, and the database table field comment according to the address information;

Exporting the database table and database table comments in a preset format and generating a catalog worksheet; exporting the database table fields and database table field comments in a preset format and generating the database table worksheet;

Wherein, the generated catalog work table and the database work table are located in the same table file under a preset path, and the database table comments in the catalog work table correspond to the database table work table.

In the above method, by obtaining the database tables that need to be exported, the catalog worksheet is generated, the fields of the database table are read, and the database table worksheet is generated. The database table comments in the catalog worksheet correspond to the database table worksheet and are located in the same table file , When there are multiple tables in the database, it is convenient to export, view and maintain at the same time, and has strong ease of use and practicality.

In the second aspect, an embodiment of the present application provides an apparatus for exporting a database table, including:

The obtaining module is used to obtain database information of the target database, the database information includes: address information, database user name, and database password;

A reading module, configured to read the database table to be exported, database table comments, database table fields, and database table field comments according to the address information after the database password and the database user name are verified;

The execution module is used to export the database table and database table comments in a preset format and generate a catalog worksheet; export the database table fields and database table field comments in the preset format and generate a database table worksheet; wherein , The generated catalog work table and the database work table are located in the same table file under a preset path, and the database table comments in the catalog work table correspond to the database table work table.

In the third aspect, an embodiment of the present application provides a terminal device, including a memory, a processor, and a computer program stored in the memory and running on the processor. When the processor executes the computer program, Implement the described method.

In a fourth aspect, an embodiment of the present application provides a computer-readable storage medium that stores a computer program that implements the method when the computer program is executed by a processor.

In a fifth aspect, the embodiments of the present application provide a computer program product, which when the computer program product runs on a terminal device, causes the terminal device to execute the method for exporting a database table described in any one of the above-mentioned first aspects.

It is understandable that, for the beneficial effects of the second aspect to the fifth aspect described above, reference may be made to the relevant description in the first aspect described above, and details are not repeated here.

Beneficial effect

Compared with the prior art, the embodiment of the application has the following beneficial effects: by obtaining the database tables that need to be exported, generating the catalog worksheet, reading the fields of the database table, generating the database table worksheet, the database table comments in the catalog worksheet and the database The table worksheets correspond to each other and are located in the same table file. When there are multiple tables in the database, it is convenient to export, view and maintain at the same time, and has strong ease of use and practicability.

Description of the drawings

In order to more clearly describe the technical solutions in the embodiments of the present application, the following will briefly introduce the accompanying drawings that need to be used in the embodiments or exemplary technical descriptions. Obviously, the accompanying drawings in the following description are only of the present application. For some embodiments, those of ordinary skill in the art can obtain other drawings based on these drawings without creative work.

Fig. 1 is a schematic diagram of a system provided by an embodiment of the present application;

2 is a schematic flowchart of a method for exporting a database table provided by an embodiment of the present application;

FIG. 3 is a schematic diagram of an interface for exporting a database table provided by an embodiment of the present application;

4 is a schematic diagram of an interface of a database table structure provided by an embodiment of the present application;

FIG. 5 is a schematic diagram of an interface for exporting a data table file provided by an embodiment of the present application;

Figure 6(a) is a schematic diagram of an interface for exporting a data table file provided by another embodiment of the present application;

Figure 6(b) is a schematic diagram of an interface for exporting a data table file provided by another embodiment of the present application;

FIG. 7 is a schematic structural diagram of an apparatus for deriving a database table provided by an embodiment of the present application;

Fig. 8 is a schematic structural diagram of a terminal device provided by an embodiment of the present application.

Embodiments of the present invention

In the following description, for the purpose of illustration rather than limitation, specific details such as a specific system structure and technology are proposed for a thorough understanding of the embodiments of the present application. However, it should be clear to those skilled in the art that the present application can also be implemented in other embodiments without these specific details. In other cases, detailed descriptions of well-known systems, devices, circuits, and methods are omitted to avoid unnecessary details from obstructing the description of this application.

It should be understood that when used in the specification and appended claims of this application, the term "comprising" indicates the existence of the described features, wholes, steps, operations, elements and/or components, but does not exclude one or more other The existence or addition of features, wholes, steps, operations, elements, components, and/or collections thereof.

It should also be understood that the term "and/or" used in the specification and appended claims of this application refers to any combination of one or more of the associated listed items and all possible combinations, and includes these combinations.

As used in the description of this application and the appended claims, the term "if" can be construed as "when" or "once" or "in response to determination" or "in response to detecting ". Similarly, the phrase "if determined" or "if detected [described condition or event]" can be interpreted as meaning "once determined" or "in response to determination" or "once detected [described condition or event]" depending on the context ]" or "in response to detection of [condition or event described]".

In addition, in the description of the specification of this application and the appended claims, the terms "first", "second", "third", etc. are only used to distinguish the description, and cannot be understood as indicating or implying relative importance.

Reference to "one embodiment" or "some embodiments" described in the specification of this application means that one or more embodiments of this application include a specific feature, structure, or characteristic described in combination with the embodiment. Therefore, the sentences "in one embodiment", "in some embodiments", "in some other embodiments", "in some other embodiments", etc. appearing in different places in this specification are not necessarily All refer to the same embodiment, but mean "one or more but not all embodiments" unless it is specifically emphasized otherwise. The terms "including", "including", "having" and their variations all mean "including but not limited to", unless otherwise specifically emphasized.

The method for exporting database tables provided in the embodiments of this application can be applied to tablet computers, notebook computers, and ultra-mobile personal computers (ultra-mobile personal computers). personal computer, UMPC), netbooks, personal digital assistants (personal On terminal devices such as digital assistants, PDAs, etc., the embodiments of this application do not impose any restrictions on the specific types of terminal devices.

FIG. 1 shows a block diagram of a part of the structure of a terminal device provided in an embodiment of the present application. 1, the terminal device includes: a memory 110, an input unit 120, a display unit 130, wireless fidelity (wireless fidelity (WiFi) module 140, processor 150, power supply 160 and other components. Those skilled in the art can understand that the structure of the terminal device shown in FIG. 1 does not constitute a limitation on the terminal device, and may include more or less components than shown in the figure, or a combination of certain components, or different component arrangements. .

The following describes the components of the terminal device in detail with reference to Figure 1:

The memory 110 may be used to store software programs and modules. The processor 150 executes various functional applications and data processing of the terminal device by running the software programs and modules stored in the memory 110. The memory 110 may mainly include a program storage area and a data storage area. The program storage area may store an operating system, an application program required by at least one function (such as a sound playback function, an image playback function, etc.), etc.; Data created by the use of terminal equipment (such as audio data, phone book, etc.), etc. In addition, the memory 110 may include a high-speed random access memory, and may also include a non-volatile memory, such as at least one magnetic disk storage device, a flash memory device, or other volatile solid-state storage devices.

The input unit 120 may be used to receive inputted number or character information, and generate key signal input related to user settings and function control of the terminal device. Specifically, the input unit 120 may include a touch panel 121 and other input devices 122. The touch panel 121, also called a touch screen, can collect the user's touch operations on or near it (for example, the user uses any suitable objects or accessories such as fingers, stylus, etc.) on the touch panel 121 or near the touch panel 121. Operation), and drive the corresponding connection device according to the preset program. Optionally, the touch panel 121 may include two parts: a touch detection device and a touch controller. Among them, the touch detection device detects the user's touch position, detects the signal brought by the touch operation, and transmits the signal to the touch controller; the touch controller receives the touch information from the touch detection device, converts it into contact coordinates, and then sends it To the processor 150, and can receive and execute the commands sent by the processor 150. In addition, the touch panel 121 can be implemented in multiple types such as resistive, capacitive, infrared, and surface acoustic wave. In addition to the touch panel 121, the input unit 120 may also include other input devices 122. Specifically, the other input device 122 may include, but is not limited to, one or more of a physical keyboard, function keys (such as volume control buttons, switch buttons, etc.), trackball, mouse, and joystick.

The display unit 130 may be used to display information input by the user or information provided to the user and various menus of the terminal device. The display unit 130 may include a display panel 131. Optionally, a liquid crystal display (Liquid Crystal Display, LCD), Organic Light Emitting Diode (Organic The display panel 131 is configured in the form of Light-Emitting Diode, OLED). Further, the touch panel 121 can cover the display panel 131. When the touch panel 121 detects a touch operation on or near it, it transmits it to the processor 150 to determine the type of the touch event, and then the processor 150 responds to the touch event. The type provides corresponding visual output on the display panel 131. Although in FIG. 1, the touch panel 121 and the display panel 131 are used as two independent components to implement the input and input functions of the terminal device, in some embodiments, the touch panel 121 and the display panel 131 may be integrated And realize the input and output functions of terminal equipment.

WiFi is a short-distance wireless transmission technology. Through the WiFi module 140, terminal devices can help users send and receive emails, browse web pages, and access streaming media. It provides users with wireless broadband Internet access. Although FIG. 1 shows the WiFi module 140, it is understandable that it is not a necessary component of the terminal device, and can be omitted as needed without changing the essence of the invention.

The processor 150 is the control center of the terminal device. It uses various interfaces and lines to connect the various parts of the entire terminal device, runs or executes software programs and/or modules stored in the memory 110, and calls data stored in the memory 110 , Perform various functions of the terminal equipment and process data, so as to monitor the terminal equipment as a whole. Optionally, the processor 150 may include one or more processing units; preferably, the processor 150 may integrate an application processor and a modem processor, where the application processor mainly processes the operating system, user interface, application programs, etc. , The modem processor mainly deals with wireless communication. It can be understood that the foregoing modem processor may not be integrated into the processor 150.

The terminal device also includes a power supply 160 (such as a battery) for supplying power to various components. Preferably, the power supply may be logically connected to the processor 150 through a power management system, so that functions such as charging, discharging, and power management are realized through the power management system.

The following embodiments can be implemented on a terminal device having the above hardware structure. The following embodiment will take a terminal device as an example to describe the method for deriving a database table provided in the embodiment of the present application.

As shown in FIG. 2, the method for exporting a database table provided by the embodiment of the present application includes:

Step S201: Obtain database information of the target database, where the database information includes address information, database user name, and database password.

In this embodiment, the type of the target database is a relational database Oracle, and the relational database stores data in the form of rows and columns to form a database table. A database can include multiple database tables. In the target database, all database tables are displayed and stored in the form of the corresponding relationship between the database table name, database table type, and database table comment; for each database table, each database table The corresponding relationship between the fields contained in the table and the data table to which it belongs is displayed and stored.

Specifically, as shown in Figure 3, a schematic diagram of an interface for exporting a database table provided by an embodiment of the present application; an input box for the database address, database user name, and database password is set on the database table exporting interface, and the terminal device receives the user input through the input unit The database information entered in the database table export interface includes: database address, database user name, and database password. Among them, the database address includes the protocol name, sub-protocol name, IP address, port, and database instance name of the database; the database user name is the name of the user who has the authority to back up the database and operate the specified fields; the database password is used for verification The reliability of the operating user's identity ensures that the security of the database is not leaked; the database user name and database password are used for identity confirmation.

In a possible implementation, as shown in Figure 3, the database table export interface is also provided with input boxes for the export path and export file name; exporting the database table also includes the determination of the export path and the export file name. The database export interface is provided with an input box area for the export path and the export file name, which can receive the relevant information that the user inputs the export path and the export file name through the input unit of the terminal device. Among them, the export path can be set to the default path, which is automatically generated before each export. For example, it can be the desktop of the terminal device being operated by default, or the specified path can be optionally set as needed; the export file name can be based on the current export Time node or receiving user input specific file name to confirm the name.

In a possible implementation manner, obtaining database information of the target database includes:

Obtain a filter condition of the target database, where the filter condition includes the database table comment to be exported; read the database table comment to be exported according to the filter condition.

In one embodiment, the database table is displayed and stored in the database in a form corresponding to the database table name, database field, and database field comment; when the database table is exported, the filter condition for the database table export can be set as needed. As shown in Figure 3, the filter condition is that before exporting the database table, the terminal device receives the data table name or database table field that needs to be exported entered by the user on the database table export interface; specifically, filtering can be given in the filter condition input box area The input template of the condition, the user can fill in or modify the filter condition according to the input template; when exporting multiple times, the input filter condition can be stored in a preset time period, which can be selected by the user within the preset time period. There is no need to edit the database table again when it is exported multiple times, which saves data export time and makes the database table export operation more convenient.

It should be noted that the filter condition can be a statement for the database table that needs to be exported in the target database, or it can be a filter for the database table in the target database that does not need to be exported; the filter condition can include multiple databases that need to be exported Table or multiple database tables that do not need to be exported, you can set the export statement of the filter conditions according to your needs.

Step S202: After the database password and the database user name are verified, read the database table to be exported, the database table comment, the database table field, and the database table field comment according to the address information.

In one embodiment, the obtained database password and database user name are authenticated to ensure the security of the database and the reliability of the identity of the user accessing the target data. In the target database, the database tables are stored in the form of columns, that is, the table names of all database tables are a column, the table comments corresponding to the table names are a column, the table fields are a column, and the table field comments corresponding to the table fields are a column. Store display. According to the export instruction, the terminal device reads relevant information of the database table to be exported, including: database table, database table comment, database table field, and database table field comment.

Among them, the database table list in the target database includes the table names of all database tables and corresponding table comments; it can also include the database table type corresponding to the table name of each database table and the comments corresponding to the database table; it can also include Multiple field names and field comments corresponding to the table name of the database table.

In one embodiment, as shown in FIG. 4, an interface schematic diagram of the database table structure provided by an embodiment of the present application, the target database includes the table name of the database table, such as ACCT, ACCTPERSON; Field names, such as PLANTYP, YNKC, YNPOS, YNCGQR, YNCGSH corresponding to ACCT, the field annotation corresponding to each field name "estimate method", "does the store use inventory", "is it connected to the fast food system", "is it necessary "Purchase Confirmation", "Whether Procurement Review Is Required", etc.

Specifically, after reading the table name of the database table, the corresponding table comment, multiple field names and field comments corresponding to the table name of the database table, the read data is grouped according to the table name of the database table, for example, The ACCT database table and its corresponding fields PLANTYP, YNKC, YNPOS, YNCGQR, YNCGSH are a group, and the ACCTPERSON database table and its corresponding fields CARDID, VNAME, VTELE, VSIGN are a group.

In one embodiment, reading the database table to be exported, database table comments, database table fields, and database table field comments according to the address information includes: obtaining the table name of the database table to be exported according to the database table; According to the database table comment, obtain the Chinese name corresponding to the table name of the database table to be exported; obtain the field name of the database table according to the database table field; obtain the Chinese name corresponding to the field name of the database table according to the table field comment Field comment.

In a possible implementation, query and read the table name of the database table through User_Tables. For example, in Figure 5, the table Chinese name "financial table" corresponding to the table name "ACCT" of the database table is queried and read through USER_TAB_COMMENTS The table comment of the database table, that is, the Chinese name corresponding to the table name of the database table, for example, the Chinese name of the table "financial table" corresponding to the table name "ACCT" of the database table in Figure 5; query and read the fields of the database table through USER_TAB_COLS Names, such as the fields PLANTYP, YNKC, YNPOS, YNCGQR, YNCGSH in the database table in Figure 4; query and read the field comments of the database table through USER_COL_COMMENTS, that is, the Chinese field comments corresponding to the field names of the database table, such as those in Figure 4 Chinese field notes "estimate method", "does the store use inventory", etc.

Step S203: Export the database table and database table notes in a preset format and generate a catalog worksheet; export the database table fields and database table field notes in a preset format and generate a database table worksheet.

In a possible implementation manner, the database tables and database table comments of the target database are exported, that is, the table names of the database tables and the corresponding Chinese names are exported to generate a catalog work table of the database tables. As shown in Figure 5, the interface diagram of the export data table file provided by an embodiment of this application has a preset format, one column of table names (ACCT, ACCTPERSON), and one column of corresponding Chinese names (financial table, financial personnel table). Stored in the catalog worksheet, the name of the catalog worksheet can be automatically set as the table catalog, which is convenient for quick distinction and selection when there are multiple database tables to export and generate multiple worksheets, which is more convenient for operation.

In addition, the database table fields and database table field comments are exported in a preset format and a database table worksheet is generated. As shown in Figure 6(a) and Figure 6(b), another embodiment of the present application provides a schematic diagram of an interface for exporting a data table file. In the exported worksheet, the database tables ACCT and ACCTPERSON correspond to the table names and Chinese The names are in the table directory; the fields PLANTYP, YNKC, YNPOS, YNCGQR, and YNCGSH of the database table ACCT are all in the worksheet named ACCT. The name of the worksheet is the Chinese name corresponding to the table name of the database table; correspondingly, The fields CARDID, VNAME, VTELE, and VSIGN of the database table ACCTPERSON are all in the worksheet named ACCTPERSON. The name of the worksheet is the Chinese name corresponding to the table name of the database table.

In one embodiment, exporting the database table and database table annotations in a preset format and generating a catalog work table includes:

A1. Establish the corresponding relationship between the table name, the Chinese name corresponding to the table name, and the position of the cell in the catalog work table;

Specifically, according to the read database tables and database table comments, establish a catalog work table corresponding to the database table and database table comments, obtain the address of the cell in the catalog work table, and establish the database table and database table comments for each data in the database table and database table comments. Correspondence of each cell address in the table of contents.

A2. According to the corresponding relationship, export the table name and the Chinese name and generate a catalog work table.

Specifically, add the read database table and database table comment to the directory work table according to the correspondence between each data in the database table and the database table comment and each cell address in the directory work table. According to the database table, database table comment, The data type of the table note determines the attributes of the cells in the table of contents and records the corresponding data type.

In one embodiment, exporting the database table fields and database table field comments in a preset format and generating a database table worksheet includes:

According to the correspondence between the database table field, the database table field comment, and the table name of the database table, according to the table name of the database, the database table field and the database table corresponding to the table name of the database table Field comments are grouped and exported and one or more database tables are generated.

Specifically, the database table worksheet corresponding to each database table is established according to the database table field and the database table field comments, the address of the cell in the database table worksheet is obtained, and the name of the database table worksheet is set according to the table name of the database table Establish the correspondence relationship between each data in the database table field and database table field comment and each cell address in the database table worksheet, and add the database table field and database table field comments to the database table worksheet in turn according to the corresponding relationship In the database table field, the data type of the database table field annotation is determined to determine the cell attributes in the corresponding database table worksheet, and the data type, default value, description and other related information corresponding to the field name are marked.

In a possible implementation, the catalog worksheet is the names and corresponding notes of all database tables that are required to be exported in the database table list, that is, the catalog of the tables; the database table worksheet is the data structure and corresponding data of each database table Content; establish the link between the Chinese name of the database table in the catalog worksheet or the table name and the database table worksheet, from the Chinese name of the database table in the catalog worksheet, you can directly jump to the corresponding database table worksheet, in each In the database table worksheet, there is a connection with the directory worksheet, and you can directly jump from a certain database table worksheet to the directory worksheet, as shown in Figure 5, click "Financial Table" or "Financial Personnel Table" You can jump directly to the corresponding financial table or financial staff table. As shown in Figure 6(a) or 6(b), in the financial table or financial staff table interface, you can directly return to the table of contents through "Return to table of contents". It should be noted that the number of database table worksheets is determined by the number of database tables that need to be exported, that is, each name in the directory worksheet corresponds to a database table worksheet, and you can directly jump from the directory worksheet to the corresponding one through the established link In the selected database table worksheet, it is convenient to view and modify the database structure.

In a possible implementation manner, the catalog worksheet and the database worksheet are saved as a local table file in xls or xlsx format according to a preset path and a preset name.

Exemplarily, the catalog worksheet and multiple database worksheets can be stored locally according to the preset path and preset name of the application, and the table file stored locally is an Excel table file in xls or xlsx format; the catalog worksheet and more Each database worksheet can be generated in a table file as required, and the table name of the database table in the directory worksheet includes all the database table worksheets in the file.

In a possible implementation manner, the preset path includes a default path and a selected save path;

The file is stored with a preset name according to the default path or the selected saving path; the preset name includes the time node at which the database table is exported.

In one embodiment, the preset name may be a name containing the date generated according to the current export time node, for example, it may be specific to year, month, day, hour and minute, which is used to avoid file names when exporting database table files of multiple databases. If the form file with the same name is repeated, it can be saved successfully every time.

In one embodiment, after the database table is exported to the workbook, the corresponding table query script information is generated according to the database table structure in each database table worksheet, so as to facilitate the modification or update of the table building program; the script information is directly copied Out, the database table can be built directly in the database client tool. Especially for scenarios where there are many database tables, the format of the exported database structure document is concise and easy to view, without the need to install additional complex export tools.

In addition, during the export process, the export progress can be displayed and prompts for the export process are given. For example, as shown in Figure 3, there are display boxes under the "Export" and "Exit" keys; when selecting the input filter conditions, the corresponding filter can be displayed. Condition example; when you click the export button to export data, a prompt of the export progress will be displayed; specifically, it can display the fields read during the export process and the storage location, and prompt the failure or problem during the export process, and prompt the user to input Whether there are errors in the information, and finally give a prompt of export success or export failure. In the exported form file, you can also reserve a "home page" worksheet for users to add remarks.

Through this embodiment, by obtaining the database tables that need to be exported, the table catalog worksheet is generated, the fields of the database tables are read, and the worksheets of the database tables are generated. The table catalog worksheets include the worksheets of multiple database tables. The corresponding jump can be realized. When there are multiple tables in the database, it is convenient to export at the same time for viewing and maintenance.

It should be noted that within the technical scope disclosed by this application, those skilled in the art can easily think of other sorting schemes that should also fall within the protection scope of this application, and will not be repeated here.

It should be understood that the size of the sequence number of each step in the foregoing embodiment does not mean the order of execution. The execution sequence of each process should be determined by its function and internal logic, and should not constitute any limitation on the implementation process of the embodiment of the present application.

Refer to FIG. 7, which is an apparatus for deriving a database table provided by an embodiment of the present application. For ease of description, only the parts related to the embodiment of the present application are shown.

The device for exporting the database table includes:

The obtaining module 71 is configured to obtain database information of the target database, the database information including: address information, database user name, and database password;

The reading module 72 is configured to read the to-be-exported database table, database table comment, database table field, and database table field comment according to the address information after the database password and the database user name are verified;

The execution module 73 is configured to export the database table and database table notes in a preset format and generate a catalog worksheet; export the database table fields and database table field notes in the preset format and generate a database table worksheet; Wherein, the generated catalog work table and the database work table are located in the same table file under a preset path, and the database table comments in the catalog work table correspond to the database table work table.

Through this embodiment, by obtaining the database tables that need to be exported, the table catalog worksheet is generated, the fields of the database tables are read, and the worksheets of the database tables are generated. The table catalog worksheets include worksheets of multiple database tables, and the table catalog worksheets There is a link relationship between the work with the database table, which is located in different worksheets in the same table file, and the corresponding jump can be realized through the link instruction, that is, jump directly from the table directory worksheet to the corresponding data table as needed Worksheets can also be directly returned to the table catalog worksheets from the link instructions in the database table work; when there are multiple tables in the database, it is convenient to export at the same time for viewing and maintenance.

FIG. 8 is a schematic structural diagram of a terminal device provided by an embodiment of this application. As shown in FIG. 8, the terminal device 8 of this embodiment includes: at least one processor 80 (only one is shown in FIG. A computer program 82 running on the processor 80, when the processor 80 executes the computer program 82, the steps in any of the foregoing embodiments of the method for exporting a database table are implemented.

The terminal device 8 may be a computing device such as a desktop computer, a notebook, a palmtop computer, and a cloud server. The terminal device may include, but is not limited to, a processor 80 and a memory 81. Those skilled in the art can understand that FIG. 8 is only an example of the terminal device 8 and does not constitute a limitation on the terminal device 8. It may include more or less components than shown in the figure, or a combination of certain components, or different components. , For example, can also include input and output devices, network access devices, and so on.

The so-called processor 80 may be a central processing unit (Central Processing Unit, CPU), the processor 80 may also be other general-purpose processors or digital signal processors (Digital Signal Processor, DSP), Application Specific Integrated Circuit (Application Specific Integrated Circuit, ASIC), ready-made programmable gate array (Field-Programmable Gate Array, FPGA) Or other programmable logic devices, discrete gates or transistor logic devices, discrete hardware components, etc. The general-purpose processor may be a microprocessor or the processor may also be any conventional processor or the like.

The memory 81 may be an internal storage unit of the terminal device 8 in some embodiments, such as a hard disk or memory of the terminal device 8. In other embodiments, the memory 81 may also be an external storage device of the terminal device 8, such as a plug-in hard disk equipped on the terminal device 8, a smart memory card (Smart Memory Card). Media Card, SMC), Secure Digital (Secure Digital, SD) card, flash memory card (Flash Card) and so on. Further, the memory 81 may also include both an internal storage unit of the terminal device 8 and an external storage device. The memory 81 is used to store an operating system, an application program, a boot loader (BootLoader), data, and other programs, such as the program code of the computer program. The memory 81 can also be used to temporarily store data that has been output or will be output.

It should be noted that the information interaction and execution process between the above-mentioned devices/units are based on the same concept as the method embodiment of this application, and its specific functions and technical effects can be found in the method embodiment section. I won't repeat it here.

Those skilled in the art can clearly understand that, for the convenience and conciseness of description, only the division of the above functional units and modules is used as an example. In practical applications, the above functions can be allocated to different functional units and modules as needed. Module completion, that is, the internal structure of the device is divided into different functional units or modules to complete all or part of the functions described above. The functional units and modules in the embodiments can be integrated into one processing unit, or each unit can exist alone physically, or two or more units can be integrated into one unit. The above-mentioned integrated units can be hardware-based Formal realization can also be realized in the form of a software functional unit. In addition, the specific names of the functional units and modules are only for the convenience of distinguishing each other, and are not used to limit the protection scope of the present application. For the specific working process of the units and modules in the foregoing system, reference may be made to the corresponding process in the foregoing method embodiment, which will not be repeated here.

An embodiment of the present application also provides a network device, which includes: at least one processor, a memory, and a computer program stored in the memory and running on the at least one processor, and the processor executes The computer program implements the steps in any of the foregoing method embodiments.

The embodiments of the present application also provide a computer-readable storage medium. The computer-readable storage medium may be non-volatile or volatile. The computer-readable storage medium stores a computer program, and the computer When the program is executed by the processor, the steps in the foregoing method embodiments can be realized.

The embodiments of the present application provide a computer program product. When the computer program product runs on a mobile terminal, the steps in the foregoing method embodiments can be realized when the mobile terminal is executed.

If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer readable storage medium. Based on this understanding, the implementation of all or part of the processes in the above-mentioned embodiment methods in the present application can be accomplished by instructing relevant hardware through a computer program. The computer program can be stored in a computer-readable storage medium. When executed by the processor, the steps of the foregoing method embodiments can be implemented. Wherein, the computer program includes computer program code, and the computer program code may be in the form of source code, object code, executable file, or some intermediate forms. The computer-readable medium may at least include: any entity or device capable of carrying computer program code to the photographing device/terminal device, recording medium, computer memory, read-only memory (ROM, Read-Only Memory), and random access memory (RAM, Random Access Memory), electrical carrier signals, telecommunications signals, and software distribution media. For example, U disk, mobile hard disk, floppy disk or CD-ROM, etc. In some jurisdictions, according to legislation and patent practices, computer-readable media cannot be electrical carrier signals and telecommunication signals.

In the above-mentioned embodiments, the description of each embodiment has its own focus. For parts that are not described in detail or recorded in an embodiment, reference may be made to related descriptions of other embodiments.

A person of ordinary skill in the art may realize that the units and algorithm steps of the examples described in combination with the embodiments disclosed herein can be implemented by electronic hardware or a combination of computer software and electronic hardware. Whether these functions are executed by hardware or software depends on the specific application and design constraint conditions of the technical solution. Professionals and technicians can use different methods for each specific application to implement the described functions, but such implementation should not be considered beyond the scope of this application.

In the embodiments provided in this application, it should be understood that the disclosed apparatus/network equipment and method may be implemented in other ways. For example, the device/network device embodiments described above are only illustrative. For example, the division of the modules or units is only a logical function division, and there may be other divisions in actual implementation, such as multiple units. Or components can be combined or integrated into another system, or some features can be omitted or not implemented. In addition, the displayed or discussed mutual coupling or direct coupling or communication connection may be indirect coupling or communication connection through some interfaces, devices or units, and may be in electrical, mechanical or other forms.

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, they may be located in one place, or they may be distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the objectives of the solutions of the embodiments.

The above-mentioned embodiments are only used to illustrate the technical solutions of the present application, not to limit them; although the present application has been described in detail with reference to the foregoing embodiments, a person of ordinary skill in the art should understand that it can still implement the foregoing The technical solutions recorded in the examples are modified, or some of the technical features are equivalently replaced; these modifications or replacements do not cause the essence of the corresponding technical solutions to deviate from the spirit and scope of the technical solutions of the embodiments of the application, and should be included in Within the scope of protection of this application.

Claims

A method for exporting database tables, including:

Acquiring database information of the target database, the database information including: address information, database user name, and database password;

After the database password and the database user name are verified, read the database table to be exported, the database table comment, the database table field, and the database table field comment according to the address information;

Exporting the database table and database table comments in a preset format and generating a catalog worksheet; exporting the database table fields and database table field comments in a preset format and generating the database table worksheet;

Wherein, the generated catalog work table and the database work table are located in the same table file under a preset path, and the database table comments in the catalog work table correspond to the database table work table.
The method for exporting a database table according to claim 1, wherein obtaining database information of the target database comprises:

Obtain a filter condition of the target database, where the filter condition includes the database table comment to be exported; read the database table comment to be exported according to the filter condition.
The method for exporting a database table according to claim 1, wherein reading the database table to be exported, database table comments, database table fields, and database table field comments according to the address information comprises:

According to the database table, obtain the table name of the database table to be exported;

Acquire the Chinese name corresponding to the table name of the database table to be exported according to the database table comment;

Obtaining the field name of the database table according to the database table field;

According to the table field comment, the Chinese field comment corresponding to the field name of the database table is obtained.
The method for exporting a database table according to claim 3, wherein exporting the database table and database table annotations in a preset format and generating a catalog work table comprises:

Establishing the corresponding relationship between the table name, the Chinese name corresponding to the table name and the position of the cell in the catalog work table;

According to the corresponding relationship, the table name and the Chinese name are derived and a directory work table is generated.
The method for exporting a database table according to claim 3, wherein the exporting of the database table fields and the database table field comments in a preset format and generating a database table worksheet comprises:

According to the correspondence between the database table field, the database table field comment, and the table name of the database table, according to the table name of the database, the database table field and the database table corresponding to the table name of the database table Field comments are grouped and exported and one or more database tables are generated.
The method for exporting a database table according to claim 1, wherein the method comprises: the preset path includes a default path and a selected save path;

Store the file with a preset name according to the default path or the selected save path;

The preset name includes the time node at which the database table is derived.
The method for exporting a database table according to claim 6, which comprises:

The catalog worksheet and the database worksheet are saved as a local table file in xls or xlsx format according to a preset path and a preset name.
A device for exporting database tables, which includes:

The obtaining module is used to obtain database information of the target database, the database information includes: address information, database user name, and database password;

A reading module, configured to read the database table to be exported, database table comments, database table fields, and database table field comments according to the address information after the database password and the database user name are verified;

The execution module is used to export the database table and database table comments in a preset format and generate a catalog worksheet; export the database table fields and database table field comments in the preset format and generate a database table worksheet; wherein , The generated catalog work table and the database work table are located in the same table file under a preset path, and the database table comments in the catalog work table correspond to the database table work table.
The device according to claim 8, wherein the acquiring module is specifically configured to:

Obtain a filter condition of the target database, where the filter condition includes the database table comment to be exported; read the database table comment to be exported according to the filter condition.
The device according to claim 8, wherein reading the database table to be exported, database table comments, database table fields, and database table field comments according to the address information comprises:

According to the database table, obtain the table name of the database table to be exported;

Acquire the Chinese name corresponding to the table name of the database table to be exported according to the database table comment;

Obtaining the field name of the database table according to the database table field;

According to the table field comment, the Chinese field comment corresponding to the field name of the database table is obtained.
10. The device of claim 10, wherein exporting the database table and database table annotations in a preset format and generating a catalog work table comprises:

Establishing the corresponding relationship between the table name, the Chinese name corresponding to the table name and the position of the cell in the catalog work table;

According to the corresponding relationship, the table name and the Chinese name are derived and a directory work table is generated.
10. The device of claim 10, wherein exporting the database table fields and database table field comments in a preset format and generating a database table worksheet comprises:

According to the correspondence between the database table field, the database table field comment, and the table name of the database table, according to the table name of the database, the database table field and the database table corresponding to the table name of the database table Field comments are grouped and exported and one or more database tables are generated.
The device according to claim 8, wherein it comprises: the preset path includes a default path and a selected save path;

Store the file with a preset name according to the default path or the selected save path;

The preset name includes the time node at which the database table is derived.
The device according to claim 13, wherein it comprises:

The catalog worksheet and the database worksheet are saved as a local table file in xls or xlsx format according to a preset path and a preset name.
A terminal device includes a memory, a processor, and a computer program that is stored in the memory and can run on the processor, wherein the processor implements the following steps when the processor executes the computer program:

Acquiring database information of the target database, the database information including: address information, database user name, and database password;

After the database password and the database user name are verified, read the database table to be exported, the database table comment, the database table field, and the database table field comment according to the address information;

Exporting the database table and database table comments in a preset format and generating a catalog worksheet; exporting the database table fields and database table field comments in a preset format and generating the database table worksheet;

Wherein, the generated catalog work table and the database work table are located in the same table file under a preset path, and the database table comments in the catalog work table correspond to the database table work table.
The terminal device according to claim 15, wherein acquiring database information of the target database comprises:

Obtain a filter condition of the target database, where the filter condition includes the database table comment to be exported; read the database table comment to be exported according to the filter condition.
The terminal device according to claim 15, wherein reading the database table to be exported, database table comments, database table fields, and database table field comments according to the address information comprises:

According to the database table, obtain the table name of the database table to be exported;

Acquire the Chinese name corresponding to the table name of the database table to be exported according to the database table comment;

Obtaining the field name of the database table according to the database table field;

According to the table field comment, the Chinese field comment corresponding to the field name of the database table is obtained.
The terminal device according to claim 17, wherein exporting the database table and database table annotations in a preset format and generating a catalog work table comprises:

Establishing the corresponding relationship between the table name, the Chinese name corresponding to the table name and the position of the cell in the catalog work table;

According to the corresponding relationship, the table name and the Chinese name are derived and a directory work table is generated.
The terminal device of claim 17, wherein exporting the database table fields and database table field comments in a preset format and generating a database table worksheet comprises:

According to the correspondence between the database table field, the database table field comment, and the table name of the database table, according to the table name of the database, the database table field and the database table corresponding to the table name of the database table Field comments are grouped and exported and one or more database tables are generated.
A computer-readable storage medium storing a computer program, wherein the computer program implements the method according to any one of claims 1 to 7 when the computer program is executed by a processor.