Bootstrap-Table服务端分页
后台源码地址: 点我自取
前台源码地址: 点我自取
后端myBatis分页查询语句如下:
<resultMap type="java.util.HashMap" id="reallyMap">
<id column="createTime" property="createTime" jdbcType="VARCHAR" />
<result column="subjects" property="subjects" jdbcType="VARCHAR" />
<result column="examName" property="examName" jdbcType="VARCHAR" />
<result column="startTime" property="startTime" jdbcType="VARCHAR"/>
<result column="endTime" property="endTime" jdbcType="VARCHAR"/>
</resultMap>
<!--id对应你的接口方法名-->
<select id="inputAllGame" resultMap="reallyMap" >
select
<include refid="Base_Column_List" />
from game
<where>
<if test="searchText!=null and searchText!=''">
POSITION(#{searchText} IN examName)
</if>
</where>
order by createTime desc
LIMIT #{pageNumber},#{pageSize}
</select>
效果如下: