ibatis中动态查询返回字段返回用resultClass="java.util.HashMap" 的问题

org.springframework.jdbc.BadSqlGrammarException: SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:  
--- The error occurred in jndi:/localhost/studen/WEB-INF/app-config/query/sqlmap/Test.xml. 
--- The error occurred while applying a result map. 
--- Check the QueryReport_QueryBucketTest.SELECT_QUERYUBUCKETTESTDETAIL_CN-AutoResultMap. 
--- Check the result mapping for the 'LPV_CNT_1' property. 
--- Cause: java.sql.SQLException: 列名无效

 

 

    <select id="SELECT_QUERYUBUCKETTESTDETAIL_CN" resultClass="java.util.HashMap" parameterClass="java.util.HashMap" 
       select yyyymmdd,
       <isNotEmpty prepend=" " property="user_type">
             <isEqual property="user_type" compareValue="1">
                cookie_cnt as  cookie_cnt_1
             </isEqual>
              <isEqual property="user_type" compareValue="2">
                cookie_cnt as  cookie_cnt_2
             </isEqual>
              <isEqual property="user_type" compareValue="3">
                cookie_cnt as  cookie_cnt_3
             </isEqual>
      </isNotEmpty>

 

当user_type=1查询的时候列名是cookie_cnt_1, 如果第一次查询user_type=1，那么第二次查询user_type=2就会报这个错，因为ibatis保留列名为第一次查询时候的列名cookie_cnt_1，ibatis可以设置一个参数remapResults="true"，每次查询都重新更新列名，

 

<select id="SELECT_QUERYUBUCKETTESTDETAIL_CN" resultClass="java.util.HashMap" parameterClass="java.util.HashMap"  remapResults="true"