您的当前位置:首页正文

mybatis mapper使用字段使用in 查询sql语句拼接

2024-11-29 来源:个人技术集锦
public PageResult<User> getUserList(@Param("condition")SidCustManage condition, Pageable pageHelper) ;
<if test="condition.custIds != null and condition.custIds != ''">
and sidCust.cust_id IN <foreach collection="condition.custIds" index="index" item="custid" open="(" separator="," close=")"> #{condition.custIds[${index}]} </foreach></if>
显示全文