Data entry and output method and device capable of verifying data validity in real time

Abstract

The invention discloses a data entry and output method and device capable of verifying data validity in real time, and relates to the technical field of data input, verification and generation, and the method comprises the following steps: S1, loading and analyzing an XSD configuration file to obtain a plurality of data structures, each data structure corresponding to a data table; s2, generating a data entry interface according to the content of the data table for a user to create and manage data; s3, generating a specific data item interaction window on the data entry interface, performing data entry by using the interaction window, and verifying the validity of the entered data in real time; wherein the interaction window body comprises prompt information and a data interaction control; and S4, storing the input data and outputting files in various data formats. According to the method, the corresponding input interface is automatically generated by loading the XSD configuration file, the data input process is managed and controlled, the validity of the input value is verified in real time, and output of various data files is supported.

Description

Technical Field

[0001] This invention relates to the field of data input, verification, and generation technology, and more specifically to a data input and output method and apparatus capable of verifying data validity in real time. Background Technology

[0002] In today's information age, various industries have a large demand for data acquisition and processing. Different data tables need to be designed for collecting basic data to suit different business needs and scenarios. Different data items have their own standard formats and ranges, and large amounts of data need to be saved in the form of data files in computer systems for subsequent analysis and statistics.

[0003] Currently, commonly used data files include Excel and XML files. In the software industry, JSON formatted text files are also frequently used, or databases are used to store data. Regarding data integrity verification, patent CN113570255A proposes a batch file quality inspection method that can check multiple dimensions such as file field format and data volume thresholds. Patent CN118672640A describes a configuration file inspection and file format conversion method, device, and medium. This method uses XSD to verify XML data files, and different XSD configuration files can be used to verify data objects with different data structures.

[0004] However, in practice, the data entry process is highly inefficient due to its variability and diversity. Different data collection tables and data item descriptions need to be created for different business scenarios; even within the same business scenario, the collected data items change over time. The data verification methods described above are all for cases where the data files already exist. In such cases, invalid data that is difficult to retrieve often has to be deleted directly. When dealing with large volumes of data, verifying data validity and modifying data formats consumes significant human resources.

[0005] Patent CN109829146A discloses an information collection and management method and system. This device includes an information collection terminal, a processor, and a memory, proposing to improve the efficiency of data collection and management through front-end and back-end program processing. Furthermore, in the area of ​​e-government data processing, patent CN111047270A discloses an intelligent optimization configuration system and method for e-government forms. This system allows users to input and verify information via a client; the server stores the data and performs automated calculations and management of the e-government data, achieving rational configuration of the data and supporting automatic report generation.

[0006] Therefore, it is evident that data devices that integrate data entry, data verification, and data storage are a feasible way to improve data processing efficiency in various industries. Thus, there is an urgent need for a data entry and output method and device that can verify the validity of data in real time. Summary of the Invention

[0007] To overcome the shortcomings of the existing technology, this invention discloses a data entry and output method and apparatus capable of real-time data validity verification. This invention integrates data entry, data verification, and data storage, improving data processing efficiency. First, based on an XSD configuration file, this invention generates a corresponding data entry interface, displaying an interactive window for the required data. Then, it monitors the data entry process, immediately prompting for correction when any entered data is invalidated. Finally, after data entry is complete, it supports the generation of data files in various formats.

[0008] To achieve the above objectives, the technical solution adopted by the present invention is as follows: In a first aspect, the present invention provides a data entry and output method capable of real-time verification of data validity, comprising the following steps: S1. Load and parse the XSD configuration file to obtain multiple data structures, each of which corresponds to a data table. Step S1 includes: loading the XSD configuration file, parsing the data structures, ranges, and relationships in the XSD configuration file, and mapping xs:element to a data table according to the XSD definition.

[0009] Preferably, step S1 includes: Load the first element node in LineData.xsd. This node contains four child data nodes: Tracks, Signals, Routes, and Points. Map these four child data nodes to four types of data tables. Each of the four data tables contains multiple Track, Signal, Route, and Point data records. Track, Signal, Route, and Point represent tracks, signals, routes, and switches, respectively. Load all child data nodes contained in Track, Signal, Route, and Point. Each child node is mapped to a column field of the corresponding data table. The column field definition includes its information description, range, and data item composition. Load the key and keyref definitions to represent the reference relationships between data items; If the data structure changes, modify the LineData.xsd file and reload it; by loading different XSD configuration files, different data tables, data column fields and constraint relationships are parsed accordingly.

[0010] S2. Generate a data entry interface based on the contents of the data table, allowing users to create and manage data; Preferably, in step S2, the data entry interface includes a data table area, a data record area, and a data item entry area, wherein the data item entry area provides an interactive window for each data item; when the input data item changes, a new data entry interface is generated by modifying and reloading the XSD configuration file.

[0011] Preferably, in step S2, the leftmost part of the data entry interface is a data table area, which includes Tracks, Signals, Routes, and Points data tables; Clicking on the data table on the left will display the data column information and existing data rows in the central data record area of ​​the interface. The right side of the interface is the data item entry area for a single row of data. In the central data recording area of ​​the interface, clicking the "New" button adds a row of data to the data table. At the same time, the data entry area will display all the columns and fields of the selected row of data. Each column and field consists of one or more data. For each data, a corresponding interactive form is displayed. The interactive form contains prompts and data interaction controls to help users fill in the correct values ​​when entering data. After entering the data in the data entry area on the right side of the interface, click "Save" to successfully add a row of valid data to the data record area; use the "Delete" button to delete existing data rows in the data table.

[0012] S3. Generate specific data item interaction forms on the data entry interface, use the interaction forms to enter data, and verify the validity of the entered data in real time; wherein, the interaction forms include prompt information and data interaction controls; Step S3 includes: the user traverses each data table, adds data records, and enters each data item in the data table through an interactive form; during the entry process, the device determines whether the currently entered value is valid. If it is valid, the data value is saved; if it is invalid, an error message is displayed, requiring the user to re-enter the data.

[0013] Preferably, step S3 includes: in the data entry area on the right side of the data entry interface, each data item has a corresponding data interaction control, and information descriptions are provided on both sides of the control, including the explanation of the data item, the valid range, and the data unit; after the user enters the data, the content is verified, and if it does not meet the requirements in XSD, the interface displays an error message and requires re-entry.

[0014] Preferably, in step S3, different data types correspond to different data interaction controls during data entry, including: For numeric data items, a text input box is provided, and the supported input range is displayed next to the input box. If the input data value is not within this range, an error message will appear on the interface until the user corrects the content in the text input box. For data items of enumeration type, an enumeration value is provided for the user to select through a drop-down list; For data items with reference relationships, a drop-down list or a reference data expansion method can be used. The reference data expansion method is as follows: Click the "#" button next to the input box to bring up all referenceable data and their extended information for the user to select.

[0015] Preferably, in step S3, during data entry, the data recording area in the center of the data entry interface contains columns in the data table that are either single data items or expanded into complex data structures. The expanded complex data structures include: The column field is expanded into multiple sub-data items, including: Kp in the Signals table, which contains three sub-fields. When entering data, the three sub-data items of Kp are entered respectively. The column field expands to a list of data items, including: the Point_ID_List column field from the Routes table, which is a list of multiple Point_IDs, and each Point_ID field references the ID column from the Points table; this field cannot be entered directly, but by clicking the "#" button, all Points information will pop up, and then you can select; this field is a list and supports multiple selections; if Point_ID_List is empty, select 0, which means Point_ID_Not_Define.

[0016] In step S3, data items generate suitable interactive forms based on different numerical types: for numeric data items, the type and range of the input value are checked; for referenced and enumerated data items, a visual selection of valid values ​​is provided; for composite data items, each data item is entered and controlled in turn.

[0017] Step S3 includes: real-time detection of the validity of various data items during the data entry process. Each time the user enters a data item, the device checks its validity. If it does not meet the XSD restriction requirements, the device immediately displays an error message for that data item until the user modifies the data item.

[0018] S4. Store the entered data and output multiple data format files.

[0019] Preferably, step S4 includes: Stored according to the XML structure defined by XSD, it supports generating Excel, XML, and text data files. When generating an Excel file, the table name on the left side of the interface is used as the sheet name of Excel, and the columns of each sheet are the same as the column names in the data record area in the middle of the interface. For complex column data, its parent-child relationship is represented by parentheses, and parallel data items are separated by commas; when generating a text file, the content is in JSON format text.

[0020] In a second aspect, the present invention also provides a data entry and output device that can verify the validity of data in real time, including: An XSD loading module for loading and parsing an XSD configuration file to obtain multiple data tables corresponding to different data structures; A data object module, communicatively connected to the XSD loading module, for generating a data entry interface according to the content of the data table and verifying the validity of the entered data in real time; A data generation module, communicatively connected to the data object module, for storing the entered data in an XML structure and supporting the output of multiple data format files; A data management module, communicatively connected to the XSD loading module, the data object module, and the data generation module respectively, for managing the data in each module.

[0021] Preferably, the data object module includes a data object design diagram, which includes the inclusion and inheritance relationships of various data objects. The XSD parsing class provides interfaces for other modules to call. The minimum description unit of data items is the base class of various xs:element and xs:attribute, and the basic interfaces provided by it are overridden in the inheritance class to implement the functions of different xs:element and xs:attribute.

[0022] Preferably, the data entry and output device includes: Loading and parsing by the XSD loading module: Design SchemaSysPar <XSD parsing> for parsing the XSD file, and loading all information in the xsd through SchemaSysPar Create; among them, each sub-node of the first xs:element corresponds to instantiating a SchemaTable <data table>, and tables includes data tables such as Tracks, Signals, Routes, and Points; Each SchemaTable<data table> contains a SchemaTableEntry<data object>, Tracks instantiate SchemaTableEntry<data object> Track, and Signal, Route, and Point are instantiated by their respective data tables; A SchemaTableEntry<data object> contains various SchemaElements<column fields of the data object>, which are the different column fields of the Track table; a column field can be a single data item or expanded into a composite data item structure. A SchemaElement contains a List. <schemaattribute>and List <schemaelement>; SchemaElement class extends SchemaSequenceElement, SchemaChoiceElement, SchemaGroupElement corresponding to various xs:complexType in XSD; SchemaAttribute and SchemaElement inherit from SchemaUnit, provide Validate, Generate and ConstructUI interface, all subclasses override the above interface; Data object module generates data entry interface: Entry interface contains all table SchemaSysPar::tables, each table generates all data columns SchemaTableEntry::columnItems, each data column SchemaElement provides all data items items and attris corresponding entry control in its structure; SchemaSysPar<XSD parsing class> generates entry interface for the table tablename through ConstructUI; the generated UIComponent of data items is combined to obtain the whole UITable of the table tablename; UIComponent and ConstructUI generate input box, drop-down box, data association table box and multi-box combination for different types of column fields respectively; Data object module monitors the data entry process: Control in SchemaElement class is defined for controlling the reference relationship of data column fields; Control is displayed as a Button with "#", when Click event occurs, the corresponding field information of the referenced data table is obtained through Keyref information and is displayed in a list; SchemaElement and SchemaAttribute both define Validate function for validity verification of the entered data value; Data storage and file generation: The data generation module calls the Generate interface of the data object to generate all data structures and outputs the data file.

[0023] The beneficial effects of the present application are as follows: 1. The present application can define various data structures through XSD configuration file, and define the name, description, range and reference relationship of each data item.

[0024] 2、The application automatically generates the entry interface of the corresponding data table and all data items by loading the XSD configuration file, and flexibly copes with various business scenarios and data changes.

[0025] 3、The application generates corresponding data entry controls according to the data item type and relationship to ensure the correctness of the data value. The data device verifies the user input data in real time, and immediately prompts the invalid data to require modification.

[0026] 4、The application supports generating Excel, XML, text and other data files.

[0027] 5、The application designs various data objects, supports data column combination data table, data column structure expansion, and provides a unified external interface for various data objects.

[0028] 6、The application automatically generates the corresponding entry interface by loading the XSD configuration file, controls the data entry process, verifies the validity of the input value in real time, and supports outputting various data files.

[0029] 7、Compared with patent application CN113570255A "A quality detection method for batch processing files", the patent is for checking the field format and data volume threshold of the existing data file. The application aims to verify in real time during the early data entry process, and additionally increases the control of data reference correctness. When the data is wrong, prompt information is immediately given to require modification, which can efficiently and accurately generate data files.

[0030] 8、Compared with patent application CN118672640A "A configuration file checking and file format mutual conversion method, device and medium", the method proposes to use XSD configuration file to verify XML data file. The application optimizes the XSD control and verification process of data. The XSD file can only verify the XML format file, and the verification of data is non-real-time. In the application, there is no need to generate a complete XML file, and the data device immediately checks the data item of the current operation. In addition, XSD verifies the XML file, and the prompt information is not easy to understand, which has a certain technical threshold for users. Users need to master the XSD and XML syntax basis, and combine XSD and XML content to locate data problems.

[0031] 9、Compared with patent applications CN109829146A "A method and system for information collection and management" and CN111047270A "An intelligent optimization configuration system and method for e-government forms", the above two methods both design data collection end and data service end, and propose to collect and verify data in the front end, and store and process data in the back end. The present application optimizes the data collection end: designs dynamic loading configuration, and automatically generates the corresponding data table and all data entry control interfaces of the data items according to the XSD configuration file; and monitors and prompts errors in real time during data entry. BRIEF DESCRIPTION OF DRAWINGS

[0032] Figure 1 A flowchart of the method of the present application; Figure 2 A data entry interface example of the present application; Figure 3 An alarm example when the input data value is invalid; Figure 4 A reference relationship data entry operation schematic diagram of the present application; Figure 5 A module design diagram of the data device of the present application; Figure 6 A detailed design diagram of the data object of the present application. DETAILED DESCRIPTION

[0033] The concept, specific structure and generated technical effects of the present application will be described clearly and completely in combination with the embodiments and the drawings, so as to fully understand the purpose, features and effects of the present application.

[0034] Example 1 A data entry and output method capable of verifying data validity in real time, which takes the system data table of rail transit as an example for illustration, but can also be applied to data processes in other industries. Figure 1 As shown in the main flowchart, the execution mode of each activity in the main flow will be introduced below.

[0035] I. Data device loads XSD configuration file XSD is a configuration file that can be used to define an extensible data structure. It can accurately describe data structure, data item occurrence times, data item range, data item reference relationship, etc. through a series of element and attribute restrictions. The data device can flexibly load XSD files, parse data structure, range and relationship in XSD, and map xs:element defined by XSD into a data table.

[0036] S1: Load data configuration file LineData.xsd. S1-1, load the first element node in LineData.xsd, which contains four child data nodes - Tracks, Signals, Routes and Points, mapped to four data tables respectively. The above data tables contain multiple Track, Signal, Route and Point data records respectively.

[0037] S1-2, load all child data nodes contained in Track, Signal, Route and Point respectively, each of which is mapped to a column field of the corresponding data table. The column field definition contains its information description, range and data item composition.

[0038] S1-3, load the key and keyref definitions to represent the reference relationship between data items.

[0039] As a preferred embodiment of the present embodiment, if the data structure changes, only the LineData.xsd file needs to be modified and reloaded. By loading different XSD files, the data device can correspondingly parse different data tables, data column fields and constraint relationships.

[0040] II. Generating a data entry interface according to XSD configuration file information After the data device loads the data table and its related information, it generates a corresponding data entry interface for the data collection end according to the table content. The interface is divided into a data table area, a data record area and a data item entry area, and for each data item, a corresponding interactive form (including prompt information and data interaction controls) is provided to prompt the data input personnel.

[0041] As a preferred embodiment of the present embodiment, when the input data item changes, by modifying the XSD configuration file and reloading, the data device will automatically generate a new data entry interface without manual interface revision.

[0042] S2, generate a data entry interface.

[0043] S2-1, as shown in the figure, is a data entry interface generated according to LineData.xsd in S1. The leftmost side of the interface is the data table area, which contains Tracks, Signals, Routes and Points data tables. Figure 2

[0044] S2-2, click Tracks on the left side, and the central area of the interface displays the data column information of the Tracks table and the existing data rows, and the right side of the interface is the data item entry area of a single data row.

[0045] ​S2-3 By clicking the "New" button, you can add a row of data to Tracks. In the data entry area on the right side of the interface, each field has a description to help you fill it in correctly.

[0046] After entering the data in S2-4, click "Save" to successfully add a row of valid data. You can delete existing rows of data in the table using the "Delete" button.

[0047] 3. Real-time monitoring and data entry of the device to ensure data accuracy.

[0048] Users can refer to the instructions in S2 to enter the required data sequentially. In the data entry area on the right side of the interface, each data item has a corresponding interactive control. Information descriptions are displayed on either side of the controls, including an explanation of the data item, its valid range, and the data unit. Furthermore, after each data item is entered, the tool will validate the content. If it does not meet the requirements of XSD, the interface will immediately display an error message and require the user to re-enter the data.

[0049] S3, Regulatory Data Entry Process S3-1, the data entry area on the right side of the interface has different input controls for different data items of different types. For numeric data items such as the ID of a Track, there is a text input box, and the supported range of ID data [1, 255] is displayed next to the input box. If the input data value is not within this range, an error message will appear, such as... Figure 3 The image shows the alarm message when the input data value is invalid. In this case, the ID value must be corrected before any other data can be processed.

[0050] S3-2 For enumerated data items, such as Track_Type in the Tracks table, the corresponding input box cannot be entered directly. The corresponding value can only be selected through the drop-down list (the enumerated value of Track_Type defined in XSD).

[0051] S3-3, for data items with referential relationships, such as the Track_ID field in the Signals table, XSD requires that this value must be included in the ID column of the Tracks table. The Track_ID box cannot be entered directly; it can be selected using the dropdown menu in S3-2; or refer to... Figure 4 The diagram illustrates the data entry process for reference relationships. First, click the "#" button next to the input box to bring up all the ID and Name information in the Tracks table, and then select from them.

[0052] S3-4, as shown Figure 2 The data table area in the center of the interface can contain columns that can be single data items or expanded into complex data structures.

[0053] The S3-4-1 column field can be expanded into multiple sub-data items. For example, the Kp column field in the Signals table contains three sub-fields. When entering data, the three sub-data items of Kp are entered separately.

[0054] The S3-4-2 column field can be expanded into a list of data items. For example, the Point_ID_List column in the Routes table is a list of multiple Point_IDs. Each Point_ID field references the ID column in the Points table. This field cannot be entered directly; instead, click the "#" button in S3-3 to bring up all Points information, and then select from the list. Note: This field is a list and supports multiple selections. If Point_ID_List is empty, you can select 0, which indicates Point_ID_Not_Define. In a preferred embodiment of this invention, the data device can control the validity of various data items in real time during the data entry process. For ordinary data items, the input value is checked for type and range; for referenced data items and enumerated data items, a visual selection of valid values ​​is provided; for data with complex structures, each data item is entered and controlled sequentially.

[0055] IV. Data Storage and Output.

[0056] The system can generate XML data structures for storage based on the entered data, and supports outputting different data files.

[0057] S4. During generation, the data is stored according to the XML structure defined by XSD. The data device supports generating Excel, XML, and text data files. Preferably, when generating an Excel file, the sheet names on the left side of the interface are used as the sheet names, and the column names of each sheet are consistent with the column names of the data record area in the middle of the interface. Complex column data uses parentheses to indicate their parent-child relationships and commas to separate parallel data items. Preferably, when generating a text file, the content is in JSON format. Example 2 A data entry and output device capable of verifying data validity in real time, such as Figure 5 The diagram shown is a modular design of the data device, mainly comprising an XSD loading module, a data management module, a data generation module, and a data object module; as shown... Figure 6 The diagram shows a detailed design of the data objects. The diagram shows the inclusion and inheritance relationships of various data objects. The XSD parsing class provides an interface for other modules to call. The smallest descriptive unit of a data item is the base class of various xs:element and xs:attribute. The basic interface it provides is overridden in the inherited class to implement the functions of different xs:element and xs:attribute.

[0058] The main design process of this data device is as follows: S5-1 XSD parsing process. Design SchemaSysPar<XSD parsing> to parse the XSD file, and load all information in the xsd through SchemaSysPar Create(string xsdfullname). Each sub-node of the first xs:element instantiates a SchemaTable<data table> correspondingly. In the example described in S1-1, tables includes 4 types of data tables: Tracks, Signals, Routes, and Points.

[0059] S5-1-1 Each SchemaTable<data table> contains a SchemaTableEntry<data object>. Corresponding to the instance in S1-2, the Tracks instantiates the SchemaTableEntry<data object> Track. Similarly, Signal, Route, and Point are instantiated by their respective data tables.

[0060] S5-1-2 SchemaTableEntry<data object> contains multiple SchemaElement<column fields of the data object>, that is, different column fields of the Track table. The column fields can be single data items or extended to composite data item structures, so List is included in SchemaElement <schemaattribute>and List <schemaelement>.

[0061] S5-1-3 SchemaElement class extends SchemaSequenceElement, SchemaChoiceElement, SchemaGroupElement, which corresponds to various xs:complexType in XSD. S5-1-4 SchemaAttribute and SchemaElement inherit from SchemaUnit, which provides interfaces such as Validate, Generate, and ConstructUI, and all subclasses override the above interfaces.

[0062] S5-2 Generation of data entry interface. The entry interface contains all the tables SchemaSysPar::tables, each table generates all its data columns SchemaTableEntry::columnItems, and each data column SchemaElement provides all data items items and attris in its structure corresponding to the entry control.

[0063] S5-2-1 SchemaSysPar<XSD parsing class> generates the entry interface for the table tablename by ConstructUI(string tablename). The generated UIComponent of the data items is combined to obtain the overall UITable of the table tablename.

[0064] S5-2-2, for different types of column fields described in S3, UIComponent ConstructUI(SchemaSysPar xsd, UIComponent parent) generates input box, drop-down box, data association table box and multi-box combination respectively.

[0065] S5-3, monitoring of the data entry process.

[0066] S5-3-1, Control is defined in SchemaElement class to control the reference relationship of data column fields. Control is displayed as a Button with "#", when Click event occurs, the corresponding field information of the referenced data table is obtained through Keyref information and displayed in a list.

[0067] S5-3-2, SchemaElement and SchemaAttribute both define Validate function, which is used for validity verification of the entered data value.

[0068] S5-4, data storage and file generation. The data generation module invokes the Generate interface of the data object, generates all data structures, and outputs data files.

[0069] The above describes the embodiments of the present application, but the present application is not limited to the above-mentioned embodiments. Those skilled in the art can make various equivalent modifications or replacements without departing from the spirit of the present application, and these equivalent modifications or replacements are included in the scope defined by the claims of the present application.< / schemaelement> < / schemaattribute> < / schemaelement> < / schemaattribute>

Claims

1. A data entry and output method that can verify the validity of data in real time, characterized by, The method comprises the following steps: S1, loading and parsing the XSD configuration file to obtain a plurality of data structures, each data structure corresponding to a data table; S2, generating a data entry interface according to the content of the data table, for a user to create and manage data; S3, generating a specific data item interaction form in the data entry interface, using the interaction form to enter data, and verifying the validity of the entered data in real time; wherein the interaction form includes prompt information and data interaction controls; S4, storing the entered data and outputting a plurality of data format files.

2. The data entry and output method of claim 1, wherein, The S1 step comprises: Loading the first element node in LineData.xsd, which contains four child data nodes Tracks, Signals, Routes, and Points, mapping the four child data nodes to four data tables in turn, and the four data tables containing a plurality of Track, Signal, Route, and Point data records, wherein Track, Signal, Route, and Point represent track, signal, route, and turnout, respectively; Loading all child data nodes contained in Track, Signal, Route, and Point, each child data node mapping to a column field of the corresponding data table, and the column field definition including its information description, range, and data item composition; Loading the key and keyref definitions to represent the reference relationship between data items; If the data structure changes, modify the LineData.xsd file and reload it again; by loading different XSD configuration files, different data tables, data column fields, and constraint relationships are parsed.

3. The data entry and output method of claim 1, wherein In the S2 step, the data entry interface includes a data table area, a data record area, and a data item entry area, wherein the data item entry area provides an interaction form for each data item; when the input data item changes, the XSD configuration file is modified and reloaded to generate a new data entry interface.

4. The data entry and output method of claim 1, wherein In the S2 step, the leftmost side of the data entry interface is the data table area, containing Tracks, Signals, Routes, and Points data tables; Clicking on the left side data table, the central data record area of the interface displays the data column information and existing data rows of the data table, and the right side of the interface is a single-row data item entry area; In the central data record area of the interface, a row of data is added to the data table by clicking the "New" button, and the data item entry area will display all column fields of the selected row data; each column field information is composed of a single or multiple data, and an interaction form corresponding to each data is displayed, which includes prompt information and data interaction controls to help users enter correct values; After entering the data in the data item entry area on the right side of the interface, click "Save" to successfully add a row of valid data to the data record area; the existing data rows in the data table can be deleted through the "Delete" button.

5. The data entry and output method of claim 1, wherein S3 includes: in the data entry interface right side of the data entry area, each data item has a corresponding data interaction control, and the control is flanked by information description, including data item explanation, valid range and data unit; after the user enters the data, the content is verified, and when it does not meet the requirements in XSD, the interface prompts error information and requires re-entry.

6. The data entry and output method of claim 1, wherein, S3 step in the data entry, different types of data correspond to different data interaction controls, including: For numerical type data items, text input boxes are provided, and the input box displays the supported range; if the input data value is not in this range, the interface will prompt an error until the user modifies the content in the text input box correctly; For enumeration type data items, enumeration values are provided for users to select through a drop-down box; For data items with reference relationships, the reference data expansion method is used, that is, clicking the "#" button next to the input box pops up all the referenceable data and their expansion information for the user to check.

7. The data entry and output method of claim 1, wherein S3 step in the data entry, the data record area in the center of the data entry interface, the column fields in the data table are single data items or expanded into complex data structures, wherein the expansion of complex data structures includes: The column field is expanded into multiple sub-data items, including the Kp column field of the Signals table, which contains three sub-fields, and when entering, the three sub-data items of Kp are entered respectively; The column field is expanded into a data item list, including the column field Point_ID_List of the Routes table, which is a List table of multiple Point_IDs, and each Point_ID field references the ID column of the Points table; this field cannot be directly input, and all Points information is popped up by clicking the "#" button, and then checked; this field is a list and supports multiple selection; if Point_ID_List is empty, select 0, indicating Point_ID_Not_Define.

8. The data entry and output method of claim 1, wherein, S4 includes: According to the XSD defined XML structure for storage, support to generate Excel, XML and text data files, when generating Excel files, the sheet name of Excel is the table name on the left side of the interface, and the columns of each sheet are consistent with the column names in the middle data record area of the interface, wherein the complex column data is represented by parentheses to represent the parent-child relationship, and the data items are separated by commas; when generating text files, the content is JSON format text.

9. A data entry and output device in which data validity can be verified in real time, characterized by It includes: XSD loading module for loading and parsing XSD configuration file to get multiple data tables corresponding to different data structures; Data object module, in communication connection with the XSD loading module, for generating a data entry interface according to the content of the data table and verifying the validity of the entered data in real time; Data generation module, in communication connection with the data object module, for storing the entered data in XML structure and supporting output of multiple data format files; A data management module is in communication connection with the XSD loading module, the data object module and the data generating module respectively, and is used for managing data in each module.

10. The data entry and output device capable of verifying data validity in real time according to claim 9, wherein, The data object module includes a data object design diagram, the data object design diagram includes containing and inheritance relationships of various data objects, an XSD analysis class provides an interface for calling by other modules, and a data item minimum description unit is a base class of various xs:element and xs:attribute, a basic interface provided by the data item minimum description unit is rewritten in an inheritance class, and functions of different xs:element and xs:attribute are realized.

Images