CN109344151A - The method of batch registration and modification user information - Google Patents
The method of batch registration and modification user information Download PDFInfo
- Publication number
- CN109344151A CN109344151A CN201810896908.3A CN201810896908A CN109344151A CN 109344151 A CN109344151 A CN 109344151A CN 201810896908 A CN201810896908 A CN 201810896908A CN 109344151 A CN109344151 A CN 109344151A
- Authority
- CN
- China
- Prior art keywords
- data set
- user
- user information
- data
- document
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Disclose the method for a kind of batch registration and modification user information, comprising: the document is submitted to server by the user information typing document to be registered of batch by administrator；The server reads the data in document, is reconstructed into the data set A and unverified data set B by verification；The data set A by verification is reconstructed into non-registered users data set A1 and registered users data set A2；Registered users data set A2 is reconstructed into the user data set A21 and illegal user's data set A22 for needing to modify；By non-registered users data set A1 and the user data set A21 modified merging is needed to be inserted into the registration table of database.Present invention batch registration user information by way of submitting document simplifies administrator's operation；By the way that whole operation flow is divided into separate traffic branch, and the batch data submitted according to branch module reconstruct, reduces unnecessary flow chart of data processing, make the simpler convenience of resume module.
Description
Technical field
The present invention relates to electronic information field, in particular to a kind of method of batch registration modification user information.
Background technique
In being normally applied system, user's registration fills in logon form in homepage by user, and registration information is submitted to clothes
It is engaged in end, receiving verify its specification for whether meeting system setting after submitting record from the background.After record is by verification, from the background according to pass
Key field judges whether record is existing in library, there is no being then saved in library, initialising subscriber information；In the presence of then illustrate weight
Name, returns to user for exception information.In management information system and enterprise application system, function mould that user can be used
Block is controlled by permission, cannot oneself register account number, but by administrator's uniform registration of this area or department distribute account.Management
If member's fill message one by one when register user, submission, heavy workload and time-consuming, so needing to infuse by the way of batch
Volume user information improves efficiency.
Therefore, expect to develop a kind of method for capableing of batch registration and modification user information.
Summary of the invention
In order to solve the above problem in the prior art, the present invention proposes the side of a kind of batch registration and modification user information
Method is reconstructed cumbersome business judgement and process flow, the batch data submitted is arranged according to the business after reconstruct, simplifies
Business realizing process.
Batch registration according to the present invention and the method for modifying user information include:
The document is submitted to server by the user information typing document to be registered of batch by step 1, administrator；
Step 2, the server read the data in document, are reconstructed into the data set A by verification and not passed through
The data set B of verification；
Step 3 is reconstructed into non-registered users data set A1 and registered users data by the data set A of verification for described
Collect A2；
Registered users data set A2 is reconstructed into the user data set A21 for needing to modify and illegal user's data by step 4
Collect A22；
The user data set A21 merging that non-registered users data set A1 and needs are modified is inserted into database by step 5
In registration table.
Preferably, in step 1 administrator according to one user information of every row format typing document, and in step 2
Described in server read the data in document line by line.
Preferably, the user information in step 1 includes: user name, password, post, administrator.
Preferably, the document of institute's typing is txt document.
Preferably, in step 2, the data in document, length requirement, character set specification school based on setting are read by row
Test the information of each user.
Preferably, in step 3, note of the username field in database of all records of data set A of verification will be passed through
It is inquired in volume table, obtains inquiry data C, include in database corresponding to the user name that inquires in the inquiry data C
The affiliated administrator of storage, and the user information that will inquire user name is added in registered users data set A2,
Otherwise it adds it in non-registered users data set A1.
Preferably for java web site, by the username field all recorded in the data set A of verification with
The splicing of select*in sentence is inquired in the registration table in database, obtains inquiry data C.
Preferably, in step 4, each user in registered users data set A2 is judged based on the inquiry data C
It is whether consistent with current administrator based on the inquiry data C corresponding to name, if unanimously, modifying user information and adding
It into the user data set A21 for needing to modify while saving in the database, is judged as illegal user if inconsistent, will use
Family information is added in the user data set A22 for needing to modify.
Preferably, in steps of 5, judge that connection type of database makes if database is mysql type by jdbc
By non-registered users data set A1 and the user data set A21 modified merging is needed to be inserted into data with replace into sentence
In the registration table in library；If database is oracle type, merge into sentence is used.
Preferably, this method further include: step 6, return to registering result, the registering result includes the number for submitting user
Amount, the quantity of registration user, quantity, the quantity of abnormal user and the abnormal cause for modifying user.
Present invention batch registration user information by way of submitting document simplifies administrator's operation；By will be whole
Operation flow is divided into separate traffic branch, and the batch data submitted according to branch module reconstruct, reduces unnecessary number
According to process flow, make the simpler convenience of resume module；It submits method to save and modify data by jdbc batch, shortens
Sql executes the time, simplifies database abnormality processing situation；The simple and quick verification for realizing batch user information, registration,
The functions such as modification.
The present invention has other characteristics and advantages, these characteristics and advantages are from the attached drawing and subsequent tool being incorporated herein
It will be apparent, or will be carried out in body embodiment in the drawings and the subsequent detailed description incorporated herein
Statement in detail, the drawings and the detailed description together serve to explain specific principles of the invention.
Detailed description of the invention
Exemplary embodiment of the present is described in more detail in conjunction with the accompanying drawings, of the invention is above-mentioned and other
Purpose, feature and advantage will be apparent, wherein in exemplary embodiments of the present invention, identical appended drawing reference is usual
Represent same parts.
Fig. 1 shows the process of the method for the batch registration and modification user information of an exemplary embodiment of the present invention
Figure.
Specific embodiment
The method of batch registration according to the present invention and modification user information specifically includes that administrator will register or modify
Multiple user informations system is submitted in the form of document, system obtains the record to be registered one by one.Verification is registered first
Whether record meets format specification, after verification, then goes to judge whether to bear the same name with the existing user of system, not bearing the same name then will note
Record is added in library, and user initializes successfully；If duplication of name illustrates that user has been registered, judge that the administrator of registered users is not
It is current administrator: if so, according to the record modification user information is submitted；It is not to prompt user name illegal.
In terms of administrator, once-through operation can register multiple users, reduce repetitive operation, when shortening work
Between；User information registration and modification are placed in a module and handle, and reduce operation complexity.From system perspective, batch is received
Information reduces front and back interaction times, and batch, which saves, reduces the database Connection Time, saves resource.
The present invention will be described in more detail below with reference to accompanying drawings.Although showing the preferred embodiment of the present invention in attached drawing,
However, it is to be appreciated that may be realized in various forms the present invention and should not be limited by the embodiments set forth herein.On the contrary, providing
These embodiments are of the invention more thorough and complete in order to make, and can will fully convey the scope of the invention to ability
The technical staff in domain.
Fig. 1 shows the process of the method for the batch registration and modification user information of an exemplary embodiment of the present invention
Figure comprising step S1~S5.
In step sl, administrator is by the user information typing document to be registered of batch, and the document is submitted to clothes
Business device.
It is recorded for example, will be able to include user name, password, post and the user information to be registered of administrator as one,
In a document by a plurality of record storage, and by the document it uploads onto the server.The document can be txt document, be also possible to it
The document that he is suitably formed.
Administrator according to the format typing document of one user information of every row, can also preferably be made by other separators
For the separation of different user information.
In step s 2, server reads the data in document, is reconstructed into the data set A by verification and not passed through
The data set B of verification.
When user information is by row typing, then server reads the data in document line by line.
Server background reads the file information, obtains autotomying for every record, and according to the setting of system, such as setting
Length requirement, character set specification, complexity etc. are verified.It is added to by the user information to be registered of verification and passes through inspection
Data set A in, and by by verifying data be saved in the registration table of database one by one；Default will not met
User information platform is added in unverified data set B.It realizes the data reconstruction in the read document of server
To pass through the data set A of verification and unverified data set B.
In step s3, non-registered users data set A1 and registered users number will be reconstructed by the data set A verified
According to collection A2.
Next, carrying out the uniqueness verification of data.Specifically, the user of all records of data set A of verification will be passed through
File-name field is inquired in the registration table of database, is obtained inquiry data C, is included the user inquired in the inquiry data C
The affiliated administrator stored in database corresponding to name.
For java web site, pass through the username field all recorded and select* in the data set A by verification
The splicing of in sentence is inquired in the registration table of database, obtains inquiry data C.Registration tableau format such as following table in database
It is shown:
Table 1
| Title | Type | It whether can be sky | Default value | Annotation |
| Username | Varchar(24) | N | User name (major key) | |
| password | Varchar(24) | N | Password | |
| job | Varchar(64) | N | Post | |
| admin | Varchar(24) | N | Administrator |
It can be inquired in the database according to user name, illustrate that user is registered, which is added to registered
In user data set A2, if do not inquired, add it in non-registered users data set A1.Realizing will pass through
The data set A of verification is reconstructed into non-registered users data set A1 and registered users data set A2.
In step s 4, registered users data set A2 is reconstructed into the user data set A21 for needing to modify and illegal use
User data collection A22.
Judged corresponding to each user name in registered users data set A2 based on the inquiry data C based on described
Whether consistent with current administrator data C is inquired, if unanimously, modifying user information and being added to the number of users for needing to modify
According to being saved in the database simultaneously in collection A21, it is judged as illegal user if inconsistent, cannot registers, and by user information
It is added in the user data set A22 for needing to modify.Registered users data set A2 is reconstructed into the number of users for needing to modify
According to collection A21 and illegal user's data set A22.
In step s 5, the user data set A21 merging that non-registered users data set A1 and needs are modified is inserted into number
According in the registration table in library.
Firstly, judging connection type of database by jdbc.If it is judged that database is mysql type, then use
Replace into sentence；If it is judged that database is oracle type, then merge into sentence is used.In Sql sentence
In, according to critical field (major key) with the presence or absence of judging that insertion is done in current record or update operates, the user to be registered believes
The user information that breath and needs are modified is submitted together to be saved in registration table.
This method also step S6 returns to registering result.The registering result includes the quantity for submitting user, registration user
Quantity, quantity, the quantity of abnormal user and the abnormal cause for modifying user.
It submits the quantity of user to be counted according to the record sum read in step S2, registers the quantity of user according to step
Record sum in rapid S3 in non-registered users data set A1 is counted, and the quantity for modifying user needs to repair according in step S4
The record sum in user data set A21 changed is counted, and the quantity of abnormal user is according to unverified in step S2
The record sum in illegal user's data set A22 in data set B and step S4 counts.
One cumbersome business judgement and process flow are specifically included data check uniqueness and administrator test by the present invention
Card is registered according to different check result, and modification and abnormality processing are reconstructed into relatively independent several business branches.According to weight
Process after structure arranges all data received, simplifies the process flow of every data.It, can in business branch after reconstitution
Abnormal conditions to submit data according to the processing of the scene batch in current block, without considering whole business.
According to traditional batch process, need that each data is verified and submitted, when submitting n data,
Need to be implemented database manipulation 2n times (inquiry n times submit n times).The present invention spells all record major keys and select*in sentence
Connect and inquire, it is only necessary to do a data base querying, verifying and compare by background process, should in database execution when
Between be transferred in faster background process；Method is submitted using jdbc batch, shortens sql execution, whole process only needs to hold
2 sql sentences of row.Abnormal mechanism is submitted by the batch of jdbc, is eliminated in background logic to database exception rollback
Operation.
A business is merged into present invention registration and modification, simplifies user's operation.When database is submitted, mergin is used
Into (replace into being used in mysql, use merge into oracle) reduces newly-increased modification merging treatment
Sql executes number.
Various embodiments of the present invention are described above, above description is exemplary, and non-exclusive, and
It is not limited to disclosed each embodiment.Without departing from the scope and spirit of illustrated each embodiment, for this skill
Many modifications and changes are obvious for the those of ordinary skill in art field.
Claims (10)
1. a kind of method of batch registration and modification user information characterized by comprising
The document is submitted to server by the user information typing document to be registered of batch by step 1, administrator；
Step 2, the server read the data in document, are reconstructed into through the data set A of verification and unverified
Data set B；
Step 3 is reconstructed into non-registered users data set A1 and registered users data set by the data set A of verification for described
A2；
Registered users data set A2 is reconstructed into the user data set A21 and illegal user's data set for needing to modify by step 4
A22；
The user data set A21 that non-registered users data set A1 and needs are modified is merged the registration for being inserted into database by step 5
In table.
2. the method for batch registration according to claim 1 and modification user information, which is characterized in that manage in step 1
Reason person is according to the format typing document of one user information of every row, and the server is read in document line by line in step 2
Data.
3. the method for batch registration according to claim 1 and modification user information, which is characterized in that the use in step 1
Family information includes: user name, password, post, administrator.
4. the method for batch registration according to claim 1 and modification user information, which is characterized in that the document of institute's typing
For txt document.
5. the method for batch registration according to claim 1 and modification user information, which is characterized in that in step 2, press
Row reads the data in document, the information of length requirement, each user of character set specification validation based on setting.
6. the method for batch registration according to claim 1 and modification user information, which is characterized in that in step 3, will
It is inquired in the registration table of database by the username field of all records of data set A of verification, obtains inquiry data C,
It include the affiliated administrator stored in database corresponding to the user name that inquires in the inquiry data C, and will
The user information for inquiring user name is added in registered users data set A2, otherwise adds it to non-registered users data
Collect in A1.
7. the method for batch registration according to claim 6 and modification user information, which is characterized in that for java web
Website is spliced with select*in sentence in database by the username field all recorded in the data set A by verification
It is inquired in registration table, obtains inquiry data C.
8. the method for batch registration according to claim 6 and modification user information, which is characterized in that in step 4, base
Judge corresponding to each user name in registered users data set A2 in the inquiry data C based on the inquiry data C
It is whether consistent with current administrator, if unanimously, modifying user information and being added in the user data set A21 for needing to modify
It saves in the database simultaneously, is judged as illegal user if inconsistent, user information is added to the user for needing to modify
In data set A22.
9. the method for batch registration according to claim 1 and modification user information, which is characterized in that in steps of 5, lead to
Jdbc judgement connection type of database is crossed, if database is mysql type, using replace into sentence by unregistered use
The user data set A21 merging that user data collection A1 and needs are modified is inserted into the registration table of database；If database is
Oracle type then uses merge into sentence.
10. the method for batch registration according to any one of claims 1-9 and modification user information, feature exist
In, further includes:
Step 6, registering result is returned to, the registering result includes the quantity for submitting user, the quantity for registering user, modification user
Quantity, the quantity of abnormal user and abnormal cause.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810896908.3A CN109344151A (en) | 2018-08-08 | 2018-08-08 | The method of batch registration and modification user information |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810896908.3A CN109344151A (en) | 2018-08-08 | 2018-08-08 | The method of batch registration and modification user information |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109344151A true CN109344151A (en) | 2019-02-15 |
Family
ID=65291294
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810896908.3A Pending CN109344151A (en) | 2018-08-08 | 2018-08-08 | The method of batch registration and modification user information |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109344151A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110362722A (en) * | 2019-06-04 | 2019-10-22 | 苏州神州数码捷通科技有限公司 | A kind of handbook data method of calibration based on big data |
| CN110851803A (en) * | 2019-11-08 | 2020-02-28 | 北京明略软件系统有限公司 | System and method for registering user information in batch |
| CN112965967A (en) * | 2021-02-10 | 2021-06-15 | 中国工商银行股份有限公司 | Data uniqueness checking method and device during batch modification |
| CN114666887A (en) * | 2020-12-23 | 2022-06-24 | 海能达通信股份有限公司 | Terminal registration method, communication device, and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102750608A (en) * | 2012-05-22 | 2012-10-24 | 山西优府信息技术开发有限公司 | Batch registering system |
| CN104536997A (en) * | 2014-12-12 | 2015-04-22 | 北京国双科技有限公司 | Method and device for data batch processing of client interface |
| CN107679081A (en) * | 2017-08-30 | 2018-02-09 | 平安科技（深圳）有限公司 | Information amending method, device, computer equipment and computer-readable recording medium |
| CN107704539A (en) * | 2017-09-22 | 2018-02-16 | 清华大学 | The method and device of extensive text message batch structuring |
-
2018
- 2018-08-08 CN CN201810896908.3A patent/CN109344151A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102750608A (en) * | 2012-05-22 | 2012-10-24 | 山西优府信息技术开发有限公司 | Batch registering system |
| CN104536997A (en) * | 2014-12-12 | 2015-04-22 | 北京国双科技有限公司 | Method and device for data batch processing of client interface |
| CN107679081A (en) * | 2017-08-30 | 2018-02-09 | 平安科技（深圳）有限公司 | Information amending method, device, computer equipment and computer-readable recording medium |
| CN107704539A (en) * | 2017-09-22 | 2018-02-16 | 清华大学 | The method and device of extensive text message batch structuring |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110362722A (en) * | 2019-06-04 | 2019-10-22 | 苏州神州数码捷通科技有限公司 | A kind of handbook data method of calibration based on big data |
| CN110851803A (en) * | 2019-11-08 | 2020-02-28 | 北京明略软件系统有限公司 | System and method for registering user information in batch |
| CN110851803B (en) * | 2019-11-08 | 2022-03-29 | 北京明略软件系统有限公司 | System and method for registering user information in batch |
| CN114666887A (en) * | 2020-12-23 | 2022-06-24 | 海能达通信股份有限公司 | Terminal registration method, communication device, and storage medium |
| CN112965967A (en) * | 2021-02-10 | 2021-06-15 | 中国工商银行股份有限公司 | Data uniqueness checking method and device during batch modification |
| CN112965967B (en) * | 2021-02-10 | 2024-01-26 | 中国工商银行股份有限公司 | Data uniqueness checking method and device during batch modification |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109344151A (en) | The method of batch registration and modification user information | |
| US7953744B2 (en) | Database change verifier | |
| US7496954B1 (en) | Single sign-on system and method | |
| US7660988B2 (en) | Electronic notary | |
| CN103618717B (en) | The dynamic confirming method of more account client informations, device and system | |
| US6564323B2 (en) | Personal information controlling method and personal information controlling apparatus | |
| US6564247B1 (en) | System and method for registering user identifiers | |
| US6185583B1 (en) | Parallel rule-based processing of forms | |
| CN109460841B (en) | User account opening method, system and storage medium | |
| CN105760976B (en) | Service checking method and system | |
| CN106844730B (en) | Method and device for displaying file content | |
| CN105760192B (en) | Registration method and device for service module of system server | |
| CN103890734B (en) | Remote measurement file hash and collision detection | |
| US9756034B2 (en) | Law enforcement agency portal | |
| RU2002105489A (en) | System and method for integrating printed business documents with computer readable data entered over a computer network | |
| US7895332B2 (en) | Identity migration system apparatus and method | |
| US11563585B1 (en) | Systems and methods for smart contracts including arbitration attributes | |
| CN108492087A (en) | Architectural design bidding platform registers auditing system | |
| CN111143399A (en) | Data processing method, data processing device, storage medium and computer equipment | |
| US7024412B1 (en) | Systems and methods for database configuration migration | |
| US20100229231A1 (en) | License management system, license management method and license management program | |
| EP1162562A1 (en) | Membership management method and membership management system | |
| CN113343216B (en) | Issuer management method, issuer management device, storage medium and server | |
| KR101178998B1 (en) | Method and System for Certificating Data | |
| JP4080687B2 (en) | Server apparatus for electronic procedure system |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190215 |
|
| RJ01 | Rejection of invention patent application after publication |