Ibatis Iterate的使用

最新推荐文章于 2019-06-21 16:59:01 发布

原创最新推荐文章于 2019-06-21 16:59:01 发布 · 771 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#ibatis #iterate

java 专栏收录该内容

10 篇文章

订阅专栏

本文介绍使用MyBatis框架时，对参数进行校验的方法，特别是如何正确配置和使用迭代器来避免运行时错误。当传递给SQL映射文件的参数不是集合、数组或迭代器类型时，会抛出异常。

用法

<isNotNull property="videoIdList" prepend="and">
                <![CDATA[ video_id IN ]]>
                <iterate property="videoIdList" open="(" close=")" conjunction=",">
                    <![CDATA[ #videoIdList[]# ]]>
                </iterate>
 </isNotNull>

<iterate property="videoIdList">不加 property会报如下异常信息

“org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];
— The error occurred in appName/sql-material.xml.
— The error occurred while preparing the mapped statement for execution.
— Check the material.list.
— Check the parameter map.
— Cause: com.ibatis.sqlmap.client.SqlMapException: ParameterObject or property was not a Collection, Array or Iterator.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
— The error occurred in appName/sql-material.xml.
— The error occurred while preparing the mapped statement for execution.
— Check the material.list.
— Check the parameter map.
— Cause: com.ibatis.sqlmap.client.SqlMapException: ParameterObject or property was not a Collection, Array or Iterator.”