CN104239073B - Data maintenance system rapid prototyping development system and method - Google Patents

Data maintenance system rapid prototyping development system and method Download PDF

Info

Publication number
CN104239073B
CN104239073B CN201410546590.8A CN201410546590A CN104239073B CN 104239073 B CN104239073 B CN 104239073B CN 201410546590 A CN201410546590 A CN 201410546590A CN 104239073 B CN104239073 B CN 104239073B
Authority
CN
China
Prior art keywords
data
information
tree
configuration
xml
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.)
Active
Application number
CN201410546590.8A
Other languages
Chinese (zh)
Other versions
CN104239073A (en
Inventor
徐帆江
张明安
邓勇
刘静涛
郭亮
侯玮玮
梁国政
郭思彤
刘超
吴伊萌
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Institute of Software of CAS
Original Assignee
Institute of Software of CAS
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Institute of Software of CAS filed Critical Institute of Software of CAS
Priority to CN201410546590.8A priority Critical patent/CN104239073B/en
Publication of CN104239073A publication Critical patent/CN104239073A/en
Application granted granted Critical
Publication of CN104239073B publication Critical patent/CN104239073B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Landscapes

  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention discloses a data maintenance system rapid prototyping development system and method. A data maintenance system integration framework software system comprises a main program framework and an XML configuration part, a main program generates a corresponding graphical interface automatically by parsing an XML configuration file, a data base is operated through the graphical interface, and data edition is conducted. The method includes the steps that a corresponding trie and table layout information are obtained by parsing the XML file through the data maintenance framework, data are displayed on a data maintenance page through the information, and a data maintenance logic module is used for data maintenance operation. According to the data maintenance system rapid prototyping development system and method, the trie and master-detail table data maintenance information are configured in a form of the XML file, a data maintenance framework data maintenance interface generation module and a data edition logical processing module are adopted for data displaying and maintenance, the maintainability and the malleability of the system are improved, and the programming work is more efficient and more convenient to conduct, and the product development cycle is shortened as well.

Description

A kind of data maintenance system Rapid prototyping system and method
Technical field
The invention belongs to computer data maintenance technology field, and in particular to a kind of data maintenance system rapid prototype development System and method.
Background technology
Computer application system based on data base generally using database table come storage entity data, and to solid data It is requisite function in this kind of system that data in table are safeguarded (increase, change, deleting).Generally, need The special data maintenance program of exploitation or module are realizing this kind of function.The maintenance program of physical data table is generally much like, this Planting similarity causes in program comprising code that is a large amount of simple and repeating.Often workload is very big for the such program of exploitation, but It is with low content of technology.Importantly, if application system caused database table structure to change because of changes in demand, data maintenance Program must be changed accordingly, and to adapt to these changes, this later maintenance to whole system is a very big burden.
The present invention is directed to current present situation, proposes a kind of data maintenance system Rapid prototyping system and method, it is intended to make Human and material resources are saved to greatest extent with efficient programming technique method, and reduces cost shortens product development cycle, seizes city Field first chance.
The content of the invention
The technology solve problem of the present invention:Overcome the deficiencies in the prior art, there is provided a kind of cross-platform data maintenance system and Method, conveniently realizes the modification of data maintenance information, makes programing work more efficient, more convenient, and shortens product development cycle.
The technology of the present invention solution:A kind of data maintenance system Rapid prototyping system, including:Mastery routine framework and XML configuration modules;
Data maintenance page configuration information is divided into dictionary tree information and form data, dictionary tree by the XML configuration modules Information includes SQL statement needed for tree type, spanning tree, tree addition type, sets corresponding master meter title;Form data includes table pair Answer database table title, inquiry field, querying condition, form correspondence Edit button situation, form map field information, form Correspondence is from table information, form and associate field information, the row view information of form, the label page head from table;Match somebody with somebody above-mentioned again Confidence breath is stored in the form of an xml-file, and a configuration information for safeguarding the page is stored as an XML file, and by XML file Parsing, generates corresponding graphical interfaces;
The mastery routine frame module includes XML parsing modules, data maintenance page generation module and data service logic Module;The XML parsing modules parsing XML configuration modules obtain corresponding dictionary tree and form configuration information, and automatically generate Corresponding graphical interfaces;Data maintenance page generation module passes through the graphical interfaces operating database, in the data maintenance page Show the configuration information;Data maintenance logic module carries out attended operation to the data of the data base, including increasing, delete Except, modification and inquire about.
A kind of data maintenance system rapid prototype development method, realizes that step is as follows:
(1) data maintenance page configuration information is divided into into dictionary tree information and form data;
(2) dictionary tree information includes SQL statement needed for tree type, spanning tree, tree addition type, sets corresponding master meter name Claim;Form data includes table correspondence database title, inquiry field, querying condition, form correspondence Edit button situation, table Lattice map field information, form correspondence are from table information, form and the associate field information from table, the row view information of form, mark Sign page head;The various configuration informations of the dictionary tree and form are indicated using XML language, by one the page is safeguarded Configuration information is stored as an XML file, obtains XML configuration informations;
(3) XML configuration informations are parsed and obtains corresponding dictionary tree and form configuration information, and automatically generate corresponding figure Interface;By the graphical interfaces operating database, in configuration information described in data maintenance page presentation;To the data base's Data carry out attended operation, including increase, delete, change and inquire about.
Present invention advantage compared with prior art is:The inventive method, can be easily real by XML configuration file The exploitation of existing data maintenance rapid prototyping system, makes programing work more efficient, more convenient, and shortens product development cycle.
Description of the drawings
Fig. 1 is flowchart of the present invention;
Fig. 2 is login module flow chart in the present invention;
Fig. 3 is generation module block flow chart in median surface of the present invention;
Fig. 4 is data editing module flow chart in the present invention;
Fig. 5 is data display logic module flow chart in the present invention;
Fig. 6 is XML configuration module flow charts in the present invention.
Specific embodiment
Below by specific embodiment, and coordinate accompanying drawing, the present invention is described in detail.
Present system is mainly made up of two big modules, including mastery routine framework, XML Configuration Frameworks.
1. mastery routine framework is used to parse XML, shows and edit database data;
2.XML Configuration Frameworks complete XML configuration features, there is provided parsed to main frame.
Mastery routine frame module
Login module
User logs in page setup user name, password, Service name option, under Service name option is by reading oracle catalogues Tnsname.ora is obtained, including the IP address of service, port numbers etc..To prevent the faulty operation of user, wrong place should be set Reason.During register, the general mistake for occurring has:The user name or password of user input mistake;User is directly single " login " button is hit, miscue frame occurs in the judgement to above-mentioned situation.
When customer side is mounted with oracle clients, program is connected to oracle by way of oci, with the side of oci Formula obtains data base's connection, and the user name to client's input, password judge;When customer side is fitted without oracle client During end, program is connected to oracle by way of thin, and data base's connection is obtained in the way of thin, and to client's input User name, password are judged.Whether procedure judges choose oci or thin modes connects data base, improves program and can use Property.
After logining successfully, connected using singleton pattern data storage storehouse, mastery routine framework modules are used in conjunction with the number Connect according to storehouse, first judge whether data base connection is available or is turned off when using, it is such as unavailable or be turned off, then reacquire Data base connects.This mode is avoided and repeatedly obtains the time-consuming of data base's connection, while ensure that the complete of database session Property.
Interface generation module
(1) interface data is obtained
1) XML configuration informations are read
Including tree configuration information, table configuration information, row view configuration information.
Tree configuration information includes the corresponding master meter title of SQL statement, the tree, the data of the tree needed for tree type, spanning tree Addition type.
Table configuration information includes tabbed information configuration, label page head, Shipping Options Page correspondence tree title;Table essential information is matched somebody with somebody Put, table correspondence database table name, to be inquired about field, querying condition.
Row view configuration information includes time type, date type, picture/mb-type, text box type, RTF types, list Type, tree type, custom option type, final election box type, double selection form types, multiple rows of selection form types, form Tree type configuration information.
2) reading database information
According to database table title in the XML configuration informations for reading, the information of the data form is read from data base, wrapped Include field name, field type, major key information, foreign key information, unique key informations.
(2) interface is generated
1) title bar:The title of software adds the title of upper module.User's specifically what mould operated at present can be illustrated Block.
2) navigation area:It is with designation of unit navigation, so listing the tree of designation of unit in navigation area in this exemplary module Type structure, user clicks on certain record, and will just the data of the related army be shown in the display field on the right.And double-click navigation Icon in tree, then can launch or close the node, such that it is able to seeing or shielding the child node of the node.
3) navigation selection, condition entry area:The content for wanting to be searched in navigation tree can be input into, " inquiry " be clicked on and is pressed Button, will find first record that local matches in navigation tree, again tap on " inquiry " button, can continue down to look into Ask.
4) operation button area:" increase ", " deletion ", " submission ", " cancellation ", " browsing data ", " data are put in the region The order buttons such as derivation ".Click on them, it will select the tables of data that state of activation is currently in area to carry out phase following list The database manipulation answered.
5) list selects area:The title of table page has corresponded to the title of certain specific table in data base, clicks on corresponding table Page, it is possible to activate edit-modify state of the database table in user.
6) display field:The table page of area's selection is selected according to list, the data of the database table are shown in the region. It is only aobvious if clicking certain node in the navigation tree in left side, then the designation of unit shown according to the node is crossed into filter data Show the data of the army.Can be automatically brought to from table in respective field by the field data from table reference in master meter, and from When table increases data newly, also can be according to the corresponding data in master meter.
7) condition prompting area:Related content is pointed out by for the operation of user in the region.For example, in user operation not When, program cannot accordingly when, can prompt the user on how to be input into suitable data;The data of mistake in user input, program without When submitting in normal direction data base, the reason for user error can be pointed out;When user does not know how to be input into, user can be pointed out the data Which is required field in table, and which is major key field.
(3) row view is generated
According to the interface data for obtaining, programming automatic generation row view, row view includes as follows:
1) time type
Time of occurrence selection interface, after selection time, the selected time is filled into data form.
2) date type
There is date selection interface, after option date, the selected date is filled into data form.
3) picture/mb-type
Data form is entered after editing mode, picture editor's window occurs, can carry out the importing of picture, derivation, deletion, Replicate, paste.
4) text box type
Data form is entered after editing mode, multiline text frame editor occurs, edits text, submits data to.
5) RTF types
Data form is entered after editing mode, RTF editors occurs, can carry out importing, derivation, the volume of RTF files Volume, submit data after finishing to.
6) list type
Data form is entered after editing mode, list window occurs, selects the optionies for needing, selected item to be filled into data Form, submits data to after finishing.
7) tree type
Data form is entered after editing mode, tree editor occurs, selects the optionies for needing, selected item to be filled into number According to form, data are submitted after finishing to.
8) custom option type
Data form is entered after editing mode, self-defined selection editor occurs, selects the optionies for needing, selected item Data form is filled into, data are submitted after finishing to
9) final election box type
Data form is check box, check box choose or non-selected state is showing and edit data, editor finishes After submit data to.
10) double selection form types
Data form is entered after editing mode, double Table edit window occurs, selects the optionies for needing, selected item to fill out Data form is charged to, data are submitted after finishing to.
11) multiple rows of selection form types
Data form is entered after editing mode, multiple rows of Table edit window occurs, selects the optionies for needing, selected item to fill out Data form is charged to, data are submitted after finishing to.
12) form tree type configuration information
Data form is entered after editing mode, form tree editor occurs, selects the optionies for needing, selected item filling To data form, data are submitted after finishing to.
Data edition logic module
For input content, data editing module Constrained is limited, and can only be such as input into numeral, can only be input into letter or can only Content of input set form etc.;For data form, data editing module there are a set of general data additions and deletions to change look into logic, When data are submitted to data base, such as there is the mistake that ORACLE data bases return, data edition logic module can point out user Wrong content;When a certain form is chosen at interface, the form is current table, and data edition logic is run for current table.
Data display logic module
The node of left side dictionary tree is clicked on, corresponding database data can be inquired about and shown to right side master meter;In clicking on master meter A certain data, can inquire about and show corresponding database data from table.When in interface editing data, if should in the form Field has external key, then can produce below the form correspondence external key optionies, optionies can be drop-down list form, under Draw tree-like formula or drop-down form.
XML configuration modules
XML has become a kind of general data interchange format, its platform-neutral, language independence, system now Independence, brings great convenience to data integration with interacting.
Engineering management module
(1) engineering configuration file
Engineering configuration file is divided into two parts:
1) engineering name, database name, user name, the encrypted message of engineering are stored, and master meter is from the configuration of table name information File;
2) storing master meter includes the configuration file of row view information, dictionary tree navigation tree specifying information from table specifying information.
(2) newly built construction is created
1) click on and create newly built construction button, occur creating newly built construction navigation dialog box;
2) user input engineering name, connection database name, database user name, database password are lifted;
3) connect after data base's success, database table list of file names occur, there is provided table name screening function;Connection is not into occurring carrying Show information.
(3) engineering is opened
Open engineering and be divided into two kinds of situations:
1) there was only engineering configuration file;
2) there are engineering configuration file, master-salve table dictionary tree navigation tree information configuration file.
(4) interface layout
1) interface left side is engineering tree, and the first nodes of the tree are engineering name, are had under engineering name node " tree information " " master-salve table information " node, is specifically to set title under " tree information " node, is specific table under " master-salve table information " node Title, the such as table have one or more from table, then be it below table node from table name.
2) interface right side is desktop window, double-clicks left side engineering tree node, and right side desktop window represents the detailed of the node Configuration information.
XML information configuration module
(1) information configuration is set
1) virtual tree
Virtual tree is used for situation of the data interface left side without tree, the situation of interface video data form.
DataTree represents tree label, and Type represents tree type, and MTables represents master meter, and Table represents table name.
Configuration information is as follows in XML file:
<DataTree>
<Type>Virtual</Type>
<MTables>
<Table>table1</Table>
<Table>table2</Table>
</MTables>
</DataTree>
2) general type tree
There are dictionary tree, and feelings of the dictionary tree without other particular/special requirements for data interface left side in general type tree Condition.
DataTree represents tree label, and Type represents tree type, and MTables represents master meter, and Table represents table name, SqlString is the SQL query statement for producing general type tree information needed.Configuration information is as follows in XML file:
<DataTree>
<Type>Normal</Type>
<SqlString>Select sequence numbers, title from dictionary _ product information</SqlString>
<MTables>
<Table>table1</Table>
<Table>table2</Table>
</MTables>
</DataTree>
3) navigation tree
Navigation tree provides navigation feature, clicks on navigation tree node, and right side Shipping Options Page show area then shows corresponding with the node Shipping Options Page.DataTree represents tree label, and Type represents tree type, and MTables represents master meter, and Table represents table name.Lead Boat tree root is generated according to the hierarchical relationship between tabbed information and Shipping Options Page.Configuration information is as follows in XML file:
<DataTree>
<Type>TabTree</Type>
<MTables>
<Table>table1</Table>
<Table>table2</Table>
</MTables>
</DataTree>
4) child nodes tree is shown
After choosing the node for showing child nodes tree, all letters of the node and its child nodes can be shown in master meter Breath.DataTree represents tree label, and Type represents tree type, and MTables represents master meter, and Table represents table name, SqlString is the SQL query statement for producing general type tree information needed.Configuration information is as follows in XML file:
<DataTree>
<Type>ShowChildTree</Type>
<SqlString>Select engineering sequence numbers, engineering name from dictionaries _ engineering information</SqlString>
<MTables>
<Table>table1</Table>
<Table>table2</Table>
</MTables>
</DataTree>
5) leaf node tree is added
The type tree is generated by the data message of the SQL statement inquiry under " SqlString " label, and by The data message of " LeafSqlString " inquiry is that leaf node adds child nodes.DataTree represents tree label, Type tables Show tree type, MTables represents master meter, and Table represents table name, and SqlString is to produce general type tree information needed SQL query statement.
All types tree XML configuration informations can be configured<AddEnable></AddEnable>Label, content can be " All " (representing that whole nodes can add) or " Leaf " (represent and only have child node to add).
Configuration information is as follows in XML file:
<DataTree>
<Type>AllLeafTree</Type>
<SqlString>Select sequence numbers, title from dictionary _ product information</SqlString>
<LeafSqlString>Select models from dictionary _ product information _ model where sequence number=</ LeafSqlString>
<MTables>
<Table>table1</Table>
<Table>table2</Table>
</MTables>
</DataTree>
(2) table information configuration
1) table essential information configuration
1. tabbed information configuration, including label page head, Shipping Options Page correspondence tree title;
2. table essential information configuration, including table correspondence database table name, to be inquired about field, querying condition.
2) functional keyss hide configuration
Functional keyss include addition, delete, submit to, cancelling, in addition to above-mentioned generalized edit functional keyss, can be voluntarily fixed again The button of adopted other general utility functionss, such as browses, the Excel preservations of data to the total data of form.By configuring such as subscript Sign and hide these functional keyss.
DisVisible represents invisible, and Button represents button, and add represents addition button, and remove represents that deletion is pressed Button.
<DisVisible>
<Button>add</Button>
<Button>remove</Button>
</DisVisible>
3) from table information configuration
Including from table name, master meter and the associate field from table, configuration information is as follows.
SlaveTables represents that from table STable is represented specifically from table, and name is represented from table name, and Field represents word Section, mtabfield represents master meter field, and stabfield is represented from literary name section.
<SlaveTables>
<STable name=" from table 1 ">
<Field mtabfield=" associate fields " stabfield=" associate fields ">
</STable>
<STable name=" from table 2 ">
<Field mtabfield=" associate fields " stabfield=" associate fields ">
</STable>
</SlaveTables>
(4) map field configuration
RfTables represents the field portions with mapping relations;
One map field information of RfTable tag representations, dbtname element representations need the database table being mapped to Name;
Rtidfield element representations need the field in the data base being mapped to, and its value is identical with ridfield;
The field of value is needed in the data base that confield element representations are mapped to, its value is included the number in interface According in form;
Ridfield represents the actual field of current data form.
Configuration information is as follows:
<RfTables>
<In RfTable dbtname=" products _ information " ridfield=" product ISNs " rtidfield=" products Code " confield=" names of product ">Name of product</RfTable>
</RfTables>
(3) row view information configuration
1) time type
Field type is if DATE in data base, then the row view for giving tacit consent to the field is date plus time format, without the need for Configured in xml.
2) date type
Colname represents the row name of correspondence form, and Date represents that this is classified as date type.
XML configuration informations are:
<View colname=" the dates of birth ">Date</View>
3) picture/mb-type
Colname represents the row name of correspondence form, and Picture represents that this is classified as picture/mb-type.
XML configuration informations are:
<View colname=" personnel's photos ">Picture</View>
4) text box type
Colname represents the row name of correspondence form, and Text represents that this is classified as text box type.
XML configuration informations are:
<View colname=" summaries ">Text</View>
5) RTF types
Colname represents the row name of correspondence form, and Text represents that this is classified as text box type.
XML configuration informations are:
<View colname=" summaries ">Text</View>
6) list type
Colname represents the row name of correspondence form, and dbtable represents data base's name, and idfield represents the tree-like knot of generation Such as " product serial number " etc sequence number mark needed for structure, if idfield is sky, does not generate tree structure and generates list Structure, contentfield represents the field for needing display content, and Tree represents that the type of the row is tree type or list type.
XML configuration informations are:
<View colname=" product categories "
Dbtable=" dictionaries _ product category "
Idfield=" "
Contentfield=" classifications ">Tree</View>
7) tree type
Colname represents the row name of correspondence form, and dbtable represents data base's name, and idfield represents the tree-like knot of generation Such as " product serial number " etc sequence number mark needed for structure, if idfield is sky, does not generate tree structure and generates list Structure, contentfield represents the field for needing display content, and Tree represents that the type of the row is tree type or list type.
XML configuration informations are:
<View colname=" products "
Dbtable=" dictionaries _ product information "
Idfield=" product serial numbers "
Contentfield=" names of product ">Tree</View>
8) custom option type
Colname represents the row name of correspondence form, and itemscontent represents self-defined optionies content, between optionies Separated with space, Combobox represents that this is classified as self-defined Selective type.
XML configuration informations are:
<Whether View colname=" participate in "
Whether itemscontent=" ">Combobox</View>
9) final election box type
Colname represents the row name of correspondence form, and Check represents that this is classified as final election box type, the field such as in data base Data are that " 1 " then check box is chosen, and are that " 0 " check box is not chosen.
XML configuration informations are:
<View colname=" flag bits ">Check</View>
10) double selection form types
Colname represents the row name of correspondence form, and dbtable represents data base's table name, and choiceone represents first choosing An information is selected, " all over products big class " in its value " all over products big class, product category " represents the field in data base.
" product category " represents the field in interface data form, between separated with English comma, and front and back position is sequentially Can not become.Choicetwo is identical with choiceone implications.DoubleChoice represents that this is classified as double selection form types.
XML configuration informations are:
<View colname=" product categories "
Dbtable=" dictionaries _ product classification "
Choiceone=" all over products big class, product category "
Choicetwo=" all over products is classified, product classification ">DoubleChoice</View>
11) multiple rows of selection form types
Colname represents the row name of correspondence form, and dbtable represents data base's table name, and choiceone represents first choosing An information is selected, " all over products big class " in its value " all over products big class, product category " represents the field in data base.
" product category " represents the field in interface data form, between separated with English comma, and front and back position is sequentially Can not become.Choicetwo, choiceone, choicetree implication is identical.MultChoicee represents that this is classified as multiple rows of selection table Lattice type.
XML configuration informations are:
<View colname=" product categories "
Dbtable=" dictionaries _ product classification "
Choiceone=" all over products big class, product category "
Choicetwo=" all over products is classified, product classification "
Choicethree=" all over products subclasses, product subclass ">MultChoice</View>
12) form tree type
Colname represents the row name of correspondence form, and maintreesql represents the SQL query statement needed for production framework tree, Sqlstr represents the SQL query statement generated needed for form.
Collist represents the row name that the field contents that sqlstr is checked out are corresponding in turn to on interface, and order is consistent; Colwidth represents the width of each row of form in form tree, and width is located at for " 0 " if hiding certain row;Rcol is represented The associate field of maintreesql and sqlstring, TableTree represents that the row view is form tree view.
XML configuration informations are:
<View colname=" names "
Sqlstring=" select personnel's names, identification card number, unit from dictionary _ personnel's order by units "
Maintreesql=" select sequence numbers, unit from dictionary _ unit order by sequence numbers " collist=" surnames Name, identification card number, affiliated unit "
Colwidth=" 50,150,0 "
Rcol=" units ">TableTree</View>
System flow
(1) by main frame program user log database;
(2) user selects the page of data to be shown;
(3) as needed with reference to XML configuration file write explanation formulate needed for configuration file;
(4) mastery routine parsing XML configuration file, generates respective interface and corresponding mathematical logic;
(5) client carries out database manipulation after logging in by mastery routine.
Above example only to illustrate technical scheme rather than be limited, the ordinary skill of this area Personnel can modify or equivalent to technical scheme, without departing from the spirit and scope of the present invention, this The protection domain of invention should be to be defined described in claim.

Claims (2)

1. a kind of data maintenance system Rapid prototyping system, it is characterised in that include:Mastery routine framework and XML configuration moulds Block;
The mastery routine frame module includes again:Login module, interface generation module, data edition logic module, data display Logic module;Login module reads ORACLE configuration files, according to user input user name encrypted message, selects OCI or THIN Login mode, and judge whether login is successful;Interface generation module parses XML configuration file, obtains corresponding dictionary tree and table Lattice configuration information, and automatically generate corresponding graphical interfaces;Data maintenance logic module is tieed up to the data of the data base Shield operation, including increase, delete, change and inquire about;Data display logic module chooses nodal information according to dictionary tree, in data Corresponding data is shown in form, and according to data message is chosen in master meter, corresponding data is being shown from table;
The XML configuration modules include again:Engineering management module, XML information configuration module;Engineering management module is used to manage life Into the function of XML configuration file, engineering can be created, engineering is opened, is generated engineering configuration file;XML information configuration module will Data maintenance page configuration information is divided into dictionary tree information and form data, and dictionary tree information is included needed for tree type, spanning tree SQL statement, tree addition type, the corresponding master meter title of tree;Form data includes table correspondence database title, inquiry word Section, querying condition, form correspondence Edit button situation, form map field information, form correspondence are from table information, form and from table Associate field information, the row view information of form, label page head;Again by above-mentioned configuration information with the shape of XML configuration file Formula is stored, and a configuration information for safeguarding the page is stored as an XML configuration file, and XML configuration file is parsed, and generates phase The graphical interfaces answered.
2. a kind of data maintenance system rapid prototype development method, it is characterised in that realize that step is as follows:
(1) data maintenance page configuration information is divided into into dictionary tree information and form data;
(2) dictionary tree information includes SQL statement needed for tree type, spanning tree, tree addition type, sets corresponding master meter title;Table Lattice information includes that table correspondence database title, inquiry field, querying condition, form correspondence Edit button situation, form reflect Field information, form correspondence are penetrated from table information, form and associate field information, the row view information of form, the Shipping Options Page from table Title;The various configuration informations of the dictionary tree and form are indicated using XML language, the configuration for safeguarding the page by Information Store is an XML configuration file, obtains XML configuration informations;
(3) XML configuration informations are parsed and obtains corresponding dictionary tree and form configuration information, and automatically generate corresponding figure circle Face;By the graphical interfaces operating database, in configuration information described in data maintenance page presentation;Number to the data base According to carrying out attended operation, including increase, delete, modification and inquiring about.
CN201410546590.8A 2014-10-15 2014-10-15 Data maintenance system rapid prototyping development system and method Active CN104239073B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201410546590.8A CN104239073B (en) 2014-10-15 2014-10-15 Data maintenance system rapid prototyping development system and method

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201410546590.8A CN104239073B (en) 2014-10-15 2014-10-15 Data maintenance system rapid prototyping development system and method

Publications (2)

Publication Number Publication Date
CN104239073A CN104239073A (en) 2014-12-24
CN104239073B true CN104239073B (en) 2017-05-03

Family

ID=52227215

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201410546590.8A Active CN104239073B (en) 2014-10-15 2014-10-15 Data maintenance system rapid prototyping development system and method

Country Status (1)

Country Link
CN (1) CN104239073B (en)

Families Citing this family (13)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105608088B (en) * 2014-11-19 2019-03-19 中国航空工业集团公司西安飞机设计研究所 A kind of database based on configuration file automatically creates and data dynamic recording method
CN105653513B (en) * 2015-12-30 2019-10-11 北京农信互联科技有限公司 A kind of list input method and system based on pig farm management
CN105700925B (en) * 2016-01-13 2019-02-19 深圳市华讯方舟软件信息有限公司 A kind of interface implementing method and device of APP
CN106843844B (en) * 2016-12-26 2020-06-12 南威软件股份有限公司 Display device of custom view
CN107153544A (en) * 2017-05-09 2017-09-12 合肥汉腾信息技术有限公司 A kind of Worksheet self-defining method and device
CN107506179B (en) * 2017-07-07 2020-09-15 中国建设银行股份有限公司 Interface prototype data generation method and computer equipment
CN107656733A (en) * 2017-08-08 2018-02-02 山东中创软件工程股份有限公司 The visible processing method and system of a kind of business object
CN107562955A (en) * 2017-09-30 2018-01-09 北京酷我科技有限公司 A kind of rapid generation of SQL statement
CN110019306B (en) * 2017-12-27 2021-08-31 航天信息股份有限公司 SQL statement searching method and system based on XML format file
CN110276053A (en) * 2019-06-26 2019-09-24 中国船舶重工集团公司第七一九研究所 Display methods, device and the electronic equipment of the data of custom coding format
CN111382314A (en) * 2020-03-20 2020-07-07 山东浪潮通软信息科技有限公司 Method for realizing flexible configuration of heterogeneous system service integration
CN113360666A (en) * 2021-05-31 2021-09-07 珠海大横琴科技发展有限公司 Data dictionary management method and device, electronic equipment and storage medium
CN113741968A (en) * 2021-08-27 2021-12-03 厦门华厦学院 Method for quickly generating table corresponding to directory tree and tree node of software system

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102646039A (en) * 2012-02-29 2012-08-22 河海大学 Software interface generating system and method based on extensible markup language (XML) Schema
CN103164333A (en) * 2011-12-16 2013-06-19 京信通信系统(中国)有限公司 WEB testing method and WEB testing system of embedded device system and WEB server
CN103593443A (en) * 2013-11-18 2014-02-19 南京新模式软件集成有限公司 Method for electronic file metadata expansion

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7412690B2 (en) * 2003-07-02 2008-08-12 International Business Machines Corporation Method, apparatus, and program for code reusability and maintainability in XML-driven projects

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103164333A (en) * 2011-12-16 2013-06-19 京信通信系统(中国)有限公司 WEB testing method and WEB testing system of embedded device system and WEB server
CN102646039A (en) * 2012-02-29 2012-08-22 河海大学 Software interface generating system and method based on extensible markup language (XML) Schema
CN103593443A (en) * 2013-11-18 2014-02-19 南京新模式软件集成有限公司 Method for electronic file metadata expansion

Also Published As

Publication number Publication date
CN104239073A (en) 2014-12-24

Similar Documents

Publication Publication Date Title
CN104239073B (en) Data maintenance system rapid prototyping development system and method
Welsh Dealing with data: Using NVivo in the qualitative data analysis process
US8127224B2 (en) System for creating and editing mark up language forms and documents
US5664182A (en) Persistent storage of report objects
CA2671284C (en) Generating end-user presentations from structured data
US8010530B2 (en) Presentation of multilingual metadata
US20080215621A1 (en) Metamodel-based automatic report generation
EP1585036A2 (en) Management of parameterized database queries
CN107111639B (en) Building reports
US9069830B2 (en) Retrieving data objects
US7401075B2 (en) System for viewing and indexing mark up language messages, forms and documents
CN110991157A (en) Engineering quality evaluation system design method based on electronic file credible technology
EP3423957A1 (en) Improved construction of database schema models for database systems and rest api&#39;s
CN107368346A (en) A kind of code generating method and device based on metadata and script engine
CN106469140A (en) A kind of report generating system and its method
US20140068422A1 (en) Inserting rules-driven paragraphs into user-designated locations in a document irrespective of modifications to the structure of the document
US6772156B1 (en) Method and apparatus for creating and displaying a table of content for a computer-generated report having page-level security
CN108776702A (en) A kind of data make a report on page user-defined visual configuration method
CN116468010A (en) Report generation method, device, terminal and storage medium
CN109445794A (en) A kind of page building method and device
CN111124938B (en) Method for generating componentized test case
CN102043769A (en) Method and device for editing documents
CN104133680A (en) Fast building method of ERP form module
CN110531964B (en) Personalized intelligent software development method
US20050278306A1 (en) Linked logical fields

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant