当前位置: 首页>>编程示例 >>用法及示例精选 >>正文

jQWidgets jqxDataTable serverProcessing属性用法及代码示例

jQWidgets是一个 JavaScript 框架，用于为 PC 和移动设备制作基于 Web 的应用程序。它是一个非常强大、优化、独立于平台且得到广泛支持的框架。这jqx数据表用于读取和显示 HTML 表中的数据。它还用于显示来自各种数据源(例如 XML、JSON、Array、CSV 或 TSV)的数据。

serverProcessing 属性用于设置或返回是否使用服务器管理排序、过滤和分页，并且显示的 jqxDataTable 向服务器方向传递 Ajax 请求并显示返回的数据。此外，如果当前页面、页面大小、排序列或排序顺序发生更改，则 jqxDataTable 将自发执行新的数据绑定以及更改的参数。它是布尔类型，默认值为 false。

jqxDataTable默认发送到服务器的数据列表如下：

  • sortdatafield:它是已排序列的指定数据字段。
  • sortorder:这是规定的排序顺序。
  • pagenum:它是显示数据表的指定页码。
  • pagesize:它是显示数据表的指定页面大小。
  • filterscount:它是应用于显示的 jqxDataTable 的过滤器的计数。
  • filtervalue:它是过滤器的规定值。
  • filtercondition:这是过滤器的规定条件。过滤器的条件可以是“CONTAINS”、“DOES_NOT_CONTAIN”、“EQUAL”、“EQUAL_CASE_SENSITIVE”、NOT_EQUAL”、“GREATER_THAN”、“GREATER_THAN_OR_EQUAL”、“LESS_THAN”、“LESS_THAN_OR_EQUAL”、“STARTS_WITH” 、“STARTS_WITH_CASE_SENSITIVE”、“ENDS_WITH”、“ENDS_WITH_CASE_SENSITIVE”、“NULL”、“NOT_NULL”、“EMPTY” 或 “NOT_EMPTY”。
  • filterdatafield:它是过滤器列的指定数据字段。
  • filteroperator:它是过滤器的指定运算符，其中 0 用于“AND”，1 用于“OR”。

用法:

  • 设置服务器处理属性。
$('Selector').jqxDataTable({ 
serverProcessing: true,
});
  • 返回服务器处理属性。
var serverProcessing = 
$('Selector').jqxDataTable('serverProcessing');

链接文件：下载jQWidgets从给定的链接。在 HTML 文件中，找到下载文件夹中的脚本文件。

<link rel=”stylesheet” href=”jqwidgets/styles/jqx.base.css” type=”text/css” />
<script type=”text/javascript” src=”scripts/jquery.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxcore.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxdata.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxbuttons.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxscrollbar.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxlistbox.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxdropdownlist.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxdatatable.js”></script>

示例 1：下面的例子说明了jqxDataTable服务器处理jQWidgets 中的属性。

HTML


<!DOCTYPE html> 
<html lang="en"> 
  
<head> 
    <link rel="stylesheet" href= 
"jqwidgets/styles/jqx.base.css" 
          type="text/css"/> 
    <script type="text/javascript" 
            src="scripts/jquery.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxcore.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxdata.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxbuttons.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxscrollbar.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxlistbox.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxdropdownlist.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxdatatable.js"> 
    </script> 
</head> 
  
<body> 
    <center> 
        <h1 style="color:green;"> 
            GeeksforGeeks 
        </h1> 
        <h3> 
            jQWidgets jqxDataTable 
            serverProcessing Property 
        </h3> 
        <div id="#Data_Table"></div> 
        <table id="Data_Table" border="1"> 
            <thead> 
                <tr> 
                    <th>Employee_Name</th> 
                    <th>Company</th> 
                    <th>Designation</th> 
                </tr> 
            </thead> 
            <tbody> 
                <tr> 
                    <td>Rohit</td> 
                    <td>GeeksforGeeks</td> 
                    <td>HR</td> 
                </tr> 
                <tr> 
                    <td>Rahul</td> 
                    <td>Capgemini</td> 
                    <td>Software Engineer</td> 
                </tr> 
                <tr> 
                    <td>Vivek</td> 
                    <td>CESC</td> 
                    <td>Electrical Engineer</td> 
                </tr> 
                <tr> 
                    <td>Amit</td> 
                    <td>Apple</td> 
                    <td>Manager</td> 
                </tr> 
            </tbody> 
        </table> 
  
        <input type="button" style="margin:29px;" 
               id="jqxbtn" value="Click here" /> 
        <div id="log"></div> 
    </center> 
    <script type="text/javascript"> 
        $(document).ready(function () { 
            $("#Data_Table").jqxDataTable({ 
                serverProcessing: true, 
                columns: [{ 
                    text: 'Employee_Name', 
                    dataField: 'Employee_Name', 
                    width: 190 
                }, { 
                    text: 'Company', 
                    dataField: 'Company', 
                    width: 160 
                }, { 
                    text: 'Designation', 
                    dataField: 'Designation', 
                    width: 190 
                }] 
            }); 
            $("#jqxbtn").jqxButton({ 
                width: 280 
            }); 
            $("#jqxbtn").on("click", function () { 
                var sp = $('#Data_Table') 
                    .jqxDataTable('serverProcessing'); 
                $('#log').text(sp); 
            }); 
        }); 
    </script> 
</body> 
  
</html>

输出：

示例 2：下面是jqxDataTable的另一个例子服务器处理jQWidgets 中的属性。

HTML


<!DOCTYPE html> 
<html lang="en"> 
  
<head> 
    <link rel="stylesheet" href= 
"jqwidgets/styles/jqx.base.css" 
          type="text/css"/> 
    <script type="text/javascript" 
            src="scripts/jquery.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxcore.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxdata.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxbuttons.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxscrollbar.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxlistbox.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxdropdownlist.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxdatatable.js"> 
    </script> 
</head> 
  
<body> 
    <center> 
        <h1 style="color:green;"> 
            GeeksforGeeks 
        </h1> 
        <h3> 
            jQWidgets jqxDataTable 
            serverProcessing Property 
        </h3> 
        <div id="#Data_Table"></div> 
        <table id="Data_Table" border="1"> 
            <thead> 
                <tr> 
                    <th>Employee_Name</th> 
                    <th>Company</th> 
                    <th>Designation</th> 
                </tr> 
            </thead> 
            <tbody> 
                <tr> 
                    <td>Rohit</td> 
                    <td>GeeksforGeeks</td> 
                    <td>HR</td> 
                </tr> 
                <tr> 
                    <td>Rahul</td> 
                    <td>Capgemini</td> 
                    <td>Software Engineer</td> 
                </tr> 
                <tr> 
                    <td>Vivek</td> 
                    <td>CESC</td> 
                    <td>Electrical Engineer</td> 
                </tr> 
                <tr> 
                    <td>Amit</td> 
                    <td>Apple</td> 
                    <td>Manager</td> 
                </tr> 
            </tbody> 
        </table> 
  
        <input type="button" style="margin:29px;" 
               id="jqxbtn" value="Click here" /> 
        <div id="log"></div> 
    </center> 
    <script type="text/javascript"> 
        $(document).ready(function () { 
            $("#Data_Table").jqxDataTable({ 
                serverProcessing: null, 
                columns: [{ 
                    text: 'Employee_Name', 
                    dataField: 'Employee_Name', 
                    width: 190 
                }, { 
                    text: 'Company', 
                    dataField: 'Company', 
                    width: 160 
                }, { 
                    text: 'Designation', 
                    dataField: 'Designation', 
                    width: 190 
                }] 
            }); 
            $("#jqxbtn").jqxButton({ 
                width: 280 
            }); 
            $("#jqxbtn").on("click", function () { 
                var sp = $('#Data_Table') 
                    .jqxDataTable('serverProcessing'); 
                if (sp === null) { 
                    $('#log').text("Null!"); 
                } 
                else { 
                    $('#log').text("Not null!"); 
                } 
            }); 
        }); 
    </script> 
</body> 
  
</html>

输出：

参考： https://www.jqwidgets.com/jquery-widgets-documentation/documentation/jqxdatatable/jquery-datatable-api.htm



相关用法


注：本文由纯净天空筛选整理自nidhi1352singh大神的英文原创作品 jQWidgets jqxDataTable serverProcessing Property。非经特殊声明，原始代码版权归原作者所有，本译文未经允许或授权，请勿转载或复制。