CN103699544B - The method and system of cross-page selection data - Google Patents
The method and system of cross-page selection data Download PDFInfo
- Publication number
- CN103699544B CN103699544B CN201210367263.7A CN201210367263A CN103699544B CN 103699544 B CN103699544 B CN 103699544B CN 201210367263 A CN201210367263 A CN 201210367263A CN 103699544 B CN103699544 B CN 103699544B
- Authority
- CN
- China
- Prior art keywords
- data
- page
- chosen
- row
- acquisition system
- 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
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/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/38—Creation or generation of source code for implementing user interfaces
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- Human Computer Interaction (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
A kind of method of cross-page selection data, comprises the following steps：The data row that acquisition is chosen in current page；Obtain trigger action；Judge whether the trigger action is page turn over operation, if so, then carry out page turning, and preserve data row that current page chooses to database, then using the page turning as new current page, return to the step for obtaining the data row chosen in current page；If it is not, then perform corresponding function according to the trigger action, and preserve data row that current page chooses to database.Additionally, additionally providing a kind of system of cross-page selection data.The method and system of above-mentioned cross-page selection data, the data row chosen of current page is just preserved in page turning or when performing corresponding function, is not required to choose once then perform and is once preserved operation, reduces the number of times for preserving and operating, and improves computer processing performance.
Description
Technical field
The present invention relates to computer software fields, more particularly to a kind of method and system of cross-page selection data.
Background technology
In the data display of information system, there are the need that the specific data for being distributed in the different pages are carried out with batch operation
Ask, such as：Page turning is carried out after first page chooses certain row, other rows are chosen in second page, then to being selected in first page and second page
In row carry out batch examination ＆ verification, delete, disable, setting a property, send short message, mail, batch under push away document etc. operation.
However, traditional most information system does not do cross-page selection data, the data only chosen to current page are carried out
Operation；There is cross-page selection function for some information systems, typically take and choose data line just to preserve once to choose shape
State, moves back and the mode of preservation state is discharged when selecting data line is processed, and so frequently chooses on data line or move back choosing,
If data volume can influence computer processing performance when big, and the state that will be chosen is stored in client or server buffer, accounts for
With more client or server resource, because client environment is changeable, selected state data may be caused unstable.
The content of the invention
Based on this, it is necessary to cause the problem that computer processing performance declines for frequently preservation selection data, there is provided one
The method for planting the cross-page selection data that can improve treatment effeciency.
Additionally, there is a need to for the problem that frequently preservation selection data cause computer processing performance to decline, there is provided one
The system for planting the cross-page selection data that can improve treatment effeciency.
A kind of method of cross-page selection data, comprises the following steps：
The data row that acquisition is chosen in current page；
Obtain trigger action；
Judge whether the trigger action is page turn over operation, if so, then carrying out page turning, and preserve the data that current page is chosen
Row returns to the step for obtaining the data row chosen in current page to database, then using the page turning as new current page；If
It is no, then corresponding function is performed according to the trigger action, and preserve data row that current page chooses to database.
Wherein in one embodiment, performing corresponding function according to the trigger action, and preserve current page and choose
Data row to after database, also include：
Judge whether that the data row that will be chosen saves as data acquisition system, if so, then preserving the data set in database
Close, if it is not, then exit using when delete database in preserve the data row chosen.
Wherein in one embodiment, the step for obtaining the data row chosen in current page includes：
The Major key of the data row that acquisition is chosen in current page；
It is described to include the step of the data acquisition system is preserved in database：
Produce data acquisition system mark；
The corresponding relation set up between the data acquisition system mark and the Major key of the data row chosen, and will be described
Corresponding relation is preserved in the database.
Wherein in one embodiment, it is described preserve the data acquisition system in database the step of after, also include
Step：
The data acquisition system that acquisition is chosen；
Show the data row in the data acquisition system；
To the data row perform function operation in the data acquisition system.
Wherein in one embodiment, set up data acquisition system mark and the data row chosen Major key it
Between corresponding relation, and by the corresponding relation preserve in the database after, also including step：
Associated information data table and relation database table is created in database, described information tables of data is used to record institute
There is the Major key of data row, the Major key that the relation database table is used to record the data row chosen is right with what data acquisition system was identified
Should be related to；
Obtain data display request；
Data row in selected state is determined from information data table and relation database table according to the displaying request；
Show the selected state of all data rows and the data row chosen.
A kind of system of cross-page selection data, including：
Acquisition module, for obtaining the data row chosen in current page；
Trigger module, for obtaining trigger action；
Judge module, for judging whether the trigger action is page turn over operation；
Page module, for when I is page turn over operation in the trigger action, carrying out page turning；
Memory module, for when page turning is carried out, preserves data row that current page chooses to database；
The acquisition module be additionally operable to using page turning as after new current page, the data that acquisition is chosen in new current page
OK；
Performing module, for when the trigger action is not page turn over operation, being performed according to the trigger action corresponding
Function；
The memory module is additionally operable to, when corresponding function is performed according to the trigger action, preserve what current page was chosen
Data row is to database.
Wherein in one embodiment, the system of the cross-page selection data also includes removing module, the judge module
The data row that preservation current page is chosen when the memory module performs corresponding function according to the trigger action is additionally operable to arrive
After database, further determine whether that the data row that will be chosen saves as data acquisition system, if so, the memory module is additionally operable to
The data acquisition system is stored in the database, if it is not, then the removing module is used to delete database when application is exited
The data row chosen of middle preservation.
Wherein in one embodiment, the acquisition module is additionally operable to obtain the major key of the data row chosen in current page
Value；
The memory module includes：
Generation unit, for producing data acquisition system to identify；
Relation sets up unit, and for setting up, the data acquisition system mark is corresponding with the Major key of the data row chosen to close
System；
Memory cell, for the corresponding relation to be preserved in the database.
Wherein in one embodiment, the system of the cross-page selection data also includes：
Module is chosen, for obtaining the data acquisition system chosen；
Display module, for showing the data row in the data acquisition system；
The performing module is additionally operable to perform corresponding feature operation to the data row in the data acquisition system.
Wherein in one embodiment, the system of the cross-page selection data also includes：
Creation module, for creating associated information data table and relation database table, described information number in database
It is used to record the Major key of all data rows according to table, the relation database table is used to record the Major key and number of the data row chosen
According to the corresponding relation of set identification；
Request module, for obtaining data display request；
Enquiry module, for determining to be in from information data table and relation database table to choose shape according to the displaying request
The data row of state；
Display module, the selected state for showing all data rows and the data row chosen.
The method and system of above-mentioned cross-page selection data, just preserves current page and chooses in page turning or when performing corresponding function
Data row, be not required to choose once then perform once preserve operation, reduce preserve operation number of times, improve computer disposal
Performance.
Brief description of the drawings
Fig. 1 is the method flow schematic diagram of cross-page selection data in one embodiment；
Fig. 2 is the method flow schematic diagram of cross-page selection data in another embodiment；
The particular flow sheet of Fig. 3 in database to preserve data acquisition system in one embodiment the step of；
Fig. 4 be one embodiment in call preservation data acquisition system particular flow sheet；
Fig. 5 is the method flow schematic diagram of cross-page selection data in another embodiment；
Fig. 6 is the internal structure schematic diagram of the system of cross-page selection data in one embodiment；
Fig. 7 is the internal structure schematic diagram of the system of cross-page selection data in another embodiment；
Fig. 8 is the internal structure schematic diagram of acquisition module in one embodiment；
Fig. 9 is the internal structure schematic diagram of the system of cross-page selection data in another embodiment.
Specific embodiment
The technical scheme of the method and system of cross-page selection data is carried out with reference to specific embodiment combination accompanying drawing
Detailed description, so that it is clearer.
As shown in figure 1, in one embodiment, a kind of method of cross-page selection data is comprised the following steps：
Step S110, the data row that acquisition is chosen in current page.
First, information system need to be signed in, into data maintenance interface, then user is obtained at the data maintenance interface again
The data row chosen in current page by the input equipment such as mouse or button or touch-screen.Current page refers to be shown to user
The place page checked.The corresponding client of information system can be browser（IE or Firefox etc.）Or application program（Such as VB, C++
Deng）.The data row chosen is obtained in sometime point, for browser, client script Ajax can be used（Asynchronous
JavaScript and XML, interaction network page application）Preserve, for application program, can newly-built thread preserved.Ajax's
Core is JavaScript object XmlHttpRequest, and JavaScript can be used to server by XmlHttpRequest
Response is filed a request and processes, without blocked user.
In one embodiment, step S110 is specially：The Major key of the data row that acquisition is chosen in current page.Specifically
, Major key is the unique mark for distinguishing each data row.
Step S120, obtains trigger action.
Specifically, the trigger action can be page turn over operation or feature operation.Feature operation includes batch duplicating, sends short
Letter, transmission mail etc., but not limited to this.
Step S130, judges whether trigger action is page turn over operation, if so, step S140 is performed, if it is not, performing step
S150.Step S140, carries out page turning, and preserves data row that current page chooses to database, then using page turning as new current
Page, is then back to step S110.
Specifically, page turning reaches lower one page, and data row that current page chooses is preserved simultaneously in database, will can choose
The Major key of data row be saved in database.Page turning refers to that this is next after page turning reaches lower one page as new current page
Page turns into new current page.
Step S150, corresponding function is performed according to trigger action, and preserves data row that current page chooses to database.
Specifically, trigger action is not page turn over operation, then it represents that directly carry out feature operation in current page, perform corresponding
Function, such as batch duplicating, transmission short message, transmission mail.The data that current page is chosen are preserved while perform function is operated
Row arrives database.
Acquisition and preservation for Major key can be obtained, and submit to database by taking browser as an example by script function
Preserved.Such as script function code is as follows：
Above-mentioned code can be regarded as：When user clicks on the button of entitled btnSavechk, the entitled chkid of program pass
Check box, if check box be selected state（checked）, then the value of check box is preserved（That is the Major key of data row）, number
A character string with CSV is constituted according to capable Major key.The Major key of the data row that will be chosen is submitted to
HandlerChk.ashx functions treatment, HandlerChk.ashx functions are service end treatment files, perform SQL
（Structured Query Language, SQL）Realization is saved in the Major key chosen in database.This
Outward, obtain data row Major key and be stored in database can be by the language reality such as primary JavaScript language, VB, C++
It is existing.
The method of above-mentioned cross-page selection data, the data that current page is chosen just are preserved in page turning or when performing corresponding function
OK, it is not required to choose once perform and once preserves operation, reduce the number of times for preserving operation, improves computer processing performance.
As shown in Fig. 2 in one embodiment, a kind of method of cross-page selection data, including：
Step S110, the data row that acquisition is chosen in current page.
Step S120, obtains trigger action.
Step S130, judges whether trigger action is page turn over operation, if so, step S140 is performed, if it is not, performing step
S150。
Step S140, carries out page turning, and preserves the data row that current page chooses and work as to database, then using page turning as new
Preceding page, is then back to step S110.
Step S150, corresponding function is performed according to trigger action, and preserves data row that current page chooses to database.
Step S160, judges whether that the data row that will be chosen saves as data acquisition system, if so, step S170 is performed, if it is not,
Perform step S180.Step S170, preserves the data acquisition system in database.
Step S180, exit using when delete database in preserve the data row chosen.
Specifically, it refers to the program for exiting the perform function operation of selection data row to exit application.
Whether above-mentioned cross-page selection data method, data acquisition system is saved as by the data row for judging to choose, if preserving
It is data acquisition system, when convenient next time operates same data row, is not required to choose again again, the data set can be directly invoked
Close, check the data row chosen in the data acquisition system, then directly carry out feature operation.
Additionally, corresponding data row can be chosen according to different service neededs, data acquisition system is then saved as, can preserved
Multiple data acquisition systems, it is for selection to call.
As shown in figure 3, in one embodiment, it is above-mentioned to include the step of preservation data acquisition system in database：
Step S171, produces data acquisition system mark.
Specifically, after data row is chosen, preservation being provided with maintenance of information interface and currently choosing data behavioral data collection
The button of conjunction, by obtaining the trigger action to the button, the display information input frame on maintenance of information interface obtains user and exists
The information such as the data acquisition system title, the data acquisition system description that are input into information input frame, preserve the data acquisition system title to database
In, produce data acquisition system mark, data acquisition system mark to represent the uniqueness of data acquisition system in database.Data acquisition system is identified
Can as needed define, such as by prefix serial number can be added to constitute, first data acquisition system is designated FA0000001, second
Data acquisition system is designated FA0000002, incremented by successively etc., but not limited to this.Step S173, set up the data acquisition system mark with
Corresponding relation between the Major key of the data row chosen, and the corresponding relation is preserved in the database.
Specifically, setting up corresponding relation between the Major key of the data row that data acquisition system is identified and chosen, for example, choose
Data row Major key be 001,003, data acquisition system is designated FA0000001, can set up respectively 001 and 003 with
The corresponding relation of FA0000001, preserves the corresponding relation as a data acquisition system.The Major key of the data row for example chosen
It is 001,002, data acquisition system is designated FA0000002, can respectively sets up the corresponding relation of 001 and 002 and FA0000002, and
Preserved the corresponding relation as a data acquisition system.
The corresponding relation that the Major key of the data row chosen by foundation is identified with data acquisition system, record data set, note
The data structure of record is simple.
Additionally, corresponding relation is stored in the pass of foundation between the Major key of the data row that data acquisition system can be identified and chosen
It is in tables of data, the particular content description of data acquisition system to be stored in data acquisition system table, and two tables of data are associated.
Wherein, association sets up corresponding relation.
Additionally, recording the data of all data rows by information data table；By relation database table record data set mark
Corresponding relation between the Major key of the data row known and choose；Record data acquisition system is marked by data acquisition system and identifies corresponding retouching
State information.
If information data table is only supported to save as a kind of data acquisition system, " can preserve current user's click is got
Choose the set of data behavioral data " button when produce data acquisition system mark.
If information data table is supported to save as various data acquisition systems, produced when selected line carries out page turning or feature operation
Data acquisition system is identified, after carrying out page turning or feature operation, the data row that will be chosen（Such as 2 row data, Major key is respectively 001,
002）It is saved in database, specifically includes：（1）A data set identification is inserted in data acquisition system table, such as：FA0000001；
（2）2 records are inserted in relation database table simultaneously, the corresponding relation of 001,002 and FA0000001 is set up respectively.If obtain using
The button of " preserve and currently choose the set of data behavioral data " is clicked at family, after obtaining user input name set, set description, is
Unite and data acquisition system title, data acquisition system description renewal are designated the row of FA0000001 to data acquisition system in data acquisition system table；If
Data acquisition system is not saved as into scheme, then exit apply when, system is automatically deleted the note of FA0000001 in data acquisition system table
Record, while 2 records inserted in deleting relation database table.
As shown in figure 4, in one embodiment, the method for above-mentioned cross-page selection data preserves the number in database
According to set the step of after, also including the data acquisition system for calling preservation the step of, specifically include：
Step S210, the data acquisition system that acquisition is chosen.
Specifically, into behind maintenance of information interface, required data acquisition system is selected in the multiple data acquisition systems for preserving.
Step S220, the data row in display data set.
Specifically, the data row in the data acquisition system that will be chosen all shows.
Step S230, to the data row perform function operation in data acquisition system.
Specifically, can batch in the data acquisition system data row perform function operation.Feature operation refers to multiple batch
System, transmission short message, transmission mail etc..
As shown in figure 5, in one embodiment, the method for above-mentioned cross-page selection data is setting up the data acquisition system mark
Know and the corresponding relation between the Major key of the data row chosen, and the corresponding relation is preserved in the database
Afterwards, also including step：
Step S310, creates associated information data table and relation database table in database, and the information data table is used
In the Major key for recording all data rows, the relation database table is used to record the Major key and data acquisition system mark of the data row chosen
The corresponding relation of knowledge.
Specifically, information data table includes primary key column, name column and description row, primary key column is used to record all data rows
Major key, name column is used to recording the title of each data row, and description row the title of data row and are retouched for the description to title
State be Major key to data row supplementary notes.As shown in table 1, in primary key column, Major key is 001, corresponding entitled visitor
Family 1, description column information illustrates there is corresponding relation with the primary key column of a line, name column and description row for the information of client 1.
Table 1
Relation database table includes that foreign key column and data set identification are arranged, and foreign key column is used to record the major key for choosing data row
Value, data acquisition system identity column is identified for record data set.With the Major key and data acquisition system mark of a line in relation database table
There is corresponding relation in knowledge.As shown in table 2, external key train value is 001, and corresponding data set identification is classified as FA0000001.
Table 2
The effect of external key is to be associated information data table with relation database table, the data row chosen recorded in foreign key column
Major key it is identical with the Major key in information data table, represent the Major key corresponding data behavior choosing in information data table
Middle state.
Data acquisition system identifies corresponding particular content, marks to record by data acquisition system.Data acquisition system table includes primary key column, name
Claim row and description row.The primary key column record data set mark of data acquisition system table, name column record data set title, description row
The information of record data set.As shown in table 3.
Table 3
| Primary key column | Title | Description row |
| FA0000001 | Data acquisition system 1 | Buy the potential customers of A products |
| FA0000002 | Data acquisition system 2 | Buy the potential customers of B products |
Step S320, obtains data display request.
Step S330, the number in selected state is determined according to displaying request from information data table and relation database table
According to row.
Specifically, information data table have recorded the Major key of all data rows, relation database table have recorded chooses data row
Major key, by compare, it may be determined that choose data row in information data table.Looked into by information data table and relation database table
Inquiry can determine that the data row of selected state, be not required to the record storage in internal memory, or the data row storage that will be chosen in client or
On server, occupying for resource is reduced.
Step S340, shows the selected state of all data rows and the data row chosen.
Specifically, the data row that displaying is chosen can be identified by predetermined flag, to distinguish unchecked data row.
As shown in fig. 6, in one embodiment, a kind of system of cross-page selection data includes acquisition module 110, trigger mode
Block 120, judge module 130, page module 140, memory module 150 and performing module 160.Wherein：
Acquisition module 110 is used to obtain the data row chosen in current page.
First, information system need to be signed in, into data maintenance interface, then by acquisition module 110 in the data maintenance
Interface obtains the data row that user is chosen by the input equipment such as mouse or button or touch-screen in current page.Current page is to criticize
It is being shown to the place page that user checks.The corresponding client of information system can be browser（IE or Firefox etc.）Or application
Program（Such as VB, C++）.The data row chosen is obtained in sometime point, for browser, client script Ajax can be used
（Asynchronous JavaScript and XML, interaction network page application）Preserve, for application program, can newly-built thread
Preserved.The core of Ajax is JavaScript object XmlHttpRequest, be can be used by XmlHttpRequest
JavaScript files a request to server and processes response, without blocked user.
In one embodiment, acquisition module 110 is additionally operable to obtain the Major key of the data row chosen in current page.Specifically
, Major key is the unique mark for distinguishing each data row.
Trigger module 120 is used to obtain trigger action.Specifically, the trigger action can be page turn over operation or feature operation.
Feature operation includes batch duplicating, transmission short message, transmission mail etc., but not limited to this.
Judge module 130 is used to judge whether the trigger action is page turn over operation.
Page module 140 is for when I is page turn over operation in trigger action, carrying out page turning.Specifically, page module 140 is turned over
Page reaches lower one page.
Memory module 150 is used for when page turning is carried out, the data row that preservation current page is chosen to database.Specifically, depositing
Storage module 150 preserves the data row chosen of current page in database, the number that will can be chosen under page turning arrival while one page
It is saved in database according to capable Major key.
Acquisition module 110 be additionally operable to using page turning as after new current page, the data that acquisition is chosen in new current page
OK.
Performing module 160 is used to, when trigger action is not page turn over operation, corresponding function is performed according to trigger action.Tool
Body, trigger action is not page turn over operation, then it represents that directly carry out feature operation in current page, performs corresponding function, is such as criticized
Amount replicates, sends short message, sends mail etc..The data row chosen of current page to data is preserved while perform function is operated
Storehouse.
Memory module 150 is additionally operable to, when corresponding function is performed according to the trigger action, preserve what current page was chosen
Data row is to database.
Additionally, the acquisition and preservation for Major key can be obtained, and submit to number by taking browser as an example by script function
Preserved according to storehouse.Script function code will not be repeated here as described in method.
The system of above-mentioned cross-page selection data, the data that current page is chosen just are preserved in page turning or when performing corresponding function
OK, it is not required to choose once perform and once preserves operation, reduce the number of times for preserving operation, improves computer processing performance.
As shown in fig. 7, in one embodiment, the system of above-mentioned cross-page selection data, except including acquisition module 110,
Trigger module 120, judge module 130, page module 140, memory module 150 and performing module 160, also including removing module
170th, module 180 and display module 190 are chosen.
Judge module 130 is additionally operable to be preserved when memory module 150 performs corresponding function according to the trigger action works as
The data row that preceding page is chosen further determines whether that the data row that will be chosen saves as data acquisition system to after database, if so,
Memory module 150 is additionally operable to store the data acquisition system in the database, if it is not, then removing module 170 is used to exit
Using when delete database in preserve the data row chosen.
Choose module 180 for obtain the data acquisition system chosen.Specifically, into behind maintenance of information interface, what is preserved
Required data acquisition system is selected in multiple data acquisition systems.
Display module 190 is used to show the data row in the data acquisition system.Specifically, in the data acquisition system that will be chosen
Data row all shows.
Performing module 160 is additionally operable to perform corresponding feature operation to the data row in the data acquisition system.Specifically, can criticize
That measures operates to the data row perform function in the data acquisition system.Feature operation refers to batch duplicating, sends short message, sends mail
Deng.
Whether above-mentioned cross-page selection data system, data acquisition system is saved as by the data row for judging to choose, if preserving
It is data acquisition system, when convenient next time operates same data row, is not required to choose again again, the data set can be directly invoked
Close, check the data row chosen in the data acquisition system, then directly carry out feature operation.
As shown in figure 8, in one embodiment, acquisition module 110 is additionally operable to the data row that acquisition is chosen in current page
Major key；
Memory module 150 sets up unit 153 and memory cell 155 including generation unit 151, relation.Wherein：
Generation unit 151 is used to produce data acquisition system to identify.
Specifically, after data row is chosen, preservation being provided with maintenance of information interface and currently choosing data behavioral data collection
The button of conjunction, by obtaining the trigger action to the button, the display information input frame on maintenance of information interface obtains user and exists
The information such as the data acquisition system title, the data acquisition system description that are input into information input frame, preserve the data acquisition system title to database
In, produce data acquisition system mark, data acquisition system mark to represent the uniqueness of data acquisition system in database.Data acquisition system is identified
Can as needed define, such as by prefix serial number can be added to constitute, first data acquisition system is designated FA0000001, second
Data acquisition system is designated FA0000002, incremented by successively etc., but not limited to this.Relation sets up unit 153 for setting up data set
Close the corresponding relation between the Major key of mark and the data row chosen.
Specifically, setting up corresponding relation between the Major key of the data row that data acquisition system is identified and chosen, for example, choose
Data row Major key be 001,003, data acquisition system is designated FA0000001, can set up respectively 001 and 003 with
The corresponding relation of FA0000001, preserves the corresponding relation as a data acquisition system.The Major key of the data row for example chosen
It is 001,002, data acquisition system is designated FA0000002, can respectively sets up the corresponding relation of 001 and 002 and FA0000002, and
Preserved the corresponding relation as a data acquisition system.The Major key of the data row chosen by foundation is identified with data acquisition system
Corresponding relation, record data set, the data structure of record is simple.
Memory cell 155 is used to preserve the corresponding relation in the database.
Additionally, recording the data of all data rows by information data table；By relation database table record data set mark
Corresponding relation between the Major key of the data row known and choose；Record data acquisition system is marked by data acquisition system and identifies corresponding retouching
State information.
If information data table is only supported to save as a kind of data acquisition system, " can preserve current user's click is got
Choose the set of data behavioral data " button when produce data acquisition system mark.
If information data table is supported to save as various data acquisition systems, produced when selected line carries out page turning or feature operation
Data acquisition system is identified, after carrying out page turning or feature operation, the data row that will be chosen（Such as 2 row data, Major key is respectively 001,
002）It is saved in database, specifically includes：（1）A data set identification is inserted in data acquisition system table, such as：FA0000001,
（2）2 records are inserted in relation database table simultaneously, the corresponding relation of 001,002 and FA0000001 is set up respectively.If obtain using
The button of " preserve and currently choose the set of data behavioral data " is clicked at family, after obtaining user input name set, set description, is
Unite and data acquisition system title, data acquisition system description renewal are designated the row of FA0000001 to data acquisition system in data acquisition system table；If
Data acquisition system is not saved as into scheme, then exit apply when, system is automatically deleted the note of FA0000001 in data acquisition system table
Record, while 2 records inserted in deleting relation database table.
As shown in figure 9, in one embodiment, the system of above-mentioned cross-page selection data, except including acquisition module 110,
Trigger module 120, judge module 130, page module 140, memory module 150 and performing module 160, also including creation module
210th, request module 220, enquiry module 230 and display module 240.Wherein：
Creation module 210 is used to create associated information data table and relation database table, the Information Number in database
It is used to record the Major key of all data rows according to table, the relation database table is used to record the Major key and data of the data row chosen
The corresponding relation of set identification.
Specifically, information data table includes primary key column, name column and description row, primary key column is used to record all data rows
Major key, name column is used to recording the title of each data row, and description row the title of data row and are retouched for the description to title
State be Major key to data row supplementary notes.As shown in table 1, in primary key column, Major key is 001, corresponding entitled visitor
Family 1, description column information illustrates there is corresponding relation with the primary key column of a line, name column and description row for the information of client 1.Close
It is that tables of data includes that foreign key column and data set identification are arranged, foreign key column is used to record the Major key for choosing data row, data acquisition system
Identity column is identified for record data set.There is corresponding closing with data acquisition system mark in the Major key in relation database table with a line
System.As shown in table 2, external key train value is 001, and corresponding data set identification is classified as FA0000001.The effect of external key is by Information Number
It is associated with relation database table according to table, the major key in the Major key and information data table of the data row chosen recorded in foreign key column
Value is identical, represents the corresponding data behavior selected state of the Major key in information data table.
Data acquisition system identifies corresponding particular content, marks to record by data acquisition system.Data acquisition system table includes primary key column, name
Claim row and description row.The primary key column record data set mark of data acquisition system table, name column record data set title, description row
The information of record data set.As shown in table 3.
Request module 220 is used to obtain data display request.
Enquiry module 230 is used to determine to be in from information data table and relation database table to choose according to the displaying request
The data row of state.
Specifically, information data table have recorded the Major key of all data rows, relation database table have recorded chooses data row
Major key, by compare, it may be determined that choose data row in information data table.Looked into by information data table and relation database table
Inquiry can determine that the data row of selected state, be not required to the record storage in internal memory, or the data row storage that will be chosen in client or
On server, occupying for resource is reduced.
Display module 240 is used to show the selected state of all data rows and the data row chosen.Specifically, displaying is chosen
Data row can be identified by predetermined flag, to distinguish unchecked data row.
Embodiment described above only expresses several embodiments of the invention, and its description is more specific and detailed, but simultaneously
Therefore the limitation to the scope of the claims of the present invention can not be interpreted as.It should be pointed out that for one of ordinary skill in the art
For, without departing from the inventive concept of the premise, various modifications and improvements can be made, these belong to guarantor of the invention
Shield scope.Therefore, the protection domain of patent of the present invention should be determined by the appended claims.
Claims (6)
1. a kind of method of cross-page selection data, comprises the following steps：
The Major key of the data row that acquisition is chosen in current page；
Trigger action is obtained, the trigger action is page turn over operation or feature operation；
Judge whether the trigger action is page turn over operation, if so, then carry out page turning, and preserve the data row that current page chooses and arrive
Database, then using the page turning as new current page, return to the step for obtaining the data row chosen in current page；If it is not,
Feature operation then is carried out in current page, corresponding function is performed according to the trigger action, and preserve the data that current page is chosen
Row arrives database；
Judge whether that the data row that will be chosen saves as data acquisition system, if so, then preserving the data acquisition system in database；
It is described to include the step of the data acquisition system is preserved in database：
Produce data acquisition system mark；
The corresponding relation set up between data acquisition system mark and the Major key of the data row chosen, and by the correspondence
Relation is preserved in the database；
Methods described, also includes：
Associated information data table and relation database table is created in database, described information tables of data is used to record all numbers
According to capable Major key, the relation database table is used to record the corresponding pass that the Major key of the data row chosen is identified with data acquisition system
System；
Obtain data display request；
Data row in selected state is determined from information data table and relation database table according to the displaying request；
Show the selected state of all data rows and the data row chosen.
2. it is according to claim 1 it is cross-page selection data method, it is characterised in that according to the trigger action perform
Corresponding function, and data row that current page chooses is preserved to after database, also include：
If the data row that will not choose saves as data acquisition system, exit using when delete database in preserve the number chosen
According to row.
3. it is according to claim 1 it is cross-page selection data method, it is characterised in that institute is preserved in database described
After the step of stating data acquisition system, also including step：
The data acquisition system that acquisition is chosen；
Show the data row in the data acquisition system；
To the data row perform function operation in the data acquisition system.
4. it is a kind of it is cross-page selection data system, it is characterised in that including：
Acquisition module, the Major key for obtaining the data row chosen in current page；
Trigger module, for obtaining trigger action, the trigger action is page turn over operation or feature operation；
Judge module, for judging whether the trigger action is page turn over operation；
Page module, for when the trigger action is page turn over operation, carrying out page turning；
Memory module, for when page turning is carried out, preserves data row that current page chooses to database；
The acquisition module be additionally operable to using page turning as after new current page, the data row that acquisition is chosen in new current page；
Performing module, for when the trigger action is not page turn over operation, corresponding function being performed according to the trigger action；
The memory module is additionally operable to carry out feature operation in current page, when performing corresponding function according to the trigger action,
Preserve the data row chosen of current page to database；
The judge module is additionally operable to preserve current when the memory module performs corresponding function according to the trigger action
The data row chosen of page further determines whether that the data row that will be chosen saves as data acquisition system, if so, institute to after database
State memory module and be additionally operable to store the data acquisition system in the database；
The memory module includes：
Generation unit, for producing data acquisition system to identify；
Relation sets up unit, the Major key corresponding relation for setting up the data acquisition system mark and the data row chosen；
Memory cell, for the corresponding relation to be preserved in the database；
The system, also includes：
Creation module, for creating associated information data table and relation database table, described information tables of data in database
Major key for recording all data rows, the relation database table is used to record the Major key and data set of the data row chosen
Close the corresponding relation of mark；
Request module, for obtaining data display request；
Enquiry module, for being determined in selected state from information data table and relation database table according to the displaying request
Data row；
Display module, the selected state for showing all data rows and the data row chosen.
5. it is according to claim 4 it is cross-page selection data system, it is characterised in that it is described it is cross-page selection data system
Also including removing module, if the data row for will not choose saves as data acquisition system, database is deleted when application is exited
The data row chosen of middle preservation.
6. it is according to claim 4 it is cross-page selection data system, it is characterised in that it is described it is cross-page selection data system
Also include：
Module is chosen, for obtaining the data acquisition system chosen；
Display module, for showing the data row in the data acquisition system；
The performing module is additionally operable to perform corresponding feature operation to the data row in the data acquisition system.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210367263.7A CN103699544B (en) | 2012-09-27 | 2012-09-27 | The method and system of cross-page selection data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210367263.7A CN103699544B (en) | 2012-09-27 | 2012-09-27 | The method and system of cross-page selection data |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103699544A CN103699544A (en) | 2014-04-02 |
| CN103699544B true CN103699544B (en) | 2017-05-31 |
Family
ID=50361075
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210367263.7A Active CN103699544B (en) | 2012-09-27 | 2012-09-27 | The method and system of cross-page selection data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103699544B (en) |
Families Citing this family (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106201224A (en) * | 2015-05-05 | 2016-12-07 | 阿里巴巴集团控股有限公司 | The method and device that a kind of batch data processes |
| CN105260394A (en) * | 2015-09-15 | 2016-01-20 | 广州视睿电子科技有限公司 | web cross-page data selection method and system |
| CN106776970A (en) * | 2016-12-05 | 2017-05-31 | 金蝶软件（中国）有限公司 | Web narration book page turn over operation method and apparatus |
| CN108304112B (en) * | 2017-01-13 | 2020-10-13 | 北京国双科技有限公司 | Data processing method and device |
| CN110597435B (en) * | 2019-09-05 | 2021-01-01 | 北京蒙奇迪科技发展有限公司 | Cross-page checking system and method |
| CN111309985B (en) * | 2020-03-10 | 2023-08-25 | 支付宝(杭州)信息技术有限公司 | High-dimensional vector storage method and device based on PostgreSQL database |
| CN111460187B (en) * | 2020-04-01 | 2023-06-30 | 重庆金山医疗技术研究院有限公司 | Picture labeling method, device, equipment and readable storage medium |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1929488A (en) * | 2006-10-08 | 2007-03-14 | 华为技术有限公司 | Method and device for operation in multiple pages based on server paging |
| CN101894105A (en) * | 2009-05-19 | 2010-11-24 | 苏州市易达信息系统有限公司 | Level 2 cache WEB table paging check memorizing method |
Family Cites Families (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| GB2316207B (en) * | 1993-07-29 | 1998-05-20 | Fujitsu Ltd | Data processor having page turning function for managing a plurality of data sets |
| US8707174B2 (en) * | 2010-02-25 | 2014-04-22 | Microsoft Corporation | Multi-screen hold and page-flip gesture |
| CN102043823A (en) * | 2010-09-27 | 2011-05-04 | 深圳市五巨科技有限公司 | Method and device for flexibly selecting and gathering fields in dynamic pages |
| CN102521296A (en) * | 2011-11-30 | 2012-06-27 | 向进轮 | Method for screening data items in separated pages of web page |
-
2012
- 2012-09-27 CN CN201210367263.7A patent/CN103699544B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1929488A (en) * | 2006-10-08 | 2007-03-14 | 华为技术有限公司 | Method and device for operation in multiple pages based on server paging |
| CN101894105A (en) * | 2009-05-19 | 2010-11-24 | 苏州市易达信息系统有限公司 | Level 2 cache WEB table paging check memorizing method |
Non-Patent Citations (2)
| Title |
|---|
| GridView跨页多选;Jack G;《博客园http://cnblogs.com/Jack_G/archive/2012/05/02/2479145.html》;20120502;第1-4页 * |
| Java checkbox实现跨页多选;北极悠蓝的技术博客;《ITeye技术网站 http://kevin19900306.iteye.com/blog/1184047》;20110930;网页正文第1-2页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103699544A (en) | 2014-04-02 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103699544B (en) | The method and system of cross-page selection data | |
| CN107784026B (en) | ETL data processing method and device | |
| TW201737072A (en) | Application program project evaluation method and system | |
| JP6514244B2 (en) | Difference detection device and program | |
| US8775423B2 (en) | Data mining across multiple social platforms | |
| CN106528894B (en) | The method and device of label information is set | |
| CN109635276B (en) | Information matching method and terminal | |
| KR102018445B1 (en) | Compression of cascading style sheet files | |
| CN104423982B (en) | The processing method and processing equipment of request | |
| CN106533921A (en) | Rapid filing method and system based on E-mail information | |
| CN109688205A (en) | The hold-up interception method and device of web page resources | |
| CN104077392B (en) | Reminding method and device are suggested in a kind of search | |
| CN110362826A (en) | Periodical submission method, equipment and readable storage medium storing program for executing based on artificial intelligence | |
| CN106610932A (en) | Corpus processing method and device and corpus analyzing method and device | |
| CN111046083A (en) | Data analysis method and system and big data platform | |
| CN104166659A (en) | Method and system for map data duplication judgment | |
| CN110597789B (en) | Automatic generation method, device and equipment of architecture diagram and computer readable storage medium | |
| CN107784588A (en) | Insurance user information merging method and device | |
| CN104240107A (en) | Community data screening system and method thereof | |
| CN116155597A (en) | Access request processing method and device and computer equipment | |
| CN103312584A (en) | Method and apparatus for releasing information in network community | |
| CN104142885B (en) | A kind of method and apparatus for carrying out abnormality test to tested program | |
| CN104866545A (en) | Method for searching keywords on information display page | |
| CN103778210A (en) | Method and device for judging specific file type of file to be analyzed | |
| CN104239455B (en) | The acquisition methods and device of a kind of search result |
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 |