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

List of usage examples for org.apache.ibatis.session SqlSession getMapper

  1. HOME
  2. Java
  3. org.apache.ibatis
  4. org.apache.ibatis.session.*
  5. SqlSession
  6. 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.user.TestBasic.java

License:Open Source License

/**
 * /*from w w w . j  a  va  2  s . c  om*/
 */
@Test
public void testInsert() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        UserInfoMapper mapper = sqlSession.getMapper(UserInfoMapper.class);
        UserInfo userInfo = new UserInfo();
        userInfo.setUsername("abel533");
        userInfo.setPassword("123456");
        userInfo.setUsertype("2");
        userInfo.setEmail("abel533@gmail.com");
        Collection collection = sqlSession.getConfiguration().getMappedStatements();
        for (Object o : collection) {
            if (o instanceof MappedStatement) {
                MappedStatement ms = (MappedStatement) o;
                if (ms.getId().contains("UserInfoMapper.insert")) {
                    System.out.println(ms.getId());
                }
            }
        }

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

        Assert.assertNotNull(userInfo.getId());
        Assert.assertTrue((int) userInfo.getId() >= 6);

        Assert.assertEquals(1, mapper.deleteByPrimaryKey(userInfo));
    } finally {
        sqlSession.rollback();
        sqlSession.close();
    }
}

From source file:com.quancheng.mybatis.mapper.test.user.TestBasic.java

License:Open Source License

/**
 * ?/*from w w  w  . j av  a 2 s  .c o  m*/
 */
@Test
public void testDelete() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        UserInfoMapper mapper = sqlSession.getMapper(UserInfoMapper.class);
        //
        Assert.assertEquals(5, mapper.selectCount(new UserInfo()));
        //100
        UserInfo userInfo = mapper.selectByPrimaryKey(1);

        //?
        Assert.assertEquals(1, mapper.deleteByPrimaryKey(1));

        //
        Assert.assertEquals(4, mapper.selectCount(new UserInfo()));
        //?
        Assert.assertEquals(1, mapper.insert(userInfo));
    } finally {
        sqlSession.rollback();
        sqlSession.close();
    }
}

From source file:com.quancheng.mybatis.mapper.test.user.TestBasic.java

License:Open Source License

/**
 * //www . j a  v a  2 s  .co m
 */
@Test
public void testSelect() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        UserInfoMapper mapper = sqlSession.getMapper(UserInfoMapper.class);
        UserInfo userInfo = new UserInfo();
        userInfo.setUsertype("1");
        List<UserInfo> userInfos = mapper.select(userInfo);
        Assert.assertEquals(3, userInfos.size());
    } finally {
        sqlSession.close();
    }
}

From source file:com.quancheng.mybatis.mapper.test.user.TestBasic.java

License:Open Source License

/**
 * ?/*  ww  w  .  j  av a 2s .com*/
 */
@Test
public void testUpdateByPrimaryKey() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        UserInfoMapper mapper = sqlSession.getMapper(UserInfoMapper.class);
        UserInfo userInfo = mapper.selectByPrimaryKey(2);
        Assert.assertNotNull(userInfo);
        userInfo.setUsertype(null);
        userInfo.setEmail("abel533@gmail.com");
        //?username
        Assert.assertEquals(1, mapper.updateByPrimaryKey(userInfo));

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

From source file:com.quancheng.mybatis.mapper.test.user.TestBasic.java

License:Open Source License

/**
 * ??null/*from  ww  w . ja v  a 2  s.c  o  m*/
 */
@Test
public void testUpdateByPrimaryKeySelective() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        UserInfoMapper mapper = sqlSession.getMapper(UserInfoMapper.class);
        UserInfo userInfo = mapper.selectByPrimaryKey(1);
        Assert.assertNotNull(userInfo);
        userInfo.setUsertype(null);
        userInfo.setEmail("abel533@gmail.com");
        //?username
        Assert.assertEquals(1, mapper.updateByPrimaryKeySelective(userInfo));

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

From source file:com.quancheng.mybatis.mapper.test.user.TestDelete.java

License:Open Source License

/**
 * ?//from   www.  j a v  a 2 s  .c  o m
 */
@Test
public void testDynamicDelete() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        UserLoginMapper mapper = sqlSession.getMapper(UserLoginMapper.class);
        //
        Assert.assertEquals(10, mapper.selectCount(new UserLogin()));
        UserLogin userLogin = new UserLogin();
        userLogin.setUsername("test1");
        List<UserLogin> userLoginList = mapper.select(userLogin);
        //?
        Assert.assertEquals(userLoginList.size(), mapper.delete(userLogin));
        //?
        for (int i = 0; i < userLoginList.size(); i++) {
            Assert.assertEquals(1, mapper.insert(userLoginList.get(i)));
            Assert.assertEquals(i + 1, (int) userLoginList.get(i).getLogid());
        }
        //
        Assert.assertEquals(10, mapper.selectCount(new UserLogin()));
    } finally {
        sqlSession.close();
    }
}

From source file:com.quancheng.mybatis.mapper.test.user.TestMap.java

License:Open Source License

/**
 * /*from  w  ww.ja  va 2s.c  om*/
 */
//    @Test
public void testInsert() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        UserInfoMapMapper mapper = sqlSession.getMapper(UserInfoMapMapper.class);
        UserInfoMap userInfoMap = new UserInfoMap();
        userInfoMap.setUserName("abel533");
        userInfoMap.setPassword("123456");
        userInfoMap.setUserType("2");

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

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

        Assert.assertEquals(1, mapper.deleteByPrimaryKey(userInfoMap));
    } finally {
        sqlSession.close();
    }
}

From source file:com.quancheng.mybatis.mapper.test.user.TestMap.java

License:Open Source License

/**
 * ?/*from  w  ww.j  av  a2  s.  c  o  m*/
 */
//    @Test
public void testDelete() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        UserInfoMapMapper mapper = sqlSession.getMapper(UserInfoMapMapper.class);
        //
        Assert.assertEquals(5, mapper.selectCount(new UserInfoMap()));
        //100
        UserInfoMap userInfoMap = mapper.selectByPrimaryKey(1);

        //?
        Assert.assertEquals(1, mapper.deleteByPrimaryKey(1));

        //
        Assert.assertEquals(4, mapper.selectCount(new UserInfoMap()));
        //?
        Assert.assertEquals(1, mapper.insert(userInfoMap));
    } finally {
        sqlSession.close();
    }
}

From source file:com.quancheng.mybatis.mapper.test.user.TestMap.java

License:Open Source License

/**
 * /* w  w w.  ja v a  2s .  co  m*/
 */
//    @Test
public void testSelect() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        UserInfoMapMapper mapper = sqlSession.getMapper(UserInfoMapMapper.class);
        UserInfoMap userInfoMap = new UserInfoMap();
        userInfoMap.setUserType("1");
        List<UserInfoMap> UserInfoMaps = mapper.select(userInfoMap);
        Assert.assertEquals(3, UserInfoMaps.size());
    } finally {
        sqlSession.close();
    }
}

From source file:com.quancheng.mybatis.mapper.test.user.TestMap.java

License:Open Source License

/**
 * ?//from  w ww . j ava  2 s  .c  o m
 */
//    @Test
public void testUpdateByPrimaryKey() {
    SqlSession sqlSession = MybatisHelper.getSqlSession();
    try {
        UserInfoMapMapper mapper = sqlSession.getMapper(UserInfoMapMapper.class);
        UserInfoMap userInfoMap = mapper.selectByPrimaryKey(2);
        Assert.assertNotNull(userInfoMap);
        userInfoMap.setUserType(null);
        userInfoMap.setRealName("liuzh");
        //?user_type
        Assert.assertEquals(1, mapper.updateByPrimaryKey(userInfoMap));

        userInfoMap = mapper.selectByPrimaryKey(userInfoMap);
        Assert.assertNull(userInfoMap.getUserType());
        Assert.assertEquals("liuzh", userInfoMap.getRealName());
    } finally {
        sqlSession.close();
    }
}