Basic operations of Jquery Table-JS Tutorial-php.cn

Basic operations of Jquery Table

巴扎黑

Release： 2017-06-26 14:35:02

Original

1167 people have browsed it

Jquery is very convenient to operate Html Table. Here is a brief summary of the basic operations of the table.

First create a general table css and a table Table:

table
{
    border-collapse: collapse;
    border-spacing: 0;
    margin-right: auto;
    margin-left: auto;
    width: 800px;
 }
 th, td
 {
    border: 1px solid #b5d6e6;
    font-size: 12px;
    font-weight: normal;
    text-align: center;
    vertical-align: middle;
    height: 20px;
 }
 th
 {
    background-color: Gray;
 }

Copy after login

表头一	表头二	表头三	表头四	表头五
第一行第一列	第一行第二列	第一行第三列	第一行第四列	第一行第五列
第二行第一列	第二行第二列	第二行第三列	第二行第四列	第二行第五列
第三行第一列	第三行第二列	第三行第三列	第三行第四列	第三行第五列
第四行第一列	第四行第二列	第四行第三列	第四行第四列	第四行第五列

1. Move the mouse to the row to change the background color:

Add a css style:

.hover
{
  background-color: #cccc00;
}

Copy after login

Js script:

$(document).ready(function () {
    //鼠标移动到行变色,单独建立css类hover
    //tr:gt(0):表示获取大于 tr index 为0 的所有tr，即不包括表头
    $("#table1 tr:gt(0)").hover(
    function () { $(this).addClass("hover") },
    function () { $(this).removeClass("hover") })
});

Copy after login

Result Execution result:

2. Table Odd and even rows change color:

Odd and even rows css:

.odd{ background-color: #bbf;}
.even{ background-color:#ffc; }

Copy after login

Js script:

$(document).ready(function () {
    //奇偶行不同颜色
    $("#table2 tbody tr:odd").addClass("odd"),
    $("#table2 tbody tr:even").addClass("even")
    //或者
    //$("#table2 tbody tr:odd").css("background-color", "#bbf"),
    //$("#table2 tbody tr:even").css("background-color", "#ffc")
});

Copy after login

The result shows:

3. Basic operations:

(1) Delete rows, such as deleting the second row in the table:

//删除指定行（第二行）
 $("#table3 tr:gt(0):eq(1)").remove();

Copy after login

(2) Delete columns, such as deleting the second column in the table:

//eq:获取子元素索引从 0 开始，先删除表头
$("#table3 tr th:eq(1)").remove();
//nth-child:获取子元素从 1 开始
$("#table3 tr td:nth-child(2)").remove();

Copy after login

(3) Delete other rows, such as all rows except the second row:

 $("#table3 tr:gt(0):not(:eq(1))").remove();

Copy after login

(4) Delete other columns, such as the second row All columns except the second column:

//先删除表头
$("#table3 tr th:not(:eq(1))").remove();
$("#table3 tr td:not(:nth-child(2))").remove();

Copy after login

(5) Hide rows, such as hiding the second row:

 $("#table3 tr:gt(0):eq(1)").hide();
//或者
//$("#table3 tr:gt(0):eq(1)").css("display", "none")
//显示
//$("#table3 tr:gt(0):eq(1)").css("display", "");

Copy after login

(6) Hide Column, such as hiding the second column:

 $("#table3 tr th:eq(1)").hide();
 $("#table3 tr td:nth-child(2)").hide();
//或者
//$("#table3 tr th:eq(1)").css("display", "none");
//$("#table3 tr td:nth-child(2)").css("display", "none");
//显示
//$("#table3 tr th:eq(1)").css("display", "");
//$("#table3 tr td:nth-child(2)").css("display", "");

Copy after login

(7) Insert a new row at the last position of the table:

var newRow = "<tr>
<td>新行第一列</td>
<td>新行第二列</td>
<td>新行第三列</td>
<td>新行第四列</td>
<td>新行第五列</td>
</tr>";
$("#table3 tr:last").after(newRow);

Copy after login

(8) Insert a row after the second row:

var newRow = "<tr>
<td>新行第一列</td>
<td>新行第二列</td>
<td>新行第三列</td>
<td>新行第四列</td>
<td>新行第五列</td>
</tr>";
$("#table3 tr:gt(0):eq(1)").after(newRow);

Copy after login

(9) Get the value of the cell, such as the second row and third column:

var v = $("#table3 tr:gt(0):eq(1) td:eq(2)").text();
//结果显示：第二行第三列

Copy after login

(10) Get all the values of a column, such as the second column:

var v = "";
 $("#table3 tr td:nth-child(2)").each(function () {
        v += $(this).text()+" ";
});
//结果：第一行第二列  第二行第二列  第三行第二列

Copy after login

(11) Get all the values of a row, such as the second row:

 var v = "";
 $("#table3 tr:gt(0):eq(1) td").each(function () {
        v += $(this).text() + " ";
 });
//结果：第二行第一列  第二行第二列  第二行第三列  第二行第四列  第二行第五列

Copy after login

(12) Merge row cells, such as merging the second row The second and third cells:

$("#table3 tr:gt(0):eq(1) td:eq(1)").attr("colspan", 2);
$("#table3 tr:gt(0):eq(1) td:eq(2)").remove();

Copy after login

(13) Split the row cells and restore the merged cells above:

//注意不能使用
//$("#table3 tr:gt(0):eq(1) td:eq(1)").removeAttr("colspan");
 $("#table3 tr:gt(0):eq(1) td:eq(1)").attr("colspan", 1);
 $("#table3 tr:gt(0):eq(1) td:eq(1)").after("<td>第二行第三列</td>")

Copy after login

(14) Merge column cells, such as merging the second cell and third cell in the second column

$("#table3 tr:gt(0):eq(1) td:eq(1)").attr("rowspan", 2);
$("#table3 tr:gt(0):eq(2) td:eq(1)").remove();

Copy after login

(15) Split column cells, such as the above Restore the newly merged cells:

 $("#table3 tr:gt(0):eq(1) td:eq(1)").attr("rowspan", 1);
//在下面行第一个单元格后插入单元格
 $("#table3 tr:gt(0):eq(2) td:eq(0)").after("<td>第三行第二列</td>");

Copy after login

(16) Add a click event to each cell, and pop up the row index and column index of the cell:

$(document).ready(function () {
    //点击#table3 的单元格返回 单元格索引
    $("#table3 td").click(function () {
        var tdSeq = $(this).parent().find("td").index($(this));
        var trSeq = $(this).parent().parent().find("tr").index($(this).parent());
        alert("第" + (trSeq) + "行，第" + (tdSeq+1) + "列");
    })
});

Copy after login

##--= Source code download=--

Author: Rising Sun

Source:

The copyright of this article belongs to the author and the blog park. Reprinting is welcome, but this statement must be retained without the author's consent. And provide a link to the original text in an obvious position on the article page, otherwise we reserve the right to pursue legal liability.

The above is the detailed content of Basic operations of Jquery Table. For more information, please follow other related articles on the PHP Chinese website!