文章标题

最新推荐文章于 2022-05-12 11:32:07 发布

和Java狼狈为奸

最新推荐文章于 2022-05-12 11:32:07 发布

阅读量475

点赞数 1

分类专栏： jsp+servle java 文章标签：数据库分页

本文链接：https://blog.csdn.net/Myc_CSDN/article/details/49666919

版权

java 同时被 2 个专栏收录

17 篇文章 0 订阅

订阅专栏

jsp+servle

2 篇文章 0 订阅

订阅专栏

基于上面的分页，继续将Servlet也贴出来

import java.io.IOException;
import java.sql.SQLException;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import com.gxa.bj.lg.model.UserInfo;
import com.gxa.bj.lg.service.SerUserInfo;
@WebServlet(name="page",urlPatterns="/page.do")
public class PartPageServlet extends HttpServlet{
    SerUserInfo serU = new SerUserInfo();
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp)
            throws ServletException, IOException {
        HttpSession session = req.getSession();
        String Index = req.getParameter("hf"); 
        session.setAttribute("pageIndex", Index);
        int pageIndex = Integer.parseInt(Index);
        try {
            List<UserInfo> list = serU.getListPage(pageIndex);
            req.setAttribute("list", list);
            req.getRequestDispatcher("partPage.jsp").forward(req, resp);
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }
    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp)
            throws ServletException, IOException {
        doGet(req,resp);
    }
}

下面是测试的jsp页面（用了jstl标签）

<body>
  <script>
    function showPrve() {
        if(document.getElementById("hf").value=="") {
            document.getElementById("hf").value = 1;
        }else {
            var pageIndex = parseInt(document.getElementById("hf").value)-1;
            document.getElementById("hf").value = pageIndex;
        }
        document.form1.submit();
    }
    function showNext() {
        if(document.getElementById("hf").value == "") {
            document.getElementById("hf").value = 1;
        }else {
            var pageIndex = parseInt(document.getElementById("hf").value)+1;
            document.getElementById("hf").value = pageIndex;
        }
        document.form1.submit();
    }
  </script>
  <form method="post" name="form1" action="page.do">
    <table>
        <tr>
            <td>用户名</td>
            <td>邮箱</td>
        </tr>
        <c:forEach items="${requestScope.list }" var="user">
            <tr>
                <td>
                    ${user.getUserName()}
                </td>
                <td>
                    ${user.getUserEmail() }
                </td>
            </tr>

        </c:forEach>
        <input type="button" value="上一页" onclick="showPrve()" id="prve"/>
        <input type="button" value="下一页" onclick="showNext()" id="next"/>
        <input type="hidden" value="${sessionScope.pageIndex }" name = "hf" id="hf"/>
    </table>
  </form>
 </body>

和Java狼狈为奸

关注

1
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
文章标题

基于上面的分页，继续将Servlet也贴出来import java.io.IOException;import java.sql.SQLException;import java.util.List;import javax.servlet.ServletException;import javax.servlet.annotation.WebServlet;import javax.ser
复制链接

扫一扫

专栏目录