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.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);//from w ww .j  ava 2  s  .  co  m
    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  ww  w  . j a va  2s  . co 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/*from   w  w w . j a va  2  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  . java2 s.  c  o 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 .j  av  a 2  s  .  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// w  w w . j av  a 2s.c  om
 */
@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,???// w  w w  .j a v  a 2  s .  com
 */
@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 {/* w  ww. j  a v  a 2  s  .  c o  m*/
        //?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 {/*  ww  w . java 2 s  .c o  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();
    }
}

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

License:Open Source License

/**
 * Mapper?PageHelper.startPage??Mapper??
 *///  w  ww .jav  a2  s. 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();
    }
}