CN114510478A - General data entry method, device, equipment and medium based on data model - Google Patents
General data entry method, device, equipment and medium based on data model Download PDFInfo
- Publication number
- CN114510478A CN114510478A CN202111668309.4A CN202111668309A CN114510478A CN 114510478 A CN114510478 A CN 114510478A CN 202111668309 A CN202111668309 A CN 202111668309A CN 114510478 A CN114510478 A CN 114510478A
- Authority
- CN
- China
- Prior art keywords
- data
- entry
- batch
- universal
- user
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2379—Updates performed during online database operations; commit processing
- G06F16/2386—Bulk updating operations
-
- 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
- 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
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/34—Graphical or visual programming
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Software Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Stored Programmes (AREA)
Abstract
The invention provides a data model-based universal data entry method, a data entry device, equipment and a medium, wherein the method comprises a configuration process, a data import process and a visual addition, deletion, modification and check process; the configuration process is to provide a series of configuration interfaces for users to specify a data source and a general input object table, confirm table information and configure table fields; the data import process is to select a configured universal input object table, mainly uploads a file to be imported, and a program analyzes an Execl file input by a user through an API (application program interface) provided by an Apache POI (Point of interest) and converts the file into a List < Map > for storage; carrying out data validity check and main key check; the batch is inserted into the database. By using the invention, after the configuration is completed, the user can easily complete the addition, deletion, modification, check and uploading of the excel import data on one page, for developers, the business table uses a general entry function, the operation of the database is realized without generating corresponding three-layer architecture codes for each data table, no codes are generated additionally, and the work of the developers is greatly reduced.
Description
Technical Field
The invention relates to the technical field of computers, in particular to a data model-based universal data method, device, equipment and medium.
Background
In the development of computer programs, a data model (i.e., a data table) is not separated from a large or small system, and maintaining and managing the data model is very important for one system. Then what the data of a system comes from, in addition to some data built by itself at the time of system development, often times the data needs to be imported from outside the system based on business needs.
When data is imported from the outside of the system, usually, Excel is provided from the outside for large-batch data, and single operation is directly completed on a corresponding operation page for small-batch data. However, the current import aiming at external large-batch Excel data has the following defects:
(1) in terms of code implementation, a corresponding three-layer architecture code needs to be generated for each data table to implement operation on the database, so that the rewriting work of a large number of codes causes heavy tasks for developers, the independence of an input module is poor, and the method cannot adapt to various project systems;
(2) management operations on data, such as adding a new service table to be maintained and the like, can only be realized by developers, and users cannot relate to the service table, so that the workload of the developers is greatly increased;
(3) the user's operation on the data is not a real-time visual operation and cannot obtain intuitive feedback in real time.
Disclosure of Invention
The technical problem to be solved by the invention is to provide a data model-based universal data entry method, device, equipment and medium, wherein a user can easily realize entry of Excel data into a service table of a system only by specifying the service table into which data needs to be imported, and the user can intuitively operate the Excel data as if directly operating a database, so that the Excel data entry method is more beneficial to dynamic maintenance and update of the data; in addition, compared with the traditional entry mode, the user can arbitrarily designate the business table for data entry within a certain limit, and the entry function of which tables is realized by developers is not limited; for developers, in terms of code implementation, the business table uses a general entry function, and respective codes do not need to be generated for each table needing entry, so that the development work is greatly reduced.
In a first aspect, the invention provides a general data entry method based on a data model, which comprises a configuration process, a data import process and a visual addition, deletion, modification and check process;
the configuration process is as follows: providing a series of configuration interfaces for a user to specify a data source and a general input object table, confirming table information and configuring table fields, wherein the configuration table fields comprise whether the designated fields are empty or not and whether the designated fields are primary keys or not; after the user configuration is finished, the background executes and stores the configuration information, and the configuration information is added into the data model; the data model comprises a universal entry batch table, a universal entry table field and universal entry table information, wherein the corresponding entry table ID in the universal entry batch table and the universal entry table field is associated with the primary key ID in the universal entry table information;
the data import process is as follows: displaying the general input list for a user to select a general input object table configured through the configuration process, entering an operation page of the general input object table, and performing the following data import process after an Apache POI tool analyzes an excel file selected by the user:
s1, acquiring data of the Execl file, and converting the data into List < Map > for storage;
s2, carrying out data validity check;
s3, checking the primary key;
s4, inserting the data into a database in batches;
the visual process of adding, deleting, modifying and checking comprises the following steps: and providing interactive buttons for newly adding, deleting, modifying and inquiring on the data operation page of the universal input object table, so that a user can directly perform operations of adding, deleting, modifying and inquiring.
In a second aspect, the present invention provides a data model-based universal data entry device, comprising:
the configuration module is used for providing a series of configuration interfaces for a user to specify a data source and a general input object table, confirming table information and configuring table fields, wherein the configuration table fields comprise indication fields of whether the fields are empty or not and whether the fields are primary keys or not; after the user configuration is finished, the background executes and stores the configuration information, and the configuration information is added into the data model; the data model comprises a universal entry batch table, a universal entry table field and universal entry table information, wherein the corresponding entry table ID in the universal entry batch table and the universal entry table field is associated with the primary key ID in the universal entry table information;
the data import module is used for displaying the general input list, so that a user can select the general input object table configured through the configuration process and enter an operation page of the general input object table, and the following data import process is carried out after an Execl file selected by the user is analyzed by an Apache POI tool:
s1, acquiring the data of the Execl file, and converting the data into List < Map > for storage;
s2, carrying out data validity check;
s3, checking the primary key;
s4, inserting the data into a database in batches;
and the visual adding, deleting, modifying and checking module is used for providing interactive buttons of adding, deleting, modifying and inquiring on the data operation page of the universal input object table, so that a user can directly perform adding, deleting, modifying and checking operations. .
In a third aspect, the present invention provides an electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the method of the first aspect when executing the program.
In a fourth aspect, the invention provides a computer-readable storage medium having stored thereon a computer program which, when executed by a processor, performs the method of the first aspect.
One or more technical solutions provided in the embodiments of the present invention have at least the following technical effects or advantages: the front end largely uses JavaScript to complete the interaction of the user page, so that the operation of the user has the characteristic of real-time visualization; on the back-end implementation, the design uses the API program provided by Apache POI to read and write to Microsoft Office formatted archives. In the aspect of code implementation, the operation of the database is realized without generating a corresponding three-layer architecture code for each data table, the service table uses a general entry function, no code is generated additionally, and only an unaffected field is newly added on the original table. Meanwhile, the system is a pure entry module, has strong independence and is suitable for various project systems. And a part of database management functions and maintenance and management operations of the service table are transferred to a front-end page for users to use, so that the management operation of the users on the data is facilitated, and the workload of developers is reduced.
The foregoing description is only an overview of the technical solutions of the present invention, and the embodiments of the present invention are described below in order to make the technical means of the present invention more clearly understood and to make the above and other objects, features, and advantages of the present invention more clearly understandable.
Drawings
The invention will be further described with reference to the following examples with reference to the accompanying drawings.
FIG. 1 is a schematic view of a data source management interface according to the present invention;
FIG. 2 is a diagram of a data structure according to the present invention;
FIG. 3 is a flow chart of a method according to one embodiment of the present invention;
FIG. 4 is a schematic diagram of a universal entry list according to an embodiment of the present invention;
FIG. 5 is a schematic diagram of a generic entry add interface according to an embodiment of the invention;
FIG. 6 is a diagram illustrating a configuration table field interface according to an embodiment of the invention;
FIG. 7 is a diagram illustrating an operational status of a universal entry list according to an embodiment of the present invention;
FIG. 8 is a table operation page diagram according to an embodiment of the present invention;
FIG. 9 is a diagram illustrating a state of a pop-up operation page in an embodiment of the present invention;
FIG. 10 is a diagram illustrating a table operation page import completion status according to an embodiment of the present invention;
FIG. 11 is a diagram illustrating an exemplary import batch pull status according to an embodiment of the present invention;
FIG. 12 is a schematic view of a visualized add operation according to an embodiment of the present invention;
FIG. 13 is a schematic view of a visual delete operation according to an embodiment of the present invention;
FIG. 14 is a schematic view of a visualized modification operation according to an embodiment of the present invention;
FIG. 15 is a schematic view illustrating the completion of a visual update operation according to an embodiment of the present invention;
FIG. 16 is a diagram illustrating a visualized query operation according to an embodiment of the present invention;
FIG. 17 is a schematic structural diagram of an apparatus according to a second embodiment of the present invention;
fig. 18 is a schematic structural diagram of an electronic device according to a third embodiment of the invention;
FIG. 19 is a schematic structural diagram of a medium according to a fourth embodiment of the present invention.
Detailed Description
By providing the data model-based universal data entry method, device, equipment and medium, a user can easily enter Excel data into a service table of a system only by specifying the service table into which the data needs to be imported, and the user can intuitively operate the Excel data as if the user directly operates a database, so that dynamic maintenance and update of the data are facilitated; in addition, compared with the traditional entry mode, the user can arbitrarily designate the business table for data entry within a certain limit, and the entry function of which tables is realized by developers is not limited; for developers, in terms of code implementation, the business table uses a general entry function, and respective codes do not need to be generated for each table needing entry, so that the development work is greatly reduced.
The technical scheme in the embodiment of the application has the following general idea: the front end largely uses JavaScript to complete the interaction of the user page, so that the operation of the user has the characteristic of real-time visualization; on the back-end implementation, the design uses the API program provided by Apache POI to read and write to Microsoft Office format archives. In code implementation, the operation on the database is realized without generating corresponding three-layer architecture codes for each data table, the operation on the database is completed by using the JDBC technology, and the encapsulation is further completed by using JdbcUtils tools. The service table uses a general entry function, no code is generated additionally, and only the field without influence is newly added on the original table. Meanwhile, the system is a pure entry module, has strong independence and is suitable for various project systems. And a part of database management functions and maintenance and management operations of the service table are transferred to a front-end page for users to use, so that the management operation of the users on the data is facilitated, and the workload of developers is reduced.
The early preparation and database design of the present invention are described below:
one important feature of the universal data entry of the present invention is the "universal" two-character, how does that embody "universal"? That is, the process of completing entry of all tables needing entry is completely consistent (i.e. the codes and the flows are respectively consistent), and the difference is zero. The corresponding architecture code (Controller, Service, Dao, etc.) is not required to be created for each table, and JDBC techniques are used to complete the operation on the database. For convenience of use, packaging is further completed by means of JdbcUtils tools in the implementation process. Later use only needs to complete the two steps of creating a data source in advance and acquiring SQL to execute.
As shown in fig. 1, namely, a data source management interface is used to create data sources in advance. Which supports cross-library operations. However, the same database only needs to be filled with one data source information, and the data source is shared by the operations under the same database.
The data model used by the present invention is shown in FIG. 2: the method comprises a universal input batch table, a universal input table field and universal input table information, wherein corresponding input table IDs are arranged in the universal input batch table and the universal input table field, and the corresponding input table IDs are associated with primary key IDs in the universal input table information; each record in the information of the universal input table corresponds to a table using the universal input function, and the fields of the universal input table store the fields owned by each universal input table. The field corresponding to the universal entry table can be found in the table of the universal entry table field through the unique ID (namely the primary key ID) in the universal entry table information. The data model has only three tables, so that the data model has the advantages of simple structure, clear relationship and conformity to the normal form.
Example one
As shown in fig. 3, the present embodiment provides a general data entry method based on a data model, which includes a configuration process, a data import process, and a visual add-delete-modify-check process;
the configuration process is as follows: providing a series of configuration interfaces for a user to specify a data source and a general input object table, confirming table information and configuring table fields, wherein the configuration table fields comprise whether the designated fields are empty or not and whether the designated fields are primary keys or not; after the user configuration is finished, the background executes and stores the configuration information, and the configuration information is added into the data model; the data model comprises a universal entry batch table, a universal entry table field and universal entry table information, wherein the corresponding entry table ID in the universal entry batch table and the universal entry table field is associated with the primary key ID in the universal entry table information;
as shown in fig. 4, the table entry list is a general entry list, and has a general entry function, so that a user configures a table to be operated, and adds the table to the general entry list. Clicking on "general entry add" in fig. 4 may enter the page of fig. 5, specify the data source and the table, and start configuring the table, where the data source is created in advance through fig. 1. The addition of a new service table using the function according to the generic entry in fig. 5 is actually to add a new entry table information (fs _ general _ entry) recorded in the data model, from which the data of the generic entry list in fig. 4 comes. In the code implementation, unlike its data model, when designing JAVA entity class, an additional attribute of List < FsGeneralEntryColumn > columnList is required to be set for storing the column field information of the universal entry table. And then, acquiring and setting fields owned by a certain universal entry table by a Get/Set method.
And after clicking 'next step', performing table field configuration on the service table using the function. Page as shown in fig. 6, in order to configure the interface of the table fields, the field list shown in the figure is used to show all the fields of the table in the database, and the description of reading the fields is used as "description". The program executes the Sql statement to obtain the field information of the table, taking Mysql as an example, the statement is: a COLUMN NAME of "caption" is taken as "caption" if "caption" is empty, i.e., a list COLUMN _ NAME, a list _ symbol _ schema, a database NAME, and a list NAME (the statements of sqlServer and Oracle are slightly different). The display of this field on the page and the import template will then use this "description".
There may be a plurality of columns as the "primary key" for judging whether the number is repeated (for example, a user is determined based on the name and the mobile phone number), and the primary key is fixed not to be empty. The "display form type" is a text type by default, and may be selected as a number or a time type. The need to select as a time type specifies a "special field format" (i.e., time format) for this field; the column field format of text and numeric type does not work.
The data import process is as follows: after the adding operation of the general entry is completed, a newly added table can be found in the general entry list. As shown in fig. 7, displaying the universal entry list for the user to select the universal entry object table configured by the configuration process, clicking the "operation" button recorded in the universal entry object table, as shown in fig. 8, entering the data operation page of the universal entry object table, clicking the import button, as shown in fig. 9, popping up an import box, providing direct import and "download template" import on the import box, if the user selects direct import, manually checking whether the column name is consistent with the description in the table configuration, if the "download template" import is selected, importing by using the downloaded template without manually checking whether the column name is consistent with the description in the table configuration, and subsequently performing a data import process on the Execl file selected by the user by using an Apache tool, where the Apache is an open source code POI library of the Apache software foundation, and the POI provides a Java API to the functions of reading and writing Microsoft Office format archives, the data import process is as follows:
s1, acquiring the data of the Execl file, and converting the data into List < Map > for storage;
s2, carrying out data validity check;
s3, checking the primary key;
s4, inserting the data into the database in batch, and after the data is successfully imported, the data is shown in figure 10.
The data operation page shown in fig. 8 is a data presentation and operation page of a table, and a series of data operations of importing, adding, deleting, modifying, and checking may be performed on the data operation page.
The visual process of adding, deleting, modifying and checking comprises the following steps: and providing interactive buttons for newly adding, deleting, modifying and inquiring on the data operation page of the universal input object table, so that a user can directly perform operations of adding, deleting, modifying and inquiring.
As a more preferred or specific implementation manner of this embodiment, the method further includes importing a batch withdrawal process;
the import batch withdrawal process is as follows: providing an interactive button for importing batch withdrawal on a data operation page of the universal entry object table, so that a user can directly perform import batch withdrawal operation, when the interactive button for importing batch withdrawal is triggered, as shown in fig. 11, firstly displaying records which are imported and not yet withdrawn, and when the interactive button is selected by the user, matching all data imported in the same batch according to the same value of an import batch identification field, and performing batch deletion.
Specifically, after the table field configuration is completed, the background executes an initialization process when executing the saving, that is:
judging whether an identification column exists in a business table corresponding to the universal input object table to serve as the unique identification of each record;
if yes, ending the initialization process;
if not, executing the alter statement to modify the table structure, newly adding a record identification column with the column name of 'FS _ GENERAL _ UUID', and generating a unique random value by using a database function; then judging whether the initialization is successful, if so, ending the initialization process; if not, deleting the newly added unique identification column to restore the table structure, and re-executing the initialization process.
In the data importing process:
the S1 specifically includes:
s11, receiving the excel file transmitted from the foreground by the MultipartFile class, and calling a getInputStream method to convert the file into an input stream form to read the content of the excel file;
s12, acquiring the name of the file by a getOriginalFilename method, creating a Workbook object according to the suffix of the name, creating an HSSFWorkbook object if the suffix is xls, and creating an XSSFWorkbook object if the suffix is xlsx;
s13, creating a container of ArrayList < Map < String, Object > > type, storing the content in the general input Object table into the container, acquiring the sheet of the Workbook Object, and calling the getRow method of the sheet Object to acquire the data of the specified row;
when the data of the first row is acquired, firstly, the column names (Chinese of the column names) of each column of the data of the first row are stored by using an ordered set List and are used as keys of each Map in a List < Map > container, and then, each subsequent row of data is acquired in a traversing manner and is stored in the List < Map > container and is used as a value of each Map in the List < Map > container; it should be noted that, when the value of each row of cells is obtained as the value of Map, it is necessary to determine the type (character string, number, time type, etc.) of the cell and perform corresponding processing (such as formatting time, etc.);
the S2 is specifically: carrying out data validity check, wherein the data validity check is divided into a null field validity judgment, a data type judgment and a format judgment, and a regular expression is required to be used for carrying out the data validity check on a field of a time format;
the S3 is specifically: before each piece of data is inserted, a field of the data set as a main key is taken out, column description is converted into a column name, a data value is added, a query SQL statement is spliced, a packaged JDBC tool class is used for directly executing the query SQL, whether the fields with the same main key exist or not is searched, and repeated data is not allowed to be inserted;
the S4 is specifically: adding an import BATCH identification field with a field name of 'FS _ GENERAL _ BATCH _ ID' to a universal entry object table to identify an import BATCH, wherein an import BATCH identification field needs to be additionally inserted in each insertion operation; after completing the above S1 to S3, the values stored in the List < Map > container (this value includes the key and value of each Map) are spliced into a batch inserted SQL statement, and executed using JDBC tool class as well; after the batch insertion is finished, correspondingly adding a record in the universal input batch table, recording input information (input state and input quantity), and associating the record with data in the universal input object table;
the visual increasing, deleting and checking process comprises the following conditions:
(1) as shown in fig. 12, the interaction on the data operation page is mostly implemented by using jQuery, when an additional operation button is triggered, a line of text box is newly added on the data operation page for a user to input a new data text, and a background completes a new data library insertion operation; each row Tr has a plurality of cells td which can be acquired by transmitting column information through a background, the background firstly checks whether the page has operations for submitting completion, and if the page has a completion event, the completion event is executed firstly; if not, a variable label is created, the page tag code is spliced, assigned to the variable label, then the tbody element is found, and the tag is inserted into the table using the prepend method, i.e., $ ("tbody"). When a user inputs legal data and triggers to finish a newly added event, acquiring all text box contents of the newly added row tr, corresponding to column descriptions one by one, storing the contents into an array in a key value pair mode, converting the array into json, then executing an ajax request, transmitting the json of the newly added data and a row record ID to a background, judging whether the row record ID is empty by the background, executing a new adding operation if the row record ID is empty, and executing an updating operation if the row record ID is not empty;
the background acquires data, converts the data into List < Map > convenient for Java operation, performs data validity check, passes the check, converts the column description into a column name, adds a data value, well splices and inserts Sql, executes the Sql by using a packaged JDBC tool class, and completes the insertion of a newly added record into the database;
(2) as shown in fig. 13, when an operation button for deleting any record is triggered on the data operation page, the background deletes the piece of data according to the FS _ generall _ UUID of the record, and when the operation button for batch deletion is triggered, the selected plurality of records perform batch deletion together;
(3) as shown in fig. 14, when a user triggers a modify table event on the data manipulation page, double-clicking the cell into an edit state (text box) can directly manipulate the data to be modified on the page. Multiple values of the same row can be edited. Double clicking on another row or clicking "done" completes the data update operation. The modification operation is implemented similarly to the addition, and the flag for performing modification and addition is the FS _ generall _ UUID mentioned above, so that the data record to be modified can be located according to the FS _ generall _ UUID, and the modification operation is performed accurately, and the update operation is shown in fig. 15.
(4) As shown in fig. 16, when a user triggers a query event on the data operation page, a field set for query when saving the entry table or modifying the entry table shows a query box on the page, and when the user clicks the query event on the query trigger page and inputs a query condition, the user queries according to the condition input by the user. When the type of the query field is text or number, querying according to a set query mode, wherein the query mode of the field can be fuzzy query (like) or precise query (the same); the field type is temporal and will provide a time control to query based on the start time and the end time. When the page is returned, the relevant information queryMapList of the query column is also returned,
model.addAttribute("queryMapList",queryMapList)。
based on the same inventive concept, the application also provides a device corresponding to the method in the first embodiment, which is detailed in the second embodiment.
Example two
As shown in fig. 17, in the present embodiment, there is provided a data model-based general data entry device, including:
the configuration module is used for providing a series of configuration interfaces for a user to specify a data source and a general input object table, confirming table information and configuring table fields, wherein the configuration table fields comprise indication fields of whether the fields are empty or not and whether the fields are primary keys or not; after the user configuration is finished, the background executes and stores the configuration information, and the configuration information is added into the data model; the data model comprises a universal entry batch table, a universal entry table field and universal entry table information, wherein the corresponding entry table ID in the universal entry batch table and the universal entry table field is associated with the primary key ID in the universal entry table information;
as shown in fig. 4, the table entry list is a general entry list, and has a general entry function, so that a user configures a table to be operated, and adds the table to the general entry list. Clicking on "general entry add" in fig. 4 may enter the page of fig. 5, specify the data source and the table, and start configuring the table, where the data source is created in advance through fig. 1. Adding a table according to the generic entry addition in fig. 5 is actually adding a table recorded in the generic entry table information (fs _ general _ entry) in the data model, and the data of the generic entry table in fig. 4 comes from this. In the code implementation, unlike its data model, when designing JAVA entity class, an additional attribute of List < FsGeneralEntryColumn > columnList is required to be set for storing the column field information of the universal entry table. And then, acquiring and setting fields owned by a certain universal entry table by a Get/Set method.
And after clicking the next step, carrying out table field configuration on the universal entry table. Page as shown in fig. 6, in order to configure the interface of the table field, the field list shown in the figure is used to show all the fields of the table in the database, and the description of reading the field is used as "description". The program executes the Sql statement to obtain the field information of the table, taking Mysql as an example, the statement is: a COLUMN NAME of "caption" is taken as "caption" if it is empty, i.e., selected COLUMN _ NAME, COLUMN _ program _ format _ schema, database NAME and table _ NAME (the statements of SqlServer and Oracle are slightly different). The display of this field on the page and the import template will then use this "description".
There may be a plurality of columns as the "primary key" for judging whether the number is repeated (for example, for identifying a user by name and mobile phone number), and the primary key is fixed and not empty. The "display form type" is a text type by default, and may be selected as a number or a time type. The need to select as a time type specifies a "special field format" (i.e., time format) for this field; the column field format of text and numeric type does not work.
The data import module is used for displaying the general input list, so that a user can select the general input object table configured through the configuration process and enter an operation page of the general input object table, and the following data import process is carried out after an Execl file selected by the user is analyzed by an Apache POI tool:
s1, acquiring data of the Execl file, and converting the data into List < Map > for storage;
s2, carrying out data validity check;
s3, checking the primary key;
s4, inserting the data into a database in batches;
after the adding operation of the general entry is completed, a newly added table can be found in the general entry list. As shown in fig. 7, the universal entry list is displayed for the user to select the universal entry object table configured by the configuration process, click the "operate" button of the record in the universal entry object table, as shown in fig. 8, upon entering the data manipulation page of the generic entry object table, click the import button, as shown in fig. 9, a lead-in box is popped up, direct lead-in and "download template" lead-in are provided on the lead-in box, if the user selects direct lead-in, the user needs to manually check whether the column name is consistent with the column description in the table configuration, if the user selects "download template" lead-in, and importing by using the downloaded template without manually checking whether the column name is consistent with the column description in the table configuration, and then performing a data import process on the excell file selected by the user by using an Apache POI tool, wherein the Apache POI is an open source code function library of an Apache software foundation, and the POI provides an API for a Java program to have a function of reading and writing the Microsoft Office format archive.
And the visual adding, deleting, modifying and checking module is used for providing interactive buttons of adding, deleting, modifying and inquiring on the data operation page of the universal input object table, so that a user can directly perform adding, deleting, modifying and checking operations.
As a more preferred or specific implementation manner of this embodiment, the apparatus further includes:
and the import batch withdrawal module is used for providing an import batch withdrawal interactive button on the data operation page of the universal entry object table for a user to directly perform import batch withdrawal operation, when the import batch withdrawal interactive button is triggered, as shown in fig. 11, records which are imported and not withdrawn are displayed firstly, and when the records are selected by the user, all data imported in the same batch are matched according to the values of the import batch identification fields, and are deleted in batches.
Specifically, when the configuration module completes the configuration of the table fields and the background executes the saving, the configuration module first executes an initialization process, that is:
judging whether an identification column exists in a business table corresponding to the universal input object table to serve as the unique identification of each record;
if yes, ending the initialization process;
if not, executing the alter statement to modify the table structure, newly adding a record identification column with the column name of 'FS _ GENERAL _ UUID', and generating a unique random value by using a database function; then judging whether the initialization is successful, if so, ending the initialization process; if not, deleting the newly added unique identification column to restore the table structure, and re-executing the initialization process.
In the data importing process:
the S1 specifically includes:
s11, receiving the excel file transmitted from the foreground by the MultipartFile class, and calling a getInputStream method to convert the file into an input stream form to read the content of the excel file;
s12, acquiring the name of the file by a getOriginalFilename method, creating a Workbook object according to the suffix of the name, creating an HSSFWorkbook object if the suffix is xls, and creating an XSSFWorkbook object if the suffix is xlsx;
s13, creating a container of ArrayList < Map < String, Object > > type, storing the content in the general input Object table into the container, acquiring the sheet of the Workbook Object, and calling the getRow method of the sheet Object to acquire the data of the specified row;
when the data of the first row is acquired, firstly, the column names (Chinese of the column names) of each column of the data of the first row are stored by using an ordered set List and are used as keys of each Map in a List < Map > container, and then, each subsequent row of data is acquired in a traversing manner and is stored in the List < Map > container and is used as a value of each Map in the List < Map > container; it should be noted that, when the value of each row of cells is obtained as the value of Map, it is necessary to determine the type (character string, number, time type, etc.) of the cell and perform corresponding processing (such as formatting time, etc.);
the S2 is specifically: carrying out data validity check, wherein the data validity check is divided into a null field validity judgment, a data type judgment and a format judgment, and a regular expression is required to be used for carrying out the data validity check on a field of a time format;
the S3 is specifically: before each piece of data is inserted, a field of the data set as a main key is taken out, column description is converted into a column name, a data value is added, a query SQL statement is spliced, a packaged JDBC tool class is used for directly executing the query SQL, whether the fields with the same main key exist or not is searched, and repeated data is not allowed to be inserted;
the S4 is specifically: adding an import BATCH identification field with a field name of 'FS _ GENERAL _ BATCH _ ID' to a universal entry object table to identify an import BATCH, wherein an import BATCH identification field needs to be additionally inserted in each insertion operation; after the steps from S1 to S3 are completed, the values stored in the List < Map > container are spliced into SQL statements which are inserted in batches, and the SQL statements are executed by using JDBC tool classes; after the batch insertion is finished, correspondingly adding a record in the universal input batch table, recording input information (input state and input quantity), and associating the record with data in the universal input object table;
the visualized add-delete-modify-check module executes the following processes:
(1) as shown in fig. 12, the interaction on the data operation page is mostly implemented by using jQuery, when an additional operation button is triggered, a line of text box is newly added on the data operation page for a user to input a new data text, and a background completes a new data library insertion operation; each row Tr has a plurality of cells td which can be acquired by transmitting column information through a background, the background firstly checks whether the page has operations for submitting completion, and if the page has a completion event, the completion event is executed firstly; if not, a variable label is created, the page tag code is spliced, assigned to the variable label, then the tbody element is found, and the tag is inserted into the table using the prepend method, i.e., $ ("tbody"). When a user inputs legal data and triggers to finish a newly added event, acquiring all text box contents of the newly added row tr, corresponding to column descriptions one by one, storing the contents into an array in a key value pair mode, converting the array into json, then executing an ajax request, transmitting the json of the newly added data and a row record ID to a background, judging whether the row record ID is empty by the background, executing a new adding operation if the row record ID is empty, and executing an updating operation if the row record ID is not empty;
the background acquires data, converts the data into List < Map > convenient for Java operation, performs data validity check, passes the check, converts the column description into a column name, adds a data value, well splices and inserts Sql, executes the Sql by using a packaged JDBC tool class, and completes the insertion of a newly added record into the database;
(2) as shown in fig. 13, when an operation button for deleting any record is triggered on the data operation page, the background deletes the piece of data according to the FS _ generall _ UUID of the record, and when the operation button for batch deletion is triggered, the selected plurality of records perform batch deletion together;
(3) as shown in fig. 14, when a user triggers a modify table event on the data manipulation page, double-clicking the cell into an edit state (text box) can directly manipulate the data to be modified on the page. Multiple values of the same row can be edited. Double clicking on another row or clicking "done" completes the data update operation. The modification operation is implemented similarly to the addition, and the flag for performing modification and addition is the FS _ generall _ UUID mentioned above, so that the data record to be modified can be located according to the FS _ generall _ UUID, and the modification operation is performed accurately, and the update operation is shown in fig. 15.
(4) As shown in fig. 16, when a user triggers a query event on a data operation page, a field set as a query when saving or modifying an entry table displays a query box on the page, and when the user clicks the query event on the query trigger page and inputs a query condition, the user queries according to the condition input by the user. When the type of the query field is text or number, querying according to a set query mode, wherein the query mode of the field can be fuzzy query (like) or precise query (the same); the field type is temporal and will provide a time control to query based on the start time and the end time. When the page is returned, relevant information of the query column, queryMapList, model.
Since the apparatus described in the second embodiment of the present invention is an apparatus used for implementing the method of the first embodiment of the present invention, based on the method described in the first embodiment of the present invention, a person skilled in the art can understand the specific structure and the deformation of the apparatus, and thus the details are not described herein. All the devices adopted in the method of the first embodiment of the present invention belong to the protection scope of the present invention.
Based on the same inventive concept, the application provides an electronic device embodiment corresponding to the first embodiment, which is detailed in the third embodiment.
EXAMPLE III
The present embodiment provides an electronic device, as shown in fig. 18, which includes a memory, a processor, and a computer program stored in the memory and executable on the processor, and when the processor executes the computer program, any one of the first embodiment modes may be implemented.
Since the electronic device described in this embodiment is a device used for implementing the method in the first embodiment of the present application, based on the method described in the first embodiment of the present application, a specific implementation of the electronic device in this embodiment and various variations thereof can be understood by those skilled in the art, and therefore, how to implement the method in the first embodiment of the present application by the electronic device is not described in detail herein. The equipment used by those skilled in the art to implement the methods in the embodiments of the present application is within the scope of the present application.
Based on the same inventive concept, the application provides a storage medium corresponding to the fourth embodiment, which is described in detail in the fourth embodiment.
Example four
The present embodiment provides a computer-readable storage medium, as shown in fig. 19, on which a computer program is stored, and when the computer program is executed by a processor, any one of the first embodiment can be implemented.
The technical scheme provided in the embodiment of the application at least has the following technical effects or advantages: the methods, devices, systems, apparatuses, and media provided by embodiments of the present application,
as will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, apparatus or system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
Although specific embodiments of the invention have been described above, it will be understood by those skilled in the art that the specific embodiments described are illustrative only and are not limiting upon the scope of the invention, and that equivalent modifications and variations can be made by those skilled in the art without departing from the spirit of the invention, which is to be limited only by the appended claims.
Claims (10)
1. A general data entry method based on a data model is characterized in that: the method comprises a configuration process, a data import process and a visual adding, deleting, modifying and checking process;
the configuration process is as follows: providing a series of configuration interfaces for a user to specify a data source and a general input object table, confirming table information and configuring table fields, wherein the configuration table fields comprise whether the designated fields are empty or not and whether the designated fields are primary keys or not; after the user configuration is finished, the background executes and stores the configuration information, and the configuration information is added into the data model; the data model comprises a universal entry batch table, a universal entry table field and universal entry table information, wherein the corresponding entry table ID in the universal entry batch table and the universal entry table field is associated with the primary key ID in the universal entry table information;
the data import process is as follows: displaying the general input list for a user to select a general input object table configured through the configuration process, entering an operation page of the general input object table, and performing the following data import process after an Apache POI tool analyzes an Execl file selected by the user:
s1, acquiring data of the Execl file, and converting the data into List < Map > for storage;
s2, carrying out data validity check;
s3, checking the primary key;
s4, inserting the data into a database in batches;
the visual process of adding, deleting, modifying and checking comprises the following steps: and providing interactive buttons for newly adding, deleting, modifying and inquiring on the data operation page of the universal input object table, so that a user can directly perform operations of adding, deleting, modifying and inquiring.
2. A data model-based universal data entry method according to claim 1, wherein: when the background executes and stores the user configuration, an initialization process is executed firstly, namely:
judging whether an identification column exists in a business table corresponding to the universal input object table to serve as the unique identification of each record;
if yes, ending the initialization process;
if not, executing the alter statement to modify the table structure, newly adding a record identification column, and generating a unique random value by using a database function; then judging whether the initialization is successful, if so, ending the initialization process; if not, deleting the newly added unique identification column to restore the table structure, and re-executing the initialization process.
3. A data model-based universal data entry method according to claim 1, wherein: in the data importing process:
the S1 specifically includes:
s11, receiving the excel file transmitted from the foreground by the MultipartFile class, and calling a getInputStream method to convert the file into an input stream form to read the content of the excel file;
s12, acquiring the name of the file by a getOriginalFilename method, creating a Workbook object according to the suffix of the name, creating an HSSFWorkbook object if the suffix is xls, and creating an XSSFWorkbook object if the suffix is xlsx;
s13, creating a container of ArrayList < Map < String, Object > > type, storing the content in the general input Object table into the container, acquiring the sheet of the Workbook Object, and calling the getRow method of the sheet Object to acquire the data of the specified row;
when the data of the first row is obtained, firstly, the column names of each column of the data of the first row are stored by using an ordered set List as the key of each Map in a later List < Map > container, and then, each subsequent row of data is obtained in a traversing manner and stored in the List < Map > container as the value of each Map in the later List < Map > container;
the S2 is specifically: carrying out data validity check, wherein the data validity check is divided into a null field validity judgment, a data type judgment and a format judgment, and a regular expression is required to be used for carrying out the data validity check on a field of a time format;
the S3 is specifically: before each piece of data is inserted, a field of the data set as a main key is taken out, column description is converted into a column name, a data value is added, a query SQL statement is spliced, a packaged JDBC tool class is used for directly executing the query SQL, whether the fields with the same main key exist or not is searched, and repeated data is not allowed to be inserted;
the S4 is specifically: adding an import batch identification field for identifying an import batch to a general entry object table, and then additionally inserting an import batch identification field in each insertion operation; after the steps from S1 to S3 are completed, splicing the values stored in the List < Map > container into SQL statements which are inserted in batches, and executing the SQL statements by using JDBC tool classes; after the batch insertion is finished, correspondingly adding a record in the universal input batch table, recording import information, and associating the record with data in the universal input object table;
the visual increasing, deleting and checking process comprises the following conditions:
(1) when the newly added operation button is triggered, a line of text box is newly added on the data operation page for a user to input a newly added data text, and the background completes the newly added data library insertion operation: when a user inputs legal data and triggers to finish a newly added event, acquiring all text box contents of the newly added row tr, corresponding to column descriptions one by one, storing the contents into an array in a key value pair mode, converting the array into json, then executing an ajax request, transmitting the json of the newly added data and a row record ID to a background, judging whether the row record ID is empty by the background, executing a new adding operation if the row record ID is empty, and executing an updating operation if the row record ID is not empty;
the background acquires data, converts the data into List < Map > convenient for Java operation, performs data validity check, passes the check, converts the column description into a column name, adds a data value, well splices and inserts Sql, executes the Sql by using a packaged JDBC tool class, and completes the insertion of a newly added record into the database;
(2) when any one record deleting operation button is triggered, the background deletes the data according to the recorded FS _ GENERAL _ UUID, and when the batch deleting operation button is triggered, the selected records are deleted in batch;
(3) when a user triggers a table modification event on a data operation page, the background can position a data record to be modified according to FS _ GENERAL _ UUID, and accurately modify the data record;
(4) when a user triggers a query event on a data operation page, a query frame is displayed on the page by a field set as query when an entry table is saved or modified, and query is performed according to conditions input by the user.
4. A data model-based universal data entry method according to claim 1, wherein: also includes importing a batch withdrawal process;
the import batch withdrawal process is as follows: and providing an interactive button for importing batch withdrawal on a data operation page of the universal entry object table, so that a user can directly conduct import batch withdrawal operation, when the interactive button for importing batch withdrawal is triggered, displaying the imported and unretracted records, matching all imported data of the same batch according to the same value of the import batch identification field when the interactive button is selected by the user, and deleting the data in batch.
5. A general data entry device based on data model is characterized in that: the method comprises the following steps:
the configuration module is used for providing a series of configuration interfaces for a user to specify a data source and a general input object table, confirming table information and configuring table fields, wherein the configuration table fields comprise indication fields of whether the fields are empty or not and whether the fields are primary keys or not; after the user configuration is finished, the background executes and stores the configuration information, and the configuration information is added into the data model; the data model comprises a universal entry batch table, a universal entry table field and universal entry table information, wherein the corresponding entry table ID in the universal entry batch table and the universal entry table field is associated with the primary key ID in the universal entry table information;
the data import module is used for displaying the general input list, so that a user can select the general input object table configured through the configuration process and enter an operation page of the general input object table, and the following data import process is carried out after an Execl file selected by the user is analyzed by an Apache POI tool:
s1, acquiring data of the Execl file, and converting the data into List < Map > for storage;
s2, carrying out data validity check;
s3, checking the primary key;
s4, inserting the data into a database in batches;
and the visual adding, deleting, modifying and checking module is used for providing interactive buttons of adding, deleting, modifying and inquiring on the data operation page of the universal input object table, so that a user can directly perform adding, deleting, modifying and checking operations.
6. A data model-based universal data entry device as claimed in claim 5, wherein: when the background executes and stores the user configuration, an initialization process is executed firstly, namely:
judging whether an identification column exists in a business table corresponding to the universal input object table to serve as the unique identification of each record;
if yes, ending the initialization process;
if not, executing the alter statement to modify the table structure, newly adding a record identification column, and generating a unique random value by using a database function; then judging whether the initialization is successful, if so, ending the initialization process; if not, deleting the newly added unique identification column to restore the table structure, and re-executing the initialization process.
7. A data model-based universal data entry device as claimed in claim 5, wherein: in the data importing process:
the S1 specifically includes:
s11, receiving the excel file transmitted from the foreground by the MultipartFile class, and calling a getInputStream method to convert the file into an input stream form to read the content of the excel file;
s12, acquiring the name of the file by a getOriginalFilename method, creating a Workbook object according to the suffix of the name, creating an HSSFWorkbook object if the suffix is xls, and creating an XSSFWorkbook object if the suffix is xlsx;
s13, creating a container of ArrayList < Map < String, Object > > type, storing the content in the general input Object table into the container, acquiring the sheet of the Workbook Object, and calling the getRow method of the sheet Object to acquire the data of the specified row;
when the data of the first row is obtained, firstly, the column names of each column of the data of the first row are stored by using an ordered set List as keys of each Map in a List < Map > container, and then, each subsequent row of data is obtained in a traversing manner and stored in the List < Map > container;
the S2 is specifically: carrying out data validity check, wherein the data validity check comprises the steps of judging the validity of a blank field, judging the type of data and judging the format, and the fields of a time format need to be subjected to validity check by using a regular expression;
the S3 is specifically: before each piece of data is inserted, a field of the data set as a main key is taken out, column description is converted into a column name, a data value is added, a query SQL statement is spliced, a packaged JDBC tool class is used for directly executing the query SQL, whether the fields with the same main key exist or not is searched, and repeated data is not allowed to be inserted;
the S4 is specifically: adding an import batch identification field for identifying an import batch to a general entry object table, and then additionally inserting an import batch identification field in each insertion operation; after the batch insertion is finished, correspondingly adding a record in the universal input batch table, recording import information, and associating the record with data in the universal input object table;
the visualized adding, deleting, modifying and checking module executes the following specific processes:
(1) when the newly added operation button is triggered, a line of text box is newly added on the data operation page for a user to input a newly added data text, and the background finishes the operation of inserting a newly added data library; when a user inputs legal data and triggers to finish a newly added event, acquiring all text box contents of the newly added row tr, corresponding to column descriptions one by one, storing the contents into an array in a key value pair mode, converting the array into json, then executing an ajax request, transmitting the json of the newly added data and a row record ID to a background, judging whether the row record ID is empty by the background, executing a new adding operation if the row record ID is empty, and executing an updating operation if the row record ID is not empty;
the background acquires data, converts the data into List < Map > convenient for Java operation, performs data validity check, passes the check, converts the column description into a column name, adds a data value, well splices and inserts Sql, executes the Sql by using a packaged JDBC tool class, and completes the insertion of a newly added record into the database;
(2) when any one record deleting operation button is triggered, the background deletes the data according to the recorded FS _ GENERAL _ UUID, and when the batch deleting operation button is triggered, the selected records are deleted in batch;
(3) when a user triggers a table modification event on a data operation page, the background can position a data record to be modified according to FS _ GENERAL _ UUID, and accurately modify the data record;
(4) when a user triggers a query event on a data manipulation page, a field set to query when saving the entry form or modifying the entry form will present a query box on the page.
8. A data model-based universal data entry device as claimed in claim 5, wherein: further comprising:
and the import batch withdrawal module is used for providing an import batch withdrawal interactive button on the data operation page of the universal entry object table for a user to directly carry out import batch withdrawal operation, when the import batch withdrawal interactive button is triggered, the imported and unretracted records are firstly displayed, and when the import batch withdrawal interactive button is selected by the user, all the imported data in the same batch are matched according to the same value of the import batch identification field, and are deleted in batches.
9. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the method according to any of claims 1 to 4 when executing the program.
10. A computer-readable storage medium, on which a computer program is stored which, when being executed by a processor, carries out the method according to any one of claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111668309.4A CN114510478A (en) | 2021-12-31 | 2021-12-31 | General data entry method, device, equipment and medium based on data model |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111668309.4A CN114510478A (en) | 2021-12-31 | 2021-12-31 | General data entry method, device, equipment and medium based on data model |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114510478A true CN114510478A (en) | 2022-05-17 |
Family
ID=81548064
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111668309.4A Pending CN114510478A (en) | 2021-12-31 | 2021-12-31 | General data entry method, device, equipment and medium based on data model |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114510478A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115422280A (en) * | 2022-11-04 | 2022-12-02 | 杭州西湖新基建数字技术有限公司 | Interface method for data addition, deletion and modification of uncertain data structure |
| CN115544006A (en) * | 2022-09-23 | 2022-12-30 | 北京上里科技文化有限公司 | General database data operation model and construction method thereof |
| CN115630086A (en) * | 2022-12-22 | 2023-01-20 | 西安葡萄城软件有限公司 | Method for converting Access application into Web application program |
| CN116049196A (en) * | 2023-03-07 | 2023-05-02 | 杭州巨创网络科技有限公司 | System, method, electronic device and medium for updating database based on target form |
-
2021
- 2021-12-31 CN CN202111668309.4A patent/CN114510478A/en active Pending
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115544006A (en) * | 2022-09-23 | 2022-12-30 | 北京上里科技文化有限公司 | General database data operation model and construction method thereof |
| CN115422280A (en) * | 2022-11-04 | 2022-12-02 | 杭州西湖新基建数字技术有限公司 | Interface method for data addition, deletion and modification of uncertain data structure |
| CN115422280B (en) * | 2022-11-04 | 2023-02-14 | 杭州西湖新基建数字技术有限公司 | Interface method for increasing, deleting and modifying data of uncertain data structure |
| CN115630086A (en) * | 2022-12-22 | 2023-01-20 | 西安葡萄城软件有限公司 | Method for converting Access application into Web application program |
| CN116049196A (en) * | 2023-03-07 | 2023-05-02 | 杭州巨创网络科技有限公司 | System, method, electronic device and medium for updating database based on target form |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11514033B2 (en) | System for providing dynamic linked panels in user interface | |
| US20230385033A1 (en) | Storing logical units of program code generated using a dynamic programming notebook user interface | |
| CN114510478A (en) | General data entry method, device, equipment and medium based on data model | |
| US10311078B2 (en) | Identifying and formatting data for data migration | |
| KR101323011B1 (en) | Command user interface for displaying selectable functionality controls in a database application | |
| US10423392B2 (en) | Systems and methods for transactional applications in an unreliable wireless network | |
| US11301643B2 (en) | String extraction and translation service | |
| US20150261507A1 (en) | Validating sql queries in a report | |
| CN107578217B (en) | Working electronic flow autonomous generation method and device and office management system | |
| US20230102947A1 (en) | Providing operations in accordance with worksheet relationships and data object relationships | |
| CN114461612A (en) | Database-based data management method and management system | |
| US10942732B1 (en) | Integration test framework | |
| US11010140B2 (en) | Integration of workflow and logical data objects using visual programming | |
| US9530115B2 (en) | Message evaluation tool | |
| US20230035835A1 (en) | System and method of a modular framework for configuration and reuse of web components | |
| US20230086037A1 (en) | Graphical diagram comparison | |
| US11640229B2 (en) | Control menu for navigating parent view content | |
| US11861377B1 (en) | Reuseable groupings of app extensions | |
| US20220350447A1 (en) | Editor for the creation and modification of data model metadata | |
| US20240037325A1 (en) | Ability to add non-direct ancestor columns in child spreadsheets | |
| US8869028B2 (en) | Interface structures and associated method for automated mining of legacy systems using visual configuration tools | |
| US20210042289A1 (en) | Persistent and configurable multidimensional data constraints | |
| CN117453713A (en) | SQL sentence generation method, device and storage medium for multi-type database | |
| WO2022231775A1 (en) | Editor for the creation and modification of data model metadata | |
| CN115630243A (en) | Page processing method and device, electronic equipment and 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 |