mybatis对oracle分页,mybatis中oracle实现分页效果

com.dao;importjava.util.List;importjava.util.Map;importorg.apache.ibatis.session.RowBounds;importcom.model.Student;public interfaceStudentMapper {/*** 分页查询*/

public List selectall(RowBounds rb);//需要传RowBounds 类型的参数

}

配置文件

/p>

PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

select * from student

JUnit测试

packagecom.util;import static org.junit.Assert.*;importjava.util.ArrayList;importjava.util.HashMap;importjava.util.List;importjava.util.Map;importorg.apache.ibatis.session.RowBounds;importorg.apache.ibatis.session.SqlSession;importorg.junit.After;importorg.junit.Before;importorg.junit.Test;importcom.dao.StudentMapper;importcom.model.Student;public classJtest {privateSqlSession ss;privateStudentMapper sm;

@Beforepublic void setUp() throwsException {

ss=SqlSessionUtil.getSqlSession();

sm=ss.getMapper(StudentMapper.class);

}

@Afterpublic void tearDown() throwsException {

ss.commit();

ss.close();

}

@Testpublic voidselectall() {//跳过几行

int offset = 3;//取几行

int limit = 3;

RowBounds rb= newRowBounds(offset, limit);

List st=sm.selectall(rb);for(Student tt:st){

System.out.println(tt);

}

}

}

数据就取出来了

二、物理分页。

用roacle是数据库自己的分页语句分页

接口

packagecom.dao;importjava.util.List;importjava.util.Map;importorg.apache.ibatis.session.RowBounds;importcom.model.Student;public interfaceStudentMapper {/*** 分页查询*/

public Listselectall(Integer offset, Integer limit );

}

配置文件

/p>

PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

select * from (select t.*,rownum rownu from STUDENT t

where rownum<=#{param1}*#{param2})tt

where tt.rownu>(#{param1}-1)*#{param2}

JUnit测试

packagecom.util;import static org.junit.Assert.*;importjava.util.ArrayList;importjava.util.HashMap;importjava.util.List;importjava.util.Map;importorg.apache.ibatis.session.RowBounds;importorg.apache.ibatis.session.SqlSession;importorg.junit.After;importorg.junit.Before;importorg.junit.Test;importcom.dao.StudentMapper;importcom.model.Student;public classJtest {privateSqlSession ss;privateStudentMapper sm;

@Beforepublic void setUp() throwsException {

ss=SqlSessionUtil.getSqlSession();

sm=ss.getMapper(StudentMapper.class);

}

@Afterpublic void tearDown() throwsException {

ss.commit();

ss.close();

}

@Testpublic voidselectall() {//当前第几页

Integer offset = 2;//每页行数

Integer limit = 3;

List st=sm.selectall(offset, limit);for(Student tt:st){

System.out.println(tt);

}

}

}

查询结果

mybatis中oracle实现分页效果

标签：odi   map   setup   导致   查询   dao   需要   gets   color

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉 本文系统来源：http://www.cnblogs.com/hq233/p/6753712.html