PageHelper

心已赠人 2022-02-09 12:13 188阅读 0赞

> ##### 1. pom.xml #####

<dependency>
    	    	<groupId>com.github.pagehelper</groupId>
    	    	<artifactId>pagehelper</artifactId>	   
    		</dependency>		
      		
    		<dependency>
    			<groupId>org.mybatis</groupId>
    			<artifactId>mybatis</artifactId>		
    		</dependency>

> ##### 2.Spring/applicationContext-dao.xml配置 #####

> ##### 3.MyBatis配置 #####

<?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>
    	<plugins>
    		
    		
    		<plugin interceptor="com.github.pagehelper.PageHelper">
    			
    			<property name="dialect" value="mysql"/>
    		</plugin>
    	</plugins>
    </configuration>

> ##### 4.PageResult实体类 #####

/** * 分页结果类 * @author ronybo * */
    public class PageResult implements Serializable{ 
    	// 总记录数
    	private long total;
    	// 当前记录数
    	private List rows;
    	public long getTotal() { 
    		return total;
    	}
    	public void setTotal(long total) { 
    		this.total = total;
    	}
    	public List getRows() { 
    		return rows;
    	}
    	public void setRows(List rows) { 
    		this.rows = rows;
    	}
    	public PageResult(long total, List rows) { 
    		super();
    		this.total = total;
    		this.rows = rows;
    	}
    }

> 服务层

@Service
    public class BrandServiceImpl implements BrandService { 
    	/** * 数据访问层 */
    	@Autowired
    	private TbBrandMapper brandMapper;
    	
    	@Override
    	public PageResult findPage(int pageNum, int pageSize) { 
    		
    		/** * MyBatis分页插件 * 在前面写这一句话，会自动实现分页 * 后面该咋写咋写 */
    		PageHelper.startPage(pageNum, pageSize);
    		/** * 查询所有，返回MyBatis的分页对象 */
    		Page<TbBrand> pageBrands = (Page<TbBrand>) brandMapper.selectByExample(null);
    		
    		/** * 返回一个PageResult * getTotal() ： PageResult的总记录数 * getResult() ： PageResult的当前记录数 */
    		return new PageResult(pageBrands.getTotal(), pageBrands.getResult());
    	}
    }

> angular.js