<resultMap class="java.util.HashMap" id="expQuesMap">
<result property="qid" javaType="java.lang.Integer"/>
<result property="totalExp" javaType="java.lang.Integer" />
</resultMap>
<!-- 某天该用户按问题产生的经验值合计 -->
<select id="queryExpByQues" parameterClass="map" resultMap="expQuesMap">
<![CDATA[
SELECT qid , SUM(exp_reg) AS totalExp
FROM t_ruanko_ke_user_experience
WHERE cid = #cid# AND NAME = #name#
AND DATE_FORMAT(create_date , '%y-%m-%d') = #strDate#
<result property="qid" javaType="java.lang.Integer"/>
<result property="totalExp" javaType="java.lang.Integer" />
</resultMap>
<!-- 某天该用户按问题产生的经验值合计 -->
<select id="queryExpByQues" parameterClass="map" resultMap="expQuesMap">
<![CDATA[
SELECT qid , SUM(exp_reg) AS totalExp
FROM t_ruanko_ke_user_experience
WHERE cid = #cid# AND NAME = #name#
AND DATE_FORMAT(create_date , '%y-%m-%d') = #strDate#