SQL server分页查询
SELECT * FROM [dbo].[news] order by [id] offset 0 rows fetch next 2 rows only
其中 offset 后面的相当于 mysql limit 后的第一个数字,代表从第几个数开始
next 后面的相当于 mysql limit 后的第二个数字,代表一页有多少行
xml文件的sql语句如下:
<select id="selectProjectItemList" resultType="java.util.HashMap">
SELECT t2.BidProjectId as bidProjectId,t2.BidProjectName as bidProjectName,t2.PurOrgName as purOrgName,
CONVERT(varchar(20),t2.LastModifyTime,20) as lastModifyTime FROM BidProjects t2
<where>
<if test="bidProjectName != null and bidProjectName != '' "> and t2.BidProjectName like '%'+#{bidProjectName}+'%' </if>
</where>
ORDER BY t2.LastModifyTime desc
offset ${page} rows fetch next ${limit} rows only
</select>
controller 空置层传值
@PostMapping("/selectProjectItemList")
@ResponseBody
public Response<?> selectProjectItemList(Integer page, Integer limit) {
Map<String, Object> map = new HashMap<>();
map.put("page", String.valueOf((page - 1) * limit));
map.put("limit", String.valueOf(limit));
List<Map<String, Object>> list = wxPublicService.selectProjectItemList(map);
return new Response<>(list);
}