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.provider.TestProvider.java

License:Open Source License

@Test
public void testProvider() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    Map<String, Object> map = new HashMap<String, Object>();
    map.put("id", 100);
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {//from  w w w  .j a  va 2s. co m
        PageHelper.startPage(1, 10);
        List<Country> list = countryMapper.selectByProvider(map);
        assertEquals(100, list.get(0).getId());
        assertEquals(1, list.size());
        assertEquals(1, ((Page<?>) list).getTotal());

        map.put("countryname", "?");
        PageHelper.startPage(1, 10);
        list = countryMapper.selectByProvider(map);
        assertEquals(0, list.size());
    } finally {
        sqlSession.close();
    }
}

From source file:com.github.pagehelper.test.basic.provider.TestProvider.java

License:Open Source License

@Test
public void testCountryProvider() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    Country country = new Country();
    country.setId(100);/* w  w w  .  j a v a2  s.c om*/
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {
        PageHelper.startPage(1, 10);
        List<Country> list = countryMapper.selectByCountryProvider(country);
        assertEquals(100, list.get(0).getId());
        assertEquals(1, list.size());
        assertEquals(1, ((Page<?>) list).getTotal());

        country.setCountryname("?");
        PageHelper.startPage(1, 10);
        list = countryMapper.selectByCountryProvider(country);
        assertEquals(0, list.size());
    } finally {
        sqlSession.close();
    }
}

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

License:Open Source License

@Test
public void simpleOrderTest() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    //?countsql//from   www.ja v  a2  s.c o  m
    try {
        PageHelper.startPage(1, 50);
        List<Country> list = countryMapper.selectAllOrderby();
        //183
        Assert.assertEquals(183, ((Page<?>) list).getTotal());
    } finally {
        sqlSession.close();
    }
}

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

License:Open Source License

@Test
public void paramsOrderTest() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    //?countsql// w  ww . j  a v a2  s  .  co  m
    try {
        PageHelper.startPage(1, 50);
        List<Country> list = countryMapper.selectAllOrderByParams("countryname", "countrycode");
        //183
        Assert.assertEquals(183, ((Page<?>) list).getTotal());
    } finally {
        sqlSession.close();
    }
}

From source file:com.github.pagehelper.test.basic.sql.TestExists.java

License:Open Source License

/**
 * unioncountsql/*from  w  w w .  j  a v  a 2s .  co m*/
 */
@Test
public void testExists() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {
        //?110?count
        PageHelper.startPage(1, 10);
        List<Country> list = countryMapper.selectExists();
        assertEquals(101, list.get(0).getId());
        assertEquals(10, list.size());
        assertEquals(83, ((Page<?>) list).getTotal());

        //?110?count
        PageHelper.startPage(2, 10);
        list = countryMapper.selectExists();
        assertEquals(111, list.get(0).getId());
        assertEquals(10, list.size());
        assertEquals(83, ((Page<?>) list).getTotal());
    } finally {
        sqlSession.close();
    }
}

From source file:com.github.pagehelper.test.basic.sql.TestLeftjoin.java

License:Open Source License

/**
 * left joincountsql//from  w w w .java 2s  . co m
 */
@Test
public void testLeftjoin() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {
        //?110?count
        PageHelper.startPage(1, 10);
        List<Country> list = countryMapper.selectLeftjoin();
        assertEquals(1, list.get(0).getId());
        assertEquals(10, list.size());
        assertEquals(183, ((Page<?>) list).getTotal());

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

From source file:com.github.pagehelper.test.basic.sql.TestUnion.java

License:Open Source License

/**
 * unioncountsql//from  w ww .  jav  a2 s . com
 */
@Test
public void testUnion() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {
        //?110?count
        PageHelper.startPage(1, 10);
        List<Country> list = countryMapper.selectUnion();
        assertEquals(1, list.get(0).getId());
        assertEquals(10, list.size());
        assertEquals(13, ((Page<?>) list).getTotal());

        //?110?count
        PageHelper.startPage(2, 10);
        list = countryMapper.selectUnion();
        assertEquals(181, list.get(0).getId());
        assertEquals(3, list.size());
        assertEquals(13, ((Page<?>) list).getTotal());
    } finally {
        sqlSession.close();
    }
}

From source file:com.github.pagehelper.test.basic.sql.TestWith.java

License:Open Source License

/**
 * withcountsql - ?oracle,???//from   w  w w  .  j ava 2s .co  m
 */
@Test
public void testUnion() throws Exception {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    //?oracle
    if (!TestUtil.getXmlPath().equalsIgnoreCase("oracle")) {
        return;
    }
    try {
        //?110?count
        PageHelper.startPage(1, 10);
        List<Country> list = countryMapper.selectWith();
        assertEquals(151, list.get(0).getId());
        assertEquals(10, list.size());
        assertEquals(33, ((Page<?>) list).getTotal());

        //?110?count
        PageHelper.startPage(2, 10);
        list = countryMapper.selectWith();
        assertEquals(161, list.get(0).getId());
        assertEquals(10, list.size());
        assertEquals(33, ((Page<?>) list).getTotal());
    } finally {
        sqlSession.close();
    }
}

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

License:Open Source License

@Test
public void test() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {//from w w w  .  j ava  2s  . c  om
        //?110?count
        PageHelper.startPage(1, 10);
        List<Country> list = countryMapper.selectDistinct();
        assertEquals(10, list.size());
        assertEquals(24, ((Page<?>) list).getTotal());
    } finally {
        sqlSession.close();
    }
}

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

License:Open Source License

@Test
public void test() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {/*  w  w  w .j a v a  2  s .co  m*/
        //?110?count
        PageHelper.startPage(1, 10);
        List<Map<String, Object>> mapList = countryMapper.execute("select * from country");
        Assert.assertEquals(10, mapList.size());
        mapList = countryMapper.execute("select * from country");
        Assert.assertEquals(183, mapList.size());
        List<Country> countryList = countryMapper.selectAll();
        Assert.assertEquals(183, countryList.size());
    } finally {
        sqlSession.close();
    }
}