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

License:Open Source License

@Test
public void testCountByExample() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {//from w w w . j  ava2s  .co m
        CommonMapper commonMapper = sqlSession.getMapper(CommonMapper.class);
        EntityMapper entityMapper = new EntityMapper(commonMapper);

        CountryExample example = new CountryExample();
        example.createCriteria().andIdGreaterThan(100).andIdLessThanOrEqualTo(150);

        int count = entityMapper.countByExample(Country.class, example);
        Assert.assertEquals(50, count);

        example = new CountryExample();
        example.createCriteria().andCountrynameLike("A%");

        count = entityMapper.countByExample(Country.class, example);
        Assert.assertEquals(12, count);
    } finally {
        sqlSession.close();
    }
}

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

License:Open Source License

@Test
public void testDeleteByExample() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {/*from ww w. ja  v a  2 s  .  c o  m*/
        CommonMapper commonMapper = sqlSession.getMapper(CommonMapper.class);
        EntityMapper entityMapper = new EntityMapper(commonMapper);

        CountryExample example = new CountryExample();
        example.createCriteria().andIdGreaterThan(100).andIdLessThanOrEqualTo(150);

        int count = entityMapper.deleteByExample(Country.class, example);
        Assert.assertEquals(50, count);

        example = new CountryExample();
        example.createCriteria().andCountrynameLike("A%");

        count = entityMapper.deleteByExample(Country.class, example);
        Assert.assertEquals(12, count);
    } finally {
        //
        sqlSession.rollback();
        sqlSession.close();
    }
}

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

License:Open Source License

@Test
public void testSelectByExample() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {//  w w  w  .  j  a v a 2  s .co  m
        CommonMapper commonMapper = sqlSession.getMapper(CommonMapper.class);
        EntityMapper entityMapper = new EntityMapper(commonMapper);

        CountryExample example = new CountryExample();
        example.createCriteria().andCountrynameEqualTo("China");

        List<Country> countries = entityMapper.selectByExample(Country.class, example);
        Assert.assertEquals(1, countries.size());
        Assert.assertEquals("CN", countries.get(0).getCountrycode());

        example = new CountryExample();
        example.createCriteria().andIdEqualTo(100);

        countries = entityMapper.selectByExample(Country.class, example);
        Assert.assertEquals(1, countries.size());
        Assert.assertEquals("MY", countries.get(0).getCountrycode());
    } finally {
        sqlSession.close();
    }
}

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

License:Open Source License

@Test
public void testUpdateByExampleSelective() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {/*from  w  w w  .  j av a 2 s .  com*/
        CommonMapper commonMapper = sqlSession.getMapper(CommonMapper.class);
        EntityMapper entityMapper = new EntityMapper(commonMapper);

        CountryExample example = new CountryExample();
        example.createCriteria().andCountrynameEqualTo("China");

        Country country = new Country();
        country.setCountryname("?");
        int count = entityMapper.updateByExampleSelective(country, example);

        Assert.assertEquals(1, count);

        example = new CountryExample();
        example.createCriteria().andCountrynameEqualTo("?");

        List<Country> countries = entityMapper.selectByExample(Country.class, example);
        Assert.assertEquals(1, countries.size());
        Assert.assertEquals("?", countries.get(0).getCountryname());
    } finally {
        //
        sqlSession.rollback();
        sqlSession.close();
    }
}

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

License:Open Source License

@Test
public void testUpdateByExample() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {/*from   w  w w  . j  av  a  2  s  .  c o  m*/
        CommonMapper commonMapper = sqlSession.getMapper(CommonMapper.class);
        EntityMapper entityMapper = new EntityMapper(commonMapper);

        CountryExample example = new CountryExample();
        example.createCriteria().andCountrynameLike("A%");

        Country country = new Country();
        country.setCountryname("");
        int count = entityMapper.updateByExample(country, example);

        Assert.assertEquals(12, count);

        example = new CountryExample();
        example.createCriteria().andCountrynameEqualTo("");

        List<Country> countries = entityMapper.selectByExample(Country.class, example);
        Assert.assertEquals(12, countries.size());
        Assert.assertEquals("", countries.get(0).getCountryname());
    } finally {
        //
        sqlSession.rollback();
        sqlSession.close();
    }
}

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

License:Open Source License

@Test
public void testCountByExample() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {/*  w w  w  . j a va2  s.com*/
        CommonMapper commonMapper = sqlSession.getMapper(CommonMapper.class);
        EntityMapper entityMapper = new EntityMapper(commonMapper);

        int count = entityMapper.countByExample(Country.class, null);
        Assert.assertEquals(183, count);
    } finally {
        sqlSession.close();
    }
}

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

License:Open Source License

@Test
public void testDeleteByExample() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {// w  w  w  . java 2  s. c om
        CommonMapper commonMapper = sqlSession.getMapper(CommonMapper.class);
        EntityMapper entityMapper = new EntityMapper(commonMapper);

        int count = entityMapper.deleteByExample(Country.class, null);
        Assert.assertEquals(183, count);
    } finally {
        //
        sqlSession.rollback();
        sqlSession.close();
    }
}

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

License:Open Source License

@Test
public void testSelectByExample() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {/*  w  w  w .java2  s . c  o  m*/
        CommonMapper commonMapper = sqlSession.getMapper(CommonMapper.class);
        EntityMapper entityMapper = new EntityMapper(commonMapper);

        List<Country> countries = entityMapper.selectByExample(Country.class, null);
        Assert.assertEquals(183, countries.size());
    } finally {
        sqlSession.close();
    }
}

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

License:Open Source License

@Test
public void testUpdateByExampleSelective() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {/*from w  ww.j  a v a  2s  .co m*/
        CommonMapper commonMapper = sqlSession.getMapper(CommonMapper.class);
        EntityMapper entityMapper = new EntityMapper(commonMapper);

        Country country = new Country();
        country.setCountryname("?");
        int count = entityMapper.updateByExampleSelective(country, null);

        Assert.assertEquals(183, count);
    } finally {
        //
        sqlSession.rollback();
        sqlSession.close();
    }
}

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

License:Open Source License

@Test
public void testUpdateByExample() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {/*  ww  w.  j a  v  a  2  s  .c om*/
        CommonMapper commonMapper = sqlSession.getMapper(CommonMapper.class);
        EntityMapper entityMapper = new EntityMapper(commonMapper);

        Country country = new Country();
        country.setCountryname("");
        int count = entityMapper.updateByExample(country, null);

        Assert.assertEquals(183, count);
    } finally {
        //
        sqlSession.rollback();
        sqlSession.close();
    }
}