怎么用JS做一个表格的增删改查

JavaScript024

怎么用JS做一个表格的增删改查,第1张

<!doctype html>

<html>

<head>

<meta charset="UTF-8">

<title>Document</title>

</head>

<body>

    <table id="tab" width="400px" border="1px">

        <tr>

            <th>姓名</th>

            <th>年龄</th>

            <th>性别</th>

            <th>操作</th>

        </tr>

    </table>

    <hr>

    <form name="myform" action="" onsubmit="return false">

        姓名: <input type="text" name="user"><br>

        年龄: <input type="number" name="age"><br>

        性别: <input type="text" name="sex"><br>

    <br>

    <button onclick="getMessage()">提交</button>

    </form>

    <script>

        var tab = document.getElementById('tab')

        var user = document.myform.user

        var age = document.myform.age

        var sex = document.myform.sex

        function getMessage(){

                //创建行

            var tr = tab.insertRow(tab.rows.length)

            tr.insertCell(0).innerHTML = user.value

            tr.insertCell(1).innerHTML = age.value

            tr.insertCell(2).innerHTML = sex.value

            tr.insertCell(3).innerHTML = '<button onclick="del(this)">删除</button>'

        }

        function del(n){

            var index = n.parentNode.parentNode.rowIndex

            console.log(index)

            tab.deleteRow(index)

        }

    </script>

</body>

</html>

上代码

<!DOCTYPE html>

<html>

<head>

    <meta http-equiv="Content-Type" content="text/html charset=UTF-8">

    <title>RunJS 演示代码</title>

    <style>

.* {

    padding: 0

    margin: 0

}

a {

    text-decoration: none

    color: black

}

a:hover {

    color: red

}

.wrap {

    width: 900px

    height: 300px

    overflow-y: auto

    margin: auto

}

table {

    width: 800px

    border: 1px solid black

    border-collapse: collapse

}

th {

    background-color: orange

}

td,th {

    border: 1px solid black

    text-align: center

}

table input[type=text] {

    width: 100px

}

    </style>

    <script>

        var yugi = {

            col: 6,

            addRow: function(table) {

                var vals = [a.value, b.value, c.value, d.value, e.value, "<a href='###' onclick='yugi.modify(table,this)'>修改</a>&nbsp<a href='###' onclick='yugi.del(table,this)'>删除</a>"]

                var tr = table.insertRow(table.tBodies[0].rows.length)

                for (var i = 0 i < yugi.col i++) {

                    var td = tr.insertCell(tr.cells.length)

                    td.innerHTML = vals[i]

                }

            },

            modify: function(table, row) {

                var r = row.parentElement.parentElement,

                    c = r.cells

                if (/.*修改.*/g.test(row.innerHTML)) {

                    for (var i = 0 i < c.length - 1 i++) {

                        var ci = c[i]

                        var txt = document.createElement("input")

                        txt.type = "text"

                        txt.value = ci.innerHTML

                        ci.innerHTML = ""

                        ci.appendChild(txt)

                    }

                    row.innerHTML = "保存"

                } else {

                    for (var i = 0 i < c.length - 1 i++) {

                        var ci = c[i]

                        ci.innerHTML = ci.children[0].value

                    }

                    row.innerHTML = "修改"

                }

            },

            del: function(table, row) {

                var ind = row.parentElement.parentElement.rowIndex

                table.tBodies[0].deleteRow(ind)

            }

        }

    </script>

</head>

<body>

    <fieldset class="wrap">

        <legend>学生信息列表</legend>

        <div>

            <input type="text" id="a" />

            <input type="text" id="b" />

            <input type="text" id="c" />

            <input type="text" id="d" />

            <input type="text" id="e" />

            <input type="button" value="添加" onclick="yugi.addRow(table)" />

        </div>

        <table id="table">

            <tr>

                <th>学号</th>

                <th>姓名</th>

                <th>年龄</th>

                <th>学历</th>

                <th>性别</th>

                <th>地址</th>

            </tr>

        </table>

    </fieldset>

</body>

</html>

直接给个例子吧

包含两个文件(index.jsp  和  index.js)

<%@ page language="java" contentType="text/html charset=UTF-8"

pageEncoding="UTF-8"%>

    </head>

    <body onload="loadUserDatas()">

    <div class="container">

    <table class="table" id="table">

       <caption><h2>迈睿练习一</h2></caption>

       <caption>

               <button type="button" class="btn btn-info" id="user_add" data-toggle="modal"

       data-target="#myModal" onclick="optionUserData(this)">新增</button>

               <button type="button" class="btn btn-info" id="user_delete" onclick="optionUserData(this)">删除</button>

               <button type="button" class="btn btn-info" id="user_edit"  data-toggle="modal"

       data-target="#myModal"  onclick="optionUserData(this)">编辑</button>

               <button type="button" class="btn btn-info" id="user_find" onclick="optionUserData(this)">查询</button>

               <input type="text" id="s_code" placeholder="按工号查询" style="width: 80px">

               <input type="text" id="s_userName" placeholder="按姓名查询" style="width: 80px">

               <input type="text" id="s_all" placeholder="全文搜索" style="width: 80px">

       </caption>

       <thead>

          <tr>

               <th>序号</th>

             <th>工号</th>

             <th>姓名</th>

             <th>性别</th>

             <th>密码</th>

             <th>年龄</th>

             <th>出生日期</th>

          </tr>

       </thead>

       <tbody id="tbody">

       </tbody>

    </table>

 

    <!-- 模态框(Modal) -->

    <div class="modal hide" id="myModal"  role="dialog" >

       <div class="modal-dialog">

          <div class="modal-content">

             <div class="modal-header">

                <button type="button" class="close" data-dismiss="modal" aria-hidden="true"> 

                      &times

                </button>

                <h4 class="modal-title" id="myModalLabel">

                       新增用户

                </h4>

             </div>

             <div class="modal-body" id="modal-body">

                <label for="name">工号:</label>

                  <input type="text" class="form-control" id="m_code" placeholder="请输入工号">

                  <label for="name">姓名:</label>

                  <input type="text" class="form-control" id="m_userName" placeholder="请输入姓名">

                  <label for="name">性别:</label>

                  <input type="text" class="form-control" id="m_sex" placeholder="请输入性别">

                  <label for="name">密码:</label>

                  <input type="text" class="form-control" id="m_passWord" placeholder="请输入密码">

                 <label for="name">年龄:</label>

                  <input type="text" class="form-control" id="m_age" placeholder="请输入年龄">

                  <label for="name">出生日期:</label>

                  <input type="text" class="form-control" id="m_birthday" placeholder="请输入出生日期">

             </div>

             <div class="modal-footer">

                <button type="button" class="btn btn-default"

                   data-dismiss="modal">保存

                </button>

                <button type="button" class="btn btn-primary">提交更改</button>

             </div>

          </div><!-- /.modal-content -->

    </div><!-- /.modal -->

    </div>

 

    <script type="text/javascript" src="resource/jquery/jquery.js"></script>

    <script type="text/javascript" src="resource/bootstrap/js/bootstrap.min.js"></script>

    <script type="text/javascript" src="index.js"></script>

    </body>

    </html>

    复制代码

    复制代码

    //存放所有用户

    var users = users || {}

    //操作类型

    var operateType = ""

    //存放搜索对象

    var searchUsers = searchUsers || {}

    //用户构造方法

    var User = {

            Create:function(code,userName,sex,passWord,age,birthday){

                this.code = code

                this.userName = userName

                this.sex = sex

                this.passWord = passWord

                this.age = age

                this.birthday = birthday

            },

            //添加用户

            addUserData:function(){

                if(this.code != ""){

                    users[this.code] = this

                }

            },

            //删除用户

            deleteUserData:function (){

                for(var i in users){

                    if(this.code == users[i].code){

                        delete users[i]

                    }

                }

            },

            //编辑用户

            editUserData:function(){

                for(var i in users){

                    if(this.code == users[i].code){

                        users[i].userName = this.userName

                        users[i].sex = this.sex

                        users[i].passWord = this.passWord

                        users[i].birthday = this.birthday

                        users[i].age = this.age

                    }

                }

            },

            //查找用户

            findUserData:function(data){

 

                for(var i in users){

                    if(data.code.indexOf(users[i].code) >= 0 || 

                            data.userName.indexOf(users[i].userName) >= 0){

                        searchUsers[users[i].code] = users[i]

                        refreshDatas(searchUsers)

                    }

                }

            }

    }

 

    function New(aClass,aParams){

        function new_(){

            aClass.Create.apply(this,aParams)

        }

        new_.prototype = aClass

        return new new_()

    }

 

    //bootstrap模态框事件

    $('#myModal').on('hide.bs.modal', function () {

        // 执行一些动作...

        var inputElements = this.getElementsByTagName("input")

        var userArr = []

        for(var i=0i<inputElements.lengthi++){

            userArr[i] = inputElements[i].value

        }

        var user = New(User,userArr)

        //添加操作

        if(operateType == "add"){

            user.addUserData()

            refreshDatas(users)

        //编辑操作

        }else if(operateType == "edit"){

            user.editUserData()

            refreshDatas(users)

        }

    })

 

    /**

     * 首次加载页面执行方法

     */

    function loadUserDatas(){

        var userArray = initUserDatas()

        addRowData(userArray)

        refreshDatas(users)

 

    }

    /**

     * 初始化用户数据

     */

    function initUserDatas(){

        var initUser1 = New(User,["1001","小兰","女","1234","13","1991-1-1"])

        var initUser2 = New(User,["1002","小毅","男","1234","13","1991-1-1"])

        var initUser3 = New(User,["1003","兰花","女","1234","13","1991-1-1"])

        var initUser4 = New(User,["1004","兰儿","女","1234","13","1991-1-1"])

        users[initUser1.code] = initUser1

        users[initUser2.code] = initUser2

        users[initUser3.code] = initUser3

        users[initUser4.code] = initUser4

        return users

    }

 

    /**

     * 往表格添加一行html数据

     */

    function addRowData(datas){

        var tbodyElement = document.getElementById("tbody")

        var html = ""

        var color = "warning"

        var flag = true

        for(var i in datas){

            if(flag){

                color = "info"

            }else{

                color = "warning"

            }

            html = html +  "<tr class='"+ color +"'><td style='width:30px'><input type='checkbox'></td><td id='code'>"

                    + datas[i].code +"</td><td id='userName'>"

                    + datas[i].userName +"</td><td id='sex'>"

                    + datas[i].sex +"</td><td id='passWord'>"

                    + datas[i].passWord +"</td><td id='age'>"

                    + datas[i].age +"</td><td id='birthday'>"

                    + datas[i].birthday +"</td>"

                    +"</tr>"

 

            flag = !flag//颜色转换

        }

        tbodyElement.innerHTML = html

    }

    /**

     * 刷新用户数据

     */

    function refreshDatas(datas){

        addRowData(datas)

    }

 

    /**

     * 收集一行数据

     */

    function collectionRowData(param){

        var tdElement = param.getElementsByTagName("td")

        var userArr = []

        for(var i=1i<tdElement.lengthi++){

            var temp =  tdElement[i].textContent

            userArr[i-1] = temp

        }

        var user = New(User,userArr)

        return user

    }

    /**

     * 用户操作方法

     */

    function optionUserData(param){

        //获得操作类别

        var optionType = param.getAttribute("id")

        if(optionType == "user_add"){

            operateType = "add"

        }else if(optionType == "user_delete"){

            var checkRowData = isCheckedData()

            var user = collectionRowData(checkRowData)

            user.deleteUserData()

            refreshDatas(users)

        }else if(optionType == "user_edit"){

            operateType = "edit"

            var checkRowData = isCheckedData()

            var user = collectionRowData(checkRowData)

            var modal_body = document.getElementById("modal-body")

            var inputElements=  modal_body.getElementsByTagName("input")

            for(var i=0i<inputElements.lengthi++){

                var temp = inputElements[i].id.substring(2,inputElements[i].id.length)

                inputElements[i].value = user[temp]

            }

        }else if(optionType == "user_find"){

            var s_code =  document.getElementById("s_code").value

            var s_userName =  document.getElementById("s_userName").value

            var s_all=  document.getElementById("s_all").value

            //搜索数据

            var s_data = s_data || {}

            s_data.code = s_code

            s_data.userName = s_userName

            s_data.all = s_all

            var user = New(User,[])

            user.findUserData(s_data)

        }else{

 

        }

    }

 

    /**

     * 是否选中数据,返回选中数据的行

     */

    function isCheckedData(){

        var tbodyElement =document.getElementById("tbody")

        var trElements = tbodyElement.getElementsByTagName("tr")

        var flag = false

        for(var i=0i<trElements.lengthi++){

            var inputElement = trElements[i].getElementsByTagName("input")[0]

            if(inputElement.checked){

                flag = true

                return trElements[i]

            }

        }

        if(!flag){

            alert("请选择一条记录!")

            $('#myModal').unbind("on")

        }

    }