<statements> <!-- 分页查询轮渡航线 --> <procedure id ="SelectPageFerryLines" parameterMap="IBatis.Maps.Common.pmpPagingProcedure" resultMap="rmpSelectPageFerryLines"> pro_query </procedure> </statements>SelectPageFerryLines 是 statement的ID pro_query是存储过程名运行的时候,总是提示: The parameter 'p_tableName' does not exist in the stored procedure 'SelectPageFerryLines'. Check your parameterMap.
<statements>
<!-- 分页查询轮渡航线 -->
<procedure id ="SelectPageFerryLines" parameterMap="IBatis.Maps.Common.pmpPagingProcedure" resultMap="rmpSelectPageFerryLines">
pro_query
</procedure>
</statements>SelectPageFerryLines 是 statement的ID
pro_query是存储过程名运行的时候,总是提示:
The parameter 'p_tableName' does not exist in the stored procedure 'SelectPageFerryLines'. Check your parameterMap.
不会。。你把rmpSelectPageFerryLines的resultMap帖出来。。少了参数应该没有存储过程需要的p_tableName
<customMap> <parameterMaps>
<!-- 分页查询轮渡航线的参数 -->
<parameterMap id="pmpSelectPageFerryLines">
<parameter name="curPage" type="System.Int32" />
<parameter name="pageSize" type="System.Int32" />
</parameterMap>
</parameterMaps> <statementMaps>
<!-- 分页查询轮渡航线 -->
<statement statementId="SelectPageFerryLines" parameterMap="pmpSelectPageFerryLines" resultClass="hashtable">
<property name="tableName">t_ferryline</property>
<property name="selectField" fixedValue="ferrylineid,startid,posthouseid,endid,subname,price,flre" ></property>
<property name="condition" fixedValue=""></property>
<property name="orderField" fixedValue=""></property>
<property name="curPage" fixedValue="#curPage#" ></property>
<property name="pageSize" fixedValue="#pageSize#" ></property>
</statement>
</statementMaps>
</customMap><?xml version="1.0" encoding="utf-8" ?>
<sqlMap xmlns="http://ibatis.apache.org/mapping" namespace ="IBatis.Maps.Common" >
<alias>
<typeAlias type="Traffic.Bll.BaseEntity,Traffic.Bll.Common" alias="BaseEntity"/>
</alias> <resultMaps>
<!-- 基类Entity的基本属性映射 -->
<resultMap id="rmpBaseEntity" class="BaseEntity">
<result column="RowCount" property="RowCount"/>
</resultMap>
</resultMaps> <parameterMaps>
<!-- 分页存储过程通用的查询参数 -->
<parameterMap id ="pmpPagingProcedure" class="hashtable">
<parameter column="p_tableName" property="tableName" type="string" />
<parameter column="p_selectField" property="selectField" type="string" />
<parameter column="p_condition" property="condition" type="string" />
<parameter column="p_orderField" property="orderField" type="string" />
<parameter column="p_curPage" property="curPage" type="int" />
<parameter column="p_pageSize" property="pageSize" type="int" />
</parameterMap>
</parameterMaps>
</sqlMap>