1. sqlmap没有填写命名空间名称时:
<sqlMap namespace="" xmlns="http://ibatis.apache.org/mapping" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
确保调用的名称和sqlmap中的id保持一致,最好手工赋值一下,有时候手敲难免处错误
2. sqlmap填写了命名空间名称时:
<sqlMap namespace="WorkTask" xmlns="http://ibatis.apache.org/mapping" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
此时调用时,需要在前面加上命名空间名称.Id名称
var taskAllocationList = sqlMapper.QueryForList<TaskAllocation>("WorkTask.FindTaskAllocationByInputId", inputId);
SqlMap中可加可不加 命名空间.
3.Ibatis常用语法
<select id="SearchApplyDataIndexBackByIds" parameterClass="int" resultMap="ApplyDataIndexResultMap">
SELECT * FROM DC_APPLYDATAINDEXBACK
<dynamic prepend="WHERE">
<isNotEmpty prepend="AND" property="ApplyIndexIds">
APPLYINDEXID IN
<iterate property="ApplyIndexIds" open="(" close=")" conjunction=",">
$ApplyIndexIds[]$
</iterate>
</isNotEmpty>
</dynamic>
</select>
<select id="SearchApplyIndexCategorys" parameterClass="map" resultMap="ApplyIndexCategoryResultMap">
SELECT * FROM(
select t.*,ROWNUM as RN From (
Select * FROM DC_APPLYINDEXCATEGORY
<dynamic prepend="WHERE">
<isNotEmpty prepend="AND" property="ApplyId">
ApplyId = #ApplyId#
</isNotEmpty>
<isNotEmpty prepend="AND" property="ContainsStatus">
ApplyStatus IN
<iterate property="ContainsStatus" open="(" close=")" conjunction=",">
$ContainsStatus[]$
</iterate>
</isNotEmpty>
</dynamic>
ORDER BY ApplyId DESC) T)Q
WHERE Q.RN >#Start# AND Q.RN <= #End#
</select>