Table sorting method and system based on jQuery

Abstract

The invention relates to a table sorting method and system based on jQuery. The method comprises the steps of: calling a background service, and displaying data returned by the backstage service in a table in a tabular form; selecting a sorting manner and a to-be-sorted data column according to the requirements; and extracting data in the to-be-sorted data column, sorting the extracted data column in a corresponding sorting manner according to a pre-defined algorithm, and carrying out corresponding position exchange on rows of the table according to a sorting result of the data. According to the sorting method provided by the invention, without arrays or intermediate quantity, the data is subjected to bubble sorting, so that a group of data can be quickly sorted in an ascending or descending order and then the sorted data is subjected to position exchange according to the positions for achieving the effect of table sorting; and the background service does not need to be subjected to any data processing, sorting inquiry also does not need to be performed when a data processing layer is accessed, the pressure of a server and a database for the background service is shared, the work is handed over to a foreground, and the foreground can carry out sorting flexibly and quickly.

Description

technical field [0001] The invention relates to the technical field of computers, in particular to a jQuery-based table sorting method and system. Background technique [0002] The prior art sorting method basically all selects the column to be sorted from the table earlier, extracts the column data to be sorted and puts it into an array, and at the same time puts the content innerHTML of each row (based on javascript ) or $obj.html() (based on jquery) and put it in another array. The elements in the two arrays are linked by an index, and then the data list is cleared. Sort the data in the array, and then add the elements in the array storing innerHTML to the table in order through the index column. The design idea of ​​this implementation method uses the index method, which is more ingenious to implement. However, the method of extracting a large amount of data and putting it into an array, and then redrawing the table class needs to waste a lot of storage resources, and t...

AI Technical Summary

Problems solved by technology

The design idea of ​​this implementation method uses the index method, which is more ingenious to implement. However, it is necessary to extract a large amount of data and put it into an array, and then redraw the table class. It needs to waste a lot of storage resources, and the implementation is complicated.

Images