ibatis调用存储过程

最新推荐文章于 2021-02-24 23:50:54 发布

jc_dreaming2

最新推荐文章于 2021-02-24 23:50:54 发布

阅读量82

点赞数

分类专栏： IBATIS 文章标签： iBATIS Java DAO

本文链接：https://blog.csdn.net/jc_dreaming2/article/details/83699996

版权

IBATIS 专栏收录该内容

5 篇文章 0 订阅

订阅专栏




    <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();
		}
	}