mybatis 使用原生sql 或者说直接使用sql语句当作参数

mapper.xml

<resultMap type="com.union.weixin.bean.CountData" id="CountDataResult">
        <result property="totalNum" column="totalNum" javaType="String"/>
        <result property="dimension" column="dimension" javaType="String"/>
    </resultMap>

    <select id="countResourceNum" parameterType="String" resultMap="CountDataResult">
			${value}
    </select>

DAO.java

public List<CountData> countResourceNum(@Param(value="value") String sql) throws Exception;

Controller.java

List<CountData> countDatas = countDataSV.countResourceNum(countSQL);