loafer/mybatis-paging

Based on the database dialect Mybatis3 paging plug-in

Download

Step 1. Add the JitPack repository to your build file

Add it in your root settings.gradle at the end of repositories:

	dependencyResolutionManagement {
		repositoriesMode.set(RepositoriesMode.FAIL_ON_PROJECT_REPOS)
		repositories {
			mavenCentral()
			maven { url 'https://jitpack.io' }
		}
	}

Add it in your settings.gradle.kts at the end of repositories:

	dependencyResolutionManagement {
		repositoriesMode.set(RepositoriesMode.FAIL_ON_PROJECT_REPOS)
		repositories {
			mavenCentral()
			maven { url = uri("https://jitpack.io") }
		}
	}

Add to pom.xml

	<repositories>
		<repository>
		    <id>jitpack.io</id>
		    <url>https://jitpack.io</url>
		</repository>
	</repositories>

Add it in your build.sbt at the end of resolvers:

 
    resolvers += "jitpack" at "https://jitpack.io"

Add it in your project.clj at the end of repositories:

 
    :repositories [["jitpack" "https://jitpack.io"]]

Step 2. Add the dependency

	dependencies {
		implementation 'com.github.loafer:mybatis-paging:'
	}
	dependencies {
		implementation("com.github.loafer:mybatis-paging:")
	}
	<dependency>
	    <groupId>com.github.loafer</groupId>
	    <artifactId>mybatis-paging</artifactId>
	    <version></version>
	</dependency>

                            
    libraryDependencies += "com.github.loafer" % "mybatis-paging" % ""
        
        

                            
    :dependencies [[com.github.loafer/mybatis-paging ""]]

Readme

mybatis-paging

Based on the database dialect Mybatis3 paging plug-in.
The current support for Oracle、 MySQL .

Basic Usage

include the following in mybatis-config.xml.

<plugins>
    <plugin interceptor="com.github.loafer.mybatis.pagination.PaginationInterceptor">
        <property name="dialect" value="oracle"/>
        <property name="stmtIdRegex" value="*.selectPaging"/>
    </plugin>
</plugins>

or

<plugins>
    <plugin interceptor="com.github.loafer.mybatis.pagination.PaginationInterceptor">
        <property name="dialectClass" value="com.github.loafer.mybatis.pagination.dialect.OracleDialect"/>
        <property name="stmtIdRegex" value="*.selectPaging"/>
    </plugin>
</plugins>
  • dialect, database type. oracle\mysql
  • dialectClass, a subclass of com.github.loafer.mybatis.pagination.dialect.Dialect.
  • stmtIdRegex, statement id regex string. example: *.selectPaging or *.selectPaging*.

SQL Mapper config

<select id="selectPaging" resultType="hashmap">
    select * from ent_user
</select>

@See config and Basic Usage

Others

In addition, sogyf/mybatis-pagination maybe help you.