datatable的常用操作

 比如有一个datatable,

function initRuleDataTable() {
        $("#ruleDataTable").dataTable({
            "sAjaxSource": dbLinkUrl.dblist,
            "fnServerData": retrieveData,
            "processing": true,
            "serverSide": true,
            "bDestroy": true,
            "bFilter": false,
            "retrieve": true,
            "paging": true,
   "bAutoWidth": true,
            "sScrollX": "100%",
            "sScrollY": 385,
            "aoColumns": [
                {"mData": "TEST", "sTitle": "校验码","sClass":"center", "sWidth": "80px",},
                {"mData": "ID","sTitle":"操作","sClass":"center", "sWidth": "80px",},
                {"mData": "ID", "sTitle": "DB_ID",  "bVisible": false, },
                {"mData": "TITLE", "sTitle": "连接串标题", "sWidth": "15%",}, //15%
                {"mData": "DB_URL", "sTitle": "数据库连接地址", "sWidth": "300px",},
                {"mData": "DB_TYPE", "sTitle": "数据库类型", "sWidth": "120px",},
                {"mData": "DB_NAMES", "sTitle": "可使用数据库", "sWidth": "20%",},
                {"mData": "ITEM_NAMES", "sTitle": "可使用项目", "sWidth": "20%",},
                //{"mData": "ITEM_IDS", "sTitle": "可使用项目", "sWidth": "20%",},
                {"mData": "CREATER", "sTitle": "创建人", "sWidth": "80px",},
                {"mData": "CTIME", "sTitle": "创建时间", "sWidth": "150px",},
                {"mData": "EDITOR", "sTitle": "更新人", "sWidth": "80px",},
                {"mData": "UTIME", "sTitle": "更新时间", "sWidth": "150px",},
            ],   //1处

问题1

鼠标放到表格中,会显示表格中的数据

"aoColumnDefs":[  {"aTargets":[3],"mRender":function(data,type,full){
                        return "<label title='"+data+"'>"+data+"</label>";
                    }},      ]   //这段代码放到  “1处” 后面,可以实现第4列的表格数据的提示。

 

 

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值