MyBatis鐨刾agehelper鎬庝箞浣跨敤
PageHelper鏄竴涓狹yBatis鐨勫垎椤垫彃浠讹紝瀹冨彲浠ユ柟渚垮湴瀹炵幇鏁版嵁搴撴煡璇㈢粨鏋滅殑鍒嗛〉鍔熻兘銆備笅闈㈡槸浣跨敤PageHelper鐨勬楠わ細
- 鍦ㄩ」鐩殑pom.xml鏂囦欢涓坊鍔燩ageHelper鐨勪緷璧栵細
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>鐗堟湰鍙?span class="hljs-tag"></version>
</dependency>
- 鍦∕yBatis鐨勯厤缃枃浠朵腑锛屾坊鍔燩ageHelper鐨勬彃浠堕厤缃細
<plugins>
<plugin interceptor="com.github.pagehelper.PageInterceptor">
<!-- 鍚敤鍚堢悊鍖栨椂锛屽鏋減ageNum<1浼氭煡璇㈢涓€椤碉紝濡傛灉pageNum>pages浼氭煡璇㈡渶鍚庝竴椤?-->
<property name="reasonable" value="true"/>
</plugin>
</plugins>
- 鍦↗ava浠g爜涓娇鐢≒ageHelper杩涜鍒嗛〉鏌ヨ銆傞鍏堬紝闇€瑕佸湪闇€瑕佸垎椤电殑鏌ヨ鏂规硶涔嬪墠璋冪敤PageHelper鐨?code>startPage鏂规硶锛岃鏂规硶浼氳嚜鍔ㄥ皢鎺ヤ笅鏉ョ殑涓€鏉℃煡璇㈣鍙ヨ繘琛屽垎椤点€備緥濡傦細
// 鍦ㄦ煡璇㈡柟娉曚箣鍓嶈皟鐢╯tartPage鏂规硶
PageHelper.startPage(pageNum, pageSize);
// 鎵ц鏌ヨ鏂规硶
List<User> users = userDao.selectUsers();
鍏朵腑锛?code>pageNum琛ㄧず瑕佹煡璇㈢殑椤电爜锛?code>pageSize琛ㄧず姣忛〉鐨勮褰曟暟銆?code>selectUsers鏂规硶鏄嚜宸卞畾涔夌殑鏌ヨ鏂规硶銆?/p>
- 鑾峰彇鍒嗛〉缁撴灉銆傛煡璇㈣鍙ユ墽琛屽畬姣曞悗锛屽彲浠ラ€氳繃Page瀵硅薄鑾峰彇鍒嗛〉缁撴灉銆備緥濡傦細
// 鑾峰彇鍒嗛〉缁撴灉
Page<User> page = (Page<User>) users;
// 鑾峰彇鎬昏褰曟暟
long total = page.getTotal();
// 鑾峰彇褰撳墠椤电殑璁板綍鏁?/span>
int size = page.size();
// 鑾峰彇鎬婚〉鏁?/span>
int pages = page.getPages();
// 鑾峰彇褰撳墠椤电爜
int pageNum = page.getPageNum();
// 鑾峰彇姣忛〉鐨勮褰曟暟
int pageSize = page.getPageSize();
// 鑾峰彇褰撳墠椤电殑鏁版嵁
List<User> userList = page.getResult();
杩欏氨鏄娇鐢≒ageHelper杩涜鍒嗛〉鏌ヨ鐨勫熀鏈楠ゃ€傞€氳繃PageHelper锛屾垜浠彲浠ユ柟渚垮湴瀹炵幇鏁版嵁搴撴煡璇㈢粨鏋滅殑鍒嗛〉鍔熻兘锛屽噺灏戜簡鎵嬪啓鍒嗛〉閫昏緫鐨勫伐浣滈噺銆?/p>