CN102346785A - Method and device for directly self-defining field of database - Google Patents
Method and device for directly self-defining field of database Download PDFInfo
- Publication number
- CN102346785A CN102346785A CN2011103623602A CN201110362360A CN102346785A CN 102346785 A CN102346785 A CN 102346785A CN 2011103623602 A CN2011103623602 A CN 2011103623602A CN 201110362360 A CN201110362360 A CN 201110362360A CN 102346785 A CN102346785 A CN 102346785A
- Authority
- CN
- China
- Prior art keywords
- field
- information
- database
- steps
- self
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Abstract
The invention discloses a method for directly self-defining the field of a database, comprising the following steps of: A1, receiving self-defined data table information input by a user from a WEB page, wherein the data table information contains the name of a data table; A2, receiving added field information from the self-defined data table, wherein the field information contains field name and field type; A3, judging whether to continue adding the self-defined data table and the field information; and A4, confirming to finish creating a self-defined table and a field. The invention also discloses a device for directly self-defining the field of a database. The method and device for directly self-defining the field of the database in the invention are widely used and simple and convenient and has the effects of lowering the development difficulty of operation of the database and greatly reducing development work time and labor cost.
Description
Technical field
The present invention relates to field of computer data processing, more particularly, relate to a kind of method and apparatus that is used for directly database being realized custom field.
Background technology
Database (Database) be according to data structure organize, the warehouse of storage and management data; It results from before modern 50 years; Development along with infotech and market; Particularly after nineteen nineties; Data management no longer only is storage and management data, and is transformed into the mode of the needed various data managements of user.Database has number of different types, has all obtained in all fields using widely to the large-scale database system that can carry out mass data storage from the form that the most simply stores various data.
1974, the Ray Boyce of IBM and Don Chamberlin showed the mathematical definition of 12 criterions of Codd relational database with simple key word grammer, had proposed to the milestone formula SQL (StructuredQuery Language) language.The function of sql like language comprises inquiry, manipulation, definition and control, is comprehensive, a general relational database language, is again a kind of language of height deproceduring simultaneously, only requires that the user points out what is done and not it may be noted that how to do.The integrated whole operations that realized in the database life cycle of SQL.SQL provides with relational database and has carried out mutual method, and it can be worked with the standard programming language.From producing, sql like language has just become the test stone of check relational database, and the developing direction of relational database product is all being instructed in the change each time of sql like language standard.
At present, domestic do not have this type of invention of on the Web page, directly database being operated, the general user to the database action need directly through command line mode or the database client through specialty.So need possess certain database professional knowledge and operative skill, higher to the threshold that database uses, the technical requirement of development data storehouse is high, needs suitable human cost.
Summary of the invention
The technical matters that the present invention will solve is, the method and apparatus of directly database being operated on a kind of Web page that is used for database realization custom field is provided.
The invention discloses a kind of method that is used for directly database being realized custom field, comprising:
A1. in the WEB page, receive the self-defining data table information of user's input, described tables of data information comprises tables of data title, explanation of tables, remarks or the like;
A2. in described self-defining data table, receive and add field information, described field information comprises that field title, field type, field description, field length, field are divided into groups and the control information of field;
A3. judging whether needs to continue to add self-defining data table and field information, if not, gets into steps A 4, if return steps A 1;
A4. confirm to accomplish and create self-defined table and field;
A5. field configuration information is safeguarded.
In the method that is used for directly database being realized custom field of the present invention, also comprise between said steps A 1 and the steps A 2:
Whether the title of A11. judging the self-defining data table meets preset definition, if, get into steps A 12, if not, get into steps A 110, display reminding information and refusal are preserved, that is: prompting error message and refusal are preserved;
A12. whether there is tables of data of the same name in the judgment data storehouse, if, then getting into steps A 110, prompting error message and refusal are preserved, and if not, then get into steps A 2.
In the method that is used for directly database being realized custom field of the present invention, also comprise between said steps A 2 and the steps A 3:
A21. judge whether the field title meets preset definition and meet preset definition, if, get into steps A 22, if not, get into steps A 110, prompting error message and refusal are preserved;
A22. whether there is field title of the same name in the judgment data storehouse, if, then getting into steps A 110, prompting error message and refusal are preserved, and if not, then get into steps A 23;
A23. judge field type fill in whether correct, if, then get into steps A 24, if not, then get into steps A 110, prompting error message and refusal are preserved.
A24. judge whether field length meets preset definition, if, then get into A25, if not, then getting into steps A 110, display reminding information and refusal are preserved;
A25. judge whether field divides into groups, if, then get into steps A 4, if not, then getting into steps A 110, display reminding information and refusal are preserved.
The invention also discloses a kind of device that is used for directly database being realized custom field, be used to realize above-mentioned method, comprising:
Self-defining data table information input unit is used for receiving the self-defining data table information that the user imports at the WEB page, and described tables of data information comprises tables of data title, explanation of tables, remarks or the like;
The field information adding device; Preserving the unit with described tables of data information links to each other; Be used for receiving the interpolation field information at described self-defining data table, described field information comprises that field title, field type, field description, field length, field are divided into groups and the control information of field;
Judgement information adding device is preserved the unit with described tables of data information and field information preservation unit links to each other, and is used to judge whether that needs continue to add self-defining data table and field information;
Confirm to accomplish the unit, link to each other, be used for confirming to accomplish self-defined table of establishment and field with described judgement information adding device.
At the device that is used for directly database being realized custom field of the present invention, also comprise tables of data title judging unit at described self-defining data table information input unit, be used for the judgment data table name and claim whether meet preset definition/duplication of name.
At the device that is used for directly database being realized custom field of the present invention, preserve the unit at described field information adding device and field information and comprise and judge that whether correct field title judging unit and field type that whether field meets preset definition/duplication of name fill in field type judging unit; Comprised the field length judging unit: be used to judge that field length is filled in whether meets preset definition; Comprise that also field gives judging unit: be used to judge whether selected field to divide into groups.
At the device that is used for directly database being realized custom field of the present invention, described tables of data information and field information are stored in a plurality of metadata tables preset in the database.
The invention discloses a kind of method of realization custom field device of operating database, be used for the realization custom field device of above-mentioned database,
B1. the realization custom field device of above-mentioned database being made into control is packaged in the Web page;
B2. described control receives user's operating command, and wherein, described operational order is: the data presentation of the maintenance of custom field, the data query of custom field, custom field.
In the method for the realization custom field device of operating database of the present invention, the maintenance of described custom field, concrete steps are:
C1. user control will generate corresponding the interpolation or the modification page according to the attribute of the custom field of having created;
C2. whether the content and the length of judges input meet preset definition, if, getting into steps A 110, prompting error message and refusal are preserved, if meet preset definition, get into step C3;
C3. preserve self-defined information.
In the method for the realization custom field device of operating database of the present invention, the data query of described custom field, concrete steps are:
D1. judge that this field whether can be as querying condition, if, then get into step D2, if not, then get into step D11, that is: this field is presented in the page as search condition;
D2. all can be presented at as the field of querying condition in the page;
D21. whether judges fills in querying condition, if, then get into step D3, if not, step D4 then got into;
D3. the key word of the inquiry of in the custom field querying condition, filling in according to the user generates a complete SQL statement;
D4. this control will not return SQL statement.
In the method for the realization custom field device of operating database of the present invention; The data presentation of described custom field; Specifically: when step e 1. shows self-defining data, will from database, reading and recording also be presented in the page correspondingly.
The invention discloses a kind of system of realization custom field device of operating database, be used to realize above-mentioned method, comprising:
Control is provided with the unit: be used for realization custom field device with above-mentioned database and be made into control and be packaged in the Web page;
The maintenance unit of custom field: with described control the unit is set and links to each other, be used to safeguard custom field;
The data query unit of custom field: with described control the unit is set and links to each other, be used to inquire about custom field;
The data display unit of custom field: with described control the unit is set and links to each other, be used to show the data of custom field.
In the system of the realization custom field device of operating database of the present invention, described custom field maintenance unit comprises: dictionary subelement and text box subelement.
The method and apparatus that is used for database realization custom field of embodiment of the present invention has following beneficial technical effects:
This technological invention greatly reduces the development difficulty for database manipulation; The developer is freed from loaded down with trivial details database manipulation and SQL statement; And make the general user also can realize management and control to a certain extent to database; This invention has ubiquity; Can in various websites and project, call; Method of application is very convenient, and general developer only needs the simple training just can be on top of, thereby greatly reduces the time and the human cost of development.
Description of drawings
Fig. 1 is a kind of self-defining method flow diagram of realization that is used for database of the embodiment of the invention;
Fig. 2 is a kind of self-defining apparatus module block scheme of realization that is used for database of the embodiment of the invention;
Fig. 3 a is the method overview flow chart of the realization custom field device of a kind of operating database of the embodiment of the invention;
Fig. 3 b is the method decomposition process figure of the realization custom field device of a kind of operating database of embodiment;
Fig. 4 is the system of the realization custom field device of a kind of operating database of the embodiment of the invention.
Embodiment
By describing technology contents of the present invention, structural attitude in detail, realized purpose and effect, give explanation below in conjunction with embodiment and conjunction with figs. are detailed.
The realization of this invention is divided into two parts: the establishment of tables of data and data field and maintenance, carry out data typing, maintenance, inquiry and demonstration to accomplishing the tables of data of creating.
At first when creating self-defined table; This technology can judge whether the title of self-defining data table meets preset definition; If do not meet preset definition; Then point out error message and refusal to preserve; If name meets preset definition then continue whether to exist in the judgment data storehouse tables of data of the same name; If exist then return the prompting error message and refusal is preserved; If do not have tables of data of the same name in the database then check and pass through, and relevant tables of data information is saved in carries out record in the metadata table.After accomplishing the definition of tables of data, the user can add field in the self-defining data table.When adding field; Can meet preset definition to the name of field title meets preset definition property and checks; If name does not meet preset definition then point out error message; If name meets whether preset definition is then judged has duplication of name in same the tables of data field title, if exist with file-name field then point out error message.If the field title is judged pass through, to judge that then whether correct field type fill in, whether correct like string length, whether the mantissa of floating number holds water etc.If judge not through point out mistake, if through judging whether that then field is set divides into groups, if judge not through point out mistake, if through then preserving successfully.
After tables of data and data field definition are accomplished, be submitted to, will in database, create corresponding entity form.Concrete grammar is following:
See also Fig. 1, a kind of self-defining method of realization that is used for database of the present invention comprises:
A1. in the WEB page, receive the self-defining data table information of user's input, described tables of data information comprises the tables of data title; Preserve described tables of data information;
A2. in described self-defining data table, receive and add field information, described field information comprises field title, field type;
Also comprise between said steps A 1 and the steps A 2:
Whether the title of A11. judging the self-defining data table meets preset definition meets preset definition, if, get into steps A 12, if not, get into steps A 110, prompting error message and refusal are preserved;
A12. whether there is tables of data of the same name in the judgment data storehouse, if, then getting into steps A 110, prompting error message and refusal are preserved, and if not, then get into steps A 2.
A3. judge whether to continue to be received from the definition of data table and add field information, if not, get into steps A 4, if return steps A 1;
Also comprise between said steps A 2 and the steps A 3:
A21. judge whether the field title meets preset definition and meet preset definition, if, get into steps A 22, if not, get into steps A 110, prompting error message and refusal are preserved;
A22. whether there is field title of the same name in the judgment data storehouse, if, then getting into steps A 110, prompting error message and refusal are preserved, and if not, then get into steps A 23;
A23. judge field type fill in whether correct, if, then get into steps A 24, if not, then get into steps A 110, prompting error message and refusal are preserved.
A24. judge whether field length meets preset definition, if, then get into A25, if not, then getting into steps A 110, display reminding information and refusal are preserved;
A25. judge whether field divides into groups, if, then get into steps A 4, if not, then getting into steps A 110, display reminding information and refusal are preserved.
A4. confirm to accomplish to create self-defined table and field, preserve described field information.
A5. field information is safeguarded.
Generally speaking, the establishment of tables of data and data field and maintenance: have the information that several metadata tables are used for preserving custom data table and data field in the database in advance.The user at first fills in self-defining tables of data in the page, and relevant data table name and descriptor is kept in the metadata table.After accomplishing the definition of tables of data; The user just can add field in tables of data; And fill in the essential information of field and safeguard and the configuration information of page display way during inquiry in order to control data according to the prompting of the page; These information can be kept in the metadata table equally; And can the field that define be presented in the page with the form of tabulation; At this moment, all field essential information and configuration informations can be made amendment.
Accomplish after all definition; The user can confirm and create entity list on Web; Program can produce relevant establishment tables of data automatically; The SQL statement of sequence and relevant trigger also automatically performs; This process does not need the user to participate in; After accomplishing all operations, the page can return creates successful feedback information.
The field of having accomplished in the entity list of establishment can't be made amendment to essential informations such as field types, but can safeguard configuration information.Simultaneously also can be through above-mentioned same process to adding field in the self-defining entity list, system can produce relevant SQL statement automatically equally and automatically perform.
The user can define a certain field for containing dictionary when configuration field, and the dictionary content is safeguarded.The field that is set to contain dictionary can directly be selected from dictionary with the form of drop-down list when carrying out content maintenance.
See also Fig. 2; A kind of device that is used for directly database being realized custom field; Be used to realize above-mentioned method, comprise: self-defining data table information input unit 10, tables of data information are preserved unit 20, field information adding device 30, field information preservation unit 40, judge information adding device 50, are confirmed to accomplish unit 60, dispensing unit 70.Self-defining data table information input unit 10 is used for receiving the self-defining data table information that the user imports at the WEB page, and described tables of data information comprises the tables of data title; Tables of data information is preserved unit 20, links to each other with self-defining data table information input unit 10, is used to preserve described tables of data information; Field information adding device 30 is preserved unit 20 with tables of data information and is linked to each other, and is used for receiving the interpolation field information at described self-defining data table, and described field information comprises field title, field type; Field information is preserved unit 40, links to each other with field information adding device 30, is used to preserve described field information; Judgement information adding device 50 links to each other with self-defining data table information input unit 10 and field information adding device 30, is used to judge whether that needs continue to add self-defining data table and field information; Confirm to accomplish unit 60, link to each other, be used for the affirmation completion and create self-defined table and field with judging information adding device 50; Dispensing unit 70 is used for self-defining data table and the field accomplished are configured.
Self-defining data table information input unit 10 and tables of data information are preserved between the unit 20 and are also comprised tables of data title judging unit, are used for the judgment data table name and claim whether meet preset definition/duplication of name; Field information adding device 30 and field information are preserved unit 40 and are also comprised and judge that whether correct field title judging unit and field type that whether field meets preset definition/duplication of name fill in field type judging unit; Described tables of data information and field information are stored in a plurality of metadata tables preset in the database.
See also Fig. 3 a, Fig. 3 b, a kind of method of realization custom field device of operating database is used to operate the realization custom field device of the database described in the present invention, comprising:
B1. the realization custom field device of above-mentioned database being made into control is packaged in the Web page;
B2. described control receives user's operating command, and wherein, described operational order is: the data presentation of the maintenance of custom field, the data query of custom field, custom field.
Wherein, the maintenance of described custom field, concrete steps are:
C1. user control will generate corresponding the interpolation or the modification page according to the attribute of the custom field of having created;
When custom field is made amendment; Judge at first whether the tables of data at this field place has created entity list; If create; The essential information of this field then; Like the field title; Field types etc. can't be modified, and can only revise as whether being retrieved descriptors such as field grouping; If do not create entity list, then all field informations all can be modified.
Whether custom field also can create entity list to the tables of data at this field place by deletion the time judges that if create, then this field will not allow deletion, if do not create entity list, then allow to be deleted.
Control can judge whether this field needs the user to safeguard when generating; If do not need the field of user's manual maintenance then skip; If need the field of user's manual maintenance to continue then to judge whether it contains dictionary; If contain dictionary; Then input mode is expressed as drop-down list, and preserves the tables of data of dictionary in the reading database, the dictionary information relevant with this field is saved in the drop-down list for alternative; If this field does not contain dictionary, then input mode is expressed as text box.Judge simultaneously whether this field is necessary field, if be must on the page with red asterisk sign, and be that null value is that refusal is preserved in this field.Judge the field type and the length of this field, and the content that is not inconsistent of refusing user's input and field type and field length, the field of numeric type for example is if user's input removes digital and the character the radix point then point out error message; If surpassing the numeral of precision, floating type numeral user input also can point out error message etc.Satisfactory data will obtain correct preservation.
When generating the custom field querying condition; Will judge whether this field can be as querying condition; If misjudgment then skip this field; If correct judgment then continue to judge this field type; If be character type then in the combobox of operation expression, list: " Equals "; " Like "; Expression formulas such as " Not "; If for numeric type or date type then in the combobox of operation expression, list "="; "＞"; "＜"; "＞="; The expression formula of digital operation such as "＜=" expression, and in the text box of input inquiry condition, add the control of restriction input except that numeral and the character the radix point.The time can judge whether self-defined table exists and user's input inquiry content in self-defining querying condition whether in inquiry at last, if self-defined table does not exist or the user does not inquire about custom field, then this control will not return SQL statement.
C2. whether the content and the length of judges input meet preset definition, if, getting into steps A 110, prompting error message and refusal are preserved, if meet preset definition, get into step C3;
C3. preserve self-defined information.
Specifically, the content of the users such as field type of definition input and length etc. limited when user control can be created according to custom field, and the content that exceeds restriction will remind user and refusal to preserve with the mode of page prompts.The field that contains dictionary simultaneously will be with the form of drop-down list so that the user selects.
Accomplish the custom field of safeguarding, the save button that the user can click in the control is preserved.
This user control can be made amendment to the custom field data that are kept in the database simultaneously; The developer only need in the Page_Load method, revise relevant parameter just can be with database in existing self-defining data be presented in the page, the user can directly make amendment to data in the page and preserve.
The data query of described custom field, concrete steps are:
D1. judge that this field whether can be as querying condition, if, then get into step D2, if not, then get into step D11, that is: this field is presented in the page as search condition;
D2. all can be presented at as the field of querying condition in the page;
D21. whether judges fills in querying condition, if, then get into step D3, if not, step D4 then got into;
D3. the key word of the inquiry of in the custom field querying condition, filling in according to the user generates a complete SQL statement;
D4. do not return SQL statement.
Specifically; This function realizes that through the form of user control the developer need be placed on control in the page, and configuration is like parameters such as data table names; When the page loaded, the field that control can be set to inquire about when creating was presented in the page as search condition.This control does not comprise button; The developer need place inquire button in the page; Pass-along message is in control during the trigger button incident; Control can generate a complete SQL statement according to the key word of the inquiry that the user fills in the custom field querying condition; The developer can be embedded into this SQL statement in the SQL statement of master meter querying condition generation, accomplishes a complete SQL statement.
The data presentation of described custom field, concrete steps are: when E1. shows self-defining data, will from database, reading and recording also be presented in the page correspondingly.Specifically, this function realizes through the form of user control.The developer need be placed on control in the page, and disposes like the data table name, parameters such as data major key, and when the page loaded, control can supply the data presentation of certain records the user to check in the page.
See also Fig. 4; A kind of system of realization custom field device of operating database; Be used to realize above-mentioned method; This function realizes through the form of user control; The developer need be placed on control in the page, and configuration is like parameters such as data table names, when the page loads; User control will generate the corresponding page so that the user adds the content of self-defining data and revises according to the attribute of the custom field of having created.Comprise: control is provided with unit 80, the maintenance unit 90 of custom field, the data query unit 100 of custom field, the data display unit 110 of custom field.Control is provided with unit 80: be used for realization custom field device with the database described in the claim 4 and be made into control and be packaged in the Web page; The maintenance unit 90 of custom field: with control unit 80 is set and links to each other, be used to safeguard custom field;
The data query unit 100 of custom field: with control unit 80 is set and links to each other, be used to inquire about custom field;
The data display unit 110 of custom field: with control unit 80 is set and links to each other, be used to show the data of custom field.
Wherein, described custom field maintenance unit comprises: dictionary subelement and text box subelement.
The present invention can make the user on the Web page, oracle database carried out limited operation and management, and the user is freed from the database knowledge of specialty and complicated SQL statement.For the developer, only need simple carry out calling of control and can realize function this invention, need not to carry out extra code and exploitation.The present technique scheme has been encapsulated in all operations to database in webpage and the user control, for the developer, only need call packaged control and carry out the simple parameters configuration, and need not to carry out extra code.For the general user, only need on webpage, carry out simple text and fill in and submit the sequence of operations that just can accomplish database and data recording to, and needn't understand database be how to operate also needn't write SQL statement.
The method and apparatus that is used for database realization custom field of embodiment of the present invention has following beneficial technical effects:
Greatly reduce development difficulty for database manipulation; The developer is freed from loaded down with trivial details database manipulation and SQL statement; And make the general user also can realize management and control to a certain extent to database; This invention has ubiquity; Can in various websites and project, call; Method of application is very convenient, and general developer only needs the simple training just can be on top of, thereby greatly reduces the time and the human cost of development.
Combine accompanying drawing that embodiments of the invention are described above; But the present invention is not limited to above-mentioned embodiment; Above-mentioned embodiment only is schematic; Rather than it is restrictive; Those of ordinary skill in the art is under enlightenment of the present invention; Not breaking away under the scope situation that aim of the present invention and claim protect, also can make a lot of forms, these all belong within the protection of the present invention.
Claims (14)
1. a method that is used for directly database being realized custom field is characterized in that, comprising:
A1. in the WEB page, receive the self-defining data table information of user's input, described tables of data information comprises the tables of data title;
A2. in said self-defining data table, add field information, said field information comprises field title, field type;
A3. judge whether to continue to be received from the definition of data table and add field information, if not, get into steps A 4, if return steps A 1;
A4. confirm to accomplish and create self-defined table and field.
2. the method that is used for directly database being realized custom field according to claim 1 is characterized in that, also comprises between said steps A 1 and the steps A 2:
Whether the title of A11. judging the self-defining data table meets preset definition, if, get into steps A 12, if not, get into steps A 110, display reminding information and refusal are preserved;
A12. whether there is tables of data of the same name in the judgment data storehouse, if, then getting into steps A 110, display reminding information and refusal are preserved and refusal is preserved, and if not, then get into steps A 2.
3. the method that is used for directly database being realized custom field according to claim 1 is characterized in that, also comprises between said steps A 2 and the steps A 3:
A21. judge whether the field title meets preset definition, if, get into steps A 22, if not, get into steps A 110, display reminding information and refusal are preserved;
A22. whether there is field title of the same name in the judgment data storehouse, if, then getting into steps A 110, display reminding information and refusal are preserved, and if not, then get into steps A 23;
A23. judge field type fill in whether correct, if, then get into steps A 24, if not, then get into steps A 110, display reminding information and refusal are preserved;
A24. judge whether field length meets preset definition, if, then get into A25, if not, then getting into steps A 110, display reminding information and refusal are preserved;
A25. judge whether field divides into groups, if, then get into steps A 4, if not, then getting into steps A 110, display reminding information and refusal are preserved.
4. the method that is used for directly database being realized custom field according to claim 1 is characterized in that, also comprises steps A 5, and field information is safeguarded.
5. a device that is used for directly database being realized custom field is used to realize the described method of claim 1, it is characterized in that, comprising:
Self-defining data table information input unit is used for receiving the self-defining data table information that the user imports at the WEB page, and described tables of data information comprises the tables of data title;
The field information adding device links to each other with described self-defining data table information input unit, is used for receiving the interpolation field information at described self-defining data table, and described field information comprises field title, field type;
Judgement information adding device links to each other with described self-defining data table information input unit and field information adding device, is used to judge whether that needs continue to add self-defining data table and field information;
Confirm to accomplish the unit, link to each other, be used for confirming to accomplish self-defined table of establishment and field with described judgement information adding device.
6. the device that is used for directly database being realized custom field according to claim 5; It is characterized in that; Also comprise tables of data title judging unit at described self-defining data table information input unit, be used for the judgment data table name and claim whether meet preset definition/duplication of name.
7. the device that is used for directly database being realized custom field according to claim 5; It is characterized in that, also comprise at described field information adding device and judge that whether correct field title judging unit and field type that whether field meets preset definition/duplication of name fill in field type judging unit.
8. the device that is used for directly database being realized custom field according to claim 5 is characterized in that described tables of data information and field information are stored in a plurality of metadata tables preset in the database.
9. the method for the realization custom field device of an operating database is used for the realization custom field device of the database described in the operational rights requirement 5, it is characterized in that:
B1. the realization custom field device of the database described in the claim 5 being made into control is packaged in the Web page;
B2. described control receives user's operating command, and wherein, described operational order is: the data presentation of the maintenance of custom field, the data query of custom field, custom field.
10. the method for the realization custom field device of operating database according to claim 9 is characterized in that, the maintenance of described custom field, and concrete steps are:
C1. user control generates corresponding the interpolation or the modification page according to the attribute of the custom field of having created;
C2. whether the content and the length of judges input meet preset definition, if, getting into steps A 110, prompting error message and refusal are preserved, if meet preset definition, get into step C3;
C3. preserve self-defined information.
11. the method according to the realization custom field device of the described operating database of claim 10 is characterized in that, the data query of described custom field, and concrete steps are:
D1 judges that this field whether can be as querying condition, if, then get into step D2, if not, then get into step D11, this field is presented in the page as search condition;
D2 can be presented at all in the page as the field of querying condition,
D21. whether judges fills in querying condition, if, then get into step D3, if not, step D4 then got into;
D3. the key word of the inquiry of in the custom field querying condition, filling in according to the user generates a complete SQL statement;
D4. do not return SQL statement.
12. the method for the realization custom field device of operating database according to claim 10; It is characterized in that; The data presentation of described custom field, concrete steps are: when E1. shows self-defining data, will from database, reading and recording also be presented in the page correspondingly.
13. the system of the realization custom field device of an operating database is used to realize the described method of claim 10, it is characterized in that, comprising:
Control is provided with the unit: be used for realization custom field device with the database described in the claim 5 and be made into control and be packaged in the Web page;
The maintenance unit of custom field: with described control the unit is set and links to each other, be used to safeguard custom field;
The data query unit of custom field: with described control the unit is set and links to each other, be used to inquire about custom field;
The data display unit of custom field: with described control the unit is set and links to each other, be used to show the data of custom field.
14. the system according to the realization custom field device of the described operating database of claim 13 is characterized in that described custom field maintenance unit comprises: dictionary subelement and text box subelement.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011103623602A CN102346785A (en) | 2011-11-15 | 2011-11-15 | Method and device for directly self-defining field of database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011103623602A CN102346785A (en) | 2011-11-15 | 2011-11-15 | Method and device for directly self-defining field of database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102346785A true CN102346785A (en) | 2012-02-08 |
Family
ID=45545462
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2011103623602A Pending CN102346785A (en) | 2011-11-15 | 2011-11-15 | Method and device for directly self-defining field of database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102346785A (en) |
Cited By (25)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103020139A (en) * | 2012-11-21 | 2013-04-03 | 用友软件股份有限公司 | Data sheet extension system and method |
| CN103440272A (en) * | 2013-08-05 | 2013-12-11 | 北京康邦科技有限公司 | Database maintenance method and device |
| CN103902676A (en) * | 2014-03-20 | 2014-07-02 | 河北中机盛科信息技术有限公司 | Bill extension item user-defining device and method |
| CN104063409A (en) * | 2013-04-11 | 2014-09-24 | 腾讯科技（深圳）有限公司 | Field adding method and system of database |
| CN104123143A (en) * | 2013-04-24 | 2014-10-29 | 鸿富锦精密工业（深圳）有限公司 | User control loading system and method |
| CN104462361A (en) * | 2014-12-05 | 2015-03-25 | 广州普邦园林股份有限公司 | Method and device for matching data in data table |
| CN104750810A (en) * | 2015-03-30 | 2015-07-01 | 浪潮集团有限公司 | Data querying and processing method based on configuration |
| CN106021453A (en) * | 2016-05-17 | 2016-10-12 | 中国建设银行股份有限公司 | Data processing method and system |
| CN106095821A (en) * | 2016-06-01 | 2016-11-09 | 浪潮软件集团有限公司 | Universal form configuration management method |
| CN106202091A (en) * | 2015-05-04 | 2016-12-07 | 阿里巴巴集团控股有限公司 | A kind of field method to set up and device |
| CN106506661A (en) * | 2016-11-18 | 2017-03-15 | 浪潮软件集团有限公司 | Method, server and system for dynamically returning data |
| CN106598612A (en) * | 2016-12-20 | 2017-04-26 | 北京润科通用技术有限公司 | Operation method and system for data table in database |
| CN106933837A (en) * | 2015-12-29 | 2017-07-07 | 航天信息股份有限公司 | A kind of database table model and creation method |
| CN106940721A (en) * | 2017-03-15 | 2017-07-11 | 百望电子发票数据服务有限公司 | A kind of data processing method and system of self-defined choice box |
| CN107491494A (en) * | 2017-07-24 | 2017-12-19 | 广东省环境监测中心 | A kind of field storage method and system applied to soil environment monitoring system |
| CN107766397A (en) * | 2017-03-03 | 2018-03-06 | 平安医疗健康管理股份有限公司 | Database update method and apparatus |
| CN108197091A (en) * | 2016-12-08 | 2018-06-22 | 腾讯科技（深圳）有限公司 | A kind of method, system and relevant device for creating tables of data |
| CN108256074A (en) * | 2018-01-17 | 2018-07-06 | 链家网（北京）科技有限公司 | Method, apparatus, electronic equipment and the storage medium of checking treatment |
| CN109726204A (en) * | 2018-12-24 | 2019-05-07 | 深圳市奋源科技有限公司 | A kind of data information management method and device based on self-defining data table |
| CN109741018A (en) * | 2018-12-17 | 2019-05-10 | 广州天越电子科技有限公司 | The method and system of the customized management of business are realized by custom field |
| CN110471970A (en) * | 2019-08-08 | 2019-11-19 | 紫光云技术有限公司 | A kind of regulation engine data forwarding method that can flexibly match |
| CN111078713A (en) * | 2019-11-04 | 2020-04-28 | 广东兴睿科技有限公司 | Method for synchronously modifying draggable custom interface and background database |
| CN111984666A (en) * | 2019-05-23 | 2020-11-24 | 北京数聚鑫云信息技术有限公司 | Database access method and device, computer readable storage medium and computer equipment |
| CN112000414A (en) * | 2020-08-24 | 2020-11-27 | 中国银行股份有限公司 | Configurable display method and device of parameter information |
| CN113111239A (en) * | 2021-04-08 | 2021-07-13 | 北京联创新天科技有限公司 | Universal database operation method, device and storage medium thereof |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101241434A (en) * | 2008-03-04 | 2008-08-13 | 浪潮集团山东通用软件有限公司 | Form self-defining method |
| CN101546403A (en) * | 2008-03-27 | 2009-09-30 | 天津德智科技有限公司 | Online service system and method for providing online service |
| CN101609398A (en) * | 2008-06-18 | 2009-12-23 | 中兴通讯股份有限公司 | The development system of network application and method |
| CN101976261A (en) * | 2010-11-04 | 2011-02-16 | 上海银杏界信息科技有限公司 | Storage and search method for webpage data |
| CN102033951A (en) * | 2010-12-15 | 2011-04-27 | 北京新媒传信科技有限公司 | WEB database platform |
-
2011
- 2011-11-15 CN CN2011103623602A patent/CN102346785A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101241434A (en) * | 2008-03-04 | 2008-08-13 | 浪潮集团山东通用软件有限公司 | Form self-defining method |
| CN101546403A (en) * | 2008-03-27 | 2009-09-30 | 天津德智科技有限公司 | Online service system and method for providing online service |
| CN101609398A (en) * | 2008-06-18 | 2009-12-23 | 中兴通讯股份有限公司 | The development system of network application and method |
| CN101976261A (en) * | 2010-11-04 | 2011-02-16 | 上海银杏界信息科技有限公司 | Storage and search method for webpage data |
| CN102033951A (en) * | 2010-12-15 | 2011-04-27 | 北京新媒传信科技有限公司 | WEB database platform |
Cited By (35)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103020139B (en) * | 2012-11-21 | 2016-01-20 | 用友网络科技股份有限公司 | Tables of data expanding system and tables of data extended method |
| CN103020139A (en) * | 2012-11-21 | 2013-04-03 | 用友软件股份有限公司 | Data sheet extension system and method |
| CN104063409A (en) * | 2013-04-11 | 2014-09-24 | 腾讯科技（深圳）有限公司 | Field adding method and system of database |
| CN104063409B (en) * | 2013-04-11 | 2016-03-16 | 腾讯科技（深圳）有限公司 | A kind of field of database increases method and system |
| CN104123143A (en) * | 2013-04-24 | 2014-10-29 | 鸿富锦精密工业（深圳）有限公司 | User control loading system and method |
| CN103440272A (en) * | 2013-08-05 | 2013-12-11 | 北京康邦科技有限公司 | Database maintenance method and device |
| CN103902676A (en) * | 2014-03-20 | 2014-07-02 | 河北中机盛科信息技术有限公司 | Bill extension item user-defining device and method |
| CN104462361B (en) * | 2014-12-05 | 2017-10-31 | 广州普邦园林股份有限公司 | The method and apparatus of data in a kind of matched data table |
| CN104462361A (en) * | 2014-12-05 | 2015-03-25 | 广州普邦园林股份有限公司 | Method and device for matching data in data table |
| CN104750810A (en) * | 2015-03-30 | 2015-07-01 | 浪潮集团有限公司 | Data querying and processing method based on configuration |
| CN106202091A (en) * | 2015-05-04 | 2016-12-07 | 阿里巴巴集团控股有限公司 | A kind of field method to set up and device |
| CN106933837A (en) * | 2015-12-29 | 2017-07-07 | 航天信息股份有限公司 | A kind of database table model and creation method |
| CN106021453A (en) * | 2016-05-17 | 2016-10-12 | 中国建设银行股份有限公司 | Data processing method and system |
| CN106095821A (en) * | 2016-06-01 | 2016-11-09 | 浪潮软件集团有限公司 | Universal form configuration management method |
| CN106506661A (en) * | 2016-11-18 | 2017-03-15 | 浪潮软件集团有限公司 | Method, server and system for dynamically returning data |
| CN108197091A (en) * | 2016-12-08 | 2018-06-22 | 腾讯科技（深圳）有限公司 | A kind of method, system and relevant device for creating tables of data |
| CN106598612A (en) * | 2016-12-20 | 2017-04-26 | 北京润科通用技术有限公司 | Operation method and system for data table in database |
| CN107766397B (en) * | 2017-03-03 | 2020-01-31 | 平安医疗健康管理股份有限公司 | Database updating method and device |
| CN107766397A (en) * | 2017-03-03 | 2018-03-06 | 平安医疗健康管理股份有限公司 | Database update method and apparatus |
| CN106940721A (en) * | 2017-03-15 | 2017-07-11 | 百望电子发票数据服务有限公司 | A kind of data processing method and system of self-defined choice box |
| CN106940721B (en) * | 2017-03-15 | 2020-02-14 | 国信电子票据平台信息服务有限公司 | Data processing method and system for user-defined selection box |
| CN107491494A (en) * | 2017-07-24 | 2017-12-19 | 广东省环境监测中心 | A kind of field storage method and system applied to soil environment monitoring system |
| CN108256074A (en) * | 2018-01-17 | 2018-07-06 | 链家网（北京）科技有限公司 | Method, apparatus, electronic equipment and the storage medium of checking treatment |
| CN108256074B (en) * | 2018-01-17 | 2020-06-23 | 贝壳找房(北京)科技有限公司 | Verification processing method and device, electronic equipment and storage medium |
| CN109741018A (en) * | 2018-12-17 | 2019-05-10 | 广州天越电子科技有限公司 | The method and system of the customized management of business are realized by custom field |
| CN109726204A (en) * | 2018-12-24 | 2019-05-07 | 深圳市奋源科技有限公司 | A kind of data information management method and device based on self-defining data table |
| CN109726204B (en) * | 2018-12-24 | 2023-01-31 | 深圳市奋源科技有限公司 | Data management method and device based on user-defined data table |
| CN111984666A (en) * | 2019-05-23 | 2020-11-24 | 北京数聚鑫云信息技术有限公司 | Database access method and device, computer readable storage medium and computer equipment |
| CN111984666B (en) * | 2019-05-23 | 2024-03-29 | 北京数聚鑫云信息技术有限公司 | Database access method, apparatus, computer readable storage medium and computer device |
| CN110471970A (en) * | 2019-08-08 | 2019-11-19 | 紫光云技术有限公司 | A kind of regulation engine data forwarding method that can flexibly match |
| CN111078713A (en) * | 2019-11-04 | 2020-04-28 | 广东兴睿科技有限公司 | Method for synchronously modifying draggable custom interface and background database |
| CN112000414A (en) * | 2020-08-24 | 2020-11-27 | 中国银行股份有限公司 | Configurable display method and device of parameter information |
| CN112000414B (en) * | 2020-08-24 | 2023-09-19 | 中国银行股份有限公司 | Configurable display method and device for parameter information |
| CN113111239A (en) * | 2021-04-08 | 2021-07-13 | 北京联创新天科技有限公司 | Universal database operation method, device and storage medium thereof |
| CN113111239B (en) * | 2021-04-08 | 2024-03-29 | 北京联创新天科技有限公司 | General database operation method, device and storage medium thereof |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102346785A (en) | Method and device for directly self-defining field of database | |
| US10606573B2 (en) | System and method for computer language migration using a re-architecture tool for decomposing a legacy system and recomposing a modernized system | |
| CN104239073B (en) | Data maintenance system rapid prototyping development system and method | |
| CN103593443A (en) | Method for electronic file metadata expansion | |
| CN104133772A (en) | Automatic test data generation method | |
| CN102609403A (en) | Formatting data by example | |
| US8407235B2 (en) | Exposing and using metadata and meta-metadata | |
| CN107844425A (en) | A kind of database statement inspection method and device | |
| CN107368346A (en) | A kind of code generating method and device based on metadata and script engine | |
| US20110246535A1 (en) | Apparatus and Method for Constructing Data Applications in an Unstructured Data Environment | |
| JP2006172446A (en) | Complex data access | |
| CN102682035A (en) | Data management method and system | |
| US7197696B1 (en) | System, method and computer program product to populate data into spreadsheets and execute functions and programs within the same | |
| CN108228762B (en) | Method and system for configuring master database universal templates | |
| US9990407B2 (en) | Stand-alone database browsing system and method | |
| CN114706915A (en) | Method for building BOM information from PLM system by EDA software | |
| Ossher | A mechanism for specifying the structure of large, layered systems | |
| US7958103B1 (en) | Incorporated web page content | |
| CN110531964B (en) | Personalized intelligent software development method | |
| CN114072787A (en) | System and method for fast data entry to facilitate document review | |
| CN108766513B (en) | Intelligent health medical data structured processing system | |
| CN109376343A (en) | The automatic generation method and electronic equipment of a kind of list under programming platform | |
| US9342518B1 (en) | Declaring directives in a data store | |
| JP2007164503A (en) | System production method, system and program, and data structure of definition information used in system production | |
| CN103116601A (en) | Method and system of improving accuracy degree of intelligent association of input method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20120208 |