CN117539450A - Code generation method based on WPS loading item - Google Patents
Code generation method based on WPS loading item Download PDFInfo
- Publication number
- CN117539450A CN117539450A CN202410028710.9A CN202410028710A CN117539450A CN 117539450 A CN117539450 A CN 117539450A CN 202410028710 A CN202410028710 A CN 202410028710A CN 117539450 A CN117539450 A CN 117539450A
- Authority
- CN
- China
- Prior art keywords
- column
- name
- wps
- code
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 30
- 238000011161 development Methods 0.000 claims abstract description 11
- 230000007547 defect Effects 0.000 abstract description 3
- 230000018109 developmental process Effects 0.000 description 9
- 238000013461 design Methods 0.000 description 4
- 230000009286 beneficial effect Effects 0.000 description 2
- 230000008676 import Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 239000008186 active pharmaceutical agent Substances 0.000 description 1
- 239000012141 concentrate Substances 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000033772 system development Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/31—Programming languages or programming paradigms
-
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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/23—Updating
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/60—Software deployment
- G06F8/65—Updates
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Software Systems (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Computing Systems (AREA)
- Computer Security & Cryptography (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a code generation method based on WPS loading items, which comprises the steps of displaying the code generator loading items on a WPS navigation menu; setting code generation parameters of code generator loading items; generating a source code file based on the code generator load item; wherein a database table containing data table information is generated; reading information of a database table; connecting a database and generating a database table; writing a code template file, and replacing a value needing dynamic replacement in the code template file by adopting a placeholder; and reading the uploaded code template file, replacing a value needing dynamic replacement in the code template file according to the read information of the database table, and generating a source code file. The invention is based on the secondary development capability provided by the WPS, and the WPS expansion application developed by using the WPS loading item well overcomes a plurality of defects of the current mainstream generated code.
Description
Technical Field
The invention relates to the technical field of system development, in particular to a code generation method based on a WPS loading item.
Background
In the current development process of the informationized application system, the generation of the universal program code by the code generator is a common operation, is used for reducing the complexity of manual operation, concentrates on the business development, and improves the development efficiency. The common code generation modes at present are as follows: 1. designing database fields on tools such as EXCEL tables, using a code generation tool to generate or manually write SQL sentences for creating the database tables, and copying the SQL sentences to a database for execution; generating a source code file by a code generation tool, and manually copying the source code file to a project source code folder; 2. the database table is designed firstly, and then a code generation tool is used for reading the structure of the database table to generate a source code file. The manner in which these common codes are generated has the following problems: 1. the database design and code generation are carried out in steps by using different tools, and still have many manual operations such as copy and paste and the like, thus being relatively troublesome, low in efficiency and easy to make mistakes. 2. When the database table structure changes, the code is regenerated and the table structure document is maintained, so that document maintenance lag is easily caused, even the document is not updated, and the database table structure designed by the document is inconsistent with the actual table structure of the database.
Disclosure of Invention
In order to overcome the defects of the prior art, the invention provides a code generation method based on a WPS loading item, and the database table structure and the source code file can be created or updated according to the EXCEL table design content after only limited configuration, so that manual operation is greatly reduced, and development efficiency is improved.
In order to achieve the above purpose, the technical scheme adopted by the invention is as follows:
a code generation method based on WPS load item comprises the following steps:
step 1, displaying code generator loading items on a WPS navigation menu;
step 2, setting code generation parameters of code generator loading items;
step 3, generating a source code file based on the code generator loading item;
the step 3 comprises the following steps:
step 31, generating a database table containing data table information;
step 32, reading information of a database table;
step 33, connecting the database, inquiring whether the database table is generated, if not, creating a new database table, if so, comparing the generated database table with the database table in step 31, and updating the generated database table;
step 34, writing a code template file, and replacing a value needing dynamic replacement in the code template file by using a placeholder;
and 35, reading the uploaded code template file, and replacing a value needing dynamic replacement in the code template file according to the read information of the database table to generate a source code file.
In step 1, a batch file or script file is created to modify the parameter values of the plug-in configuration parameters under the WPS directory, and the code generator loading item is displayed on the WPS navigation menu.
Further, in step 2, the setting button of the code generator loading item is clicked, parameters including database connection names, database types, database connection character strings, database names, database table character sets, class naming policies, variable naming policies, file saving paths, file name naming policies, development languages are input, and the parameters are written into the local files.
Further, in step 3, the generate button of the code generator loader is clicked to generate the source code file.
Further, in step 31, the table structure of the database table includes a plurality of sub-structures, each sub-structure includes one data table information, and the first four behavior table information and the field information of the table information of each sub-structure: the first row comprises two columns, wherein the first column is the table name, and the second column is the field information of the table name; the second row comprises two columns, wherein the first column is a table prefix, and the second column is field information of the table prefix; the third row comprises two columns, wherein the first column is the name of the service module, and the second column is the field information of the name of the service module; the fourth row comprises two columns, wherein the first column is the packet name, and the second column is the field information of the packet name; the fifth row of the table structure comprises a plurality of columns, wherein the first column is a field name, the second column is a field type, the third column is a field description, the fourth column is whether filling is needed, the fifth column is a main key, the sixth column is whether an index is needed, and the seventh column is whether self-increment is needed; the sixth row of the table structure and field information greater than the sixth row of the table structure information.
Further, there is at least one blank row between each substructure.
Further, step 32 includes: step 321, declaring an empty JS object array for storing all data sheet information; step 322, declaring a first JS object, where the first JS object includes four attributes including a table name, a table prefix, a service module name, and a package name; step 323, calling the first row of the Rows object reading substructure, calling the Cells object to read each column of the first row, skipping if the column value is blank, reading the next column if the column value is a table name, giving the next column value as an attribute value of the table name attribute of the first JS object, reading the column value as three Rows of a table prefix, a business module name and a package name by the same method, and adding the first JS object into the JS object array; step 324, calling the fifth row of the Rows object reading substructure, declaring a second JS object, calling the Cells object to read each column of the fifth row, if the column value is a field name, respectively giving the sequence number and the value of the current column as an attribute name and a corresponding attribute value of the attribute of the second JS object, and reading the rest columns of the fifth row by the same method; step 325, calling a sixth row of the Rows object reading substructure, declaring a third JS object, where the third JS object contains seven attributes with null attribute names, calling the Cells object to read a first column of the sixth row, extracting attribute values corresponding to column numbers of the current column from the second JS object, respectively assigning the extracted attribute values and the values of the current column as attribute names and corresponding attribute values of the first attribute of the third JS object, reading the remaining columns of the sixth row by the same method, and adding the third JS object to the second JS object; step 326, referring to step 325, until a blank line is read, adding the second JS object to the JS object array; step 327, repeating steps 321-326 until the sub-structure including all the data table information is read.
Further, in step 33, if not, generating an SQL statement for creating a table according to the table structure of the database table in step 31, and creating a new database table; if so, querying field information of the generated database table and comparing with field information of a table structure of the database table in step 31: and if the generated database table has field information which is not provided with a set table structure and inconsistent field information and the database table has fields which are not provided with a table structure, generating SQL sentences of the newly added fields, the modified fields and the deleted fields respectively, and executing the SQL sentences to update the generated database table.
Further, in step 35, the JS object array is circulated, and the field information of the database table is used to replace the placeholders in the code template file, so as to generate the source code file.
Compared with the prior art, the invention has the following beneficial effects:
the invention is based on the secondary development capability provided by the WPS, and the WPS expansion application developed by using the WPS loading item well overcomes a plurality of defects of the current mainstream generated code. On one hand, the database table and the source code file can be quickly generated, so that manual operation is greatly reduced, and the use is more flexible and simple; on the other hand, the database table is automatically modified by connecting the database and automatically comparing the existing structure of the database, so that the database table is consistent with the actual structure of the database, and the method is beneficial for developers to understand the design of the database.
Drawings
FIG. 1 is a flow chart of the method of the present invention.
Detailed Description
The present invention will be described in further detail with reference to the accompanying drawings, in order to make the objects, technical solutions and advantages of the present invention more apparent. It will be apparent that the described embodiments are only some, but not all, embodiments of the invention. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention. In the present invention, the terms "first," "second," "third," and the like are used for descriptive purposes only and are not to be construed as indicating or implying relative importance.
Term interpretation:
WPS is an office software suite.
WPS loaders are a set of solutions based on Web technology to extend WPS applications.
oem.ini is a file in WPS software.
JsApiPlugin, JSPluginsServer are two parameters in oem.ini file.
JS is fully called JavaScript, which is a scripting language.
Rows, cells are APIs provided by WPS software.
SQL statements are statement structured query languages.
There are two modes in the prior art: firstly, designing a database, and then connecting the database by using other tools to read the table structure to generate a template code. Recording a database table structure by using modes such as an EXCEL table, analyzing the database table structure information by using a code generation tool, generating SQL sentences and source code files created by the database table, and manually copying the SQL sentences of the created table to a database to execute so as to generate the database table; manually copying code under the project source code folder. The two modes or the database and the business code generation are carried out separately, and the operations such as copying, pasting and the like are needed to be carried out manually, which is troublesome; or the table structure document is not maintained after the table structure of the database is modified in the development process, so that the table structure of the document record is inconsistent with the actual structure of the database.
For this purpose, the invention provides a code generation method based on WPS loading items. The WPS loading item is a solution for expanding the WPS application program based on the Web technology, and the webpage opened by the WPS loading item can directly interact with the WPS application program and can share data with each other. In this way, the user opens the file to connect to the database, and by comparing and creating or updating the database table structure and the source code file, the manual operation is greatly reduced, and the development efficiency is improved.
As shown in fig. 1, the code generation method based on WPS load item provided by the present invention includes the following steps:
step 1, displaying code generator loading items on a WPS navigation menu;
step 2, setting code generation parameters of code generator loading items;
step 3, generating a source code file based on the code generator loading item;
the step 3 comprises the following steps:
step 31, generating a database table containing data table information;
step 32, reading information of a database table;
step 33, connecting the database, inquiring whether the database table is generated, if not, creating a new database table, if so, comparing the generated database table with the database table in step 31, and updating the generated database table;
step 34, writing a code template file, and replacing a value needing dynamic replacement in the code template file by using a placeholder;
and 35, reading the uploaded code template file, and replacing a value needing dynamic replacement in the code template file according to the read information of the database table to generate a source code file.
In a specific embodiment, a batch file or script file PowerShell is newly created, the batch file or script file PowerShell is clicked to run, a parameter value of JsApiPlugin, JSPluginsServer in an oem.ini file under the WPS directory is modified, the parameter value is used for enabling a code generator loading item, and after modification, the loading item is automatically loaded and displayed on a WPS navigation menu when the WPS is opened each time.
Clicking a code generator loading item on a WPS navigation bar, clicking parameter setting, inputting parameters such as a database connection name, a database type, a database connection character string, a database name, a database table character set, a class naming strategy, a variable naming strategy, a file saving path, a file name naming strategy, a development language and the like, calling a basic interface FileSystemprovided by the WPS to write the parameters into a local file, loading the WPS loading item, and setting the parameters for multiple times.
Setting a table structure of the database table, and generating the database table containing the data table information based on the designed table structure. The table structure of the database table comprises a plurality of substructures, each substructures comprises one piece of data table information, the first four pieces of behavior table information of each substructures and field information of the table information: the first row comprises two columns, wherein the first column is the table name, and the second column is the field information of the table name; the second row comprises two columns, wherein the first column is a table prefix, and the second column is field information of the table prefix; the third row comprises two columns, wherein the first column is the name of the service module, and the second column is the field information of the name of the service module; the fourth row comprises two columns, wherein the first column is the packet name, and the second column is the field information of the packet name; the fifth row of the table structure comprises a plurality of columns, wherein the first column is a field name, the second column is a field type, the third column is a field description, the fourth column is whether filling is needed, the fifth column is a main key, the sixth column is whether an index is needed, and the seventh column is whether self-increment is needed; the sixth row of the table structure and field information greater than the sixth row of the table structure information. Preferably, there is at least one blank row between each substructure for distinguishing between different data table information.
One of the substructures of the table structure of the database table is shown in table 1 below.
TABLE 1
Reading information of a database table includes: step 321, declaring an empty JS object array for storing all data sheet information; step 322, declaring a first JS object, where the first JS object includes four attributes including a table name, a table prefix, a service module name, and a package name; step 323, calling the first row of the Rows object reading substructure, calling the Cells object to read each column of the first row, skipping if the column value is blank, reading the next column if the column value is a table name, giving the next column value as an attribute value of the table name attribute of the first JS object, reading the column value as three Rows of a table prefix, a business module name and a package name by the same method, and adding the first JS object into the JS object array; step 324, calling the fifth row of the Rows object reading substructure, declaring a second JS object, calling the Cells object to read each column of the fifth row, if the column value is a field name, respectively giving the sequence number and the value of the current column as an attribute name and a corresponding attribute value of the attribute of the second JS object, and reading the rest columns of the fifth row by the same method; step 325, calling a sixth row of the Rows object reading substructure, declaring a third JS object, where the third JS object contains seven attributes with null attribute names, calling the Cells object to read a first column of the sixth row, extracting attribute values corresponding to column numbers of the current column from the second JS object, respectively assigning the extracted attribute values and the values of the current column as attribute names and corresponding attribute values of the first attribute of the third JS object, reading the remaining columns of the sixth row by the same method, and adding the third JS object to the second JS object; step 326, referring to step 325, until a blank line is read, adding the second JS object to the JS object array; step 327, repeating steps 321-326 until the sub-structure including all the data table information is read.
Connecting a database, inquiring whether a database table is generated, if not, generating an SQL statement for creating the table according to the table structure set in the step 3, and creating a new database table; if so, querying field information of the generated database table and comparing the field information with field information of the table structure set in the step 3: and if the generated database table has field information which is not provided with a set table structure and inconsistent field information and the database table has fields which are not provided with a table structure, generating SQL sentences of the newly added fields, the modified fields and the deleted fields respectively, and executing the SQL sentences to update the generated database table. The query and comparison of database tables is prior art, and therefore will not be described in detail.
And writing a code template file according to the programming language developed by the project by a developer. Taking java as an example, to generate an entity service class, a file with the name { # entity } servicel.java is newly created, and the content of the file is:
package {#rootPackage}.{#package}.service;
import {#rootPackage}.{#package}.model.{#entity};
import com.sy.base.service.BaseService;
public interface {#entity}Service extends BaseService<{#entity}> {}
in the code template file, the content to be dynamically replaced is occupied by { #xxx }, wherein { #xxx is called a placeholder, and a specific value is used for replacing the placeholder when the source code file is generated, and the placeholders in the invention are shown in table 2. The application range in table 2 is the application range of the placeholder in the source code file, and the application range is not limited to the application range in the source code file, and the application range in table 2 can be used in the file name and the file content of the source code file, and the file content can only be used in the file content of the source code file.
TABLE 2
Wherein the support naming policies generate names using a specified naming policy, such as sys_subject, generate names sysDidt using hump nomenclature, and generate SysDict using pascal nomenclature.
And finally, reading the uploaded code template file, circulating the JS object array, and replacing placeholders in the code template file by field information of a database table to generate a source code file. If the name of the code template file has a placeholder, the placeholder is replaced by the actual value to form a new file name, and the new file is saved in a path set in the parameter.
Finally, it should be noted that: the above embodiments are merely preferred embodiments of the present invention for illustrating the technical solution of the present invention, but not limiting the scope of the present invention; although the invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical scheme described in the foregoing embodiments can be modified or some or all of the technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit of the corresponding technical solutions; that is, even though the main design concept and spirit of the present invention is modified or finished in an insubstantial manner, the technical problem solved by the present invention is still consistent with the present invention, and all the technical problems are included in the protection scope of the present invention; in addition, the technical scheme of the invention is directly or indirectly applied to other related technical fields, and the technical scheme is included in the scope of the invention.
Claims (9)
1. A code generation method based on WPS load item, comprising the steps of:
step 1, displaying code generator loading items on a WPS navigation menu;
step 2, setting code generation parameters of code generator loading items;
step 3, generating a source code file based on the code generator loading item;
the step 3 comprises the following steps:
step 31, generating a database table containing data table information;
step 32, reading information of a database table;
step 33, connecting the database, inquiring whether the database table is generated, if not, creating a new database table, if so, comparing the generated database table with the database table in step 31, and updating the generated database table;
step 34, writing a code template file, and replacing a value needing dynamic replacement in the code template file by using a placeholder;
and 35, reading the uploaded code template file, and replacing a value needing dynamic replacement in the code template file according to the read information of the database table to generate a source code file.
2. The code generation method based on WPS load item according to claim 1, wherein in step 1, a batch file or script file is created to modify parameter values of configuration parameters of plug-in under WPS directory, and the code generator load item is displayed on the WPS navigation menu.
3. The WPS-loader-based code generation method of claim 1, wherein in step 2, a setting button of the code generator loader is clicked, parameters including a database connection name, a database type, a database connection string, a database name, a database table character set, a class naming policy, a variable naming policy, a file save path, a file name naming policy, a development language are input, and the above parameters are written into the local file.
4. The WPS-loader-based code generation method of claim 1, wherein in step 3, the generation button of the code generator loader is clicked to generate the source code file.
5. The WPS entry-based code generation method of claim 1, wherein in step 31, the table structure of the database table includes a plurality of sub-structures, each sub-structure including one data table information, the first four behavior table information of each sub-structure and field information of the table information: the first row comprises two columns, wherein the first column is the table name, and the second column is the field information of the table name; the second row comprises two columns, wherein the first column is a table prefix, and the second column is field information of the table prefix; the third row comprises two columns, wherein the first column is the name of the service module, and the second column is the field information of the name of the service module; the fourth row comprises two columns, wherein the first column is the packet name, and the second column is the field information of the packet name; the fifth row of the table structure comprises a plurality of columns, wherein the first column is a field name, the second column is a field type, the third column is a field description, the fourth column is whether filling is needed, the fifth column is a main key, the sixth column is whether an index is needed, and the seventh column is whether self-increment is needed; the sixth row of the table structure and field information greater than the sixth row of the table structure information.
6. The WPS entry based code generation method of claim 5 wherein there is at least one blank row between each substructure.
7. The WPS entry based code generation method of claim 6 wherein step 32 includes: step 321, declaring an empty JS object array for storing all data sheet information; step 322, declaring a first JS object, where the first JS object includes four attributes including a table name, a table prefix, a service module name, and a package name; step 323, calling the first row of the Rows object reading substructure, calling the Cells object to read each column of the first row, skipping if the column value is blank, reading the next column if the column value is a table name, giving the next column value as an attribute value of the table name attribute of the first JS object, reading the column value as three Rows of a table prefix, a business module name and a package name by the same method, and adding the first JS object into the JS object array; step 324, calling the fifth row of the Rows object reading substructure, declaring a second JS object, calling the Cells object to read each column of the fifth row, if the column value is a field name, respectively giving the sequence number and the value of the current column as an attribute name and a corresponding attribute value of the attribute of the second JS object, and reading the rest columns of the fifth row by the same method; step 325, calling a sixth row of the Rows object reading substructure, declaring a third JS object, where the third JS object contains seven attributes with null attribute names, calling the Cells object to read a first column of the sixth row, extracting attribute values corresponding to column numbers of the current column from the second JS object, respectively assigning the extracted attribute values and the values of the current column as attribute names and corresponding attribute values of the first attribute of the third JS object, reading the remaining columns of the sixth row by the same method, and adding the third JS object to the second JS object; step 326, referring to step 325, until a blank line is read, adding the second JS object to the JS object array; step 327, repeating steps 321-326 until the sub-structure including all the data table information is read.
8. The WPS entry-based code generation method of claim 1, wherein in step 33, if not, an SQL statement to create a table is generated from the table structure of the database table of step 31, creating a new database table; if so, querying field information of the generated database table and comparing with field information of a table structure of the database table in step 31: and if the generated database table has field information which is not provided with a set table structure and inconsistent field information and the database table has fields which are not provided with a table structure, generating SQL sentences of the newly added fields, the modified fields and the deleted fields respectively, and executing the SQL sentences to update the generated database table.
9. The WPS entry-based code generation method of claim 7, wherein in step 35, the JS object array is circulated, and the source code file is generated by replacing placeholders in the code template file with field information of the database table.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202410028710.9A CN117539450B (en) | 2024-01-09 | Code generation method based on WPS loading item |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202410028710.9A CN117539450B (en) | 2024-01-09 | Code generation method based on WPS loading item |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN117539450A true CN117539450A (en) | 2024-02-09 |
| CN117539450B CN117539450B (en) | 2024-05-10 |
Family
ID=
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20130346302A1 (en) * | 2012-06-20 | 2013-12-26 | Visa International Service Association | Remote Portal Bill Payment Platform Apparatuses, Methods and Systems |
| US20140052617A1 (en) * | 2011-12-13 | 2014-02-20 | Visa International Service Association | Payment platform interface widget generation apparatuses, methods and systems |
| CN114372279A (en) * | 2021-12-17 | 2022-04-19 | 南京中孚信息技术有限公司 | WPS-based JS loading item technology auxiliary password determining system |
| CN115186638A (en) * | 2022-05-17 | 2022-10-14 | 泉州市智管工软件开发有限公司 | Zero code development platform-based engineering data form making method and system |
| CN115237863A (en) * | 2022-09-22 | 2022-10-25 | 中建电子商务有限责任公司 | EXCEL data import method based on WPS loading item |
| CN115562642A (en) * | 2022-10-28 | 2023-01-03 | 天翼电子商务有限公司 | Code generating method based on database and Mustache template engine |
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140052617A1 (en) * | 2011-12-13 | 2014-02-20 | Visa International Service Association | Payment platform interface widget generation apparatuses, methods and systems |
| US20130346302A1 (en) * | 2012-06-20 | 2013-12-26 | Visa International Service Association | Remote Portal Bill Payment Platform Apparatuses, Methods and Systems |
| CN114372279A (en) * | 2021-12-17 | 2022-04-19 | 南京中孚信息技术有限公司 | WPS-based JS loading item technology auxiliary password determining system |
| CN115186638A (en) * | 2022-05-17 | 2022-10-14 | 泉州市智管工软件开发有限公司 | Zero code development platform-based engineering data form making method and system |
| CN115237863A (en) * | 2022-09-22 | 2022-10-25 | 中建电子商务有限责任公司 | EXCEL data import method based on WPS loading item |
| CN115562642A (en) * | 2022-10-28 | 2023-01-03 | 天翼电子商务有限公司 | Code generating method based on database and Mustache template engine |
Non-Patent Citations (3)
| Title |
|---|
| ALAN: "自研摸鱼工具-javafx-mybatis-generator", Retrieved from the Internet <URL:https://zhuanlan.zhihu.com/p/636727703> * |
| ALGIRDAS JASAITIS: "How to Create a Database in Excel (In Easy Steps)", Retrieved from the Internet <URL:https://www.wps.com/blog/how-to-create-a-database-in-excel-in-easy-steps> * |
| ROGERKFL: "WPS自动写代码？只需10秒，学会这技巧！", Retrieved from the Internet <URL:http://www.360doc.com/content/12/0121/07/6308846_1040806158.shtml> * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US6678885B2 (en) | System and method for common code generation | |
| US7873899B2 (en) | Mapping schemes for creating and storing electronic documents | |
| CN108762743B (en) | Data table operation code generation method and device | |
| CN106598612B (en) | Operation method and system for data table in database | |
| US20030084401A1 (en) | Efficient web page localization | |
| CN112015413A (en) | Programming-free data visualization Web display system and implementation method thereof | |
| US8527867B2 (en) | Enabling users to edit very large XML data | |
| CN1591411A (en) | Data processing system | |
| CN110705237B (en) | Automatic document generation method, data processing device and storage medium | |
| JP2014063204A (en) | Data conversion method, and apparatus and program for the same | |
| CN102364437A (en) | Multi-language site development system and implementation method thereof | |
| CN111026756A (en) | Method for dynamically generating form and associated query | |
| CN111241800A (en) | MySQL database table structure document generation method, storage medium and intelligent terminal | |
| KR102490941B1 (en) | An online report creation system using Excel tool | |
| CN117539450B (en) | Code generation method based on WPS loading item | |
| CN117539450A (en) | Code generation method based on WPS loading item | |
| US20100299669A1 (en) | Generation of a Comparison Task List of Task Items | |
| CN104899045A (en) | Universal software coding assistance system and method | |
| CN107844639B (en) | Project standard structure automatic generation method and system | |
| WO2010147453A1 (en) | System and method for designing a gui for an application program | |
| KR102499832B1 (en) | An online report creation system with query binding function | |
| US20120066248A1 (en) | Dynamic Creation of Materialized Database Views | |
| CN112257404A (en) | QT5 software-based automatic generation method and generation device for requirement specification document | |
| CN118035250A (en) | Method for realizing Excel report export based on WPS loading item | |
| CN117216092A (en) | Method, device and equipment for optimizing TDSQL script and readable storage medium |
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 |