package com.yc.utils;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.apache.commons.lang.StringUtils;
public class SqlParameterUtil {
	/**
	 * 字符串提取 如（select * from table1 where  a='&cccc&'）
	 * 则返回list
	 * @param sql
	 * @param split
	 * @return
	 */
	public static List<String> getReplaceParameter(String sql,String split)
	{
		int splitLength=split.length();
		List<String> list=new ArrayList<String>();
		int i=0;
		int postion=0;
		while(sql.indexOf(split,i)!=-1){
			i=sql.indexOf(split,i)+splitLength;
			postion=sql.indexOf(split, i);
			if(postion==-1)break;
			String temp=sql.substring(i,postion);
			i=postion+splitLength;
			list.add(temp);
		}
		return list;
	}
	/**
	 * 将地址栏参数封装成map
	 * @param param 如：formid=9802 and fieldid=hdtable
	 * @return
	 */
	public static Map<String,String> getParameter2Map(String param){
		Map<String,String> mapParam = new HashMap<String, String>();
		if(StringUtils.isBlank(param))return mapParam;
		String[]ps = param.split(" and ");
		String [] temp = null;
		for(int i=0;i<ps.length;i++){
			temp = ps[i].split("=");
			if(temp.length!=2)continue;
			mapParam.put(temp[0].trim(), temp[1].replace("'", ""));
		}
		return mapParam;
	}
	
	
	
	public static void main(String []args){
		String parameter = "formid = 9801 and fieldid=hdtable";
		Map<String,String> para = SqlParameterUtil.getParameter2Map(parameter);
		for(Map.Entry<String, String> entry : para.entrySet()){
//			System.out.println(entry.getKey());
//			System.out.println(entry.getValue());
		}
	}
}