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.cache.CacheTest.java

License:Open Source License

/**
 * Mapper?PageHelper.startPage??Mapper??
 *//*from w  w w.ja  v a 2 s  .c om*/
@Test
public void testThreads() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    sqlSession.close();
    try {
        Thread.sleep(300);
    } catch (InterruptedException e) {
        e.printStackTrace();
    }
    Thread thread1 = new Thread(new CacheThread());
    Thread thread2 = new Thread(new CacheThread());
    Thread thread3 = new Thread(new CacheThread());
    Thread thread4 = new Thread(new CacheThread());
    Thread thread5 = new Thread(new CacheThread());
    thread1.start();
    thread2.start();
    thread3.start();
    thread4.start();
    thread5.start();
    try {
        Thread.sleep(300);
    } catch (InterruptedException e) {
        e.printStackTrace();
    }
}

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

License:Open Source License

@Test
public void test1() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {//  w w  w .java 2 s.c om
        //?110?count
        PageHelper.startPage(1, 10);
        List<Country> list = countryMapper.selectGreterThanId(10);
        assertEquals(10, list.size());

        //?110?count
        PageHelper.startPage(1, 10);
        list = countryMapper.selectGreterThanId(10);
        assertEquals(10, list.size());
    } finally {
        sqlSession.close();
    }

    sqlSession = MybatisHelper.getSqlSession();
    countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {
        //?110?count
        PageHelper.startPage(1, 10);
        List<Country> list = countryMapper.selectGreterThanId(10);
        assertEquals(10, list.size());
    } finally {
        sqlSession.close();
    }
}

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

License:Open Source License

@Test
public void test2() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {/*from w  w w  . j av a2s .c om*/
        //?110?count
        PageHelper.startPage(1, 10);
        List<Country> list = countryMapper.selectGreterThanId(10);
        assertEquals(10, list.size());
    } finally {
        sqlSession.close();
    }
}

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

License:Open Source License

@Test
public void test3() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {//from  ww w  . j a  v a 2s  . c  o  m
        //?110?count
        PageHelper.startPage(1, 10);
        List<Country> list = countryMapper.selectGreterThanId(10);
        assertEquals(10, list.size());
    } finally {
        sqlSession.close();
    }
}

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

License:Open Source License

@Test
public void testCloseable() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    //???jdk7+/*w w w .  j a v a  2 s.c  o m*/
    //        try(Page<Object> page = PageHelper.startPage(1, 10)) {
    //            int a = 10/0;
    //            countryMapper.selectAll();
    //            Assert.fail();
    //        } catch (Exception e){
    //            e.printStackTrace();
    //        }
    List<Country> countries = countryMapper.selectAll();
    Assert.assertEquals(183, countries.size());
    sqlSession.close();
}

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

License:Open Source License

@Test
public void test() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {/*w ww .  j  a  va 2s  .  c o  m*/
        //?110?count
        PageHelper.startPage(1, 5);
        List<Country> list1 = countryMapper.selectGreterThanId(1);

        //?110?count
        PageHelper.startPage(1, 5);
        List<Country> list2 = countryMapper.selectCollectionMap();
        assertEquals(5, list2.size());
        assertEquals(183, ((Page<?>) list2).getTotal());
    } finally {
        sqlSession.close();
    }
}

From source file:com.github.pagehelper.test.basic.count.TestGroupBy.java

License:Open Source License

@Test
public void testGroupBy() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {//w  w w .ja  v  a2s.c o m
        //?110?count
        Page<Country> page = PageHelper.startPage(1, 10);
        ;
        countryMapper.selectGroupBy();
        //1,'Angola','AO'
        assertEquals(1, page.get(0).getId());
        assertEquals(10, page.size());
        assertEquals(183, page.getTotal());

        PageInfo<Country> pageInfo = page.toPageInfo();
        System.out.println(pageInfo);

        //?210?count
        page = PageHelper.startPage(2, 10);
        countryMapper.selectGroupBy();
        //1,'Angola','AO'
        assertEquals(1, page.get(0).getId());
        assertEquals(10, page.size());
        assertEquals(183, page.getTotal());
    } finally {
        sqlSession.close();
    }
}

From source file:com.github.pagehelper.test.basic.count.TestSelectItems.java

License:Open Source License

/**
 *  - ${}//from w  w  w .  ja v a2s. c  om
 */
@Test
public void testSelectColumns() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {
        //?110?count
        PageHelper.startPage(1, 10);
        List<Country> list = countryMapper.selectColumns();
        //1,'Angola','AO'
        assertEquals(1, list.get(0).getId());
        assertEquals("Angola", list.get(0).getCountryname());
        assertEquals("AO", list.get(0).getCountrycode());
        assertEquals(10, list.size());
        assertEquals(183, ((Page<?>) list).getTotal());

        //?110?count
        PageHelper.startPage(1, 10);
        list = countryMapper.selectColumns("id", "countryname");
        //1,'Angola','AO'
        assertEquals(1, list.get(0).getId());
        assertEquals("Angola", list.get(0).getCountryname());
        assertNull(list.get(0).getCountrycode());
        assertEquals(10, list.size());
        assertEquals(183, ((Page<?>) list).getTotal());
    } finally {
        sqlSession.close();
    }
}

From source file:com.github.pagehelper.test.basic.count.TestSelectItems.java

License:Open Source License

/**
 * #{}count?/*from www.  j a  va 2  s  .  c o m*/
 */
@Test
public void testSelectColumn2() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {
        //?110?count
        PageHelper.startPage(1, 10);
        List<Country> list = countryMapper.selectMULId(1);
        //1,'Angola','AO'
        assertEquals(1, list.get(0).getId());
        assertEquals(10, list.size());
        assertEquals(183, ((Page<?>) list).getTotal());

        //?110?count
        PageHelper.startPage(1, 10);
        list = countryMapper.selectMULId(5);
        //1,'Angola','AO'
        assertEquals(5, list.get(0).getId());
        assertEquals(10, list.size());
        assertEquals(183, ((Page<?>) list).getTotal());
    } finally {
        sqlSession.close();
    }
}

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

License:Open Source License

@Test
public void testMapperWithStartPage() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {/*www. j a v  a  2  s.c o  m*/
        //?110?count
        PageHelper.startPage(1, 10).countColumn("id");
        Country country = new Country();
        country.setCountryname("c");
        List<Country> list = countryMapper.selectLike(country);
        assertEquals(30, list.get(0).getId());
        assertEquals(10, list.size());
        assertEquals(39, ((Page<?>) list).getTotal());

        //?110?count
        PageHelper.startPage(4, 10);
        list = countryMapper.selectLike(country);
        assertEquals(130, list.get(0).getId());
        assertEquals(9, list.size());
        assertEquals(39, ((Page<?>) list).getTotal());
    } finally {
        sqlSession.close();
    }
}