java 查询条件的封装_java封装前端查询条件（通用）

import hengyi.oa.mobile.exception.ServiceException;

import java.io.UnsupportedEncodingException;

import java.util.List;

import java.util.Map;

import java.util.Map.Entry;

import javax.servlet.http.HttpServletRequest;

import org.apache.commons.lang.StringUtils;

/**

* 查询条件封装类

* @author     Xue.YQ

* @created    2018年11月11日

*/

public class TableTagBean

{

public static final int DEFAULT_PAGE_SIZE = 20;

private static final String DELIMITER = "\n";

private int m_page;

private int m_pageSize = DEFAULT_PAGE_SIZE;

private int m_total;

private String m_orderBy;

private boolean m_asc;

private StringMap m_condition = new StringMap();

private List m_list;

private boolean m_builded = false;

private String m_conditionParam = null;

private int m_pageCount;

private boolean m_canPrev;

private boolean m_canNext;

public TableTagBean() {}

public boolean getAsc() {

return m_asc;

}

public void setAsc(boolean asc) {

ensureNotBuilded();

m_asc = asc;

}

public StringMap getCondition() {

return m_condition;

}

public void setCondition(StringMap condition) {

ensureNotBuilded();

m_condition = condition;

}

public String getOrderBy() {

return m_orderBy;

}

public void setOrderBy(String orderBy) {

ensureNotBuilded();

m_orderBy = orderBy;

}

public int getPage() {

return m_page;

}

public void setPage(int page) {

ensureNotBuilded();

m_page = page;

}

public int getPageSize() {

return m_pageSize;

}

public void setPageSize(int pageSize) {

ensureNotBuilded();

m_pageSize = pageSize;

}

public int getTotal() {

return m_total;

}

public void setTotal(int total) {

ensureNotBuilded();

m_total = total;

}

public List getList() {

return m_list;

}

public void setList(List list) {

ensureNotBuilded();

m_list = list;

}

public void ensureNotBuilded() {

if (m_builded) {

throw new IllegalStateException(

"Can't set attribute to TableTagBean after build() is called.");

}

}

public boolean getCanNext() {

return m_canNext;

}

public boolean getCanPrev() {

return m_canPrev;

}

public String getConditionParam() {

return m_conditionParam;

}

public int getPageCount() {

return m_pageCount;

}

public void build() throws UnsupportedEncodingException {

if (m_condition.size() > 0) {

m_conditionParam = CryptoUtil.base64url_encode(m_condition

.toString(DELIMITER).getBytes("GBK"));

}

if (m_total % m_pageSize != 0) {

m_pageCount = m_total / m_pageSize + 1;

} else {

m_pageCount = m_total / m_pageSize;

}

m_canPrev = m_page > 0;

m_canNext = m_page < m_pageCount - 1;

m_builded = true;

}

public static TableTagBean getFromRequest(HttpServletRequest req)

throws UnsupportedEncodingException {

TableTagBean r = new TableTagBean();

String p = req.getParameter("p");

if (StringUtils.isNotEmpty(p) ) {

r.setPage(Integer.parseInt(p));

}

String o = req.getParameter("o");

if (StringUtils.isNotEmpty(o)) {

r.setOrderBy(o);

}

String a = req.getParameter("a");

if (StringUtils.isNotEmpty(a)) {

r.setAsc(a.equals("1"));

}

String c = req.getParameter("c");

if (StringUtils.isNotEmpty(c)) {

r.setCondition(decodeConditionParam(c));

}

return r;

}

private static StringMap decodeConditionParam(String c)

throws UnsupportedEncodingException {

String s = new String(CryptoUtil.base64url_decode(c), "GBK");

return new StringMap(s, DELIMITER);

}

public String getQueryParameter() {

StringBuffer sb=new StringBuffer();

sb.append("p="+m_page);

if(m_orderBy!=null) {

sb.append("&o="+m_orderBy+"&a="+(m_asc?"1":"0"));

}

if(m_conditionParam!=null) {

sb.append("&c="+m_conditionParam);

}

return sb.toString();

}

@Override

public String toString() {

StringBuffer sb = new StringBuffer();

sb.append("[TableTagBean]\r\n");

sb.append("m_page: " + m_page + "\r\n");

sb.append("m_pageSize :" + m_pageSize + "\r\n");

sb.append("m_total :" + m_total + "\r\n");

sb.append("m_orderBy :" + m_orderBy + "\r\n");

sb.append("m_asc :" + m_asc + "\r\n");

sb.append("m_condition :" + m_condition + "\r\n");

sb.append("m_list(size) :" + m_list.size() + "\r\n");

sb.append("m_builded :" + m_builded + "\r\n");

sb.append("m_conditionParam :" + m_conditionParam + "\r\n");

sb.append("m_pageCount :" + m_pageCount + "\r\n");

sb.append("m_canPrev :" + m_canPrev + "\r\n");

sb.append("m_canNext :" + m_canNext + "\r\n");

return sb.toString();

}

@SuppressWarnings({ "rawtypes", "unchecked" })

public static TableTagBean getFromParameter(HttpServletRequest request)

throws ServiceException

{

String start = request.getParameter("start");

String limit = request.getParameter("limit");

String asc = request.getParameter("dir");

String orderBy = request.getParameter("sort");

int page = (start != null) ? Integer.parseInt(start) : 0;

int pageSize = (limit != null) ? Integer.parseInt(limit) : 30;

boolean isAsc = "ASC".equals(asc);

TableTagBean ttb = new TableTagBean();

ttb.setPage(page);

ttb.setPageSize(pageSize);

ttb.setOrderBy(orderBy);

ttb.setAsc(isAsc);

Mapm = request.getParameterMap();

String isEncodeURI = request.getParameter("isEncodeURI");

if (m != null) {

for (Entry entry : m.entrySet()) {

String key = (String)entry.getKey();

Object[] value = (Object[])entry.getValue();

//            if("Y".equals(isEncodeURI)){

//                String v= java.net.URLDecoder.decode(value[0].toString(), "UTF-8");

//                ttb.getCondition().put(key, (value[0] == null) ? null :v);

//            }else{

ttb.getCondition().put(key, (value[0] == null) ? null : value[0].toString());

//            }

}

}

return ttb;

}

}

调用之处：

@RequestMapping("/listAgentAwaitRepor")

public ListlistAgentAwaitRepor(HttpServletRequest request) throws ServiceException

{

TableTagBean ttb = TableTagBean.getFromParameter(request);

return oldAgentAwaitReportSearchFacade.list(ttb);

}

取值之处：

String titleName = ttb.getCondition().get("titleName");

if(!GenericValidator.isBlankOrNull(titleName))

{

sql.append(" and biz.biz_title like :bizTitle ");

sqlParams.put("bizTitle", "%"+titleName.trim()+"%");

}