Example usage for org.apache.ibatis.session SqlSession close

Introduction

In this page you can find the example usage for org.apache.ibatis.session SqlSession close.

Prototype

@Override
void close();

Source Link

Document

Closes the session.

Usage

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 ww.j  a v  a2 s  . 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  w w w  .ja  va  2  s.  co  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  ww. ja  va 2s. com*/
        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   www . j ava2 s. c o m
        CommonMapper commonMapper = sqlSession.getMapper(CommonMapper.class);
        EntityMapper entityMapper = new EntityMapper(commonMapper);

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

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  a  v  a 2  s .  com
        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 www .j  a  va 2 s  . c om
        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 {//from w w w . j  av  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 {// w w  w. j a  v a2s .  c o  m
        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  ww w  .j av a 2 s . c om
        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 {//from ww w. j a  v  a2  s  . c  o m
        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();
    }
}