CN102117292A - File secondary generation and query method - Google Patents
File secondary generation and query method Download PDFInfo
- Publication number
- CN102117292A CN102117292A CN2009102477546A CN200910247754A CN102117292A CN 102117292 A CN102117292 A CN 102117292A CN 2009102477546 A CN2009102477546 A CN 2009102477546A CN 200910247754 A CN200910247754 A CN 200910247754A CN 102117292 A CN102117292 A CN 102117292A
- Authority
- CN
- China
- Prior art keywords
- file
- querying
- generates
- querying method
- condition
- 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.)
- Granted
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a file secondary generation and query method comprising the following steps of (A1) collocating interface parameters, setting the file type and reading the file; (A2) according to the file type, dynamically loading and displaying the contents corresponding to the file type; (A3) selecting the query conditions, and conducting query according to the query conditions; (A4) displaying and keeping statistics on the query result; and (A5) conducting file secondary generation, and enabling the query result to generate the secondary treating report file in a file mapping method.
Description
Technical field
The present invention relates to the file secondary and generate and querying method, more specifically, relate to bank card file secondary and generate and querying method.
Background technology
At present, along with becoming increasingly abundant of the growing of banking and bank card business kind, the bank card file is carried out the generation of simple and rapid secondary and inquires about becoming more and more important under the windows platform.In existing bank card querying method, use SQL (Structured Query Language (SQL)) statement to inquire about by loading to database software at the following file of unix platform.Yet, the translation that this existing method can not be carried out type of transaction can not be added up according to type of transaction, and this existing method only is suitable for the technician data are handled, thereby poor for applicability, complicated operation, and can not carry out secondary treating to data.Secondly, under the windows platform, existing file processing instrument uses the intermediate storage mode of database software as data source and intermediate data processing usually, thereby, the function of instrument itself is subjected to the constraint of database software, thereby has limited the application cost and the convenience of existing bank card querying method.
Summary of the invention
In order to solve the existing defective of above-mentioned prior art scheme, the present invention proposes and a kind ofly do not use any database software, and can carry out that the file secondary generates and the method for inquiry as data source and intermediate treatment storage mode as a result.
One of purpose of the present invention is achieved through the following technical solutions:
A kind of file secondary generates and querying method, and described file secondary generates and querying method comprises the steps:
(A1) preparation interface parameter, be provided with file type go forward side by side the style of writing part read;
(A2) according to described file type, dynamic loading also shows the content of described file type correspondence;
(A3) select querying condition, and inquire about according to described querying condition;
(A4) demonstration and statistical query result;
(A5) the file secondary generates, and statistics is generated the secondary treating report file with the File mapping method;
In the disclosed in the above scheme, preferably, use memory-mapped that file is carried out batch and read in processing.
In the disclosed in the above scheme, preferably, described bank card file secondary generates and querying method is performed under the windows platform.
In the disclosed in the above scheme, preferably, described step (A1) further comprises:
(B1) mode of described file is opened in select File and selection;
(B2), and be mapped in the internal memory by memory-mapped technology every with file to file block;
(B3) according in the memory parameters to the requirement of file layout configuration, each internal memory that reads in is divided block file to split and loses in the container.
In the disclosed in the above scheme, preferably, described step (A3) further comprises:
(C1) the configuration parameter file loads;
(C2) carrying out querying condition handles and the container packing;
(C3) flowing water query processing.
In the disclosed in the above scheme, preferably, all parameter informations are preserved with the .cfg document form in step (C1).
In the disclosed in the above scheme, preferably, in step (C3),,, obtain the concrete data in the flowing water and mate,, take off delegation's flowing water and mate again if do not match then directly abandon according to the Kinematic Positioning method to each condition field information in the described container; Mate if mate then proceed querying condition, finish up to all conditions coupling.
File secondary disclosed in this invention generates and querying method has following advantage: can carry out the file type configuration to the bank card chronological file under the windows platform, the dynamic self-adapting configuration of querying condition and display result, and can carry out correspondence inquiry and the generation of secondary treating file, simultaneously, in file secondary generation disclosed in this invention and querying method, do not use any database software as data source and intermediate treatment storage mode as a result, and can be for different file type bank card chronological files, system is coupling and the pairing condition field of demonstration this document type automatically, type of transaction, display field and designated statistics field, but and the equal dynamic-configuration of above-mentioned self-adaptation result, thereby make things convenient for the user to carry out accurately or fuzzy query according to selectable service condition field of actual conditions and type of transaction, and will inquire about and statistics generation excel/csv format message list file, be convenient to secondary treating, as from the foregoing, generate and querying method is with good expansibility and stronger adaptability at file secondary disclosed in this invention.
Description of drawings
In conjunction with the accompanying drawings, technical characterictic of the present invention and advantage will be understood better by those skilled in the art, wherein:
Fig. 1 generates and the querying method process flow diagram for file secondary according to an embodiment of the invention;
Fig. 2 is that file reads the process flow diagram of processing according to an embodiment of the invention;
Fig. 3 is the process flow diagram handled of file polling according to an embodiment of the invention.
Embodiment
Fig. 1 generates and the querying method process flow diagram for file secondary according to an embodiment of the invention.As shown in Figure 1, file secondary generation disclosed in this invention and querying method comprise the steps; (A1) preparation interface parameter, be provided with file type go forward side by side the style of writing part read; (A2) according to described file type, dynamic loading also shows the content of described file type correspondence; (A3) select querying condition, and inquire about according to described querying condition; (A4) demonstration and statistical query result; (A5) the file secondary generates, and statistics is generated the secondary treating report file with the File mapping method.Wherein, in steps A 1, for stamping the querying condition sign as the format fields of querying condition; For the querying condition field that the user can not discern, stamp the translator of Chinese sign; If amount field, is stamped accurate matching inquiry sign as the querying condition field; The possible type of transaction of configuration file type correspondence; The Query Result field that the type file need show is stamped show label; To the amount of money class field that needs to add up, stamp statistical mark.In steps A 2,, querying condition format fields, type of transaction, the display format field of correspondence are loaded, and be shown in the interface according to the file type of reading in; Condition field after the translation is if desired then loaded the content after the translation, and will add up format fields and be loaded in the internal memory.In steps A 3, select the querying condition field, the Query Information that input is corresponding; Select the inquiry type of transaction, and can between described a plurality of condition fields be to a plurality of condition field typings " with " logical relation, also can between described a plurality of values be to a plurality of values of each condition field typing " or " logical relation; Between a plurality of types of transaction be " or " logical relation, between condition field and the type of transaction be " with " logical relation.In steps A 4, carry out inquiry, for not disposing the accurately condition of inquiry, carry out the fuzzy matching mode, accurately mate for the condition that configuration is accurately inquired about.With the type of transaction of typing, translate into the transaction ISN, perhaps critical field information (as type of message, type of message and service point condition-code field) in the file layout is mated again; Query Result is intercepted and output according to display field, carry out the type of transaction translation, according to type of transaction Query Result is classified, for each type of transaction statistics transaction stroke count, amount field (as setting the capital that needs statistics, commission receivable, commission payable etc.).In steps A 5, with the display field that is provided with, and all statisticses generate the secondary treating report file with the File mapping method, and form is excel or csv; If any querying condition is not set, then the file to whole input is considered as the Query Result processing.When the secondary treating file generates, add up all results and output in the file by type of transaction; This report file both can directly use for the user as statistical report form or file, and also can carry out secondary treating to this report file once more according to actual conditions by the user, thereby solve the diversified demand of user to form.In described bank card file secondary generation and querying method, Memory Mapping File and its is handled with internal memory and is used combination; Use the memory-mapped technology, file is carried out batch read in processing, simultaneously mapping and the onesize secondary report file of original; In internal memory, after the above-mentioned steps processing, the content that will meet treatment conditions is kept in the memory headroom, enough for guaranteeing Installed System Memory, surpass 100 then directly the result mapping is generated in the secondary report file if handle record, after system handles finishes, this secondary report file is carried out handling by the reduction of real processing results.
Fig. 2 is that file reads the process flow diagram of processing according to an embodiment of the invention.As shown in Figure 2, file disclosed by the invention reads the mode that comprises the steps: (B1) select File and select to open described file of handling; (B2), and be mapped in the internal memory by memory-mapped technology every with file to file block; (B3) according in the memory parameters to the requirement of file layout configuration, each internal memory that reads in is divided block file to split and loses in the container.Read in the processing at bank card file disclosed by the invention, for the file of selecting, carry out virtual memory mappings, the direct mapping of file block (as each 640kb size) is loaded in the internal memory, again according to the line feed or the new line requirement of in the memory parameters file layout being disposed, divide block file to split to the internal memory that reads in, lose in the container, for the program subsequent treatment by every row; Simultaneously, the pointer memory is read into the position of file block part, if this document does not have disposable whole graftabl, then packs into from this pointer position next time.
Fig. 3 is the process flow diagram handled of file polling according to an embodiment of the invention.As shown in Figure 3, file polling processing procedure disclosed in this invention comprises the steps: that (C1) configuration parameter file loads; (C2) carrying out querying condition handles and the container packing; (C3) flowing water query processing.In step C1, all parameter informations are preserved with the .cfg document form; After file is selected, according to the parameter configuration in the file name selective loading .cfg file of input; In internal memory, comprise: file attribute structure, file layout field and attribute structure body, type of transaction, field translation, statistical information structure and container etc.In step C2, with the querying condition of a selection, and the value of typing, according to field name, the length position, conditional value is formed structure.The querying condition structure of a plurality of selections is inserted in the container, leave in the internal memory.In step C3, to each condition field information in this container,, obtain the concrete data in the flowing water according to the Kinematic Positioning method, mate, if do not match then directly abandon, take off delegation's flowing water and mate again; Mate if mate then proceed querying condition, finish up to all conditions coupling, qualified flowing water is kept in the internal memory; If eligible query note surpasses 100, then stop inquiry, and Query Result shows; Generate the secondary report file if desired, then directly will write down mapping and write in the report file, disposed by inquiry file up to whole.
Although the present invention is described by above-mentioned preferred implementation, its way of realization is not limited to above-mentioned embodiment.Should be realized that: under the situation that does not break away from purport of the present invention and scope, those skilled in the art can make different variations and modification to the present invention.
Claims (7)
1. a file secondary generates and querying method, and described file secondary generates and querying method comprises the steps:
(A1) preparation interface parameter, be provided with file type go forward side by side the style of writing part read;
(A2) according to described file type, dynamic loading also shows the content of described file type correspondence;
(A3) select querying condition, and inquire about according to described querying condition;
(A4) demonstration and statistical query result;
(A5) the file secondary generates, and statistics is generated the secondary treating report file with the File mapping method.
2. file secondary according to claim 1 generates and querying method, it is characterized in that, uses memory-mapped that file is carried out batch and reads in processing.
3. generate and querying method according to the described file secondary of any claim among the claim 1-2, it is characterized in that, described file secondary generates and querying method is performed under the windows platform.
4. generate and querying method according to the described file secondary of any claim among the claim 1-2, it is characterized in that described step (A1) further comprises:
(B1) mode of described file is opened in select File and selection;
(B2), and be mapped in the internal memory by memory-mapped technology every with file to file block;
(B3) according in the memory parameters to the requirement of file layout configuration, each internal memory that reads in is divided block file to split and loses in the container.
5. generate and querying method according to the described file secondary of any claim among the claim 1-2, it is characterized in that described step (A3) further comprises:
(C1) the configuration parameter file loads;
(C2) carrying out querying condition handles and the container packing;
(C3) flowing water query processing.
6. file secondary according to claim 5 generates and querying method, it is characterized in that, in step (C1) all parameter informations is preserved with the .cfg document form.
7. file secondary according to claim 5 generates and querying method, it is characterized in that, in step (C3), to each condition field information in the described container, according to the Kinematic Positioning method, obtain the concrete data in the flowing water and mate,, take off delegation's flowing water and mate again if do not match then directly abandon; Mate if mate then proceed querying condition, finish up to all conditions coupling.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200910247754.6A CN102117292B (en) | 2009-12-30 | 2009-12-30 | File secondary generates and querying method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200910247754.6A CN102117292B (en) | 2009-12-30 | 2009-12-30 | File secondary generates and querying method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102117292A true CN102117292A (en) | 2011-07-06 |
| CN102117292B CN102117292B (en) | 2016-03-09 |
Family
ID=44216066
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN200910247754.6A Active CN102117292B (en) | 2009-12-30 | 2009-12-30 | File secondary generates and querying method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102117292B (en) |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103593525A (en) * | 2013-11-14 | 2014-02-19 | 信利半导体有限公司 | Secondary processing method and device of DFM analysis report |
| CN105117431A (en) * | 2015-08-07 | 2015-12-02 | 北京思特奇信息技术股份有限公司 | Dynamic configuration method and system for external imported data |
| CN105930178A (en) * | 2015-11-12 | 2016-09-07 | 中国银联股份有限公司 | Configurable parameter dynamic loading method and system |
| CN106156075A (en) * | 2015-03-31 | 2016-11-23 | 中国科学院声学研究所 | A kind of report generation and the method and device of displaying |
| CN106446235A (en) * | 2016-10-10 | 2017-02-22 | Tcl集团股份有限公司 | Video searching method and device |
| CN108418703A (en) * | 2018-01-10 | 2018-08-17 | 北京思特奇信息技术股份有限公司 | A kind of method for early warning and system based on real-time event detecting |
| CN108932237A (en) * | 2017-05-22 | 2018-12-04 | 上海掌门科技有限公司 | Method and apparatus Watch list inquiry and obtained |
| CN109241040A (en) * | 2017-07-10 | 2019-01-18 | 北京京东尚科信息技术有限公司 | The method and apparatus of data cleansing |
| CN114896467A (en) * | 2022-04-24 | 2022-08-12 | 北京月新时代科技股份有限公司 | Neural network-based field matching method and intelligent data entry method |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101118549A (en) * | 2007-09-05 | 2008-02-06 | 中国移动通信集团福建有限公司 | Data enquire method |
-
2009
- 2009-12-30 CN CN200910247754.6A patent/CN102117292B/en active Active
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101118549A (en) * | 2007-09-05 | 2008-02-06 | 中国移动通信集团福建有限公司 | Data enquire method |
Cited By (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103593525A (en) * | 2013-11-14 | 2014-02-19 | 信利半导体有限公司 | Secondary processing method and device of DFM analysis report |
| CN106156075B (en) * | 2015-03-31 | 2019-08-02 | 中国科学院声学研究所 | A kind of method and device of report generation and displaying |
| CN106156075A (en) * | 2015-03-31 | 2016-11-23 | 中国科学院声学研究所 | A kind of report generation and the method and device of displaying |
| CN105117431A (en) * | 2015-08-07 | 2015-12-02 | 北京思特奇信息技术股份有限公司 | Dynamic configuration method and system for external imported data |
| CN105930178A (en) * | 2015-11-12 | 2016-09-07 | 中国银联股份有限公司 | Configurable parameter dynamic loading method and system |
| CN105930178B (en) * | 2015-11-12 | 2018-12-28 | 中国银联股份有限公司 | A kind of configurable dynamic state of parameters stowage and system |
| CN106446235A (en) * | 2016-10-10 | 2017-02-22 | Tcl集团股份有限公司 | Video searching method and device |
| CN108932237A (en) * | 2017-05-22 | 2018-12-04 | 上海掌门科技有限公司 | Method and apparatus Watch list inquiry and obtained |
| CN109241040A (en) * | 2017-07-10 | 2019-01-18 | 北京京东尚科信息技术有限公司 | The method and apparatus of data cleansing |
| CN109241040B (en) * | 2017-07-10 | 2021-05-25 | 北京京东尚科信息技术有限公司 | Data cleaning method and device |
| CN108418703A (en) * | 2018-01-10 | 2018-08-17 | 北京思特奇信息技术股份有限公司 | A kind of method for early warning and system based on real-time event detecting |
| CN114896467A (en) * | 2022-04-24 | 2022-08-12 | 北京月新时代科技股份有限公司 | Neural network-based field matching method and intelligent data entry method |
| CN114896467B (en) * | 2022-04-24 | 2024-02-09 | 北京月新时代科技股份有限公司 | Neural network-based field matching method and data intelligent input method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102117292B (en) | 2016-03-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102117292A (en) | File secondary generation and query method | |
| CN111367976B (en) | Method and device for exporting EXCEL file data based on JAVA reflection mechanism | |
| CN101908015B (en) | Device and method for creating test case based on components | |
| CN107463376A (en) | The method and device for automatically generating back end interface document based on Javadoc | |
| CN109657215A (en) | Document structure tree method, equipment, storage medium and device based on template | |
| CN104700169A (en) | Method and system for inspecting and managing invoices | |
| CN101702218B (en) | Information sending method applied to enterprise resource planning ERP and device | |
| CN109726388A (en) | Pdf document analytic method, device, equipment and computer readable storage medium | |
| CN101814052A (en) | Automatic test method | |
| CN106327100A (en) | Change list generation method and device | |
| CN103077192B (en) | A kind of data processing method and system thereof | |
| CN104915297A (en) | APP electricity consumption automatic test method for android device | |
| CN201435074Y (en) | Device for generating test case based on member | |
| CN112464632A (en) | Form style dynamic storage and conversion method under excel report | |
| CN106407172A (en) | XML (Extensible Markup Language)-based report generating method | |
| CN101751436A (en) | Method and system for generating reports | |
| CN110019970A (en) | Inventory downloads template creation method, device, terminal and readable storage medium storing program for executing | |
| MX2007011983A (en) | Method, system, and computer program product for electronic messaging. | |
| CN107798459A (en) | Parameter values computational methods, device, storage medium and computer equipment | |
| CN112214473B (en) | Data migration method and system between databases | |
| CN111556039B (en) | Web data export method and device for general microservice | |
| CN108536660A (en) | A kind of generation method and terminal of self-defined report | |
| CN106296131A (en) | WYSIWYG document approval system and document approval method | |
| CN112258151B (en) | Pampas-based account checking method, device, computer equipment and storage medium | |
| CN108228688B (en) | Template generation method, system and server based on XBRL |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |