【Mybatis Plus-04】XML自定义分页

UserMapper.java

public interface UserMapper extends BaseMapper {
	//方式一
    IPage selectMyPage(IPage page, @Param(Constants.WRAPPER) Wrapper queryWrapper);
    //方式二
	List selectMyPage2(@Param("pageNum")int pageNum, @Param("pageSize")int PageSize);
}

UserMapper.xml

    
        select * from boot_user
    

	
       select * from boot_user limit #{pageNum},#{pageSize}
    

测试

@SpringBootTest
@RunWith(SpringRunner.class)
public class MapperTests {
    @Test
    public void page(){
        Page page = new Page<>(1,1);
        QueryWrapper userQueryWrapper = new QueryWrapper<>();
        userQueryWrapper.gt("age",5);
        userMapper.selectMyPage(page,userQueryWrapper);
    }
    
    @Test
    public void page2(){
        int pageNum=1;
        int pageSize=2;
        List users = userMapper.selectMyPage2(pageNum, pageSize);
        userMapper.selectMyPage2(pageNum,pageSize);
    }
}

打印sql
page()
page2()

如果要对字段进行比较，方式一更合适