mapper.xml使用注释

直接看代码

这个是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 */ 这个注释，