庄周梦蝶

生活、程序、未来
   :: 首页 ::  ::  :: 聚合  :: 管理

备忘——javascript操作表格排序

Posted on 2007-03-10 17:26 dennis 阅读(6144) 评论(1)  编辑  收藏 所属分类: web开发
表格排序,一般的处理方法是传递排序的字段到后台进行重新查询并排序,javascript也可以做到简单的表格排序,备忘代码:
           //类型转换器,将列的字段类型转换为可以排序的类型:String,int,float
            function convert(sValue, sDataType) {
                
switch(sDataType) {
                    
case "int":
                        
return parseInt(sValue);
                    
case "float":
                        
return parseFloat(sValue);
                    
case "date":
                        
return new Date(Date.parse(sValue));
                    
default:
                        
return sValue.toString();
                
                }
            }
            
            
//排序函数产生器,iCol表示列索引,sDataType表示该列的数据类型
            function generateCompareTRs(iCol, sDataType) {
        
                
return  function compareTRs(oTR1, oTR2) {
                            
var vValue1 = convert(oTR1.cells[iCol].firstChild.nodeValue, sDataType);
                            
var vValue2 = convert(oTR2.cells[iCol].firstChild.nodeValue, sDataType);
        
                            
if (vValue1 < vValue2) {
                                
return -1;
                            } 
else if (vValue1 > vValue2) {
                                
return 1;
                            } 
else {
                                
return 0;
                            }
                        };
            }
            
            
//排序方法
            function sortTable(sTableID, iCol, sDataType) {
                
var oTable = document.getElementById(sTableID);
                
var oTBody = oTable.tBodies[0];
                
var colDataRows = oTBody.rows;
                
var aTRs = new Array;
                
                
//将所有列放入数组
                for (var i=0; i < colDataRows.length; i++) {
                    aTRs[i] 
= colDataRows[i];
                }
                 
                
//判断最后一次排序的列是否与现在要进行排序的列相同,是的话,直接使用reverse()逆序
                if (oTable.sortCol == iCol) {
                    aTRs.reverse();
                } 
else {
                    
//使用数组的sort方法,传进排序函数
                    aTRs.sort(generateCompareTRs(iCol, sDataType));
                }
        
                
var oFragment = document.createDocumentFragment();
                
for (var i=0; i < aTRs.length; i++) {
                    oFragment.appendChild(aTRs[i]);
                }
       
                oTBody.appendChild(oFragment);
                
//记录最后一次排序的列索引
                oTable.sortCol = iCol;
            }

完整例子:
<html>
    
<head>
    
<title>Table Sort Example</title>
        
<script type="text/javascript">
            
            
//转换器,将列的字段类型转换为可以排序的类型:String,int,float
            function convert(sValue, sDataType) {
                
switch(sDataType) {
                    
case "int":
                        
return parseInt(sValue);
                    
case "float":
                        
return parseFloat(sValue);
                    
case "date":
                        
return new Date(Date.parse(sValue));
                    
default:
                        
return sValue.toString();
                
                }
            }
            
            
//排序函数产生器,iCol表示列索引,sDataType表示该列的数据类型
            function generateCompareTRs(iCol, sDataType) {
        
                
return  function compareTRs(oTR1, oTR2) {
                            
var vValue1 = convert(oTR1.cells[iCol].firstChild.nodeValue, sDataType);
                            
var vValue2 = convert(oTR2.cells[iCol].firstChild.nodeValue, sDataType);
        
                            
if (vValue1 < vValue2) {
                                
return -1;
                            } 
else if (vValue1 > vValue2) {
                                
return 1;
                            } 
else {
                                
return 0;
                            }
                        };
            }
            
            
//排序方法
            function sortTable(sTableID, iCol, sDataType) {
                
var oTable = document.getElementById(sTableID);
                
var oTBody = oTable.tBodies[0];
                
var colDataRows = oTBody.rows;
                
var aTRs = new Array;
                
                
//将所有列放入数组
                for (var i=0; i < colDataRows.length; i++) {
                    aTRs[i] 
= colDataRows[i];
                }
                 
                
//判断最后一次排序的列是否与现在要进行排序的列相同,是的话,直接使用reverse()逆序
                if (oTable.sortCol == iCol) {
                    aTRs.reverse();
                } 
else {
                    
//使用数组的sort方法,传进排序函数
                    aTRs.sort(generateCompareTRs(iCol, sDataType));
                }
        
                
var oFragment = document.createDocumentFragment();
                
for (var i=0; i < aTRs.length; i++) {
                    oFragment.appendChild(aTRs[i]);
                }
       
                oTBody.appendChild(oFragment);
                
//记录最后一次排序的列索引
                oTable.sortCol = iCol;
            }

        
</script>
    
</head>
    
<body>
        
<p>Click on the table header to sort in ascending order.</p>
        
<table border="1" id="tblSort">
            
<thead>
                
<tr>
                    
<th onclick="sortTable('tblSort', 0)" 
                        style
="cursor:pointer">Last Name</th>
                    
<th onclick="sortTable('tblSort', 1)" 
                        style
="cursor:pointer">First Name</th>
                    
<th onclick="sortTable('tblSort', 2, 'date')" 
                        style
="cursor:pointer">Birthday</th>
                    
<th onclick="sortTable('tblSort', 3, 'int')" 
                        style
="cursor:pointer">Siblings</th>
                
</tr>
            
</thead>
            
<tbody>
                
<tr>
                    
<td>Smith</td>
                    
<td>John</td>
                    
<td>7/12/1978</td>
                    
<td>2</td>
                
</tr>
                
<tr>
                    
<td>Johnson</td>
                    
<td>Betty</td>
                    
<td>10/15/1977</td>
                    
<td>4</td>
                
</tr>
                
<tr>
                    
<td>Henderson</td>
                    
<td>Nathan</td>
                    
<td>2/25/1949</td>
                    
<td>1</td>
                
</tr>
                
<tr>
                    
<td>Williams</td>
                    
<td>James</td>
                    
<td>7/8/1980</td>
                    
<td>4</td>
                
</tr>
                
<tr>
                    
<td>Gilliam</td>
                    
<td>Michael</td>
                    
<td>7/22/1949</td>
                    
<td>1</td>
                
</tr>
                
<tr>
                    
<td>Walker</td>
                    
<td>Matthew</td>
                    
<td>1/14/2000</td>
                    
<td>3</td>
                
</tr>
            
</tbody>
        
</table>        
    
</body>
</html>


评论

# re: 备忘——javascript操作表格排序  回复  更多评论   

2012-03-15 15:43 by www
这个连续使用两次就会报错,会使浏览器崩溃的

只有注册用户登录后才能发表评论。


网站导航: