CN110780860A - Generation method and device of table building script, computer equipment and storage medium - Google Patents

Abstract

Embodiments of the present application provide a method, apparatus, computer device, and computer-readable storage medium for generating a table building script. The embodiment of the present application belongs to the database development technology. When the generation of the table building script is realized, an Excel file is obtained, and the Excel file contains the table data required for building a database table, and the table data includes the table name, the fields contained in the database table and its data type; parse the Excel file through a preset method to obtain table data; through the first preset method, the table data is correspondingly inserted into the preset grammar format for establishing a database table to obtain a plurality of subscripts; according to establishing a database table The syntax of the database management system used is to splicing a plurality of sub-scripts through the second preset method to generate a script for creating a database table, and by automatically generating a table-building script, the time cost of generating the table-building script is saved, and the construction is improved. Efficiency of table script generation.

Description

Method, device, computer equipment and storage medium for generating table building script

technical field

The present application relates to the technical field of database development, and in particular, to a method, apparatus, computer device, and computer-readable storage medium for generating a table building script.

Background technique

The creation of database tables, referred to as table creation, and the script for creating database tables, referred to as table creation scripts, can also be referred to as table creation scripts. Since any data requirement is inseparable from a database table, building a table is the first step in development. In traditional technology, table building is generally a script for creating database tables by coders in the IT industry by writing codes. Especially when multiple database tables need to be created, table building is a complicated and non-technical work, and characters are prone to appear. and format and other clerical errors, especially when there are many fields, it will cost a lot of time, which greatly reduces the generation efficiency of the table building script.

SUMMARY OF THE INVENTION

The embodiments of the present application provide a method, apparatus, computer device, and computer-readable storage medium for generating a table building script, which can solve the problem of low generation efficiency of the table building script in the traditional technology.

In a first aspect, an embodiment of the present application provides a method for generating a table building script, the method comprising: obtaining an Excel file, where the Excel file contains table data required for building a database table, and the table data includes creating all the tables. The table name required by the database table, the field contained in the database table and the data type of the field; the Excel file is parsed by a preset method to obtain the table data; The table data is correspondingly inserted into the preset grammar format for establishing the database table to obtain a plurality of subscripts; according to the grammar of the database management system used for establishing the database table, multiple The subscripts are spliced to generate a script for building the database table.

In a second aspect, an embodiment of the present application further provides a device for generating a table building script, including: an acquisition unit configured to acquire an Excel file, where the Excel file contains table data required for establishing a database table, and the table data Including the table name required for establishing the database table, the field contained in the database table and the data type of the field; a parsing unit for parsing the Excel file by a preset method to obtain the table data; inserting a unit for correspondingly inserting the table data into a preset syntax format for establishing the database table by a first preset method to obtain a plurality of subscripts; a generating unit for establishing the database table according to the Using the syntax of the database management system, a plurality of the sub-scripts are spliced by a second preset method to generate a script for establishing the database table.

In a third aspect, an embodiment of the present application further provides a computer device, which includes a memory and a processor, the memory stores a computer program, and the processor generates the table building script when executing the computer program method.

In a fourth aspect, an embodiment of the present application further provides a computer-readable storage medium, where the computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the processor executes the table building process Script generation method.

Embodiments of the present application provide a method, apparatus, computer device, and computer-readable storage medium for generating a table building script. When the embodiment of the present application realizes the generation of the table building script, the developer only needs to write the field name and the table name into the Excel file, and the computer device obtains the Excel file, and the Excel file contains the table data required for building the database table, The table data includes the table name required to establish the database table, the fields contained in the database table and the data type of the field, and the Excel file can be automatically parsed by a preset method to obtain the table data. , and through the first preset method, the table data is correspondingly inserted into the preset grammatical format for establishing the database table to obtain a plurality of subscripts, and then according to the database management system used for establishing the database table The grammar, the second preset method is used to splicing a plurality of the sub-scripts to generate the script for establishing the database table, thereby realizing the automatic generation of the table-building script. The script of the database table, the embodiment of the present application, by automatically generating the table-building script, frees developers from complicated and unskilled mechanical labor, saves the time and cost of generating the table-building script, and improves the generation of the table-building script. s efficiency.

Description of drawings

In order to explain the technical solutions of the embodiments of the present application more clearly, the following briefly introduces the accompanying drawings used in the description of the embodiments. For those of ordinary skill, other drawings can also be obtained from these drawings without any creative effort.

1 is a schematic flowchart of a method for generating a table building script provided by an embodiment of the present application;

FIG. 2 is a schematic block diagram of an apparatus for generating a table building script provided by an embodiment of the present application; and

FIG. 3 is a schematic block diagram of a computer device according to an embodiment of the present application.

Detailed ways

The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present application. Obviously, the described embodiments are part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by those of ordinary skill in the art without creative efforts shall fall within the protection scope of the present application.

It is to be understood that, when used in this specification and the appended claims, the terms "comprising" and "comprising" indicate the presence of the described features, integers, steps, operations, elements and/or components, but do not exclude one or The presence or addition of a number of other features, integers, steps, operations, elements, components, and/or sets thereof.

It should also be understood that the terminology used in the specification of the application herein is for the purpose of describing particular embodiments only and is not intended to limit the application. As used in this specification and the appended claims, the singular forms "a," "an," and "the" are intended to include the plural unless the context clearly dictates otherwise.

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

The method for generating a table building script provided by the embodiments of the present application can be applied to computer equipment such as a terminal or a server, and the steps of the method for generating a table building script are implemented by software installed on the terminal or server, wherein the terminal can It is an electronic device such as a mobile phone, a notebook computer, a tablet computer or a desktop computer, and the server may be a cloud server or a server cluster. Taking a terminal as an example, the specific implementation process of the method for generating a table building script provided by the embodiment of the present application is as follows: the terminal obtains an Excel file, and the Excel file contains table data required for establishing a database table, and the table data includes the table data required for establishing a database table. Describe the required table name of the database table, the field contained in the database table and the data type of the field, the table data is filled in the Excel file by the developer, and the terminal parses the Excel file by default In order to obtain the table data, through the first preset method, the table data is correspondingly inserted into the preset grammar format for establishing the database table to obtain a plurality of subscripts, according to the use of establishing the database table. The syntax of the database management system is based on the second preset method, and a plurality of the sub-scripts are spliced to generate a script for establishing the database table.

It should be noted that, in the actual operation process, the application scenarios of the above table building script generation method are only used to illustrate the technical solutions of the present application, and are not used to limit the technical solutions of the present application.

FIG. 1 is a schematic flowchart of a method for generating a table building script according to an embodiment of the present application. The method for generating a table building script is applied to a terminal or a server, and the method is implemented by application software installed in the terminal or server, which may exist in a system manner, for example, wherein the terminal or server is a A computer device that performs all or part of the functions of the generation method of the table building script. Please refer to FIG. 1. As shown in FIG. 1, the method includes the following steps S101-S104:

S101. Acquire an Excel file, where the Excel file contains table data required for establishing a database table, and the table data includes a table name required for establishing the database table, a field contained in the database table, and the value of the field. type of data.

Specifically, the script for creating the database table actually refers to the code for creating the database table. To create a table in a database, the general code structure is:

CREATE TABLE table name

(

column name 1 data type,

column name 2 data type,

......

)

Since creating a database table requires at least the table name of the database table, the fields contained in the database table and the data types of the fields, and the table name, the fields contained in the database table and the data types of the fields are required User-defined, so this part of the content needs to be set by the user through the Excel file. For example, in the above example, the Excel template will contain the table name, column name 1 and its data type, column name 2 and its data type 2, etc. field. The system for implementing the method of the present invention in the terminal or server can be pre-set with an Excel template for the user to fill in the table data, and the user can download the Excel template that comes with the system after reading the instructions for use, and fill in the table structure according to the Excel template, Among them, the user fills in the table structure according to the Excel template, which means that the user fills in the table name, fields and other information contained in the database table contained in the Excel template according to the template Excel, and saves the Excel file generated by the Excel template after filling in the table structure to the local directory. Subsequently, for example, upload the Excel file from the local directory through the "Upload File" button, that is, click "Select File" to select the Excel file to upload the Excel file locally, so that the computer device obtains the Excel file. Among them, in the Excel template, the default Sheet1 page is the navigation page, and the overview information of each table is placed. From the Sheet2 page, fill in the table structure according to the template, and the subsequent script will automatically generate and build the table according to the table structure of the Sheet2 page, Sheet3 page, etc. script.

The computer equipment obtains the Excel file uploaded by the user, and the Excel file contains the table name, the field and the data type of the field required for establishing the database table, that is, the table name required for establishing the database table, the data type contained in the database table are included in the Excel file. The column name and the data type of the column field.

S102. Parse the Excel file in a preset manner to obtain the table data.

Among them, the default methods include JAR packages and libraries in Python. JAR packages include POI packages and JXL packages in JAVA; libraries in Python include Xlrd library.

Specifically, the computer device parses the Excel file in a preset manner to obtain the table data. For example, the computer device uses a JAR package to parse the Excel file to obtain table data for creating a table, where the table data includes table name, field name and the data type of the field.

Further, in one embodiment, the step of parsing the Excel file in a preset manner to obtain the table data includes:

The table data contained in the Excel file is obtained through the POI package in JAVA or Jxl.jar.

Specifically, use the third-party JAR package to parse the Excel content, and use the JAR package to read the content of the Excel table in JAVA. One way is to import the POI package, and the other way is to import the JXL package. JAVA parses Excel through the POI package. In POI, HSSFWorkbook is used for parsing Excel tables in XLS format, and XSSFWorkbook is used for parsing tables in .XLSX format, so as to obtain the table name, field name and field data type required to create a database table. Wait for the content of the Excel file. Among them, JAVA can read the value of the specified row and column from the Excel file through the package jxl.jar, and Java can read the Excel file and turn the Excel file into a two-dimensional String array, thus Get the table name and field name required to create a table.

S103. Using the first preset method, correspondingly insert the table data into a preset syntax format for establishing the database table to obtain a plurality of sub-scripts.

Specifically, to create a database table A of a SQL database management system, the database table A contains two columns B and C, and the manually written script for creating the table is:

CREATE TABLE table name A; //ADD1

(

column name B datatype; //ADD2

column name C datatype; //ADD3

......

)

The pre-set syntax format for establishing the database table is:

CREATE TABLE X1; //ADD1

(

x2 x3; //add2

x4 x5; // ADD3

......

)

When the script for generating database table A is created by the method of this embodiment of the present application, the user only needs to perform a simple operation to generate the script automatically, for example, by clicking "Select Folder" on the system to select the directory for storing the generated table-building script, and finally , and click Generate Script. Among them, generating the table building script is to use the third-party Jar package to parse the content of the Excel file. For example, Java parses the Excel file through the POI package. Since the Excel file contains the table name A, column name B and its data type, which are filled in by the user according to the Excel template, Fields such as column name C and its data type, so as to obtain fields such as table name A, column name B and its data type, column name C and its data type required to create a database table.

In one embodiment, the first preset method includes an Insert method of the StringBuffer class. The step of correspondingly inserting the table data into a preset syntax format for establishing the database table by the first preset method to obtain a plurality of subscripts includes:

Through the Insert method of the StringBuffer class, the table data is correspondingly inserted into the preset SQL syntax format for establishing the database table to obtain multiple SQL subscripts.

Specifically, in JAVA, after parsing the Excel content through a third-party JAR package, the table name A, column name B and its data type, column name C and its data type are obtained, and then the Insert method of the StringBuffer class is used, for example, the following script is used: public insert(int offset,int i), which means to insert the string representation of the int parameter into this sequence, insert the table name A into the position X1 of ADD1 after CREATE TABLE, and insert the column name B and its data type into ADD2 respectively At positions X2 and X3, insert the column name C and its data type into the positions X4 and X5 of ADD3 to obtain multiple subscripts, such as "CREATE TABLE table name A", "column name B data type" , "column name C datatype; //ADD3".

S104. According to the syntax of the database management system used for establishing the database table, splicing a plurality of the sub-scripts through a second preset method to generate a script for establishing the database table.

The second preset method includes the append method and the appendTo method in the StringBuffer class.

Specifically, after obtaining a plurality of sub-scripts, according to the syntax of the database management system used for establishing the database table, the plurality of sub-scripts are spliced by a second preset method to generate a script for establishing the database table.

Further, in one embodiment, according to the grammar of the database management system used for establishing the database table, a plurality of the sub-scripts are spliced by a second preset method to generate a script for establishing the database table. The steps include:

According to the grammar of the database management system used for establishing the database table, a plurality of the subscripts are spliced by the Append method in the StringBuffer class to obtain the initial script for establishing the database table;

The initial script is string-formatted using the ToString method to generate a script for building the database table.

Specifically, taking the above-mentioned SQL database management system as an example, after obtaining multiple SQL sub-scripts, the StringBuffer class is used to splicing the multiple sub-scripts into a table building script according to the SQL syntax. Among them, in addition to using the StringBuffer class to splice SQL scripts, you can also use the StringBuilder class to splice SQL scripts. The splicing of SQL scripts is actually the use of Stringbuffer to continuously append SQL scripts according to SQL syntax, and finally Tostring. Among them, publicStringBuffer append(String s), appends the specified string to this character sequence, the Tostring method converts the data in front of Tostring() into a string format, and the ToString method returns a "text representation" of this object. string. For example, use the SQL scripts such as "CREATE TABLE table name A", "column name B data type" and "column name C data type" obtained in the above example, and append the SQL script continuously through Stringbuffer according to the SQL syntax, and finally Tostring it. , and applying the above-mentioned format of the SQL syntax, the SQL script for creating table A that is the same as the script for creating table A manually written above can be obtained by the method of the embodiment of the present application.

When the embodiment of the present application realizes the generation of the table building script, the developer only needs to write the field name and the table name into the Excel file, and the computer device obtains the Excel file, and the Excel file contains the table data required for building the database table, The table data includes the table name required to establish the database table, the fields contained in the database table and the data type of the field, and the Excel file can be automatically parsed by a preset method to obtain the table data. , and through the first preset method, the table data is correspondingly inserted into the preset grammatical format for establishing the database table to obtain a plurality of subscripts, and then according to the database management system used for establishing the database table The grammar, the second preset method is used to splicing a plurality of the sub-scripts to generate the script for establishing the database table, thereby realizing the automatic generation of the table-building script. The script of the database table, the embodiment of the present application, by automatically generating the table-building script, frees developers from complicated and unskilled mechanical labor, saves the time and cost of generating the table-building script, and improves the generation of the table-building script. s efficiency.

In one embodiment, the Excel file contains a plurality of worksheets, and before the step of parsing the Excel file in a preset manner to obtain the table data, the method further includes:

loop through each worksheet of the Excel file;

The step of parsing the Excel file by default to obtain the table data includes:

Parse each of the worksheets in a preset manner to obtain table data of a database table corresponding to each of the worksheets.

Among them, traversal, which is called Traversal in English, means that along a certain search route, each node in the tree is visited once and only once.

Specifically, in the case that the Excel file contains multiple worksheets, and each worksheet corresponds to a database table, it is necessary to analyze each worksheet one by one. The computer equipment obtains the Excel file, parses the first worksheet contained in the Excel file by a preset method, and then loops through all the Sheet pages of the Excel file to obtain the table name required for each corresponding table to be built, the database table The fields contained in and the data types of the fields, that is, each of the worksheets is parsed by a preset method to convert each of the worksheets into a two-dimensional array to obtain the database table corresponding to each of the worksheets The table data, each of the table data is correspondingly inserted into the preset syntax format for establishing the database table by the first preset method to obtain a plurality of subscripts corresponding to each database table, according to the method for establishing the database table. Using the syntax of the database management system, the multiple sub-scripts corresponding to each database table are spliced respectively by the second preset method to correspondingly generate multiple scripts for establishing the database table, so as to obtain the construction of each corresponding to-be-built table. Table script.

By including multiple worksheets in the Excel file, the user only needs to fill in the table name, the fields contained in the database table and the data of the fields required to create each database table in the multiple database tables to be created according to the Excel template Table data such as types, combined with the preset grammar format for establishing the database table, through the technical method of the embodiment of the present application, a large batch of Hive table building scripts can be generated through the Excel table structure with one click, which saves time and cost and allows developers to Freeing from complicated and unskilled mechanical labor not only saves the labor cost of developers, improves development quality and coding efficiency, but also does not require any coding ability for users to use the method of establishing database tables. Even people without coding foundation can independently complete the work of the table building script, which improves the generation efficiency of the table building script. Among them, Hive is a data warehouse tool based on Hadoop.

In one embodiment, the step of parsing each of the worksheets in a preset manner to obtain table data of a database table corresponding to each of the worksheets includes:

Parse each of the worksheets in a preset manner, and convert each of the worksheets into a two-dimensional array to obtain table data of the database table corresponding to each of the worksheets;

The step of correspondingly inserting the table data into a preset syntax format for establishing the database table by the first preset method to obtain a plurality of subscripts includes:

Through the first preset method, the table data of the database table corresponding to each of the worksheets is correspondingly inserted into the preset syntax format for establishing the database table to obtain the multiple data corresponding to each of the database tables. a subscript;

The step of splicing a plurality of the subscripts to generate the script for establishing the database table by the second preset method according to the grammar of the database management system used for establishing the database table includes:

According to the grammar of the database management system used to establish the database table, the multiple sub-scripts corresponding to each of the database tables are spliced separately by the second preset method to generate correspondingly the corresponding database table. script.

Specifically, in the case of establishing multiple database tables, the content contained in each worksheet in the Excel file corresponds to a database table, that is, a Sheet page corresponds to a database table, and a worksheet in the Excel file contains the required information for establishing a database table. Table name, fields contained in the database table and data types of the fields, for example, to create five database tables A, B, C, D and E, the table name required to create the database table A, the database table The fields contained in and the data types of the fields are in one worksheet, the table name required to create the B database table, the fields contained in the database table and the data types of the fields are in another worksheet, and so on , the table name required to establish the E database table, the field contained in the database table and the data type of the field are in the fifth worksheet, corresponding to five database tables of A, B, C, D and E, and the Excel file contains at least five worksheets. For the case that the Excel file contains multiple worksheets, the Excel template will contain multiple worksheets, and each worksheet contains information such as the table name, column name 1 and its data type required to create a database table.

In one embodiment, after the step of splicing a plurality of the sub-scripts according to the syntax of the database management system used for establishing the database table by a second preset method to generate the script for establishing the database table ,Also includes:

The script that builds the database table is encapsulated using IO streams.

Among them, IO stream, English is Input Output Stream, Chinese is input and output stream, IO stream is input and output in the form of stream.

Specifically, when the table building script is generated, the developer writes the field name and the table name into an Excel file, uploads the Excel file to a computer device, and the computer device obtains the Excel file, and automatically parses the Excel file by a preset method. file to obtain table data such as the table name required to establish the database table, the fields contained in the database table and the data types of the fields, and by the first preset method, the table data is correspondingly inserted into the preset In order to obtain a plurality of sub-scripts in the grammar format used for establishing the database table, then according to the grammar of the database management system used for establishing the database table, the plurality of sub-scripts are spliced by the second preset method to generate a script for establishing the database table, and then use the IO stream to encapsulate the script for establishing the database table. For example, in the case of creating multiple database tables and the Excel file contains multiple Sheet pages, the computer device obtains the Excel file, and then loops through all the Sheet pages of Excel to obtain the table building script corresponding to the table to be built for each Sheet page, and then use The IO stream writes the SQL script into a local file. Among them, Java IO is the basis for realizing input and output, which can easily realize the input and output operations of data. In Java, different input sources and output sources (such as keyboards, files or network connections, etc.) are abstractly expressed as "streams" (Stream in English). Streams allow Java programs to access different input and output sources in the same way.

It should be noted that, in the methods for generating table building scripts described in the above-mentioned embodiments, the technical features contained in different embodiments can be recombined as required to obtain a combined implementation scheme, but all of them are within the requirements of this application. within the scope of protection.

Please refer to FIG. 2 , which is a schematic block diagram of an apparatus for generating a table building script according to an embodiment of the present application. Corresponding to the above method for generating a table building script, an embodiment of the present application further provides an apparatus for generating a table building script. As shown in FIG. 2 , the apparatus for generating a table building script includes a unit for executing the above-mentioned method for generating a table building script, and the apparatus may be configured in a computer device such as a terminal or a server. Specifically, please refer to FIG. 2 , the table building script generating apparatus 200 includes an acquiring unit 201 , a parsing unit 202 , an inserting unit 203 and a generating unit 204 .

Wherein, the obtaining unit 201 is configured to obtain an Excel file, where the Excel file contains table data required for establishing a database table, and the table data includes a table name required for establishing the database table, and the table data contained in the database table. the field and the data type of said field;

parsing unit 202, configured to parse the Excel file by a preset method to obtain the table data;

The inserting unit 203 is used for correspondingly inserting the table data into the preset syntax format for establishing the database table by the first preset method to obtain a plurality of sub-scripts;

The generating unit 204 is configured to generate a script for establishing the database table by splicing a plurality of the sub-scripts through a second preset method according to the syntax of the database management system used for establishing the database table.

In one embodiment, the Excel file includes a plurality of worksheets, and the generating apparatus 200 of the table building script further includes:

a loop unit for looping through each worksheet of the Excel file;

The parsing unit 202 is configured to parse each of the worksheets in a preset manner to obtain table data of a database table corresponding to each of the worksheets.

In one embodiment, the parsing unit 202 is configured to parse each of the worksheets in a preset manner, and convert each of the worksheets into a two-dimensional array to obtain the corresponding The table data of the database table;

The inserting unit 203 is configured to insert, through the first preset method, the table data of the database table corresponding to each of the worksheets into a preset syntax format for establishing the database table to obtain each a plurality of subscripts corresponding to the database tables;

The generating unit 204 is used for splicing a plurality of the subscripts corresponding to each of the database tables by the second preset method to generate correspondingly according to the grammar of the database management system used for establishing the database table. Build scripts for each of the database tables.

In one embodiment, the inserting unit 203 is configured to insert the table data into a preset SQL syntax format for establishing the database table through the Insert method of the StringBuffer class to obtain multiple SQL sub-scripts .

In one embodiment, the generating unit 204 includes:

The splicing subunit is used for splicing a plurality of described sub-scripts to obtain the initial script of establishing the database table by the Append method in the StringBuffer class according to the syntax of the database management system used for establishing the database table;

The formatting subunit is used to format the initial script by using the ToString method to generate a script for establishing the database table.

In one embodiment, the parsing unit 202 is configured to obtain the table data contained in the Excel file through a POI package in JAVA or Jxl.jar.

In one embodiment, the generating apparatus 200 of the table building script further includes:

The encapsulation unit is used to encapsulate the script for establishing the database table by using the IO stream.

It should be noted that those skilled in the art can clearly understand that, for the specific implementation process of the above-mentioned table building script generating device and each unit, reference may be made to the corresponding descriptions in the foregoing method embodiments. For the convenience and brevity of the description, in This will not be repeated here.

At the same time, the division and connection methods of each unit in the above-mentioned table-building script generating device are only used for illustration. In other embodiments, the table-building script generating device may be divided into different units as required, or the table building Each unit in the script generating device adopts different connection sequences and methods to complete all or part of the functions of the above-mentioned table building script generating device.

The above-mentioned generating apparatus for a table building script can be implemented in the form of a computer program, and the computer program can be executed on the computer device as shown in FIG. 3 .

Please refer to FIG. 3 , which is a schematic block diagram of a computer device provided by an embodiment of the present application. The computer device 300 may be a computer device such as a desktop computer or a server, or may be a component or component in other devices.

Referring to FIG. 3 , the computer device 300 includes a processor 302 , a memory and a network interface 305 connected through a system bus 301 , wherein the memory may include a non-volatile storage medium 303 and an internal memory 304 .

The nonvolatile storage medium 303 can store an operating system 3031 and a computer program 3032 . When the computer program 3032 is executed, it can cause the processor 302 to execute a method for generating the above-mentioned table building script.

The processor 302 is used to provide computing and control capabilities to support the operation of the entire computer device 300 .

The internal memory 304 provides an environment for running the computer program 3032 in the non-volatile storage medium 303. When the computer program 3032 is executed by the processor 302, the processor 302 can execute a method for generating the above table building script.

The network interface 305 is used for network communication with other devices. Those skilled in the art can understand that the structure shown in FIG. 3 is only a block diagram of a part of the structure related to the solution of the present application, and does not constitute a limitation on the computer device 300 to which the solution of the present application is applied. The specific computer device 300 may include more or fewer components than shown, or combine certain components, or have a different arrangement of components. For example, in some embodiments, the computer device may only include a memory and a processor. In such an embodiment, the structures and functions of the memory and the processor are the same as those of the embodiment shown in FIG. 3 , and details are not repeated here.

Wherein, the processor 302 is used to run the computer program 3032 stored in the memory, so as to realize the following steps: obtaining an Excel file, the Excel file contains table data required for establishing a database table, and the table data includes establishing all the table data. The table name required by the database table, the field contained in the database table and the data type of the field; the Excel file is parsed by a preset method to obtain the table data; The table data is correspondingly inserted into the preset grammar format for establishing the database table to obtain a plurality of subscripts; according to the grammar of the database management system used for establishing the database table, multiple The subscripts are spliced to generate a script for building the database table.

In one embodiment, when the processor 302 implements the step of acquiring an Excel file, the Excel file contains a plurality of worksheets, and the processor 302 implements the parsing of the Excel file by a preset method. Before the step of file to get the table data, also implement the following steps:

loop through each worksheet of the Excel file;

When the processor 302 implements the step of parsing the Excel file in a preset manner to obtain the table data, the processor 302 specifically implements the following steps:

Parse each of the worksheets in a preset manner to obtain table data of a database table corresponding to each of the worksheets.

In one embodiment, when the processor 302 implements the step of parsing each of the worksheets in a preset manner to obtain table data of a database table corresponding to each of the worksheets, the processor 302 specifically implements the following steps:

Parse each of the worksheets in a preset manner, and convert each of the worksheets into a two-dimensional array to obtain table data of the database table corresponding to each of the worksheets;

When the processor 302 implements the step of correspondingly inserting the table data into the preset syntax format for establishing the database table to obtain a plurality of sub-scripts through the first preset method, the processor 302 specifically implements the following: step:

Through the first preset method, the table data of the database table corresponding to each of the worksheets is correspondingly inserted into the preset syntax format for establishing the database table to obtain the multiple data corresponding to each of the database tables. subscript;

The processor 302 implements the step of splicing a plurality of the sub-scripts to generate a script for establishing the database table by using the second preset method according to the syntax of the database management system used for establishing the database table. , implement the following steps:

According to the grammar of the database management system used to establish the database table, the multiple sub-scripts corresponding to each of the database tables are spliced separately by the second preset method to generate correspondingly the corresponding database table. script.

In one embodiment, the processor 302 inserts the table data correspondingly into a preset syntax format for establishing the database table to obtain a plurality of sub-scripts by implementing the first preset method. Steps, the specific implementation of the following steps:

Through the Insert method of the StringBuffer class, the table data is correspondingly inserted into the preset SQL syntax format for establishing the database table to obtain multiple SQL subscripts.

In one embodiment, when the processor 302 implements the syntax according to the database management system used to establish the database table, a plurality of the sub-scripts are spliced by a second preset method to generate the When scripting the steps of the database table, implement the following steps:

According to the grammar of the database management system used for establishing the database table, a plurality of the subscripts are spliced by the Append method in the StringBuffer class to obtain the initial script for establishing the database table;

The initial script is string-formatted using the ToString method to generate a script for building the database table.

In one embodiment, when the processor 302 implements the step of parsing the Excel file in a preset manner to obtain the table data, the processor 302 specifically implements the following steps:

The table data contained in the Excel file is obtained through the POI package in JAVA or Jxl.jar.

In one embodiment, when the processor 302 implements the syntax according to the database management system used to establish the database table, a plurality of the sub-scripts are spliced by a second preset method to generate the After the steps of the script for the database table, also implement the following steps:

The script that builds the database table is encapsulated using IO streams.

It should be understood that, in this embodiment of the present application, the processor 302 may be a central processing unit (Central Processing Unit, CPU), and the processor 302 may also be other general-purpose processors, digital signal processors (Digital Signal Processor, DSP), application-specific integrated circuits (Application Specific Integrated Circuit, ASIC), off-the-shelf Programmable Gate Array (Field-Programmable Gate Array, FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, and the like. Wherein, the general-purpose processor can be a microprocessor or the processor can also be any conventional processor or the like.

It can be understood by those skilled in the art that all or part of the processes in the methods of the above embodiments can be implemented by a computer program, and the computer program can be stored in a computer-readable storage medium. The computer program is executed by at least one processor in the computer system to implement the flow steps of the above-described method embodiments.

Therefore, the present application also provides a computer-readable storage medium. The computer-readable storage medium may be a non-volatile computer-readable storage medium, and the computer-readable storage medium stores a computer program, and when the computer program is executed by the processor, causes the processor to perform the following steps:

A computer program product, when running on a computer, causes the computer to execute the steps of the method for generating a table building script described in the above embodiments.

The computer-readable storage medium may be an internal storage unit of the aforementioned device, such as a hard disk or a memory of the device. The computer-readable storage medium may also be an external storage device of the device, such as a plug-in hard disk, a smart memory card (Smart Media Card, SMC), a secure digital (Secure Digital, SD) card equipped on the device , Flash card (Flash Card) and so on. Further, the computer-readable storage medium may also include both an internal storage unit of the device and an external storage device.

Those skilled in the art can clearly understand that, for the convenience and brevity of description, for the specific working process of the above-described devices, devices and units, reference may be made to the corresponding processes in the foregoing method embodiments, which will not be repeated here.

The computer-readable storage medium may be various computer-readable storage media that can store program codes, such as a U disk, a removable hard disk, a read-only memory (Read-Only Memory, ROM), a magnetic disk, or an optical disk.

Those of ordinary skill in the art can realize that the units and algorithm steps of each example described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, computer software, or a combination of the two. Interchangeability, the above description has generally described the components and steps of each example in terms of function. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. Skilled artisans may implement the described functionality using different methods for each particular application, but such implementations should not be considered beyond the scope of this application.

In the several embodiments provided in this application, it should be understood that the disclosed apparatus and method may be implemented in other manners. For example, the apparatus embodiments described above are merely illustrative. For example, the division of each unit is only a logical function division, and other division methods may be used in actual implementation. For example, multiple units or components may be combined or may be integrated into another system, or some features may be omitted, or not implemented.

The steps in the method of the embodiment of the present application may be adjusted, combined and deleted in sequence according to actual needs. Units in the apparatus of the embodiment of the present application may be combined, divided, and deleted according to actual needs. In addition, each functional unit in each embodiment of the present application may be integrated into one processing unit, or each unit may exist physically alone, or two or more units may be integrated into one unit.

The integrated unit, if implemented in the form of a software functional unit and sold or used as an independent product, may be stored in a storage medium. Based on this understanding, the technical solutions of the present application are essentially or part of contributions to the prior art, or all or part of the technical solutions can be embodied in the form of software products, and the computer software products are stored in a storage medium , including several instructions to cause an electronic device (which may be a personal computer, a terminal, or a network device, etc.) to execute all or part of the steps of the methods described in the various embodiments of the present application.

The above are only specific implementations of the present application, but the scope of protection disclosed in the present application is not limited to this. Any person skilled in the art can easily think of various equivalents within the technical scope disclosed in the present application. Modifications or substitutions of the present application shall be included within the scope of protection of the present application. Therefore, the protection scope of the present application shall be subject to the protection scope of the claims.

Claims (10)

1. a generation method of table building script, is characterized in that, described method comprises: Acquire an Excel file, the Excel file contains table data required for establishing a database table, and the table data includes a table name required for establishing the database table, a field contained in the database table, and the data type of the field ; Parse the Excel file in a preset manner to obtain the table data; By the first preset method, the table data is correspondingly inserted into the preset syntax format for establishing the database table to obtain a plurality of sub-scripts; According to the syntax of the database management system used for establishing the database table, a plurality of the subscripts are spliced by a second preset method to generate a script for establishing the database table. 2. the generation method of the described table building script according to claim 1, is characterized in that, comprises a plurality of worksheets in described Excel file, before the step that described Excel file is parsed to obtain described table data by preset mode ,Also includes: loop through each worksheet of the Excel file; The step of parsing the Excel file by default to obtain the table data includes: Parse each of the worksheets in a preset manner to obtain table data of a database table corresponding to each of the worksheets. 3. The method for generating a table-building script according to claim 2, wherein the step of parsing each of the worksheets by a preset method to obtain table data of the database table corresponding to each of the worksheets comprises the following steps: : Parse each of the worksheets in a preset manner, and convert each of the worksheets into a two-dimensional array to obtain table data of the database table corresponding to each of the worksheets; The step of correspondingly inserting the table data into a preset syntax format for establishing the database table by the first preset method to obtain a plurality of subscripts includes: Through the first preset method, the table data of the database table corresponding to each of the worksheets is correspondingly inserted into the preset syntax format for establishing the database table to obtain the multiple data corresponding to each of the database tables. a subscript; The step of splicing a plurality of the subscripts to generate the script for establishing the database table by the second preset method according to the grammar of the database management system used for establishing the database table includes: According to the grammar of the database management system used to establish the database table, the multiple sub-scripts corresponding to each of the database tables are spliced separately by the second preset method to generate correspondingly the corresponding database table. script. 4. the generation method of table building script according to claim 1, is characterized in that, described by the first preset method, described table data is correspondingly inserted in the grammatical format that is used to establish described database table preset in order to The steps to obtain multiple subscripts include: Through the Insert method of the StringBuffer class, the table data is correspondingly inserted into the preset SQL syntax format for establishing the database table to obtain multiple SQL subscripts. 5. according to the generation method of the described table building script of claim 4, it is characterized in that, described according to the grammar of the database management system that the described database table is used, by the second preset method a plurality of described sub-scripts are carried out. The steps of splicing to generate a script to build the database table include: According to the grammar of the database management system used for establishing the database table, a plurality of the subscripts are spliced by the Append method in the StringBuffer class to obtain the initial script for establishing the database table; The initial script is string-formatted using the ToString method to generate a script for building the database table. 6. the generation method of the table building script according to claim 1, is characterized in that, the described step of analyzing described Excel file to obtain described table data by preset mode comprises: The table data contained in the Excel file is obtained through the POI package in JAVA or Jxl.jar. 7. The generation method of table building script according to claim 1, is characterized in that, described according to the grammar of the database management system used for establishing described database table, by the second preset method a plurality of described sub-scripts are carried out. After the step of splicing to generate the script for establishing the database table, it also includes: The script that builds the database table is encapsulated using IO streams. 8. a generation device of a table building script, is characterized in that, comprises: The acquisition unit is used to acquire an Excel file, the Excel file contains table data required for establishing a database table, and the table data includes a table name required for establishing the database table, fields contained in the database table and all the data type of the described field; parsing unit for parsing the Excel file by a preset method to obtain the table data; an inserting unit for correspondingly inserting the table data into a preset grammatical format for establishing the database table through a first preset method to obtain a plurality of subscripts; The generating unit is configured to generate a script for establishing the database table by splicing a plurality of the sub-scripts through a second preset method according to the syntax of the database management system used for establishing the database table. 9. A computer device, characterized in that the computer device comprises a memory and a processor connected to the memory; the memory is used for storing a computer program; the processor is used for running the computer program stored in the memory , to execute the steps of the method for generating a table building script according to any one of claims 1-7. 10. A computer-readable storage medium, characterized in that the computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the processor executes any one of claims 1-7. The steps of the generation method of the table building script described in the item.

Images