jsp页面分页按钮

弈浮生

于 2023-12-12 17:03:48 发布

阅读量57

点赞数

文章标签： java 前端 jsp

本文链接：https://blog.csdn.net/qq_43621676/article/details/134953952

版权

页面：

<div class="page-and-btn">
    <div class="pull-right">
        <ul class="pagination">
            <li>
                <a>第<font color="red">${jdbcDriverList.pageNum}</font>页,共<font color="red">${jdbcDriverList.pages}</font> 页</a>
                <a>每页显示<font color="red">${jdbcDriverList.pageSize}</font>条</a>
            </li>
            <li>
                <a onclick="toPage(${jdbcDriverList.navigateFirstPage}, ${jdbcDriverList.pageSize})">首页</a>
            </li>
            <c:if test="${jdbcDriverList.pageNum != jdbcDriverList.navigateFirstPage}">
                <li>
                    <a onclick="toPage(${jdbcDriverList.prePage}, ${jdbcDriverList.pageSize})">上一页</a>
                </li>
            </c:if>
            <c:forEach items="${jdbcDriverList.navigatepageNums}" var="pageNumber"
                       varStatus="status">
                <li><a onclick="toPage(${pageNumber}, ${jdbcDriverList.pageSize})">${pageNumber}</a></li>
            </c:forEach>
            <c:if test="${jdbcDriverList.pageNum != jdbcDriverList.navigateLastPage}">
                <li>
                    <a onclick="toPage(${jdbcDriverList.nextPage}, ${jdbcDriverList.pageSize})">下一页</a>
                </li>
            </c:if>
            <li>
                <a onclick="toPage(${jdbcDriverList.navigateLastPage}, ${jdbcDriverList.pageSize})">尾页</a>
            </li>
            <li>
                <a>共<font color="red">${jdbcDriverList.total}</font>条记录</a>
            </li>
        </ul>
    </div>
</div>

js代码:

function toPage(pageNum, pageSize) {
    let sysName = $("#sysName").val()
    let env = $("#env").val()
    let sqlExecutionResult = $("#sqlExecutionResult").val()
    let taskNo = $("#taskNo").val()
    let createdBy = $("#createdBy").val()
    let queryStartDate = $("#queryStartDate").val()
    let queryEndDate = $("#queryEndDate").val()
    let params = "";
    if (sysName.length > 0) {
        params = params + "&sysName=" + sysName;
    }
    if (env.length > 0) {
        params = params + "&env=" + env;
    }
    if (sqlExecutionResult.length > 0) {
        params = params + "&sqlExecutionResult=" + sqlExecutionResult;
    }
    if (taskNo.length > 0) {
        params = params + "&taskNo=" + taskNo;
    }
    if (createdBy.length > 0) {
        params = params + "&createdBy=" + createdBy;
    }
    if (queryStartDate.length > 0) {
        params = params + "&queryStartDate=" + queryStartDate;
    }
    if (queryEndDate.length > 0) {
        params = params + "&queryEndDate=" + queryEndDate;
    }
    window.location.href = basePath + "/jdbc/list?pageNum=" + pageNum + "&pageSize=" + pageSize + params;
}

后端接口，结合com.github.pagehelper:pagehelper的jar包：

@RequestMapping(value = UrlConstant.AUDIT_LIST, method = {RequestMethod.POST, RequestMethod.GET})
    public String list(Model model, JdbcSourceDTO jdbcSource) {
        PageInfo<JdbcSourceDTO> jdbcDriverList = jdbcAboutService.getJdbcDriverList(jdbcSource);
        //脚本预览url
        model.addAttribute("fileServerPreviewUrl", fileServerPreviewUrl);
        model.addAttribute("fileServerDownloadUrl", fileServerDownloadUrl);
        model.addAttribute("jdbcDriverList", jdbcDriverList);
        model.addAttribute("jdbcSource", jdbcSource);
        return "audit/listSql";
}

public PageInfo<JdbcSourceDTO> getJdbcDriverList(JdbcSourceDTO jdbcSourceDTO) {
        PageHelper.startPage(jdbcSourceDTO.getPageNum(), jdbcSourceDTO.getPageSize());
        List<JdbcSourceDTO> jdbcSourceList = sqlExecutionLogDao.getJdbcDriverList(jdbcSourceDTO);
        return new PageInfo<>(jdbcSourceList);

}

根据个人场景业务修改即可