mybatis 分页查询

  <!-- 分页查询 -->
  <select id="datalistPage" parameterType="page" resultType="pd" useCache="false">
    select *
    from exam_paper
    where 1=1
      <if test="pd.USERNAME != null and pd.USERNAME != ''"><!-- 关键词检索 -->
and
(
papername LIKE CONCAT(CONCAT('%', #{pd.USERNAME}),'%')
)
 </if>