reportutil.java

来自「一个专门用来快速开发网站的框架」· Java 代码 · 共 39 行

package com.core.report;

import java.io.UnsupportedEncodingException;

import javax.servlet.http.HttpServletRequest;

public class ReportUtil {
    /**
     * 根据参数从request中取出字段的值，拼接成SQl语句的where。
     * @param request
     * @param fieldNames
     * @return
     */
    public String getWhereFromRequest(HttpServletRequest request,String[] fieldNames,String[] likeNames){
        String ret=" where 1>0 ";
        try {
            request.setCharacterEncoding("GBK");
        } catch (UnsupportedEncodingException e) {
            e.printStackTrace();
        }
        for(int i=0;i<fieldNames.length;i++){
            String param=request.getParameter(fieldNames[i]);
            if(null!=param && !param.equals("")){
                ret+=" and "+fieldNames[i]+"='"+param+"' ";
            }
        }

        //(employer0_.AAB004 like '%煤矿%')
        for(int i=0;i<likeNames.length;i++){
            String param=request.getParameter(likeNames[i]);
            if(null!=param && !param.equals("")){
                ret+=" and "+likeNames[i]+" like'%"+param+"%' ";
            }
        }
        return ret;
    }

}