1,bLengthChange 是否显示选择table中显示数据量 show(10,20,100...)column
2,bPaginate 是否显示分页menus
3,bProcessing table载入数据时,是否显示‘进度’提示
4,bInfo 是否显示有关table中现有数据的信息,执行过滤数据操作(filtered data)时显示对应信息
5,bAutoWidth
是否启动自动计算各个字段(td单元格)所在宽度
$(document).ready( function () {
$('#example').dataTable( {
"bAutoWidth": false
} );
} );
6,bScrollInfinite 是否启动初始化滚动条--数据过多了,通常和sScrollY结合使用
不能和pagination分页功能并存,分页了数据就不会过多了(垂直方向)
$(document).ready( function() {
$('#example').dataTable( {
"bScrollInfinite": true,
"bScrollCollapse": true,
"sScrollY": "200px"
} );
} );
7,bServerSide是否启动服务器端数据导入,即要和sAjaxSource结合使用
$(document).ready( function () {
$('#example').dataTable( {
"bServerSide": true,
"sAjaxSource": "xhr.php"
} );
} );
8,bSort 是否启动各个字段的排序功能--点击table对应字段的最上面一下,
该列就会进行asc或desc排序
bSortable可对应启动单个字段的排序功能
9,bSortClasses 是否启动给正在被排序的列(字段)加上class(有sorting_1,sorting_2和
sorting_3三种)属性,以凸显正在排序的列,这个功能耗时间,数据大时,关闭
10,bStateSave 是否启动状态保留,开启cookie记住table信息如分页信息,
数据长度,filtering过滤和sorting过滤等信息。
11,sScrollX 字段过多,启动横向滚动条
$(document).ready( function() {
$('#example').dataTable( {
"sScrollX": "100%",
"bScrollCollapse": true
} );
} );
12,sScrollY 数据过多,使用垂直滚动条 第六个有使用到
$(document).ready( function() {
$('#example').dataTable( {
"sScrollY": "200px",
"bPaginate": false
} );
} );
13,bFilter 是否启动搜索功能
14,bDestroy
$(document).ready( function() {
$('#example').dataTable( {
"sScrollY": "200px", //显示200px垂直长度窗口
"bPaginate": false //禁用分页
} );
// Some time later....
$('#example').dataTable( {
"bFilter": false,
"bDestroy": true //这使得在200px长度窗口显示出来的数据,下一个窗口显示
//有使得有了分页功能
} );
} );
15, iDisplayLength 一个分页显示多少行数据
16, iDisplayStart 从第几行开始显示数据
18,sPaginationType
DataTables内建方法有‘two_button’和‘full_numbers’
$(document).ready( function() {
$('#example').dataTable( {
"sPaginationType": "full_numbers"
} );
} )
这类方法是可以自定义的,如:自己写个listbox方法,提供一个下拉框来选择显示当前一个table中显示多少数据,
$(document).ready(function() { $('#example').dataTable( { "sPaginationType":
"listbox" } );} );$.fn.dataTableExt.oPagination.listbox = { /* * Function: oPagination.listbox.fnInit * Purpose: Initalise dom elements required for pagination with listbox input * Returns: - * Inputs: object:oSettings - dataTables settings object * node:nPaging - the DIV which contains this pagination control * function:fnCallbackDraw - draw function which must be called on update */ "fnInit":
function (oSettings, nPaging, fnCallbackDraw) { var
nInput = document.createElement('select'); var
nPage = document.createElement('span'); var
nOf = document.createElement('span'); nOf.className =
"paginate_of"; nPage.className =
"paginate_page"; if
(oSettings.sTableId !== '') { nPaging.setAttribute('id', oSettings.sTableId +
'_paginate'); } nInput.style.display =
"inline"; nPage.innerHTML =
"Page "; nPaging.appendChild(nPage); nPaging.appendChild(nInput); nPaging.appendChild(nOf); $(nInput).change(function
(e) { // Set DataTables page property and redraw the grid on listbox change event. window.scroll(0,0);
//scroll to top of page if
(this.value ===
"" || this.value.match(/[^0-9]/)) {
/* Nothing entered or non-numeric character */ return; } var
iNewStart = oSettings._iDisplayLength * (this.value - 1); if
(iNewStart > oSettings.fnRecordsDisplay()) { /* Display overrun */ oSettings._iDisplayStart = (Math.ceil((oSettings.fnRecordsDisplay() - 1) / oSettings._iDisplayLength) - 1) * oSettings._iDisplayLength; fnCallbackDraw(oSettings); return; } oSettings._iDisplayStart = iNewStart; fnCallbackDraw(oSettings); });
/* Take the brutal approach to cancelling text selection */ $('span', nPaging).bind('mousedown',
function () { return
false; }); $('span', nPaging).bind('selectstart',
function () { return
false; }); }, /* * Function: oPagination.listbox.fnUpdate * Purpose: Update the listbox element * Returns: - * Inputs: object:oSettings - dataTables settings object * function:fnCallbackDraw - draw function which must be called on update */ "fnUpdate":
function (oSettings, fnCallbackDraw) { if
(!oSettings.aanFeatures.p) { return; } var
iPages = Math.ceil((oSettings.fnRecordsDisplay()) / oSettings._iDisplayLength); var
iCurrentPage = Math.ceil(oSettings._iDisplayStart / oSettings._iDisplayLength) + 1;
/* Loop over each instance of the pager */ var
an = oSettings.aanFeatures.p; for
(var
i = 0, iLen = an.length; i < iLen; i++) { var
spans = an[i].getElementsByTagName('span'); var
inputs = an[i].getElementsByTagName('select'); var
elSel = inputs[0]; if(elSel.options.length != iPages) { elSel.options.length = 0;
//clear the listbox contents for
(var
j = 0; j < iPages; j++) { //add the pages var
oOption = document.createElement('option'); oOption.text = j + 1; oOption.value = j + 1; try
{ elSel.add(oOption,
null); // standards compliant; doesn't work in IE }
catch (ex) { elSel.add(oOption);
// IE only } } spans[1].innerHTML =
" nbsp;of nbsp;" + iPages; } elSel.value = iCurrentPage; } }};