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

License:Open Source License

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

        Country country = new Country();
        country.setCountrycode("CN");
        Country result = entityMapper.selectOne(country);

        Assert.assertEquals("China", result.getCountryname());
    } finally {
        sqlSession.close();
    }
}

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

License:Open Source License

@Test(expected = Exception.class)
public void testSelectAllByNull() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {//from  w ww  .  jav  a 2 s  . co m
        CommonMapper commonMapper = sqlSession.getMapper(CommonMapper.class);
        EntityMapper entityMapper = new EntityMapper(commonMapper);

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

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

License:Open Source License

@Test
public void testUpdateByPrimaryKey() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {//ww w .jav a 2s .c  o  m
        CommonMapper commonMapper = sqlSession.getMapper(CommonMapper.class);
        EntityMapper entityMapper = new EntityMapper(commonMapper);
        Country country = new Country();
        country.setId(100);
        country.setCountryname("");
        int count = entityMapper.updateByPrimaryKey(country);
        Assert.assertEquals(1, count);

        country = entityMapper.selectByPrimaryKey(Country.class, 100);
        Assert.assertNull(country.getCountrycode());
        Assert.assertEquals("", country.getCountryname());
    } finally {
        //
        sqlSession.rollback();
        sqlSession.close();
    }
}

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

License:Open Source License

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

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

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

License:Open Source License

@Test
public void testUpdateByPrimaryKeySelective() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {/* w w w.  j  a v a2  s . c o  m*/
        CommonMapper commonMapper = sqlSession.getMapper(CommonMapper.class);
        EntityMapper entityMapper = new EntityMapper(commonMapper);
        Country country = new Country();
        country.setId(100);
        country.setCountryname("");
        int count = entityMapper.updateByPrimaryKeySelective(country);
        Assert.assertEquals(1, count);

        country = entityMapper.selectByPrimaryKey(Country.class, 100);
        Assert.assertNotNull(country.getCountrycode());
        Assert.assertEquals("", country.getCountryname());
    } finally {
        //
        sqlSession.rollback();
        sqlSession.close();
    }
}

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

License:Open Source License

@Test(expected = Exception.class)
public void testUpdateSelectiveNull() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {//from   w  w  w .ja va 2 s  .  c om
        CommonMapper commonMapper = sqlSession.getMapper(CommonMapper.class);
        EntityMapper entityMapper = new EntityMapper(commonMapper);

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

From source file:com.github.abel533.sql.test.SelectOneTest.java

License:Open Source License

@Test
public void testSqlHelperSelectOne() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    SqlMapper sqlMapper = new SqlMapper(sqlSession);
    try {//from  w  w  w  .j  ava2  s . c o  m
        Map<String, Object> map = sqlMapper.selectOne("select * from country where id = 35");
        Assert.assertEquals("China", map.get("COUNTRYNAME"));
    } finally {
        sqlSession.close();
    }
}

From source file:com.github.abel533.sql.test.SelectOneTest.java

License:Open Source License

@Test
public void testSqlHelperSelectOne2() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    SqlMapper sqlMapper = new SqlMapper(sqlSession);
    try {//w  w  w  .j a v a2  s . co  m
        Country country = sqlMapper.selectOne("select * from country where id = 35", Country.class);
        Assert.assertEquals("China", country.getCountryname());
    } finally {
        sqlSession.close();
    }
}

From source file:com.github.abel533.sql.test.SelectOneTest.java

License:Open Source License

@Test
public void testSqlHelperSelectOne3() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    SqlMapper sqlMapper = new SqlMapper(sqlSession);
    try {// w  w  w .ja  va2  s . c  om
        Map<String, Object> map = sqlMapper.selectOne("select * from country where id = #{id}", 35);
        Assert.assertEquals("China", map.get("COUNTRYNAME"));
    } finally {
        sqlSession.close();
    }
}

From source file:com.github.abel533.sql.test.SelectOneTest.java

License:Open Source License

@Test
public void testSqlHelperSelectOne4() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    SqlMapper sqlMapper = new SqlMapper(sqlSession);
    try {/*from  ww w  .  j a v  a2 s  .c o m*/
        Country country = sqlMapper.selectOne("select * from country where id = #{id}", 35, Country.class);
        Assert.assertEquals("China", country.getCountryname());
    } finally {
        sqlSession.close();
    }
}