ibatis中调用存储过程

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

lpacec

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

阅读量229

点赞数

分类专栏： ibatis 文章标签： iBATIS SQL XML

ibatis 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

[code]
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap
PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-2.dtd">

<sqlMap namespace="DxIncomeMonth">
<typeAlias alias="DX_Income" type="com.lp.webwork.domainDx.DX_Income" />
<typeAlias alias="incomeMonthQuery" type="com.lp.webwork.domainDx.DX_IncomeMonthQuery" />

<parameterMap id="queryMap" class="incomeMonthQuery">
<parameter property="year_month" jdbcType="VARCHAR" javaType="java.lang.String" />
</parameterMap>

<procedure id="queryDxIncomeMonth" parameterMap="queryMap" resultClass="DX_Income">
<![CDATA[{call ht_income_LT_month(?)}]]>
</procedure>
</sqlMap>
[/code]