<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#
GROUP BY qid ORDER BY create_date DESC;
]]>
</select>
DAO使用时调用方式:
Map params = new HashMap();
params.put("cid" , new Integer(cid));
params.put("name" , name);
params.put("strDate" , strDate);
sqlMap.queryForMap("queryExpByQues" , params , "qid" , "totalExp");
返回一个MAP,参数1:statement名称;参数2:查询参数字段;参数3:KEY值;参数4:VALUE值(可选)