package smartbi.demo.javaquery;
import java.io.BufferedReader;
import java.io.Reader;
import java.security.InvalidParameterException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.Collections;
import java.util.LinkedHashMap;
import java.util.List;
import java.util.Map;
import java.util.Map.Entry;
import org.apache.log4j.Logger;
import smartbi.connectionpool.ConnectionPool;
import smartbi.freequery.metadata.IJavaQueryData;
import smartbi.freequery.metadata.JavaQueryConfig;
import smartbi.freequery.metadata.JavaQueryOutputField;
import smartbi.freequery.metadata.JavaQueryParameter;
import smartbi.freequery.querydata.CellData;
import smartbi.freequery.querydata.GridData;
import smartbi.net.sf.json.JSONObject;
import smartbi.util.DbUtil;
import smartbi.util.StringUtil;
import smartbi.util.ValueType;
public class CellStringSplitToRows implements IJavaQueryData {
public static final String CN_DS_ID = "DS_ID"; // config name
public static final String CN_QUERY_SQL = "QUERY_SQL"; // config name
public static final String CN_IGNORE_EMPTY_VALUE = "IGNORE_EMPTY_VALUE"; // config name
public static final String SPLIT_DELIMITER = ",";
protected static final String ID_OUTPUT_FIELD_1 = "VALUES";
protected static final String NAME_OUTPUT_FIELD_1 = "values";
protected static final String ID_PARAMETER_1 = "SQL_PARAMETER_VALUES";
protected static final String NAME_PARAMETER_1 = "sqlParameterValues";
protected static final boolean USE_CACHE_DATA = false;
protected static final Logger LOG = Logger.getLogger(CellStringSplitToRows.class);
protected Map configs = new LinkedHashMap();
protected List outputFields;
protected List paramet