PageHelper分页的应用和模糊查询

点击后表示层代码编写：

/**
	 * 利用分页查看用户数据信息
	 * @param pageNum
	 * @param pageSize
	 * @param model
	 * @return
	 */
	@RequestMapping(value="/admin/index")
	public String ToAdminIndex(
			@RequestParam(value="pageNum",required=false,defaultValue="1")int pageNum,
			@RequestParam(value="pageSize",required=false,defaultValue="3")int pageSize,
			Model model,String condition
			) {
			PageHelper.startPage(pageNum, pageSize);//pageNum当前页，pageSize每页显示的数据个数
			PageInfo<TAdmin> queryAllAdmin = as.queryAllAdmin(condition);//condition模糊查询需要的数据
			model.addAttribute("queryAllAdmin",queryAllAdmin);//将查到的数据保存在model中
		return "admin/index";
	}

业务逻辑层代码编写：

@Override
	public PageInfo<TAdmin> queryAllAdmin(String condition) {
		TAdminExample example = new TAdminExample();
		if(!StringUtil.isEmpty(condition)) {
			Criteria criteria1 = example.createCriteria();
			criteria1.andLoginacctLike("%"+condition+"%");
			Criteria criteria2 = example.createCriteria();
			criteria2.andUsernameLike("%"+condition+"%");
			Criteria criteria3 = example.createCriteria();
			criteria3.andEmailLike("%"+condition+"%");
			example.or(criteria1);
			example.or(criteria2);
			example.or(criteria3);
		}
		List<TAdmin> allAdmins = tam.selectByExample(example);//example：当condition为空时，没有数据，不为空时为模糊查询内容。
		PageInfo<TAdmin> pageInfo = new PageInfo<TAdmin>(allAdmins,4);//allAdmins查到的所有用户信息，4表示分页时显示的页数
		return pageInfo;
	}

jsp页面编写的代码

<tbody>
	<c:forEach var="admin" items="${queryAllAdmin.list }" varStatus="status">
	<tr>
		<td>${status.count }</td>
		<td><input adminId="${admin.id }" type="checkbox"></td>
		<td>${admin.loginacct }</td>
		<td>${admin.username }</td>
		<td>${admin.email }</td>
		<td>
			<button type="button" class="btn btn-success btn-xs">
				<i class=" glyphicon glyphicon-check"></i>
			</button>
			<button type="button" class="btn btn-primary btn-xs" onclick="window.location.href='${PATH}/admin/toUpdate?id=${admin.id}&pageNum=${queryAllAdmin.pageNum }'">
				<i class=" glyphicon glyphicon-pencil"></i>
			</button>
			<button type="button" adminId="${admin.id}" class="deleteBtnClass btn btn-danger btn-xs">
				<i class=" glyphicon glyphicon-remove"></i>
			</button>
		</td>
	</tr>
	</c:forEach>

</tbody>
		<tfoot>
			<tr>
				<td colspan="6" align="center">
					<ul class="pagination">
					<c:if test="${queryAllAdmin.isFirstPage }">
						<li class="disabled"><a href="#">上一页</a></li>
					</c:if>
					<c:if test="${!queryAllAdmin.isFirstPage }">
						<li><a href="${PATH }/admin/index?pageNum=${queryAllAdmin.pageNum-1}&condition=${param.condition }">上一页</a></li>
					</c:if>
					<c:forEach items="${queryAllAdmin.navigatepageNums }" var="currentNum">
						<c:if test="${currentNum==queryAllAdmin.pageNum }">
						<li class="active"><a href="#">${currentNum } <span class="sr-only">(current)</span></a></li>
						</c:if>
						<c:if test="${currentNum!=queryAllAdmin.pageNum }">
						<li><a href="${PATH }/admin/index?pageNum=${currentNum }&condition=${param.condition }">${currentNum } <span class="sr-only">(current)</span></a></li>
						</c:if>
					</c:forEach>
					<c:if test="${queryAllAdmin.isLastPage }">
						<li class="disabled"><a href="#">下一页</a></li>
					</c:if>
					<c:if test="${!queryAllAdmin.isLastPage }">
						<li><a href="${PATH }/admin/index?pageNum=${queryAllAdmin.pageNum+1}&condition=${param.condition }">下一页</a></li>
					</c:if>
					</ul>
				</td>
			</tr>
		</tfoot>