CN107015957A - User's list generation method and device - Google Patents
User's list generation method and device Download PDFInfo
- Publication number
- CN107015957A CN107015957A CN201710158999.6A CN201710158999A CN107015957A CN 107015957 A CN107015957 A CN 107015957A CN 201710158999 A CN201710158999 A CN 201710158999A CN 107015957 A CN107015957 A CN 107015957A
- Authority
- CN
- China
- Prior art keywords
- data
- user
- tables
- list
- field
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
Abstract
The present invention relates to a kind of user's list generation method and device, methods described includes obtaining the data table name and each field involved by user's list to be generated；Corresponding data table configuration file is read according to the data table name；The data entry mode of each field is obtained from the tables of data configuration file；According to the data entry mode of each field, user's list is generated.Above-mentioned user's list generation method and device, the data entry mode of each field involved by user's list is stored in advance, so when user needs to set new user's list, then no longer need to reconfigure the data entry mode of each field, the configuration file for inquiring about corresponding tables of data is only needed to obtain the data entry mode of involved field, and new user's list is generated, greatly reduce the workload of exploitation.
Description
Technical field
The present invention relates to database application field, more particularly to a kind of user's list generation method and device.
Background technology
The business datum or key message of user can be typically stored in software application system in database.In order to
Such function is reached, in software development process, software engineer would generally be first according to the business demand of user in database
In set up one or more tables of data, then design the software interface that one or more users interact with tables of data and user be provided record
Enter or change business datum, wherein, the software interface is referred to as user's list.
But there are many tables of data in a usual system, software engineer needs to design many user's lists and volumes
Form handler is write to complete interacting for user and database, and the design of each user's list will include the defeated of data item
Enter the validity check of design and data item, workload is very big, if being related to the change of business demand, for example increase newly, change,
Business datum etc. is deleted, then needs to remodify user's list and corresponding form handler, that is, redesigns new use
The data entry mode of the data item of family list and the validity check of data item etc., development amount is than larger.
The content of the invention
Based on this, it is necessary to for user's list development amount it is big the problem of there is provided a kind of user's list generation side
Method and device.
A kind of user's list generation method, methods described includes：
Obtain the data table name and each field involved by user's list to be generated；
Corresponding data table configuration file is read according to the data table name；
The data entry mode of each field is obtained from the tables of data configuration file；
According to the data entry mode of each field, user's list is generated.
In one of the embodiments, methods described also includes：
Tables of data generation interface is provided；
The data entry mode that interface receives each field of tables of data to be generated is generated by the tables of data；
The data entry mode of each field of the tables of data to be generated is stored to the tables of data configuration file
In；
The tables of data to be generated is generated according to the tables of data configuration file.
In one of the embodiments, it is described receive and store the data table name involved by user's list to be generated and
The step of each field, including：
User's list generation interface is provided；
Interface is generated by user's list and receives involved data table name；
Each field in corresponding data table is shown according to the data table name；
Field in the selected tables of data of interface reception is generated by user's list；
The field stored in the selected tables of data is received as the field involved by user's list, and storage
Data table name be used as the data table name involved by user's list.
In one of the embodiments, methods described also includes：
The data check mode that interface receives each field of the tables of data to be generated is generated by the tables of data；
The data check mode of each field of the tables of data to be generated is stored to the tables of data configuration file
In；
After the step of generation user's list, in addition to：
Pass through the user's list generated and receive input data；
Corresponding tables of data configuration file is read according to the data table name；
The data check mode of each field from tables of data configuration file acquisition user's list；
The input data is verified according to the data check mode；
When Input Data Verification success, then the input data is stored；
When the Input Data Verification fails, then the Input Data Verification is pointed out to fail.
In one of the embodiments, the step verified according to the data check mode to the input data
Suddenly, including：
According to the data check mode, school is carried out to the data type of the input data, length range and purposes
Test；
When the data type of the input data, length range and purposes verify success, then the input number is returned
According to the successful result of verification；
When the data type of the input data, length range and purposes, at least one verification is unsuccessful, then returns
The result of the Input Data Verification failure.
A kind of user's list generating means, described device includes：
First receiving module, data table name and each field involved by user's list to be generated for obtaining；
First read module, for reading corresponding data table configuration file according to the data table name；
First acquisition module, the data entry mode for obtaining each field from the tables of data configuration file；
User's list generation module, for the data entry mode according to each field, generates the user
List.
In one of the embodiments, first receiving module also provides for tables of data generation interface, and passes through number
The data entry mode that interface receives each field of tables of data to be generated is generated according to table；
Memory module, for the data entry mode of each field of the tables of data to be generated to be stored to the number
According in table configuration file；
Tables of data generation module, for generating the tables of data to be generated according to the tables of data configuration file.
In one of the embodiments, first receiving module includes：
First receiving unit, receives involved for providing user's list generation interface, and generating interface by user's list
And data table name, and pass through user's list and generate interface and receive field in the selected tables of data；
Display unit, for showing each field in corresponding data table according to the data table name；
Memory cell, for storing the field in the selected tables of data as the field involved by user's list,
And storage received data table name is used as the data table name involved by user's list.
In one of the embodiments, first receiving module is additionally operable to generate interface reception institute by the tables of data
State the data check mode of each field of tables of data to be generated；
The memory module be additionally operable to by the data check mode of each field of the tables of data to be generated store to
In the tables of data configuration file；
Described device also includes：
Second receiving module, the user's list generated for passing through receives input data；
Second read module, for reading corresponding tables of data configuration file according to the data table name；
Second acquisition module, the data for each field from tables of data configuration file acquisition user's list
Verification mode；
Correction verification module, for being verified according to the data check mode to the input data, and in the input
During data check success, then the input data is stored；When the Input Data Verification fails, then the input data is pointed out
Verification failure.
In one of the embodiments, the correction verification module includes：
Verification unit, for according to the data check mode, data type, length range to the input data with
And purposes is verified；
As a result returning unit, for verifying success in the data type of the input data, length range and purposes,
Then return to the successful result of the Input Data Verification；In the data type of the input data, length range and purposes extremely
A rare verification is unsuccessful, then returns to the result of the Input Data Verification failure.
Above-mentioned user's list generation method and device, the data entry mode of each field involved by user's list is pre-
First stored, so when user needs to set new user's list, then no longer need to reconfigure the data of each field
Input mode, it is only necessary to which the data entry mode of involved field can be obtained by inquiring about the configuration file of corresponding tables of data,
And new user's list is generated, greatly reduce the workload of exploitation.
Brief description of the drawings
Fig. 1 is the schematic diagram of user's form generation system in an embodiment；
Fig. 2 is the flow chart of user's list generation method in an embodiment；
Fig. 3 is the flow chart of tables of data generation step in an embodiment；
Fig. 4 is the surface chart at tables of data generation interface in embodiment illustrated in fig. 3；
Fig. 5 be embodiment illustrated in fig. 2 in step S202 flow chart；
Fig. 6 is the surface chart at user's list generation interface shown in Fig. 5；
Fig. 7 is the flow chart of input data process step in an embodiment；
The flow chart that Fig. 8 is step S708 in embodiment illustrated in fig. 7；
Fig. 9 is the structural representation of user's list generating means in an embodiment.
Embodiment
In order to make the purpose , technical scheme and advantage of the present invention be clearer, it is right below in conjunction with drawings and Examples
The present invention is further elaborated.It should be appreciated that specific embodiment described herein is used only for explaining the present invention, and
It is not used in the restriction present invention.
Describe in detail embodiments in accordance with the present invention before, it should be noted that, described embodiment essentially consist in
The combination of user's list generation method step related to device and system component.Therefore, said system component and method and step
Showed in position by ordinary symbol in the accompanying drawings, and merely illustrate the implementation with understanding the present invention
The relevant details of example, in order to avoid because of those obvious details for having benefited from those of ordinary skill in the art of the present invention
The disclosure is obscured.
Herein, such as left and right, upper and lower, front and rear, and first and second etc relational terms are used merely to area
Divide an entity or action and another entity or action, and not necessarily require or imply any between this entity or action
Actual this relation or order.Term " comprising ", "comprising" or any other variant are intended to including for nonexcludability, by
This causes the process, method, article or the equipment that include a series of key elements not only to include these key elements, but also comprising not bright
Other key elements really listed, or be this process, method, article or the intrinsic key element of equipment.
Referring to Fig. 1, Fig. 1 is the schematic diagram of user's form generation system in an embodiment, including processor, operation
System, database and the device generated for user's list, wherein database is the set of managing related data, above-mentioned data
The tables of data generated and user's list etc. can be stored in storehouse, such as submits when user's typing or after changed data user's table
Single, then processor can collect each data item on user's list, then connect database, the data insertion being collected into or
It is modified in the tables of data for being stored in database.
Referring to Fig. 2, Fig. 2 is the flow chart of user's list generation method in an embodiment, the present embodiment in this way should
Use in user's form generation system in above-mentioned Fig. 1 to illustrate.Operation has user's table on user's form generation system
Single generation program, generates program to realize user's list generation method by user's list.User's list generation method bag
Include：
S202：Obtain the data table name and each field involved by user's list to be generated.
Tables of data is the component units of database, and for sorting data into storage, the essential information classification of such as user is deposited
Enter a file, the Transaction Information classification of user is stored in another file, product information classification one file of deposit, these files
It is exactly tables of data.
User's list refers to the software interface for input data table data, such as in expense reimbursement system, Ke Yitong
Cross expense reimbursement interface and carry out typing and specifically submit an expense account information, this expense reimbursement interface is that can regard user's list as.
Field is the component units of tables of data, and the essential information data of such as user can include user's name, Yong Hudeng
Account ID, login password, user's sex or age of user etc. are recorded, wherein " user's name, User logs in account ID, login are close
Code, user's sex or age of user " is exactly the field of user basic information tables of data, alternatively referred to as user basic information data
The data row of table.
S204：Corresponding data table configuration file is read according to data table name.
Specifically, the information of tables of data is stored in tables of data configuration file, processor can set up data table name and
Tables of data configuration file can be named as data table name by the matching relationship of tables of data configuration file, such as processor, or
Processor can also be built by setting up the mode such as the form of matching relationship of be stored with data table name and data table configuration file
The matching relationship of vertical data table name and data table configuration file.When processor by tables of data configuration file by being named as data
During matching relationship of the mode of table name to set up data table name and data table configuration file, user often creates a new number
A configuration file with tables of data name nominating is then generated according to table, so as to then can uniquely determine phase by data table name
The tables of data configuration file answered.
S206：The data entry mode of each field is obtained from tables of data configuration file.
Specifically, when each field involved by processor receives user's list, it is no longer necessary to software developer
Write for each field data entry mode design program, it is only necessary to simply call be stored in it is each in tables of data
The data entry mode of individual field, greatly reduces workload, and do not need the software developer or programmer of specialty
Operated, the configuration to user's list just can be completed by shirtsleeve operation.
S208：According to the data entry mode of each field, user's list is generated.
When getting the data entry mode of each field for the user's list to be generated, then only need each according to this
The data entry mode of individual field generates user's list, greatly reduces workload.
Above-mentioned user's list generation method, the data entry mode of each field involved by user's list is carried out in advance
Storage, so when user needs to set new user's list, then no longer needs to reconfigure the data input side of each field
Formula, it is only necessary to which the data entry mode of involved field can be obtained by inquiring about the configuration file of corresponding tables of data, and be generated
New user's list, greatly reduces the workload of exploitation.
In one of the embodiments, Fig. 3 and Fig. 4 are referred to, Fig. 3 is the flow of tables of data generation step in an embodiment
Figure, Fig. 4 is the surface chart at tables of data generation interface in embodiment illustrated in fig. 3, in this embodiment, the tables of data generation step bag
Include：
S302：Tables of data generation interface is provided.
As shown in figure 4, tables of data generation interface can include three parts：Form columns configuration section, title configuration
Part and Column Properties configuration section.Wherein form columns configuration section is used for total columns of configuration data table, and title is matched somebody with somebody
Putting part is used for the title of configuration data table, and Column Properties configuration section is used for the attribute of each field in configuration data table.
When user needs newdata table, tables of data generation interface can be opened, the columns of tables of data is set first,
That is the Field Count of corresponding data table, processor, can be in the generation pair of Column Properties configuration section after the columns of user's setting is detected
Answer the Column Properties dispensing unit of quantity, such as Fig. 4, the columns of the tables of data of user configuring is 3, then in Column Properties configuration section meeting
3 Column Properties dispensing units are presented, when current interface can not show 3 Column Properties dispensing units completely, can also carry out
Pagination Display, as shown in figure 4, so as to which user can realize switching of the page etc. by the roller of mouse.
Secondly user can be by the name of the title, i.e. tables of data configuration file of title configuration section configuration data table
Claim, the data table name can be English or phonetic etc., in addition to convenient can also set data tag table, the label can
Think Chinese etc., be easy to memory and nonproductive poll, when user is other countries, the label may be arranged as other languages,
Such as Japanese.
3rd, such as Fig. 4, generate 3 Column Properties dispensing units, and each Column Properties dispensing unit can include：Column name,
Column label, column data type, row length range, row default value, row input prompting, row specific use, data entry mode etc..Its
The row that middle column name corresponds in tables of data, i.e. field name, column label can correspond to the data item title of user's list；Row
Data type could be arranged to text type, numeric type etc.；Row length range can include maximum length and minimum length etc.；
The lime light when column data can be inputted for prompting user is reminded in row input, for example, at least by 6 characters, it is necessary to include English
Chinese character etc., such as row specific use can be for example unique for storing password, picture, user for setting the purposes of the row
Property ID (identity, identity), Email, ordinary attachments, identification card number etc.；Data entry mode is end user in user
The method of input data on list, for example, be manually entered, inputted from other pages selection data item, number is selected from drop-down list
Inputted according to item, individual event selection input, multinomial selection input etc..The content of above-mentioned each Column Properties dispensing unit is not limited to this
Option listed by embodiment, in other embodiments, the content of each Column Properties dispensing unit can be configured as needed.
S304：The data entry mode that interface receives each field of tables of data to be generated is generated by tables of data.
Specifically, with reference to above, user can according to the data entry mode of each field of Column Properties configuration of described dispensing unit,
So as to the configuration of complete paired data table.
S306：The data entry mode of each field of tables of data to be generated is stored into tables of data configuration file.
Specifically, in order to be subsequently generated during user's list, it is no longer necessary to which the data to each field in user's list are defeated
Enter mode to be configured, the data entry mode for each field that may relate to tables of data in the present embodiment is configured in advance
And be stored in tables of data configuration file, when user configuring user's list, it can directly invoke in tables of data configuration file
Data, simplify the generating process of user's list, greatly reduce the workload of exploitation；In addition, in user configuring tables of data
When, option and installment can be carried out by drop-down menu etc., the option and installment is configuring number by research staff's preprogramming
According to table field when no longer need user to be programmed, can greatly reduce tables of data configuration workload.
S308：Tables of data to be generated is generated according to tables of data configuration file.
Specifically, after user configuring completes tables of data, because processor has obtained the title of tables of data, total row
Number, the column name each arranged, column label, column data type, row length range, row default value, row input are reminded, arrange special use
On the way, data entry mode etc., processor can go out these information structurings by configuration processor the SQL for creating tables of data
(Structured Query Language, SQL) sentence, then connects database, performs the sentence and then may be used
To be created that corresponding tables of data in database, wherein SQL statement needs many one ID (identity, identity) row of increase to make
For major key, for the uniqueness recorded in mark data table.
In above-described embodiment, the input that interface receives each field involved in tables of data is generated beforehand through tables of data
Mode etc. is configured, and generates corresponding configuration file, so that in user's list generating process, it is no longer necessary to user's list institute
Data entry mode for each field being related to etc. is configured, and only needs to call the tables of data configuration file of corresponding data table
The relevant configuration of respective field can be inquired, such as data entry mode, so as to greatly reduce the workload of exploitation.
Fig. 5 and Fig. 6 are referred to, Fig. 5 is the flow chart of the step S202 in embodiment illustrated in fig. 2, and Fig. 6 is shown in Fig. 5
User's list generates the surface chart at interface, and in this embodiment, step S202 receives and store user's list institute to be generated
The step of data table name and each field for being related to, it can include：
S502：User's list generation interface is provided.
Specifically, interface is generated there is provided user's list refering to Fig. 6, user's list generates interface and selected including tables of data
Partly, user's form name configuration section and data sheet field selected section.Wherein, tables of data selected section is used to select to be generated
Into user's list belonging to tables of data, user's form name configuration section is used to configure the title of user's list in order to follow-up
Using calling during user's list, data sheet field selected section is used for all fields for providing selected tables of data, so as to
The field involved by user's list to be generated is therefrom selected in user.
A general tables of data can configure multiple user's lists, when user needs newly-built user's list, can open
User's list generates interface, selects the tables of data belonging to user's list to be generated from tables of data selected section first, such as schemes
6, select the presence of 3 fields in user basic information tables of data, the table, including user's name, user's sex and user identity card
Number, then 3 fields can be shown in data sheet field selected section, so that user selects.
Secondly, user can configure the title of user's list by user's form name configuration section, and user can pass through
The part sets user's form name, user's form tags and user's list title etc., and user's form name can be with user
The title of list configuration file is identical, is unique to identify user's form name, user's form tags are to be used to help
Family is remembered quickly to find user's list, and user's list title is shown on user's list, and for example " user believes substantially
Cease tables of data " etc..
3rd, when user have selected tables of data, and each field in user's list generation interface display corresponding data table,
Title, label including each field etc., can set a choice box, when user chooses the choice box on the side of the field
When, then it represents that user's list is related to the field.
S504：Interface is generated by user's list and receives involved data table name.
Specifically, referring to Fig. 6, user can select corresponding tables of data by way of drop-down menu, can also be direct
Selected by the title of input data table.When being selected by directly inputting the title of tables of data, then it can utilize upper
The label of set tables of data is stated, user only needs to input the label of corresponding tables of data, you can to call out corresponding data
Table.
S506：Each field in corresponding data table is shown according to data table name.
Specifically, after user chooses corresponding tables of data, user's list generation interface can then directly display this
Involved corresponding field, such as user's name, user's sex and user identity card word shown in Fig. 6 in tables of data
Section.
S508：Field in the selected tables of data of interface reception is generated by user's list.
Specifically, when showing the respective field of tables of data, user can select current user's list institute to be generated
The field being related to, so as to only configure user's list by simply choosing action, it is not necessary to write the journey of complexity again
Sequence etc..
S510：The field stored in selected tables of data is connect as the field involved by user's list, and storage
The data table name of receipts is used as the data table name involved by user's list.
After user configuring completes the respective field of user's list, processor generation user's list configuration file, and carry out
Storage, the title of entitled user's list of user's list configuration file.
After generation user's list configuration file, processor can read user's list according to the title of user's list and match somebody with somebody
File is put, the title and all fields of user's list is therefrom obtained, includes the default value etc. of each field, then according to number
Corresponding tables of data configuration file is read according to table name, the data entry mode of each field in user's list is obtained, and according to
The data entry mode of each field calls corresponding input control, is sequentially displayed in display interface and is inputted for user.For example
If data entry mode is drop-down list input mode, corresponding drop down list control is called；If data entry mode
Time input mode, then allocating time input control；If data entry mode is to call date input mode, day is called
Phase input control；If data entry mode, which is annex, uploads mode, annex uploading control is called；If data entry mode
It is plain text input mode, then calls plain text input control.Control for needing user data, processor can be carried
Supplier's method supplies the related data of the user configuring control, such as when the input mode that certain data is arranged in some tables of data arranges for drop-down
When table is inputted, processor can provide the selection data required for method is configured in the drop-down list, for example, " completed, carried out
In, cancel, hang up ", then these data are stored in control data configuration file, the configuration data of control configuration file is pressed
Storage is indexed according to data table name and data column name, each data can correspond to some in specific tables of data
Data are arranged.Processor also provides method, and user can change matching somebody with somebody for the control that data row are related in any one tables of data at any time
Put data.
In this embodiment, user only needs that by simply operating new user's list can be configured, and no longer needs
New data entry mode of user's list etc. is recompiled, it is simple to operate.
In one of the embodiments, during tables of data is generated, refering to Fig. 4, it can also include passing through tables of data
Generate the data check mode that interface receives each field of tables of data to be generated.By each field of tables of data to be generated
Data check mode store into tables of data configuration file.Wherein, data check mode described herein include data type,
Length range and purposes, when user is in configuration data table, those contents are carried out with postponing, then can be according to those contents
The data that user inputs are verified.In actual applications, by the data check mode of each field involved by tables of data
Stored, such as data type, length range and purposes, when user is by user's list input data, Ke Yitong
Cross the real-time school of data progress that the data type stored in tables of data configuration file, length range and purposes etc. are inputted to user
Test, to ensure the validity of data.
Specifically, referring to Fig. 7, Fig. 7 is the flow chart of input data process step in an embodiment, at the input data
Manage step that is, after the step of generating user's list, be able to can also include after the step S208 shown in Fig. 2：
S702：Pass through generated user's list and receive input data.
Specifically, after user's list is generated, user is that data to be entered can be inputted by user's list, for example
By taking user's list that user's list generation interface shown in Fig. 6 is generated as an example, user can be inputted by user's list and be used
Name in an account book claims and identification card number.
S704：Corresponding tables of data configuration file is read according to data table name.
Specifically, it is necessary to the title and identification card number that are inputted to user after user inputs user's name and identification card number
Verified, the data that thereby may be ensured that user's input are effective data.
S706：The data check mode of each field from tables of data configuration file acquisition user's list.
Specifically, the data check mode of the field of each in tables of data is matched somebody with somebody during tables of data is generated
Put, so when generating user's list, it is no longer necessary to which the data check mode to the field is configured, it is possible to reduce exploitation work
Measure.And corresponding tables of data configuration file can be inquired by data table name, can be with so that when user input data
Tables of data configuration file is called to realize the verification to the data of input.
S708：Input data is verified according to data check mode.
Specifically, when processor, which detects user, submits input data by user's list, i.e., matched somebody with somebody by tables of data
File is put to verify input data.
S710：When Input Data Verification success, then input data is stored.
Specifically, when Input Data Verification success, then the input data is submitted in corresponding tables of data by processor,
I.e. processor according to user's form name read user's list configuration file so that obtain fields all on user's list and
Corresponding data table name, then the value of each field on user's list is obtained, constructing SQL statement connects database, will be corresponding
Input data is stored into corresponding tables of data.
S712：When Input Data Verification fails, then Input Data Verification failure is pointed out.
Specifically, when Input Data Verification fails, then the information of failure can be verified by display data to use
Family, to point out user to re-enter data etc..
In above-described embodiment, when user is by user's list input data, it can be called accordingly according to data table name
Tables of data configuration file, so as to carry out automatic Verification to input data according to tables of data configuration file, it is not necessary in generation
Data check mode is reset during user's list, it is possible to reduce the workload of development process.
In one of the embodiments, step S708 is the step verified according to data check mode to input data
Suddenly, it can include：According to data check mode, the data type of input data, length range and purposes are verified；When
Data type, length range and the purposes of input data verify success, then return to the successful result of Input Data Verification；When
At least one verification of data type, length range and the purposes of input data is unsuccessful, then returns to Input Data Verification and lose
The result lost.
Specifically, it may refer to Fig. 8, the flow chart that Fig. 8 is step S708 in embodiment illustrated in fig. 7, in this embodiment,
Tables of data configuration file is read according to data table name first, then obtains every in user's list from the tables of data configuration file
Data type, length range and the purposes of individual field；Secondly Effective judgement is carried out to each input data in user's list,
For example when the data type configured in tables of data configuration file is integer, then integer validity check function pair is called to input number
According to being verified；If the data type configured in tables of data configuration file is decimal, decimal validity check function is called
Input data is verified；If the data type configured in tables of data configuration file is time or date, allocating time
Or date validation verification function pair input data is verified；If the data type configured in tables of data configuration file is text
This, then judge whether text size scope is reasonable, if unreasonable, data length scope mistake is pointed out, if text size
Scope is reasonable, and the purposes of data field is storage Email, then calls Email Effective judgement function pair to input number
According to being verified；If the purposes of data field is storage telephone number, call telephone number Effective judgement function pair defeated
Enter data to be verified；If the purposes of data field is storage identity ID, call identity card Effective judgement function pair defeated
Enter data to be verified；If the purposes of data field is storage URL addresses, URL address validity discriminant functions pair are called
Input data is verified；If the purposes of data field is not storage URL addresses, storage identity ID, storage telephone number and
Email is stored, then calls other Effective judgement function pair input datas to be verified；If in tables of data configuration file
The data type of configuration is not text, time or date, decimal and integer, then calls the Validity Function pair of other data types
Input data is verified.
In above-described embodiment, by being verified to the data type of input data, length range and purposes, Ke Yibao
The validity of the data of input is demonstrate,proved, and the data check mode of input data need not be once again set up, only by data table name
Claim the data check mode that can obtain corresponding field, it is simple to operate.
Refer to shown in Fig. 9, Fig. 9 is the structural representation of user's list generating means in an embodiment, in the embodiment
In, the device can include：
First receiving module 100, data table name and each field involved by user's list to be generated for obtaining.
First read module 200, for reading corresponding data table configuration file according to data table name.
First acquisition module 300, the data entry mode for obtaining each field from tables of data configuration file.
User's list generation module 400, for the data entry mode according to each field, generates user's list.
In one of the embodiments, the first receiving module 100 also provides for tables of data generation interface, and passes through data
Table generation interface receives the data entry mode of each field of tables of data to be generated.
Memory module, is configured for the data entry mode of each field of tables of data to be generated to be stored to tables of data
In file.
Tables of data generation module, for generating tables of data to be generated according to tables of data configuration file.
In one of the embodiments, the first receiving module 100 includes：
First receiving unit, receives involved for providing user's list generation interface, and generating interface by user's list
And data table name, and pass through user's list and generate interface and receive field in selected tables of data.
Display unit, for showing each field in corresponding data table according to data table name.
Memory cell, for storing the field in selected tables of data as the field involved by user's list, and
Storage received data table name is used as the data table name involved by user's list.
In one of the embodiments, the first receiving module 100 is additionally operable to receive to be generated by tables of data generation interface
Tables of data each field data check mode.
Memory module, which is additionally operable to store the data check mode of each field of tables of data to be generated to tables of data, matches somebody with somebody
Put in file.
Device can also include：
Second receiving module, the user list generated for passing through receives input data.
Second read module, for reading corresponding tables of data configuration file according to data table name.
Second acquisition module, the data check side for each field from tables of data configuration file acquisition user's list
Formula.
Correction verification module, for being verified according to data check mode to input data, and in Input Data Verification success
When, then store input data；When Input Data Verification fails, then Input Data Verification failure is pointed out.
In one of the embodiments, correction verification module can include：
Verification unit, for according to data check mode, entering to the data type of input data, length range and purposes
Row verification.
As a result returning unit, for verifying success in the data type of input data, length range and purposes, is then returned
Return the successful result of Input Data Verification；In at least one verification of the data type of input data, length range and purposes
It is unsuccessful, then return to the result of Input Data Verification failure.
The above-mentioned specific restriction for user's list generating means is referred to above for user's list generation method
Limit, will not be repeated here.
Each technical characteristic of embodiment described above can be combined arbitrarily, to make description succinct, not to above-mentioned reality
Apply all possible combination of each technical characteristic in example to be all described, as long as however, the combination of these technical characteristics is not deposited
In contradiction, the scope of this specification record is all considered to be.
Embodiment described above only expresses the several embodiments of the present invention, and it describes more specific and detailed, but simultaneously
Can not therefore it be construed as limiting the scope of the patent.It should be pointed out that coming for one of ordinary skill in the art
Say, without departing from the inventive concept of the premise, various modifications and improvements can be made, these belong to the protection of the present invention
Scope.Therefore, the protection domain of patent of the present invention should be determined by the appended claims.
Claims (10)
1. a kind of user's list generation method, it is characterised in that methods described includes：
Obtain the data table name and each field involved by user's list to be generated；
Corresponding data table configuration file is read according to the data table name；
The data entry mode of each field is obtained from the tables of data configuration file；
According to the data entry mode of each field, user's list is generated.
2. according to the method described in claim 1, it is characterised in that methods described also includes：
Tables of data generation interface is provided；
The data entry mode that interface receives each field of tables of data to be generated is generated by the tables of data；
The data entry mode of each field of the tables of data to be generated is stored into the tables of data configuration file；
The tables of data to be generated is generated according to the tables of data configuration file.
3. method according to claim 1 or 2, it is characterised in that the reception simultaneously stores user's list institute to be generated
The step of data table name and each field for being related to, including：
User's list generation interface is provided；
Interface is generated by user's list and receives involved data table name；
Each field in corresponding data table is shown according to the data table name；
Field in the selected tables of data of interface reception is generated by user's list；
The field in the selected tables of data is stored as the field involved by user's list, and the received number of storage
The data table name involved by user's list is used as according to table name.
4. method according to claim 2, it is characterised in that methods described also includes：
The data check mode that interface receives each field of the tables of data to be generated is generated by the tables of data；
The data check mode of each field of the tables of data to be generated is stored into the tables of data configuration file；
After the step of generation user's list, in addition to：
Pass through the user's list generated and receive input data；
Corresponding tables of data configuration file is read according to the data table name；
The data check mode of each field from tables of data configuration file acquisition user's list；
The input data is verified according to the data check mode；
When Input Data Verification success, then the input data is stored；
When the Input Data Verification fails, then the Input Data Verification is pointed out to fail.
5. method according to claim 4, it is characterised in that it is described according to the data check mode to the input number
The step of according to being verified, including：
According to the data check mode, the data type of the input data, length range and purposes are verified；
When the data type of the input data, length range and purposes verify success, then the input data school is returned to
Test successful result；
When the data type of the input data, length range and purposes, at least one verification is unsuccessful, then returns described
The result of Input Data Verification failure.
6. a kind of user's list generating means, it is characterised in that described device includes：
First receiving module, data table name and each field involved by user's list to be generated for obtaining；
First read module, for reading corresponding data table configuration file according to the data table name；
First acquisition module, the data entry mode for obtaining each field from the tables of data configuration file；
User's list generation module, for the data entry mode according to each field, generates user's list.
7. device according to claim 6, it is characterised in that first receiving module also provides for tables of data generation
Interface, and the data entry mode that interface receives each field of tables of data to be generated is generated by tables of data；
Memory module, for the data entry mode of each field of the tables of data to be generated to be stored to the tables of data
In configuration file；
Tables of data generation module, for generating the tables of data to be generated according to the tables of data configuration file.
8. the device according to claim 6 or 7, it is characterised in that first receiving module includes：
First receiving unit, is generated involved by the reception of interface for providing user's list generation interface, and by user's list
Data table name, and the field in the selected tables of data of interface reception is generated by user's list；
Display unit, for showing each field in corresponding data table according to the data table name；
Memory cell, for storing the field in the selected tables of data as the field involved by user's list, and
Storage received data table name is used as the data table name involved by user's list.
9. device according to claim 8, it is characterised in that first receiving module is additionally operable to by the tables of data
Generate the data check mode that interface receives each field of the tables of data to be generated；
The memory module is additionally operable to store the data check mode of each field of the tables of data to be generated to described
In tables of data configuration file；
Described device also includes：
Second receiving module, the user's list generated for passing through receives input data；
Second read module, for reading corresponding tables of data configuration file according to the data table name；
Second acquisition module, the data check for each field from tables of data configuration file acquisition user's list
Mode；
Correction verification module, for being verified according to the data check mode to the input data, and in the input data
When verifying successfully, then the input data is stored；When the Input Data Verification fails, then the Input Data Verification is pointed out
Failure.
10. device according to claim 9, it is characterised in that the correction verification module includes：
Verification unit, for according to the data check mode, to the data type of the input data, length range and use
Way is verified；
As a result returning unit, for verifying success in the data type of the input data, length range and purposes, is then returned
Return the successful result of Input Data Verification；In the data type of the input data, length range and purposes at least
One verification is unsuccessful, then returns to the result of the Input Data Verification failure.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710158999.6A CN107015957A (en) | 2017-03-16 | 2017-03-16 | User's list generation method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710158999.6A CN107015957A (en) | 2017-03-16 | 2017-03-16 | User's list generation method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107015957A true CN107015957A (en) | 2017-08-04 |
Family
ID=59440748
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710158999.6A Pending CN107015957A (en) | 2017-03-16 | 2017-03-16 | User's list generation method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107015957A (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107688664A (en) * | 2017-09-25 | 2018-02-13 | 平安科技（深圳）有限公司 | Chart generation method, device, computer equipment and storage medium |
| CN109165266A (en) * | 2018-09-03 | 2019-01-08 | 中国平安人寿保险股份有限公司 | List generation method, device, computer equipment and storage medium |
| CN109902511A (en) * | 2019-02-18 | 2019-06-18 | 天津字节跳动科技有限公司 | Method of data capture and device |
| CN110096496A (en) * | 2019-03-27 | 2019-08-06 | 深圳市买买提信息科技有限公司 | A kind of form validation method, relevant apparatus and equipment |
| CN112054741A (en) * | 2020-08-06 | 2020-12-08 | 深圳市杉川机器人有限公司 | Motor control method and device, terminal equipment and storage medium |
| CN112104292A (en) * | 2020-08-06 | 2020-12-18 | 深圳市杉川机器人有限公司 | Motor control method and device, terminal equipment and storage medium |
| CN113592633A (en) * | 2021-08-04 | 2021-11-02 | 上海通联金融服务有限公司 | Method for credit card approval and approval business |
| CN115309752A (en) * | 2022-09-30 | 2022-11-08 | 畅捷通信息技术股份有限公司 | Multi-tenant dynamic form generation method and device and storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101221564A (en) * | 2007-08-03 | 2008-07-16 | 哈尔滨工程大学 | Universal independent data acquisition method |
| CN102201009A (en) * | 2011-06-21 | 2011-09-28 | 深圳市凯立德科技股份有限公司 | Form generating method and device |
| CN102779040A (en) * | 2012-06-21 | 2012-11-14 | 东莞市微模式软件有限公司 | Method and device for generating user-defined form |
-
2017
- 2017-03-16 CN CN201710158999.6A patent/CN107015957A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101221564A (en) * | 2007-08-03 | 2008-07-16 | 哈尔滨工程大学 | Universal independent data acquisition method |
| CN102201009A (en) * | 2011-06-21 | 2011-09-28 | 深圳市凯立德科技股份有限公司 | Form generating method and device |
| CN102779040A (en) * | 2012-06-21 | 2012-11-14 | 东莞市微模式软件有限公司 | Method and device for generating user-defined form |
Cited By (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107688664A (en) * | 2017-09-25 | 2018-02-13 | 平安科技（深圳）有限公司 | Chart generation method, device, computer equipment and storage medium |
| CN107688664B (en) * | 2017-09-25 | 2020-04-03 | 平安科技（深圳）有限公司 | Chart generation method and device, computer equipment and storage medium |
| CN109165266A (en) * | 2018-09-03 | 2019-01-08 | 中国平安人寿保险股份有限公司 | List generation method, device, computer equipment and storage medium |
| CN109902511A (en) * | 2019-02-18 | 2019-06-18 | 天津字节跳动科技有限公司 | Method of data capture and device |
| CN110096496A (en) * | 2019-03-27 | 2019-08-06 | 深圳市买买提信息科技有限公司 | A kind of form validation method, relevant apparatus and equipment |
| CN112104292A (en) * | 2020-08-06 | 2020-12-18 | 深圳市杉川机器人有限公司 | Motor control method and device, terminal equipment and storage medium |
| CN112054741A (en) * | 2020-08-06 | 2020-12-08 | 深圳市杉川机器人有限公司 | Motor control method and device, terminal equipment and storage medium |
| CN112054741B (en) * | 2020-08-06 | 2022-06-03 | 深圳市杉川机器人有限公司 | Motor control method and device, terminal equipment and storage medium |
| CN112104292B (en) * | 2020-08-06 | 2022-07-22 | 深圳市杉川机器人有限公司 | Motor control method, device, terminal equipment and storage medium |
| CN113592633A (en) * | 2021-08-04 | 2021-11-02 | 上海通联金融服务有限公司 | Method for credit card approval and approval business |
| CN113592633B (en) * | 2021-08-04 | 2024-03-29 | 上海通联金融服务有限公司 | Method for credit card approval and approval business |
| CN115309752A (en) * | 2022-09-30 | 2022-11-08 | 畅捷通信息技术股份有限公司 | Multi-tenant dynamic form generation method and device and storage medium |
| CN115309752B (en) * | 2022-09-30 | 2023-01-13 | 畅捷通信息技术股份有限公司 | Multi-tenant dynamic form generation method and device and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107015957A (en) | User's list generation method and device | |
| CN102521734B (en) | E-mail system based on dialogue shows the message of extension | |
| US10069892B2 (en) | Versatile information management system and method thereof | |
| US9047346B2 (en) | Reporting language filtering and mapping to dimensional concepts | |
| US8468167B2 (en) | Automatic data validation and correction | |
| CN104361139A (en) | Data importing device and method | |
| US10585947B2 (en) | Linking business objects and documents | |
| US9639518B1 (en) | Identifying entities in a digital work | |
| EP2168059A1 (en) | Integrated sharing of electronic documents | |
| WO2009043009A2 (en) | Auto-generation and syndication of tables as forms | |
| CN112631997A (en) | Data processing method, device, terminal and storage medium | |
| US11727213B2 (en) | Automatic conversation bot generation using input form | |
| US10482150B1 (en) | Electronic forms interaction framework for a consistent user experience | |
| JP6087452B1 (en) | Paper document management system | |
| US20050240562A1 (en) | Method, computer program product and device for importing a plurality of data sets into a system | |
| US8832086B1 (en) | Method and system for search listing pagination | |
| CN109635300A (en) | Data verification method and device | |
| EP2272043A2 (en) | Electronic donor medical records management system | |
| CN110999264A (en) | System and method for integrating message content into a target data processing device | |
| US8909748B1 (en) | Configurable views of context-relevant content | |
| US9336377B2 (en) | Synchronized sign-on methods for non-programmatic integration systems | |
| US20210390251A1 (en) | Automatic generation of form application | |
| KR100720891B1 (en) | System of Managing Book-Lending Interlinking with Database and Process of Managing Book-Lending Using the Same | |
| CN108304291B (en) | Test input information retrieval apparatus and method | |
| CN103324986A (en) | Reservation management device and reservation management method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |