myBatisPlus的IPage分页

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