`

ibatis调用存储过程

阅读更多

 
    <resultMap class="HuiZongObject" id="HuiZongResult">
       <result property="casecontext" column="casecontext"/>
       <result property="shoujian" column="shoujian"/>
       <result property="banjian" column="banjian"/>
    </resultMap>


  <parameterMap id="getHuiZongQuery" class="map" >
		<parameter property="distictId" jdbcType="INTEGER" javaType="java.lang.Integer" mode="IN"/>
		<parameter property="deptId" jdbcType="INTEGER" javaType="java.lang.Integer" mode="IN"/>
		<parameter property="startdate" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
		<parameter property="dateEnd" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
	</parameterMap>



<procedure id="getHuiZong" parameterMap="getHuiZongQuery"  resultMap="HuiZongResult">
		  <![CDATA[
			{call getBanJianTongJibaobiao1(?,?,?,?)}
		 ]]>		
	 </procedure>




dao
public List getHuiZongList(Integer distictId,Integer deptId,String startdate,String dateEnd)throws DAOException
	{
		try {
			Map params = new HashMap();
			params.put("distictId", distictId);
			params.put("deptId", deptId);
			params.put("startdate", startdate);
			params.put("dateEnd", dateEnd);
			return smcTemplate.queryForList("PrintNotice.getHuiZong", params);
		} catch (Exception ex) {
			logger.error("执行:" + this.getClass()
					+ ".getHuiZong()方法出错!");
			logger.error(ex.getMessage());
			throw new DAOException();
		}
	}



用list获取该存储过程中的临时表中的值
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics