CN106126633B - Processing method, the device and system of noble metal data - Google Patents

Processing method, the device and system of noble metal data Download PDF

Info

Publication number
CN106126633B
CN106126633B CN201610461141.2A CN201610461141A CN106126633B CN 106126633 B CN106126633 B CN 106126633B CN 201610461141 A CN201610461141 A CN 201610461141A CN 106126633 B CN106126633 B CN 106126633B
Authority
CN
China
Prior art keywords
noble metal
metal block
block number
section
record
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN201610461141.2A
Other languages
Chinese (zh)
Other versions
CN106126633A (en
Inventor
江鸿
林明
吴迪
何幼雄
乔迟
王凯
丁小进
陈颖
唐智龙
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
China Construction Bank Corp
Original Assignee
China Construction Bank Corp
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by China Construction Bank Corp filed Critical China Construction Bank Corp
Priority to CN201610461141.2A priority Critical patent/CN106126633B/en
Publication of CN106126633A publication Critical patent/CN106126633A/en
Application granted granted Critical
Publication of CN106126633B publication Critical patent/CN106126633B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
    • G06F16/33—Querying
    • G06F16/3331—Query processing
    • G06F16/334—Query execution

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Computational Linguistics (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The present invention provides processing method, the device and system of a kind of noble metal data, the form that noble metal block number is recorded using single block number as one in the database is stored, this method comprises: receiving the demand information of service terminal；At least using noble metal block number as sort field, a plurality of noble metal record is ranked up；Increase corresponding arrangement serial number in every record after sequence；Corresponding arrangement serial number is subtracted using the number section serial number of the noble metal block number after sequence, and it is poor to obtain serial number；By in multiple attribute-bits of noble metal, at least number section head, block number length and the identical noble metal block number of serial number difference merge into continuous number section, to be shown in service terminal in the form that continuous number section is shown.The present invention is by changing noble metal block number in the storage form of background data base, so that on the basis of becoming simple direct to the modification process of noble metal balance account book, while also assuring that front end display mode does not change.

Description

Processing method, the device and system of noble metal data
Technical field
The present invention relates to financial services technology field more particularly to a kind of processing method of noble metal data, device and it is System.
Background technique
In banking system of today, noble metal is that a kind of common keeping is in kind.In the database of bank, noble metal is It is recorded in the form of noble metal block number.Under normal conditions, noble metal block number is made of number section head and number section serial number, number section Head is made of arbitrary string, does not include number in number section head generally, and the cardinar number character segment after number section head is number section serial number.
In the service process of banking system, need to show nugget at service cabinets end (hereinafter referred to as service terminal) Number, so that teller checks the noble metal inventories of mechanism.Since noble metal block number is excessive, in the database of the same mechanism There may be ten tens of thousands of supreme million noble metal block number record, for the ease of checking, when banking system front end is shown using every The display mode (referred to as continuous number section is shown) of row one continuous number section of display, as only shown a continuous number section in every row Originate block number and cut-off block number.In background data base, noble metal block number is stored in the noble metal remaining sum registration of background data base In book, also, storage form of the noble metal block number in register is also consistent with front end display format, i.e., continuous with one Number section is stored as a record.
In the routine work of bank, when national treasury allots noble metal material object, need to noble metal balance account book The operation for carrying out increase block number, deleting the modification records such as block number, specific work process are as follows:
1) noble metal recalls authorities to when alloting demand, first judging the noble metal number section to be recalled in mechanism Noble metal balance account book in whether there is.If in the presence of needing to step on the noble metal remaining sum of mechanism according to the demand of alloting Record in note book (hereinafter referred to as book) is split, and will include the consecutive number for the number section of being recalled in mechanism book Duan Jinhang is split, and is respectively processed later.It exchanges out number section to be deleted, remaining discontinuous number section be split into a plurality of Record.
2) receiving mechanism needs to judge that can the number section that called in the gold of your in mechanism after receiving alloted number section The number section belonged in balance account book merges into continuous number section, if can be will call in number section and merge with existing number section, if cannot Merge, then increases a record newly.
Inventors have found that the process logic modified in the prior art to noble metal balance account book is extremely complex, lead It causes the operating process of rear end background server very cumbersome, influences the treatment effeciency of background server.
Summary of the invention
For the deficiency of existing method, the invention proposes processing method, the device and system of a kind of noble metal data, should Method is stored in the form of recording noble metal block number using single block number as one in the database, so as to your gold Belong to balance account book modification process become simple direct on the basis of, while also assuring that front end display mode does not change Become.
To achieve the above objectives, technical scheme is as follows:
The invention discloses a kind of processing methods of noble metal data, and noble metal block number is in the database with single block number work The form recorded for one is stored, this method comprises:
Receive the demand information of service terminal；
At least using noble metal block number as sort field, a plurality of noble metal record stored in the database is arranged Sequence, in multiple attribute-bits of noble metal, will at least there is the noble metal block number of same No. paragraph header and identical block number length It is successively arranged according to the size of number section serial number；
Increase corresponding arrangement serial number, the arranged mode and number section sequence of the arrangement serial number in every record after sequence The sortord of number size is consistent；Corresponding arrangement serial number is subtracted using the number section serial number of the noble metal block number after sequence, It is poor to obtain serial number；
By in multiple attribute-bits of noble metal, at least number section head, block number length and the identical nugget of serial number difference Number merge into continuous number section, with the form that shows the noble metal information stored in database with continuous number section in service terminal into Row display.
Preferably, described at least using noble metal block number as sort field, to your a plurality of gold stored in the database Before or after category record is ranked up, further includes:
The noble metal block number is split, the number section head and number section serial number of each noble metal block number are obtained；
It is described with expensive when being split to the noble metal block number before being ranked up to noble metal record Metal block number is sort field, is ranked up to a plurality of noble metal record stored in the database specifically: at least to tear open Number section head, number section serial number and the number section serial number length of noble metal block number after point are sort field, to storing in the database A plurality of noble metal record be ranked up, in multiple attribute-bits of noble metal, will at least there is same No. paragraph header and phase Noble metal block number with number section serial number length is successively arranged according to the size of number section serial number.
Preferably, the noble metal block number is split, obtains number section head point and the number section of each noble metal block number The concrete mode of serial number part are as follows: use regular expression, inquire number section head point and the number section sequence of the noble metal block number Number part, and the number section head point and number section serial number part are split, obtain the number section head of each noble metal block number Divide and number section serial number part.
Preferably, corresponding arrangement serial number is subtracted using the number section serial number of the noble metal block number after sequence, obtains sequence Before number difference, further includes: the number section serial number length of record noble metal block number, the number section is identical and number section serial number length is identical When, the block number length is identical.
Preferably, the sort field being ranked up to noble metal block number further includes noble metal mechanism number, keeping teller number, produces At least one of product code, matter damage mark, property rights mark, locking mark and Storage Cabinets box number.
Preferably, by multiple attribute-bits of noble metal, at least number section head, block number length and serial number difference are identical expensive Metal block number merges into continuous number section, by service terminal by the noble metal information stored in database in the form of continuous number section The concrete mode shown are as follows: structured query language is used, inquiry is grouped to noble metal record, it will be expensive In multiple attribute-bits of metal, at least number section head, number section serial number length and the identical noble metal block number of serial number difference merge into one Group, every group as a continuous number section, in service terminal by the noble metal information stored in database with the shape of continuous number section Formula is shown.
Preferably, this method further include: receiving when recalling instruction of noble metal block number, recalled in deletion database Noble metal block number record；When calling in instruction of noble metal block number is being received, is increasing the noble metal block number called in the database Record.
It preferably, is to be recorded in the form of a list to the recording mode of the noble metal block number in database, one Record occupies same a line or same row of list；Service terminal is to the exhibition method of the continuous number section of noble metal block number, with column The form of table is shown, and the record of a continuous number section occupies same a line or same row of list.
Preferably, before being ranked up to noble metal record, when being split to the noble metal block number, After the demand information for receiving service terminal, further includes:
Inquiry is last to record the action type modified to noble metal block number in database；
When the last time having carried out the operation of deletion block number record to noble metal block number record in database, then skip to institute The step of noble metal block number is split is stated, a plurality of noble metal stored in the database record is ranked up into described The step of；
When the last time having carried out the operation of increase block number record to noble metal block number record in database, then enter to institute State the step of noble metal block number is split.
Preferably, this method further include:
Receive the need for showing multiple noble metal block numbers that some or certain continuous number sections include of some service terminal transmission Seek information；
The information for multiple noble metal block numbers that the continuous number section includes is sent to the service terminal, in the industry Multiple noble metal block numbers that continuous number section includes described in business terminal display.
Preferably, this method further include:
Receive the demand information of the single or multiple noble metal block numbers of locking of some service terminal transmission；
The single or multiple noble metal block numbers are locked, to avoid in other service terminals in addition to the service terminal On repetitive operations are carried out to the single or multiple noble metal block numbers.
The embodiment of the invention also discloses a kind of noble metal data processing equipments, and noble metal block number is in the database with single The form that block number is recorded as one is stored, which includes:
Receiving unit, for receiving the demand information of service terminal；
Sequencing unit is used at least using noble metal block number as sort field, to your a plurality of gold stored in the database Belong to record to be ranked up, in multiple attribute-bits of noble metal, will at least there is same No. paragraph header and identical block number length Noble metal block number successively arranged according to the size of number section serial number；
Serial number adding unit, for increasing corresponding arrangement serial number, the arrangement serial number in every record after sequence Arranged mode it is consistent with the sortord of number section serial number size；
Computing unit, for subtracting corresponding arrangement serial number using the number section serial number of the noble metal block number after sequence, It is poor to obtain serial number；
Combining unit, for by multiple attribute-bits of noble metal, at least number section head, block number length and serial number difference phase Same noble metal block number merges into continuous number section；
Transmission unit, for the noble metal information after merging cell processing to be sent to display device, by database The noble metal information of middle storage is shown in service terminal in the form that continuous number section is shown.
Preferably, device further include: split cells obtains each expensive for splitting to the noble metal block number The number section head of metal block number point and number section serial number part.
Preferably, the device further include: record modification unit, for your gold to be increased in noble metal data handling procedure Belong to the number section serial number length of block number and the record content of serial number difference, and when receiving noble metal block number and recalling instruction, deletion number According to the noble metal block number record recalled in library；When receiving noble metal block number and calling in instruction, in the database increases and to call in Noble metal block number record.
Preferably, device further include: query unit is carried out for inquiring noble metal block number record in last database The action type of modification.
Preferably, the device further include: information locking unit, for receiving some service terminal in the receiving unit When the demand information of the single or multiple noble metal block numbers of locking of transmission, the single or multiple noble metal block numbers are locked.
The embodiment of the invention also discloses a kind of noble metal data processing system, including database, background server and extremely A few service terminal；
Wherein, the database is for storing noble metal block number, the storage form of the noble metal block number in the database It is recorded for single block number as one；
It is right at least using noble metal block number as sort field after the background server is used to receive the demand of service terminal The a plurality of noble metal record stored in the database is ranked up, will at least have in multiple attribute-bits of noble metal There is the noble metal block number of same No. paragraph header and identical block number length successively to be arranged according to the size of number section serial number, and is sorting Increase corresponding arrangement serial number in afterwards every record, and subtracted using the number section serial number of the noble metal block number after sequence it is right with it The arrangement serial number answered, obtains that serial number is poor, by multiple attribute-bits of noble metal, at least number section head, block number length and serial number The identical noble metal block number of difference merges into continuous number section, and the noble metal information after block number merging treatment is sent to display dress It sets, wherein the arranged mode of the arrangement serial number is consistent with the sortord of number section serial number size；
The service terminal is for showing the noble metal information stored in database in the form that continuous number section is shown Show.
Preferably, the background server is also used to split the noble metal block number, obtains each nugget Number number section head and number section serial number.
Preferably, the background server is also used in noble metal data handling procedure, increases number of noble metal block number The record content of section serial number length and serial number difference, and when receiving noble metal block number and recalling instruction, directly delete in database The noble metal block number record recalled；When receiving noble metal block number and calling in instruction, directly increase in the database call in it is expensive Metal block number record.
Preferably, the service terminal is also used to that index entry, the index entry is arranged when showing the noble metal information Index field include mandatory field and Optional Field, the mandatory field includes that number section head, number section serial number and number section serial number are long Degree, the Optional Field include the noble metal mechanism number, keeping teller number, product code, matter damage mark, property rights mark, lock Calibration knowledge, Storage Cabinets box number.
Preferably, the service terminal is also used to when showing the noble metal information, is carried out to the noble metal information Sequencing display and/or Pagination Display.
Preferably, the service terminal is also used to while showing continuous number section, and Xiang Suoshu background server sends exhibition Show some or the demand information of multiple noble metal block numbers that certain continuous number sections include, and shows that the continuous number section includes more A noble metal block number；The background server is also used to receive the displaying of some service terminal transmission some or certain continuous number sections The demand information for the multiple noble metal block numbers for including, and the information for the multiple noble metal block numbers for including by the continuous number section is sent To the service terminal.
Preferably, the service terminal, which is also used to send to the background server, locks single or multiple noble metal block numbers Demand information, to avoid on other service terminals in addition to the service terminal to the single or multiple nuggets Number carry out repetitive operation；The background server is also used to receive the single or multiple noble metals of locking of some service terminal transmission The demand information of block number, and lock the single or multiple noble metal block numbers.
The beneficial effects of the present invention are:
The processing method and system of noble metal data disclosed by the invention, by changing noble metal block number in background data base Storage form, i.e., record the form that stores for continuous number section as one, be revised as remembering using single block number as one Record is stored, so that alloting in business in noble metal need to will only adjust for recalling mechanism in such a way that inquiry compares Block number is compared with the block number that mechanism stores out, judges the block number that need to be recalled and number section whether are stored in mechanism i.e. Can, without such as carrying out complicated calculating in the prior art.For calling in mechanism, there are no must carry out any judging Journey, but directly increase the block number record called in the database.In other words, that is, it needs to noble metal balance account book In noble metal block number when being deleted and being increased, directly carry out deleting and increased operation, without doing difference again Whether block number is located at a series of pre actions such as the judgement of same continuous number section, so that the modification process of background data base Become simple direct, improves the treatment effeciency of background server.
Also, method disclosed by the invention is used, by being ranked up to the noble metal block number in register, calculates number section Serial number and sort serial number serial number it is poor, so as to according to serial number difference it is whether identical, to determine whether be continuous number section, in turn Continuous number section record and be shown in service terminal.It is real by operating process such as these simple sequences and groupings Show noble metal block number with single block number record in register, and can show continuous number section when front end is shown, it is both simple The operation for having changed backstage also ensures the convenience that front end is shown.
Detailed description of the invention
In order to more clearly explain the embodiment of the invention or the technical proposal in the existing technology, to embodiment or will show below There is attached drawing needed in technical description to be briefly described, it should be apparent that, the accompanying drawings in the following description is only this Some embodiments of invention for those of ordinary skill in the art without creative efforts, can be with It obtains other drawings based on these drawings.
Fig. 1 is the flow chart of the processing method of noble metal data disclosed in the embodiment of the present invention one；
Fig. 2 is the flow chart of the processing method of noble metal data disclosed in the embodiment of the present invention two；
Fig. 3 is the flow chart of the processing method of noble metal data disclosed in the embodiment of the present invention three；
Fig. 4 is the structure chart of the processing unit of noble metal data disclosed by the embodiments of the present invention.
Specific embodiment
The present invention is described in further detail in the following with reference to the drawings and specific embodiments.
Inventors have found that being carried out every time to noble metal balance account book during the alloting of noble metal in the prior art Before modification, require to carry out a deterministic process, i.e. judgement recalls number section and calls in the number section in number section and mechanism register It is made whether to be located at same continuous number section, that is, judges between different number sections with the presence or absence of inclusion relation and multiple continuous Can number section form a continuous number section.
This judgement is carried out, first has to judge different noble metal block numbers whether in same number section.Judgment method is, A block number is obtained, from back to front, taking first is not the character of number, until the character to the first character of block number, is cut Number section head is taken out, subsequent pure digi-tal is number section serial number.It is respectively compared the length and number section head of two block numbers, when two block numbers Length and completely the same number section when, just belong to same number section.
Judge whether number section includes or whether can make up continuous number section again later.The process is, firstly, it is necessary to judge With in the consecutive number segment record of kind noble metal in the noble metal remaining sum book of mechanism, if having and be less than or equal to required number The starting block number of section starting block number, more than or equal to required number section cut-off block number by block number.Continuous number section split process, needs Block number after calculating several pieces of block number of starting is how many, finds block number identical with required number section cut-off block number.Continuous number section Merging process needs to judge between different continuous number sections that the starting block number and another continuous number section of a continuous number section are cut Whether next block number to block number is identical.
It from the above analysis, can be evident that, when progress noble metal material object is alloted, recall mechanism and call in machine Noble metal record modification process in the database of structure need to carry out complicated operation, bring very big pressure to backstage background server Power influences the working efficiency of background server.Occur this problem be mainly by noble metal block number database storage form It is caused.Background data base is consistent to the storage mode of noble metal block number and the display mode of service terminal, although being convenient for business The reading data of terminal, but it is excessively complicated to the pre action before the noble metal record modification in database, modify mode Also not easy.But the convenience that service terminal is shown has to meet, therefore stores shape to adjustment noble metal block number Formula, while also must assure that front end display mode is constant.
Embodiment one
Based on the above reasons, the embodiment of the present invention one proposes a kind of processing method of noble metal data, solves and is changing In variable database while the storage form of noble metal block number, guarantee that service terminal display mode is constant.
Firstly, the storage form of noble metal block number in the database is had adjusted, by existing skill in the present embodiment of the present invention It is stored in art in the form that the form that continuous number section is stored is revised as recording using single noble metal block number as one.
Due to having modified the storage form of noble metal block number in the database, so that when generation noble metal allots business, The operation that background server need to carry out greatly reduces.Specifically, middle progress is negative compared with the prior art for recalling mechanism The preposition deterministic process of duty, by the way of background server need to only be compared using inquiry in the present embodiment, the block number that will need to recall It is compared with the block number stored in mechanism database, judges whether be stored with the block number that need to be recalled and number section in mechanism i.e. Can, it is deleted if so, will directly the block number recalled be needed to be recorded in mechanism database, without such as existing skill Complicated calculating is carried out in art.For calling in mechanism, there are no palpuses to carry out any deterministic process, but directly in the database Increase the block number record called in.
That is, when needing that the noble metal block number in noble metal balance account book is deleted and increased, directly Delete and increased operation, the system such as judgement for whether being located at same continuous number section without doing different block numbers again The pre action of column improves the processing of background server so that the modification process of background data base becomes simple direct Efficiency.
In addition, in the prior art database to the recording mode of noble metal block number also exist simultaneously coupling it is too strong lack Point.Original noble metal material object is one piece of one piece of placement, and in database is continuous number section one record, so as to cause expensive Metal block number is in Input Process, if mistake occurs in a record, will lead to the note of the muti-piece noble metal of entire continuous number section Mistake can all occur in record, to be not easy to position the block number for mistake occur.And single block number in the embodiment of the present invention Storage mode the strong disadvantage of coupling would not also occur, if some block number since any connection being not present between each block number Record there is mistake, be more convenient for mistake positioning and modification.
On the basis of single block number is stored as a record, noble metal processing side disclosed by the embodiments of the present invention Method also ensure noble metal block number service terminal display mode with it is identical in the prior art, i.e., in service terminal with continuous blocks Number shown as a record, the flow chart of this method as shown in Figure 1, specifically includes the following steps:
Step S101, the demand information of service terminal is received, i.e. reception trigger action information.
It under normal circumstances, will be to background service when service terminal generation noble metal allots demand or noble metal is traded Device end sends the demand information of service terminal, to trigger the data handling procedure of the embodiment of the present invention.For example, noble metal is traded When, the business personnel of front end will issue noble metal data query information in service terminal, which is service terminal Demand information, can be used as trigger action information.In addition, the computer system of mechanism receives noble metal when alloting business, Also the instruction information that triggering noble metal allots business can be received, which also can be used as the touching of the triggering embodiment of the present invention Send out operation information.
Step S102, according to the demand of service terminal, at least using noble metal block number as sort field, in the database The a plurality of noble metal record of storage is ranked up, and by multiple attribute-bits of noble metal, at least has same No. paragraph header It is successively arranged with the noble metal block number of identical block number length according to the size of number section serial number.
The attendant of front end is to carry out normal noble metal transactional services etc., it is necessary to your gold seen in service terminal The various attribute-bits belonged to, to introduce the noble metal situation of mechanism inventory to client.To meet the needs of service terminal, With regard to needing to be identified according to the different attribute of noble metal, the noble metal block number in database is sorted out and sorted.
The attribute in kind of noble metal is more, and attribute-bit can also have much accordingly, and such as identifying noble metal, whether matter is damaged Matter damage mark, mark is can to sell or the specified property rights mark extracted of client, and identifying current noble metal systems locking cannot go out The locking mark sold, identifies the product code etc. of product type, there are also the marks for indicating noble metal storage condition in national treasury, such as Noble metal mechanism number, keeping teller number, Storage Cabinets box number etc., additionally include the signature identification of noble metal block number, as block number is long Degree, number section head, number section serial number etc..
When being ranked up in the present embodiment to noble metal block number, sequence appropriate can be selected according to the demand of front-end business The priority of field and sort field.Due to for noble metal block number, the number section head situation identical with block number length Under, it can be just identified as same number section, be located in same number section, number section serial number is continuously just identified as continuous number section.Therefore When theoretically, in order to ensure service terminal displaying, it is shown using a continuous number section as a record, as long as according to number section The similarities and differences of head and block number length are ranked up, as only by number section head and the identical block number of block number length according to number section serial number Size order is successively arranged.
But the demand of service terminal in actual operation, often it is not able to satisfy only in accordance with the sequence of number section head.Under normal circumstances, It may be selected noble metal mechanism number, product code, matter damage mark, property rights mark, locking mark, block number length and number section is identical Noble metal block number, be ranked up according to the size of number section serial number, can also only select noble metal mechanism number, product code, guarantor Pipe teller number, block number length and the first-class several fields of number section, are ranked up according to the size of number section serial number later.Anyway select Sort field is selected, must include number section head, block number length and number section serial number in sort field, i.e., with complete noble metal block number work For sort field.
Step S103, it after completing sequence, needs to increase corresponding arrangement serial number in every after sequence record, arrange The arranged mode of serial number is consistent with the sortord of number section serial number size.
Specifically, arranging serial number if noble metal block number is successively arranged according to the ascending sequence of number section serial number Also ascending successively layout, i.e., the serial number 1 of primary block number in the noble metal balance account book of database, later The serial number of block number is incremented by successively in order.Conversely, if noble metal block number is successively carried out according to the descending sequence of number section serial number Arrangement then arranges serial number also descending successively layout, i.e., last block in the noble metal balance account book of database Number serial number 1, the serial number of block number is incremented by successively in order before.Preferred noble metal block number is according to number section serial number in the present embodiment Ascending sequence is arranged successively.
Step S104, corresponding arrangement serial number is subtracted using the number section serial number of the noble metal block number after sequence, is obtained Serial number is poor.
Sortord in previous step, so that the noble metal block number for being located at same continuous number section obtains after the step The serial number difference arrived is identical.It is whether identical by serial number difference i.e. after the calculating of this step, that is, it can determine whether that multiple noble metal block numbers are It is no to be located at same continuous number section.
Step S105, by multiple attribute-bits of noble metal, at least number section head, block number length and serial number difference are identical Noble metal block number merges into continuous number section, to show the noble metal information stored in database with continuous number section in service terminal Form shown.In this step to the display format of continuous number section can with it is identical in the prior art, to ensure that business The simplicity that terminal is shown.
Using method disclosed by the embodiments of the present invention, pass through the nugget in the noble metal balance account book to database It number is ranked up, the serial number for calculating number section serial number and the serial number that sorts is poor, so as to according to poor whether identical of serial number, to judge Whether it is continuous number section, and then continuous number section record and be shown in service terminal.Pass through these simple sequences And the operating process such as grouping, noble metal block number is realized with single block number record in register, and can when front end is shown To show continuous number section, the operation on backstage is not only simplified, also ensures the convenience that front end is shown.
Embodiment two
The processing method of noble metal data disclosed by the embodiments of the present invention, on the basis of a upper embodiment, to the data Processing method has carried out further improvement and refinement, specifically, the method flow diagram of the present embodiment is as shown in Fig. 2, this reality The step that content is identical as a upper embodiment in example is applied, the description of an embodiment is can refer to, is repeated no more in the present embodiment.This Method in embodiment the following steps are included:
Step S201, the demand information of service terminal is received, i.e. reception trigger action information.
Step S202, the noble metal block number is split, obtain each noble metal block number number section head point and number Section serial number part.
Specifically, regular expression can be used, the number section head point and number section serial number portion of the noble metal block number are inquired Point, and the number section head point and number section serial number part are split, obtain each noble metal block number number section head point and Number section serial number part.The number section head point and number section serial number part are individually recorded respectively later, the record side of the two Formula is consistent with the attribute-bit recording mode of noble metal.
It wherein, is to be recorded in the form of a list to the recording mode of the noble metal block number in database, a note Record occupies same a line or same row of list.When occupying same a line of list such as a record, different lines in the same row are then Different attribute for recording the noble metal identifies, likewise, if record when occupying the same row of list, in same row Do not go together, for record the noble metal different attribute mark.For the former, your gold of the noble metal block number in database The record form belonged in balance account book is as shown in table 1.For the ease of showing, only with noble metal attribute mark in the present embodiment table 1 Illustrate for several in knowledge, does not show whole attribute-bits.
The recording mode of 1 noble metal block number of table in the database
In table 1, in being not carried out the present embodiment before each step, the record arrangement mode of noble metal block number in the database Unordered and random, only as example in the present embodiment, following steps are also illustrated by taking the data shape in table 1 as an example.Table 1 In each attribute-bit be only illustrated as an example, do not indicate any actual noble metal information.
After executing step S202, using regular expression, the number section head of noble metal block number and number section serial number are split Later, the recording mode of noble metal is as shown in table 2.
Table 2 is to the recording mode after the fractionation of noble metal block number
Do not increase the step of noble metal block number is split in embodiment one, noble metal block number is being ranked up, is calculating serial number In the process of difference, background server is needed through first identifier paragraph header and number section serial number part, then carries out relevant operation, this implementation After the process for increasing step S202 in example, it is only necessary to regular expression is used, number section head and number section serial number part can be distinguished, The identification for carrying out block number one by one is no longer needed to, the treatment process of background server is further simplified.
Step S203, the number section serial number length of noble metal block number is recorded, the number section is identical and number section serial number length phase Meanwhile the block number length is identical.
In addition, after due to splitting number section head and number section serial number, number section serial number pure digi-tal, it is possible to number section serial number occur Former bands 0 if often cardinar number character segment prefix band 0, recorded after zero-suppressing automatically and in the setting of database, Such as ABC00120456, practical number section serial number part is 00120456, and 120456 can be then automatically record as in database, is caused There is mistake in the record of number section serial number, therefore, in the present embodiment increases the record to number section serial number length, as shown in table 3.
Table 3 increases noble metal block number the recording mode of number section serial number length
Step S204, according to the demand of service terminal, at least using noble metal block number as sort field, in the database The a plurality of noble metal record of storage is ranked up, and by multiple attribute-bits of noble metal, at least has same No. paragraph header It is successively arranged with the noble metal block number of identical block number length according to the size of number section serial number.
In the present embodiment, since number section head and number section serial number being split, in the identical situation of number section, Number section serial number length is identical, and block number length must be the same.Therefore, in the present embodiment the step specific executive mode are as follows: at least Using number section head, number section serial number and the number section serial number length of the noble metal block number after splitting as sort field, in the database The a plurality of noble metal record of storage is ranked up, will at least have same No. paragraph header in multiple attribute-bits of noble metal It is successively arranged with the noble metal block number of identical number section serial number length according to the size of number section serial number.
After executing this step, the recording mode of the noble metal block number in table 3 is as shown in table 4.
Table 4 is to the recording mode after the sequence of noble metal block number
It is only illustrated for the sortord in the above table in the present embodiment, in practical operation, product code, Storage Cabinets Member number, matter damage mark, the relationship of the first-class interfield of number section will appear various situations, not repeat them here in the present embodiment.
For sortord, only in the case where product code, matter damage identify identical situation, number section is identical, number section in table 3 It on the basis of serial number length etc. is identical, is arranged according to the ascending sequence of number section serial number, therefore every note after sequence Arrangement serial number in record also carries out layout with ascending sequence.In other embodiments, sortord can be according to business The demand of terminal is adjusted, and with the data instance of table 3, it is identical can not such as to consider that matter damage identifies whether, only considers number section head With the fields such as number section serial number length, then ranking results also can be different.
Theoretically, sort field may also include noble metal mechanism number, keeping teller number, product code, matter damage mark, property rights At least one of mark, locking mark and Storage Cabinets box number,.In actual mechanical process, number section head, number section are generally included at least Serial number and number section serial number length, in addition, also will increase noble metal mechanism number, keeping teller number, product generation according to business demand The fields such as code, matter damage mark.
Also, it in terms of the hierarchy of sort field (i.e. the priority of sort field), can also be carried out according to business demand Corresponding setting.For example, the priority of each sort field is followed successively by, the highest priority of noble metal mechanism number, product generation Code takes second place, third matter damage mark, is successively locked out mark, number section head, number section serial number length, number section serial number, this feelings later Under condition, it will be appreciated that be, in sequence, first again together by the identical arrangement of noble metal mechanism number, later in noble metal mechanism phase With record in, be arranged together product code is identical, it is in the identical record of product code, matter damage mark is identical Be arranged together, identified in identical record in matter damage, will locking mark is identical is arranged together, it is identical in locking mark In record, it is arranged together number section is identical, in the identical record of number section, by the identical arrangement of number section serial number length Together, it in the identical record of number section serial number length, is arranged successively according to the size of number section serial number.Certainly in other embodiments In, can also quantity to sort field and priority be adjusted correspondingly.
Step S205, it after completing sequence, needs to increase corresponding arrangement serial number in every after sequence record, arrange The arranged mode of serial number is consistent with the sortord of number section serial number size.
This step is identical as step executive mode corresponding in a upper embodiment, your gold after executing this step, in table 4 The recording mode for belonging to block number is as shown in table 5.
Table 5 increases arrangement serial number in the noble metal block number record after sequence
Step S206, corresponding arrangement serial number is subtracted using the number section serial number of the noble metal block number after sequence, is obtained Serial number is poor.
After calculating serial number difference, serial number difference can be recorded in the database, the data in table 5 calculate serial number The results are shown in Table 6 after difference.As can be seen from the table, in the continuous situation of number section serial number, serial number difference is identical.
Table 6 calculates the recording mode between noble metal block number and arrangement serial number after serial number difference
Step S207, by multiple attribute-bits of noble metal, at least number section head, block number length and serial number difference are identical Noble metal block number merges into continuous number section, to show the noble metal information stored in database with continuous number section in service terminal Form shown.As before described in step, in the identical situation of number section, number section serial number length is identical, can indicate Block number length is identical.It should be noted that the lookup for the ease of service terminal to the continuous number section of noble metal, in step S204 In, field required when searching is disposed as sort field as far as possible, to avoid needing to repeat to sort.
Service terminal is to be shown in the form of a list to the exhibition method of the continuous number section of noble metal block number, one The record of continuous number section occupies same a line or same row of list.It is preferably illustrated using the former in the present embodiment, such as 7 institute of table Show.
Specifically, structured query language can be used in this step, i.e. SQL (full name Structured Query Language) language is grouped inquiry to noble metal record, by multiple attribute-bits of noble metal, at least number Paragraph header, number section serial number length and the identical noble metal block number of serial number difference merge into one group, every group as a continuous number section, with Service terminal shows the noble metal information stored in database in the form of continuous number section.
Using the query process of sql like language, also very simple, strong operability, effect are high.By 6 medium size paragraph header of table, number section serial number Length is identical and the identical block number of serial number difference merges, and obtains continuous number section, shows that result example is as shown in table 7.
Table 7 is in service terminal to the display form of noble metal block number
In service terminal display, it need to generally increase the quantity for the block number for including in continuous number section, as shown above.And And display form can be same as the prior art, that is, does not include that setting number section head, serial number be poor, displaying of number section serial number length, when So, can also be as shown in table 7, the case where showing these fields, can no longer show serial number in the continuous number section after merging, can also weigh New serial number is newly set, it is without limitation in the present embodiment.
In addition, in the embodiment of the present invention when service terminal shows noble metal information, also settable index entry, with Lookup convenient for service terminal to noble metal storage condition in database.Theoretically, the index field of the index entry includes essential Field and Optional Field, the mandatory field include number section head, number section serial number and number section serial number length；The Optional Field includes The noble metal mechanism number, keeping teller number, product code, matter damage mark, property rights mark, locking mark, Storage Cabinets box number.It changes Sentence is talked about, and for index field, mandatory field is the field that must be provided with, and Optional Field is dispensable, and can Think any one or more in the above field.In actual setting index entry, multiple index words generally can be selectively set Section, it does not repeat them here in the present embodiment, is arranged according to actual needs.
It further, can also be according to business demand and the index entry, to described expensive when service terminal is shown Metal block number is ranked up display and/or Pagination Display.
The setting up procedure of display and/or Pagination Display is ranked up to index entry and to noble metal block number above, can be used JAVA program is realized.
It should be noted that the noble metal block number split process of step S202 can be set step S203, step S204, In step S205 before either step, also can be set it is any in step S203, step S204, step S205 after, this reality It applies before being preferably provided at step S203 in example.The execution sequence that number section serial number length is recorded in same step S203 can also be with Arbitrary adjustment is done, as long as by the curriculum offering of step S203 before step S206, to ensure that serial number difference calculates just True property.The present embodiment is only illustrated with above-mentioned execution sequence, and other execution sequences are also in the protection scope of the embodiment of the present invention Among, the other execution sequences of the present embodiment repeat no more.
In addition, when business is traded and alloted to noble metal, which occurs, background server also needs in service terminal and national treasury end Corresponding modification is made to the noble metal block number record in database.
Wherein, when noble metal transaction occurs for service terminal, i.e., after client determines the purchase situation of noble metal, front end Business personnel will be in the purchase information of service terminal sending noble metal data, and later, background server can modify database In corresponding noble metal block number correspondence attribute-bit.Since the block number information in database is monolithic storage, modification In the process, background server only need to directly modify corresponding block number attribute, search and continuous number section without doing any block number The operation such as fractionation, simplify the processing logic of background server, when avoiding identical services and taking place frequently, the work of background server The case where process breaks down.
Specifically, when national treasury or service terminal generation noble metal allot business, recalling mechanism in the present embodiment and receiving To noble metal block number when recalling instruction, the noble metal block number record recalled in database is directly deleted, is also not required to appoint What block number is searched and the operations such as the fractionation of continuous number section.Receiving mechanism is receiving when calling in instruction of noble metal block number, directly The noble metal block number record for increasing call in the database is connect, without carrying out any whether being positioned at same consecutive number The deterministic process etc. of section, simplifies the operation of background server.
Further, it may also allow for service terminal to the list in continuous number section when service terminal is shown in the present embodiment Block noble metal such as is shown and locks at the operation, for example, in service terminal display, it can be on the periphery of continuous number section display position Region is arranged drop-down menu and identifies, and clicks drop-down menu mark, can show multiple block numbers in continuous number section.When multiple industry Business terminal is simultaneously emitted by the query information in step S201, after the adjustment for triggering backstage noble metal block number information, and meanwhile it is multiple When terminal display device shows same interface simultaneously, and multiple service terminals carry out the operation such as locking to same continuous number section in succession When, some service terminal can lock the single block number under the continuous number section, while not influence other service terminals again The operation such as inquiry and locking to other block numbers in the continuous number section, to avoid the display interface of the continuous number section of frequent updating Bring is inconvenient.
The specific implementation of aforesaid operations are as follows: service terminal sends to background server and shows some or certain consecutive numbers The demand information for multiple noble metal block numbers that section includes is arranged as the attendant of service terminal clicks in continuous number section viewing area The operation of the drop-down menu mark on domain periphery, the displaying some or certain continuous number sections can be sent to background server includes The demand information of multiple noble metal block numbers.Background server receive the transmission of some service terminal displaying some or it is certain continuous After the demand information for multiple noble metal block numbers that number section includes, the multiple noble metal block numbers that can include by the continuous number section Information be sent to the service terminal, to show multiple nuggets that the continuous number section includes in the service terminal Number.
For locking the implementation of noble metal block number are as follows: service terminal is single or multiple to background server transmission locking The demand information of noble metal block number, such as after showing multiple noble metal block numbers that continuous number section includes, the service of service terminal Personnel click the locking mark that noble metal block number display area periphery is arranged in, and it is single the locking can be sent to background server Or the demand information of multiple noble metal block numbers.Except of course that being respectively provided with a locking mark in each noble metal block number display area Except, one locking mark can also be set on continuous number section display area periphery, for locking the noble metal of entire continuous number section Block number.
Background server receives the demand information of the single or multiple noble metal block numbers of locking of some service terminal transmission Later, the single or multiple noble metal block numbers are locked, to avoid on other service terminals in addition to the service terminal Repetitive operation is carried out to the single or multiple noble metal block numbers.The mode of specific locking noble metal block number can be to lock When some noble metal block number, in addition the mark of the service terminal of the demand information is issued, in order to identify and to process of exchange Record etc..
Embodiment three
The flow chart of the processing method of noble metal data disclosed in the present embodiment as shown in figure 3, identical as embodiment two, The identical step implementation process of middle content is also identical, and this embodiment is not repeated.
Unlike embodiment two, in the present embodiment after receiving trigger action information, step S302 is increased, To the query process for the action type that noble metal block number record is modified in last database, when the last time is in database Noble metal block number record carry out be delete block number record operation, then the treatment process of this less noble metal data is skipped to expensive The step of metal block number is split etc. is directly entered the process being ranked up in step 307 to noble metal block number；Work as the last time What it is to the noble metal block number record progress in database is the operation for increasing block number record, then this less noble metal data is processed Journey enters step the process split in 305 to noble metal block number.
Further, in step 305 to the split process of noble metal block number when being executed, due to newly-increased noble metal block number Part attribute field be in the state of non-typing, and hence it is also possible to further increase a step, that is, judge existing number According in the noble metal block number stored in library, whether it is in not in the attributes such as number section head, number section serial number, number section length, serial number difference The state of typing substantive content, if so, only carrying out the fractionation of block number, number section serial number length to these newly-increased noble metal block numbers The processing such as record, and block number is split, the block number of number section serial number record is then not repeated to carry out to having already passed through in operation before Corresponding processing.
It should be noted that the premise for implementing this embodiment scheme is in the processing method process for executing the noble metal data In, when at least executing this method to the last time in database, noble metal block number is split and is recorded number section serial number length Processing result saved.
Method in the present embodiment, which passes through simply to increase, modifies to noble metal information in last database The query process of action type takes place frequently the period in business, avoids the need for carrying out noble metal data existing in database Repetition split process again and again, further improves the working efficiency of background server.
Example IV
It is corresponding with embodiment of the method, it is expensive in the present embodiment present embodiment discloses a kind of noble metal data processing equipment The form that metal block number is recorded using single block number as one in the database is stored, the noble metal data processing equipment knot Composition is as shown in figure 4, specifically include following functions module:
Receiving unit 11 processes noble metal data with triggering following for receiving the demand information of service terminal Journey.
Sequencing unit 12, for the demand according to service terminal, at least using noble metal block number as sort field, to the number It is ranked up according to a plurality of noble metal record stored in library, will at least have identical in multiple attribute-bits of noble metal The noble metal block number of number section head and identical block number length is successively arranged according to the size of number section serial number.
Serial number adding unit 13, for increasing corresponding arrangement serial number, the arrangement sequence in every record after sequence Number arranged mode it is consistent with the sortord of number section serial number size.
Computing unit 14, for subtracting corresponding arrangement sequence using the number section serial number of the noble metal block number after sequence Number, it is poor to obtain serial number.
Combining unit 15, for by multiple attribute-bits of noble metal, at least number section head, block number length and serial number to be poor Identical noble metal block number merges into continuous number section.
Transmission unit 16, for the noble metal information after merging cell processing to be sent to display device, by data The noble metal information stored in library is shown in service terminal in the form that continuous number section is shown.
In addition, further including split cells 17, for splitting to the noble metal block number, each noble metal block number is obtained Number section head and number section serial number.
Record modification unit 18, in noble metal data handling procedure, the number section serial number for increasing noble metal block number to be long The record content of degree and serial number difference, and when receiving noble metal block number and recalling instruction, it is directly recalled in deletion database expensive Metal block number record；When receiving noble metal block number and calling in instruction, directly increase the noble metal block number called in the database Record.
Corresponding with embodiment of the method, the function for multiple noble metal block numbers that number section continuous for displaying includes can be by connecing Receive the multiple noble metal block numbers for showing some or certain continuous number sections include that unit 11 is used to receive the transmission of some service terminal Demand information, the information for multiple noble metal block numbers that the continuous number section includes is sent to the business by transmission unit 16 Terminal, to show multiple noble metal block numbers that the continuous number section includes in the service terminal.
In addition, further including lock cell for the function of locking single or multiple noble metal block numbers, in receiving unit 11 when receiving the demand information of the single or multiple noble metal block numbers of locking of some service terminal transmission, lock it is described single or Multiple noble metal block numbers, to avoid on other service terminals in addition to the service terminal to your single or multiple gold Belong to block number and carries out repetitive operation.
In other embodiments, which further includes query unit, for inquiring last data Noble metal block number records the action type modified in library.Noble metal block number record in database is deleted when the last time Except block number record operation when, then skip split cells 17, directly by sequencing unit 12 to noble metal block number record handle； When the last time having carried out the operation of increase block number record to noble metal block number record in database, then successively by split cells 17, sequencing unit 12 etc. handles noble metal block number record.
Embodiment five
Corresponding with embodiment of the method, present embodiment discloses a kind of noble metal data processing system, which includes number According to library, background server and at least one service terminal.Background server in the present embodiment is equivalent in an embodiment Processing unit.
Wherein, the database is for storing noble metal block number, the storage form of the noble metal block number in the database It is recorded for single block number as one.
After the background server is used to receive the demand information of service terminal, i.e. trigger action information, service terminal is extremely Your less using noble metal block number as sort field, a plurality of noble metal record stored in the database is ranked up, in gold In the multiple attribute-bits belonged to, by the noble metal block number at least with same No. paragraph header and identical block number length according to number section serial number Size successively arranged, and increase corresponding arrangement serial number in every after sequence record, and using expensive after sequence The number section serial number of metal block number subtracts corresponding arrangement serial number, obtains that serial number is poor, will be in multiple attribute-bits of noble metal In, at least number section head, block number length and the identical noble metal block number of serial number difference merge into continuous number section, will be through block number merging treatment Noble metal information afterwards is sent to display device, wherein the arranged mode of the arrangement serial number and the sequence of number section serial number size Mode is consistent.
The service terminal is for showing the noble metal information stored in database in the form that continuous number section is shown Show.
The background server is also used to split the noble metal block number, obtains the number section of each noble metal block number Head point and number section serial number part.Also, in noble metal data handling procedure, increase the number section serial number length of noble metal block number Your gold recalled in database directly deleted and when receiving noble metal block number and recalling instruction with the record content of serial number difference Belong to block number record；When receiving noble metal block number and calling in instruction, directly increase the noble metal block number note called in the database Record.
It is corresponding with content in embodiment of the method, the function for multiple noble metal block numbers that number section continuous for displaying includes, Specific implementation process is that the service terminal is also used to while showing continuous number section, and Xiang Suoshu background server sends exhibition Show some or the demand information of multiple noble metal block numbers that certain continuous number sections include, and shows that the continuous number section includes more A noble metal block number.The background server is also used to receive the displaying of some service terminal transmission some or certain continuous number sections The demand information for the multiple noble metal block numbers for including, and the information for the multiple noble metal block numbers for including by the continuous number section is sent To the service terminal.
The function for multiple noble metal block numbers that number section continuous for displaying includes, in addition to implementations described above process, also It can only be realized by the processor of service terminal, not do excessively repeat here.
For locking the function of single or multiple noble metal block numbers, specific implementation process is that the service terminal is also used to The demand information for locking single or multiple noble metal block numbers is sent, to the background server to avoid the service terminal is being removed Except other service terminals on repetitive operations are carried out to the single or multiple noble metal block numbers；The background server is also used In the demand information for the single or multiple noble metal block numbers of locking for receiving the transmission of some service terminal, and lock described single or more A noble metal block number.
In addition, index entry can also be arranged, also, can be with root when service terminal shows noble metal information The noble metal information is arranged when showing the noble metal information according to the demand of business and the facilities of index entry Sequence is shown and/or Pagination Display, to facilitate business service personnel to check noble metal information.The i.e. described service terminal is also used to Index entry is set when showing the noble metal information, and display is ranked up to the noble metal information and/or paging is aobvious Show.The index field of the index entry includes mandatory field and Optional Field, and the mandatory field includes number section head, number section serial number With number section serial number length, the Optional Field include the noble metal mechanism number, keeping teller number, product code, matter damage mark, Property rights mark, locking mark, Storage Cabinets box number.
Obviously, various changes and modifications can be made to the invention without departing from essence of the invention by those skilled in the art Mind and range.In this way, if these modifications and changes of the present invention belongs to the range of the claims in the present invention and its equivalent technologies Within, then the present invention is also intended to include these modifications and variations.

Claims (19)

1. a kind of processing method of noble metal data, which is characterized in that noble metal block number in the database using single block number as The form of one record is stored, this method comprises:
Receive the demand information of service terminal；
At least using noble metal block number as sort field, a plurality of noble metal record stored in the database is ranked up, with In multiple attribute-bits of noble metal, will at least the noble metal block number with same No. paragraph header and identical block number length according to number The size of section serial number is successively arranged；
Increase corresponding arrangement serial number in every record after sequence, the arranged mode and number section serial number of the arrangement serial number are big Small sortord is consistent；Corresponding arrangement serial number is subtracted using the number section serial number of the noble metal block number after sequence, is obtained Serial number is poor；
By in multiple attribute-bits of noble metal, at least number section head, block number length and the identical noble metal block number of serial number difference are closed And be continuous number section, the noble metal information stored in database to be shown in the form that continuous number section is shown in service terminal Show；It wherein, is to be recorded in the form of a list to the recording mode of the noble metal block number in database, a record accounts for According to same a line or same row of list；Service terminal is to the exhibition method of the continuous number section of noble metal block number, with the shape of list Formula is shown, and the record of a continuous number section occupies same a line or same row of list；
Described at least using noble metal block number as sort field, a plurality of noble metal record stored in the database is arranged Before or after sequence, further includes:
The noble metal block number is split, the number section head and number section serial number of each noble metal block number are obtained；
It is described with noble metal when being split to the noble metal block number before being ranked up to noble metal record Block number is sort field, to stored in the database a plurality of noble metal record be ranked up specifically: at least with split after Noble metal block number number section head, number section serial number and number section serial number length be sort field, it is more to being stored in the database Noble metal record is ranked up, will at least have same No. paragraph header and same No. in multiple attribute-bits of noble metal The noble metal block number of section serial number length is successively arranged according to the size of number section serial number.
2. the processing method of noble metal data according to claim 1, which is characterized in that carried out to the noble metal block number It splits, obtains number section head point and the concrete mode of number section serial number part of each noble metal block number are as follows:
Using regular expression, the number section head point and number section serial number part of the noble metal block number are inquired, and will be described number Paragraph header part and number section serial number part are split, and the number section head point and number section serial number part of each noble metal block number are obtained.
3. the processing method of noble metal data according to claim 1, which is characterized in that use the nugget after sequence Number number section serial number subtract corresponding arrangement serial number, obtain serial number difference before, further includes: record noble metal block number number section Serial number length, when the number section is identical and number section serial number length is identical, the block number length is identical.
4. the processing method of noble metal data according to claim 1, which is characterized in that be ranked up to noble metal block number Sort field further include noble metal mechanism number, keeping teller number, product code, matter damage mark, property rights mark, locking mark and At least one of Storage Cabinets box number.
5. the processing method of noble metal data according to claim 3, which is characterized in that will be in multiple attributes of noble metal In mark, at least number section head, block number length and the identical noble metal block number of serial number difference merge into continuous number section, in service terminal The concrete mode that the noble metal information stored in database is shown in the form of continuous number section are as follows:
Using structured query language, inquiry is grouped to noble metal record, it will be in multiple attribute marks of noble metal In knowledge, at least number section head, number section serial number length and the identical noble metal block number of serial number difference merge into one group, and every group as a company Continuous number section, is shown the noble metal information stored in database by service terminal in the form of continuous number section.
6. the processing method of noble metal data according to claim 1, which is characterized in that further include: your gold received Belong to when recalling instruction of block number, deletes the noble metal block number record recalled in database；Receiving calling in for noble metal block number When instruction, increase the noble metal block number record called in the database.
7. the processing method of noble metal data according to claim 1, which is characterized in that recorded when to the noble metal Before being ranked up, when being split to the noble metal block number, after the demand information for receiving service terminal, also wrap It includes:
Inquiry is last to record the action type modified to noble metal block number in database；
When the last time having carried out the operation of deletion block number record to noble metal block number record in database, then skip to described expensive The step of metal block number is split, into the step for recording and being ranked up to a plurality of noble metal stored in the database Suddenly；
When the last time having carried out the operation of increase block number record to noble metal block number record in database, then enter to described expensive The step of metal block number is split.
8. the processing method of noble metal data according to claim 1, which is characterized in that further include:
Receive the demand letter for showing multiple noble metal block numbers that some or certain continuous number sections include of some service terminal transmission Breath；
The information for multiple noble metal block numbers that the continuous number section includes is sent to the service terminal, with whole in the business End shows multiple noble metal block numbers that the continuous number section includes.
9. the processing method of noble metal data according to claim 8, which is characterized in that further include:
Receive the demand information of the single or multiple noble metal block numbers of locking of some service terminal transmission；
The single or multiple noble metal block numbers are locked, to avoid right on other service terminals in addition to the service terminal The single or multiple noble metal block numbers carry out repetitive operation.
10. a kind of noble metal data processing equipment, which is characterized in that noble metal block number is in the database using single block number as one The form of item record is stored, which includes:
Receiving unit, for receiving the demand information of service terminal；
Sequencing unit, for being remembered to a plurality of noble metal stored in the database at least using noble metal block number as sort field Record is ranked up, will be at least expensive with same No. paragraph header and identical block number length in multiple attribute-bits of noble metal Metal block number is successively arranged according to the size of number section serial number；
Serial number adding unit, for increasing corresponding arrangement serial number, the volume of the arrangement serial number in every record after sequence Row's mode is consistent with the sortord of number section serial number size；
Computing unit is obtained for being subtracted corresponding arrangement serial number using the number section serial number of the noble metal block number after sequence Serial number is poor；
Combining unit, for by multiple attribute-bits of noble metal, at least number section head, block number length and serial number difference to be identical Noble metal block number merges into continuous number section；
Transmission unit will be deposited for the noble metal information after merging cell processing to be sent to display device in database The noble metal information of storage is shown in service terminal in the form that continuous number section is shown；Wherein, to your gold in database The recording mode for belonging to block number is to be recorded in the form of a list, and one records the same a line or same row for occupying list；Business Terminal is to be shown in the form of a list to the exhibition method of the continuous number section of noble metal block number, the note of a continuous number section Record occupies same a line or same row of list；
Split cells, for being split to the noble metal block number, obtain each noble metal block number number section head point and number Section serial number part；
It is described with noble metal when being split to the noble metal block number before being ranked up to noble metal record Block number is sort field, to stored in the database a plurality of noble metal record be ranked up specifically: at least with split after Noble metal block number number section head, number section serial number and number section serial number length be sort field, it is more to being stored in the database Noble metal record is ranked up, will at least have same No. paragraph header and same No. in multiple attribute-bits of noble metal The noble metal block number of section serial number length is successively arranged according to the size of number section serial number.
11. noble metal data processing equipment according to claim 10, which is characterized in that further include: record modification unit, For in noble metal data handling procedure, increasing the number section serial number length of noble metal block number and the record content of serial number difference, and When receiving noble metal block number and recalling instruction, the noble metal block number record recalled in database is deleted；Receiving noble metal When block number calls in instruction, increase the noble metal block number record called in the database.
12. noble metal data processing equipment according to claim 10, which is characterized in that further include: query unit is used for It inquires noble metal block number in last database and records the action type modified.
13. noble metal data processing equipment according to claim 10, which is characterized in that further include: information locking unit, For receiving the demand information of the single or multiple noble metal block numbers of locking of some service terminal transmission in the receiving unit When, lock the single or multiple noble metal block numbers.
14. a kind of noble metal data processing system, which is characterized in that including database, background server and at least one business Terminal；
Wherein, the database is single for storing noble metal block number, the storage form of the noble metal block number in the database A block number is recorded as one；
After the background server is used to receive the demand of service terminal, at least using noble metal block number as sort field, to described The a plurality of noble metal record stored in database is ranked up, will at least have phase in multiple attribute-bits of noble metal The noble metal block number of jack per line paragraph header and identical block number length is successively arranged according to the size of number section serial number, and after sequence Increase corresponding arrangement serial number in every record, and is subtracted using the number section serial number of the noble metal block number after sequence corresponding Serial number is arranged, obtains that serial number is poor, by multiple attribute-bits of noble metal, at least number section head, block number length and serial number difference phase Same noble metal block number merges into continuous number section, and the noble metal information after block number merging treatment is sent to display device, In, the arranged mode of the arrangement serial number is consistent with the sortord of number section serial number size；
The service terminal is for showing the noble metal information stored in database in the form that continuous number section is shown；
The background server is also used to split the noble metal block number, obtain each noble metal block number number section head and Number section serial number；
It is described with noble metal when being split to the noble metal block number before being ranked up to noble metal record Block number is sort field, to stored in the database a plurality of noble metal record be ranked up specifically: at least with split after Noble metal block number number section head, number section serial number and number section serial number length be sort field, it is more to being stored in the database Noble metal record is ranked up, will at least have same No. paragraph header and same No. in multiple attribute-bits of noble metal The noble metal block number of section serial number length is successively arranged according to the size of number section serial number.
15. noble metal data processing system according to claim 14, which is characterized in that the background server is also used to In noble metal data handling procedure, increase the number section serial number length of noble metal block number and the record content of serial number difference, and connecing When receiving noble metal block number and recalling instruction, the noble metal block number record recalled in database is directly deleted；Receiving noble metal When block number calls in instruction, directly increase the noble metal block number record called in the database.
16. noble metal data processing system according to claim 14, which is characterized in that the service terminal is also used to Index entry is set when showing the noble metal information, and the index field of the index entry includes mandatory field and Optional Field, institute Stating mandatory field includes number section head, number section serial number and number section serial number length, the Optional Field include the noble metal mechanism number, Keeping teller number, product code, matter damage mark, property rights mark, locking mark, Storage Cabinets box number.
17. noble metal data processing system according to claim 16, which is characterized in that the service terminal is also used to When showing the noble metal information, display and/or Pagination Display are ranked up to the noble metal information.
18. noble metal data processing system according to claim 14, which is characterized in that the service terminal is also used to While showing continuous number section, Xiang Suoshu background server sends the multiple noble metals for showing that some or certain continuous number sections include The demand information of block number, and show multiple noble metal block numbers that the continuous number section includes；The background server is also used to connect The demand information for showing multiple noble metal block numbers that some or certain continuous number sections include of some service terminal transmission is received, and will The information for multiple noble metal block numbers that the continuous number section includes is sent to the service terminal.
19. noble metal data processing system according to claim 18, which is characterized in that the service terminal be also used to The background server sends the demand information for locking single or multiple noble metal block numbers, to avoid except the service terminal it Repetitive operation is carried out to the single or multiple noble metal block numbers on outer other service terminals；The background server is also used to The demand information of the single or multiple noble metal block numbers of locking of some service terminal transmission is received, and is locked described single or multiple Noble metal block number.
CN201610461141.2A 2016-06-22 2016-06-22 Processing method, the device and system of noble metal data Active CN106126633B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201610461141.2A CN106126633B (en) 2016-06-22 2016-06-22 Processing method, the device and system of noble metal data

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201610461141.2A CN106126633B (en) 2016-06-22 2016-06-22 Processing method, the device and system of noble metal data

Publications (2)

Publication Number Publication Date
CN106126633A CN106126633A (en) 2016-11-16
CN106126633B true CN106126633B (en) 2019-10-18

Family

ID=57267996

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201610461141.2A Active CN106126633B (en) 2016-06-22 2016-06-22 Processing method, the device and system of noble metal data

Country Status (1)

Country Link
CN (1) CN106126633B (en)

Families Citing this family (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109544239A (en) * 2018-11-26 2019-03-29 广州每金珠宝有限公司 A kind of red packet management method based on gold product monomer
CN112860780B (en) * 2021-03-30 2024-06-14 中国工商银行股份有限公司 Data export method and device and terminal equipment

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101751475A (en) * 2010-01-08 2010-06-23 联动优势科技有限公司 Method for compressing section records and device therefor
CN101751406A (en) * 2008-12-18 2010-06-23 赵伟 Method and device for realizing column storage based relational database
CN102163226A (en) * 2011-04-12 2011-08-24 浙江大学 Adjacent sorting repetition-reducing method based on Map-Reduce and segmentation

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
EP1591916B1 (en) * 2004-04-26 2013-11-06 Sap Ag Method, computer program and device for deleting data sets contained in a table system

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101751406A (en) * 2008-12-18 2010-06-23 赵伟 Method and device for realizing column storage based relational database
CN101751475A (en) * 2010-01-08 2010-06-23 联动优势科技有限公司 Method for compressing section records and device therefor
CN102163226A (en) * 2011-04-12 2011-08-24 浙江大学 Adjacent sorting repetition-reducing method based on Map-Reduce and segmentation

Also Published As

Publication number Publication date
CN106126633A (en) 2016-11-16

Similar Documents

Publication Publication Date Title
US6496838B1 (en) Database reconciliation method and system
US20030171942A1 (en) Contact relationship management system and method
US20030097359A1 (en) Deduplicaiton system
CN110781183A (en) Method and device for processing incremental data in Hive database and computer equipment
CN112463800A (en) Data reading method and device, server and storage medium
CN108073707B (en) Financial business data updating method and device and computer readable storage medium
US7509334B2 (en) Methods, systems and computer program products for segmented presentation of service order status information
CN106126633B (en) Processing method, the device and system of noble metal data
CN113420057A (en) Account checking data processing method and related device
US7707078B2 (en) Method and apparatus for mapping dimension-based accounting entries to allow segment-based reporting
CN110489032B (en) Dictionary query method for electronic book and electronic equipment
CN109214362B (en) Document processing method and related equipment
CN111190965B (en) Impromptu relation analysis system and method based on text data
CN110502529B (en) Data processing method, device, server and storage medium
CN106708869B (en) Group data processing method and device
CN110019182B (en) Data tracing method and device
CN107741979A (en) A kind of help information display methods and device
CN109460318A (en) It is a kind of can rollback archives acquisition data introduction method, computer installation and computer readable storage medium
JP2002063363A (en) Insurance contract information management system and customer index generating method
JP2018013819A (en) Business matching support system, and business matching support method
CN111683128A (en) Information sending method, device, prejudgment server and storage medium
CN110321412A (en) Printing approaches to IM and device
JP6368442B1 (en) Information processing apparatus and information processing method
JPH1125187A (en) Journal slip input method
US20210141996A1 (en) System and method for note taking and management

Legal Events

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