Detailed explanation of the steps to operate table with jquery

This time I will bring you a detailed explanation of the steps of jquery operating table, what are the precautions for jquery operating table, the following is a practical case, let's take a look.

Although p CSS is now popular for page layout, there are still many advantages to using table in many places. It is more convenient to use table to display data. The following is a summary of the common methods of jQuery operating Table tr td. Memorize these. Operation skills, when you use them next time, you will be like a fish in water and improve development efficiency

The following are the commonly used functions of jQuery table operations:

1. Move the mouse row Color change

$('#table1 tr').hover(function(){
    $(this).children('td').addClass('hover')
}, function(){
    $(this).children('td').removeClass('hover')
});

Method 2:

$("#table1 tr:gt(0)").hover(function() { 
    $(this).children("td").addClass("hover"); 
}, function() { 
    $(this).children("td").removeClass("hover"); 
});

2. Different colors for odd and even rows

$('#table1 tbody tr:odd').css('
background-color
', '#bbf');
$('#table1 tbody tr:even').css('background-color','#ffc');
//操作class
$("#table1 tbody tr:odd").addClass("odd");
$("#table1 tbody tr:even").addClass("even");

3.Hide one row

$('#table1 tbody tr:eq(3)').hide();
$("#table1 tr td::nth-child(3)").hide();
$("#table1 tr").each(function(){$("td:eq(3)",this).hide()});

4. Hide a column

$('#table1 tr td::nth-child(3)').hide();

5.Delete a row

// 删除除第一行外的所有行
$('#table1 tr:not(
:first
)').remove();
// 删除指定行
$('#table1 tr:eq(3)').remove();

6. Delete a column

// 删除除第一列外的所有列
$('#table1 tr th:not(:nth-child(1))').remove();
$('#table1 tr td:not(:nth-child(1))').remove();
// 删除第一列
$('#table1 tr td::nth-child(1)').remove();

7. Get (set) the value of a certain cell

// 设置table1,第2个tr的第一个td的值。  
$('#table1 tr:eq(1) td:nth-child(1)').html('value'); 
// 获取table1,第2个tr的第一个td的值。
$('#table1 tr:eq(1) td:nth-child(1)').html();

8. Insert a row

// 在第二个tr后插入一行$('<tr><td>插入3</td><td>插入</td><td>插入</td><td>插入</td></tr>').insertAfter($('#table7 tr:eq(1)'));

9. Get the value of the specified cell in each row

var arr = [];
$('#table1 tr td:nth-child(1)').each(function (key, value) {
   arr.push($(this).html());
});
var result = arr.join(',');

10. Select all or none

//方法零：
$('#all').on('click', function () {
    $('input.checkSub').prop('checked', this.checked); // 给当前一起绑定的子选择添加效果
});
//方法一：
//全选或全不选 此传入的参数为event 如：checkAll(event)
function checkAll(evt){
 evt=evt?evt:window.event;
 var chall=evt.target?evt.target:evt.srcElement;
 var tbl=$("#table1");
 var trlist=tbl.find("tr");
 for(var i=1;i<trlist.length;i++){
  var tr=$(trlist[i]);
  var input=tr.find("INPUT[type=&#39;checkbox&#39;]");
  input.attr("checked",chall.checked);
 }
}
//方法二：
//全选或全不选 此传入的参数为this 如：checkAll(this)
function checkAll(evt){
 var tbl=$("#table1");
 var trlist=tbl.find("tr");
 for(var i=1;i<trlist.length;i++){
  var tr=$(trlist[i]);
  var input=tr.find("INPUT[type=&#39;checkbox&#39;]");
  input.attr("checked",evt.checked);
 }
}
//方法三：
//全选或全不选 此传入的参数为this 如：checkAll(this)
function checkAll(evt){
    $("#table1 tr").find("input[type=&#39;checkbox&#39;]").each(function(i){
     $(this).attr("checked",evt.checked)
    });
}
//方法四：
//全选或全不选 此传入的参数为this 如：checkAll(this)
function checkAll(evt){
    $("#table1 tr").find("input[type=&#39;checkbox&#39;]").attr("checked",evt.checked);
}

11. The client dynamically adds a line

function btnAddRow(){
    //行号是从0开始，最后一行是新增、删除、保存按钮行 故减去2
    var rownum=$("#table1 tr").length-2;
        var chk="<input type=&#39;checkbox&#39; id=&#39;chk_"+rownum+"&#39; name=&#39;chk_"+rownum+"&#39;/>";
    var text="<input type=&#39;text&#39; id=&#39;txt_"+rownum+"&#39; name=&#39;txt_"+rownum+"&#39; width=&#39;75px&#39;/>";
    var sel="<select id=&#39;sel_"+rownum+"&#39;><option value=&#39;1&#39;>男</option><option value=&#39;0&#39;>女</option></select>";
    var row="<tr><td>"+chk+"</td><td>"+text+"</td><td>"+sel+"</td><td>"+text+"</td><td>"+text+"</td></tr>";
    $(row).insertAfter($("#table1 tr:eq("+rownum+")"));   
}

12. The client deletes a line

每次只能删除一行，删除多行时出错
function btn
Delete
Row(){
   $("#table1 tr").find("input[type='checkbox']").each(function(i){
    if($(this).attr("checked")){ 
     if(i!=0){//不能删除行标题       
     $("#table1 tr:eq("+i+")").remove();
     }
    }
   });
}

This is better than the above, you can delete more at once A record

function btnDeleteRow(){
   $("#table1 tr").each(function(i){
       var chk=$(this).find("input[type='checkbox']");
       if(chk.attr("id")!="checkall"){//不能删除标题行       
     if(chk.attr("checked")){
     $(this).remove();
     }
       }
    });
}

13. Client saving

function btnSaveClick(){
   //find()方法中我暂时不知道如何设定多个筛选条件，所以下面得不到select列表的值
   //$("#table1 tr td").find("input[type='text']" || "select").each(function(i){
   //alert($(this).val());
   //});             
   $("#table1 tr").find("td").each(function(i){
      if($(this).find("input[type='text']").length>0){
          alert($(this).find("input[type='text']").val());
      }else if($(this).find("select").length>0)
      {
          alert($(this).find("select").val());
      }
    });
}

I believe you have mastered the method after reading the case in this article. For more exciting information, please pay attention to other related articles on the PHP Chinese website!

Recommended reading:

jquery alternates rows to add styles to the table

JS method of converting XML and JSON to each other

The above is the detailed content of Detailed explanation of the steps to operate table with jquery. For more information, please follow other related articles on the PHP Chinese website!