MyBatis传入参数为list 数组 map
<!--Array:forech中的collection属性类型是array,collection的值必须是:list,item的值可以随意,Dao接口中参数名字随意 -->
<select id="getEmployeesArrayParams" resultType="Employees">
select *
from EMPLOYEES e
where e.EMPLOYEE_ID in
<foreach collection="array" item="id" index="index"
open="(" close=")" separator=",">
#{id}
</foreach>
</select>
<select id="getEmployeesMapParams" resultType="Employees">
select *
from EMPLOYEES e
<where>
<if test="departmentId!=null and departmentId!=''">
e.DEPARTMENT_ID=#{departmentId}
</if>
<if test="employeeIdsArray!=null and employeeIdsArray.length!=0">
AND e.EMPLOYEE_ID in
<foreach collection="employeeIdsArray" item="employeeId"
index="index" open="(" close=")" separator=",">
#{employeeId}
</foreach>
</if>
</where>
</select>
更多相关文章
- Java正则表达式过滤脚本威胁--封装类
- Linux下安装linux tar.gz包
- 更改sqlplus命令提示符的样式
- Spring Security + OAuth2 精讲 多场景打造企业级认证与授权
- Server Core App Compatibility
- 来勾搭吗?我是运维服务商
- crontab 拨号 不生效
- python utc时间转北京时间
- 新人