Examples with User com.github.pagehelper.model.User used on opensource projects

Example 56 with User

use of com.github.pagehelper.model.User in project Mybatis-PageHelper by pagehelper.

the class PageHelperTest method testNamespaceWithRowBounds.

/**
 * 使用命名空间方式的RowBounds进行分页，使用RowBounds时不进行count查询
 * 通过修改代码可以进行count查询，没法通过其他方法改变参数
 * 因为如果通过调用一个别的方法来标记count查询，还不如直接startPage
 * <p/>
 * 同时使用startPage时，以startPage为准，会根据startPage参数来查询
 */
@Test
public void testNamespaceWithRowBounds() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        // 获取从0开始，10条内容
        List<User> list = sqlSession.selectList("selectAll", null, new RowBounds(0, 10));
        assertEquals(10, list.size());
        assertEquals(183, ((Page<?>) list).getTotal());
        // 判断查询结果的位置是否正确
        assertEquals(1, list.get(0).getId());
        assertEquals(10, list.get(list.size() - 1).getId());
        // 获取从10开始，10条内容
        list = sqlSession.selectList("selectAll", null, new RowBounds(10, 10));
        assertEquals(10, list.size());
        assertEquals(183, ((Page<?>) list).getTotal());
        // 判断查询结果的位置是否正确
        assertEquals(11, list.get(0).getId());
        assertEquals(20, list.get(list.size() - 1).getId());
        // 获取从20开始，20条内容
        list = sqlSession.selectList("selectAll", null, new RowBounds(20, 20));
        assertEquals(20, list.size());
        assertEquals(183, ((Page<?>) list).getTotal());
        // 判断查询结果的位置是否正确
        assertEquals(21, list.get(0).getId());
        assertEquals(40, list.get(list.size() - 1).getId());
        // 同时使用startPage和RowBounds时，以startPage为准
        PageHelper.startPage(1, 20);
        list = sqlSession.selectList("selectAll", null, new RowBounds(0, 10));
        assertEquals(20, list.size());
        assertEquals(183, ((Page<?>) list).getTotal());
        // 判断查询结果的位置是否正确
        assertEquals(1, list.get(0).getId());
        assertEquals(20, list.get(list.size() - 1).getId());
    } finally {
        sqlSession.close();
    }
}

Example 57 with User

use of com.github.pagehelper.model.User in project Mybatis-PageHelper by pagehelper.

the class PageHelperTest method testNamespaceWithStartPage.

/**
 * 使用命名空间调用时，使用PageHelper.startPage
 * <p/>
 * startPage第三个参数可以控制是(true)否(false)执行count查询，使用两个查询的startPage时默认进行count查询
 * <p/>
 * 使用startPage方法时，如果同时使用RowBounds，以startPage为准
 */
@Test
public void testNamespaceWithStartPage() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        // 获取第1页，10条内容，默认查询总数count
        PageHelper.startPage(1, 10);
        List<User> list = sqlSession.selectList("selectAll");
        assertEquals(10, list.size());
        assertEquals(183, ((Page<?>) list).getTotal());
        // 获取第2页，10条内容，显式查询总数count
        PageHelper.startPage(2, 10, true);
        list = sqlSession.selectList("selectAll");
        assertEquals(10, list.size());
        assertEquals(183, ((Page<?>) list).getTotal());
        // 获取第2页，10条内容，不查询总数count
        PageHelper.startPage(2, 10, false);
        list = sqlSession.selectList("selectAll");
        assertEquals(10, list.size());
        assertEquals(-1, ((Page<?>) list).getTotal());
        // 获取第3页，20条内容，默认查询总数count
        PageHelper.startPage(3, 20);
        list = sqlSession.selectList("selectAll");
        assertEquals(20, list.size());
        assertEquals(183, ((Page<?>) list).getTotal());
    } finally {
        sqlSession.close();
    }
}

Example 58 with User

use of com.github.pagehelper.model.User in project Mybatis-PageHelper by pagehelper.

the class RemoveOrderTest method paramsOrderTest.

@Test
public void paramsOrderTest() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
    // 主要观看查询执行count查询的sql
    try {
        PageHelper.startPage(1, 50);
        List<User> list = userMapper.selectAllOrderByParams("name", "py");
        // 总数183
        Assert.assertEquals(183, ((Page<?>) list).getTotal());
    } finally {
        sqlSession.close();
    }
}

Example 59 with User

use of com.github.pagehelper.model.User in project Mybatis-PageHelper by pagehelper.

the class RemoveOrderTest method simpleOrderTest.

@Test
public void simpleOrderTest() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
    // 主要观看查询执行count查询的sql
    try {
        PageHelper.startPage(1, 50);
        List<User> list = userMapper.selectAllOrderby();
        // 总数183
        Assert.assertEquals(183, ((Page<?>) list).getTotal());
    } finally {
        sqlSession.close();
    }
}

Example 60 with User

use of com.github.pagehelper.model.User in project Mybatis-PageHelper by pagehelper.

the class TestExecute method test.

@Test
public void test() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
    try {
        // 获取第1页，10条内容，默认查询总数count
        PageHelper.startPage(1, 10);
        List<Map<String, Object>> mapList = userMapper.execute("select * from user");
        Assert.assertEquals(10, mapList.size());
        mapList = userMapper.execute("select * from user");
        Assert.assertEquals(183, mapList.size());
        List<User> userList = userMapper.selectAll();
        Assert.assertEquals(183, userList.size());
    } finally {
        sqlSession.close();
    }
}