Mybatis 拦截器 SQL 日志进程

Question

我在我的项目中制作Mybatis sqllog intercepor。

倘。 #{__frch_CUST_0} #{__frch_CUST_1} ~~~ #{__frch_CUST_N}

如何获取参数值"__frch_CUST_n"？

// mybatis interceptor sql log function
public String getSqlLog(StatementHandler handler)
{
    String sql = handler.getBoundSql().getSql();
    Object param = handler.getParameterHandler().getParameterObject();
    List<ParameterMapping> paramMapping = handler.getBoundSql().getParameterMappings();
    // change ? value to replace point 
    for(ParameterMapping mapping:paramMapping)
    {
        sql = sql.replaceFirst("\?", "#{"+mapping.getProperty()+"}");
    }
    for(ParameterMapping mapping:paramMapping)
    {
        String sqlparam      = "#{"+mapping.getProperty()+"}";
        String sqlparamname  = mapping.getProperty();
        Object sqlparamvalue = ((Map) param).get(sqlparamname);
        if( !sqlparamname.startsWith("__frch_") )
        {
            if(isNull(sqlparamvalue))
            {
                sql = sql.replace(sqlparam, "NULL");
            }
            else
            {
                if(sqlparamvalue instanceof String)
                {
                    try
                    {
                        sql = sql.replace(sqlparam, "'"+getSQLString(sqlparamvalue.toString())+"'");
                    }
                    catch(Exception e)
                    {
                        sql = sql.replace(sqlparam, "'"+getSQLString(sqlparamvalue.toString())+"'");
                    }
                }
                else
                {
                    sql = sql.replace(sqlparam, sqlparamvalue.toString());
                }
            }
        }
        else
        {
            **// HOW CAN I DO HERE?**   
        }
    }       
    return sql;
}

感谢您阅读我的问题..

Answer 1

我解决了我自己。

mybatis 制作新的 arrayList 参数。 并使用它。

示例列表值

日期 = ['20180101'，'20180102'，'20180103'];

步骤 = ["计划"、"制作"、"设置"];

__frch_DATE_0

__frch_DATE_1

__frch_DATE_2

__frch_STEP_3

__frch_STEP_4

__frch_STEP_5

MYBATIS __frch_ = ['20180101

'，'20180102'，'20180103'，'计划'，'制造'，'设置']

所以我使用它。我的问题解决了。.

public String getSqlLog(StatementHandler handler)
{
    String sql = handler.getBoundSql().getSql();
    Object param = handler.getParameterHandler().getParameterObject();
    List<ParameterMapping> paramMapping = handler.getBoundSql().getParameterMappings();        
    List foreachlist = new ArrayList();
    for(ParameterMapping mapping:paramMapping)
    {
        sql = sql.replaceFirst("\?", "#{"+mapping.getProperty()+"}");
    }
    for(ParameterMapping mapping:paramMapping)
    {
        String sqlparam      = "#{"+mapping.getProperty()+"}";
        String sqlparamname  = mapping.getProperty();
        Object sqlparamvalue = ((Map) param).get(sqlparamname);
        if( !sqlparamname.startsWith("__frch_") )
        {
            if(isNull(sqlparamvalue))
            {
                sql = sql.replace(sqlparam, "NULL");
            }
            else
            {
                if(sqlparamvalue instanceof String)
                {
                    try
                    {
                        sql = sql.replace(sqlparam, "'"+getSQLString(sqlparamvalue.toString())+"'");
                    }
                    catch(Exception e)
                    {
                        sql = sql.replace(sqlparam, "'"+getSQLString(sqlparamvalue.toString())+"'");
                    }
                }
                else
                {
                    sql = sql.replace(sqlparam, sqlparamvalue.toString());
                }
            }
        }
        else
        {
            if( foreachlist.size() == 0 )
            {
                Map parammap = (Map)param;
                Iterator iterator = parammap.keySet().iterator();
                while(iterator.hasNext()) 
                {
                   String key = iterator.next().toString();
                   Object value = (Object)parammap.get(key);
                   if( value instanceof List )
                   {
                       List valuelist = (List)value;
                       for(int i=0;i<valuelist.size();i++)
                       {
                           foreachlist.add(valuelist.get(i));
                       }
                   }
                }
            }
            String buff = sqlparamname.split("__frch_")[1];
            int index  = Integer.parseInt(buff.substring(buff.lastIndexOf("_")+1));
            try
            {
                sql = sql.replace(sqlparam, "'"+getSQLString((String)foreachlist.get(index))+"'");
            }
            catch(Exception e)
            {
                ;
            }
        }
    }       
    return sql;
}