配置文件
<delete id="deleteByids" parameterType="map" >
delete
from SYS_LOG
where LOGID in
<foreach collection="logids" index="index" item="item" open="(" separator="," close=")">
#{item}
</foreach>
</delete>
输出的日志
[springmvc_mybatis][DEBUG] [2015-09-27 16:33:23] org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(49) | ==> Preparing: delete from SYS_LOG where LOGID in ( ? , ? , ? , ? )
[springmvc_mybatis][DEBUG] [2015-09-27 16:33:23] org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(49) | ==> Parameters: 'L201509270008'(String), 'L201509270007'(String), 'L201509270006'(String), 'L201509270005'(String)
[springmvc_mybatis][DEBUG] [2015-09-27 16:33:23] org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(49) | <== Updates: 0
数据库查询

数据库删除