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.osc.edu.chapter2.Starter.java

License:Open Source License

/**
 * <pre>/*  www  . j  av a 2  s .co m*/
 *  ?  samples/commons/db_configuration/build.xml ?? test-db-start, initializeData Task  .
 * </pre>
 * @param args
 */
public static void main(String[] args) {
    SqlSession session = SqlSessionFactoryManager.getSqlSession();

    List<CustomersDto> customersList = null;
    List<EmployeesDto> employeesList = null;

    logger.debug("Invoke query using Mapper XML.");

    // (xml) mapper ?? namespace, id ?  
    customersList = session.selectList("com.osc.edu.commons.customers.mapper.CustomersMapper.getCustomersList");
    employeesList = session.selectList("com.osc.edu.commons.employees.mapper.EmployeesMapper.getEmployeesList");

    logger.debug("customersList's size : {}", customersList.size());
    logger.debug("employeesList's size : {}", employeesList.size());

    // Mapper ?? ?  
    CustomersMapper customersMapper = session.getMapper(CustomersMapper.class);
    EmployeesMapper employeesMapper = session.getMapper(EmployeesMapper.class);

    //  ? ? ?  ?? .
    customersMapper.deleteCustomers(103);
    employeesMapper.deleteEmployees(1002);

    customersList = customersMapper.getCustomersList();
    employeesList = employeesMapper.getEmployeesList();

    logger.debug("customersList's size : {}", customersList.size());
    logger.debug("employeesList's size : {}", employeesList.size());

    session.close();
}

From source file:com.qs.validation.ValidationCheck.java

public static List<User> getAllUser() {

    ValidationCheck vc = new ValidationCheck();
    SqlSession session = vc.getSqlSession();
    List<User> list = null;
    try {/*from w w w. j a v a2  s .c o m*/
        UserDao userDao = session.getMapper(UserDao.class);
        list = userDao.getAllUser();
        System.out.println(list.size());

    } finally {
        session.close();
    }

    return list;
}

From source file:com.qs.validation.ValidationCheck.java

public static List<String> getPasswordByName(String userName) {

    List<String> list = null;
    ValidationCheck vc = new ValidationCheck();
    SqlSession session = vc.getSqlSession();

    try {/* w w w.  java  2  s.co m*/
        UserDao userDao = session.getMapper(UserDao.class);
        list = userDao.getPasswordByName(userName);
        if (!list.isEmpty()) {
            System.out.println(list.size() + list.get(0));
        }

    } finally {
        session.close();
    }

    return list;
}

From source file:com.qs.validation.ValidationCheck.java

public boolean checkUserNameExist(String userName) {

    List<String> list = null;
    ValidationCheck vc = new ValidationCheck();
    SqlSession session = vc.getSqlSession();
    try {// www  .j  ava  2s  .c o m

        UserDao userDao = session.getMapper(UserDao.class);
        //User test=userDao.getUserByUserName("admin");
        //System.out.println(test.getPassword()+"test ");
        list = userDao.getPasswordByName(userName);
        if (!list.isEmpty()) {
            System.out.println(list.size() + list.get(0));
            return false;
        } else {
            return true;
        }

    } catch (Exception e) {
        System.out.println(e);
        return false;
    } finally {
        session.close();
    }

}

From source file:com.quancheng.mybatis.mapper.test.able.TestBasicAble.java

License:Open Source License

/**
 * /*from   w w w  .  j ava 2s. c o m*/
 */
@Test
public void testInsert() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        UserInfoAbleMapper mapper = sqlSession.getMapper(UserInfoAbleMapper.class);
        UserInfoAble userInfo = new UserInfoAble();
        userInfo.setUsername("abel533");
        userInfo.setPassword("123456");
        userInfo.setUsertype("2");
        userInfo.setEmail("abel533@gmail.com");//insert=false

        Assert.assertEquals(1, mapper.insert(userInfo));

        Assert.assertNotNull(userInfo.getId());
        Assert.assertEquals(6, (int) userInfo.getId());

        userInfo = mapper.selectByPrimaryKey(userInfo.getId());
        //email?
        Assert.assertNull(userInfo.getEmail());
    } finally {
        sqlSession.rollback();
        sqlSession.close();
    }
}

From source file:com.quancheng.mybatis.mapper.test.able.TestBasicAble.java

License:Open Source License

/**
 * ?/*www . j  av a  2  s  .co m*/
 */
@Test
public void testUpdateByPrimaryKey() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        UserInfoAbleMapper mapper = sqlSession.getMapper(UserInfoAbleMapper.class);
        UserInfoAble userInfo = mapper.selectByPrimaryKey(2);
        Assert.assertNotNull(userInfo);
        userInfo.setUsertype(null);
        userInfo.setEmail("abel533@gmail.com");
        userInfo.setAddress("??");//update=false
        //?username
        Assert.assertEquals(1, mapper.updateByPrimaryKey(userInfo));

        userInfo = mapper.selectByPrimaryKey(userInfo);
        Assert.assertNull(userInfo.getUsertype());
        Assert.assertNotEquals("??", userInfo.getAddress());
        Assert.assertEquals("abel533@gmail.com", userInfo.getEmail());
    } finally {
        sqlSession.rollback();
        sqlSession.close();
    }
}

From source file:com.quancheng.mybatis.mapper.test.able.TestBasicAble.java

License:Open Source License

/**
 * ??null/*  w  w  w  .ja  va 2s.  c o m*/
 */
@Test
public void testUpdateByPrimaryKeySelective() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        UserInfoAbleMapper mapper = sqlSession.getMapper(UserInfoAbleMapper.class);
        UserInfoAble userInfo = mapper.selectByPrimaryKey(1);
        Assert.assertNotNull(userInfo);
        userInfo.setUsertype(null);
        userInfo.setPassword(null);
        userInfo.setAddress("??");
        //?username
        Assert.assertEquals(1, mapper.updateByPrimaryKeySelective(userInfo));

        userInfo = mapper.selectByPrimaryKey(1);
        Assert.assertEquals("1", userInfo.getUsertype());
        Assert.assertEquals("12345678", userInfo.getPassword());
        Assert.assertNotEquals("??", userInfo.getAddress());
    } finally {
        sqlSession.rollback();
        sqlSession.close();
    }
}

From source file:com.quancheng.mybatis.mapper.test.country.TestCache.java

License:Open Source License

@Test
public void testCache() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {//  www.ja v a 2  s  . c om
        CachedCountryMapper mapper = sqlSession.getMapper(CachedCountryMapper.class);
        Country country = new Country();
        country.setCountrycode("CN");
        //
        country = mapper.selectOne(country);
        //?close??
        sqlSession.close();

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

From source file:com.quancheng.mybatis.mapper.test.country.TestCache.java

License:Open Source License

@Test
public void testCache2() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {//from  w  w  w.  j a va 2  s .c  om
        //
        sqlSession.selectOne("selectCache", 35);
        //?close??
        sqlSession.close();

        //======================================================================
        sqlSession = MybatisHelper.getSqlSession();
        sqlSession.selectOne("selectCache", 35);
        sqlSession.close();
    } finally {
        sqlSession.close();
    }
}

From source file:com.quancheng.mybatis.mapper.test.country.TestDeleteByPrimaryKey.java

License:Open Source License

/**
 * ?//  w ww. java2 s.c om
 */
@Test
public void testDynamicDelete() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        CountryMapper mapper = sqlSession.getMapper(CountryMapper.class);
        //
        Assert.assertEquals(183, mapper.selectCount(new Country()));
        //100
        Country country = mapper.selectByPrimaryKey(100);
        //?
        Assert.assertEquals(1, mapper.deleteByPrimaryKey(100));
        //
        Assert.assertEquals(182, mapper.selectCount(new Country()));
        //?
        Assert.assertEquals(1, mapper.insert(country));
    } finally {
        sqlSession.close();
    }
}