jQuery表格排序(tablesorter)

时间:2022-07-18 13:21:00

1.在html页面的head中引用 <script src="/static/Bootstrap/js/jquery/jquery.tablesorter.min.js"></script>

2.在.js文件中加载tablesorter:
$("table tbody").append(html);
$("table").trigger("update"); table是js自动生成的,需要在生成时添加这句

3.在.js文件中对需要排序的表格调用tablesorter()方法:
  $('#tresult').tablesorter({headers:{0:{sorter:false}}});  #不能对第一列进行排序

$(document).ready(function() {
$("table").tablesorter();
$("#append").click(function() {
// add some html
var html = "<tr><td>Peter</td><td>Parker</td><td>28</td><td>$9.99</td><td>20%</td><td>Jul 6, 2006 8:14 AM</td></tr>";
html += "<tr><td>John</td><td>Hood</td><td>33</td><td>$19.99</td><td>25%</td><td>Dec 10, 2002 5:14 AM</td></tr><tr><td>Clark</td><td>Kent</td><td>18</td><td>$15.89</td><td>44%</td><td>Jan 12, 2003 11:14 AM</td></tr>";
html += "<tr><td>Bruce</td><td>Almighty</td><td>45</td><td>$153.19</td><td>44%</td><td>Jan 18, 2001 9:12 AM</td></tr>";
// append new html to table body
$("table tbody").append(html);
// let the plugin know that we made a update
$("table").trigger("update");
// set sorting column and direction, this will sort on the first and third column
var sorting = [[2,1],[0,0]];
// sort on the first column
$("table").trigger("sorton",[sorting]);
return false;
});
});

http://plugins.jquery.com/tablesorter/ (download tablesorter.js)

from:http://tablesorter.com/docs/example-empty-table.html#