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.abel533.entity.test.TestUpdateByPrimaryKeySelective.java

License:Open Source License

@Test
public void testUpdateByPrimaryKeySelective() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {//ww w . j av a 2s .com
        CommonMapper commonMapper = sqlSession.getMapper(CommonMapper.class);
        EntityMapper entityMapper = new EntityMapper(commonMapper);
        Country country = new Country();
        country.setId(100);
        country.setCountryname("");
        int count = entityMapper.updateByPrimaryKeySelective(country);
        Assert.assertEquals(1, count);

        country = entityMapper.selectByPrimaryKey(Country.class, 100);
        Assert.assertNotNull(country.getCountrycode());
        Assert.assertEquals("", country.getCountryname());
    } finally {
        //
        sqlSession.rollback();
        sqlSession.close();
    }
}

From source file:com.github.abel533.entity.test.TestUpdateByPrimaryKeySelective.java

License:Open Source License

@Test(expected = Exception.class)
public void testUpdateSelectiveNull() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {/*from  www  . ja  v  a  2  s  .c  om*/
        CommonMapper commonMapper = sqlSession.getMapper(CommonMapper.class);
        EntityMapper entityMapper = new EntityMapper(commonMapper);

        entityMapper.updateByPrimaryKeySelective(null);
    } finally {
        sqlSession.close();
    }
}

From source file:com.github.abel533.test.country.TestCache.java

License:Open Source License

@Test
public void testCache() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {// ww  w.  j  av  a  2 s  . co m
        CachedCountryMapper mapper = sqlSession.getMapper(CachedCountryMapper.class);
        Country country = new Country();
        country.setCountrycode("CN");
        //
        country = mapper.selectOne(country);
        Assert.assertEquals(true, country.getId() == 35);
        Assert.assertEquals("China", country.getCountryname());
        //?close??
        sqlSession.close();

        //======================================================================
        sqlSession = MybatisHelper.getSqlSession();
        mapper = sqlSession.getMapper(CachedCountryMapper.class);
        country = new Country();
        country.setCountrycode("CN");
        //
        country = mapper.selectOne(country);

        Assert.assertEquals(true, country.getId() == 35);
        Assert.assertEquals("China", country.getCountryname());
        //?close??
        sqlSession.close();

        //======================================================================
        sqlSession = MybatisHelper.getSqlSession();
        mapper = sqlSession.getMapper(CachedCountryMapper.class);

        country = new Country();
        country.setCountryname("?");
        country.setId(35);
        //?
        int result = mapper.updateByPrimaryKeySelective(country);
        Assert.assertEquals(1, result);
        sqlSession.commit();
        //?close??
        sqlSession.close();

        //======================================================================
        sqlSession = MybatisHelper.getSqlSession();
        mapper = sqlSession.getMapper(CachedCountryMapper.class);
        country = new Country();
        country.setCountrycode("CN");
        //??
        country = mapper.selectOne(country);

        Assert.assertEquals(true, country.getId() == 35);
        Assert.assertEquals("?", country.getCountryname());

        country = new Country();
        country.setCountryname("China");
        country.setId(35);
        //
        result = mapper.updateByPrimaryKeySelective(country);
        sqlSession.commit();
        Assert.assertEquals(1, result);
    } finally {
        sqlSession.close();
    }
}

From source file:com.github.abel533.test.jdbc.TestJDBC.java

License:Open Source License

/**
 * ??//  ww w.  j a  va2 s  . c  o m
 */
@Test
public void testJDBC() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        CountryJDBCMapper mapper = sqlSession.getMapper(CountryJDBCMapper.class);
        CountryJDBC country = new CountryJDBC();
        country.setId(10086);
        country.setCountrycode("CN");
        Assert.assertEquals(1, mapper.insert(country));

        //CN
        country = new CountryJDBC();
        country.setCountrycode("CN");
        List<CountryJDBC> list = mapper.select(country);

        Assert.assertEquals(1, list.size());
        //??,??
        Assert.assertEquals(1, mapper.deleteByPrimaryKey(10086));
    } finally {
        sqlSession.close();
    }
}

From source file:com.github.abel533.test.jdbc.TestJDBC.java

License:Open Source License

/**
 * ??//from   w w  w.  j a  v a2  s  . c  o m
 */
@Test
public void testJDBC2() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        CountryJDBCMapper mapper = sqlSession.getMapper(CountryJDBCMapper.class);
        CountryJDBC country = new CountryJDBC();
        country.setCountrycode("CN");
        country.setCountryname("?");
        Assert.assertEquals(1, mapper.insert(country));
        //??,??
        Assert.assertEquals(1, mapper.deleteByPrimaryKey(country.getId()));
    } finally {
        sqlSession.close();
    }
}

From source file:com.github.pagehelper.rowbounds.test.PageRowBoundsTest.java

License:Open Source License

/**
 * Mapper??RowBounds???xml??//from   w  w w.  j av a 2  s  .c  o m
 * <p/>
 * RowBounds??count?Page?
 * <p/>
 * ??startPagestartPage
 */
@Test
public void testMapperWithPageRowBounds() {
    SqlSession sqlSession = RowBoundsHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {
        //?110?count
        PageRowBounds pageRowBounds = new PageRowBounds(0, 10);
        List<Country> list = countryMapper.selectAll(pageRowBounds);
        //PageInfo?
        assertEquals(10, list.size());
        assertEquals(183L, pageRowBounds.getTotal().longValue());
        //??
        assertEquals(1, list.get(0).getId());
        assertEquals(10, list.get(list.size() - 1).getId());

        //?1010??count
        pageRowBounds = new PageRowBounds(90, 10);
        list = countryMapper.selectAll(pageRowBounds);
        assertEquals(10, list.size());
        assertEquals(183L, pageRowBounds.getTotal().longValue());
        //??
        assertEquals(91, list.get(0).getId());
        assertEquals(100, list.get(list.size() - 1).getId());

        //?320?count
        pageRowBounds = new PageRowBounds(100, 20);
        list = countryMapper.selectAll(pageRowBounds);
        assertEquals(20, list.size());
        assertEquals(183L, pageRowBounds.getTotal().longValue());
        //??
        assertEquals(101, list.get(0).getId());
        assertEquals(120, list.get(list.size() - 1).getId());
    } finally {
        sqlSession.close();
    }
}

From source file:com.github.pagehelper.rowbounds.test.PageRowBoundsTest.java

License:Open Source License

/**
 * Mapper?PageHelper.startPage??Mapper??
 *///from   ww w .  j  a v  a2 s.c om
@Test
public void testWithRowboundsAndCountTrue() {
    SqlSession sqlSession = RowBoundsHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {
        //limit=0,?count,????rounbounds?count?-1
        //?-1
        PageRowBounds pageRowBounds = new PageRowBounds(0, -1);
        List<Country> list = countryMapper.selectAll(pageRowBounds);
        assertEquals(183, list.size());

        //pageSize<0?
        list = countryMapper.selectAll(new PageRowBounds(0, -100));
        assertEquals(183, list.size());
    } finally {
        sqlSession.close();
    }
}

From source file:com.github.pagehelper.rowbounds.test.RowBoundsTest.java

License:Open Source License

/**
 * Mapper??RowBounds???xml??/*from www .jav  a 2  s  . c om*/
 * <p/>
 * RowBounds??count?Page?
 * <p/>
 * ??startPagestartPage
 */
@Test
public void testMapperWithRowBounds() {
    SqlSession sqlSession = RowBoundsHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {
        //?110?count
        List<Country> list = countryMapper.selectAll(new RowBounds(0, 10));
        //PageInfo?
        assertEquals(10, list.size());
        //??
        assertEquals(1, list.get(0).getId());
        assertEquals(10, list.get(list.size() - 1).getId());

        //?1010??count
        list = countryMapper.selectAll(new RowBounds(90, 10));
        assertEquals(10, list.size());
        //??
        assertEquals(91, list.get(0).getId());
        assertEquals(100, list.get(list.size() - 1).getId());

        //?320?count
        list = countryMapper.selectAll(new RowBounds(100, 20));
        assertEquals(20, list.size());
        //??
        assertEquals(101, list.get(0).getId());
        assertEquals(120, list.get(list.size() - 1).getId());
    } finally {
        sqlSession.close();
    }
}

From source file:com.github.pagehelper.rowbounds.test.RowBoundsTest.java

License:Open Source License

/**
 * Mapper?PageHelper.startPage??Mapper??
 */// w  ww .  j a v a2 s  .c  o m
@Test
public void testWithRowboundsAndCountTrue() {
    SqlSession sqlSession = RowBoundsHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {
        //limit=0,?count,????rounbounds?count?-1
        //?-1
        List<Country> list = countryMapper.selectAll(new RowBounds(0, -1));
        assertEquals(183, list.size());

        //pageSize<0?
        list = countryMapper.selectAll(new RowBounds(0, -100));
        assertEquals(183, list.size());
    } finally {
        sqlSession.close();
    }
}

From source file:com.github.pagehelper.test.basic.annotations.TestAnnotations.java

License:Open Source License

/**
 * Mapper?PageHelper.startPage??Mapper??
 *///  ww w.  j  a va2 s. co 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.selectByOrder2("id");
        assertEquals(1, list.get(0).getId());
        assertEquals(10, list.size());
        assertEquals(183, ((Page<?>) list).getTotal());

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