searchpagehelper.java

企业进销存源码

package com.web.util;

import javax.servlet.http.*;


public abstract class SearchPageHelper extends PageHelper {

    protected String defaultSqlStr = null;

    public String getSqlStr() {
        return this.defaultSqlStr;
    }

    public void setSqlStr(String sqlStr) {
        //replace default SQL sentence.
        this.defaultSqlStr = sqlStr;
    }

    public void setSqlStr(String sqlStr, HttpServletRequest request) {
        //replace default SQL sentence.

        String sessionName = SessionTool.getNameByRequest(request);
        request.getSession().setAttribute(sessionName, sqlStr);

        this.defaultSqlStr = sqlStr;
    }

    public abstract String getSqlStr(HttpServletRequest request);

    public Page getPage(HttpServletRequest request) {
        Page page = null;
        String s = "";
        s = getSqlStr(request);
        String s1 = (String) request.getSession().getAttribute("SQLSTR" + SessionTool.getNameByRequest(request));
        if (request.getParameter("jumpPage") == null) {
            setSqlStr(s, request);
            page = getPage("1", Page.defaultPageSize);
            request.getSession().setAttribute("SQLSTR" + SessionTool.getNameByRequest(request), s);
        } else {
            setSqlStr(s1, request);
            page = getPage(request.getParameter("jumpPage"), Page.defaultPageSize);
        }


        return page;
    }


    public Page getPage(HttpServletRequest request, int pageSize) {
        Page page = null;
        String s = "";
        s = getSqlStr(request);
        String s1 = (String) request.getSession().getAttribute("SQLSTR" + SessionTool.getNameByRequest(request));
        if (request.getParameter("jumpPage") == null) {
            setSqlStr(s, request);
            page = getPage("1", pageSize);
            request.getSession().setAttribute("SQLSTR" + SessionTool.getNameByRequest(request), s);
        } else {
            setSqlStr(s1, request);
            page = getPage(request.getParameter("jumpPage"), pageSize);
        }


        return page;
    }
}