mybatis框架order by作为参数传入时失效的解决

<select id="stattoday" resulttype="com.dahua.la.business.model.vo.statsysresultvo">
      select a,
             b,
        count(1) as total
      from table
      where  a is not null
      and b is not null
      and operatetime >= #{starttime,jdbctype=timestamp}
      and operatetime <= #{endtime,jdbctype=timestamp}
      group by a, b
   order by
   <foreach collection="orderitems" item="item" separator=",">
      #{item.orderby} #{item.order}
   </foreach>
</select>

select a, b, count(1) as total 
from table 
where a is not null and b is not null 
and operatetime >= ? and operatetime <= ? 
group by a, b 
order by ? ?

<foreach collection="orderitems" item="item" separator=",">
    ${item.orderby} ${item.order}
</foreach>

order by ${columnname}