java中List分頁的幾種方法介紹
1.根據入參帶分頁參數進行sql查詢分頁
Criteria criteria = new Criteria(); //將dataAuto轉成 factoryId brandId seriesId 等查詢條件 String dataAuth = ""; TypeCaseHelper.dataAuto(criteria, dataAuth); // 設置分頁信息 ExtPager pager = new ExtPager(); Integer startTure = start * pageSize; criteria.setMysqlPageSize(pageSize); criteria.setMysqlStart(startTure); // 排序信息 if (StringUtils.isNotBlank(pager.getDir()) && StringUtils.isNotBlank(pager.getSort())) { criteria.setOrderByClause(pager.getSort() + " " + pager.getDir()); } List<VhlAlarmStatusMgtEntity> listDistinct = getVhlAlarmStatusMgtEntities(vin, faultStatus, confirmStatus, startDateTime, endDateTime, sdf, sdfm, carTypeList, criteria);
對應的分頁sql
<select id="selectByExample" parameterType="Criteria" resultMap="BaseResultMap"> select <include refid="Base_Column_List" /> from status_mgt <where> <if test="condition.carTypeList != null and condition.carTypeList.size() > 0" > and car_type in <foreach collection="condition.carTypeList" item="item" open="(" separator="," close=")"> #{item} </foreach> </if> <if test="condition.startDateTime != null and condition.startDateTime!=''"> and alarm_time >= str_to_date(#{condition.startDateTime,jdbcType=VARCHAR},'%Y-%m-%d %H:%i:%S') </if> <if test="condition.endDateTime != null and condition.endDateTime!=''"> and str_to_date(#{condition.endDateTime,jdbcType=VARCHAR},'%Y-%m-%d %H:%i:%S') >= alarm_time </if> and logic_flag = 1 </where> order by alarm_time desc <if test="mysqlStart != null and mysqlPageSize != null"> limit #{mysqlStart}, #{mysqlPageSize} </if> </select>
2.對所有list根據分頁參數分頁
Criteria criteria1 = new Criteria(); List<VhlAlarmStatusMgtEntity> listDistinctForCout = getVhlAlarmStatusMgtEntities(vin, faultStatus, confirmStatus, startDateTime, endDateTime, sdf, sdfm, carTypeList, criteria1); Integer count = listDistinctForCout.size(); // 記錄總數 Integer pageCount; // 頁數 if (count % pageSize == 0) { pageCount = count / pageSize; } else { pageCount = count / pageSize + 1; } int fromIndex; // 開始索引 int toIndex; // 結束索引 if (!pageCount.equals(start+1)) { fromIndex = start * pageSize; toIndex = fromIndex + pageSize; if(toIndex > count){ fromIndex = (start-1) * pageSize; toIndex = count; } } else { fromIndex = start * pageSize; toIndex = count; } List<VhlAlarmStatusMgtEntity> pageList = listDistinctForCout.subList(fromIndex, toIndex);
3.PageHelper分頁
//開啟分頁 PageHelper.startPage(Integer.parseInt(pageNum), Integer.parseInt(pageSize)); PageInfo<Map<String, String>> pageInfo = new PageInfo(datalist); HashMap<String, Object> map= new HashMap<>(); map.put("datalist", datalist); map.put("total", pageInfo.getTotal()); map.put("size", pageInfo.getPageSize()); map.put("page", pageInfo.getPageNum());
到此這篇關於java中List分頁的幾種方法介紹的文章就介紹到這瞭,更多相關java List分頁方法內容請搜索WalkonNet以前的文章或繼續瀏覽下面的相關文章希望大傢以後多多支持WalkonNet!
推薦閱讀:
- Mybatis Example的高級用法詳解
- Mybatis圖文並茂講解分頁插件
- mybatis example如何自動生成代碼 排序語句
- js如何使用Pagination+PageHelper實現分頁
- Mysql大數據量查詢優化思路詳析