【MyBatis】分页插件PageHelper

public class Employee {
	
	private Integer id;
	private String lastName;
	private String email;
	private String gender;
	
	
	public Employee(String lastName, String email, String gender) {
		super();
		this.lastName = lastName;
		this.email = email;
		this.gender = gender;
	}
	public Employee() {
		super();
		// TODO Auto-generated constructor stub
	}
	
	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	public String getLastName() {
		return lastName;
	}
	public void setLastName(String lastName) {
		this.lastName = lastName;
	}
	public String getEmail() {
		return email;
	}
	public void setEmail(String email) {
		this.email = email;
	}
	public String getGender() {
		return gender;
	}
	public void setGender(String gender) {
		this.gender = gender;
	}
	@Override
	public String toString() {
		return "Employee [id=" + id + ", lastName=" + lastName + ", email="
				+ email + ", gender=" + gender + "]";
	}
	
	

}

public interface EmployeeMapper {
	public List<Employee> getEmps();
}

public class MyBatisTest {
	public SqlSessionFactory getSqlSessionFactory() throws IOException {
		String resource = "mybatis-config.xml";
		InputStream inputStream = Resources.getResourceAsStream(resource);
		return new SqlSessionFactoryBuilder().build(inputStream);
	}
	@Test
	public void test01() throws IOException {
		SqlSessionFactory sqlSessionFactory = getSqlSessionFactory();
		SqlSession openSession = sqlSessionFactory.openSession();
		try {
			/*【不用分页】EmployeeMapper mapper = openSession.getMapper(EmployeeMapper.class);		
			List<Employee> emps = mapper.getEmps();  
			for (Employee employee : emps) {
				System.out.println(employee);
			}*/
			
			
			
//			//【用分页】：最简单法
//			EmployeeMapper mapper = openSession.getMapper(EmployeeMapper.class);	
//			Page<Object> page = PageHelper.startPage(1, 5); 
//			List<Employee> emps = mapper.getEmps(); 
//			for (Employee employee : emps) {
//				System.out.println(employee);
//			}
			
			
			
			
//			//【得分页的详细信息】
//			EmployeeMapper mapper = openSession.getMapper(EmployeeMapper.class);	
//			Page<Object> page = PageHelper.startPage(1, 5); 
//			List<Employee> emps = mapper.getEmps(); 
//			for (Employee employee : emps) {
//				System.out.println(employee);
//			}
//			System.out.println("当前页码："+page.getPageNum());
//			System.out.println("总记录数："+page.getTotal());
//			System.out.println("每页的记录数："+page.getPageSize());
//			System.out.println("总页码："+page.getPages());
			
			
			
			//【PageInfo法】
			EmployeeMapper mapper = openSession.getMapper(EmployeeMapper.class);
			PageHelper.startPage(1, 5);
			List<Employee> emps = mapper.getEmps(); 	
			PageInfo info= new PageInfo(emps);
			System.out.println("当前页码："+info.getPageNum());
			System.out.println("总记录数："+info.getTotal());
			System.out.println("每页的记录数："+info.getPageSize());
			System.out.println("总页码："+info.getPages());
			System.out.println("是否第一页："+info.isIsFirstPage());
			
			
			
//			//【分页导航】PageInfo<>(emps, 3)，参数1是封装结果，参数2是分页导航
//			EmployeeMapper mapper = openSession.getMapper(EmployeeMapper.class);
//			Page<Object> page = PageHelper.startPage(1, 2);
//			List<Employee> emps = mapper.getEmps();
//			
//			PageInfo<Employee> info = new PageInfo<>(emps, 3);
//			System.out.println("当前页码："+info.getPageNum());
//			System.out.println("总记录数："+info.getTotal());
//			System.out.println("每页的记录数："+info.getPageSize());
//			System.out.println("总页码："+info.getPages());
//			System.out.println("是否第一页："+info.isIsFirstPage());
//			System.out.println("连续显示的页码：");
//			int[] nums = info.getNavigatepageNums();
//			for (int i = 0; i < nums.length; i++) {
//				System.out.println(nums[i]); 
//			}
			
			
		} finally {
			openSession.close();
		}

	}


	

}

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/mybatis
jdbc.username=root
jdbc.password=root

orcl.driver=oracle.jdbc.OracleDriver
orcl.url=jdbc:oracle:thin:@localhost:1521:XE
orcl.username=test
orcl.password=root	

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
 PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
 "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.atguigu.mybatis.dao.EmployeeMapper">
	<!--public List<Employee> getEmps();  -->
	<select id="getEmps" databaseId="mysql" resultType="com.atguigu.mybatis.bean.Employee">
		select id,last_name lastName,email,gender 
		from tbl_employee
	</select>
</mapper>

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
 PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
 "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>


	
	<properties resource="dbconfig.properties"></properties>
	<plugins>
		<plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
	</plugins>
	
	<environments default="dev_mysql">
		<environment id="dev_mysql">
			<transactionManager type="JDBC" />
			<dataSource type="POOLED">
				<property name="driver" value="${jdbc.driver}" />
				<property name="url" value="${jdbc.url}" />
				<property name="username" value="${jdbc.username}" />
				<property name="password" value="${jdbc.password}" />
			</dataSource>
		</environment>
		
		<environment id="dev_oracle">
			<transactionManager type="JDBC" />
			<dataSource type="POOLED">
				<property name="driver" value="${orcl.driver}" />
				<property name="url" value="${orcl.url}" />
				<property name="username" value="${orcl.username}" />
				<property name="password" value="${orcl.password}" />
			</dataSource>
		</environment>
	</environments>
	
	<databaseIdProvider type="DB_VENDOR">
		<property name="MySQL" value="mysql"/>
		<property name="Oracle" value="oracle"/>
	</databaseIdProvider>
	<mappers>
		<mapper resource="EmployeeMapper.xml" />
	</mappers>
</configuration>