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

List of usage examples for org.apache.ibatis.session SqlSession rollback

  1. HOME
  2. Java
  3. org.apache.ibatis
  4. org.apache.ibatis.session.*
  5. SqlSession
  6. rollback

Introduction

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

Prototype

void rollback();

Source Link

Document

Discards pending batch statements and rolls database connection back.

Usage

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  ww.  ja v  a 2s.  c  o m
        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 {/*from w  w w .j av a  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 {/*  ww w.  ja va  2 s  .  c om*/
        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   www.ja v  a  2 s.  c  om
        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.TestInsertSelective.java

License:Open Source License

@Test
public void testInsertSelectiveByNew() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {/* w  ww.j ava2 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   www  .  j  a v a  2 s.c om
        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.TestMBGExample.java

License:Open Source License

@Test
public void testDeleteByExample() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {/* w w  w .  j  a  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 testUpdateByExampleSelective() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {/* 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().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 a v a 2  s. com
        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 testDeleteByExample() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {//w w  w. j a  v  a 2 s  . com
        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();
    }
}