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.sql.test.SelectOneTest.java

License:Open Source License

@Test(expected = TooManyResultsException.class)
public void testSqlHelperSelectOne5() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    SqlMapper sqlMapper = new SqlMapper(sqlSession);
    try {/*from w w w . j  a  va2s . 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(expected = TooManyResultsException.class)
public void testSqlHelperSelectOne6() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    SqlMapper sqlMapper = new SqlMapper(sqlSession);
    try {//  w  w w. j  a  v a 2 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(expected = TooManyResultsException.class)
public void testSqlHelperSelectOne7() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    SqlMapper sqlMapper = new SqlMapper(sqlSession);
    try {//from ww w  . j  a 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(expected = TooManyResultsException.class)
public void testSqlHelperSelectOne8() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    SqlMapper sqlMapper = new SqlMapper(sqlSession);
    try {/*ww  w.  j  a  v  a2  s.  c om*/
        Country country = sqlMapper.selectOne("select * from country where id < #{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(expected = TooManyResultsException.class)
public void testSqlHelperSelectOne9() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    SqlMapper sqlMapper = new SqlMapper(sqlSession);
    try {/*from ww  w . jav  a2 s .  c  o m*/
        Country country = new Country();
        country.setId(35);
        Country result = sqlMapper.selectOne(
                "<script>" + "select * from country " + "   <where>" + "       <if test=\"id != null\">"
                        + "           id &lt; #{id}" + "       </if>" + "   </where>" + "</script>",
                country, Country.class);
        Assert.assertEquals("China", result.getCountryname());
    } finally {
        sqlSession.close();
    }
}

---

From source file:com.github.abel533.test.country.TestCache.java

License:Open Source License

@Test
public void testCache() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {//  w  w  w.j a  v a 2s .  com
        CachedCountryMapper mapper = sqlSession.getMapper(CachedCountryMapper.class);
        Country country = new Country();
        country.setCountrycode("CN");
        //
        country = mapper.selectOne(country);
        Assert.assertEquals(true, country.getId() == 35);
        Assert.assertEquals("China", country.getCountryname());
        //?close??
        sqlSession.close();

        //======================================================================
        sqlSession = MybatisHelper.getSqlSession();
        mapper = sqlSession.getMapper(CachedCountryMapper.class);
        country = new Country();
        country.setCountrycode("CN");
        //
        country = mapper.selectOne(country);

        Assert.assertEquals(true, country.getId() == 35);
        Assert.assertEquals("China", country.getCountryname());
        //?close??
        sqlSession.close();

        //======================================================================
        sqlSession = MybatisHelper.getSqlSession();
        mapper = sqlSession.getMapper(CachedCountryMapper.class);

        country = new Country();
        country.setCountryname("?");
        country.setId(35);
        //?
        int result = mapper.updateByPrimaryKeySelective(country);
        Assert.assertEquals(1, result);
        sqlSession.commit();
        //?close??
        sqlSession.close();

        //======================================================================
        sqlSession = MybatisHelper.getSqlSession();
        mapper = sqlSession.getMapper(CachedCountryMapper.class);
        country = new Country();
        country.setCountrycode("CN");
        //??
        country = mapper.selectOne(country);

        Assert.assertEquals(true, country.getId() == 35);
        Assert.assertEquals("?", country.getCountryname());

        country = new Country();
        country.setCountryname("China");
        country.setId(35);
        //
        result = mapper.updateByPrimaryKeySelective(country);
        sqlSession.commit();
        Assert.assertEquals(1, result);
    } finally {
        sqlSession.close();
    }
}

---

From source file:com.github.abel533.test.jdbc.TestJDBC.java

License:Open Source License

/**
 * ??//w  w  w.  jav  a 2 s  . c  o m
 */
@Test
public void testJDBC() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        CountryJDBCMapper mapper = sqlSession.getMapper(CountryJDBCMapper.class);
        CountryJDBC country = new CountryJDBC();
        country.setId(10086);
        country.setCountrycode("CN");
        Assert.assertEquals(1, mapper.insert(country));

        //CN
        country = new CountryJDBC();
        country.setCountrycode("CN");
        List<CountryJDBC> list = mapper.select(country);

        Assert.assertEquals(1, list.size());
        //??,??
        Assert.assertEquals(1, mapper.deleteByPrimaryKey(10086));
    } finally {
        sqlSession.close();
    }
}

---

From source file:com.github.abel533.test.jdbc.TestJDBC.java

License:Open Source License

/**
 * ??/*ww  w . j a  v a2  s  .  com*/
 */
@Test
public void testJDBC2() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        CountryJDBCMapper mapper = sqlSession.getMapper(CountryJDBCMapper.class);
        CountryJDBC country = new CountryJDBC();
        country.setCountrycode("CN");
        country.setCountryname("?");
        Assert.assertEquals(1, mapper.insert(country));
        //??,??
        Assert.assertEquals(1, mapper.deleteByPrimaryKey(country.getId()));
    } finally {
        sqlSession.close();
    }
}

---

From source file:com.github.pagehelper.rowbounds.test.PageRowBoundsTest.java

License:Open Source License

/**
 * Mapper??RowBounds???xml??//from  ww  w .ja  v  a 2s .c o  m
 * <p/>
 * RowBounds??count?Page?
 * <p/>
 * ??startPagestartPage
 */
@Test
public void testMapperWithPageRowBounds() {
    SqlSession sqlSession = RowBoundsHelper.getSqlSession();
    CountryMapper countryMapper = sqlSession.getMapper(CountryMapper.class);
    try {
        //?110?count
        PageRowBounds pageRowBounds = new PageRowBounds(0, 10);
        List<Country> list = countryMapper.selectAll(pageRowBounds);
        //PageInfo?
        assertEquals(10, list.size());
        assertEquals(183L, pageRowBounds.getTotal().longValue());
        //??
        assertEquals(1, list.get(0).getId());
        assertEquals(10, list.get(list.size() - 1).getId());

        //?1010??count
        pageRowBounds = new PageRowBounds(90, 10);
        list = countryMapper.selectAll(pageRowBounds);
        assertEquals(10, list.size());
        assertEquals(183L, pageRowBounds.getTotal().longValue());
        //??
        assertEquals(91, list.get(0).getId());
        assertEquals(100, list.get(list.size() - 1).getId());

        //?320?count
        pageRowBounds = new PageRowBounds(100, 20);
        list = countryMapper.selectAll(pageRowBounds);
        assertEquals(20, list.size());
        assertEquals(183L, pageRowBounds.getTotal().longValue());
        //??
        assertEquals(101, list.get(0).getId());
        assertEquals(120, list.get(list.size() - 1).getId());
    } finally {
        sqlSession.close();
    }
}

---

From source file:com.github.pagehelper.rowbounds.test.PageRowBoundsTest.java

License:Open Source License

/**
 * ???RowBoundsRowBounds?count//from ww w.java 2  s .  co  m
 * ??count??
 * ?count?startPage
 * <p/>
 * ?startPagestartPage?startPage??
 */
@Test
public void testNamespaceWithPageRowBounds() {
    SqlSession sqlSession = RowBoundsHelper.getSqlSession();
    try {
        //?010?
        PageRowBounds pageRowBounds = new PageRowBounds(0, 10);
        List<Country> list = sqlSession.selectList("selectAll", null, pageRowBounds);
        assertEquals(10, list.size());
        assertEquals(183L, pageRowBounds.getTotal().longValue());
        //??
        assertEquals(1, list.get(0).getId());
        assertEquals(10, list.get(list.size() - 1).getId());

        //?1010?
        pageRowBounds = new PageRowBounds(90, 10);
        list = sqlSession.selectList("selectAll", null, pageRowBounds);
        assertEquals(10, list.size());
        assertEquals(183L, pageRowBounds.getTotal().longValue());
        //??
        assertEquals(91, list.get(0).getId());
        assertEquals(100, list.get(list.size() - 1).getId());

        //?2020?
        pageRowBounds = new PageRowBounds(100, 20);
        list = sqlSession.selectList("selectAll", null, pageRowBounds);
        assertEquals(20, list.size());
        assertEquals(183L, pageRowBounds.getTotal().longValue());
        //??
        assertEquals(101, list.get(0).getId());
        assertEquals(120, list.get(list.size() - 1).getId());
    } finally {
        sqlSession.close();
    }
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• »