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

License:Open Source License

@Test
public void testDeleteByPrimaryKey() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {/*from   w  ww .j  av  a 2  s.c om*/
        CommonMapper commonMapper = sqlSession.getMapper(CommonMapper.class);
        EntityMapper entityMapper = new EntityMapper(commonMapper);
        //?
        int count = entityMapper.deleteByPrimaryKey(Country.class, 1);
        Assert.assertEquals(1, count);
        Assert.assertEquals(182, entityMapper.count(new Country()));
    } finally {
        //
        sqlSession.rollback();
        sqlSession.close();
    }
}

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

License:Open Source License

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

        entityMapper.deleteByPrimaryKey(Country.class, null);
    } finally {
        sqlSession.close();
    }
}

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

License:Open Source License

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

        Example example = new Example(Country.class);
        example.createCriteria().andGreaterThan("id", 100).andLessThanOrEqualTo("id", 150);

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

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

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

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

License:Open Source License

@Test
public void testDeleteByExample() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {//  ww  w.j  av a2 s .  co m
        CommonMapper commonMapper = sqlSession.getMapper(CommonMapper.class);
        EntityMapper entityMapper = new EntityMapper(commonMapper);

        Example example = new Example(Country.class);
        example.createCriteria().andGreaterThan("id", 100).andLessThanOrEqualTo("id", 150);

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

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

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

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

License:Open Source License

@Test
public void testSelectByExample() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {//from w w  w.  java2  s .  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");

        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 {//  w  w  w  . java  2  s .c  o m
        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  ww .  j a  va2 s  .c om*/
        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  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().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  .j a v  a 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   w ww.ja va  2s .  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.insert(country);

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