1 官网地址：http://www.datatables.net/
2 基本参数介绍 http://blog.csdn.net/mickey_miki/article/details/8240477 （这里已经介绍的很详细了）
如果要使用ajax请求数据的话应使用fnReloadAjax&& 官网上有插件 http://www.datatables.net/plug-ins/api
3 遇到的问题：服务数据返回格式,fnReloadAjax修改,调用fnReloadAjax,初始化datatable
&服务返回数据格式：
$re = $joinerObj-&findAll($conditons);
foreach($re as $k=&$v){
$listArray['aaData'][$k]['joinerid'] ='&input type="checkbox" value="'.$v['joinerid'].'" name="shopId" delTag="delId"&';
$listArray['aaData'][$k]['joinerid'] = "&input type='checkbox' value=".$v['joinerid']." name='delJoiner' delTag='delId' class='checkNetMusic' attr_aid=".$v['aid']."/&";
$listArray['aaData'][$k]['aid'] = $v['aid'];
$listArray['aaData'][$k]['appid'] = $v['appid'];
$listArray['aaData'][$k]['name'] = $v['name'];
$listArray['aaData'][$k]['tel'] = $v['tel'];
$listArray['aaData'][$k]['time'] = date('Y-m-d',$v['time']);
$listArray['aaData'][$k]['message'] = $v['message'];
$listArray['aaData'][$k]['company'] = $v['company'];
echo json_encode($listArray);
"aaData": []}';
关于ReloadAjax的修改：
主要是修改这里
for ( var i=0 ; i&json.aaData. i++ )
that.oApi._fnAddData( oSettings, json.aaData[i] );
$.fn.dataTableExt.oApi.fnReloadAjax = function ( oSettings, sNewSource, fnCallback, bStandingRedraw )
if ( sNewSource !== undefined && sNewSource !== null ) {
oSettings.sAjaxSource = sNewS
// Server-side processing should just call fnDraw
if ( oSettings.oFeatures.bServerSide ) {
this.fnDraw();
this.oApi._fnProcessingDisplay( oSettings, true );
var that =
var iStart = oSettings._iDisplayS
var aData = [];
this.oApi._fnServerParams( oSettings, aData );
oSettings.fnServerData.call( oSettings.oInstance, oSettings.sAjaxSource, aData, function(json) {
/* Clear the old information from the table */
that.oApi._fnClearTable( oSettings );
/* Got the data - add it to the table */
var aData =
(oSettings.sAjaxDataProp !== "") ?
that.oApi._fnGetObjectDataFn( oSettings.sAjaxDataProp )(json) :
for ( var i=0 ; i&json.aaData. i++ )
that.oApi._fnAddData( oSettings, json.aaData[i] );
oSettings.aiDisplay = oSettings.aiDisplayMaster.slice();
that.fnDraw();
if ( bStandingRedraw === true )
oSettings._iDisplayStart = iS
that.oApi._fnCalculateEnd( oSettings );
that.fnDraw( false );
that.oApi._fnProcessingDisplay( oSettings, false );
/* Callback user function - for event handlers etc */
if ( typeof fnCallback == 'function' && fnCallback !== null )
fnCallback( oSettings );
}, oSettings );
初始化和调用：
aoColumnDefs 需要和服务器返回的列数以及table的head头的列数保持一致发送ajax请求：registerMainTable.fnReloadAjax('produce.php?c=activitymanage&a=joinerInfo&appid='+appid+'&aid='+aid);
var optsortable={
"bJQueryUI": true,
"aoColumns": [
{ "mDataProp": "joinerid" },
{ "mDataProp": "name" },
{ "mDataProp": "tel" },
{ "mDataProp": "time" },
{ "mDataProp": "message" },
{ "mDataProp": "company" }
"aoColumnDefs": [ { "bSortable": false, "aTargets": [ 0 ] },{ "bSortable": false, "aTargets": [ 1 ] },{ "bSortable": false, "aTargets": [ 2 ] },{ "bSortable": false, "aTargets": [ 3 ] },{ "bSortable": false, "aTargets": [ 4 ] },{ "bSortable": false, "aTargets": [ 5 ] }],
"sPaginationType": "full_numbers",
/*语言设置*/
"oLanguage": {
"sLengthMenu": "每页显示 _MENU_条",
"sZeroRecords": "没有找到符合条件的数据",
"sProcessing": "&img src=&./loading.gif& /&",
"sInfo": "当前第 _START_ - _END_ 条　共计 _TOTAL_ 条",
"sInfoEmpty": "没有记录",
"sInfoFiltered": "(从 _MAX_ 条记录中过滤)",
"sSearch": "搜索：",
"oPaginate": {
"sFirst": "首页",
"sPrevious": "前一页",
"sNext": "后一页",
"sLast": "尾页"
var registerMainTable = $("#newsTable1").dataTable(optsortable);
$("#newsTable tbody a").live('click',function(){
$("#activitylist").css('display','none');
var aid = $(this).closest('a').attr('aid');
var appid = $("#appid").val();
registerMainTable.fnReloadAjax('produce.php?c=activitymanage&a=joinerInfo&appid='+appid+'&aid='+aid);
$("#details").css('display','block');
html页面中使用table
&table id="newsTable1"
width="100%" cellpadding="0" cellspacing="1" bgcolor="#999999"&
&tr class="ui-widget-header "&
&th&&input type="checkbox" id="checkJoiner"/&&/th&
&th&姓名&/th&
&th&***&/th&
&th&时间&/th&
&th&留言&/th&
&th&公司&/th&
&tbody id="joinInfo"&&/tbody&
&关于删除行的问题：需要使用oTable.fnDeleteRow();
比如：$.each(b,function(){oTable.fnDeleteRow(this)});
function delJioner(){
var b=new Array();
var a=new Array();
var optsortable={bRetrieve:true,oLanguage:{sLengthMenu:"每页显示 _MENU_ 条",sZeroRecords:"没有数据。",sInfo:"_START_ / _END_ ，共 _TOTAL_ 条",sInfoEmpty:"没有记录。",sInfoFiltered:"(筛选自_MAX_条信息)",sSearch:"搜索："},aoColumnDefs:[ { "bSortable": false, "aTargets": [ 0 ] },{ "bSortable": false, "aTargets": [ 1 ] },{ "bSortable": false, "aTargets": [ 2 ] },{ "bSortable": false, "aTargets": [ 3 ] },{ "bSortable": false, "aTargets": [ 4 ] },{ "bSortable": false, "aTargets": [ 5 ] }],};
var oTable=$("#newsTable1").dataTable(optsortable);
var appid = $('#appid').val();
$("input[delTag='delId']").each(function(){
if($(this).attr("checked")=="checked"){
a.push($(this).attr("value"));
b.push(this.parentNode.parentNode);
if(a.length==0){
alert("请选择条目！");
if(!confirm("确定要删除记录吗?")){
return false
$("#netNewsTabs").mask("请稍候...");
type:"post",
url:"produce.php?c=activitymanage&a=delMultiJoiner&appid="+appid+"&delList="+a.toString(),
success:function(msg){
var data = eval(msg);
var err_code = data[0].err_
var err_msg = data[0].err_
if(err_code != 0 )
alert(err_msg);
return false;
$.each(b,function(){$(this).closest('tr').hide();});
$.each(b,function(){oTable.fnDeleteRow(this)});
alert(err_msg);
$("#netNewsTabs").unmask();
error:function(){
alert("网络请求失败，请重试！");
$("#netNewsTabs").unmask();
阅读(...) 评论()急求，6.01装了插件badgeclear后点任何程序图标都重启_iphone4s吧_百度贴吧
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&签到排名：今日本吧第个签到，本吧因你更精彩，明天继续来努力！
本吧签到人数：0成为超级会员，使用一键签到本月漏签0次！成为超级会员，赠送8张补签卡连续签到：天&&累计签到：天超级会员单次开通12个月以上，赠送连续签到卡3张
关注：705,531贴子：
急求，6.01装了插件badgeclear后点任何程序图标都重启收藏
RT,也不进入安全模式，插件删不了。。不知道怎么办，急死了，求大神指导
登录百度帐号推荐应用石家庄58同城
相关信息共 83 &条