CN106598612A - Operation method and system for data table in database - Google Patents
Operation method and system for data table in database Download PDFInfo
- Publication number
- CN106598612A CN106598612A CN201611187178.7A CN201611187178A CN106598612A CN 106598612 A CN106598612 A CN 106598612A CN 201611187178 A CN201611187178 A CN 201611187178A CN 106598612 A CN106598612 A CN 106598612A
- Authority
- CN
- China
- Prior art keywords
- field information
- data
- tables
- file
- data table
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/34—Graphical or visual programming
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
Abstract
The invention discloses an operation method and an operation system for a data table in database, applied to LabVIEW software. The method is developed based on a LabVIEW language, and comprises the steps of firstly displaying original field information corresponding to the data table in an original control on an interface, determining a target control needing to be modified according to a user command; then modifying first target field information of the target control according to a user need, thus acquiring modified second target field information; and at last acquiring the updated data table according to the second target field information. According to the method and the system provided by the invention, the user can directly display all field information of the data table on the interface control, then the field information in the control is modified, added or deleted according to a test index, processing operation performed by professional by using a database edition management tool is not needed, the field information in the control can be directly operated, misoperation is not easy to occur, and correct storage of data is ensured.
Description
Technical field
The invention belongs to automatic test technology field, is the operation for being related to tables of data in a kind of data base in particular
Method and system.
Background technology
In field of automatic testing, the storage of test data, playback are requisite links.It is commonly used for test data storage
Data base have MySQL, SQL Server, Oracle, Access, Excel etc..All it is direct generally to the operation of data above storehouse
Using some graphical tools, such as MySQL-Front is created to tables of data, and configures the field letter of correspondence test index
Breath, generates tables of data;Or under DOS environment, directly configuration is completed using corresponding programmed statements, but this is all to operator
Propose to be required compared with high-tech.
First, the index of different product needed tests is different, when there is new test index to need to be tested, just needs
Will in data base the corresponding tables of data of the newly-built test index, if operated using database edits management tool, just
The skill set requirements of cycle testss editorial staff are improved;Secondly, product may add, changes or delete and deposit in research and development test
Field information content of the storage in tables of data, it is necessary to which the field information content of tables of data is added, is changed or is deleted, with
And the attribute of each field is configured, cumbersome easy error, affect the storage of data for newly adding;Finally, if with
Family immediate operand is managed according to storehouse editorial management instrument to the tables of data in data base, mistake easily occurs, affects existing
The storage of data.
To sum up, original operation to tables of data in data base needs to propose operator higher technical requirements, and holds
Easily there is maloperation, affect the correct storage of data.
The content of the invention
In view of this, the invention provides in a kind of data base tables of data operational approach and system, to solve existing skill
Because original operation to tables of data in data base needs to propose operator higher technical requirements in art, and easily occur
Maloperation, affects the problem of the correct storage of data.
For achieving the above object, the present invention provides following technical scheme:
The operational approach of tables of data in a kind of data base, is applied to LabVIEW softwares, and methods described includes:
Raw data table is read, and the corresponding original field information of the raw data table is assigned to corresponding on interface
Original control is shown;
Target widget is determined by user instruction, and the first object field information to the target widget is modified,
Obtain the second aiming field information;
Tables of data after being updated according to the second aiming field information.
Wherein, the reading raw data table, and the corresponding original field information of the raw data table is assigned to into boundary
Corresponding original control is shown on face, including:
The raw data table is read, and is read by file manipulation function corresponding with the raw data table to be configured
File;
The content of the file to be configured is parsed, is institute by the Content Transformation of the file to be configured by character string conversion
State the corresponding original field information of raw data table;
The original field information is assigned to into the corresponding original control on the interface, and by the text to be configured
The title of part and the original field information are displayed in the described original control on the interface.
Wherein, it is described updated according to the second aiming field information after tables of data, including:
Create corresponding comprising the target widget in the LabVIEW softwares according to the second aiming field information
The SQL statement of all aiming field information;
The SQL statement, the tables of data after being updated are performed by data base tool downloading data storehouse handling function.
Preferably, also include:
The second aiming field information in tables of data after the renewal is converted to into the file manipulation function
The string format held;
The character string after the file manipulation function is by conversion is stored as corresponding formatted file and is stored in number
According in storehouse.
Wherein, the first object field information is the corresponding all aiming field information of the target widget or part mesh
Marking-up segment information.
Wherein, the original control includes:Field name, data type, data length and whether allow NULL.
The operating system of tables of data in a kind of data base, is applied to LabVIEW softwares, and the system includes:
Read module, for reading raw data table, and by the corresponding original field information assignment of the raw data table
Shown to corresponding original control on interface;
Modified module, for determining target widget by user instruction, and to the first object field of the target widget
Information is modified, and obtains the second aiming field information;
Update module, for the tables of data after being updated according to the second aiming field information.
Wherein, the read module, including:
Reading unit, for reading the raw data table, and is read and the initial data by file manipulation function
The corresponding file to be configured of table;
Resolution unit, for parsing the content of the file to be configured, is changed the file to be configured by character string
Content Transformation be the corresponding original field information of the raw data table;
Assignment display unit, for the original field information to be assigned to into the corresponding original control on the interface
Part, and the title of the file to be configured and the original field information are included into the described original control on the interface
In.
Wherein, the update module, including:
Sentence creating unit, includes for being created in the LabVIEW softwares according to the second aiming field information
The SQL statement of the corresponding all aiming field information of the target widget;
Performance element, for performing the SQL statement by data base tool downloading data storehouse handling function, is updated
Tables of data afterwards.
Preferably, also include:
Modular converter, for the second aiming field information in the tables of data after the renewal to be converted to into the text
The string format that part handling function is supported;
Memory module, for by the file manipulation function by conversion after the character string be stored as corresponding form
File is stored in data base.
Understand via above-mentioned technical scheme, compared with prior art, the present invention discloses tables of data in a kind of data base
Operational approach and system, it is applied to LabVIEW softwares, and the method includes:Raw data table is read, and by raw data table pair
The original field information answered is assigned to corresponding original control on interface and is shown;Target widget is determined by user instruction,
And the first object field information to target widget is modified, the second aiming field information is obtained;According to the second aiming field
Information updated after tables of data.The present invention is based on LabVIEW language developments, shows in the original control first on interface
The corresponding original field information of raw data table, being determined according to user instruction needs the target widget of modification, then according to user
Demand the first object field information of target widget is modified, obtain amended second aiming field information, finally
Tables of data after being updated according to the second aiming field information, user can directly on interface control video data table institute
There is field information, then the operation such as the field information in control is modified, adds or deleted according to test index, without the need for making
Process is carried out with database edits management tool by professional to operate, and directly the field information in control can be grasped
Make, it is not easy to maloperation occurs, it is ensured that the correct storage of data.
Description of the drawings
In order to be illustrated more clearly that the embodiment of the present invention or technical scheme of the prior art, below will be to embodiment or existing
The accompanying drawing to be used needed for having technology description is briefly described, it should be apparent that, drawings in the following description are only this
Inventive embodiment, for those of ordinary skill in the art, on the premise of not paying creative work, can be with basis
The accompanying drawing of offer obtains other accompanying drawings.
Fig. 1 is the operational approach schematic flow sheet of tables of data in a kind of data base provided in an embodiment of the present invention;
Fig. 2 is the original field information interface control schematic diagram of raw data table provided in an embodiment of the present invention;
Fig. 3 is the concrete grammar schematic flow sheet of step S101 in Fig. 1 provided in an embodiment of the present invention;
Fig. 4 is for reading configuration file provided in an embodiment of the present invention and preserves configuration file flow chart;
Fig. 5 is the concrete grammar schematic flow sheet of step S103 in Fig. 1 provided in an embodiment of the present invention;
Fig. 6 is that tables of data provided in an embodiment of the present invention updates flow chart;
Fig. 7 is another schematic flow sheet of operational approach of tables of data in a kind of data base provided in an embodiment of the present invention;
Fig. 8 is the operating system configuration schematic diagram of tables of data in a kind of data base provided in an embodiment of the present invention;
Fig. 9 is the concrete structure schematic diagram of acquisition module 801 in Fig. 8 provided in an embodiment of the present invention;
Figure 10 is the concrete structure schematic diagram of update module 803 in Fig. 8 provided in an embodiment of the present invention;
Figure 11 is another structural representation of operating system of tables of data in a kind of data base provided in an embodiment of the present invention.
Specific embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is carried out clear, complete
Site preparation is described, it is clear that described embodiment is only a part of embodiment of the invention, rather than the embodiment of whole.It is based on
Embodiment in the present invention, it is every other that those of ordinary skill in the art are obtained under the premise of creative work is not made
Embodiment, belongs to the scope of protection of the invention.
Accompanying drawing 1 is referred to, Fig. 1 is that the operational approach flow process of tables of data in a kind of data base provided in an embodiment of the present invention is shown
It is intended to.As shown in figure 1, the invention discloses in a kind of data base tables of data operational approach, be applied to LabVIEW softwares, should
It is as follows that method specifically includes step:
S101, reading raw data table, and the corresponding original field information of raw data table is assigned to into correspondence on interface
Original control shown.
It should be noted that the present invention needs to read raw data table, and the corresponding original field of raw data table is believed
Breath is assigned to corresponding original control on interface and is shown.Specifically, as shown in Fig. 2 Fig. 2 is provided in an embodiment of the present invention
The original field information interface control schematic diagram of raw data table, the present invention is primarily to create and configuration data table, support
On interface from Fig. 2 importing configuration files and can directly in the enterprising edlin in interface, support tables of data table name it is self-defined
And the configuration of the field information in original control.As shown in Figure 2, configurable original field information mainly can include:
Field quantity, field name, data type (string, long, single, double, date/time, binary), data are long
Spend, whether allow NULL etc..
S102, target widget is determined by user instruction, and the first object field information to target widget is modified,
Obtain the second aiming field information.
When being configured, the corresponding original control of raw data table first shown in interface according to user instruction is needed
In determine that target widget, i.e. user need the corresponding control of field information content changed, delete or add, it is then corresponding
Using its field information as aiming field information to be modified.
It should be noted that believing corresponding first object field after modification instruction of the user to target widget is received
Breath is modified, and obtains the second aiming field information, wherein, first object field information can be that target widget is corresponding all
Field information, or the corresponding partial target field information of target widget.
S103, updated according to the second aiming field information after tables of data.
It should be noted that the second aiming field information for obtaining being carried out into the establishment of tables of data in data base and being matched somebody with somebody
Put, the tables of data after being updated, and the tables of data after renewal is included in corresponding target widget, in data base, root
The tables of data after updating is generated according to amended second aiming field information, that is, realizes creating and configuration data table.
Specifically, accompanying drawing 3 is referred to, Fig. 3 is the concrete grammar flow process of step S101 in Fig. 1 provided in an embodiment of the present invention
Schematic diagram.As shown in figure 3, step S101, raw data table is read, and by the corresponding original field information assignment of raw data table
Shown that the step specifically includes following steps to corresponding original control on interface:
S301, reading raw data table, and text to be configured corresponding with raw data table is read by file manipulation function
Part.
Such as Fig. 4, Fig. 4 is for reading configuration file provided in an embodiment of the present invention and preserves configuration file flow chart.Such as Fig. 4
It is shown, data are read with xml data forms, then with xml data form storage files.
S302, the content for parsing file to be configured, are changed the Content Transformation of file to be configured as original by character string
The corresponding original field information of tables of data.
The content of the configuration file of reading is converted to into the corresponding original field letter of raw data table by character string
Breath.Original field information mainly can include:Field name, data type (string, long, single, double, date/
Time, binary), data length, whether allow NULL etc..
S303, original field information is assigned to corresponding original control on interface, and by the title of file to be configured and
Original field information is displayed in the original control on interface.
In the present embodiment, program reads file to be configured, treats profile data and is processed, and resolves to initial data
The original field information of table, by original field information corresponding original control on interface is assigned to, and by the name of file to be configured
Claim and original field information is displayed in the original control on interface.
Specifically, accompanying drawing 5 is referred to, Fig. 5 is the concrete grammar stream of step S103 in Fig. 1 provided in an embodiment of the present invention
Journey schematic diagram.As shown in figure 5, step S103, updated according to the second aiming field information after tables of data, the step is concrete
Comprise the steps:
S501, created in LabVIEW softwares comprising the corresponding all mesh of target widget according to the second aiming field information
The SQL statement of marking-up segment information.
In the present embodiment, as shown in fig. 6, Fig. 6 is tables of data provided in an embodiment of the present invention updates flow chart.User is led to
Cross and interface configuration data is judged, parsed and is changed, by the second aiming field information by the attended operation to character string
The SQL statement comprising the corresponding all aiming field information of target widget is created in LabVIEW softwares, SQL statement is generated.
It should be noted that SQL statement includes three partial contents:Data table name:The data table name being input into using interface.
Field information in tables of data:Using method be to use loop structure, travel through the self-defined row field number of clusters group in all interfaces;Row with
Separated using ", " between row, space-separated is used between each self-information of each field, uniform data type is character string type;
Concatenation character string function is called, all row field informations are connected into a character string statement, removed for finally having more and tease
Number.Tables of data attribute information:It is that " gbk ", each row storage form are to increase the table storage engines for " INNODB ", default character collection
“COMPACT”。
S502, the SQL statement, the data after being updated are performed by data base tool downloading data storehouse handling function
Table.
In the present embodiment, the DB Tools that program passes through DB Tools (Database Tool, data base tool)
Execute Query functions perform above-mentioned SQL statement, complete the establishment and configuration of tables of data, the tables of data after being updated.
Specifically, accompanying drawing 7 is referred to, Fig. 7 is the operation side of tables of data in a kind of data base provided in an embodiment of the present invention
Another schematic flow sheet of method.As shown in fig. 7, the embodiment of the present invention discloses a kind of operational approach of tables of data in data base, the party
Method specifically includes following steps:
S701, reading raw data table, and the corresponding original field information of raw data table is assigned to into correspondence on interface
Original control shown.
It should be noted that the present invention needs to read raw data table, and the corresponding original field of raw data table is believed
Breath is assigned to corresponding original control on interface and is shown.Specifically, as shown in Fig. 2 Fig. 2 is provided in an embodiment of the present invention
The original field information interface control schematic diagram of raw data table, the present invention is primarily to create and configuration data table, support
On interface from Fig. 2 importing configuration files and can directly in the enterprising edlin in interface, support tables of data table name it is self-defined
And the configuration of the field information in original control.As shown in Figure 2, configurable original field information mainly can include:
Field quantity, field name, data type (string, long, single, double, date/time, binary), data are long
Spend, whether allow NULL etc..
S702, target widget is determined by user instruction, and the first object field information to target widget is modified,
Obtain the second aiming field information.
When being configured, in needing the control in the raw data table first shown in interface control according to user instruction
Determine that target widget, i.e. user need the corresponding control of field information content changed, delete or add, it is then corresponding to incite somebody to action
Its field information is used as aiming field information to be modified.
It should be noted that believing corresponding first object field after modification instruction of the user to target widget is received
Breath is modified, and obtains the second aiming field information, wherein, first object field information can be that target widget is corresponding all
Field information, or the corresponding partial target field information of target widget..
S703, updated according to the second aiming field information after tables of data.
It should be noted that the second aiming field information for obtaining being carried out into the establishment of tables of data in data base and being matched somebody with somebody
Put, the tables of data after being updated, and the tables of data after renewal is included in corresponding target widget, in data base, root
The tables of data after updating is generated according to amended second aiming field information, that is, realizes creating and configuration data table.
S704, the character that the second aiming field information in the tables of data after renewal is converted to file manipulation function support
String format.
S705, the character string after conversion is stored as by corresponding formatted file by file manipulation function it is stored in data base
In.
File manipulation function is xml lattice according to the different and different of configuration file format, such as configuration file in said process
During formula, file manipulation function is xml functions, and when configuration file is txt forms, file manipulation function is txt functions.
The present embodiment can be stored the tables of data after renewal, can be provided the user with and subsequently used similar number
Can directly invoke according to when table.
In the present embodiment, user needs the field information in more new configuration file when needing to use new data base, only, so
Create and configuration data table by clicking directly on the establishment on interface afterwards;Not more new configuration file can also be selected, before multiplexing
The configuration file of preservation, by configuration file parsing obtain tables of data, in interface control show, then again in interface control voluntarily
Modification related data.By taking xml format configuration files as an example, the loading of configuration file is entered using xml function pair configuration files are read
Row reads, and then the character string of reading is converted to into data sheet field information format, is assigned to interface control and shows;Configuration file
Storage first interface control value is converted to into string format, then using write xml document function stored.
The present invention discloses a kind of operational approach and system of tables of data in data base, and it is applied to LabVIEW softwares, the party
Method includes:Raw data table is read, and the corresponding original field information of raw data table is assigned to corresponding original on interface
Control is shown;Target widget is determined by user instruction, and the first object field information to target widget is modified,
Obtain the second aiming field information;Tables of data after being updated according to the second aiming field information.The present invention is based on LabVIEW
Language development, shows the corresponding original field information of raw data table in the original control first on interface, referred to according to user
Order determines the target widget for needing modification, then the first object field information of target widget is repaiied according to the demand of user
Change, obtain amended second aiming field information, the tables of data after being updated finally according to the second aiming field information is used
Family can directly on interface control video data table all field informations, then according to test index to the field in control
Information such as modifies, adds or deletes at the operation, and process behaviour is carried out by professional without using database edits management tool
Make, and directly the field information in control can be operated, it is not easy to which maloperation occurs, it is ensured that data are correctly deposited
Storage.
The present invention also discloses corresponding system on the basis of method disclosed above.
Accompanying drawing 8 is referred to, Fig. 8 is that the operating system configuration of tables of data in a kind of data base provided in an embodiment of the present invention is shown
It is intended to.As shown in figure 8, the invention discloses in a kind of data base tables of data operating system, be applied to LabVIEW softwares, institute
The system of stating specifically includes following structure:
Read module 801, for reading raw data table, and the corresponding original field information of raw data table is assigned to
Corresponding original control is shown on interface;
Modified module 802, for determining target widget by user instruction, and the first object field to target widget is believed
Breath is modified, and obtains the second aiming field information;
Update module 803, for the tables of data after being updated according to the second aiming field information.
Each module in due to the present embodiment is able to carry out the method shown in Fig. 1, the part that the present embodiment is not described in detail,
Refer to the related description to Fig. 1.
Specifically, as shown in figure 9, above-mentioned read module 801 specifically includes following structure:
Reading unit 901, for reading raw data table, and is read corresponding with raw data table by file manipulation function
File to be configured;
Resolution unit 902, for parsing the content of file to be configured, parses the content of file to be configured, by character string
Change the Content Transformation of file to be configured as the corresponding original field information of raw data table;
Assignment display unit 903, for original field information to be assigned to into corresponding original control on interface, and will wait to match somebody with somebody
The title and original field information for putting file is displayed in the original control on interface.
Each module in due to the present embodiment is able to carry out the method shown in Fig. 3, the part that the present embodiment is not described in detail,
Refer to the related description to Fig. 3.
Specifically, as shown in Figure 10, above-mentioned update module 803 specifically includes following structure:
Sentence creating unit 1001, for being created in LabVIEW softwares comprising described according to the second aiming field information
The SQL statement of the corresponding all aiming field information of target widget;
Performance element 1002, for performing SQL statement by data base tool downloading data storehouse handling function, is updated
Tables of data afterwards.
Each module in due to the present embodiment is able to carry out the method shown in Fig. 5, the part that the present embodiment is not described in detail,
Refer to the related description to Fig. 5.
Accompanying drawing 11 is referred to, Figure 11 is that the operating system of tables of data in a kind of data base provided in an embodiment of the present invention is another
Structural representation.As shown in figure 11, the embodiment of the invention discloses in a kind of data base tables of data operating system, be applied to
LabVIEW softwares, the system specifically includes following structure:
Read module 1101, for reading raw data table, and by the corresponding original field information assignment of raw data table
Shown to corresponding original control on interface;
Modified module 1102, for determining target widget by user instruction, and to the first object field of target widget
Information is modified, and obtains the second aiming field information;
Update module 1103, for according to the tables of data after being updated according to the second aiming field information.
Modular converter 1104, for the second aiming field information in the tables of data after renewal to be converted to into file operation letter
The string format that number is supported;
Memory module 1105, for the character string after conversion to be stored as into corresponding formatted file by file manipulation function
In being stored in data base.
Each module in due to the present embodiment is able to carry out the method shown in Fig. 7, the part that the present embodiment is not described in detail,
Refer to the related description to Fig. 7.
The present invention discloses a kind of operating system of tables of data in data base, and it is applied to LabVIEW softwares, and the present invention is based on
LabVIEW language developments, show the corresponding original field information of raw data table in the original control first on interface, according to
User instruction determines the target widget for needing modification, then the first object field information according to the demand of user to target widget
Modify, obtain amended second aiming field information, the number after being updated finally according to the second aiming field information
According to table, user can directly on interface control video data table all field informations, then according to test index to control
In field information the operation such as modify, add or delete, entered by professional without using database edits management tool
Row processes operation, and directly the field information in control can be operated, it is not easy to maloperation occurs, it is ensured that data
Correct storage.
In sum, the present invention discloses a kind of operational approach and system of tables of data in data base, and it is applied to LabVIEW
Software, the method includes:Read raw data table, and the corresponding original field information of raw data table is assigned to it is right on interface
The original control answered is shown;Target widget is determined by user instruction, and to the first object field information of target widget
Modify, obtain the second aiming field information;Tables of data after being updated according to the second aiming field information.Base of the present invention
The corresponding original field information of raw data table, root are shown in LabVIEW language developments, the original control first on interface
Determining according to user instruction needs the target widget of modification, then the first object field of target widget is believed according to the demand of user
Breath is modified, and obtains amended second aiming field information, after being updated finally according to the second aiming field information
Tables of data, user can directly on interface control video data table all field informations, then according to test index to control
Field information in part such as modifies, adds or deletes at the operation, without using database edits management tool by professional
Process operation is carried out, and directly the field information in control can be operated, it is not easy to maloperation occurs, it is ensured that data
Correct storage.
It should be noted that each embodiment in this specification is described by the way of progressive, each embodiment weight
Point explanation is all difference with other embodiment, between each embodiment identical similar part mutually referring to.
Method proposed by the invention is exemplarily described above in association with accompanying drawing, the explanation of above example is
It is used to help understand the core concept of the present invention.For one of ordinary skill in the art, according to the thought of the present invention, concrete
Will change in embodiment and range of application.In sum, this specification content should not be construed as to the present invention's
Limit.
The foregoing description of the disclosed embodiments, enables professional and technical personnel in the field to realize or using the present invention.
Various modifications to these embodiments will be apparent for those skilled in the art, as defined herein
General Principle can be realized in other embodiments without departing from the spirit or scope of the present invention.Therefore, the present invention
The embodiments shown herein is not intended to be limited to, and is to fit to and principles disclosed herein and features of novelty phase one
The most wide scope for causing.
Claims (10)
1. in a kind of data base tables of data operational approach, it is characterised in that be applied to LabVIEW softwares, methods described includes:
Raw data table is read, and the corresponding original field information of the raw data table is assigned to corresponding original on interface
Control is shown;
Target widget is determined by user instruction, and the first object field information to the target widget is modified, and is obtained
Second aiming field information;
Tables of data after being updated according to the second aiming field information.
2. operational approach according to claim 1, it is characterised in that the reading raw data table, and will be described original
The corresponding original field information of tables of data is assigned to corresponding original control on interface and is shown, including:
The raw data table is read, and text to be configured corresponding with the raw data table is read by file manipulation function
Part;
The content of the file to be configured is parsed, is changed the Content Transformation of the file to be configured as the original by character string
The corresponding original field information of beginning tables of data;
The original field information is assigned to into the corresponding original control on the interface, and by the file to be configured
Title and the original field information are displayed in the described original control on the interface.
3. operational approach according to claim 1, it is characterised in that described to be obtained according to the second aiming field information
Tables of data after renewal, including:
Create corresponding all comprising the target widget in the LabVIEW softwares according to the second aiming field information
The SQL statement of aiming field information;
The SQL statement, the tables of data after being updated are performed by data base tool downloading data storehouse handling function.
4. operational approach according to claim 2, it is characterised in that also include:
The second aiming field information in tables of data after the renewal is converted to into what the file manipulation function was supported
String format;
The character string after the file manipulation function is by conversion is stored as corresponding formatted file and is stored in data base
In.
5. operational approach according to claim 1, it is characterised in that the first object field information is the target control
The corresponding all aiming field information of part or partial target field information.
6. operational approach according to claim 1, it is characterised in that the original field information includes:Field name, number
According to type, data length and whether allow NULL.
7. in a kind of data base tables of data operating system, it is characterised in that be applied to LabVIEW softwares, the system includes:
Read module, for reading raw data table, and is assigned to boundary by the corresponding original field information of the raw data table
Corresponding original control is shown on face;
Modified module, for determining target widget by user instruction, and to the first object field information of the target widget
Modify, obtain the second aiming field information;
Update module, for the tables of data after being updated according to the second aiming field information.
8. operating system according to claim 7, it is characterised in that the read module, including:
Reading unit, for reading the raw data table, and is read and the raw data table pair by file manipulation function
The file to be configured answered;
Resolution unit, for parsing the content of the file to be configured, is changed in the file to be configured by character string
Appearance is converted to the corresponding original field information of the raw data table;
Assignment display unit, for the original field information to be assigned to into the corresponding original control on the interface, and
The title of the file to be configured and the original field information are included in the described original control on the interface.
9. operating system according to claim 7, it is characterised in that the update module, including:
Sentence creating unit, for being created in the LabVIEW softwares comprising described according to the second aiming field information
The SQL statement of the corresponding all aiming field information of target widget;
Performance element, for performing the SQL statement by data base tool downloading data storehouse handling function, after being updated
Tables of data.
10. operating system according to claim 8, it is characterised in that also include:
Modular converter, for the second aiming field information in the tables of data after the renewal to be converted to into the file behaviour
Make the string format of function support;
Memory module, for by the file manipulation function by conversion after the character string be stored as corresponding formatted file
In being stored in data base.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201611187178.7A CN106598612B (en) | 2016-12-20 | 2016-12-20 | Operation method and system for data table in database |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201611187178.7A CN106598612B (en) | 2016-12-20 | 2016-12-20 | Operation method and system for data table in database |
Publications (2)
Publication Number | Publication Date |
---|---|
CN106598612A true CN106598612A (en) | 2017-04-26 |
CN106598612B CN106598612B (en) | 2020-08-28 |
Family
ID=58600455
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201611187178.7A Active CN106598612B (en) | 2016-12-20 | 2016-12-20 | Operation method and system for data table in database |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN106598612B (en) |
Cited By (12)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109325041A (en) * | 2018-08-14 | 2019-02-12 | 中国平安人寿保险股份有限公司 | Business data processing method, device, computer equipment and storage medium |
CN109726194A (en) * | 2018-12-30 | 2019-05-07 | 深圳互联先锋科技有限公司 | Database table management method, device and computer equipment on line |
CN109814895A (en) * | 2018-11-29 | 2019-05-28 | 广州因特信息科技有限公司 | A kind of database update method and system of automation |
CN110244688A (en) * | 2019-06-06 | 2019-09-17 | 惠州市德赛西威汽车电子股份有限公司 | Meter bus panel automatic generation method and its system based on LabVIEW |
CN110704100A (en) * | 2018-06-25 | 2020-01-17 | 沃尔缇夫能源系统公司 | Method and device for configuring functional module software |
CN111125262A (en) * | 2018-10-31 | 2020-05-08 | 北京国双科技有限公司 | Method and device for processing field information, storage medium and processor |
CN111782608A (en) * | 2020-07-21 | 2020-10-16 | 平安国际智慧城市科技股份有限公司 | Automatic file generation method and device, electronic equipment and storage medium |
CN112035040A (en) * | 2020-08-31 | 2020-12-04 | 北京润科通用技术有限公司 | Interface variable information processing method and device |
CN112732795A (en) * | 2021-01-19 | 2021-04-30 | 华东师范大学 | Big data visualization method and system |
CN112749185A (en) * | 2021-01-20 | 2021-05-04 | 青岛以萨数据技术有限公司 | SQL language generation system and method |
CN113342801A (en) * | 2020-03-02 | 2021-09-03 | 上海南华机电有限公司 | LabVIEW-based database table creating method, system and terminal |
CN114443687A (en) * | 2021-12-23 | 2022-05-06 | 苏州浪潮智能科技有限公司 | Software package self-defining system and application method for constructing operating system image |
Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1862538A (en) * | 2006-02-27 | 2006-11-15 | 华为技术有限公司 | Data configuration system and method for implementing data configuration |
US20080005721A1 (en) * | 2006-06-29 | 2008-01-03 | Augusta Systems, Inc. | Method and System for Rapidly Developing Sensor-Enabled Software Applications |
CN101661512A (en) * | 2009-09-25 | 2010-03-03 | 万斌 | System and method for identifying traditional form information and establishing corresponding Web form |
CN102346785A (en) * | 2011-11-15 | 2012-02-08 | 北京创腾科技有限公司 | Method and device for directly self-defining field of database |
CN102819547A (en) * | 2012-01-13 | 2012-12-12 | 金蝶软件(中国)有限公司 | Method and device for configuring field attribute |
CN105426448A (en) * | 2015-11-06 | 2016-03-23 | 广州华多网络科技有限公司 | Method, device and system for interface display |
US20160283526A1 (en) * | 2014-03-17 | 2016-09-29 | Kenshoo Ltd. | Live database schema tree change |
-
2016
- 2016-12-20 CN CN201611187178.7A patent/CN106598612B/en active Active
Patent Citations (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1862538A (en) * | 2006-02-27 | 2006-11-15 | 华为技术有限公司 | Data configuration system and method for implementing data configuration |
US20080005721A1 (en) * | 2006-06-29 | 2008-01-03 | Augusta Systems, Inc. | Method and System for Rapidly Developing Sensor-Enabled Software Applications |
CN101661512A (en) * | 2009-09-25 | 2010-03-03 | 万斌 | System and method for identifying traditional form information and establishing corresponding Web form |
CN102346785A (en) * | 2011-11-15 | 2012-02-08 | 北京创腾科技有限公司 | Method and device for directly self-defining field of database |
CN102819547A (en) * | 2012-01-13 | 2012-12-12 | 金蝶软件(中国)有限公司 | Method and device for configuring field attribute |
US20160283526A1 (en) * | 2014-03-17 | 2016-09-29 | Kenshoo Ltd. | Live database schema tree change |
CN105426448A (en) * | 2015-11-06 | 2016-03-23 | 广州华多网络科技有限公司 | Method, device and system for interface display |
Cited By (16)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110704100A (en) * | 2018-06-25 | 2020-01-17 | 沃尔缇夫能源系统公司 | Method and device for configuring functional module software |
CN109325041B (en) * | 2018-08-14 | 2023-11-21 | 中国平安人寿保险股份有限公司 | Service data processing method, device, computer equipment and storage medium |
CN109325041A (en) * | 2018-08-14 | 2019-02-12 | 中国平安人寿保险股份有限公司 | Business data processing method, device, computer equipment and storage medium |
CN111125262B (en) * | 2018-10-31 | 2024-02-13 | 北京国双科技有限公司 | Method and device for processing field information, storage medium and processor |
CN111125262A (en) * | 2018-10-31 | 2020-05-08 | 北京国双科技有限公司 | Method and device for processing field information, storage medium and processor |
CN109814895A (en) * | 2018-11-29 | 2019-05-28 | 广州因特信息科技有限公司 | A kind of database update method and system of automation |
CN109726194A (en) * | 2018-12-30 | 2019-05-07 | 深圳互联先锋科技有限公司 | Database table management method, device and computer equipment on line |
CN110244688A (en) * | 2019-06-06 | 2019-09-17 | 惠州市德赛西威汽车电子股份有限公司 | Meter bus panel automatic generation method and its system based on LabVIEW |
CN113342801A (en) * | 2020-03-02 | 2021-09-03 | 上海南华机电有限公司 | LabVIEW-based database table creating method, system and terminal |
CN111782608A (en) * | 2020-07-21 | 2020-10-16 | 平安国际智慧城市科技股份有限公司 | Automatic file generation method and device, electronic equipment and storage medium |
CN111782608B (en) * | 2020-07-21 | 2024-04-16 | 平安国际智慧城市科技股份有限公司 | File automatic generation method and device, electronic equipment and storage medium |
CN112035040A (en) * | 2020-08-31 | 2020-12-04 | 北京润科通用技术有限公司 | Interface variable information processing method and device |
CN112732795A (en) * | 2021-01-19 | 2021-04-30 | 华东师范大学 | Big data visualization method and system |
CN112749185A (en) * | 2021-01-20 | 2021-05-04 | 青岛以萨数据技术有限公司 | SQL language generation system and method |
CN114443687B (en) * | 2021-12-23 | 2024-02-27 | 苏州浪潮智能科技有限公司 | Software package custom system for constructing operating system image and application method |
CN114443687A (en) * | 2021-12-23 | 2022-05-06 | 苏州浪潮智能科技有限公司 | Software package self-defining system and application method for constructing operating system image |
Also Published As
Publication number | Publication date |
---|---|
CN106598612B (en) | 2020-08-28 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN106598612A (en) | Operation method and system for data table in database | |
JP4827834B2 (en) | Method and apparatus for modifying process control data | |
KR101213812B1 (en) | Data binding in a word?processing application | |
US9977798B2 (en) | Data migration and table manipulation in a database management system | |
CN102819585B (en) | Method for controlling document of extensive makeup language (XML) database | |
CN107273122A (en) | Based on decoupling mechanism can iteration set up operation system method and its terminal | |
CN102224492A (en) | Data maintenance system | |
CN108762743A (en) | Data table operation code generation method and device | |
US20110153562A1 (en) | Error prevention for data replication | |
CN104769588B (en) | Queue identifying system | |
US11409505B1 (en) | Automated authoring of software solutions from a data model with related patterns | |
CN102053987B (en) | For showing the unified interface with Update Table array | |
CN106990970A (en) | Based on MVC dynamic pages generation method and system | |
CN107665227A (en) | A kind of data version control method and versions of data controller | |
US8326902B2 (en) | Online database modeling | |
EP1477915A2 (en) | System and method of data modelling | |
US20090055421A1 (en) | Migration and transformation of data structures | |
US20060136471A1 (en) | Differential management of database schema changes | |
CN103593730B (en) | A kind of design parameter management system recalled | |
CN102521408B (en) | Method for accessing flat file by using java database connectivity (JDBC) interface | |
KR101022716B1 (en) | System for generating automatically electronic document and method thereof | |
US20230004477A1 (en) | Providing a pseudo language for manipulating complex variables of an orchestration flow | |
CN109117173A (en) | A kind of configuration file management method based on Item version exploitation | |
Becker et al. | CollectionBuilder-CONTENTdm: Developing a Static Web ‘Skin’for CONTENTdm-Based Digital Collections | |
CN108334621A (en) | Database operation method, device, equipment and computer readable storage medium |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |