helperdialect mysql_springBoot mybatis mysql pagehelper layui 分页

table.render({

elem: ‘#adminInfoList‘

, url: ‘/admin/queryAdminInfoAll‘

, cols: [[

{type: ‘checkbox‘, fixed: ‘left‘},

{

field: ‘adminInfoEntity‘, title: ‘头像‘,

templet: function (data) {

return ‘‘

}

}

, {field: ‘adminAccount‘, title: ‘登录名‘}

, {

field: ‘adminInfoEntity‘, title: ‘邮箱‘, sort: true,

templet: function (data) {

return ‘‘ + data.adminInfoEntity.adminInfoEmail + ‘‘

}

}

, {

field: ‘adminInfoEntity‘, title: ‘权限‘,

templet: function (data) {

if (data.adminInfoEntity.adminInfoClass == 0) {

return ‘‘ + "普通管理员" + ‘‘

}

if (data.adminInfoEntity.adminInfoClass == 1) {

return ‘‘ + "超级管理员" + ‘‘

}

}

}

, {

field: ‘adminInfoName‘, title: ‘实名‘,

templet: function (data) {

return ‘‘ + data.adminInfoEntity.adminInfoName + ‘‘

}

}

, {

field: ‘adminInfoEntity‘, title: ‘状态‘, width: 85, templet: function (data) {

if (data.adminInfoEntity.adminInfoCode == 1) {

return ‘

‘ lay-text="启用|禁用" value=‘ + data.adminInfoEntity.adminInfoCode + ‘>

‘

} else {

return ‘

‘lay-text="启用|禁用" value=‘ + data.adminInfoEntity.adminInfoCode + ‘>

‘

}

}

}

, {

field: ‘adminInfoEntity‘, title: ‘性别‘,

templet: function (data) {

if (data.adminInfoEntity.adminInfoSex == 2) {

return ‘‘ + ‘男‘ + ‘‘

}

if (data.adminInfoEntity.adminInfoSex == 0) {

return ‘‘ + ‘保密‘ + ‘‘

}

if (data.adminInfoEntity.adminInfoSex == 1) {

return ‘‘ + ‘女‘ + ‘‘

}

}

}

, {

field: ‘adminInfoEntity‘, title: ‘手机号码‘, sort: true,

templet: function (data) {

return ‘‘ + data.adminInfoEntity.adminInfoPhone + ‘‘

}

}

, {fixed: ‘right‘, title: ‘操作‘, toolbar: ‘#barDemo‘, width: 140}

]]

, limit: 15

, limits: [15, 20, 25, 50, 100]

, parseData: function (data) {

/**

* 打印数据

*

*/

console.log(data)

}

/**

* 开启分页

*/

, page: true

});