CN106776962A - A kind of general Excel data import multiple database physical table methods - Google Patents
A kind of general Excel data import multiple database physical table methods Download PDFInfo
- Publication number
- CN106776962A CN106776962A CN201611102064.8A CN201611102064A CN106776962A CN 106776962 A CN106776962 A CN 106776962A CN 201611102064 A CN201611102064 A CN 201611102064A CN 106776962 A CN106776962 A CN 106776962A
- Authority
- CN
- China
- Prior art keywords
- data
- importing
- excel
- import
- database
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 230000008676 import Effects 0.000 title claims abstract description 26
- 238000000034 method Methods 0.000 title claims abstract description 25
- 238000012856 packing Methods 0.000 claims description 6
- 238000009472 formulation Methods 0.000 claims 1
- 239000000203 mixture Substances 0.000 claims 1
- 238000013523 data management Methods 0.000 abstract description 2
- 238000005538 encapsulation Methods 0.000 abstract description 2
- 230000004048 modification Effects 0.000 description 3
- 238000012986 modification Methods 0.000 description 3
- 238000004458 analytical method Methods 0.000 description 2
- 230000008859 change Effects 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
- 230000004044 response Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Multiple database physical table methods are imported the invention discloses a kind of general Excel data, belongs to the data management field of computer ERP software.One Xml file of customization, in Xml files the table of data and the information of row are imported according to the form addition formulated, the information of row matches with the Excel file for needing to import, corresponding SQL statement can be automatically generated when importing data, in importing data to specified database table, while in importing data to multiple database tables.The present invention only needs to configure corresponding Xml files according to the requirement of oneself importing table, the import operation for calling the unified method of encapsulation just to realize to Excel multilists, improves the efficiency of the program of writing, and saves substantial amounts of human and material resources.
Description
Technical field
The present invention relates to the data management field of computer ERP software, specifically a kind of general Excel data are led
Enter multiple database physical table methods.
Background technology
With the development of enterprise and Software Industry, increasing enterprise has been customized different soft according to the business of oneself
Part, arranges, stores substantial amounts of basic data and business datum.Enterprise needs these data preparations, typing when ERP reaches the standard grade
To in ERP system；But at present major part data can only manual entry, workload is big and easily error.Accordingly, it would be desirable to find one
Kind easily and efficiently data inputting scheme will become highly significant solving this problem.
Traditional Excel data import treatment, it is necessary to according in system document train value number import Excel fixing
The row content of file, number of columns.And, after after online implementing, if certain is arranged during client needs to increase or delete Excel file
Value, it is necessary to system developer makes corresponding modification treatment to File importer according to the demand of client.Traditional
Excel data importing treatment can only import a database physical table, and multiple importings can only be developed when importing multiple physical tables
Method, wastes time and energy.Therefore traditional Excel file importing treatment, it is impossible to accomplish fast and accurate customer in response demand.
The content of the invention
Technical assignment of the invention is directed to above weak point, there is provided a kind of general Excel data import many numbers
According to storehouse physical table method, using the title and attribute of customized Xml document analysis specific node, obtain importing needed for data
Table name, field name, type, length and need verify data accuracy regular expression, so as to import Excel data
Verified, collected arrangement, realized the importing of database multi-list.
The technical solution adopted for the present invention to solve the technical problems is：
A kind of general Excel data import multiple database physical table methods, customize an Xml file, are pressed in Xml files
The table of data and the information of row are imported according to the form addition formulated, the information of row matches with the Excel file for needing to import,
Corresponding SQL statement can be automatically generated when importing data, in importing data to specified database table, while importing data to
In multiple database tables, the method realizes that step is as follows：
Configure the Xml of specific node title, table name, field name, type, length needed for for importing table and need checking
The regular expression of data accuracy；
The information needed for importing is parsed using Xml；
By the finish message data to be imported for parsing；
Database table is imported by the data genaration SQL statement for arranging；
Wherein, by configuring the Xml files of specific node, obtain table name needed for Excel data are imported into database, field with
And corresponding constraint.
Further, unified method for packing, for the Excel data that different configuration information arrangements is imported, and according to
Configuration information retrieves incongruent data and provides prompting.
Further, unified method for packing, sorts out correct data and imports database for different configuration informations.
Compared to the prior art a kind of general Excel data of the invention import multiple database physical table methods, tool
There is following beneficial effect：
Using the title and attribute of customized Xml document analysis specific node, table name, the field needed for importing data are obtained
Name, type, length and need verify data accuracy regular expression, so as to import Excel data verified,
Arrangement is collected, the importing of database multi-list is realized；Only need to configure corresponding Xml files according to the requirement of oneself importing table, adjust
The import operation to Excel multilists can be just realized with the unified method of encapsulation, the efficiency of the program of writing is improve, saved
Substantial amounts of human and material resources；
If the content that Excel is imported in file changes, it is only necessary to change the respective column and database in Xml files
Corresponding row in table, any modification treatment is made to importing program without system developer；In the project implementation process, when
When running into client's Excel importing contents and changing, project implementation personnel pass through the import plan, it becomes possible to accomplish to need client
Fast reaction, the precisely execution asked.
Specific embodiment
With reference to specific embodiment, the invention will be further described.
A kind of general Excel data import multiple database physical table methods, by customizing an Xml file, in Xml
The table of data and the information of row are imported according to the form addition formulated in file, the information of row will be with the Excel for needing to import
File matches, and corresponding SQL statement can be automatically generated when importing data, in importing data to specified database table, can
With according to actual needs while in importing data to multiple database tables.
Meanwhile, if the content that Excel is imported in file is when changing, it is only necessary to change respective column in Xml files,
Row corresponding with database table, any modification treatment is made to importing program without system developer.
So, in the project implementation process, when running into client's Excel importing contents and changing, project implementation personnel
By the import plan, it becomes possible to accomplish the fast reaction to customer demand, precisely perform.
The method realizes that step is as follows：
Configure the Xml of specific node title, table name, field name, type, length needed for for importing table and need checking
The regular expression of data accuracy；
The information needed for importing is parsed using Xml；
By the finish message data to be imported for parsing；
Database table is imported by the data genaration SQL statement for arranging；
Wherein, by configuring the Xml files of specific node, obtain table name needed for Excel data are imported into database, field with
And corresponding constraint.
Unified method for packing, the Excel data for importing is arranged for different configuration informations, and examine according to configuration information
Rope goes out incongruent data and provides prompting.
Unified method for packing, sorts out correct data and imports database for different configuration informations.
By specific embodiment above, the those skilled in the art can readily realize the present invention.But should
Work as understanding, the present invention is not limited to above-mentioned specific embodiment.On the basis of disclosed embodiment, the technical field
Technical staff can be combined different technical characteristics, so as to realize different technical schemes.
In addition to the technical characteristic described in specification, the known technology of those skilled in the art is.
Claims (3)
1. a kind of general Excel data import multiple database physical table methods, it is characterised in that one Xml file of customization,
The information of the table and row that to import data, information and the needs importing of row are added according to the form of formulation in Xml files
Excel file matches, and corresponding SQL statement can be automatically generated when importing data, imports data to specified database table
In, while in importing data to multiple database tables, the method realizes that step is as follows：
Configure the Xml of specific node title, table name, field name, type, length needed for for importing table and need checking
The regular expression of data accuracy；
The information needed for importing is parsed using Xml；
By the finish message data to be imported for parsing；
Database table is imported by the data genaration SQL statement for arranging；
Wherein, by configuring the Xml files of specific node, obtain table name needed for Excel data are imported into database, field with
And corresponding constraint.
2. a kind of general Excel data according to claim 1 import multiple database physical table methods, and its feature exists
In unified method for packing, the Excel data for importing are arranged for different configuration informations, and retrieve not according to configuration information
The data that meet simultaneously provide prompting.
3. a kind of general Excel data according to claim 1 import multiple database physical table methods, and its feature exists
In unified method for packing, sort out correct data for different configuration informations and import database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611102064.8A CN106776962A (en) | 2016-12-05 | 2016-12-05 | A kind of general Excel data import multiple database physical table methods |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611102064.8A CN106776962A (en) | 2016-12-05 | 2016-12-05 | A kind of general Excel data import multiple database physical table methods |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106776962A true CN106776962A (en) | 2017-05-31 |
Family
ID=58883242
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201611102064.8A Pending CN106776962A (en) | 2016-12-05 | 2016-12-05 | A kind of general Excel data import multiple database physical table methods |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106776962A (en) |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107909134A (en) * | 2017-12-14 | 2018-04-13 | 深圳市兆驰数码科技股份有限公司 | A kind of method, apparatus and system of bar code generation and printing |
| CN108133341A (en) * | 2017-12-21 | 2018-06-08 | 郑州云海信息技术有限公司 | A kind of generation method and system of the material alternative condition based on ERP system |
| CN108153550A (en) * | 2017-06-16 | 2018-06-12 | 广东网金数据服务有限公司 | A kind of Excel data lead-in methods, device and user terminal |
| WO2019000698A1 (en) * | 2017-06-25 | 2019-01-03 | 平安科技（深圳）有限公司 | Method and system for generating sql statement, electronic apparatus and readable storage medium |
| CN109241074A (en) * | 2018-09-28 | 2019-01-18 | 中国平安财产保险股份有限公司 | Check data automatic processing method, device, computer equipment and storage medium |
| CN109726284A (en) * | 2018-12-07 | 2019-05-07 | 成都品果科技有限公司 | A kind of versatile data analysing method |
| WO2019085354A1 (en) * | 2017-11-01 | 2019-05-09 | 平安科技（深圳）有限公司 | Excel system interface-based database linkage method, electronic device, and storage medium |
| CN109947832A (en) * | 2019-01-29 | 2019-06-28 | 平安科技（深圳）有限公司 | EXCEL tables of data is generated to method, apparatus, terminal and the storage medium of SQL file |
| CN110019485A (en) * | 2018-02-07 | 2019-07-16 | 中国平安人寿保险股份有限公司 | A kind of product data storage method, terminal device and storage medium |
| CN112162994A (en) * | 2020-09-08 | 2021-01-01 | 杭州涂鸦信息技术有限公司 | SQL (structured query language) generation method and system for system entry data |
| CN112835901A (en) * | 2021-02-01 | 2021-05-25 | 长沙市到家悠享家政服务有限公司 | File storage method and device, computer equipment and computer readable storage medium |
| CN113420045A (en) * | 2021-07-21 | 2021-09-21 | 中睿信数字技术有限公司 | Method and system for constructing technical and tactical model based on interactive analysis |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2007094570A (en) * | 2005-09-27 | 2007-04-12 | Nomura Research Institute Ltd | Database utilization system |
| CN103150380A (en) * | 2013-03-13 | 2013-06-12 | 河海大学 | Table format customizable Excel table analysis method |
| CN103744982A (en) * | 2014-01-15 | 2014-04-23 | 北京神州普惠科技股份有限公司 | Method for importing Excel data into database |
| CN104572666A (en) * | 2013-10-15 | 2015-04-29 | 镇江雅迅软件有限责任公司 | Method for analyzing and importing Excel into database in batch based on Jxl |
-
2016
- 2016-12-05 CN CN201611102064.8A patent/CN106776962A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2007094570A (en) * | 2005-09-27 | 2007-04-12 | Nomura Research Institute Ltd | Database utilization system |
| CN103150380A (en) * | 2013-03-13 | 2013-06-12 | 河海大学 | Table format customizable Excel table analysis method |
| CN104572666A (en) * | 2013-10-15 | 2015-04-29 | 镇江雅迅软件有限责任公司 | Method for analyzing and importing Excel into database in batch based on Jxl |
| CN103744982A (en) * | 2014-01-15 | 2014-04-23 | 北京神州普惠科技股份有限公司 | Method for importing Excel data into database |
Non-Patent Citations (1)
| Title |
|---|
| 舒清录: "基于.NET的异构数据源数据迁移技术", 《计算机技术与发展》 * |
Cited By (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108153550A (en) * | 2017-06-16 | 2018-06-12 | 广东网金数据服务有限公司 | A kind of Excel data lead-in methods, device and user terminal |
| WO2019000698A1 (en) * | 2017-06-25 | 2019-01-03 | 平安科技（深圳）有限公司 | Method and system for generating sql statement, electronic apparatus and readable storage medium |
| WO2019085354A1 (en) * | 2017-11-01 | 2019-05-09 | 平安科技（深圳）有限公司 | Excel system interface-based database linkage method, electronic device, and storage medium |
| CN107909134A (en) * | 2017-12-14 | 2018-04-13 | 深圳市兆驰数码科技股份有限公司 | A kind of method, apparatus and system of bar code generation and printing |
| CN108133341A (en) * | 2017-12-21 | 2018-06-08 | 郑州云海信息技术有限公司 | A kind of generation method and system of the material alternative condition based on ERP system |
| CN110019485A (en) * | 2018-02-07 | 2019-07-16 | 中国平安人寿保险股份有限公司 | A kind of product data storage method, terminal device and storage medium |
| CN109241074A (en) * | 2018-09-28 | 2019-01-18 | 中国平安财产保险股份有限公司 | Check data automatic processing method, device, computer equipment and storage medium |
| CN109241074B (en) * | 2018-09-28 | 2023-09-26 | 中国平安财产保险股份有限公司 | Automatic auditing data processing method and device, computer equipment and storage medium |
| CN109726284A (en) * | 2018-12-07 | 2019-05-07 | 成都品果科技有限公司 | A kind of versatile data analysing method |
| CN109947832A (en) * | 2019-01-29 | 2019-06-28 | 平安科技（深圳）有限公司 | EXCEL tables of data is generated to method, apparatus, terminal and the storage medium of SQL file |
| CN112162994A (en) * | 2020-09-08 | 2021-01-01 | 杭州涂鸦信息技术有限公司 | SQL (structured query language) generation method and system for system entry data |
| CN112835901A (en) * | 2021-02-01 | 2021-05-25 | 长沙市到家悠享家政服务有限公司 | File storage method and device, computer equipment and computer readable storage medium |
| CN113420045A (en) * | 2021-07-21 | 2021-09-21 | 中睿信数字技术有限公司 | Method and system for constructing technical and tactical model based on interactive analysis |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106776962A (en) | A kind of general Excel data import multiple database physical table methods | |
| US11216302B2 (en) | Modifying task dependencies at worker nodes using precompiled libraries | |
| CN104133772B (en) | Automatic test data generation method | |
| US8943059B2 (en) | Systems and methods for merging source records in accordance with survivorship rules | |
| CN104572895B (en) | MPP databases and Hadoop company-datas interoperability methods, instrument and implementation method | |
| US8782081B2 (en) | Query template definition and transformation | |
| CN104965735B (en) | Device for generating upgrading SQL scripts | |
| CN110069246A (en) | The plateform system and its application that a kind of Java Web application is quickly developed | |
| CN110196971A (en) | Online document edit methods, device, terminal device and storage medium | |
| CN111078702B (en) | SQL sentence classification management and unified query method and device | |
| CN105868204A (en) | Method and apparatus for converting script language SQL of Oracle | |
| CN102426587B (en) | Method for customizing and inquiring heterogeneous BOM (Bill of Materiel) based on complex product | |
| US10614126B2 (en) | Textual query editor for graph databases that performs semantic analysis using extracted information | |
| CN103838672A (en) | Automated testing method and device for all-purpose financial statements | |
| CN106445536B (en) | Automatic business design management system | |
| US20140344817A1 (en) | Converting a hybrid flow | |
| CN106648587A (en) | Annotation-based Web application code generation method | |
| CN104598635A (en) | Automatic complex document generating method based on XML (Extensive Markup Language) description | |
| CN104715032A (en) | Mapping system and method of Chinese and English table name and field name of report system | |
| CN112364024B (en) | Control method and device for automatic comparison of table data in batches | |
| CN105279269A (en) | SQL generating method and system for supporting table free association | |
| CN106815366A (en) | A kind of method and system of Mass production data | |
| CN109284469B (en) | Webpage development framework | |
| CN107193549A (en) | Webpage quick development method based on metadata | |
| CN112667598B (en) | Data model rapid construction system based on business demand change |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170531 |
|
| RJ01 | Rejection of invention patent application after publication |