主頁(yè) > 知識(shí)庫(kù) > servlet分頁(yè)代碼示例

servlet分頁(yè)代碼示例

熱門標(biāo)簽:北票市地圖標(biāo)注 電銷機(jī)器人是有一些什么技術(shù) 地圖標(biāo)注線上教程 商洛電銷 杭州ai語(yǔ)音電銷機(jī)器人功能 杭州語(yǔ)音電銷機(jī)器人軟件 電銷機(jī)器人好賣么 高德地圖標(biāo)注樣式 四川保險(xiǎn)智能外呼系統(tǒng)商家

1.首先創(chuàng)建一個(gè)對(duì)象 UserData,用以保存從數(shù)據(jù)庫(kù)中獲取的數(shù)據(jù)。

復(fù)制代碼 代碼如下:

package com.tool;

import java.math.BigDecimal;
import java.util.Date;

/**
 * Created by lx_sunwei on 14-1-6.
 */
public class UserData {

    /**
     * EMP表中的數(shù)據(jù)屬性
     */
    private String ename;
    private String job;
    private BigDecimal empno;
    private BigDecimal mgr;
    private Date hireDate;
    private BigDecimal sal;
    private BigDecimal comm;
    private BigDecimal deptno;

    public BigDecimal getEmpno() {
        return empno;
    }

    public void setEmpno(BigDecimal empno) {
        this.empno = empno;
    }

    public BigDecimal getMgr() {
        return mgr;
    }

    public void setMgr(BigDecimal mgr) {
        this.mgr = mgr;
    }

    public Date getHireDate() {
        return hireDate;
    }

    public void setHireDate(Date hireDate) {
        this.hireDate = hireDate;
    }

    public BigDecimal getSal() {
        return sal;
    }

    public void setSal(BigDecimal sal) {
        this.sal = sal;
    }

    public BigDecimal getComm() {
        return comm;
    }

    public void setComm(BigDecimal comm) {
        this.comm = comm;
    }

    public BigDecimal getDeptno() {
        return deptno;
    }

    public void setDeptno(BigDecimal deptno) {
        this.deptno = deptno;
    }

    public String getEname() {
        return ename;
    }

    public void setEname(String ename) {
        this.ename = ename;
    }

    public String getJob() {
        return job;
    }

    public void setJob(String job) {
        this.job = job;
    }
}

2.創(chuàng)建一個(gè) DBHelper 對(duì)象用以與數(shù)據(jù)庫(kù)進(jìn)行交互

復(fù)制代碼 代碼如下:

package com.dao;

import com.tool.UserData;

import java.math.BigDecimal;
import java.sql.*;
import java.util.*;
import java.util.Date;

/**
 * Created by lx_sunwei on 14-1-6.
 */
public class DBHelper {

    Connection conn;  //數(shù)據(jù)庫(kù)連接對(duì)象
    PreparedStatement pt;  //SQL語(yǔ)句預(yù)處理對(duì)象
    ResultSet rs;  //結(jié)果集對(duì)象

    public  DBHelper(){
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");  //裝載驅(qū)動(dòng)
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }

    /**
     * 獲取當(dāng)前頁(yè)的數(shù)據(jù)
     * @param curPage
     * @param rowsPerPage
     * @return
     */
    public ListUserData> getData(int curPage, int rowsPerPage) {

        ListUserData> dataList = new ArrayList>();
        String url = "jdbc:oracle:thin:@localhost:1521:orcl";
        try {
            conn = DriverManager.getConnection(url,"scott","tiger");
            String sql = "select * from emp where rownum = ((? - 1) * "+rowsPerPage+" + "+rowsPerPage+") minus " +
                    " select * from emp where rownum = (? - 1) * "+rowsPerPage+" ";
            pt = conn.prepareStatement(sql);
            pt.setInt(1,curPage);
            pt.setInt(2,curPage);
            rs = pt.executeQuery();
            while (rs.next()){
                /**
                 * 從結(jié)果集中取得數(shù)據(jù)
                 */
                UserData userData = new UserData();
                BigDecimal empno = rs.getBigDecimal("empno");
                String ename = rs.getString("ename");
                String job = rs.getString("job");
                BigDecimal mgr = rs.getBigDecimal("mgr");
                Date hireDate = rs.getDate("hiredate");
                BigDecimal sal = rs.getBigDecimal("sal");
                BigDecimal comm = rs.getBigDecimal("comm");
                BigDecimal deptno = rs.getBigDecimal("deptno");
                /**
                 * 設(shè)置對(duì)象屬性
                 */
                userData.setEmpno(empno);
                userData.setEname(ename);
                userData.setJob(job);
                userData.setMgr(mgr);
                userData.setHireDate(hireDate);
                userData.setSal(sal);
                userData.setComm(comm);
                userData.setDeptno(deptno);
                dataList.add(userData);  //把對(duì)象添加集合中
            }
            rs.close();
            pt.close();
            conn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return dataList;
    }

    /**
     * 返回總頁(yè)數(shù)
     * @return
     */
    public int getMaxPage(int rowsPerPage) {
        int maxPage;
        int maxRowCount = 0;
        String url = "jdbc:oracle:thin:@localhost:1521:orcl";
        try {
            conn = DriverManager.getConnection(url,"scott","tiger");  //創(chuàng)建數(shù)據(jù)庫(kù)連接
            String sql = "select count(*) from emp";
            pt = conn.prepareStatement(sql);
            rs = pt.executeQuery();
            if (rs.next()){
                maxRowCount = rs.getInt(1);  //總行數(shù)
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        maxPage = (maxRowCount + rowsPerPage - 1) / rowsPerPage;  //總頁(yè)數(shù)
        return maxPage;
    }
}

3.創(chuàng)建 Servlet 對(duì)顯示頁(yè)面進(jìn)行控制

復(fù)制代碼 代碼如下:

package com.servlet;

import com.dao.DBHelper;
import com.tool.UserData;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.util.*;

/**
 * Created by lx_sunwei on 14-1-6.
 */
public class Servlet extends HttpServlet {

    public int rowsPerPage;  //每頁(yè)顯示的行數(shù)
    public int curPage;  //當(dāng)前頁(yè)頁(yè)碼
    public int maxPage;  //總共頁(yè)數(shù)
    DBHelper db = new DBHelper();
    public Servlet(){
        rowsPerPage = 5;
    }

    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String curPage1 = request.getParameter("page");  //獲取當(dāng)前頁(yè)頁(yè)碼
        if (curPage1 == null){
            curPage = 1;
            request.setAttribute("curPage",curPage);  //設(shè)置curPage對(duì)象
        }else {
            curPage = Integer.parseInt(curPage1);
            if (curPage 1){
                curPage = 1;
            }
            request.setAttribute("curPage",curPage);
        }

        ListUserData> dataList;
        dataList = db.getData(curPage,rowsPerPage);  //獲取當(dāng)前頁(yè)的數(shù)據(jù)
        maxPage = db.getMaxPage(rowsPerPage);  //獲取總頁(yè)數(shù)
        request.setAttribute("dataList",dataList);
        request.setAttribute("maxPage", maxPage);

        RequestDispatcher rd = request.getRequestDispatcher("pagemain.jsp");  //將請(qǐng)求轉(zhuǎn)發(fā)到pagemain.jsp頁(yè)面
        rd.forward(request,response);
    }

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        doPost(request,response);
    }
}

4.創(chuàng)建 JSP 頁(yè)面,顯示數(shù)據(jù)。

復(fù)制代碼 代碼如下:

%@ page import="java.util.List" %>
%@ page import="com.tool.UserData" %>
%@ page contentType="text/html;charset=UTF-8" language="java" %>
html>
head>
    title>servlet數(shù)據(jù)分頁(yè)/title>
    link rel="stylesheet" type="text/css" href="css.css">
/head>
body>
div style="margin-top: 15%; margin-left: 25%">
    table>
        caption>SCOTT用戶,EMP表中的數(shù)據(jù)/caption>
        %! int curPage,maxPage; %>
        % curPage =Integer.parseInt(request.getAttribute("curPage").toString()); %> !--取得當(dāng)前頁(yè)-->
        % maxPage =Integer.parseInt((String)request.getAttribute("maxPage").toString()); %> !--取得總頁(yè)數(shù)-->
        %if (request.getAttribute("dataList") == null){
        %>
        tr>
            td colspan="8">沒(méi)有數(shù)據(jù)/td>
        /tr>
        %
        }else {
        %>
        tr>
            !--表頭-->
            th>EMPNO/th>
            th>ENAME/th>
            th>JOB/th>
            th>MGR/th>
            th>HIREDATE/th>
            th>SAL/th>
            th>COMM/th>
            th>DEPTNO/th>
        /tr>
        %
            List list = (List) request.getAttribute("dataList");
            for (Object aList : list) {
                UserData userData = (UserData) aList;
        %>
        tr>
            !--取得表中數(shù)據(jù)-->
            td>%= userData.getEmpno() %>/td>
            td>%= userData.getEname() %>/td>
            td>%= userData.getJob() %>/td>
            td>%= userData.getMgr() %>/td>
            td>%= userData.getHireDate() %>/td>
            td>%= userData.getSal() %>/td>
            td>%= userData.getComm() %>/td>
            td>%= userData.getDeptno() %>/td>
        /tr>
        %
                }
            }
        %>
    /table>
/div>
div style="margin-top: 8%; margin-left: 29%">
    第%= curPage %>頁(yè),共%= maxPage %>頁(yè)nbsp;nbsp;
    %if (curPage > 1){
    %>
    a href="Servlet?page=1">首頁(yè)/a>
    a href="Servlet?page=%=curPage - 1%>">上一頁(yè)/a>
    %
    }else {
    %>
    首頁(yè) 上一頁(yè)
    %
        }%>
    %if (curPage maxPage){
    %>nbsp;nbsp;
    a href="Servlet?page=%=curPage + 1%>">下一頁(yè)/a>
    a href="Servlet?page=%=maxPage %>">尾頁(yè)/a>
    %
    }else {
    %>
    下一頁(yè) 尾頁(yè)
    %
        }%>
    nbsp;nbsp;轉(zhuǎn)至第nbsp;form name="form1" action="Servlet" method="get">
    label>
        select name="page" onchange="document.form1.submit()">
            %for ( int i = 1; i = maxPage; i++){
                if (i == curPage){
            %>
            !--當(dāng)前頁(yè)頁(yè)碼默認(rèn)選中-->
            option selected value="%= i%>">%= i %>/option>
            %
            }else {
            %>
            option value="%= i %>">%= i %>/option>
            %
                    }
                }%>
        /select>
    /label>
/form>nbsp;頁(yè)
/div>
/body>
/html>

web.xml 中的配置文件為:

復(fù)制代碼 代碼如下:

?xml version="1.0" encoding="UTF-8"?>
web-app xmlns="http://java.sun.com/xml/ns/javaee"
           xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
           xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
          http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
           version="3.0">

    servlet>
        servlet-name>Servlet/servlet-name>
        servlet-class>com.servlet.Servlet/servlet-class>
    /servlet>
    servlet-mapping>
        servlet-name>Servlet/servlet-name>
        url-pattern>/Servlet/url-pattern>
    /servlet-mapping>

/web-app>

把項(xiàng)目部署到 Tomcat 服務(wù)器上,輸入地址:http://localhost:8080/Servlet   這樣就可以看到效果

您可能感興趣的文章:
  • jsp servlet javaBean后臺(tái)分頁(yè)實(shí)例代碼解析
  • javabean servlet jsp實(shí)現(xiàn)分頁(yè)功能代碼解析
  • jsp+servlet+javabean實(shí)現(xiàn)數(shù)據(jù)分頁(yè)方法完整實(shí)例
  • Servlet實(shí)現(xiàn)分頁(yè)效果

標(biāo)簽:西藏 青島 云浮 貴州 紅河 江西 宿州 丹東

巨人網(wǎng)絡(luò)通訊聲明:本文標(biāo)題《servlet分頁(yè)代碼示例》,本文關(guān)鍵詞  servlet,分頁(yè),代碼,示例,servlet,;如發(fā)現(xiàn)本文內(nèi)容存在版權(quán)問(wèn)題,煩請(qǐng)?zhí)峁┫嚓P(guān)信息告之我們,我們將及時(shí)溝通與處理。本站內(nèi)容系統(tǒng)采集于網(wǎng)絡(luò),涉及言論、版權(quán)與本站無(wú)關(guān)。
  • 相關(guān)文章
  • 下面列出與本文章《servlet分頁(yè)代碼示例》相關(guān)的同類信息!
  • 本頁(yè)收集關(guān)于servlet分頁(yè)代碼示例的相關(guān)信息資訊供網(wǎng)民參考!
  • 推薦文章