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

List of usage examples for org.apache.ibatis.session SqlSession getMapper

  1. HOME
  2. Java
  3. org.apache.ibatis
  4. org.apache.ibatis.session.*
  5. SqlSession
  6. getMapper

Introduction

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

Prototype

<T> T getMapper(Class<T> type);

Source Link

Document

Retrieves a mapper.

Usage

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

License:Open Source License

/**
 * Mapper?PageHelper.startPage??Mapper??
 *//*  w w w.j  a v  a  2 s  .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  av  a 2s  .co  m
@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??
 *///  www  .  ja va  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);
        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();
    }
}

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 {//from   w ww .j a va  2  s . co m
        //?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 www.  ja  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.cache.SecondCacheTest.java

License:Open Source License

@Test
public void test3() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {//from   w  w w .j a v a2s.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  2s .  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 w w  .j av  a  2 s .  com*/
        //?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  ww  .j  a v a  2s.  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

/**
 *  - ${}// ww w .  ja v a2s. c  o  m
 */
@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();
    }
}