共4个文件

requestLogList.jsp

RequestInfoController.java

RequestInfoBean.java

RequestInfoService.java

 

1、requestLogList.jsp

功能点：

1.1、总个数：页面加载时COUNT(1)查询总数

1.2、总页数：总个数 %（取模）每页显示数量，如果正好结果为0时，总数除以每页显示数量为总页数，不能整除就是总数除以每页显示数量的加上1为总页数。

如：rs.getInt("TTL_CNT") % Constant.UNIT_CNT == 0 ? rs.getInt("TTL_CNT") / Constant.UNIT_CNT : rs.getInt("TTL_CNT") / Constant.UNIT_CNT + 1;

1.3、首页：点击 首页 时指向第一页

1.4、上一页：当前页 - 1（当前页保存在session当中）

1.5、上一页：当前页 + 1

1.6、尾页：总页数

1.7、直接访问：直接用js方式调用后台，传递页数

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%><%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
     <%@ include file="top.jsp" %>
访问日志查询
     
      
      
      
          
      
      
           
        
                 
NO
                 
characterEncoding
                 
contentType
                 
contextPath
                 
localAddr
                 
localName
                 
localPort
                 
method
                 
remoteAddr
                 
remoteHost
                 
remotePort
                 
remoteUser
                 
requestURI
                 
requestedSessionId
                 
locale
                 
regiDt
            
            
                 
          
                 
          
                  
          
                 
          
                 
          
                 
          
                 
          
                 
          
                 
          
                 
          
                 
          
                 
          
                 
          
                 
          
                 
          
                 
          
            
           
      
     
总个数：${sessionScope.ttlCnt} 页  
总页数：${sessionScope.ttlPage} 页  
首页 |   
         
      
               上一页     
          
              
       上一页 |       
      
     
         
      
               下一页      
          
              
       下一页  |     
      
      尾页      直接访问:<%@ include file="bottom.jsp" %>

2、RequestInfoController.java

package com.test.system.controller;import java.io.IOException;import java.util.ArrayList;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.test.system.bean.RequestInfoBean;import com.test.system.service.RequestInfoService;/** * Servlet implementation class RequestInfoController */@WebServlet("/RequestInfoController")public class RequestInfoController extends HttpServlet {    private static final long serialVersionUID = 1L;           /**     * @see HttpServlet#HttpServlet()     */    public RequestInfoController() {        super();    }    /**     * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)     */    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {                String callTp = request.getParameter("callTp");        if (callTp.equals("requestInfoList")) {            int now_page_num = 1;                        RequestInfoService ris = new RequestInfoService();            ArrayList
     
       requestInfoList = ris.getRequestInfoList("", now_page_num);                        HttpSession session = request.getSession();            // 当前页面（第一次查询时设置成第一页）            session.setAttribute("now_page_num", now_page_num);                        // 总页数            int ttlPage = ris.getTtlPage();            session.setAttribute("ttlPage", ttlPage);            // 获取总数             int ttlCnt = ris.getTtlCount();            session.setAttribute("ttlCnt", ttlCnt);                        request.setAttribute("requestInfoList", requestInfoList);            request.getRequestDispatcher("/view/requestLogList.jsp").forward(request, response);                    } else if (callTp.equals("requestInfoPageList")) {            RequestInfoService ris = new RequestInfoService();            ArrayList
      
        requestInfoList = ris.getRequestInfoList("", Integer.parseInt(request.getParameter("now_page_num")));                        HttpSession session = request.getSession();            session.setAttribute("now_page_num", request.getParameter("now_page_num"));                        // 总页数            int ttlPage = ris.getTtlPage();            session.setAttribute("ttlPage", ttlPage);                        // 获取总数             int ttlCnt = ris.getTtlCount();            session.setAttribute("ttlCnt", ttlCnt);                        request.setAttribute("requestInfoList", requestInfoList);            request.getRequestDispatcher("/view/requestLogList.jsp").forward(request, response);                        }    }    /**     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)     */    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {        this.doGet(request, response);    }}
      
     

3、RequestInfoBean.java

package com.test.system.bean;public class RequestInfoBean {    private String characterEncoding = "";    private String contentType = "";    private String contextPath = "";    private String localAddr = "";    private String localName = "";    private int localPort = 0;    private String method = "";    private String remoteAddr = "";    private String remoteHost = "";    private int remotePort = 0;    private String remoteUser = "";    private String requestURI = "";    private String requestedSessionId = "";    private String locale = "";    private String regiDt = "";        private int RowSeq = 0;        public String getCharacterEncoding() {        return characterEncoding;    }    public void setCharacterEncoding(String characterEncoding) {        this.characterEncoding = characterEncoding;    }    public String getContentType() {        return contentType;    }    public void setContentType(String contentType) {        this.contentType = contentType;    }    public String getContextPath() {        return contextPath;    }    public void setContextPath(String contextPath) {        this.contextPath = contextPath;    }    public String getLocalAddr() {        return localAddr;    }    public void setLocalAddr(String localAddr) {        this.localAddr = localAddr;    }    public String getLocalName() {        return localName;    }    public void setLocalName(String localName) {        this.localName = localName;    }    public int getLocalPort() {        return localPort;    }    public void setLocalPort(int localPort) {        this.localPort = localPort;    }    public String getMethod() {        return method;    }    public void setMethod(String method) {        this.method = method;    }    public String getRemoteAddr() {        return remoteAddr;    }    public void setRemoteAddr(String remoteAddr) {        this.remoteAddr = remoteAddr;    }    public String getRemoteHost() {        return remoteHost;    }    public void setRemoteHost(String remoteHost) {        this.remoteHost = remoteHost;    }    public int getRemotePort() {        return remotePort;    }    public void setRemotePort(int remotePort) {        this.remotePort = remotePort;    }        public String getRemoteUser() {        return remoteUser;    }    public void setRemoteUser(String remoteUser) {        this.remoteUser = remoteUser;    }    public String getRegiDt() {        return regiDt;    }    public void setRegiDt(String regiDt) {        this.regiDt = regiDt;    }    public String getRequestURI() {        return requestURI;    }    public void setRequestURI(String requestURI) {        this.requestURI = requestURI;    }    public String getRequestedSessionId() {        return requestedSessionId;    }    public void setRequestedSessionId(String requestedSessionId) {        this.requestedSessionId = requestedSessionId;    }        public String getLocale() {        return locale;    }    public void setLocale(String locale) {        this.locale = locale;    }    public int getRowSeq() {        return RowSeq;    }    public void setRowSeq(int rowSeq) {        RowSeq = rowSeq;    }}

4、RequestInfoService.java

UNIT_CNT：每页显示数量（常量提取到Constant.java中）

now_page_num：当天页面

package com.test.system.service;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.util.ArrayList;import javax.servlet.http.HttpServletRequest;import com.test.common.Constant;import com.test.common.dao.BaseDao;import com.test.system.bean.RequestInfoBean;public class RequestInfoService {    private int idx = 1;        public RequestInfoService() {    }    // 保存request信息    public void saveRequestInfo(HttpServletRequest request){        Connection conn = null;        PreparedStatement pstmt = null;                    BaseDao baseDao = new BaseDao();        try {            conn = baseDao.dbConnection();        } catch (SQLException e1) {            e1.printStackTrace();        }                StringBuffer sqlBf = new StringBuffer();        sqlBf.setLength(0);                sqlBf.append("INSERT INTO REQUEST_INFO (REQUEST_INFO_SEQ               \n");        sqlBf.append("                        , CHARACTER_ENCODING             \n");        sqlBf.append("                        , CONTENT_TYPE                   \n");        sqlBf.append("                        , CONTEXT_PATH                   \n");        sqlBf.append("                        , LOCAL_ADDR                     \n");        sqlBf.append("                        , LOCAL_NAME                     \n");        sqlBf.append("                        , LOCAL_PORT                     \n");        sqlBf.append("                        , METHOD                         \n");        sqlBf.append("                        , REMOTE_ADDR                    \n");        sqlBf.append("                        , REMOTE_HOST                    \n");        sqlBf.append("                        , REMOTE_PORT                    \n");        sqlBf.append("                        , REMOTE_USER                    \n");        sqlBf.append("                        , REQUEST_URI                    \n");        sqlBf.append("                        , REQUESTED_SESSION_ID           \n");        sqlBf.append("                        , LOCALE                         \n");        sqlBf.append("                        , REGI_DT)                       \n");        sqlBf.append("VALUES(SEQ_REQUEST_INFO.NEXTVAL                          \n");        sqlBf.append("     , ?          \n");        sqlBf.append("     , ?          \n");        sqlBf.append("     , ?          \n");        sqlBf.append("     , ?          \n");        sqlBf.append("     , ?          \n");        sqlBf.append("     , ?          \n");        sqlBf.append("     , ?          \n");        sqlBf.append("     , ?          \n");        sqlBf.append("     , ?          \n");        sqlBf.append("     , ?          \n");        sqlBf.append("     , ?          \n");        sqlBf.append("     , ?          \n");        sqlBf.append("     , ?          \n");        sqlBf.append("     , ?          \n");                sqlBf.append("     , SYSDATE)   \n");        System.out.println(sqlBf.toString());                try {            pstmt = conn.prepareStatement(sqlBf.toString());            idx = 1;            pstmt.setString(idx++, request.getCharacterEncoding());            pstmt.setString(idx++, request.getContentType());            pstmt.setString(idx++, request.getContextPath());            pstmt.setString(idx++, request.getLocalAddr());            pstmt.setString(idx++, request.getLocalName());            pstmt.setInt(idx++, request.getLocalPort());            pstmt.setString(idx++, request.getMethod());            pstmt.setString(idx++, request.getRemoteAddr());            pstmt.setString(idx++, request.getRemoteHost());            pstmt.setInt(idx++, request.getRemotePort());            pstmt.setString(idx++, request.getRemoteUser());            pstmt.setString(idx++, request.getRequestURI());            pstmt.setString(idx++, request.getRequestedSessionId());            pstmt.setString(idx++, request.getLocale().toString());                        int i = pstmt.executeUpdate();            if (i == 1) {                System.out.println("##### save request success \n");            } else {                System.out.println("##### save request fail \n");            }        } catch (SQLException e) {            e.printStackTrace();        }                try {            baseDao.dbDisconnection();        } catch (SQLException e) {            e.printStackTrace();        }            }        // 查询List    public ArrayList
     
       getRequestInfoList(String str, int now_page_num){                Connection conn = null;        PreparedStatement pstmt = null;        ResultSet rs = null;                ArrayList
      
        requestInfoList = new ArrayList
       
        ();        BaseDao baseDao = new BaseDao();        try {            conn = baseDao.dbConnection();        } catch (SQLException e1) {            e1.printStackTrace();        }        StringBuffer sqlBf = new StringBuffer();        sqlBf.setLength(0);        sqlBf.append("SELECT  A.*                                                                     \n");        sqlBf.append("FROM    (SELECT T1.*                                                            \n");        sqlBf.append("              , ROWNUM AS ROW_SEQ                                               \n");        sqlBf.append("         FROM   (SELECT  CHARACTER_ENCODING                                     \n");        sqlBf.append("                       , CONTENT_TYPE                                           \n");        sqlBf.append("                       , CONTEXT_PATH                                           \n");        sqlBf.append("                       , LOCAL_ADDR                                             \n");        sqlBf.append("                       , LOCAL_NAME                                             \n");        sqlBf.append("                       , LOCAL_PORT                                             \n");        sqlBf.append("                       , METHOD                                                 \n");        sqlBf.append("                       , REMOTE_ADDR                                            \n");        sqlBf.append("                       , REMOTE_HOST                                            \n");        sqlBf.append("                       , REMOTE_PORT                                            \n");        sqlBf.append("                       , REMOTE_USER                                            \n");        sqlBf.append("                       , REQUEST_URI                                            \n");        sqlBf.append("                       , REQUESTED_SESSION_ID                                   \n");        sqlBf.append("                       , LOCALE                                                 \n");        sqlBf.append("                       , TO_CHAR(REGI_DT, 'YYYY/MM/DD HH24:MI:SS')   REGI_DT    \n");        sqlBf.append("                 FROM    REQUEST_INFO                                           \n");        sqlBf.append("                 ORDER BY REQUEST_INFO_SEQ DESC                                 \n");        sqlBf.append("                ) T1                                                            \n");        sqlBf.append("         WHERE ROWNUM < (? * ?) + 1                                             \n");        sqlBf.append("        ) A                                                                     \n");        sqlBf.append("WHERE A.ROW_SEQ > (? * (? - 1))                                                  \n");        sqlBf.append("ORDER BY A.ROW_SEQ                                                              \n");                try {            pstmt = conn.prepareStatement(sqlBf.toString());            pstmt.setInt(1, Constant.UNIT_CNT);            pstmt.setInt(2, now_page_num);            pstmt.setInt(3, Constant.UNIT_CNT);            pstmt.setInt(4, now_page_num);                        rs = pstmt.executeQuery();            while (rs.next()) {                RequestInfoBean rib = new RequestInfoBean();                                rib.setCharacterEncoding(rs.getString("CHARACTER_ENCODING"));                rib.setContentType(rs.getString("CONTENT_TYPE"));                rib.setContextPath(rs.getString("CONTEXT_PATH"));                rib.setLocalAddr(rs.getString("LOCAL_ADDR"));                rib.setLocalName(rs.getString("LOCAL_NAME"));                rib.setLocalPort(rs.getInt("LOCAL_PORT"));                rib.setMethod(rs.getString("METHOD"));                rib.setRemoteAddr(rs.getString("REMOTE_ADDR"));                rib.setRemoteHost(rs.getString("REMOTE_HOST"));                rib.setRemotePort(rs.getInt("REMOTE_PORT"));                rib.setRemoteUser(rs.getString("REMOTE_USER"));                rib.setRequestURI(rs.getString("REQUEST_URI"));                rib.setRequestedSessionId(rs.getString("REQUESTED_SESSION_ID"));                rib.setLocale(rs.getString("LOCALE"));                rib.setRegiDt(rs.getString("REGI_DT"));                rib.setRowSeq(rs.getInt("ROW_SEQ"));                                requestInfoList.add(rib);            }                    } catch (SQLException e) {            e.printStackTrace();        }                try {            baseDao.dbDisconnection();        } catch (SQLException e) {            e.printStackTrace();        }                return requestInfoList;    }            // 获取记录总数    public int getTtlCount(){        int ttlCnt = 0;   // Total Count                Connection conn = null;        PreparedStatement pstmt = null;        ResultSet rs = null;                BaseDao baseDao = new BaseDao();        try {            conn = baseDao.dbConnection();        } catch (SQLException e1) {            e1.printStackTrace();        }        StringBuffer sqlBf = new StringBuffer();        sqlBf.setLength(0);                sqlBf.append("SELECT  COUNT(1)    TTL_CNT          \n");        sqlBf.append("FROM    REQUEST_INFO                 \n");        try {            pstmt = conn.prepareStatement(sqlBf.toString());            rs = pstmt.executeQuery();            if (rs.next()) {                ttlCnt = rs.getInt("TTL_CNT");            }                    } catch (SQLException e) {            e.printStackTrace();        }                try {            baseDao.dbDisconnection();        } catch (SQLException e) {            e.printStackTrace();        }                        return ttlCnt;    }        // 获取页数    public int getTtlPage(){        int ttlPage = 0;   // Total Count                Connection conn = null;        PreparedStatement pstmt = null;        ResultSet rs = null;                BaseDao baseDao = new BaseDao();        try {            conn = baseDao.dbConnection();        } catch (SQLException e1) {            e1.printStackTrace();        }        StringBuffer sqlBf = new StringBuffer();        sqlBf.setLength(0);                sqlBf.append("SELECT  COUNT(1)    TTL_CNT          \n");        sqlBf.append("FROM    REQUEST_INFO                 \n");        try {            pstmt = conn.prepareStatement(sqlBf.toString());            rs = pstmt.executeQuery();            if (rs.next()) {                ttlPage = rs.getInt("TTL_CNT") % Constant.UNIT_CNT == 0 ? rs.getInt("TTL_CNT") / Constant.UNIT_CNT : rs.getInt("TTL_CNT") / Constant.UNIT_CNT + 1;            }                    } catch (SQLException e) {            e.printStackTrace();        }                try {            baseDao.dbDisconnection();        } catch (SQLException e) {            e.printStackTrace();        }                        return ttlPage;    }    }
       
      
     

 

测试结果：