{"id":16590,"date":"2024-03-15T13:17:58","date_gmt":"2024-03-15T13:17:58","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-is-mybatis-pagehelper-used\/"},"modified":"2025-08-07T04:14:17","modified_gmt":"2025-08-07T04:14:17","slug":"how-is-mybatis-pagehelper-used","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-is-mybatis-pagehelper-used\/","title":{"rendered":"How is MyBatis PageHelper used?"},"content":{"rendered":"<p>MyBatis PageHelper is a plugin used for pagination that assists us in implementing pagination when querying with MyBatis.<\/p>\n<p>\u4f7f\u7528 PageHelper\uff0c\u9700\u8981\u5148\u5728\u9879\u76ee\u4e2d\u6dfb\u52a0 PageHelper \u7684\u4f9d\u8d56\u3002\u7136\u540e\uff0c\u5728 MyBatis \u7684\u914d\u7f6e\u6587\u4ef6\u4e2d\u914d\u7f6e PageHelper \u63d2\u4ef6\u3002<\/p>\n<p>The example code is shown below:<\/p>\n<p>1. Add dependencies:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-tag\">&lt;<span class=\"hljs-name\">dependency<\/span>&gt;<\/span>\r\n    <span class=\"hljs-tag\">&lt;<span class=\"hljs-name\">groupId<\/span>&gt;<\/span>com.github.pagehelper<span class=\"hljs-tag\">&lt;\/<span class=\"hljs-name\">groupId<\/span>&gt;<\/span>\r\n    <span class=\"hljs-tag\">&lt;<span class=\"hljs-name\">artifactId<\/span>&gt;<\/span>pagehelper<span class=\"hljs-tag\">&lt;\/<span class=\"hljs-name\">artifactId<\/span>&gt;<\/span>\r\n    <span class=\"hljs-tag\">&lt;<span class=\"hljs-name\">version<\/span>&gt;<\/span>latest-version<span class=\"hljs-tag\">&lt;\/<span class=\"hljs-name\">version<\/span>&gt;<\/span>\r\n<span class=\"hljs-tag\">&lt;\/<span class=\"hljs-name\">dependency<\/span>&gt;<\/span>\r\n<\/code><\/pre>\n<p>2. Set up PageHelper:<br \/>\nAdd the PageHelper plugin configuration to the MyBatis configuration file, as shown in the example code below:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-tag\">&lt;<span class=\"hljs-name\">plugins<\/span>&gt;<\/span>\r\n    <span class=\"hljs-tag\">&lt;<span class=\"hljs-name\">plugin<\/span> <span class=\"hljs-attr\">interceptor<\/span>=<span class=\"hljs-string\">\"com.github.pagehelper.PageInterceptor\"<\/span>&gt;<\/span>\r\n        <span class=\"hljs-tag\">&lt;<span class=\"hljs-name\">property<\/span> <span class=\"hljs-attr\">name<\/span>=<span class=\"hljs-string\">\"dialect\"<\/span> <span class=\"hljs-attr\">value<\/span>=<span class=\"hljs-string\">\"mysql\"<\/span>\/&gt;<\/span>\r\n        <span class=\"hljs-comment\">&lt;!-- \u5176\u4ed6\u914d\u7f6e\u9879\u5982\uff1ahelperDialect, reasonable, supportMethodsArguments, autoRuntimeDialect, params, rowBoundsWithCount, pageSizeZero, closeConn, defaultCount --&gt;<\/span>\r\n    <span class=\"hljs-tag\">&lt;\/<span class=\"hljs-name\">plugin<\/span>&gt;<\/span>\r\n<span class=\"hljs-tag\">&lt;\/<span class=\"hljs-name\">plugins<\/span>&gt;<\/span>\r\n<\/code><\/pre>\n<p>3. Performing paginated queries with PageHelper:<br \/>\nIn the method where paginated queries are needed, use the PageHelper.startPage method to specify the page number and number of items per page, and then perform the query operation. Sample code is as follows:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">import<\/span> com.github.pagehelper.PageHelper;\r\n<span class=\"hljs-keyword\">import<\/span> java.util.List;\r\n\r\n<span class=\"hljs-keyword\">public<\/span> <span class=\"hljs-keyword\">class<\/span> <span class=\"hljs-title class_\">UserDao<\/span> {\r\n    <span class=\"hljs-keyword\">public<\/span> List&lt;User&gt; <span class=\"hljs-title function_\">getUsers<\/span><span class=\"hljs-params\">(<span class=\"hljs-type\">int<\/span> pageNum, <span class=\"hljs-type\">int<\/span> pageSize)<\/span> {\r\n        <span class=\"hljs-comment\">\/\/ \u4f7f\u7528 PageHelper.startPage \u65b9\u6cd5\u6307\u5b9a\u9875\u6570\u548c\u6bcf\u9875\u663e\u793a\u7684\u6570\u91cf<\/span>\r\n        PageHelper.startPage(pageNum, pageSize);\r\n        <span class=\"hljs-comment\">\/\/ \u8fdb\u884c\u67e5\u8be2\u64cd\u4f5c<\/span>\r\n        List&lt;User&gt; userList = userMapper.selectUsers();\r\n        <span class=\"hljs-keyword\">return<\/span> userList;\r\n    }\r\n}\r\n<\/code><\/pre>\n<p>This is the basic usage of using MyBatis PageHelper for pagination. We can further customize the settings by configuring PageHelper to meet specific requirements.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MyBatis PageHelper is a plugin used for pagination that assists us in implementing pagination when querying with MyBatis. \u4f7f\u7528 PageHelper\uff0c\u9700\u8981\u5148\u5728\u9879\u76ee\u4e2d\u6dfb\u52a0 PageHelper \u7684\u4f9d\u8d56\u3002\u7136\u540e\uff0c\u5728 MyBatis \u7684\u914d\u7f6e\u6587\u4ef6\u4e2d\u914d\u7f6e PageHelper \u63d2\u4ef6\u3002 The example code is shown below: 1. Add dependencies: &lt;dependency&gt; &lt;groupId&gt;com.github.pagehelper&lt;\/groupId&gt; &lt;artifactId&gt;pagehelper&lt;\/artifactId&gt; &lt;version&gt;latest-version&lt;\/version&gt; &lt;\/dependency&gt; 2. Set up PageHelper: Add the PageHelper plugin configuration to the MyBatis configuration file, as [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[453,1402,299,1404,1403],"class_list":["post-16590","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-development","tag-guide","tag-programming","tag-technology","tag-tutorial"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How is MyBatis PageHelper used? - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn about how is mybatis pagehelper used?. Comprehensive guide with examples and best practices.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-is-mybatis-pagehelper-used\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How is MyBatis PageHelper used?\" \/>\n<meta property=\"og:description\" content=\"Learn about how is mybatis pagehelper used?. Comprehensive guide with examples and best practices.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-is-mybatis-pagehelper-used\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-15T13:17:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-07T04:14:17+00:00\" \/>\n<meta name=\"author\" content=\"Emily Johnson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Emily Johnson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-is-mybatis-pagehelper-used\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-is-mybatis-pagehelper-used\/\"},\"author\":{\"name\":\"Emily Johnson\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3b041b19cffc258705478ecfab895378\"},\"headline\":\"How is MyBatis PageHelper used?\",\"datePublished\":\"2024-03-15T13:17:58+00:00\",\"dateModified\":\"2025-08-07T04:14:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-is-mybatis-pagehelper-used\/\"},\"wordCount\":119,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"Development\",\"guide\",\"programming\",\"technology\",\"tutorial\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-is-mybatis-pagehelper-used\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-is-mybatis-pagehelper-used\/\",\"name\":\"How is MyBatis PageHelper used? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T13:17:58+00:00\",\"dateModified\":\"2025-08-07T04:14:17+00:00\",\"description\":\"Learn about how is mybatis pagehelper used?. Comprehensive guide with examples and best practices.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-is-mybatis-pagehelper-used\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-is-mybatis-pagehelper-used\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-is-mybatis-pagehelper-used\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How is MyBatis PageHelper used?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3b041b19cffc258705478ecfab895378\",\"name\":\"Emily Johnson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g\",\"caption\":\"Emily Johnson\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/emilyjohnson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How is MyBatis PageHelper used? - Blog - Silicon Cloud","description":"Learn about how is mybatis pagehelper used?. Comprehensive guide with examples and best practices.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/blog\/how-is-mybatis-pagehelper-used\/","og_locale":"en_US","og_type":"article","og_title":"How is MyBatis PageHelper used?","og_description":"Learn about how is mybatis pagehelper used?. Comprehensive guide with examples and best practices.","og_url":"https:\/\/www.silicloud.com\/blog\/how-is-mybatis-pagehelper-used\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T13:17:58+00:00","article_modified_time":"2025-08-07T04:14:17+00:00","author":"Emily Johnson","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Emily Johnson","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-is-mybatis-pagehelper-used\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-is-mybatis-pagehelper-used\/"},"author":{"name":"Emily Johnson","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3b041b19cffc258705478ecfab895378"},"headline":"How is MyBatis PageHelper used?","datePublished":"2024-03-15T13:17:58+00:00","dateModified":"2025-08-07T04:14:17+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-is-mybatis-pagehelper-used\/"},"wordCount":119,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["Development","guide","programming","technology","tutorial"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-is-mybatis-pagehelper-used\/","url":"https:\/\/www.silicloud.com\/blog\/how-is-mybatis-pagehelper-used\/","name":"How is MyBatis PageHelper used? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T13:17:58+00:00","dateModified":"2025-08-07T04:14:17+00:00","description":"Learn about how is mybatis pagehelper used?. Comprehensive guide with examples and best practices.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-is-mybatis-pagehelper-used\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-is-mybatis-pagehelper-used\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-is-mybatis-pagehelper-used\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How is MyBatis PageHelper used?"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3b041b19cffc258705478ecfab895378","name":"Emily Johnson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g","caption":"Emily Johnson"},"url":"https:\/\/www.silicloud.com\/blog\/author\/emilyjohnson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/16590","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=16590"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/16590\/revisions"}],"predecessor-version":[{"id":50146,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/16590\/revisions\/50146"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=16590"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=16590"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=16590"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}