private String getQueryParameter(HttpServletRequest request,String paramName) {
		String value = request.getParameter(paramName);
		if (StringUtils.isBlank(value)) {
			return null;
		}
		return value.trim();
	}
	
	private List<String> getMultiValuesBySeparator(HttpServletRequest request,
			String paramName) {
		String sep = ",";
		List<String> list = new ArrayList<String>();
		String paramValue = getQueryParameter(request, paramName);
		if ( StringUtils.isNotBlank(paramValue) ) {
			String[] valueArray = paramValue.replaceAll("；", sep)
											.replaceAll("，", sep)
											.replaceAll(";", sep)
											.split(sep);
			for (String value : valueArray) {
				if (StringUtils.isNotBlank(value)) {
					list.add(value.trim());
				}
			}
		}
		return list;
	}
	
	private String getEncodeQueryParameter(HttpServletRequest request,String paramName){
		String value = request.getParameter(paramName);
		if(StringUtils.isBlank(value)){
			return null;
		} else {
			try {
				value = new String(value.trim().getBytes("ISO8859-1"), "utf-8");
//				System.out.println("Action Encode value ISO8859 ->utf-8  = " + value);
			} catch (UnsupportedEncodingException e) {
				e.printStackTrace();
			}
		}
		return value;
	}
	
	private List<String> getEncodeMultiValuesBySeparator(HttpServletRequest request,String paramName) throws UnsupportedEncodingException{
		String sep = ",";
		List<String> list = new ArrayList<String>();
		String paramValue = getEncodeQueryParameter(request,paramName);
		if( null  != paramValue ){
			String[] valueArray = paramValue.replaceAll("；", sep)
											.replaceAll("，", sep)
											.replaceAll(";", sep)
											.split(sep);
			for(String value : valueArray){
				if(StringUtils.isNotBlank(value)){
					list.add(value.trim());
				}
			}
		}
		return list;
	}
	
	private String writerMessageToClient(HttpServletResponse response,String message) throws IOException{
		response.reset();
		response.setContentType("text/plain;charset=UTF-8");
		PrintWriter writer = response.getWriter();
		writer.append(message.replaceAll("null", "").replaceAll("\r\n", "  "));
		writer.close();
		return null;
	}

private boolean isArrayBlank(String[] array) {
		boolean isBlank = false;
		if (array == null || array.length == 0) {
			isBlank = true;
		} else {
			int arraySize = array.length;
			logger.info("arraySize = " + arraySize);
			List<Boolean> isArrayBlankList = new ArrayList<Boolean>(arraySize);
			for (String value : array) {
				logger.info("StringUtils.isBlank(value) = " + StringUtils.isBlank(value));
				if (StringUtils.isBlank(value)) {
					isArrayBlankList.add(true);
				}
			}
			if (arraySize == isArrayBlankList.size()) {
				isBlank = true;
			}
		}
		System.out.println("isBlank = " + isBlank);
		return isBlank;
	}



            // and newuser.userGroupId in ('1', '2')  
		if( StringUtils.isNotBlank(zoneIds) ){
			sqlBuff.append("   and newuser.userGroupId in (").append( insql(zoneIds) ).append(")  ");
		}

private String insql(String ids){
		StringBuffer idsBuff = new StringBuffer();
		String semicolon = "'";
		String sep = "";
		String[] idArray = ids.split(",");
		for(String id : idArray){
			idsBuff.append(sep).append(semicolon).append(id).append(semicolon);
			sep = ",";
		}
		return idsBuff.toString();
	}
	
	private String insql(String[] ids){
		StringBuffer idsBuff = new StringBuffer();
		String semicolon = "'";
		String sep = "";
		for(String id : ids){
			idsBuff.append(sep).append(semicolon).append(id).append(semicolon);
			sep = ",";
		}
		return idsBuff.toString();
	}