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.TestIntMax.java

License:Open Source License

/**
 * Mapper?PageHelper.startPage??Mapper??
 *///  w  w  w .ja va2s . c o m
@Test
public void testCountCache() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {
        //?110?count
        PageHelper.startPage(1, Integer.MAX_VALUE);
        List<Country> list = countryMapper.selectIf(1);
        assertEquals(2, list.get(0).getId());
        assertEquals(182, list.size());
        assertEquals(182, ((Page<?>) list).getTotal());

        //?110?count
        PageHelper.startPage(1, Integer.MAX_VALUE);
        list = countryMapper.selectIf(null);
        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.TestISelect.java

License:Open Source License

@Test
public void testGroupBy2() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    final CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {/*from   w  ww .j a va2  s  .co  m*/
        Page<Country> page = PageHelper.startPage(1, 10).setOrderBy("id desc").doSelectPage(new ISelect() {
            @Override
            public void doSelect() {
                countryMapper.selectGroupBy();
            }
        });
        //?lambda
        //Page<Country> page = PageHelper.startPage(1, 10).setOrderBy("id desc").doSelectPage(()-> 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);

        pageInfo = PageHelper.startPage(1, 10).setOrderBy("id desc").doSelectPageInfo(new ISelect() {
            @Override
            public void doSelect() {
                countryMapper.selectGroupBy();
            }
        });
        //lambda
        //pageInfo = PageHelper.startPage(1, 10).setOrderBy("id desc").doSelectPageInfo(() -> countryMapper.selectGroupBy());

        System.out.println(pageInfo);

        final Country country = new Country();
        country.setCountryname("c");

        long total = PageHelper.count(new ISelect() {
            @Override
            public void doSelect() {
                countryMapper.selectLike(country);
            }
        });
        //lambda
        //long total = PageHelper.count(()->countryMapper.selectLike(country));

        System.out.println(total);
    } finally {
        sqlSession.close();
    }
}

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

License:Open Source License

/**
 * Mapper?PageHelper.startPage??Mapper??
 *///from   ww  w  .  ja v a 2 s  .  c o  m
@Test
public void testMapperWithStartPage() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {
        //?110?count
        PageHelper.startPage(1, 10);
        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();
    }
}

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

License:Open Source License

/**
 * Mapper?PageHelper.startPage??Mapper??
 *///from w  w w .  j  a va2  s.com
@Test
public void testMapperWithStartPage() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        //?110?count
        PageHelper.startPage(1, 10);
        Map<String, Object> map = new HashMap<String, Object>();
        map.put("countryname", "c");
        List<Country> list = sqlSession.selectList("selectLike", map);
        assertEquals(30, list.get(0).getId());
        assertEquals(10, list.size());
        assertEquals(39, ((Page<?>) list).getTotal());

        PageHelper.startPage(1, 10);
        map.put("countryname", "China");
        map.put("countrycode", "CN");
        list = sqlSession.selectList("selectByMap", map);
        assertEquals(35, list.get(0).getId());
        assertEquals(1, list.size());
        assertEquals(1, ((Page<?>) list).getTotal());
    } finally {
        sqlSession.close();
    }
}

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

License:Open Source License

/**
 * Mapper?PageHelper.startPage??Mapper??
 *///from  w  ww .ja  v a  2s  .c  o m
@Test
public void testThreads() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    sqlSession.close();
    try {
        Thread.sleep(1000);
    } 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(5000);
    } catch (InterruptedException e) {
        e.printStackTrace();
    }
}

From source file:com.github.pagehelper.test.namespace.BasicTest.java

License:Open Source License

@Test
public void testNamespace1() {
    SqlSession sqlSession = MybatisRowBoundsHelper.getSqlSession();
    try {//w w  w  . java  2 s.  com
        Map<String, Object> map = new HashMap<String, Object>();
        Country country = new Country();
        country.setCountryname("China");
        map.put("country", country);
        //????Map
        map = Collections.unmodifiableMap(map);
        List<Country> list = sqlSession.selectList("select1", map, new RowBounds(1, 10));
        assertEquals(1, list.size());
        //??
        assertEquals(35, list.get(0).getId());
    } finally {
        sqlSession.close();
    }
}

From source file:com.github.pagehelper.test.namespace.BasicTest.java

License:Open Source License

@Test
public void testNamespace3() {
    SqlSession sqlSession = MybatisRowBoundsHelper.getSqlSession();
    try {/*from   www .j a v  a2  s  .c om*/
        Map<String, Object> map = new HashMap<String, Object>();
        Country country = new Country();
        map.put("country", country);
        //????Map
        map = Collections.unmodifiableMap(map);
        List<Country> list = sqlSession.selectList("select1", map, new RowBounds(1, 10));
        assertEquals(10, list.size());
        //??
        assertEquals(1, list.get(0).getId());

        map = new HashMap<String, Object>();
        country = new Country();
        country.setCountryname("China");
        map.put("country", country);
        //????Map
        map = Collections.unmodifiableMap(map);
        list = sqlSession.selectList("select1", map, new RowBounds(1, 10));
        assertEquals(1, list.size());
        //??
        assertEquals(35, list.get(0).getId());
    } finally {
        sqlSession.close();
    }
}

From source file:com.github.pagehelper.test.namespace.BasicTest.java

License:Open Source License

@Test
public void testNamespace2() {
    SqlSession sqlSession = MybatisRowBoundsHelper.getSqlSession();
    try {/*  www  . ja  v a2  s  .  co  m*/
        Map<String, Object> map = new HashMap<String, Object>();
        Country country = new Country();
        country.setCountryname("China");
        map.put("country", country);
        PageHelper.startPage(1, 10);
        List<Country> list = sqlSession.selectList("select1", map);
        assertEquals(1, list.size());
        //??
        assertEquals(35, list.get(0).getId());
    } finally {
        sqlSession.close();
    }
}

From source file:com.github.pagehelper.test.page.PageTest.java

License:Open Source License

/**
 * Mapper?PageHelper.startPage??Mapper??
 *//*from  www  .  j  a  v a2s  .com*/
@Test
public void testMapperWithStartPage() {
    SqlSession sqlSession = MybatisPageHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {
        //?202?
        //??
        PageHelper.startPage(20, 2);
        List<Country> list = countryMapper.selectAll();
        PageInfo page = new PageInfo(list);
        assertEquals(1, list.size());
        assertEquals(7, page.getStartRow());
        assertEquals(4, page.getPageNum());
        assertEquals(7, page.getTotalNum());

        //?-32?
        //?7???
        PageHelper.startPage(-3, 2);
        list = countryMapper.selectAll();
        page = new PageInfo(list);
        assertEquals(2, list.size());
        assertEquals(1, page.getStartRow());
        assertEquals(1, page.getPageNum());
        assertEquals(7, page.getTotalNum());
    } finally {
        sqlSession.close();
    }
}

From source file:com.github.pagehelper.test.pagesize.PageSizeLessThenOrEqualZeroTest.java

License:Open Source License

/**
 * Mapper?PageHelper.startPage??Mapper??
 *//*  w ww.jav  a  2s .c  o  m*/
@Test
public void testWithStartPage() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {
        //pageSize=0,?count
        PageHelper.startPage(1, 0);
        List<Country> list = countryMapper.selectAll();
        PageInfo<Country> page = new PageInfo<Country>(list);
        assertEquals(0, list.size());
        assertEquals(183, page.getTotal());

        //limit<0?
        PageHelper.startPage(1, -100);
        list = countryMapper.selectAll();
        page = new PageInfo<Country>(list);
        assertEquals(0, list.size());
        assertEquals(183, page.getTotal());
    } finally {
        sqlSession.close();
    }
}