MyBatis+Spring分页插件配置

来源：互联网发布：全球数据库编辑：程序博客网时间：2024/06/01 10:25

1．pom.xml依赖

<dependency>    <groupId>org.mybatis</groupId>    <artifactId>mybatis-spring</artifactId>    <version>1.3.0</version></dependency><dependency>    <groupId>org.mybatis</groupId>    <artifactId>mybatis</artifactId>    <version>3.4.1</version></dependency><dependency>    <groupId>com.github.miemiedev</groupId>    <artifactId>mybatis-paginator</artifactId>    <version>1.2.15</version></dependency>

2．TestUser.mapper.xml 映射文件

<resultMap id="BaseResult" type="com.ecs.mybatis.TestUser">  <id column="id" property="id" />  <result column="name" property="name" />  <result column="address" property="address" /></resultMap><select id="query" resultMap="BaseResult" parameterType="map" useCache="false" >    SELECT * FROM TEST_USER where name = #{name}</select>

3．datasource.xml spring配置

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">    <property name="dataSource" ref="jdbcDataSource" />    <property name="configLocation" value="classpath:mybatis/mybatis-config.xml" />     <property name="plugins">        <list>            <bean class="com.github.miemiedev.mybatis.paginator.OffsetLimitInterceptor" >                <property name="dialectClass" value="com.github.miemiedev.mybatis.paginator.dialect.OracleDialect" />            </bean>        </list>    </property></bean>

4．测试

@Testpublic void testquery(){    int page = 1;     //页号, 从1开始    int pageSize = 3; //每页有几条数据    String sortString = "id.asc"; //如果你想排序的话逗号分隔可以排序多列     PageBounds pageBounds = new PageBounds(page, pageSize , Order.formString(sortString));    TestUser user = new TestUser();    user.setName("张三");    List<TestUser> list = userDao.query("张三",pageBounds);    PageList<TestUser> pageList = (PageList<TestUser>)list;    Paginator p =  pageList.getPaginator();    //System.err.println("totalCount:"+p.getTotalCount());    //System.err.println("totalPage:"+p.getTotalPages());    System.out.println(list);    for(TestUser u:pageList){        System.out.println();        System.out.print(u.getId()+"\t");    }}

0 0