1.本来开始是准备传个参数值companyPartyId
SELECT
company_code,
company_name,
parent_party_id
FROM
company t
WHERE IF(
(SELECT
company_name
FROM
company
WHERE company_party_id = ${companyPartyId}) LIKE '%局' OR '%委',t.parent_party_id = ${companyPartyId} AND (t.company_name NOT LIKE '%局'OR '%委' ),t.company_party_id = ${companyPartyId} )
GROUP BY company_code
但是,考虑到这个参数值为空的情况下,所以需要对这个参数值判空处理,那么就有了加下来的脚本
SELECT
company_code,
company_name,
parent_party_id
FROM
company t
WHERE 1 = 1 IF(
(SELECT
company_name
FROM
company
WHERE 1 = 1) LIKE '%局'
OR '%委',
$ { IF(
ISNULL(companyPartyId),
"",
" and t.parent_party_id= '" + companyPartyId + "' "
) }
AND (
t.company_name NOT LIKE '%局'
OR '%委'
),
$ { IF(
ISNULL(companyPartyId),
"",
" and t.company_party_id = '" + companyPartyId + "' "
) }
)
GROUP BY company_code
注:
关注点,传参的方式,用${}