Example usage for org.apache.ibatis.session SqlSession 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.sinotopia.mybatis.mapper.test.example.TestSelectCountByExample.java

License:Open Source License

@Test
public void testSelectCountByExampleForUpdate() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {//  w w w.j a v a2  s  . c  o m
        CountryMapper mapper = sqlSession.getMapper(CountryMapper.class);
        Example example = new Example(Country.class);
        example.setForUpdate(true);
        example.createCriteria().andGreaterThan("id", 100);
        int count = mapper.selectCountByExample(example);
        //
        Assert.assertEquals(83, count);
    } finally {
        sqlSession.close();
    }
}

From source file:com.sinotopia.mybatis.pagehelper.test.basic.ArgumentsMapTest.java

License:Open Source License

/**
 * Mapper?PageHelper.startPage??Mapper??
 *//* w  w  w.j ava  2 s .  co  m*/
@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());
    } finally {
        sqlSession.close();
    }
}

From source file:com.sinotopia.mybatis.pagehelper.test.basic.ArgumentsObjTest.java

License:Open Source License

/**
 * Mapper?PageHelper.startPage??Mapper??
 *//* w  ww  . jav  a 2s.c  o 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());
    } finally {
        sqlSession.close();
    }
}

From source file:com.sinotopia.mybatis.pagehelper.test.basic.cache.CacheTest.java

License:Open Source License

/**
 * Mapper?PageHelper.startPage??Mapper??
 *///from w w  w  . j a  va2  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.selectGreaterThanId(10);
        assertEquals(10, list.size());
        //?110?count
        PageHelper.startPage(2, 10);
        list = countryMapper.selectGreaterThanIdAndNotEquelContryName(10, "china");
        assertEquals(10, list.size());
        //?110?count
        PageHelper.startPage(3, 10);
        list = countryMapper.selectGreaterThanIdAndNotEquelContryName(10, "china");
        assertEquals(10, list.size());
        //?110?count
        PageHelper.startPage(4, 10);
        list = countryMapper.selectGreaterThanIdAndNotEquelContryName(10, "china");
        assertEquals(10, list.size());
        //?110?count
        PageHelper.startPage(5, 10);
        list = countryMapper.selectGreaterThanIdAndNotEquelContryName(10, "china");
        assertEquals(10, list.size());
    } finally {
        sqlSession.close();
    }
}

From source file:com.sinotopia.mybatis.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 w  w .java 2s  .  c  o m*/
        //?110?count
        PageHelper.startPage(1, 10);
        List<Country> list = countryMapper.selectGreaterThanId(10);
        assertEquals(10, list.size());

        //?110?count
        PageHelper.startPage(1, 10);
        list = countryMapper.selectGreaterThanId(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.selectGreaterThanId(10);
        assertEquals(10, list.size());
    } finally {
        sqlSession.close();
    }
}

From source file:com.sinotopia.mybatis.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  a v  a2s  .  com*/
        //?110?count
        PageHelper.startPage(1, 10);
        List<Country> list = countryMapper.selectGreaterThanId(10);
        assertEquals(10, list.size());
    } finally {
        sqlSession.close();
    }
}

From source file:com.sinotopia.mybatis.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 {/* w ww  .j a va  2  s  .  co  m*/
        //?110?count
        PageHelper.startPage(1, 10);
        List<Country> list = countryMapper.selectGreaterThanId(10);
        assertEquals(10, list.size());
    } finally {
        sqlSession.close();
    }
}

From source file:com.sinotopia.mybatis.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 a v a 2s  .co m*/
        //?110?count
        PageHelper.startPage(1, 5);
        List<Country> list1 = countryMapper.selectGreaterThanId(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.sinotopia.mybatis.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 {/*from  w w  w  . j  a  v a2  s .  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();
    }
}