在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 */ 这个注释,