Springboot2中如何整合pagehelper
springboot
pagehelper
1、pom.xml
<?xml version="1.0" encoding="UTF-8"?> <project> <modelversion>4.0.0</modelversion> <parent> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-starter-parent</artifactid> <version>2.2.1.RELEASE</version> <relativepath></relativepath> <!-- lookup parent from repository --> </parent> <groupid>qinfeng.zheng</groupid> <artifactid>learn-pagequery</artifactid> <version>0.0.1-SNAPSHOT</version> <name>learn-pagequery</name> <description>Demo project for Spring Boot</description> <properties> <java.version>1.8</java.version> </properties> <dependencies> <dependency> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-starter-web</artifactid> </dependency> <dependency> <groupid>org.mybatis.spring.boot</groupid> <artifactid>mybatis-spring-boot-starter</artifactid> <version>1.3.2</version> </dependency> <dependency> <groupid>mysql</groupid> <artifactid>mysql-connector-java</artifactid> <version>5.1.47</version> <scope>runtime</scope> </dependency> <dependency> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-starter-test</artifactid> <scope>test</scope> <exclusions> <exclusion> <groupid>org.junit.vintage</groupid> <artifactid>junit-vintage-engine</artifactid> </exclusion> </exclusions> </dependency> <dependency> <groupid>com.github.pagehelper</groupid> <artifactid>pagehelper-spring-boot-starter</artifactid> <version>1.2.12</version> </dependency> </dependencies> <build> <plugins> <plugin> <groupid>org.springframework.boot</groupid> <artifactid>spring-boot-maven-plugin</artifactid> </plugin> </plugins> </build> </project>
登入後複製
2. application.peroperties
#pagehelper
pagehelper.helper-dialect=mysql
pagehelper.params=count= countSql
pagehelper.reasonable=true
pagehelper.support-methods-arguments=true#mysql
spring.datasource.driver-class-name = com.mysql.jdbc.Driver
spring.datasource.url= jdbc:mysql://120.79.xx.xx:3306/test?useUnicode=yes&characterEncoding=UTF-8&useSSL=false
spring.datasource.username = root
spring.datasource. password = 1212212
3.實體類別
public class Country implements Serializable {
private static final long serialVersionUID = 6569081236403751407L;
private int id;
private String countryname;
private String countrycode;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getCountryname() {
return countryname;
}
public void setCountryname(String countryname) {
this.countryname = countryname;
}
public String getCountrycode() {
return countrycode;
}
public void setCountrycode(String countrycode) {
this.countrycode = countrycode;
}
}登入後複製
4，mapper介面類別
@Mapper
public interface CountryMapper {
@Select("select * from country")
List<country> findAll();
}</country>登入後複製
5.cotroller類別
@RestController
public class CountryController {
@Autowired
private CountryMapper countryMapper;
@GetMapping("/findAll")
public List<country> findAll(@RequestParam(defaultValue = "1") Integer pageNum, @RequestParam(defaultValue = "20") Integer pageSize) {
PageHelper.startPage(pageNum, pageSize);
List<country> countries = countryMapper.findAll();
Page page = (Page) countries;
System.out.println("每页展示条数：" + page.getPageSize());
System.out.println("总条数：" + page.getTotal());
System.out.println("当前页：" + page.getPageNum());
System.out.println("总页数：" + page.getPages());
return countries;
}
}</country></country>登入後複製
7.測試數據
直接抄官方資料
drop table country if exists; create table country ( id int primary key auto_increment, countryname varchar(32), countrycode varchar(2) ); insert into country (id, countryname, countrycode) values(1,'Angola','AO'); insert into country (id, countryname, countrycode) values(2,'Afghanistan','AF'); insert into country (id, countryname, countrycode) values(3,'Albania','AL'); insert into country (id, countryname, countrycode) values(4,'Algeria','DZ'); insert into country (id, countryname, countrycode) values(5,'Andorra','AD'); insert into country (id, countryname, countrycode) values(6,'Anguilla','AI'); insert into country (id, countryname, countrycode) values(7,'Antigua and Barbuda','AG'); insert into country (id, countryname, countrycode) values(8,'Argentina','AR'); insert into country (id, countryname, countrycode) values(9,'Armenia','AM'); insert into country (id, countryname, countrycode) values(10,'Australia','AU'); insert into country (id, countryname, countrycode) values(11,'Austria','AT'); insert into country (id, countryname, countrycode) values(12,'Azerbaijan','AZ'); insert into country (id, countryname, countrycode) values(13,'Bahamas','BS'); insert into country (id, countryname, countrycode) values(14,'Bahrain','BH'); insert into country (id, countryname, countrycode) values(15,'Bangladesh','BD'); insert into country (id, countryname, countrycode) values(16,'Barbados','BB'); insert into country (id, countryname, countrycode) values(17,'Belarus','BY'); insert into country (id, countryname, countrycode) values(18,'Belgium','BE'); insert into country (id, countryname, countrycode) values(19,'Belize','BZ'); insert into country (id, countryname, countrycode) values(20,'Benin','BJ'); insert into country (id, countryname, countrycode) values(21,'Bermuda Is.','BM'); insert into country (id, countryname, countrycode) values(22,'Bolivia','BO'); insert into country (id, countryname, countrycode) values(23,'Botswana','BW'); insert into country (id, countryname, countrycode) values(24,'Brazil','BR'); insert into country (id, countryname, countrycode) values(25,'Brunei','BN'); insert into country (id, countryname, countrycode) values(26,'Bulgaria','BG'); insert into country (id, countryname, countrycode) values(27,'Burkina-faso','BF'); insert into country (id, countryname, countrycode) values(28,'Burma','MM'); insert into country (id, countryname, countrycode) values(29,'Burundi','BI'); insert into country (id, countryname, countrycode) values(30,'Cameroon','CM'); insert into country (id, countryname, countrycode) values(31,'Canada','CA'); insert into country (id, countryname, countrycode) values(32,'Central African Republic','CF'); insert into country (id, countryname, countrycode) values(33,'Chad','TD'); insert into country (id, countryname, countrycode) values(34,'Chile','CL'); insert into country (id, countryname, countrycode) values(35,'China','CN'); insert into country (id, countryname, countrycode) values(36,'Colombia','CO'); insert into country (id, countryname, countrycode) values(37,'Congo','CG'); insert into country (id, countryname, countrycode) values(38,'Cook Is.','CK'); insert into country (id, countryname, countrycode) values(39,'Costa Rica','CR'); insert into country (id, countryname, countrycode) values(40,'Cuba','CU'); insert into country (id, countryname, countrycode) values(41,'Cyprus','CY'); insert into country (id, countryname, countrycode) values(42,'Czech Republic','CZ'); insert into country (id, countryname, countrycode) values(43,'Denmark','DK'); insert into country (id, countryname, countrycode) values(44,'Djibouti','DJ'); insert into country (id, countryname, countrycode) values(45,'Dominica Rep.','DO'); insert into country (id, countryname, countrycode) values(46,'Ecuador','EC'); insert into country (id, countryname, countrycode) values(47,'Egypt','EG'); insert into country (id, countryname, countrycode) values(48,'EI Salvador','SV'); insert into country (id, countryname, countrycode) values(49,'Estonia','EE'); insert into country (id, countryname, countrycode) values(50,'Ethiopia','ET'); insert into country (id, countryname, countrycode) values(51,'Fiji','FJ'); insert into country (id, countryname, countrycode) values(52,'Finland','FI'); insert into country (id, countryname, countrycode) values(53,'France','FR'); insert into country (id, countryname, countrycode) values(54,'French Guiana','GF'); insert into country (id, countryname, countrycode) values(55,'Gabon','GA'); insert into country (id, countryname, countrycode) values(56,'Gambia','GM'); insert into country (id, countryname, countrycode) values(57,'Georgia','GE'); insert into country (id, countryname, countrycode) values(58,'Germany','DE'); insert into country (id, countryname, countrycode) values(59,'Ghana','GH'); insert into country (id, countryname, countrycode) values(60,'Gibraltar','GI'); insert into country (id, countryname, countrycode) values(61,'Greece','GR'); insert into country (id, countryname, countrycode) values(62,'Grenada','GD'); insert into country (id, countryname, countrycode) values(63,'Guam','GU'); insert into country (id, countryname, countrycode) values(64,'Guatemala','GT'); insert into country (id, countryname, countrycode) values(65,'Guinea','GN'); insert into country (id, countryname, countrycode) values(66,'Guyana','GY'); insert into country (id, countryname, countrycode) values(67,'Haiti','HT'); insert into country (id, countryname, countrycode) values(68,'Honduras','HN'); insert into country (id, countryname, countrycode) values(69,'Hongkong','HK'); insert into country (id, countryname, countrycode) values(70,'Hungary','HU'); insert into country (id, countryname, countrycode) values(71,'Iceland','IS'); insert into country (id, countryname, countrycode) values(72,'India','IN'); insert into country (id, countryname, countrycode) values(73,'Indonesia','ID'); insert into country (id, countryname, countrycode) values(74,'Iran','IR'); insert into country (id, countryname, countrycode) values(75,'Iraq','IQ'); insert into country (id, countryname, countrycode) values(76,'Ireland','IE'); insert into country (id, countryname, countrycode) values(77,'Israel','IL'); insert into country (id, countryname, countrycode) values(78,'Italy','IT'); insert into country (id, countryname, countrycode) values(79,'Jamaica','JM'); insert into country (id, countryname, countrycode) values(80,'Japan','JP'); insert into country (id, countryname, countrycode) values(81,'Jordan','JO'); insert into country (id, countryname, countrycode) values(82,'Kampuchea (Cambodia )','KH'); insert into country (id, countryname, countrycode) values(83,'Kazakstan','KZ'); insert into country (id, countryname, countrycode) values(84,'Kenya','KE'); insert into country (id, countryname, countrycode) values(85,'Korea','KR'); insert into country (id, countryname, countrycode) values(86,'Kuwait','KW'); insert into country (id, countryname, countrycode) values(87,'Kyrgyzstan','KG'); insert into country (id, countryname, countrycode) values(88,'Laos','LA'); insert into country (id, countryname, countrycode) values(89,'Latvia','LV'); insert into country (id, countryname, countrycode) values(90,'Lebanon','LB'); insert into country (id, countryname, countrycode) values(91,'Lesotho','LS'); insert into country (id, countryname, countrycode) values(92,'Liberia','LR'); insert into country (id, countryname, countrycode) values(93,'Libya','LY'); insert into country (id, countryname, countrycode) values(94,'Liechtenstein','LI'); insert into country (id, countryname, countrycode) values(95,'Lithuania','LT'); insert into country (id, countryname, countrycode) values(96,'Luxembourg','LU'); insert into country (id, countryname, countrycode) values(97,'Macao','MO'); insert into country (id, countryname, countrycode) values(98,'Madagascar','MG'); insert into country (id, countryname, countrycode) values(99,'Malawi','MW'); insert into country (id, countryname, countrycode) values(100,'Malaysia','MY'); insert into country (id, countryname, countrycode) values(101,'Maldives','MV'); insert into country (id, countryname, countrycode) values(102,'Mali','ML'); insert into country (id, countryname, countrycode) values(103,'Malta','MT'); insert into country (id, countryname, countrycode) values(104,'Mauritius','MU'); insert into country (id, countryname, countrycode) values(105,'Mexico','MX'); insert into country (id, countryname, countrycode) values(106,'Moldova, Republic of','MD'); insert into country (id, countryname, countrycode) values(107,'Monaco','MC'); insert into country (id, countryname, countrycode) values(108,'Mongolia','MN'); insert into country (id, countryname, countrycode) values(109,'Montserrat Is','MS'); insert into country (id, countryname, countrycode) values(110,'Morocco','MA'); insert into country (id, countryname, countrycode) values(111,'Mozambique','MZ'); insert into country (id, countryname, countrycode) values(112,'Namibia','NA'); insert into country (id, countryname, countrycode) values(113,'Nauru','NR'); insert into country (id, countryname, countrycode) values(114,'Nepal','NP'); insert into country (id, countryname, countrycode) values(115,'Netherlands','NL'); insert into country (id, countryname, countrycode) values(116,'New Zealand','NZ'); insert into country (id, countryname, countrycode) values(117,'Nicaragua','NI'); insert into country (id, countryname, countrycode) values(118,'Niger','NE'); insert into country (id, countryname, countrycode) values(119,'Nigeria','NG'); insert into country (id, countryname, countrycode) values(120,'North Korea','KP'); insert into country (id, countryname, countrycode) values(121,'Norway','NO'); insert into country (id, countryname, countrycode) values(122,'Oman','OM'); insert into country (id, countryname, countrycode) values(123,'Pakistan','PK'); insert into country (id, countryname, countrycode) values(124,'Panama','PA'); insert into country (id, countryname, countrycode) values(125,'Papua New Cuinea','PG'); insert into country (id, countryname, countrycode) values(126,'Paraguay','PY'); insert into country (id, countryname, countrycode) values(127,'Peru','PE'); insert into country (id, countryname, countrycode) values(128,'Philippines','PH'); insert into country (id, countryname, countrycode) values(129,'Poland','PL'); insert into country (id, countryname, countrycode) values(130,'French Polynesia','PF'); insert into country (id, countryname, countrycode) values(131,'Portugal','PT'); insert into country (id, countryname, countrycode) values(132,'Puerto Rico','PR'); insert into country (id, countryname, countrycode) values(133,'Qatar','QA'); insert into country (id, countryname, countrycode) values(134,'Romania','RO'); insert into country (id, countryname, countrycode) values(135,'Russia','RU'); insert into country (id, countryname, countrycode) values(136,'Saint Lueia','LC'); insert into country (id, countryname, countrycode) values(137,'Saint Vincent','VC'); insert into country (id, countryname, countrycode) values(138,'San Marino','SM'); insert into country (id, countryname, countrycode) values(139,'Sao Tome and Principe','ST'); insert into country (id, countryname, countrycode) values(140,'Saudi Arabia','SA'); insert into country (id, countryname, countrycode) values(141,'Senegal','SN'); insert into country (id, countryname, countrycode) values(142,'Seychelles','SC'); insert into country (id, countryname, countrycode) values(143,'Sierra Leone','SL'); insert into country (id, countryname, countrycode) values(144,'Singapore','SG'); insert into country (id, countryname, countrycode) values(145,'Slovakia','SK'); insert into country (id, countryname, countrycode) values(146,'Slovenia','SI'); insert into country (id, countryname, countrycode) values(147,'Solomon Is','SB'); insert into country (id, countryname, countrycode) values(148,'Somali','SO'); insert into country (id, countryname, countrycode) values(149,'South Africa','ZA'); insert into country (id, countryname, countrycode) values(150,'Spain','ES'); insert into country (id, countryname, countrycode) values(151,'Sri Lanka','LK'); insert into country (id, countryname, countrycode) values(152,'St.Lucia','LC'); insert into country (id, countryname, countrycode) values(153,'St.Vincent','VC'); insert into country (id, countryname, countrycode) values(154,'Sudan','SD'); insert into country (id, countryname, countrycode) values(155,'Suriname','SR'); insert into country (id, countryname, countrycode) values(156,'Swaziland','SZ'); insert into country (id, countryname, countrycode) values(157,'Sweden','SE'); insert into country (id, countryname, countrycode) values(158,'Switzerland','CH'); insert into country (id, countryname, countrycode) values(159,'Syria','SY'); insert into country (id, countryname, countrycode) values(160,'Taiwan','TW'); insert into country (id, countryname, countrycode) values(161,'Tajikstan','TJ'); insert into country (id, countryname, countrycode) values(162,'Tanzania','TZ'); insert into country (id, countryname, countrycode) values(163,'Thailand','TH'); insert into country (id, countryname, countrycode) values(164,'Togo','TG'); insert into country (id, countryname, countrycode) values(165,'Tonga','TO'); insert into country (id, countryname, countrycode) values(166,'Trinidad and Tobago','TT'); insert into country (id, countryname, countrycode) values(167,'Tunisia','TN'); insert into country (id, countryname, countrycode) values(168,'Turkey','TR'); insert into country (id, countryname, countrycode) values(169,'Turkmenistan','TM'); insert into country (id, countryname, countrycode) values(170,'Uganda','UG'); insert into country (id, countryname, countrycode) values(171,'Ukraine','UA'); insert into country (id, countryname, countrycode) values(172,'United Arab Emirates','AE'); insert into country (id, countryname, countrycode) values(173,'United Kiongdom','GB'); insert into country (id, countryname, countrycode) values(174,'United States of America','US'); insert into country (id, countryname, countrycode) values(175,'Uruguay','UY'); insert into country (id, countryname, countrycode) values(176,'Uzbekistan','UZ'); insert into country (id, countryname, countrycode) values(177,'Venezuela','VE'); insert into country (id, countryname, countrycode) values(178,'Vietnam','VN'); insert into country (id, countryname, countrycode) values(179,'Yemen','YE'); insert into country (id, countryname, countrycode) values(180,'Yugoslavia','YU'); insert into country (id, countryname, countrycode) values(181,'Zimbabwe','ZW'); insert into country (id, countryname, countrycode) values(182,'Zaire','ZR'); insert into country (id, countryname, countrycode) values(183,'Zambia','ZM');
登入後複製
好，一切準備就緒，啟動springboot項目，瀏覽器訪問，注意controller中列印
第一次請求：
controller列印：
#第二次要求：
controller列印：
OK ,驗證完畢！完美！ ！ ！
補充：
在做分頁功能時，前端分頁插件一般都需要一些諸如當前頁數，總條數，總共多少頁之類的數據，這時可以引用PageInfo這個對象，它完全能夠滿足插件的分頁要求。
@GetMapping("/findAll")
public PageInfo<country> findAll(@RequestParam(defaultValue = "1") Integer pageNum, @RequestParam(defaultValue = "20") Integer pageSize) {
PageHelper.startPage(pageNum, pageSize);
List<country> countries = countryMapper.findAll();
// Page page = (Page) countries;
// System.out.println("每页展示条数：" + page.getPageSize());
// System.out.println("总条数：" + page.getTotal());
// System.out.println("当前页：" + page.getPageNum());
// System.out.println("总页数：" + page.getPages());
PageInfo<country> result = new PageInfo(countries);
return result;
}</country></country></country>登入後複製
請求測試：
檢視PageInfo類別的原始碼，不難發現，它對前端分頁外掛程式的屬性支援還是很全面的
private int pageNum; // 当前页码 private int pageSize; // 每页展示的多少条数据 private int size; // 数据总条数 private int startRow; private int endRow; private int pages; // 总共多少页 private int prePage; // 前一页 private int nextPage; // 后一页 private boolean isFirstPage; private boolean isLastPage; private boolean hasPreviousPage; private boolean hasNextPage; private int navigatePages; private int[] navigatepageNums; private int navigateFirstPage; private int navigateLastPage;
登入後複製
以上是Springboot2中如何整合pagehelper的詳細內容。更多資訊請關注PHP中文網其他相關文章！
本網站聲明
本文內容由網友自願投稿，版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容，請聯絡admin@php.cn
熱AI工具
Undresser.AI Undress
人工智慧驅動的應用程序，用於創建逼真的裸體照片
AI Clothes Remover
用於從照片中去除衣服的線上人工智慧工具。
Undress AI Tool
免費脫衣圖片
Clothoff.io
AI脫衣器
Video Face Swap
使用我們完全免費的人工智慧換臉工具，輕鬆在任何影片中換臉！
熱門文章
刺客信條陰影：貝殼謎語解決方案
1 個月前
By DDD
Windows 11 KB5054979中的新功能以及如何解決更新問題
3 週前
By DDD
在哪裡可以找到原子中的起重機控制鑰匙卡
1 個月前
By DDD
如何修復KB5055523無法在Windows 11中安裝？
2 週前
By DDD
Inzoi：如何申請學校和大學
3 週前
By DDD
熱工具
記事本++7.3.1
好用且免費的程式碼編輯器
SublimeText3漢化版
中文版，非常好用
禪工作室 13.0.1
強大的PHP整合開發環境
Dreamweaver CS6
視覺化網頁開發工具
SublimeText3 Mac版
神級程式碼編輯軟體(SublimeText3)
Springboot怎麼整合Jasypt實現設定檔加密
Jun 01, 2023 am 08:55 AM
Jasypt介紹Jasypt是一個java庫，它允許開發員以最少的努力為他/她的專案添加基本的加密功能，並且不需要對加密工作原理有深入的了解用於單向和雙向加密的高安全性、基於標準的加密技術。加密密碼，文本，數字，二進位檔案...適合整合到基於Spring的應用程式中，開放API，用於任何JCE提供者...添加如下依賴：com.github.ulisesbocchiojasypt-spring-boot-starter2. 1.1Jasypt好處保護我們的系統安全，即使程式碼洩露，也可以保證資料來源的
SpringBoot怎麼整合Redisson實現延遲隊列
May 30, 2023 pm 02:40 PM
使用場景1、下單成功，30分鐘未支付。支付超時，自動取消訂單2、訂單簽收，簽收後7天未進行評估。訂單超時未評價，系統預設好評3、下單成功，商家5分鐘未接單，訂單取消4、配送超時，推播簡訊提醒…對於延時比較長的場景、即時性不高的場景，我們可以採用任務調度的方式定時輪詢處理。如：xxl-job今天我們採
怎麼在SpringBoot中使用Redis實現分散式鎖
Jun 03, 2023 am 08:16 AM
一、Redis實現分散式鎖原理為什麼需要分散式鎖在聊分散式鎖之前，有必要先解釋一下，為什麼需要分散式鎖。與分散式鎖相對就的是單機鎖，我們在寫多執行緒程式時，避免同時操作一個共享變數產生資料問題，通常會使用一把鎖來互斥以保證共享變數的正確性，其使用範圍是在同一個進程中。如果換做是多個進程，需要同時操作一個共享資源，如何互斥？現在的業務應用通常是微服務架構，這也意味著一個應用會部署多個進程，多個進程如果需要修改MySQL中的同一行記錄，為了避免操作亂序導致髒數據，此時就需要引入分佈式鎖了。想要實現分
springboot讀取檔案打成jar包後存取不到怎麼解決
Jun 03, 2023 pm 04:38 PM
springboot讀取文件，打成jar包後訪問不到最新開發出現一種情況，springboot打成jar包後讀取不到文件，原因是打包之後，文件的虛擬路徑是無效的，只能通過流去讀取。文件在resources下publicvoidtest(){Listnames=newArrayList();InputStreamReaderread=null;try{ClassPathResourceresource=newClassPathResource("name.txt");Input
Springboot+Mybatis-plus不使用SQL語句進行多表新增怎麼實現
Jun 02, 2023 am 11:07 AM
在Springboot+Mybatis-plus不使用SQL語句進行多表添加操作我所遇到的問題準備工作在測試環境下模擬思維分解一下:創建出一個帶有參數的BrandDTO對像模擬對後台傳遞參數我所遇到的問題我們都知道,在我們使用Mybatis-plus中進行多表操作是極其困難的,如果你不使用Mybatis-plus-join這一類的工具,你只能去配置對應的Mapper.xml文件,配置又臭又長的ResultMap,然後再寫對應的sql語句,這種方法雖然看上去很麻煩,但具有很高的靈活性,可以讓我們
SpringBoot怎麼自訂Redis實作快取序列化
Jun 03, 2023 am 11:32 AM
1.自訂RedisTemplate1.1、RedisAPI預設序列化機制基於API的Redis快取實作是使用RedisTemplate範本進行資料快取操作的，這裡開啟RedisTemplate類，查看該類別的源碼資訊publicclassRedisTemplateextendsRedisAccessorimplementsRedisOperations,BeanClassLoaderAware{//聲明了value的各種序列化方式，初始值為空@NullableprivateRedisSe
SpringBoot與SpringMVC的比較及差別分析
Dec 29, 2023 am 11:02 AM
SpringBoot和SpringMVC都是Java開發中常用的框架，但它們之間有一些明顯的差異。本文將探究這兩個框架的特點和用途，並對它們的差異進行比較。首先，我們來了解一下SpringBoot。 SpringBoot是由Pivotal團隊開發的，它旨在簡化基於Spring框架的應用程式的建立和部署。它提供了一種快速、輕量級的方式來建立獨立的、可執行
SpringBoot+Dubbo+Nacos 開發實戰教程
Aug 15, 2023 pm 04:49 PM
本文來寫個詳細的例子來說下dubbo+nacos+Spring Boot開發實戰。本文不會講述太多的理論的知識，會寫一個最簡單的例子來說明dubbo如何與nacos整合，快速建構開發環境。
