KeyWord.xml
<sql id="Key_Com_Column">
SELECT
BD_KEY_WORD.KEY_ID as keyId,
KEY_WORD as keyWord,
DESC_TYPE as descType,
KEY_TYPE as keyType,
BD_KEY_WORD.CREATE_TIME as createTime,
APPLY_TIME as applyTime,
BD_KEY_WORD.STATUS as status,
KEY_CAUSE as keyCause,
SF_COMPANY_INFO.COMPANY_NAME as comName
FROM
BD_KEY_WORD
LEFT JOIN
BD_KEY_COM
ON BD_KEY_WORD.KEY_ID = BD_KEY_COM.KEY_ID
LEFT JOIN
SF_COMPANY_INFO
ON BD_KEY_COM.COM_ID = SF_COMPANY_INFO.COM_ID
</sql>
<select id="sqlectKeyWordAndCom" resultType="com.geostar.bigdata.dto.KeyWordVo">
<include refid="Key_Com_Column"/>
WHERE 1 = 1
<if test="comName != null and comName != ''">
and SF_COMPANY_INFO.COMPANY_NAME like