CN117952074A - Data importing method, device and medium - Google Patents

Abstract

The application discloses a data importing method, equipment and a medium, wherein the method comprises the following steps: determining preset import parameters, and determining an import template according to the import parameters; determining an import entity class according to the import parameters so as to receive import data through the import entity class; traversing the table through the import template to obtain import data, and mapping the import data through the import entity class to enable the import data to be assigned to the field of the import entity class, thereby completing data import. The method and the system are configured based on the excel template, and the tidied data is automatically imported into the system by the user, so that not only is the workload of the developer saved, but also the time of the user is saved, and the use efficiency and the data acquisition efficiency are greatly improved.

Description

Data importing method, device and medium

Technical Field

The present application relates to the field of computer technologies, and in particular, to a data importing method, device, and medium.

Background

With the continuous update of electronic applications, more and more people depend on the internet, the internet brings great convenience to our lives, various functions are continuously powerful, the data volume is continuously increased, and users bring various demands for convenience. For the function of importing data on a page, the single data importing method commonly used in the market has low efficiency and is very inconvenient to use.

Disclosure of Invention

In order to solve the above problems, the present application proposes a data importing method, including: determining preset import parameters, and determining an import template according to the import parameters; determining an import entity class according to the import parameters so as to receive import data through the import entity class; traversing the table through the import template to obtain the import data, and mapping the import data through the import entity class to enable the import data to be assigned to the fields of the import entity class, so that data import is completed.

In one example, before traversing the table through the import template, the method further comprises: determining a receiving sequence according to the import parameters, and configuring the import entity class according to the receiving sequence; determining a preset import input stream and determining an import object, wherein the import object comprises the table; and determining an attribute field according to the configured import entity class so as to assign the data of the import object to the attribute field.

In one example, traversing the table through the import template specifically includes: determining a start line and an end line of the table, and performing cyclic traversal on the table according to the start line and the end line.

In one example, the method further comprises: and determining a plurality of rows of the table, determining a plurality of cells corresponding to the rows, and performing cycle traversal on the cells.

In one example, the method further comprises: determining entity class attributes of the imported entity class, and determining cell formats corresponding to the entity class attributes according to the imported template; and acquiring the numerical value of the corresponding cell according to the cell format.

In one example, the cell format includes, but is not limited to, a date format, a number type, a string type.

In one example, the method further comprises: and assigning the numerical value to an attribute field of the import entity class.

In one example, the import parameters include, but are not limited to, title, column name, cell format.

On the other hand, the application also provides a data importing device, which comprises: at least one processor; and a memory communicatively coupled to the at least one processor; wherein the memory stores instructions executable by the at least one processor to enable the data importing apparatus to perform: determining preset import parameters, and determining an import template according to the import parameters; determining an import entity class according to the import parameters so as to receive import data through the import entity class; traversing the table through the import template to obtain the import data, and mapping the import data through the import entity class to enable the import data to be assigned to the fields of the import entity class, so that data import is completed.

In another aspect, the present application also provides a non-volatile computer storage medium storing computer-executable instructions configured to: determining preset import parameters, and determining an import template according to the import parameters; determining an import entity class according to the import parameters so as to receive import data through the import entity class; traversing the table through the import template to obtain the import data, and mapping the import data through the import entity class to enable the import data to be assigned to the fields of the import entity class, so that data import is completed.

The method and the system are configured based on the excel template, and the tidied data is automatically imported into the system by the user, so that not only is the workload of the developer saved, but also the time of the user is saved, and the use efficiency and the data acquisition efficiency are greatly improved.

Drawings

The accompanying drawings, which are included to provide a further understanding of the application and are incorporated in and constitute a part of this specification, illustrate embodiments of the application and together with the description serve to explain the application and do not constitute a limitation on the application. In the drawings:

FIG. 1 is a flow chart of a data importing method according to an embodiment of the present application;

Fig. 2 is a schematic diagram of a data importing apparatus according to an embodiment of the present application.

Detailed Description

In order to make the objects, technical solutions and advantages of the present application more apparent, the technical solutions of the present application will be clearly and completely described below with reference to specific embodiments of the present application and corresponding drawings. It will be apparent that the described embodiments are only some, but not all, embodiments of the application. All other embodiments, which can be made by those skilled in the art based on the embodiments of the application without making any inventive effort, are intended to be within the scope of the application.

The following describes in detail the technical solutions provided by the embodiments of the present application with reference to the accompanying drawings.

Today, internet programs are exploded, various system layers are endless, and basically each system has the functional operation of data input. When the data volume to be recorded is relatively large, the recording efficiency of the page system is low, each piece of data is required to be stored and recorded again, and if the recording data repetition rate is relatively high, the operation on the page is inconvenient for users. Although various online software systems are convenient for our lives, like a system with a larger data volume, the process of data acquisition is troublesome, for example: the data is collected off line, and then the data is manually imported into the database, for example, a user inputs the data through a system function, so that time consumption is long in any mode, and repeated workload is high.

As shown in fig. 1, in order to solve the above problem, a data importing method provided in an embodiment of the present application includes:

S101, determining preset import parameters, and determining an import template according to the import parameters.

An import template is configured, an excel file is created, and the field names needing to be imported are configured to each column, wherein the import parameters comprise a title, a column name and the like. Template configuration according to import parameters is a preparation for the import method. If the field is in the form of a drop down list, data validity is also configured, etc. And (3) writing an import method by Java, acquiring data in the excel file into a Java entity class list form, and storing the Java entity class list form in a database.

S102, determining an import entity class according to the import parameters so as to receive import data through the import entity class.

And creating an imported entity class of the imported data, and defining the received entity class according to the sequence of the excel template configuration, wherein the entity class attribute needs to be in one-to-one correspondence with the template sequence.

The method comprises the steps of obtaining a file import input stream, creating a Workbook object, and reading data from the file input stream, wherein the specific code is Workbook wb=workbook factor. Workbook is a class in the Apache POI library that is used to represent an Excel Workbook. Work bookFactory is a factory class in the Apache POI library for creating different types of workbook objects, such as XLS and XLSX formatted workbooks. file is a file object, which is Exc el file to read. getInputStream () is one method of the File class that returns an input stream for reading the contents of the File. The function of the code is therefore to take an input stream from a given file object and then create a corresponding Workbook object using WorkbookFactory. This Workbook object can be used to read and manipulate data in an Excel file.

The method comprises the steps of obtaining an excel Sheet page to be imported, obtaining a first Sheet object of a worksheet in a workbook, and obtaining the first excel Sheet by default. The specific code is SHEET SHEET =wb.getscheett (0). Sheet is a class in the Apache POI library that is used to represent Excel worksheets. wb is a previously created Workbook object representing the entire Excel Workbook. GETSHEETAT (0) is a method of the Workbook class for obtaining worksheets at specified indices. The index starts with 0, so 0 represents the first worksheet. The function of the code is therefore to obtain a reference to the first worksheet from a given Workbook object and assign it to the sheet variable. In this way, we can use sheet objects to access and manipulate the data in the worksheet.

The attribute fields of the receiving entity class are acquired by using the java reflection principle, all Field fields stated in one class are acquired, and corresponding values are attached to each attribute in sequence. The specific code is Field [ ] fields=classname. The corresponding Class object is first obtained by a Class name, here it is assumed that this object is assigned a className. Then, all fields declared in this class are obtained using the GETDECLAREDFIELDS () method. This method returns a Field array that contains all the fields declared in the class. Through this array, related information of each field, such as the name, type, modifier, etc., of the field can be acquired. This information may be used to perform operations such as modifying the values of the fields, obtaining the values of the fields, etc. The GETDECLAREDFIELDS () method can only get the fields declared in the current class, but cannot get the fields declared in the parent class or interface. If a field in the parent class or interface needs to be acquired, the GETFIELDS () method can be used.

S103, traversing the table through the import template to obtain the import data, and mapping the import data through the import entity class to enable the import data to be assigned to the field of the import entity class, so that data import is completed.

The java code part is compiled, wherein the java code part is divided into specific 4 small steps, firstly, a sheet page is cycled to obtain data rows, each row is recycled to obtain cell data values, an entity class attribute field is recycled, and the obtained cell values are assigned to the entity class attribute field. And circularly traversing the data in the sheet page, defining a template data initial line, wherein the initial line is generally defined as a fixed value, and then obtaining the line number of the last piece of data of the working page according to sheet. The row data in the worksheet is traversed with specific codes for (int i= startRowIndex; i < =sheet. Getlastrownum (); i++) { }. The start row index startRowIndex indicates from which row to start traversing. The index of the last row of the worksheet is obtained using the sheet. The condition of the loop is i < = sheet. Each iteration of the loop, the value of i will increase by 1, indicating a traversal to the next row. Within the loop block, some operations may be performed on each row, such as obtaining a value of a cell, modifying data of a cell, and so on. The function of the code is to traverse each row of data of the worksheet starting from the start row.

Each cell in each row of data, i.e. column data in the worksheet, is circularly traversed, with a specific code for (int j= firstColumnIndex; j < = lastColumnIndex; j++) { }. A start column index firstColumnIndex and a last column index lastColumnIndex, which represent the beginning of a traversal from which column and the end of a traversal to which column. The condition of the loop is j < = lastColumnIndex, i.e. the current column index is equal to or less than the index of the last column. Each iteration of the loop, the value of j will increase by 1, indicating a traversal to the next column. Within the loop block, some operations may be performed on each column, such as obtaining a value of a cell, modifying data of a cell, and so on. The function of the code is to traverse each column of data of the worksheet starting from the start column. Judging the type of each column of values in the cycle according to the service scene requirement, wherein the type is a cell format configured in an excel template, and acquiring values in different formats according to the type, for example: date format, number type, string type.

And assigning the obtained value to the entity class, circularly traversing the received entity class attribute array, and assigning the obtained value to the corresponding attribute field.

And after the processed data are returned, the processed data are inserted into the database in batches in the form of entity class lists.

The method for importing the template based on excel is finished, and can be realized by adding and deleting steps on the basis, so that the method is not limited to one implementation mode and can be expanded according to the thought.

As shown in fig. 2, the embodiment of the present application further provides a data importing apparatus, including:

at least one processor; and

A memory communicatively coupled to the at least one processor; wherein,

The memory stores instructions executable by the at least one processor to enable a data importing device to perform:

determining preset import parameters, and determining an import template according to the import parameters;

determining an import entity class according to the import parameters so as to receive import data through the import entity class;

traversing the table through the import template to obtain the import data, and mapping the import data through the import entity class to enable the import data to be assigned to the fields of the import entity class, so that data import is completed.

The embodiment of the application also provides a nonvolatile computer storage medium, which stores computer executable instructions, wherein the computer executable instructions are configured to:

determining preset import parameters, and determining an import template according to the import parameters;

determining an import entity class according to the import parameters so as to receive import data through the import entity class;

traversing the table through the import template to obtain the import data, and mapping the import data through the import entity class to enable the import data to be assigned to the fields of the import entity class, so that data import is completed.

In the 90 s of the 20 th century, improvements to one technology could clearly be distinguished as improvements in hardware (e.g., improvements to circuit structures such as diodes, transistors, switches, etc.) or software (improvements to the process flow). However, with the development of technology, many improvements of the current method flows can be regarded as direct improvements of hardware circuit structures. Designers almost always obtain corresponding hardware circuit structures by programming improved method flows into hardware circuits. Therefore, an improvement of a method flow cannot be said to be realized by a hardware entity module. For example, a programmable logic device (Programmable Logic Device, PLD) (e.g., field programmable gate array (Field Programmable GATE ARRAY, FPGA)) is an integrated circuit whose logic functions are determined by user programming of the device. A designer programs to "integrate" a digital system onto a PLD without requiring the chip manufacturer to design and fabricate application-specific integrated circuit chips. Moreover, nowadays, instead of manually manufacturing integrated circuit chips, such programming is mostly implemented with "logic compiler (logic compiler)" software, which is similar to the software compiler used in program development and writing, and the original code before being compiled is also written in a specific programming language, which is called hardware description language (Hardware Description Language, HDL), but HDL is not just one, but a plurality of kinds, such as ABEL(Advanced Boolean Expression Language)、AHDL(Altera Hardware Description Language)、Confluence、CUPL(Cornell University Programming Language)、HDCal、JHDL(Java Hardware Description Language)、Lava、Lola、MyHDL、PALASM、RHDL(Ruby Hardware Description Language), and VHDL (Very-High-SPEED INTEGRATED Circuit Hardware Description Language) and Verilog are currently most commonly used. It will also be apparent to those skilled in the art that a hardware circuit implementing the logic method flow can be readily obtained by merely slightly programming the method flow into an integrated circuit using several of the hardware description languages described above.

The controller may be implemented in any suitable manner, for example, the controller may take the form of, for example, a microprocessor or processor and a computer readable medium storing computer readable program code (e.g., software or firmware) executable by the (micro) processor, logic gates, switches, application SPECIFIC INTEGRATED Circuits (ASICs), programmable logic controllers, and embedded microcontrollers, examples of controllers include, but are not limited to, the following microcontrollers: ARC 625D, atmel AT91SAM, microchip PIC18F26K20, and Silicone Labs C8051F320, the memory controller may also be implemented as part of the control logic of the memory. Those skilled in the art will also appreciate that, in addition to implementing the controller in a pure computer readable program code, it is well possible to implement the same functionality by logically programming the method steps such that the controller is in the form of logic gates, switches, application specific integrated circuits, programmable logic controllers, embedded microcontrollers, etc. Such a controller may thus be regarded as a kind of hardware component, and means for performing various functions included therein may also be regarded as structures within the hardware component. Or even means for achieving the various functions may be regarded as either software modules implementing the methods or structures within hardware components.

The system, apparatus, module or unit set forth in the above embodiments may be implemented in particular by a computer chip or entity, or by a product having a certain function. One typical implementation is a computer. In particular, the computer may be, for example, a personal computer, a laptop computer, a cellular telephone, a camera phone, a smart phone, a personal digital assistant, a media player, a navigation device, an email device, a game console, a tablet computer, a wearable device, or a combination of any of these devices.

For convenience of description, the above devices are described as being functionally divided into various units, respectively. Of course, the functions of each element may be implemented in one or more software and/or hardware elements when implemented in the present specification.

The embodiments of the present application are described in a progressive manner, and the same and similar parts of the embodiments are all referred to each other, and each embodiment is mainly described in the differences from the other embodiments. In particular, for the apparatus and medium embodiments, the description is relatively simple, as it is substantially similar to the method embodiments, with reference to the section of the method embodiments being relevant.

The devices and media provided in the embodiments of the present application are in one-to-one correspondence with the methods, so that the devices and media also have similar beneficial technical effects as the corresponding methods, and since the beneficial technical effects of the methods have been described in detail above, the beneficial technical effects of the devices and media are not repeated here.

It will be appreciated by those skilled in the art that embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.

The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.

These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.

These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.

In one typical configuration, a computing device includes one or more processors (CPUs), input/output interfaces, network interfaces, and memory.

The memory may include volatile memory in a computer-readable medium, random Access Memory (RAM) and/or nonvolatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). Memory is an example of computer-readable media.

Computer readable media, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of storage media for a computer include, but are not limited to, phase change memory (PRAM), static Random Access Memory (SRAM), dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), read Only Memory (ROM), electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium, which can be used to store information that can be accessed by a computing device. Computer-readable media, as defined herein, does not include transitory computer-readable media (transmission media), such as modulated data signals and carrier waves.

It should also be noted that the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises an element.

The foregoing is merely exemplary of the present application and is not intended to limit the present application. Various modifications and variations of the present application will be apparent to those skilled in the art. Any modification, equivalent replacement, improvement, etc. which come within the spirit and principles of the application are to be included in the scope of the claims of the present application.

Claims (10)

1.A data importing method, comprising:

determining preset import parameters, and determining an import template according to the import parameters;

determining an import entity class according to the import parameters so as to receive import data through the import entity class;

traversing the table through the import template to obtain the import data, and mapping the import data through the import entity class to enable the import data to be assigned to the fields of the import entity class, so that data import is completed.

2. The method of claim 1, wherein prior to traversing the form through the import template, the method further comprises:

determining a receiving sequence according to the import parameters, and configuring the import entity class according to the receiving sequence;

Determining a preset import input stream and determining an import object, wherein the import object comprises the table;

And determining an attribute field according to the configured import entity class so as to assign the data of the import object to the attribute field.

3. The method according to claim 2, characterized in that traversing the form by the import template comprises:

Determining a start line and an end line of the table, and performing cyclic traversal on the table according to the start line and the end line.

4. The method according to claim 1, wherein the method further comprises:

and determining a plurality of rows of the table, determining a plurality of cells corresponding to the rows, and performing cycle traversal on the cells.

5. The method according to claim 4, wherein the method further comprises:

determining entity class attributes of the imported entity class, and determining cell formats corresponding to the entity class attributes according to the imported template;

And acquiring the numerical value of the corresponding cell according to the cell format.

6. The method of claim 5, wherein the cell format includes, but is not limited to, date format, number type, string type.

7. The method of claim 5, wherein the method further comprises:

And assigning the numerical value to an attribute field of the import entity class.

8. The method of claim 1, wherein the import parameters include, but are not limited to, title, column name, cell format.

9. A data importing apparatus, comprising:

at least one processor; and

A memory communicatively coupled to the at least one processor; wherein,

The memory stores instructions executable by the at least one processor to enable the data importing device to perform:

determining preset import parameters, and determining an import template according to the import parameters;

determining an import entity class according to the import parameters so as to receive import data through the import entity class;

traversing the table through the import template to obtain the import data, and mapping the import data through the import entity class to enable the import data to be assigned to the fields of the import entity class, so that data import is completed.

10. A non-transitory computer storage medium storing computer-executable instructions, the computer-executable instructions configured to:

determining preset import parameters, and determining an import template according to the import parameters;

determining an import entity class according to the import parameters so as to receive import data through the import entity class;

traversing the table through the import template to obtain the import data, and mapping the import data through the import entity class to enable the import data to be assigned to the fields of the import entity class, so that data import is completed.