Example usage for org.apache.ibatis.session SqlSession 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.quancheng.mybatis.mapper.test.country.TestDeleteByPrimaryKey.java

License:Open Source License

/**
 * ?/*  w ww .  ja v a  2s  . c  o m*/
 */
@Test
public void testDynamicDeleteException() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        CountryMapper mapper = sqlSession.getMapper(CountryMapper.class);
        //?
        Assert.assertEquals(1, mapper.deleteByPrimaryKey(100));
    } finally {
        sqlSession.rollback();
        sqlSession.close();
    }
}

From source file:com.quancheng.mybatis.mapper.test.example.TestDeleteByExample.java

License:Open Source License

@Test
public void testDeleteByExample() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {/*from ww w  .  ja  v a2s  .  co m*/
        CountryMapper mapper = sqlSession.getMapper(CountryMapper.class);
        Example example = new Example(Country.class);
        example.createCriteria().andGreaterThan("id", 100);
        int count = mapper.deleteByExample(example);
        //
        Assert.assertEquals(83, count);
    } finally {
        sqlSession.rollback();
        sqlSession.close();
    }
}

From source file:com.quancheng.mybatis.mapper.test.example.TestDeleteByExample.java

License:Open Source License

@Test
public void testDeleteByExample2() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {/*  w w  w .  j a v  a2 s . c  o  m*/
        CountryMapper mapper = sqlSession.getMapper(CountryMapper.class);
        Example example = new Example(Country.class);
        example.createCriteria().andLike("countryname", "A%");
        example.or().andGreaterThan("id", 100);
        example.setDistinct(true);
        int count = mapper.deleteByExample(example);
        //
        Assert.assertEquals(true, count > 83);
    } finally {
        sqlSession.rollback();
        sqlSession.close();
    }
}

From source file:com.quancheng.mybatis.mapper.test.example.TestDeleteByExample.java

License:Open Source License

@Test
public void testDeleteByExample3() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {//from w  ww  .  ja  v a2  s . c  o  m
        CountryMapper mapper = sqlSession.getMapper(CountryMapper.class);
        CountryExample example = new CountryExample();
        example.createCriteria().andCountrynameLike("A%");
        example.or().andIdGreaterThan(100);
        example.setDistinct(true);
        int count = mapper.deleteByExample(example);
        //
        Assert.assertEquals(true, count > 83);
    } finally {
        sqlSession.rollback();
        sqlSession.close();
    }
}

From source file:com.quancheng.mybatis.mapper.test.example.TestUpdateByExample.java

License:Open Source License

@Test
public void testUpdateByExample() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {/*from  ww  w . jav  a 2s.  c om*/
        CountryMapper mapper = sqlSession.getMapper(CountryMapper.class);
        Example example = new Example(Country.class);
        example.createCriteria().andEqualTo("id", 35);
        Country country = new Country();
        //country.setDynamicTableName123("country_123");
        country.setCountryname("?");
        country.setId(1000);
        int count = mapper.updateByExample(country, example);
        Assert.assertEquals(1, count);

        example = new Example(Country.class);
        example.createCriteria().andIsNull("countrycode");
        count = mapper.selectCountByExample(example);
        Assert.assertEquals(1, count);
    } finally {
        sqlSession.rollback();
        sqlSession.close();
    }
}

From source file:com.quancheng.mybatis.mapper.test.example.TestUpdateByExample.java

License:Open Source License

@Test
public void testUpdateByExample2() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {/* w  ww.j  av a 2 s  . co  m*/
        CountryMapper mapper = sqlSession.getMapper(CountryMapper.class);
        Country country = new Country();
        country.setCountryname("?");
        country.setId(1000);

        CountryExample example = new CountryExample();
        example.createCriteria().andIdEqualTo(35);
        int count = mapper.updateByExample(country, example);
        Assert.assertEquals(1, count);

        example = new CountryExample();
        example.createCriteria().andCountrycodeIsNull();
        count = mapper.selectCountByExample(example);
        Assert.assertEquals(1, count);
    } finally {
        sqlSession.rollback();
        sqlSession.close();
    }
}

From source file:com.quancheng.mybatis.mapper.test.example.TestUpdateByExampleSelective.java

License:Open Source License

@Test
public void testUpdateByExampleSelective() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {//from www . ja  v a  2 s . co  m
        CountryMapper mapper = sqlSession.getMapper(CountryMapper.class);
        Example example = new Example(Country.class);
        example.createCriteria().andGreaterThan("id", 100);
        Country country = new Country();
        country.setCountryname("?");
        int count = mapper.updateByExampleSelective(country, example);
        Assert.assertEquals(83, count);

        example = new Example(Country.class);
        example.createCriteria().andEqualTo("countryname", "?");
        count = mapper.selectCountByExample(example);
        Assert.assertEquals(83, count);
    } finally {
        sqlSession.rollback();
        sqlSession.close();
    }
}

From source file:com.quancheng.mybatis.mapper.test.example.TestUpdateByExampleSelective.java

License:Open Source License

@Test
public void testUpdateByExampleSelective2() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {/*from   ww  w  . j a  v a  2s . co  m*/
        CountryMapper mapper = sqlSession.getMapper(CountryMapper.class);
        Example example = new Example(Country.class);
        example.createCriteria().andLike("countryname", "A%");
        example.or().andGreaterThan("id", 100);
        example.setDistinct(true);
        Country country = new Country();
        country.setCountryname("?");
        int count = mapper.updateByExampleSelective(country, example);
        Assert.assertEquals(true, count > 83);

        example = new Example(Country.class);
        example.createCriteria().andEqualTo("countryname", "?");
        count = mapper.selectCountByExample(example);
        Assert.assertEquals(true, count > 83);
    } finally {
        sqlSession.rollback();
        sqlSession.close();
    }
}

From source file:com.quancheng.mybatis.mapper.test.example.TestUpdateByExampleSelective.java

License:Open Source License

@Test
public void testUpdateByExampleSelective3() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {/*w w  w .j  a  v  a2  s . co m*/
        CountryMapper mapper = sqlSession.getMapper(CountryMapper.class);
        CountryExample example = new CountryExample();
        example.createCriteria().andCountrynameLike("A%");
        example.or().andIdGreaterThan(100);
        example.setDistinct(true);
        Country country = new Country();
        country.setCountryname("?");
        int count = mapper.updateByExampleSelective(country, example);
        Assert.assertEquals(true, count > 83);

        example = new CountryExample();
        example.createCriteria().andCountrynameEqualTo("?");
        count = mapper.selectCountByExample(example);
        Assert.assertEquals(true, count > 83);
    } finally {
        sqlSession.rollback();
        sqlSession.close();
    }
}

From source file:com.quancheng.mybatis.mapper.test.ids.TestIds.java

License:Open Source License

@Test
public void testDeleteByIds() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {/*from  www  . j ava 2  s .c  o m*/
        CountryMapper mapper = sqlSession.getMapper(CountryMapper.class);
        int count = mapper.deleteByIds("1,2,3");
        //
        Assert.assertEquals(3, count);
        Assert.assertEquals(180, mapper.selectCount(null));
    } finally {
        sqlSession.rollback();
        sqlSession.close();
    }
}