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.test.basic.EnumTest.java

License:Open Source License

@Test
public void testCloseable() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    PageHelper.startPage(1, 2);// ww  w. ja  v a2s  .c  om
    List<CountryCode> countryCodes = countryMapper.selectByCode(Code.AD);
    Assert.assertEquals(1, countryCodes.size());
    sqlSession.close();
}

From source file:com.github.pagehelper.test.basic.example.TestExample.java

License:Open Source License

@Test
public void testNull() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {//from   w  ww.  j  a  v a  2s .  c  o  m
        PageHelper.startPage(1, 20);
        List<Country> list = countryMapper.selectByExample(null);
        assertEquals(1, list.get(0).getId());
        assertEquals(20, list.size());
        assertEquals(183, ((Page<?>) list).getTotal());
    } finally {
        sqlSession.close();
    }
}

From source file:com.github.pagehelper.test.basic.example.TestExample.java

License:Open Source License

@Test
public void testGreaterThan() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {/*  w  w  w  .j  a  v  a 2 s.c  o  m*/
        CountryExample example = new CountryExample();
        example.createCriteria().andIdGreaterThan(100);
        PageHelper.startPage(1, 20);
        List<Country> list = countryMapper.selectByExample(example);
        assertEquals(101, list.get(0).getId());
        assertEquals(20, list.size());
        assertEquals(83, ((Page<?>) list).getTotal());
    } finally {
        sqlSession.close();
    }
}

From source file:com.github.pagehelper.test.basic.example.TestExample.java

License:Open Source License

@Test
public void testInList() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {//www. j  a v  a  2s  . c  om
        CountryExample example = new CountryExample();
        example.createCriteria().andIdIn(Arrays.asList(1, 2, 3, 4, 5));
        PageHelper.startPage(1, 20);
        List<Country> list = countryMapper.selectByExample(example);
        assertEquals(1, list.get(0).getId());
        assertEquals(5, list.size());
        assertEquals(5, ((Page<?>) list).getTotal());
    } finally {
        sqlSession.close();
    }
}

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

License:Open Source License

@Test
public void testIPage() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {//from   w ww . j a  v  a2  s  .  c o m
        CountryIPage queryModel = new CountryIPage();
        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(null);
        queryModel.setPageSize(null);
        queryModel.setOrderBy("id asc");
        list = countryMapper.selectByQueryModel(queryModel);
        assertEquals(1, list.get(0).getId());
        assertEquals(183, list.size());
        assertEquals(183, ((Page<?>) list).getTotal());
    } finally {
        sqlSession.close();
    }
}

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

License:Open Source License

@Test
public void testOffset() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {/*from  w w w  .j  a  v  a 2  s .c om*/
        PageHelper.startPage(1, 6);
        List<Country> list = countryMapper.selectAll();
        assertEquals(6, list.size());
        assertEquals(183, ((Page<?>) list).getTotal());

        PageHelper.offsetPage(6, 20);
        list = countryMapper.selectAll();
        PageInfo<Country> pageInfo = new PageInfo<Country>(list);
        System.out.println(pageInfo.toString());
        assertEquals(2, ((Page<?>) list).getPageNum());
        assertEquals(20, list.size());
        assertEquals(183, ((Page<?>) list).getTotal());

        PageHelper.offsetPage(105, 20, "id desc");
        list = countryMapper.selectAll();
        pageInfo = new PageInfo<Country>(list);
        System.out.println(pageInfo.toString());
        assertEquals(7, ((Page<?>) list).getPageNum());
        assertEquals(20, list.size());
        assertEquals(183, ((Page<?>) list).getTotal());
        assertEquals(7, ((Page<?>) list).getPageNum());
    } finally {
        sqlSession.close();
    }
}

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

License:Open Source License

@Test
public void testPageNum() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {//from   www  .ja  v a2 s . c om
        PageHelper.offsetPage(5, 5);
        List<Country> list = countryMapper.selectAll();
        assertEquals(2, ((Page<?>) list).getPageNum());
        assertEquals(5, list.size());
        assertEquals(183, ((Page<?>) list).getTotal());

        PageHelper.offsetPage(15, 5);
        list = countryMapper.selectAll();
        assertEquals(4, ((Page<?>) list).getPageNum());
        assertEquals(5, list.size());
        assertEquals(183, ((Page<?>) list).getTotal());
    } finally {
        sqlSession.close();
    }
}

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

License:Open Source License

@Test
public void shouldGetAllCountries() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {//from  ww  w .j a v a2 s.c  o m
        List<Country> list = sqlSession.selectList("selectAll");
        assertEquals(183, list.size());
    } finally {
        sqlSession.close();
    }
}

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

License:Open Source License

/**
 * Mapper?PageHelper.startPage??Mapper??
 *///from  w  w  w .java  2  s. c  om
@Test
public void testMapperWithStartPage() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {
        //?110?count
        PageHelper.startPage(1, 10, "id desc");
        List<Country> list = countryMapper.selectAll();
        assertEquals(10, list.size());
        assertEquals(183, ((Page<?>) list).getTotal());

        //?210??count
        PageHelper.orderBy("countryname desc");
        list = countryMapper.selectAll();
        assertEquals(183, list.size());
        assertEquals(183, ((Page<?>) list).getTotal());

        //?210??count
        PageHelper.startPage(2, 10, false);
        PageHelper.orderBy("id asc");
        list = countryMapper.selectAll();
        assertEquals(10, list.size());
        assertEquals(-1, ((Page<?>) list).getTotal());

        //?320?count
        PageHelper.orderBy("countryname desc");
        PageHelper.startPage(3, 20);
        list = countryMapper.selectAll();
        assertEquals(20, list.size());
        assertEquals(183, ((Page<?>) list).getTotal());
    } finally {
        sqlSession.close();
    }
}

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

License:Open Source License

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

        //?210??count
        list = countryMapper.selectAll(new RowBounds(10, 10));
        assertEquals(10, list.size());
        assertEquals(-1, ((Page<?>) list).getTotal());
        //??
        assertEquals(11, list.get(0).getId());
        assertEquals(20, list.get(list.size() - 1).getId());

        //?320?count
        list = countryMapper.selectAll(new RowBounds(60, 20));
        assertEquals(20, list.size());
        assertEquals(-1, ((Page<?>) list).getTotal());
        //??
        assertEquals(61, list.get(0).getId());
        assertEquals(80, list.get(list.size() - 1).getId());

        //?startPageRowBoundsstartPage
        PageHelper.startPage(1, 20);
        list = countryMapper.selectAll(new RowBounds(60, 20));
        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();
    }
}