看了很多办法,都没有改成功,希望有大佬稍微指点一下,万分感谢!! pojo
private Integer pageIndex =1;//当前页码
private Integer pageSize =3;//显示条数
private Integer totalCount =0; //总条数
private Integer pageTotalCount =0; //总页数
//每页显示的数据集合
private List<T> list = new ArrayList<T>();
sevice
@Override
public PageInfo<Admin> findPageInfo(String a_username, String a_describe,Integer a_id,Integer pageIndex, Integer pageSize) {
PageInfo<Admin> pi = new PageInfo<Admin>();
pi.setPageIndex(pageIndex);
pi.setPageSize(pageSize);
//获取总条数
Integer totalCount = adminDao.totalCount(a_username,a_describe,a_id);
if (totalCount>0){
pi.setTotalCount(totalCount);
//每一页显示管理员信息数
//currentPage = (pageIndex-1)*pageSize 当前页码数减1*最大条数=开始行数
List<Admin> adminList = adminDao.getAdminList(a_username,a_describe,a_id,
(pi.getPageIndex()-1)*pi.getPageSize(),pi.getPageSize());
pi.setList(adminList);
}
return pi;
}
dao
/**
* 进行分页查询
*/
//获取总条数
public Integer totalCount(@Param("a_username") String a_username, @Param("a_describe") String a_describe,@Param("a_id") Integer a_id);
//获取用户列表
public List<Admin> getAdminList(@Param("a_username") String a_username, @Param("a_describe") String a_describe,@Param("a_id") Integer a_id, @Param("currentPage") Integer currentPage, @Param("pageSize") Integer pageSize);
controller
/**
* 分页查询
*/
@RequestMapping(value = "/findAdmin")
public String findAdmin(String a_username, String a_describe,Integer pageIndex,
Integer a_id ,Integer pageSize, Model model) {
PageInfo<Admin> ai = adminService.findPageInfo(a_username,a_describe,
a_id,pageIndex,pageSize);
model.addAttribute("ai",ai);
return "admin_list";
}
page.jsp
<body>
<div class="page-bar" id="pg_div">
<ul class="page-num-ul">
<li class="pg-li">共${param.totalCount}条记录 ${param.currentPageNo}/${param.totalPageCount}页
<c:if test="${param.currentPageNo>1}">
<a class="pg_a" href="javascript:page_nav(document.forms[0],1);">首页</a>
<a class="pg_a" href="javascript:page_nav(document.forms[0],${param.currentPageNo-1});">上一页</a>
</c:if>
<c:if test="${param.currentPageNo<param.totalPageCount}">
<a class="pg_a" href="javascript:page_nav(document.forms[0],${param.currentPageNo+1});">下一页</a>
<a class="pg_a" href="javascript:page_nav(document.forms[0],${param.totalPageCount});">最后一页</a>
</c:if>
</li>
</ul>
<ul class="page-go-form"><label>跳转至</label>
<input type="text" name="inputPage" id="inputPage" class="page-key" />页
<button type="button" class="page-btn" onClick='jump_to(document.forms[0],document.getElementById("inputPage").value)'>GO</button>
</ul>
</div>
</body>
admin_list.jsp
<head>
<meta name="renderer" content="webkit|ie-comp|ie-stand">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<meta name="viewport" content="width=device-width,user-scalable=yes, minimum-scale=0.4, initial-scale=0.8,target-densitydpi=low-dpi" />
<%--<meta http-equiv="Cache-Control" content="no-siteapp" />--%>
<link rel="icon" href="/images/favicon.ico" sizes="32x32" />
<link rel="stylesheet" href="/css/font.css">
<link rel="stylesheet" href="/css/xadmin.css">
<script type="text/javascript" src="/js/jquery-1.3.2.min.js"></script>
<script src="/lib/layui/layui.js"></script>
<script type="text/javascript" src="/js/xadmin.js"></script>
<script src="/layui_exts/excel.js"></script>
<style type="text/css">
.layui-table{
text-align: center;
}
.layui-table th{
text-align: center;
}
</style>
</head>
<body>
<div class="x-nav">
<span class="layui-breadcrumb">
<a href="">首页</a>
<a href="/findAdmin">管理员信息</a>
</span>
<a class="layui-btn layui-btn-small" style="line-height:1.6em;margin-top:3px;float:right" href="/findAdmin" title="刷新">
<i class="layui-icon" style="line-height:30px">ဂ</i></a>
</div>
<div class="x-body">
<div class="layui-row">
<form class="layui-form layui-col-md12 x-so" action="/findAdmin" >
<input type="hidden" class="layui-input" placeholder="请输入用户名" name="a_id" id="a_id">
<input class="layui-input" placeholder="请输入用户名" name="a_username" id="a_username">
<input class="layui-input" placeholder="请输入级别描述" name="a_describe" id="a_describe" >
<input class="layui-input" type="hidden" name="pageIndex" value="1">
<input class="layui-input" type="hidden" name="pageSize" value="3">
<button class="layui-btn" lay-submit="" lay-filter="search"><i class="layui-icon"></i></button>
</form>
</div>
<xblock>
<button id="addStudnetBtn" class="layui-btn layui-btn-normal"> <i class="layui-icon"></i>添加</button>
<button class="layui-btn layui-btn-warm" lay-filter="toolbarDemo" lay-submit=""><i class="layui-icon"></i>导出</button>
<span class="x-right" style="line-height:40px">共有数据:${ai.totalCount} 条</span>
</xblock>
<%--表格数据--%>
<table class="layui-table" >
<thead>
<tr>
<%--<th>--%>
<%--<div class="layui-unselect header layui-form-checkbox" lay-skin="primary"><i class="layui-icon"></i></div>--%>
<%--</th>--%>
<th>ID</th>
<th>用户名</th>
<%--<th>密码</th>--%>
<th>姓名</th>
<th>电话</th>
<%--<th>级别</th>--%>
<th>级别描述</th>
<th>操作</th>
</thead>
<tbody>
<c:forEach items="${ai.list}" var="ai">
<tr>
<%--<td>--%>
<%--<div class="layui-unselect layui-form-checkbox" lay-skin="primary" data-id='2'><i class="layui-icon"></i></div>--%>
<%--</td>--%>
<%--<td>${class.c_id}</td>--%>
<td class="myid">${ai.a_id}</td>
<td>${ai.a_username}</td>
<%--<td>${ai.a_password}</td>--%>
<td>${ai.a_name}</td>
<td>${ai.a_phone}</td>
<%--<td>${ai.a_power}</td>--%>
<td>${ai.a_describe}</td>
<td class="td-manage">
<%--href="/findAdminById?a_id=${ai.a_id}"--%>
<a title="编辑" class="updateEdit" href="#">
<i class="layui-icon"></i>
</a>
<a title="删除" onclick="member_del(this,'${ai.a_id}','${ai.a_power}')" href="javascript:;">
<i class="layui-icon"></i>
</a>
</td>
</tr>
</c:forEach>
</tbody>
</table>
<%--添加模态框--%>
<div class="layui-row" id="test" style="display: none;">
<div class="layui-col-md10">
<form class="layui-form" id="addEmployeeForm">
<div class="layui-form-item">
<label class="layui-form-label">用户名:</label>
<div class="layui-input-block">
<input type="text" name="a_username" class="layui-input" placeholder="请输入用户名">
</div>
</div>
<div class="layui-form-item">
<label class="layui-form-label">密码:</label>
<div class="layui-input-block">
<input type="password" lay-verify="required" name="a_password" class="layui-input" placeholder="请输入密码">
</div>
</div>
<div class="layui-form-item">
<label class="layui-form-label">姓名:</label>
<div class="layui-input-block">
<input type="text" name="a_name" class="layui-input" placeholder="请输入姓名">
</div>
</div>
<div class="layui-form-item">
<label class="layui-form-label">电话:</label>
<div class="layui-input-block">
<input type="text" name="a_phone" class="layui-input" placeholder="请输入电话">
</div>
</div>
<div class="layui-form-item">
<label class="layui-form-label">级别:</label>
<div class="layui-input-block">
<input type="text" lay-verify="required" name="a_power" class="layui-input" placeholder="请输入级别1-2">
</div>
</div>
<div class="layui-form-item">
<label class="layui-form-label">级别描述:</label>
<div class="layui-input-block">
<input type="text" name="a_describe" class="layui-input" placeholder="请输入级别描述">
</div>
</div>
<div class="layui-form-item">
<div class="layui-input-block">
<button type="button" class="layui-btn layui-btn-normal" lay-submit lay-filter="formDemo">提交</button>
<button type="reset" class="layui-btn layui-btn-primary">重置</button>
</div>
</div>
</form>
</div>
</div>
<div class="" >
<input type="hidden" id="totalPageCount" value="${ai.pageTotalCount}"/>
<c:import url="pageBtn.jsp">
<c:param name="totalCount" value="${ai.totalCount}"/>
<c:param name="currentPageNo" value="${ai.pageIndex}"/>
<c:param name="totalPageCount" value="${ai.pageTotalCount}"/>
</c:import>
</div>
</div>
<script>
layui.config({
base: 'layui_exts/',
}).extend({
excel: 'excel',
});
layui.use(['jquery', 'excel', 'form','layer','laydate'], function(){
var form = layui.form,
$ = layui.jquery,
laydate = layui.laydate;
var excel = parent.layui.excel;
//执行一个laydate实例
laydate.render({
elem: '#start' //指定元素
});
form.render();
form.on('submit(toolbarDemo)', function(){
$.ajax({
url: '/exportadminlist',
type: 'post',
dataType: 'json',
contentType: "application/json; charset=utf-8",
success: function (data) {
console.log(data);
// 1. 如果需要调整顺序,请执行梳理函数
var dt = excel.filterExportData(data, [
'a_id'
,'a_username'
,'a_name'
,'a_phone'
,'a_describe'
]);
// 2. 数组头部新增表头
dt.unshift({a_id: 'ID', a_username: '用户名', a_name: '姓名', a_phone: '电话', a_describe: '级别描述'});
// 意思是:A列40px,B列60px(默认),C列120px,D、E、F等均未定义
var colConf = excel.makeColConfig({
'A': 40,
'D': 90
}, 60);
var timestart = Date.now();
// 3. 执行导出函数,系统会弹出弹框
excel.exportExcel({
sheet1: dt
}, '管理员数据.xlsx', 'xlsx', {
extend: {
'!cols': colConf
}
});
var timeend = Date.now();
var spent = (timeend - timestart) / 1000;
layer.alert('导出耗时 '+spent+' s');
//setTimeout(function () {window.location.href='/findAdmin';},2000);
},
error: function () {
//console.log(data);
setTimeout(function () {window.location.href='/findAdmin';},2000);
}
});
});
/*添加弹出框*/
$("#addStudnetBtn").click(function () {
layer.open({
type:1,
title:"添加管理员",
skin:"myclass",
area:["50%"],
anim:2,
content:$("#test").html()
});
$("#addEmployeeForm")[0].reset();
form.on('submit(formDemo)', function(data) {
// layer.msg('aaa',{icon:1,time:3000});
var param=data.field;
// console.log(JSON.stringify(param));
$.ajax({
url: '/addAdmin',
type: "post",
data:JSON.stringify(param),
contentType: "application/json; charset=utf-8",
success:function(da){
console.log(da);
layer.msg('添加成功', {icon: 1, time: 2000});
setTimeout(function () {window.location.href='/findAdmin';},2000);
},
error:function(){
layer.msg('添加失败',{icon:0,time:2000});
setTimeout(function () {window.location.href='/findAdmin';},2000);
}
});
// return false;
});
});
});
/*编辑*/
$(".updateEdit").click(function () {
var myid = $(this).parent("td").parent("tr").children(".myid").html();
//判断
var admin_id = ${sessionScope.ad.a_id};
if(admin_id != myid){
layer.alert("对不起,您没有权限:(");
}else {
<%--window.location.href = "/findAdminById?a_id=${ai.a_id}";--%>
window.location.href = "/findAdminById?a_id=" + myid;
}
});
/*删除*/
function member_del(obj,a_id,a_power){
var power = ${sessionScope.ad.a_power};
var id = ${sessionScope.ad.a_id};
if(power != 1 && id != a_id){
layer.alert("对不起,您没有权限:(");
}
// else if(power == 1 && id == a_id){
// layer.alert("对不起,您没有权限:(");
// }
else {
layer.confirm('确认要删除吗?',function(index){
//发异步删除数据
$.get("/deleteAdmin",{"a_id":a_id},function (data) {
if(data = true){
layer.msg('删除成功!',{icon:1,time:2000});
setTimeout(function () {window.location.href='/findAdmin';},2000);
}else {
layer.msg('删除失败!',{icon:1,time:2000});
setTimeout(function () {window.location.href='/findAdmin';},2000);
}
});
});
}
}
</script>
</body>