CN110347985A - Method, apparatus, computer equipment and the storage medium that table generates - Google Patents
Method, apparatus, computer equipment and the storage medium that table generates Download PDFInfo
- Publication number
- CN110347985A CN110347985A CN201910463805.2A CN201910463805A CN110347985A CN 110347985 A CN110347985 A CN 110347985A CN 201910463805 A CN201910463805 A CN 201910463805A CN 110347985 A CN110347985 A CN 110347985A
- Authority
- CN
- China
- Prior art keywords
- code
- template
- data
- parsing
- gauge outfit
- 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.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Stored Programmes (AREA)
Abstract
Method, apparatus, computer equipment and the storage medium that a kind of table provided herein generates obtain the pre- gauge outfit data and the corresponding field name of each gauge outfit data for importing data template；According to the parsing code of gauge outfit data described in the gauge outfit data acquisition, and according to the field name, generate preset service template builds table script and first code；By by it is described build table script and the first code storage at specified application site, instruction is imported to form the data of the preset service template, and the parsing code and preset general character code combination are generated to the service code of the preset service template；The data for triggering the preset service template import instruction, the preset service template table needed for being generated by the service code.Corresponding electrical form importing is carried out without developing new importing template code every time, realizes that the generation of table, the optimization of O&M process improve the development efficiency of import feature, save the cost.
Description
Technical field
This application involves field of computer technology, in particular to method, apparatus that a kind of table generates, computer equipment and
Storage medium.
Background technique
The data import feature of existing system, since the data template of importing is different, it is often necessary to according to each specific
The data template of importing demand is developed again, and to realize the importing of each data template, but data import every time
Primary corresponding import feature need to be developed, the wasting of resources is caused.
Summary of the invention
The main purpose of the application is to provide a kind of method, apparatus, computer equipment and storage medium that table generates, purport
Convenient for generating table, development cost is saved.
To achieve the above object, this application provides a kind of methods that table generates, comprising the following steps:
Obtain the pre- gauge outfit data and the corresponding field name of each gauge outfit data for importing data template；
According to the parsing code of gauge outfit data described in the gauge outfit data acquisition, wherein the parsing code is according to institute
The program in machine code that the particular content and position for stating gauge outfit data generate；And according to the field name, generate preset service mould
Plate builds table script and first code, wherein the table format built table script and be used to create the preset service template,
The first code is the parsing code of the field name；
By by it is described build table script and the first code storage at specified application site, it is described pre- to be formed
If the data of service moulding plate import instruction, and the parsing code and preset general character code combination are generated the default clothes
The service code for template of being engaged in；
The data for triggering the preset service template import instruction, the preset service needed for being generated by the service code
Template table.
In one embodiment, the step of parsing code of the gauge outfit data according to the gauge outfit data acquisition, packet
It includes:
Read the table field of the pre- each table for importing gauge outfit data described in data template and each described
The position of table field；
Each table field is parsed by API Function, it is corresponding to obtain each table field
First parsing code；
Code, all first parsing generations are parsed according to all table fields corresponding described first got
Code forms the parsing code of the gauge outfit data.
In one embodiment, the parsing code and preset general character code combination are generated into the preset service template
The step of service code, comprising:
Receive the preset general character code of third party, wherein the general character code refers to the data template of multiple pre- importings
Identical code in importing process；
The parsing code is inserted into a designated order in the general character code, to form the preset service template
Service code, the service code are the code for generating electrical form content.
In one embodiment, described according to the field name, generate preset service template builds table script and the first generation
The step of code, comprising:
The file of the pre- front end page code for importing data template is got, the first file for generating specified format is deposited
It stores up in result list, and gets the file of preset control template code, generate the second file storage of java format
Into the result list, wherein the control template is for handling the general character code to obtain the file of java format, institute
State the first file and second file be used to form the pre- importing data template general character template；
After getting the pre- importing data template, read each described in the pre- gauge outfit data for importing data template
Each field name of table；
Parse the field name generate it is corresponding it is described build table script and first code, and by it is described build table script and
First code is stored in the result list, and table script and the first code of building is for importing and forming required institute
State preset service template.
In one embodiment, described to build table script and first code storage to specified application site for described
Place, to form the step of data of the preset service template import instruction, comprising:
Establish the incidence relation of the first code Yu the field name；
The table script of building is stored in specified directory, and the first code of incidence relation will be present and be stored in
In presetting database, instruction is imported to form the data of the preset service template.
Present invention also provides the devices that a kind of table generates, comprising:
First obtains module, for obtaining the pre- gauge outfit data and the corresponding word of each gauge outfit data for importing data template
Section name；
Second obtains module, the parsing code for the gauge outfit data according to the gauge outfit data acquisition, wherein described
Parsing code is the program in machine code generated according to the particular content of the gauge outfit data and position；And according to the field
Name, generate preset service template builds table script and first code, wherein the table script of building is for creating the default clothes
The table format for template of being engaged in, the first code are the parsing code of the field name；
First generation module, for by building table script and first code storage to specified using position for described
Place is set, imports instruction to form the data of the preset service template, and by the parsing code and preset general character code
The service code of preset service template described in combination producing；
Second generation module, the data for triggering the preset service template import instruction, pass through the service code
Preset service template table needed for generating.
In one embodiment, the second acquisition module includes:
Reading unit, for read it is described it is pre- import data template in gauge outfit data each table table field and
The position of each table field；
Resolution unit obtains each table for parsing by API Function to each table field
The corresponding first parsing code of lattice field；
Acquiring unit owns for parsing code according to all table fields corresponding described first got
The first parsing code forms the parsing code of the gauge outfit data.
In one embodiment, first generation module includes:
Receiving unit, for receiving the preset general character code of third party, wherein the general character code refers to multiple pre- lead
Identical code in the data template importing process entered；
Assembled unit, for the parsing code to be inserted into a designated order in the general character code, described in being formed
The service code of preset service template, the service code are the code for generating electrical form content.
The application also provides a kind of computer equipment, including memory and processor, is stored with calculating in the memory
The step of machine program, the processor realizes any of the above-described the method when executing the computer program.
The application also provides a kind of computer storage medium, is stored thereon with computer program, the computer program quilt
The step of processor realizes method described in any of the above embodiments when executing.
Method, apparatus, computer equipment and the storage medium that table provided herein generates have below beneficial to effect
Fruit:
Method, apparatus, computer equipment and the storage medium that table provided herein generates, by obtaining pre- import
The general character code building general character page of data template, and the parsing code of gauge outfit data in pre- importing data template is got, into
And the code of the preset service template table imported needed for generating, corresponding electricity is carried out without developing new importing template code every time
Sub-table imports, and realizes the generation of table, improves the development efficiency of import feature, save the cost.
Detailed description of the invention
Fig. 1 is the method and step schematic diagram that table generates in one embodiment of the application；
Fig. 2 is the apparatus structure block diagram that table generates in one embodiment of the application；
Fig. 3 is the structural schematic block diagram of the computer equipment of one embodiment of the application.
The embodiments will be further described with reference to the accompanying drawings for realization, functional characteristics and the advantage of the application purpose.
Specific embodiment
It is with reference to the accompanying drawings and embodiments, right in order to which the objects, technical solutions and advantages of the application are more clearly understood
The application is further elaborated.It should be appreciated that specific embodiment described herein is only used to explain the application, not
For limiting the application.
It referring to Fig.1, is that the method for table generation is provided in one embodiment of the application, comprising the following steps:
Step S1 obtains the pre- gauge outfit data and the corresponding field name of each gauge outfit data for importing data template；
Step S2, according to the parsing code of gauge outfit data described in the gauge outfit data acquisition, wherein the parsing code is
The program in machine code generated according to the particular content of the gauge outfit data and position；And it according to the field name, generates default
Service moulding plate builds table script and first code, wherein the table script of building is for creating the table of the preset service template
Sound of laughing formula, the first code are the parsing code of the field name；
Step S3, by by it is described build table script and the first code storage at specified application site, with shape
Instruction is imported at the data of the preset service template, and the parsing code and preset general character code combination are generated into institute
State the service code of preset service template；
Step S4, the data for triggering the preset service template import instruction, needed for being generated by the service code
Preset service template table.
In above step, user is provided with the general character Code Template of import feature on tool in advance, wherein tool includes
The general character Code Template of import feature, general character Code Template include such as front end import feature jsp (java service page) page,
The template of the common codes such as transmitting assembly, attribute ownership, is combined into a general character template for the general module in each template, raw
Interface etc. is imported so that system can carry out upload attachment according to the general character code at general character code.
Above-mentioned jsp is the java server page, and the java realized in html grammer extends (with<%, %>shape
Formula).Jsp and servlet (Java Servlet, servlet or service adapter) equally, are executed in server end.
Be typically returned to client is exactly a html (HyperText Markup Language, hypertext markup language) text,
Client can browse as long as having browser.
System obtains the front-end code for importing the jsp page, and will acquire selected importing data template file
Front-end code is made into the file of jsp template, and importing data film rear end control layer identification code can receive the importing transmitted to front end
Data file data flow (i.e. the contents list of excel file), since the code of each upper transmitting file upload procedure is all the same, because
This can be used as general character code using identical code, controller template is made into, so that excel file is passed to control
Layer identification code.
The front end import feature jsp page includes file transmitting assembly, attribution data, to each pre- importing data template text
The importing of part is consistent, and jsp page code is directly organized into the automatic output of the page of general character, with the data template of importing nothing itself
It closes, any process for importing data template importing interface can use equally, can upload attachment；It is attached in the java code of backstage
It is general character code that part, which uploads, is directly organized into standard code output, and difference is the parsing to module column, the parsing code root of column
It is generated according to data template gauge outfit, first code is generated according to the corresponding field name of first trip in template；It imports data template and adds a line
The corresponding field name of each column gauge outfit and data type are identified, parsing template is led according to the corresponding field of the first row by tool generation
Enter data storage builds table script, is triggered by a key, directly generates the of front and back client database needed for table imports parsing
One code.
After getting the pre- gauge outfit data for importing data template, the gauge outfit (column head) of the gauge outfit data is parsed, is obtained
The parsing code of corresponding gauge outfit data is got, the parsing code is for parsing the specific of column head in service moulding plate in fill system
Place is stored in database profession with getting corresponding result list, and such as in one embodiment, receiving needs to give birth in system
At importing service moulding plate in gauge outfit include column name and each column name specific name field name, then get each column
Name generates corresponding parsing code, which is stored in system for filling the specific location for parsing column in service moulding plate
It is to be output in the output directory of middle tool, and export complete service document to result list and save as specified title, root
Table script and first code are built according to the generation of field name corresponding to gauge outfit data is corresponding, wherein are preset and be used on generation
The tool for building table script and first code, by user trigger tool generate it is corresponding build table script and first code, pass through by
The table script and first code storage built is at specified application site, to form the number of the preset service template
It is instructed according to importing, and the parsing code and preset general character code combination is generated to the service generation of the preset service template
Code, wherein first code refers to saving the insert sentence of storage, and first code is stored in system, builds table script storage and arrive
Behind specified data library, the import feature of new service moulding plate is formed, when needing specified column head, user is received and triggers work
Tool generates the order of code, and by the storage of the code of generation into system specified application project, so that the system application coexists
Corresponding import feature is contained, without carrying out writing for code again, directly produces corresponding template code.
In one embodiment, the difference section in service moulding plate replaced as needed gets corresponding column head, in turn
Generate it is corresponding build table script and first code, and then generation required for parsing code and general character code building by generating
Code, writes corresponding edit code without user each time, greatly improves import feature, save the waste of resource, saves
Cost-saving.
In one embodiment, the step S2 of the parsing code of the gauge outfit data according to the gauge outfit data acquisition,
Include:
Step S21, read it is described it is pre- import data template described in gauge outfit data each table table field and
The position of each table field；
Step S22 parses each table field by API Function, obtains each table word
The corresponding first parsing code of section；
Step S23, according to the corresponding first parsing code of all table fields got, all described the
One parsing code forms the parsing code of the gauge outfit data.
In above step, in the present embodiment, gauge outfit data are the pre- table imported in data template (importing excel in advance)
Head data, by reading the pre- gauge outfit data imported in data template, wherein each pre- distinctive points for importing data template file
Maximum is that the gauge outfit data in data are inconsistent, can be by calling the api function of parsing excel, and then imports data to pre-
Data in template file are parsed, wherein system is each in gauge outfit data in pre- importing data template by reading
The position of table field and each table field in table, by calling API to parse each field,
Obtain the corresponding first parsing code of each field, all first parsing code-groups at the corresponding parsing code,
By according to the pre- column for importing data template it is first-born at parsing code be stored in the output directory of the tool in system, so as to user
It needs to generate specified field in service moulding plate, according to parsing code and then the corresponding importing corresponding data of generation can be corresponded to
Template code.
In one embodiment, system is by reading in every excel table in excel file in gauge outfit data
Field corresponding to field name, wherein excel file is put into specified tool mesh by the title of the entitled each field of field
In record, each field name is bracketed by bracket, so that system is by reading the field name in bracket, generates corresponding database
The first code for building table script and save value database.It is programmed code again without user, the effect greatly improved
Rate saves cost.
In one embodiment, the executable file " Build.bat " for getting tool in advance receives user's triggering
Executable file, the execution file execution prestore the instrumentation code being stored under file classes, wherein the instrumentation code according to
Secondary execution following steps: the jsp page of front end is copied in file " result ", and correspondence is renamed as corresponding jsp lattice
The title of formula；It will be in controller template duplicating to file " result ", wherein the controller template is for locating
The attachmentes such as general character code are managed, the name modifications copied in file " result " are corresponding Controller.java format
Title；Service template file is read, while reading derivative template xlsx, each column name of the 1st row is parsed, gets column name
With the field name in bracket, parsing code is generated with column name, for filling the specific place for parsing column in service template, so
After export complete service file and save as xxxServers.java to result catalogue；By in parsing gauge outfit bracket
Field name generates database and builds table script and first code.
In one embodiment, user has pre-selected service moulding plate；Table script and first are built using what tool generated
Code；Wherein, building table script is set in database, and first code is stored in database, for importing corresponding data
Code；By parsing code and the corresponding template code of general character code building, template code is for importing corresponding data
To at corresponding template position.When needing to generate the excel table of preset service template in systems, preset service template is triggered
Importing instruction, and the consistent excel table of gauge outfit for corresponding to pre- importing data template is generated by service code.
In one embodiment, the parsing code and preset general character code combination are generated into the preset service template
The step S3 of service code, comprising:
Step S31 receives the preset general character code of third party, wherein the general character code refers to multiple pre- importings
Identical code in data template importing process；
The parsing code is inserted into the general character code, to form the preset service by step S32 in a designated order
The service code of template, the service code are the code for generating electrical form content.
In above step, it is each it is pre- import data template file import realization process used by code be it is identical,
It is to realize all codes of front and back end database script that import feature is automatically generated according to template, wherein front end import feature
The jsp page contains file transmitting assembly, attribution data etc., by the way that jsp page code to be organized into the page code of general character,
Wherein, the general character code is unrelated with the pre- importing specific data of data template, and general character code is applied to pre- importing data template
On be conducted into.
In one embodiment, in order to realize the general character code for automatically generating import feature, default one is led user in advance
The import feature for entering data gets in specific code according to the specific code to be write and imports data with altogether with other
Property specific code, all specific codes with general character are generated into a general character codes, if it is subsequent need using when can be straight
Use is connect, will not be that the specific code of general character code separates, further, each pre- gauge outfit for importing data template is corresponding
Specific code is all different, but the mode one parsed is used, and can generate corresponding parsing code by preset tool, then
Parsing code and general character code combination corresponding to gauge outfit data by required service moulding plate, can be obtained corresponding importing
Function facilitates user to replace different pre- importing data template file, produces corresponding generation without writing code again
Code.
In one embodiment, according to the field name, generate preset service template builds table script and first code
Step S2, comprising:
Step S201 gets the file of the pre- front end page code for importing data template, generates specified format
First file is stored into result list, and gets the file of preset control template code, generates the of java format
Two files are stored into the result list, wherein the control template is for handling the general character code to obtain java lattice
The file of formula, first file and second file are used to form the general character template of the data template of the pre- importing；
Step S202 after getting the pre- importing data template, reads the pre- gauge outfit data for importing data template
In each table each field name；
Step S203, parse the field name generate it is corresponding it is described build table script and first code, and built described
Table script and first code are stored in the result list, and table script and the first code of building is for importing and forming institute
The preset service template needed.
In above step, the front end import feature jsp page includes file transmitting assembly, and attribution data pre- is led to each
The importing for entering data template file is consistent, and jsp page code is directly organized into the automatic output of the page of general character, with the number of importing
Unrelated according to template itself, any process for importing data template importing interface can use equally, can upload attachment；From the background
It is general character code that attachment, which uploads, in java code, is directly organized into standard code output, and difference is the parsing to module column, column
Parsing code generated according to data template gauge outfit, first code is generated according to the corresponding field name of first trip in template；Import number
According to template plus the corresponding field name of a line identifier each column gauge outfit and data type, it is logical according to the corresponding field of the first row to parse template
That crosses tool generation importing data storage builds table script, is triggered by a key, directly generates table importing and parse required front and back
The first code of client database.
The file of the pre- front end page code for importing data template is got, the first file for generating specified format is deposited
It stores up in result list, and gets the file of preset control template code, generate the second file storage of java format
Into the result list, wherein the control template is for handling the general character code to obtain the file of java format, institute
It states the first file and second file is used to form the data template of the pre- importing；Get the pre- importing data template
Afterwards, each field name of each table in the pre- gauge outfit data for importing data template is read；Parse the word
Table script and first code are built described in section name generation is corresponding, corresponding file, reading service template text are executed by tool
Part, and pre- importing data template table is read simultaneously, the field name of corresponding column name and column name bracket is parsed, the bracket
Field name produces above-mentioned first code, i.e. parsing code, and table script and the are built in field name generation in bracket by tool
One code is stored at specified position to form new import feature, without writing new program in machine code every time.Wherein,
First code refers to saving the insert sentence of storage, and first code is stored in result list, builds the storage of table script to finger
After fixed database, the import feature of required service moulding plate is formed, when needing specified column head, user is received and triggers work
Tool generates the order of code, and by the storage of the code of generation into system specified application project, so that the system application coexists
There is corresponding import feature, without carrying out writing for code again, directly produces corresponding template code.
In one embodiment, described to build table script and first code storage to specified application site for described
Place, to form the step S4 that the data of the preset service template import instruction, comprising:
Step S41 establishes the incidence relation of the first code Yu the field name；
The table script of building is stored in specified directory, and the first generation of incidence relation will be present by step S42
Code is stored in presetting database, imports instruction to form the data of the preset service template.
In above step, after building table script according to field name generation, it is saved directly to the corresponding number of specified application system
According to library, there are corresponding import features for application system, rewrite database script again without user, save user time,
Save cost.
In the present embodiment, it gets and builds table script and first code, first code is for being saved into database
Insert sentence, after receiving the service moulding plate of user's selection, according to the code generator of system, wherein code generator
It include to parse the tools such as template, general character template, service moulding plate, after the Trigger Function for receiving user, system is multiple front end jsp
The jsp file for forming corresponding format in specified file library is made, required all attachmentes to be processed are uploaded into specified template
In after copied in specified file library again, generate the jsp file of corresponding format module, and then reading service template file, together
When read it is specific pre- import data template xlsx, each column name of the first row in pre- importing data template is parsed, to get
Corresponding column name and the corresponding field name of specific each column name, wherein field name is bracketed by bracket is set to column name
Position at, corresponding parsing code is generated by column name, which parses the specific of column for filling in service moulding plate
At position, so as to export complete service document to the catalogue in specified file library, and it is stored as corresponding service java；
Table script and the first code (insert for being saved into database are built by what the field name in the bracket that is resolved to generated database
Sentence).
According to above step, is got in the catalogue in specified file library and build the specified directory that table script is stored in system
In, and the first code of incidence relation will be present and be stored in presetting database, to form the preset service template
Data import instruction complete required for import feature column head, so that subsequent user is needed using specific data excel
When, without writing corresponding program in machine code again, working efficiency is improved, cost is saved.
In conclusion the method that the table to provide in the embodiment of the present application generates, by obtaining pre- importing data template
The general character code building general character page, and get it is pre- importing data template in gauge outfit data parsing code, and then generate institute
The code for the preset service template table that need to be imported, the corresponding electrical form of importing template code progress without developing new every time are led
Enter, realize the generation of table, improves the development efficiency of import feature, save the cost.
Referring to Fig. 3, a kind of device that table generates is additionally provided in one embodiment of the application, comprising:
First obtains module 10, corresponding for obtaining the pre- gauge outfit data for importing data template and each gauge outfit data
Field name；
Second obtains module 20, the parsing code for the gauge outfit data according to the gauge outfit data acquisition, wherein institute
Stating parsing code is the program in machine code generated according to the particular content of the gauge outfit data and position；And according to the field
Name, generate preset service template builds table script and first code, wherein the table script of building is for creating the default clothes
The table format for template of being engaged in, the first code are the parsing code of the field name；
First generation module 30, for by building table script and first code storage to specified application for described
At position, instruction is imported to form the data of the preset service template, and by the parsing code and preset general character generation
The service code of preset service template described in code combination producing；
Second generation module 40, the data for triggering the preset service template import instruction, pass through the service generation
Code generates required preset service template table.
In the present embodiment, user is provided with the general character Code Template of import feature on tool in advance, wherein kit
The general character Code Template of import feature is contained, general character Code Template includes such as front end import feature jsp (java service page) page
Face, the template of the common codes such as transmitting assembly, attribute ownership, is combined into a general character mould for the general module in each template
Plate generates general character code, so that system can carry out upload attachment according to the general character code, imports interface etc..
Above-mentioned jsp is the java server page, and the java realized in html grammer extends (with<%, %>shape
Formula).Jsp and servlet (Java Servlet, servlet or service adapter) equally, are executed in server end.
Be typically returned to client is exactly a html (HyperText Markup Language, hypertext markup language) text,
Client can browse as long as having browser.
The front-end code for importing the jsp page is obtained, and before will acquire selected pre- importing data template file
End code is made into the file of jsp template, this is pre- to import data template file rear end control layer identification code and can receive and transmit to front end
It is pre- to import data template document data flow (i.e. the contents list of excel file), due to the generation of each upper transmitting file upload procedure
Code is all the same, therefore can be used as general character code using identical code, is made into controller template, so that excel is literary
Part passes to control layer identification code.
The front end import feature jsp page includes file transmitting assembly, attribution data, to each pre- importing data template text
The importing of part is consistent, and jsp page code is directly organized into the automatic output of the page of general character, with the data template of importing nothing itself
It closes, any process for importing data template importing interface can use equally, can upload attachment；It is attached in the java code of backstage
It is general character code that part, which uploads, is directly organized into standard code output, and difference is the parsing to module column, the parsing code root of column
It is generated according to data template gauge outfit, first code is generated according to the corresponding field name of first trip in template；It imports data template and adds a line
The corresponding field name of each column gauge outfit and data type are identified, parsing template is led according to the corresponding field of the first row by tool generation
Enter data storage builds table script, is triggered by a key, directly generates the of front and back client database needed for table imports parsing
One code.
After first acquisition module 10 gets the pre- gauge outfit data for importing data template, to the gauge outfit (column of the gauge outfit data
Head) it is parsed, the second acquisition module 20 gets the parsing code of corresponding gauge outfit data, and the parsing code is for filling system
The specific place for parsing column head in system in service moulding plate, is stored in database profession, such as one with getting corresponding result list
In specific embodiment, receiving gauge outfit in the service moulding plate for needing the importing generated in system includes column name and each column name tool
The field name of body title then gets each column name and generates corresponding parsing code, and the parsing code is for filling service moulding plate
The specific location of middle parsing column, is stored in be output in the output directory of tool in system, and exports complete service document and arrives
Result list simultaneously saves as specified title, is generated according to field name corresponding to gauge outfit data and corresponding builds table script and first
Code presets the tool for being used on and generating and building table script and first code, triggers tool by user and generates corresponding build
Table script and first code, the first generation module 30 by by the table script and first code storage built to specified
At application site, with formed the preset service template data import instruction, and by the parsing code with it is preset total
Property code combination generate the service code of the preset service template, wherein first code refers to saving the insert of storage
Sentence, first code are stored in system, after building the storage to specified data library of table script, form the importing of new service moulding plate
Function receives user and triggers the order of tool generation code, and the code storage of generation is arrived when needing specified column head
In system specified application project, the data that the second generation module 40 triggers the preset service template import instruction, pass through institute
State the preset service template table needed for service code generates.Corresponding import feature is contained so that the system application coexists, is not necessarily to
Writing for code is carried out again, directly produces corresponding template code.
In one embodiment, the difference section in service moulding plate replaced as needed gets corresponding column head, in turn
Generate it is corresponding build table script and first code, and then generation required for parsing code and general character code building by generating
Code, writes corresponding edit code without user each time, greatly improves import feature, save the waste of resource, saves
Cost-saving.
In the present embodiment, the second acquisition module 20 includes:
First reading unit, for reading the pre- table field for importing each table of gauge outfit data in data template
And the position of each table field；
First resolution unit obtains each institute for parsing by API Function to each table field
State the corresponding first parsing code of table field；
First acquisition unit, for parsing code according to all table fields corresponding described first got,
All first parsing codes form the parsing code of the gauge outfit data.
In the present embodiment, gauge outfit data are the pre- gauge outfit data imported in data template (importing excel in advance), are passed through
Read the pre- gauge outfit data imported in data template, wherein each pre- distinctive points maximum for importing data template file is to count
It is inconsistent according to interior gauge outfit data, it can be by calling the api function of parsing excel, and then imported in data template file to pre-
Data parsed, wherein the first reading unit is by reading each table in pre- importing data template in gauge outfit data
The position of table field and each table field in lattice, the first resolution unit is by calling API to each word
Duan Jinhang parsing, obtains the corresponding first parsing code of each field, and first acquisition unit is all according to what is got
First parsing code-group at the corresponding parsing code, by according to the pre- column for importing data template it is first-born at parsing code deposit
It is stored in the output directory of the tool in system, it, can be according to parsing so that user needs to generate specified field in service moulding plate
Code and then the corresponding template code for generating corresponding importing corresponding data.
In one embodiment, by reading the word in every excel table in excel file in gauge outfit data
Field name corresponding to section, wherein excel file is put into specified tool roll by the title of the entitled each field of field,
Each field name is bracketed by bracket, so that system is by reading the field name in bracket, generates building for corresponding database
The first code of table script and save value database.It is programmed code again without user, the efficiency greatly improved, section
Cost-saving.
In one embodiment, the executable file " Build.bat " for getting tool in advance receives user's triggering
Executable file, the execution file execution prestore the instrumentation code being stored under file classes, wherein the instrumentation code according to
Secondary execution following steps: the jsp page of front end is copied in file " result ", and correspondence is renamed as corresponding jsp lattice
The title of formula；It will be in controller template duplicating to file " result ", wherein the controller template is for locating
The attachmentes such as general character code are managed, the name modifications copied in file " result " are corresponding Controller.java format
Title；Service template file is read, while reading derivative template xlsx, each column name of the 1st row is parsed, gets column name
With the field name in bracket, parsing code is generated with column name, for filling the specific place for parsing column in service template, so
After export complete service file and save as xxxServers.java to result catalogue；By in parsing gauge outfit bracket
Field name generates database and builds table script and first code.
In the present embodiment, user has pre-selected service moulding plate；Table script and first code are built using what tool generated；
Wherein, building table script is set in database, and first code is stored in database, for importing the generation of corresponding data
Code；By the parsing code and corresponding template code of general character code building, template code is used to for corresponding data importeding into pair
At the template position answered.When needing to generate the excel table of preset service template in systems, triggering preset service template is led
Enter instruction, and is generated by service code and correspond to the pre- consistent excel table of gauge outfit for importing data template.
In one embodiment, first generation module 30 includes:
Receiving unit, for receiving the preset general character code of third party, wherein the general character code refers to multiple pre- lead
Identical code in the data template importing process entered；
Assembled unit, for the parsing code to be inserted into a designated order in the general character code, described in being formed
The service code of preset service template, the service code are the code for generating electrical form content.
In the present embodiment, code used by each pre- realization process for importing the importing of data template file is identical
, it is to realize all codes of front and back end database script that import feature is automatically generated according to template, wherein front end imports function
The energy jsp page, contains file transmitting assembly, attribution data etc., by the page generation that jsp page code is organized into general character
Code, wherein the general character code is unrelated with the pre- specific data of data template that import, and general character code is applied to import data template in advance
On be conducted into.
In one embodiment, in order to realize the general character code for automatically generating import feature, default one is led user in advance
The import feature for entering data, according to the specific code to be write, receiving unit receives in specific code and imports number with other
According to the specific code with general character, all specific codes with general character are generated into a general character codes, if it is subsequent need using
When can directly use, will not be that the specific code of general character code separates, further, each pre- table for importing data template
Corresponding specific code is all different, but the mode one parsed is used, and can be passed through preset tool and be generated corresponding parsing
Code, then parsing code corresponding to gauge outfit data of the assembled unit by required service moulding plate is sequentially inserted into according to specified
It is combined in general character code, to form the service code of the preset service template, corresponding import feature can be obtained,
In, the service code is the code for generating electrical form content, facilitates the different pre- importing data template text of user's replacement
Part produces corresponding code without writing code again.
In one embodiment, second module 20 is obtained, comprising:
Second acquisition unit, for getting the file of the pre- front end page code for importing data template, generation refers to
First file of the formula that fixes is stored into result list, and gets the file of preset control template code, generates java
Second file of format is stored into the result list, wherein the control template is for handling the general character code to obtain
To the file of java format, first file and second file are used to form the general character of the data template of the pre- importing
Template；
Second reading unit reads the pre- importing data template after getting the pre- importing data template
Each field name of each table in gauge outfit data；
Second resolution unit, for parse the field name generate it is corresponding it is described build table script and first code, and
Table script is built and first code is stored in the result list for described, and table script and the first code of building is for importing
And the preset service template needed for being formed.
In the present embodiment, the front end import feature jsp page includes file transmitting assembly, attribution data, to each pre-
The importing for importing data template file is consistent, and jsp page code is directly organized into the automatic output of the page of general character, with importing
Data template itself is unrelated, and any process for importing data template importing interface can use equally, can upload attachment；Afterwards
It is general character code that attachment, which uploads, in platform java code, is directly organized into standard code output, and difference is the parsing to module column,
The parsing code of column is generated according to data template gauge outfit, and first code is generated according to the corresponding field name of first trip in template；It imports
Data template adds the corresponding field name of a line identifier each column gauge outfit and data type, parses template according to the corresponding field of the first row
By tool generate import data storage build table script, by a key trigger, directly generate table import parsing needed for before
The first code of back-end data base.
Second acquisition unit gets the file of the pre- front end page code for importing data template, generates specified format
The first file store into result list, and get the file of preset control template code, generate java format
Second file is stored into the result list, wherein the control template is for handling the general character code to obtain java
The file of format, first file and second file are used to form the general character template of the data template of the pre- importing；
After second reading unit gets the pre- importing data template, read each in the pre- gauge outfit data for importing data template
Each field name of the table；Second resolution unit parse the field name generate it is corresponding it is described build table script and
First code executes corresponding file, reading service template file by tool, and reads pre- importing data template table simultaneously
Lattice, parse the field name of corresponding column name and column name bracket, and the field name of the bracket produces above-mentioned first code, that is, solves
Analyse code, field name generation in bracket built by table script and first code by tool, storage at specified position to
New import feature is formed, without writing new program in machine code every time.Wherein, first code refers to saving the insert of storage
Sentence, first code are stored in result list, after building the storage to specified data library of table script, form required service moulding plate
Import feature receive user when needing specified column head and trigger the order that tool generates code, and by the code of generation
It stores in system specified application project, has corresponding import feature so that the system application coexists, without carrying out again
Code is write, and corresponding template code is directly produced.
In one embodiment, the second generation module 40 includes:
Unit is established, for establishing the incidence relation of the first code Yu the field name；
For the table script of building to be stored in specified directory, and the described of incidence relation will be present in storage unit
First code is stored in presetting database, imports instruction to form the data of the preset service template.
In the present embodiment, after building table script according to field name generation, it is corresponding to be saved directly to specified application system
Database, there are corresponding import features for application system, database script are rewritten again without user, when saving user
Between, save cost.
In the present embodiment, it gets and builds table script and first code, establish unit and establish first code and field name
Incidence relation, wherein first code is used for the insert sentence that is saved into database, when the service for receiving user's selection
After template, according to the code generator of system, wherein code generator includes parsing template, general character template, service moulding plate etc.
Tool, after the Trigger Function for receiving user, system copies in specified file library the jsp for forming corresponding format front end jsp
File copies in specified file library again after uploading to required all attachmentes to be processed in specified template, generates and corresponds to
Format module jsp file, and then reading service template file, while reading and specific pre- importing data template xlsx, solution
The pre- each column name for importing the first row in data template is precipitated, it is corresponding to get corresponding column name and specific each column name
Field name, wherein field name is bracketed by bracket to be set at the position of column name, generates corresponding parsing generation by column name
Code, the parsing code is for filling the particular locations for parsing column in service moulding plate, so as to export complete service document
To the catalogue in specified file library, and it is stored as corresponding service java；Number is generated by the field name in the bracket that is resolved to
Table script and the first code (insert sentence) for being saved into database are built according to library.
In the present embodiment, it is got in the catalogue in specified file library and builds the specified directory that table script is stored in system
In, and the first code of incidence relation will be present and be stored in presetting database, to form the preset service template
Data import instruction complete required for import feature column head, so that subsequent user is needed using specific data excel
When, without writing corresponding program in machine code again, working efficiency is improved, cost is saved.
In conclusion the device that the table to provide in the embodiment of the present application generates, by obtaining pre- importing data template
The general character code building general character page, and get it is pre- importing data template in gauge outfit data parsing code, and then generate institute
The code for the preset service template table that need to be imported, the corresponding electrical form of importing template code progress without developing new every time are led
Enter, realize the generation of table, improves the development efficiency of import feature, save the cost.
Referring to Fig. 3, a kind of computer equipment is also provided in the embodiment of the present application, which can be server,
Its internal structure can be as shown in Figure 3.The computer equipment includes processor, the memory, network connected by system bus
Interface and database.Wherein, the processor of the Computer Design is for providing calculating and control ability.The computer equipment is deposited
Reservoir includes non-volatile memory medium, built-in storage.The non-volatile memory medium is stored with operating system, computer program
And database.The built-in storage provides environment for the operation of operating system and computer program in non-volatile memory medium.
The database of the computer equipment is for storing the data such as general character code.The network interface of the computer equipment is used for and outside
Terminal passes through network connection communication.To realize a kind of method that table generates when the computer program is executed by processor.
Above-mentioned processor executes the step of method that above table generates:
Obtain the pre- gauge outfit data and the corresponding field name of each gauge outfit data for importing data template；
According to the parsing code of gauge outfit data described in the gauge outfit data acquisition, wherein the parsing code is according to institute
The program in machine code that the particular content and position for stating gauge outfit data generate；And according to the field name, generate preset service mould
Plate builds table script and first code, wherein the table format built table script and be used to create the preset service template,
The first code is the parsing code of the field name；
By by it is described build table script and the first code storage at specified application site, it is described pre- to be formed
If the data of service moulding plate import instruction, and the parsing code and preset general character code combination are generated the default clothes
The service code for template of being engaged in；
The data for triggering the preset service template import instruction, the preset service needed for being generated by the service code
Template table.
In one embodiment, the step of the parsing code of processor gauge outfit data according to the gauge outfit data acquisition
Suddenly, comprising:
Read the table field of the pre- each table for importing gauge outfit data described in data template and each described
The position of table field；
Each table field is parsed by API Function, it is corresponding to obtain each table field
First parsing code；
Code, all first parsing generations are parsed according to all table fields corresponding described first got
Code forms the parsing code of the gauge outfit data.
In one embodiment, the processor generates the parsing code and preset general character code combination described default
The step of service code of service moulding plate, comprising:
Receive the preset general character code of third party, wherein the general character code refers to the data template of multiple pre- importings
Identical code in importing process；
The parsing code is inserted into a designated order in the general character code, to form the preset service template
Service code, the service code are the code for generating electrical form content.
In one embodiment, the processor is according to the field name, generate preset service template build table script and
The step of first code, comprising:
The file of the pre- front end page code for importing data template is got, the first file for generating specified format is deposited
It stores up in result list, and gets the file of preset control template code, generate the second file storage of java format
Into the result list, wherein the control template is for handling the general character code to obtain the file of java format, institute
State the first file and second file be used to form the pre- importing data template general character template；
After getting the pre- importing data template, read each described in the pre- gauge outfit data for importing data template
Each field name of table；
Parse the field name generate it is corresponding it is described build table script and first code, and by it is described build table script and
First code is stored in the result list, and table script and the first code of building is for importing and forming required institute
State preset service template.
In one embodiment, the processor builds table script and first code storage to specified application for described
At position, to form the step of data of the preset service template import instruction, comprising:
Establish the incidence relation of the first code Yu the field name；
The table script of building is stored in specified directory, and the first code of incidence relation will be present and be stored in
In presetting database, instruction is imported to form the data of the preset service template.
It will be understood by those skilled in the art that structure shown in Fig. 3, only part relevant to application scheme is tied
The block diagram of structure does not constitute the restriction for the computer equipment being applied thereon to application scheme.
One embodiment of the application also provides a kind of computer storage medium, is stored thereon with computer program, computer journey
A kind of method that table generates is realized when sequence is executed by processor, specifically:
Obtain the pre- gauge outfit data and the corresponding field name of each gauge outfit data for importing data template；
According to the parsing code of gauge outfit data described in the gauge outfit data acquisition, wherein the parsing code is according to institute
The program in machine code that the particular content and position for stating gauge outfit data generate；And according to the field name, generate preset service mould
Plate builds table script and first code, wherein the table format built table script and be used to create the preset service template,
The first code is the parsing code of the field name；
By by it is described build table script and the first code storage at specified application site, it is described pre- to be formed
If the data of service moulding plate import instruction, and the parsing code and preset general character code combination are generated the default clothes
The service code for template of being engaged in；
The data for triggering the preset service template import instruction, the preset service needed for being generated by the service code
Template table.
In one embodiment, the step of the parsing code of processor gauge outfit data according to the gauge outfit data acquisition
Suddenly, comprising:
Read the table field of the pre- each table for importing gauge outfit data described in data template and each described
The position of table field；
Each table field is parsed by API Function, it is corresponding to obtain each table field
First parsing code；
Code, all first parsing generations are parsed according to all table fields corresponding described first got
Code forms the parsing code of the gauge outfit data.
In one embodiment, the processor generates the parsing code and preset general character code combination described default
The step of service code of service moulding plate, comprising:
Receive the preset general character code of third party, wherein the general character code refers to the data template of multiple pre- importings
Identical code in importing process；
The parsing code is inserted into a designated order in the general character code, to form the preset service template
Service code, the service code are the code for generating electrical form content.
In one embodiment, the processor is according to the field name, generate preset service template build table script and
The step of first code, comprising:
The file of the pre- front end page code for importing data template is got, the first file for generating specified format is deposited
It stores up in result list, and gets the file of preset control template code, generate the second file storage of java format
Into the result list, wherein the control template is for handling the general character code to obtain the file of java format, institute
State the first file and second file be used to form the pre- importing data template general character template；
After getting the pre- importing data template, read each described in the pre- gauge outfit data for importing data template
Each field name of table；
Parse the field name generate it is corresponding it is described build table script and first code, and by it is described build table script and
First code is stored in the result list, and table script and the first code of building is for importing and forming required institute
State preset service template.
In one embodiment, the processor builds table script and first code storage to specified application for described
At position, to form the step of data of the preset service template import instruction, comprising:
Establish the incidence relation of the first code Yu the field name；
The table script of building is stored in specified directory, and the first code of incidence relation will be present and be stored in
In presetting database, instruction is imported to form the data of the preset service template.
In conclusion method, apparatus, computer equipment and storage that the table to provide in the embodiment of the present application generates are situated between
Matter by obtaining the pre- general character code building general character page for importing data template, and gets gauge outfit in pre- importing data template
The parsing code of data, and then the code of the preset service template table imported needed for generating, without developing new importing mould every time
Plate code carries out corresponding electrical form importing, realizes the generation of table, improves the development efficiency of import feature, save the cost.
Those of ordinary skill in the art will appreciate that realizing all or part of the process in above-described embodiment method, being can be with
Relevant hardware is instructed to complete by computer program, the computer program can store and a non-volatile computer
In read/write memory medium, the computer program is when being executed, it may include such as the process of the embodiment of above-mentioned each method.Wherein,
Any reference used in provided herein and embodiment to memory, storage, database or other media,
Including non-volatile and/or volatile memory.Nonvolatile memory may include read-only memory (ROM), programming ROM
(PROM), electrically programmable ROM (EPROM), electrically erasable ROM (EEPROM) or flash memory.Volatile memory may include
Random access memory (RAM) or external cache.By way of illustration and not limitation, RAM can by diversified forms
, such as static state RAM (SRAM), dynamic ram (DRAM), synchronous dram (SDRAM), double speed are according to rate SDRAM (SSRSDRAM), increasing
Strong type SDRAM (ESDRAM), synchronization link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM
(RDRAM), direct memory bus dynamic ram (DRDRAM) and memory bus dynamic ram (RDRAM) etc..
It should be noted that, in this document, the terms "include", "comprise" or its any other variant are intended to non-row
His property includes, so that the process, device, article or the method that include a series of elements not only include those elements, and
And further include the other elements being not explicitly listed, or further include for this process, device, article or method institute it is intrinsic
Element.In the absence of more restrictions, the element limited by sentence "including a ...", it is not excluded that including being somebody's turn to do
There is also other identical elements in the process, device of element, article or method.
The foregoing is merely preferred embodiment of the present application, are not intended to limit the scope of the patents of the application, all utilizations
Equivalent structure or equivalent flow shift made by present specification and accompanying drawing content is applied directly or indirectly in other correlations
Technical field, similarly include in the scope of patent protection of the application.
Claims (10)
1. a kind of method that table generates, which comprises the following steps:
Obtain the pre- gauge outfit data and the corresponding field name of each gauge outfit data for importing data template；
According to the parsing code of gauge outfit data described in the gauge outfit data acquisition, wherein the parsing code is according to the table
The program in machine code that the particular content of head data and position generate；And according to the field name, generate preset service template
Build table script and first code, wherein the table script of building is described for creating the table format of the preset service template
First code is the parsing code of the field name；
By by it is described build table script and the first code storage at specified application site, to form the default clothes
The data for template of being engaged in import instruction, and the parsing code and preset general character code combination are generated the preset service mould
The service code of plate；
The data for triggering the preset service template import instruction, the preset service template needed for being generated by the service code
Table.
2. the method that table according to claim 1 generates, which is characterized in that described according to the gauge outfit data acquisition institute
The step of stating the parsing code of gauge outfit data, comprising:
Read the table field and each table of the pre- each table for importing gauge outfit data described in data template
The position of field；
Each table field is parsed by API Function, obtains each table field corresponding first
Parse code；
Code, all first parsings code-groups are parsed according to all table fields corresponding described first got
At the parsing code of the gauge outfit data.
3. the method that table according to claim 1 generates, which is characterized in that by the parsing code and preset general character
Code combination generates the step of service code of the preset service template, comprising:
Receive the preset general character code of third party, wherein the general character code refers to that the data template of multiple pre- importings imports
Identical code in the process；
The parsing code is inserted into a designated order in the general character code, to form the service of the preset service template
Code, the service code are the code for generating electrical form content.
4. the method that table according to claim 1 generates, which is characterized in that it is described according to the field name, it generates pre-
If the step of building table script and first code of service moulding plate, comprising:
The file of the pre- front end page code for importing data template is got, the first file storage for generating specified format is arrived
In result list, and the file of preset control template code is got, the second file for generating java format is stored to institute
It states in result list, wherein the control template is for handling the general character code to obtain the file of java format, and described the
One file and second file are used to form the general character template of the data template of the pre- importing；
After getting the pre- importing data template, each table in the pre- gauge outfit data for importing data template is read
Each field name；
Parse the field name generate it is corresponding it is described build table script and first code, and build table script and first for described
Code is stored in the result list, it is described build table script and the first code be used to import and be formed it is required described pre-
If service moulding plate.
5. the method that table according to claim 1 generates, which is characterized in that described by the table script and described built
First code is stored at specified application site, to form the step of data of the preset service template import instruction, packet
It includes:
Establish the incidence relation of the first code Yu the field name；
The table script of building is stored in specified directory, and will be present incidence relation the first code be stored in it is default
In database, instruction is imported to form the data of the preset service template.
6. the device that a kind of table generates characterized by comprising
First obtains module, for obtaining the pre- gauge outfit data and the corresponding field of each gauge outfit data for importing data template
Name；
Second obtains module, the parsing code for the gauge outfit data according to the gauge outfit data acquisition, wherein the parsing
Code is the program in machine code generated according to the particular content of the gauge outfit data and position；It is raw and according to the field name
Table script and first code are built at preset service template, wherein the table script of building is for creating the preset service mould
The table format of plate, the first code are the parsing code of the field name；
First generation module, for by building table script and first code storage to specified application site for described
Place imports instruction to form the data of the preset service template, and by the parsing code and preset general character code-group
Symphysis at the preset service template service code；
Second generation module, the data for triggering the preset service template import instruction, are generated by the service code
Required preset service template table.
7. the device that table according to claim 6 generates, which is characterized in that described second, which obtains module, includes:
Reading unit, for reading the pre- table field of each table of gauge outfit data and each of importing in data template
The position of the table field；
Resolution unit obtains each table word for parsing by API Function to each table field
The corresponding first parsing code of section；
Acquiring unit, it is all described for parsing code according to all table fields corresponding described first got
First parsing code forms the parsing code of the gauge outfit data.
8. the device that table according to claim 6 generates, which is characterized in that first generation module includes:
Receiving unit, for receiving the preset general character code of third party, wherein the general character code refers to multiple pre- importings
Identical code in data template importing process；
Assembled unit, it is described default to be formed for the parsing code to be inserted into a designated order in the general character code
The service code of service moulding plate, the service code are the code for generating electrical form content.
9. a kind of computer equipment, including memory and processor, it is stored with computer program in the memory, feature exists
In the step of processor realizes any one of claims 1 to 5 the method when executing the computer program.
10. a kind of computer storage medium, is stored thereon with computer program, which is characterized in that the computer program is located
The step of reason device realizes method described in any one of claims 1 to 5 when executing.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910463805.2A CN110347985B (en) | 2019-05-30 | 2019-05-30 | Method, device, computer equipment and storage medium for generating table |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910463805.2A CN110347985B (en) | 2019-05-30 | 2019-05-30 | Method, device, computer equipment and storage medium for generating table |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110347985A true CN110347985A (en) | 2019-10-18 |
| CN110347985B CN110347985B (en) | 2023-07-28 |
Family
ID=68174440
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910463805.2A Active CN110347985B (en) | 2019-05-30 | 2019-05-30 | Method, device, computer equipment and storage medium for generating table |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110347985B (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111177243A (en) * | 2019-12-24 | 2020-05-19 | 浙江大搜车软件技术有限公司 | Data export method and device, storage medium and electronic device |
| CN111209732A (en) * | 2019-12-26 | 2020-05-29 | 广东飞企互联科技股份有限公司 | Method and system for generating form display fields and outputting form display fields to import template in batches |
| CN111382157A (en) * | 2020-03-09 | 2020-07-07 | 山东汇贸电子口岸有限公司 | Device for realizing multi-plug-in form traversal operation through constructor based on service |
| CN112099801A (en) * | 2020-11-03 | 2020-12-18 | 广州市玄武无线科技股份有限公司 | Excel analysis method and system based on metadata driving |
| CN112579963A (en) * | 2020-12-30 | 2021-03-30 | 北京达佳互联信息技术有限公司 | Object generation method, device, electronic equipment, storage medium and program product |
| CN113505580A (en) * | 2021-07-26 | 2021-10-15 | 京东科技控股股份有限公司 | Method and device for analyzing table file |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20100325173A1 (en) * | 2009-06-23 | 2010-12-23 | The Board Of Regents Of The The University Of Texas System | Rapid development of informatics systems for collaborative data management |
| CN106469064A (en) * | 2016-09-04 | 2017-03-01 | 深圳市云智易联科技有限公司 | Code generating method and code generating unit |
| CN107656914A (en) * | 2017-10-16 | 2018-02-02 | 厦门海迈科技股份有限公司 | Form generation method, device, terminal device and the storage medium of configurableization |
| CN107688593A (en) * | 2017-04-13 | 2018-02-13 | 平安科技（深圳）有限公司 | Script file generation method and device |
| CN108170809A (en) * | 2017-12-28 | 2018-06-15 | 平安科技（深圳）有限公司 | Build table scenario generation method, device, equipment and computer readable storage medium |
-
2019
- 2019-05-30 CN CN201910463805.2A patent/CN110347985B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20100325173A1 (en) * | 2009-06-23 | 2010-12-23 | The Board Of Regents Of The The University Of Texas System | Rapid development of informatics systems for collaborative data management |
| CN106469064A (en) * | 2016-09-04 | 2017-03-01 | 深圳市云智易联科技有限公司 | Code generating method and code generating unit |
| CN107688593A (en) * | 2017-04-13 | 2018-02-13 | 平安科技（深圳）有限公司 | Script file generation method and device |
| CN107656914A (en) * | 2017-10-16 | 2018-02-02 | 厦门海迈科技股份有限公司 | Form generation method, device, terminal device and the storage medium of configurableization |
| CN108170809A (en) * | 2017-12-28 | 2018-06-15 | 平安科技（深圳）有限公司 | Build table scenario generation method, device, equipment and computer readable storage medium |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111177243A (en) * | 2019-12-24 | 2020-05-19 | 浙江大搜车软件技术有限公司 | Data export method and device, storage medium and electronic device |
| CN111177243B (en) * | 2019-12-24 | 2023-11-14 | 浙江大搜车软件技术有限公司 | Data export method and device, storage medium and electronic device |
| CN111209732A (en) * | 2019-12-26 | 2020-05-29 | 广东飞企互联科技股份有限公司 | Method and system for generating form display fields and outputting form display fields to import template in batches |
| CN111209732B (en) * | 2019-12-26 | 2023-06-20 | 广东飞企互联科技股份有限公司 | Method and system for generating form display fields and outputting form display fields to import templates in batches |
| CN111382157A (en) * | 2020-03-09 | 2020-07-07 | 山东汇贸电子口岸有限公司 | Device for realizing multi-plug-in form traversal operation through constructor based on service |
| CN112099801A (en) * | 2020-11-03 | 2020-12-18 | 广州市玄武无线科技股份有限公司 | Excel analysis method and system based on metadata driving |
| CN112579963A (en) * | 2020-12-30 | 2021-03-30 | 北京达佳互联信息技术有限公司 | Object generation method, device, electronic equipment, storage medium and program product |
| CN113505580A (en) * | 2021-07-26 | 2021-10-15 | 京东科技控股股份有限公司 | Method and device for analyzing table file |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110347985B (en) | 2023-07-28 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110347985A (en) | Method, apparatus, computer equipment and the storage medium that table generates | |
| CN103383645B (en) | Code generating method and system | |
| US20080046868A1 (en) | Method and system for template-based code generation | |
| CN103597469B (en) | Live browser instrument in IDE | |
| CN103399734B (en) | Method for generating REST service and achieving REST and corresponding equipment | |
| CN101383871B (en) | Network element configuration implementing method and apparatus | |
| US8949790B2 (en) | Debugging visual and embedded programs | |
| CN102306102B (en) | Program file automatic generation method and device | |
| CN110333850A (en) | Generation method, device, computer equipment and the storage medium of interface document | |
| CN103500087A (en) | Code generation method and device based on maven plug-in and freemarker template | |
| CN101072122A (en) | Method, system and user end device for obtaining access amount statistical data | |
| CN101183395A (en) | Method and system for realizing staticize of dynamic page | |
| CN104360937A (en) | Intelligent parameter checking device | |
| CN100512158C (en) | Network measuring system structure and realizing method thereof | |
| CN108491367A (en) | Method, apparatus, computer equipment and the storage medium that report file generates | |
| CN102222278A (en) | Operation process customizing method and device | |
| CN110377892A (en) | A kind of government intelligence form templat designing system | |
| CN102141991A (en) | Method and system for web server | |
| CN109284125A (en) | Dependence packet configuration method, device, equipment and medium in big data platform | |
| CN106951270A (en) | A kind of code process method, system and server | |
| CN109375943A (en) | A kind of program file generation method and device | |
| CN103605639A (en) | Method of making e-books based on EPUB format | |
| CN104750463B (en) | A kind of developing plug method and system | |
| JP6699200B2 (en) | Grammar generation for simple data types | |
| CN102521008A (en) | Program compiling device and method for compiling program |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |