Example usage for org.apache.ibatis.session SqlSession getMapper

Introduction

In this page you can find the example usage for org.apache.ibatis.session SqlSession getMapper.

Prototype

<T> T getMapper(Class<T> type);

Source Link

Document

Retrieves a mapper.

Usage

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

License:Open Source License

/**
 * ?/*from  w  ww .  ja  va  2s.  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/*from  w w w .ja  v a2s.  c om*/
 */
@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 {// w w  w . j  a  v a 2s .  c o  m
        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.TestDeleteByPrimaryKey.java

License:Open Source License

/**
 * ?// w w w  .j  a v a 2  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();
    }
}

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

License:Open Source License

/**
 * ?//from   ww w .  j  a  v a 2s.co m
 */
@Test
public void testDynamicDeleteZero() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        CountryMapper mapper = sqlSession.getMapper(CountryMapper.class);
        //?
        Assert.assertEquals(0, mapper.deleteByPrimaryKey(null));
        Assert.assertEquals(0, mapper.deleteByPrimaryKey(-100));
        Assert.assertEquals(0, mapper.deleteByPrimaryKey(0));
        Assert.assertEquals(0, mapper.deleteByPrimaryKey(1000));
    } finally {
        sqlSession.close();
    }
}

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

License:Open Source License

/**
 * ???//w  ww.j  a  va 2  s . c om
 */
@Test
public void testDynamicDeleteEntity() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        CountryMapper mapper = sqlSession.getMapper(CountryMapper.class);

        Country country = new Country();
        country.setId(100);
        Assert.assertEquals(1, mapper.deleteByPrimaryKey(country));
    } finally {
        sqlSession.close();
    }
}

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

License:Open Source License

/**
 * Map???//from   w  w w .  j av  a2  s  .c  om
 */
@Test
public void testDynamicDeleteMap() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        CountryMapper mapper = sqlSession.getMapper(CountryMapper.class);

        Map map = new HashMap();
        map.put("id", 100);
        Assert.assertEquals(1, mapper.deleteByPrimaryKey(map));

        map = new HashMap();
        map.put("countryname", "China");
        Assert.assertEquals(0, mapper.deleteByPrimaryKey(map));
    } finally {
        sqlSession.close();
    }
}

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

License:Open Source License

/**
 * ??/*from   w  ww .j a va2  s .  c  om*/
 */
@Test(expected = Exception.class)
public void testDynamicDeleteNotFoundKeyProperties() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        CountryMapper mapper = sqlSession.getMapper(CountryMapper.class);
        //?
        Assert.assertEquals(0, mapper.deleteByPrimaryKey(new Key()));
    } finally {
        sqlSession.close();
    }
}

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

License:Open Source License

/**
 * ?/*from  ww  w.  ja  v a 2s  .  co 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.country.TestInsert.java

License:Open Source License

/**
 * ??,id?null,/*  w w  w . java  2  s .  co  m*/
 */
@Test(expected = PersistenceException.class)
public void testDynamicInsertAll() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        CountryMapper mapper = sqlSession.getMapper(CountryMapper.class);
        mapper.insert(new Country());
    } finally {
        sqlSession.close();
    }
}