xml使用foreach

合集 - SQL(16)

1.SQL中模糊查询（like、REGEXP）的用法2023-02-232.SQL中GROUP_CONCAT相关用法2023-02-093.MYSQL中ORDER BY使用2022-08-114.MYSQL中 UNION ALL 与 ORDER BY 联合使用2022-08-105.MYSQL语法2022-07-226.MYSQL中EXISTS的用法2022-07-217.MYSQL中JOIN的用法2022-07-218.SQL优化2022-07-21

9.xml使用foreach2023-03-10

10.EXPLAIN 详解（SQL优化）2022-07-2111.mysql_存储过程_入门2022-05-0912.SQL中的case when then else end用法（数据库内容纵向变横向）2022-01-0813.MYSQL检索条件区分大小写（CAST、BINARY）2023-09-0714.sql_mode=only_full_group_by以及ANY_VALUE()2024-04-2615.异常com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction2022-09-0716.MYSQL中SHOW PROCESSLIST使用2024-07-24

收起

 

public class OrderScenicBindParam implements Serializable {
    private Long orgId;
    private List<Long> parkList;

    public Long getOrgId() {
        return orgId;
    }

    public void setOrgId(Long orgId) {
        this.orgId = orgId;
    }

    public List<Long> getParkList() {
        return parkList;
    }

    public void setParkList(List<Long> parkList) {
        this.parkList = parkList;
    }
}

List<Long>类型的入参 parkList

    <select id="selectScenicCodeByParkList" parameterType="cn.galasys.clota.ota.entity.OrderScenicBindParam" resultType="Long">
        select distinct code from order_scenic_bind_rule where is_deleted = 'false' and status = 'true' and org_id = #{orgId}
        and (
        <foreach collection="parkList" item="parkId" index="index" separator="or">
            scenic_id like concat('%',#{parkId},'%')
        </foreach>
        )
    </select>

String类型的入参 visitorId（1,2,3,4），使用 split(,)拆分成数组

    <select id="selectBlockGuestList" parameterType="cn.galasys.clota.ota.vo.hotel.HotelParam" resultType="cn.galasys.clota.ota.vo.hotel.BlockGuestDto">
        SELECT ov.visitor_type as visitorType,ov.visitor_name as visitorName,ov.document_info as documentInfo,ov.phone_number as phoneNumber,
        ov.document_type as documentType,ov.document_code as documentCode,ov.gender,ov.age_qualifying_code as ageQualifyingCode,ov.guest_type as guestType
        FROM order_visitor ov
        WHERE ov.order_id = #{orderId} AND ov.visitor_type = #{visitorType} AND ov.is_deleted = 'false'
        <if test="visitorId != null and visitorId != ''">
            and ov.id in
            <foreach item="visId" collection="visitorId.split(',')" open="(" separator="," close=")" index="index" >
                #{visId}
            </foreach>
        </if>
    </select>

 

参考：https://blog.csdn.net/qqqwwweeerasd/article/details/122990644