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.TestExample.java

License:Open Source License

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

        Example example = new Example(Country.class);
        example.createCriteria().andEqualTo("countryname", "China");

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

        example = new Example(Country.class);
        example.createCriteria().andEqualTo("id", 100);

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

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

License:Open Source License

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

        Example example = new Example(Country.class);
        example.createCriteria().andIn("id", Arrays.asList(new Object[] { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11 }))
                .andNotIn("id", Arrays.asList(new Object[] { 11 }));
        List<Country> countries = entityMapper.selectByExample(example);
        //
        Assert.assertEquals(10, countries.size());
    } finally {
        sqlSession.close();
    }
}

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

License:Open Source License

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

        Example example = new Example(Country.class);
        example.createCriteria().andEqualTo("countryname", "China");

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

        Assert.assertEquals(1, count);

        example = new Example(Country.class);
        example.createCriteria().andEqualTo("countryname", "?");

        List<Country> countries = entityMapper.selectByExample(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.TestExample.java

License:Open Source License

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

        Example example = new Example(Country.class);
        example.createCriteria().andLike("countryname", "A%");

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

        Assert.assertEquals(12, count);

        example = new Example(Country.class);
        example.createCriteria().andEqualTo("countryname", "");

        List<Country> countries = entityMapper.selectByExample(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.TestInsert.java

License:Open Source License

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

        Assert.assertEquals(0, entityMapper.count(new Country2()));

        int count = entityMapper.insert(new Country2());

        Assert.assertEquals(1, count);

        Assert.assertEquals(1, entityMapper.count(new Country2()));
    } finally {
        //
        sqlSession.rollback();
        sqlSession.close();
    }
}

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

License:Open Source License

@Test
public void testInsertOne() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {//from   w  w  w .  ja  va 2 s . co  m
        CommonMapper commonMapper = sqlSession.getMapper(CommonMapper.class);
        EntityMapper entityMapper = new EntityMapper(commonMapper);

        Country country = new Country();
        country.setId(999);
        country.setCountrycode("CN");
        int count = entityMapper.insert(country);

        Assert.assertEquals(1, count);
        Assert.assertEquals(184, entityMapper.count(new Country()));
    } finally {
        //
        sqlSession.rollback();
        sqlSession.close();
    }
}

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

License:Open Source License

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

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

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

License:Open Source License

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

        Assert.assertEquals(0, entityMapper.count(new Country2()));

        int count = entityMapper.insertSelective(new Country2());

        Assert.assertEquals(1, count);

        Assert.assertEquals(1, entityMapper.count(new Country2()));
    } finally {
        //
        sqlSession.rollback();
        sqlSession.close();
    }
}

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

License:Open Source License

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

        Country country = new Country();
        country.setId(999);
        country.setCountrycode("CN");
        int count = entityMapper.insertSelective(country);

        Assert.assertEquals(1, count);
        Assert.assertEquals(184, entityMapper.count(new Country()));
    } finally {
        //
        sqlSession.rollback();
        sqlSession.close();
    }
}

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

License:Open Source License

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

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