增、删、查、改

<script src="https://cdn.bootcdn.net/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
<script src="https://cdn.bootcdn.net/ajax/libs/jquery.SPServices/0.7.2/jquery.SPServices-0.7.2.min.js"></script>
<script type="text/javascript" src="/_layouts/15/sp.runtime.js"></script>
<script type="text/javascript" src="/_layouts/15/sp.js"></script>


        //插入1
        var camlQuery = "<Batch OnError='Continue' >" +
                      "<Method ID='1' Cmd='New'>" +
                       "<Field Name='Title'>可以更新吗</Field>" +
                       "<Field Name='name'>小红</Field>" +
                      "</Method>" +
                     "</Batch>";
        $().SPServices({
            operation: "UpdateListItems",
            async: false,
            listName: "User",
            batchCmd: "New",
            updates: camlQuery ,
            completefunc: function(xData, Status) {
                console.log(Status);
                $(xData.responseXML).SPFilterNode("z:row").each(function (index, item) { 
                        var Title = item.getAttribute("ows_Title");
                                var name = item.getAttribute("ows_name");
                                console.log(Title);
                                console.log(name);
                });
            }
        });
        //插入2
        var arr = [["Title","这是一个标题"],["name","小米"]];
        $().SPServices({
            operation: "UpdateListItems",
            async: false,
            listName: "User",
            batchCmd: "New",
            valuepairs: arr ,
            completefunc: function(xData, Status) {
                console.log(Status);
                $(xData.responseXML).SPFilterNode("z:row").each(function (index, item) { 

                        var LinkTitle = item.getAttribute("ows_Title");
                                var name = item.getAttribute("ows_name");
                                console.log(LinkTitle);
                                console.log(name);
                });
            }
        });
        //修改
        var arr = [["Title","这是一个标题"],["name","修改"]];
        var UserID = 1;
        $().SPServices({
            operation: "UpdateListItems",
            async: false,
            listName: "User",
                batchCmd:"Update",
            ID: UserID,
            valuepairs: arr ,
            completefunc: function(xData, Status) {
                console.log(Status);
                $(xData.responseXML).SPFilterNode("z:row").each(function (index, item) { 

                        var LinkTitle = item.getAttribute("ows_Title");
                                var name = item.getAttribute("ows_name");
                                console.log(LinkTitle);
                                console.log(name);
                });
            }
        });
        //删除
        $().SPServices({
            operation: "UpdateListItems",
            async: false,
            listName: "User",
            batchCmd:"Delete",
            ID:2,
            completefunc: function(xData, Status) {
                console.log(Status);
            }
         });
       //获取当前用户信息
        var userInfo = $().SPServices.SPGetCurrentUser({

            fieldNames: ['Name', 'email', 'userName', 'userId', 'title'],
            completefunc: function (da, code) {
                console.info(code)
            }
        });
var queryStr = "<Query>" +
            "<Where>" +
            "<Eq>" +
            "<FieldRef Name='name' />" +
            "<Value Type='Text'>" + userInfo.title + "</Value>" +
            "</Eq>" +
            "</Where>" +
            "<OrderBy>" +
            "<FieldRef Name='ID' Ascending='FALSE' />" +
            "</OrderBy>" +
            "</Query>";
        $().SPServices({
            operation: "GetListItems",
            webURL: "/teams/Dev",
            listName: "approvedRecords",
            CAMLViewFields: "<ViewFields Properties='True' />",
            CAMLQuery: queryStr,
            includeAllAttrs: false,    //是否包含z:row节点中的所有属性  
            removeOws: true,           //是否需要移除Ows_前缀  
            async: false,

            completefunc: function (xData, Status) {
                if (Status == 'success') {
                    //转json
                    var myJson = $(xData.responseXML).SPFilterNode("z:row").SPXmlToJson({
                        mapping: {
                            ows_ID: { mappedName: "ID", objectType: "Counter" },
                            ows_personnelNo: { mappedName: "personnelNo", objectType: "Text" },
                            ows_name: { mappedName: "name", objectType: "Text" },
                            ows_approveDate: { mappedName: "approveDate", objectType: "Text" },
                            ows_dateCategory: { mappedName: "dateCategory", objectType: "Text" },
                            ows_eventCategory: { mappedName: "eventCategory", objectType: "Text" },
                            ows_duration: { mappedName: "duration", objectType: "Number" },
                            ows_description: { mappedName: "description", objectType: "Text" },
                            ows_approveStatus: { mappedName: "approveStatus", objectType: "Text" },
                            ows_currentApproveName: { mappedName: "currentApproveName", objectType: "Text" },
                            ows_approveComment: { mappedName: "approveComment", objectType: "Text" },
                        },
                        includeAllAttrs: false,
                        removeOws: false
                    });
                    

                }
                else {
                    console.log(xData);
                }
            }
        });