突然发现代码中 SQL 也不是那么丑陋

相信我，这是本站不支持横向滚动造成的。

SqlBuilder sql = SqlBuilder.builder()
        .init("""
                SELECT
                   ims_card_info.id,
                   ims_card_info.iccid,
                   ims_card_info.msisdn,
                   ims_card_info.imei,
                   ims_card_info.imsi,
                   ims_card_info.`status`,
                   ims_card_info.operator_account_id,
                   ims_card_info.first_active_time,
                   ims_card_info.account_open_time,
                   ims_card_info.silent_end_time,
                   ims_card_apn.apn_status
                FROM
                   ims_card_info
                LEFT JOIN ims_card_apn ON ims_card_apn.iccid = ims_card_info.iccid
                WHERE 1=1
                """)
        .append("and ims_card_info.id > {id}", cardSearchDTO.getId() != null)
        .append("and ims_card_info.operator_account_id = {operatorAccountId}", cardSearchDTO.getOperatorAccountId() != null)
        .append("and ims_card_info.status = {status}", cardSearchDTO.getStatus() != null && cardSearchDTO.getStatus().compareTo(-1) > 0)
        .append("and (ims_card_info.silent_end_time <= {silentEndTime} or ims_card_info.silent_end_time is null)", cardSearchDTO.getSilentEndTime() != null)
        .append("and ims_card_apn.apn_status = {apnStatus}", cardSearchDTO.getApnStatus() != null)
        .append("order by ims_card_info.id asc", true)
        .append("limit 2000", true);

MagicDBUtils.get(jdbcTemplate).selectList(sql.toString(), cardSearchDTO, CardInfoDTO.class);

https://magician-io.com