详解Mybatis分页插件-示例代码

public interface SysLoginLogMapper { 
  /** 
   * 根据查询条件查询登录日志 
   * @param logip 
   * @param username 
   * @param loginDate 
   * @param exitDate 
   * @return 
   */ 
  List findSysLoginLog(@Param("logip") String logip, 
                   @Param("username") String username, 
                   @Param("loginDate") String loginDate, 
                   @Param("exitDate") String exitDate, 
                   @Param("logerr") String logerr); 
 
} 

<&＃63;xml version="1.0" encoding="UTF-8" &＃63;> 
 
 
  
  select * from sys_login_log a 
   
   left join sys_user b on a.userid = b.userid 
   
   
    
    a.logip like '%'||#{logip}||'%' 
    
    
    and (b.username like '%'||#{username}||'%' or b.realname like '%'||#{username}||'%') 
    
    
    and to_date(substr(a.logindate,0,10),'yyyy-MM-dd') = to_date(#{loginDate},'yyyy-MM-dd') 
    
    
    and to_date(substr(a.EXITDATE,0,10),'yyyy-MM-dd') = to_date(#{exitDate},'yyyy-MM-dd') 
    
    
    and a.logerr like '%'||#{logerr}||'%' 
    
   
  order by logid desc 
  
 

public List findSysLoginLog(String loginIp, 
                     String username, 
                     String loginDate, 
                     String exitDate, 
                     String logerr) throws BusinessException { 
  return sysLoginLogMapper.findSysLoginLog(loginIp, username, loginDate, exitDate, logerr); 
} 

public PageHelper.Page findSysLoginLog(String loginIp, 
                     String username, 
                     String loginDate, 
                     String exitDate, 
                     String logerr, 
                     int pageNumber, 
                     int pageSize) throws BusinessException { 
  PageHelper.startPage(pageNumber,pageSize); 
  sysLoginLogMapper.findSysLoginLog(loginIp, username, loginDate, exitDate, logerr); 
  return PageHelper.endPage(); 
} 

PageHelper.startPage(pageNumber,pageSize); 

sysLoginLogMapper.findSysLoginLog(loginIp, username, loginDate, exitDate, logerr); 

PageHelper.endPage();