Example usage for org.apache.ibatis.session SqlSession close

Introduction

In this page you can find the example usage for org.apache.ibatis.session SqlSession close.

Prototype

@Override
void close();

Source Link

Document

Closes the session.

Usage

From source file:com.github.pagehelper.rowbounds.test.PageRowBoundsTest.java

License:Open Source License

@Test
public void testNamespaceWithRowBounds2() {
    SqlSession sqlSession = RowBoundsHelper.getSqlSession();
    try {//from  w ww.  j a  v  a 2s  . c o m
        //?010?
        PageRowBounds pageRowBounds = new PageRowBounds(0, 10);
        List<Country> list = sqlSession.selectList("selectIf", null, pageRowBounds);
        assertEquals(10, list.size());
        assertEquals(183L, pageRowBounds.getTotal().longValue());
        //??
        assertEquals(1, list.get(0).getId());
        assertEquals(10, list.get(list.size() - 1).getId());

        Map<String, Object> map = new HashMap<String, Object>();
        map.put("id", 10);
        //?1010?
        pageRowBounds = new PageRowBounds(90, 10);
        list = sqlSession.selectList("selectIf", map, pageRowBounds);
        assertEquals(10, list.size());
        assertEquals(173L, pageRowBounds.getTotal().longValue());
        //??
        assertEquals(101, list.get(0).getId());
        assertEquals(110, list.get(list.size() - 1).getId());
    } finally {
        sqlSession.close();
    }
}

From source file:com.github.pagehelper.rowbounds.test.PageRowBoundsTest.java

License:Open Source License

/**
 * Mapper?PageHelper.startPage??Mapper??
 *///w w  w  .j  a v  a  2s  .c  o m
@Test
public void testWithRowboundsAndCountTrue() {
    SqlSession sqlSession = RowBoundsHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {
        //limit=0,?count,????rounbounds?count?-1
        //?-1
        PageRowBounds pageRowBounds = new PageRowBounds(0, -1);
        List<Country> list = countryMapper.selectAll(pageRowBounds);
        assertEquals(183, list.size());

        //pageSize<0?
        list = countryMapper.selectAll(new PageRowBounds(0, -100));
        assertEquals(183, list.size());
    } finally {
        sqlSession.close();
    }
}

From source file:com.github.pagehelper.rowbounds.test.RowBoundsTest.java

License:Open Source License

/**
 * Mapper??RowBounds???xml??/*from  w w  w.j a v  a  2 s. co m*/
 * <p/>
 * RowBounds??count?Page?
 * <p/>
 * ??startPagestartPage
 */
@Test
public void testMapperWithRowBounds() {
    SqlSession sqlSession = RowBoundsHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {
        //?110?count
        List<Country> list = countryMapper.selectAll(new RowBounds(0, 10));
        //PageInfo?
        assertEquals(10, list.size());
        //??
        assertEquals(1, list.get(0).getId());
        assertEquals(10, list.get(list.size() - 1).getId());

        //?1010??count
        list = countryMapper.selectAll(new RowBounds(90, 10));
        assertEquals(10, list.size());
        //??
        assertEquals(91, list.get(0).getId());
        assertEquals(100, list.get(list.size() - 1).getId());

        //?320?count
        list = countryMapper.selectAll(new RowBounds(100, 20));
        assertEquals(20, list.size());
        //??
        assertEquals(101, list.get(0).getId());
        assertEquals(120, list.get(list.size() - 1).getId());
    } finally {
        sqlSession.close();
    }
}

From source file:com.github.pagehelper.rowbounds.test.RowBoundsTest.java

License:Open Source License

/**
 * ???RowBoundsRowBounds?count//from   w w  w .  ja v  a2  s .co m
 * ??count??
 * ?count?startPage
 * <p/>
 * ?startPagestartPage?startPage??
 */
@Test
public void testNamespaceWithRowBounds() {
    SqlSession sqlSession = RowBoundsHelper.getSqlSession();
    try {
        //?010?
        List<Country> list = sqlSession.selectList("selectAll", null, new RowBounds(0, 10));
        assertEquals(10, list.size());
        //??
        assertEquals(1, list.get(0).getId());
        assertEquals(10, list.get(list.size() - 1).getId());

        //?1010?
        list = sqlSession.selectList("selectAll", null, new RowBounds(90, 10));
        assertEquals(10, list.size());
        //??
        assertEquals(91, list.get(0).getId());
        assertEquals(100, list.get(list.size() - 1).getId());

        //?2020?
        list = sqlSession.selectList("selectAll", null, new RowBounds(100, 20));
        assertEquals(20, list.size());
        //??
        assertEquals(101, list.get(0).getId());
        assertEquals(120, list.get(list.size() - 1).getId());
    } finally {
        sqlSession.close();
    }
}

From source file:com.github.pagehelper.rowbounds.test.RowBoundsTest.java

License:Open Source License

@Test
public void testNamespaceWithRowBounds2() {
    SqlSession sqlSession = RowBoundsHelper.getSqlSession();
    try {//from   ww w .  jav  a  2  s .c om
        //?010?
        List<Country> list = sqlSession.selectList("selectIf", null, new RowBounds(0, 10));
        assertEquals(10, list.size());
        //??
        assertEquals(1, list.get(0).getId());
        assertEquals(10, list.get(list.size() - 1).getId());

        Map<String, Object> map = new HashMap<String, Object>();
        map.put("id", 10);
        //?1010?
        list = sqlSession.selectList("selectIf", map, new RowBounds(90, 10));
        assertEquals(10, list.size());
        //??
        assertEquals(101, list.get(0).getId());
        assertEquals(110, list.get(list.size() - 1).getId());
    } finally {
        sqlSession.close();
    }
}

From source file:com.github.pagehelper.rowbounds.test.RowBoundsTest.java

License:Open Source License

/**
 * Mapper?PageHelper.startPage??Mapper??
 *//*from w ww . j  av a2 s  . c  om*/
@Test
public void testWithRowboundsAndCountTrue() {
    SqlSession sqlSession = RowBoundsHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {
        //limit=0,?count,????rounbounds?count?-1
        //?-1
        List<Country> list = countryMapper.selectAll(new RowBounds(0, -1));
        assertEquals(183, list.size());

        //pageSize<0?
        list = countryMapper.selectAll(new RowBounds(0, -100));
        assertEquals(183, list.size());
    } finally {
        sqlSession.close();
    }
}

From source file:com.github.pagehelper.test.basic.annotations.TestAnnotations.java

License:Open Source License

/**
 * Mapper?PageHelper.startPage??Mapper??
 *//*from  ww  w .j  av  a 2s.  c  o  m*/
@Test
public void testMapperWithStartPage() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {
        //?110?count
        PageHelper.startPage(1, 10);
        List<Country> list = countryMapper.selectByOrder2("id");
        assertEquals(1, list.get(0).getId());
        assertEquals(10, list.size());
        assertEquals(183, ((Page<?>) list).getTotal());

        //?110?count
        PageHelper.startPage(1, 10);
        list = countryMapper.selectByOrder("countryname");
        assertEquals(2, list.get(0).getId());
        assertEquals(10, list.size());
        assertEquals(183, ((Page<?>) list).getTotal());
    } finally {
        sqlSession.close();
    }
}

From source file:com.github.pagehelper.test.basic.ArgumentsMapTest.java

License:Open Source License

/**
 * Mapper?PageHelper.startPage??Mapper??
 *//* w w w  . j  a  va2s .  c  om*/
@Test
public void testArgumentsMap() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {
        List<Country> list = countryMapper.selectByPageNumSizeOrderBy(1, 10, "id desc");
        assertEquals(10, list.size());
        assertEquals(183, ((Page<?>) list).getTotal());

        list = countryMapper.selectByPageNumSize(2, 10);
        assertEquals(10, list.size());
        assertEquals(183, ((Page<?>) list).getTotal());

        list = countryMapper.selectByPageNumSize(3, 20);
        assertEquals(20, list.size());
        assertEquals(183, ((Page<?>) list).getTotal());

        list = countryMapper.selectByOrderBy("id desc");
        assertEquals(183, list.size());
        assertEquals(183, list.get(0).getId());
    } finally {
        sqlSession.close();
    }
}

From source file:com.github.pagehelper.test.basic.ArgumentsObjTest.java

License:Open Source License

/**
 * Mapper?PageHelper.startPage??Mapper??
 *///  www.j a  v a  2  s  .com
@Test
public void testArgumentsObj() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {
        CountryQueryModel queryModel = new CountryQueryModel();
        queryModel.setPageNum(1);
        queryModel.setPageSize(10);
        queryModel.setOrderBy("id desc");
        List<Country> list = countryMapper.selectByQueryModel(queryModel);
        assertEquals(10, list.size());
        assertEquals(183, ((Page<?>) list).getTotal());

        queryModel.setPageNum(2);
        queryModel.setOrderBy(null);
        list = countryMapper.selectByQueryModel(queryModel);
        assertEquals(10, list.size());
        assertEquals(183, ((Page<?>) list).getTotal());

        queryModel.setPageNum(3);
        queryModel.setPageSize(20);
        list = countryMapper.selectByQueryModel(queryModel);
        assertEquals(20, list.size());
        assertEquals(183, ((Page<?>) list).getTotal());

        queryModel.setPageNum(null);
        queryModel.setPageSize(null);
        queryModel.setOrderBy("id desc");
        list = countryMapper.selectByQueryModel(queryModel);
        assertEquals(183, list.size());
        assertEquals(183, list.get(0).getId());
    } finally {
        sqlSession.close();
    }
}

From source file:com.github.pagehelper.test.basic.cache.CacheTest.java

License:Open Source License

/**
 * Mapper?PageHelper.startPage??Mapper??
 *//*w w  w .j  av  a  2s . com*/
@Test
public void testMapperWithStartPage() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {
        //?110?count
        PageHelper.startPage(1, 10);
        List<Country> list = countryMapper.selectGreterThanId(10);
        assertEquals(10, list.size());
        //?110?count
        PageHelper.startPage(2, 10);
        list = countryMapper.selectGreterThanIdAndNotEquelContryname(10, "china");
        assertEquals(10, list.size());
        //?110?count
        PageHelper.startPage(3, 10);
        list = countryMapper.selectGreterThanIdAndNotEquelContryname(10, "china");
        assertEquals(10, list.size());
        //?110?count
        PageHelper.startPage(4, 10);
        list = countryMapper.selectGreterThanIdAndNotEquelContryname(10, "china");
        assertEquals(10, list.size());
        //?110?count
        PageHelper.startPage(5, 10);
        list = countryMapper.selectGreterThanIdAndNotEquelContryname(10, "china");
        assertEquals(10, list.size());
    } finally {
        sqlSession.close();
    }
}