直接看代码

这个是XML内正确的用法。

<!-- order by create_time desc -->

    <select id="selectBookList" resultMap="BaseResultMap">
        <trim>
            select
            <include refid="Base_Column_List"/>
            from t_book_info
            <where>
                <if test="bookType != null">
                    and book_type = #{bookType}
                </if>
                <if test="rareFlag != null">
                    and rare_flag = #{rareFlag}
                </if>
                <if test="borrowFlag != null">
                    and borrow_flag = #{borrowFlag}
                </if>
                <if test="loseFlag != null">
                    and lose_flag = #{loseFlag}
                </if>
            </where>
            
            <!-- order by create_time desc -->

            <if test="pageNo != null">
                limit #{startNum},#{pageSize}
            </if>
        </trim>
    </select>

执行效果：

==>  Preparing: select id, book_name, book_price, book_auther, book_type, rare_flag, borrow_times, borrow_flag, lose_flag, press, press_date, remark, create_time, update_time from t_book_info limit ?,?
==> Parameters: 0(Integer), 10(Integer)
<==      Total: 10

注：不能使用 /* xxxx */ 这个注释，